ifference between revisions of "EMO:Offers File Format"
Jump to navigation
Jump to search
(Created page with "{{#hidens:}}") |
|||
| Line 1: | Line 1: | ||
{{#hidens:}} | {{#hidens:}} | ||
| + | The formatting criteria for files containing Offers to be imported into '''''Forecast Definitions''''' are described below. | ||
| + | |||
| + | The file must be in csv format and named according the following convention: | ||
| + | :'''Offersyyyymmdd.csv''' | ||
| + | |||
| + | Where: | ||
| + | *''''Offers'''' is the text "Offers" | ||
| + | *''''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: | ||
| + | *a single header row | ||
| + | *one or more data rows | ||
| + | |||
| + | === Header Rows === | ||
| + | The header row must be the first row in the file and must have the exact text in column as presented in below. | ||
| + | |||
| + | 1 Company | ||
| + | 2 Grid_Injection_Point | ||
| + | 3 Station | ||
| + | 4 Unit | ||
| + | 5 Trading_Date | ||
| + | 6 Trading_Period | ||
| + | 7 Max_Output | ||
| + | 8 Max_Ramp_Up_Rate | ||
| + | 9 Max_Ramp_Down_Rate | ||
| + | 10 Band1_Power | ||
| + | 11 Band1_Price | ||
| + | 12 Band2_Power | ||
| + | 13 Band2_Price | ||
| + | 14 Band3_Price | ||
| + | 15 Band3_Power | ||
| + | 16 Band4_Price | ||
| + | 17 Band4_Power | ||
| + | 18 Band5_Price | ||
| + | 19 Band5_Power | ||
| + | 20 Created_Date | ||
| + | 21 Last_Amended_Date | ||
Revision as of 16:04, 30 January 2013
The formatting criteria for files containing Offers to be imported into Forecast Definitions are described below.
The file must be in csv format and named according the following convention:
- Offersyyyymmdd.csv
Where:
- 'Offers' is the text "Offers"
- '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:
- a single header row
- one or more data rows
Header Rows
The header row must be the first row in the file and must have the exact text in column as presented in below.
1 Company 2 Grid_Injection_Point 3 Station 4 Unit 5 Trading_Date 6 Trading_Period 7 Max_Output 8 Max_Ramp_Up_Rate 9 Max_Ramp_Down_Rate 10 Band1_Power 11 Band1_Price 12 Band2_Power 13 Band2_Price 14 Band3_Price 15 Band3_Power 16 Band4_Price 17 Band4_Power 18 Band5_Price 19 Band5_Power 20 Created_Date 21 Last_Amended_Date