Spreadsheet: 127382d1320329062-excel-2007-using-sumproduct-and-iserror-together-capss_data_01q12
Sheet: Sheet1

 |  |  | Data
Reg_Code | E_Code | TYPE | Sum of Num of Top2 Resp | Sum of Num of Resp | Sum of % Agree Outcome Achieved
01R04 | 1192 | DISASTER | 1 | 1 | 1
 | 1192 Total |  | 1 | 1 | 1
 | 1315 | DISASTER | 1 | 1 | 1
 | 1315 Total |  | 1 | 1 | 1
01R04 Total |  |  | 2 | 2 | 1
02R04 | 2012 | DISASTER | 31 | 32 | 0.96875
 | 2012 Total |  | 31 | 32 | 0.96875
02R04 Total |  |  | 31 | 32 | 0.96875
03R04 | 3008 | DISASTER | 13 | 13 | 1
 | 3008 Total |  | 13 | 13 | 1
03R04 Total |  |  | 13 | 13 | 1
03R08 | 3060 | DISASTER | 11 | 12 | 0.9166666666666666
 | 3060 Total |  | 11 | 12 | 0.9166666666666666
03R08 Total |  |  | 11 | 12 | 0.9166666666666666
[NAME] | 5132 | DISASTER | 1 | 1 | 1
 | 5132 Total |  | 1 | 1 | 1
05R08 Total |  |  | 1 | 1 | 1
05R24 | 5348 | DISASTER | 9 | 9 | 1
 | 5348 Total |  | 9 | 9 | 1
05R24 Total |  |  | 9 | 9 | 1
05R28 | 5058 | CDE | 98 | 111 | 0.8828828828828829
 |  | DISASTER | 4 | 4 | 1
 | 5058 Total |  | 102 | 115 | 0.8869565217391304
 | 5378 | DISASTER | 5 | 7 | 0.7142857142857143
 | 5378 Total |  | 5 | 7 | 0.7142857142857143
 | 5380 | CDE | 10 | 17 | 0.5882352941176471
 |  | DISASTER | 2 | 2 | 1
 | 5380 Total |  | 12 | 19 | 0.631578947368421
 | 5503 | CDE | 474 | 591 | 0.8020304568527918
 |  | DISASTER | 64 | 69 | 0.927536231884058
 | 5503 Total |  | 538 | 660 | 0.8151515151515152
05R28 Total |  |  | 657 | 801 | 0.8202247191011236
05R36 | 5310 | DISASTER | 6 | 7 | 0.8571428571428571
 | 5310 Total |  | 6 | 7 | 0.8571428571428571
05R36 Total |  |  | 6 | 7 | 0.8571428571428571
05R40 | 5468 | CDE | 42 | 48 | 0.875
 |  | DISASTER | 1 | 1 | 1
 | 5468 Total |  | 43 | 49 | 0.8775510204081632
05R40 Total |  |  | 43 | 49 | 0.8775510204081632
07R08 | 7038 | DISASTER | 8 | 8 | 1
 | 7038 Total |  | 8 | 8 | 1
07R08 Total |  |  | 8 | 8 | 1
08R04 | 8004 | DISASTER | 1 | 1 | 1
 | 8004 Total |  | 1 | 1 | 1
08R04 Total |  |  | 1 | 1 | 1
10R08 | 10198 | CDE | 60 | 73 | 0.821917808219178
 |  | DISASTER | 10 | 10 | 1
 | 10198 Total |  | 70 | 83 | 0.8433734939759037
 | 10296 | DISASTER | 50 | 70 | 0.7142857142857143
 | 10296 Total |  | 50 | 70 | 0.7142857142857143
10R08 Total |  |  | 120 | 153 | 0.7843137254901961
10R14 | 10164 | DISASTER | 17 | 17 | 1
 | 10164 Total |  | 17 | 17 | 1
10R14 Total |  |  | 17 | 17 | 1
10R16 | 10061 | DISASTER | 1 | 1 | 1
 | 10061 Total |  | 1 | 1 | 1
