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 |
|---|---|---|
|
|
|
|
| |
|
|
|
|
|
