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:


I'm not sure I can help you with the Power function forecasting. You might be
better off, for now, using the show formula option on the chart and copying the
values. I have devised a formula which I think should work, but it has some
strange anomalies that I don't understand, so I would not advise using it.


I will ask the question specifically and see if someone has an answer.

I have no experience with horse racing, so cannot advise you any further on
what approach to use. I prefer the stock market, myself. :-)


--ron