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

{"sheet":"TimeSheet","index":0,"n_rows":33,"n_cols":12,"rows_kept":33,"merged":[[1,1,1,5],[1,6,1,11],[3,1,3,3],[3,6,3,7],[3,8,3,9],[4,1,4,3],[4,6,4,7],[4,8,4,9],[5,1,5,3],[5,6,5,7],[5,8,5,9],[6,1,6,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[32,6,32,9],[32,10,32,11]]}
[]
[null,"TIME SHEET",{"$nulls":4},"NOD PUBLISHERS"]
[]
[null,"222 2nd Ave",{"$nulls":4},"Employee name:",null,"Shir Rosenstein"]
[null,"Apt. 100",{"$nulls":4},"Manager name:",null,"Naoki Kaneko"]
[null,"Bellevue, WA 54321",{"$nulls":4},"Week starting:",null,{"$f":"TODAY()","v":"2023-02-09"}]
[null,"(502) 555-0123"]
[]
[null,"Day of week","Time in","Breaks\n(minutes)","Time out",null,"Total\n[h]:mm","Regular\n[h]:mm","Overtime\n[h]:mm","Sick\n[h]:mm","Holiday\n[h]:mm","Vacation\n[h]:mm"]
[null,{"$f":"Week_Starting","v":"2023-02-09"},"09:05:00",15,"18:00:00",null,{"$f":"MROUND((IF(OR(C10=\"\",E10=\"\"),0,IF(E10<C10,E10+1-C10,E10-C10))-D10/1440),1/1440)","v":0.3611111111111111},0.3333333333333333,0.02777777777777779]
[null,{"$f":"B10+1","v":"2023-02-10"},"09:05:00",30,"17:45:00",null,{"$f":"MROUND((IF(OR(C11=\"\",E11=\"\"),0,IF(E11<C11,E11+1-C11,E11-C11))-D11/1440),1/1440)","v":0.3402777777777778},0.3333333333333333,0.006944444444444475]
[null,"2023-02-11","09:00:00",45,"18:30:00",null,0.36458333333333337,0.3333333333333333,0.031250000000000056]
[null,"2023-02-12","09:00:00",45,"18:30:00",null,0.36458333333333337,0.3333333333333333,0.031250000000000056]
[null,"2023-02-13",{"$nulls":4},0,null,null,0.3333333333333333]
[null,"2023-02-14",{"$nulls":4},0]
[null,"2023-02-15",{"$nulls":4},0]
[{"$nulls":6},"Total",{"$f":"SUM(H10:H16)","v":1.3333333333333333},{"$f":"SUM(I10:I16)","v":0.09722222222222238},{"$f":"SUM(J10:J16)","v":0.3333333333333333},{"$f":"SUM(K10:K16)","v":0},{"$f":"SUM(L10:L16)","v":0}]
[]
[null,"Day of week","Time in","Breaks\n(minutes)","Time out",null,"Total\n[h]:mm","Regular\n[h]:mm","Overtime\n[h]:mm","Sick\n[h]:mm","Holiday\n[h]:mm","Vacation\n[h]:mm"]
[null,{"$f":"B16+1","v":"2023-02-16"},{"$nulls":4},{"$f":"MROUND((IF(OR(C20=\"\",E20=\"\"),0,IF(E20<C20,E20+1-C20,E20-C20))-D20/1440),1/1440)","v":0}]
[null,{"$f":"B20+1","v":"2023-02-17"},{"$nulls":4},{"$f":"MROUND((IF(OR(C21=\"\",E21=\"\"),0,IF(E21<C21,E21+1-C21,E21-C21))-D21/1440),1/1440)","v":0}]
[null,"2023-02-18",{"$nulls":4},0]
[null,"2023-02-19",{"$nulls":4},0]
[null,"2023-02-20",{"$nulls":4},0]
[null,"2023-02-21",{"$nulls":4},0]
[null,"2023-02-22",{"$nulls":4},0]
[{"$nulls":6},"Total",{"$f":"SUM(H20:H26)","v":0},{"$f":"SUM(I20:I26)","v":0},{"$f":"SUM(J20:J26)","v":0},{"$f":"SUM(K20:K26)","v":0},{"$f":"SUM(L20:L26)","v":0}]
[]
[{"$nulls":6}," ","Regular","Overtime","Sick","Holiday","Vacation"]
[{"$nulls":6},"Rate/hr:",{"v":15,"d":"15.00"},{"$f":"1.5*H30","v":{"v":22.5,"d":"22.50"}},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"}]
[null,"Employee Signature",null,null,"Date",null,"Total pay:",{"$f":"ROUND((H27+H17)*24*H30,2)","v":{"v":480,"d":"480.00"}},{"$f":"ROUND((I27+I17)*24*I30,2)","v":{"v":52.5,"d":"52.50"}},{"$f":"ROUND((J27+J17)*24*J30,2)","v":{"v":120,"d":"120.00"}},{"$f":"ROUND((K27+K17)*24*K30,2)","v":0},{"$f":"ROUND((L27+L17)*24*L30,2)","v":0}]
[]
[null,"Manager Signature",null,null,"Date",null,"Grand total pay:",{"$nulls":3},{"$f":"SUM(H31:L31)","v":{"v":652.5,"d":"652.50"}}]