Settlement Prep Without the Spreadsheet Archaeology
2026-08-27 · Workplex · 6 min read · Settlement, Workflow, Medical Evidence
Ask a defense attorney what takes the longest before a Compromise and Release, and it is rarely the legal analysis. It is the spreadsheet: paging back through medical bills, prior awards, and treatment notes to rebuild numbers the file already contains, because nobody trusts a summary they cannot re-derive by hand.
The numbers are already in the file — the work is reassembly
A settlement figure is not one number. It is medical specials pulled from every bill in the record, permanent disability rating carried through from the medical-legal reports, prior awards on the same body part, and future medical exposure estimated off the treatment pattern. Every input already exists in the file. The hours go into finding and reconciling them, not deciding what they mean.
Start the worksheet built, not blank
The alternative is to let the same extraction that builds a chronology also populate the settlement worksheet — medical specials, PD rating, prior awards, and future medical exposure, each figure cited back to the report it came from. The attorney opens a draft worksheet, not a blank spreadsheet and a stack of records.
- Medical specials totaled automatically from every bill in the record, not re-added by hand.
- PD rating and apportionment carried through from the med-legal reports, with the source report one click away.
- Prior awards on the same body part surfaced automatically, not found by memory or a manual search.
- Every figure on the worksheet cites its page — the attorney checks a number, not the whole file.
A settlement figure the attorney can trace to its source is worth more than one they trust because it took all day.
What this changes at the table
Prep time is not the only cost of a slow C&R workup — negotiating posture is. An attorney who has spent the morning re-deriving numbers walks into a settlement conference tired and reactive. An attorney who opened a sourced worksheet walks in with the whole case's economics already in hand, and spends that time on strategy instead of arithmetic. The figure is still theirs to set. The archaeology is not theirs to redo.