Every business we work with has one: a spreadsheet with a name like "Master_FINAL_v3" that three people are afraid to edit and everyone depends on. It's usually the ugliest artifact in the company. It's also the most honest one.
Org charts describe intentions. Spreadsheets describe reality.
A process document tells you how a business is supposed to work. The spreadsheet that's actually running the business tells you how it really works — including every workaround, exception, and manual patch that accumulated because the "official" process didn't quite fit.
- Column headers reveal what the business actually tracks, not what a template assumes it should track.
- Manual formulas and copy-pasted sections point directly at the steps causing the most pain.
- Who's allowed to edit which tab tells you more about real responsibility than any org chart does.
What we do with it
We don't try to make the new software match the spreadsheet exactly — some of what's in there is a workaround for a tool that couldn't do what was needed, not a requirement to preserve. But we do treat it as ground truth for what the business needs to track, before we propose anything new.
If the new system can't explain every column in that spreadsheet, it's not ready to replace it.
The part people don't expect
The messiest spreadsheets are usually the best sign of a well-run business under real constraints, not a poorly run one. The mess is what happens when people solve real problems with the only tool they had. Replacing it well means respecting that, not judging it.