Frankford Brake Systems
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.
NOTE: 0’s were filled into the template for the third operator and formulas for the part averages were modified.
Number of operators
2Upper specification limit 1.06 Average range 0.033
Data
Operator 1
Operator 2 Operator 3
Trial Trial Trial Part <—- Formula adjusted to account for only two operators
Part # 1 2 3
Average
Range 1 2 3 Average
Range
1 2 3
Average
Range Average
10.970 0.990 0.990 0.983 0.020 0.960 0.990 1.000 0.983 0.040 0.000 0.000 0.000 0.000 0.000 0.983
20.940 0.960 0.970 0.957 0.030 0.950 1.000 1.000 0.983 0.050 0.000 0.000 0.000 0.000 0.000 0.970
31.000 1.000 0.990 0.997 0.010 1.020 1.030 1.000 1.017 0.030 0.000 0.000 0.000 0.000 0.000 1.007
% of Total Variation
% of Tolerance
Repeatability (Equipment Variation) – EV 0.101 EV 73.60% EV 83.88% EV 54.17%
Reproducibility (Appraiser Variation) – AV 0.012 AV 8.71% AV 9.93% AV 0.76%
Repeatability and Reproducibility – R&R 0.101 R&R 74.12% R&R 84.46% R&R 54.93%
Do not modify these tables
Trials/Operators D4 K1 K2
23.27 4.56 3.65
Parts K3
23.65
32.7
42.3
10 1.62