{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Weekly Time Record"],"not_rendered":{"images":4},"read":"whole","date_system":"1900"}

{"sheet":"Weekly Time Record","index":0,"n_rows":28,"n_cols":9,"rows_kept":28,"merged":[[11,2,11,3],[13,1,13,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[27,5,27,6],[28,5,28,6]]}
[]
[null,null,"RPE Gym",{"$nulls":5}," "]
[null,null,"Weekly time record"]
[]
[null,"Employee name",{"$nulls":3},"Manager"]
[null,"Natasha Jones",{"$nulls":3},"Ravi Costa"]
[]
[null,"Employee address ",{"$nulls":3},"Contact details"]
[null,"321 Sycamore St.",{"$nulls":3},"(123) 456-7890"]
[null,"Albany, NY 12345",{"$nulls":3},"natasha@example.com"]
[]
[null,"Week ending:",{"$f":"TODAY()-WEEKDAY(TODAY(),1)","v":"2022-12-10"}]
[]
[null,"Day",null,"Regular \nhours","Overtime hours","Sick","Vacation","Total"]
[null,"Monday",{"$f":"IF($C$12=0,\"\",$C$12-6)","v":"2022-12-04"},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"SUM(D15:G15)","v":{"v":8,"d":"8.00"}}]
[null,"Tuesday",{"$f":"IF($C$12=0,\"\",$C$12-5)","v":"2022-12-05"},{"v":8,"d":"8.00"},{"$nulls":3},{"v":8,"d":"8.00"}]
[null,"Wednesday",{"$f":"IF($C$12=0,\"\",$C$12-4)","v":"2022-12-06"},{"v":8,"d":"8.00"},{"$nulls":3},{"v":8,"d":"8.00"}]
[null,"Thursday",{"$f":"IF($C$12=0,\"\",$C$12-3)","v":"2022-12-07"},{"v":6,"d":"6.00"},null,{"v":2,"d":"2.00"},null,{"v":8,"d":"8.00"}]
[null,"Friday",{"$f":"IF($C$12=0,\"\",$C$12-2)","v":"2022-12-08"},{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"v":10,"d":"10.00"}]
[null,"Saturday",{"$f":"IF($C$12=0,\"\",$C$12-1)","v":"2022-12-09"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"Sunday",{"$f":"IF($C$12=0,\"\",$C$12)","v":"2022-12-10"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"}]
[]
[null,"Total hours",null,{"$f":"SUM(D15:D21)","v":{"v":38,"d":"38.00"}},{"$f":"SUM(E15:E21)","v":{"v":2,"d":"2.00"}},{"$f":"SUM(F15:F21)","v":{"v":2,"d":"2.00"}},{"$f":"SUM(G15:G21)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H15:H21)","v":{"v":42,"d":"42.00"}}]
[null,"Rate per hour",null,{"v":25,"d":"$25.00"}]
[null,"Total pay",null,{"$f":"IFERROR(D23*D24,\"\")","v":{"v":950,"d":"$950.00"}},{"$f":"IFERROR(E23*E24,\"\")","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(D25:G25)","v":{"v":950,"d":"$950.00"}}]
[]
[]
[null,"Employee's signature",null,"Date",null,"Manager's signature",null,"Date"]