ifference between revisions of "EMO:Offers File Format"

From EMO Wiki
Jump to navigation Jump to search
 
(13 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
{{#hidens:}}
 
{{#hidens:}}
−
The formatting criteria for files containing Offers to be imported into '''''Forecast Definitions''''' are described below.
+
The formatting criteria for files containing Offers to be imported into '''''[[EMO:The Forecast Definition Window|Forecast Definitions]]''''' are described below.
  
−
The file must be in csv format and named according the following convention:
+
The file must be in csv format and named according to the following convention:
 
:'''Offersyyyymmdd.csv'''
 
:'''Offersyyyymmdd.csv'''
  
Line 18: Line 18:
 
The header row must be the first row in the file and must have the exact text in column as presented below.
 
The header row must be the first row in the file and must have the exact text in column as presented below.
  
−
Column Text
+
{|
 +
| '''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
 +
|}
  
−
#Company
+
 
−
#Grid_Injection_Point
+
=== Data Rows ===
−
#Station
+
A data row will exist for each Offering Unit and must conform to the formatting requirements as presented in the following table:
−
#Unit
+
 
−
#Trading_Date
+
{|
−
#Trading_Period
+
| '''Column'''
−
#Max_Output
+
| '''Format'''
−
#Max_Ramp_Up_Rate
+
|-
−
#Max_Ramp_Down_Rate
+
| Company
−
#Band1_Power
+
| 4 Alpha Company code (Not used)
−
#Band1_Price
+
|-
−
#Band2_Power
+
| Grid_Injection_Point
−
#Band2_Price
+
| Standard 3 Alpha 4 numeric code (e.g. ABY0111)
−
#Band3_Price
+
|-
−
#Band3_Power
+
| Station
−
#Band4_Price
+
| Standard 3 Alpha code (e.g. OPU)
−
#Band4_Power
+
|-
−
#Band5_Price
+
| Unit
−
#Band5_Power
+
| Single digit integer Unit number (0 = whole Station)
−
#Created_Date
+
|-
−
#Last_Amended_Date
+
| Trading_Period
 +
| Integer 1 - 50
 +
|-
 +
| Max_Output
 +
| Numeric
 +
|-
 +
| Max_Ramp_Up_Rate
 +
| Numeric
 +
|-
 +
| Max_Ramp_Down_Rate
 +
| Numeric
 +
|-
 +
| Band1_Power
 +
| Numeric
 +
|-
 +
| Band1_Price
 +
| Numeric
 +
|-
 +
| Band2_Power
 +
| Numeric
 +
|-
 +
| Band2_Price
 +
| Numeric
 +
|-
 +
| Band3_Power
 +
| Numeric
 +
|-
 +
| Band3_Price
 +
| Numeric
 +
|-
 +
| Band4_Power
 +
| Numeric
 +
|-
 +
| Band4_Price
 +
| Numeric
 +
|-
 +
| Band5_Power
 +
| Numeric
 +
|-
 +
| Band5_Price
 +
| Numeric
 +
|-
 +
| Created_Date
 +
| dd/mm/yyyy
 +
|-
 +
| Last_Amended_Date
 +
| dd/mm/yyyy
 +
|}
 +
 
 +
 
 +
A sample segment of an Offers file is presented below:
 +
[[File:Offers File.PNG|1000px|thumb|centre|Segment of example Offers File]]
 +
 
 +
[[Main Page|Home]]

Latest revision as of 10:41, 13 February 2014

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


Data Rows

A data row will exist for each Offering Unit and must conform to the formatting requirements as presented in the following table:

Column Format
Company 4 Alpha Company code (Not used)
Grid_Injection_Point Standard 3 Alpha 4 numeric code (e.g. ABY0111)
Station Standard 3 Alpha code (e.g. OPU)
Unit Single digit integer Unit number (0 = whole Station)
Trading_Period Integer 1 - 50
Max_Output Numeric
Max_Ramp_Up_Rate Numeric
Max_Ramp_Down_Rate Numeric
Band1_Power Numeric
Band1_Price Numeric
Band2_Power Numeric
Band2_Price Numeric
Band3_Power Numeric
Band3_Price Numeric
Band4_Power Numeric
Band4_Price Numeric
Band5_Power Numeric
Band5_Price Numeric
Created_Date dd/mm/yyyy
Last_Amended_Date dd/mm/yyyy


A sample segment of an Offers file is presented below:

Segment of example Offers File

Home

Retrieved from "http://emo.energylink.co.nz/index.php?title=EMO:Offers_File_Format&oldid=6176"