Companion files · The Private Markets Career Guides

The Safety Manager

A Practitioner's Guide to Safety Management: OSHA Recordkeeping and Injury Rates, Hazard Control, Incident Investigation, Training, Workers' Compensation Costs and the Safety Management System.

These are the companion files of the book. Five workbooks follow Weldmarsh Industries, Inc., the fictional industrial company of the case, across two calendar years and five sites: hours worked and the three rates, the injury log in counts, the leading indicators and the corrective action register, the cost of claims, and the three options of the year-two decision. Each keeps the case’s figures in blue input cells that you overwrite with your own, guards every division against an empty divisor, and ends with a Checks tab. A toolkit holds the check-lists of Appendix B in editable form.

The five workbooks, the toolkit and the read-me, in one archive190 KB

The archive holds the five workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

One rate, one base8 x 200,000 / 266,228 = 6.01: the 2025 TRIR of the distribution center, its cases over its own hours worked
Like-for-like20 x 200,000 / 1,979,892 = 2.02: the 2025 DART of the four original sites, the acquired plant left out of both sides
Overdue actions11 / 57 = 19.3 percent of the corrective actions open at the end of 2025 were past their due date

The files are provided as they are, without warranty of any kind. The model is illustrative: Weldmarsh Industries, Inc., the city of Orrinford, its sites and its people are fictional; the hours, cases, days, rates, costs and effects are the book’s assumptions, not market norms or the record of any real company. The workbooks count; they never decide whether a case is recordable, and nothing here promises fewer injuries. Not legal, medical or engineering advice.