← All projects

PRJ-07

Jan 2025 — Mar 2025 · Axis Lighting

PCB Series/Parallel Mikrolite Tool

Electrical Engineering · Excel Tooling

Excel tool that calculates driver currents and board forward voltage for PCBs wired in series/parallel combinations, standardizing electrical spec-out across teams.

TEAMS ALIGNED ON ONE TOOL

05

Problem

Electrical, shop-drawing, and methods-of-manufacturing teams each ran their own driver-current and Vf math for series/parallel PCB arrangements — inconsistent results and slow spec turnarounds.

Approach

  • Modeled series/parallel PCB behavior for driver current and board forward voltage in a single Excel workbook
  • Validated results against measured bench data across representative product families
  • Rolled out through cross-functional training to shop drawing, electrical, mechanical, continuous improvement, and methods-of-manufacturing teams

Outcome

One shared calculator adopted across five teams — consistent driver/Vf numbers, faster electrical spec-out, and a common reference during design reviews.

Artifacts

Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.

Cross-functional training session — walkthrough of the driver-current and forward-voltage calculator delivered to the shop drawing, electrical, mechanical, continuous improvement, and methods-of-manufacturing teams.

Next · PRJ-01

DriveWorks Product Automation