{"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":21,"n_cols":8,"rows_kept":21,"merged":[[0,1,0,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[4,2,4,3],[17,3,17,6],[18,3,18,6],[19,3,19,6],[20,3,20,6]]}
[null,"Weekly Time Record"]
[null,"Company Name"]
[null,"Employee:",{"$nulls":3},"Employee phone:"]
[null,"Manager:",{"$nulls":3},"Employee e-mail:"]
[null,"Week ending:",{"$f":"TODAY()","v":"2017-09-25"}]
[]
[null,"Day","Date","Regular Hours","Overtime Hours","Sick","Vacation","Total"]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"), \"\")","v":"Tuesday"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-6), \"\")","v":"2017-09-19"},{"$nulls":4},{"$f":"IFERROR(SUM(D8:G8), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"), \"\")","v":"Wednesday"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-5), \"\")","v":"2017-09-20"},{"$nulls":4},{"$f":"IFERROR(SUM(D9:G9), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"), \"\")","v":"Thursday"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-4), \"\")","v":"2017-09-21"},{"$nulls":4},{"$f":"IFERROR(SUM(D10:G10), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"), \"\")","v":"Friday"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-3), \"\")","v":"2017-09-22"},{"$nulls":4},{"$f":"IFERROR(SUM(D11:G11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"), \"\")","v":"Saturday"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-2), \"\")","v":"2017-09-23"},{"$nulls":4},{"$f":"IFERROR(SUM(D12:G12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"), \"\")","v":"Sunday"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5-1), \"\")","v":"2017-09-24"},{"$nulls":4},{"$f":"IFERROR(SUM(D13:G13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(TimeSheet[[#This Row],[Date]],\"aaaa\"), \"\")","v":"Monday"},{"$f":"IFERROR(IF($C$5=0,\"\",$C$5), \"\")","v":"2017-09-25"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"Total hours",{"$f":"IFERROR(SUM(D8:D14), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(E8:E14), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(F8:F14), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(G8:G14), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(H8:H14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,null,"Rate per hour"]
[null,null,"Total pay",{"$f":"IFERROR(D15*D16, \"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(E15*E16, \"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(F15*F16, \"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(G15*G16, \"\")","v":{"v":0,"d":"$0"}},{"$f":"IFERROR(SUM(D17:G17), \"\")","v":{"v":0,"d":"$0"}}]
[]
[{"$nulls":3},"Employee signature",{"$nulls":3},"Date"]
[]
[{"$nulls":3},"Manager signature",{"$nulls":3},"Date"]