# Gage R&R Data Collection Sheet (Two Operators, Two Trials)

> Source: https://netray.co/tools/gage-rr-data-collection-sheet-excel
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Record two-operator, two-trial measurements per part and get ranges, part means and an approximate repeatability estimate.

## Category

quality

## Industry

Manufacturing

## Audience

- Quality engineer
- Metrology technician
- Supplier quality
- Six Sigma Green Belt

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Part #

**Key:** part

**Type:** text

#### Op A trial 1

**Key:** a1

**Type:** number

#### Op A trial 2

**Key:** a2

**Type:** number

#### Op B trial 1

**Key:** b1

**Type:** number

#### Op B trial 2

**Key:** b2

**Type:** number

#### Range A

**Key:** ra

**Type:** number

**Expr:** abs(a1 - a2)

**Format:** decimal

#### Range B

**Key:** rb

**Type:** number

**Expr:** abs(b1 - b2)

**Format:** decimal

#### Part mean

**Key:** pm

**Type:** number

**Expr:** (a1 + a2 + b1 + b2) / 4

**Format:** decimal

**Rows:**

**Part:** 1

**A1:** 25.012

**A2:** 25.014

**B1:** 25.011

**B2:** 25.015

**Part:** 2

**A1:** 25.031

**A2:** 25.029

**B1:** 25.032

**B2:** 25.03

**Part:** 3

**A1:** 24.998

**A2:** 25.001

**B1:** 24.999

**B2:** 25.002

**Part:** 4

**A1:** 25.047

**A2:** 25.045

**B1:** 25.049

**B2:** 25.044

**Part:** 5

**A1:** 25.022

**A2:** 25.02

**B1:** 25.023

**B2:** 25.021

**Part:** 6

**A1:** 25.006

**A2:** 25.008

**B1:** 25.005

**B2:** 25.009

**Totals:**

#### Average range, operator A

**Key:** ra

**Agg:** avg

**Format:** decimal

#### Average range, operator B

**Key:** rb

**Agg:** avg

**Format:** decimal

#### Max part mean

**Key:** pm

**Agg:** max

**Format:** decimal

#### Min part mean

**Key:** pm

**Agg:** min

**Format:** decimal

**Summary:**

#### Overall average range (Rbar)

**Key:** rbar

**Expr:** (avg_ra + avg_rb) / 2

**Format:** decimal

#### Repeatability, equipment variation (Rbar x 0.8862)

**Key:** ev

**Expr:** rbar * 0.8862

**Format:** decimal

**Description:** K1 constant for 2 trials.

#### Part mean spread (Rp)

**Key:** rp

**Expr:** max_pm - min_pm

**Format:** decimal

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to run the study

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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.

**Cta:** If you want MSA results recorded against gauges and inspection plans in your ERP, Netray can help set that up.

**Faq:**

#### Why use two operators and two trials?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

gage r&r excel template, gage r and r data sheet, MSA data collection sheet, gauge repeatability worksheet, measurement system analysis template, gage R&R form, average and range method, MSA excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json