{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Time sheet","Sheet1"],"not_rendered":{"images":5,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Time sheet","index":0,"n_rows":70,"n_cols":31,"rows_kept":70,"merged":[[1,20,1,30],[2,13,2,14],[2,16,2,17],[20,2,20,6],[31,2,31,6],[56,15,56,16],[56,21,56,23],[56,27,56,29],[58,15,58,16],[58,21,58,23],[58,27,58,29]]}
[null,null,"COLORADO SPRINGS SCHOOL DISTRICT 11"]
[null,null,"ESP Timesheet",{"$nulls":7},"                     Primary Job",{"$nulls":9},"Extra Duties"]
[{"$nulls":13},"Leave Taken",null,null,"Primary Job:",{"$nulls":3},"Crossing Guard",null,null,"Lunch Rm Aide",null,null,"Extra Duty 1",null,null,"Extra Duty 2"]
[{"$nulls":9},"Day","Date","Hrs Worked",null,"Hrs","Type",null,"OT","Extra Hrs",null,null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs"]
[{"$nulls":9},"Sun",{"$nulls":4},"",null,null,{"$f":"L5","v":0}]
[null,null,"Employee Name",{"$nulls":3},"Empl ID",null,null,"Mon",{"$nulls":4},"",null,null,{"$f":"IF(O6=\"Non Contract Day\", L6, (SUM(L6+N6-C17)))","v":0}]
[{"$nulls":9},"Tue",{"$nulls":4},"",null,null,{"$f":"IF(O7=\"Non Contract Day\", L7, (SUM(L7+N7-C17)))","v":0}]
[{"$nulls":9},"Wed",{"$nulls":4},"",null,null,{"$f":"IF(O8=\"Non Contract Day\", L8, (SUM(L8+N8-C17)))","v":0}]
[null,null,"Job Title",{"$nulls":3},"Month/Year",null,null,"Thurs",{"$nulls":4},"",null,null,{"$f":"IF(O9=\"Non Contract Day\", L9, (SUM(L9+N9-C17)))","v":0}]
[{"$nulls":9},"Fri",{"$nulls":4},"",null,null,{"$f":"IF(O10=\"Non Contract Day\", L10, (SUM(L10+N10-C17)))","v":0}]
[{"$nulls":9},"Sat",{"$nulls":4},"",null,null,{"$f":"L11","v":0}]
[null,null,"Work Location",{"$nulls":6},"Total",null,{"$f":"SUM(L5:L11)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"MAX(0,L12- 40)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0, SUM(R5:R11)-Q12)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(U5:U11)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(V5:V11)","v":{"v":0,"d":"0.00"}}," ",{"$f":"SUM(X5:X11)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Y5:Y11)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AA5:AA11)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AB5:AB11)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AD5:AD11)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AE5:AE11)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":6},{"$f":"C14*1.5","v":{"v":0,"d":"$0.00"}},null,null,"Day","Date","Hrs Worked",null,"Hrs","Type",null,"OT","Extra Hrs",null,null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs"]
[null,null,"Hourly Rate",{"$nulls":3},"OT Rate",null,null,"Sun",{"$nulls":4},"",null,null,{"$f":"L15","v":0}]
[{"$nulls":9},"Mon",{"$nulls":4},"",null,null,{"$f":"IF(O16=\"Non Contract Day\", L16, (SUM(L16+N16-C17)))","v":0}]
[{"$nulls":6},"",null,null,"Tue",{"$nulls":4},"",null,null,{"$f":"IF(O17=\"Non Contract Day\", L17, (SUM(L17+N17-C17)))","v":0}]
[null,null,"Reg Scheduled Daily Hours - REQUIRED",{"$nulls":6},"Wed",{"$nulls":4},"",null,null,{"$f":"IF(O18=\"Non Contract Day\", L18, (SUM(L18+N18-C17)))","v":0}]
[{"$nulls":9},"Thurs",{"$nulls":4},"",null,null,{"$f":"IF(O19=\"Non Contract Day\", L19, (SUM(L19+N19-C17)))","v":0}]
[{"$nulls":9},"Fri",{"$nulls":4},"",null,null,{"$f":"IF(O20=\"Non Contract Day\", L20, (SUM(L20+N20-C17)))","v":0}]
[null,null,"Extra Work Hours",{"$nulls":6},"Sat",{"$nulls":4},"",null,null,{"$f":"L21","v":0}]
[{"$nulls":9},"Total ",null,{"$f":"SUM(L15:L21)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"MAX(0,L22- 40)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0, SUM(R15:R21)-Q22)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(U15:U21)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(V15:V21)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(X15:X21)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Y15:Y21)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AA15:AA21)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AB15:AB21)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AD15:AD21)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AE15:AE21)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Hours","Rate",null,"Total"]
[{"$nulls":9},"Day","Date","Hrs Worked",null,"Hrs","Type",null,"OT","Extra Hrs",null,null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs"]
[null,null,"Extra hours",{"$f":"SUM(R12+R22+R32+R42+R52)","v":{"v":0,"d":"0.00"}},{"$f":"C14","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D25*E25)","v":{"v":0,"d":"$0.00"}},null,null,"Sun",{"$nulls":4},"",null,null,{"$f":"L25","v":0}]
[{"$nulls":9},"Mon ",{"$nulls":4},"",null,null,{"$f":"IF(O26=\"Non Contract Day\", L26, (SUM(L26+N26-C17)))","v":0}]
[null,null,"Acct No:",{"$nulls":6},"Tue",{"$nulls":4},"",null,null,{"$f":"IF(O27=\"Non Contract Day\", L27, (SUM(L27+N27-C17)))","v":0}]
[{"$nulls":9},"Wed",{"$nulls":4},"",null,null,{"$f":"IF(O28=\"Non Contract Day\", L28, (SUM(L28+N28-C17)))","v":0}]
[null,null,"Signature",{"$nulls":6},"Thurs",{"$nulls":4},"",null,null,{"$f":"IF(O29=\"Non Contract Day\", L29, (SUM(L29+N29-C17)))","v":0}]
[{"$nulls":9},"Fri     ",{"$nulls":4},"",null,null,{"$f":"IF(O30=\"Non Contract Day\", L30, (SUM(L30+N30-C17)))","v":0}]
[{"$nulls":9},"Sat",{"$nulls":4},"",null,null,{"$f":"L31","v":0}]
[null,null,"Overtime Work Hours",{"$nulls":6},"Total",null,{"$f":"SUM(L25:L31)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"MAX(0,L32- 40)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0, SUM(R25:R31)-Q32)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(U25:U31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(V25:V31)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(X25:X31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Y25:Y31)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AA25:AA31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AB25:AB31)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AD25:AD31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AE25:AE31)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":3},"Hours","Rate",null,"Total",null,null,"Day","Date","Hrs Worked",null,"Hrs","Type",null,"OT","Extra Hrs",null,null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs"]
[{"$nulls":9},"Sun",{"$nulls":4},"",null,null,{"$f":"L35","v":0}]
[null,null,"OT Hours",{"$f":"SUM(Q12+Q22+Q32+Q42+Q52)","v":{"v":0,"d":"0.00"}},{"$f":"C14*1.5","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(D36*E36)","v":{"v":0,"d":"$0.00"}},null,null,"Mon",{"$nulls":4},"",null,null,{"$f":"IF(O36=\"Non Contract Day\", L36, (SUM(L36+N36-C17)))","v":0}]
[{"$nulls":9},"Tue",{"$nulls":4},"",null,null,{"$f":"IF(O37=\"Non Contract Day\", L37, (SUM(L37+N37-C17)))","v":0}]
[null,null,"Acct No:",{"$nulls":6},"Wed",{"$nulls":4},"",null,null,{"$f":"IF(O38=\"Non Contract Day\", L38, (SUM(L38+N38-C17)))","v":0}]
[{"$nulls":9},"Thurs",{"$nulls":4},"",null,null,{"$f":"IF(O39=\"Non Contract Day\", L39, (SUM(L39+N39-C17)))","v":0}]
[null,null,"Signature",{"$nulls":6},"Fri     ",{"$nulls":4},"",null,null,{"$f":"IF(O40=\"Non Contract Day\", L40, (SUM(L40+N40-C17)))","v":0}]
[{"$nulls":9},"Sat ",{"$nulls":4},"",null,null,{"$f":"L41","v":0}]
[{"$nulls":9},"Total ",null,{"$f":"SUM(L35:L41)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"MAX(0,L42- 40)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0, SUM(R35:R41)-Q42)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(U35:U41)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(V35:V41)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(X35:X41)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Y35:Y41)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AA35:AA41)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AB35:AB41)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AD35:AD41)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AE35:AE41)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Comments/Notes:",{"$nulls":6},"Day","Date","Hrs Worked",null,"Hrs","Type",null,"OT","Extra Hrs",null,null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs",null,"Hours","OT Hrs"]
[{"$nulls":9},"Sun",{"$nulls":4},"",null,null,{"$f":"L45","v":0}]
[{"$nulls":9},"Mon",{"$nulls":4},"",null,null,{"$f":"IF(O46=\"Non Contract Day\", L46, (SUM(L46+N46-C17)))","v":0}]
[{"$nulls":9},"Tue",{"$nulls":4},"",null,null,{"$f":"IF(O47=\"Non Contract Day\", L47, (SUM(L47+N47-C17)))","v":0}]
[{"$nulls":9},"Wed",{"$nulls":4},"",null,null,{"$f":"IF(O48=\"Non Contract Day\", L48, (SUM(L48+N48-C17)))","v":0}]
[{"$nulls":9},"Thurs",{"$nulls":4},"",null,null,{"$f":"IF(O49=\"Non Contract Day\", L49, (SUM(L49+N49-C17)))","v":0}]
[{"$nulls":9},"Fri",{"$nulls":4},"",null,null,{"$f":"IF(O50=\"Non Contract Day\", L50, (SUM(L50+N50-C17)))","v":0}]
[{"$nulls":9},"Sat",{"$nulls":4},"",null,null,{"$f":"L51","v":0}]
[{"$nulls":9},"Total",null,{"$f":"SUM(L45:L51)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"MAX(0,L52- 40)","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0, SUM(R45:R51)-Q52)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(U45:U51)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(V45:V51)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(X45:X51)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Y45:Y51)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AA45:AA51)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AB45:AB51)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AD45:AD51)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AE45:AE51)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":16},{"$f":"SUM(Q12+Q22+Q32+Q42+Q52)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(R12+R22+R32+R42+R52)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(U52+U42+U32+U22+U12)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(V52+V42+V32+V22+V12)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(X52+X42+X32+X22+X12)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Y52+Y42+Y32+Y22+Y12)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AA52+AA42+AA32+AA22+AA12)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AB52+AB42+AB32+AB22+AB12)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AD52+AD42+AD32+AD22+AD12)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AE52+AE42+AE32+AE22+AE12)","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":9},"Extra Duty 1:",{"$nulls":4},"Extra Duty 2:",{"$nulls":7},"Crossing Guard",{"$nulls":5},"Lunch Room Aide"]
[{"$nulls":9},{"$f":"AA53","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J57*K57)","v":{"v":0,"d":"$0.00"}},null,null,{"$f":"AD53","v":{"v":0,"d":"0.00"}},null,null,{"$f":"O57*P57","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P57*R57)","v":{"v":0,"d":"$0.00"}},null,{"$f":"U53","v":{"v":0,"d":"0.00"}},{"v":12,"d":"$12.00"},null,null,{"$f":"SUM(U57*V57)","v":{"v":0,"d":"$0.00"}},null,{"$f":"X53","v":{"v":0,"d":"0.00"}},{"v":12,"d":"$12.00"},null,null,{"$f":"SUM(AA57*AB57)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},"HRS","             RATE","                TOTAL",null,null,"HRS                                 RATE",null,null,"        TOTAL",null,null,"HRS",null,"RATE",null,"TOTAL",null,"HRS",null,"RATE",null,"TOTAL"]
[null,"Employee Signature",null,null,"Date",{"$nulls":4},{"$f":"AB53","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J59*K59)","v":{"v":0,"d":"$0.00"}},null,null,{"$f":"AE53","v":{"v":0,"d":"0.00"}},null,null,{"$f":"O59*P59","v":{"v":0,"d":"$0.00"}},null,null,{"$f":"V53","v":{"v":0,"d":"0.00"}},{"v":18,"d":"$18.00"},null,null,{"$f":"SUM(U59*V59)","v":{"v":0,"d":"$0.00"}},null,{"$f":"Y53","v":{"v":0,"d":"0.00"}},{"v":18,"d":"$18.00"},null,null,{"$f":"SUM(AA59*AB59)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},"OT HRS","          OT RATE","                TOTAL",null,null,"OT HRS                         OT RATE",null,null,"        TOTAL",null,null,"OT HRS",null,"OT RATE",null,"TOTAL",null,"OT HRS",null,"OT RATE",null,"TOTAL"]
[{"$nulls":9},"Acct No.",{"$nulls":4},"Acct No.",{"$nulls":5},"Earn Code: CRC",{"$nulls":5},"Earn Code: LRA"]
[null,"Supervisor Signature                                                  ",null,null,"Date",{"$nulls":4},"Signature",{"$nulls":4},"Signature",{"$nulls":5},"Signature",{"$nulls":5},"Signature"]
[{"$nulls":26},"Most schools pay for their lunch room aides"]
[null,null,"All extra hours and overtime hours must be pre-approved by the employee's supervisor."]
[null,null,"FLEX time (under 40 hours) is the flexibility of hours within the same week. Supervisors may approve flexing of hours from Sunday through Saturday.  Time may not be carried over to the next week."]
[null,null,"Schools and Departments must retain a copy of the signed time sheet in an accessible file for three years from the date of completion. For Instructional of Group Activity Stipend use Acct No. 10-681-00-009CA-0150(4 or 2)0-0000. ESP still need a waiver from CSEA."]
[]
[]
[]
[null,null,"Updated 7.10.2019"]

{"sheet":"Sheet1","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"hidden":true}
[]
["Non Contract Day"]
["Sick Leave"]
["Personal Leave"]
["Vacation"]
["Bereavement"]
["Jury Duty"]
["Military"]
["Worker's Compensation"]
["Leave W/O Pay"]