Advanced Safety Dashboard Excel Template

Monitor your Safety Leading indicators 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 simple, 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 and advanced tool to analyse and improve safety at work. It can help you to reduce work-related injuries.

Video:

Template Requirements and How to Use:

• Works on PC with Windows.
• Does not work on MAC.
• Requires Microsoft Excel version 2013 or higher with Power Pivot add-in. 👉🏼 Watch this video to find out if your Excel version includes the Power Pivot add-in.
• Allow Macros to run (enable content when opening file).
• Ready-to-use template, just enter or import your data.
• Dashboard ready to be printed.
• Instructions on the Excel sheet “User Guide”.

Customizable template:

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.

Included in the download:

• A template with sample data
• An empty template, ready to receive your data.

Download link:

• Downloads are available from your account once your payment is confirmed.

Warning:

We have put a lot of effort into providing you with a quality work tool at a reasonable price. We kindly ask you to respect the copyright so that we can continue to exist, develop and improve our services. Thank you.

Once purchased, it is prohibited to resell, redistribute, sublicense, assign or transfer this file to anyone in any form. Please read our terms and conditions before purchasing this product.