The meter average is calculated every time a meter value record is performed as long as the average window field is different than zero.
The field "Window Size of Moving Average" is considered as the maximum number of readings/days to be included in the calculation of the meter average.
There are 3 methods to calculate a meter average:
- Global: meter value average based on all meter readings previous to the reading. To the current meter reading, we subtract the value of the first reading and the value is divided by the day differences between two readings. If there are only readings on the same day as the current record, the average will be the difference between the current record and the first reading. In this method, the following field is not filled in "Window Size of Moving Average".
Example:
Date | Cummulative Reading | Increment | Dif. Reading | Dif. Days | Average |
15/jan | 200 | 200 | 0 | 0 | 0 |
16/jan | 300 | 100 | 100 | 1 | 100 |
19/jan | 350 | 50 | 150 | 4 | 37.50 |
21/jan | 370 | 20 | 170 | 6 | 28,33 |
After inserting the readings, the following average values are presented:
- The average calculation for January 16th is: the last inserted record, 300, to be subtracted EVERY TIME on the first recorded reading, 200. Then, it is divided by the difference between the number of reading days and the used records, on this case, the difference is 1 day. This way: [(300 - 200) / 1 ] = 100.
- The average calculation for January 21st is: the last inserted reading, that is 370, to be subtracted by the first recorded reading, 200. After subtracting, we divide by the difference of the number of days between these two reading records, that is, day 21 - day 15. This way: [(370 - 300 ) / 6 ] = 28,33.
II. Moving Average – Readings: average calculation based on the number of previous readings. This number is defined on the field Window Size of Moving Average.
Example:
Date | Cummulative Reading | Increment | Dif. Reading | Dif. Days | Average |
15/jan | 200 | 200 | 0 | 0 | 0 |
16/jan | 300 | 100 | 100 | 1 | 100 |
17/jan | 0 | 0 | - | - | - |
18/jan | 0 | 0 | - | - | - |
19/jan | 350 | 50 | 50 | 3 | 16.67 |
24/jan | 370 | 20 | 70 | 8 | 8,75 |
After inserting the readings, the following average values are presented:
- Window size of moving average: 4 (readings)
- The average calculation for January 16th is: the last inserted record, 300, to be subtracted to the fourth recorded reading. Since we do not have that record, the one for January 15th is used, 200. Then, it is divided by the difference between the number of reading days and the used records, on this case, the difference is 1 day. This way: [(300 - 200) / 1 ] = 100.
- The average calculation for January 24th is: the last inserted reading, that is 370, to be subtracted by the fourth recorded reading, that is the reading recorded on January 17th, however, on that day, there were no records. Let's use the last one inserted, the reading for January 16th, 300. After subtracting, we divide by the difference of the number of days between these two reading records, that is, day 24 - day 16. This way: [(370 - 300 ) / 8 ] = 8,75.
III. Moving Average – Days: average calculation based on readings recorded on a set of days previous to the current record. If there are no reading record on that time period, is used as the reading for the record previous to the current one. The number of days is defined on the fields Window Size of Moving Average.
Example:
Date | Cummulative Reading | Increment | Dif. Reading | Dif. Days | Average |
15/jan | 200 | 200 | 0 | 0 | 0.00 |
16/jan | 300 | 100 | 100 | 1 | 100.00 |
17/jan | 0 | 0 | - | - | - |
18/jan | 0 | 0 | - | - | - |
19/jan | 350 | 50 | 50 | 3 | 16,67 |
After inserting the readings, we have the following average values:
- Window Size of Moving Average: 3 (days)
- The average calculation for January 16th is: the last inserted record, 300, to be subtracted by the reading recorded 3 days ago. Since we do not have the record for January 13th, the one for January 15th is used, 200. Then, it is divided by the difference between the number of days and the used records, on this case, the difference is 1 day. This way: [(300 - 200) / 1 ] = 100.
- The average calculation for January 19th is: the last inserted reading, that is 350, to be subtracted by the reading recorded 3 days ago, 300. If a recorded reading is not found, it uses the next older record and divides it by the difference of the number of days (January 19th - January 16th). This way: [(350 - 300 ) / 3] = 16,67.