On Mon, 29 Aug 2005 00:13:42 -0400, Ron Rosenfeld
wrote:

On Sun, 28 Aug 2005 09:17:01 -0700, "DBane"
wrote:

Ron,
Thank you so very much. This was what I was seeking. Your answer made
putting it the cell range so simple, even for a foolish polish truck driver
that I am. I played with that formula for a month, it was totally
frustrated. I am Probably stretching my luck and your patience. Could you
possibly give me what is needed to return the result the chart wizard uses
when using the power function forcasting 1 period forward. Using the the same
variables used in the trend function. You are very knowedgable in this field.
I believe you have an idae of what I am trying to accomplish. I use the same
range of numbers, using th forcast function with a median. what I am doing is
taking the 3 functions and averaging them. My question is if you were doing
this , would you use just 1 function,and if so which would be your choice.
You have been so very helpful so far, that I feel bad about having you do my
work for me. Bottom line is you know what your doing.
"Ron Rosenfeld" wrote:


OK, I figured out my error. Here is the formula for the Power Function
projection. As in the previous, it assumes your values are B3:B20

It's a bit more complicated as excel does not have a built-in function for
this; although someone else reading might have a simpler one.

=(COUNT(B3:B20)+1)*10^INDEX(LINEST(LOG(
OFFSET(B3,0,0,COUNT(B3:B20))),LOG(ROW(
INDIRECT("1:"&COUNT(B3:B20))))),1,2)^LINEST(
LOG(OFFSET(B3,0,0,COUNT(B3:B20))),LOG(
ROW(INDIRECT("1:"&COUNT(B3:B20)))))

Good luck at the track!!


--ron


Nope, there's still something wrong here, so don't bet on these results :-((


--ron