Demand File Format

From EMO Wiki
Revision as of 09:34, 31 January 2013 by Sisep (talk | contribs) (→‎Header Rows)
Jump to navigation Jump to search

The formatting criteria for files containing Demand data to be imported into the Forecast Definition are described below.

The file must be in csv format and named according the following convention:

Loadyyyymmdd.csv

Where:

'Load' is the text 'Load'
'yyyy' is the numerical 4 digit year (e.g. 2006)
'mm' is the numerical 2 digit month (e.g. 06)
'dd' is the numerical 2 digit day (e.g. 08)

The file must contain two row types:

  • three header rows
  • one or more data rows

Header Rows

The header rows must be the first three rows in the file and must contain the text formatted as presented in the following table.

Row Column Text
Rowspan="3" | 1
1
"Date"
rowspan="2" | 2 - 51
Text of date in format: "dd-mmm-yy"
e.g. "1-Dec-05"
rowspan="2" | 2