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

{"sheet":"Weekly Time Sheet","index":0,"n_rows":20,"n_cols":19,"rows_kept":20,"merged":[[0,11,0,18],[1,2,1,10],[3,3,3,7],[3,10,3,11],[3,12,3,14],[3,16,3,17],[3,18,3,19],[4,3,4,7],[4,10,4,11],[4,12,4,14],[4,16,4,17],[4,18,4,19],[5,3,5,7],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,17],[8,18,9,18],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[9,16,9,17],[10,2,10,3],[11,2,11,3],[13,2,13,3],[13,18,14,18],[14,2,14,3],[15,2,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[15,16,15,17],[18,3,18,7],[18,8,18,9],[18,12,18,16],[18,17,18,18]]}
[{"$nulls":11},"Weekly Time Sheet With Breaks"]
[null,null,"[Company Name]"]
[]
[{"$nulls":3},"[Street Address]",{"$nulls":6},"Employee name:",{"$nulls":5},"Week starting:",null,"2017-05-29"]
[{"$nulls":3},"[Street Address 2]",{"$nulls":6},"Manager name:",{"$nulls":5},"Week ending:",null,{"$f":"IF($S$4=0,\"\",$S$4+6)","v":"2017-06-04"}]
[{"$nulls":3},"[City, ST  ZIP Code]"]
[]
[]
[{"$nulls":4},"Sunday",null,"Monday",null,"Tuesday",null,"Wednesday",null,"Thursday",null,"Friday",null,"Saturday"]
[{"$nulls":4},{"$f":"IF($S$4=0,\"\",$S$4)","v":"2017-05-29"},null,{"$f":"IF($S$4=0,\"\",$S$4+1)","v":"2017-05-30"},null,{"$f":"IF($S$4=0,\"\",$S$4+2)","v":"2017-05-31"},null,{"$f":"IF($S$4=0,\"\",$S$4+3)","v":"2017-06-01"},null,{"$f":"IF($S$4=0,\"\",$S$4+4)","v":"2017-06-02"},null,{"$f":"IF($S$4=0,\"\",$S$4+5)","v":"2017-06-03"},null,{"$f":"IF($S$4=0,\"\",$S$4+6)","v":"2017-06-04"}]
[null,null,"Time In",null,null,"Total",null,"Total",null,"Total",null,"Total",null,"Total",null,"Total",null,"Total"]
[null,null,"Time Out",null,null,{"$f":"IF((OR(E12=\"\",E11=\"\")),0,IF((E12<E11),((E12-E11)*24)+24,(E12-E11)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(G12=\"\",G11=\"\")),0,IF((G12<G11),((G12-G11)*24)+24,(G12-G11)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(I12=\"\",I11=\"\")),0,IF((I12<I11),((I12-I11)*24)+24,(I12-I11)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(K12=\"\",K11=\"\")),0,IF((K12<K11),((K12-K11)*24)+24,(K12-K11)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(M12=\"\",M11=\"\")),0,IF((M12<M11),((M12-M11)*24)+24,(M12-M11)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(O12=\"\",O11=\"\")),0,IF((O12<O11),((O12-O11)*24)+24,(O12-O11)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(Q12=\"\",Q11=\"\")),0,IF((Q12<Q11),((Q12-Q11)*24)+24,(Q12-Q11)*24))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Meal Break"]
[null,null,"Time In",null,null,"Total",null,"Total",null,"Total",null,"Total",null,"Total",null,"Total",null,"Total","Total Hours Scheduled"]
[null,null,"Time Out",null,null,{"$f":"IF((OR(E15=\"\",E14=\"\")),0,IF((E15<E14),((E15-E14)*24)+24,(E15-E14)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(G15=\"\",G14=\"\")),0,IF((G15<G14),((G15-G14)*24)+24,(G15-G14)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(I15=\"\",I14=\"\")),0,IF((I15<I14),((I15-I14)*24)+24,(I15-I14)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(K15=\"\",K14=\"\")),0,IF((K15<K14),((K15-K14)*24)+24,(K15-K14)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(M15=\"\",M14=\"\")),0,IF((M15<M14),((M15-M14)*24)+24,(M15-M14)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(O15=\"\",O14=\"\")),0,IF((O15<O14),((O15-O14)*24)+24,(O15-O14)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(Q15=\"\",Q14=\"\")),0,IF((Q15<Q14),((Q15-Q14)*24)+24,(Q15-Q14)*24))","v":{"v":0,"d":"0.00"}}]
[null,null,"Total",null,{"$f":"IF(OR(ISTEXT(F12),ISTEXT(F15)),\"Error in C12 or C15\",(F12+F15))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(H12),ISTEXT(H15)),\"Error in C12 or C15\",(H12+H15))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(J12),ISTEXT(J15)),\"Error in C12 or C15\",(J12+J15))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(L12),ISTEXT(L15)),\"Error in C12 or C15\",(L12+L15))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(N12),ISTEXT(N15)),\"Error in C12 or C15\",(N12+N15))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(P12),ISTEXT(P15)),\"Error in C12 or C15\",(P12+P15))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(R12),ISTEXT(R15)),\"Error in C12 or C15\",(R12+R15))","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(E16:R16)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[{"$nulls":3},"Employee signature",{"$nulls":4},"Date",{"$nulls":3},"Manager signature",{"$nulls":4},"Date"]