Performance calculations on equipment level - HxGN EAM - 11.07.01 - Feature Briefs - Hexagon

Condition Rating

Convert the calculated equipment Condition Score to the Condition Rating. This process converts a number range to another range while maintaining the ratio as follows:

Old Range = (Old Maximum – Old Minimum)

New Range = (New Maximum – New Minimum)

Rating = (((Old Value – Old Minimum) * New Range) / Old Range) + New Minimum

Old range is determined by the Condition Score Start and Condition Score End of the equipment and can be found on the decay curve or the equipment ranking.

New range is from 0 to 100. Note that all other ratings calculated for the performance also range from 0 to 100.

Old Value is the calculated Condition Score of the equipment.

Capacity Code

Copy of the Capacity Code from the selected performance formula.

Available Capacity

For the selected Capacity Code, the system will:

Use the current active Capacity attached to the equipment.

If nothing found, then search on the equipment Category level.

If still nothing found, then search on the equipment Class level.

On Category and Class level the system always searches capacities on the equipment class definition record where the Organization matches that of the equipment. If no data is found or the record(s) do not exist, then the system searches for the same where the Organization matches that of the equipment and the Class/Class Org. is */*. If still no data is found, or no record exists, then then the system searches for the same where the Organization is * and the Class/Class Org. is */*.

If nothing is found, the system will leave this field blank.

Desired Capacity

Like Available Capacity but searching for Desired Capacity.

Capacity Rating

Capacity Rating = Available Capacity / Desired Capacity * 100

To not impact the performance negatively the system will set this to 100 if Available Capacity or Desired Capacity or both are blank or if Desired Capacity is zero or if the calculated Capacity Rating is > 100.

Number of Failures

Count the number of ‘technically completed’ breakdown (system job type ‘BR’) work orders attached to the equipment. A technically completed work order has a completion date filled in but may still have a released status. If Include Children is selected on the formula, work orders against child equipment will also be included in the count.

Work orders will be counted over the past year only.

MTBF (Days)

365 / Number of Failures. If Number of Failures is 0 set to blank.

MTBF Rating

Set Failures equal to the minimum of Number of Failures and Maximum Allowable Failures per Year.

MTBF Rating = 100 - ((Failures * 100) / Maximum Allowable Failures per Year)

MUBF

365 * Daily Average Usage / Number of Failures.

System only calculates this value if Usage Based is selected on the formula. Set to blank otherwise or if Number of Failures is 0.

MUBF Rating

Like MTBF but now the calculation is based on the number of failures per usage.

System only calculates this value if Usage Based is selected on the formula.

If the Meter Unit of the Equipment is not equal to At Usage per Day UOM on the selected formula, the system will try to convert At Usage per Day to the Meter Unit.

MTTR (Hours)

See Number of Failures for a description on how the system determines which work orders to include. For the included work orders the system calculates the average repair time as follows:

If Use Downtime Hours if Present is selected on the formula, use this value to calculate repair time for the work order.

If unselected or if on the work order Downtime Hours is blank, then calculate repair time based on the setting of Repair Time Calculation on the formula:

If WO Closed / Reported, the repair time is the difference between the work order Date Completed and the Date/Time Reported.

Otherwise repair time is the sum of the maximum hours of any one person for each day that hours are booked on the work order.

MTTR (Hours) = average repair time of all included work orders. If no work orders are found set to zero.

MTTR Rating

Set Repair Time equal to the minimum of MTTR (Hours) and Maximum Allowable Repair Hours

MTTR Rating = 100 - ((Repair Time * 100) / Maximum Allowable Repair Hours)

Variable 1 Result

Populate with the query result of the Variable 1 Query associated to Variable 1 of the selected formula.

Variable 1 Rating

System determines:

Range = Absolute (Best Acceptable Result 1 – Worst Acceptable Result 1)

Minimum = Minimum of Best Acceptable Result 1 and Worst Acceptable Result 1

Maximum = Maximum of Best Acceptable Result 1 and Worst Acceptable Result 1

Variable =

Minimum if Variable 1 Result < Minimum,

else Maximum if Variable 1 Result > Maximum,

else Variable 1 Result.

Variable 1 Rating = (((Variable – Minimum) * 100) / Range)

And if the Best Acceptable Result 1 < Worst Acceptable Result 1, then

Variable 1 Rating = 100 – Variable 1 Rating

Variable n Result

For variable 2 through 6 results, see Variable 1 Result.

Variable n Rating

For variable 2 through 6 results, see Variable 1 Rating.

Performance

Performance =

Condition Rating * Condition Rating Weight +

Capacity Rating * Capacity Rating Weight +

MTBF Rating (or MUBF Rating if Usage Based) * MTBF Rating Weight +

MTTR Rating * MTTR Rating Weight +

Variable 1 Rating * Variable 1 Rating Weight +

Variable 2 Rating * Variable 2 Rating Weight +

Variable 3 Rating * Variable 3 Rating Weight +

Variable 4 Rating * Variable 4 Rating Weight +

Variable 5 Rating * Variable 5 Rating Weight +

Variable 6 Rating * Variable 6 Rating Weight

Performance Formula

Set to the selected Performance Formula.

Performance Last Updated

Set equal to system date/time the calculation took place.