Excel Dashboard for OSHA Safety KPIs (2026): TRIR, DART, LTIR and the Cases Missing From Your 300 Log

Excel dashboard for US safety managers: TRIR, DART, LTIR and severity on OSHA's 200,000-hour base (29 CFR 1904). Every case treated beyond first aid must be on the 300 log within 7 calendar days, and each one left off is a recordkeeping violation of up to $16,550 in 2026 (OSHA memo, May 21, 2026).

Who is this for? US safety and EHS managers who keep an OSHA 300 log under 29 CFR 1904. Type the hours your people actually worked and your log counts: the dashboard puts them on OSHA's 200,000-hour base (TRIR, DART, LTIR, severity), then adds the cases treated beyond first aid that never reached the log. Each case must be logged within 7 calendar days; each one left off is a recordkeeping violation of up to $16,550 in 2026.

Your numbers

Your result

TRIR as logged (per 200,000 hours)-
TRIR with unlogged cases added-
TRIR understated by-
DART rate (per 200,000 hours)-
LTIR, days-away cases (per 200,000 hours)-
Severity rate, days per 200,000 hours-
Your true TRIR ÷ benchmark-
Cases your hours allow at the benchmark-
OSHA fine exposure, unlogged cases (up to)-

Everything updates as you type. Nothing is uploaded. This runs in your browser.

Get the full calculatorFull version: the .xlsx with all 9 live formulas, one copy per site or per month, works offline.

Open full tool → getreadystack.com · Put this on your site with your logo