{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Page1","AttachmentA","Instructions","Groups","Data","Codes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Page1","index":0,"n_rows":77,"n_cols":47,"rows_kept":77,"cut":false,"hidden":false,"merged":[[47,12,47,28],[41,12,42,28],[44,12,45,28],[42,43,42,47],[41,43,41,47],[44,43,44,47],[47,34,47,47],[43,43,43,47],[43,12,43,28],[46,12,46,28],[48,34,48,47],[49,34,49,47],[51,0,51,47],[52,0,52,47],[48,12,49,28],[69,0,69,47],[53,0,68,47],[70,7,70,20],[71,24,71,27],[71,30,72,43],[71,44,72,48],[71,7,71,18],[72,24,72,27],[76,28,76,48],[72,7,72,18],[72,19,72,21],[73,30,73,48],[74,30,75,43],[74,44,75,48],[35,12,35,13],[46,30,46,47],[39,12,39,28],[40,12,40,28],[19,0,19,11],[22,0,22,11],[23,0,23,11],[40,30,40,47],[39,36,39,47],[37,46,37,47],[37,12,37,15],[35,46,35,47],[36,46,36,47],[36,12,36,13],[22,12,23,47],[24,12,24,47],[14,12,14,47],[21,12,21,47],[10,12,10,47],[11,12,11,47],[12,8,12,10],[13,2,13,11],[12,12,12,47],[13,12,13,47],[19,12,19,47],[16,33,16,42],[10,2,10,7],[11,2,11,7],[10,8,10,10],[11,8,11,10],[14,2,14,11],[12,2,12,7],[7,0,7,7],[7,8,7,39],[9,0,9,5],[9,12,9,44],[7,40,7,47],[8,0,8,47],[9,8,9,10],[3,0,3,7],[4,0,4,7],[4,44,4,47],[4,40,4,43],[5,0,5,7],[5,8,5,39],[5,40,5,43],[5,44,5,47],[4,8,4,39],[3,8,3,38],[33,0,33,11],[30,0,30,11],[31,0,31,11],[26,0,26,11],[18,0,18,11],[27,0,27,11],[24,0,24,11],[32,0,32,11],[25,0,25,11],[16,3,16,7],[16,8,16,11],[16,13,16,15],[16,16,16,20],[16,22,16,32],[30,12,30,47],[26,12,26,47],[31,12,31,47],[32,12,33,47],[18,12,18,47],[25,12,25,47]]}
[]
[null,"Click on the \"Instructions\" tab below before using this form."]
[]
[null,null,null,null,null,null,null,null,"BUILDING PERMIT",null,null,null,null,null,null,null,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(I4=\"APPLICATION FOR BUILDING PERMIT\",\"HECO-17a-TWR\",\"HECO-17-TWR\")","v":"HECO-17-TWR"}]
["(Rev. 9/6/2018)",null,null,null,null,null,null,null,"FOR",null,null,null,null,null,null,null,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,"COMMUNICATIONS TOWER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expires:"]
[]
["PROJECT:",null,null,null,null,null,null,null,{"$f":"IF(I12>0,(I11 & \" - \" & I12 & \" - \" & I13),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,"Code",null,null,null,"Description"]
[null,null,"Agency:",null,null,null,null,null,null,null,null,null,{"$f":"IF(I11=207,\"University of Virginia\",IF(I11=209,\"University of Virginia Medical Center\",IF(I11=246,\"University of Virginia's College at Wise\",IF(I11=948,\"Southwest Virginia Higher Education Center\",\"*****   Please enter an Agency Code   *****\"))))","v":"*****   Please enter an Agency Code   *****"}]
[null,null,"Project:"]
[null,null,"Sub-Project:",null,null,null,null,null,0]
[null,null,"FIPS Code / Location:"]
[null,null,"Street Address:"]
[]
[null,null,null,"PIMS #:",null,null,null,null,null,null,null,null,null,"WO #:",null,null,null,null,null,null,null,null,"Indicate type of Project:"]
[]
["TOWER OWNER:"]
["TOWER NAME / ID:"]
[]
["Tower Project Type:"]
["Tower Owner's Address:"]
[]
["FAACS Number:"]
["Building Code Edition:",null,null,null,null,null,null,null,null,null,null,null,"VUSBC 2015 Edition"]
["Group:",null,null,null,null,null,null,null,null,null,null,null,"U"]
["Tower Type:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pole"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Truss, Engineered"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Truss, Factory Engineered and Fabricated"]
["Tower Material:"]
["Height Above Grade (feet):"]
["Code Modifications Issued:"]
["( Sections modified )"]
[]
["Wind Speed (mph):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site Class:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Wind Exposure Category:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seismic Design Category:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Soil Bearing Capacity (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,null,"Quality Assurance Plan Required ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[]
["Foundation Designer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Insp:"]
[null,null,null,null,null,null,null,null,null,null,"License Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key Dates"]
[null,null,null,null,null,null,null,null,null,null,"Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foundation Design Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Superstructure Design Date:"]
["Superstructure Designer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AARB Approval Date:"]
[null,null,null,null,null,null,null,null,null,null,"Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Est'd Construct'n Completion:"]
[]
["Contractor:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency Contact"]
[null,null,null,null,null,null,null,null,null,null,"License Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:"]
[null,null,null,null,null,null,null,null,null,null,"Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E-mail:"]
[]
["BUILDING OFFICIAL ACTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Original to:",null,null,null,null,null,"FP&C Admin (Kim Breeden)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approved:"]
[null,"Copies to:",null,null,null,null,null,"Project Manager"]
[null,null,null,null,null,null,null,"Regional Fire Marshal Office -"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  University Building Official                       Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As Required:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Director Of Health System Physical Plant        Date"]

{"sheet":"AttachmentA","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,1,7,6],[8,1,8,6],[12,6,12,7],[3,9,3,10],[3,0,3,3],[4,0,4,3],[4,9,4,10],[3,4,3,8],[4,4,4,8]]}
[]
[null,"Click on the \"Instructions\" tab below before using this form."]
[]
[{"$f":"Page1!A4","v":0},null,null,null,null,null,null,null,null,{"$f":"Page1!AO4","v":"HECO-17-TWR"}]
[{"$f":"Page1!A5","v":"(Rev. 9/6/2018)"},null,null,null,null,null,null,null,null,"Attachment \"A\""]
[]
[null,"Select appropriate date from drop down boxes in boxes below."]
[null,"Date of University Building Official Inspection"]
[null,"Date of Authorized Use & Occupancy"]
[null,"All work has been completed in accordance with the contract documents."]
[]
[]
[]
[null,null,"Project Manager",null,null,null,"Date"]
[]
[]
["Description:"]

{"sheet":"Instructions","index":2,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,8,19,10],[21,8,21,10]]}
[]
[null,"DATA ENTRY INSTRUCTIONS"]
[]
[null,"- Print these instructions for your reference."]
[]
[null,"- Click on the \"Page 1\" tab to go to the Permit Application (or Certificate Application) form."]
[]
[null,"- Data fields available for data entry by agencies are highlighted in yellow."]
[]
[null,"- Data fields reserved for Building Official use are highlighted in light blue."]
[]
[null,"- Use the tab key to move forward to the next fillable field.",null,null,null,null,null,null,"|----->"]
[]
[null,"- Use the shift-tab combination to move backwards to the previous fillable field.",null,null,null,null,null,null,"<-----|"]
[]
[null,"- Some fields have \"drop-down\" selection arrows on the right side of the field.  For these"]
[null,"  types of fields, click on the arrow, then select the appropriate choice from the list."]
[" ","  (Note:  The \"drop-down\" arrow does not appear until the cell is selected.)"]
[]
[null,"- When Permit (or Certificate) Application is complete, save the file and e-mail it to:",null,null,null,null,null,null,"Buildingpermitrequest@virginia.edu"]
[]
[null,"- If you have questions or comments related to the use of this form e-mail them to:",null,null,null,null,null,null,"Buildingpermitrequest@virginia.edu"]

{"sheet":"Groups","index":3,"n_rows":88,"n_cols":5,"rows_kept":88,"cut":false,"hidden":true,"merged":[]}
[]
[null,"\"GROUP\" REFERENCE LIST"]
[]
[null,"  Enter all applicable Groups ( the codes only ) in the Group field on \"Page 1\"."]
[]
[null,"  Refer to the Building Code for a more complete description and examples of these classifications."]
[]
[null,null,"Code","Description"]
[null,null,"A-1","Assembly uses, usually with fixed seating, intended for the production and viewing of"]
[null,null,null,null,"performing arts or motion pictures."]
[]
[null,null,"A-2","Assembly uses intended for food and/or drink consumption."]
[]
[null,null,"A-3","Assembly uses intended for worship, recreation or amusement and other assembly uses"]
[null,null,null,null,"not classified elsewhere in Group A."]
[]
[null,null,"A-4","Assembly uses intended for viewing of indoor sporting events and activities with"]
[null,null,null,null,"spectator seating."]
[]
[null,null,"A-5","Assembly uses intended for participation in or viewing outdoor activities."]
[]
[null,null,"B","Business Group B occupancy includes, among others, the use of a building or structure"]
[null,null,null,null,"or a portion thereof, for office, professional or service-type transactions,"]
[null,null,null,null,"including storage of records and accounts."]
[]
[null,null,"E","Educational Group E occupancy includes, among others, the use of a building or structure,"]
[null,null,null,null,"or a portion thereof, by six or more persons at any one time for educational"]
[null,null,null,null,"purposes through the 12th grade."]
[]
[null,null,"F-1","Factory industrial, moderate hazard."]
[]
[null,null,"F-2","Factory industrial, low hazard."]
[]
[null,null,"H-1","High hazard. Buildings and structures containing materials that pose a detonation hazard."]
[]
[null,null,"H-2","High hazard. Building and structures containing materials that present a deflagration "]
[null,null,null,null,"hazard or hazard from accelerated burning."]
[]
[null,null,"H-3","High hazard. Buildings and structures containing materials that readily support combustion"]
[null,null,null,null,"or present a physical hazard."]
[]
[null,null,"H-4","High hazard. Buildings and structures that contain materials that are health hazards."]
[]
[null,null,"H-5","High hazard. Semiconductor fabrication facilities and comparable research and development"]
[null,null,null,null,"areas in which hazardous production materials (HPM) are used and the aggregate"]
[null,null,null,null,"quantity of materials is in excess of those listed the tables referenced in the Code."]
[]
[null,null,"I-1","Institutional. This occupancy shall include a building or portion thereof housing more than 16"]
[null,null,null,null,"persons, on a 24-hour basis, who because of age, mental disability or other reasons,"]
[null,null,null,null,"live in a supervised residential environment that provides personal care services.  The"]
[null,null,null,null,"occupants are capable of responding to an emergency situation without physical"]
[null,null,null,null,"assistance from the staff."]
[]
[null,null,"I-2","Institutional. This occupancy shall include buildings and structures used for medical, surgical,"]
[null,null,null,null,"psychiatric, nursing or custodial care on a 24-hour basis of more than 5 persons who"]
[null,null,null,null,"are not capable of self-preservation."]
[]
[null,null,"I-3","Institutional. This occupancy shall include buildings and structures that are inhabited by more than"]
[null,null,null,null,"5 persons who are under restraint or security."]
[]
[null,null,"I-4","Institutional. This occupancy shall include buildings and structures occupied by persons of any age"]
[null,null,null,null,"who receive custodial care for less than 24 hours by individuals other than parents or"]
[null,null,null,null,"guardians, relatives by blood, marriage, or adoption, and in a place other than the home of"]
[null,null,null,null,"the person cared for."]
[]
[null,null,"M","Mercantile.  This occupancy includes, among others, buildings and structures or a portion thereof,"]
[null,null,null,null,"for the display and sale of merchandise, and involves stocks of goods, wares or merchandise"]
[null,null,null,null,"incidental to such purposes and accessible to the public."]
[]
[null,null,"R-1","Residential, hotels, motels, boarding houses (transient)."]
[]
[null,null,"R-2","Residential, multiple family (e.g., apartment houses, non-transient boarding houses, convents,"]
[null,null,null,null,"dormitories, fraternities, sororities, monasteries."]
[]
[null,null,"R-3","Residential, one- and two-family dwelling units, adult and childcare facilities for five or fewer"]
[null,null,null,null,"persons of any age for less than 24 hours."]
[]
[null,null,"R-4","Buildings arranged for occupancy as Residential Care/Assisted Living Facilities including more"]
[null,null,null,null,"than 5 but not more than 16 occupants, excluding staff."]
[]
[null,null,"R-5","Detached one and two-family dwellings and multiple single-family dwellings (townhouses) not more"]
[null,null,null,null,"than three stories high with separate means of egress and their accessory structures."]
[]
[null,null,"S-1","Storage, moderate hazard.  Buildings occupied for storage uses which are not classified as Group S-2."]
[]
[null,null,"S-2","Storage, low hazard.  Buildings used for the storage of noncombustible materials."]
[]
[null,null,"U","Utility and Miscellaneous."]

{"sheet":"Data","index":4,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["BUILDING TYPE","TOWER"]
["FORM TYPE","PERMIT"]
[]
["PROJECT"]
["Agency Code",{"$f":"TEXT(Page1!I11,\"000\")","v":"000"}]
["Project Num",{"$f":"TEXT(Page1!I12,\"00000\")","v":"00000"}]
["Subproject Num",{"$f":"TEXT(Page1!I13,\"000\")","v":"000"}]
["Subproject Title",{"$f":"UPPER(Page1!M13)","v":""}]
["Contractor",{"$f":"UPPER(Page1!M47)","v":""}]
["Contractor License Number",{"$f":"UPPER(Page1!M48)","v":""}]
[]
["BUILDING INFO"]
["Building FIPS",{"$f":"LEFT(Page1!M14,3)","v":""}]
["Tower Name/ID",{"$f":"UPPER(Page1!M20)","v":""}]
["Tower Owner",{"$f":"UPPER(Page1!M19)","v":""}]
["Tower Owner's Address",{"$f":"UPPER(Page1!M23)","v":""}]
["Code Edition",{"$f":"UPPER(Page1!M26)","v":"VUSBC 2015 EDITION"}]
["Use Group",{"$f":"UPPER(Page1!M27)","v":"U"}]
["Tower Type - Pole",{"$f":"IF(Page1!M28=\"\",\"N\",\"X\")","v":"N"}]
["Tower Type - Truss, Engineered",{"$f":"IF(Page1!M29=\"\",\"N\",\"X\")","v":"N"}]
["Tower Type - Truss, Fabricated",{"$f":"IF(Page1!M30=\"\",\"N\",\"X\")","v":"N"}]
["Tower Material",{"$f":"UPPER(Page1!M31)","v":""}]
["Height Above Grade",{"$f":"UPPER(Page1!M32)","v":""}]
["Code Modifications",{"$f":"UPPER(Page1!M33)","v":""}]
["Wind Speed",{"$f":"UPPER(Page1!M36)","v":""}]
["Wind Exposure Category",{"$f":"UPPER(Page1!M37)","v":""}]
["Seismic - Av"]
["Seismic - Aa"]
["Seismic - S"]
["Seismic Design Category",{"$f":"UPPER(Page1!AU37)","v":"N/A"}]
["Site Class",{"$f":"UPPER(Page1!AU36)","v":"N/A"}]
["Soil Bearing Capacity",{"$f":"UPPER(Page1!M38)","v":""}]
["Tower Project Type - New",{"$f":"IF(Page1!M22=\"New Tower\",\"X\",\"\")","v":""}]
["Tower Project Type - Addition",{"$f":"IF(Page1!M22=\"Addition to Existing Tower\",\"X\",\"\")","v":""}]
["Tower Project Type - Added Eq.",{"$f":"IF(Page1!M22=\"Added Equipment\",\"X\",\"\")","v":""}]
["Foundation Designer",{"$f":"UPPER(Page1!M40)","v":""}]
["Foundation Address",{"$f":"UPPER(Page1!M42)","v":""}]
["Superstucture Designer",{"$f":"UPPER(Page1!M44)","v":""}]
["Superstucture Address",{"$f":"UPPER(Page1!M45)","v":""}]
["Foundation Design Date",{"$f":"IF(Page1!AR42=0,\"\",Page1!AR42)","v":""}]
["Superstructure Design Date",{"$f":"IF(Page1!AR43=0,\"\",Page1!AR43)","v":""}]
["AARB Approval Date",{"$f":"IF(Page1!AR44=0,\"\",Page1!AR44)","v":""}]
["Est'd Constr Cmpltn Date",{"$f":"IF(Page1!AR45=0,\"\",Page1!AR45)","v":""}]
[]
["PERMIT INFO"]
["Issue Date",{"$f":"IF(Page1!AS5=0,\"\",Page1!AS5)","v":""}]
["Expiration Date",{"$f":"IF(Page1!AS6=0,\"\",Page1!AS6)","v":""}]

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