Offers Profile File Format

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

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.

Row	Column	Text
1	1	"Generator Names/Dates"
	2 - n	3 Alpha day of week (e.g. "Mon")
2	1	"Trading Period"
2 - n	Numeric (1 - 50)
3	1	Price/Quantity
	Even columns from 2 - n	"Price"
	Odd columns from 3 - n	"Quantity"
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:

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:

Sample section of a Units as Rows Offers Profile file

Home