Author Topic: Quick - Need some excel-fu!  (Read 5627 times)

Le Poisson

  • Senior Mustachian
  • ********
  • Posts: 13577
Quick - Need some excel-fu!
« on: April 15, 2016, 08:24:23 AM »
A coworker messed with my spreadsheet and I can't get it working again. Key problem is gettin gthis formula working in excel speak:

Ln(T)=0.92 Ln(X)+2.72 <-- Fitted curve equation for auto trips generated by single family dwellings, where X is # of dwellings in a neighbourhood.


I seem to recall the excel version looking like this: =EXP(0.92(LN(D1))+2.72)

But that is giving me bogus answers. Anyone wanna guess where I'm screwing this up???


Tjat

  • Pencil Stache
  • ****
  • Posts: 561
Re: Quick - Need some excel-fu!
« Reply #1 on: April 15, 2016, 10:49:57 AM »
=EXP(0.92*(LN(D1))+2.72)

Le Poisson

  • Senior Mustachian
  • ********
  • Posts: 13577
Re: Quick - Need some excel-fu!
« Reply #2 on: April 15, 2016, 11:01:54 AM »
=EXP(0.92*(LN(D1))+2.72)

This is too simple. Please find a more complicated method so I don't feel dumb.

Thanks for your help.

ShoulderThingThatGoesUp

  • Magnum Stache
  • ******
  • Posts: 3056
  • Location: Emmaus, PA
Re: Quick - Need some excel-fu!
« Reply #3 on: April 15, 2016, 11:07:12 AM »
=EXP(0.92*(LN(D1))+2.72)

This is too simple. Please find a more complicated method so I don't feel dumb.

Thanks for your help.

My version of Excel forced the * in so I didn't even bother posting it. I guess you're not using 2013?

Le Poisson

  • Senior Mustachian
  • ********
  • Posts: 13577
Re: Quick - Need some excel-fu!
« Reply #4 on: April 15, 2016, 11:23:40 AM »
=EXP(0.92*(LN(D1))+2.72)

This is too simple. Please find a more complicated method so I don't feel dumb.

Thanks for your help.

My version of Excel forced the * in so I didn't even bother posting it. I guess you're not using 2013?

PSssht! New software!?!?! What universe are you living in? True issue... my Corel Suite is no longer supported. It needs life support.

Felicity

  • Stubble
  • **
  • Posts: 149
  • Age: 30
  • Location: Greater Boston Area
  • ruff!
    • Fetching Financial Freedom
Re: Quick - Need some excel-fu!
« Reply #5 on: April 15, 2016, 11:41:57 AM »
=EXP(0.92*(LN(D1))+2.72)

This is too simple. Please find a more complicated method so I don't feel dumb.

Thanks for your help.

=EXP(0.92*(LN(D1))+2.72) + COS(PI())^2 + SIN(PI())^2 -1

How's that? :D

Sailor Sam

  • Magnum Stache
  • ******
  • Posts: 4511
  • Age: 40
  • Location: Steel Beach
  • Semper...something
Re: Quick - Need some excel-fu!
« Reply #6 on: April 15, 2016, 11:47:45 AM »
=EXP(0.92*(LN(D1))+2.72)

This is too simple. Please find a more complicated method so I don't feel dumb.

Thanks for your help.

I have no useful help, and I just stopped by to laugh at you. I work with a lot of sumif and sumifs functions. I feel your pain. But still laughing.

Le Poisson

  • Senior Mustachian
  • ********
  • Posts: 13577
Re: Quick - Need some excel-fu!
« Reply #7 on: April 15, 2016, 12:00:42 PM »
=EXP(0.92*(LN(D1))+2.72)

This is too simple. Please find a more complicated method so I don't feel dumb.

Thanks for your help.

=EXP(0.92*(LN(D1))+2.72) + COS(PI())^2 + SIN(PI())^2 -1

How's that? :D

Outstanding. I will use this to befuddle all who look at the sheet.

Le Poisson

  • Senior Mustachian
  • ********
  • Posts: 13577
Re: Quick - Need some excel-fu!
« Reply #8 on: April 15, 2016, 12:01:13 PM »
=EXP(0.92*(LN(D1))+2.72)

This is too simple. Please find a more complicated method so I don't feel dumb.

Thanks for your help.

I have no useful help, and I just stopped by to laugh at you. I work with a lot of sumif and sumifs functions. I feel your pain. But still laughing.

Give sumproduct a go. its so much more fun...