ifference between revisions of "EMO:Demand File Format"

From EMO Wiki
Jump to navigation Jump to search
Line 40: Line 40:
 
| rowspan="2" |  
 
| rowspan="2" |  
 
:2
 
:2
 +
|
 +
:1
 +
|
 +
:"Period"
 +
|-
 +
|
 +
:2 - 51
 +
|
 +
:Integer Trading Period number (1 - 50)
 +
|-
 +
| rowspan="2" !
 +
:3
 
|
 
|
 
:1
 
:1

Revision as of 08:38, 31 January 2013

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)
rowspan="2" !
3
1
Node
2 - 51
No data