{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Setup Here","Weekly 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":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
["Weekly Timesheets"]
["Please list the date you want the pay sheet to start. Usually starts on a Sunday"]
["Pay Period Start Date","2020-06-23"]
["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]
["Employee #2","Jane","Doe",101]
["Employee #3","Steve","Doe",102]
["Employee #4","Aaron","Doe",103]
["Employee #5","Ryan","Doe",104]
["Employee #6","Bill","Doe",105]
["Employee #7","Peggy","Doe",106]
["Employee #8","Suzy","Doe",107]
["Employee #9","Sally","Doe",108]
["Employee #10","William","Doe",109]

{"sheet":"Weekly Timesheets","index":1,"n_rows":121,"n_cols":8,"rows_kept":121,"cut":false,"hidden":false,"merged":[[2,9,4,9]]}
[]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$9,\", \", 'Setup Here'!$B$9,\" #\",'Setup Here'!$D$9)","v":"Doe, John #100"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},43641.589305555557,43641.616342592592,43641.616423611114,43641.927291666667,{"$f":"IF((((C4-B4)+(E4-D4))*24)>8,8,((C4-B4)+(E4-D4))*24)","v":8},{"$f":"IF(H4>8,H4-8,0)","v":0.10972222208511084},{"$f":"(((IF($E4<$B4,$E4+1,$E4)-$B4)-(IF($D4<$C4,$D4+1,$D4)-$C4))-(INT((IF($E4<$B4,$E4+1,$E4)-$B4)-(IF($D4<$C4,$D4+1,$D4)-$C4))))*24","v":8.1097222220851108}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C5-B5)+(E5-D5))*24)>8,8,((C5-B5)+(E5-D5))*24)","v":0},0,{"$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":0}]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},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+3","v":"2020-06-26"},null,null,null,null,0,{"$f":"IF(H7>8,H7-8,0)","v":0},0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F4:F10)","v":8}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G4:G10))","v":0.10972222208511084}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H4:H10)","v":8.1097222220851108}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$10,\", \", 'Setup Here'!$B$10,\" #\",'Setup Here'!$D$10)","v":"Doe, Jane #101"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C16-B16)+(E16-D16))*24)>8,8,((C16-B16)+(E16-D16))*24)","v":0},{"$f":"IF(H16>8,H16-8,0)","v":0},{"$f":"(((IF($E16<$B16,$E16+1,$E16)-$B16)-(IF($D16<$C16,$D16+1,$D16)-$C16))-(INT((IF($E16<$B16,$E16+1,$E16)-$B16)-(IF($D16<$C16,$D16+1,$D16)-$C16))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C17-B17)+(E17-D17))*24)>8,8,((C17-B17)+(E17-D17))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},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+3","v":"2020-06-26"},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+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F16:F22)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G16:G22))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H16:H22)","v":0}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$11,\", \", 'Setup Here'!$B$11,\" #\",'Setup Here'!$D$11)","v":"Doe, Steve #102"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C28-B28)+(E28-D28))*24)>8,8,((C28-B28)+(E28-D28))*24)","v":0},{"$f":"IF(H28>8,H28-8,0)","v":0},{"$f":"(((IF($E28<$B28,$E28+1,$E28)-$B28)-(IF($D28<$C28,$D28+1,$D28)-$C28))-(INT((IF($E28<$B28,$E28+1,$E28)-$B28)-(IF($D28<$C28,$D28+1,$D28)-$C28))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C29-B29)+(E29-D29))*24)>8,8,((C29-B29)+(E29-D29))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},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+3","v":"2020-06-26"},null,null,null,null,{"$f":"IF((((C31-B31)+(E31-D31))*24)>8,8,((C31-B31)+(E31-D31))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F28:F34)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G28:G34))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H28:H34)","v":0}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$12,\", \", 'Setup Here'!$B$12,\" #\",'Setup Here'!$D$12)","v":"Doe, Aaron #103"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C40-B40)+(E40-D40))*24)>8,8,((C40-B40)+(E40-D40))*24)","v":0},{"$f":"IF(H40>8,H40-8,0)","v":0},{"$f":"(((IF($E40<$B40,$E40+1,$E40)-$B40)-(IF($D40<$C40,$D40+1,$D40)-$C40))-(INT((IF($E40<$B40,$E40+1,$E40)-$B40)-(IF($D40<$C40,$D40+1,$D40)-$C40))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C41-B41)+(E41-D41))*24)>8,8,((C41-B41)+(E41-D41))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},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+3","v":"2020-06-26"},null,null,null,null,{"$f":"IF((((C43-B43)+(E43-D43))*24)>8,8,((C43-B43)+(E43-D43))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F40:F46)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G40:G46))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H40:H46)","v":0}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$13,\", \", 'Setup Here'!$B$13,\" #\",'Setup Here'!$D$13)","v":"Doe, Ryan #104"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C52-B52)+(E52-D52))*24)>8,8,((C52-B52)+(E52-D52))*24)","v":0},{"$f":"IF(H52>8,H52-8,0)","v":0},{"$f":"(((IF($E52<$B52,$E52+1,$E52)-$B52)-(IF($D52<$C52,$D52+1,$D52)-$C52))-(INT((IF($E52<$B52,$E52+1,$E52)-$B52)-(IF($D52<$C52,$D52+1,$D52)-$C52))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C53-B53)+(E53-D53))*24)>8,8,((C53-B53)+(E53-D53))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},null,null,null,null,{"$f":"IF((((C54-B54)+(E54-D54))*24)>8,8,((C54-B54)+(E54-D54))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+3","v":"2020-06-26"},null,null,null,null,{"$f":"IF((((C55-B55)+(E55-D55))*24)>8,8,((C55-B55)+(E55-D55))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F52:F58)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G52:G58))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H52:H58)","v":0}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$14,\", \", 'Setup Here'!$B$14,\" #\",'Setup Here'!$D$14)","v":"Doe, Bill #105"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C64-B64)+(E64-D64))*24)>8,8,((C64-B64)+(E64-D64))*24)","v":0},{"$f":"IF(H64>8,H64-8,0)","v":0},{"$f":"(((IF($E64<$B64,$E64+1,$E64)-$B64)-(IF($D64<$C64,$D64+1,$D64)-$C64))-(INT((IF($E64<$B64,$E64+1,$E64)-$B64)-(IF($D64<$C64,$D64+1,$D64)-$C64))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C65-B65)+(E65-D65))*24)>8,8,((C65-B65)+(E65-D65))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},null,null,null,null,{"$f":"IF((((C66-B66)+(E66-D66))*24)>8,8,((C66-B66)+(E66-D66))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+3","v":"2020-06-26"},null,null,null,null,{"$f":"IF((((C67-B67)+(E67-D67))*24)>8,8,((C67-B67)+(E67-D67))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F64:F70)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G64:G70))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H64:H70)","v":0}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$15,\", \", 'Setup Here'!$B$15,\" #\",'Setup Here'!$D$15)","v":"Doe, Peggy #106"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C76-B76)+(E76-D76))*24)>8,8,((C76-B76)+(E76-D76))*24)","v":0},{"$f":"IF(H76>8,H76-8,0)","v":0},{"$f":"(((IF($E76<$B76,$E76+1,$E76)-$B76)-(IF($D76<$C76,$D76+1,$D76)-$C76))-(INT((IF($E76<$B76,$E76+1,$E76)-$B76)-(IF($D76<$C76,$D76+1,$D76)-$C76))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C77-B77)+(E77-D77))*24)>8,8,((C77-B77)+(E77-D77))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},null,null,null,null,{"$f":"IF((((C78-B78)+(E78-D78))*24)>8,8,((C78-B78)+(E78-D78))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+3","v":"2020-06-26"},null,null,null,null,{"$f":"IF((((C79-B79)+(E79-D79))*24)>8,8,((C79-B79)+(E79-D79))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F76:F82)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G76:G82))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H76:H82)","v":0}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$16,\", \", 'Setup Here'!$B$16,\" #\",'Setup Here'!$D$16)","v":"Doe, Suzy #107"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C88-B88)+(E88-D88))*24)>8,8,((C88-B88)+(E88-D88))*24)","v":0},{"$f":"IF(H88>8,H88-8,0)","v":0},{"$f":"(((IF($E88<$B88,$E88+1,$E88)-$B88)-(IF($D88<$C88,$D88+1,$D88)-$C88))-(INT((IF($E88<$B88,$E88+1,$E88)-$B88)-(IF($D88<$C88,$D88+1,$D88)-$C88))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C89-B89)+(E89-D89))*24)>8,8,((C89-B89)+(E89-D89))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},null,null,null,null,{"$f":"IF((((C90-B90)+(E90-D90))*24)>8,8,((C90-B90)+(E90-D90))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+3","v":"2020-06-26"},null,null,null,null,{"$f":"IF((((C91-B91)+(E91-D91))*24)>8,8,((C91-B91)+(E91-D91))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F88:F94)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G88:G94))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H88:H94)","v":0}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$17,\", \", 'Setup Here'!$B$17,\" #\",'Setup Here'!$D$17)","v":"Doe, Sally #108"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C100-B100)+(E100-D100))*24)>8,8,((C100-B100)+(E100-D100))*24)","v":0},{"$f":"IF(H100>8,H100-8,0)","v":0},{"$f":"(((IF($E100<$B100,$E100+1,$E100)-$B100)-(IF($D100<$C100,$D100+1,$D100)-$C100))-(INT((IF($E100<$B100,$E100+1,$E100)-$B100)-(IF($D100<$C100,$D100+1,$D100)-$C100))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C101-B101)+(E101-D101))*24)>8,8,((C101-B101)+(E101-D101))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},null,null,null,null,{"$f":"IF((((C102-B102)+(E102-D102))*24)>8,8,((C102-B102)+(E102-D102))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+3","v":"2020-06-26"},null,null,null,null,{"$f":"IF((((C103-B103)+(E103-D103))*24)>8,8,((C103-B103)+(E103-D103))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F100:F106)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G100:G106))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H100:H106)","v":0}]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$18,\", \", 'Setup Here'!$B$18,\" #\",'Setup Here'!$D$18)","v":"Doe, William #109"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
[{"$f":"'Setup Here'!$B$4","v":"2020-06-23"},null,null,null,null,{"$f":"IF((((C112-B112)+(E112-D112))*24)>8,8,((C112-B112)+(E112-D112))*24)","v":0},{"$f":"IF(H112>8,H112-8,0)","v":0},{"$f":"(((IF($E112<$B112,$E112+1,$E112)-$B112)-(IF($D112<$C112,$D112+1,$D112)-$C112))-(INT((IF($E112<$B112,$E112+1,$E112)-$B112)-(IF($D112<$C112,$D112+1,$D112)-$C112))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+1","v":"2020-06-24"},null,null,null,null,{"$f":"IF((((C113-B113)+(E113-D113))*24)>8,8,((C113-B113)+(E113-D113))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+2","v":"2020-06-25"},null,null,null,null,{"$f":"IF((((C114-B114)+(E114-D114))*24)>8,8,((C114-B114)+(E114-D114))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+3","v":"2020-06-26"},null,null,null,null,{"$f":"IF((((C115-B115)+(E115-D115))*24)>8,8,((C115-B115)+(E115-D115))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2020-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2020-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2020-06-29"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Reg Hours",{"$f":"SUM(F112:F118)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G112:G118))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H112:H118)","v":0}]

