{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Employee Name 1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Employee Name 1","index":0,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,4,7,4],[39,5,39,10],[1,11,1,14],[3,11,3,14],[14,17,15,17],[3,5,3,7],[37,5,37,10],[17,13,17,14],[28,13,28,14],[14,18,15,18],[14,19,15,19],[25,17,26,17],[25,18,26,18],[25,19,26,19]]}
[null,null,null,"Bi-Weekly/Hourly Time Report"]
[null,null,null,"Reporting Period",null,"2024-11-09",{"$f":"F2+13","v":"2024-11-22"},null,null,"Dept/ORG #"]
[]
[null,null,null,"Employee Name",null,null,null,null,null,"ID #"]
[]
[null,null,null,null,"Sheduled Hours",null,"Sat","Sun","Mon","Tue","Wed","Thur","Fri"]
[null,null,null,null,null,"Week 1",0,0,7.5,7.5,7.5,7.5,7.5]
[null,null,null,null,null,"Week 2",0,0,7.5,7.5,7.5,7.5,7.5,null,null,null,null,"Comments"]
["Date","Shift Time"," Shift Diff Hours","Week 1","Vacation","Sick","Family Sick","Comp Time Used","Holiday","Misc Hrs","Misc Hrs Code*","FMLA","Stand-by pay","Overtime Worked","Comp Time Earned","Actual Hours Worked","Total"]
[{"$f":"F2","v":"2024-11-09"},null,null,"Saturday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"G7+N10+O10-E10-F10-G10-H10-I10-J10","v":0},{"$f":"P10+E10+F10+G10+H10+I10+J10","v":0}]
[{"$f":"A10+1","v":"2024-11-10"},null,null,"Sunday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"H7+N11+O11-E11-F11-G11-H11-I11-J11","v":0},{"$f":"P11+E11+F11+G11+H11+I11+J11","v":0}]
["2024-11-11",null,null,"Monday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I7+N12+O12-E12-F12-G12-H12-I12-J12","v":7.5},{"$f":"SUM(E12:J12,P12)","v":7.5}]
["2024-11-12",null,null,"Tuesday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"J7+N13+O13-E13-F13-G13-H13-I13-J13","v":7.5},{"$f":"SUM(E13:J13,P13)","v":7.5}]
["2024-11-13",null,null,"Wednesday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K7+N14+O14-E14-F14-G14-H14-I14-J14","v":7.5},7.5]
["2024-11-14",null,null,"Thursday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L7+N15+O15-E15-F15-G15-H15-I15-J15","v":7.5},7.5,"Standard Hours","Comp Earned","Overtime"]
["2024-11-15",null,null,"Friday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7+N16+O16-E16-F16-G16-H16-I16-J16","v":7.5},7.5]
[null,null,{"$f":"SUM(C10:C16)","v":0},"Total Week 1",{"$f":"SUM(E10:E16)","v":0},0,0,0,0,0,null,null,null,{"$f":"SUM(N10:N16)","v":0},{"$f":"SUM(O10:O16)","v":0},{"$f":"SUM(P10:P16)","v":37.5},{"$f":"SUM(Q10:Q16)","v":37.5},37.5,0,{"$f":"MAX(0,Q17-R17)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments"]
["Date","Shift Time"," Shift Diff Hours","Week 2","Vacation","Sick","Family Sick","Comp Time Used","Holiday","Misc Hrs","Misc Hrs Code*","FMLA","Stand-by Pay","Overtime Worked","Comp Time Earned","Actual Hours Worked","Total"]
[{"$f":"F2+7","v":"2024-11-16"},null,null,"Saturday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"G8+N21+O21-E21-F21-G21-H21-I21-J21","v":0},{"$f":"P21+E21+F21+G21+H21+I21+J21","v":0}]
[{"$f":"A21+1","v":"2024-11-17"},null,null,"Sunday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"H8+N22+O22-E22-F22-G22-H22-I22-J22","v":0},0]
[{"$f":"A22+1","v":"2024-11-18"},null,null,"Monday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I8+N23+O23-E23-F23-G23-H23-I23-J23","v":7.5},7.5]
["2024-11-19",null,null,"Tuesday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"J8+N24+O24-E24-F24-G24-H24-I24-J24","v":7.5},7.5]
["2024-11-20",null,null,"Wednesday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K8+N25+O25-E25-F25-G25-H25-I25-J25","v":7.5},7.5]
["2024-11-21",null,null,"Thursday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"L8+N26+O26-E26-F26-G26-H26-I26-J26","v":7.5},7.5,"Standard Hours","Comp Earned","Overtime"]
["2024-11-22",null,null,"Friday",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M8+N27+O27-E27-F27-G27-H27-I27-J27","v":7.5},7.5]
[null,null,{"$f":"SUM(C21:C27)","v":0},"Total Week 2",{"$f":"SUM(E21:E27)","v":0},0,0,0,0,0,null,null,null,{"$f":"SUM(N21:N27)","v":0},{"$f":"SUM(O21:O27)","v":0},{"$f":"SUM(P21:P27)","v":37.5},{"$f":"SUM(Q21:Q27)","v":37.5},37.5,0,{"$f":"MAX(0,Q28-R28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"            Earn comp rather than OT"]
[null,null,{"$f":"SUM(C28+C17)","v":0},"Bi-Weekly Totals",{"$f":"E28+E17","v":0},0,0,0,0,0,null,null,{"$f":"SUM(IF(ISTEXT(M10:M16),0.5,M10:M16),IF(ISTEXT(M21:M27),0.5,M21:M27))","v":0},0,0,{"$f":"SUM(P10:P16,P21:P27)","v":75},{"$f":"Q28+Q17","v":75},{"$f":"R28+R17","v":75},{"$f":"S28+S17","v":0},0]
[null,null,null,"Earn Codes",170,180,181,190,150,"MISC",null,null,"GRAND TOTAL",null,null,{"$f":"E30+F30+G30+H30+I30+J30+P30","v":75},null,null,191,"030"]
[]
[]
[null,null,null,"* Miscellaneous Earn Codes:  220-Jury Duty     230-Military Leave     240-Funeral Leave    420-Unpaid Leave"]
[]
[]
[]
[null,null,null,"Employee Signature:",null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,"Supervisor Signature:",null,null,null,null,null,null,null,null,"Date:"]