10R16 Total |  |  | 1 | 1 | 1
10R28 | 10091 | DISASTER | 2 | 2 | 1
 | 10091 Total |  | 2 | 2 | 1
 | 10276 | CDE | 1 | 1 | 1
 |  | DISASTER | 1 | 1 | 1
 | 10276 Total |  | 2 | 2 | 1
10R28 Total |  |  | 4 | 4 | 1
10R32 | 10228 | DISASTER | 22 | 22 | 1
 | 10228 Total |  | 22 | 22 | 1
10R32 Total |  |  | 22 | 22 | 1
11R04 | 11189 | DISASTER | 7 | 7 | 1
 | 11189 Total |  | 7 | 7 | 1
 | 11364 | DISASTER | 12 | 13 | 0.9230769230769231
 | 11364 Total |  | 12 | 13 | 0.9230769230769231
 | 11472 | CDE | 265 | 271 | 0.977859778597786
 | 11472 Total |  | 265 | 271 | 0.977859778597786
11R04 Total |  |  | 284 | 291 | 0.9759450171821306
13R04 | 13302 | DISASTER | 79 | 89 | 0.8876404494382022
 | 13302 Total |  | 79 | 89 | 0.8876404494382022
13R04 Total |  |  | 79 | 89 | 0.8876404494382022
13R12 | 13004 | DISASTER | 3 | 3 | 1
 | 13004 Total |  | 3 | 3 | 1
 | 13054 | DISASTER | 5 | 5 | 1
 | 13054 Total |  | 5 | 5 | 1
 | 13290 | CDE | 4 | 7 | 0.5714285714285714
 |  | DISASTER | 3 | 3 | 1
 | 13290 Total |  | 7 | 10 | 0.7
13R12 Total |  |  | 15 | 18 | 0.8333333333333334
14R12 | 14084 | CDE | 13 | 22 | 0.5909090909090909
 | 14084 Total |  | 13 | 22 | 0.5909090909090909
14R12 Total |  |  | 13 | 22 | 0.5909090909090909
15R08 | 15080 | DISASTER | 7 | 8 | 0.875
 | 15080 Total |  | 7 | 8 | 0.875
 | 15436 | DISASTER | 1 | 1 | 1
 | 15436 Total |  | 1 | 1 | 1
15R08 Total |  |  | 8 | 9 | 0.8888888888888888
16R04 | 16213 | DISASTER | 20 | 25 | 0.8
 | 16213 Total |  | 20 | 25 | 0.8
16R04 Total |  |  | 20 | 25 | 0.8
16R08 | 16298 | DISASTER |  | 1 | 0
 | 16298 Total |  |  | 1 | 0
16R08 Total |  |  |  | 1 | 0
18R08 | 18206 | CDE | 304 | 344 | 0.8837209302325582
 |  | DISASTER | 30 | 38 | 0.7894736842105263
 | 18206 Total |  | 334 | 382 | 0.8743455497382199
18R08 Total |  |  | 334 | 382 | 0.8743455497382199
21R08 | 21036 | CDE | 2 | 2 | 1
 | 21036 Total |  | 2 | 2 | 1
 | 21066 | DISASTER | 8 | 8 | 1
 | 21066 Total |  | 8 | 8 | 1
 | 21254 | DISASTER | 10 | 10 | 1
 | 21254 Total |  | 10 | 10 | 1
21R08 Total |  |  | 20 | 20 | 1
22R08 | 22192 | DISASTER | 1 | 1 | 1
 | 22192 Total |  | 1 | 1 | 1
 | 22332 | DISASTER | 13 | 15 | 0.8666666666666667
 | 22332 Total |  | 13 | 15 | 0.8666666666666667
22R08 Total |  |  | 14 | 16 | 0.875
22R16 | 22124 | CDE | 4 | 15 | 0.2666666666666667
 | 22124 Total |  | 4 | 15 | 0.2666666666666667
 | 22178 | DISASTER | 7 | 7 | 1
 | 22178 Total |  | 7 | 7 | 1
 | 22252 | DISASTER | 3 | 3 | 1
 | 22252 Total |  | 3 | 3 | 1
 | 22288 | DISASTER | 7 | 7 | 1
 | 22288 Total |  | 7 | 7 | 1
