Process Trail Bundle Excel | 13 Quality Tools: SPC, Gage R&R, Capability, 5 Why, Control Plan, Layered Audit | IATF 16949

A drifting process does not end when you find the cause. It starts with a reading on the check sheet, moves through containment, a check on the gage, the chart and capability, a root cause and a control plan, and finishes with proof that the fix held. This bundle gives you a working Excel tool for every step of that trail, built to hand off from one step to the next.

It is the companion to the free field book “One Drifting Shaft. The Process Trail.” The book walks the 8 steps. This bundle gives you the 13 tools to run them.

The 13 tools, step by step

Step 1: Spot the drift

QA-F-285 In-Process Inspection Sheet: record readings at the machine and catch the drift early.

Step 2: Contain it

QA-F-215 NCM Red Tag Log: tag the suspect material and log where it is.
QA-F-200 Quality Alert Form: tell the floor what the problem is and what to do about it, with operator acknowledgment.

Step 3: Rule out the gage

QA-F-295 Gage R&R: find out whether the measuring system is capable before you chase the process.
QA-F-230 Calibration Log: see which gages are in date and which are overdue.

Step 4: Read the chart

QA-F-270 SPC Control Chart: plot the readings and see whether the process is drifting.

Step 5: Measure capability

QA-F-250 Process Capability Study: judge the process against the spec limits.

Step 6: Find what changed

QA-F-310 3-Legged 5 Why Analysis: take the cause, the escape and the system through the whys.
QA-F-365 Fishbone Diagram: lay out the possible causes on one page.
QA-F-280 Setup & First-Off Inspection Report: confirm the setup and approve the first piece.

Step 7: Lock it in

QA-F-350 Control Plan: put the method, sample, frequency and reaction plan in one document.

Step 8: Prove it held

QA-F-393 Effectiveness Verification Tracker: checks at 30, 60 and 90 days, with a closure gate that says close, hold or reopen.
QA-F-205 Layered Process Audit: keep checking the process so the fix does not drift back.

One trail, start to finish

Spot and contain: catch the drift, tag it, alert the floor
Check the measuring: gage, chart and capability before you touch the process
Find and lock in: run the cause analysis, approve the first piece, update the control plan
Prove it held: verify at 30, 60 and 90 days, then audit in layers

How this differs from our other bundles
The SPC & Process Capability bundle and the Measurement and Calibration bundle stay available as shorter, entry-level sets. The Process Trail Bundle covers the whole path, from the first reading on the check sheet to proof the fix held.

Details

13 Excel workbooks in one instant download
Works with Excel 2016, 2019, 2021 and Microsoft 365
Departments, parts and examples are generic, so replace them with your own
Open each workbook’s instructions tab for setup

Built by a quality practitioner for quality practitioners: process engineers, quality engineers, quality managers, supervisors, and IATF 16949 / ISO 9001 sites. Standards referenced for informational alignment only. Not a certification.