{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Important Info","New Building-All Grades","Addition-Elem","Addition-MS,HS","Example New Building-All Grades","Example Addition-Elem","Example Addition-MS,HS","Formulas","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":33,"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":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,35,23],[37,0,41,23],[20,1,20,17],[18,2,18,23],[1,1,1,23],[5,2,5,23],[7,2,7,23],[9,1,9,23],[3,2,3,23],[15,2,15,23],[13,2,13,23],[6,2,6,23],[14,2,14,23],[17,2,17,23],[16,2,16,23]]}
[]
[null,"INSTRUCTIONS FOR NEW FACILITIES CALCULATOR"]
[]
[null,1,"Select a worksheet to complete.  If your district has a new building, choose the \"New Building\" worksheet.  If your district has an addition, choose the \"Addition\" worksheet that reflects the grade range of students in the addition."]
[null,2,"Complete the heading area on the worksheet you selected.  Select the claim year (First or Second) from the drop down."]
[null,3,"Enter the enrollment and FTE for any new facilities to be claimed.  Student's FTE entered in the New Facilities Calculator should be equal to their enrollment FTE.  Example:  special education preschool students count as .5 FTE, part-time students will be counted for less than 1.0 FTE, etc."]
[null,4,"Follow specific instructions on the worksheet you use."]
[null,5,"If you have multiple new buildings or additions, you can copy the worksheets for each new facility.  If you use more than one worksheet, add the Total FTE field from each worksheet together to produce the FTE amount to be entered into the SO66."]
[]
[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,"•","New Facilities weighting (school facilities weighting) is calculated by taking the student FTE in a new facility times 25% (.25) rounded to one decimal place.  This is reported directly on the SO66"]
[null,"•","Eligibility is dependent on the school district having a 25% Local Option Budget (LOB) and documentation showing the new facility was paid for from bonds authorized on or before 7/1/2015."]
[null,"•","Generally, a remodeled facility does not meet the definition of \"new\" facility.  However, under certain circumstances, a remodel has been allowed for funding.  Districts should contact Craig Neuenswander, Director of School Finance, prior to claiming any remodeled facility -  craign@ksde.org  (785)296-3872."]
[null,"•","Two year's funding is allowed."]
[null,"•","Students counted in the district's enrollment who attend outside the building are NOT eligible for the new facilities weighting.  This includes virtual students."]
[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,"EXAMPLES - NEW FACILITIES CALCULATOR"]
[]
[null,"Example 1","New Building"]
[null,"Example 2","Addition - Elementary School"]
[null,"Example 3","Addition - Middle School, High School"]
[]
[]
[]
["New Facilities Calculator\nUpdated 8/1/22\n\n\nKansas leads the world in the success of each student."]

{"sheet":"New Building-All Grades","index":1,"n_rows":72,"n_cols":24,"rows_kept":72,"cut":false,"hidden":false,"merged":[[1,0,1,14],[2,0,2,14],[5,0,5,3],[4,0,4,3],[7,0,7,3],[4,11,4,14],[5,11,5,14],[7,11,7,14],[6,0,6,4],[6,10,6,12],[82,0,84,14],[41,4,41,5],[43,4,43,6],[22,7,22,10],[23,7,23,10],[24,7,24,10],[25,7,25,10],[26,7,26,10],[27,7,27,10],[28,7,28,10],[29,7,29,10],[71,0,80,14],[8,11,8,14],[35,7,35,10],[36,7,36,10],[37,7,37,10],[30,7,30,10],[31,7,31,10],[32,7,32,10],[33,7,33,10],[34,7,34,10],[17,1,17,13],[13,1,13,13],[15,1,15,13],[20,4,20,10],[8,0,8,3]]}
[]
["New Facilities Calculator"]
["New Building"]
[]
[]
["School Year",null,null,null,null,null,null,null,null,null,null,"District"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First"]
["Claim  Year",null,null,null,null,null,null,null,null,null,null,"Building",null,null,null,null,null,null,null,null,null,null,null,"Second"]
[]
[]
[]
[]
["1.","Enter the enrollment and FTE for all students enrolled and attending in a new building on September 20th."]
[]
["2.","Student's FTE entered into the calculator should be equal to their enrollment FTE.  Example:  special education preschool students count as .5 FTE, part-time students will be counted for less than 1.0 FTE."]
[]
["3.","The building must meet the requirements for the New Facilities Weighting.  See Important Info worksheet."]
[]
[]
[null,null,null,null,"New Building"]
[null,null,null,null,"Grade","Enrollment","FTE","District Notes"]
[null,null,null,null,"PreK with an IEP"]
[null,null,null,null,"4 Year Old At Risk"]
[null,null,null,null,"Kindergarten"]
[null,null,null,null,"1st"]
[null,null,null,null,"2nd"]
[null,null,null,null,"3rd"]
[null,null,null,null,"4th"]
[null,null,null,null,"5th"]
[null,null,null,null,"6th"]
[null,null,null,null,"7th"]
[null,null,null,null,"8th"]
[null,null,null,null,"9th"]
[null,null,null,null,"10th"]
[null,null,null,null,"11th"]
[null,null,null,null,"12th"]
[null,null,null,null,"Non-graded"]
[]
[null,null,null,null,"Total Enrollment",{"$f":"SUM(F23:F38)","v":0}]
[]
[null,null,null,null,"Total FTE - INPUT ON SO66",null,{"$f":"SUM(G23:G38)","v":0}]
[]
[null,null,null,null,"Funded FTE",null,null,{"$f":"SUM($G$42*0.25)","v":0}]
[]
[]
[]
[]
[]
[]
[]
["Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["New Facilities Calculator\nUpdated 8/1/22\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Addition-Elem","index":2,"n_rows":168,"n_cols":26,"rows_kept":168,"cut":false,"hidden":false,"merged":[[4,13,4,16],[27,8,27,9],[4,5,4,7],[4,9,4,10],[5,9,5,10],[8,9,8,10],[7,9,7,10],[5,5,5,7],[8,5,8,7],[7,5,7,7],[176,0,178,10],[1,0,1,10],[2,0,2,10],[5,0,5,3],[4,0,4,3],[8,0,8,3],[7,0,7,3],[23,3,23,9],[19,3,19,9],[17,3,17,9],[21,3,21,9],[11,3,11,9],[13,3,13,9],[15,3,15,9],[167,0,174,10]]}
[]
["New Facilities Calculator"]
["Addition - Elementary"]
[]
[]
["School Year",null,null,null,null,"Teacher",null,null,null,"District"]
[]
[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,"First"]
["Claim Year",null,null,null,null,"Room Number/Grade",null,null,null,"Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Second"]
[]
[]
[null,null,"1.","This calculator should be completed for each room in an elementary school addition.  Copy the worksheet for each room to be claimed."]
[]
[null,null,"2.","For count week, enter the number of students who are physically in the room during each 5 minute time period so that students pulled out of the room during the day for other services are removed from the count."]
[]
[null,null,"3.","Enter zeros for time periods when all students leave the room to attend other services (Ex: art, music, morning recess/afternoon recess, etc.).  Don't leave these time periods blank.  "]
[]
[null,null,"4.","Leave all cells blank for lunch time.  Leave all cells blank for any recess time immediately before or immediately after lunch time."]
[]
[null,null,"5.","Leave all time periods blank that occur outside of your school's scheduled hours."]
[]
[null,null,"6.","Pre-K special ed students and 4 year old at risk students may be included in the New Facilities claim. These student's countable FTE is .5.  Enter the total number of countable students divided by 2 into the appropriate time periods for these students."]
[]
[null,null,"7.","The building must meet the requirements for the New Facilities Weighting.  See Important Info worksheet."]
[]
[]
[]
[null,null,null,"MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","District Comments"]
[null,null,"07:30:00"]
[null,null,"07:35:00"]
[null,null,"07:40:00"]
[null,null,"07:45:00"]
[null,null,"07:50:00"]
[null,null,"07:55:00"]
[null,null,"08:00:00"]
[null,null,"08:05:00"]
[null,null,"08:10:00"]
[null,null,"08:15:00"]
[null,null,"08:20:00"]
[null,null,"08:25:00"]
[null,null,"08:30:00"]
[null,null,"08:35:00"]
[null,null,"08:40:00"]
[null,null,"08:45:00"]
[null,null,"08:50:00"]
[null,null,"08:55:00"]
[null,null,"09:00:00"]
[null,null,"09:05:00"]
[null,null,"09:10:00"]
[null,null,"09:15:00"]
[null,null,"09:20:00"]
[null,null,"09:25:00"]
[null,null,"09:30:00"]
[null,null,"09:35:00"]
[null,null,"09:40:00"]
[null,null,"09:45:00"]
[null,null,"09:50:00"]
[null,null,"09:55:00"]
[null,null,"10:00:00"]
[null,null,"10:05:00"]
[null,null,"10:10:00"]
[null,null,"10:15:00"]
[null,null,"10:20:00"]
[null,null,"10:25:00"]
[null,null,"10:30:00"]
[null,null,"10:35:00"]
[null,null,"10:40:00"]
[null,null,"10:45:00"]
[null,null,"10:50:00"]
[null,null,"10:55:00"]
[null,null,"11:00:00"]
[null,null,"11:05:00"]
[null,null,"11:10:00"]
[null,null,"11:15:00"]
[null,null,"11:20:00"]
[null,null,"11:25:00"]
[null,null,"11:30:00"]
[null,null,"11:35:00"]
[null,null,"11:40:00"]
[null,null,"11:45:00"]
[null,null,"11:50:00"]
[null,null,"11:55:00"]
[null,null,"12:00:00"]
[null,null,"12:05:00"]
[null,null,"12:10:00"]
[null,null,"12:15:00"]
[null,null,"12:20:00"]
[null,null,"12:25:00"]
[null,null,"12:30:00"]
[null,null,"12:35:00"]
[null,null,"12:40:00"]
[null,null,"12:45:00"]
[null,null,"12:50:00"]
[null,null,"12:55:00"]
[null,null,"01:00:00"]
[null,null,"01:05:00"]
[null,null,"01:10:00"]
[null,null,"01:15:00"]
[null,null,"01:20:00"]
[null,null,"01:25:00"]
[null,null,"01:30:00"]
[null,null,"01:35:00"]
[null,null,"01:40:00"]
[null,null,"01:45:00"]
[null,null,"01:50:00"]
[null,null,"01:55:00"]
[null,null,"02:00:00"]
[null,null,"02:05:00"]
[null,null,"02:10:00"]
[null,null,"02:15:00"]
[null,null,"02:20:00"]
[null,null,"02:25:00"]
[null,null,"02:30:00"]
[null,null,"02:35:00"]
[null,null,"02:40:00"]
[null,null,"02:45:00"]
[null,null,"02:50:00"]
[null,null,"02:55:00"]
[null,null,"03:00:00"]
[null,null,"03:05:00"]
[null,null,"03:10:00"]
[null,null,"03:15:00"]
[null,null,"03:20:00"]
[null,null,"03:25:00"]
[null,null,"03:30:00"]
[null,null,"03:35:00"]
[null,null,"03:40:00"]
[null,null,"03:45:00"]
[null,null,"03:50:00"]
[null,null,"03:55:00"]
[null,null,"04:00:00"]
[null,null,"04:05:00"]
[null,null,"04:10:00"]
[null,null,"04:15:00"]
[null,null,"04:20:00"]
[null,null,"04:25:00"]
[null,null,"04:30:00"]
[]
[null,null,null,{"$f":"SUM(D35:D137)","v":0},{"$f":"SUM(E35:E137)","v":0},{"$f":"SUM(F35:F137)","v":0},{"$f":"SUM(G35:G137)","v":0},{"$f":"SUM(H35:H137)","v":0},{"$f":"SUM(D139:H139)","v":0},"Total Students in Time Periods"]
[]
[null,null,null,null,null,null,null,null,{"$f":"COUNT(D35:H137)","v":0},"Count of Entries"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(I139/I141,1),0)","v":0},"Total FTE - ENTER ON SO66"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM($I$143*0.25)","v":0},"Funded FTE"]
[]
[]
[]
["Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["New Facilities Calculator\nUpdated 8/1/22\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Addition-MS,HS","index":3,"n_rows":147,"n_cols":26,"rows_kept":147,"cut":false,"hidden":false,"merged":[[146,0,153,10],[62,6,62,7],[41,15,41,18],[42,15,42,18],[43,15,43,18],[20,3,20,9],[22,3,22,9],[24,3,24,9],[29,3,29,9],[60,3,60,9],[155,0,157,10],[28,12,28,18],[30,15,30,18],[32,15,32,18],[33,15,33,18],[34,15,34,18],[48,12,48,13],[36,15,36,18],[37,15,37,18],[38,15,38,18],[39,15,39,18],[40,15,40,18],[92,2,92,9],[94,4,94,8],[35,15,35,18],[62,4,62,5],[18,3,18,9],[6,0,6,3],[6,5,6,7],[6,9,6,10],[8,0,8,3],[8,5,8,7],[8,9,8,10],[9,0,9,3],[9,5,9,7],[9,9,9,10],[14,3,14,9],[16,3,16,9],[5,13,5,16],[1,0,1,10],[2,0,2,10],[5,0,5,3],[5,5,5,7],[5,9,5,10]]}
[]
["New Facilities Calculator"]
["Addition - Middle School, High School"]
[]
[]
[]
["School Year",null,null,null,null,"Teacher",null,null,null,"District"]
[]
[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,"First"]
["Claim Year",null,null,null,null,"Room Number/Grade",null,null,null,"Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Second"]
[]
[]
[]
[]
[null,null,"1.","This calculator should be completed for each room in a middle school or high school addition.  Copy the worksheet for each room to be claimed."]
[]
[null,null,"2.","Based on the bell schedule of the building, select one of the three tables below to complete for each room:  same schedule every day, every other day schedule, or different schedule every day"]
[]
[null,null,"3.","Complete the course names/numbers."]
[]
[null,null,"4.","Complete the enrollments based on actual enrollments during count week.  When there is no scheduled class in the room, leave the cell blank."]
[]
[null,null,"5.","Complete the Number of Periods in Schedule field.  This should be the total number of available periods in the day.  Example:  If there are 10 periods in a day and the room is only occupied by students for 5 periods, the number 10 should be entered."]
[]
[null,null,"6.","The building must meet the requirements for the New Facilities Weighting.  See Important Info worksheet."]
[]
[]
[]
[]
[null,null,null,"SAME SCHEDULE EVERY DAY"]
[]
[null,null,null,"Period","Course Name/#","Enrollments/FTE","District Notes"]
[null,null,null,1]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[]
[]
[]
[null,null,null,null,"Number of Periods in Schedule"]
[]
[null,null,null,null,"Total Enrollment",{"$f":"SUM(F33:F44)","v":0}]
[]
[null,null,null,null,"Total FTE - INPUT ON SO66",{"$f":"IFERROR(SUM($F$48/$F$46),0)","v":0}]
[]
[null,null,null,null,"Funded FTE",{"$f":"SUM($F$50*0.25)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Every Other Day Schedule"]
[]
[null,null,null,null,"Day 1",null,"Day 2"]
[null,null,null,"Period","Course Name/#","Enrollments/FTE","Course Number","Enrollments/FTE","District Notes"]
[null,null,null,1]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[]
[]
[]
[null,null,null,null,"Number of Periods in Schedule"]
[]
[null,null,null,null,"Total Enrollment",{"$f":"SUM(F65:F76)","v":0},null,{"$f":"SUM(H65:H76)","v":0}]
[]
[null,null,null,null,"Total FTE - INPUT ON SO66",{"$f":"IFERROR(SUM(($F$80+$H$80)/$F$78),0)","v":0}]
[]
[null,null,null,null,"Funded FTE",{"$f":"SUM($F$82*0.25)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Different Schedule Every Day"]
[]
[null,null,null,null,"Enrollments"]
[null,null,"Period","Course Name/#","M","T","W","TH","F","District Notes"]
[null,null,1]
[]
[null,null,2]
[]
[null,null,3]
[]
[null,null,4]
[]
[null,null,5]
[]
[null,null,6]
[]
[null,null,7]
[]
[null,null,8]
[]
[null,null,9]
[]
[null,null,10]
[]
[]
[]
[]
[null,null,null,null,"Number of Periods in Schedule"]
[]
[null,null,null,"Total Enrollment",{"$f":"SUM(E97:E118)","v":0},{"$f":"SUM(F97:F118)","v":0},{"$f":"SUM(G97:G118)","v":0},{"$f":"SUM(H97:H118)","v":0},{"$f":"SUM(I97:I118)","v":0}]
[]
[null,null,null,null,"Total FTE - INPUT ON SO66",{"$f":"IFERROR(SUM(($E$122+$F$122+$G$122+$H$122+$I$122)/$F$120),0)","v":0}]
[]
[null,null,null,null,"Funded FTE",{"$f":"SUM($F124*0.25)","v":0}]
[]
[]
[]
[]
[]
["Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["New Facilities Calculator\nUpdated 8/1/22\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example New Building-All Grades","index":4,"n_rows":74,"n_cols":24,"rows_kept":74,"cut":false,"hidden":false,"merged":[[36,7,36,10],[37,7,37,10],[41,4,41,5],[43,4,43,6],[82,0,84,14],[73,0,80,14],[35,7,35,10],[24,7,24,10],[25,7,25,10],[26,7,26,10],[27,7,27,10],[28,7,28,10],[29,7,29,10],[30,7,30,10],[31,7,31,10],[32,7,32,10],[33,7,33,10],[34,7,34,10],[23,7,23,10],[6,0,6,4],[6,10,6,12],[7,0,7,3],[7,11,7,14],[8,0,8,3],[8,11,8,14],[13,1,13,13],[15,1,15,13],[17,1,17,13],[20,4,20,10],[22,7,22,10],[1,0,1,14],[2,0,2,14],[4,0,4,3],[4,11,4,14],[5,0,5,3],[5,11,5,14]]}
[]
["New Facilities Calculator"]
["New Building"]
[]
["19/20",null,null,null,null,null,null,null,null,null,null,"USD 1001"]
["School Year",null,null,null,null,null,null,null,null,null,null,"District"]
[]
["First",null,null,null,null,null,null,null,null,null,null,"Prairie Elementary",null,null,null,null,null,null,null,null,null,null,null,"First"]
["Claim  Year",null,null,null,null,null,null,null,null,null,null,"Building",null,null,null,null,null,null,null,null,null,null,null,"Second"]
[]
[]
[]
[]
["1.","Enter the enrollment and FTE for all students enrolled and attending in a new building on September 20th."]
[]
["2.","Student's FTE entered into the calculator should be equal to their enrollment FTE.  Example:  special education preschool students count as .5 FTE, part-time students will be counted for less than 1.0 FTE."]
[]
["3.","The building must meet the requirements for the New Facilities Weighting.  See Important Info worksheet."]
[]
[]
[null,null,null,null,"New Building"]
[null,null,null,null,"Grade","Enrollment","FTE","District Notes"]
[null,null,null,null,"PreK with an IEP",11,5.5]
[null,null,null,null,"4 Year Old At Risk",27,13.5]
[null,null,null,null,"Kindergarten",52,52]
[null,null,null,null,"1st",63,63]
[null,null,null,null,"2nd",58,58]
[null,null,null,null,"3rd",61,60.2,"One part-time student (home schooled)"]
[null,null,null,null,"4th",65,65]
[null,null,null,null,"5th",57,56.3,"One part-time student (home schooled)"]
[null,null,null,null,"6th"]
[null,null,null,null,"7th"]
[null,null,null,null,"8th"]
[null,null,null,null,"9th"]
[null,null,null,null,"10th"]
[null,null,null,null,"11th"]
[null,null,null,null,"12th"]
[null,null,null,null,"Non-graded"]
[]
[null,null,null,null,"Total Enrollment",{"$f":"SUM(F23:F38)","v":394}]
[]
[null,null,null,null,"Total FTE (Input on SO66)",null,{"$f":"SUM(G23:G38)","v":373.5}]
[]
[null,null,null,null,"Funded FTE",null,null,{"$f":"SUM($G$42*0.25)","v":93.375}]
[]
[]
[]
[]
[]
[]
[]
["Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["New Facilities Calculator\nUpdated 6/18/20\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example Addition-Elem","index":5,"n_rows":168,"n_cols":26,"rows_kept":168,"cut":false,"hidden":false,"merged":[[4,13,4,16],[1,0,1,10],[2,0,2,10],[4,0,4,3],[4,5,4,7],[4,9,4,10],[5,0,5,3],[5,5,5,7],[5,9,5,10],[7,0,7,3],[7,5,7,7],[7,9,7,10],[176,0,178,10],[8,0,8,3],[8,5,8,7],[8,9,8,10],[11,3,11,9],[13,3,13,9],[15,3,15,9],[17,3,17,9],[19,3,19,9],[21,3,21,9],[23,3,23,9],[27,8,27,9],[167,0,174,10]]}
[]
["New Facilities Calculator"]
["Addition - Elementary"]
[]
["19/20",null,null,null,null,"Smith, Terry",null,null,null,"USD 1001"]
["School Year",null,null,null,null,"Teacher",null,null,null,"District"]
[]
["Second",null,null,null,null,"101/2nd",null,null,null,"Sunflower Elementary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First"]
["Claim Year",null,null,null,null,"Room Number/Grade",null,null,null,"Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Second"]
[]
[]
[null,null,"1.","This calculator should be completed for each room in an elementary school addition.  Copy the worksheet for each room to be claimed."]
[]
[null,null,"2.","Enter the number of students who are physically in the room during each 5 minute time period so that students pulled out of the room during the day for other services are removed from the count."]
[]
[null,null,"3.","Enter zeros for time periods when all students leave the room to attend other services (Ex: art, music, morning recess/afternoon recess, etc.).  Don't leave these time periods blank.  "]
[]
[null,null,"4.","Leave all cells blank for lunch time.  Leave all cells blank for any recess time immediately before or immediately after lunch time."]
[]
[null,null,"5.","Leave all time periods blank that occur outside of your school's scheduled hours."]
[]
[null,null,"6.","Pre-K special ed students and 4 year old at risk students may be included in the New Facilities claim. These student's countable FTE is .5.  Enter the total number of countable students divided by 2 into the appropriate time periods."]
[]
[null,null,"7.","The building must meet the requirements for the New Facilities Weighting.  See Important Info worksheet."]
[]
[]
[]
[null,null,null,"MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRIDAY","District Comments"]
[null,null,"07:30:00"]
[null,null,"07:35:00"]
[null,null,"07:40:00"]
[null,null,"07:45:00"]
[null,null,"07:50:00"]
[null,null,"07:55:00"]
[null,null,"08:00:00",29,29,29,29,29,"School begins at 8:00am"]
[null,null,"08:05:00",28,28,28,28,28,"1 student to sped services"]
[null,null,"08:10:00",28,28,28,28,28]
[null,null,"08:15:00",28,28,28,28,28]
[null,null,"08:20:00",28,28,28,28,28]
[null,null,"08:25:00",28,28,28,28,28]
[null,null,"08:30:00",28,28,28,28,28]
[null,null,"08:35:00",28,28,28,28,28]
[null,null,"08:40:00",28,28,28,28,28]
[null,null,"08:45:00",28,28,28,28,28]
[null,null,"08:50:00",29,29,29,29,29,"1 student returns from sped services"]
[null,null,"08:55:00",29,29,29,29,29]
[null,null,"09:00:00",29,29,29,29,29]
[null,null,"09:05:00",29,29,29,29,29]
[null,null,"09:10:00",29,29,29,29,29]
[null,null,"09:15:00",29,29,29,29,29]
[null,null,"09:20:00",29,29,29,29,29]
[null,null,"09:25:00",29,29,29,29,29]
[null,null,"09:30:00",29,29,29,29,29]
[null,null,"09:35:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"09:40:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"09:45:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"09:50:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"09:55:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"10:00:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"10:05:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"10:10:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"10:15:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"10:20:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"10:25:00",0,0,0,0,0,"Art/Music rotation"]
[null,null,"10:30:00",29,29,29,29,29]
[null,null,"10:35:00",29,29,29,29,29]
[null,null,"10:40:00",29,29,29,29,29]
[null,null,"10:45:00",29,29,29,29,29]
[null,null,"10:50:00",29,29,29,29,29]
[null,null,"10:55:00",29,29,29,29,29]
[null,null,"11:00:00",29,29,29,29,29]
[null,null,"11:05:00",29,29,29,29,29]
[null,null,"11:10:00",26,26,26,26,26,"3 students to ESL services"]
[null,null,"11:15:00",26,26,26,26,26]
[null,null,"11:20:00",26,26,26,26,26]
[null,null,"11:25:00",26,26,26,26,26]
[null,null,"11:30:00",26,26,26,26,26]
[null,null,"11:35:00",26,26,26,26,26]
[null,null,"11:40:00",26,26,26,26,26]
[null,null,"11:45:00",26,26,26,26,26]
[null,null,"11:50:00",26,26,26,26,26]
[null,null,"11:55:00",27,27,27,27,27,"2 st return from ESL services, 1 st to sped serv"]
[null,null,"12:00:00",27,27,27,27,27]
[null,null,"12:05:00",27,27,27,27,27]
[null,null,"12:10:00",27,27,27,27,27]
[null,null,"12:15:00",27,27,27,27,27]
[null,null,"12:20:00",27,27,27,27,27]
[null,null,"12:25:00",27,27,27,27,27]
[null,null,"12:30:00",27,27,27,27,27]
[null,null,"12:35:00",27,27,27,27,27]
[null,null,"12:40:00",null,null,null,null,null,"Lunch"]
[null,null,"12:45:00",null,null,null,null,null,"Lunch"]
[null,null,"12:50:00",null,null,null,null,null,"Lunch"]
[null,null,"12:55:00",null,null,null,null,null,"Lunch"]
[null,null,"01:00:00",null,null,null,null,null,"Lunch"]
[null,null,"01:05:00",null,null,null,null,null,"Lunch"]
[null,null,"01:10:00",null,null,null,null,null,"Recess immediately after lunch"]
[null,null,"01:15:00",null,null,null,null,null,"Recess immediately after lunch"]
[null,null,"01:20:00",null,null,null,null,null,"Recess immediately after lunch"]
[null,null,"01:25:00",29,29,29,29,29]
[null,null,"01:30:00",29,29,29,29,29]
[null,null,"01:35:00",29,29,29,29,29]
[null,null,"01:40:00",29,29,29,29,29]
[null,null,"01:45:00",29,29,29,29,29]
[null,null,"01:50:00",29,29,29,29,29]
[null,null,"01:55:00",29,29,29,29,29]
[null,null,"02:00:00",29,29,29,29,29]
[null,null,"02:05:00",29,29,29,29,29]
[null,null,"02:10:00",29,29,29,29,29]
[null,null,"02:15:00",29,29,29,29,29]
[null,null,"02:20:00",29,29,29,29,29]
[null,null,"02:25:00",29,29,29,29,29]
[null,null,"02:30:00",29,29,29,29,29]
[null,null,"02:35:00",29,29,29,29,29]
[null,null,"02:40:00",29,29,29,29,29]
[null,null,"02:45:00",29,29,29,29,29]
[null,null,"02:50:00",29,29,29,29,29]
[null,null,"02:55:00",29,29,29,29,29]
[null,null,"03:00:00",29,29,29,29,29]
[null,null,"03:05:00",29,29,29,29,29]
[null,null,"03:10:00",29,29,29,29,29]
[null,null,"03:15:00",29,29,29,29,29]
[null,null,"03:20:00",29,29,29,29,29]
[null,null,"03:25:00",29,29,29,29,29]
[null,null,"03:30:00",29,29,29,29,29]
[null,null,"03:35:00",29,29,29,29,29,"School dismissed at 3:40"]
[null,null,"03:40:00"]
[null,null,"03:45:00"]
[null,null,"03:50:00"]
[null,null,"03:55:00"]
[null,null,"04:00:00"]
[null,null,"04:05:00"]
[null,null,"04:10:00"]
[null,null,"04:15:00"]
[null,null,"04:20:00"]
[null,null,"04:25:00"]
[null,null,"04:30:00"]
[]
[null,null,null,{"$f":"SUM(D35:D137)","v":2034},{"$f":"SUM(E35:E137)","v":2034},{"$f":"SUM(F35:F137)","v":2034},{"$f":"SUM(G35:G137)","v":2034},{"$f":"SUM(H35:H137)","v":2034},{"$f":"SUM(D139:H139)","v":10170},"Total Students in Time Periods"]
[]
[null,null,null,null,null,null,null,null,{"$f":"COUNT(D35:H137)","v":415},"Count of Entries"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(I139/I141,1),0)","v":24.5},"Total FTE - ENTER ON SO66"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM($I$143*0.25)","v":6.125},"Funded FTE"]
[]
[]
[]
["Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["New Facilities Calculator\nUpdated 6/18/20\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Example Addition-MS,HS","index":6,"n_rows":147,"n_cols":26,"rows_kept":147,"cut":false,"hidden":false,"merged":[[5,13,5,16],[1,0,1,10],[2,0,2,10],[5,0,5,3],[5,5,5,7],[5,9,5,10],[6,0,6,3],[6,5,6,7],[6,9,6,10],[8,0,8,3],[8,5,8,7],[8,9,8,10],[30,15,30,18],[9,0,9,3],[9,5,9,7],[9,9,9,10],[14,3,14,9],[16,3,16,9],[18,3,18,9],[20,3,20,9],[22,3,22,9],[24,3,24,9],[28,12,28,18],[29,3,29,9],[43,15,43,18],[32,15,32,18],[33,15,33,18],[34,15,34,18],[35,15,35,18],[36,15,36,18],[37,15,37,18],[38,15,38,18],[39,15,39,18],[40,15,40,18],[41,15,41,18],[42,15,42,18],[155,0,157,10],[48,12,48,13],[60,3,60,9],[62,4,62,5],[62,6,62,7],[92,2,92,9],[94,4,94,8],[146,0,153,10]]}
[]
["New Facilities Calculator"]
["Addition - Middle School, High School"]
[]
[]
["19/20",null,null,null,null,"Strong, Susan",null,null,null,"USD 1001"]
["School Year",null,null,null,null,"Teacher",null,null,null,"District"]
[]
["First",null,null,null,null,106,null,null,null,"Sunflower High School",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First"]
["Claim Year",null,null,null,null,"Room Number/Grade",null,null,null,"Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Second"]
[]
[]
[]
[]
[null,null,"1.","This calculator should be completed for each room in a middle school or high school addition.  Copy the worksheet for each room to be claimed."]
[]
[null,null,"2.","Based on the bell schedule of the building, select one of the three tables below to complete for each room:  same schedule every day, every other day schedule, or different schedule every day"]
[]
[null,null,"3.","Complete the course names/numbers."]
[]
[null,null,"4.","Complete the enrollments based on actual enrollments during count week.  When there is no scheduled class in the room, leave the cell blank."]
[]
[null,null,"5.","Complete the Number of Periods in Schedule field.  This should be the total number of available periods in the day.  Example:  If there are 10 periods in a day and the room is only occupied by students for 5 periods, the number 10 should be entered."]
[]
[null,null,"6.","The building must meet the requirements for the New Facilities Weighting.  See Important Info worksheet."]
[]
[]
[]
[]
[null,null,null,"SAME SCHEDULE EVERY DAY"]
[]
[null,null,null,"Period","Course Name/#","Enrollments/FTE","District Notes"]
[null,null,null,1,"1121-001",26]
[null,null,null,2,"8561-001",28]
[null,null,null,3,null,null,"Planning Period"]
[null,null,null,4,"8731-001",10]
[null,null,null,5,"9025-010",15]
[null,null,null,6,"8623-004",16]
[null,null,null,7,"8721-001",17]
[null,null,null,8,"9133-008",12,"School Dismissed"]
[null,null,null,9]
[null,null,null,10]
[]
[]
[]
[null,null,null,null,"Number of Periods in Schedule",10]
[]
[null,null,null,null,"Total Enrollment",{"$f":"SUM(F33:F44)","v":124}]
[]
[null,null,null,null,"Total FTE - INPUT ON SO66",{"$f":"IFERROR(SUM($F$48/$F$46),0)","v":12.4}]
[]
[null,null,null,null,"Funded FTE",{"$f":"SUM($F$50*0.25)","v":3.1}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Every Other Day Schedule"]
[]
[null,null,null,null,"Purple Day",null,"Silver Day"]
[null,null,null,"Period","Course Name/#","Enrollments/FTE","Course Number","Enrollments/FTE","District Notes"]
[null,null,null,1,"SC3001-11T",26,"SC3001-21C",25]
[null,null,null,2,"SC3001-12T2",28,"SC3001-22C",64]
[null,null,null,3,"SC3001-13T3",32,"SC3001-23C",32]
[null,null,null,4,"SC3001-14T2",10,"SC3001-24C",12]
[null,null,null,5,"SC3001-15T",15,"SC3001-25C",64]
[null,null,null,6,"SC3001-16T3",16,"SC3001-26C",15]
[null,null,null,7,null,null,null,null,"Planning Period"]
[null,null,null,8,"SS2001-18C",12,"SC3001-26C",14]
[null,null,null,9]
[null,null,null,10]
[]
[]
[]
[null,null,null,null,"Number of Periods in Schedule",8]
[]
[null,null,null,null,"Total Enrollment",{"$f":"SUM(F65:F76)","v":139},null,{"$f":"SUM(H65:H76)","v":226}]
[]
[null,null,null,null,"Total FTE - INPUT ON SO66",{"$f":"IFERROR(SUM(($F$80+$H$80)/$F$78),0)","v":45.625}]
[]
[null,null,null,null,"Funded FTE",{"$f":"SUM($F$82*0.25)","v":11.40625}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Different Schedule Every Day"]
[]
[null,null,null,null,"Enrollments"]
[null,null,"Period","Course Name/#","M","T","W","TH","F","District Notes"]
[null,null,1,"MA1071-11L",17,null,17,null,17]
[]
[null,null,2,"MA3001-13L",18,null,18,null,18]
[]
[null,null,3,"MA3001-15L",21,null,21,null,21]
[]
[null,null,4,"MA1001-23S",22,null,22,null,22]
[]
[null,null,5,"MA1024-7K",28,null,28,null,28]
[]
[null,null,6,"MA3001-12L2",null,18,null,18,18]
[]
[null,null,7,"MA1001-23S",null,20,null,20,20]
[]
[null,null,8,"MA3001-12L2",null,23,null,23,23]
[]
[null,null,9,"MA1081-14L",null,26,null,26,26]
[]
[null,null,10,"MA1071-11L",null,28,null,28,28]
[]
[]
[]
[]
[null,null,null,null,"Number of Periods in Schedule",10]
[]
[null,null,null,"Total Enrollment",{"$f":"SUM(E97:E118)","v":106},{"$f":"SUM(F97:F118)","v":115},{"$f":"SUM(G97:G118)","v":106},{"$f":"SUM(H97:H118)","v":115},{"$f":"SUM(I97:I118)","v":221}]
[]
[null,null,null,null,"Total FTE - INPUT ON SO66",{"$f":"IFERROR(SUM(($E$122+$F$122+$G$122+$H$122+$I$122)/$F$120),0)","v":66.3}]
[]
[null,null,null,null,"Funded FTE",{"$f":"SUM($F124*0.25)","v":16.574999999999999}]
[]
[]
[]
[]
[]
["Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["New Facilities Calculator\nUpdated 6/18/20\n\n\nKansas leads the world in the success of each student."]

{"sheet":"Formulas","index":7,"n_rows":74,"n_cols":2,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
["Cell","F8"]
["Heading","none"]
["Formula"," =COUNTIF(C7,\"=\"&\"Lunch\")"]
["Translation","Places a 1 in cell if the word Lunch is in C7 (Type of Time, row above)."]
[]
["Cell","G8"]
["Heading","Mins"]
["Formula"," =IF(OR(C8=\"Lunch\",C8=\"Recess\",AND(F8=1,C8=\"Passing\")), 0, IF(D8>E8,(E8+0.5)-D8,E8-D8))"]
["Translation","If there is a 1 in F8 and the word Passing in C8 (Type), don't count the time.  If the words Lunch or Recess are in C8 (Type), don't count the time.  If not, then count the time.  If beg time is greater than end time, then (end time + .5) minus beg time  If not, then end time minus beg time."]
[]
["Cell","G33"]
["Heading","Total Mins"]
["Formula"," =SUM(G8:G32)"]
["Translation","Adds up all time"]
[]
["Cell","AC8"]
["Heading","Daily Average"]
["Formula"," =ROUND(((G8+L8+Q8+V8+AA8+G57+L57+Q57+V57+AA57)/10)*1440,0)/1440"]
["Translation","Adds up all times in first rows of both tables (the formula sees decimals) and divides by 10 for average which is rounded. Excel stores time as a decimal portion of a day.  Dividing the totaled decimals by 1440 converts to actual minutes.  1440 is the number of minutes in a day."]
[]
["Cell","AC33"]
["Heading","total of daily average column"]
["Formula"," =ROUND((SUM(G33:AA33)+SUM(G82:AA82))/10*1440,0)/1440"]
["Translation","Adds up total minutes row for both columns, divides by 10 to average, converts to actual minutes, then rounds."]
[]
["Cell","AD8"]
["Heading","Contact Minutes"]
["Formula"," =IF(OR(ISNUMBER(SEARCH(\"*Period*\",C8)),ISNUMBER(SEARCH(\"*Period*\",H8)),ISNUMBER(SEARCH(\"*Period*\",M8)),ISNUMBER(SEARCH(\"*Period*\",R8)),ISNUMBER(SEARCH(\"*Period*\",W8))),AC8,0)"]
["Translation","Looks for the word period in Type columns of both tables and returns a zero if it finds it.  If it doesn't find the word period, then returns the result in AC8."]
[]
["Cell","AD33"]
["Heading","total of Contact Minutes column"]
["Formula"," =SUM(AD8:AD30)"]
["Translation","adds up all contact minutes"]
[]
["Cell","AE8"]
["Heading","P-test"]
["Formula"," =IF(OR(ISNUMBER(SEARCH(\"*Period*\",C8)),ISNUMBER(SEARCH(\"*Period*\",H8)),ISNUMBER(SEARCH(\"*Period*\",M8)),ISNUMBER(SEARCH(\"*Period*\",R8)),ISNUMBER(SEARCH(\"*Period*\",W8))),INDIRECT(\"R\"&TEXT(MIN(IF(COUNTIF(C8:W8,C8:W8)=MAX(COUNTIF(C8:W8,C8:W8)),ROW(C8:W8)*1000+COLUMN(C8:W8))),\"0\\C000\"),0),\"\")"]
["Translation","Looks for the word Period in Type columns of both tables.  Not sure what happens after that."]
[]
["Cell","AF8"]
["Heading","Period"]
["Formula"," =IF(AE8=0, AE57,AE8)"]
["Translation"]
[]
["Cell","AG8"]
["Heading","Seq"]
["Formula"," =IF(AH8=0,\"\",(MAX(AG$7:AG7)+1)*1)"]
["Translation"]
[]
["Cell","AH8"]
["Heading","P Num"]
["Formula"," =IF(AF8=\"\",0,REPLACE(AF8,SEARCH(\" \",AF8,1),7,\"\"))"]
["Translation"]
[]
["Cell","AI8"]
["Heading","Contact"]
["Formula"," =AD8"]
["Translation"]
[]
["Cell","AJ8"]
["Heading","Seminar"]
["Formula"," =IF(OR(ISNUMBER(SEARCH(\"*Seminar*\",C8)),ISNUMBER(SEARCH(\"*Seminar*\",H8)),ISNUMBER(SEARCH(\"*Seminar*\",M8)),ISNUMBER(SEARCH(\"*Seminar*\",R8)),ISNUMBER(SEARCH(\"*Seminar*\",W8))),AC8,0)"]
["Translation"]
[]
["Cell","AJ33"]
["Heading","toal of seminar minutes column"]
["Formula"," =SUM(AJ8:AJ30)"]
["Translation"]
[]
["Cell","L36"]
["Heading","Total Minutes per Day"]
["Formula"," =ROUND((SUM(G82:AA82)+SUM(G33:AA33))/10*1440,0)/1440"]
["Translation"]

{"sheet":"Sheet2","index":8,"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":""}]