The spreadsheet that became a system, turned into a real one
Jobs, orders and settlements move from spreadsheets and email into one application. Data is entered once and everyone sees the same version.
From spreadsheet to application
We treat the spreadsheet as the spec, because it shows how you really work.
- 1Reading the spreadsheetColumns, formulas, colours and comments tell us how the process works. We talk to the people who fill it in.
- 2App designEach tab becomes a screen or a report, and formulas become rules in the system.
- 3Moving the dataHistoric data from the sheets goes into the database. We clean up duplicates and typos on the way.
- 4Switch-overFor a few days the spreadsheet and the app run side by side. Once results match, the spreadsheet goes to the archive.
Signs your spreadsheet is already a system
The file has versions in its name
One person can edit at a time
One person understands the formulas
Decisions get lost in email
What replaces the spreadsheet
The app does what the spreadsheet did, and what it couldn't.
One database
Roles and permissions
Change history
Notifications
Reports
Export to Excel
How we check the results
We count spreadsheets, file versions and time spent reconciling data before and after the switch.
- 1Spreadsheets in circulation
- 2Email threads about decisions
- 3Time reconciling data
- 4Errors in summaries
The app's change history shows who works on the data and where errors start.
Common questions
Will we lose the data in our spreadsheets?
No. We move it into the database, and the original files stay in the archive.
The team likes Excel. Will they get used to it?
We design screens with the people who fill in the sheet today, and Excel export stays for anyone who wants to calculate their own way.
Wouldn't SharePoint or Google Sheets do?
A shared sheet fixes versions but gives you no roles, rules or decision history. For simple processes it's enough, and then we'll say so.
Which spreadsheet should we start with?
The one the most people work in and that breaks most often.
Describe your spreadsheet
Tell us what the spreadsheet is for, how many people work in it and what usually goes wrong. We reply within one business day.