{"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 certification area (date of school closure, response to COVID-19 question, Director Name (electronic signature), and date completed at bottom of 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 10/25/19\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":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[43,3,43,5],[40,3,40,5],[1,1,1,5],[2,1,2,5],[5,4,5,5],[4,4,4,5],[62,1,62,5],[46,1,46,2],[45,1,45,2],[6,1,6,5],[53,0,60,5],[39,1,39,5],[42,1,42,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,"Please complete all four sections below (orange highlights)."]
[]
[null,"I certify that I have firsthand knowledge that the employees listed above had assignments and duties that were 100% special education as of:",null,null,null,null,null,null,"Please select the appropriate date here."]
[null,null,"Please select the appropriate date here.","Select your district's last normally scheduled school day for 2019-20.",null,null,null,null,"2020-03-01"]
[null,null,null,null,null,null,null,null,"2020-03-03"]
[null,"After that date, were the duties of any employees listed above modified because of the COVID-19 pandemic?  ",null,null,null,null,null,null,"2020-03-04"]
[null,null,"Please select the appropriate response here.","Your response has no effect on funding for 2019-20",null,null,null,null,"2020-03-05",null,"Please select the appropriate response here."]
[null,null,null,null,null,null,null,null,"2020-03-06",null,"Yes"]
[null,null,null,null,null,null,null,null,"2020-03-07",null,"No"]
[null,"Director's Name",null,null,null,"Date",null,null,"2020-03-08"]
[null,null,null,null,null,null,null,null,"2020-03-09"]
[null,null,null,null,null,null,null,null,"2020-03-10"]
[null,null,null,null,null,null,null,null,"2020-03-11"]
[null,null,null,null,null,null,null,null,"2020-03-12"]
[null,null,null,null,null,null,null,null,"2020-03-13"]
[null,null,null,null,null,null,null,null,"2020-03-14"]
["Bi-Annual Certification of Time\nUpdated 4/1/20\n\n\nKansas leads the world in the success of each student.",null,null,null,null,null,null,null,"2020-03-15"]
[null,null,null,null,null,null,null,null,"2020-03-16"]
[null,null,null,null,null,null,null,null,"2020-03-17"]
[null,null,null,null,null,null,null,null,"2020-03-18"]
[null,null,null,null,null,null,null,null,"2020-03-19"]
[null,null,null,null,null,null,null,null,"2020-03-20"]
[null,null,null,null,null,null,null,null,"2020-03-21"]
[null,null,null,null,null,null,null,null,"2020-03-22"]
[null,null,null,null,null,null,null,null,"2020-03-23"]
[null,null,null,null,null,null,null,null,"2020-03-24"]
[null,null,null,null,null,null,null,null,"2020-03-25"]
[null,null,null,null,null,null,null,null,"2020-03-26"]
[null,null,null,null,null,null,null,null,"2020-03-27"]
[null,null,null,null,null,null,null,null,"2020-03-28"]
[null,null,null,null,null,null,null,null,"2020-03-29"]
[null,null,null,null,null,null,null,null,"2020-03-30"]
[null,null,null,null,null,null,null,null,"2020-03-31"]

{"sheet":"Example","index":2,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[73,1,73,5],[51,3,51,5],[53,1,53,5],[54,3,54,5],[56,1,56,2],[57,1,57,2],[64,0,71,5],[1,1,1,5],[2,1,2,5],[4,4,4,5],[5,4,5,5],[6,1,6,5],[50,1,50,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","XXXX-XXXXXXXXX",1000,"Early Childhood"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please complete all four sections below (orange highlights)."]
[]
[null,"I certify that I have firsthand knowledge that the employees listed above had assignments and duties that were 100% special education as of:",null,null,null,null,null,null,"Please select the appropriate date here."]
[null,null,"2020-03-16","Select your district's last normally scheduled school day for 2019-20.",null,null,null,null,"2020-03-01"]
[null,null,null,null,null,null,null,null,"2020-03-03"]
[null,"After that date, were the duties of any employees listed above modified because of the COVID-19 pandemic?  ",null,null,null,null,null,null,"2020-03-04"]
[null,null,"Yes","Your response has no effect on funding for 2019-20",null,null,null,null,"2020-03-05",null,"Please select the appropriate response here."]
[null,null,null,null,null,null,null,null,"2020-03-06",null,"Yes"]
[null,"Kathleen Q Boxx",null,null,null,"2020-05-31",null,null,"2020-03-07",null,"No"]
[null,"Director's Name",null,null,null,"Date",null,null,"2020-03-08"]
[null,null,null,null,null,null,null,null,"2020-03-09"]
[null,null,null,null,null,null,null,null,"2020-03-10"]
[null,null,null,null,null,null,null,null,"2020-03-11"]
[null,null,null,null,null,null,null,null,"2020-03-12"]
[null,null,null,null,null,null,null,null,"2020-03-13"]
[null,null,null,null,null,null,null,null,"2020-03-14"]
["Bi-Annual Certification of Time\nUpdated 4/1/20\n\n\nKansas leads the world in the success of each student.",null,null,null,null,null,null,null,"2020-03-15"]
[null,null,null,null,null,null,null,null,"2020-03-16"]
[null,null,null,null,null,null,null,null,"2020-03-17"]
[null,null,null,null,null,null,null,null,"2020-03-18"]
[null,null,null,null,null,null,null,null,"2020-03-19"]
[null,null,null,null,null,null,null,null,"2020-03-20"]
[null,null,null,null,null,null,null,null,"2020-03-21"]
[null,null,null,null,null,null,null,null,"2020-03-22"]
[null,null,null,null,null,null,null,null,"2020-03-23"]
[null,null,null,null,null,null,null,null,"2020-03-24"]
[null,null,null,null,null,null,null,null,"2020-03-25"]
[null,null,null,null,null,null,null,null,"2020-03-26"]
[null,null,null,null,null,null,null,null,"2020-03-27"]
[null,null,null,null,null,null,null,null,"2020-03-28"]
[null,null,null,null,null,null,null,null,"2020-03-29"]
[null,null,null,null,null,null,null,null,"2020-03-30"]
[null,null,null,null,null,null,null,null,"2020-03-31"]