← 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

→