Gage R&R Data Collection Sheet (Two Operators, Two Trials)
Before you trust an SPC chart or a capability index, you need to know whether the gauge is good enough. This sheet is the data-collection form for a two-operator, two-trial study, with live ranges and a quick repeatability estimate.
| Part # | Op A trial 1 | Op A trial 2 | Op B trial 1 | Op B trial 2 | Range A | Range B | Part mean | |
|---|---|---|---|---|---|---|---|---|
0.002 | 0.004 | 25.013 | ||||||
0.002 | 0.002 | 25.0305 | ||||||
0.003 | 0.003 | 25 | ||||||
0.002 | 0.005 | 25.0462 | ||||||
0.002 | 0.002 | 25.0215 | ||||||
0.002 | 0.004 | 25.007 |
Standard studies use 10 parts, 2 or 3 operators and 2 or 3 trials, in random order. This sheet gives a quick repeatability estimate only. Use your Gage R&R calculator or statistical software for full %GRR, reproducibility and ndc.
Tie MSA studies to inspection plans
Optional: a review of how gauge studies and calibration records can link to inspection characteristics in your ERP.
Optional. The tool and every export work without this. No spam.
How to run the study
Pick parts that span the process range, not ten identical ones. Number them out of sight of the operators. Have each operator measure every part twice in random order without seeing the earlier reading. Enter readings in the table. The sheet computes the range of each pair, the part mean, and the overall average range. Multiply Rbar by the K1 constant (0.8862 for two trials) to estimate equipment variation. Keep the unit and resolution the same as production.
- Use at least 10 parts for a formal study; the sample rows show how the sheet works
- Randomize the measurement order
- Operators must not see their earlier readings
- Record the gauge ID and calibration status with the export
Method and what the numbers mean
The average and range method estimates repeatability from the within-operator ranges and the part-to-part spread from the spread of part means. Equipment variation compared with the tolerance or the total variation shows how much the gauge consumes. Common AIAG guidance treats under 10% as acceptable, 10% to 30% as conditionally acceptable depending on the application, and over 30% as not acceptable. Reproducibility (operator to operator) needs the operator averages, which the full calculation covers.
Common mistakes
Using parts that are all nearly identical makes the gauge look worse than it is because there is no part variation to compare against. Letting operators see earlier readings biases the result. Studying a worn or uncalibrated gauge wastes time. Also check resolution: if your gauge cannot split the tolerance into at least ten steps, repeatability will look poor no matter how careful the operators are.
Frequently Asked Questions
Why use two operators and two trials?
It is the minimum design that lets you estimate both repeatability (same operator, same part) and some operator effect. More operators, parts and trials give a more reliable answer. Ten parts, three operators and three trials is a common formal design.
What is the K1 constant?
K1 converts the average range into a standard deviation estimate for repeatability. It is 0.8862 for two trials and 0.5908 for three trials. It comes from the d2 factor, so it depends on the number of trials per operator.
What is an acceptable gage R&R result?
AIAG MSA guidance treats under 10% of total variation or tolerance as acceptable, 10% to 30% as possibly acceptable based on cost and risk, and over 30% as unacceptable. Your customer or quality manual may set a stricter rule.
Is this a replacement for software?
No. It is a data-collection form with a quick repeatability check. For a complete analysis with reproducibility, interaction and number of distinct categories, use a full Gage R&R calculation or statistical software.
If you want MSA results recorded against gauges and inspection plans in your ERP, Netray can help set that up.
Related Tools
SPC Control Plan Worksheet
Row-by-row control plan that picks the chart type, sample size and reaction plan for each characteristic. Export to Excel.
Quality & InspectionFishbone Cause and Effect Worksheet
Tabular fishbone: capture causes by 6M category, add evidence and team votes, rank them and export to Excel.
Quality & InspectionDefect Check Sheet Worksheet
Tally defect types by day, get row and column totals, and feed the counts into a Pareto chart. Exports to Excel.
Quality & InspectionSAP QM Gauge R&R Study Calculator
Combine repeatability, reproducibility and part variation into %GRR, %tolerance and distinct categories.
More Quality & Inspection tools
See all- Cpk Confidence Interval Calculator
- Pp Ppk Process Performance Calculator
- DPMO and Sigma Level Calculator
- X-bar and R Control Chart Limits Worksheet
- Control Chart Constants Table (A2, D3, D4, d2, c4)
- P Chart Control Limits Calculator
- Defect Pareto Analysis Worksheet
- DMAIC Project Charter Template
- SIPOC Diagram Template
Keep exploring
Free tools
- Gage Master List WorksheetAn editable inventory of every measuring device with identification, location, status and calibration interval.
- Gage Stability Study Control Chart WorksheetLog repeated master readings over time and get subgroup means, ranges and X-bar and R control limits for a stability check.
- Gage R&R Python Script Generator (Average and Range)Fill in the file name, tolerance, and get a plain Python script that computes the average and range gage R&R.
ERP fixes and how-tos
- Acumatica Manufacturing Data Collection: Labor and Production EntryHow shop floor data collection works in Acumatica Manufacturing: clock, labor, move and material entry, who should enter what and how to keep data clean.
- Infor Factory Track for M3: Shop Floor Data Collection ExplainedWhat Infor Factory Track does for M3 manufacturers: shop floor data collection feeding M3 orders, how the integration is structured and how to plan the setup.
- Infor XA Factory Track: What It Does and How to Plan Shop Floor Data CollectionWhat Factory Track does for Infor XA shop floor data collection, which transactions it captures, how to plan a setup, and alternatives when it is aging.
Runs with your ERP
- RF-SMART Manufacturing Data Collection for JD Edwards WorldShop floor barcode data collection for JD Edwards World with RF-SMART: what it reports, how it connects, setup steps, pitfalls and a private AI layer on top.
- RF-SMART Manufacturing Data Collection with JD Edwards EnterpriseOneHow RF-SMART collects work order completions, labor, lot and serial data and shop floor labels in JD Edwards EnterpriseOne, online or offline: setup, pitfalls.
- Infor VISUAL Shop Floor Mobile for Labor TrackingHow Infor VISUAL Shop Floor Mobile captures clock-ins and labor data from shop-floor devices directly into VISUAL: data flow, setup, pitfalls and private AI.
Guides
- How to Estimate Laser Cutting Cost Per PartA working formula for laser cutting cost per part: cut time, pierce time, assist gas, material by nest, machine rate, setup and handling for fab shops.
- Offline-Capable Mobile Data Collection for SyteLineBuild offline-capable mobile data collection for SyteLine. Configure local storage, sync queues, and conflict resolution for CloudSuite Industrial mobile apps.
- Shop Floor Data Collection: Connecting Machines and Operators to Your ERPShop floor data collection guide: connect CNC machines, barcode scanning, and IIoT sensors to ERP. Covers OPC UA, MTConnect, Factory Track, costs, and AI agents.
Integrations
- How to add a mobile app to Infor SyteLineBuild or extend a mobile app for Infor SyteLine: barcode scanning, labor reporting, inventory moves and approvals over IDO REST, with offline and device options.
- How to add a mobile app to Global Shop SolutionsOptions for a mobile app on Global Shop Solutions: vendor mobile tools, barcode scanning, shop floor data collection and custom apps over ODBC or APIs.