Resource Library/Process Control and Measurement/Gage R&R Study Data Sheet
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
- 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
A calibration certificate shows the gauge reads true on a gauge block in a lab. It does not show whether two inspectors get the same answer on a real part at the machine, or whether the gauge can tell good parts from bad on a tight tolerance. That is what a gauge study answers, and auditors and customers ask for one behind every capability number and key characteristic. Most shops either skip it or run it in a spreadsheet nobody can check. This data sheet lays out the study, does the arithmetic of the average and range method with the published constants, and records the decision.
Who uses it
Quality engineers and metrology or calibration staff; the operators and inspectors who take part.
When
Before a gauge is used on a key characteristic or a capability study; after a gauge is repaired, replaced or found out of tolerance; when a customer's measurement system requirement calls for one; and on the interval your MSA plan sets.
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 kit and how the tools connectThe FAI and Production Readiness Kit Handbook, chapter 2
- The calibration control workflowThe Calibration Control Kit Handbook, chapter 3
- Inspection planning and key characteristics (E11, D16, E07)The FAI and Production Readiness Kit Handbook, chapter 7
- Who does whatThe Calibration Control Kit Handbook, chapter 4
- Proving fitness: measurement system analysis (E03, E04)The Calibration Control Kit Handbook, chapter 10
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
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 · PDFFree download -
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
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 -
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 -
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
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.