Bloomfield Tool Co.
Gauge Repeatability and Reproducibility
This spreadsheet is designed for up to three operators, three trials, and ten parts. Enter data ONLY in yellow shaded cells.
Number of operators 2Upper specification limit 0.10 Average range 0.0072
Number of trials 2Lower specification limit 0.05 Range of operator averages 0.0018
Number of parts 10 Range of part averages 0.0478
Data
Part
Part # 1 2 3 Average Range 1 2 3 Average Range 1 2 3 Average Range Average Sample Operator 1 Operator 2
10.065 0.060 0.0625 0.0050 0.065 0.055 0.0600 0.0100 0.0613 10.0650 0.0600 0.0650 0.0550
20.100 0.105 0.1025 0.0050 0.105 0.095 0.1000 0.0100 0.1013 20.1000 0.1050 0.1050 0.0950
% of Total Variation % of Tolerance
Repeatability (Equipment Variation) – EV 0.0326 EV 38.84% EV 65.21% EV 15.09% Note: Formulas had to be removed from the template for Operator 3
Reproducibility (Appraiser Variation) – AV 0.0000 AV 0.00% AV 0.00% AV 0.00%
Repeatability and Reproducibility – R&R 0.0326 R&R 38.84% R&R 65.21% R&R 15.09%
Part Variation – PV 0.0774 PV 92.15% PV 154.71% PV 84.91%
Total Variation – TV 0.0839
Upper control limit for individual ranges 0.0234
Do not modify these tables
Trials/Operators D4 K1 K2
2 3.27 4.56 3.65
3 2.58 3.05 2.70
Parts K3
2 3.65
5 2.08
6 1.93
7 1.82
8 1.74
9 1.67
Variance Ratios
Trial
Trial
Trial
Operator 1
Operator 2
30.085 0.095 0.0900 0.0100 0.082 0.094 0.0880 0.0120 0.0890 30.0850 0.0950 0.0820 0.0940
40.055 0.058 0.0565 0.0030 0.049 0.053 0.0505 0.0040 0.0535 40.0550 0.0580 0.0485 0.0525
50.092 0.088 0.0900 0.0040 0.099 0.090 0.0945 0.0090 0.0923 50.0920 0.0880 0.0990 0.0900
60.085 0.080 0.0825 0.0050 0.075 0.070 0.0725 0.0050 0.0775 60.0850 0.0800 0.0750 0.0700
70.060 0.070 0.0650 0.0100 0.055 0.064 0.0595 0.0090 0.0623 70.0600 0.0700 0.0550 0.0640
80.068 0.075 0.0715 0.0070 0.067 0.072 0.0695 0.0050 0.0705 80.0680 0.0750 0.0670 0.0720
90.080 0.091 0.0855 0.0110 0.087 0.082 0.0845 0.0050 0.0850 90.0800 0.0910 0.0870 0.0820