{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data","Notes on Changes","Page1","AttachmentA","Use Groups","Codes"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":"Data","index":0,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["BUILDING TYPE","STANDARD BUILDING"]
["FORM TYPE","CERTIFICATE"]
[]
["PROJECT"]
["Agency Code",{"$f":"TEXT(Page1!J9,\"000\")","v":"000"}]
["Project Num",{"$f":"TEXT(Page1!J10,\"00000\")","v":"00000"}]
["Subproject Num",{"$f":"TEXT(Page1!J11,\"000\")","v":"000"}]
["Subproject Title",{"$f":"UPPER(Page1!N11)","v":""}]
[]
["BUILDING INFO"]
["Building Description",{"$f":"UPPER(Page1!N16)","v":""}]
["Building FIPS",{"$f":"LEFT(Page1!N12,3)","v":""}]
["Purpose-Occupancy",{"$f":"UPPER(Page1!N18)","v":""}]
["Occupancy Load",{"$f":"UPPER(Page1!N19)","v":""}]
["Occupancy Remarks",{"$f":"UPPER(Page1!N20)","v":""}]
["Code Edition",{"$f":"UPPER(Page1!N21)","v":""}]
["Use Group",{"$f":"UPPER(Page1!N23)","v":""}]
["Construction Type",{"$f":"UPPER(Page1!N24)","v":""}]
["Height",{"$f":"UPPER(Page1!N25)","v":""}]
["Number of Stories",{"$f":"UPPER(Page1!N26)","v":""}]
["Gross Area",{"$f":"UPPER(Page1!N27)","v":""}]
["Code Modifications",{"$f":"UPPER(Page1!N28)","v":""}]
["Floor Live Load",{"$f":"UPPER(Page1!N31)","v":""}]
["Roof Live Load",{"$f":"UPPER(Page1!N33)","v":""}]
["Soil Bearing Capacity",{"$f":"UPPER(Page1!AQ33)","v":""}]
["Wind Speed",{"$f":"UPPER(Page1!Z35)","v":""}]
["Wind Exposure Category",{"$f":"UPPER(Page1!Z37)","v":""}]
["Bldg Classification Category","* NEW, RESERVED FOR IBC (I,II,III,IV)"]
["Seismic Exposure Group",{"$f":"UPPER(Page1!#REF!)","v":{"$error":"#REF!"}}]
["Seismic Performance Cat",{"$f":"UPPER(Page1!#REF!)","v":{"$error":"#REF!"}}]
["Seismic Design Category","* NEW, RESERVED FOR IBC (A,B,C,D)"]
["Fire Suppression - Wet",{"$f":"IF(Page1!B42=\"\",\"N\",\"X\")","v":"N"}]
["Fire Suppression - Dry",{"$f":"IF(Page1!B43=\"\",\"N\",\"X\")","v":"N"}]
["Fire Suppression - Chemical",{"$f":"IF(Page1!B44=\"\",\"N\",\"X\")","v":"N"}]
["Fire Suppression - Other",{"$f":"IF(Page1!B45=\"\",\"N\",\"X\")","v":"N"}]
["Fire Suppression - None",{"$f":"IF(Page1!B46=\"\",\"N\",\"X\")","v":"N"}]
["Fire Suppression - Not Reqd",{"$f":"IF(Page1!B47=\"\",\"N\",\"X\")","v":"N"}]
["Elevators - New",{"$f":"IF(Page1!K42=\"\",\"N\",\"X\")","v":"N"}]
["Elevators - Existing",{"$f":"IF(Page1!K43=\"\",\"N\",\"X\")","v":"N"}]
["Elevators - Number",{"$f":"Page1!S44","v":0}]
["Fire Alarm - Auto",{"$f":"IF(Page1!V42=\"\",\"N\",\"X\")","v":"N"}]
["Fire Alarm - Manual",{"$f":"IF(Page1!V43=\"\",\"N\",\"X\")","v":"N"}]
["Fire Alarm - None",{"$f":"IF(Page1!V44=\"\",\"N\",\"X\")","v":"N"}]
["Fire Alarm - Not Reqd",{"$f":"IF(Page1!V45=\"\",\"N\",\"X\")","v":"N"}]
[]
["CERTIFICATE INFO"]
["Issue Date",{"$f":"IF(Page1!AT3=0,\"\",Page1!AT3)","v":""}]
["Expiration Date",{"$f":"IF(Page1!AT4=0,\"\",Page1!AT4)","v":""}]
["AE Cert Sub Complt",{"$f":"IF(Page1!AS42=0,\"\",Page1!AS42)","v":""}]
["Cntr Cert Sub Complt",{"$f":"IF(Page1!AS43=0,\"\",Page1!AS43)","v":""}]
["Fire Marshal Insp Rpt",{"$f":"IF(Page1!AS44=0,\"\",Page1!AS44)","v":""}]
["CO-13b Checklist",{"$f":"IF(Page1!AS45=0,\"\",Page1!AS45)","v":""}]
["CO-13b Checklist Signer",{"$f":"UPPER(Page1!AJ46)","v":""}]

{"sheet":"Notes on Changes","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date","Change"]
["2008-09-25","Copy to section added Office of Risk Mgmt"]

{"sheet":"Page1","index":2,"n_rows":69,"n_cols":42,"rows_kept":69,"cut":false,"hidden":false,"merged":[[66,28,67,48],[50,1,59,48],[47,21,47,28],[61,7,61,20],[63,7,63,18],[47,44,47,48],[61,34,61,47],[62,34,62,39],[62,42,62,47],[63,34,63,47],[17,1,17,12],[18,1,18,12],[34,44,34,45],[30,13,30,17],[64,7,64,18],[64,19,64,22],[48,1,48,48],[49,1,49,48],[60,1,60,48],[20,13,20,45],[24,13,24,45],[36,30,36,41],[36,44,36,45],[45,44,45,48],[46,18,46,19],[45,18,45,19],[32,13,32,17],[21,1,21,12],[34,1,34,12],[27,1,27,12],[28,1,28,12],[30,1,30,12],[24,1,24,12],[25,1,25,12],[15,1,15,12],[32,42,32,45],[34,25,34,26],[39,1,39,8],[43,18,43,19],[39,21,39,28],[36,1,36,12],[36,25,36,26],[44,10,44,19],[43,12,43,17],[42,44,42,48],[43,44,43,48],[22,1,22,12],[23,1,23,12],[22,13,22,45],[23,13,23,45],[26,1,26,12],[20,1,20,12],[25,13,25,45],[39,30,39,48],[41,18,41,19],[32,1,32,12],[44,44,44,48],[42,18,42,19],[0,9,0,40],[7,9,7,11],[13,8,13,11],[10,3,10,8],[3,45,3,48],[5,1,5,8],[5,9,5,40],[10,13,10,45],[11,3,11,12],[1,41,1,48],[1,9,1,40],[3,1,3,12],[1,1,1,8],[2,1,2,8],[2,45,2,48],[2,41,2,44],[2,9,2,40],[11,13,11,45],[8,9,8,11],[9,9,9,11],[10,9,10,11],[9,3,9,8],[8,3,8,8],[26,13,26,45],[21,13,21,45],[27,13,28,45],[41,44,41,48],[39,10,39,19],[68,28,68,48],[46,44,46,48],[3,41,3,44],[19,13,19,45],[7,13,7,45],[6,1,6,48],[5,41,5,48],[7,1,7,6],[13,13,13,15],[13,16,13,19],[8,13,8,45],[9,13,9,45],[16,1,16,45],[14,1,14,45],[13,3,13,7],[15,13,15,45],[17,13,17,45],[18,13,18,45],[19,1,19,12]]}
[null,null,null,null,null,null,null,null,null,"UNIVERSITY of VIRGINIA"]
[null,null,null,null,null,null,null,null,null,"CERTIFICATE",null,null,null,null,null,null,null,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":"IF(J2=\"APPLICATION FOR CERTIFICATE\",\"HECO-13.3a\",\"HECO-13.3\")","v":"HECO-13.3"}]
[null,"(Rev. 12/19/13)",null,null,null,null,null,null,null,"OF USE AND OCCUPANCY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Issued:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(J2=\"TEMPORARY CERTIFICATE\",\"Expires:\",\"\")","v":""}]
[]
[null,"PROJECT:",null,null,null,null,null,null,null,{"$f":"IF(J10>0,(J9 & \" - \" & J10 & \" - \" & J11),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"Code",null,null,null,"Description"]
[null,null,null,"Agency:",null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=207,\"University of Virginia\",IF(J9=209,\"University of Virginia Medical Center\",IF(J9=246,\"University of Virginia's College at Wise\",IF(J9=948,\"Southwest Virginia Higher Education Center\",\"*****   Please enter an Agency Code   *****\"))))","v":"*****   Please enter an Agency Code   *****"}]
[null,null,null,"Project:"]
[null,null,null,"Sub-Project:"]
[null,null,null,"FIPS Code / Location:"]
[]
[null,null,null,"PIMS #:",null,null,null,null,null,null,null,null,null,"WO #:"]
[]
[null,"BUILDING:"]
[]
[null,"Purpose/Occupancy:"]
[null,"Occupant Load:"]
[null,"Occupancy Remarks:"]
[null,"Building Code Edition:"]
[null,"Accessibility Standards:"]
[null,"Use Group(s):"]
[null,"Type of Construction:"]
[null,"Building Height (feet):"]
[null,"Number of Stories:"]
[null,"Gross Area (gsf):"]
[null,"Code Modifications Issued:"]
[null,"( Sections modified )"]
[]
[null,"Floor Live Load (psf):"]
[]
[null,"Roof Live Load (psf):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil Bearing Capacity (psf):"]
[]
[null,"Wind Design Criteria:",null,null,null,null,null,null,null,null,null,null,null,"Wind Speed (mph):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Building Occupany Category:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Wind Exposure Category:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seismic Design Criteria:"]
[]
[]
[null,"Fire Suppression",null,null,null,null,null,null,null,null,"Elevators",null,null,null,null,null,null,null,null,null,null,"Fire Alarm System",null,null,null,null,null,null,null,null,{"$f":"IF(J2=\"APPLICATION FOR CERTIFICATE\",\"Attachments ( Enter Date & Submit Copy )\",\"Certifications & Reports\")","v":"Certifications & Reports"}]
[]
[null,null,null,"Wet",null,null,null,null,null,null,null,null,"New",null,null,null,null,null,null,null,null,null,null,"Automatic",null,null,null,null,null,null,"Architect/Engineer's Certificate:"]
[null,null,null,"Dry",null,null,null,null,null,null,null,null,"Existing",null,null,null,null,null,null,null,null,null,null,"Manual",null,null,null,null,null,null,"Contractor's Certificate:"]
[null,null,null,"Chemical",null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"+S42+S43","v":0},null,null,null,null,"None",null,null,null,null,null,null,"Fire Marshal's Inspection Rpt:"]
[null,null,null,"Other",null,null,null,null,null,null,"Other Conveyors",null,null,null,null,null,null,null,null,null,null,null,null,"Not Required",null,null,null,null,null,null,"Checklist for Occupancy:"]
[null,null,null,"None",null,null,null,null,null,null,null,null,"New",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Struct & Special Inspections Rpt:"]
[null,null,null,"Not Required",null,null,null,null,null,null,null,null,"Existing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elevator Inspection Report:"]
[null,null,null,"SPRINKLER HEAD DATABASE UPDATED:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potable Water Report:"]
[null,"SPECIAL CONDITIONS / STIPULATIONS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Original to:",null,null,null,null,null,"Geospatial Engineering Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Mgr"]
[null,"Copies to:",null,null,null,null,null,"Support Staff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proj Mgr Phone:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FAX:"]
[null,null,null,null,null,null,null,"Project Manager",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proj Mgr E-mail:"]
[null,null,null,null,null,null,null,"Regional Fire Marshal Office -"]
[null,null,null,null,null,null,null,"Office of Risk management"]
[null,null,null,null,null,null,null,"Scott Martin, Computer Systems Sr Engineer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By :"]
[null,null,null,null,null,null,null,"Nina Green, Systems Control Center Mgr"]
[null,null,null,null,null,null,null,"FM Directors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"University Building Official                    Date"]

{"sheet":"AttachmentA","index":3,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,9,2,10],[3,9,3,10],[3,0,3,1],[2,3,2,7]]}
[]
[]
[null,null,null,{"$f":"Page1!J1","v":"UNIVERSITY of VIRGINIA"},null,null,null,null,null,{"$f":"Page1!AP2","v":"HECO-13.3"}]
[{"$f":"Page1!D14","v":"PIMS #:"},null,{"$f":"Page1!I14","v":0},null,null,null,null,null,null,"Attachment \"A\""]

{"sheet":"Use Groups","index":4,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"\"USE GROUP\" REFERENCE LIST"]
[]
[null,"  Enter all applicable use groups ( the codes only ) in the Use Group field on \"Page 1\"."]
[]
[null,null,"Code","Description"]
[null,null,"A-1","Assembly, theaters"]
[null,null,"A-2","Assembly, nightclubs, restaurants, bars, banquet halls"]
[null,null,"A-3","Assembly, general - community halls, libraries, museums"]
[null,null,"A-4","Assembly, churches"]
[null,null,"B","Business"]
[null,null,"E","Educational"]
[null,null,"F-1","Factory and industrial, moderate hazard"]
[null,null,"F-2","Factory and industrial, low hazard"]
[null,null,"H","High hazard"]
[null,null,"I-1","Institutional, supervised environment"]
[null,null,"I-2","Institutional, incapacitated"]
[null,null,"I-3","Institutional, restrained"]
[null,null,"M","Mercantile"]
[null,null,"R-1","Residential, hotels"]
[null,null,"R-2","Residential, multiple family"]
[null,null,"R-3","Residential, one- and two-family"]
[null,null,"S-1","Storage, moderate hazard"]
[null,null,"S-2","Storage, low hazard"]
[null,null,"U","Utility, Miscellaneous"]

{"sheet":"Codes","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["FIPS","CONSTRUCTION_TYPE"]
["003 - Albemarle Co.","Noncombustible, Protected, Type IA"]
["540 - Charlottesville, City Of","Noncombustible, Protected, Type IB"]
["043 - Clarke Co.","Noncombustible, Protected, Type IIA"]
["131 - Northampton Co.","Noncombustible, Unprotected, Type IIB"]
["195 - Wise Co.","Noncombustible/Combustible, Protected, Type IIIA"]
["999 - Unknown Or Multiple Locations","Noncombustible/Combustible, Unprotected, Type IIIB"]
[null,"Noncombustible/Combustible, Heavy Timber, Type IV"]
[null,"Combustible, Protected, Type VA"]
[null,"Combustible, Unprotected, Type VB"]
[null,"N/A"]