{"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":8,"rows_kept":35,"merged":[[31,3,31,6],[33,3,33,6]]}
[]
[{"$nulls":7},"BI-WEEKLY TIME SHEET"]
[]
[null,"[Company Name]"]
[]
[null,"Street Address:",{"$nulls":3},"Pay Period Start Date:"]
[null,"Address 2:",{"$nulls":3},"Pay Period End Date:"]
[null,"City, State ZIP:"]
[]
[null,"Employee:",{"$nulls":3},"Employee Phone:"]
[null,"Manager:",{"$nulls":3},"Employee Email:"]
[]
[null,"Day",null,"Regular Hours","Overtime Hours","Sick","Vacation","Total"]
[null,"Monday",{"$f":"IFERROR(IF(H6=\"\",\"\",H6),\"\")","v":""},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IF(SUM(D14:G14)>24,\"You've entered more than 24 hours.\",SUM(D14:G14))","v":{"v":8,"d":"8.00"}}]
[null,"Tuesday",{"$f":"IF($H$6=\"\",\"\",C14+1)","v":""},{"v":8,"d":"8.00"},{"$nulls":3},{"v":8,"d":"8.00"}]
[null,"Wednesday","",{"v":8,"d":"8.00"},{"$nulls":3},{"v":8,"d":"8.00"}]
[null,"Thursday","",{"v":8,"d":"8.00"},{"v":2.5,"d":"2.50"},null,null,{"v":10.5,"d":"10.50"}]
[null,"Friday","",{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"v":10,"d":"10.00"}]
[null,"Saturday","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"Sunday","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"Monday","",{"$nulls":3},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"}]
[null,"Tuesday","",null,null,{"v":8,"d":"8.00"},null,{"v":8,"d":"8.00"}]
[null,"Wednesday","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"Thursday","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"Friday","",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"},null,null,{"v":9,"d":"9.00"}]
[null,"Saturday","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"Sunday","",{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"Total Hours",{"$f":"SUM(D14:D27)","v":{"v":64,"d":"64.00"}},{"$f":"SUM(E14:E27)","v":{"v":7.5,"d":"7.50"}},{"$f":"SUM(F14:F27)","v":{"v":8,"d":"8.00"}},{"$f":"SUM(G14:G27)","v":{"v":8,"d":"8.00"}},{"$f":"SUM(H14:H27)","v":{"v":87.5,"d":"87.50"}}]
[null,null,"Rate Per Hour",{"v":10,"d":"$10.00"},{"$f":"D29*1.5","v":{"v":15,"d":"$15.00"}},{"$f":"D29","v":{"v":10,"d":"$10.00"}},{"$f":"D29","v":{"v":10,"d":"$10.00"}}]
[null,null,"Total Pay",{"$f":"D28*D29","v":{"v":640,"d":"$640.00"}},{"$f":"E28*E29","v":{"v":112.5,"d":"$112.50"}},{"$f":"F28*F29","v":{"v":80,"d":"$80.00"}},{"$f":"G28*G29","v":{"v":80,"d":"$80.00"}},{"$f":"SUM(D30:G30)","v":{"v":912.5,"d":"$912.50"}}]
[]
[]
[{"$nulls":3},"Employee Signature"]
[]
[{"$nulls":3},"Manager Signature"]