Safety Dashboard Excel Template

59

This ready to use Excel Template allows you to analyse and monitor workplace safety KPIs and trend like the frequency rate of work accidents with and without lost time, the severity rate, lost workdays, downtime due to incidents, the investigations status, safety training, and the detailed analysis of incidents by location, root cause, type, people involved, type of injury, etc.

Categories: ,

This ready to use Excel Template allows you to analyse and monitor workplace safety KPIs and trend like the frequency rate of work accidents with and without lost time, the severity rate, lost workdays, downtime due to incidents, the investigations status, safety training, and the detailed analysis of incidents by location, root cause, type, people involved, type of injury, etc.

With this dashboard you can monitor:

  • Workplace Safety KPIs: total number of incidents, workplace accidents and near misses. Headcount, number of occupational health and safety training hours, accident frequency rate with and without lost time, the severity rate of work accidents, the total number of lost workdays because of work accidents and the downtime caused by all incidents.
  • Incident analysis: total number and percentage of incidents by the type and the location of the incident, the root causes, the contributing factors, the type of injury, the parts of the body affected (with pictogram) and the category of involved person.
  • The status of work accident investigations.
  • The monthly trend of frequency rate for work accidents with and without lost time.
  • The monthly trend of severity rate for work accidents.
  • Analyses can be filtered by root cause, location, year and by month

Using this tool is very simple, you just need to enter regularly or import:

  • Workplace incidents data.
  • Human resources data.

It is a practical and easy-to-use template, ideal for Executives, Plant, Production and Safety Managers who need to analyse and improve safety at their plants. It can help you to reduce safety-related issues.

Video:

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”.
  • Allow Macros to run (enable content when opening file).
  • 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.

Power Pivot

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.


 

Software

Microsoft Excel

About the author

Nisrine LAHRECHE
Consultante Formatrice Microsoft Excel, Power BI, Analyse des données