22R16 Total |  |  | 21 | 32 | 0.65625
22R24 | 22168 | DISASTER | 1 | 1 | 1
 | 22168 Total |  | 1 | 1 | 1
 | 22234 | DISASTER | 44 | 44 | 1
 | 22234 Total |  | 44 | 44 | 1
22R24 Total |  |  | 45 | 45 | 1
23R16 | 23200 | DISASTER | 1 | 1 | 1
 | 23200 Total |  | 1 | 1 | 1
23R16 Total |  |  | 1 | 1 | 1
24R08 | 24316 | DISASTER | 15 | 15 | 1
 | 24316 Total |  | 15 | 15 | 1
24R08 Total |  |  | 15 | 15 | 1
25R12 | 16452 | DISASTER | 7 | 8 | 0.875
 | 16452 Total |  | 7 | 8 | 0.875
 | 25040 | CDE | 1 | 1 | 1
 |  | DISASTER | 11 | 11 | 1
 | 25040 Total |  | 12 | 12 | 1
 | 25150 | CDE | 50 | 63 | 0.7936507936507936
 |  | DISASTER | 30 | 34 | 0.8823529411764706
 | 25150 Total |  | 80 | 97 | 0.8247422680412371
25R12 Total |  |  | 99 | 117 | 0.8461538461538461
25R16 | 13012 | DISASTER | 2 | 2 | 1
 | 13012 Total |  | 2 | 2 | 1
 | 25062 | DISASTER | 6 | 10 | 0.6
 | 25062 Total |  | 6 | 10 | 0.6
 | 25380 | CDE | 1 | 1 | 1
 |  | DISASTER | 161 | 167 | 0.9640718562874252
 | 25380 Total |  | 162 | 168 | 0.9642857142857143
25R16 Total |  |  | 170 | 180 | 0.9444444444444444
25R20 | 25060 | DISASTER | 8 | 8 | 1
 | 25060 Total |  | 8 | 8 | 1
 | 25152 | CDE | 5 | 6 | 0.8333333333333334
 |  | DISASTER | 25 | 26 | 0.9615384615384616
 | 25152 Total |  | 30 | 32 | 0.9375
25R20 Total |  |  | 38 | 40 | 0.95
27R12 | 27172 | DISASTER | 6 | 6 | 1
 | 27172 Total |  | 6 | 6 | 1
 | 27384 | DISASTER |  | 1 | 0
 | 27384 Total |  |  | 1 | 0
27R12 Total |  |  | 6 | 7 | 0.8571428571428571
28R08 | 28066 | DISASTER | 5 | 6 | 0.8333333333333334
 | 28066 Total |  | 5 | 6 | 0.8333333333333334
28R08 Total |  |  | 5 | 6 | 0.8333333333333334
30R08 | 30140 | DISASTER | 3 | 4 | 0.75
 | 30140 Total |  | 3 | 4 | 0.75
 | 30220 | DISASTER | 2 | 3 | 0.6666666666666666
 | 30220 Total |  | 2 | 3 | 0.6666666666666666
30R08 Total |  |  | 5 | 7 | 0.7142857142857143
31R04 | 31053 | DISASTER | 1 | 1 | 1
 | 31053 Total |  | 1 | 1 | 1
 | 31061 | DISASTER | 10 | 12 | 0.8333333333333334
 | 31061 Total |  | 10 | 12 | 0.8333333333333334
 | 31090 | DISASTER | 1 | 1 | 1
 | 31090 Total |  | 1 | 1 | 1
31R04 Total |  |  | 12 | 14 | 0.8571428571428571
32R16 | 32236 | DISASTER | 10 | 10 | 1
 | 32236 Total |  | 10 | 10 | 1
32R16 Total |  |  | 10 | 10 | 1
32R24 | 32048 | DISASTER | 5 | 5 | 1
 | 32048 Total |  | 5 | 5 | 1
 | 32400 | DISASTER | 12 | 12 | 1
 | 32400 Total |  | 12 | 12 | 1
