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

{"sheet":"Time card","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"merged":[[1,1,1,7],[3,2,3,3],[3,6,3,7],[4,2,4,3],[4,6,4,7],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7]]}
[]
[null,"TIME CARD"]
[]
[null,"EMPLOYEE","Itai Gerbi",null,null,"MANAGER","Briana Hernandez"]
[null,"STREET ADDRESS","4567 8th Ave",null,null,"EMPLOYEE PHONE","405-555-0155"]
[null,"ADDRESS 2","Apt 101",null,null,"EMPLOYEE E-MAIL","itai@example.com"]
[null,"CITY, ST  ZIP CODE","Carson City, NV",null,null,"WEEK ENDING",{"$f":"8-WEEKDAY(NOW())+TODAY()","v":"2023-10-15"}]
[]
[null,"DAY","DATE","REGULAR HOURS","SICK ","OVERTIME","VACATION","TOTAL"]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Monday"},{"$f":"IFERROR(IF($G$7=0,\"\",$G$7-6),\"\")","v":"2023-10-09"},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(IF(SUM(D10:G10)>24,\"Total > 24 hours.\",SUM(D10:G10)), \"\")","v":{"v":8,"d":"8.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Tuesday"},{"$f":"IFERROR(IF($G$7=0,\"\",$G$7-5),\"\")","v":"2023-10-10"},{"v":8,"d":"8.00"},null,{"v":2,"d":"2.00"},null,{"$f":"IFERROR(IF(SUM(D11:G11)>24,\"Total > 24 hours.\",SUM(D11:G11)), \"\")","v":{"v":10,"d":"10.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Wednesday"},{"$f":"IFERROR(IF($G$7=0,\"\",$G$7-4),\"\")","v":"2023-10-11"},{"v":2,"d":"2.00"},{"v":3,"d":"3.00"},null,{"v":3,"d":"3.00"},{"v":8,"d":"8.00"}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Thursday"},{"$f":"IFERROR(IF($G$7=0,\"\",$G$7-3),\"\")","v":"2023-10-12"},{"v":8,"d":"8.00"},{"$nulls":3},{"v":8,"d":"8.00"}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Friday"},{"$f":"IFERROR(IF($G$7=0,\"\",$G$7-2),\"\")","v":"2023-10-13"},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Saturday"},{"$f":"IFERROR(IF($G$7=0,\"\",$G$7-1),\"\")","v":"2023-10-14"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[DATE]],\"aaaa\"), \"\")","v":"Sunday"},{"$f":"IFERROR(IF($G$7=0,\"\",$G$7),\"\")","v":"2023-10-15"},{"v":8,"d":"8.00"},{"$nulls":3},{"v":8,"d":"8.00"}]
[null,"Total hours",null,{"$f":"IFERROR(SUM(D10:D16), \"\")","v":{"v":34,"d":"34.00"}},{"$f":"IFERROR(SUM(E10:E16), \"\")","v":{"v":3,"d":"3.00"}},{"$f":"IFERROR(SUM(F10:F16), \"\")","v":{"v":2,"d":"2.00"}},{"$f":"IFERROR(SUM(G10:G16), \"\")","v":{"v":3,"d":"3.00"}},{"$f":"IFERROR(SUM(H10:H16), \"\")","v":{"v":42,"d":"42.00"}}]
[null,"Rate per hour",null,{"v":25,"d":"$25.00"},{"v":25,"d":"$25.00"},{"v":37.5,"d":"$37.50"},{"v":25,"d":"$25.00"}]
[null,"TOTAL PAY",null,{"$f":"IFERROR(D17*D18, \"\")","v":{"v":850,"d":"$850.00"}},{"$f":"IFERROR(E17*E18, \"\")","v":{"v":75,"d":"$75.00"}},{"$f":"IFERROR(F17*F18, \"\")","v":{"v":75,"d":"$75.00"}},{"$f":"IFERROR(G17*G18, \"\")","v":{"v":75,"d":"$75.00"}},{"$f":"IFERROR(SUM(D19:G19), \"\")","v":{"v":1075,"d":"$1,075.00"}}]
[]
[]
[null,"Employee signature",{"$nulls":3},"Date"]
[]
[null,"Manager signature",{"$nulls":3},"Date"]