{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":21,"n_cols":28,"rows_kept":21,"merged":[[0,0,0,27],[1,0,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,2,17],[1,27,2,27]]}
["DRIVER SHIFT SCHEDULE "]
[{"$nulls":3},"Sunday",null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday",null,"Rest per day (minutes)","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Total","Rest","Total Week"]
["Staff","Location","Shift","Start","End","Start","End","Start","End","Start","End","Start","End","Start","End","Start","End"]
["Driver A","North C","Day Shift","AL","AL","AL","AL","AL","AL","AL","AL","AL","AL","AL","AL","AL","AL",45,{"$f":"IFERROR(E4-D4,0)","v":"00:00:00"},{"$f":"IFERROR(G4-F4,0)","v":"00:00:00"},{"$f":"IFERROR(I4-H4,0)","v":"00:00:00"},{"$f":"IFERROR(K4-J4,0)","v":"00:00:00"},{"$f":"IFERROR(M4-L4,0)","v":"00:00:00"},{"$f":"IFERROR(O4-N4,0)","v":"00:00:00"},{"$f":"IFERROR(Q4-P4,0)","v":"00:00:00"},{"$f":"SUM(S4:Y4)*24","v":0},{"$f":"(R4/60)*(COUNT(D4:Q4)/2)-(R4/60)","v":-0.75},{"$f":"Z4-AA4","v":{"v":0.75,"d":"0.8"}}]
["Driver B","South C","Day Shift","OFF","OFF","07:00:00","15:30:00","07:00:00","15:30:00","08:30:00","17:00:00","08:30:00","17:00:00","11:00:00","17:00:00","OFF","OFF",45,{"$f":"IFERROR(E5-D5,0)","v":"00:00:00"},{"$f":"IFERROR(G5-F5,0)","v":"08:30:00"},{"$f":"IFERROR(I5-H5,0)","v":"08:30:00"},{"$f":"IFERROR(K5-J5,0)","v":"08:30:00"},{"$f":"IFERROR(M5-L5,0)","v":"08:30:00"},{"$f":"IFERROR(O5-N5,0)","v":"06:00:00"},{"$f":"IFERROR(Q5-P5,0)","v":"00:00:00"},40,{"$f":"(R5/60)*(COUNT(D5:Q5)/2)-(R5/60)","v":3},{"$f":"Z5-AA5","v":{"v":37,"d":"37.0"}}]
["Driver C","North C","Night Shift","OFF","OFF","OFF","OFF","OFF","OFF","17:00:00","07:20:00","17:00:00","07:20:00","17:00:00","07:20:00","OFF","OFF",120,{"$f":"IFERROR(E6+1-D6,0)","v":"00:00:00"},{"$f":"IFERROR(G6+1-F6,0)","v":"00:00:00"},{"$f":"IFERROR(I6+1-H6,0)","v":"00:00:00"},{"$f":"IFERROR(K6+1-J6,0)","v":"14:20:00"},{"$f":"IFERROR(M6+1-L6,0)","v":"14:20:00"},{"$f":"IFERROR(O6+1-N6,0)","v":"14:20:00"},{"$f":"IFERROR(Q6+1-P6,0)","v":"00:00:00"},43,{"$f":"(R6/60)*(COUNT(D6:Q6)/2)","v":6},{"$f":"Z6-AA6","v":{"v":37,"d":"37.0"}}]
["Driver D","South C","Night Shift","17:00:00","07:20:00","17:00:00","07:20:00","17:00:00","07:20:00","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF",120,{"$f":"IFERROR(E7+1-D7,0)","v":"14:20:00"},{"$f":"IFERROR(G7+1-F7,0)","v":"14:20:00"},{"$f":"IFERROR(I7+1-H7,0)","v":"14:20:00"},{"$f":"IFERROR(K7+1-J7,0)","v":"00:00:00"},{"$f":"IFERROR(M7-L7,0)","v":"00:00:00"},{"$f":"IFERROR(O7-N7,0)","v":"00:00:00"},{"$f":"IFERROR(Q7-P7,0)","v":"00:00:00"},43,{"$f":"(R7/60)*(COUNT(D7:Q7)/2)","v":6},{"$f":"Z7-AA7","v":{"v":37,"d":"37.0"}}]
["Driver E","Central ","Day Shift","07:00:00","17:00:00","07:00:00","14:00:00","07:00:00","13:00:00","07:00:00","14:00:00","OFF","OFF","OFF","OFF","07:00:00","17:00:00",45,{"$f":"IFERROR(E8-D8,0)","v":"10:00:00"},{"$f":"IFERROR(G8-F8,0)","v":"07:00:00"},{"$f":"IFERROR(I8-H8,0)","v":"06:00:00"},{"$f":"IFERROR(K8-J8,0)","v":"07:00:00"},{"$f":"IFERROR(M8-L8,0)","v":"00:00:00"},{"$f":"IFERROR(O8-N8,0)","v":"00:00:00"},{"$f":"IFERROR(Q8-P8,0)","v":"10:00:00"},40,{"$f":"(R8/60)*(COUNT(D8:Q8)/2)-(R8/60)","v":3},{"$f":"Z8-AA8","v":{"v":37,"d":"37.0"}}]
["Driver F","Eastern","Day Shift","OFF","OFF","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","14:00:00","OFF","OFF",45,{"$f":"IFERROR(E9-D9,0)","v":"00:00:00"},{"$f":"IFERROR(G9-F9,0)","v":"08:30:00"},{"$f":"IFERROR(I9-H9,0)","v":"08:30:00"},{"$f":"IFERROR(K9-J9,0)","v":"08:30:00"},{"$f":"IFERROR(M9-L9,0)","v":"08:30:00"},{"$f":"IFERROR(O9-N9,0)","v":"06:00:00"},{"$f":"IFERROR(Q9-P9,0)","v":"00:00:00"},40,3,{"v":37,"d":"37.0"}]
["Driver G"," Central","Night Shift","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","17:00:00","07:00:00",120,{"$f":"IFERROR(E10+1-D10,0)","v":"00:00:00"},{"$f":"IFERROR(G10+1-F10,0)","v":"00:00:00"},{"$f":"IFERROR(I10+1-H10,0)","v":"00:00:00"},{"$f":"IFERROR(K10+1-J10,0)","v":"00:00:00"},{"$f":"IFERROR(M10+1-L10,0)","v":"00:00:00"},{"$f":"IFERROR(O10+1-N10,0)","v":"00:00:00"},{"$f":"IFERROR(Q10+1-P10,0)","v":"14:00:00"},14,0,{"v":14,"d":"14.0"}]
["Driver H"," South C","Day Shift","OFF","OFF","07:00:00","17:00:00","07:00:00","17:00:00","09:30:00","17:00:00","09:30:00","17:00:00","12:00:00","17:00:00","OFF","OFF",45,{"$f":"IFERROR(E11-D11,0)","v":"00:00:00"},{"$f":"IFERROR(G11-F11,0)","v":"10:00:00"},{"$f":"IFERROR(I11-H11,0)","v":"10:00:00"},{"$f":"IFERROR(K11-J11,0)","v":"07:30:00"},{"$f":"IFERROR(M11-L11,0)","v":"07:30:00"},{"$f":"IFERROR(O11-N11,0)","v":"05:00:00"},{"$f":"IFERROR(Q11-P11,0)","v":"00:00:00"},{"v":40.00000000000001,"d":"40"},3,{"$f":"Z11-AA11","v":{"v":37.00000000000001,"d":"37.0"}}]
["Driver I"," South C","Night Shift","17:00:00","07:20:00","17:00:00","07:20:00","17:00:00","07:20:00","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF",120,{"$f":"IFERROR(E12+1-D12,0)","v":"14:20:00"},{"$f":"IFERROR(G12+1-F12,0)","v":"14:20:00"},{"$f":"IFERROR(I12+1-H12,0)","v":"14:20:00"},{"$f":"IFERROR(K12+1-J12,0)","v":"00:00:00"},{"$f":"IFERROR(M12-L12,0)","v":"00:00:00"},{"$f":"IFERROR(O12-N12,0)","v":"00:00:00"},{"$f":"IFERROR(Q12-P12,0)","v":"00:00:00"},43,{"$f":"(R12/60)*(COUNT(D12:Q12)/2)","v":6},{"$f":"Z12-AA12","v":{"v":37,"d":"37.0"}}]
["Driver J"," South C","Night Shift","OFF","OFF","OFF","OFF","OFF","OFF","17:00:00","07:20:00","17:00:00","07:20:00","17:00:00","07:20:00","OFF","OFF",120,{"$f":"IFERROR(E13+1-D13,0)","v":"00:00:00"},{"$f":"IFERROR(G13+1-F13,0)","v":"00:00:00"},{"$f":"IFERROR(I13+1-H13,0)","v":"00:00:00"},{"$f":"IFERROR(K13+1-J13,0)","v":"14:20:00"},{"$f":"IFERROR(M13+1-L13,0)","v":"14:20:00"},{"$f":"IFERROR(O13+1-N13,0)","v":"14:20:00"},{"$f":"IFERROR(Q13+1-P13,0)","v":"00:00:00"},43,{"$f":"(R13/60)*(COUNT(D13:Q13)/2)","v":6},{"$f":"Z13-AA13","v":{"v":37,"d":"37.0"}}]
["Driver K"," South C","Day Shift","OFF","OFF","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","14:00:00","OFF","OFF",45,{"$f":"IFERROR(E14-D14,0)","v":"00:00:00"},{"$f":"IFERROR(G14-F14,0)","v":"08:30:00"},{"$f":"IFERROR(I14-H14,0)","v":"08:30:00"},{"$f":"IFERROR(K14-J14,0)","v":"08:30:00"},{"$f":"IFERROR(M14-L14,0)","v":"08:30:00"},{"$f":"IFERROR(O14-N14,0)","v":"06:00:00"},{"$f":"IFERROR(Q14+1-P14,0)","v":"00:00:00"},40,3,{"v":37,"d":"37.0"}]
["Driver L"," South C","Day Shift","07:00:00","17:00:00","OFF","OFF","OFF","OFF","07:00:00","14:00:00","07:00:00","14:00:00","07:00:00","13:00:00","07:00:00","17:00:00",45,{"$f":"IFERROR(E15-D15,0)","v":"10:00:00"},{"$f":"IFERROR(G15-F15,0)","v":"00:00:00"},{"$f":"IFERROR(I15-H15,0)","v":"00:00:00"},{"$f":"IFERROR(K15-J15,0)","v":"07:00:00"},{"$f":"IFERROR(M15-L15,0)","v":"07:00:00"},{"$f":"IFERROR(O15-N15,0)","v":"06:00:00"},{"$f":"IFERROR(Q15-P15,0)","v":"10:00:00"},40,3,{"v":37,"d":"37.0"}]
["Driver M"," South C","Night Shift","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","OFF","17:00:00","07:00:00",120,{"$f":"IFERROR(E16+1-D16,0)","v":"00:00:00"},{"$f":"IFERROR(G16+1-F16,0)","v":"00:00:00"},{"$f":"IFERROR(I16+1-H16,0)","v":"00:00:00"},{"$f":"IFERROR(K16+1-J16,0)","v":"00:00:00"},{"$f":"IFERROR(M16+1-L16,0)","v":"00:00:00"},{"$f":"IFERROR(O16+1-N16,0)","v":"00:00:00"},{"$f":"IFERROR(Q16+1-P16,0)","v":"14:00:00"},14,0,{"$f":"Z16-AA16","v":{"v":14,"d":"14.0"}}]
["Driver N"," Central","Day Shift","OFF","OFF","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","16:30:00","08:00:00","14:00:00","OFF","OFF",45,{"$f":"IFERROR(E17-D17,0)","v":"00:00:00"},{"$f":"IFERROR(G17-F17,0)","v":"08:30:00"},{"$f":"IFERROR(I17-H17,0)","v":"08:30:00"},{"$f":"IFERROR(K17-J17,0)","v":"08:30:00"},{"$f":"IFERROR(M17-L17,0)","v":"08:30:00"},{"$f":"IFERROR(O17-N17,0)","v":"06:00:00"},{"$f":"IFERROR(Q17-P17,0)","v":"00:00:00"},40,{"$f":"(R17/60)*(COUNT(D17:Q17)/2)-(R17/60)","v":3},{"$f":"Z17-AA17","v":{"v":37,"d":"37.0"}}]
[]
[null,"KEY"]
[null,"AL - Annual Leave"]
[null,"OFF - Day off"]