ifference between revisions of "EMO:Generation Profile File Format"
Line 70: | Line 70: | ||
The header row must be the first row in the file and must contain the text formatted as presented in the following table. | 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 | ||
+ | | | ||
+ | :"Generator Names/Dates" | ||
+ | |- | ||
+ | | | ||
+ | :2 - n | ||
+ | | | ||
+ | :3 Alpha day of week (e.g. "Mon") | ||
+ | |- | ||
+ | | rowspan="2"| | ||
+ | :2 | ||
+ | | | ||
+ | :1 | ||
+ | | | ||
+ | :"Trading Period" | ||
+ | |- | ||
+ | | | ||
+ | :2 - n | ||
+ | | | ||
+ | :Numeric (1 - 50) | ||
+ | |} | ||
+ | |||
+ | |||
+ | A data row will exist for each Node and must conform to the formatting requirements as presented in the following table: | ||
+ | |||
+ | {|class="wikitable" | ||
+ | ! Column | ||
+ | ! Format | ||
+ | |- | ||
+ | | | ||
+ | :Generator Names/Dates | ||
+ | | | ||
+ | :<Unit Name> (e.g. ABY0111) | ||
+ | |- | ||
+ | | | ||
+ | :Unit Generation | ||
+ | | | ||
+ | :Numeric (three decimal paces) or zero | ||
+ | |} | ||
+ | |||
+ | |||
+ | The following is a sample section of a Units as Rows Generation Profile file: | ||
+ | [[File:Units as Rows Gen.PNG|1000px|thumb|centre|Sample section of a Units as Rows Generation Profile file]] | ||
+ | |||
+ | |||
+ | [[EMO:EMarketOffer User Manual|Home]] - [[EMO:Data File Formats|Back]] |
Revision as of 11:27, 31 January 2013
The formatting criteria for files containing Generation Profile data to be imported into a 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:
- Unit as Columns
- Unit as Rows
Units 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 Units as Columns Generation Profile file:
Units 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 |
---|---|---|
|
|
|
|
| |
|
|
|
|
|
A data row will exist for each Node and must conform to the formatting requirements as presented in the following table:
Column | Format |
---|---|
|
|
|
|
The following is a sample section of a Units as Rows Generation Profile file: