Automatic Power Forecasts (Beta)


Examples

Smallest Possible Example

tiny.xls with one spreadsheet (daily data)
Column B is the target series of the forecast because there rows 16-22 are empty. Note that with that few data points no useful forecast can be done. This example merely exists to demonstrate the input format for this website's forecast algorithm.

Hourly data

Auszug aus hourly.csv
Extract from hourly.csv with rows hidden.
Column B is the target series because there all cells after row 9138 (Jan 16, 2013) are empty while all other series are complete until Feb 16, 2013.

15-minute data

Auszug aus 15mins.xls
Column F is the target series because there rows 2-1441 are empty.

The data is generated following a simple principle: F(t)=B(t-1)+C(t-2)+D(t-3)-E(t-4) as also depicted with colors in the image.

Note that the order of the data (i.e., of each point in time) is reversed. The system deals with data both in increasing and decreasing order of time.

Daily and hourly data

Auszug von Tagesdaten aus daily_hourly.xls
Sheet1: Extract of daily data from daily_hourly.xls with rows hidden.
Auszug von Stundendaten aus daily_hourly.xls
Sheet2: Extract of hourly data from daily_hourly.xls with rows hidden.
Column E of the daily data is the target series. The data cannot be made available for legal reasons.

Changelog
  • 2019-05-01 Languages supported: EN, DE
  • 2019-01-02 Speed and accuracy optimizations
  • 2018-11-02 Speed optimizations (up to 50%+)
  • 2018-10-31 Added progress bar, strings are now interpreted as category data
  • 2018-10-23 Beta launch