EMO:Demand Profile File Format - Revision history

Greg: /* Nodes as Rows */

2014-02-12T21:41:58Z

Nodes as Rows

2013-01-31T20:16:07Z

2013-01-31T20:15:46Z

2013-01-30T21:20:35Z

Nodes as Rows

2013-01-30T21:16:13Z

Node as Columns

2013-01-30T21:10:57Z

Node as Columns

2013-01-30T21:09:57Z

Node as Columns

2013-01-30T21:02:07Z

2013-01-30T02:24:25Z

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

New page

← Older revision		Revision as of 21:41, 12 February 2014
Line 125:		Line 125:


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

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

@@ Line 1: / Line 1: @@
 {{#hidens:}}
-The formatting criteria for files containing Demand Profile data to be imported into '''''Forecast Definition''''' or a '''''Powerflow Case Definition''''' are described below.
+The formatting criteria for files containing Demand Profile data to be imported into '''''[[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 21:20, 30 January 2013
Line 101:		Line 101:
	:Numeric (1 - 50)		:Numeric (1 - 50)
	\|}		\|}
		+
		+
		+	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
		+	\|-
		+	\|
		+	:Node Names/Dates
		+	\|
		+	:<Node Name> (e.g. ABY0111)
		+	\|-
		+	\|
		+	:Nodal Demand
		+	\|
		+	:Numeric (three decimal paces) or zero
		+	\|}
		+
		+
		+	The following is a sample section of a Node as Rows Demand Profile file:
		+	[[File:Nodes as Rows.PNG\|1000px\|thumb\|centre\|Sample section of a Node as Rows Demand Profile file]]
		+
		+
		+	[[EMO:EMarketOffer User Manual\|Home]] - [[EMO:Data File Formats\|Back]]

← Older revision		Revision as of 21:16, 30 January 2013
Line 63:		Line 63:
	The following is a sample section of a Node as Columns Demand Profile file:		The following is a sample section of a Node as Columns Demand Profile file:
	[[File:Demand Profile File.png\|1000px\|thumb\|centre\|Sample Section of Node as Columns Demand Profile file]]		[[File:Demand Profile File.png\|1000px\|thumb\|centre\|Sample Section of Node as Columns Demand Profile file]]
		+
		+
		+	=== Nodes as Rows ===
		+	The file must contain two row types:
		+	*two 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.
		+
		+	{\|class="wikitable"
		+	! Row
		+	! Column
		+	! Text
		+	\|-
		+	\| rowspan="2" \|
		+	:1
		+	\|
		+	:1
		+	\|
		+	:"Node Names/Dates"
		+	\|-
		+	\|
		+	:2 - n
		+	\|
		+	:3 Alpha day of week (e.g. "Mon")
		+	\|-
		+	\| rowspan="2"\|
		+	:2
		+	\|
		+	:1
		+	\|
		+	:"Trading Period"
		+	\|-
		+	\|
		+	:2 - n
		+	\|
		+	:Numeric (1 - 50)
		+	\|}

← Older revision		Revision as of 21:10, 30 January 2013
Line 62:		Line 62:

	The following is a sample section of a Node as Columns Demand Profile file:		The following is a sample section of a Node as Columns Demand Profile file:
−	[[File:Demand Profile File\|1000px\|thumb\|centre\|Sample Section of Node as Columns Demand Profile file]]	+	[[File:Demand Profile File.png\|1000px\|thumb\|centre\|Sample Section of Node as Columns Demand Profile file]]

← Older revision		Revision as of 21:09, 30 January 2013
Line 59:		Line 59:
	:Numeric (three decimal places) or zero		:Numeric (three decimal places) or zero
	\|}		\|}
		+
		+
		+	The following is a sample section of a Node as Columns Demand Profile file:
		+	[[File:Demand Profile File\|1000px\|thumb\|centre\|Sample Section of Node as Columns Demand Profile file]]

← Older revision		Revision as of 21:02, 30 January 2013
Line 1:		Line 1:
	{{#hidens:}}		{{#hidens:}}
		+	The formatting criteria for files containing Demand Profile data to be imported into '''''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:
		+	*Node as Columns
		+	*Node as Rows
		+
		+	=== Node 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="3"\|
		+	:1
		+	\|
		+	:1
		+	\|
		+	:"Date"
		+	\|-
		+	\|
		+	:2
		+	\|
		+	:"Trading Period"
		+	\|-
		+	\|
		+	:3 - n
		+	\|
		+	:<Node Name> (e.g. ABY0111)
		+	\|}
		+
		+
		+	A data row will exist for each Trading Period and must conform 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)
		+	\|-
		+	\|
		+	:Nodal Demand
		+	\|
		+	:Numeric (three decimal places) or zero
		+	\|}