Menu

Menu	Option	Purpose	Action
Data	Load Data	To load historical or externally sourced data into the Forecast Definition	Opens the Load Data Window
	Copy Forecast	To make a copy of the current Forecast Definition	Opens a new forecast Definition Window with the same data as the current Forecast Definition
	Import	To import prepared Forecast Components from the Resource Library	Opens the Component Library Import Window
	Export	To export Components of the current Forecast Definition to the Resource Library	Opens the Component Library Export Window
Graphs	Offers Graph	To provide access to a Chart of all loaded Offers for the current Forecast Definition	Opens the Total Offers Chart
	Supply Curve	To provide access to a Supply Curve for the current Forecast Definition	Opens the Supply Curve Chart
Profiles	Demand Profile	To import, export and edit the Demand Profile for the Forecast Definition	Opens the Forecast Definition Demand Profile Window
	Offers Profile	To import, export and edit the Offers Profile for the current Forecast Definition	Opens the Forecast Definition Offers Profile Window

The Load Data Window

Access

The Data > Load Data Option in the Forecast Definition Window Menu Bar.

Purpose

To:

• Control the loading of all Forecast Definition input data in a single operation
• See the details of the last load operation
• Average a weekly Demand profile from a longer set of Demand data

Components

Component	Purpose
Demand Data Panel	Controls the loading of Demand Data, found below the highlighted "Demand" heading
Offers Data Panel	Controls the loading of Offers Data, found below the highlighted "Offers" heading
Transmission Data Panel	Controls the loading of Transmission data
Control Panel	Initiates or cancels the loading operation specified in the template, found below the highlighted "Transmission" heading

The Load Demand From Database Panel

Purpose

To load Demand data into a Forecast Definition from a Demand database.

Usage

>> To use the Panel:

1. Open the Forecast Definition Window using the Data > Load Data menu option
2. Click the Database button in the Demand Data Panel of the Load Data Window

Components

Component	Purpose
Date From Field	Uses a date selector to specify the inclusive date (day) to start loading Demand data into the Forecast Definition
Number of Weeks Button	Specifies the number of weeks of Demand data (starting at the specified Load Start Date) to use when creating an averaged Demand profile for each Node
Date to Display	Shows the last date for which Demand data will be loaded or included into an averaged profile
Clear and Load Check box	Clears all existing Demand data before loading new Demand data (toggles with the Keep and Overwrite Check box)
Keep and Overwrite Check box	Keeps existing Demand data and overwrites with new data averaged with existing data, allowing averaged Demand profiles to be created using Demand data from discontinuous time periods (toggles with the Clear and Load Check box)
Last Load Operation Details	Records when Demand data was last loaded and if the load operation was successful
Include Demand Data in Load Check box	To include or exclude Demand data from the next Load Operation
Reset Button	Restores the entire Demand Load Panel (file and database) to its default settings: Load from database Start Date = First date of the Forecast Definition Effective Date Range Number of weeks = 1 Clear and Load = Checked Include Demand in next load operation

The Load Demand From File Panel

Purpose

To specify the details of the Demand data to load into a Forecast Definition from a pre-formatted file.

>> To use the Panel:

1. Open the Forecast Definition Window using the Data > Load Data menu option in the Forecast Definition Window
2. Click the File button in the Demand Data Panel of the Load Data Window

Components

Component	Purpose
Demand File Button	Shows the name of the last Selected Demand data file
The File Button	Opens the Standard Windows directory browser to search for the required Demand data file
Clear and Load Check Box	Clears all existing Demand data before new data is loaded (toggles with the Keep and Overwrite Check Box)
Keep and Overwrite Check Box	Keeps existing Demand data and overwrites with new data averaged with existing data, allowing averaged Demand profiles to be created using Demand data from discontinuous time periods (toggles with the Clear and Load Check box)
Last Load Operation Details	Records when Demand data was last loaded and if the load operation was successful
Include Demand Data in Load Check box	To include or exclude Demand data from the next Load Operation
Reset Button	Restores the entire Demand Load Panel (file and database) to its default settings: Load from database Start Date = First date of the Forecast Definition Effective Date Range Number of weeks = 1 Clear and Load = Checked Include Demand in next load operation

NOTE: If you choose to Keep and Overwrite the data loaded from file, it is possible to mix Demand data sourced from file and database.

The Load Offers from Database Panel

Purpose

To load a Forecast Definition from an Offers database.

>> To use the Panel:

