{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Form 4","Reference Data"],"not_rendered":{"charts":0,"images":2,"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":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Background: "]
[null,"To reflect the changes for reporting designated school space, Alberta Education revised the Reporting Designated Space in School Buildings Form (Form 4) for 2021/22. These changes will help to ensure alignment of official data between Alberta Infrastructure and Alberta Education. Alberta Education uses this data in the calculation of IMR and O&M Space Allocation Funding."]
[null,"School Authorities must submit an updated Form 4 every school year by the deadline identified in the Reporting of School Space Allocations for Calculation of Operations and Maintenance Grant Guidelines. For 2021-22, Alberta Education is providing your school authority a version of the Form 4 that is pre-populated with all of the Lease Data that was on file with Alberta Infrastructure for the 2020-21 school year.  "]
[null,"Going forward, the previous year’s submission will be the starting point for the next year’s submission.  For example, in 2022/23 you will be able to make a copy of the 2021/22 Form 4 submission. You can then revise, add, and delete to reflect the changes in designated space. Any changes to the instructions or filing dates will be published in the Reporting of School Space Allocations for Calculation of Operations and Maintenance Grant Guidelines."]
[null,"Form 4 - Instructions: "]
[null,"Please review all information in the form provided. Update the designated spaces (in the blue table), paying specific attention to the following: "]
[null,"1.)    If the lease or designated space is ongoing and in a school with an active K-12 program: "]
[null,"-          Column C should say “Active” "]
[null,"-          Select “Revise” in Column D, and "]
[null,"-          Identify the type of user – using the drop down list - in Column I."]
[null,"-          Leave Column J blank. "]
[null,"-          Complete the rest of the columns. "]
[null,"2.)    If the lease or designated space is ongoing and is in a school that does not have an Active K-12 program: "]
[null,"-          Ensure that Column C says “closed”, "]
[null,"-          Leave Column I blank, and select the appropriate user type from the drop-down in Column J"]
[null,"-          Complete the rest of the columns. "]
[null,"3.)    If the lease or designated space is not active, regardless of location: "]
[null,"-          Select “delete lease” in Column D  "]
[null,"-          Update the end of the lease in column L. "]
[null,"4.)    If you are adding a lease or designated space that is not currently in the list, complete all the columns (column I if the school has an active K-12 program, OR Column J if the lease is in a closed school) and select “Add” in Column D. "]
[null,"Notes: "]
[null,"-          Ensure Column N accurately reflects the amount of total leased area. This area may be equal to or greater than the designated instructional area identified in the Instructional Area Form, if non-instructional area is included in the lease agreement. "]
[null,"-          Either Column I or J should be completed for any given record, not both. "]
[null,"-          Lease and Outreach changes reported in this document also require an updated Instructional Area Form; Column O is confirmation that you have updated your IAF to reflect the designated space. “No” is not an option. "]
[null,"-          If you have macro capability on your computer, you can use the “Name and Save” button to save the file automatically with a consistent syntax.  Your file will save to the Documents Folder of your computer."]
[null,"-          The completed Excel version of the file can be emailed as outlined in the pink highlighted text in Row 7."]
[]
[null,"Data Fields: "]
[null,"Active or Closed School – does the building currently contain an active K-12 program, “Active” means yes, “Closed School” means no. "]
[null,"Add / Revise / Delete Lease – “Add” means a newly designated space is being reported, “revised” means a previously reported space is being updated or continuing, and “Delete” means a previously identified lease or designated space is not longer being used. "]
[null,"School Code – This is the unique 4-digit code assigned by Education "]
[null,"Facility Code – This is the code that begins with F and is followed by 4 digits.  It is assigned by Infrastructure and can be found on your Gross Area Data Report"]
[null,"Name of School – The official name as identified on your ACU report"]
[null,"Lessee – The name of the organization that has entered into the lease agreement."]
[null,"Type of User in an Active School  - As outlined in Appendix D of the School Capital Manual"]
[null,"Type of User in a Closed School - As outlined in Appendix D of the School Capital Manual"]
[null,"Start Date – this would be the start date of the signed lease.  If this is a renewed lease, the start date would be the renewal date.    Uses the Canadian standard calendar format of dd/mm/yy\""]
[null,"End Date – this would be the scheduled end date of the lease.   As designated leases are supposed to be 1 year renewable leases, this would normally be the end of June or the end of August of the current school year.  Uses the Canadian standard calendar format of DD/MM/YYYY, however you can enter Sep 1, 2021 and it will be automatically reformatted."]
[null,"Monthly Lease Rate – this is the full cost by month.  Enter the amount only – ex. 2400 NOT $2400/month"]
[null,"Total Leased Area in M2  - enter the area as a decimal number without the measure"]
[null,"This area has been identified in the IAF – This is simply a reminder field to ensure alignment of the data being reported.  N/A is only an option only for Closed Schools and for Active Schools where decentralized admin is being reported.  All other active Designated Leased Space should also be reported in the IAF."]

{"sheet":"Form 4","index":1,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,2,13,14],[16,10,16,11],[0,6,3,12],[10,2,10,4],[10,6,10,9],[10,11,10,12],[5,11,5,14],[15,2,15,3]]}
[null,null,null,null,null,null,"REPORTING DESIGNATED SPACE IN SCHOOL BUILDINGS\n(For Leases, Outreach Programs & Decentralized Admin)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form 4"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(N11,\" - \",O3,\" - \",R11)","v":{"$error":"#N/A"}}]
[null,null,"This form must be updated annually to inform government of all current leases in Designated School Space.1    Please email the EXCEL version of this form to: gary.tran@gov.ab.ca"]
[]
[]
[]
[null,null,"School Jurisdiction (Lessor):",null,null,null,null,null,null,null,null,"For the School Year",null,null,null,null,null,{"$f":"VLOOKUP(G11,'Reference Data'!A2:B77,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Starting with the 2021-22 School Year - only report leases that are in spaces defined as Designated School Space. \nDesignated School Spaces are areas within the school facility provided to the leasee for use during normal school operating hours.  The school authority does not use these areas for K-12 Program Delivery."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Term of Lease"]
[null,null,"Active or Closed School","Add / Revise / Delete Lease","School Code","Facility Code","Name of School","Lessee","Active School - Type of User \n(As outlined in Appendix D of the School Capital Manual)","Closed School - Type of User\n(As outlined in Appendix D of the School Capital Manual)","Start Date\nDD/MM/YYYY","End Date\nDD/MM/YYY","Monthly Lease Rate\n$/month","Total Leased Area in M2","This area has been identified in the IAF "]

{"sheet":"Reference Data","index":2,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["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"]