Hazard Vulnerability Matrix Worksheet

Toolkit IS-559 / G-556

11

Hazard Vulnerability Assessment Spreadsheet– Completed Example Location/Facility: Manatee County Date Completed: 01/05/11 Completed by: EM This table has been adapted from a Microsoft Excel spreadsheet for inclusion in this Toolkit as an example of a system your community could implement. Scoring instructions are included after the table.

Type of Hazard Historical Occurrence

Prob. of Occurrence

Human Impact

Property Impact

Business Impact

Mitigation Activities

Internal Resources

External Resources

Total

Civil Disturbance* 1 1 1 1 1 3 3 3 0.3 Communications Failure

3 2 3 1 3 3 3 4 2.0

Coastal Oil Spill* 1 1 1 2 2 2 1 3 1.1 Computer Crime/Virus/ Software Failure

1 1 1 3 3 3 3 3 1.2

Drought* 1 1 2 3 3 3 2 3 1.6 Epidemic 1 2 3 3 3 3 3 4 2.0 Fire: Brush & Forest*

2 2 2 3 2 4 4 4 1.6

Fire: Structural 1 1 3 3 3 4 4 4 1.3 Flooding: Short Duration *

4 4 3 2 2 3 3 3 3.2

Flooding: Freshwater*

4 4 2 2 3 3 3 3 3.2

Flooding: Drainage*

3 3 2 2 2 4 3 3 2.2

Flooding: Coastal Tidal*

1 2 4 4 4 4 3 4 2.6

Freeze* 1 1 1 2 2 2 2 3 1.0 Gas Leak 1 1 2 2 2 3 3 3 1.0 Hazardous Material Spills: *

0.0

a. Roadways * 2 3 1 2 1 3 2 4 1.7 b. Air* 1 1 3 1 3 3 2 4 1.2 d. Pipeline* 1 1 2 1 2 3 3 4 0.7 e. Rail Systems* 1 1 2 1 1 2 3 4 0.6

Toolkit IS-559 / G-556

12

Type of Hazard Historical Occurrence

Prob. of Occurrence

Human Impact

Property Impact

Business Impact

Mitigation Activities

Internal Resources

External Resources

Total

Hurricanes* 1 2 4 4 4 3 3 3 2.8 Lightning 4 4 3 1 1 3 3 4 2.7 Mass Immigration* 1 1 2 1 1 3 4 4 0.3 Military Conflict 1 1 1 1 1 1 3 5 0.3 Plane/Train/Auto Crash

2 2 2 2 2 3 3 5 1.4

Power Failure 2 2 2 1 2 4 3 5 1.1 Severe Weather/Storms *

3 3 2 2 2 3 3 4 2.2

Sinkholes/ Subsidence*

1 1 1 1 1 1 1 1 1.0

Terrorism 1 1 3 2 2 4 3 5 0.9 Theft/Vandalism 2 2 3 3 3 4 4 4 2.0 Thunderstorm 3 3 1 1 1 3 3 4 1.6 Tornado* 2 2 3 3 2 4 4 4 1.8 Tropical Storm * 2 3 3 3 3 3 4 4 2.6 Water Pipe Break 3 3 2 2 2 3 3 3 2.3 Weapons of Mass Destruction: Chemical/ Biological/Nuclear

1 2 4 3 3 4 3 5 2.0

Wildfires 2 2 3 3 2 4 4 4 1.8 Workplace Violence

1 1 2 1 2 3 3 3 0.8

Work Stoppage 1 1 2 1 3 1 1 1 1.7 Analysis Results: High Risk: Greater than 3.5 Medium Risk: 2.0 to 3.5 Low Risk: Less than 2 * Hazards of Concern as per HVA

Adapted from Manatee County Florida’s Hazard Vulnerability Analysis