Spreadsheet: 74323d1274871943-excel-2007-ifs-function-simplified
Sheet: A

 |  |  |  | Staff Absences |  |  |  |  |  |  | STAFF ABSENCE RECONCILIATION |  |  |  |  |  |  |  |  | TEMPORARY TEACHERS (On Contracts)
 |  | DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODES | SIBDISSECTIONS | Staff Names |  | Casuals |  | CASUALS AND FULL LOAD
 |  |  |  |  |  |  |  |  |  |  | ABSENT TEACHER | CASUAL TEACHER | REASON | CODE | SUBDISSECTION |  |  |  | ABSENT TEACHER | CASUAL TEACHER | REASON | CODE | SUBDISSECTION
 | ABSENT STAFF |  |  |  | REPLACEMENT STAFF |  |  |  |  |  |  |  |  |  |  |  |  |  | C.PHUNG | A.BURIC | MAT LEAVE | 240 |  | ALL YEAR |  |  | 200 | 464002 |  |  |  |  |  | NO. OF CASUALS DAY TO DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAP | [NAME] | NAP | 711 |  |  |  |  | 205 | 382690
WEEK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C.JORGENSEN | P.PHAM | LWOP | 235 |  |  |  |  | 210 | 281051 |  |  |  |  |  | NO. OF CASUALS IN RECONC
1A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | T.LOREGGIAN | MAT LEAVE | 240 |  | TERM1 TO T2W7 |  |  | 215 | 346690
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J.TAWSE | R.SHORT | MAT LEAVE | 240 | (0.6 WE,TH,FR ONLY) |  |  |  | 225 |  |  |  |  |  |  | DIFFERENCE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NUMERACY | J.GEORGES | PAS | 302 |  | ALL YEAR |  |  | 235
DAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PSP1 | V.TRAN | LITERACY | 302 |  |  |  |  | 240
MONA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G.MISRA | N.SLEIMAN | MAT LEAVE | 240 | (0.4 TH,FR ONLY) |  |  |  | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAP | G.LOWE | NAP | 711 |  |  |  |  | 250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAP | V.SHARMA | NAP | 711 |  |  |  |  | 301
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAP | N.VANDENBOS | NAP | 711 |  |  |  |  | 302
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAP | D.GRIERSON | NAP | 711 |  |  |  |  | 711
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAP | E.MADSEN | NAP | 711
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A.BRIGHT | A.REID | LWOP | 235 |  | MON,TUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENG UV (0.2) | J.DUVALL | UV | 250 |  | MONDAY ONLY
 |  |  |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  |  | J.MENZIES | J.DUVALL | LWOP | 235 |  | TUESDAY ONLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C.MANUEL | J.DUVALL | MAT LEAVE | 240 |  | WED,THU,FRI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAPA UV (0.6) | [NAME] | UV | 250 |  | MONA,TUEA,THUA,MONB,THUB,FRIB
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY |  |  |  |  |  |  |  |  |  |  | [NAME].ERSKINE | [NAME] | MAT LEAVE | 240 |  | WEDA,FRIA,WEDB,THUB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENG UV | [NAME] | UV | 250
REASON |  |  |  |  | REASON |  |  |  |  |  |  |  |  |  |  |  |  |  | CAREERS UV | D.KANTI | UV | 250
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL |  |  |  |  |  |  |  |  |  |  |  |  |  | SCI UV | H.LUONG | UV | 250
PD 1 |  |  |  |  | PD 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (0.2) | N.KUROVSKY | UV | 250 |  | MONDAY ONLY
PD 2 |  |  |  |  | PD 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | CAREERS UV (0.2) | N.KUROVSKY | UV | 250 |  | TUESDAY ONLY
RECESS DUTY |  |  |  |  | RECESS DUTY |  |  |  |  |  |  |  |  |  |  |  |  |  | INTEGRATION 0.4) | N.KUROVSKY | UV | 302 |  | WED,THU ONLY
PD 3 |  |  |  |  | PD 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | MATHS UV (0.2) | N.KUROVSKY | UV | 250 |  | FRI ONLY
PD 4 |  |  |  |  | PD 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | C.BEADON (0.2) | R.LAWRENCE | LWOP | 235 |  | FRI
LUNCH 1 |  |  |  |  | LUNCH 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | G.SHEKAR (0.4) | R.LAWRENCE | LWOP | 235 |  | MON,WED
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERMANENTS
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON |  |  |  |  |  | FULL LOAD TEACHERS (Submitted Thru ecpc)
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1 |  |  |  |  |  | ABSENT TEACHER | CASUAL TEACHER | REASON | CODE | SUBDISSECTION
PD 2 |  |  |  |  | PD 2 |  |  |  |  |  | L.TRELOAR | N.ROCCA | W.COMP | 225
RECESS DUTY |  |  |  |  | RECESS DUTY |  |  |  |  |  | STW | D.ODWYER | STW | 302 | 464002
PD 3 |  |  |  |  | PD 3 |  |  |  |  |  | HSIE 1 UV | B.GLENN | UV | 250
PD 4 |  |  |  |  | PD 4 |  |  |  |  |  | SCI UV | B.REARDON | UV | 250
LUNCH 1 |  |  |  |  | LUNCH 1 |  |  |  |  |  | MATHS UV | L.CAI | UV | 250
LUNCH 2 |  |  |  |  | LUNCH 2 |  |  |  |  |  | A.STEFAN | [NAME] | LWOP | 235
PD 5 |  |  |  |  | PD 5 |  |  |  |  |  | HSIE 2 UV | R.HUSSAYNI | UV | 250
PD 6 |  |  |  |  | PD 6 |  |  |  |  |  | PE UV | A.CHOKBENGBOUN | UV | 250
 |  |  |  |  |  |  |  |  |  |  | A.KHOUW (0.5) | H.WANG | SICK | 215 |  | MONA,TUEA,FRIA,THUB,FRIB
 |  |  |  |  |  |  |  |  |  |  | MATHS UV (0.5) | H.WANG | UV | 250 |  | WEDA,THUA,MONB,TUEB,WEDB
 |  |  |  |  |  |  |  |  |  |  | NAP | A.REID | NAP | 711 |  | WED ONLY
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Cover
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Cover Req
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6
STAFF ABSENT | CLASS | ROOM | COVERED BY |  | STAFF ABSENT | CLASS | ROOM | COVERED BY
REASON |  |  |  |  | REASON
PERIOD 0 / ROLL |  |  |  |  | PERIOD 0 / ROLL
PD 1 |  |  |  |  | PD 1
PD 2 |  |  |  |  | PD 2
RECESS DUTY |  |  |  |  | RECESS DUTY
PD 3 |  |  |  |  | PD 3
PD 4 |  |  |  |  | PD 4
LUNCH 1 |  |  |  |  | LUNCH 1
LUNCH 2 |  |  |  |  | LUNCH 2
PD 5 |  |  |  |  | PD 5
PD 6 |  |  |  |  | PD 6