# Average Units Per Day Calculation

## Question

Is there a way to calculate average units per day in Maximo?

Average Units per Day are calculated based on the following Average Calculation Method:

All: Use all readings taken for the given asset and meter to calculate the average.

 Date 10/1/09 10/2/09 10/3/09 Time 12:00am 2:00am 12:00pm Reading 10 (delta) 10 (delta) 30 (delta)

10+10+30 / 2.5 days

Average = 20 units / day

Note: If the above readings were entered after the fact (i.e. 7/1/02) the average would be the same. The date delta is calculated as time between readings, not until today.

Sliding Days: This method uses a sliding window. The user states how many days of readings should be included in the window.

The user has determined that readings from the last 2 days will be used:

 Date 10/1/09 10/2/09 10/3/09 Time 12:00am 12:00am 12:00pm Reading 10 (delta) 10 (delta) 30 (delta)

20 / 1.5 day

Average = 13.3 units / day

Sliding Readings: This method uses a sliding window. The user states how many readings to include in the window, the last ‘n’ readings, and as subsequent readings are taken, the window moves.

The user has determined that only the last 2 readings will be used:

 Date 10/1/09 10/2/09 Time 12:00am 12:00am Reading 10 (delta) 10 (delta)

10 / 1 day

Average = 10 units / day

 Date 10/1/09 10/2/09 10/3/09 Time 12:00am 2:00am 2:00pm Reading 10 (delta) 10 (delta) 30 (delta)

30 / 1.5

Average = 20 units / day