Spreadsheet: 89945d1289698314-sum-columns-based-on-header-cell-grade-book
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Scores |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum each category
 | Mot | Cit | Fit | A1 | A3 | A2 | A4 | A5 | A6 | A7 | Fit | Cit | Mot | Mot | Mot | Mot | Mot | Mot | Mot | Mot | Total | Percent | Points |  | Fit | Cit | Mot | A1 | A2 | A3 | A4 | A5 | A6 | A7
 | 100 | 20 | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 758 |  | Possible |  | 0.05 | 0.1 | 0.15 | 0.15 | 0.05 | 0.05 | 0.1 | 0.15 | 0.15 | 0.05
1 | x |  |  | 25 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 568 | 0.8632218844984803 | 658
2 | 92 | 20 | 10 | 25 | 100 | 90 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 620 | 0.8179419525065963 | 758
3 | 96 | 20 | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 634 | 0.8364116094986808 | 758
4 | 98 | 20 |  |  | 100 | 100 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 418 | 0.5514511873350924 | 758
5 | 78 |  | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 596 | 0.7862796833773087 | 758
6 | 94 | 20 | 10 | 25 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 692 | 0.9129287598944591 | 758
7 | 92 |  |  | 25 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 660 | 0.8707124010554089 | 758
8 | 88 |  | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 726 | 0.9577836411609498 | 758
9 | 98 | 20 | 10 | 25 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 696 | 0.9182058047493403 | 758
10 | 98 | 20 | 10 | 25 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 696 | 0.9182058047493403 | 758
11 | 96 | 20 | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 754 | 0.9947229551451188 | 758
12 | 94 |  |  | 20 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 717 | 0.945910290237467 | 758
13 | 96 | 20 | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 754 | 0.9947229551451188 | 758
14 | 62 | 20 | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 600 | 0.7915567282321899 | 758
15 |  |  |  | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 508 | 0.6701846965699209 | 758
16 | 94 | 20 | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 632 | 0.8337730870712401 | 758
17 | 100 | 20 | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 758 | 1 | 758
18 | 82 |  | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 600 | 0.7915567282321899 | 758
19 | 100 | 20 | 10 | 25 | 100 | 100 | 90 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 748 | 0.9868073878627969 | 758
20 | 90 |  | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 608 | 0.8021108179419525 | 758
21 | 96 |  | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 734 | 0.9683377308707124 | 758
22 | 90 |  |  |  | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 573 | 0.7559366754617414 | 758
23 | 88 | 20 | 10 | 25 | 100 | 90 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 736 | 0.9709762532981531 | 758
24 | 84 | 20 | 10 | 25 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 682 | 0.899736147757256 | 758
25 | 98 | 20 | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 636 | 0.8390501319261213 | 758
26 | 96 | 20 | 10 | 25 | 100 | 100 | 100 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 574 | 0.7572559366754618 | 758
27 | 98 | 20 | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 756 | 0.9973614775725593 | 758
28 | 92 |  |  | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 720 | 0.9498680738786279 | 758
29 | 96 | 20 | 10 | 25 | 100 | 100 | 100 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 574 | 0.7572559366754618 | 758
30 | 98 | 20 | 10 | 25 | 100 | 100 | 100 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 576 | 0.7598944591029023 | 758
31 | 94 |  | 10 | 25 | 100 | 100 | 100 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 552 | 0.7282321899736148 | 758
32 | 96 |  | 10 | 20 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 669 | 0.8825857519788918 | 758
33 | 94 |  | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 612 | 0.8073878627968337 | 758
34 | 100 |  | 10 | 25 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 678 | 0.8944591029023746 | 758
35 | 94 | 20 | 10 | 20 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 627 | 0.8271767810026385 | 758
36 | 48 |  | 10 | 20 | 100 | 100 | 100 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 501 | 0.6609498680738787 | 758
37 | 98 | 20 | 10 | 25 | 100 | 90 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 686 | 0.9050131926121372 | 758
38 | 98 | 20 | 10 | 20 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 631 | 0.8324538258575198 | 758
39 | 94 | 20 | 10 | 20 | 100 | 90 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 617 | 0.8139841688654353 | 758
40 | 96 |  |  | 15 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 594 | 0.783641160949868 | 758
41 | 92 |  |  | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 600 | 0.7915567282321899 | 758
42 | 50 |  | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 688 | 0.9076517150395779 | 758
43 | 94 | 20 | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 632 | 0.8337730870712401 | 758
44 | 92 | 20 | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 630 | 0.8311345646437994 | 758
45 | 96 | 20 | 10 | 20 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 629 | 0.8298153034300791 | 758
46 | 96 | 20 | 10 | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 754 | 0.9947229551451188 | 758
47 | 96 | 20 | 10 | 25 | 100 | 100 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 451 | 0.5949868073878628 | 758
48 | 60 |  |  | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 568 | 0.7493403693931399 | 758
49 | 94 |  |  | 25 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 722 | 0.9525065963060686 | 758
50 | 90 |  | 10 | 25 | 100 | 100 | 100 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 668 | 0.8812664907651715 | 758
51 | 96 |  |  | 25 | 100 | 100 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 421 | 0.5554089709762533 | 758
52 | 100 | 20 | 10 | 25 | 100 | 100 | 100 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 638 | 0.841688654353562 | 758
53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 758
54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 758
55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 758
56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 758
57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 758
58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 758
59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 758
60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 758