Case 01 · Order handling
Seventy-eight sheets, no owner, no specification
The workbook ran the order process. Nobody had written down how. Every rule lived inside a formula, every exception in somebody’s memory, and the file could no longer be edited safely by more than one person at a time. We read it end to end, recovered the rules rather than guessing them, and rebuilt it as a production application with roles, permissions and an audit trail in days rather than quarters.
Spreadsheet to system
- Legacy workbook
- Rebuilt in production
What was read
The whole file, not a sample. Seventy-eight sheets, every formula and every cross-reference, including the tabs nobody had opened in two years.
What was recovered
The rules, stated explicitly. This included several the business did not know it was applying, and two it no longer agreed with.
What was delivered
An application, not a spreadsheet with a nicer front end. Roles, permissions, an audit trail, and more than one person able to work at once.