Quote automation for special parts in medical technology

The client was losing high-value order opportunities to a five-to-seven-day delay in quoting custom medical components. Every specification sheet had to pass through the engineering department so that price and manufacturability were determined correctly.

The entire pricing and feasibility framework sat in a single master spreadsheet of the chief engineer, grown over fifteen years — thousands of linked cells, proprietary metallurgical formulas and historical supplier prices. The spreadsheet was extraordinarily precise but so fragile that only the chief engineer could operate it safely. That made him an administrative bottleneck.

We deliberately decided against an expensive reprogramming of the engineering logic. Instead, we preserved the chief engineer's spreadsheet as the central calculation engine and wrapped it in an automated API layer, through which even non-technical sales staff could trigger the calculations safely and in a guided way.

As a solo engagement, we isolated the spreadsheet on a hardened internal server and developed a Python microservice with specialized spreadsheet libraries. Alongside it, we built a clear, intuitive web assistant for sales: when a salesperson entered the customer's raw dimensions and material requirements, the microservice fed them into the hidden cells, triggered the calculation, extracted the finished cost values and automatically generated a clean PDF quote.

The quoting cycle dropped from several days to under twelve minutes. Sales staff could produce binding quotes directly in the first customer conversation, instead of routing requests through engineering.

The chief engineer retained full sovereignty over his spreadsheet and continued to update raw-material costs directly in Excel — without ever having to touch a single line of application code.