32R24 Total |  |  | 17 | 17 | 1
33R08 | 33408 | DISASTER | 1 | 1 | 1
 | 33408 Total |  | 1 | 1 | 1
 | 33432 | DISASTER | 9 | 9 | 1
 | 33432 Total |  | 9 | 9 | 1
33R08 Total |  |  | 10 | 10 | 1
33R12 | 33188 | DISASTER | 15 | 15 | 1
 | 33188 Total |  | 15 | 15 | 1
 | 33322 | DISASTER | 13 | 13 | 1
 | 33322 Total |  | 13 | 13 | 1
33R12 Total |  |  | 28 | 28 | 1
33R16 | 33132 | DISASTER | 8 | 8 | 1
 | 33132 Total |  | 8 | 8 | 1
 | 33152 | DISASTER | 3 | 3 | 1
 | 33152 Total |  | 3 | 3 | 1
 | 33430 | DISASTER | 26 | 27 | 0.9629629629629629
 | 33430 Total |  | 26 | 27 | 0.9629629629629629
 | 33468 | DISASTER | 11 | 11 | 1
 | 33468 Total |  | 11 | 11 | 1
33R16 Total |  |  | 48 | 49 | 0.9795918367346939
34R08 | 34118 | DISASTER | 1 | 1 | 1
 | 34118 Total |  | 1 | 1 | 1
34R08 Total |  |  | 1 | 1 | 1
35R12 | 35072 | DISASTER | 6 | 6 | 1
 | 35072 Total |  | 6 | 6 | 1
 | 35106 | DISASTER | 1 | 1 | 1
 | 35106 Total |  | 1 | 1 | 1
 | 35373 | DISASTER | 1 | 1 | 1
 | 35373 Total |  | 1 | 1 | 1
35R12 Total |  |  | 8 | 8 | 1
35R16 | 35024 | CDE | 2 | 3 | 0.6666666666666666
 | 35024 Total |  | 2 | 3 | 0.6666666666666666
 | 35168 | DISASTER | 28 | 29 | 0.9655172413793104
 | 35168 Total |  | 28 | 29 | 0.9655172413793104
 | 35384 | CDE | 1 | 1 | 1
 |  | DISASTER | 3 | 3 | 1
 | 35384 Total |  | 4 | 4 | 1
 | 35392 | DISASTER | 4 | 4 | 1
 | 35392 Total |  | 4 | 4 | 1
35R16 Total |  |  | 38 | 40 | 0.95
35R20 | 35360 | DISASTER | 1 | 1 | 1
 | 35360 Total |  | 1 | 1 | 1
35R20 Total |  |  | 1 | 1 | 1
35R28 | 35170 | CDE | 20 | 22 | 0.9090909090909091
 | 35170 Total |  | 20 | 22 | 0.9090909090909091
 | 35184 | DISASTER | 1 | 2 | 0.5
 | 35184 Total |  | 1 | 2 | 0.5
 | 35352 | CDE | 8 | 8 | 1
 |  | DISASTER | 1 | 1 | 1
 | 35352 Total |  | 9 | 9 | 1
35R28 Total |  |  | 30 | 33 | 0.9090909090909091
36R04 | 36232 | CDE | 11 | 11 | 1
 |  | DISASTER | 17 | 17 | 1
 | 36232 Total |  | 28 | 28 | 1
36R04 Total |  |  | 28 | 28 | 1
37R04 | 37060 | DISASTER | 1 | 1 | 1
 | 37060 Total |  | 1 | 1 | 1
 | 37142 | DISASTER | 2 | 4 | 0.5
 | 37142 Total |  | 2 | 4 | 0.5
37R04 Total |  |  | 3 | 5 | 0.6
38R04 | 38024 | DISASTER | 2 | 2 | 1
 | 38024 Total |  | 2 | 2 | 1
 | 38212 | DISASTER | 10 | 11 | 0.9090909090909091
 | 38212 Total |  | 10 | 11 | 0.9090909090909091
