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

{"sheet":"Weekly time record","index":0,"n_rows":24,"n_cols":9,"rows_kept":24,"merged":[[0,5,0,8],[1,1,1,3],[3,2,3,3],[3,7,3,8],[4,2,4,3],[4,7,4,8],[5,7,5,8],[6,2,6,3],[8,1,8,2],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[20,3,20,7],[22,3,22,7]]}
[{"$nulls":5},"Weekly time record"]
[null,"[Company Name]"]
[]
[null,"Employee:",{"$nulls":3},"Employee phone:"]
[null,"Manager:",{"$nulls":3},"Employee email:"]
[]
[null,"Week ending:"]
[]
[null,"Day",null,"Regular Hours","Overtime ","Sick","Vacation",null,"Total"]
[null,"Monday",{"$f":"IF($C$7=0,\"\",$C$7-6)","v":""},{"$nulls":5},{"$f":"IF(SUM(D10:G10)>24,\"Total > 24 hours.\",SUM(D10:G10))","v":{"v":0,"d":"0.00"}}]
[null,"Tuesday",{"$f":"IF($C$7=0,\"\",$C$7-5)","v":""},{"$nulls":5},{"$f":"IF(SUM(D11:G11)>24,\"Total > 24 hours.\",SUM(D11:G11))","v":{"v":0,"d":"0.00"}}]
[null,"Wednesday",{"$f":"IF($C$7=0,\"\",$C$7-4)","v":""},{"$nulls":5},{"$f":"IF(SUM(D12:G12)>24,\"Total > 24 hours.\",SUM(D12:G12))","v":{"v":0,"d":"0.00"}}]
[null,"Thursday",{"$f":"IF($C$7=0,\"\",$C$7-3)","v":""},{"$nulls":5},{"$f":"IF(SUM(D13:G13)>24,\"Total > 24 hours.\",SUM(D13:G13))","v":{"v":0,"d":"0.00"}}]
[null,"Friday",{"$f":"IF($C$7=0,\"\",$C$7-2)","v":""},{"$nulls":5},{"$f":"IF(SUM(D14:G14)>24,\"Total > 24 hours.\",SUM(D14:G14))","v":{"v":0,"d":"0.00"}}]
[null,"Saturday",{"$f":"IF($C$7=0,\"\",$C$7-1)","v":""},{"$nulls":5},{"$f":"IF(SUM(D15:G15)>24,\"Total > 24 hours.\",SUM(D15:G15))","v":{"v":0,"d":"0.00"}}]
[null,"Sunday",{"$f":"IF($C$7=0,\"\",$C$7)","v":""},{"$nulls":5},{"$f":"IF(SUM(D16:G16)>24,\"Total > 24 hours.\",SUM(D16:G16))","v":{"v":0,"d":"0.00"}}]
[null,null,"Total hours",{"$f":"SUM(D10:D16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E10:E16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F10:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G10:G16)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(I10:I16)","v":{"v":0,"d":"0.00"}}]
[null,null,"Rate per hour"]
[null,null,"Total pay",{"$f":"D17*D18","v":{"v":0,"d":"$0.00"}},{"$f":"E17*E18","v":{"v":0,"d":"$0.00"}},{"$f":"F17*F18","v":{"v":0,"d":"$0.00"}},{"$f":"G17*G18","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D19:G19)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":3},"Employee signature",{"$nulls":4},"Date"]
[]
[{"$nulls":3},"Manager signature",{"$nulls":4},"Date"]