WHS KPI Dashboard and Injury Rate Calculator

An editable Excel workbook for the injury rates and safety measures most businesses report: LTIFR, TRIFR, AFR, severity rate and incidence rate, using the per-million-hours definitions set out on a Definitions sheet. Use the Calculator for one period, or record each month and let the sheet work out the month and rolling 12 month rates. A worked example with fixed figures and a TRUE or FALSE formula check shows the formulas calculate. Lead indicators track inspections, actions closed on time, near misses, hazard reports and training. No Queensland law defines these rates, so the workbook states its own definitions and uses them the same way every period.

What Is Included In Our WHS KPI Dashboard and Injury Rate Calculator?

• A Start Here sheet: type your details once and they appear on every sheet and printed page
• A Calculator for one period: type hours worked, average workers, injuries and days lost and read the rates at once
• LTIFR, TRIFR, AFR, severity rate, serious claim frequency rate, incidence rate per 1,000 and per 100 workers and average days lost per LTI
• A worked example with fixed figures, the answer worked by hand and a Formula check that shows TRUE when every formula calculates
• A Monthly KPIs sheet with a row for each month and automatic month and rolling 12 month rates, with divide-by-zero guarded
• Lead indicators: inspections done against planned, actions closed on time, near misses and hazards reported, training current, with optional targets you type yourself
• A Definitions sheet that sets out exactly what hours worked, LTI, MTI, RWI, days lost and each rate count
• A plain-English summary of the Queensland rules on notifying incidents and reporting injuries to the insurer

Legislation and Codes of Practice Referenced

• Work Health and Safety Act 2011 (Qld): ss 35 to 38 (notifiable incidents and notification), s 47 (consultation)
• Workers’ Compensation and Rehabilitation Act 2003 (Qld): s 133 (employer’s duty to report an injury)

What You Get

• An editable Microsoft Excel workbook with no macros
• A Calculator, a worked example with a formula check, a monthly dashboard and a Definitions sheet
• Working formulas, lead indicators and colour highlighting of lost time injuries
• Room for 120 months (ten years) of records
• Print-ready pages with your business and site details repeated on every printed page

Review it and adjust it to suit your business, your sites and the way your team works, and talk it through with your workers. If you have any trouble downloading this template, you can contact us at any time. Please make sure you read our Disclaimer before downloading.