← All projects
PRJ-04
MAR 2023 — JUNE 2024 · Axis Lighting
MU10 Linear Solver
Process Design · Engineering Tools
ExcelVBASolidWorks PDMSQLElectrical Solving LogicVersion Control
A single, version-controlled Excel solver for linear fixtures. It gives every department the same driver current, board voltage, driver selection, input power and input current.
Preliminary Excel tools
8→1
Teams on read-only PDM Vault access
5
Challenge
- 7–8 preliminary Excel tools were fixed and stored in the Vault, but NCRs stayed high.
- Each tool had its own logic, and teams checked values against different sources.
Approach
- Built on my Methods Configurator to show leadership the value of one tool for all products.
- Designed the electrical solving logic: driver currents, board Vf, driver selection, input power and current, notes and summary tables. A mechanical colleague built the mechanical solving.
- Added a standard mode with an info center, and an advanced mode for engineering.
- Released in the PDM Vault with revision control and read-only access for Shop Drawing, Methods, CI, Quality and Engineering Support.
Outcome
- Released with most linear products covered; older products were integrated later.
- Retired the old Fixture Configurator Tester and Power Configurator.
- Enhancements shipped through several revisions and versions.
- The logic became the starting point for the Universal Configurator, built by IT.
Artifacts
Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.
MU10 LED RSET Calculator — short preview of the released calculator solving section emitters, driver currents, board Vf, input power and input current from one universal Excel + VBA model.
Next · PRJ-05
LED Board Depletion