Mold Tuning Digital Function Module
Turning unmaintainable, complex Excel calculations into a system driven by JSON config files.
Overview
A calculation system for digital mold tuning: users enter measured values, the system runs the trigonometry and formulas automatically, stores every record, and ships with an admin back office.
Why it was needed
The calculations and records were kept in Excel on site. Once the data grew it couldn't keep up — error-prone and hard to maintain.
My role
The front-end pages, the back-end system, the NoSQL database design, and the admin data-management pages.
Technical challenge
Every mold base has its own layout, formulas and diagrams. Hard-coding each one would have made maintenance and extension a nightmare. The core challenge was abstracting those differences away.
Implementation
A single JSON config file drives the sample images, layout and calculation formulas. Supporting a new mold base means maintaining JSON — never touching the fiddly page templates.
Result
Delivered and in use by the client.
Details
System design overview
The system converts and computes specialist mold data such as digital mold-tuning values.
Configurable diagrams and copy
The system renders the matching diagrams and explanatory text from the JSON config, so the interface stays intuitive to operate and understand.
Trigonometry and formula calculation
Users type in simple measured values and the system works out the required angles and other results, shown directly on the page.
Calculation record management
Every calculation is stored in MongoDB so administrators can review and analyse the data from the back office.
Core design: driven by JSON config
The heart of the system is switching between mold-base requirements without rebuilding anything. A single JSON config file therefore governs the sample images, layout and calculation formulas.