Companion files · The Private Markets Career Guides
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 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.
Chapters 2 and 5
Hours worked by site and month, employees and temporary workers apart, cases by category, and TRIR, DART and LTIR by site, by year and for the like-for-like sites, each on its own hours. Tabs: Sites, Hours, Cases, Rates. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 131 KBChapters 3, 4 and 7
One row per recordable case and no name: counts by category, site, month, worker and cause group, days away and days of restriction by site, and a flag for any count above the cap. Tabs: Cases, Categories, Days. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 230 KBChapter 6
Inspections done against planned, near misses by site and month, and a corrective action register that ties open, opened and closed and counts the overdue actions. Tabs: Inspections, Near misses, Corrective actions, Summary. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 349 KBChapter 13
The claims of each year from the loss run, paid plus reserves as of its date, and the indirect cost by the company’s written rule, case by case, labeled as an estimate. Tabs: Claims, Direct cost, Indirect cost, Summary. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 432 KBChapter 16
Three options for 2026 to 2028: cost, cases avoided, costs avoided, net and simple payback, with a sensitivity tab that scales every effect. All projections. Tabs: Options, Effects, Sensitivity, Summary. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 521 KBAppendix B
The first 90 days in the job; Keeping the log and the annual summary; Investigating an incident; Site inspection and corrective action follow-up; Lockout and machine guarding: the annual program review; Forklifts: training, evaluation and traffic; Preparing for a federal inspection and its closing conference; Return to work and following a claim.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me6 KB| One rate, one base | 8 x 200,000 / 266,228 = 6.01: the 2025 TRIR of the distribution center, its cases over its own hours worked |
| Like-for-like | 20 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 actions | 11 / 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.