Spreadsheets are the fastest way to prototype a business and the riskiest way to scale past 20 employees. Here is how to replace a revenue-critical workbook without breaking daily ops.
File-locking collisions: Two estimators or dispatchers cannot work simultaneously without saving conflicting copies (`Quote_Master_v4_FINAL.xlsx`).
Broken VLOOKUP margin leaks: One pasted row shifts a formula range and quietly underprices a $40,000 order.
Zero change history: Nobody can tell who changed a customer multiplier, alloy scrap factor, or commission rate last Thursday.
CSV export-reimport loops: Staff dump CSVs out of the ERP at 8 a.m., massage rows in Excel, and re-type totals back in at 4 p.m.
Single-person dependency: Only the person who wrote the macros in 2019 knows which hidden tabs must never be touched.
Phase 01Formula & edge-case extraction
Translate named ranges, rate tables, and undocumented overrides into unit-tested code backed by Postgres.
Phase 02Keyboard-fast web UI
Keep grid keyboard speed, copy-paste support, and instant CSV/PDF export so veteran staff never feel slowed down.
Phase 03Live ERP sync & permissions
Pull live item costs from your ERP automatically; lock margin-floor and rate-table edits to managers with full audit logs.
Phase 042-week shadow cutover
Run the new app alongside the old sheet for 10 business days, verify 100% math parity, then archive the workbook read-only.
Retire one high-risk workbook at a time; keep harmless ad-hoc sheets in Excel.
Typical scope & timeline
Replacing a single critical quoting, commission, or scheduling workbook typically ships in 4 to 6 weeks ($12,000–$22,000), deployed to your own cloud account with 100% source-code ownership.