{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Form 19","Reference Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Instructions for Using Form 19"]
[]
[null,"Form 19 has been developed to allow Education to monitor and report on relocations of Outreach Programs into K-12 facilities."]
[]
[null,"Form 19 is only required when a school authority is first relocating an existing Outreach Program into a facility with an active K-12 program."]
[]
[null,"The Form is a protected worksheet.  The fields highlighted in light green are input fields.  The fields highighted in light grey are protected fields with formulas and cannot be changed."]
[]
[null,"Select your school jurisdiction from the drop down in field G11"]
[]
[null,"Enter the Existing Outreach Program Code in Field 13G.  Please note, this form is not used to apply for permission to operate an Outreach Program.  If you do not currently have an active Outreach Program you will need to refer to the Outreach Program Handbook."]
[]
[null,"Fill in the remaining input fields.  "]
[]
[null,"If the relocation of the Outreach Program to a school facility results in an estimated area per student that exceeds the threshhold of three times the rated area per student for students in a regular 10-12 program, or if the newly Designated Outreach Space exceeds 150% of the space that previously accommodated the outreach program, the message 'Explanation Required' will appear in ROW 27.   If this message appears an explanation will be required in C33 to identify why the program is requiring significantly more space.  Any form showing the Explanation Required message will need to be approved by Education before the IAF can be processed."]
[]
[null,"If you have macro capability on your computer, you can use the Name and Save Button to automatically save the file with a consistent syntax.  The Form 19 file will save to the Documents folder of your computer.  "]
[]
[null,"Attach the relevant Form 19 to the email that you are sending to Capital Planning with the revised IAF for the K-12 school."]
[]
[null,"If you have any questions regarding this information, please contact Pat Brideaux by email at pat.brideaux@gov.ab.ca"]

{"sheet":"Form 19","index":1,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[15,2,15,4],[15,6,15,7],[21,6,21,10],[29,9,29,10],[26,8,26,9],[27,2,27,10],[17,2,17,4],[18,2,18,4],[25,2,25,4],[20,2,20,4],[32,2,39,10],[29,3,29,4],[24,2,24,4],[21,2,21,4],[22,2,22,4],[26,2,26,4],[22,8,22,9],[23,2,23,4],[23,8,23,9],[24,8,24,9],[2,2,3,10],[5,2,5,3],[25,8,25,9],[5,4,5,9],[11,2,11,4],[12,2,12,4],[13,2,13,4],[12,6,12,10],[9,2,9,3],[9,6,9,10],[13,6,13,10],[16,2,16,4],[19,2,19,4],[14,6,14,10],[14,2,14,4],[20,6,20,10]]}
[null,null,null,null,null,null,null,null,null,null,"Form 19"]
[null,null,"RELOCATION of OUTREACH PROGRAMS TO EXISTING K-12 FACILITIES"]
[null,null,"Starting with the 2020-21 School Year - Outreach Programs are no longer required to be located in a stand-alone facility.  School authorities choosing to relocate an existing Outreach Program into an under-utilized K-12 facility will need to complete the following information and provide it with the revised Instructional Area Form (IAF).\nDesignated Outreach Spaces are instructional areas, within a school facility that offers an active regular K-12 program, that are used exclusively for the provision of Outreach Education "]
[]
[]
[null,null,"Format for File Name:",null,{"$f":"CONCATENATE(K1:K1,\" - \",N10,\" - \",\"Relocation of Outreach\",\" \",G12,\" to SC\",G20)","v":"Form 19 - FFCA - Relocation of Outreach  to SC"}]
[]
[]
[]
[null,null,"School Jurisdiction",null,null,null,"Foundations for the Future Charter Academy Charter School Society",null,null,null,null,null,null,{"$f":"VLOOKUP(G10,'Reference Data'!A2:B77,2,FALSE)","v":"FFCA"}]
[]
[null,1,"School Code for the Existing Outreach Program"]
[null,2,"School Name of the Existing Outreach Program"]
[null,3,"Name of Third Party Lease Holder for program being relocated"]
[null,4,"Physical Location of the Existing Outreach Program being relocated"]
[null,5,"Outreach being relocated for the School Year"]
[null,6,"Total Area  (in M2) previously leased for the Outreach Program  (include instructional and non-instructional area)"]
[null,7,"Approximate number of students accommodated annually through Outreach Program ( use 5 year average - student enrolment in program)"]
[null,8,"Approximate historical accommodation area per student - in m2 per student",null,null,null,{"$f":"IF(ISBLANK(G18),\"\",+G17/G18)","v":""}]
[null,9,"School Code for the K-12 Program into which the Outreach Program is being relocated - the Receiving School"]
[null,10,"School Name for the K-12 Program into which the Outreach Program is being relocated - the Receiving School"]
[null,11,"How has the facility in #10 above been adjusted to accommodate the Outreach Program?  A new small scale plan must accompany this form and the IAF where there were any changes to the instructional or non-instructional area."]
[null,12,"What was the total non-instructional area in the previous SSP?",null,null,null,2000,null,"What is the total non-instructional area in the new SSP?",null,2400]
[null,13,"Amount of Instructional Space being converted to Designated Outreach Space in the school named above.",null,null,null,null,null,"Approximate difference [Increase/Decrease] in non-instructional space resulting from reconfiguration for Outreach",null,{"$f":"IF(ISBLANK(K23),\"\",+G23-K23)","v":-400}]
[null,null,"Difference [Increase/ (Decrease)] in Area Leased vs allocated to Designated Outreach Space in Owned Building",null,null,null,{"$f":"IF(ISBLANK(K24),\"\",G17-G24)","v":0},null,"Difference [Increase/ (Decrease)] in Area Leased vs allocated to Designated Outreach Space + lost instructional area in Owned Building",null,{"$f":"(+G23-K23)+(G17-G24)","v":-400}]
[null,null,"Estimated accommodation area per outreach student - in K-12 facility - Instructional only",null,null,null,{"$f":"IF(ISBLANK(G24),\"\",+G24/G18)","v":""},null,"Estimated effect to accommodation area per outreach student as a result of relocation",null,{"$f":"IF(ISBLANK(G24),\"\",(G24+K23-G23)/G18)","v":""}]
[null,null,{"$f":"IF(ISBLANK(G24),\"\",IF(G17*150%>G24,\"\",\"Explanation Required-area\"))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(G24),\"\",IF(K26>3.65*3,\"Explanation Required-area per student\",\"\"))","v":""}]
[null,null,"If the Designated Outreach Area is significantly larger than the amount of area previously leased for the Outreach Program, (either the area in M2 or the area per student) a message will appear above indicating that an explanation is required.  Please provide the explanation in the field below.  Any Form 19 that requires an explanation will need to be reviewed and approved by Education staff before the IAF can be processed "]
[]
[null,null,null,"Revised IAF has been completed with the Designated Outreach Space identified above.",null,null,null,null,null,"Revised Small Scale Plan is required and is attached"]
[]
[null,null,"Explanation:"]

