Resource Library/Process Control and Measurement/MSA Planning Worksheet
MSA Planning Worksheet
Decide which measurement systems need a study, which study, who runs it and by when, then track the verdicts, the conditions and the re-study dates in one plan.
- 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
Calibration shows a gauge reads true on a standard. It does not show the gauge is fit for the characteristic it measures, in the hands of the people who use it. Customers and auditors increasingly ask for that proof behind key characteristics and capability numbers, and most small shops have a few studies in a folder and no plan. This worksheet lists every measurement system that needs proving, picks the study, schedules it, and turns each result into a verdict and a re-study date, so the gaps are visible before someone else finds them.
Who uses it
Quality engineers and metrology or calibration staff; quality managers who review the plan.
When
Set it up from your control plans and calibration register; add a line for every new gauge, key characteristic or capability study; review monthly and before audits.
Free to use, change and copy, in your own organization or with your clients; add your own logo, keep the Aegis credit. Part of: Calibration Control Kit. Clause references: 7.1.5, 7.1.5.1 (with 8.5.1 and 9.1.1) (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
- The calibration control workflowThe Calibration Control Kit Handbook, chapter 3
- Who does whatThe Calibration Control Kit Handbook, chapter 4
- Proving fitness: measurement system analysis (E03, E04)The Calibration Control Kit Handbook, chapter 10
- Records that hold upThe Calibration Control Kit Handbook, chapter 13
- The weekly and monthly rhythmThe Calibration Control Kit Handbook, chapter 14
Related resources
-
Workbook
Calibration and Measurement Risk Register
More than a calibration log: track every instrument's due date and status, what it measures and how far a failure would reach, and run an out-of-tolerance impact assessment the day a calibration fails.
Excel · PDFFree by email -
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 -
Workbook
Out-of-Tolerance Impact Assessment
When a calibration comes back out of tolerance: record the event, trace every lot the instrument measured since it was last known good, judge each reading against its limits with the error, decide, tell the customer where needed, and close with the evidence.
Excel · PDFFree by email -
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 -
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
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 · PDFFree download
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.