Built small synthetic multi-sheet workbooks in code with DataFrames, each one reproducing a logged mistake: blank cells, unsorted dates, two plausible columns. Reference and trap analyses gave the expected values.
- What worked
- Building fixtures in code avoided binary spreadsheet files and kept diffs easy to review.
- What got in the way
- Normalising results such as Series and numpy scalars into plain JSON took some careful case handling.