{"sheet":"Reference Data","index":2,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":true,"merged":[[81,0,81,1]]}
["Jurisdiction Name","AbbrevList",null,null,null,null,"ACTIVE","ACTIVITY TYPE","CLOSED","SCHOOL YEAR"]
["Almadina School Society","Almadina","YES","ACTIVE","FOR-PROFIT",null,"Designated Lease - For Profit","ADD","Decent Admin","2021-22"]
["Aurora School Ltd.","Aurora","N/A","CLOSED","NOT-FOR-PROFIT",null,"Designated Lease - Not-for-Profit","REVISE","Cross Gov't Lease","2022-23"]
["Boyle Street Education Centre","BSEC",null,null,null,null,"Designated Outreach","DELETE","Lease to Charter School","2023-24"]
["Calgary Arts Academy Society","CAA",null,null,null,null,"Decentralized Admin",null,"Lease to Other School Board","2024-25"]
["Calgary Girls' School Society","CGSS",null,null,null,null,"Other",null,"Lease to Private School","2025-26"]
["CAPE - Centre for Academic and Personal Excellence Institute","CAPE",null,null,null,null,null,null,"Lease to Private Sector - Non School","2026-27"]
["Connect Charter School Society","ConnectCharter",null,null,null,null,null,null,null,"2027-28"]
["Foundations for the Future Charter Academy Charter School Society","FFCA",null,null,null,null,null,null,null,"2028-29"]
["Lloydminster Public School Division","LloydPublic",null,null,null,null,null,null,null,"2029-30"]
["Lloydminster Roman Catholic Separate School Division","LloydCath",null,null,null,null,null,null,null,"2030-31"]
["Mother Earth's Children's Charter School Society","MECCS",null,null,null,null,null,null,null,"2031-32"]
["New Horizons Charter School Society","NHS",null,null,null,null,null,null,null,"2032-33"]
["Suzuki Charter School Society","Suzuki",null,null,null,null,null,null,null,"2033-34"]
["The Aspen View School Division","AVSD",null,null,null,null,null,null,null,"2034-35"]
["The Battle River School Division ","BRSD"]
["The Black Gold School Division ","BGSD"]
["The Buffalo Trail School Division","BTSD"]
["The Calgary Roman Catholic Separate School Division","CRCSSD"]
["The Calgary School Division","CBE"]
["The Canadian Rockies School Division","CRSD"]
["The Chinook's Edge School Division","CESD"]
["The Christ the Redeemer Catholic Separate School Division","CTRCatholic "]
["The Clearview School Division","CSD"]
["The East Central Alberta Catholic Separate School Division","ECACSSD"]
["The East Central Francophone Education Region","ECFER"]
["The Edmonton Catholic Separate School Division","ECSD"]
["The Edmonton School Division","EPSD"]
["The Elk Island Catholic Separate School Division","EICSSD"]
["The Elk Island School Division","EISD"]
["The Evergreen Catholic Separate School Division","ECSSD"]
["The Foothills School Division","FSD"]
["The Fort McMurray Roman Catholic Separate School Division","FMRCSSD"]
["The Fort McMurray School Division","FMSD"]
["The Fort Vermilion School Division","FVSD"]
["The Golden Hills School Division","GHSD"]
["The Grande Prairie Roman Catholic Separate School Division","GPRCSSD"]
["The Grande Prairie School Division ","GPSD"]
["The Grande Yellowhead School Division","GYSD"]
["The Grasslands School Division","GSD"]
["The Greater North Central Francophone Education Region","GNCFER"]
["The Greater St. Albert Roman Catholic Separate School Division","GSARCSSD"]
["The High Prairie School Division","HPSD"]
["The Holy Family Catholic Separate School Division","HFCSSD"]
["The Holy Spirit Roman Catholic Separate School Division","HSRCSSD"]
["The Horizon School Division","HSD"]
["The Lakeland Roman Catholic Separate School Division","LRCSSD"]
["The Lethbridge School Division","LSD"]
["The Living Waters Catholic Separate School Division","LWCSSD"]
["The Livingstone Range School Division","LRSD"]
["The Medicine Hat Roman Catholic Separate School Division","MHRCSSD"]
["The Medicine Hat School Division","MHSD"]
["The Northern Gateway School Division","NGSD"]
["The Northern Lights School Division","NLSD"]
["The Northland School Division","NSD"]
["The Northwest Francophone Education Region","CSNO"]
["The Palliser School Division","Palliser SD"]
["The Parkland School Division","Parkland SD"]
["The Peace River School Division","PRSD"]
["The Peace Wapiti School Division","PWPSD"]
["The Pembina Hills School Division","PHRD"]
["The Prairie Land School Division","PLRD"]
["The Prairie Rose School Division","PRSD"]
["The Red Deer Catholic Separate School Division","RDCSSD"]
["The Red Deer School Division ","RDSD"]
["The Rocky View School Division","RVSD"]
["The Southern Francophone Education Region","FrancoSUD"]
["The St. Albert School Division","SASD"]
["The St. Paul School Division","SPSD"]
["The St. Thomas Aquinas Roman Catholic Separate School Division ","STARCSSD"]
["The Sturgeon School Division ","SSD"]
["The Westwind School Division","Westwind SD"]
["The Wetaskiwin School Division","Wetaskiwin SD"]
["The Wild Rose School Division ","WRSD"]
["The Wolf Creek School Division","WCSD"]
["Valhalla School Foundation","Valhalla"]
["Westmount Charter School Society","Westmount"]
[]
[]
[]
[]
["Designation of already existing classrooms only - no changes to interior walls"]
["Designation of existing classrooms and reconfig of non-instruct spaces only (entrances, etc)"]
["Reconfiguration of space that changed instructional & non-instructional areas"]