Spreadsheet to Web App
Turn a complex pricing, quoting, or engineering spreadsheet into a dependable web application, with the calculations proven identical.
Spreadsheets are the most common place valuable business logic ends up, and they are genuinely good at what they do until the moment they are not. The file that started as a convenience becomes the thing the business runs on, understood by two people, impossible to give a customer, and dangerous to change. This is the specific version of that problem, and it is the one I have solved most often.
You may recognize this if
- The file has grown for years and nobody is confident what a change would break.
- It contains formulas, lookups, macros, and rules that exist nowhere else.
- Two people understand it, and one of them is planning to retire.
- Different copies are in circulation and you are not certain which is authoritative.
- You want customers to use it, but handing over the spreadsheet is out of the question.
- It breaks when someone types the wrong thing in the wrong cell.
How it is done
Inventory the formulas
Every formula, lookup, macro, validation rule, and named range gets catalogued, along with the rules that were never written down. Ambiguity gets resolved with the person who knows, before any of it becomes code.
Rebuild the calculation as a tested service
The logic moves into code with unit tests around the cases that matter, including the awkward edge cases the spreadsheet handled by accident.
Prove parity on real history
The new engine runs against real historical jobs and its output is compared against the original workbook until they agree. Parity comes before improvement, always.
Design the interface around the real user
A spreadsheet forces everyone through the same grid. An application does not, so a field measurement flow and an office review flow can each be what they should be.
Keep the rates editable
Pricing and rate tables stay under business control through an admin interface. Hard-coding them would trade a file you own for software you have to file a request against.
Proof
Custom windows and doors manufacturing · Australia
Quote production fell from 2 to 3 hours to about 10 minutes.
Common questions
- What happens to our existing spreadsheets and tools?
- They usually stay, at least at first. I prefer to connect the tools your team already trusts before replacing them. If a calculation needs to move into an application, I reproduce the logic and test it against real historical cases until the old and new results agree.
Related solutions
This is part of something broader
This is one practical form of Expert Process & Calculation Systems. A wider project may combine it with applications, integrations, reporting, or AI depending on where the process is breaking today.
Expert Process & Calculation Systems