# The Safety Manager: companion files

Julian R. Sterling

## What is here

- SAFE_1_Hours_and_Rates.xlsx (Chapters 2 and 5; Hours and Rates workbook of Appendix A): tabs Sites, Hours, Cases, Rates, then Checks. Hours worked by site and month, employees and temporary workers apart; cases by category; TRIR, DART and LTIR by site, by year and for the like-for-like sites (1,910,088 hours and a TRIR of 3.56 in 2024, 1,979,892 hours and 3.74 in 2025); the all-sites hours (2,103,056 in 2025, TRIR 3.99) in a cell of their own.
- SAFE_2_Injury_Log.xlsx (Chapters 3, 4 and 7; Injury Log workbook): tabs Cases, Categories, Days, then Checks. One row per recordable case, no name (34 cases in 2024, 42 in 2025); counts by category, site, month, worker and cause group; days away and days of restriction by site (355 days away in 2025); the cap on counted days as a rule at the top of the Days tab.
- SAFE_3_Leading_Indicators.xlsx (Chapter 6; Leading Indicators workbook): tabs Inspections, Near misses, Corrective actions, Summary, then Checks. Inspections done against planned (79.2 percent in 2024, 96.2 in 2025), near misses by site and month (6.0 per recordable case in 2025), and a corrective action register that ties open, opened and closed (57 open at the end of 2025, 19.3 percent overdue).
- SAFE_4_Claim_Cost.xlsx (Chapter 13; Claim Cost workbook): tabs Claims, Direct cost, Indirect cost, Summary, then Checks. The claims of each year from the loss run, paid plus reserves ($233,570 in 2024, $396,700 in 2025, $12,021 per claim), and the indirect cost by the company's written rule, case by case ($63,576 in 2025, an estimate).
- SAFE_5_Safety_Options.xlsx (Chapter 16; Safety Options workbook): tabs Options, Effects, Sensitivity, Summary, then Checks. Three options for 2026 to 2028: cost, cases avoided, costs avoided, net and simple payback ($293,000 against $365,772 for option a, payback 1.9 years), and a sensitivity tab that scales every effect. All projections, never results.
- SAFE_Safety_Manager_Toolkit.docx: the 8 check-lists of Appendix B, editable (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).

## How to use the workbooks

Each tab opens with a note that names the chapter it serves and says what to type. The workbooks have no separate read-me tab: this file and the notes carry the instructions. Input cells are blue on a light blue fill. In the grids (sites, months, cases, claims, actions, years) the case's figures are typed in place: overwrite them with your own, and clear the case before the first real use, because a file that still holds a fictional site's hours next to your own is worse than no file. A single input shows the case's figure, an empty yellow cell for yours, and a Used column that takes your figure when you type one; every formula reads the Used column. The rules Appendix A places in a "rules tab" (hours of investigation per case, the cap on counted days, the day limit of the overtime premium) sit at the top of the tab that applies them: Days in the Injury Log workbook, Indirect cost in the Claim Cost workbook. Black type is a formula, green type a link to another tab. Every cell that divides stays empty, never an error, until its divisor is entered. Rebuild the case first: the Checks tab of each workbook compares the live cells with the figures printed in the book, then runs the structural checks of Appendix A, and reads ALL CHECKS OK while the case figures are in place. Each of the 13 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. Rates are rounded to two decimals, shares to one decimal of a percent, dollars to the dollar.

Two inputs to try first:

1. In SAFE_1_Hours_and_Rates.xlsx, on Sites, change the like-for-like flag of Garrowdale to Yes: the like-for-like rows of the Rates tab take its hours and cases at once, and the Checks tab flags the acquired site.
2. In SAFE_5_Safety_Options.xlsx, on Sensitivity, type 150 percent in the yellow cell: every effect rises by half, and the net and the payback of each option move; clear it and the case's halved effects come back.

To use a workbook on your own company, fill the inputs from timekeeping, the log, the inspection plan, the corrective action register, the loss run and the quotes you have received, in the order Appendix A gives, and keep a copy with the case for comparison. The workbooks are separate files with no link between them: where one workbook needs a figure of another (the hours of the Hours and Rates workbook in the Injury Log workbook, the recordable cases in the Leading Indicators workbook, the cost rules in the Safety Options workbook), it is typed, with its source beside it. The workbooks count; they never decide whether a case is recordable, which stays with the person who keeps the log.

## A word of caution

Weldmarsh Industries, Inc., the city of Orrinford, the sites of Stannerley, Quarleigh, Fenmarrow, Hollinshed and Garrowdale and the company's people are fictional. Hours, cases, days, rates, costs, penalties and effects are teaching assumptions, not market norms, targets or recommendations, and nothing here promises fewer injuries. Which rule applies to a real employer, whether a case is recordable, how a machine is guarded and when a worker returns to work are questions for its counsel, its clinicians and its qualified engineers. No real insurer, broker, claims administrator, staffing agency, software vendor, training or certification body, equipment maker or consultancy is described or recommended. Nothing here is legal, medical or engineering advice.
