{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Instructions","Data Code Legend","Data Entry","Data Validation","Jurisdiction List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":39,"comments":1,"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":"Summary","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data Code Legend","index":2,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,0,31,1],[0,0,0,1],[16,0,16,1],[25,0,25,1]]}
["Instructional Space"]
["Room Name","Code","Notes"]
["Classroom","CR"]
["Early Childhood Services","ECS","Listed under CR in form"]
["Distance Learning Classroom","DLC","Listed under CR in form"]
["Special Education Classroom","SED","Listed under CR in form"]
["Science Room","SCI"]
["Ancillary Rooms (Music, Drama, Arts)","ANC"]
["Breakout Rooms","BREAKOUT"]
["Business Education (Typing, Computers)","BES","Listed under COM/BES in form"]
["Computer Room","COM","Listed under COM/BES in form"]
["Stage","STG","Listed under STG/SAN in form"]
["Stage Ancillary","SAN","Listed under STG/SAN in form"]
["Modular","MODULAR","For any modular classroom, no matter if it's CR or ECS; This is for modulars and portables, attached or detached"]
[]
[]
["Career & Technology Studies"]
["Room Name","Code"]
["Career Technology Studies","CTS"]
["Home Economics","HEC"]
["Industrial Arts","IA"]
["Kitchen","KIT"]
["Vocational Education","VED"]
[]
[]
["Physical Activity Space"]
["Room Name","Code"]
["Gymnasium","GYM"]
["Physical Activity Room","PAR"]
[]
[]
["Libraries"]
["Room Name","Code"]
["Library","LIB"]

{"sheet":"Data Entry","index":3,"n_rows":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":false,"merged":[[13,17,13,19],[30,13,36,15],[3,2,3,3],[2,2,2,3],[13,1,13,3],[4,2,4,3],[6,2,6,3],[7,2,7,3],[5,2,5,3],[13,7,13,10],[13,12,13,15]]}
[null,"Instructional Area Form"]
[]
[null,"School Name"]
[null,"Jurisdiction"]
[null,"Jurisdiction Code",{"$f":"IF(Jurisdiction=\"\", \"-\", LOOKUP(Jurisdiction,JurisTable))","v":"-"}]
[null,"School Code","xxxx"]
[null,"Facility Code","Fxxxx"]
[null,"Building ID","BxxxxA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"School Instructional  Area (less exempt)",{"$f":"SUM(D47)","v":0}]
[null,"Grade Configuration ",null,"to",null,null,null,null,"School Gross Area (m2)",null,null,null,null,"Area Per Student",{"$f":"IF($C$10=\"\",0,IF($E$10<7,'Data Validation'!M4,IF($C$10=7,'Data Validation'!M6, IF($E$10<10,'Data Validation'!M5,IF($C$10=\"K\",'Data Validation'!M6,IF($C$10<9,'Data Validation'!M6,IF($C$10>8,'Data Validation'!M7,0)))))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Capacity",{"$f":"IF(O10=0,0,ROUND((O9/O10+K32+P27+T21),0))","v":0}]
[]
[]
[null,"Instructional Space ",null,null,null,null,null,"Career and Technology Studies",null,null,null,null,"Physical Activity Space",null,null,null,null,"Libraries"]
[null,"Room Number","Code ","Area (m2)","Exempt?^",null,null,"Room Number","Code ","Area (m2)","Rated Capacity",null,"Room Number","Code","Area (m2)","Rated Capacity",null,"Room Number","Area (m2)","Rated Capacity"]
[null,null,null,null,null,{"$f":"IF(E16=\"Yes\",D16,0)","v":0},null,null,null,null,{"$f":"IF(I16=\"\",,20)","v":0},null,null,null,null,{"$f":"IF(O16=\"\",0,IF(N16=\"PAR\",20, IF(($O$9/$O$10)<=300, 0, IF($C$10=\"K\",0,IF($C$10<7,0,IF(O16<641,25,IF(O16<801,50,IF(O16>800,75))))))))","v":0},null,null,null,{"$f":"IF(S16=\"\",0,IF(($O$9/$O$10)<=300,0,IF($C$10=\"K\",0,IF($C$10<7,0,25))))","v":0}]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,{"$f":"IF(S17=\"\",0,IF(($O$9/$O$10)<=300,0,IF($C$10=\"K\",0,IF($C$10<7,0,25))))","v":0}]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,{"$f":"IF(S18=\"\",0,IF(($O$9/$O$10)<=300,0,IF($C$10=\"K\",0,IF($C$10<7,0,25))))","v":0}]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,"Total ",{"$f":"SUM(T16:T18)","v":0}]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0,null,null,null,"Total ",{"$f":"SUM(P16:P24)","v":0}]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0,null,null,"Notes:"]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,"Total ",{"$f":"SUM(J16:J30)","v":0},{"$f":"SUM(K16:K30)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"IF(E35=\"Yes\",D35,0)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"IF(E39=\"Yes\",D39,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(E40=\"Yes\",D40,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(E41=\"Yes\",D41,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(E42=\"Yes\",D42,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(E43=\"Yes\",D43,0)","v":0}]
[null,"^ Enter \"Yes\" if space is exempt, such as  being leased out ."]
[]
[null,"Total ",null,{"$f":"SUM(D16:D43)","v":0},null,{"$f":"SUM(F16:F43)","v":0}]
[null,"Total Less Exempt Area",null,{"$f":"D46-F46","v":0}]

{"sheet":"Data Validation","index":4,"n_rows":21,"n_cols":44,"rows_kept":21,"cut":false,"hidden":true,"merged":[[19,6,19,7]]}
[]
[]
[null,null,null,null,null,"Data for Drop Down Cells",null,null,null,null,null,null,"Area per student"]
[null,null,null,null,null,"CR","CTS","K","GYM",null,"K-3, K-4, K-5, K-6",null,3.47]
[null,null,null,null,null,"ANC","HEC",1,"PAR",null,"K-9, 5-9",null,3.61]
[null,null,null,null,null,"SCI","IA",2,null,null,"K-12, 7-9, 7-12",null,3.69]
[null,null,null,null,null,"MODULAR","KIT",3,null,null,"9-12, 10-12",null,3.65]
[null,null,null,null,null,"BREAKOUT","VED",4,"0-640"]
[null,null,null,null,null,"COM/BSE",null,5,"641-800"]
[null,null,null,null,null,"STG/SAN",null,6,"801-"]
[null,null,null,null,null,"Other",null,7]
[null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,9,"Yes"]
[null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,12]
[]
[]
[]
["School Name","Jurisdiction","Jurisdiction Code","School Code","Facility Code","Building ID","Grade Configuration",null,"Gross Area","Exempt Instructional Area","CTS Capacity","# CTS labs","Total CTS Area","Gym Capacity","# Gyms","Gym Area","PAR Capacity","# PARs","PAR Area","Library Capacity","# Library","Library Area","# Classrooms","Area of Classrooms","# Science Rooms","Area of Science Rooms","# Breakout Rooms","Area of Breakout Rooms","# Ancillary Rooms","Area of Ancillary Rroms","# Modulars","Area of Modulars","# Stages","Area of Stages","# Computer Labs","Area of Computer Labs","# Other Rooms","Area of Other Rooms","Notes","Total Instructional Area","Instructional Area per Student","Net Instructional Area","Total Capacity","Net Capacity"]
[{"$f":"SchoolName","v":0},{"$f":"Jurisdiction","v":0},{"$f":"JurisdictionCode","v":"-"},{"$f":"SchoolCode","v":"xxxx"},{"$f":"FacilityCode","v":"Fxxxx"},{"$f":"BuildingID","v":"BxxxxA"},{"$f":"'Data Entry'!C10","v":0},{"$f":"'Data Entry'!E10","v":0},{"$f":"'Data Entry'!J10","v":0},{"$f":"'Data Entry'!F46","v":0},{"$f":"'Data Entry'!K32","v":0},{"$f":"COUNT(CTSArea)","v":0},{"$f":"'Data Entry'!J32","v":0},{"$f":"SUMIF(GymPARCode, \"GYM\", GymPARCapacity)","v":0},{"$f":"COUNTIF(GymPARCode, \"Gym\")","v":0},{"$f":"SUMIF(GymPARCode, \"GYM\", GymPARArea)","v":0},{"$f":"SUMIF(GymPARCode, \"PAR\", GymPARCapacity)","v":0},{"$f":"COUNTIF(GymPARCode, \"PAR\")","v":0},{"$f":"SUMIF(GymPARCode, \"PAR\", GymPARArea)","v":0},{"$f":"'Data Entry'!T21","v":0},{"$f":"COUNT(LibraryArea)","v":0},{"$f":"SUM(LibraryArea)","v":0},{"$f":"COUNTIF(InstrAreaCode, \"CR\")","v":0},{"$f":"SUMIF(InstrAreaCode, \"CR\", InstrArea)","v":0},{"$f":"COUNTIF(InstrAreaCode, \"SCI\")","v":0},{"$f":"SUMIF(InstrAreaCode, \"SCI\", InstrArea)","v":0},{"$f":"COUNTIF(InstrAreaCode,\"BREAKOUT\")","v":0},{"$f":"SUMIF(InstrAreaCode, \"BREAKOUT\", InstrArea)","v":0},{"$f":"COUNTIF(InstrAreaCode, \"ANC\")","v":0},{"$f":"SUMIF(InstrAreaCode, \"ANC\", InstrArea)","v":0},{"$f":"COUNTIF(InstrAreaCode, \"MODULAR\")","v":0},{"$f":"SUMIF(InstrAreaCode, \"MODULAR\", InstrArea)","v":0},{"$f":"COUNTIF(InstrAreaCode, \"STG/SAN\")","v":0},{"$f":"SUMIF(InstrAreaCode, \"STG/SAN\", InstrArea)","v":0},{"$f":"COUNTIF(InstrAreaCode, \"COM/BSE\")","v":0},{"$f":"SUMIF(InstrAreaCode, \"COM/BSE\", InstrArea)","v":0},{"$f":"COUNTIF(InstrAreaCode, \"Other\")","v":0},{"$f":"SUMIF(InstrAreaCode, \"Other\", InstrArea)","v":0},{"$f":"'Data Entry'!N31","v":0},{"$f":"SUM(X21,Z21,AB21,AD21,AF21,AH21,AJ21,AL21)","v":0},{"$f":"'Data Entry'!O10","v":0},{"$f":"SUM(X21,Z21,AB21,AD21,AF21,AH21,AJ21,AL21)-J21","v":0},{"$f":"(AN21/AO21)+K21+N21+Q21+T21","v":{"$error":"#DIV/0!"}},{"$f":"(AP21/AO21)+K21+N21+Q21+T21","v":{"$error":"#DIV/0!"}}]

{"sheet":"Jurisdiction List","index":5,"n_rows":76,"n_cols":2,"rows_kept":76,"cut":false,"hidden":true,"merged":[]}
["Almadina School Society","6021"]
["Aspen View Public School Division No. 78","2125"]
["Aurora School Ltd.","6020"]
["Battle River Regional Division No. 31","2285"]
["Black Gold Regional Division No. 18","2245"]
["Boyle Street Education Centre","6017"]
["Buffalo Trail Public Schools Regional Division No. 28","1155"]
["Calgary Arts Academy Society","0151"]
["Calgary Girls' School Society","0152"]
["Calgary Roman Catholic Separate School District No. 1","4010"]
["Calgary School District No. 19","3030"]
["Canadian Rockies Regional Division No. 12","3065"]
["CAPE - Centre for Academic and Personal Excellence Institute","6019"]
["Chinook's Edge School Division No. 73","0053"]
["Christ the Redeemer Catholic Separate Regional Division No. 3","4208"]
["Clearview School Division No. 71","0052"]
["Connect Charter School Society","0045"]
["East Central Alberta Catholic Separate Schools Regional Division No. 16","4330"]
["East Central Francophone Education Region No. 3","8060"]
["Edmonton Catholic Separate School District No. 7","0110"]
["Edmonton School District No. 7","3020"]
["Elk Island Catholic Separate Regional Division No. 41","0046"]
["Elk Island Public Schools Regional Division No. 14","2195"]
["Evergreen Catholic Separate Regional Division No. 2","0048"]
["Foothills School Division No. 38","1180"]
["Fort McMurray Public School District No. 2833","3260"]
["Fort McMurray Roman Catholic Separate School District No. 32","4160"]
["Fort Vermilion School Division No. 52","1250"]
["Foundations for the Future Charter Academy Charter School Society","0009"]
["Golden Hills School Division No. 75","2155"]
["Grande Prairie Roman Catholic Separate School District No. 28","4130"]
["Grande Prairie School District No. 2357","3240"]
["Grande Yellowhead Public School Division No. 77","1085"]
["Grasslands Regional Division No. 6","2045"]
["Greater North Central Francophone Education Region No. 2","8040"]
["Greater St. Albert Roman Catholic Separate School District No. 734","4077"]
["High Prairie School Division No. 48","1220"]
["Holy Family Catholic Regional Division No. 37","0021"]
["Holy Spirit Roman Catholic Separate Regional Division No. 4","4481"]
["Horizon School Division No. 67","1045"]
["Lakeland Roman Catholic Separate School District No. 150","4105"]
["Lethbridge School District No. 51","3040"]
["Living Waters Catholic Regional Division No. 42","0047"]
["Livingstone Range School Division No. 68","1135"]
["Lloydminster Public School Division","3170"]
["Lloydminster Roman Catholic Separate School Division","4870"]
["Medicine Hat Catholic Separate Regional Division No. 20","4501"]
["Medicine Hat School District No. 76","3050"]
["Mother Earth's Children's Charter School Society","0154"]
["New Horizons Charter School Society","6015"]
["Northern Gateway Regional Division No. 10","2275"]
["Northern Lights School Division No. 69","1245"]
["Northland School Division No. 61","1280"]
["Northwest Francophone Education Region No. 1","8050"]
["Palliser Regional Division No. 26","2255"]
["Parkland School Division No. 70","2305"]
["Peace River School Division No. 10","1070"]
["Peace Wapiti School Division No. 76","0177"]
["Pembina Hills Regional Division No. 7","1175"]
["Prairie Land Regional Division No. 25","1115"]
["Prairie Rose School Division No. 8","0195"]
["Red Deer Catholic Regional Division No. 39","0019"]
["Red Deer Public School District No. 104","3070"]
["Rocky View School Division No. 41","1190"]
["St. Albert Public School District No. 5565","7020"]
["St. Paul Education Regional Division No. 1","2185"]
["St. Thomas Aquinas Roman Catholic Separate Regional Division No. 38","0020"]
["Sturgeon School Division No. 24","1110"]
["Suzuki Charter School Society","0012"]
["The Southern Francophone Education Region No. 4","0284"]
["Valhalla School Foundation","0224"]
["Westmount Charter School Society","0109"]
["Westwind School Division No. 74","0056"]
["Wetaskiwin Regional Division No. 11","2115"]
["Wild Rose School Division No. 66","1325"]
["Wolf Creek School Division No. 72","0054"]