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:
- Open the Forecast Definition Window using the Data > Load Data menu option
- 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:
- Open the Forecast Definition Window using the Data > Load Data menu option in the Forecast Definition Window
- 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:
- Open the Forecast Definition Window using the Data > Load Data menu option in the Forecast Definition Window
- 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:
- Open the Forecast Definition Window using the Data > Load Data menu option in the Forecast Definition Window
- 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:
- First enter the Effective Date Range of the forecast
- 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)
- 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
- Highlight the files to be loaded (NOTE: holding the <SHIFT> key while right clicking with the mouse allows multiple files to be highlighted)
- Click open to select the files and display them in the Selected Offers Files box
- Check the Load Offer Data Check box
- 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 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:
- Check and uncheck the top level box (to clear all lower level checks)
- Expand the first level to show second level items (if not already expanded)
- Check the Units Box
>> Example 3. To export Offers only for Benmore:
- Uncheck the top level box if already checked (to clear all lower level checks)
- Expand the first level to show second level items (if not already expanded)
- Uncheck the Units Box if already checked (to clear all lower level checks)
- Expand the second level to show individual units at the third level
- 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
|