IT Infrastructure Cost Estimator
A complex Excel workbook transformed into a responsive web application with dynamic pricing, PDF reports, and multi-region support.
The Challenge
A proptech consulting firm relied on a complex Excel spreadsheet to estimate IT infrastructure costs for building projects. The spreadsheet had grown over years into a tangled web of formulas that only one person understood. It couldn't be shared with clients, didn't scale to multiple users, and required manual PDF creation for every proposal.
Our Solution
We reverse-engineered the entire calculation chain and rebuilt it as a web application. Every formula, every lookup table, every conditional — faithfully replicated in code. Then we added what Excel couldn't: multi-user access, a guided wizard for project creation, automatic PDF generation, and an override system that lets users tweak any value without breaking downstream calculations.
Dynamic Calculation Engine
A multi-step formula chain that replicates complex spreadsheet logic: building blocks, equipment multipliers, regional pricing, and cost derivations.
PDF Report Generation
Professional 3-page landscape design briefs generated via headless Chrome, matching the client's existing document format.
Multi-Region Pricing
Four global regions with different cost bases and equipment specifications. Pricing adjusts automatically based on region and site size.
Override System
Every calculated value can be manually overridden without breaking the formula chain. Overrides are tracked and can be reverted.
5-Step Project Wizard
Guided project creation: building blocks, zones, regions, site sizes, and scope toggles. Complex configurations made approachable.
Excel Import/Export
Import existing project data from Excel and export results back — bridging the gap between the legacy spreadsheet and the new platform.