1. Open the Forecast Definition Window using the Data > Load Data menu option in the Forecast Definition Window
2. Click the Database button in the Offers Data Panel of the Load Data Window

Components

Component	Purpose
Date From Field	Uses a date selector to specify the inclusive date (day) to start loading Offers data into the Forecast Definition
Date To Display	Shows the last date for which Offers data will be loaded
Clear and Load Check Box	Clears all existing Offers data before loading new data (toggles with the Keep and Overwrite Check Box)
Keep and Overwrite Check Box	Keeps existing Offers data and overwrites with new data from the database
Last Load Operation Details	Records when Offers data was last loaded and if the load operation was successful
Include Offers Data in Load Check Box	To include or exclude Offers data from the next Load Operation
Include Load Reserve Settings in the Data Loading Check box	When checked this features causes any reserves requirements data stored in the database to be loaded along with reserve offers. When not checked Reserve Offers will be excluded from the data load. Loading Offers data with this box unchecked will cause previously loaded or entered Reserves Settings to be deleted from the Forecast Definition
Reset Button	Restores the entire Offers Load Panel (file and database) to its default settings: Load from database Start Date = First date of the Forecast Definition Effective Date Range Clear and Load = Checked Include Offers in next load operation

The Load Offers from File Panel

Purpose

To specify the details of the Offers data to load into a Forecast Definition from a pre-formatted file of Offers data.

>> To use the panel:

1. Open the Forecast Definition Window using the Data > Load Data menu option in the Forecast Definition Window
2. Click the File button in the Offers Data Panel of the Load Data Window

Components

Component	Purpose
Selected Offers files Box	Shows the list of currently (or previously) selected Offers files
The Get Files... Button	Opens the Standard Windows directory browser to search for Offers files
Clear and Load Check Box	Clears all existing Offers data before loading new Offers data (toggles with the Keep and Overwrite Check Box)
Keep and Overwrite Check Box	Keeps existing Offers data and overwrites with new (toggles with the Clear and Load Check Box)
Last Load Operation Details	Records when Offers data was last loaded and if the load operation was successful
Include Offers Data in Load Check Box	To include or exclude Offers data from the next Load Operation
Include Load Reserve Settings in the Data Loading Check box	When checked this features causes any reserves requirements data stored in the database to be loaded along with reserve offers. When not checked Reserve Offers will be excluded from the data load. Loading Offers data with this box unchecked deletes previously loaded or entered Reserves Settings from the Forecast Definition
Reset Button	Restores the entire Offers Load Panel (file and database) to its default settings: Load from database Start Date = First date of the Forecast Definition Effective Date Range Clear and Load = Checked Include Demand in next load operation

NOTE: If you choose to Keep and Overwrite the data loaded from file it is possible to mix Offers data sourced from file and database.

>> To Load a Forecast Definition with Offers from Files:

1. First enter the Effective Date Range of the forecast
2. Select the dates of the Offers data you wish to use taking care to note the days of the week for these dates (for initial loading it is best to select seven consecutive and complete Offers files with the earliest file having the same day of the week as the first day of your selected Effective Date Range)
3. Bring up the Load Offers from Files Panel and use the "Get Files ..." button which opens the Windows file browser to locate the required Offers files
4. Highlight the files to be loaded (NOTE: holding the <SHIFT> key while right clicking with the mouse allows multiple files to be highlighted)
5. Click open to select the files and display them in the Selected Offers Files box
6. Check the Load Offer Data Check box
7. The Offers data will be loaded with the next load data operation.

The Load Transmission Data Panel

Access

The Forecast Definition Window using the Data > Load Data menu option.

Purpose

To specify the date range of Transmission data you want to load into a Forecast Definition from your default Transmission System data source.

Transmission System Data Loading Modes

A Transmission System data can be loaded into a Forecast Definition in one of two modes:

• Date Range Mode, which uses system data for all periods in the Forecast's Effective Date Range (or a user-entered date range)
• Period Mode, which uses system data from a single period and applies it to all periods in the Forecast's Effective Date Range

How EMarketOffer internally constructs Transmission System data

When creating the Transmission System data EMarketOffer first uses the latest EM6/COMIT/Ellsoft supplied data file to build the basic system. The Transmission System is modelled as a set of Circuits with specific ratings (taking into account Summer and Winter changes). Any line re-ratings scheduled in the Constraint data falling within the Forecast Effective Date Range are applied over the top of the original ratings. Finally any Group Constraints that were or will be applied during the Forecast Effective Date Range are activated.

