{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Important Info","CTE Contact Minutes","Example","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":11,"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":119,"n_cols":21,"rows_kept":119,"cut":false,"hidden":false,"merged":[[38,0,40,24],[23,1,23,6],[10,1,10,24],[28,0,35,24],[113,1,119,3],[117,20,117,23],[118,20,118,23],[72,1,74,22],[1,1,1,23],[7,2,7,23],[19,2,19,23],[21,1,21,17],[14,2,14,23],[4,2,4,23],[5,2,5,23],[17,2,17,23],[18,2,18,23],[8,2,8,23]]}
[]
[null,"INSTRUCTIONS FOR CTE CONTACT MINUTES WORKSHEET"]
[]
[null,1,"Complete name of school."]
[null,2,"Complete Official Bell Schedule table.  Include only minutes in class.  Don't include passing minutes, break minutes, lunch minutes or seminar minutes.  We recommend that you complete the Bell Schedule Calculator (available on our website) to make sure the correct daily average number of minutes per class period is input into the Official Bell Schedule table."]
[null,3,"Complete the Countable Seminar Minutes table.  Daily average number of minutes in seminar can be easily calculated with the Bell Schedule Calculator.  Periods in full time student schedule - don't count seminar.  Computed seminar time will calculate for you and will prefill into the Official Bell Schedule table."]
[null,4,"Complete the CTE Roster Information table for each approved CTE course."]
[null,5,"Total countable CTE time in minutes and hours calculates at bottom of worksheet."]
[null,6,"To enter course information for more than one high school, you can make a copy of the worksheet for each school.  Space is provided to enter 35 courses on each worksheet."]
[]
[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,"•","CTE courses eligible for additional funding must be approved by the Career and Technical Education (CTE) team under the Pathways process."]
[null,"•","The district must maintain a count day roster for each class approved for additional funding."]
[null,"•","The count day rosters must show the exact course code as approved on the Pathways list."]
[null,"•","Calculations for contact minutes are based on the school's official bell schedule.  Passing minutes, break minutes, lunch minutes and seminar minutes are not included in class time.  We recommend that you complete the Bell Schedule Calculator (available on our website)."]
[null,"•","Seminar is a block of time allotted within the school day where students have the opportunity to go to any teacher outside the regular class period and get help.  A portion of seminar time can be counted as CTE Contact minutes.  The Countable Seminar Minutes table calculates the countable portion of seminar for you."]
[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 - CTE MINUTES WORKSHEET"]
[]
[null,"See example worksheet or click here."]
[]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 5/29/24\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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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/18/18"]

{"sheet":"CTE Contact Minutes","index":1,"n_rows":139,"n_cols":8,"rows_kept":139,"cut":false,"hidden":false,"merged":[[1,0,1,7],[3,5,3,6],[4,5,4,6],[13,0,13,1],[22,0,22,7],[147,0,147,7],[126,1,126,5],[127,1,127,5],[128,1,128,5],[129,1,129,5],[138,0,145,7]]}
[]
["CTE Contact Minutes"]
[]
[null,null,null,null,null,"OFFICIAL BELL SCHEDULE"]
[null,null,null,null,null,"DON'T INCLUDE PASSING MINUTES"]
[null,null,null,null,null,null,"Minutes"]
["Name of School",null,null,null,null,"Period","In Class"]
[null,null,null,null,null,0]
[null,null,null,null,1,1]
[null,null,null,null,2,2]
[null,null,null,null,3,3]
[null,null,null,null,4,4]
[null,null,null,null,5,5]
["COUNTABLE SEMINAR MINUTES",null,null,null,6,6]
["Daily Average # of Minutes in Seminar",null,null,null,7,7]
["Periods in full time student schedule",null,null,null,8,8]
["Computed Seminar Time",{"$f":"IF(B15=0,0,ROUND(B15/B16,1))","v":0},null,null,9,9]
[null,null,null,null,10,10]
[null,null,null,null,11]
[null,null,null,null,12]
[null,null,null,null,null,"Sem",{"$f":"ROUND(B17,0)","v":0}]
[]
["CTE ROSTER INFORMATION"]
["Course Name","Teacher","16 Digit Course Code","Period","Enrollment","Time","Total","Notes"]
[null,null,null,null,null,{"$f":"VLOOKUP(D25,$F$7:$G$21,2,FALSE)","v":0},{"$f":"ROUND(E25*F25,1)","v":0}]
[null,null,null,null,null,{"$f":"VLOOKUP(D26,$F$7:$G$21,2,FALSE)","v":0},0]
[null,null,null,null,null,{"$f":"VLOOKUP(D27,$F$7:$G$21,2,FALSE)","v":0},{"$f":"ROUND(E27*F27,1)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,{"$f":"ROUND(E31*F31,1)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,{"$f":"VLOOKUP(D37,$F$7:$G$21,2,FALSE)","v":0},{"$f":"ROUND(E37*F37,1)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,{"$f":"VLOOKUP(D40,$F$7:$G$21,2,FALSE)","v":0},{"$f":"ROUND(E40*F40,1)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,{"$f":"VLOOKUP(D80,$F$7:$G$21,2,FALSE)","v":0},{"$f":"ROUND(E80*F80,1)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,"Total Enrollments",{"$f":"SUM(E25:E124)","v":0},"Total Minutes",{"$f":"SUM(G25:G124)","v":0}]
[]
[null,"Total CTE Minutes",null,null,null,null,{"$f":"G125","v":0}]
[null,"Countable Seminar Minutes (total enrollments x computed seminar time)",null,null,null,null,{"$f":"SUM(E125*G21)","v":0}]
[null,"Total CTE Minutes",null,null,null,null,{"$f":"G125+G128","v":0}]
[null,"Total CTE Hours",null,null,null,null,{"$f":"G129/60","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 5/29/2024\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example","index":2,"n_rows":139,"n_cols":8,"rows_kept":139,"cut":false,"hidden":false,"merged":[[126,1,126,5],[1,0,1,7],[3,5,3,6],[4,5,4,6],[13,0,13,1],[22,0,22,7],[127,1,127,5],[128,1,128,5],[129,1,129,5],[138,0,145,7],[147,0,147,7]]}
[]
["CTE Contact Minutes"]
[]
[null,null,null,null,null,"OFFICIAL BELL SCHEDULE"]
[null,null,null,null,null,"DON'T INCLUDE PASSING MINUTES"]
["Sunflower High",null,null,null,null,null,"Minutes"]
["Name of School",null,null,null,null,"Period","In Class"]
[null,null,null,null,null,0]
[null,null,null,null,1,1,42]
[null,null,null,null,2,2,42]
[null,null,null,null,3,3,45]
[null,null,null,null,4,4,41]
[null,null,null,null,5,5,42]
["COUNTABLE SEMINAR MINUTES",null,null,null,6,6,47]
["Daily Average # of Minutes in Seminar",23,null,null,7,7,42]
["Periods in full time student schedule",7,null,null,8,8]
["Computed Seminar Time",{"$f":"IF(B15=0,0,ROUND(B15/B16,1))","v":3.3},null,null,9,9]
[null,null,null,null,10,10]
[null,null,null,null,11]
[null,null,null,null,12]
[null,null,null,null,null,"Sem",{"$f":"ROUND(B17,0)","v":3}]
[]
["CTE ROSTER INFORMATION"]
["Course Name","Teacher","16 Digit Course Code","Period","Enrollment","Time","Total","Notes"]
["Animal Science B","Madison, S.","10001G0.999999GGF",6,12,{"$f":"VLOOKUP(D25,$F$7:$G$21,2,FALSE)","v":47},{"$f":"ROUND(E25*F25,1)","v":564}]
["Agri Business A","Short, L.","99999G0.111111GGF",3,20,{"$f":"VLOOKUP(D26,$F$7:$G$21,2,FALSE)","v":45},900]
["Marketing A","Pinea, B.","55555G0.666666GGF",2,18,{"$f":"VLOOKUP(D27,$F$7:$G$21,2,FALSE)","v":42},{"$f":"ROUND(E27*F27,1)","v":756}]
["Woodworking A","Fluek, R.","33333G0.222222GGF",1,16,42,672]
["Furn & Cabinetmaking","Klinger, Z.","44444G0.000000GGF",4,9,41,369]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,{"$f":"ROUND(E89*F89,1)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,"Total Enrollments",{"$f":"SUM(E25:E124)","v":75},"Total Minutes",{"$f":"SUM(G25:G124)","v":3261}]
[]
[null,"Total CTE Minutes",null,null,null,null,{"$f":"G125","v":3261}]
[null,"Countable Seminar Minutes (total enrollments x computed seminar time)",null,null,null,null,{"$f":"SUM(E125*G21)","v":225}]
[null,"Total CTE Minutes",null,null,null,null,{"$f":"G125+G128","v":3486}]
[null,"Total CTE Hours",null,null,null,null,{"$f":"G129/60","v":58.1}]
[]
[]
[]
[]
[]
[]
[]
[]
["CTE Contact Minutes Calculator\nUpdated 6/29/2023\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Sheet1","index":3,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,"The password is: ",null,"secret"]

{"sheet":"Sheet2","index":4,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"1G ",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX($A$2:$A$40,SMALL(IF(LEN($A$2:$A$40)>0,ROW($A$2:$A$40)-ROW($E$1)),ROW(1:1)),1),\"\")","v":0},null,"","1G "]
[null,{"$f":"IFERROR(INDEX($A$2:$A$40,SMALL(IF(LEN($A$2:$A$40)>0,ROW($A$2:$A$40)-ROW($E$1)),ROW(2:2)),1),\"\")","v":""},null,"1R ",""]
[null,"",null,"","1R "]
[null,"",null,"2G ",""]
[null,"",null,"","2G "]
[null,"",null,"2R ",""]
[null,"",null,"","2R "]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"3G ",""]
[null,"",null,"","3G "]
[null,"",null,"3R ",""]
[null,"",null,"","3R "]
[null,"",null,"4G ",""]
[null,"",null,"","4G "]
[null,"",null,"4R ",""]
[null,null,null,"","4R "]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]
[null,null,null,"",{"$f":"IFERROR(INDEX($D$2:$D$20,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20))),\"\")","v":""}]