Excel template
Control Plan Excel Template
AIAG format Control Plan with Row Check, gauges and MSA and a one-page dashboard
Control Plan template for Excel in AIAG format for IATF 16949: 6 tabs, 200 characteristics, a 100-gauge MSA list, an automatic Row Check on every line and a one-page dashboard. Example file and blank file, no macros.
- AIAG layout for IATF 16949, 200 characteristic rows
- Row Check flags visual-only special characteristics, low frequency, gauge issues and missing PFMEA reference
- Gauges and MSA tab: %GR&R, calibration due date and status flow into each row
- Special characteristics overview on one page
- Phase prototype, pre-launch, safe launch or production with approvals and core team
- Example file (water pump line, 22 characteristics, 16 gauges) and blank file
Secure checkout by Polar. Digital download: at checkout you agree to immediate delivery and waive the 14-day withdrawal right, so downloads are not refunded. Support: info@qmbench.com.
Free alternativeTry the free online tool firstThe free Control Plan on QM Bench runs in your browser with a PDF report. The template is for a file you keep, edit and fill with your own data.Open the free toolWhat is inside
- 1
Start Here
5-step workflow and the checks built in.
- 2
Dashboard
Characteristics, special characteristics and their issues, rows with issues, gauge / MSA issues, completeness, issues-by-type chart and the issue list.
- 3
Control Plan
200 rows in AIAG layout: operation, machine, product and process characteristic, special class, specification with LSL / USL, technique, gauge, sample size, frequency, control method, reaction plan, responsible, PFMEA reference, severity, MSA status and Row Check.
- 4
Gauges & MSA
100 gauges with type, resolution, location, calibration due date, MSA result, ndc, status and where each gauge is used.
- 5
Settings
Evaluation date, your special-characteristic symbols (CC, SC or customer symbols) and the dropdown lists.
- 6
Revision History
30 revisions.
Try the template in your browser
A simplified copy of the Row Check: every line is checked for specification, gauge, sample and frequency, reaction plan and, for CC / SC characteristics, an acceptable MSA.
DemoIllustrative preview with example data, not the template itself. The Excel file has more rows, tabs, charts and checks.
| Op. | Characteristic | Class | LSL | USL | Gauge | Sample | Frequency | Reaction plan | MSA | Row Check |
|---|---|---|---|---|---|---|---|---|---|---|
| OK | ||||||||||
| OK | ||||||||||
| Check: gauge, reaction plan, MSA | ||||||||||
| Check: MSA |
The workbook has the full AIAG layout with 200 rows, a 100-gauge MSA list that fills the MSA status, PFMEA reference and severity, and a one-page dashboard.
A Control Plan that checks itself
Every row is checked for what auditors look for: special characteristic checked only visually, low frequency, gauge overdue or not capable, severity 9 to 10 without special class, special characteristic without PFMEA reference and incomplete rows.
Gauges and MSA in the same file
%GR&R or attribute effectiveness and the calibration due date flow into the Control Plan automatically, with the usual acceptance bands: up to 10 % acceptable, 10 to 30 % conditional, above 30 % not acceptable.
One page for the audit
The dashboard and the special characteristics overview show the state of the plan at a glance.
Honest scope
No PFMEA (enter the reference and severity), no process flow diagram, SPC charts or MSA study calculation, and no customer-specific forms. Not affiliated with AIAG or IATF.
Who it is for
- Quality and process engineers preparing APQP / PPAP submissions
- Automotive and industrial suppliers working to IATF 16949 or ISO 9001
- Plants that need an audit-ready Control Plan without expensive software
Not included
- PFMEA (enter the PFMEA reference and severity manually)
- Process flow diagram, SPC charts or MSA study calculation (enter your GR&R result)
- Customer-specific Control Plan forms
Details
- Format
- Microsoft Excel .xlsx, 2 files, 6 tabs
- Works in
- Excel 2010 or newer, Microsoft 365 (Windows, Mac), LibreOffice Calc
- Macros
- None
- Rows
- 200 characteristics, 100 gauges, 30 revisions
- Standard
- IATF 16949 8.5.1.1, 8.3.3.3, 7.1.5.1.1; AIAG Control Plan format
- Sample data
- Water pump line: 22 characteristics, 16 gauges
- Delivery
- Instant download after payment
Frequently asked questions
›Where do I buy it?
Here on QM Bench with the Buy button: secure card checkout by Polar with a receipt, and the two Excel files arrive by e-mail right after payment.
›Is there a free alternative?
Yes. The free Control Plan tool on QM Bench builds a plan in your browser with a PDF. The Excel template adds the Row Check, the gauges and MSA list and the dashboard in a file you keep.
›Does it work with the PFMEA template?
Enter the PFMEA reference and severity in each row. The PFMEA Excel template lists the special characteristics you transfer here.
›Can I get a refund?
No. It is a digital download: at checkout you agree to immediate delivery and waive the 14-day right of withdrawal, and the file stays with you. If something does not work as described, write to info@qmbench.com and you will get help or a corrected file.
Get the Control Plan Excel Template
Instant download by e-mail after payment. Paste your measurements and read the verdict.
Buy now · €14Or try the free online tool first →