NOTE: EMarketOffer uses EM6/COMIT/Ellsoft Constraint information to extract historical and expected Group Constraint data. Of the three types of Group Constraints (Permanent, Outage and Temporary), only the timing of future Permanent Constraints can be predicted using EM6 Constraint information. You will need to monitor your sources of Transmission System data for updates to ensure your Forecast Definitions contain the latest Outage and Temporary Group Constraint data.

Date Range Mode

Access

By clicking on the Date Range tab in the Transmission Data Panel.

Purpose

To select a date range for loading Transmission System data into a Forecast Definition.

NOTE: This Mode is only available when Transmission System data can be obtained from EM6/COMIT-provided files.

Load Items

A Definition loaded through the Date Range Mode will contain the following:

• Base Grid Configuration
• All re-ratings applied during the date range
• All Group Constraints applied during the date range

Components

Component	Purpose
Date Selectors	Allow you to select the days for which to start and finish loading Transmission Data into the Forecast Definition
Clear and Load Check box	Clears all existing Transmission data before loading new data (toggles with the Keep and Overwrite check box)
Keep and Overwrite Check box	Keeps existing Transmission data ad overwrites with new data
Last Load Operation Details	Records when Transmission data was last loaded
Include Transmission Data in Load Check box	To include or exclude Transmission data from the next Load Operation
Reset Button	Restores the entire Transmission Load Panel (file and database) to its default settings: Start Date = First date of the Forecast Definition Effective Date Range End Date - Last date of the Effective Date Range Clear and Load = Checked Include Transmission System data in next load operation

Period Mode

Purpose

To select a specific period to provide the basic Transmission System data for all periods in your Forecast Effective Date Range.

This Mode is only available when either the Transmission System data can be obtained from your online database or from EM6/COMIT-provided files. It is the only loading option available when EM6/COMIT data files are not available.

NOTE: When using Period Mode EMarketOffer applies the basic grid and re-ratings to obtain the System Configuration for the Period and applies this to all periods in the Effective Date Range. It does not keep specific record of Circuit re-ratings or Equation Constraints, which are kept when loading in Date Range Mode.

Components

Component	Purpose
Date Selector	Selects the inclusive date of the period to load Transmission data into the Forecast Definition
Period Selection Bar	To select the loading Period
Period Selection Box	Used with the mouse or by text entry to select the loading Period
Clear and Load Check box	Clears all existing Transmission data before loading new data (toggles with the Keep and Overwrite check box)
Keep and Overwrite Check box	Keeps existing Transmission data and overwrites with new data from the database
Last Load Operation Details	Displays when Transmission System data was last loaded
Include Transmission Data in Load Check box	Allows you to include or exclude Transmission data from the next Load Operation
Reset Button	Restores the entire Transmission Load Panel (file and database) to its default settings: Start Date = First date of the Powerflow Case Definition Effective Date Range End Date - Last date of the Effective Date Range Clear and Load = Checked Include Transmission System data in next load operation

The Export Forecast Components Window

Access

The Data > Export... menu option in the Forecast Definition Window

Features

Feature	Purpose
Component Name Field	To enter a short name to identify the Component in the Library. Defaulted from the Forecast Definition Name for new Components
Component Description Field	To enter a more detailed description of the Component (e.g. when it was created, by whom and for what reason)
Component Browsing Panel	To select which parts of the current Forecast Definition will be included in thee component. The tree of Component items can be expanded using the +/- signs
Export Button	To Export details of selected items to a Component stored in the Library
Close	Closes the Export Forecast Component Window. Closing without first exporting the Component will not save the Component

Using the Component Browsing Panel

>> Example 1. To export a whole Forecast Definition:

1. 1 Check the box at the top level (next to the Forecast Definition name)

NOTE: The box appears checked if any item further down the tree has been checked. To be certain you have included all items in cases where the top level box is already checked, clear the check to reset everything to unchecked then check again to select everything.

>> Example 2. To export all Offers from a Forecast Definition:

1. Check and uncheck the top level box (to clear all lower level checks)
2. Expand the first level to show second level items (if not already expanded)
3. Check the Units Box

>> Example 3. To export Offers only for Benmore:

1. Uncheck the top level box if already checked (to clear all lower level checks)
2. Expand the first level to show second level items (if not already expanded)
3. Uncheck the Units Box if already checked (to clear all lower level checks)
4. Expand the second level to show individual units at the third level
5. Check the boxes for BEN0162_BEN0 and BEN0163_BEN0 (both the Units and the top level box should appear checked)

