2 Sigma Template.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	R	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1			Date:					Quality:						GSM:			Profile's 2-σ Values		Overall 2-σ Value					1.281547149				Average GSM			40.5
2																												Minimum GSM			39.0
3		Roll	Left Side												Right Side				Sample GSM compared to profile average									Maximum GSM			42.2
4		No.	1	2	3	4	5	6	7	8	9	10	11	12	13	14			1	2	3	4	5	6	7	8	9	10	11	12	13	14
5		1	41.8	40.0	40.0	40.8	40.4	40.8	41.0	41.8	41.6	41.6	41.4	41.0	40.8	40.4	1.21	1	0.8	-1.0	-1.0	-0.2	-0.6	-0.2	0.0	0.8	0.6	0.6	0.4	0.0	-0.2	-0.6
6		2	40.6	39.8	39.0	39.0	39.6	39.4	40.0	40.4	40.8	39.8	40.2	39.8	40.8	40.2	1.15	2	0.6	-0.2	-1.0	-1.0	-0.4	-0.6	0.0	0.4	0.8	-0.2	0.2	-0.2	0.8	0.2
7		3	40.6	39.8	39.4	39.8	39.8	40.0	40.2	40.6	40.6	40.8	40.6	40.0	40.8	40.8	0.92	3	0.3	-0.5	-0.9	-0.5	-0.5	-0.3	-0.1	0.3	0.3	0.5	0.3	-0.3	0.5	0.5
8		4	40.0	40.0	39.4	39.4	39.2	39.6	40.0	40.6	40.6	40.0	39.8	39.0	40.0	40.0	0.92	4	0.2	0.2	-0.4	-0.4	-0.6	-0.2	0.2	0.8	0.8	0.2	0.0	-0.8	0.2	0.2
9		5	40.2	40.4	39.4	39.6	39.6	40.2	40.2	40.0	40.0	40.4	40.6	39.6	40.0	39.8	0.70	5	0.2	0.4	-0.6	-0.4	-0.4	0.2	0.2	0.0	0.0	0.4	0.6	-0.4	0.0	-0.2
10		6	41.0	40.4	39.6	39.6	40.0	40.6	40.4	40.4	40.4	40.0	40.6	39.4	40.0	40.0	0.88	6	0.8	0.2	-0.6	-0.6	-0.2	0.4	0.2	0.2	0.2	-0.2	0.4	-0.8	-0.2	-0.2
11		7	40.8	40.6	40.8	40.6	40.4	41.0	40.4	40.4	40.8	40.4	41.0	40.0	40.4	40.6	0.54	7	0.2	0.0	0.2	0.0	-0.2	0.4	-0.2	-0.2	0.2	-0.2	0.4	-0.6	-0.2	0.0
12		8	40.0	40.8	40.0	40.0	39.6	40.2	40.2	40.2	40.6	40.2	41.2	39.8	40.0	40.0	0.81	8	-0.2	0.6	-0.2	-0.2	-0.6	0.0	0.0	0.0	0.4	0.0	1.0	-0.4	-0.2	-0.2
13		9	40.8	41.0	40.2	39.8	40.8	41.0	41.0	41.2	40.6	40.8	41.0	39.8	40.4	41.2	0.92	9	0.1	0.3	-0.5	-0.9	0.1	0.3	0.3	0.5	-0.1	0.1	0.3	-0.9	-0.3	0.5
14		10	41.6	41.8	41.2	41.0	41.4	41.8	42.0	42.0	42.2	42.0	41.8	41.2	41.8	41.6	0.70	10	-0.1	0.1	-0.5	-0.7	-0.3	0.1	0.3	0.3	0.5	0.3	0.1	-0.5	0.1	-0.1
15		11	40.8	41.0	40.6	40.4	40.0	41.0	40.6	41.2	41.2	40.8	41.2	40.2	40.6	39.8	0.88	11	0.1	0.3	-0.1	-0.3	-0.7	0.3	-0.1	0.5	0.5	0.1	0.5	-0.5	-0.1	-0.9
16		12	40.0	40.8	40.6	39.8	40.0	41.0	41.2	41.0	40.6	40.8	40.8	40.2	40.4	40.0	0.88	12	-0.5	0.3	0.1	-0.7	-0.5	0.5	0.7	0.5	0.1	0.3	0.3	-0.3	-0.1	-0.5
17		13	40.8	41.2	41.6	40.6	40.4	41.6	41.4	41.2	41.0	40.8	41.0	40.2	40.4	40.0	0.99	13	-0.1	0.3	0.7	-0.3	-0.5	0.7	0.5	0.3	0.1	-0.1	0.1	-0.7	-0.5	-0.9
18		14	40.4	41.0	40.6	40.0	40.4	40.8	41.0	40.6	40.4	40.6	39.8	40.0	40.0	40.2	0.74	14	0.0	0.6	0.2	-0.4	0.0	0.4	0.6	0.2	0.0	0.2	-0.6	-0.4	-0.4	-0.2
19		15	41.0	40.8	40.0	39.6	39.6	40.2	40.8	40.0	40.6	40.2	40.2	39.8	40.0	39.6	0.92	15	0.8	0.6	-0.2	-0.6	-0.6	0.0	0.6	-0.2	0.4	0.0	0.0	-0.4	-0.2	-0.6
20		16	41.8	40.0	40.0	40.8	40.4	40.8	41.0	41.8	41.6	41.6	41.4	41.0	40.8	40.4	1.21	16	0.8	-1.0	-1.0	-0.2	-0.6	-0.2	0.0	0.8	0.6	0.6	0.4	0.0	-0.2	-0.6
21		17	40.6	39.8	39.0	40.2	39.6	39.4	40.0	40.4	40.8	39.8	40.2	39.8	40.8	40.2	1.02	17	0.6	-0.2	-1.0	0.2	-0.4	-0.6	0.0	0.4	0.8	-0.2	0.2	-0.2	0.8	0.2
22		18	40.6	39.8	39.4	39.8	39.8	40.0	40.2	40.6	40.6	40.8	40.6	40.0	40.8	40.8	0.92	18	0.3	-0.5	-0.9	-0.5	-0.5	-0.3	-0.1	0.3	0.3	0.5	0.3	-0.3	0.5	0.5
23		19	40.0	40.0	39.4	39.4	39.2	39.6	40.0	40.6	40.6	40.0	39.8	39.0	40.0	40.0	0.92	19	0.2	0.2	-0.4	-0.4	-0.6	-0.2	0.2	0.8	0.8	0.2	0.0	-0.8	0.2	0.2
24		20	40.2	40.4	39.4	39.6	39.6	40.2	40.2	40.0	40.0	40.4	40.6	39.6	40.0	39.8	0.70	20	0.2	0.4	-0.6	-0.4	-0.4	0.2	0.2	0.0	0.0	0.4	0.6	-0.4	0.0	-0.2
25		21	41.0	40.4	39.6	39.6	40.0	40.6	40.4	40.4	40.4	40.0	40.6	39.4	40.0	40.0	0.88	21	0.8	0.2	-0.6	-0.6	-0.2	0.4	0.2	0.2	0.2	-0.2	0.4	-0.8	-0.2	-0.2
26		22	40.8	40.6	40.8	40.6	40.4	41.0	40.4	40.4	40.8	40.4	41.0	40.0	40.4	40.6	0.54	22	0.2	0.0	0.2	0.0	-0.2	0.4	-0.2	-0.2	0.2	-0.2	0.4	-0.6	-0.2	0.0
27		23	40.0	40.8	40.0	40.0	39.6	40.2	40.2	40.2	40.6	40.2	41.2	39.8	40.0	40.0	0.81	23	-0.2	0.6	-0.2	-0.2	-0.6	0.0	0.0	0.0	0.4	0.0	1.0	-0.4	-0.2	-0.2
28		24	40.8	41.0	40.2	39.8	40.8	41.0	41.0	41.2	40.6	40.8	41.0	39.8	40.4	41.2	0.92	24	0.1	0.3	-0.5	-0.9	0.1	0.3	0.3	0.5	-0.1	0.1	0.3	-0.9	-0.3	0.5
29		25	41.6	41.8	41.2	41.0	41.4	41.8	42.0	42.0	42.2	42.0	41.8	41.2	41.8	41.6	0.70	25	-0.1	0.1	-0.5	-0.7	-0.3	0.1	0.3	0.3	0.5	0.3	0.1	-0.5	0.1	-0.1
30
31
32	Average		40.7	40.6	40.1	40.0	40.1	40.6	40.6	40.8	40.8	40.6	40.8	40.0	40.5	40.4		Avg	0.3	0.1	-0.4	-0.4	-0.4	0.1	0.2	0.3	0.4	0.2	0.3	-0.5	0.0	-0.1
33																		2-σ	0.74	0.85	0.88	0.57	0.45	0.67	0.48	0.61	0.56	0.53	0.64	0.52	0.67	0.80
34
35			Note:
36			Random data has been filled, considering 14 samples are taken from one CD profile.
37			Before filing, please delete c5..p29 cells. Colour code will automatically appear when you enter data.
38			Do not detele values in columns R onwards.
39			In Column B, number indicates the roll number.
40			High 2 Sigma values in row 33 indicate you need to look into headbox, approach flow etc. first.
41			If your 2-Sigma values are good, don't give all credit to machines, praise your papermakers too!
42
43
44
45			Developed by:
46			D K Singhal
47			www.dksinghal.in
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
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