Demand Profile File Format

From EMO Wiki
Jump to navigation Jump to search

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

  • 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.

Row Column Text
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:

Column Format
Date
3 Alpha day of week (e.g. "Mon)
Trading Period
Numeric (1-50)
Nodal Demand
Numeric (three decimal places) or zero


The following is a sample section of a Node as Columns Demand Profile file:

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.

Row Column Text
1
1
"Node Names/Dates"
2 - n
3 Alpha day of week (e.g. "Mon")
2
1
"Trading Period"
2 - n
Numeric (1 - 50)


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

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:

Sample section of a Node as Rows Demand Profile file


Home