ufras university facilities risk assessment spreadsheet 25 april 2012
DESCRIPTION
UFRAS University Facilities Risk Assessment Spreadsheet 25 April 2012. Agenda. Outline UFRAS Develop a brief understanding of how to use UFRAS Develop an understanding of what to do with output from UFRAS Go through each sheet of UFRAS Explain input/results - PowerPoint PPT PresentationTRANSCRIPT
UFRASUniversity Facilities Risk Assessment
Spreadsheet25 April 2012
www.zapatainc.com
Agenda• Outline UFRAS
o Develop a brief understanding of how to use UFRAS
o Develop an understanding of what to do with output from UFRAS
• Go through each sheet of UFRASo Explain input/resultso Instruct users’ on how to input datao Present a synopsis of the function of each sheet
www.zapatainc.com
UFRAS• Objectively and consistently
quantifies a risk index for facilities via a matrix
www.zapatainc.com
UFRAS• Facilitates quick and efficient
comparison of risk across facilities• Conducts a hazard assessment and
vulnerability assessment• Output highlights areas of weakness• Reinforces the suggestion for mitigation
measures
www.zapatainc.com
Hazard Assessment• Evaluates the probability and intensity of
the 9 potential hazards that could affect a campus
• Data comes from reputable sourceso ASCE 7-05o NOAAo County flood maps
• Inputs are normalized relative to hazard intensities across the continental United States
• Inputs are largely static for each campuso Reference data unlikely to change; thus
campuses should not need to adjust these inputs for future use
www.zapatainc.com
Hazard Assessment
www.zapatainc.com
Vulnerability Assessment• Conducted via site visits, discussion with
facility personnel, review of drawings/documents
• Inspection checklist is completed while conducting inspection
• 1-5 hours to complete, depending on size/complexity of facility
• Facility conditions change over time, thus the need to reevaluate facilities periodically
www.zapatainc.com
Inspection Checklist• Divided into 5 sections—based on facility
components; it is the first 5 sheets in UFRAS• 92 total questions/statements • 910 permutations to produce final matrix• Inspector assigns ratings (usually 1-4) for
each question/statement which are input for risk calculation
• Unanswered questions/statements are omitted from risk index calculation
www.zapatainc.com
Results
• 1 represents lowest risk• 10 represents highest risk• Matrix is normalized by campus
www.zapatainc.com
Results
www.zapatainc.com
Analysis• Based on output from UFRAS:
o Highlights areas of weakness in facility components relative to hazards
o Mitigation measures can be tailored for the weaker areas in the facility
• Once mitigation measures are suggestedo Inspection checklist may be modified to reflect
lower vulnerability−Second matrix is concurrently produced projecting
new lower risk
www.zapatainc.com
Overview of UFRAS sheets• 11 Total sheets
o 5 sheets make up the inspection checklisto 1 sheet makes up the hazard assessmento 1 sheet concisely summarizes input datao 1 sheet allows users to modify ratings to reflect
proposed mitigation measureso 1 sheet produces normalized outputo 2 sheets produce raw output
www.zapatainc.com
Sheet 1: Site/General Checklist
• 31 questions/statements pertaining to:o General facility design parameterso Site geographyo Vegetationo Site improvements
−Streets/roads−Fencing−Drainage infrastructure
o Utilities on siteo Storage tankso Secondary/support structures
www.zapatainc.com
Sheet 2: Envelope Checklist
• 19 Questions/statements pertaining to:o Windows and doors
−Flashing−Closing mechanisms−Material
o Veneer−Attachment, configuration, material
o Foundation plane/lowest level floor planeo Building geometryo Roof system
−Coping−Drainage
www.zapatainc.com
Sheet 3: Structure Checklist
• 15 Questions/statements pertaining to:o Geometry of structure (plan and elevation)o Design loadso Structural system
−Redundancies−Hybrid−Design era
o Connectionso Foundationo Construction type/materials
www.zapatainc.com
Sheet 4: Utilities Checklist• 14 Questions/statements pertaining to:
o All utility systems within the facility−Telecommunications−Power−Gas−Water (potable, wastewater, roof drain lines)−Fire safety systems−Computing systems−Building controls−Security systems
www.zapatainc.com
Sheet 5: Contents Checklist
• 13 Questions/statements pertaining to:o Occupantso Corridors, stairwells, exit routeso Furnitureo Interior (non-structural) partition walls, flooring,
doors, windowso Specialized equipmento Light fixtureso Elevators
www.zapatainc.com
Sheet 6: PI Input Values
www.zapatainc.com
Sheet 7: Final Output• Presents normalized risk index matrices
o First set presents normalized relative to facility−As Inspected (AI) Matrix−Mitigation Measures (MM) Matrix—calculates new
risk index with updated inputs that assume suggested mitigation measures are implemented
o Second set presents normalized relative to campus
−AI Matrix−MM Matrix
o Third set presents normalized relative to sample space
−AI Matrix−MM Matrix
www.zapatainc.com
Sheet 8: Summary of EV Inputs
• Lists all 92 questions/statements with respective ratings in one place for ease of referenceo 4 page printouto For review only; no modifications can/need to be
made
www.zapatainc.com
Sheet 9: Insert Updated EV Values
• Identical layout to Sheet 8o Modify ratings in this sheet to reflect the lower
vulnerability based on suggested mitigation measures
o Anytime a rating is modified, an (*) appears to the right of the updated rating
o This input is used to produce the “MM” matrix
www.zapatainc.com
Sheet 10: Output Printout (AI)
• Displays the raw output from the input ratingso Contents of this sheet have minimal applicable
useo Summarizes the hazard informationo Presents an exposure and vulnerability matrixo Presents a raw risk index matrix
−Range 0-1 where 0 is lowest risk; 1 is highest risko All of which is used to produce normalized risk
index matrices• Error message at the bottom of sheet is only
item needed from this sheeto Error count tallies the number of times a rating
outside range limits is input in sheets 1-5
www.zapatainc.com
Sheet 11: Output Printout (MM)
• Identical in layout and function to Sheet 10o Uses data from Sheet 9 (Updated EV Inputs) to
produce a risk index matrix reflecting lower risk (assuming mitigation measures are implemented)
o This data is used to produce the “MM” set of matrices
• Error message at the bottom of sheet is only item needed from this sheeto Error count tallies the number of times a rating
outside range limits is input in Sheet 9
www.zapatainc.com
IMPORTANT – Sheet 11:Output Printout (AI)
• Cell F54 controls campus normalization o Set this cell equal to the maximum value within
the cell range B43:S47−Can be done with a master spreadsheet that links
to other facilities on campus• Cell F55 controls sample space
normalizationo Set this cell equal to the maximum value within
the sample space of raw risk index matrices−If the sample space is the campus, use the same
value that was used in F54
www.zapatainc.com
Results• Output can be combined with UFIS results
o Composite of objective importance and risk scores
• Output can be combined with any measure of facility value/importanceo Facilitates a better understanding of the results
−Incorporates a loss measure−Combines risk and importance into one result
• Must use raw risk scoreso Raw risk scores present the most accurate resulto Normalized risk scores do not have enough
resolution to provide clear delineation of results
www.zapatainc.com
Exercise• Facility “A” has a raw risk score of 0.020
o Insured value of $4.8 milliono UFIS score of 0.680
• Facility “B” has a raw risk score of 0.045o Insured value of $3.5 milliono UFIS score of 0.580
• Which facility should take priority in receiving mitigation measures?
www.zapatainc.com
Exercise• Facility “A”
o 0.020 x $4.8 million = $0.096 million (Insured value)o 0.020 x 0.680 = .0136
(UFIS results)
• Facility “B”o 0.045 x $3.5 million = $0.158 million (Insured value)o 0.045 x 0.580 = 0.0261
(UFIS results)
• Facility “B” takes priority for mitigation measures based on composite score
www.zapatainc.com
Questions/ContactBrian Zapata6302 Fairview Road, Suite 600Charlotte, NC 28210(704) 358-8240 - Phone(704) 358-8342 - Fax(888) [email protected]://www.zapatainc.com