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

#### Le Poisson

• Senior Mustachian
• Posts: 14131
##### 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: 569
##### 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: 14131
##### 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.

#### ShoulderThingThatGoesUp

• Magnum Stache
• Posts: 3054
• 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.

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: 14131
##### 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.

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: 31
• Location: Greater Boston Area
• ruff!
##### 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.

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

How's that? :D

#### Sailor Sam

• Magnum Stache
• Posts: 4726
• 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.

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: 14131
##### 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.

=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: 14131
##### 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.