Designing Interval Profile Types

Now that you have your profile relationship types defined, you need to begin defining profile types. The interval profile type defines the physical attributes of the interval data.

The essential attributes of any profile type are the UOM/SQI, the minutes per interval and the associated algorithms. The easiest way to start defining your interval profile types is to start with the profile relationship type and determine what type of data each customer may have for the same profile relationship type.

Let's start with our profile relationship types and make some assumptions regarding the physical attributes of the data that a customer may have for each of these roles:

  • Let's assume that a customer's demand may be measured in either 30-minute intervals or 60-minute intervals. In either case, the UOM is kW and SQI is not applicable. Let's also assume that the measured data may be interfaced from an external source or may be aggregated from interval register data.
  • Let's assume that the hedge cover is common, but that these values may also be in 30-minute intervals or 60-minute intervals.
  • Finally, let's assume that our spot market prices are at 60-minute intervals and that the algorithm, which rates uses to apply the interval prices, expects the "amount in excess of the hedge cover" to be in 60-minute intervals. This means that we need two different algorithms for our OVRHEDGE data. One algorithm is used for a customer with 60-minute intervals and simply subtracts the two curves and produces the resulting data. The second algorithm is used for a customer with 30-minute intervals. It performs two steps. It subtracts the hedge from the measured demand and adds together each resulting 30-minute pair to produce a 60-minute OVRHEDGE curve.

We will assume that all of our profile data will follow the same seasonal time shift as our base time zone. Refer to Time Zone and Time Changes and Designing Your Time Options for more information.

Prof. Rel. Type

Profile Type

Common/SA Owned

UOM/ SQI

Min/ Interval

Seasonal Time Shift

Algorithm

MEASDMD

DMDKW60

SA Owned

KW

60

USShift

N/a

DMDKW30

SA Owned

KW

30

USShift

N/a

DMDKW60AGG

SA Owned

KW

60

USShift

Aggregate interval register data

DMDKW30AGG

SA Owned

KW

30

USShift

Aggregate interval register data

HEDGECVR

HEDGE60

Common

KW/ HG

60

USShift

N/a

HEDGE30

Common

KW/ HG

30

USShift

N/a

OVRHEDGE

OVRHG60

SA Owned

KW/ OVR

60

USShift

Compare MEASDMD to HEDGECVR to produce 60-minute over hedge curve

OVRHG30

SA Owned

KW/ OVR

30

USShift

Compare MEASDMD to HEDGECVR and add 30-min interval pairs to produce 60-min 'over-hedge' curve

Note:

The above table accomplishes two steps: defining profile types and defining the valid profile types for a profile relationship type. When setting up this data, you will need to define your profile types first and then link them to the appropriate profile relationship type.

As with most of your control table design, this is an iterative process. As you design your profile types, you may see the need for new profile relationship types. You may find that a profile type will be valid for more than one profile relationship type.

Fastpath:

During your definition of the profile types, you may determine that new UOMs need to be defined. Refer to Setting Up Unit Of Measure Codes for more information.

During your definition of the profile types, you may determine that new pre-processing calculation groups that need to be defined. Refer to Understanding Calculation Groups and Rules for more information about defining SQI values.

Note:

Now that you have designed the control table values required to support your rate, we recommend that you set up start options for your SA types to assist a CSR in setting up a customer for this rate.

All of the above steps will need to be repeated for each interval billing rate that your company offers. For each rate, you need to define your rate components, your billing factors, your profile relationship types and then the appropriate profile types.