Maintenance Formulas
This documentation provides detailed explanations of the formulas used to calculate various KPIs. These KPIs are crucial for monitoring and improving the efficiency of maintenance processes.
Maintenance Notifications
Maintenance Order reaction time
Measures the time from the occurrence of a failure or maintenance request to the moment when a technician starts working on the maintenance order.
Formula:
If Maintenance Notification (MN) is connected to the Maintenance Order (MO):
Reaction Time = MO Start Time − MN Creation Time
If Maintenance Notification is not connected to the Maintenance Order:
Reaction Time = MO Start Time − MO Creation Time
Maintenance Orders in process and finished
KPI - Average reaction time
Represents the average time it takes for technicians to begin work on maintenance orders after they are reported, calculated for a specified list of equipment and time period.
Formula:
Only maintenance orders that meet the following criteria are included in the calculation:
The maintenance order must be completed (
Finish Timeis not null).The
Start Timeof the maintenance order must be greater than or equal to the cutoff time, which is defined as the current time minus the value of themaintenance_order_average_reaction_timeparameter (Parametrization - Other - Setting - Maintenance).
Average Reaction Time = ∑(MO Reaction Time) / MO Count
KPI - Mean time to repair (MTTR)
The average time required to repair equipment, measured from the start of a failure or incident to its completion, calculated for a specified list of equipment and time period.
Formula:
Only maintenance orders that meet the following criteria are included in the calculation:
The maintenance order must be completed (
Finish Timeis not null).The
Start Timeof the maintenance order must be greater than or equal to the cutoff time, which is defined as the current time minus the value of themaintenance_order_average_reaction_timeparameter (Parametrization - Other - Setting - Maintenance).
MTTR = ∑(MO Total Time) / MO Count
KPI - Mean time between failures (MTBF)
Formula:
Only maintenance orders that meet the following criteria are included in the calculation:
The maintenance order must be completed (
Finish Timeis not null).The
Start Timeof the maintenance order must be greater than or equal to the cutoff time, which is defined as the current time minus the value of themaintenance_order_average_reaction_timeparameter (Parametrization - Other - Setting - Maintenance).
For each finished MO, the previously finished MO is found, and the time between failures is calculated based on the use_time_created_breakdown_begin setting:
Time Between Failure = MO Time Start or Time Created − Previous MO Time Finished
If Time Start or Time Created is higher/lower than Time Finished, the result is 0.
In the case of the first MO in the period:
Time Between Failure = Time Start or Time Created − Initial Time
If the parameter in Parametrization - Settings - Maintenance: Include end of last Maintenance Order in MTBF report is active, Time Between Failure is also calculated for the last finished MO and the current time.
MTBF Calculation:
MTBF = ∑(MO Time Between Failure) / MO Count
Column - Mean time to repair
The average time required to repair equipment, measured from the start of a failure or incident to its completion, calculated for a selected equipment and time period.
Formula:
Only maintenance orders that meet the following criteria are included in the calculation:
The maintenance order must be completed (
Finish Timeis not null).The
Start Timeof the maintenance order must be greater than or equal to the cutoff time, which is defined as the current time minus the value of themaintenance_order_average_reaction_timeparameter (Parametrization - Other - Setting - Maintenance).
Following formula is used for MTTR calculation:
MTTR = ∑(MO Total Time) / MO Count
Column - Mean time between failures
The average time between equipment failures, measured from the completion of one repair to the occurrence of the next failure, calculated for a selected equipment and time period.
Formula:
Only maintenance orders that meet the following criteria are included in the calculation:
The maintenance order must be completed (
Finish Timeis not null).The
Start Timeof the maintenance order must be greater than or equal to the cutoff time, which is defined as the current time minus the value of themaintenance_order_average_reaction_timeparameter (Parametrization - Other - Setting - Maintenance).
For each finished MO, the previously finished MO is found, and the time between failures is calculated based on the use_time_created_breakdown_begin setting:
Time Between Failure = MO Time Start or Time Created − Previous MO Time Finished
If Time Start or Time Created is higher/lower than Time Finished, the result is 0.
In the case of the first MO in the period:
Time Between Failure = Time Start or Time Created − Initial Time
If the parameter in Parametrization - Settings - Maintenance: Include end of last Maintenance Order in MTBF report is active, Time Between Failure is also calculated for the last finished MO and the current time.
MTBF Calculation:
MTBF = ∑(MO Time Between Failure) / MO Count
Column - Total time
The total time spent on a maintenance order, measured from the occurrence of the failure to its completion.
Formula:
If the parameter in Parametrization - Settings - Maintenance is unchecked:
Total Time = MO Time Finished − MO Time Started
If the parameter in Parametrization - Settings - Maintenance is checked:
Total Time = MO Time Finished − MN Time Created
if Maintenance Notification is connected
Total Time = MO Time Finished − MO Time Created
if no Maintenance Notification is connected
Column - Reaction time
Measures the time from the occurrence of a failure or maintenance request to the moment when a technician starts working on the maintenance order.
Formula:
If Maintenance Notification (MN) is connected to the Maintenance Order (MO):
Reaction Time = MO Start Time − MN Creation Time
If Maintenance Notification is not connected to the Maintenance Order:
Reaction Time = MO Start Time − MO Creation Time
Equipments
Mean time to repair
The average time required to repair equipment, measured from the start of a failure or incident to its completion, calculated for a specified list of equipment and time period.
Formula:
Only maintenance orders that meet the following criteria are included in the calculation:
The maintenance order must be completed (
Finish Timeis not null).The
Start Timeof the maintenance order must be greater than or equal to the cutoff time, which is defined as the current time minus the value of themaintenance_order_average_reaction_timeparameter (Parametrization - Other - Setting - Maintenance).
Following formula is used for MTTR calculation:
MTTR = ∑(MO Total Time) / MO Count
Mean time between failures
The average time between equipment failures, measured from the completion of one repair to the occurrence of the next failure, calculated for a specified list of equipment and time period.
Formula:
Only maintenance orders that meet the following criteria are included in the calculation:
The maintenance order must be completed (
Finish Timeis not null).The
Start Timeof the maintenance order must be greater than or equal to the cutoff time, which is defined as the current time minus the value of themaintenance_order_average_reaction_timeparameter (Parametrization - Other - Setting - Maintenance).
For each finished MO, the previously finished MO is found, and the time between failures is calculated based on the use_time_created_breakdown_begin setting:
Time Between Failure = MO Time Start or Time Created − Previous MO Time Finished
If Time Start or Time Created is higher/lower than Time Finished, the result is 0.
In the case of the first MO in the period:
Time Between Failure = Time Start or Time Created − Initial Time
If the parameter in Parametrization - Settings - Maintenance: Include end of last Maintenance Order in MTBF report is active, Time Between Failure is also calculated for the last finished MO and the current time.
MTBF Calculation:
MTBF = ∑(MO Time Between Failure) / MO Count
Count of maintenance Orders
The total number of maintenance orders (MOs) finished on this Equipment during specified time period. This KPI includes all types of maintenance orders (corrective, breakdown, preventive) within the reporting period.
CMOI = Count of distinct MOs on this Equipment during the period
Deleted Maintenance Orders are also counted in this value.
Spent time
Measures the total time all technicians spent actively working on the maintenance of a specific piece of equipment during a given time period.
Formula:
Spent Time = (MO Finished − MO Start Time) × Number of Technicians
The number of technicians is determined from the history of the MO, counting all assigned technicians at any given time.
Downtime
Measures the duration for which equipment was non-operational during a specified period, calculated from the reporting of a breakdown to its complete resolution.
Formula:
Downtime = MO* Time Finished − MN* Time Created
if Maintenance Notification is connected
Downtime = MO* Time Finished − MO* Time Created
if no Maintenance Notification is connected
Calculated from Breakdown type of issues only
Equipments - Report
Mean time to repair (MTTR)
The average time required to repair equipment, measured from the start of a failure or incident to its completion, calculated for a specified list of equipment and time period.
Formula:
All breakdown Maintenance Orders that were completed and also started during specified time period and are connected with this equipment are loaded and following formula is used to calculate MTTR:
MTTR = ∑(MO Total Time) / MO Count
Mean time between failures (MTBF)
The average time between equipment failures, measured from the completion of one repair to the occurrence of the next failure, calculated for a specified list of equipment and time period.
Formula:
All breakdown Maintenance Orders that were completed and also started during specified time period and are connected with this equipment are loaded and for each finished MO, the previously finished MO is found, and the time between failures is calculated based on the use_time_created_breakdown_begin setting:
Time Between Failure = MO Time Start or Time Created − Previous MO Time Finished
If Time Start or Time Created is higher/lower than Time Finished, the result is 0.
In the case of the first MO in the period:
Time Between Failure = Time Start or Time Created − Initial Time
If the parameter in Parametrization - Settings - Maintenance: Include end of last Maintenance Order in MTBF report is active, Time Between Failure is also calculated for the last finished MO and the current time.
MTBF Calculation:
MTBF = ∑(MO Time Between Failure) / MO Count
Count of maintenance Orders
The total number of maintenance orders (MOs) finished on this Equipment during specified time period. This KPI includes all types of maintenance orders (corrective, breakdown, preventive) within the reporting period.
CMOI = Count of distinct MOs on this Equipment during the period
Deleted Maintenance Orders are also counted in this value.
Spent time
Measures the total time all technicians spent actively working on the maintenance of a specific piece of equipment during a given time period.
Formula:
Spent Time = (MO Finished − MO Start Time) × Number of Technicians
The number of technicians is determined from the history of the MO, counting all assigned technicians at any given time.
Downtime
Measures the duration for which equipment was non-operational during a specified period, calculated from the reporting of a breakdown to its complete resolution.
Formula:
Downtime = MO* Time Finished − MN* Time Created
if Maintenance Notification is connected
Downtime = MO* Time Finished − MO* Time Created
if no Maintenance Notification is connected
Calculated from Breakdown type of issues only
Technicians
Spent on Maintenance Orders
Measures the net time a technician spent working on maintenance orders (MOs) during a last X number of days specified in parameter Technician worklog history interval setting in Parametrization - Settings - Maintenance:
It includes all types of orders (corrective, breakdown, preventive) and only counts the time when the order was in the "In Progress" status. Time in the "Paused" or “Redbox” status is not included. The KPI value is calculated as the sum of all times the technician worked on orders during the reporting period.
SMO=∑(MO Time Finished − MO Time Started) for all MOs in "In Progress" status
Count of Maintenance Orders involved
The total number of maintenance orders (MOs) a technician worked on during a last X number of days specified in parameter Technician worklog history interval setting in Parametrization - Settings - Maintenance:
This KPI includes all types of maintenance orders (corrective, breakdown, preventive) where the technician was actively assigned and worked on the orders within the reporting period.
CMOI=Count of distinct MOs where technician worked during the period
Deleted Maintenance Orders are also counted in this value.
Technicians - Report
Spent on Maintenance Orders
Measures the net time a technician spent working on maintenance orders (MOs) during a specified period. It includes all types of orders (corrective, breakdown, preventive) and only counts the time when the order was in the "In Progress" status. Time in the "Paused" or “Redbox” status is not included. The KPI value is calculated as the sum of all times the technician worked on orders during the reporting period.
SMO=∑(MO Time Finished − MO Time Started) for all MOs in "In Progress" status
Count of Maintenance Orders involved
The total number of maintenance orders (MOs) a technician worked on during a specified period. This KPI includes all types of maintenance orders (corrective, breakdown, preventive) where the technician was actively assigned and worked on the orders within the reporting period.
CMOI=Count of distinct MOs where technician worked during the period
Deleted Maintenance Orders are also counted in this value.
Conclusion
This documentation provides an overview of the formulas used to calculate various KPIs in our software. Understanding these KPIs and their calculations is essential for monitoring maintenance efficiency and making informed decisions to improve equipment performance. For further assistance, refer to the help section or contact support.
Keep your maintenance processes efficient and data-driven with these KPIs!