Ace Pool & Spa

The problem

Sales reporting ran on manual data entry. Every month someone re-keyed quote data out of the service platform and into a spreadsheet: hours of work that produced nothing a computer couldn't have produced, and introduced a transcription error every time it ran.

What was built

Two command-line tools that pull from PoolBrain's HTTP API and write formatted Excel workbooks: a quote and sales tracker, and a weekly commission tracker that attributes each job and quote to the admin who created it. The owner runs either on demand.

The interesting part

PoolBrain's API does not expose who created a record, and the commission report depends entirely on that. The attribution is reconstructed from the earliest row of each job's audit history, with a second lookup against quote status history.

That reconstruction is a proxy, not ground truth, and the code says so out loud, in the module docstring and in the README, enumerating the two ways it could be wrong and flagging every affected row. A report that decides how people get paid should say when it is guessing.