Work Instruction & Change Release Excel | Step-by-Step WI with Photos, Training Sign-off by Shift, Release Dashboard | IATF 16949 ISO 9001

A corrective action is not done when the 8D closes. It is done when every operator on every shift is running the new method. This workbook holds the step-by-step work instruction, records exactly what changed and why, and tracks training sign-off until the whole floor is verified on the current revision. A live dashboard tells you when the change is truly released.

A step-by-step work instruction, with photos
Every step is a card: the written step, HOW, WHY, gage or tool, frequency, and a photo box underneath. Steps that changed this revision turn gold. Symbols mark key characteristics, safety steps and quality checks. A reaction plan, revision history and approvals finish the page.

Change release record
Record what triggered the change (8D, CAR, audit finding, engineering change), the reference number, the PFMEA line and Control Plan characteristic it ties to, the effective lot, and a plain-language “what changed” and “why”. It becomes the paper trail from the complaint to the floor.

Training sign-off by operator and shift
List every operator who runs the job. Enter the revision they were trained on, the date, trainer and method, then verify by watching a run. Status sets itself:

PENDING: listed, not trained, still inside the window
TRAINED: trained, waiting on verification
VERIFIED: trained and verified on the current revision
OVERDUE: not trained and the training window has passed
RETRAIN: trained on an older revision

Release dashboard
The dashboard reads RELEASED only when every listed operator is verified. Otherwise it says IN PROGRESS or NOT RELEASED and tells you how many operators are overdue or on an old revision. Breakdowns by shift and by department show where training is behind, and nine release checks flag missing paperwork (trigger, reference, what changed, approval, reaction plan) before an auditor does.

Worked examples included
A full 8-step instruction for a deburr and hole-inspection operation after a customer complaint, plus a 12-operator, 3-shift sign-off example that shows the dashboard in practice (9 verified, 1 trained, 1 overdue, 1 on an old revision). Example pictures are illustrations. Replace them with your own photos.

What’s inside (7 tabs)

Settings: training window, dropdown lists, operator roster
Work Instruction: blank step-by-step template with change-release record
WI Example: worked 8-step example
Training Sign-off: roster, status and verification
Sign-off Example: 12 operators across 3 shifts
Dashboard: release status, shift and department breakdowns, 9 release checks (LIVE / EXAMPLE view switch)
Instructions: setup, workflow and field definitions

Details

Microsoft Excel (.xlsx), no macros, no plugins
Works with Excel 2016, 2019, 2021 and Microsoft 365
Supports 40 operators per instruction; one operation per workbook
Instant digital download

Built by a quality practitioner for quality practitioners: quality managers, corrective action owners, production supervisors, training coordinators, and IATF 16949 / ISO 9001 sites. Standards referenced for informational alignment only. Not a certification.