{"sheet":"Summary Timesheet","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
["SUMMARY OF WEEKLY TIMESHEET DATA",null,"PAY PERIOD START DATE",{"$f":"'Setup Here'!$B$4","v":"2020-06-23"}]
[null,null,"PAY PERIOD END DATE",{"$f":"D3+6","v":"2020-06-29"}]
[]
["EMPLOYEE","Total Regular hours","Total Overtime Hours ","Total Hours"]
["Doe, John #100",{"$f":"'Weekly Timesheets'!$H$11","v":8},{"$f":"'Weekly Timesheets'!$H$12","v":0.10972222208511084},{"$f":"'Weekly Timesheets'!$H$13","v":8.1097222220851108}]
["Doe, Jane #101",{"$f":"'Weekly Timesheets'!$H$23","v":0},{"$f":"'Weekly Timesheets'!$H$24","v":0},{"$f":"'Weekly Timesheets'!$H$25","v":0}]
["Doe, Steve #102",{"$f":"'Weekly Timesheets'!$H$35","v":0},{"$f":"'Weekly Timesheets'!$H$36","v":0},{"$f":"'Weekly Timesheets'!$H$37","v":0}]
["Doe, Aaron #103",{"$f":"'Weekly Timesheets'!$H$47","v":0},{"$f":"'Weekly Timesheets'!$H$48","v":0},{"$f":"'Weekly Timesheets'!$H$49","v":0}]
["Doe, Ryan #104",{"$f":"'Weekly Timesheets'!$H$59","v":0},{"$f":"'Weekly Timesheets'!$H$60","v":0},{"$f":"'Weekly Timesheets'!$H$61","v":0}]
["Doe, Bill #105",{"$f":"'Weekly Timesheets'!$H$71","v":0},{"$f":"'Weekly Timesheets'!$H$72","v":0},{"$f":"'Weekly Timesheets'!$H$73","v":0}]
["Doe, Peggy #106",{"$f":"'Weekly Timesheets'!$H$83","v":0},{"$f":"'Weekly Timesheets'!$H$84","v":0},{"$f":"'Weekly Timesheets'!$H$85","v":0}]
["Doe, Suzy #107",{"$f":"'Weekly Timesheets'!$H$95","v":0},{"$f":"'Weekly Timesheets'!$H$96","v":0},{"$f":"'Weekly Timesheets'!$H$97","v":0}]
["Doe, Sally #108",{"$f":"'Weekly Timesheets'!$H$107","v":0},{"$f":"'Weekly Timesheets'!$H$108","v":0},{"$f":"'Weekly Timesheets'!$H$109","v":0}]
["Doe, First Name #109",{"$f":"'Weekly Timesheets'!$H$119","v":0},{"$f":"'Weekly Timesheets'!$H$120","v":0},{"$f":"'Weekly Timesheets'!$H$121","v":0}]
[]
[null,null,"REGULAR HOURS",{"$f":"SUM(B7:B16)","v":8}]
[null,null,"OVERTIME HOURS",{"$f":"SUM(C7:C16)","v":0.10972222208511084}]
[null,null,"TOTAL",{"$f":"SUM(D7:D16)","v":8.1097222220851108}]