Price Aggregation
This panel requires the Electron desktop application. In the web build, folder selection is unavailable and aggregation cannot be run.
What It Does
The Price Aggregation panel reads already-downloaded AP or iemap price files from your local folder and computes the arithmetic mean price per IEMOP time interval per region (Luzon, Visayas, Mindanao). It writes two output CSV files — one at 5-minute resolution and one at hourly resolution — in the format used directly as iPool inputs.
Aggregation is a local-only operation. No internet connection is required.
Inputs
| Setting | Options |
|---|---|
| File Type to Aggregate | AP (Indicative Administered Prices) or iemap (Indicative Energy Modified AP) |
| Date Range (start/end) | Min 2024-08-13, max today |
| Source Folder | The same base folder used when downloading. The tool automatically looks inside the AP/ or iemap/ subfolder. |
Hint text shown in the folder field: "Select the same base folder used when downloading. The tool will look inside the AP/ or iemap/ subfolder."
Run Button
| State | Label |
|---|---|
| Idle | "Process and Generate Output CSVs" |
| Busy | "Processing..." (disabled) |
Output Files
Two files are produced per aggregation run and placed in <baseFolder>/<fileType>/:
5-minute file (one row per IEMOP interval):
| File type | Output filename |
|---|---|
| AP | AP_YYYYMMDD_YYYYMMDD.csv |
| iemap | MOD_AP_YYYYMMDD_YYYYMMDD.csv |
Hourly file (one row per clock-hour, hour-ending convention):
| File type | Output filename |
|---|---|
| AP | AP_HR_YYYYMMDD_YYYYMMDD.csv |
| iemap | MOD_AP_HR_YYYYMMDD_YYYYMMDD.csv |
Both files share the same CSV format:
DateTimeEnding,CLUZ,CVIS,CMIN
Column mapping: LUZON → CLUZ, VISAYAS → CVIS, MINDANAO → CMIN. Values are written to 6 decimal places (e.g., 25.200000). Line endings are \r\n.
If either output file for the requested date range already exists, a dialog asks whether to overwrite or cancel. Cancelling leaves the existing files unchanged.
Aggregation Method
- Groups all price values per time interval per region.
- Computes the arithmetic mean per region per interval.
- 5-minute output: one row per IEMOP interval.
- Hourly output: mean of the 12 five-minute intervals per hour, using hour-ending convention (e.g., intervals 00:05–01:00 → DateTimeEnding
1:00:00 AM).
Activity Dock
Progress appears in the Activity Dock via the dl:aggregation-progress channel.
- On success: the log shows the number of intervals processed and the paths to both output files.
- On error: the error message is shown in the Activity Dock.
Error States
| Error | Where shown |
|---|---|
| End date before start date | Inline text below date fields |
| No files found for date range | Activity Dock: "No files found for the specified date range." |
| Source folder not found | Activity Dock: error from aggregator |
| Output files already exist | Native dialog: "File Already Exists — Overwrite?" |