Engineering / Commodity Logistics
Dynamic Pricing Engine
650+ Formula Calculations at Scale for Mining & Commodities.
Objective
Transform traditional, fragile Excel spreadsheets with over 650 complex mathematical formulas into a robust, centralized web application.
Outcome
A high-performance pricing logic engine capable of executing concurrent multi-variable formulas with a user-customizable interface and real-time analytical depth.
The Fragility of Scale
Mining operations rely on hyper-specific pricing formulas that fluctuate based on purity, weight, global index shifts, and logistics surcharges. For years, these resided in legacy spreadsheets that were prone to human error and lacked version control.
Our mission was to centralize this logic into an asynchronous execution environment where formulas could be updated via a GUI without code deployment, while maintaining sub-millisecond calculation speeds for analytical querying.
Core Architecture
Infrastructure
The Evaluation Pipeline
Ingestion
Real-time market indices and commodity purity levels are ingested via RabbitMQ workers.
Parsing
Symfony Expression Language evaluates complex formula nodes safely within an asynchronous PHP pool.
Aggregation
Calculated metrics are aggregated into PostgreSQL for high-speed analytical dashboarding.
System Capabilities
Async Evaluation
Parallel processing of 650+ mathematical formulas using amphp, reducing calculation time from minutes to milliseconds.
Formula Builder
A bespoke UI allowing engineers to construct complex logic using a library of predefined nodes and variables.
Analytics Dashboard
Leveraging PostgreSQL for fast analytical queries across millions of historical pricing points.