Demand File Format

The formatting criteria for files containing Demand data to be imported into the Forecast Definition are described below.

The file must be in csv format and named according the following convention:

Loadyyyymmdd.csv

Where:

'Load' is the text 'Load'

'yyyy' is the numerical 4 digit year (e.g. 2006)

'mm' is the numerical 2 digit month (e.g. 06)

'dd' is the numerical 2 digit day (e.g. 08)

The file must contain two row types:

• three header rows
• one or more data rows

Header Rows

The header rows must be the first three rows in the file and must contain the text formatted as presented in the following table.

Row	Column	Text
1	1	"Date"
	2 - 51	Text of date in format: "dd-mmm-yy"
		e.g. "1-Dec-05"
2	1	"Period"
	2 - 51	Integer Trading Period number (1 - 50)
3	1	Node
	2 - 51	No data

Data Rows

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

Column	Format
Node	Standard 3 Alpha 4 numeric node code (e.g. ABY0111)
Trading Period Demand	Numeric (or blank)

A sample section of a demand file is presented below:

Sample Section of Demand File

Home