User-Defined Weighting
1.3.2.1 Examples for Mixed Weighting
The following examples describe extrapolation with mixed weightings. The examples use degree day weighting which is defined with the following values in Customizing for SAP Utilities under Device Management Meter Reading Weighting Procedures :
Degree Day Weighting
Note: Degree day weightings are absolute values without units. They only represent weightings and not measured energy quantities. The weighting values relate to calendar days of a year, not to months. Therefore, for the total weighting of an extrapolation period, each individual day has to be taken into account with the respective degree day weighting. Calculation example: The total of the degree day weightings for the period January 1 to January 31 is 31 * 20 = 620. This is the result of 31 days with the weighting 20.
Example
Degree day weighting with consumption percentage for weighting The following data and general conditions apply:
Register type: Cumulative consumption register Weighting key: Degree day weighting
Mixed weighting: Consumption percentage for weighting = 10%
Base period category: Previous period Length of base period: 12 months Period consumption = 5,000 kWh
The example contains a move-in on January 1, 2009 with an initial move-in meter reading. Extrapolation is executed three times based on the period consumption with reference to the date of the move-in meter reading.
From the consumption percentage for weighting, you can derive that 500 kWh (10% of the period consumption) is used during extrapolation for the linear consumption percentage and is distributed evenly over all 365 days. The remaining 4,500 kWh from the period consumption are incorporated into extrapolation by means of degree day weighting and are distributed as shown in the figure Degree Day Weighting .
The following weighting totals are calculated in Customizing for the relevant periods:
Period Total for Degree Day Weighting
01.01.2009 – 01.31.2009 620
01.01.2009 – 06.30.2009 2495
01.01.2009 – 12.31.2009 4395
Formula for extrapolation:
For degree day weighting with a consumption percentage for weighting, the consumption comprises of two parts:
Extrapolated Consumption = Degree Day Weighted Consumption + Linear Consumption Percentage Both parts contain consumption determined as follows:
Degree Day Weighting Consumption = Period Consumption * 90% * (Total from Degree Day Weighting / Degree Day Annual Weighting) Linear Consumption Percentage = Period Consumption * 10% (No. Days / 365)
The percentage results from the available data.
Results of Extrapolation by Using Known Values
Note: The results are rounded to 2 decimal places.
Example
Degree day weighting with consumption to be weighted linearly The following data and general conditions apply:
Register type: Cumulative consumption register Weighting key: Degree day weighting
Mixed weighting: Consumption to be weighted linearly = 10 kWh with validity period June 1 to August 31.
Base period category: Previous period Length of base period: 12 months Period consumption = 5,000 kWh
The example contains a move-in on January 1, 2009 with an initial move-in meter reading. Extrapolation is executed three times based on the period consumption with reference to the date of the move-in meter reading.
From the consumption to be weighted linearly, you can derive that 920 kWh (92 days in the period June 1 to August 8 at 10 kWh/day) is used during extrapolation for the linear consumption. The remaining 4,080 kWh from the period consumption are incorporated into extrapolation by means of degree day weighting and are distributed as shown in the figure Degree Day Weighting .
The following weighting totals are calculated in Customizing for the relevant periods:
PUBLIC Page 36 of 96
Period Total for Degree Day Weighting
01.01.2009 – 01.31.2009 620
01.01.2009 – 06.30.2009 2495
01.01.2009 – 12.31.2009 4395
Formula for extrapolation:
For degree day weighting with consumption to be weighted linearly, the consumption comprises of two parts:
Extrapolated Consumption = Degree Day Weighted Consumption + Absolute Linear Consumption Both parts contain consumption determined as follows:
Degree Day Weighted Consumption = (Period Consumption - Linear Weighted Consumption * Validity Period)1) * )Total from Degree Day Weighting / Degree Day Annual Weighting)
Linear Consumption Percentage = Linear Weighted Consumption per Day * Number of Days 1) According to data provided in example, a value of 4,080 kWh
Results of Extrapolation by Using Known Values
Note: The results are rounded to 2 decimal places.
1.3.9.1.3.4.1 Extrapolation
In order to determine the expected consumption or the expected performance for a register on a specific date, you need data on the metering patterns of the register.
You can take this information from previous meter reading results, from a predefined periodic consumption value or from a predefined period demand.
The base period from which the expected values are calculated is very important during extrapolation. The period in which bases are created to determine expected values during extrapolation are included in the base period. Using the base period category field in the installation, you can control whether to extrapolate the expected values based on the previous period or the period of the previous year.
Meter reading results are the ideal base from which to determine expected values, as these results best reflect the consumption patterns of the customer. In order to use meter reading results, you must ensure that the base period (the interval between the first and the last meter reading result) used for extrapolation is representative.
You can only extrapolate from a previous period, if it is representative. Whether a period is representative or not is a result of the original weighting procedure.
Determining Whether a Period is Representative
To determine whether a base period is representative, use the following information:
Weighting portion of period = Minimum portion or
Minimum portion in percent * Length of meter reading period
= Minimum length of base period Example
The following meter reading reasons exist:
P eriodic meter reading F inal meter reading Meter reading at move-in ( M ) Meter reading at installation ( I ) Interim meter reading without billing ( Y ) Interim meter reading with billing ( Z ) C ontrol meter reading
The period length of the portion is 1 year (365 days) The minimum portion defined in the rate is 50%
The minimum requirements to determine whether the base period is representative are determined in the following way:
Weighting portion of period = Minimum portion or
Minimum portion in percent (50%) * Length of meter reading period (365 days)
= Minimum length of base period (182.5 days)
In the example, the base period must have a minimum weighting portion of 50% or be at least 182.5 days long in order to be representative.
( )
The period from P to Y is not representative because it does not have the minimum weighting portion (only 20% rather than the required 50%). This means that this period alone cannot be used as a basis for extrapolation. The system goes back to the previous reading (I). The period from P to I is representative because it has a weighting portion of 20% + 60% = 80%. The period from P to I can be used as a basis for extrapolation.
Meter Reading Results or Period Value as a Basis for Extrapolation
The system determines whether to use meter reading results or a selected period value as a basis for extrapolation in the following way:
Based on the last correct meter reading results, the system goes back to the previous reading and runs through the following process:
( )
If you enter a modified periodic consumption in transaction Maintain Periodic Consumption (EL 56) for a point in time that lies within the base period for the next extrapolation, the system will inform you that the entered periodic consumption can influence the extrapolation results.
Determination of Expected Consumption for Consumption Registers Determination of the expected consumption based on the meter reading results
1. You can calculate the consumption per unit of weight from the determined consumption and the determined weight of the base period: