Spreadsheet: 88055d1287964207-summing-groups-of-averages-selectively-sorted-data-project-measurements
Sheet: Sheet1

1 | 56.2 | 40 | 62 | 11.33 | 11.72
2 | 55.9 | 39 | 63 | 10.98 | 11.15
3 | X | X | X | X | X |  | 4, 8, 9, 11, 12, 17 | 1, 6, 7, 19, 20 | 2, 3, 15, 16, 21 | 5, 10, 13, 14, 18
4 | 56.8 | 60 | 80 | 10.36 | 10.51
5 | 54.4 | 29 | 51 | 8.6 | 8.76 | 4
6 | 55.3 | 38 | 64 | 11.74 | 12.15 | 8
7 | 54.8 | 42 | 60 | 11.51 | 12.77 | 9
8 | X | X | X | X | X | 11
9 | 59.7 | 60 | 80 | 10.7 | 10.85 | 12
10 | 54.1 | 29 | 52 | 8.89 | 9.06 | 17
11 | 55.3 | 61 | 79 | 10.61 | 10.72
12 | 56.2 | 61 | 80 | 10.56 | 10.59 |  |  |  |  |  | H14:102
13 | 55.5 | 30 | 52 | 8.7 | 8.99
14 | 55.1 | 28 | 51 | 8.61 | 8.72 |  | 1 | 40 |  |  |  |  | Devices | 4, 8, 9, 11, 12, 17 | 1, 6, 7, 19, 20 | 2, 3, 15, 16, 21 | 5, 10, 13, 14, 18
15 | 57.1 | 39 | 61 | 11.63 | 11.59 |  | 1 | 41 |  |  |  |  | window | 8 mm | 6 mm | 4 mm | 2 mm
16 | 56.3 | 37 | 60 | 11.54 | 11.56 |  | 1 | 40 |  |  |  |  | w ([NAME]) | 60 | 40 | 40 | 30
17 | 56.9 | 60 | 79 | 10.56 | 10.6 |  | 1 | X |  |  |  |  | [NAME]) | 80 | 60 | 60 | 50
18 | 56.6 | 29 | 52 | 8.74 | 9.1 |  | 1 | 38 |  |  |  |  | b (mm) | 7500 | 5500 | 3500 | 1500
19 | 56.9 | 40 | 60 | 11.6 | 11.58 |  | 1 | 42 |  |  |  |  | n | 4 | 4 | 6 | 8
20 | 59.6 | 39 | 60 | 12.03 | 11.74 |  | 1 | 35 |  |  |  |  | Le
21 | 56.5 | 40 | 60 | 11.39 | 11.16 |  | 1 | 40
1 | 53.9 | 41 | 63 | 11.63 | 11.66 |  | 1 | 42
2 | 55.5 | 41 | 60 | 11.29 | 11.35 |  | 2 | 39
3 | 58.1 | 43 | 61 | 11.08 | 11.12 |  | 2 | 41 |  |  |  |  |  | Devices | 4, 8, 9, 11, 12, 17 | 1, 6, 7, 19, 20 | 2, 3, 15, 16, 21 | 5, 10, 13, 14, 18
4 | 56.7 | 61 | 80 | 10.42 | 10.49 |  | 2 | X |  |  |  |  |  | window | 8 mm | 6 mm | 4 mm | 2 mm
5 | 56.8 | 31 | 51 | 8.94 | 8.91 |  | 2 | 40 |  |  |  |  |  | n | 4 | 4 | 6 | 8
6 | 53.7 | 38 | 65 | 12.13 | 12.38 |  | 2 | 40 |  |  |  |  |  | w ([NAME])
7 | 53 | 41 | 55 | 11.85 | 11.88 |  | 2 | 43 |  |  |  |  |  | ∂w (mm)
8 | 59 | 59 | 81 | 10.31 | 10.34 |  | 2 | 39 |  |  |  |  |  | [NAME])
9 | 55.8 | 61 | 82 | 10.56 | 10.68 |  | 2 | 40 |  |  |  |  |  | ∂g (mm)
10 | 55.9 | 29 | 53 | 9.085 | 9.22 |  | 2 | 40 |  |  |  |  |  | b (mm) | 7500 | 5500 | 3500 | 1500
11 | 55.4 | 61 | 81 | 10.87 | 10.88 |  | 3 | X |  |  |  |  |  | ∂b ([NAME])
12 | 54.4 | 62 | 82 | 10.81 | 10.736 |  | 3 | 43 |  |  |  |  |  | t (nm)
13 | 52.7 | 30 | 53 | 8.86 | 8.97 |  | 3 | 41 |  |  |  |  |  | ∂t (nm)
14 | 51.4 | 30 | 53 | 8.76 | 9.08 |  | 3 | 43 |  |  |  |  |  | Le (th)
15 | 54 | 38 | 63 | 11.86 | 11.71 |  | 3 | 40 |  |  |  |  |  | Le (exp)
16 | 56.4 | 41 | 62 | 11.87 | 11.75 |  | 3 | 48 |  |  |  |  |  | [NAME] (exp)
17 | 54.4 | 62 | 82 | 10.67 | 10.6 |  | 3 | 35
18 | 55.1 | 29 | 52 | 8.8 | 8.67 |  | 3 | 41
19 | X | X | X | X | X |  | 3 | 39
20 | 60.2 | 41 | 63 | 12.06 | 11.82 |  | 4 | 60
21 | 56.7 | 42 | 60 | 11.23 | 11.08 |  | 4 | 61
1 | 55.7 | 40 | 61 | 11.77 | 11.87 |  | 4 | 59
2 | X | X | X | X | X |  | 4 | 62
3 | 55.2 | 41 | 62 | 11.25 | 11.4 |  | 4 | X
4 | 55.8 | 59 | 83 | 10.49 | 1.72 |  | 4 | 61
5 | 55.7 | 32 | 50 | 8.86 | 9 |  | 4 | 52
6 | X | X | X | X | X |  | 4 | X
7 | 54.5 | 41 | 60 | 11.91 | 12.03 |  | 4 | X
8 | 56.9 | 60 | 83 | 11.05 | 10.71 |  | 5 | 29
9 | 54.6 | 61 | 80 | 10.78 | 10.86 |  | 5 | 31
10 | 54.8 | 32 | 50 | 9.38 | 9.67 |  | 5 | 32
11 | 54 | 60 | 80 | 11.12 | 11.21 |  | 5 | 34
12 | 55.6 | 60 | 83 | 10.8 | 10.9 |  | 5 | X
13 | 53.6 | 31 | 50 | 9.02 | 9.54 |  | 5 | 33
14 | 56.7 | 31 | 50 | 8.9 | 9.07 |  | 5 | 30
15 | 53.7 | 39 | 63 | 12.21 | 12.52 |  | 5 | 29
16 | 51.8 | 41 | 61 | 12.13 | 12.1 |  | 5 | 31
17 | X | X | X | X | X |  | 6 | 38
18 | 53.5 | 30 | 51 | 9.45 | 9.09 |  | 6 | 38
19 | 56.3 | 42 | 61 | 12.04 | 12.65 |  | 6 | X
20 | 53.5 | 41 | 62 | 12.51 | 12.46 |  | 6 | 40
21 | 55.2 | 41 | 62 | 11.4 | 12.13 |  | 6 | 39
1 | X | X | X | X | X |  | 6 | 34
2 | 54.8 | 40 | 59 | 11.3 | 11.2 |  | 6 | 38
3 | 57.1 | 43 | 61 | 12.2 | 11.1 |  | 6 | 40
4 | 54 | 62 | 80 | 10.7 | 10.5 |  | 6 | 40
5 | 55 | 34 | 48 | 9.3 | 8.7 |  | 7 | 42
6 | 54.1 | 40 | 61 | 12.3 | 12.2 |  | 7 | 41
7 | 53 | 43 | 59 | 12.1 | 11.8 |  | 7 | 41
8 | X | X | X | X | X |  | 7 | 43
9 | X | X | X | X | X |  | 7 | 40
10 | 55.3 | 31 | 50 | 9.2 | 9 |  | 7 | 45
11 | 54.6 | 63 | 80 | 11.2 | 10.8 |  | 7 | 40
12 | 54.2 | 60 | 79 | 11.6 | 10.8 |  | 7 | 40
13 | 50 | 31 | 51 | 9.1 | 8.8 |  | 7 | 40
14 | X | X | X | X | X |  | 8 | X
15 | 54.4 | 43 | 58 | 12.2 | 11.5 |  | 8 | 59
16 | 53.9 | 40 | 61 | 12.1 | 11.5 |  | 8 | 60
17 | 60.7 | 62 | 81 | 11 | 10.5 |  | 8 | X
18 | 54.6 | 30 | 50 | 9 | 8.6 |  | 8 | X
19 | X | X | X | X | X |  | 8 | 60
20 | X | X | X | X | X |  | 8 | 57
21 | X | X | X | X | X |  | 8 | 60
1 | 56.7 | 38 | 61 | 11.826 | 11.803 |  | 8 | X
2 | 62.2 | 40 | 62 | 11.6 | 11.461 |  | 9 | 60
3 | 54.6 | 40 | 61 | 11.63 | 11.45 |  | 9 | 61
4 | X | X | X | X | X |  | 9 | 61
5 | X | X | X | X | X |  | 9 | X
6 | 56.5 | 39 | 60 | 12.7 | 12.5 |  | 9 | 61
7 | 52.1 | 40 | 59 | X | X |  | 9 | 61
8 | X | X | X | 11.36 | 10.97 |  | 9 | 53
9 | 63.2 | 61 | 81 | 21.1 | 20.6 |  | 9 | 59
10 | 53.8 | 30 | 50 | 23.4 | 22.3 |  | 9 | 64
11 | X | X | X | X | X |  | 10 | 29
12 | 55 | 62 | 78 | 11.3 | 11.1 |  | 10 | 29
13 | 55.3 | 30 | 52 | 9.5 | 8.95 |  | 10 | 32
14 | 54.2 | 31 | 52 | 8.8 | 8.5 |  | 10 | 31
15 | 54.6 | 41 | 59 | 12.4 | 11.4 |  | 10 | 30
16 | 57.2 | 42 | 59 | 18.5 | 18.3 |  | 10 | 34
17 | 56.1 | 61 | 79 | 10.9 | 10.8 |  | 10 | 27
18 | X | X | X | X | X |  | 10 | 29
19 | 59.6 | 44 | 58 | 14.3 | 14.2 |  | 10 | 32
20 | 54.2 | 41 | 61 | 11.9 | 11.5 |  | 11 | 61
21 | 58.1 | 39 | 61 | 11.4 | 10.9 |  | 11 | 61
1 | 56 | 42 | 61 | 12.02 | 12.7 |  | 11 | 60
2 | 55.4 | 43 | 61 | 12.1 | 11.2 |  | 11 | 63
3 | 57.3 | 48 | 57 | 11.41 | 11.2 |  | 11 | X
4 | 63.2 | 61 | 79 | 10.62 | 10.47 |  | 11 | 63
5 | 52.9 | 33 | 51 | 9.314 | 9.03 |  | 11 | X
6 | 51.2 | 34 | 62 | 12.46 | 12.51 |  | 11 | 60
7 | 55.4 | 45 | 56 | 11.95 | 11.74 |  | 11 | 66
8 | 54.8 | 60 | 81 | 10.45 | 10.2 |  | 12 | 61
9 | 60.7 | 61 | 81 | 10.89 | 10.66 |  | 12 | 62
10 | 51.8 | 34 | 52 | 9.55 | 9.42 |  | 12 | 60
11 | 54.6 | 63 | 79 | 11.18 | 10.9 |  | 12 | 60
12 | 56 | 65 | 77 | 11.02 | 10.91 |  | 12 | 62
13 | 53.9 | 32 | 50 | 10.56 | 9.67 |  | 12 | 65
14 | 58 | 30 | 50 | 9.23 | 8.95 |  | 12 | 55
15 | 52.3 | 41 | 62 | 12.28 | 11.82 |  | 12 | 61
16 | 55.4 | 41 | 61 | 12.15 | 11.78 |  | 12 | 62
17 | 58.2 | 65 | 75 | 10.74 | 10.65 |  | 13 | 30
18 | 55.5 | 34 | 48 | 9.5 | 8.58 |  | 13 | 30
19 | 53.4 | 41 | 62 | 12.2 | 11.96 |  | 13 | 31
20 | 55.2 | 42 | 61 | 15 | 14.93 |  | 13 | 31
21 | X | X | X | X | X |  | 13 | 30
1 | 56.5 | 35 | 54 | 12.41 | 12.07 |  | 13 | 32
2 | 57 | 39 | 61 | 11.62 | 11.72 |  | 13 | 27
3 | 54.2 | 35 | 59 | 12.45 | 11.4 |  | 13 | 30
4 | 53.3 | 52 | 75 | 12.99 | 12.04 |  | 13 | 32
5 | 53.3 | 30 | 46 | 9.1 | 9.02 |  | 14 | 28
6 | 49.3 | 38 | 62 | 12.29 | 12.42 |  | 14 | 30
7 | 50 | 40 | 59 | 12.4 | 11.98 |  | 14 | 31
8 | 53.9 | 57 | 74 | X | X |  | 14 | X
9 | 50.1 | 53 | 75 | 11.84 | 10.87 |  | 14 | 31
10 | 50.3 | 27 | 45 | 9.76 | 9.4 |  | 14 | 30
11 | X | X | X | X | X |  | 14 | 28
12 | 52.7 | 55 | 76 | 11.1 | 10.9 |  | 14 | 28
13 | 55.1 | 27 | 53 | 9.07 | 9.11 |  | 14 | X
14 | 55.1 | 28 | 46 | 9.15 | 10.1 |  | 15 | 39
15 | 53.4 | 33 | 56 | 12.17 | 12.14 |  | 15 | 38
16 | 56.1 | 38 | 61 | 12.02 | 12.02 |  | 15 | 39
17 | 55 | 54 | 79 | 10.86 | 10.72 |  | 15 | 43
18 | 55.5 | 26 | 47 | 9.03 | 8.42 |  | 15 | 41
19 | 55.6 | 36 | 61 | 12.17 | 12.01 |  | 15 | 41
20 | 54.2 | 36 | 56 | 12.24 | 12.11 |  | 15 | 33
21 | 54.2 | 37 | 58 | 11.52 | 11.75 |  | 15 | X
1 | 54.1 | 40 | 62 | 13.64 | 11.99 |  | 15 | 41
2 | 55.4 | 40 | 62 | 11.77 | 11.62 |  | 16 | 37
3 | 56.6 | 41 | 61 | 11.93 | 11.48 |  | 16 | 41
4 | X | X | X | 10.9 | 10.82 |  | 16 | 41
5 | 53.6 | 29 | 51 | 9.1 | 9.05 |  | 16 | 40
6 | 55.5 | 40 | 62 | 12.41 | 12.66 |  | 16 | 42
7 | 53.8 | 40 | 60 | 12.13 | 12.3 |  | 16 | 41
8 | 56 | 60 | 81 | 10.66 | 10.65 |  | 16 | 38
9 | 54.6 | 59 | 82 | 11.47 | 10.87 |  | 16 | 39
10 | 54.1 | 29 | 53 | 9.36 | 9.39 |  | 16 | 40
11 | 53.2 | 60 | 80 | 11.35 | 11.2 |  | 17 | 60
12 | 58.5 | 61 | 82 | 11.39 | 11.19 |  | 17 | 62
13 | 55 | 30 | 54 | 9.3 | 9.19 |  | 17 | X
14 | 56.9 | 28 | 51 | 10.74 | 10.11 |  | 17 | 62
15 | X | X | X | X | X |  | 17 | 61
16 | 54.7 | 39 | 62 | 12.2 | 12.06 |  | 17 | 65
17 | 56.2 | 60 | 79 | 11.08 | 10.97 |  | 17 | 54
18 | 55.8 | 30 | 51 | 9.17 | 9 |  | 17 | 60
19 | 53.2 | 40 | 60 | 12.45 | 12.12 |  | 17 | 61
20 | 57.9 | 40 | 61 | 12.7 | 12.22 |  | 18 | 29
21 | 54.2 | 40 | 62 | 11.75 | 11.42 |  | 18 | 29
1 | 53 | 42 | 60 | 11.9 | 11.7 |  | 18 | 30
2 | 56 | 40 | 61 | 11.8 | 11.7 |  | 18 | 30
3 | 56 | 39 | 61 | 11.8 | 11.3 |  | 18 | X
4 | X | X | X | X | X |  | 18 | 34
5 | 52 | 31 | 49 | 9 | 8.7 |  | 18 | 26
6 | 50 | 40 | 57 | 12.7 | 12.5 |  | 18 | 30
7 | 50 | 40 | 59 | 12.2 | 12 |  | 18 | X
8 | X | X | X | X | X |  | 19 | 40
9 | 54 | 64 | 78 | 10.8 | 10.6 |  | 19 | X
10 | 47 | 32 | 48 | 9.9 | 9.2 |  | 19 | 42
11 | 49 | 66 | 77 | 11.1 | 11.9 |  | 19 | X
12 | 53 | 62 | 80 | 11 | 11 |  | 19 | 44
13 | 49 | 32 | 49 | 9.3 | 9 |  | 19 | 41
14 | X | X | X | X | X |  | 19 | 36
15 | 47 | 41 | 57 | 12.1 | 11.6 |  | 19 | 40
16 | 49 | 40 | 62 | 12.2 | 11.8 |  | 19 | 40
17 | 49 | 61 | 81 | 11.2 | 11.7 |  | 20 | 39
18 | X | X | X | X | X |  | 20 | 41
19 | 52 | 40 | 61 | 12 | 12 |  | 20 | 41
20 | 56 | 40 | 62 | 12 | 11.8 |  | 20 | X
21 | 51 | 40 | 60 | 11.2 | 11.2 |  | 20 | 41
 |  |  |  |  |  |  | 20 | 42
 |  |  |  |  |  |  | 20 | 36
 |  |  |  |  |  |  | 20 | 40
 |  |  |  |  |  |  | 20 | 40
 |  |  |  |  |  |  | 21 | 40
 |  |  |  |  |  |  | 21 | 42
 |  |  |  |  |  |  | 21 | 41
 |  |  |  |  |  |  | 21 | X
 |  |  |  |  |  |  | 21 | 39
 |  |  |  |  |  |  | 21 | X
 |  |  |  |  |  |  | 21 | 37
 |  |  |  |  |  |  | 21 | 40
 |  |  |  |  |  |  | 21 | 40