{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Secondary School Staff Plan","Primary School Staff Plan"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Secondary School Staff Plan","index":0,"n_rows":67,"n_cols":13,"rows_kept":67,"merged":[[0,0,1,12],[3,1,3,2]]}
["Secondary School Staffing Plan"]
[]
[]
["Total number of Staff","Whole School",{"$nulls":5},"Staffing codes ","A = available","U = unavailable e.g. part-time","WFH = working from home","SI = self-isolating","M = medically signed off"]
[]
[]
[]
["Maths ","Monday","Tuesday","Wednesday","Thursday","Friday",null,"English","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B9:B13,\"A\")","v":0},{"$f":"COUNTIF(C9:C13,\"A\")","v":0},0,0,0,null,"Number of staff available",{"$f":"COUNTIF(I9:I13,\"A\")","v":0},{"$f":"COUNTIF(J9:J13,\"A\")","v":0},{"$f":"COUNTIF(K9:K13,\"A\")","v":0},{"$f":"COUNTIF(L9:L13,\"A\")","v":0},{"$f":"COUNTIF(M9:M13,\"A\")","v":0}]
[]
["Science","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Humanities","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B17:B21,\"A\")","v":0},{"$f":"COUNTIF(C17:C21,\"A\")","v":0},{"$f":"COUNTIF(D17:D21,\"A\")","v":0},{"$f":"COUNTIF(E17:E21,\"A\")","v":0},{"$f":"COUNTIF(F17:F21,\"A\")","v":0},null,"Number of staff available",{"$f":"COUNTIF(I17:I21,\"A\")","v":0},{"$f":"COUNTIF(J17:J21,\"A\")","v":0},{"$f":"COUNTIF(K17:K21,\"A\")","v":0},{"$f":"COUNTIF(L17:L21,\"A\")","v":0},{"$f":"COUNTIF(M17:M21,\"A\")","v":0}]
[]
["Espressive Arts","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Technology ","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B25:B29,\"A\")","v":0},{"$f":"COUNTIF(C25:C29,\"A\")","v":0},{"$f":"COUNTIF(D25:D29,\"A\")","v":0},{"$f":"COUNTIF(E25:E29,\"A\")","v":0},{"$f":"COUNTIF(F25:F29,\"A\")","v":0},null,"Number of staff available",{"$f":"COUNTIF(I25:I29,\"A\")","v":0},{"$f":"COUNTIF(J25:J29,\"A\")","v":0},{"$f":"COUNTIF(K25:K29,\"A\")","v":0},{"$f":"COUNTIF(L25:L29,\"A\")","v":0},{"$f":"COUNTIF(M25:M29,\"A\")","v":0}]
[]
["MFL","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Physical Education","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B33:B37,\"A\")","v":0},{"$f":"COUNTIF(C33:C37,\"A\")","v":0},{"$f":"COUNTIF(D33:D37,\"A\")","v":0},{"$f":"COUNTIF(E33:E37,\"A\")","v":0},{"$f":"COUNTIF(F33:F37,\"A\")","v":0},null,"Number of staff available",{"$f":"COUNTIF(I33:I37,\"A\")","v":0},{"$f":"COUNTIF(J33:J37,\"A\")","v":0},{"$f":"COUNTIF(K33:K37,\"A\")","v":0},{"$f":"COUNTIF(L33:L37,\"A\")","v":0},{"$f":"COUNTIF(M33:M37,\"A\")","v":0}]
[]
["Support staff  - HLTAs","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Admin Team","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B41:B45,\"A\")","v":0},{"$f":"COUNTIF(C41:C45,\"A\")","v":0},{"$f":"COUNTIF(D41:D45,\"A\")","v":0},{"$f":"COUNTIF(E41:E45,\"A\")","v":0},{"$f":"COUNTIF(F41:F45,\"A\")","v":0},null,"Number of staff available",{"$f":"COUNTIF(I41:I45,\"A\")","v":0},{"$f":"COUNTIF(J41:J45,\"A\")","v":0},{"$f":"COUNTIF(K41:K45,\"A\")","v":0},{"$f":"COUNTIF(L41:L45,\"A\")","v":0},{"$f":"COUNTIF(M41:M45,\"A\")","v":0}]
[]
["Support staff  - TAs","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Site Team/Cleaners ","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B49:B53,\"A\")","v":0},{"$f":"COUNTIF(C49:C53,\"A\")","v":0},{"$f":"COUNTIF(D49:D53,\"A\")","v":0},{"$f":"COUNTIF(E49:E53,\"A\")","v":0},{"$f":"COUNTIF(F49:F53,\"A\")","v":0},null,"Number of staff available",{"$f":"COUNTIF(I49:I53,\"A\")","v":0},{"$f":"COUNTIF(J49:J53,\"A\")","v":0},{"$f":"COUNTIF(K49:K53,\"A\")","v":0},{"$f":"COUNTIF(L49:L53,\"A\")","v":0},{"$f":"COUNTIF(M49:M53,\"A\")","v":0}]
[]
[{"$nulls":7},"Lunchtime Supervisors","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
[{"$nulls":7},"Number of staff available",{"$f":"COUNTIF(I57:I61,\"A\")","v":0},{"$f":"COUNTIF(J57:J61,\"A\")","v":0},{"$f":"COUNTIF(K57:K61,\"A\")","v":0},{"$f":"COUNTIF(L57:L61,\"A\")","v":0},{"$f":"COUNTIF(M57:M61,\"A\")","v":0}]
["Total Number","Monday","Tuesday","Wednesday","Thursday","Friday"]
["Number of staff available each day",{"$f":"B14+I14+B22+I22+B30+I30+B38+I38+B46+I46+B54+I54+I62","v":0},{"$f":"C14+J14+C22+J22+C30+J30+C38+J38+C46+J46+C54+J54+J62","v":0},{"$f":"D14+K14+D22+K22+D30+K30+D38+K38+D46+K46+D54+K54+K62","v":0},0,0]
[]
["Number of pupils expected each day"]
["Staff : pupil ratio",{"$f":"B66/(B14+B22+B30+B38+B46+I14+I22+I30+I38)","v":{"$error":"#DIV/0!"}},{"$f":"C66/(C14+C22+C30+C38+C46+J14+J22+J30+J38)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Primary School Staff Plan","index":1,"n_rows":59,"n_cols":13,"rows_kept":59,"merged":[[0,0,1,12],[3,1,3,2]]}
["Primary School Staffing Plan"]
[]
[]
["Total number of Staff","Whole School",{"$nulls":5},"Staffing codes ","A = available","U = unavailable e.g. part-time","WFH = working from home","SI = self-isolating","M = medically signed off"]
[]
[]
[]
["Y1-Y6 Teaching Staff ","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Support Staff Y1-Y6 HLTAs ","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
[{"$nulls":7},"Number of staff available",{"$f":"COUNTIF(I9:I13,\"A\")","v":0},{"$f":"COUNTIF(J9:J13,\"A\")","v":0},0,0,0]
[]
[{"$nulls":7},"Support Staff EYFS HLTAs ","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
[{"$nulls":7},"Number of staff available",{"$f":"COUNTIF(I17:I21,\"A\")","v":0},{"$f":"COUNTIF(J17:J21,\"A\")","v":0},0,0,0]
[]
[{"$nulls":7},"Support Staff TAs ","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B9:B29,\"A\")","v":0},{"$f":"COUNTIF(C9:C29,\"A\")","v":0},0,0,0,null,"Number of staff available",{"$f":"COUNTIF(I25:I29,\"A\")","v":0},{"$f":"COUNTIF(J25:J29,\"A\")","v":0},0,0,0]
[]
["EYFS Teaching Staff ","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Lunchtime Supervisors","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B33:B37,\"A\")","v":0},{"$f":"COUNTIF(C33:C37,\"A\")","v":0},0,0,0,null,"Number of staff available",{"$f":"COUNTIF(I33:I37,\"A\")","v":0},{"$f":"COUNTIF(J33:J37,\"A\")","v":0},0,0,0]
[]
["Admin Team ","Monday","Tuesday","Wednesday","Thursday","Friday",null,"Site Team/Cleaners ","Monday","Tuesday","Wednesday","Thursday","Friday"]
[]
[]
[]
[]
[]
["Number of staff available",{"$f":"COUNTIF(B41:B45,\"A\")","v":0},{"$f":"COUNTIF(C41:C45,\"A\")","v":0},0,0,0,null,"Number of staff available",{"$f":"COUNTIF(I41:I45,\"A\")","v":0},{"$f":"COUNTIF(J41:J45,\"A\")","v":0},0,0,0]
[]
[]
["Total Number","Monday","Tuesday","Wednesday","Thursday","Friday"]
["Number of staff available each day",{"$f":"B30+B38+B46+I14+I22+I30+I38+I46","v":0},{"$f":"C30+C38+C46+J14+J22+J30+J38+J46","v":0},{"$f":"D30+D38+D46+K14+K22+K30+K38+K46","v":0},0,{"$f":"F30+F38+F46+M14+M22+M30+M38+M46","v":0}]
[]
["Number of EYFS pupils expected each day"]
["EYFS staff : pupil ratio",{"$f":"B52/(B38+I22)","v":{"$error":"#DIV/0!"}},{"$f":"C52/(C38+J22)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Number of Y1-Y6 pupils expected each day"]
["Y1-Y6 Staff : pupil ratio",{"$f":"B54/(B30+I14)","v":{"$error":"#DIV/0!"}},{"$f":"C54/(C30+J14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Number of EHCP pupils expected"]
["Number of 1:1 staff for EHCP pupils"]
["Staff : EHCP pupil ratio",{"$f":"B57/B58","v":{"$error":"#DIV/0!"}},{"$f":"C57/C58","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]