Spreadsheet: 176176d1345747594-index-and-offset-no-idea-resultstoolforteamanddepartment
Sheet: Pivot

Sum of % Team Score | Team
Question Number | A | B | W | EA | LH | MG | WV
1 | 0 | 0 | 1 | 0 | 1 | 0.75 | 0.5833333333333334
2 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1
3 | 1 | 1 | 1 | 1 | 1 | 0.6666666666666666 | 0.6666666666666666
4 | 1 | 1 | 1 | 1 | 1 | 1 | 1
5 | 1 | 1 | 1 | 1 | 1 | 0.8846153846153846 | 0.9166666666666666
6 | 1 | 0 | 0 | 0 | 1 | 1 | 1
7 | 1 | 1 | 1 | 1 | 0 | 0 | 0
8 | 1 | 1 | 1 | 1 | 1 | 1 | 1
9 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 1 | 1 | 1 | 1 | 1 | 0 | 0
11 | 1 | 0 | 1 | 0 | 1 | 1 | 1
12 | 0 | 0 | 0 | 0 | 1 | 1 | 1
13 | 0 | 0 | 0 | 0 | 1 | 0 | 0
14 | 0 | 0 | 1 | 0 | 1 | 1 | 1
15 | 1 | 1 | 1 | 1 | 1 | 1 | 1
16 | 1 | 1 | 1 | 1 | 1 | 1 | 1
17 | 1 | 1 | 1 | 1 | 1 | 1 | 1
18 | 0 | 1 | 1 | 0 | 1 | 1 | 0
19 | 1 | 1 | 1 | 1 | 1 | 0 | 1
20 | 1 | 1 | 1 | 1 | 1 | 1 | 1
21 | 0 | 1 | 1 | 1 | 1 | 0 | 0
22 | 1 | 1 | 1 | 1 | 0 | 1 | 1
23 | 0 | 1 | 1 | 1 | 1 | 1 | 1
24 | 1 | 1 | 1 | 1 | 0 | 1 | 1
25 | 1 | 1 | 1 | 1 | 1 | 1 | 0
26 | 1 | 1 | 1 | 1 | 1 | 0 | 1
27 | 1 | 1 | 1 | 1 | 1 | 1 | 1
28 | 0 | 1 | 1 | 1 | 1 | 0 | 0
29 | 1 | 1 | 1 | 1 | 1 | 1 | 1
30 | 1 | 0 | 1 | 1 | 1 | 1 | 1
31 | 1 | 1 | 1 | 1 | 1 | 1 | 1
32 | 1 | 1 | 1 | 1 | 1 | 1 | 1
33 | 1 | 1 | 1 | 1 | 1 | 1 | 1
34 | 1 | 1 | 1 | 1 | 1 | 0.8 | 1
35 | 1 | 1 | 1 | 1 | 1 | 1 | 1
36 | 0.2 | 0 | 1 | 0 | 0 | 0 | 0.2
37 | 0 | 1 | 0 | 1 | 1 | 0 | 0
38 | 0 | 0.6 | 0 | 0.2 | 0 | 0.2 | 0
39 | 1 | 1 | 1 | 1 | 1 | 1 | 1
40 | 1 | 1 | 1 | 1 | 1 | 1 | 1
41 | 0.8 | 0.2 | 1 | 0 | 0.2 | 1 | 0.2
42 | 1 | 1 | 1 | 1 | 1 | 1 | 1
43 | 1 | 0 | 1 | 0 | 0.8 | 1 | 1
44 | 1 | 1 | 1 | 1 | 1 | 1 | 1
45 | 0.6 | 0 | 1 | 0 | 1 | 1 | 0
46 | 0 | 1 | 0 | 0.8 | 0 | 0 | 0
47 | 0.2 | 0 | 1 | 0 | 0.6 | 0 | 0
48 | 0 | 1 | 0 | 0.8 | 0 | 0 | 0
49 | 0 | 0.4 | 0 | 0.4 | 0 | 0 | 0
50 | 0 | 0 | 0 | 0.4 | 0 | 0 | 0
51 | 1 | 1 | 1 | 1 | 1 | 1 | 1
52 | 1 | 1 | 1 | 1 | 1 | 1 | 1
53 | 0 | 1 | 1 | 1 | 1 | 0 | 0
54 | 0 | 0 | 1 | 0 | 0 | 0 | 0
55 | 0 | 1 | 1 | 1 | 1 | 0 | 0
56 | 0 | 0 | 1 | 0 | 0 | 0 | 0
57 | 0 | 0 | 0 | 0 | 1 | 0 | 0
58 | 0 | 0 | 0 | 0 | 1 | 0 | 0
59 | 0 | 1 | 0 | 1 | 0 | 0 | 0
60 | 1 | 1 | 0 | 1 | 1 | 1 | 0
61 | 1 | 0 | 0 | 0 | 1 | 0 | 0
62 | 1 | 0 | 0 | 0 | 1 | 0 | 0
63 | 1 | 0 | 0 | 0 | 1 | 0 | 0
64 | 1 | 0 | 0 | 1 | 0 | 0 | 0
65 | 0 | 0 | 0 | 0 | 0 | 0 | 0
66 | 1 | 1 | 1 | 1 | 1 | 1 | 1
67 | 1 | 0 | 1 | 0 | 0 | 1 | 0
68 | 1 | 0 | 1 | 0 | 0 | 1 | 0
69 | 0 | 0 | 0 | 0 | 0 | 0 | 0
70 | 0 | 0 | 0 | 0 | 1 | 0 | 0
71 | 1 | 0 | 0 | 0 | 1 | 1 | 0.6666666666666666
72 | 1 | 0 | 0 | 1 | 0 | 1 | 0
73 | 1 | 0 | 1 | 0 | 1 | 0.8 | 1
74 | 1 | 0 | 0 | 0 | 1 | 1 | 0.8
75 | 1 | 0 | 0 | 0 | 1 | 0.8333333333333334 | 1
76 | 1 | 0 | 0 | 0 | 1 | 1 | 1
77 | 1 | 0 | 0 | 0 | 1 | 1 | 1
78 | 1 | 0 | 0 | 0 | 1 | 1 | 1
79 | 1 | 0 | 1 | 1 | 1 | 1 | 1
80 | 1 | 0 | 1 | 1 | 1 | 0.8 | 0.8
81 | 1 | 0 | 1 | 0 | 1 | 0.4 | 1
82 | 0 | 0 | 1 | 1 | 1 | 1 | 1
83 | 0 | 1 | 0 | 0.8 | 0 | 0 | 0
84 | 1 | 0 | 1 | 0 | 1 | 0 | 0
85 | 0 | 0 | 0 | 0 | 0 | 0 | 0
86 | 1 | 1 | 1 | 1 | 1 | 1 | 0
87 | 1 | 1 | 0 | 1 | 1 | 0 | 1
88 | 1 | 1 | 1 | 1 | 1 | 1 | 1
89 | 0 | 1 | 1 | 1 | 1 | 0 | 1
90 | 1 | 1 | 1 | 1 | 1 | 1 | 1
91 | 1 | 1 | 1 | 0.4444444444444444 | 1 | 1 | 1
92 | 1 | 1 | 1 | 1 | 1 | 1 | 1
93 | 1 | 1 | 1 | 1 | 1 | 1 | 1
94 | 1 | 1 | 1 | 1 | 1 | 1 | 0
95 | 1 | 1 | 1 | 1 | 1 | 1 | 1
96 | 1 | 1 | 1 | 1 | 1 | 1 | 1
97 | 1 | 1 | 1 | 0.4444444444444444 | 1 | 1 | 1
98 | 1 | 1 | 1 | 0 | 1 | 1 | 1
99 | 0.5 | 1 | 0.5 | 1 | 1 | 0.6 | 1
100 | 1 | 1 | 1 | 0.2222222222222222 | 1 | 1 | 0.5
101 | 0.5 | 1 | 1 | 0.3333333333333333 | 1 | 1 | 1
102 | 1 | 1 | 1 | 1 | 1 | 1 | 1
103 | 1 | 1 | 1 | 1 | 1 | 1 | 1
104 | 1 | 1 | 1 | 1 | 1 | 1 | 1
105 | 1 | 1 | 1 | 1 | 1 | 1 | 1
106 | 0.5 | 1 | 1 | 1 | 1 | 1 | 0
107 | 1 | 0 | 1 | 0 | 1 | 0 | 0
108 | 1 | 0 | 1 | 0 | 1 | 0 | 1
109 | 1 | 0 | 1 | 0 | 1 | 0 | 1
110 | 1 | 0 | 1 | 0 | 1 | 0 | 1
111 | 1 | 0 | 1 | 0 | 1 | 0 | 1
112 | 0 | 0 | 1 | 0 | 1 | 0 | 0
113 | 0 | 0 | 1 | 0 | 1 | 0 | 0
114 | 1 | 0 | 1 | 0 | 1 | 0 | 0
Grand Total | 80.30000000000001 | 65.19999999999999 | 83.5 | 65.84444444444443 | 92.6 | 69.23461538461538 | 67.33333333333331