Spreadsheet: 868882d1715608300-calculating-attendance-percentages-for-the-whole-school-school-register-23-24
Sheet: 2. JAN-MAR

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