← All projects

PRJ-09

Released May 2025 · Axis Lighting

MU10 Pattern Solver

ENGINEERING AUTOMATION · EXCEL TOOLING

Tools & Excel

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

→