# The Workers' Compensation Handbook: companion files

Julian R. Sterling. Companion page: julianrsterling.com/workers-comp

1. **Workers_Comp_Workbook.xlsx**: the twelve-tab model behind every Brannock Supply Co. figure in the book (renewal and rating effective date January 1, 2027, experience period 2023 to 2025, USD): README, Inputs, Expected_Losses, Claims, Experience_Mod, Mod_Scenarios, Audit_2026, Loss_Development, Premium, Program_Options, Return_to_Work and Controls. The experience mod reads 1.1980, rounded 1.20, and the 2027 guaranteed cost premium $936,603. The Controls tab must read 0.
2. **Experience_Mod_Calculator.xlsx**: a standalone experience mod calculator on one sheet (Calculator): payroll by class for three policy years, expected loss rates, D-ratios, split point, state accident limitation, ERA factor, weight and ballast, up to 200 claims and the mod points each claim adds. Prefilled with Brannock: it reads 1.1980, rounded 1.20. Replace the blue cells with the values from your own rating worksheet.

Blue cells are inputs, black cells are formulas, no circular references. Open the files in Excel and let them calculate. The case state's rating values are fictional teaching assumptions, not any state's filed values; your rating bureau's worksheet is the document of record. Rules described in principle as read in November 2026; states differ. Education only, not insurance, legal or actuarial advice. The company, its claims and every figure are fictional.
