Walk into almost any environmental department and ask to see the compliance tracker. You will get a spreadsheet. It has a dozen tabs, color coding that made sense to its author, and formulas nobody has audited since it was built. It is the operating system of a program with legal obligations attached, and it is held together by memory.
Spreadsheets are not bad tools. They are bad systems of record for regulatory obligations. The difference shows up in five costs that rarely appear on any budget line.
1. The single-person dependency
Every compliance spreadsheet has an author, and the spreadsheet is a map of that person's mind. When they leave, retire, or move roles, their successor inherits the file but not the reasoning. Why is this limit 22.4 and not 25? Which condition drives this monthly entry? The answers lived in the author. Rebuilding that understanding costs weeks, and the rebuild happens under deadline pressure because the reporting calendar does not pause for transitions.
2. No citation trail
A tracker row says the VOC limit is 25 tons per year. Where did that come from? Which permit condition, which page, which applicable requirement? In most spreadsheets, nowhere. Every audit, every inspection, and every consultant engagement re-derives the provenance of numbers that were derived once already. That re-derivation is pure waste, and it repeats forever.
3. Silent formula errors
Spreadsheet errors do not announce themselves. A rolling 12-month total that quietly references the wrong row keeps producing plausible numbers for years. Research on spreadsheet quality has found error rates in a large share of operational spreadsheets across industries, and compliance files are not exempt. The consequence in this domain is not a wrong forecast. It is a certification signed over a wrong number.
4. Version confusion
Tracker_v3_FINAL_updated.xlsx. The file gets emailed, copied to a shared drive, edited in parallel. Two versions disagree about a deadline. Which one is real? During an agency inspection is a bad time to find out.
5. Nothing watches the watcher
A spreadsheet is passive. It will not notice that a rolling total is at 89 percent of a cap and trending up, or that a stack test window opens in 60 days and no test is scheduled. People notice, when they have time, which is exactly when things are quiet, which is exactly when programs are understaffed.
What the alternative looks like
The fix is not more spreadsheet discipline. It is a different kind of record: one where every tracked condition carries its citation to the permit that created it, where emission totals update from operating data instead of manual entry, where the deadline calendar generates alerts instead of waiting to be read, and where reports assemble from the tracked record instead of being rebuilt each cycle.
That is the record AirComply builds when it deconstructs a permit: every item cited, every total live, every deadline watched. A human still reviews and signs everything that matters. The difference is that the system underneath can survive an audit, and a departure, without archaeology.