Input Data
The input data types processed by EMarketOffer:
- Generation Data
- Price data
- Offers data
- Demand data
- Transmission data
- Static (user-defined) data
Generation Data
Generation data is used:
- As information-only in theUnits Information Grid for the Market Data Source
- To calculate Powerflows for the Market Data Source
- To calculate Powerflows for the Powerflow Case Data Source
Loading Generation Data
Historical Generation data can be loaded from an online database (see Connecting to a Networked Database). Historical or user-created Generation data can be loaded into Powerflow Case Definitions from file as a generation profile.
Price Data
Historical Price data is used as information-only in the Units Information Grid for the Market Data Source
Loading Historical Price Data
Historical Price data can only be loaded into EMarketOffer through direct connection to an online database (see Connecting to a Networked Database).
Offers Data
Historical Offers data is used:
- As information-only in the Units Information Grid' for the Market Data Source
- As input into the seven-day Offers Profile in forecast Definitions
- As input into Scenario Data Sources based on historical Trading Periods (when available)
NOTE: EMarketOffer does NOT use Offers to calculate Powerflows for historical Trading Periods.
Loading Historical Offers Data
Historical Offers can be loaded either through:
- direct connection to an online database
- from pre-formatted Offers files
- Offers profile files (Forecast Definitions only)
Pre-formatted Offers files must use the same formatting used by the COMIT service for providing Offers data and be named in the following manner:
- Offersyyyymmdd.csv
Where:
- 'Offers' is the text 'Offers'
- 'yyyy' is the numerical 4 digit year (e.g. 2012)
- 'mm' is the numerical 2 digit month (e.g. 06)
- 'dd' is the numerical 2 digit day (e.g. 08)
You can download Offers files directly from COMIT and use them without further editing (once renamed).
NOTE: Date format is important - the date in the file name is used to allocate offers data to specific week days. One Offers files cannot contain data for periods from two different calendar days.
Offers files are processed row by row without regard to overall integrity. This allows you to edit the raw Offers files prior to loading to:
- Alter Offer Prices and Quantities
- Restrict the number of offered periods to less than a full day
- Restrict the number of offering Generation Units to less than those actually offering on the day
The formatting for the Offers files can be found in the Appendix.
Offers profile files can also be used. An Offers profile file uses a proprietary format designed to capture a complete seven-day profile suitable for importing into a Forecast Definition. The format of this file can be found in the Appendix.