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

{"sheet":"Weekly Time Record","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[2,1,2,6],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,3,5,4],[5,7,5,8],[6,3,6,4],[6,7,6,8],[7,3,7,4],[7,7,7,8],[21,1,21,6],[21,7,21,8],[22,1,22,6],[22,7,22,8],[23,1,23,6],[23,7,23,8],[24,1,24,6],[24,7,24,8]]}
[]
[]
[null,"WEEKLY TIME RECORD"]
[null,"MODERN DESIGN CO"]
[]
[null,"EMPLOYEE:",null,"Miguel Reyes",null,null,"EMPLOYEE PHONE:","(805) 555-0123"]
[null,"MANAGER:",null,"Jyeshta Davgar",null,null,"EMPLOYEE E-MAIL:","miguel@example.com"]
[{"$nulls":6},"WEEK ENDING:",{"$f":"TODAY()","v":"2023-02-09"}]
[]
[null,"DAY"," ","DATE","REGULAR HOURS","OVERTIME HOURS","SICK","VACATION","TOTAL"]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Friday"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-6), \"\")","v":"2023-02-03"},{"$nulls":4},{"$f":"IFERROR(SUM(E11:H11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Saturday"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-5), \"\")","v":"2023-02-04"},{"$nulls":4},{"$f":"IFERROR(SUM(E12:H12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Sunday"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-4), \"\")","v":"2023-02-05"},{"$nulls":4},{"$f":"IFERROR(SUM(E13:H13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Monday"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-3), \"\")","v":"2023-02-06"},{"$nulls":4},{"$f":"IFERROR(SUM(E14:H14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Tuesday"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-2), \"\")","v":"2023-02-07"},{"$nulls":4},{"$f":"IFERROR(SUM(E15:H15), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Wednesday"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-1), \"\")","v":"2023-02-08"},{"$nulls":4},{"$f":"IFERROR(SUM(E16:H16), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Thursday"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8), \"\")","v":"2023-02-09"},{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TOTAL HOURS",{"$f":"IFERROR(SUM(TimeSheet[REGULAR HOURS]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(TimeSheet[OVERTIME HOURS]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(TimeSheet[SICK]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(TimeSheet[VACATION]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(TimeSheet[TOTAL]), \"\")","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"RATE PER HOUR"]
[{"$nulls":3},"TOTAL PAY",{"$f":"IFERROR(E18*E19, \"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(F18*F19, \"\")","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[]
[null,"EMPLOYEE SIGNATURE",{"$nulls":5},"DATE"]
[]
[null,"MANAGER SIGNATURE",{"$nulls":5},"DATE"]