Demand File Format

From EMO Wiki
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
1
1
"Date"
2 - 51
Text of date in format: "dd-mmm-yy"
e.g. "1-Dec-05"
2
1
"Period"
2 - 51
Integer Trading Period number (1 - 50)
3
1
Node
2 - 51
No data


Data Rows

A data row will exist for each Demand Node and must conform to the formatting requirements as presented in the following table:

Column Format
Node
Standard 3 Alpha 4 numeric node code (e.g. ABY0111)
Trading Period Demand
Numeric (or blank)


A sample section of a demand file is presented below:

Sample Section of Demand File


Home