ifference between revisions of "EMO:Offers Profile File Format"

From EMO Wiki
Jump to navigation Jump to search
(Created page with "{{#hidens:}}")
 
Line 1: Line 1:
 
{{#hidens:}}
 
{{#hidens:}}
 +
The formatting criteria for files containing Offers 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
 +
 +
=== Unit 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.
 +
 +
{|class="wikitable"
 +
! Row
 +
! Column
 +
! Text
 +
|-
 +
| rowspan="5" |
 +
:1
 +
|
 +
:1
 +
|
 +
:"Date"
 +
|-
 +
|
 +
:2
 +
|
 +
:"Trading Period"
 +
|-
 +
|
 +
:3
 +
|
 +
:"Price/Quantity"
 +
|-
 +
|
 +
:4
 +
|
 +
:"Band Number"
 +
|-
 +
|
 +
:5 - n
 +
|
 +
:<Unit Name> (e.g. ARA2201_ARA0)
 +
|}
 +
 +
 +
A data row conforms to the formatting requirements as presented in the following table:
 +
 +
{|class="wikitable"
 +
! Column
 +
! Format
 +
|-
 +
|
 +
:Date
 +
|
 +
:3 Alpha day of week (e.g. "Mon")
 +
|-
 +
|
 +
:Trading Period
 +
|
 +
:Numeric (1 - 50)
 +
|-
 +
|
 +
:Price/Quantity
 +
|
 +
:Either "Price" or "Quantity"
 +
|-
 +
|
 +
:Band Number
 +
|
 +
:Number (1 to 5)
 +
|-
 +
|
 +
:Unit (Price or Quantity)
 +
|
 +
:Numeric (three decimal places) or zero
 +
|}
 +
 +
 +
The following is a sample section of a Units as Columns Offers Profile file:
 +
[[File:units as columns Profile.png|1000px|thumb|centre|Sample section of a Units as Columns Offers Profile file]]

Revision as of 11:46, 31 January 2013

The formatting criteria for files containing Offers 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

Unit 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
1
1
"Date"
2
"Trading Period"
3
"Price/Quantity"
4
"Band Number"
5 - n
<Unit Name> (e.g. ARA2201_ARA0)


A data row conforms to the formatting requirements as presented in the following table:

Column Format
Date
3 Alpha day of week (e.g. "Mon")
Trading Period
Numeric (1 - 50)
Price/Quantity
Either "Price" or "Quantity"
Band Number
Number (1 to 5)
Unit (Price or Quantity)
Numeric (three decimal places) or zero


The following is a sample section of a Units as Columns Offers Profile file:

Sample section of a Units as Columns Offers Profile file
Retrieved from "http://emo.energylink.co.nz/index.php?title=EMO:Offers_Profile_File_Format&oldid=3504"