What is the meter average calculation?

What is the meter average calculation?

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:

  1. 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:
  1. 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.
  2. 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:
  1. Window size of moving average: 4 (readings)
  2. 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.
  3. 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.

        IIIMoving 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:
  1. Window Size of Moving Average: 3 (days)
  2. 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.
  3. 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.

    • Related Articles

    • How can I create monitorings?

      The monitorings are system entities which allow for monitoring the normal operation of the assets by monitoring a preset value and, depending on its positive or negative variation, trigger corrective maintenance actions. To create a new monitoring, ...
    • How is the average of condition controls calculated?

      When inserting monitoring values, the moving average is calculated for that value considering the average window defined in the monitoring and the average window value used on the calculation is also saved. It is performed for the next N-1 values (in ...
    • How do I insert meters values?

      Valuekeep meters can be fed information from individual records or through batch records by importing .csv files. To insert a new meter reading, select the option Assets | Meters and Monitorings | Meters: A meter list is presented; Press the button ...
    • How to see the list of meter readings?

      The meter reading list allows the maintenance manager to view the readings of all meters, whether they are from work order or not. To view the list, on the menu select the option "Assets | Explore | Meter Readings" or search by "Meter Readings". The ...
    • How do I inactivate assets?

      This operation makes it easier to inactivate a set of assets and corresponding child assets. To access this option on the equipment or tool view screen, select the option Deactivation History. There are 3 asset inactivation modes: Dispose (this ...