Rolling Demand

This rule is used to calculate rolling demand for all of the service points on the usage subscription. Demand is calculated from consumption. In electric service markets, these are typically represented by kilowatts (kW) and kilowatt hours (kWh) respectively, where demand values are calculated by multiplying consumption interval values by the number of intervals per hour. For example, the demand associated with a fifteen (15) minute interval value of 25kWh would be 100kW (25 x 4 intervals per hour).

This rule has two main modes: calculating rolling demand for a usage subscription based on either a rolling consumption total (Total) or rolling consumption average (Average), or calculating the coincident peak among all of the service points on a usage subscription based on either a rolling consumption total (Total - Coincident Peak) or rolling consumption average (Average - Coincident Peak). The coincident peak calculation can be performed on either all readings, or those designated as "on-peak" or "off-peak" via time of use mapping using the Coincident On-Peak  or Coincident Off-Peak function, See  Defining Time of Use Mapping Options for more information about time of use mapping.

The number of intervals in the rolling total or rolling average is determined via rule configuration. The Roll Interval Size parameter (in the Calculation Details section) divided by the Common Interval Size parameter (in the Interval Data Retrieval Parameters section). For example, if Roll Interval Size was 01:00:00 (1 hour) and the Common Interval Size was 00:15:00 (15 minutes), the rolling total or average would be based on sets of 4 intervals (1 hour divided by 15 minutes).

Rolled Demand Total

The "Rolled Demand Total" Roll Calculate Function identifies the peak demand for the usage subscription based on a rolling consumption total. 

For example, the table below lists sample hourly interval data for two service points belonging to single usage subscription for a 12 hour calculation period. This table includes the following:

  • Date/Time: The date and time of each interval

  • Service Point n: The kWh value for each interval at a specific service point

  • Total: The combined total of consumption at the usage subscription's service points

  • Rolling Total: The rolling total of 4 total values (based on a Roll Interval Size of 01:00:00 (1 hour) and Common Interval Size of 00:15:00 (15 minutes))

  • Demand: The demand calculated from the rolling total (calculated by multiplying the running total by the number of intervals per hour - in this example the total is the same as the demand because this is hourly data).

This rule would identify the highest demand for the usage subscription during the calculation period (indicated in bold).

Date/Time

Service Point 1

Service Point 2

Total

Rolling Total

Demand

10/27/2022 12:00 PM

12

11

23

10/27/2022 1:00 PM

10

12

22

10/27/2022 2:00 PM

11

13

24

10/27/2022 3:00 PM

13

13

26

95

95

10/27/2022 4:00 PM

14

14

28

100

100

10/27/2022 5:00 PM

13

13

26

104

104

10/27/2022 6:00 PM

12

13

25

105

105

10/27/2022 7:00 PM

11

12

23

102

102

10/27/2022 8:00 PM

12

13

25

99

99

10/27/2022 9:00 PM

13

14

27

100

100

10/27/2022 10:00 PM

12

14

26

101

101

10/27/2022 11:00 PM

12

12

24

102

102

This rule would return the following values in the usage transaction service quantities list, which represents the peak demand value during the calculation period:

Date/Time

Demand

10/27/2022 6:00 PM

105

Note: This option should be used for information and reporting purposes only. These values cannot be used for billing purposes.

Rolled Demand Total - Coincident Peak / Rolled Demand Total -  Coincident On Peak / Rolled Demand Total - Coincident Off Peak

The "Rolled Demand Total - Coincident Peak / Rolled Demand Total - Coincident On Peak / Rolled Demand Total - Coincident Off Peak" Roll Calculate Function identify the coincident peak demand for all of the service points on the usage subscription. The "coincident peak" is the time at which the combined values of multiple service points is the highest (which is not necessarily the peak for each individual service point). The coincident peak demand is the demand based on the rolling total at the coincident peak.

The data used in the calculation is based on the specific Roll Calculate Function selected:

  • Total - Coincident Peak: Evaluates all measurements matching the configured unit of measure

  • Total - Coincident On Peak: Evaluates measurements matching the configured unit of measure that falls with the "on peak" TOU period defined in the Results section based on a specified TOU Map Template.

  • Total - Coincident Off Peak: Evaluates measurements matching the configured unit of measure that falls with the "off peak" TOU period defined in the Results section based on a specified TOU Map Template.

For example, the table below lists sample hourly interval data for two service points belonging to single usage subscription for a 12 hour calculation period. This table includes the following:

  • Date/Time: The date and time of each interval

  • Service Point n: The kWh value for each interval at a specific service point

  • Total: The combined total of consumption at the usage subscription's service points

  • Rolling Total: The rolling total of 4 total values (based on a Roll Interval Size of 01:00:00 (1 hour) and Common Interval Size of 00:15:00 (15 minutes))

  • Demand: The demand calculated from the rolling total (calculated by multiplying the running total by the number of intervals per hour - in this example the total is the same as the demand because this is hourly data).

