{ "media_type": "text", "post_content": "Trying to do a logarithmic growth for a 5 year projection. Y1 is 1000, Y5 is 5000. How do I make the 3 years in between a logarithmic output? I’ve seen it done before but can’t get it to work.", "post_id": "5f2cb800bd21280025c6d59a", "reply_count": 10, "vote_count": 3, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius", "feed_type": "bowl" }

Trying to do a logarithmic growth for a 5 year projection. Y1 is 1000, Y5 is 5000. How do I make the 3 years in between a logarithmic output? I’ve seen it done before but can’t get it to work.

like
Posting as :
works at
You are currently posting as works at

Multiple logarithmic equations will fit those points. The easiest way to get a workable solution is to graph the points, add a logarithmic trend line, show the trend line’s equation, and use that to interpolate.

Post Photo
like

It’s nice to be appreciated

Uggg I know exactly how to do this in Google Sheets, oddly. Following here.

like

A = P*e^(r*t) where A is 5000, P is 1000, t is 5. Solve for r to get growth rate. Then solve for t=2,3,4

like

This is exponential not logarithmic

like

Random guess - isnt this just fitting a straight line from (1, log1000) to (5, log5000)? You can solve for m and c in y=mx+c with those two (x,y) coordinates and then solve for y=2,3,4. Is that what you are looking to do?

This provides a linear interpolation—he needs a logarithmic one

like

Write your own formula?

Additional Posts in Excel Genius

At what point do the “fake it until you make it” people get exposed? I feel like my time is coming 😬

likefunny

United is making me so angry. Guess it's Delta for 2016

like

I switched to a small agency and I can’t believe I’m saying this but I am HAPPY. I am feeling CREATIVE. My bosses are supportive and smart. My clients (national brand names) are appreciative, collaborative, polite and smart. It exists but I’m still pinching myself every day.

likeuplifting

I have my first (annual) performance evaluation coming up. Do you have any advice (for preparation or otherwise)? I’m in doubt of what goals I should set for myself for my second year and what questions I should ask during the evaluation.

like

I often use video clips in my classes, but never full movies because I often lose the students and it seems to be a waste. Does anyone show full movies in class?

like

I'm a sophomore looking to enter the strategy consulting field after graduation, and haven't found an internship for the summer yet. Does anyone have advice about what I might try to do last minute?

like

What are signs that a guy you’re seeing has a Madonna / Whore complex? And is there an equivalent for women?

like

Hey all, anyone know of any corporate paralegal, or legal analyst roles in your companies hiring? I currently manage over 125 lit cases and the burnout is real! I don’t mind a heavy work load, but feel this is an extreme. Am I wrong?

like

Do you think it’s better to work at a startup - in hopes of an IPO, or is it better to work for a Big 4 tech company? (In hopes of making the most money)

like

New York 🐠 any recommendations for must see or do with 2 young kids? Visiting the first week of October.
Also would you recommend staying in Times Square or by the 9/11 memorial?

Thanks!

like
like

I’m so new to the industry that I thought Leo Burnett was just one person on here that had a lot to say.

likefunny

I am trying to build my network on Linkedin. Is anyone willing to connect?

like

Anyone here daily an AP Royal Oak, particularly on client sites? Do clients notice? Any reactions positive or negative?

like

I recently obtained my MBA, and I've been eager to start working as an analyst. But I'm not sure where to begin. As an underwriter assistant, I now make $43,000. However, it's quite difficult to get by, and I'd love to start doing what I enjoy. Any suggestions?

like

Portfolio valuations exit opps?

like
likeupliftinghelpful

Here’s a cheerful one to end your week:

Was told last week my freelance gig was ending today.

Contacted my network of gatekeepers and one wrote to me on Sunday.

(Contd)

like

Looking to buy 97k Marriott points for $600. Can do Venmo/PayPal 🙌

likehelpful

Additional Posts (overall)

Does anyone’s firm use Office 365? My firm is saying they don’t want to move 365 because it poses a security issue being in the web and we don’t have a big enough security team to monitor it.

funny

The excel knowledge gap between upstairs office workers and downstairs production workers at my job is kind of hilarious.

Upstairs: We need to create a script to integrate outlook to excel to create that report on word.

Downstairs: If only there was a way to organize this column based on the next column.

funnylike

For those excel jockeys that work from home a decent amount, what is your ideal monitor size? I am trying to figure out how big to go to get the max number of columns while not having something useles

like

I am running a macro that uses "Application.FileDialog(MsoFileDialogType.msoFileDialogFilePicker)" to select a single workbook file and then open the selected workbook.

Cell A1 on Sheet1 of the workbook that is running the macro contains sheet names that can be selected from a drop-down list. I want to be able to use the sheet name that is in cell A1 to select that sheet in the newly opened workbook.

It's probably something simple, but I can't seem to get it to work. Any ideas?

like

I need help. I'm trying to split cells in a mailing list. I've been able to do this by using the text to columns wizard. However, within the list there are multiple residents that have two people living together with different last names. This has caused an issue for me that I have included a picture of. The only way I would know to fix this would be to do it manually. Do any of you know of a way to do this without fixing each individually?

Post Photo
like

I have a csv file that I was told has more that 1,048,575 rows. When I use Power BI or the data model in excel to see the rows that excel normally wouldn't show, I'm still only able pull up to this cap.

Any tips on how I can see the complete data set?

like

Any good excel shortcuts pdf?

like

Hey guys- is there a good way to roll forward PY documents and erase PY numbers (leaving formula intact) . Is there a good macro someone can share with dummy data or point me to a good resource (im not good with macros). In some cases I need to hardcode and keep the PY data while adding a new column for the CY data. Im hoping some smarty pants here has figured out a way to automate this routine task. Thanks a bunch!

funny

Why does my SUMIF formula not work if the data I am pulling from is filtered?

like

MbaExcel by Matthew Kuo is a great site for excel tips. At least for a barely user like me.
Thanks for the quick and easy tip/lesson on Index Match! Online was doing it wrong and I'd been trying out for almost 40 min. MbaExcel got it working in 5 min flat 🥳
Thank you Matthew!

like

Anyone have a good source to learn sql

like

Anyone know what these badges are?

Post Photo
likefunny

Hello hello.

I have a column of dates in the format of mm/dd/yyyy

How do I count how many dates occured after the 15th day of their respective months (e.g. Jan 16, 2022 is counted but Feb 2, 2022 is not)?

Note that I have to do this without adding a new column or using pivot tables.

Thank you so much!

like

How do you repeat item labels when the data is not in a pivot table

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

We have a spreadsheet saved in a shared folder and when I open it I can see all the tabs. But when others accessed the same worksheet, even while I was in it, one tab was missing. Has this ever happened to anyone? I’m trying to figure out what went wrong.

Hi, I would appreciate your help. I need to merge these two tables (blue and green) into one (see the example in red). How can I do this? Can you recommend any youtube video about this...

Post Photo
likefunny

have a column with a formula followed by a blank column. I need to repeat this pattern the worksheet (fill right). I can use the fill handle and mouse but is there a way to do it with a keyboard?

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

I created a macro in excel after googling some code and found one for when I have like 15 excel files with 2 sheets each for example, that I’m trying to combine into one workbook with 30 sheets. This code works great but for whatever reason on each sheet there appears 2 textboxes with a random jumble of letters and numbers like AkA6389h etc always in the top left corner of each sheet so I go in manually every time and delete those. Any reason you guys can imagine why that happens?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy.

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use and Privacy Policy.
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal