{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Timesheet"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Timesheet","index":0,"n_rows":41,"n_cols":21,"rows_kept":41,"merged":[[0,0,0,20],[34,8,34,9],[36,8,36,9]]}
[" TIME RECORDING DOCUMENT"]
["Date From :","2024-05-01",null,null,"Contractor's "]
["Date to :","2024-05-31",null,null,"Name: ",{"$nulls":3},"No:",null,null,"Client :",{"$nulls":7},"                ","                "]
[null,{"$f":"TEXT(B5,\"ddd\")","v":"Wed"},{"$f":"TEXT(C5,\"ddd\")","v":"Thu"},"Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat"]
["DATE",{"$f":"B2","v":"2024-05-01"},{"$f":"B5+1","v":"2024-05-02"},{"$f":"C5+1","v":"2024-05-03"},"2024-05-04","2024-05-05","2024-05-06","2024-05-07","2024-05-08","2024-05-09","2024-05-10","2024-05-11","2024-05-12","2024-05-13","2024-05-14","2024-05-15","2024-05-16","2024-05-17","2024-05-18"]
["Start:           HH:MM"]
["End              HH:MM",{"$nulls":18},"SUB TOTAL"]
["Lunch",{"$nulls":18},{"$f":"SUM(B8:S8)","v":0},"Lunch"]
["Time not worked",{"$nulls":18},{"$f":"SUM(B9:S9)","v":0},"Not Worked"]
["Normal Hours",{"$f":"SUM(B7-B6-B8-B9)","v":"00:00:00"},{"$f":"SUM(C7-C6-C8-C9)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"SUM(B10:S10)","v":0},"Normal"]
["Additional Hrs @ 1.0",{"$nulls":18},{"$f":"SUM(B11:S11)","v":0},"1.0"]
["Additional Hrs @ 1.2",{"$nulls":18},0,{"v":1.2,"d":"1.20"}]
["Additional Hrs @ 1.33",{"$nulls":18},0,{"v":1.333,"d":"1.33"}]
["Additional Hrs @ 1.5",{"$nulls":18},0,{"v":1.5,"d":"1.50"}]
["Additional Hrs @ 2.0",{"$nulls":18},0,{"v":2,"d":"2.00"}]
["Callout Hours",{"$nulls":18},0,"Callout"]
["Standby ",{"$nulls":18},0,"Standby"]
["Weekly Authorisation"]
[null,{"$f":"TEXT(B20,\"ddd\")","v":"Sun"},{"$f":"TEXT(C20,\"ddd\")","v":"Mon"},"Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed"]
["DATE",{"$f":"S5+1","v":"2024-05-19"},{"$f":"B20+1","v":"2024-05-20"},{"$f":"C20+1","v":"2024-05-21"},"2024-05-22","2024-05-23","2024-05-24","2024-05-25","2024-05-26","2024-05-27","2024-05-28","2024-05-29","2024-05-30","2024-05-31","2024-06-01","2024-06-02","2024-06-03","2024-06-04","2024-06-05"]
["Start:           HH:MM"]
["End              HH:MM",{"$nulls":18},"SUB TOTAL"]
["Lunch",{"$nulls":18},{"$f":"SUM(B23:S23)","v":0},"Lunch"]
["Time not worked",{"$nulls":18},{"$f":"SUM(B24:S24)","v":0},"Not Worked"]
["Normal Hours",{"$f":"SUM(B22-B21-B23-B24)","v":"00:00:00"},{"$f":"SUM(C22-C21-C23-C24)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"SUM(M22-M21-M23-M24)","v":"00:00:00"},"00:00:00",{"$f":"SUM(O22-O21-O23-O24)","v":"00:00:00"},{"$f":"SUM(P22-P21-P23-P24)","v":"00:00:00"},{"$f":"SUM(Q22-Q21-Q23-Q24)","v":"00:00:00"},{"$f":"SUM(R22-R21-R23-R24)","v":"00:00:00"},{"$f":"SUM(S22-S21-S23-S24)","v":"00:00:00"},{"$f":"SUM(B25:S25)","v":0},"Normal"]
["Additional Hrs @ 1.0",{"$nulls":18},{"$f":"SUM(B26:S26)","v":0},"1.0"]
["Additional Hrs @ 1.2",{"$nulls":18},0,{"v":1.2,"d":"1.20"}]
["Additional Hrs @ 1.33",{"$nulls":18},0,{"v":1.333,"d":"1.33"}]
["Additional Hrs @ 1.5",{"$nulls":18},0,{"v":1.5,"d":"1.50"}]
["Additional Hrs @ 2.0",{"$nulls":18},0,{"v":2,"d":"2.00"}]
["Callout Hours",{"$nulls":18},0,"Callout"]
["Standby Hours",{"$nulls":13}," "," "," "," "," ",0,"Standby"]
["Weekly Authorisation"]
[{"$nulls":18},"Total"]
["TOTAL NORMAL HOURS",{"$f":"SUM(T10+T25)","v":0},{"$nulls":3},"ADDTNL HRS @ 1.0",{"$f":"(T11+T26)","v":0},null,"TOTAL CALLOUT HOURS",null,{"$f":"T16+T31","v":0},{"$nulls":3},"NO. OF STANDBY",null,{"$f":"Q36","v":"@"},null,{"$f":"P35*R35","v":{"v":0,"d":"0.00"}},"Rands"]
[{"$nulls":5},"ADDTNL HRS @ 1.2",{"$f":"(T12+T27)","v":0},{"$nulls":7},"NO. OF STANDBY",null,"@",null,{"$f":"P36*R36","v":{"v":0,"d":"0.00"}},"Rands"]
[0,"KM's @",{"$nulls":3},"ADDTNL HRS @ 1.3",{"$f":"(T13+T28)","v":0},null,"TOTAL STANDBY HOURS",null,{"$f":"T17+T32","v":0},{"$nulls":3},"NO. OF STANDBY",null,"@",null,{"$f":"P37*R37","v":{"v":0,"d":"0.00"}},"Rands"]
[{"v":0,"d":"R 0.00"},"=",{"$f":"A37*A38","v":{"v":0,"d":"R 0.00"}},null,null,"ADDTNL HRS @ 1.5",{"$f":"(T14+T29)","v":0}]
[{"$nulls":5},"ADDTNL HRS @ 2.0",{"$f":"(T15+T30)","v":0}]
[{"$nulls":18},"Cost Centre:"]
[{"$nulls":8},"Contractor Signature",{"$nulls":6},"Cost Centre Manager"]