Operations desk with printed spreadsheets, calculator, and dual monitors

Migration playbook

Retiring the master workbook.

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.

Get a free workflow snapshot

Five warning signs a workbook has outgrown Excel

  • 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 01 Formula & edge-case extraction

Translate named ranges, rate tables, and undocumented overrides into unit-tested code backed by Postgres.

Phase 02 Keyboard-fast web UI

Keep grid keyboard speed, copy-paste support, and instant CSV/PDF export so veteran staff never feel slowed down.

Phase 03 Live 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 04 2-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.

Industrial counter terminal surrounded by parts binders and order forms
Retire one high-risk workbook at a time; keep harmless ad-hoc sheets in Excel.

Send a redacted copy of your scariest workbook

Strip customer names if needed. Caleb replies in 2 business days with a migration plan and fixed-scope estimate.

Get a free workflow snapshot