The Import Forecast Component Window

Access

The Data > Import... menu option in the Forecast Definition Window.

Features

Panel	Feature	Purpose
Component Browser	Component Browser, found underneath the "Resources" heading at the top of the Window	To select a component from the library
	Component List	To provide a scroll-able list of components in the default library folder available for importing into the Forecast Definition
	Browse Button	Opens the standard Windows file browsing dialogue (default folder = Library)
	Open Library Dir Button	Opens the standard Windows file Window for the library folder
	Refresh Button	Refreshes the Component Browser panel (in case you have moved components in or out of the library while the Window is open)
Component Details	Component Details, found directly beneath the "Component Browser"	Displays the details of the currently selected Component
Component Items Panel	Component Tree, found in the bottom left of the panel below the "Resource" heading	To check the items you want to import from the Component into your Forecast Definition
Forecast Definition Panel	Forecast Definition Tree, found in the bottom right of the panel below the "Import to forecast" heading	An expandable tree of Forecast Definition Items
Actions Panel	Action Panel, located at the very bottom of the Window	To initiate the import
	Import button	Imports the selected Components items into the Current Forecast Definition
	Overwrite Check box	Tells the import process to overwrite details in the current Forecast Definition with items from the Component. If this box is not checked then only items that do not exist in the current Forecast Definition are copied from the Component.
	Close	Closes the Import Component Window

NOTE: It is possible to export different sets of Components from a single Forecast Definition at different times. Each export operation using a Forecast Definition is given a unique version number to preserve previous exports. The Description field allows you to differentiate the different versions on-screen.

Using the Component Browsing Panel

>> Example 1. To export a whole Forecast Definition:

1. Check the box at the top level (next to the Forecast Definition name)

NOTE: The box appears checked if any item further down the tree has been checked. To be certain you have included all items in cases where the top level box is already checked, clear the check to reset everything to unchecked then check again to select everything.

>> Example 2. To export all Offers from a Forecast Definition:

1. Check and uncheck the top level box (to clear all lower level checks)
2. Expand the first level to show second level items (if not already expanded)
3. Check the Units Box

>> Example 3. To export Offers only for Benmore:

1. Uncheck the top level box if already checked (to clear all lower level checks)
2. Expand the first level to show second level items (if not already expanded)
3. Uncheck the Units Box if already checked (to clear all lower level checks)
4. Expand the second level to show individual units at the third level
5. Check the boxes for BEN0162_BEN0 and BEN0163_BEN0 (at this stage both the Units and the top level box should also appear checked)

The Profiles Menu Option

Access

Either the Profiles > Demand or Profiles > Offers options of the Forecast Definition Window Menu

Purpose

To:

1. Import and export Demand or Offers Profile files
2. Manually edit Demand for Offers figures for individual or groups of Trading Periods and Nodes

NOTE: The formats of Demand and Offers Profile files are covered in the Appendix.

Items

The Window displays the seven-day Offers or Demand Profile in a Data Grid with a column for each Node and a row for each Trading Period. Data in a cell can be edited manually. Cutting and pasting to and from single or multiple cells is supported.

Exporting from the Profile

>> Use the File > Export option to open the Export Node Profile Options Window

Components

Component	Purpose
Select All Nodes check box	When checked will include in the exported data Demand for all Nodes, or Offers for all Units, in the loaded Profile. When not checked the Node Selection Drop Down List is displayed
Nodes Selection drop down list	To select individual Nodes to be included in the export
Output Format Type toggle	To control whether the data will be exported with Nodes/Units as columns or rows
Included Day Selector	To select which Profile days will be exported
Output Location Toggle	To select if the data will be output to csv file or to the Windows Clipboard
On Completion Action	Causes the created CSV file to be opened automatically when the export is complete (if checked)
OK Button	Executes the data export operation. When saving to .csv file this button will open the Standard Windows 'Save As' dialogue for you to select a name and location for the exported profile
Cancel Button	Cancels the export operation and closes the Options Window

Importing into the Profile

Demand or Offers data can be imported into the Forecast Definition Profile from any properly formatted file. Selecting the File>Import menu option opens the standard Windows file browsing window to locate the import file.

An imported Profile may contain data for:

• One or many Nodes
• One or many profile days
• One or many Trading Periods

WARNING! Demand for Nodes and Offer for Units not currently contained in the Profile's Transmission System data will be loaded, but will not play any role in the dispatch analysis unless the new Node is manually connected with one or more user-defined Circuits.

Home - Back