IBM Support

Average Units Per Day Calculation

Question & Answer


Question

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

Answer


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.

Date10/1/0910/2/0910/3/09
Time12:00am2:00am12:00pm
Reading10 (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:

Date10/1/0910/2/0910/3/09
Time12:00am12:00am12:00pm
Reading10 (delta)10 (delta)30 (delta)

20 / 1.5 day

Average = 13.3 units / day

Calculation for Sliding Days:
      Determine the number of readings ‘n’ by subtracting AvgCalcValue from the current day.
      Reading(new) + Reading(new-1)…Reading(new-n)
      ------------------------------------------------------
      Reading Date(new) – Reading Date(new-n)


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:

Date10/1/0910/2/09
Time12:00am12:00am
Reading10 (delta)10 (delta)

10 / 1 day

Average = 10 units / day

Date10/1/0910/2/0910/3/09
Time12:00am2:00am2:00pm
Reading10 (delta)10 (delta)30 (delta)

30 / 1.5

Average = 20 units / day

Calculation for Sliding Readings:
      Reading(new) + Reading(new-1)…Reading(new-n)
      ------------------------------------------------------
      Reading Date(new) – Reading Date(new-n)

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Assets","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
13 April 2021

UID

swg21406743