Template Library
Safety KPI Dashboard Template
An Excel workbook for a monthly safety scorecard: lagging rates with exact intervals and a control chart, and leading indicators for near misses, hazard and action closure, safety walks, and training.
The Data tab takes one row per month: hours worked, recordable, DART, and lost-time cases, days lost, first aid cases, near misses, and the counts for hazard report and action closure, safety walks, and training. The monthly rate, a rolling 12-month rate, the average, and the upper control limit for each month calculate, and months above the limit are flagged.
The Dashboard tab shows year-to-date TRIR, DART rate, lost-time case rate, LTIFR, and severity rate, each with an exact 95% interval that shows how much a small count can move by chance, and the leading indicators against targets you set. Two charts show the monthly rate with its control limit and the leading indicators against target.
A year of example data for an illustrative 140-employee plant is included so you can see the formulas working before you replace it.
What Is Included in the Workbook
| Sheet | Purpose | What Teams Capture |
|---|---|---|
| How-To | Guidance and disclaimer | Steps and notes |
| Data | Monthly data (Excel Table) | Hours, case counts, leading indicator counts, monthly and rolling rates, control chart limits, signal flag |
| Dashboard | Year-to-date scorecard | Rates with 95% intervals, severity, near-miss ratio, leading indicators against targets, two charts |
Key Features Inside the Template
Rates With Honest Uncertainty
Exact intervals show how far a small count could be from its long-run rate.
A Control Chart That Updates
A u chart with limits that allow for the hours worked in each month.
Leading Indicators Beside the Lagging Ones
Hazard and action closure, safety walks, and training, each against a target you set.
Formulas You Can Inspect
Standard Excel functions, with no macros, so you can check and change any calculation.
Best Use Cases
- Preparing a monthly safety report for the committee and management
- Seeing whether a change in the rate is signal or chance
- Tracking leading indicators alongside lagging rates
- Training in safety measurement and statistical thinking
- Setting a baseline before a safety improvement
How to Use the Template Effectively
- Enter the hours worked and the counts for each month, using your own recordkeeping definitions.
- Set the targets for the leading indicators on the Dashboard tab.
- Read the rates and their intervals before reading the trend.
- Look at the control chart: investigate a month above the limit, and do not react to movement inside the limits.
- Compare the leading indicators with their targets, and act on the ones below target.
- Report the dashboard with the interval, not only the single number.
Who Should Use This Template
- EHS managers and safety coordinators
- Plant and operations managers
- Safety committee members
- Students and trainees learning safety metrics
Common Mistakes to Avoid
- Reading a change in a small count as a real trend
- Reporting only lagging rates
- Setting a zero-incident numeric target that discourages reporting
- Changing the definitions between periods
- Ignoring near-miss reports because the rate is low
Important Notes
Safety KPI Dashboard Template Frequently Asked Questions
How are the 95% intervals calculated?
As the exact Poisson interval for the number of cases, scaled to the rate: the lower limit is half the chi-square quantile at 2k degrees of freedom and the upper limit is half the chi-square quantile at 2k + 2 degrees of freedom. The workbook uses the CHIINV function for this.
What is the Signal column?
It flags a month whose rate is above the upper control limit for the year's average rate. The limit allows for the hours worked in that month. With low counts the lower limit is zero, so the chart can warn of a bad month but not confirm a good one.
Can I use the 1,000,000-hour base?
The dashboard shows TRIR and DART per 200,000 hours and LTIFR per 1,000,000 hours. To change the base, edit the constant in the rate formulas.