The Money Mustache Community
Learning, Sharing, and Teaching => Ask a Mustachian => Topic started by: Le Poisson 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???
-
=EXP(0.92*(LN(D1))+2.72)
-
=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)
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?
-
=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.
-
=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
-
=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.
-
=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.
-
=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...