Work samples

Open a finished model before you buy one

Three workbooks, built the way a client's would be, for companies that do not exist. Every number on these pages is the value the file computes, the formulas are the file's own, and each tie-out was broken on purpose to prove it goes red. Download the file and check it yourself.

finished workbooks: 3
tie-outs, all passing: 38
deliberate corruptions caught: 40 of 40

Accrual sheet of the Rep commission model sample, 8 rows
	A	C	D	E
5	Month	Jan-26	Feb-26	Mar-26
17	THE GAP
18	Cumulative commission earned (case basis)	$12,227	$28,224	$43,412
19	Cumulative commission booked (invoice basis)	$6,039	$16,571	$28,957
20	Liability the invoice basis is missing	$6,188	$11,652	$14,455
21	Understated by more than a month of commission?	no	no	no
22
23	ACCRUED COMMISSION LIABILITY — ROLL-FORWARD

Medical device distributors

Rep commission model

Commission accrued on the invoice date instead of the case date. Cases done in March and invoiced in May are a liability at 31 March, and an invoice-basis book does not carry them.

$14,455Commission liability missing at 31 March · Kestrel Ridge Surgical Partners, illustrative

Open the sample Download .xlsx939 formulas · 11 tie-outs

By CPT and payer sheet of the Case costing by CPT and payer sample, 8 rows
	A	B	C	D
36	Procedure	CPT	Medicare	Blue Cross PPO
37	Knee arthroscopy with meniscectomy	29881	$766	$2,956
38	Arthroscopic rotator cuff repair	29827	($394)	$3,788
39	Total knee arthroplasty	27447	($722)	$9,388
40	Lumbar epidural steroid injection	64483	$107	$742
41	Cataract removal with lens implant	66984	$113	$1,042
42	Laparoscopic cholecystectomy	47562	$380	$4,132

Ambulatory surgery centers

Case costing by CPT and payer

Revenue modeled as cases times an average rate. The same knee replacement pays $9,150 under one contract and $21,500 under another; an average puts money on Medicare cases that Medicare does not pay.

6 of 40Cases that lose money · Larkspur Surgery Center, illustrative

Open the sample Download .xlsx1,106 formulas · 14 tie-outs

Cash sheet of the Home health cash forecast sample, 8 rows
	A	C	D	E
6	Payer	Jul-26	Aug-26	Sep-26
17	Visits delivered (by period start month)	167	100	0
18	Revenue the old forecast booked on those visits	$34,235	$20,500	$0
19	Cash the old forecast expected (visit + Old_Lag days)	$27,880	$34,235	$20,500
20	Old forecast — still to land after the last month in view
21	Old forecast less what actually lands	$23,152	$19,179	($11,066)
22	Cumulative — cash the old forecast has promised that has not arrived	$23,152	$42,331	$31,265
23

Home health & hospice

Home health cash forecast

Cash tied to the visit or an invoice date. Under period payment the invoice date is neither when the work happened nor when the cash arrives.

$42,331Promised by the old forecast by the end of August, not yet arrived · Brightwater Home Health, illustrative

Open the sample Download .xlsx969 formulas · 13 tie-outs

How to read them

Yellow is yours. Black is ours.

A yellow cell is an input. Type over it and the whole file moves. Every assumption sits on one Inputs sheet, labeled in English.
Black text is a live formula. Nothing on a calculation sheet is typed. Select any cell on these pages and the bar shows the formula.
The Checks sheet is the last one. Every row must read OK before a file leaves. A check that has never been seen to fail is not a check, so each one is broken on purpose first.
The companies are invented. Kestrel Ridge, Larkspur and Brightwater do not exist. Their numbers were made up to exercise the mechanics, which are not.

Want one built on your numbers? The plans are month to month, and the first request goes in the day you sign up.

Spreadsheet Studio

The same care, on your numbers.

Describe what you need, attach your data, and a finished, checked workbook lands on your board — recalculated, its checks proved able to fail, and re-derived by a second pass before it ships.

Start this month sturdylaw@gmail.com

Not ready? Get a free teardown of a sheet you already rely on.