ifference between revisions of "EMO:Demand File Format"
Jump to navigation
Jump to search
Line 19: | Line 19: | ||
{|class="wikitable" | {|class="wikitable" | ||
− | ! | + | ! Row |
− | ! | + | ! Column |
− | ! | + | ! Text |
|- | |- | ||
| rowspan="3" | | | rowspan="3" | | ||
Line 62: | Line 62: | ||
:No data | :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: | ||
+ | |||
+ | {|class="wikitable" |
Revision as of 09:42, 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 |
---|---|---|
|
|
|
|
| |
| ||
|
|
|
|
| |
|
|
|
|
|
Data Rows
A data row will exist for each Demand Node and must conform to the formatting requirements as presented in the following table: