Performing Pre-Disaster Mitigation Assessments Using UFIS and UFRAS

1. Performing Pre-Disaster Mitigation Assessments Using UFIS and UFRAS

2. Agenda • Inspection process • How UFIS and UFRAS help • How to use UFIS • Exercise • How to use UFRAS • Exercise

3. Inspection Process • Assemble list of candidate critical facilities • Input facilities and scoring criteria in UFIS • Ranked list of facilities for inspection • Perform site visit/inspection • Building walk around / walk through • UFRAS scoring • Written report detailing findings and recommendations

4. UFIS vs. UFRAS • UFIS – University Facilities Importance Spreadsheet • Intended to rank facilities according to relative importance • Extremely simple formulas • 8 inputs per facility • Helps build consensus among stakeholders • UFRAS – University Facilities Risk Assessment Spreadsheet • Intended to rank facilities according to relative risk • Extremely intricate formulas • ~ 250 inputs per facility • Demonstrates to funding agency that mitigation dollars are being allocated effectively

5. UFIS • User’s Guide • Table 1-1 – Occupancy – ASCE 7 • Facility List • Weights • Data Entry Form • Results • Note: Macros MUST be enabled!

6. Choosing Occupancy • Most buildings are Occupancy II • Offices, warehouses • Anything not a III or IV • Occupancy III • Classroom or residence halls that hold more than 500 people • Occupancy IV • Police, fire, 911 call center, critical telecom

7. Facility List • Enter the list of facilities to be ranked in the appropriate red-shaded column • Can cut and paste into this sheet • NCCHEF # can be any number, not required for analysis • Enter the following facilities and NCCHEF # • Sycamore Dorm #1 • Atkins Library #2 • Duke Centennial Hall #3 • Public Safety Building #4 • Cameron Hall #5

8. Weights • Weights allow the user to give greater significance to one or more ranking criteria • Higher value for weight means a greater significance • Example – you are more concerned about the value of the facility’s contents than its historic value • No restriction on the value other than it must be greater than 0 • Recommended weight = 1.0 for all factors

9. Data Entry Form • Will automatically populate from the Facility List sheet • Under each Facility Factor, assign a ranking using the weights shown in the column heading • A higher weight means the facility is more important with respect to the factor • Name of user – handy if multiple people are filling out UFIS together • Comments – useful for explaining very high/low ratings

10. Factors • Occupancy – Get from Table 1-1 • Emergency Function – Is it critical in your emergency plan? • Facility Loss – High insured value of structure? • Facility Contents – High insured value of contents? • Business Continuity – is it critical to COOP? • Interconnectivity – do multiple facilities rely on this facility? • Data/Animal – is there a vivarium or high value research? • Historical/Cultural – is there historic/cultural value?

11. Example Building Properties • Sycamore – 600 beds, 15 stories, shelter in place facility, largest dorm on campus • Atkins Library – 12 stories, highest insured value on contents and structure, primary data center/fiber point of delivery • Duke Centennial – Mech. Engr. Research and classroom building, one of a kind equipment, occupancy of 300 people • Public Safety Building – Small one story structure housing police dept, 911 call center, armory • Cameron Hall – Civil engineering dept, office building, occupancy of 250 people

12. Results • Step 1 – Press “Get Data” • Step 2 – Press “Sort Results” • Sorted importance scorings presented • If you want to make changes to your scoring and then re-rank, press “Clear Results” button

13. Ranking Results • Did the UFIS generated ranking match your own prioritization?

14. Questions/Contact Brian Zapata 6302 Fairview Road, Suite 600 Charlotte, NC 28210 (704) 358-8240 - Phone (704) 358-8342 - Fax (888) 529-7243 bzapata@zapatainc.com http://www.zapatainc.com