{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Setup Here","Bi-Weekly Timesheets","Summary Timesheets"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Setup Here","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
["Bi-Weekly Timesheets"]
["Please list the date you want the pay sheet to start. Usually starts on a Sunday"]
["Pay Period Start Date","2020-06-21"]
["Overtime starts after: ",40,"hours"]
[]
[]
[]
["Please edit this list to show the employees you want to track time for"]
[null,"First Name","Last Name","Emp #"]
["Employee #1","John","Doe",100]

{"sheet":"Bi-Weekly Timesheets","index":1,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,9,17,9],[3,0,3,7],[15,0,15,7]]}
[]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$11,\", \", 'Setup Here'!$B$11,\" #\",'Setup Here'!$D$11)","v":"Doe, John #100"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
["Week 1"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-21"},43641.380972222221,43641.533009259256,43641.557395833333,43641.760625000003,{"$f":"IF((((C5-B5)+(E5-D5))*24)>8,8,((C5-B5)+(E5-D5))*24)","v":8},{"$f":"IF(H5>8,H5-8,0)","v":0.52638888888759539},{"$f":"(((IF($E5<$B5,$E5+1,$E5)-$B5)-(IF($D5<$C5,$D5+1,$D5)-$C5))-(INT((IF($E5<$B5,$E5+1,$E5)-$B5)-(IF($D5<$C5,$D5+1,$D5)-$C5))))*24","v":8.5263888888875954}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-22"},null,null,null,null,{"$f":"IF((((C6-B6)+(E6-D6))*24)>8,8,((C6-B6)+(E6-D6))*24)","v":0},0,{"$f":"(((IF($E6<$B6,$E6+1,$E6)-$B6)-(IF($D6<$C6,$D6+1,$D6)-$C6))-(INT((IF($E6<$B6,$E6+1,$E6)-$B6)-(IF($D6<$C6,$D6+1,$D6)-$C6))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C7-B7)+(E7-D7))*24)>8,8,((C7-B7)+(E7-D7))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+3","v":"2020-06-24"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-25"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-26"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-27"},null,null,null,null,0,{"$f":"IF(H11>8,H11-8,0)","v":0},{"$f":"(((IF($E11<$B11,$E11+1,$E11)-$B11)-(IF($D11<$C11,$D11+1,$D11)-$C11))-(INT((IF($E11<$B11,$E11+1,$E11)-$B11)-(IF($D11<$C11,$D11+1,$D11)-$C11))))*24","v":0}]
[null,null,null,null,null,null,"Regular Hours",{"$f":"SUM(F5:F11)","v":8}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G5:G11))","v":0.52638888888759539}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H5:H11)","v":8.5263888888875954}]
[]
["Week 2"]
[{"$f":"'Setup Here'!$B$4+7","v":"2020-06-28"},43641.380972222221,43641.533009259256,43641.557395833333,43641.760625000003,{"$f":"IF((((C17-B17)+(E17-D17))*24)>8,8,((C17-B17)+(E17-D17))*24)","v":8},{"$f":"IF(H17>8,H17-8,0)","v":0.52638888888759539},{"$f":"(((IF($E17<$B17,$E17+1,$E17)-$B17)-(IF($D17<$C17,$D17+1,$D17)-$C17))-(INT((IF($E17<$B17,$E17+1,$E17)-$B17)-(IF($D17<$C17,$D17+1,$D17)-$C17))))*24","v":8.5263888888875954}]
[{"$f":"'Setup Here'!$B$4+8","v":"2020-06-29"},null,null,null,null,{"$f":"IF((((C18-B18)+(E18-D18))*24)>8,8,((C18-B18)+(E18-D18))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+9","v":"2020-06-30"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+10","v":"2020-07-01"},null,null,null,null,0,{"$f":"IF(H20>8,H20-8,0)","v":0},0]
[{"$f":"'Setup Here'!$B$4+11","v":"2020-07-02"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+12","v":"2020-07-03"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+13","v":"2020-07-04"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Regular Hours",{"$f":"SUM(F17:F23)","v":8}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G17:G23))","v":0.52638888888759539}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H17:H23)","v":8.5263888888875954}]

{"sheet":"Summary Timesheets","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["SUMMARY OF BI-WEEKLY TIMESHEET DATA",null,"PAY PERIOD START DATE",{"$f":"'[1]Setup Here'!$B$4","v":"2020-06-23"}]
[null,null,"PAY PERIOD END DATE",{"$f":"D2+13","v":"2020-07-06"}]
[]
["EMPLOYEE","Total Regular hours","Total Overtime Hours ","Total Hours"]
["Week 1",{"$f":"'Bi-Weekly Timesheets'!H12","v":8},{"$f":"'Bi-Weekly Timesheets'!H13","v":0.52638888888759539},{"$f":"'Bi-Weekly Timesheets'!H14","v":8.5263888888875954}]
["Week 2",{"$f":"'Bi-Weekly Timesheets'!H24","v":8},{"$f":"'Bi-Weekly Timesheets'!H25","v":0.52638888888759539},{"$f":"'Bi-Weekly Timesheets'!H26","v":8.5263888888875954}]
[]
[null,null,"REGULAR HOURS",{"$f":"SUM(B6:B7)","v":16}]
[null,null,"OVERTIME HOURS",{"$f":"SUM(C6:C7)","v":1.0527777777751908}]
[null,null,"TOTAL",{"$f":"SUM(D6:D7)","v":17.052777777775191}]