Automatic Power Forecasts (Beta)

Input data

The uploaded file is considered the input data. You can only forecast data out of one file. Allowed formats are:

• CSV
• XLS
• XLSX

Other:

• File size must be at most 4MB
• CSV Files
  • must contain only one time series table
  • must use as separator: tab, comma, or semicolon
• XLS(X) files must not contain formulas
• Empty strings (e.g., "") and empty cells are considered missing values
• Every file must contain at least one time series table (in the form of a sheet). In this time series table there must be a column with numeric data with a block of missing values at the end (of the related date or date time). This column will be considered the target column.

XLS(X) files with more than one sheet

XLS(X) files can contain more than one sheet.

If more than one sheet is used, every sheet needs to fulfill the requirements of a time series table and the date/ date time covered by each sheet must be identical.

The frequency per date / date time series however can be different, e.g., one sheet may contain daily data and the other one hourly (or 15 minute data). In this case, the sheet with the hourly data must contain 24x as many rows as the sheet with the daily data. This value can vary slightly due to adjustments of summer and winter time.

Requirements per time series table

A time series table is either a CSV file or a sheet of an XLS(X) file.

Eine time series table must:

• contain as first column a date or date time column. This column must be equidistant and without missing values.
• contain at least on further column with a valid data type. More is ok as well.
• contain a table header with column names either at the beginning of all columns or at no column

Column requirements

The data of a column consists of all cells, with the possible exception of the first cell that may contain the olumn header. The following are valid column types:

• Date - international or european formats are allowed, e.g.

  • YYYY/MM, YYYY/MM/TT, YYYY/MM/TT hh:mm (international format)
  • MM/YYYY, TT/MM/YYYY, TT/MM/YYYY hh:mm (German format)
  • Years need not contain the century numbe (31/12/17 equals 31/12/2017)
  • Months and days need not contain a leading zero (1/1/17 equals 01/01/2017)
  • the date separator can be a slash /, a point . or a minus -
  • the time separator must be a colon
  • the separator between date and time must be a space
  • the system deals automatically with eventual occurrences of summer/ winter time shiftsin March and October and missing values (in March) or doubly occurring times (October) are treated correctly
  • the system was specifically tested with time series frequencies of 1 day, 1 hour and 15 minutes, but other intervals should work as well.

• numerisch - numbers in the following format

  • with or without a leading minus -
  • with or without a decimal separator (point or comman) and decimal digits
  • without thousand separator

• strings

  • will be interpreted automatically as a categorical variable as long as there is only a limited number of categories k compared to rows n (k << n)

Each column may contain empty cells, in this case the system tries to replace missing values. A cell is considered empty if it contains nothing or the empty string "".