Example - Consumption accruals

The example in this topic shows how missing data for several contiguous months is populated with accrued data over a period of 12 months.

Example

Table 1 shows consumption data for electricity for 2023. The last three months are missing data.

Table 1. Consumption data with gaps
Month Number of days Consumption Unit
January 2023 31 200.0 kWh
February 2023 28 200.0 kWh
March 2023 31 150.0 kWh
April 2023 30 200.0 kWh
May 2023 31 200.0 kWh
June 2023 30 200.0 kWh
July 2023 31 200.0 kWh
August 2023 31 200.0 kWh
September 2023 30 200.0 kWh
October 2023 31 Missing data kWh
November 2023 30 Missing data kWh
December 2023 31 Missing data kWh
In this example, the data is from 1 January 2023 to 20 September 2023. The daily average consumption value is calculated as follows:
  • Total number of days of data is 273 days.
  • Total consumption for this period is 1750 kWh
  • Daily average is calculated as 1750/273, which is equal to 6.41 kWh per day.
When the system adds accrued values for October, November, and December, it multiples the daily average value by the number of days that are missing in that month. For example:
  • For October, the accrual value is 6.41 kWh per day * 31 days, which is equal to 198.7 kWh.
  • For November, the accrual value is 6.41 kWh per day * 30 days, which is equal to 192.3 kWh.
  • For December, the accrual value is 6.41 kWh per day * 31 days, which is equal to 198.7 kWh.
An updated version of the data set with the accrued values is displayed in Table 2.
Table 2. Consumption data with accruals
Month Number of days Consumption Unit
January 2023 31 200.0 kWh
February 2023 28 200.0 kWh
March 2023 31 150.0 kWh
April 2023 30 200.0 kWh
May 2023 31 200.0 kWh
June 2023 30 200.0 kWh
July 2023 31 200.0 kWh
August 2023 31 200.0 kWh
September 2023 30 200.0 kWh
October 2023 31 198.7 kWh
November 2023 30 192.3 kWh
December 2023 31 198.7 kWh
In this example, the values for October, November, and December are accrual values.