{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Important Info","ESL Calculator - 1 week","ESL Calculator - 2 week","Example 1","Example 2","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":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,2,3,23],[29,0,36,23],[0,1,0,23],[11,1,11,23],[1,1,1,23],[19,2,19,23],[22,1,22,17],[8,2,8,23],[20,2,20,23]]}
[]
[null,"INSTRUCTIONS FOR ESL CALCULATOR"]
[]
[null,1,"Choose between the 1 week or 2 week calculator in order to provide an accurate snapshot of ESL services provided to the student.\n     1 week calculator:  Use this calculator when the same services are scheduled each week.\n     2 week calculator:  Use this calculator when there is an every other week rotating schedule for services.\nWhen using the 2 week calculator, time must be entered into both weeks for the formula to operate correctly."]
[null,2,"Complete student information, district information, teacher information and ESL provider information at top of worksheet."]
[null,3,"Complete provider (use initials), start time, and end time in table.  Please input in sequential order (i.e. 8am then 9am)."]
[null,4,"Complete signature area by typing in ESL Director or Teacher name.  Then type in date completed.  No need to print and sign"]
[null,5,"Average Daily Minutes calculated should be entered in KIDS."]
[null,6,"You can make a copy of the ESL Calculator 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,7,"Provide to auditor in electronic file."]
[]
[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,"EXAMPLES - ESL STUDENT CONTACT MINUTES CALCULATORS"]
[]
[null,"Example 1","ESL Calculator - 1 week"]
[null,"Example 2","ESL Calculator - 2 week"]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 5/30/2024\n\n\nKansas leads the world in the success of each student."]

{"sheet":"ESL Calculator - 1 week","index":1,"n_rows":54,"n_cols":30,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,0,60,23],[62,0,63,23],[18,22,18,23],[14,14,14,17],[15,14,15,17],[16,14,16,17],[17,14,17,17],[18,14,18,17],[19,22,19,23],[20,22,20,23],[30,21,30,23],[25,21,25,23],[26,21,26,23],[27,21,27,23],[19,3,19,9],[14,22,14,23],[15,22,15,23],[16,22,16,23],[37,21,37,23],[23,21,23,23],[33,21,33,23],[34,21,34,23],[35,21,35,23],[36,21,36,23],[28,21,28,23],[29,21,29,23],[17,22,17,23],[19,14,19,17],[20,14,20,17],[18,3,18,9],[20,3,20,9],[1,1,1,23],[7,4,7,10],[8,4,8,10],[9,4,9,10],[7,15,7,17],[8,15,8,17],[9,15,9,17],[7,18,7,23],[8,18,8,23],[9,18,9,23],[7,1,7,3],[8,1,8,3],[23,13,23,16],[23,17,23,20],[42,1,42,5],[42,8,42,9],[41,8,41,9],[41,1,41,5],[41,17,41,22],[23,1,23,4],[23,5,23,8],[31,21,31,23],[32,21,32,23],[24,21,24,23],[23,9,23,12],[39,21,39,22],[16,3,16,9],[17,3,17,9],[14,3,14,9],[15,3,15,9],[13,3,13,9],[3,1,3,23],[11,22,11,23],[11,19,11,21],[12,22,12,23],[13,22,13,23],[11,3,11,9],[11,11,11,13],[11,1,11,2],[12,3,12,9],[9,1,9,3],[11,14,11,17],[12,14,12,17],[13,14,13,17]]}
[]
[null,"ESL Student Contact Minutes - 1 week"]
[]
[null,"Use this calculator when the same services are scheduled every week."]
[]
[]
[]
[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,"2024-09-16",null,null,null,"2024-09-17",null,null,null,"2024-09-18",null,null,null,"2024-09-19",null,null,null,"2024-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(C26>D26,(D26+0.5)-C26,D26-C26)","v":0},null,null,null,{"$f":"IF(G26>H26,(H26+0.5)-G26,H26-G26)","v":0},null,null,null,{"$f":"IF(K26>L26,(L26+0.5)-K26,L26-K26)","v":0},null,null,null,{"$f":"IF(O26>P26,(P26+0.5)-O26,P26-O26)","v":0},null,null,null,{"$f":"IF(S26>T26,(T26+0.5)-S26,T26-S26)","v":0}]
[null,null,null,null,{"$f":"IF(C27>D27,(D27+0.5)-C27,D27-C27)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,{"$f":"IF(C28>D28,(D28+0.5)-C28,D28-C28)","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(C36>D36,(D36+0.5)-C36,D36-C36)","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(E26:E37)","v":0},"Daily Total",null,null,{"$f":"SUM(I26:I37)","v":0},"Daily Total",null,null,{"$f":"SUM(M26:M37)","v":0},"Daily Total",null,null,{"$f":"SUM(Q26:Q37)","v":0},"Daily Total",null,null,{"$f":"SUM(U26:U37)","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(E38:U38)","v":0}]
[null,"I certify that I have firsthand knowledge that the information above is true and accurate."]
[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((X40/5)*1440,0)/1440","v":0}]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 5/30/2024\n\n\nKansas leads the world in the success of each student."]

{"sheet":"ESL Calculator - 2 week","index":2,"n_rows":70,"n_cols":30,"rows_kept":70,"cut":false,"hidden":false,"merged":[[6,1,6,3],[6,4,6,10],[6,15,6,17],[6,18,6,23],[3,1,3,23],[1,1,1,23],[5,1,5,3],[5,4,5,10],[5,15,5,17],[5,18,5,23],[7,1,7,3],[7,4,7,10],[7,15,7,17],[7,18,7,23],[9,1,9,2],[9,3,9,9],[9,11,9,13],[9,14,9,17],[9,19,9,21],[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],[17,3,17,9],[17,14,17,17],[17,22,17,23],[18,3,18,9],[18,14,18,17],[18,22,18,23],[21,1,21,4],[21,5,21,8],[21,9,21,12],[21,13,21,16],[21,17,21,20],[21,21,21,23],[33,21,33,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],[31,21,31,23],[32,21,32,23],[34,21,34,23],[35,21,35,23],[37,21,37,22],[57,1,57,5],[57,8,57,9],[40,21,40,23],[41,21,41,23],[42,21,42,23],[43,21,43,23],[36,21,36,22],[49,21,49,23],[57,16,57,22],[50,21,50,23],[51,21,51,23],[52,21,52,23],[53,21,53,23],[58,1,58,5],[58,8,58,9],[69,0,76,23],[78,0,79,23],[39,1,39,4],[39,5,39,8],[39,9,39,12],[39,13,39,16],[39,17,39,20],[39,21,39,23],[54,21,54,22],[44,21,44,23],[45,21,45,23],[46,21,46,23],[47,21,47,23],[48,21,48,23]]}
[]
[null,"ESL Student Contact Minutes - 2 week"]
[]
[null,"Use this calculator when an every other week rotating schedule is used to provide services.  Time must be entered into both weeks below for the formula to operate correctly."]
[]
[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,"2024-09-16",null,null,null,"2024-09-17",null,null,null,"2024-09-18",null,null,null,"2024-09-19",null,null,null,"2024-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(C24>D24,(D24+0.5)-C24,D24-C24)","v":0},null,null,null,{"$f":"IF(G24>H24,(H24+0.5)-G24,H24-G24)","v":0},null,null,null,{"$f":"IF(K24>L24,(L24+0.5)-K24,L24-K24)","v":0},null,null,null,{"$f":"IF(O24>P24,(P24+0.5)-O24,P24-O24)","v":0},null,null,null,{"$f":"IF(S24>T24,(T24+0.5)-S24,T24-S24)","v":0}]
[null,null,null,null,{"$f":"IF(C25>D25,(D25+0.5)-C25,D25-C25)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,null,null,null,{"$f":"IF(C26>D26,(D26+0.5)-C26,D26-C26)","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(C34>D34,(D34+0.5)-C34,D34-C34)","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(E24:E35)","v":0},"Daily Total",null,null,{"$f":"SUM(I24:I35)","v":0},"Daily Total",null,null,{"$f":"SUM(M24:M35)","v":0},"Daily Total",null,null,{"$f":"SUM(Q24:Q35)","v":0},"Daily Total",null,null,{"$f":"SUM(U24:U35)","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(E36:U36)","v":0}]
[]
[]
[null,"2024-09-23",null,null,null,"2024-09-25",null,null,null,"2024-09-26",null,null,null,"2024-09-27",null,null,null,"2024-09-28"]
[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(C42>D42,(D42+0.5)-C42,D42-C42)","v":0},null,null,null,{"$f":"IF(G42>H42,(H42+0.5)-G42,H42-G42)","v":0},null,null,null,{"$f":"IF(K42>L42,(L42+0.5)-K42,L42-K42)","v":0},null,null,null,{"$f":"IF(O42>P42,(P42+0.5)-O42,P42-O42)","v":0},null,null,null,{"$f":"IF(S42>T42,(T42+0.5)-S42,T42-S42)","v":0}]
[null,null,null,null,{"$f":"IF(C43>D43,(D43+0.5)-C43,D43-C43)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[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,null,null,null,{"$f":"IF(C45>D45,(D45+0.5)-C45,D45-C45)","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,{"$f":"IF(C52>D52,(D52+0.5)-C52,D52-C52)","v":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,"Daily Total",null,null,{"$f":"SUM(E42:E53)","v":0},"Daily Total",null,null,{"$f":"SUM(I42:I53)","v":0},"Daily Total",null,null,{"$f":"SUM(M42:M53)","v":0},"Daily Total",null,null,{"$f":"SUM(Q42:Q53)","v":0},"Daily Total",null,null,{"$f":"SUM(U42:U53)","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(E54:U54)","v":0}]
[]
[null,"I certify that I have firsthand knowledge that the information above is true and accurate."]
[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,null,{"$f":"ROUND(((X37+X55)/10)*1440,0)/1440","v":0}]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 5/30/2024\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example 1","index":3,"n_rows":54,"n_cols":30,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,1,23],[3,1,3,23],[7,1,7,3],[7,4,7,10],[7,15,7,17],[7,18,7,23],[11,22,11,23],[8,1,8,3],[8,4,8,10],[8,15,8,17],[8,18,8,23],[9,1,9,3],[9,4,9,10],[9,15,9,17],[9,18,9,23],[11,1,11,2],[11,3,11,9],[11,11,11,13],[11,14,11,17],[11,19,11,21],[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],[17,3,17,9],[17,14,17,17],[17,22,17,23],[18,3,18,9],[18,14,18,17],[18,22,18,23],[19,3,19,9],[19,14,19,17],[19,22,19,23],[20,3,20,9],[20,14,20,17],[20,22,20,23],[23,1,23,4],[23,5,23,8],[23,9,23,12],[23,13,23,16],[23,17,23,20],[23,21,23,23],[35,21,35,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],[42,1,42,5],[42,8,42,9],[53,0,60,23],[62,0,63,23],[2,1,2,23],[36,21,36,23],[37,21,37,23],[39,21,39,22],[41,1,41,5],[41,8,41,9],[41,17,41,22],[30,21,30,23],[31,21,31,23],[32,21,32,23],[33,21,33,23],[34,21,34,23]]}
[]
[null,"ESL Student Contact Minutes Calculator - 1 Week"]
[null,"EXAMPLE 1"]
[null,"Use this calculator when the same services are scheduled every week."]
[]
[]
[]
[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,"Student Grade:",null,null,5,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,"Paraprofessional",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,"PRAXIS",null,null,null,null,null,null,"Paraprofessional"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2020-09-21",null,null,null,"2020-09-22",null,null,null,"2020-09-23",null,null,null,"2020-09-24",null,null,null,"2020-09-25"]
[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(C26>D26,(D26+0.5)-C26,D26-C26)","v":0.10486111111111113},"MD","01:05:00","02:05:00",{"$f":"IF(G26>H26,(H26+0.5)-G26,H26-G26)","v":4.1666666666666678E-2},"MK","09:00:00","11:31:00",{"$f":"IF(K26>L26,(L26+0.5)-K26,L26-K26)","v":0.10486111111111113},"GD","12:00:00","12:35:00",{"$f":"IF(O26>P26,(P26+0.5)-O26,P26-O26)","v":2.430555555555558E-2},"MK","09:00:00","11:31:00",{"$f":"IF(S26>T26,(T26+0.5)-S26,T26-S26)","v":0.10486111111111113}]
[null,null,null,null,{"$f":"IF(C27>D27,(D27+0.5)-C27,D27-C27)","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(C28>D28,(D28+0.5)-C28,D28-C28)","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(C36>D36,(D36+0.5)-C36,D36-C36)","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(E26:E37)","v":0.14652777777777776},"Daily Total",null,null,{"$f":"SUM(I26:I37)","v":4.1666666666666678E-2},"Daily Total",null,null,{"$f":"SUM(M26:M37)","v":0.14652777777777776},"Daily Total",null,null,{"$f":"SUM(Q26:Q37)","v":2.430555555555558E-2},"Daily Total",null,null,{"$f":"SUM(U26:U37)","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(E38:U38)","v":0.50555555555555554}]
[null,"I certify that I have firsthand knowledge that the information above is true and accurate."]
[null,"Jane Smith, ESL Director",null,null,null,null,null,null,"2020-10-01",null,null,null,null,null,null,null,null,"Average Daily Minutes (Enter this number in KIDS)",null,null,null,null,null,{"$f":"ROUND((X40/5)*1440,0)/1440","v":0.10138888888888889}]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 8/20/20\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example 2","index":4,"n_rows":70,"n_cols":30,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,1,1,23],[3,1,3,23],[5,1,5,3],[5,4,5,10],[5,15,5,17],[5,18,5,23],[9,22,9,23],[6,1,6,3],[6,4,6,10],[6,15,6,17],[6,18,6,23],[7,1,7,3],[7,4,7,10],[7,15,7,17],[7,18,7,23],[9,1,9,2],[9,3,9,9],[9,11,9,13],[9,14,9,17],[9,19,9,21],[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],[17,3,17,9],[17,14,17,17],[17,22,17,23],[18,3,18,9],[18,14,18,17],[18,22,18,23],[21,1,21,4],[21,5,21,8],[21,9,21,12],[21,13,21,16],[21,17,21,20],[21,21,21,23],[33,21,33,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],[31,21,31,23],[32,21,32,23],[34,21,34,23],[35,21,35,23],[36,21,36,22],[37,21,37,22],[39,1,39,4],[39,5,39,8],[39,9,39,12],[39,13,39,16],[39,17,39,20],[39,21,39,23],[51,21,51,23],[40,21,40,23],[41,21,41,23],[42,21,42,23],[43,21,43,23],[44,21,44,23],[45,21,45,23],[58,1,58,5],[58,8,58,9],[69,0,76,23],[78,0,79,23],[2,1,2,23],[52,21,52,23],[53,21,53,23],[54,21,54,22],[57,1,57,5],[57,8,57,9],[57,16,57,22],[46,21,46,23],[47,21,47,23],[48,21,48,23],[49,21,49,23],[50,21,50,23]]}
[]
[null,"ESL Student Contact Minutes Calculator - 2 Week"]
[null,"EXAMPLE 2"]
["`","Use this calculator when an every other week rotating schedule is used to provide services.  Time must be entered into both weeks below for the formula to operate correctly."]
[]
[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,"Student Grade:",null,null,5,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,"Paraprofessional",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,"PRAXIS",null,null,null,null,null,null,"Paraprofessional"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2020-09-21",null,null,null,"2020-09-22",null,null,null,"2020-09-23",null,null,null,"2020-09-24",null,null,null,"2020-09-25"]
[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(C24>D24,(D24+0.5)-C24,D24-C24)","v":0},null,null,null,{"$f":"IF(G24>H24,(H24+0.5)-G24,H24-G24)","v":0},null,null,null,{"$f":"IF(K24>L24,(L24+0.5)-K24,L24-K24)","v":0},null,null,null,{"$f":"IF(O24>P24,(P24+0.5)-O24,P24-O24)","v":0},null,null,null,{"$f":"IF(S24>T24,(T24+0.5)-S24,T24-S24)","v":0}]
[null,null,null,null,{"$f":"IF(C25>D25,(D25+0.5)-C25,D25-C25)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"MK","10:35:00","10:55:00",{"$f":"IF(C26>D26,(D26+0.5)-C26,D26-C26)","v":1.388888888888884E-2},null,null,null,0,"MK","10:35:00","10:55:00",1.388888888888884E-2,null,null,null,0,"MK","10:35:00","10:55:00",1.388888888888884E-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,"MD","11:00:00","12:15:00",5.2083333333333315E-2,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,"LL","02:30:00","02:45:00",1.0416666666666657E-2,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(C34>D34,(D34+0.5)-C34,D34-C34)","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(E24:E35)","v":1.388888888888884E-2},"Daily Total",null,null,{"$f":"SUM(I24:I35)","v":1.0416666666666657E-2},"Daily Total",null,null,{"$f":"SUM(M24:M35)","v":1.388888888888884E-2},"Daily Total",null,null,{"$f":"SUM(Q24:Q35)","v":5.2083333333333315E-2},"Daily Total",null,null,{"$f":"SUM(U24:U35)","v":1.388888888888884E-2}]
[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(E36:U36)","v":0.10416666666666649}]
[]
[]
[null,"2020-09-28",null,null,null,"2020-09-29",null,null,null,"2020-09-30",null,null,null,"2020-10-01",null,null,null,"2020-10-02"]
[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(C42>D42,(D42+0.5)-C42,D42-C42)","v":0},null,null,null,{"$f":"IF(G42>H42,(H42+0.5)-G42,H42-G42)","v":0},null,null,null,{"$f":"IF(K42>L42,(L42+0.5)-K42,L42-K42)","v":0},null,null,null,{"$f":"IF(O42>P42,(P42+0.5)-O42,P42-O42)","v":0},null,null,null,{"$f":"IF(S42>T42,(T42+0.5)-S42,T42-S42)","v":0}]
[null,null,null,null,{"$f":"IF(C43>D43,(D43+0.5)-C43,D43-C43)","v":0},null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[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,null,null,null,{"$f":"IF(C45>D45,(D45+0.5)-C45,D45-C45)","v":0},"MK","10:35:00","10:55:00",1.388888888888884E-2,null,null,null,0,"MK","10:35:00","10:55:00",1.388888888888884E-2,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,"GD","01:30:00","02:00:00",2.0833333333333329E-2,null,null,null,0,"LL","02:30:00","02:45:00",1.0416666666666657E-2,null,null,null,0,"LL","02:30:00","02:45:00",1.0416666666666657E-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,{"$f":"IF(C52>D52,(D52+0.5)-C52,D52-C52)","v":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,"Daily Total",null,null,{"$f":"SUM(E42:E53)","v":2.0833333333333329E-2},"Daily Total",null,null,{"$f":"SUM(I42:I53)","v":1.388888888888884E-2},"Daily Total",null,null,{"$f":"SUM(M42:M53)","v":1.0416666666666657E-2},"Daily Total",null,null,{"$f":"SUM(Q42:Q53)","v":1.388888888888884E-2},"Daily Total",null,null,{"$f":"SUM(U42:U53)","v":1.0416666666666657E-2}]
[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(E54:U54)","v":6.9444444444444323E-2}]
[]
[null,"I certify that I have firsthand knowledge that the information above is true and accurate."]
[null,"Jane Smith, ESL Director",null,null,null,null,null,null,"2020-10-01",null,null,null,null,null,null,null,"Average Daily Minutes (Enter this number in KIDS)",null,null,null,null,null,null,{"$f":"ROUND(((X37+X55)/10)*1440,0)/1440","v":1.7361111111111112E-2}]
[null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 8/20/20\n\n\nKansas leads the world in the success of each student."]

{"sheet":"ESL Worksheet Example","index":5,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":true,"merged":[[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],[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],[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],[14,3,14,9],[14,14,14,17],[14,22,14,23],[15,3,15,9],[15,14,15,17],[15,22,15,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],[10,3,10,9],[10,14,10,17],[10,22,10,23],[11,3,11,9],[11,14,11,17],[11,22,11,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],[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],[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]]}
[]
[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":6,"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"]