{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Non-Exempt Blank"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"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":"Non-Exempt Blank","index":0,"n_rows":67,"n_cols":22,"rows_kept":67,"cut":false,"hidden":false,"merged":[[54,0,61,0],[34,1,61,1],[34,0,53,0],[25,0,32,0],[7,0,24,0],[7,1,32,1],[7,12,7,13],[22,2,25,7],[22,8,23,10],[24,8,25,10],[63,2,66,7],[63,8,64,10],[65,8,66,10],[38,8,39,10],[40,8,41,10],[54,8,55,10],[56,8,57,10],[54,2,57,7],[27,10,28,10],[27,4,27,5],[27,8,27,9],[27,6,27,7],[2,2,5,22],[19,2,19,9],[10,11,18,11],[19,11,24,11],[6,2,6,22],[10,10,11,10],[20,13,20,19],[10,4,10,5],[10,6,10,7],[7,5,7,6],[8,5,8,6],[7,7,7,8],[8,7,8,8],[9,2,9,10],[10,3,11,3],[7,2,7,4],[22,13,22,19],[23,13,23,19],[27,12,27,20],[24,13,24,19],[25,13,25,19],[59,4,59,5],[43,3,44,3],[59,2,60,2],[58,2,58,10],[53,2,53,9],[43,4,43,5],[52,2,52,9],[59,6,59,7],[59,3,60,3],[43,10,44,10],[43,6,43,7],[43,8,43,9],[59,8,59,9],[43,2,44,2],[66,12,66,21],[59,10,60,10],[58,12,58,21],[59,12,59,20],[43,12,43,20],[43,11,51,11],[59,11,66,11],[52,11,57,11],[27,11,35,11],[56,14,56,19],[27,2,28,2],[27,3,28,3],[26,2,26,10],[26,12,26,21],[42,12,42,21],[40,14,40,19],[36,11,40,11],[37,2,37,9],[38,2,41,7],[36,2,36,9],[42,2,42,10],[21,13,21,19],[10,2,11,2],[7,14,7,15],[7,16,7,17],[8,12,8,13],[21,2,21,5],[8,2,8,4],[21,7,21,9],[10,8,10,9],[7,9,7,10],[8,9,8,10],[9,12,9,21],[10,12,10,20],[20,2,20,9],[8,14,8,15],[8,16,8,17]]}
[]
[]
[]
[]
[]
[]
[]
[null,"I certify and attest that this timesheet is an accurate, true, and correct record of actual time worked by this employee during this reporting period to the best of my knowledge. ","Employee Name",null,null,"Employee ID",null,"Pay Period Start Date",null,"Pay Period \nEnd Date",null,null,"Standard Days",null,"Standard Hours",null,"Standard Lunch"]
[]
[null,null,"HOURS WORKED",null,null,null,null,null,null,null,null,null,"LEAVE USED"]
[null,null,"Day of Week","Pay Period Date",null,null,null,null,"Interim",null,"Total Hrs. Worked",null,"Other Hours Used"]
[null,null,null,null,"In","Out","In","Out","Out","In",null,null,"Hol.","Vac.","Sick","Comp.","Ed/Fit.","CEA","Wea.","Other","Total","LWOP"]
[null,null,"Sun.",null,null,null,null,null,null,null,{"$f":"SUM((F13-E13)+(H13-G13)-(J13-I13))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM((F13-E13)+(H13-G13)-(J13-I13)+M13+N13+O13+P13+Q13+R13+S13+T13+V13)","v":0}]
[null,null,"Mon.",{"$f":"IF(ISERROR(D13+1),\"\",IF(D13+1<100,\"\",D13+1))","v":""},null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"SUM((F14-E14)+(H14-G14)-(J14-I14)+M14+N14+O14+P14+Q14+R14+S14+T14+V14)","v":0}]
[null,null,"Tues.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Wed.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Thurs.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Fri.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Sat.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total Hrs Worked This Week In This Pay Period ",null,null,null,null,null,null,null,{"$f":"SUM(K13:K19)","v":0},null,{"$f":"SUM(M13:M19)","v":0},0,0,{"$f":"SUM(P13:P19)","v":0},{"$f":"SUM(Q13:Q19)","v":0},0,0,0,null,{"$f":"SUM(V13:V19)","v":0}]
[null,null,"Total Hrs Worked This Week From Prior Pay Period ",null,null,null,null,null,null,null,null,null,null,"Total Leave This Week From Prior Pay Period"]
[null,null,"Total Hrs Worked This Week  ",null,null,null,{"$f":"IF((K20+K21)>0,(K20+K21),0)","v":0},"*Hrs Worked Over 40 ",null,null,{"$f":"IF(G22-1.666667>0,G22-1.666667,0)","v":0},null,null,"Total Compensable Hours This Week",null,null,null,null,null,null,{"$f":"G22+SUM(M20:T20)+V20+U21","v":0},{"$f":"SUM(V13:V19)","v":0}]
[null,null,"Notes:",null,null,null,null,null,"EE Initial & Date:",null,null,null,null,"Total Compensable Hours This Period",null,null,null,null,null,null,{"$f":"IF(K20+SUM(M20:V20)>0,(K20+SUM(M20:V20)),0)","v":0},{"$f":"SUM(V21,V22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Straight Time Earned This Week",null,null,null,null,null,null,{"$f":"IF((U22-K22-1.666667>0),((U22-K22-1.666667)),0)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"Sup. Initial & Date",null,null,null,null,"Time-and-a-Half (Calculated)",null,null,null,null,null,null,{"$f":"K22*1.5","v":0},{"$f":"U22","v":0}]
["Supervisor Certification:",null,null,null,null,null,null,null,null,null,null,null,null,"Total Comp Time",null,null,null,null,null,null,{"$f":"SUM(U24:U25)","v":0},{"$f":"IF(AND(SUM(N20:P20,R20)>0, U22-1.666667> 0),U22-1.666667,0)","v":0}]
[]
[null,null,"Day of Week","Pay Period Date",null,null,null,null,"Interim",null,"Total Hrs. Worked",null,"Other Hours Used"]
[null,null,null,null,"In","Out","In","Out","Out","In",null,null,"Hol.","Vac.","Sick","Comp.","Ed/Fit.","CEA","Wea.","Other","Total","LWOP"]
[null,null,"Sun.",{"$f":"IF(ISERROR(D19+1),\"\",IF(D19+1<100,\"\",D19+1))","v":""},null,null,null,null,null,null,{"$f":"SUM((F30-E30)+(H30-G30)-(J30-I30))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM((F30-E30)+(H30-G30)-(J30-I30)+M30+N30+O30+P30+Q30+R30+S30+T30+V30)","v":0}]
[null,null,"Mon.",{"$f":"IF(ISERROR(D30+1),\"\",IF(D30+1<100,\"\",D30+1))","v":""},null,null,null,null,null,null,{"$f":"SUM((F31-E31)+(H31-G31)-(J31-I31))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM((F31-E31)+(H31-G31)-(J31-I31)+M31+N31+O31+P31+Q31+R31+S31+T31+V31)","v":0}]
[null,null,"Tues.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Wed.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Thurs.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,"I certify and attest that this timesheet is an accurate, true, and correct record of my actual time worked and any leave time I have taken during this reporting period. ","Fri.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Sat.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total Hrs Worked This Week",null,null,null,null,null,null,null,{"$f":"SUM(K30:K36)","v":0},null,{"$f":"SUM(M30:M36)","v":0},0,0,0,{"$f":"SUM(Q30:Q36)","v":0},0,0,0,null,{"$f":"SUM(V30:V36)","v":0}]
[null,null,"*Hrs Worked Over 40",null,null,null,null,null,null,null,{"$f":"IF(K37-1.666667>0,K37-1.666667,0)","v":0},null,null,null,"Total Compensable Hours This Week",null,null,null,null,null,{"$f":"K37+SUM(M37:T37)+V37","v":0},{"$f":"SUM(V30:V36)","v":0}]
[null,null,"Notes:",null,null,null,null,null,"EE Initial & Date:",null,null,null,null,null,"Total Compensable Hours This Period",null,null,null,null,null,{"$f":"SUM(U23,U38)","v":0},{"$f":"SUM(V38,V23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Straight Time Earned This Week",null,null,null,null,null,{"$f":"IF((U38-K38-1.666667>0),((U38-K38-1.666667)),0)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"Sup. Initial & Date",null,null,null,null,null,"Time-and-a-Half (Calculated)",null,null,null,null,null,{"$f":"K38*1.5","v":0},{"$f":"U38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Comp Time",null,null,null,null,null,{"$f":"SUM(U40:U41)","v":0},{"$f":"IF(AND(SUM(N37:P37,R37)>0, U38-1.666667> 0),U38-1.666667,0)","v":0}]
[]
[null,null,"Day of Week","Pay Period Date",null,null,null,null,"Interim",null,"Total Hrs. Worked",null,"Other Hours Used"]
[null,null,null,null,"In","Out","In","Out","Out","In",null,null,"Hol.","Vac.","Sick","Comp.","Ed/Fit.","CEA","Wea.","Other","Total","LWOP"]
[null,null,"Sun.",{"$f":"IF(ISERROR(D36+1),\"\",IF(D36+1<100,\"\",D36+1))","v":""},null,null,null,null,null,null,{"$f":"SUM((F46-E46)+(H46-G46)-(J46-I46))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM((F46-E46)+(H46-G46)-(J46-I46)+M46+N46+O46+P46+Q46+R46+S46+T46+V46)","v":0}]
[null,null,"Mon.",{"$f":"IF(ISERROR(D46+1),\"\",IF(D46+1<100,\"\",D46+1))","v":""},null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"SUM((F47-E47)+(H47-G47)-(J47-I47)+M47+N47+O47+P47+Q47+R47+S47+T47+V47)","v":0}]
[null,null,"Tues.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Wed.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Thurs.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Fri.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Sat.","",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total Hrs Worked This Week",null,null,null,null,null,null,null,{"$f":"SUM(K46:K52)","v":0},null,{"$f":"SUM(M46:M52)","v":0},0,0,0,{"$f":"SUM(Q46:Q52)","v":0},0,0,{"$f":"SUM(T46:T52)","v":0},null,{"$f":"SUM(V46:V52)","v":0}]
[null,null,"*Hrs Worked Over 40",null,null,null,null,null,null,null,{"$f":"IF(K53-1.666667>0,K53-1.666667,0)","v":0},null,null,null,"Total Compensable Hours This Week",null,null,null,null,null,{"$f":"K53+SUM(M53:T53)+V53","v":0},{"$f":"SUM(V46:V52)","v":0}]
["Employee Certification:",null,"Notes:",null,null,null,null,null,"EE Initial & Date:",null,null,null,null,null,"Total Compensable Hours This Period",null,null,null,null,null,{"$f":"SUM(U39,U54)","v":0},{"$f":"SUM(V54,V39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Straight Time Earned This Week",null,null,null,null,null,{"$f":"IF((U54-K54-1.666667>0),((U54-K54-1.666667)),0)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"Sup. Initial & Date",null,null,null,null,null,"Time-and-a-Half (Calculated)",null,null,null,null,null,{"$f":"K54*1.5","v":0},{"$f":"U54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Comp Time",null,null,null,null,null,{"$f":"SUM(U56:U57)","v":0},{"$f":"IF(AND(SUM(N53:P53,R53)>0, U54-1.666667> 0),U54-1.666667,0)","v":0}]
[]
[null,null,"Day of Week","Pay Period Date",null,null,null,null,"Interim",null,"Total Hrs. Worked",null,"Other Hours Used"]
[null,null,null,null,"In","Out","In","Out","Out","In",null,null,"Hol.","Vac.","Sick","Comp.","Ed/Fit.","CEA","Wea.","Other","Total","LWOP"]
[null,null,"Sun.",{"$f":"IF(ISERROR(D52+1),\"\",IF(D52+1<100,\"\",D52+1))","v":""},null,null,null,null,null,null,{"$f":"SUM((F62-E62)+(H62-G62)-(J62-I62))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM((F62-E62)+(H62-G62)-(J62-I62)+M62+N62+O62+P62+Q62+R62+S62+T62+V62)","v":0}]
[]
[null,null,"1. Time \"In\" & \"out\" should be entered to the minute, i.e. 7:55 AM or in military time 13:00 with a semi colon. \n2. Time sheets should be turned in to your supervisor no later than 10:00 A.M. on  Monday and the day following pay day.\n*NOTE: An Authorization for Compensatory Time form should be on file for all overtime.",null,null,null,null,null,"EE Initial & Date:",null,null,null,{"$f":"M62","v":0},0,0,0,{"$f":"SUM(Q57:Q63)","v":0},0,0,0,null,{"$f":"V62","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Compensable Hours This Week",null,null,null,null,null,{"$f":"(K63+SUM(M64:T64)+V64)","v":0},{"$f":"V62","v":0}]
[null,null,null,null,null,null,null,null,"Sup. Initial & Date",null,null,null,null,null,"Total Hrs. This Pay Period",null,null,null,null,null,{"$f":"SUM(U65,U55)","v":0},{"$f":"SUM(V65,V55)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Revised 12/09/2016"]