{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["28 Sep","26 Oct","23 Nov","21 Dec","18 Jan","15 Feb","14 Mar","11 Apr","09 May","06 June","04 July","01 Aug","29 Aug","26 Sept"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"28 Sep","index":0,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,0]
[null,null,null,null,null,null,"Hours owed",null,null,0]
[]
["Week Commencing",null,"2015-09-28",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2015-10-05"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2015-10-12"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2015-10-19"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":0}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":0}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"26 Oct","index":1,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'28 Sep'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'28 Sep'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2015-10-26",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2015-11-02"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2015-11-09"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2015-11-16"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"23 Nov","index":2,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'26 Oct'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'26 Oct'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2015-11-23",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2015-11-30"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2015-12-07"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2015-12-14"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"21 Dec","index":3,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'23 Nov'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'23 Nov'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2015-12-21",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2015-12-28"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-01-04"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-01-11"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"18 Jan","index":4,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'21 Dec'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'21 Dec'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-01-18",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-01-25"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-02-01"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-02-08"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"15 Feb","index":5,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'18 Jan'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'18 Jan'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-02-15",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-02-22"]
[null,"In",null,"In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-02-29"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-03-07"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"14 Mar","index":6,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'15 Feb'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'15 Feb'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-03-14",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-03-21"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-03-28"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-04-04"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"11 Apr","index":7,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'14 Mar'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'14 Mar'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-04-11",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-04-18"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-04-25"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-05-02"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"09 May","index":8,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'11 Apr'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'11 Apr'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-05-09",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-05-16"]
[null,"In","Out","In","Out","Total"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-05-23"]
[null,"In","Out","In","Out","Total"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-05-30"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"06 June","index":9,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'09 May'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'09 May'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-06-06",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-06-13"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-06-20"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-06-27"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"04 July","index":10,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'06 June'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'06 June'!F59","v":"0:00:00"}]
[null,":"]
["Week Commencing",null,"2016-07-04",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-07-11"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-07-18"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-07-25"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"01 Aug","index":11,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'04 July'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'04 July'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-08-01",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,"00:00:00"]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-08-08"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-08-15"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-08-22"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed: ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"29 Aug","index":12,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'01 Aug'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'01 Aug'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-08-29",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing",null,"2016-09-05"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing",null,"2016-09-12"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing",null,"2016-09-19"]
[null,"In",null,"In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]

{"sheet":"26 Sept","index":13,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,6,5,10]]}
[]
["Name",null,null,null,null,null,"Hours per week worked",null,null,1.4583333333333333]
[null,null,null,null,null,null,"Hours brought forward",null,null,{"$f":"'29 Aug'!F58","v":"0:00:00"}]
[null,null,null,null,null,null,"Hours owed",null,null,{"$f":"'29 Aug'!F59","v":"0:00:00"}]
[]
["Week Commencing",null,"2016-09-26",null,null,null,"Absences"]
[null,"In","Out","In","Out","Total","Annual hol","Univ closed","Sick","Flexi","Other"]
["Monday",null,null,null,null,{"$f":"(C8-B8)+(E8-D8)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C9-B9)+(E9-D9)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C10-B10)+(E10-D10)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C11-B11)+(E11-D11)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C12-B12)+(E12-D12)","v":"00:00:00"}]
["Weekend"]
[null,null,"Total time worked",null,null,{"$f":"SUM(F8:F13)","v":0}]
[]
["Week Commencing"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C18-B18)+(E18-D18)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C19-B19)+(E19-D19)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C20-B20)+(E20-D20)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C21-B21)+(E21-D21)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C22-B22)+(E22-D22)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F18:F23)","v":0}]
["Week Commencing"]
[null,"In","Out","In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C27-B27)+(E27-D27)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C28-B28)+(E28-D28)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C29-B29)+(E29-D29)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C30-B30)+(E30-D30)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C31-B31)+(E31-D31)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F27:F32)","v":0}]
["Week Commencing"]
[null,"In",null,"In","Out","Total"]
["Monday",null,null,null,null,{"$f":"(C36-B36)+(E36-D36)","v":"00:00:00"}]
["Tuesday",null,null,null,null,{"$f":"(C37-B37)+(E37-D37)","v":"00:00:00"}]
["Wednesday",null,null,null,null,{"$f":"(C38-B38)+(E38-D38)","v":"00:00:00"}]
["Thursday",null,null,null,null,{"$f":"(C39-B39)+(E39-D39)","v":"00:00:00"}]
["Friday",null,null,null,null,{"$f":"(C40-B40)+(E40-D40)","v":"00:00:00"}]
["Weekend"]
[null,null,null,null,null,{"$f":"SUM(F36:F41)","v":0},{"$f":"SUM(G8:G40)","v":0},{"$f":"SUM(H8:H40)","v":0},{"$f":"SUM(I8:I40)","v":0},{"$f":"SUM(J8:J40)","v":0},{"$f":"SUM(K8:K40)","v":0}]
[]
["Hours worked",null,null,null,null,{"$f":"F14+F24+F33+F42","v":0}]
["Annual holiday",null,null,null,null,{"$f":"G42","v":0}]
["University closed (bank holiday etc)",null,null,null,null,{"$f":"H42","v":0}]
["Sickness",null,null,null,null,{"$f":"I42","v":0}]
["Other",null,null,null,null,{"$f":"K42","v":0}]
[]
["Total hours this period",null,null,null,null,{"$f":"SUM(F44:F48)","v":0}]
["Add: Flexi Hours Brought Forward from Last Period",null,null,null,null,{"$f":"J3","v":"0:00:00"}]
["Less: Flexi Hours Owed from Last Period",null,null,null,null,{"$f":"J4","v":"0:00:00"}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52","v":0}]
["Less: Contracted hours for the Period",null,null,null,null,{"$f":"J2*4","v":5.833333333333333}]
[]
[null,null,null,null,null,{"$f":"F50+F51-F52-F55","v":-5.833333333333333}]
["Carried forward (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57>0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
["Hours owed (max 7 hours)",null,null,null,null,{"$f":"IF(AND(F57<0,SUM(F40:K40)>0),ABS(F57),\"0:00:00\")","v":"0:00:00"}]
[]
[]
["NOTE:"]
["Flexileave Taken this period",null,null,null,null,{"$f":"J42","v":0}]
[]
[]
[null,null,"Signed:  ","Employee"]
[]
[null,null,null,"Supervisor"]