{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INSTRUCTIONS","Project Info","GSF","TEMPLATE","REF"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":7,"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":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,1],[9,0,9,2],[12,0,12,1],[13,0,13,1],[14,0,14,1]]}
["Procedure",null,"Description"]
[null,"I. Complete Project Info","Complete sections I. and II. as shown"]
[null,"II. Complete GSF","This spreadsheet is used to generate one spreadsheet per floor based off of the information you provide. Follow the instructions on the page.  "]
[null,"III. Complete Information per floor. ","Complete one spreadsheet per floor."]
[null,"IV. Submit this document to UK Project Manager"]
[]
[]
[]
[]
["R E F E R E N C E"]
[]
[]
["Gross Area (Gross Square Feet—GSF)",null," is the sum of all areas on all floors of a building included within the outside faces of its exterior walls, including all vertical penetration areas, for circulation and shaft areas that connect one floor to another."]
["Basis for Measurement:  ",null,"Gross Area is computed by physically measuring or scaling measurements from the outside faces of exterior walls, disregarding cornices, pilasters, buttresses, etc., that extend beyond the wall faces. "]
["Exterior spaces",null," (as defined below) count as part of the Gross Square Footage (GSF) of the facility and as part of the unassignable area of the facility for University space inventory purposes.\nExterior Spaces for covered areas, whether walled or not, provided they are either within the outside face lines of the buildings to the extent of the roof drip line, or if covered, to the extent of their cover’s drip line.  (Walkways, pedestrian bridges, porches, porte-cocheres, loading docks, inner or outer balconies to the extent of a drip line from a roof or balcony immediately above and patios beneath building overhangs) "]

{"sheet":"Project Info","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,0,0,1]]}
["UK INFORMATION"]
["Building Name:",null,null,null,"Step I.","Complete all information"]
["Building Number: ",null,null,null,"Step II.","Continue to the next section"]
["Project #:"]
["Project Manager:"]
[]
["CONSULTANT  INFO"]
["Contact Person:"]
["Phone #:"]
["Email Address:"]

{"sheet":"GSF","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,7,1,15],[2,7,2,15],[26,1,26,3]]}
["Floor Level","Level","GSF\nGross Area per floor [SF]"]
[null,null,null,null,null,null,"Step I.                                                                                                                      ","Complete information for all floors; add more rows using the appropriate buttons if necessary.      "]
[null,null,null,null,null,null,"Step II.   ","Click \"Auto-Generate Tabs\" once complete    "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAL",{"$f":"SUM(C2:C22)","v":0},"Sum of Gross Area per floor [SF]"]

{"sheet":"TEMPLATE","index":3,"n_rows":202,"n_cols":12,"rows_kept":202,"cut":false,"hidden":true,"merged":[[0,10,0,14],[1,11,1,16],[2,11,2,16],[3,11,3,16],[4,11,4,16]]}
["Floor Level","Floor Plan Room Number ","Room Name","NASF\nNet  Assignable Room Area [SF]","Space Use Description\n[use lookup]","Room / Space Description\n[use lookup]","Space Use Code\n[auto populates]"]
[null,null,null,null,null,null,{"$f":"LEFT(E2, 3)","v":""},null,null,null,"Step I.","Complete information for all rows per level."]
[null,null,null,null,null,null,"",null,null,null,"Step II.","Click \"Done\" once complete"]
[null,null,null,null,null,null,"",null,null,null,"Step III.","Continue to Next Level."]
[null,null,null,null,null,null,"",null,null,null,"Step IV.","When all levels complete, send to project manager"]
[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,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,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,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,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,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,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"LEFT(E34, 3)","v":""}]
[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,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,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,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,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,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,""]
[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,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"LEFT(E66, 3)","v":""}]
[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,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,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,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,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,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,""]
[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,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"LEFT(E98, 3)","v":""}]
[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,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,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,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,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,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,""]
[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,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"LEFT(E130, 3)","v":""}]
[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,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,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,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,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,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,""]
[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,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"LEFT(E162, 3)","v":""}]
[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,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,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,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,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,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,""]
[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,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"LEFT(E194, 3)","v":""}]
[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,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,"Total NASF per floor",{"$f":"SUM(D1:D201)","v":0}]

