{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Important Info","ESL Worksheet","ESL Worksheet Example","Formulas"],"not_rendered":{"charts":0,"images":2,"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":68,"n_cols":30,"rows_kept":68,"cut":false,"hidden":false,"merged":[[58,1,58,5],[58,8,58,9],[58,17,58,22],[59,1,59,5],[59,8,59,9],[31,22,31,23],[40,17,40,20],[40,21,40,23],[41,21,41,23],[42,21,42,23],[54,21,54,23],[56,21,56,22],[46,21,46,23],[47,21,47,23],[48,21,48,23],[49,21,49,23],[50,21,50,23],[53,21,53,23],[51,21,51,23],[52,21,52,23],[44,21,44,23],[45,21,45,23],[37,3,37,9],[37,14,37,17],[37,22,37,23],[40,1,40,4],[40,5,40,8],[40,9,40,12],[40,13,40,16],[43,21,43,23],[35,3,35,9],[35,14,35,17],[35,22,35,23],[36,3,36,9],[36,14,36,17],[36,22,36,23],[33,3,33,9],[33,14,33,17],[33,22,33,23],[34,3,34,9],[34,14,34,17],[34,22,34,23],[32,3,32,9],[32,14,32,17],[32,22,32,23],[28,3,28,9],[28,11,28,13],[28,14,28,17],[28,19,28,21],[28,22,28,23],[29,3,29,9],[29,14,29,17],[29,22,29,23],[30,3,30,9],[30,14,30,17],[30,22,30,23],[31,3,31,9],[31,14,31,17],[25,4,25,10],[25,15,25,17],[25,18,25,23],[26,1,26,3],[26,4,26,10],[26,15,26,17],[26,18,26,23],[67,0,74,23],[76,0,77,23],[0,1,0,23],[9,1,9,23],[1,1,1,23],[17,2,17,23],[20,1,20,17],[7,2,7,23],[18,2,18,23],[22,1,22,23],[24,1,24,3],[24,4,24,10],[24,15,24,17],[24,18,24,23],[28,1,28,2],[25,1,25,3]]}
[]
[null,"INSTRUCTIONS FOR ESL WORKSHEET"]
[]
[null,1,"Complete student information, district information, teacher information and ESL provider information at top of worksheet."]
[null,2,"Complete provider (use initials), start time, and end time in table."]
[null,3,"Complete signature area by typing in ESL Director or Teacher name.  Then type in date completed."]
[null,4,"Average Daily Minutes calculated should be entered in KIDS."]
[null,5,"You can make a copy of the ESL Worksheet for each student (right click on the tab and select Move or Copy).  Then change the name of each tab to the student's name."]
[]
[null,"IMPORTANT INFORMATION"]
[]
[null,"•","Orange highlighted cells indicate an area where the user should input data."]
[null,"•","Blue highlighted cells indicate an area where the spreadsheet contains formulas and access is restricted."]
[null,"•","Always record actual start and end times when student received ESL services with a qualified teacher or para during count week."]
[null,"•","Minutes will compute automatically."]
[null,"•","Provide a copy of each teacher's/para's schedule to the auditor."]
[null,"•","When recording times, use normal clock time.  There is no need to use military time.  Don't use AM/PM."]
[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,"•","If the hashtag symbol (#) is being displayed in the spreadsheet, try adjusting the column width by dragging the column heading."]
[]
[null,"EXAMPLE - ESL WORKSHEET"]
[]
[null,"ESL Student Contact Minutes"]
[]
[null,"Student Name:",null,null,"Skip A. Stone",null,null,null,null,null,null,null,null,null,null,"USD:",null,null,1011]
[null,"Student ID:",null,null,"9999-0000",null,null,null,null,null,null,null,null,null,null,"School:",null,null,"Oz Valley Elementary",null,null,null,null,null,null,null,null,null,null,"Endorsed"]
[null,"Student Grade:",null,null,5,null,null,null,null,null,null,null,null,null,null,"Classroom Teacher:",null,null,"Martha Kent",null,null,null,null,null,null,null,null,null,null,"Plan on File"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRAXIS"]
[null,"Provider Name:",null,"Martha Kent",null,null,null,null,null,null,null,"Provider Assignment:",null,null,"Classroom Teacher",null,null,null,null,"Provider Status:",null,null,"Plan on File",null,null,null,null,null,null,"Paraprofessional"]
[null,null,null,"Lexi Luther",null,null,null,null,null,null,null,null,null,null,"ESL Teacher",null,null,null,null,null,null,null,"Endorsed"]
[null,null,null,"Matt Dillon",null,null,null,null,null,null,null,null,null,null,"ESL Para",null,null,null,null,null,null,null,"Paraprofessional"]
[null,null,null,"Gail D'Rothy",null,null,null,null,null,null,null,null,null,null,"Librarian",null,null,null,null,null,null,null,"PRAXIS"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2019-09-16",null,null,null,"2019-09-17",null,null,null,"2019-09-18",null,null,null,"2019-09-19",null,null,null,"2019-09-20"]
[null,"Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","District Notes"]
[null,"MK","09:00:00","11:31:00",{"$f":"IF(C43>D43,(D43+0.5)-C43,D43-C43)","v":0.10486111111111113},"MD","01:05:00","02:05:00",{"$f":"IF(G43>H43,(H43+0.5)-G43,H43-G43)","v":4.1666666666666678E-2},"MK","09:00:00","11:31:00",{"$f":"IF(K43>L43,(L43+0.5)-K43,L43-K43)","v":0.10486111111111113},"GD","12:00:00","12:35:00",{"$f":"IF(O43>P43,(P43+0.5)-O43,P43-O43)","v":2.430555555555558E-2},"MK","09:00:00","11:31:00",{"$f":"IF(S43>T43,(T43+0.5)-S43,T43-S43)","v":0.10486111111111113}]
[null,null,null,null,{"$f":"IF(C44>D44,(D44+0.5)-C44,D44-C44)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"LL","12:00:00","01:00:00",{"$f":"IF(C45>D45,(D45+0.5)-C45,D45-C45)","v":4.166666666666663E-2},null,null,null,0,"LL","12:00:00","01:00:00",4.166666666666663E-2,null,null,null,0,"LL","12:00:00","01:00:00",4.166666666666663E-2]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,{"$f":"IF(C53>D53,(D53+0.5)-C53,D53-C53)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Daily Total",null,null,{"$f":"SUM(E43:E54)","v":0.14652777777777776},"Daily Total",null,null,{"$f":"SUM(I43:I54)","v":4.1666666666666678E-2},"Daily Total",null,null,{"$f":"SUM(M43:M54)","v":0.14652777777777776},"Daily Total",null,null,{"$f":"SUM(Q43:Q54)","v":2.430555555555558E-2},"Daily Total",null,null,{"$f":"SUM(U43:U54)","v":0.14652777777777776}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly Total",null,{"$f":"SUM(E55:U55)","v":0.50555555555555554}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Daily Minutes (Enter this number in KIDS)",null,null,null,null,null,{"$f":"ROUND((X57/5)*1440,0)/1440","v":0.10138888888888889}]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
["ESL Contact Minutes Calculator\nUpdated 10/25/19\n\n\nKansas leads the world in the success of each student."]

{"sheet":"ESL Worksheet","index":1,"n_rows":50,"n_cols":30,"rows_kept":50,"cut":false,"hidden":false,"merged":[[7,22,7,23],[7,19,7,21],[8,22,8,23],[9,22,9,23],[7,3,7,9],[7,1,7,2],[12,3,12,9],[13,3,13,9],[10,3,10,9],[11,3,11,9],[19,13,19,16],[19,17,19,20],[38,1,38,5],[38,8,38,9],[37,8,37,9],[37,1,37,5],[37,17,37,22],[19,1,19,4],[19,5,19,8],[27,21,27,23],[28,21,28,23],[20,21,20,23],[9,3,9,9],[7,11,7,13],[8,3,8,9],[15,14,15,17],[16,14,16,17],[14,3,14,9],[16,3,16,9],[1,1,1,23],[3,4,3,10],[4,4,4,10],[5,4,5,10],[3,15,3,17],[4,15,4,17],[5,15,5,17],[3,18,3,23],[4,18,4,23],[5,18,5,23],[3,1,3,3],[4,1,4,3],[5,1,5,3],[7,14,7,17],[8,14,8,17],[9,14,9,17],[35,21,35,22],[10,22,10,23],[11,22,11,23],[12,22,12,23],[33,21,33,23],[19,21,19,23],[29,21,29,23],[30,21,30,23],[31,21,31,23],[32,21,32,23],[24,21,24,23],[25,21,25,23],[13,22,13,23],[49,0,56,23],[58,0,59,23],[14,22,14,23],[10,14,10,17],[11,14,11,17],[12,14,12,17],[13,14,13,17],[14,14,14,17],[15,22,15,23],[16,22,16,23],[26,21,26,23],[21,21,21,23],[22,21,22,23],[23,21,23,23],[15,3,15,9],[19,9,19,12]]}
[]
[null,"ESL Student Contact Minutes"]
[]
[null,"Student Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"USD:"]
[null,"Student ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,"School:"]
[null,"Student Grade:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Classroom Teacher:"]
[]
[null,"Provider Name:",null,null,null,null,null,null,null,null,null,"Provider Assignment:",null,null,null,null,null,null,null,"Provider Status:",null,null,null,null,null,null,null,null,null,"Endorsed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan on File"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRAXIS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paraprofessional"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2019-09-16",null,null,null,"2019-09-17",null,null,null,"2019-09-18",null,null,null,"2019-09-19",null,null,null,"2019-09-20"]
[null,"Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","District Notes"]
[null,null,null,null,{"$f":"IF(C22>D22,(D22+0.5)-C22,D22-C22)","v":0},null,null,null,{"$f":"IF(G22>H22,(H22+0.5)-G22,H22-G22)","v":0},null,null,null,{"$f":"IF(K22>L22,(L22+0.5)-K22,L22-K22)","v":0},null,null,null,{"$f":"IF(O22>P22,(P22+0.5)-O22,P22-O22)","v":0},null,null,null,{"$f":"IF(S22>T22,(T22+0.5)-S22,T22-S22)","v":0}]
[null,null,null,null,{"$f":"IF(C23>D23,(D23+0.5)-C23,D23-C23)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,{"$f":"IF(C24>D24,(D24+0.5)-C24,D24-C24)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,{"$f":"IF(C32>D32,(D32+0.5)-C32,D32-C32)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Daily Total",null,null,{"$f":"SUM(E22:E33)","v":0},"Daily Total",null,null,{"$f":"SUM(I22:I33)","v":0},"Daily Total",null,null,{"$f":"SUM(M22:M33)","v":0},"Daily Total",null,null,{"$f":"SUM(Q22:Q33)","v":0},"Daily Total",null,null,{"$f":"SUM(U22:U33)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly Total",null,{"$f":"SUM(E34:U34)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Daily Minutes (Enter this number in KIDS)",null,null,null,null,null,{"$f":"ROUND((X36/5)*1440,0)/1440","v":0}]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 10/25/19\n\n\nKansas leads the world in the success of each student."]

{"sheet":"ESL Worksheet Example","index":2,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":true,"merged":[[4,1,4,3],[4,4,4,10],[4,15,4,17],[4,18,4,23],[1,1,1,23],[3,1,3,3],[3,4,3,10],[3,15,3,17],[3,18,3,23],[5,1,5,3],[5,4,5,10],[5,15,5,17],[5,18,5,23],[7,1,7,2],[7,3,7,9],[7,11,7,13],[7,14,7,17],[7,19,7,21],[7,22,7,23],[8,3,8,9],[8,14,8,17],[8,22,8,23],[9,3,9,9],[9,14,9,17],[9,22,9,23],[10,3,10,9],[10,14,10,17],[10,22,10,23],[11,3,11,9],[11,14,11,17],[11,22,11,23],[12,3,12,9],[12,14,12,17],[12,22,12,23],[13,3,13,9],[13,14,13,17],[13,22,13,23],[14,3,14,9],[14,14,14,17],[14,22,14,23],[15,3,15,9],[15,14,15,17],[15,22,15,23],[16,3,16,9],[16,14,16,17],[16,22,16,23],[19,1,19,4],[19,5,19,8],[19,9,19,12],[19,13,19,16],[19,17,19,20],[19,21,19,23],[31,21,31,23],[20,21,20,23],[21,21,21,23],[22,21,22,23],[23,21,23,23],[24,21,24,23],[25,21,25,23],[26,21,26,23],[27,21,27,23],[28,21,28,23],[29,21,29,23],[30,21,30,23],[38,1,38,5],[38,8,38,9],[54,20,54,23],[55,20,55,23],[32,21,32,23],[33,21,33,23],[35,21,35,22],[37,1,37,5],[37,8,37,9],[37,17,37,22]]}
[]
[null,"ESL Student Contact Minutes"]
[]
[null,"Student Name:",null,null,"Skip A. Stone",null,null,null,null,null,null,null,null,null,null,"USD:",null,null,1078]
[null,"Student ID:",null,null,9999,null,null,null,null,null,null,null,null,null,null,"School:",null,null,"Oz Valley Elementary"]
[null,"Student Grade:",null,null,"Kindergarten",null,null,null,null,null,null,null,null,null,null,"Classroom Teacher:",null,null,"Martha Kent"]
[]
[null,"Provider Name:",null,"Martha Kent",null,null,null,null,null,null,null,"Provider Assignment:",null,null,"Classroom Teacher",null,null,null,null,"Provider Status:",null,null,"Plan on File",null,null,null,null,null,null,"Endorsed"]
[null,null,null,"Lexi Luther",null,null,null,null,null,null,null,null,null,null,"ESL Teacher",null,null,null,null,null,null,null,"Endorsed",null,null,null,null,null,null,"Plan on File"]
[null,null,null,"Matt Dillon",null,null,null,null,null,null,null,null,null,null,"ESL Para",null,null,null,null,null,null,null,"PRAXIS",null,null,null,null,null,null,"PRAXIS"]
[null,null,null,"Gail D'Rothy",null,null,null,null,null,null,null,null,null,null,"Librarian",null,null,null,null,null,null,null,"Paraprofessional",null,null,null,null,null,null,"Paraprofessional"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2018-09-17",null,null,null,"2018-09-18",null,null,null,"2018-09-19",null,null,null,"2018-09-20",null,null,null,"2018-09-21"]
[null,"Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","Provider","Start Time","End Time","Min","District Notes"]
[null,"MK","09:00:00","11:31:00",{"$f":"IF(C22>D22,(D22+0.5)-C22,D22-C22)","v":0.10486111111111113},"MD","01:05:00","02:05:00",{"$f":"IF(G22>H22,(H22+0.5)-G22,H22-G22)","v":4.1666666666666678E-2},"MK","09:00:00","11:31:00",{"$f":"IF(K22>L22,(L22+0.5)-K22,L22-K22)","v":0.10486111111111113},"GD","12:00:00","12:35:00",{"$f":"IF(O22>P22,(P22+0.5)-O22,P22-O22)","v":2.430555555555558E-2},"MK","09:00:00","11:31:00",{"$f":"IF(S22>T22,(T22+0.5)-S22,T22-S22)","v":0.10486111111111113}]
[null,"LL","12:00:00","01:00:00",{"$f":"IF(C23>D23,(D23+0.5)-C23,D23-C23)","v":4.166666666666663E-2},null,null,null,0,"LL","12:00:00","01:00:00",{"$f":"IF(K23>L23,(L23+0.5)-K23,L23-K23)","v":4.166666666666663E-2},null,null,null,{"$f":"IF(O23>P23,(P23+0.5)-O23,P23-O23)","v":0},"LL","12:00:00","01:00:00",{"$f":"IF(S23>T23,(T23+0.5)-S23,T23-S23)","v":4.166666666666663E-2}]
[null,null,null,null,{"$f":"IF(C24>D24,(D24+0.5)-C24,D24-C24)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,{"$f":"IF(C32>D32,(D32+0.5)-C32,D32-C32)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Daily Total",null,null,{"$f":"SUM(E22:E33)","v":0.14652777777777776},"Daily Total",null,null,{"$f":"SUM(I22:I33)","v":4.1666666666666678E-2},"Daily Total",null,null,{"$f":"SUM(M22:M33)","v":0.14652777777777776},"Daily Total",null,null,{"$f":"SUM(Q22:Q33)","v":2.430555555555558E-2},"Daily Total",null,null,{"$f":"SUM(U22:U33)","v":0.14652777777777776}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly Total",null,{"$f":"SUM(E34:U34)","v":0.50555555555555554}]
[]
[null,"Lexi Luther",null,null,null,null,null,null,"2018-09-28",null,null,null,null,null,null,null,null,"Average Daily Minutes (Enter this number in KIDS)",null,null,null,null,null,{"$f":"ROUND((X36/5)*1440,0)/1440","v":0.10138888888888889}]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Kansas State Department of Education"]
[null,null,null,null,"Fiscal Auditing"]
[null,null,null,null,"785-296-4976",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESL Contact Minutes Calculator"]
[null,null,null,null,"https://www.ksde.org/Agency/Fiscal-and-Administrative-Services/Fiscal-Auditing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 6/17/18"]

{"sheet":"Formulas","index":3,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Cell","D22"]
["Heading","Minutes"]
["Formula"," =IF(C22>D22,(D22+0.5)-C22,D22-C22)"]
["Translation","If start time is greater than end time, add .5 to end time, then subtract from start time.  If start time is not greater than end time, subtract starte time from end time."]
[]
["Cell","E36"]
["Heading","Daily Total"]
["Formula"," =SUM(E22:E33)"]
["Translation","adds up all minutes served in the day"]
[]
["Cell","T39"]
["Heading","Weekly Total"]
["Formula"," =SUM(E36:U36)"]
["Translation","Adds up all the daily totals."]
[]
["Cell","T42"]
["Heading","Daily Average"]
["Formula"," =ROUND((T39/5)*1440,0)/1440"]
["Translation","Weekly total minutes divided by 5 (to get average daily minutes), then converted from decimal to actual minutes and rounded"]