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

{"sheet":"Biweekly Time Sheet","index":0,"n_rows":35,"n_cols":12,"rows_kept":35,"merged":[[1,5,1,11],[3,1,3,4],[5,1,5,4],[5,5,5,9],[5,10,5,11],[6,1,6,4],[6,5,6,9],[6,10,6,11],[7,1,7,4],[9,1,9,2],[9,3,9,4],[9,6,9,9],[9,10,9,11],[10,1,10,2],[10,3,10,4],[10,6,10,9],[10,10,10,11],[12,1,12,3],[12,5,12,6],[12,7,12,8],[12,9,12,10],[13,1,13,2],[13,5,13,6],[13,7,13,8],[13,9,13,10],[14,1,14,2],[14,5,14,6],[14,7,14,8],[14,9,14,10],[15,1,15,2],[15,5,15,6],[15,7,15,8],[15,9,15,10],[16,1,16,2],[16,5,16,6],[16,7,16,8],[16,9,16,10],[17,1,17,2],[17,5,17,6],[17,7,17,8],[17,9,17,10],[18,1,18,2],[18,5,18,6],[18,7,18,8],[18,9,18,10],[19,1,19,2],[19,5,19,6],[19,7,19,8],[19,9,19,10],[20,1,20,2],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,1,21,2],[21,5,21,6],[21,7,21,8],[21,9,21,10],[22,1,22,2],[22,5,22,6],[22,7,22,8],[22,9,22,10],[23,1,23,2],[23,5,23,6],[23,7,23,8],[23,9,23,10],[24,1,24,2],[24,5,24,6],[24,7,24,8],[24,9,24,10],[25,1,25,2],[25,5,25,6],[25,7,25,8],[25,9,25,10],[26,1,26,2],[26,5,26,6],[26,7,26,8],[26,9,26,10],[27,5,27,6],[27,7,27,8],[27,9,27,10],[28,5,28,6],[28,7,28,8],[28,9,28,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[31,4,31,9],[31,10,31,11],[32,4,32,5],[33,4,33,9],[33,10,33,11],[34,4,34,5]]}
[]
[{"$nulls":5},"Biweekly Time Sheet"]
[]
[null,"[Company Name]"]
[]
[null,"[Street Address]",{"$nulls":3},"Pay period start date:",{"$nulls":4},"2018-11-01"]
[null,"[Address 2]",{"$nulls":3},"Pay period end date:",{"$nulls":4},{"$f":"IF($K$6=\"\",\"\",$K$6+13)","v":"2018-11-14"}]
[null,"[City, ST  ZIP Code]"]
[]
[null,"Employee:",{"$nulls":4},"Employee phone:"]
[null,"Manager:",{"$nulls":4},"Employee e-mail:"]
[]
[null,"Day",null,null,"Regular Hours","Overtime Hours",null,"Sick",null,"Vacation",null,"Total"]
[null,"Monday",null,{"$f":"K6","v":"2018-11-01"},{"$nulls":7},{"$f":"IF(SUM(E14:K14)>24,\"You've entered more than 24 hours.\",SUM(E14:K14))","v":{"v":0,"d":"0.00"}}]
[null,"Tuesday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+1)","v":"2018-11-02"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Wednesday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+2)","v":"2018-11-03"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Thursday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+3)","v":"2018-11-04"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Friday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+4)","v":"2018-11-05"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Saturday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+5)","v":"2018-11-06"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Sunday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+6)","v":"2018-11-07"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Monday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+7)","v":"2018-11-08"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Tuesday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+8)","v":"2018-11-09"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Wednesday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+9)","v":"2018-11-10"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Thursday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+10)","v":"2018-11-11"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Friday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+11)","v":"2018-11-12"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Saturday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+12)","v":"2018-11-13"},{"$nulls":7},{"v":0,"d":"0.00"}]
[null,"Sunday",null,{"$f":"IF($K$6=\"\",\"\",$K$6+13)","v":"2018-11-14"},{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":3},"Total hours",{"$f":"SUM(E14:E27)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F14:F27)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(H14:H27)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J14:J27)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(L14:L27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Rate per hour"]
[{"$nulls":3},"Total pay",{"$f":"E28*E29","v":{"v":0,"d":"$0.00"}},{"$f":"F28*F29","v":{"v":0,"d":"$0.00"}},null,{"$f":"H28*H29","v":{"v":0,"d":"$0.00"}},null,{"$f":"J28*J29","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(E30:J30)","v":{"v":0,"d":"$0.00"}}]
[]
[]
[{"$nulls":4},"Employee signature",{"$nulls":5},"Date"]
[]
[{"$nulls":4},"Manager signature",{"$nulls":5},"Date"]