Advanced Safety Dashboard Excel Template

Description
This Excel template allows you to track health and safety metrics, through the analysis of occupational injuries, commuting accidents, and occupational diseases: Frequency rates, TRIR, DART, lost days, restricted work or job transfer days, severity rate, fatalities, costs, and penalties related to workplace hazards.

It provides information on safety leading and lagging indicators, incidents cause, and employee victims of incidents. It allows you to monitor the environmental impact of the company, property damages and other consequences of safety incidents. It shows occupational health and safety trends, month over month and over 3 years.

This Environmental, Health and Safety (EHS) management template will help you improve employee safety in the workplace and will facilitate your ISO 45001 and related standards certification.

The dashboard includes 6 Safety Reports:


Monthly and Annual HSE Report

Overall safety concerns summary report, month over month, and over 3 years

• Number of recordable incidents, commuting accidents, occupational diseases cases, environmental incidents, property damage and other incidents
• Number of fatalities, lost days, restricted work or job transfer days, penalties, and total costs
  
  

Occupational Incidents Report

Tracks incidents occurring in the workplace during working hours, resulting in an injury

• Occupational Safety KPIs: Total cases, Recordable cases (TRI), Frequency rate (TRIR), DART rate, Severity rate, Fatalities, Lost days, Restricted work or job transfer days, Penalties, and total Costs.
• Analysis of work-related incidents, by division, location, injury type, injury cause, root cause, contributing factor, and injury consequence, ranging from minor injury to death
• Analysis of victims, by age group, gender, employee tenure and shift time, occupation and injured body part
• Safety proactive, preventive actions, and expenses
• Occupational Safety KPIs trends over 3 years
  
  

Commuting Accidents Report

Tracks incidents occurring on the journey work-home or work-restaurant, resulting in an injury

• Commuting Safety KPIs: Total accidents, Frequency index, Fatalities, Lost days, Restricted work or job transfer days
• Analysis of motor vehicle accidents, by journey type, day of week, transportation mode, accident cause, injury consequence, ranging from minor injury to death
• Analysis of victims, by age group and gender
• Commuting accidents and Lost days trends over 3 years
  
  

Occupational Diseases Report

Tracks diseases contracted because of an exposure to risk factors arising from work activity

• Occupational Diseases KPIs: Total cases, Total diseases, Average exposure to risk, Fatalities, Lost days, Restricted work or job transfer days, Penalties, and total Costs.
• Analysis of work-related diseases, by division, location, work environment, work process and causal factor, disease category, disease type and consequence, ranging from medical treatment to death
• Analysis of victims by age group, gender, and occupation
• Occupational Diseases KPIs trends over 3 years
  
  

Environmental Incidents Report

Tracks incidents occurring in the workplace, which caused no injuries, but lead to an environmental impact

• Environmental Incidents KPIs: Total incidents, Frequency rate, Penalties and total Costs
• Analysis of environmental incidents, by division, location, root cause and contributing factor, type of impact and impact severity level
• Environmental Incidents trends over 3 years
  
  

Property Damages and other Incidents Report

Tracks incidents occurring in the workplace, which caused no injuries, and no environmental impacts

• Property Damages and other Incidents KPIs: Total incidents, Frequency rate, Downtime and total Costs
• Analysis of incidents, by division, location, root cause and contributing factor, type of incident and severity level
• Property damages and other safety incidents trends over 3 years

It is a practical and easy-to-use template, ideal for Executives, Plant, Production and Safety Managers who need an advanced tool to analyze and improve health and safety at work. It can help you reduce injuries, environmental impacts and financial consequences related to workplace risks.



Using this template is very easy:

• Enter settings data such as different divisions, locations, causes of injuries, employee occupations, etc.
• Regularly enter or import worked hours and headcount
• Regularly enter or import proactive and preventive actions data
• Regularly enter or import incident's and disease's data

Template Requirements:

• Works on PC with Windows.
• Does not work on a MAC.
• Requires Microsoft Excel version 2016 or higher with Power Pivot add-in. 👉 Watch this video to find out if your Excel version includes the Power Pivot add-in https://youtu.be/-3U0Om5d_JU
• 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 Excel file “User Guide”.

Template Customization:
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.