PRJ-09
Released May 2025 · Axis Lighting
MU10 Pattern Solver
ENGINEERING AUTOMATION · EXCEL TOOLING
Co-developed a macro-driven Excel solver for every pattern fixture shape — mechanical and electrical solving inside MU10, released May 2025.
PATTERN SHAPES SOLVED
0→freeform
PATTERN DRAWINGS
Engineers verify→self-serve
Problem
Complex pattern fixtures were not automated. Shop drawers built the mechanical layout from reflected ceiling plan drawings supplied by the applications team, then waited on the electrical engineering team for drivers, driver currents and input power and current — which took a long time.
Approach
- Co-developed a macro-driven Excel solver for all pattern shapes — free-form, circle, T-shape, X-shape, oval, rectangle and other shapes
- Guided workflow: initial sections, power drops and circuits, optional section length overrides, then solve and optimize with an alternate-emitter option
- Personally built the electrical solving — driver current and forward voltage for both colour temperatures — plus power selection and driver selection
- Built the summary tables and compiled Axis and client notes with driver and LED board quantities for the BOM, with copy-to-clipboard of a ready-to-paste summary table
- A teammate built section generation and mechanical reflector solving; the solving logic was handed to IT as the specification for porting into the universal configurator
Outcome
Released May 2025. Shop drawers can solve a complete pattern fixture (mechanical and electrical) inside MU10 instead of waiting on the engineering team for reflector lengths, drivers, driver currents and input power and current. Uniform solving logic covers every pattern shape, producing driver selections, current and forward-voltage values for both colour temperatures, a ready-to-paste summary table, and compiled Axis and client notes with driver and LED board quantities for the BOM.
Artifacts
Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.
USING THE MU10 PATTERN SOLVER FOR FREE-FORM PATTERNS — FROM THE GUIDED INPUT WORKFLOW THROUGH SOLVING TO THE DRIVER SELECTIONS, CURRENT AND FORWARD-VOLTAGE OUTPUTS.
Next · PRJ-10
Jira Service Desk Ownership