Offers File Format
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 below.
Column | Text |
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 |