{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Setup Here","Monthly Timesheets","Summary Timesheet"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"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]]}
[]
["Monthly Timesheets"]
["Please list the date you want the pay sheet to start. Usually starts on a Sunday"]
["Pay Period Start Date","2022-06-01"]
["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 ","John","Doe",100]

{"sheet":"Monthly Timesheets","index":1,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[27,0,27,7],[39,0,39,7],[51,0,51,7],[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":"2022-06-01"},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":"2022-06-02"},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":"2022-06-03"},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":"2022-06-04"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2022-06-05"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2022-06-06"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2022-06-07"},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":"2022-06-08"},null,null,null,null,{"$f":"IF((((C17-B17)+(E17-D17))*24)>8,8,((C17-B17)+(E17-D17))*24)","v":0},{"$f":"IF(H17>8,H17-8,0)","v":0},{"$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":0}]
[{"$f":"'Setup Here'!$B$4+8","v":"2022-06-09"},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":"2022-06-10"},null,null,null,null,{"$f":"IF((((C19-B19)+(E19-D19))*24)>8,8,((C19-B19)+(E19-D19))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+10","v":"2022-06-11"},null,null,null,null,0,{"$f":"IF(H20>8,H20-8,0)","v":0},0]
[{"$f":"'Setup Here'!$B$4+11","v":"2022-06-12"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+12","v":"2022-06-13"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+13","v":"2022-06-14"},null,null,null,null,{"$f":"IF((((C23-B23)+(E23-D23))*24)>8,8,((C23-B23)+(E23-D23))*24)","v":0},0,0]
[null,null,null,null,null,null,"Regular Hours",{"$f":"SUM(F17:F23)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G17:G23))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H17:H23)","v":0}]
[]
["Week 3"]
[{"$f":"'Setup Here'!$B$4+14","v":"2022-06-15"},null,null,null,null,{"$f":"IF((((C29-B29)+(E29-D29))*24)>8,8,((C29-B29)+(E29-D29))*24)","v":0},{"$f":"IF(H29>8,H29-8,0)","v":0},0]
[{"$f":"'Setup Here'!$B$4+15","v":"2022-06-16"},null,null,null,null,{"$f":"IF((((C30-B30)+(E30-D30))*24)>8,8,((C30-B30)+(E30-D30))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+16","v":"2022-06-17"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+17","v":"2022-06-18"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+18","v":"2022-06-19"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+19","v":"2022-06-20"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+20","v":"2022-06-21"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Regular Hours",{"$f":"SUM(F29:F35)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G29:G35))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H29:H35)","v":0}]
[]
["Week 4"]
[{"$f":"'Setup Here'!$B$4+21","v":"2022-06-22"},null,null,null,null,{"$f":"IF((((C41-B41)+(E41-D41))*24)>8,8,((C41-B41)+(E41-D41))*24)","v":0},{"$f":"IF(H41>8,H41-8,0)","v":0},0]
[{"$f":"'Setup Here'!$B$4+22","v":"2022-06-23"},null,null,null,null,{"$f":"IF((((C42-B42)+(E42-D42))*24)>8,8,((C42-B42)+(E42-D42))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+23","v":"2022-06-24"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+24","v":"2022-06-25"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+25","v":"2022-06-26"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+26","v":"2022-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+27","v":"2022-06-28"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Regular Hours",{"$f":"SUM(F41:F47)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G41:G47))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H41:H47)","v":0}]
[]
["Week 5"]
[{"$f":"'Setup Here'!$B$4+28","v":"2022-06-29"},null,null,null,null,{"$f":"IF((((C53-B53)+(E53-D53))*24)>8,8,((C53-B53)+(E53-D53))*24)","v":0},{"$f":"IF(H53>8,H53-8,0)","v":0},{"$f":"(((IF($E53<$B53,$E53+1,$E53)-$B53)-(IF($D53<$C53,$D53+1,$D53)-$C53))-(INT((IF($E53<$B53,$E53+1,$E53)-$B53)-(IF($D53<$C53,$D53+1,$D53)-$C53))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+29","v":"2022-06-30"},null,null,null,null,{"$f":"IF((((C54-B54)+(E54-D54))*24)>8,8,((C54-B54)+(E54-D54))*24)","v":0},0,{"$f":"(((IF($E54<$B54,$E54+1,$E54)-$B54)-(IF($D54<$C54,$D54+1,$D54)-$C54))-(INT((IF($E54<$B54,$E54+1,$E54)-$B54)-(IF($D54<$C54,$D54+1,$D54)-$C54))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+30","v":"2022-07-01"},null,null,null,null,0,0,{"$f":"(((IF($E55<$B55,$E55+1,$E55)-$B55)-(IF($D55<$C55,$D55+1,$D55)-$C55))-(INT((IF($E55<$B55,$E55+1,$E55)-$B55)-(IF($D55<$C55,$D55+1,$D55)-$C55))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+31","v":"2022-07-02"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+32","v":"2022-07-03"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+33","v":"2022-07-04"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+34","v":"2022-07-05"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Regular Hours",{"$f":"SUM(F53:F59)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G53:G59))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H53:H59)","v":0}]

{"sheet":"Summary Timesheet","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["SUMMARY OF MONTHLY TIMESHEET DATA"]
[]
["EMPLOYEE","Total Regular hours","Total Overtime Hours ","Total Hours"]
["Week 1",{"$f":"'Monthly Timesheets'!H12","v":8},{"$f":"'Monthly Timesheets'!H13","v":0.52638888888759539},{"$f":"SUM(B5+C5)","v":8.5263888888875954}]
["Week 2",{"$f":"'Monthly Timesheets'!H24","v":0},{"$f":"'Monthly Timesheets'!H25","v":0},{"$f":"SUM(B6+C6)","v":0}]
["Week 3",{"$f":"'Monthly Timesheets'!H36","v":0},{"$f":"'Monthly Timesheets'!H37","v":0},{"$f":"SUM(B7+C7)","v":0}]
["Week 4",{"$f":"'Monthly Timesheets'!H48","v":0},{"$f":"'Monthly Timesheets'!H49","v":0},{"$f":"SUM(B8+C8)","v":0}]
["Week 5",{"$f":"'Monthly Timesheets'!H60","v":0},{"$f":"'Monthly Timesheets'!H61","v":0},{"$f":"SUM(B9+C9)","v":0}]
[]
[null,null,"REGULAR HOURS",{"$f":"SUM(B5:B9)","v":8}]
[null,null,"OVERTIME HOURS",{"$f":"SUM(C5:C9)","v":0.52638888888759539}]
[null,null,"TOTAL",{"$f":"SUM(D5:D9)","v":8.5263888888875954}]