← All projects
PRJ-01
OCT 2022 — JAN 2023 · Axis Lighting, Montreal
Shop Drawing Standards
Process Standardisation · Technical Documentation
Process StandardizationTechnical DocumentationExcel/VBA ToolsShop Drawing
Replaced scattered documents with a version-controlled standards library and verification tools for a 26-member shop drawing team.
Shop drawing team members using the standards
26
Core standards documents authored
6
Challenge
- Shop drawing NCRs were high, and drivers were the biggest category.
- Root cause was the process, not the people.
- Old calculators and multiple document versions sat in departmental folders.
Approach
- Mapped the current state with shop drawing, engineering, production, supply chain and methods.
- Wrote the Driver Selection Process: approved by Engineering, then revised 9 times as products changed.
- Authored 5 more standards: driver amperage, input power and current, reflector logic, and mechanical data sheet.
- Built Excel/VBA verification tools and checklists for the SD team, production and special orders.
- Stored everything in SolidWorks PDM and trained the SD team on driver selection.
Outcome
- One version-controlled source of rules and tools for the shop drawing team.
- Exposed the issues that led to the Shop Drawing Validation Program.
Artifacts
Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.

Next · PRJ-02
Shop Drawing Validation