Help with forecasting future values based on a current value?
 

mak,
Excel has a Forecast function. In your case the syntax would look something like this

=Forecast(CellToForecast, 10MinuteRange, knownKWH'sRange)

For an example go here www.automateexcel.com/article67.html ,months would be your 10minuterange and sales would be your kwhs

It takes a good guess, but I wouldn't put much stock in it, cause if it was that good, I'd pick stocks with it.


"mak" wrote:

I look at electrical generation (kWhs) in 10 minute segments, 6 segments making up the complete hour. During any of these segments I would like to be able to forecast what the total would be at the end of the hour if we remained at the current production level. Or what we would need to increase production to, to meet a target value at the hour end.

Any help would be greatly appreciated.

Best regards,
Mark