IC-Gage-R-and-R-Template-for-Measurement-Phase-of-DMAIC_Google-Sheets

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1

2	Gage R&R Template for Measurement Phase of DMAIC													https://www.smartsheet.com/try-it?trp=12109&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Gage+R&R+Template+for+Measurement+Phase+of+DMAIC-google-sheet-12109&lpa=Gage+R&R+Template+for+Measurement+Phase+of+DMAIC+google-sheet+12109
3	User to complete non-shaded cells below, only. R&R Index calculations will populate automatically.
4
5	R&R index Based on Observed Variation										R&R index Based on Tolerance
6	82.2%										22.7%
7	sm / st										GR&R / RT
8
9	Number of Trials per Part				3	r		Ro = max ( X ) - min ( X )				0.07									30%+
10	Number of Parts				12	n		R				0.37									11–30%
11	Number of Operators				3	k															<= 10%
12
13	Repeatability (Equipment Variation)							0.22	se = R / d2
14	Reproducibility (Operator Variation)							0.01	so = ( max ( 0 ; ( Ro / d2 ) 2 – Repeatability2 / n*r ) ) 0,5
15	Total Gage R&R (Measurement Variation)							0.22	sm = ( se2 + so2 ) 0,5
16	Part to Part Variation							0.2	sp = ( max X - min X ) / d2
17	Calculated Process Standard Deviation							0.3	st = ( sp2 + sm2 ) 0,5
18
19	m	g	d2		Gage R&R 99%-Value (5,15 x Sigma)							1.1	GR&R = 5,15 x sm
20	3	36	1.69		Lower Tolerance Limit							50.0	Mintolerance
21	3	1	1.91		Higher Tolerance Limit							55.0	Maxtolerance
22	12	1	3.35		Tolerance Range							5.0	RT= Maxtolerance – Mintolerance
23					Calculated Total Variation compare to Tolerance Range							1.4	TV = 5,15 x st
24
25	1	Operator 1						2	Operator 2						3	Operator 3
26		Trial 1	Trial 2	Trial 3	R	X			Trial 1	Trial 2	Trial 3	R	X			Trial 1	Trial 2	Trial 3	R	X		X
27	1	57.1	57.5	57.8	0.7	57.5		1	57.1	57.1	57.7	0.6	57.3		1	57.1	57.1	57.1	0.0	57.1		57.3
28	2	57.2	57.5	57.1	0.4	57.3		2	57.6	57.4	57.8	0.4	57.6		2	57.6	57.5	57.3	0.3	57.5		57.4
29	3	57.3	57.3	57.1	0.2	57.2		3	57.6	57.7	57.2	0.5	57.5		3	57.1	57.1	57.1	0.0	57.1		57.3
30	4	57.1	57.1	57.1	0.0	57.1		4	58.0	58.1	57.5	0.6	57.9		4	57.2	57.5	57.7	0.5	57.5		57.5
31	5	57.3	57.5	57.6	0.3	57.5		5	58.0	58.0	58.1	0.1	58.0		5	57.7	57.6	57.2	0.5	57.5		57.7
32	6	57.1	57.1	57.1	0.0	57.1		6	57.5	57.8	57.1	0.7	57.5		6	58.1	58.0	57.5	0.6	57.9		57.5
33	7	57.7	57.5	57.2	0.5	57.5		7	57.5	57.1	57.2	0.4	57.3		7	58.0	58.0	58.1	0.1	58.0		57.6
34	8	57.7	57.1	57.1	0.6	57.3		8	57.3	57.1	57.3	0.2	57.2		8	57.8	57.5	57.1	0.7	57.5		57.3
35	9	57.8	57.6	57.4	0.4	57.6		9	57.1	57.1	57.1	0.0	57.1		9	57.1	57.1	57.7	0.6	57.3		57.3
36	10	57.2	57.6	57.7	0.5	57.5		10	57.5	57.6	57.3	0.3	57.5		10	57.4	57.6	57.8	0.4	57.6		57.5
37	11	57.5	58.0	58.1	0.6	57.9		11	57.1	57.1	57.1	0.0	57.1		11	57.6	57.7	57.2	0.5	57.5		57.5
38	12	58.1	58.0	58.0	0.1	58.0		12	57.5	57.2	57.7	0.5	57.5		12	58.0	58.1	57.5	0.6	57.9		57.8
39	13							13							13
40	14							14							14
41	15							15							15
42
43	1	Trial 1	Trial 2	Trial 3	R	X		2	Trial 1	Trial 2	Trial 3	R	X		3	Trial 1	Trial 2	Trial 3	R	X	Min X	57.3
44	Mean	57.4	57.5	57.4	0.36	57.45		Mean	57.5	57.4	57.4	0.36	57.45		Mean	57.6	57.6	57.4	0.40	57.52	Max X	57.8
45
46
47			For Repeatability					For Reproducibility					For Part-to-Part
48			m	number of trials				m	# of operators				m	# of parts
49			g	number of parts x number of operators				g	is always 1				g	is always 1
50
51			m
52			2	3	4	5	6	7	8	9	10	11	12	13	14	15
53	g	1	1.41	1.91	2.24	2.48	2.67	2.83	2.96	3.08	3.18	3.27	3.35	3.42	3.49	3.55
54		2	1.28	1.81	2.15	2.40	2.60	2.77	2.91	3.02	3.13	3.22	3.30	3.38	3.45	3.51
55		3	1.23	1.77	2.12	2.38	2.58	2.75	2.89	3.01	3.11	3.21	3.29	3.37	3.43	3.50
56		4	1.21	1.75	2.11	2.37	2.57	2.74	2.88	3.00	3.10	3.20	3.28	3.36	3.43	3.49
57		5	1.19	1.74	2.10	2.36	2.56	2.73	2.87	2.99	3.10	3.19	3.28	3.35	3.42	3.49
58		6	1.18	1.73	2.09	2.35	2.56	2.73	2.87	2.99	3.10	3.19	3.27	3.35	3.42	3.49
59		7	1.17	1.73	2.09	2.35	2.55	2.72	2.87	2.99	3.10	3.19	3.27	3.35	3.42	3.48
60		8	1.17	1.72	2.08	2.35	2.55	2.72	2.87	2.98	3.09	3.19	3.27	3.35	3.42	3.48
61		9	1.16	1.72	2.08	2.34	2.55	2.72	2.86	2.98	3.09	3.18	3.27	3.35	3.42	3.48
62		10	1.16	1.72	2.08	2.34	2.55	2.72	2.86	2.98	3.09	3.18	3.27	3.34	3.42	3.48
63		11	1.16	1.71	2.08	2.34	2.55	2.72	2.86	2.98	3.09	3.18	3.27	3.34	3.41	3.48
64		12	1.15	1.71	2.07	2.34	2.55	2.72	2.85	2.98	3.09	3.18	3.27	3.34	3.41	3.48
65		13	1.15	1.71	2.07	2.34	2.55	2.71	2.85	2.98	3.09	3.18	3.27	3.34	3.41	3.48
66		14	1.15	1.71	2.07	2.34	2.54	2.71	2.85	2.98	3.08	3.18	3.27	3.34	3.41	3.48
67		15	1.15	1.71	2.07	2.34	2.54	2.71	2.85	2.98	3.08	3.18	3.26	3.34	3.41	3.48
68		>15	1.128	1.693	2.059	2.326	2.534	2.704	2.847	2.970	3.078	3.173	3.258	3.336	3.407
69
70	CLICK HERE TO CREATE IN SMARTSHEET
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100