{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Important Info","Certification of Time","Example"],"not_rendered":{"charts":0,"images":1,"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":"Important Info","index":0,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[[14,2,14,15],[53,1,53,14],[24,0,33,16],[35,0,38,16],[18,1,18,5]]}
[]
[null,"INSTRUCTIONS FOR BI-ANNUAL CERTIFICATION OF TIME WORKSHEET"]
[]
[null,1,"Complete LEA # and LEA Name."]
[null,2,"Complete information for each employee."]
[null,3,"Complete Director's Signature and date by typing in cells.  No need to print and sign.  Provide to auditor in electronic form."]
[null,4,"Add or delete rows as necessary to accommodate number of 100% special education employees."]
[]
[null,"IMPORTANT INFORMATION"]
[]
[null,"•","Orange highlighted cells indicate an area where the user should input data."]
[null,"•","The Bi-Annual Certification of Time must be completed twice a year (end of first semester and end of second semester)."]
[null,"•","If an employee's assignments and duties are not 100% special education, a Personnel Activity Report must be completed."]
[null,"•","You may provide the completed document to your auditor as an excel file."]
[null,"•","Cutting data will cause formula errors in protected cells so we have disabled the cut function in the worksheet. Instead, copy and paste, then go back to original cell and delete data."]
[]
[null,"EXAMPLE BI-ANNUAL CERTIFICATION OF TIME WORKSHEET"]
[]
[null,"See example worksheet or click here."]
[]
[]
[]
[]
[]
["Bi-Annual Certification of Time\nUpdated 6/29/2023\n\n\nKansas leads the world in the success of each student."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The Kansas State Department of Education does not discriminate on the basis of race, color, national origin, sex, disability, or age in its programs and activities and provides equal access to the Boy Scouts and other designated youth groups. The following person has been designated to handle inquiries regarding the nondiscrimination policies: KSDE General Counsel, Office of General Counsel, KSDE, Landon State Office Building, 900 S.W. Jackson, Suite 102, Topeka, KS 66612, (785) 296-3204."]

{"sheet":"Certification of Time","index":1,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5],[5,4,5,5],[4,4,4,5],[54,1,54,5],[35,1,35,5],[38,1,38,2],[37,1,37,2],[6,1,6,5],[45,0,52,5]]}
[]
[null,"Special Education"]
[null,"Bi-Annual Certification of Time"]
[]
[]
[null,"LEA #",null,null,"LEA Name"]
[]
[null,"Number","Name","ID Number","Building","LEA Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"I certify that I have firsthand knowledge that the employees listed above have assignments and duties that are 100% special education."]
[]
[]
[null,"Director's Name",null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
["Bi-Annual Certification of Time\nUpdated 6/29/2023\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example","index":2,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[37,1,37,2],[38,1,38,2],[45,0,52,5],[54,1,54,5],[1,1,1,5],[2,1,2,5],[4,4,4,5],[5,4,5,5],[6,1,6,5],[35,1,35,5]]}
[]
[null,"Special Education"]
[null,"Bi-Annual Certification of Time"]
[]
[null,10050,null,null,"Meadowlark Special Education Coop"]
[null,"LEA #",null,null,"LEA Name"]
[]
[null,"Number","Name","ID Number","Building","LEA Notes"]
[null,1,"Sunflower, Steve","XXXXX-XXXXXXXXXX",1000,"Early Childhood"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"I certify that I have firsthand knowledge that the employees listed above have assignments and duties that are 100% special education."]
[]
[null,"Kathleen Q Boxx",null,null,null,"2019-05-31"]
[null,"Director's Name",null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
["Bi-Annual Certification of Time\nUpdated 7/15/20\n\n\nKansas leads the world in the success of each student."]