This rule would identify the highest total for all of the service points within the calculation period (indicated in bold).

Date/Time

Service Point 1

Service Point 2

Total

Rolling Total

Demand

10/27/2022 12:00 PM

12

11

23

10/27/2022 1:00 PM

10

12

22

10/27/2022 2:00 PM

11

13

24

10/27/2022 3:00 PM

13

13

26

95

95

10/27/2022 4:00 PM

14

14

28

100

100

10/27/2022 5:00 PM

13

13

26

104

104

10/27/2022 6:00 PM

12

13

25

105

105

10/27/2022 7:00 PM

11

12

23

102

102

10/27/2022 8:00 PM

12

13

25

99

99

10/27/2022 9:00 PM

13

14

27

100

100

10/27/2022 10:00 PM

12

14

26

101

101

10/27/2022 11:00 PM

12

12

24

102

102

This rule would return the following values in the usage transaction service quantities list, which represent the demand at the coincident peak:

Date/Time

Coincident Peak Demand

10/27/2022 4:00 PM

100

Note: This option should be used for information and reporting purposes only. These values cannot be used for billing purposes.

Rolled Demand Average

The "Rolled Demand Average" Roll Calculate Function identifies the peak demand for the usage subscription based on a rolling average (calculated from the rolling total). 

For example, the table below lists sample hourly interval data for two service points belonging to single usage subscription for a 12 hour calculation period. This table includes the following:

  • Date/Time: The date and time of each interval

  • Service Point n: The kWh value for each interval at a specific service point

  • Total: The combined total of consumption at the usage subscription's service points

  • Rolling Total: The rolling total of 4 total values (based on a Roll Interval Size of 01:00:00 (1 hour) and Common Interval Size of 00:15:00 (15 minutes))

  • Rolling Average: The rolling average of 4 total values (based on a Roll Interval Size of 01:00:00 (1 hour) and Common Interval Size of 00:15:00 (15 minutes))

  • Demand: The demand calculated from the rolling average (calculated by multiplying the rolling average by the number of intervals per hour - in this example the total is the same as the demand because this is hourly data).

This rule would identify the highest demand for the usage subscription during the calculation period (indicated in bold).

Date/Time

Service Point 1

Service Point 2

Total

Rolling Total

Rolling Average

Demand

10/27/2022 12:00 PM

12

11

23

10/27/2022 1:00 PM

10

12

22

10/27/2022 2:00 PM

11

13

24

10/27/2022 3:00 PM

13

13

26

95

23.75

23.75

10/27/2022 4:00 PM

14

14

28

100

25

25

10/27/2022 5:00 PM

13

13

26

104

26

26

10/27/2022 6:00 PM

12

13

25

105

26.25

26.25

10/27/2022 7:00 PM

11

12

23

102

25.5

25.5

10/27/2022 8:00 PM

12

13

25

99

24.75

24.75

10/27/2022 9:00 PM

13

14

27

100

25

25

10/27/2022 10:00 PM

12

14

26

101

25.25

25.25

10/27/2022 11:00 PM

12

12

24

102

25.5

25.5

This rule would return the following values in the usage transaction service quantities list, which represents the peak demand value during the calculation period:

Date/Time

Demand

10/27/2022 6:00 PM

26.25

Note: This option should be used for information and reporting purposes only. These values cannot be used for billing purposes.

Rolled Demand Average - Coincident Peak / Rolled Demand Average -  Coincident On Peak / Rolled Demand Average - Coincident Off Peak

The "Average - Coincident Peak / Average - Coincident On-Peak / Average - Coincident Off-Peak" Calculate Function identify the coincident peak demand for all of the service points on the usage subscription. The "coincident peak" is the time at which the combined values of multiple service points is the highest (which is not necessarily the peak for each individual service point). The coincident peak demand is the demand based on the rolling average at the coincident peak.

The data used in the calculation is based on the specific Roll Calculate Function selected:

  • Rolled Demand Total - Coincident Peak: Evaluates all measurements matching the configured unit of measure

  • Rolled Demand Total - Coincident On Peak: Evaluates measurements matching the configured unit of measure that falls with the "on peak" TOU period defined in the Results section based on a specified TOU Map Template.

  • Rolled Demand Total - Coincident Off Peak: Evaluates measurements matching the configured unit of measure that falls with the "off peak" TOU period defined in the Results section based on a specified TOU Map Template.