{"sheet":"REF","index":4,"n_rows":115,"n_cols":5,"rows_kept":115,"cut":false,"hidden":true,"merged":[]}
["Assignable Space Use Categories",null,null,null,"Room / Space Description"]
["<--- 000 Unclassified --->",null,null,null,"New Room in New Building"]
["000 - Building Services / Infrastructure",null,null,null,"Existing -no change to room"]
["050 - Inactive Area",null,null,null,"Room ID changed: xxx Changed To yyy"]
["060 - Alteration or Conversion Area",null,null,null,"Room Created"]
["070 - Unfinished Area",null,null,null,"Room Deleted"]
["<--- 100 Classroom --->",null,null,null,"Room Made Bigger"]
["110 - Classroom",null,null,null,"Room Made Smaller"]
["115 - Classroom Service",null,null,null,"Other: describe reno"]
["<--- 200 Laboratory Facilities --->"]
["210 - Class Laboratory"]
["215 - Class Laboratory Service"]
["220 - Open Lab/Computer Lab"]
["225 - Open Lab/Computer Lab Support"]
["250 - Research Lab"]
["255 - Research Laboratory Service / Non-class"]
["256 - Research/Non-class Wet Laboratory Servic"]
["257 - Research/Non-class Dry Laboratory Service"]
["<--- 300 Office Facilities --->"]
["310 - Office"]
["315 - Office Service (Reception/Mail/Copiers/Kitchenette/Storage"]
["320 - Office Faculty "]
["330 - Office Clerical "]
["340 - Office Graduate Assistant"]
["345 - Office Technical/Professional"]
["350 - Conference Room"]
["355 - Conference Room Service"]
["390 - Office Space Dormitory"]
["<--- 400 Study Facilities --->"]
["410 - Study Room"]
["420 - Stack"]
["430 - Open-Stack Study Room"]
["440 - Processing Room"]
["455 - Study Service"]
["490 - Dormitory Study Space"]
["<--- 500 Special Use Facilities --->"]
["510 - Armory"]
["515 - Armory Service"]
["520 - Athletic or Physical Education"]
["523 - Athletic Facilities Spectator Seating"]
["525 - Athletic or Physical Education Service"]
["530 - Media Production"]
["535 - Media Production Service"]
["540 - Clinic"]
["545 - Clinic Service"]
["550 - Demonstration"]
["555 - Demonstration Service"]
["560 - Field Building"]
["570 - Animal Facilities"]
["575 - Animal Facilities Service"]
["580 - Greenhouse"]
["585 - Greenhouse Service"]
["590 - Other (All Purpose)"]
["<--- 600 General Use Facilities --->"]
["610 - Assembly"]
["615 - Assembly Service"]
["620 - Exhibition"]
["625 - Exhibition Service"]
["630 - Food Facility"]
["635 - Food Facility Service"]
["640 - Day Care"]
["645 - Day Care Service"]
["650 - Lounge"]
["655 - Lounge Service"]
["660 - Merchandising"]
["665 - Merchandising Service"]
["670 - Recreation"]
["675 - Recreation Service"]
["680 - Meeting Room"]
["685 - Meeting Room Service"]
["<--- 700 Support Facilities --->"]
["710 - Central Computer or Telecommunications"]
["715 - Central Computer or Telecommunications Service"]
["720 - Shop"]
["725 - Shop Service"]
["730 - Central Storage"]
["735 - Central Storage Service"]
["740 - Vehicle Storage"]
["745 - Vehicle Storage Service"]
["750 - Central Service"]
["755 - Central Service Support"]
["760 - Hazardous Materials Storage"]
["770 - Hazardous Waste Storage"]
["775 - Hazardous Waste Service"]
["<--- 800 Health Care Facilities --->"]
["810 - Patient Bedroom"]
["815 - Patient Bedroom Service"]
["820 - Patient Bath"]
["830 - Nurse Station"]
["835 - Nurse Station Service"]
["840 - Surgery"]
["845 - Surgery Service"]
["850 - Treatment/Examination Clinic"]
["855 - Treatment/Examination Clinic Service"]
["860 - Diagnostic Service Laboratory"]
["865 - Diagnostic Service Laboratory Support"]
["870 - Central Supplies"]
["880 - Public Waiting"]
["890 - Staff On-Call Facility"]
["895 - Staff On-Call Facility Service"]
["<--- 900 Residential Facilities --->"]
["910 - Sleep/Study Without Toilet or Bath"]
["919 - Toilet or Bath"]
["920 - Sleep/Study With Toilet or Bath"]
["935 - Sleep/Study Service"]
["950 - Apartment"]
["955 - Apartment Service"]
["970 - House"]
["<--- PPP; VVV; WWW; XXX; YYY; ZZZ --->"]
["PPP  - President's Residence"]
["VVV -  Toilet"]
["WWW -  Circulation Area"]
["XXX  - Building Services"]
["YYY  - Mechanical"]
["ZZZ - Structure Area"]