Resource Library/Process Control and Measurement/SPC Process Monitoring Worksheet
SPC Process Monitoring Worksheet
An X-bar and R control chart in a workbook: limits from your own data with the published constants, four signal rules checked on every subgroup, a picture of where each mean sits, and a reaction record on every signal.
- Excel
- fillable PDF
- Worked example
- Your logo on it
- Aegis Insights
Page 1 of the PDF. Every resource includes a fully worked example.
The problem it solves
Plenty of shops chart a key characteristic because a customer asked for it, and few use the chart to run the process. Limits get drawn from the drawing tolerance, signals go unnoticed or unanswered, and the chart is filled in at the end of the shift. This worksheet calculates proper control limits from the process's own data, checks every subgroup against four signal rules as it is entered, and keeps the reaction on the same row as the signal, so the chart is a record of control, not just of measurement.
Who uses it
Manufacturing and quality engineers who set up charts; machinists and inspectors who keep them.
When
On key characteristics and on any feature where the control plan calls for SPC; after a corrective action on a process; and when you want warning of a drift before parts go out of tolerance.
Free to use, change and copy, in your own organization or with your clients; add your own logo, keep the Aegis credit. Clause references: 8.5.1, 9.1.1, 9.1.3 (with 7.1.5) (numbers only; use your own licensed copy of the standard).
A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard.
How to put it to work
Chapters of our free guides that use this tool.
- The kit and how the tools connectThe Calibration Control Kit Handbook, chapter 2
- Proving fitness: measurement system analysis (E03, E04)The Calibration Control Kit Handbook, chapter 10
- Worked example: the same instruments through the whole kitThe Calibration Control Kit Handbook, chapter 17
Related resources
-
Workbook
Process Capability (Cp/Cpk) Calculator
Paste your readings and get Cp, Cpk, Pp and Ppk with the published constants, a confidence bound, the expected parts out of specification, a stability check and a picture of the spread.
Excel · PDFFree download -
Workbook
Gage R&R Study Data Sheet
Run a gauge repeatability and reproducibility study by the average and range method: up to three operators, three trials and ten parts, with every result, the published constants and the verdict worked out for you.
Excel · PDFFree download -
Template
Control Plan Template
A control plan in the columns aerospace customers expect, with a line check that flags missing reaction plans, methods, gauge studies and capability on key characteristics before a reviewer does.
Excel · PDFFree download -
Workbook
Manufacturing Process Risk Assessment
A process FMEA in plain terms: every way each step can fail, rated on scales in plain language, prioritized severity first by levels you set, and each action followed to a re-rating and the control plan.
Excel · PDFFree download -
Workbook
Nonconformance Management Log
One line per NCR, from the moment it is found to the moment it is closed: the part, the requirement, where it was found, the disposition and who authorized it, customer approval, cost, the corrective action link and how long it has been open.
Excel · PDFFree by email -
Worksheet
CAPA Effectiveness Verification Worksheet
Prove a corrective action worked, not just that it was done: separate containment, correction and corrective action, set a measurable criterion before the action goes in, and hold the record open until the evidence is in.
Excel · PDFFree by email
Need more than one resource, or not sure where to start? Book a complimentary 30-minute Aegis Quality Guidance Call. We'll find the tools that fit your situation and a sensible place to start. No sales pressure, no obligation.
These tools help you run the work by hand. When you want the whole picture of your quality system from the records you already keep, that's what the AeroAssure Audit Defense Pack and the IA9100 Transition Gap Analysis do.