Spreadsheet: 868866d1715598589-calculating-attendance-percentages-for-the-whole-school-school-register-23-24
Sheet: 1. SEP-DEC

 |  |  | CONTACT INFO |  |  |  | TOTALS
 |  |  |  |  |  |  | PRESENT |  | AUTHORISED |  | ABSENT |  | LATE |  | TOTAL | TOTAL
 | NAME | YR | CONTACT 1 | CONTACT 2 | E CONTACT |  | P | %P | A | %A | A | %A | L | %L
 | FORENAME | YR | Contact 1 | Contact 2 | E - Contact | Column36 | P | %P | AA | %AA | A | %A | L | %L | DAYS | PERCENTAGE
 | Student 1 | 1 |  |  |  |  | 131 |  | 3 |  | 0 |  | 2 |  | 134
 | Student 2 | 1 |  |  |  |  | 128 |  | 3 |  | 3 |  | 1 |  | 134
 | Student 3 | 1 |  |  |  |  | 119 |  | 15 |  | 0 |  | 0 |  | 134
 | Student 4 | 1 |  |  |  |  | 116 |  | 6 |  | 12 |  | 3 |  | 134
 | Student 5 | 1 |  |  |  |  | 119 |  | 14 |  | 1 |  | 1 |  | 134
 | Student 6 | 1 |  |  |  |  | 111 |  | 21 |  | 2 |  | 3 |  | 134
 | Student 7 | 1 |  |  |  |  | 109 |  | 25 |  | 0 |  | 0 |  | 134
 | Student 8 | 1 |  |  |  |  | 84 |  | 49 |  | 1 |  | 3 |  | 134
 | Student 9 | 1 |  |  |  |  | 131 |  | 3 |  | 0 |  | 9 |  | 134
 | Student 10 | 1 |  |  |  |  | 126 |  | 8 |  | 0 |  | 0 |  | 134
 | Student 11 | 1 |  |  |  |  | 109 |  | 24 |  | 1 |  | 7 |  | 134
 | Student 12 | 1 |  |  |  |  | 86 |  | 35 |  | 13 |  | 6 |  | 134
 | Student 13 | 1 |  |  |  |  | 32 |  | 40 |  | 0 |  | 1 |  | 72
 | Student 14 | 1 |  |  |  |  | 130 |  | 2 |  | 2 |  | 14 |  | 134
 | Student 15 | 1 |  |  |  |  | 132 |  | 1 |  | 1 |  | 1 |  | 134
 | Student 16 | 1 |  |  |  |  | 112 |  | 22 |  | 0 |  | 1 |  | 134
 | Student 17 | 1 |  |  |  |  | 128 |  | 3 |  | 3 |  | 8 |  | 134
 | Student 18 | 1 |  |  |  |  | 133 |  | 1 |  | 0 |  | 5 |  | 134
 | Student 19 | 2 |  |  |  |  | 128 |  | 6 |  | 0 |  | 0 |  | 134
 | Student 20 | 2 |  |  |  |  | 120 |  | 10 |  | 4 |  | 0 |  | 134
 | Student 21 | 2 |  |  |  |  | 126 |  | 7 |  | 1 |  | 2 |  | 134
 | Student 22 | 2 |  |  |  |  | 124 |  | 10 |  | 0 |  | 4 |  | 134
 | Student 23 | 2 |  |  |  |  | 132 |  | 2 |  | 0 |  | 2 |  | 134
 | Student 24 | 2 |  |  |  |  | 131 |  | 3 |  | 0 |  | 2 |  | 134
 | Student 25 | 2 |  |  |  |  | 132 |  | 2 |  | 0 |  | 1 |  | 134
 | Student 26 | 2 |  |  |  |  | 112 |  | 10 |  | 12 |  | 3 |  | 134
 | Student 27 | 2 |  |  |  |  | 129 |  | 5 |  | 0 |  | 0 |  | 134
 | Student 28 | 2 |  |  |  |  | 126 |  | 6 |  | 2 |  | 0 |  | 134
 | Student 29 | 2 |  |  |  |  | 132 |  | 2 |  | 0 |  | 0 |  | 134
 | Student 30 | 2 |  |  |  |  | 121 |  | 6 |  | 7 |  | 7 |  | 134
 | Student 31 | 2 |  |  |  |  | 126 |  | 7 |  | 1 |  | 0 |  | 134
 | Student 32 | 2 |  |  |  |  | 130 |  | 2 |  | 2 |  | 0 |  | 134
 | Student 33 | 2 |  |  |  |  | 131 |  | 3 |  | 0 |  | 2 |  | 134
 | Student 34 | 2 |  |  |  |  | 106 |  | 18 |  | 10 |  | 4 |  | 134
 | Student 35 | 2 |  |  |  |  | 127 |  | 6 |  | 1 |  | 13 |  | 134
 | Student 36 | 2 |  |  |  |  | 112 |  | 22 |  | 0 |  | 0 |  | 134
 | Student 37 | 2 |  |  |  |  | 94 |  | 23 |  | 17 |  | 22 |  | 134
 | Student 38 | 2 |  |  |  |  | 113 |  | 20 |  | 1 |  | 9 |  | 134
 | Student 39 | 3 |  |  |  |  | 122 |  | 4 |  | 8 |  | 3 |  | 134
 | Student 40 | 3 |  |  |  |  | 133 |  | 1 |  | 0 |  | 1 |  | 134
 | Student 41 | 3 |  |  |  |  | 131 |  | 3 |  | 0 |  | 2 |  | 134
 | Student 42 | 3 |  |  |  |  | 128 |  | 6 |  | 0 |  | 0 |  | 134
 | Student 43 | 3 |  |  |  |  | 122 |  | 8 |  | 4 |  | 3 |  | 134
 | Student 44 | 3 |  |  |  |  | 133 |  | 1 |  | 0 |  | 3 |  | 134
 | Student 45 | 3 |  |  |  |  | 121 |  | 5 |  | 8 |  | 13 |  | 134
 | Student 46 | 3 |  |  |  |  | 120 |  | 14 |  | 0 |  | 0 |  | 134
 | Student 47 | 3 |  |  |  |  | 126 |  | 8 |  | 0 |  | 0 |  | 134
 | Student 48 | 3 |  |  |  |  | 131 |  | 1 |  | 2 |  | 4 |  | 134
 | Student 49 | 3 |  |  |  |  | 129 |  | 5 |  | 0 |  | 0 |  | 134
 | Student 50 | 3 |  |  |  |  | 126 |  | 8 |  | 0 |  | 1 |  | 134
 | Student 51 | 3 |  |  |  |  | 120 |  | 14 |  | 0 |  | 0 |  | 134
 | Student 52 | 3 |  |  |  |  | 131 |  | 1 |  | 2 |  | 11 |  | 134
 | Student 53 | 3 |  |  |  |  | 131 |  | 1 |  | 2 |  | 1 |  | 134
 | Student 54 | 3 |  |  |  |  | 123 |  | 9 |  | 2 |  | 0 |  | 134
 | Student 55 | 3 |  |  |  |  | 128 |  | 6 |  | 0 |  | 2 |  | 134
 | Student 56 | 3 |  |  |  |  | 132 |  | 2 |  | 0 |  | 2 |  | 134
 | Student 57 | 3 |  |  |  |  | 127 |  | 7 |  | 0 |  | 0 |  | 134
 | Student 58 | 3 |  |  |  |  | 18 |  | 12 |  | 0 |  | 1 |  | 30
 | Student 59 | 4 |  |  |  |  | 128 |  | 6 |  | 0 |  | 2 |  | 134
 | Student 60 | 4 |  |  |  |  | 131 |  | 3 |  | 0 |  | 2 |  | 134
 | Student 61 | 4 |  |  |  |  | 121 |  | 8 |  | 5 |  | 5 |  | 134
 | Student 62 | 4 |  |  |  |  | 127 |  | 2 |  | 5 |  | 2 |  | 134
 | Student 63 | 4 |  |  |  |  | 88 |  | 45 |  | 1 |  | 3 |  | 134
 | Student 64 | 4 |  |  |  |  | 132 |  | 2 |  | 0 |  | 2 |  | 134
 | Student 65 | 4 |  |  |  |  | 98 |  | 32 |  | 4 |  | 4 |  | 134
 | Student 66 | 4 |  |  |  |  | 128 |  | 2 |  | 4 |  | 4 |  | 134
 | Student 67 | 4 |  |  |  |  | 109 |  | 22 |  | 3 |  | 3 |  | 134
 | Student 68 | 4 |  |  |  |  | 121 |  | 3 |  | 10 |  | 6 |  | 134
 | Student 69 | 4 |  |  |  |  | 131 |  | 2 |  | 1 |  | 2 |  | 134
 | Student 70 | 4 |  |  |  |  | 132 |  | 2 |  | 0 |  | 11 |  | 134
 | Student 71 | 4 |  |  |  |  | 123 |  | 10 |  | 1 |  | 1 |  | 134
 | Student 72 | 4 |  |  |  |  | 125 |  | 7 |  | 2 |  | 12 |  | 134
 | Student 73 | 4 |  |  |  |  | 124 |  | 9 |  | 1 |  | 1 |  | 134
 | Student 74 | 5 |  |  |  |  | 129 |  | 3 |  | 2 |  | 1 |  | 134
 | Student 75 | 5 |  |  |  |  | 127 |  | 3 |  | 4 |  | 5 |  | 134
 | Student 76 | 5 |  |  |  |  | 122 |  | 11 |  | 1 |  | 2 |  | 134
 | Student 77 | 5 |  |  |  |  | 128 |  | 2 |  | 4 |  | 5 |  | 134
 | Student 78 | 5 |  |  |  |  | 103 |  | 29 |  | 2 |  | 4 |  | 134
 | Student 79 | 5 |  |  |  |  | 111 |  | 21 |  | 2 |  | 4 |  | 134
 | Student 80 | 5 |  |  |  |  | 133 |  | 1 |  | 0 |  | 1 |  | 134
 | Student 81 | 5 |  |  |  |  | 133 |  | 1 |  | 0 |  | 6 |  | 134
 | Student 82 | 5 |  |  |  |  | 124 |  | 4 |  | 6 |  | 22 |  | 134
 | Student 83 | 5 |  |  |  |  | 129 |  | 4 |  | 1 |  | 1 |  | 134
 | Student 84 | 5 |  |  |  |  | 132 |  | 2 |  | 0 |  | 2 |  | 134
 | Student 85 | 5 |  |  |  |  | 111 |  | 2 |  | 1 |  | 4 |  | 114
 | Student 86 | 5 |  |  |  |  | 123 |  | 11 |  | 0 |  | 0 |  | 134
 | Student 87 | 5 |  |  |  |  | 132 |  | 2 |  | 0 |  | 2 |  | 134
 | Student 88 | 5 |  |  |  |  | 127 |  | 5 |  | 2 |  | 1 |  | 134
 | Student 89 | 5 |  |  |  |  | 119 |  | 14 |  | 1 |  | 11 |  | 134
 | Student 90 | 5 |  |  |  |  | 129 |  | 5 |  | 0 |  | 2 |  | 134
 | Student 91 | 6 |  |  |  |  | 120 |  | 12 |  | 2 |  | 3 |  | 134
 | Student 92 | 6 |  |  |  |  | 133 |  | 1 |  | 0 |  | 1 |  | 134
 | Student 93 | 6 |  |  |  |  | 132 |  | 2 |  | 0 |  | 2 |  | 134
 | Student 94 | 6 |  |  |  |  | 119 |  | 15 |  | 0 |  | 1 |  | 134
 | Student 95 | 6 |  |  |  |  | 121 |  | 8 |  | 5 |  | 14 |  | 134
 | Student 96 | 6 |  |  |  |  | 124 |  | 10 |  | 0 |  | 1 |  | 134
 | Student 97 | 6 |  |  |  |  | 126 |  | 7 |  | 1 |  | 2 |  | 134
 | Student 98 | 6 |  |  |  |  | 133 |  | 1 |  | 0 |  | 3 |  | 134
 | Student 99 | 6 |  |  |  |  | 87 |  | 46 |  | 1 |  | 3 |  | 134
 | Student 100 | 6 |  |  |  |  | 127 |  | 3 |  | 4 |  | 10 |  | 134
 | Student 101 | 6 |  |  |  |  | 116 |  | 18 |  | 0 |  | 0 |  | 134
 | Student 102 | 6 |  |  |  |  | 125 |  | 5 |  | 4 |  | 0 |  | 134
 | Student 103 | 6 |  |  |  |  | 111 |  | 11 |  | 12 |  | 2 |  | 134
 | Student 104 | 6 |  |  |  |  | 132 |  | 2 |  | 0 |  | 6 |  | 134
 | Student 105 | 6 |  |  |  |  | 127 |  | 7 |  | 0 |  | 3 |  | 134
 | Student 106 | 6 |  |  |  |  | 114 |  | 13 |  | 7 |  | 9 |  | 134
 |  |  |  |  |  |  | 128 |  | 5 |  | 1 |  | 1 |  | 134
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0