Motivation
At any given time, the team was managing a large number of simultaneous machine builds — each a long-duration project with its own milestones and timelines. Project managers had no quick way to see the status of every active build at a glance, or to spot which ones were falling behind before it became a problem. Status lived in spreadsheets that required digging to interpret.
Implementation
Since project data already lived in Excel, the solution was built entirely in VBA. A macro reads all active project inputs across all product lines and generates a standardized scorecard for each build: current status, outstanding milestones with due dates, and a week-over-week progress comparison. The output gives managers a single, consistent view across all machine types and product lines without requiring any manual compilation.
Tools & Technologies