Maintaining Interval Price Sets
The Interval Price Set portal is used to display and maintain interval price sets.
Refer to About Interval Price Sets for more information.
You can access the portal from Menu, select Interval Price, then select Interval Price Set. You are brought to a query portal with options for searching for a specific record. Once an interval price set has been selected, you are brought to the maintenance portal to view and maintain the selected record.
The following zones may appear as part of the portal's Main tab page:
-
Interval Price Set: This zone displays the selected interval price set.
-
Interval Prices: This zone displays the individual interval prices for the interval price set
Maintaining Interval Prices
You use the Interval Prices zone to maintain interval prices for an interval price set.
To add prices, click Add in the upper right corner of the zone. The Interval Prices Upload dialog opens.
-
Specify the Incoming Data Shift for the price data.
-
Specify the Time Zone for the price data.
-
To manually enter prices, enter the Price Date/Time and Price values for each interval price in the Interval Prices section.
-
To upload prices, click CSV File To Upload. The File Upload dialog opens. Click Choose File to search for and select a comma separated values (CSV) file containing price data and click Submit. The Interval Prices Upload dialog will display the price data contained in the file. Note that you can edit the price data before saving it.
Note: You can add prices on the Interval Prices Upload dialog using both manual entry and upload, but there can be no overlapping data. The system returns an error if an uploaded file contains a date/time and price already entered in the Interval Prices section of the Interval Prices Upload dialog.
-
Click Save to save the interval prices.
To update one or more prices, select the price(s) to update and click Update. The Price dialog opens displaying the selected prices. Edit the prices as needed and click OK. Click Cancel to close the dialog without making any changes.
To delete one or more prices, select the price(s) to delete and click Delete. The Price dialog opens asking you to confirm the deletion. Click OK to delete the selected prices. Click Cancel to close the dialog without deleting the prices.
Interval Prices File Format
The file format used to upload interval prices are comma separated values (CSV) files with the data described in the following table. The field names in the Field column must included in the first row of the input file.
|
Field |
Data Type |
Sample Content |
Description |
|---|---|---|---|
|
dt |
DATE |
2023-02-11-12.00.00 |
Date and time for the interval price |
|
value |
NUMBER |
0.35 |
Interval price amount |
Sample File
The following is a sample file for interval prices spanning a six hour event.
dt,value 2023-02-11-12.00.00,0.35 2023-02-11-13.00.00,0.35 2023-02-11-14.00.00,0.35 2023-02-11-15.00.00,0.35 2023-02-11-16.00.00,0.35 2023-02-11-17.00.00,0.35