Spreadsheet: 868866d1715598589-calculating-attendance-percentages-for-the-whole-school-school-register-23-24
Sheet: 3. APR-JUL

 |  |  | 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 |  |  |  |  | 28 |  | 1 |  | 0 |  | 2 |  | 29
 | Student 2 | 1 |  |  |  |  | 26 |  | 3 |  | 0 |  | 0 |  | 29
 | Student 3 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 2 |  | 29
 | Student 4 | 1 |  |  |  |  | 17 |  | 4 |  | 8 |  | 0 |  | 29
 | Student 5 | 1 |  |  |  |  | 27 |  | 2 |  | 0 |  | 2 |  | 29
 | Student 6 | 1 |  |  |  |  | 26 |  | 0 |  | 3 |  | 0 |  | 29
 | Student 7 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 1 |  | 29
 | Student 8 | 1 |  |  |  |  | 18 |  | 2 |  | 9 |  | 0 |  | 29
 | Student 9 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 10 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 1 |  | 29
 | Student 11 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 1 |  | 29
 | Student 12 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 13 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 1 |  | 29
 | Student 14 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 3 |  | 29
 | Student 15 | 1 |  |  |  |  | 28 |  | 1 |  | 0 |  | 2 |  | 29
 | Student 16 | 1 |  |  |  |  | 28 |  | 1 |  | 0 |  | 4 |  | 29
 | Student 17 | 1 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 18 | 1 |  |  |  |  | 26 |  | 3 |  | 0 |  | 0 |  | 29
 | Student 19 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 20 | 2 |  |  |  |  | 27 |  | 0 |  | 2 |  | 2 |  | 29
 | Student 21 | 2 |  |  |  |  | 23 |  | 6 |  | 0 |  | 1 |  | 29
 | Student 22 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 23 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 24 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 25 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 4 |  | 29
 | Student 26 | 2 |  |  |  |  | 27 |  | 2 |  | 0 |  | 1 |  | 29
 | Student 27 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 1 |  | 29
 | Student 28 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 2 |  | 29
 | Student 29 | 2 |  |  |  |  | 25 |  | 4 |  | 0 |  | 0 |  | 29
 | Student 30 | 2 |  |  |  |  | 27 |  | 0 |  | 2 |  | 0 |  | 29
 | Student 31 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 32 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 1 |  | 29
 | Student 33 | 2 |  |  |  |  | 27 |  | 2 |  | 0 |  | 1 |  | 29
 | Student 34 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 35 | 2 |  |  |  |  | 20 |  | 0 |  | 9 |  | 0 |  | 29
 | Student 36 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 37 | 2 |  |  |  |  | 28 |  | 0 |  | 1 |  | 0 |  | 29
 | Student 38 | 2 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 39 | 3 |  |  |  |  | 28 |  | 1 |  | 0 |  | 1 |  | 29
 | Student 40 | 3 |  |  |  |  | 27 |  | 2 |  | 0 |  | 0 |  | 29
 | Student 41 | 3 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 42 | 3 |  |  |  |  | 14 |  | 2 |  | 13 |  | 3 |  | 29
 | Student 43 | 3 |  |  |  |  | 25 |  | 4 |  | 0 |  | 3 |  | 29
 | Student 44 | 3 |  |  |  |  | 26 |  | 3 |  | 0 |  | 0 |  | 29
 | Student 45 | 3 |  |  |  |  | 25 |  | 2 |  | 2 |  | 0 |  | 29
 | Student 46 | 3 |  |  |  |  | 23 |  | 6 |  | 0 |  | 0 |  | 29
 | Student 47 | 3 |  |  |  |  | 23 |  | 6 |  | 0 |  | 0 |  | 29
 | Student 48 | 3 |  |  |  |  | 25 |  | 4 |  | 0 |  | 0 |  | 29
 | Student 49 | 3 |  |  |  |  | 25 |  | 4 |  | 0 |  | 0 |  | 29
 | Student 50 | 3 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 51 | 3 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 52 | 3 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 53 | 3 |  |  |  |  | 23 |  | 4 |  | 2 |  | 3 |  | 29
 | Student 54 | 3 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 55 | 3 |  |  |  |  | 26 |  | 1 |  | 2 |  | 0 |  | 29
 | Student 56 | 3 |  |  |  |  | 24 |  | 5 |  | 0 |  | 0 |  | 29
 | Student 57 | 3 |  |  |  |  | 17 |  | 3 |  | 9 |  | 0 |  | 29
 | Student 58 | 3 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 59 | 4 |  |  |  |  | 20 |  | 0 |  | 9 |  | 0 |  | 29
 | Student 60 | 4 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 61 | 4 |  |  |  |  | 29 |  | 0 |  | 0 |  | 1 |  | 29
 | Student 62 | 4 |  |  |  |  | 28 |  | 0 |  | 0 |  | 1 |  | 28
 | Student 63 | 4 |  |  |  |  | 25 |  | 1 |  | 3 |  | 2 |  | 29
 | Student 64 | 4 |  |  |  |  | 28 |  | 0 |  | 1 |  | 0 |  | 29
 | Student 65 | 4 |  |  |  |  | 29 |  | 0 |  | 0 |  | 2 |  | 29
 | Student 66 | 4 |  |  |  |  | 29 |  | 0 |  | 0 |  | 1 |  | 29
 | Student 67 | 4 |  |  |  |  | 26 |  | 3 |  | 0 |  | 2 |  | 29
 | Student 68 | 4 |  |  |  |  | 16 |  | 4 |  | 9 |  | 0 |  | 29
 | Student 69 | 4 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 70 | 4 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 71 | 4 |  |  |  |  | 27 |  | 2 |  | 0 |  | 0 |  | 29
 | Student 72 | 4 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 73 | 4 |  |  |  |  | 29 |  | 0 |  | 0 |  | 4 |  | 29
 | Student 74 | 5 |  |  |  |  | 29 |  | 0 |  | 0 |  | 0 |  | 29
 | Student 75 | 5 |  |  |  |  | 28 |  | 1 |  | 0 |  | 2 |  | 29
 | Student 76 | 5 |  |  |  |  | 23 |  | 6 |  | 0 |  | 0 |  | 29
 | Student 77 | 5 |  |  |  |  | 28 |  | 1 |  | 0 |  | 1 |  | 29
 | Student 78 | 5 |  |  |  |  | 5 |  | 24 |  | 0 |  | 0 |  | 29
 | Student 79 | 5 |  |  |  |  | 26 |  | 3 |  | 0 |  | 0 |  | 29
 | Student 80 | 5 |  |  |  |  | 25 |  | 4 |  | 0 |  | 0 |  | 29
 | Student 81 | 5 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 82 | 5 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 83 | 5 |  |  |  |  | 27 |  | 2 |  | 0 |  | 2 |  | 29
 | Student 84 | 5 |  |  |  |  | 26 |  | 3 |  | 0 |  | 1 |  | 29
 | Student 85 | 5 |  |  |  |  | 0 |  | 0 |  | 1 |  | 0 |  | 1
 | Student 86 | 5 |  |  |  |  | 28 |  | 1 |  | 0 |  | 1 |  | 29
 | Student 87 | 5 |  |  |  |  | 26 |  | 3 |  | 0 |  | 0 |  | 29
 | Student 88 | 5 |  |  |  |  | 28 |  | 1 |  | 0 |  | 0 |  | 29
 | Student 89 | 6 |  |  |  |  | 27 |  | 2 |  | 0 |  | 1 |  | 29
 | Student 90 | 6 |  |  |  |  | 25 |  | 3 |  | 1 |  | 4 |  | 29
 | Student 91 | 6 |  |  |  |  | 28 |  | 0 |  | 0 |  | 0 |  | 28
 | Student 92 | 6 |  |  |  |  | 28 |  | 0 |  | 0 |  | 0 |  | 28
 | Student 93 | 6 |  |  |  |  | 28 |  | 0 |  | 0 |  | 0 |  | 28
 | Student 94 | 6 |  |  |  |  | 28 |  | 0 |  | 0 |  | 0 |  | 28
 | Student 95 | 6 |  |  |  |  | 18 |  | 5 |  | 5 |  | 2 |  | 28
 | Student 96 | 6 |  |  |  |  | 25 |  | 3 |  | 0 |  | 2 |  | 28
 | Student 97 | 6 |  |  |  |  | 25 |  | 0 |  | 3 |  | 0 |  | 28
 | Student 98 | 6 |  |  |  |  | 26 |  | 2 |  | 0 |  | 0 |  | 28
 | Student 99 | 6 |  |  |  |  | 28 |  | 0 |  | 0 |  | 0 |  | 28
 | Student 100 | 6 |  |  |  |  | 27 |  | 1 |  | 0 |  | 1 |  | 28
 | Student 101 | 6 |  |  |  |  | 23 |  | 5 |  | 0 |  | 1 |  | 28
 | Student 102 | 6 |  |  |  |  | 16 |  | 3 |  | 9 |  | 0 |  | 28