38R04 Total |  |  | 12 | 13 | 0.9230769230769231
38R16 | 38032 | DISASTER | 23 | 23 | 1
 | 38032 Total |  | 23 | 23 | 1
 | 38098 | DISASTER | 3 | 3 | 1
 | 38098 Total |  | 3 | 3 | 1
 | 38196 | DISASTER | 19 | 19 | 1
 | 38196 Total |  | 19 | 19 | 1
 | 38400 | CDE | 2 | 3 | 0.6666666666666666
 | 38400 Total |  | 2 | 3 | 0.6666666666666666
 | 38444 | DISASTER | 5 | 5 | 1
 | 38444 Total |  | 5 | 5 | 1
38R16 Total |  |  | 52 | 53 | 0.9811320754716981
38R28 | 38052 | DISASTER | 2 | 2 | 1
 | 38052 Total |  | 2 | 2 | 1
 | 38428 | DISASTER | 16 | 16 | 1
 | 38428 Total |  | 16 | 16 | 1
38R28 Total |  |  | 18 | 18 | 1
40R08 | 40008 | DISASTER | 4 | 4 | 1
 | 40008 Total |  | 4 | 4 | 1
 | 40116 | CDE | 21 | 22 | 0.9545454545454546
 |  | DISASTER | 22 | 25 | 0.88
 | 40116 Total |  | 43 | 47 | 0.9148936170212766
 | 40120 | CDE | 10 | 16 | 0.625
 |  | DISASTER | 1 | 1 | 1
 | 40120 Total |  | 11 | 17 | 0.6470588235294118
 | 40196 | DISASTER | 27 | 29 | 0.9310344827586207
 | 40196 Total |  | 27 | 29 | 0.9310344827586207
40R08 Total |  |  | 85 | 97 | 0.8762886597938144
40R12 | 33029 | DISASTER | 4 | 5 | 0.8
 | 33029 Total |  | 4 | 5 | 0.8
 | 40104 | CDE | 1 | 1 | 1
 |  | DISASTER | 3 | 3 | 1
 | 40104 Total |  | 4 | 4 | 1
 | 40186 | CDE | 42 | 56 | 0.75
 |  | DISASTER | 13 | 14 | 0.9285714285714286
 | 40186 Total |  | 55 | 70 | 0.7857142857142857
40R12 Total |  |  | 63 | 79 | 0.7974683544303798
42R12 | 42036 | CDE | 12 | 22 | 0.5454545454545454
 |  | DISASTER | 3 | 3 | 1
 | 42036 Total |  | 15 | 25 | 0.6
 | 42056 | DISASTER | 15 | 15 | 1
 | 42056 Total |  | 15 | 15 | 1
 | 42196 | DISASTER | 17 | 18 | 0.9444444444444444
 | 42196 Total |  | 17 | 18 | 0.9444444444444444
42R12 Total |  |  | 47 | 58 | 0.8103448275862069
42R20 | 42170 | DISASTER | 1 | 1 | 1
 | 42170 Total |  | 1 | 1 | 1
 | 42264 | DISASTER | 1 | 1 | 1
 | 42264 Total |  | 1 | 1 | 1
 | 42296 | DISASTER | 24 | 25 | 0.96
 | 42296 Total |  | 24 | 25 | 0.96
 | 42428 | DISASTER | 1 | 1 | 1
 | 42428 Total |  | 1 | 1 | 1
42R20 Total |  |  | 27 | 28 | 0.9642857142857143
43R16 | 43200 | DISASTER | 4 | 5 | 0.8
 | 43200 Total |  | 4 | 5 | 0.8
 | 43332 | DISASTER | 4 | 4 | 1
 | 43332 Total |  | 4 | 4 | 1
 | 43504 | DISASTER | 6 | 6 | 1
 | 43504 Total |  | 6 | 6 | 1
 | 43550 | DISASTER | 2 | 2 | 1
 | 43550 Total |  | 2 | 2 | 1
43R16 Total |  |  | 16 | 17 | 0.9411764705882353
43R28 | 43044 | DISASTER | 10 | 14 | 0.7142857142857143
 | 43044 Total |  | 10 | 14 | 0.7142857142857143
 | 43142 | DISASTER | 4 | 4 | 1
 | 43142 Total |  | 4 | 4 | 1
 | 43336 | DISASTER | 8 | 10 | 0.8
 | 43336 Total |  | 8 | 10 | 0.8
