ISO 45001 OH&S KPI Tracker Excel Template (TRIR / LTIFR calculator)

Introduction

ISO 45001 offers companies an opportunity to establish processes for managing OH&S (occupational health and safety) risks and opportunities and control measures to ensure safe and healthy working environments. One of the critical requirements of ISO 45001 is measuring and analyzing OH&S performance. Without monitoring and reviewing the performance of a Health and Safety Management System (HSMS), organisations cannot identify the strengths and weaknesses and demonstrate their effective implementation to stakeholders.

Importance of an ISO 45001 OH&S KPI Tracker Excel Template

An OH&S KPI Tracker Excel Template offers organisations an easy-to-use yet powerful tool to monitor and track safety-related Key Performance Indicators (KPI). An excel sheet provides companies with multiple benefits, including consistency, increased efficiency and accuracy, enhanced data visualisation and presentation, audit readiness, and continuous improvement. A well-structured OH&S KPI Excel sheet can help demonstrate to management and other stakeholders leading and lagging indicators, identify the significant trends, and help support informed decision-making. For instance, it can provide vital information about the incidence rate to ensure appropriate action is taken to eliminate or mitigate hazards and risks that may cause injury or ill health to workers.

Key ISO 45001 Safety Metrics: TRIR and LTIFR

Two of the critical lagging indicators used to measure and monitor the performance of OH&S are the Total Recordable Incident Rate (TRIR) and the Lost Time Injury Frequency Rate (LTIFR). TRIR and LTIFR are essential because they provide a baseline for comparing the organisation’s performance with industry standards and its past performance.

1. TRIR (Total Recordable Incident Rate)

The Total Recordable Incident Rate (TRIR) is a critical metric used by organisations to understand and determine the level of incidents that occurred in the workplace and are recordable by OSHA (Occupational Safety and Health Administration). In other words, it is a metric that indicates the number of incidents per 100 full-time employees during a specific period (mostly a year). TRIR provides an organisation with valuable insights into its overall safety performance, including the incidence rate for fatalities, injuries requiring restricted work or job transfer, day away from work, and medical treatment.

TRIR = (Number of Recordable Incidents × 200,000) / Employee Hours Worked

• Number of Recordable Incidents: This is a figure representing the total number of fatalities, injuries resulting in restricted work, transfer of duty or job, day away from work, and medical treatment.
  
  
• 200,000: This is the total number of hours required for 100 employees working 40 hours a week for 50 weeks a year.
  
  
• Employee Hours Worked: This is the total number of hours employees have worked in a given period.

2. LTIFR (Lost Time Injury Frequency Rate)

The Lost Time Injury Frequency Rate (LTIFR) is a metric that indicates the frequency of lost time injuries within an organization. It is a vital indicator because it helps an organization determine the number of incidents in which a worker is unable to perform his or her regular duties or any other duties for at least one full day or shift. Additionally, LTIFR provides valuable information to indicate the severity of injuries that occur in the workplace and the impact of these injuries on the employees, including lost working days.

LTIFR = (Number of Lost Time Injuries × 1,000,000) / Employee Hours Worked

• Number of Lost Time Injuries: This is the total number of lost time injuries within a given period.
  
  
• 1,000,000: This number represents the total number of hours that would be required for a million workers to work for a day.
  
  
• Employee Hours Worked: This is the total number of hours employees have worked in a given period.

Essential Elements of an ISO 45001 OH&S KPI Tracker Excel Template

An ISO 45001 OH&S KPI Tracker Excel Template should be helpful to organisations in recording and storing all relevant data about incidences, lost-time injuries, near misses, observations, and total hours worked. As such, companies should look for an excel sheet with the following features:

• Easy-to-use and intuitive design: An excel sheet with eye-catching data entry fields to record and store essential data, including recordable incidents, near misses, observations, and hours worked.
  
  
• Calculations: The excel sheet should have calculation fields to help users calculate the TRIR, LTIFR, and other key safety metrics.
  
  
• Dashboard: The excel sheet should have a dashboard feature that displays the critical safety indicators and graphs to help users interpret the information easily.
  
  
• Customizable: The excel sheet should be easily customizable to allow users to customise fields, reports, and dashboards.
  
  
• Compliance: The excel sheet should be designed to help users comply with ISO 45001 OH&S requirements and demonstrate effective implementation of the OH&S management system.
  
  
• Action Plan: The excel sheet should include sections or fields for taking corrective and preventive action to ensure continuous improvement of the HSMS.
  
  
• User-friendly: The excel sheet should be designed in a way that it is easy for the user to navigate.

How to Use an ISO 45001 OH&S KPI Tracker Excel Template Effectively

Having an excellent OH&S KPI tracker excel sheet is not enough. Organisations need to know how to implement and maximise its benefits.

1. Establish Effective Data Analysis Process

Organisations should set up and implement effective data analysis processes to ensure they extract valuable insights to demonstrate the effectiveness of their HSMS and drive the continuous improvement of their OH&S performance. As such, the organisations should:

• Set out specific data collection procedures: The organisations should develop clear policies and procedures for collecting, analysing, and presenting the results of the data analysis.
  
  
• Review and analyse data on a regular basis: The organisation should conduct regular data analysis to determine key insights, the root cause of incidents or near misses, and the underlying causes that may contribute to future incidents.
  
  
• Use the insights to drive performance improvement: The company should use the information obtained from the data analysis to develop and implement corrective and preventive measures to address and eliminate the causes and conditions that could result in injury or ill health.
  
  
• Report findings and recommendations: The organisation needs to develop effective reporting mechanisms to communicate the results of the data analysis and recommendations to relevant stakeholders, including management, employees, and contractors. This is important for the management review process, and it will help the company meet its OH&S objectives.

2. Integrate the Tracker into Your HSMS

In addition, the OH&S KPI tracker should be integrated into the company’s HSMS to ensure it provides the necessary information for effective decision-making that will drive performance improvement. This is important to facilitate the management review process.

3. Ensure Compliance with ISO 45001 Requirements

The company must also use the excel sheet to ensure that it meets the requirements of ISO 45001, including establishing and implementing controls to ensure safe and healthy working environments.

Conclusion

An ISO 45001 OH&S KPI tracker excel sheet can support an organisation in building a proactive, healthy work environment instead of merely responding to incidents. Using this excel sheet provides the company with the tools and data required to ensure they prevent incidents and support continuous improvement. As such, with the use of this tool, an organisation can ensure it eliminates and mitigates OH&S risks and opportunities that could affect its employees, customers, and other stakeholders.