Advanced Safety Dashboard Excel Template

Description
Monitor your Safety Leading and Lagging indicators: evaluate safety proactive and preventive actions like HSE training or equipment inspections, analyse work-related injuries and illnesses like Fatality, Lost Time injury, Restricted Work or Job Transfer injury, Medical Treatment injury, monitor Recordable Incident, Total Recordable Incident Frequency Rate, Severity Rate, Lost Days and Restriction/Transfer Days and investigations status and duration.
Analyse environmental incidents and other non-recordable incidents, monitor financial costs and filter the analyses by period, division, location, root cause, contributing factor, hazard, employee at risk, injury type, etc.

The dashboard includes 4 Reports:

Recordable Incident Report
• Number and duration of safety proactive and preventive actions
• Safety metrics: average headcount, worked hours, the total recordable incident, total recordable incident frequency and severity rate, number of deaths, number of lost days and restriction/transfer days
• Total recordable incident (TRI), Frequency Rate (TRIFR) and percentage (%), by type and location of the incident, the root cause and contributing factor, the injury type and affected body parts, the hazard and the category of employee at risk
• Status and duration of recordable incident investigations
• Recordable Incident Frequency Rates Chart
• Recordable Incident Severity Rates Chart

Non-Recordable Incident Report
• Total non-recordable incident and frequency rate
• Environmental and other non-recordable incident by type and location, root cause and contributing factor
• Status and duration of non-recordable incident investigations
• Non-Recordable Incident Frequency Rates Chart

Trends Report
• Monthly and Annual Recordable vs. Non-Recordable Incident chart
• Monthly and Annual Lost Days and Restricted/Transfer Days vs. Worked Hours
• Monthly and Annual Recordable Incident vs. Worked Hours

Costs Report
• Monthly and Year-to-date incident costs by Source of Costs
• Monthly and Year-to-date incident costs by Incident Type

All Analysis can be filtered by:
• Year and Month
• Division/Function, Manager/Supervisor, Root Cause, Contributing Factor, Location and Employee at Risk

Using this tool is very easy, you just need to enter or import regularly:
• Proactive and preventive safety actions data
• Human resources data
• Workplace incidents data

It is a practical and easy-to-use template, ideal for Executives, Plant, Production and Safety Managers who need an advanced tool to analyse and improve safety at work. It can help you to reduce work-related injuries.

How to Use:
• Ready-to-use template, just enter or import your data.
• Dashboard ready to be printed.
• Instructions on the Excel sheet "User Guide".
• Works on PC with Windows.
• Allow Macros to run (enable content when opening file).
• Requires Microsoft Excel version 2013 or higher with POWER PIVOT add-in

How do you know if you have Power Pivot? 👉 https://youtu.be/-3U0Om5d_JU

Customizable model:
Colors, fonts, and all style attributes can be changed to suit your needs. If you want to make changes on your own, just enter the password included with the file to unlock the template.