43R28 Total |  |  | 22 | 28 | 0.7857142857142857
43R36 | 43256 | DISASTER | 95 | 150 | 0.6333333333333333
 | 43256 Total |  | 95 | 150 | 0.6333333333333333
 | 43746 | DISASTER | 32 | 33 | 0.9696969696969697
 | 43746 Total |  | 32 | 33 | 0.9696969696969697
43R36 Total |  |  | 127 | 183 | 0.6939890710382514
44R04 | 44006 | DISASTER | 4 | 5 | 0.8
 | 44006 Total |  | 4 | 5 | 0.8
 | 44084 | DISASTER | 4 | 4 | 1
 | 44084 Total |  | 4 | 4 | 1
44R04 Total |  |  | 8 | 9 | 0.8888888888888888
46R08 | 46441 | CDE | 49 | 75 | 0.6533333333333333
 | 46441 Total |  | 49 | 75 | 0.6533333333333333
46R08 Total |  |  | 49 | 75 | 0.6533333333333333
46R12 | 46372 | CDE | 1 | 1 | 1
 | 46372 Total |  | 1 | 1 | 1
46R12 Total |  |  | 1 | 1 | 1
46R16 | 46036 | DISASTER | 1 | 1 | 1
 | 46036 Total |  | 1 | 1 | 1
46R16 Total |  |  | 1 | 1 | 1
47R04 | 47128 | DISASTER | 4 | 4 | 1
 | 47128 Total |  | 4 | 4 | 1
 | 47152 | DISASTER | 4 | 4 | 1
 | 47152 Total |  | 4 | 4 | 1
47R04 Total |  |  | 8 | 8 | 1
47R08 | 47116 | DISASTER | 17 | 19 | 0.8947368421052632
 | 47116 Total |  | 17 | 19 | 0.8947368421052632
 | 47138 | CDE | 2 | 3 | 0.6666666666666666
 |  | DISASTER | 14 | 16 | 0.875
 | 47138 Total |  | 16 | 19 | 0.8421052631578947
47R08 Total |  |  | 33 | 38 | 0.868421052631579
47R12 | 47015 | CDE | 2 | 2 | 1
 | 47015 Total |  | 2 | 2 | 1
 | 47066 | DISASTER | 5 | 5 | 1
 | 47066 Total |  | 5 | 5 | 1
47R12 Total |  |  | 7 | 7 | 1
48R04 | 48036 | DISASTER | 1 | 1 | 1
 | 48036 Total |  | 1 | 1 | 1
 | 48084 | DISASTER | 1 | 2 | 0.5
 | 48084 Total |  | 1 | 2 | 0.5
 | 48240 | DISASTER | 3 | 4 | 0.75
 | 48240 Total |  | 3 | 4 | 0.75
48R04 Total |  |  | 5 | 7 | 0.7142857142857143
49R08 | 49152 | DISASTER | 11 | 11 | 1
 | 49152 Total |  | 11 | 11 | 1
49R08 Total |  |  | 11 | 11 | 1
49R12 | 49110 | CDE | 70 | 88 | 0.7954545454545454
 |  | DISASTER | 12 | 15 | 0.8
 | 49110 Total |  | 82 | 103 | 0.7961165048543689
 | 49162 | DISASTER | 1 | 1 | 1
 | 49162 Total |  | 1 | 1 | 1
49R12 Total |  |  | 83 | 104 | 0.7980769230769231
55R04 | 55004 | CDE | 1 | 2 | 0.5
 | 55004 Total |  | 1 | 2 | 0.5
55R04 Total |  |  | 1 | 2 | 0.5
56R04 | 56004 | CDE | 20 | 21 | 0.9523809523809523
 |  | DISASTER | 8 | 8 | 1
 | 56004 Total |  | 28 | 29 | 0.9655172413793104
56R04 Total |  |  | 28 | 29 | 0.9655172413793104
Grand Total |  |  | 3076 | 3565 | 0.8628330995792426