Interactive example

What actually happens to a difficult loss run.

Step through the same sequence the product follows. Every figure below is authored for this example — nothing here is a real client file, and no analysis is run in your browser.

Interactive example using synthetic data

Walkthrough

Start with one loss run

Select a loss run file
ClaimsListing_2019-2024_FINAL(2).xlsx
412 KB · Sheet1 · 1,284 rows

Reading the file

The workbook is read with a quick summary.

Format
Excel workbook, one sheet
Rows
1,284
Columns
7
Report date of loss-run
Not stated

The Report date can be specified later.

Why the boring parts are the product

Every obstacle in the example above is one that changes the answer rather than merely slowing the work. A valuation date that is nowhere in the file. Open claims carrying no reserve, which most ingestion quietly reads as zero.

None of that is exotic. It is what loss runs are like, and resolving it is most of the distance between a spreadsheet and a number an auditor will accept.

Bring one of your own files to the Clinic →