THE QUIET DEATH OF EXCEL IN ROOFING
Job-tracker spreadsheets are the silent margin leak in every $5M–$20M roofer. A practical migration plan that doesn't burn the company down.
Every roofer above $5M revenue runs at least one piece of their operation in Excel. Usually the job-tracker. Sometimes the commission calculator. Often the AR aging report. Always the budget vs actual the owner glances at on Saturday morning.
Excel doesn't get killed by a vendor. It gets killed by the day the spreadsheet finally breaks something visible.
What's actually wrong with the spreadsheet
Most arguments against operational Excel are aesthetic or theoretical. They aren't the real problem. The real problem is structural: a spreadsheet is one human's mental model in a grid, and the company has now passed three people through that grid.
Three patterns we see in every roofer we audit:
**The phantom formula.** Someone three years ago wrote `=IF(B7>0, B7*1.07, B7*1.04)` to capture an upcharge on a specific job type. Nobody now remembers what 7% versus 4% means. Every job since has run that formula. Bonus: row 213 was overwritten by hand to fix a one-off, breaking the column.
**The merged-cell trap.** Someone merged cells to make the section header look nicer. Three updates later, the conditional formatting points at the wrong cells, the sort silently corrupts data, and only the row count makes the owner realize half the jobs are missing.
**The truth-fork.** Two sales reps are editing the same job tracker. Their versions diverge for a week before someone manually reconciles. Median jobs lost per quarter on $10M revenue companies: 1.4. Median dollars at risk: $48K.
We pulled the last one from a 12-operator audit. The dollar figure was conservative — it only counted jobs the owner could later trace, not the ones that just disappeared.
Why companies don't quit
The reasons are obvious and they aren't wrong:
- The spreadsheet is fast. You can change a column in 4 seconds.
- Everyone already knows it.
- The migration to anything else feels like a 90-day project nobody has time for.