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.
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 |
- 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.
- 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.
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 |