EMO:Offers Profile File Format - Revision history

Greg: /* Units as Rows */

2014-02-12T21:42:34Z

Units as Rows

2013-01-31T20:17:35Z

2013-01-30T23:01:18Z

Units as Rows

2013-01-30T22:50:04Z

Unit as Columns

2013-01-30T22:46:47Z

2013-01-30T02:24:48Z

Created page with "{{#hidens:}}"

New page

← Older revision		Revision as of 21:42, 12 February 2014
Line 173:		Line 173:


−	[[~~EMO:EMarketOffer User Manual~~\|Home~~]] - [[EMO:Data File Formats\|Back~~]]	+	[[Main Page\|Home]]

@@ Line 1: / Line 1: @@
 {{#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 formatting criteria for files containing Offers Profile data to be imported into a '''''[[EMO:The Forecast Definition Window|Forecast Definition]]''''' or a '''''[[EMO:The Powerflow Case Definition Window|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:

← Older revision		Revision as of 23:01, 30 January 2013
Line 90:		Line 90:

	The header row must be the first row in the file and must contain the text formatted as presented in the following table.		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="2"\|
		+	:1
		+	\|
		+	:1
		+	\|
		+	:"Generator Names/Dates"
		+	\|-
		+	\|
		+	:2 - n
		+	\|
		+	:3 Alpha day of week (e.g. "Mon")
		+	\|-
		+	\| rowspan"2" \|
		+	:2
		+	\|
		+	:1
		+	\|
		+	:"Trading Period"
		+	\|-
		+	\|
		+	:2 - n
		+	\|
		+	:Numeric (1 - 50)
		+	\|-
		+	\| rowspan="3" \|
		+	:3
		+	\|
		+	:1
		+	\|
		+	:Price/Quantity
		+	\|-
		+	\|
		+	:Even columns from 2 - n
		+	\|
		+	:"Price"
		+	\|-
		+	\|
		+	:Odd columns from 3 - n
		+	\|
		+	:"Quantity"
		+	\|-
		+	\| rowspan="2" \|
		+	:4
		+	\|
		+	:1
		+	\|
		+	:"Band Number"
		+	\|-
		+	\|
		+	:2 - n
		+	\|
		+	:Numeric (1 to 5)
		+	\|}
		+
		+
		+	A data row will exist for each Node and must conform to the formatting requirements as presented in the following table:
		+
		+	{\|class="wikitable"
		+	! Column
		+	! Format
		+	\|-
		+	\|
		+	:Generator Names/Data
		+	\|
		+	:<Unit Name> (e.g. ABY0111)
		+	\|-
		+	\|
		+	:Unit Offer
		+	\|
		+	:Numeric (three decimal places) or zero
		+	\|}
		+
		+
		+	The following is a sample section of a Units as Rows Offers Profile file:
		+	[[File:Units as rows offers.png\|1000px\|thumb\|centre\|Sample section of a Units as Rows Offers Profile file]]
		+
		+
		+	[[EMO:EMarketOffer User Manual\|Home]] - [[EMO:Data File Formats\|Back]]

← Older revision		Revision as of 22:50, 30 January 2013
Line 82:		Line 82:
	The following is a sample section of a Units as Columns Offers Profile file:		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]]		[[File:units as columns Profile.png\|1000px\|thumb\|centre\|Sample section of a Units as Columns Offers Profile file]]
		+
		+
		+	=== Units as Rows ===
		+	The file must contain two row types:
		+	*Four header rows
		+	*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.

← Older revision		Revision as of 22:46, 30 January 2013
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]]