For example, the table below lists sample hourly interval data for two service points belonging to single usage subscription for a 12 hour calculation period. This table includes the following:

  • Date/Time: The date and time of each interval

  • Service Point n: The kWh value for each interval at a specific service point

  • Total: The combined total of consumption at the usage subscription's service points

  • Rolling Total: The rolling total of 4 total values (based on a Roll Interval Size of 01:00:00 (1 hour) and Common Interval Size of 00:15:00 (15 minutes))

  • Rolling Average: The rolling average of 4 total values (based on a Roll Interval Size of 01:00:00 (1 hour) and Common Interval Size of 00:15:00 (15 minutes))

  • Demand: The demand calculated from the rolling average (calculated by multiplying the rolling average by the number of intervals per hour - in this example the total is the same as the demand because this is hourly data).

This rule would identify the highest demand for the usage subscription during the calculation period (indicated in bold).

Date/Time

Service Point 1

Service Point 2

Total

Rolling Total

Rolling Average

Demand

10/27/2022 12:00 PM

12

11

23

10/27/2022 1:00 PM

10

12

22

10/27/2022 2:00 PM

11

13

24

10/27/2022 3:00 PM

13

13

26

95

23.75

23.75

10/27/2022 4:00 PM

14

14

28

100

25

25

10/27/2022 5:00 PM

13

13

26

104

26

26

10/27/2022 6:00 PM

12

13

25

105

26.25

26.25

10/27/2022 7:00 PM

11

12

23

102

25.5

25.5

10/27/2022 8:00 PM

12

13

25

99

24.75

24.75

10/27/2022 9:00 PM

13

14

27

100

25

25

10/27/2022 10:00 PM

12

14

26

101

25.25

25.25

10/27/2022 11:00 PM

12

12

24

102

25.5

25.5

This rule would return the following values in the usage transaction service quantities list, which represents the peak demand value during the calculation period:

Date/Time

Demand

10/27/2022 4:00 PM

25

Note: This option should be used for information and reporting purposes only. These values cannot be used for billing purposes.

Notes and Recommendations

  • When using he "Coincident On Peak" or "Coincident Off Peak" Roll Calculate Function, you must specify either a TOU map (in the TOU Map field) or a TOU map template (in the On Peak Off Peak Schedule drop-down list) in the Calculation Details section, and specify the appropriate time of use period (On-Peak or Off-Peak, respectively) in the TOU field in the Results section.

  • A recommended practice is to configure a Service Quantity Identifier (SQI) to uniquely identify coincident peak data and specify it in the SQI field in the Results section.

Note:  Additional detail on the logic of this rule can be found in the Detailed Description of the D1-CALROLDEM Algorithm Type.

For help with the meaning of specific configuration fields, refer to the embedded help on the screen when adding or editing the rule.

Business Object

D1-CalcRollingDemandRule

Example Scenarios

Below are some example scenarios that can be achieved based on configuration of this rule.

Scenario 1: Calculate demand for services points based on rolling total

  • Interval Data Retrieval Parameters:

    • UOM: Kilowatt-Hour

    • Common Interval Size: 00:15:00

  • Calculation Details:

    • Roll Calculate Function: Rolled Demand Total

    • Roll Interval Size: 01:00:00

  • Results

    • UOM: Kilowatt

    • TOU

    • SQI

Scenario 2: Calculate demand for services points based on rolling average

  • Interval Data Retrieval Parameters:

    • UOM: Kilowatt-Hour

    • Common Interval Size: 00:15:00

  • Calculation Details:

    • Roll Calculate Function: Rolled Demand Average

    • Roll Interval Size: 01:00:00

  • Results

    • UOM: Kilowatt

    • TOU

    • SQI

Scenario 3: Total - Coincident Peak 

  • Interval Data Retrieval Parameters:

    • UOM: Kilowatt-Hour

    • Common Interval Size: 00:15:00

  • Calculation Details:

    • Roll Calculate Function: Rolled Demand Total, Coincident Peak

    • Roll Interval Size: 01:00:00

  • Results

    • UOM: Kilowatt

    • TOU

    • SQI: Coincident Peak

Scenario 4: Average - Coincident On Peak

  • Interval Data Retrieval Parameters:

    • UOM: Kilowatt-Hour

  • Calculation Details:

    • Roll Calculate Function: Rolled Demand Average, Coincident, On Peak

    • Roll Interval Size: 01:00:00

    • Reference TOU Map by Template: Yes

    • On Peak Off Peak Schedule: <TOU map template>

  • Results

    • UOM: Kilowatt

    • TOU: On Peak

    • SQI: Coincident On Peak