Forecasting by use of spreadsheets

摘要

This invention concerns a forecasting control system which takes data and processes it to provide selective data reports including forecasts as a continuum of post results. The system makes use of arrays and in particular arrays embedded in computerised spreadsheets to process measured and forecast data and produce control reports. In particular the system produces a summary array and a closing array by adding together the other arrays. In another aspect the invention concerns a method of operating the computerised spreadsheets.