Offers File Format

From EMO Wiki
Revision as of 07:47, 31 January 2013 by Sisep (talk | contribs) (→‎Header Rows)
Jump to navigation Jump to search

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