Work Instruction Automation System
Reduced work-instruction creation time by approximately 80–90% while improving consistency and revision control.
Problem
Creating assembly work instructions manually required repetitive formatting, image placement, revision work, and quality checks. The process took engineering time without adding technical value.
Constraints
- Fit the company's existing Excel and PowerPoint workflow
- Preserve revision history
- Support varied assembly complexity and image counts
- Flag missing information before output
Engineering approach
I separated structured content from presentation. Engineers enter parts, equipment, steps, hazards, PPE, and revision information in Excel; Python validates the inputs, processes images, and assembles the presentation.
Key decisions
- Selectable 2-, 4-, or 8-step page layouts
- Custom PPE by assembly
- Revision history retained rather than overwritten
- Validation focused on actionable missing fields
- Standardized parent and subassembly references
Implementation
The application builds PowerPoint work instructions from structured worksheets and organized image folders. Layout logic keeps step text readable and images consistently placed while accommodating different instruction lengths.
What I learned
Useful automation must fit the engineer's real workflow. The biggest gains came from making the system flexible enough for different assemblies while keeping output predictable for operators.
Company templates, part numbers, product details, and internal screenshots are intentionally excluded. The case study focuses on the engineering system and verified outcome.