An industrial heating element manufacturer replaced decades of spreadsheet-based engineering calculations with a web application featuring real-time 3D visualization, automated BOMs, and one-click PDF specs. Quote time dropped from 30-45 minutes to 3-5 minutes. Sales reps now generate quotes in the field without engineering support.

The Challenge

Every heater this company builds is engineered to order -- customers specify voltage, wattage, dimensions, materials, and mounting. The engineering team calculates resistance values, wire gauges, coil specs, power densities, and material requirements for every quote.

For decades, that knowledge lived in complex spreadsheets -- hundreds of formulas, lookup tables, and conditional logic across multiple files. The operational problems were significant:

• Single point of failure: Only a few engineers understood the calculations. Quotes stalled when they were out.
• No remote access: Tools lived on specific computers. Field sales reps could not quote on the spot.
• Version chaos: Multiple copies with slightly different formulas. No one knew which was authoritative.
• Manual document creation: Spec sheets and quotes assembled by hand after every configuration.
• Months of training: New engineers took months to learn the spreadsheet system's hidden logic.

The Solution

We built a web-based product configurator that encodes the company's engineering expertise into a guided, interactive application accessible from any browser.

200+ Engineering Formulas in Code

We systematically translated every spreadsheet formula into maintainable JavaScript -- named constants, discrete calculation functions, reactive updates via React hooks, and a real-time validation layer. Every calculation was verified against original spreadsheet results across hundreds of test configurations.

Real-Time 3D Visualization

As users configure a heater, a Three.js 3D model updates instantly showing physical dimensions, terminal configurations, mounting hardware, and sheath materials. Customers rotate, zoom, and see exactly what they are ordering before committing -- dramatically reducing order errors and change requests.

Automated BOM and Cost Calculation

The configurator generates complete bills of materials with cost breakdowns: sheath material, resistance wire, insulation, terminals, hardware, and labor estimates. Material costs are maintainable without code changes. The BOM feeds directly into quote generation.

One-Click PDF Specs

Users generate professional specification sheets with technical specs, 2D engineering drawings, complete BOMs, cost breakdowns, and manufacturing notes. PDFs generate client-side using jsPDF -- no server dependency, works offline.

Manufacturing Process Routing

For internal use, the app generates operation sequences, setup/run times, material staging requirements, and quality checkpoints -- exportable to the ERP system, eliminating duplicate data entry between sales and production.

Implementation

Phase 1: Core configurator for highest-volume product line. All formulas implemented and validated against original spreadsheet results.

Phase 2: Three.js 3D visualization with parametric models that update based on configuration parameters.

Phase 3: Client-side PDF generation matching existing document standards. 2D technical drawings included.

Phase 4: Extended to additional heater types (cartridge, tubular, defrost, oven). Common functionality refactored into shared utilities.

Phase 5: BOM/costing engine and manufacturing routing generation.

Ongoing: Expanding to 30+ product configurations with pricing engine and ERP/CRM integration for seamless order processing.

The Results