ifference between revisions of "EMO:Demand Profile File Format"
Line 63: | Line 63: | ||
The following is a sample section of a Node as Columns Demand Profile file: | The following is a sample section of a Node as Columns Demand Profile file: | ||
[[File:Demand Profile File.png|1000px|thumb|centre|Sample Section of Node as Columns Demand Profile file]] | [[File:Demand Profile File.png|1000px|thumb|centre|Sample Section of Node as Columns Demand Profile file]] | ||
+ | |||
+ | |||
+ | === Nodes as Rows === | ||
+ | The file must contain two row types: | ||
+ | *two header rows | ||
+ | *one or more data rows | ||
+ | |||
+ | The header row must be the first row in the file and must contain the text formatted as presented in the following table. | ||
+ | |||
+ | {|class="wikitable" | ||
+ | ! Row | ||
+ | ! Column | ||
+ | ! Text | ||
+ | |- | ||
+ | | rowspan="2" | | ||
+ | :1 | ||
+ | | | ||
+ | :1 | ||
+ | | | ||
+ | :"Node Names/Dates" | ||
+ | |- | ||
+ | | | ||
+ | :2 - n | ||
+ | | | ||
+ | :3 Alpha day of week (e.g. "Mon") | ||
+ | |- | ||
+ | | rowspan="2"| | ||
+ | :2 | ||
+ | | | ||
+ | :1 | ||
+ | | | ||
+ | :"Trading Period" | ||
+ | |- | ||
+ | | | ||
+ | :2 - n | ||
+ | | | ||
+ | :Numeric (1 - 50) | ||
+ | |} |
Revision as of 10:16, 31 January 2013
The formatting criteria for files containing Demand Profile data to be imported into Forecast Definition or a Powerflow Case Definition are described below.
The file must be in csv format and can be of any name. File format can be in one of two formats:
- Node as Columns
- Node as Rows
Node as Columns
The file must contain two row types:
- one header row
- one or more data rows
The header row must be the first row in the file and must contain the text formatted as presented in the following table.
Row | Column | Text |
---|---|---|
|
|
|
|
| |
|
|
A data row will exist for each Trading Period and must conform to the formatting requirements as presented in the following table:
Column | Format |
---|---|
|
|
|
|
|
|
The following is a sample section of a Node as Columns Demand Profile file:
Nodes as Rows
The file must contain two row types:
- two header rows
- one or more data rows
The header row must be the first row in the file and must contain the text formatted as presented in the following table.
Row | Column | Text |
---|---|---|
|
|
|
|
| |
|
|
|
|
|