State of Nebraska Hazard AnalysisApril 2009

INSTRUCTIONS:

I.Open the Hazard Profiles workbook in Excel. I have included both the latest version of Excel and an earlier version, use whichever will open for you. You will find tabs across the bottom of the workbook that includes:

A.Participants list you can print out and use as an attendance roster or just enter the information for the people who are helping to complete the assessment.

B.Summary sheet:

1.This sheet will automatically populate as numbers are entered into the Hazard Profile sheets.

a.You should not have to enter any data into this sheet unless you add a localized hazard on one of the two bottom rows

b.The other blanks contain formulas and are locked so you cannot put numbers directly into the cells without deleting the formulas.

2.The hazards listed on the sheet are the hazards identified in the State Emergency Operations Plan (SEOP). To simplify this process some of these have been combined. The SEOP lists, nuclear attack, conventional attack,sabotage, insurrection, cyber attack, bio/chemical attack and terrorism as a single hazard titled Terrorism.

3,There are two blank rows at the bottom of the Summary sheet. These blank rows are for you to add the hazard name and enter any localized hazards your county feels should be included in this analysis but are not on the list. The last two tabs are titled “Blank 1” and “Blank 2”. Use these tabs to develop the hazard profile for your localized hazards. Enter the name of the hazard on the top of the profile sheet but Do Not Change the Tab Name because thatname is the link in the formula to the summary sheet. The numbers entered on the profile on tab named “Blank 1” will populate the first blank row on the Summary sheet and numbers entered on the profile sheet on tab “Blank 2” will populate the second blank row on the Summary sheet.

C.Hazard Profile Sheets:

1.This is the worksheet used to profile each of the hazards. This worksheet was taken from the FEMA planning guide CPG-101 with a few modifications for Nebraska.

2.Each hazard is scored using the four factors listed below. For each factor there are sub-factors with points assigned to each sub-factor. Once your team has determined which of the sub-factors best describes the affect that factor has on your county, enter the assigned number in the white (or un-shaded) cell to the right of that sub-factor.

a.Potential Magnitude: or the percentage of the county that could be affected by the hazard. This is an indication of the geographical area that could be impacted by a hazard. Other factors will indicate who could be affected.

b.Frequency of Occurrence: or how often does/can this hazard affect the county.

c.Areas Likely to be Most Affected: This is the exception to the scoring instruction as you will select all that apply. For example if you have a river or stream which floods your county, you would select each of the sub-factors that are located within the flood zones for that river or stream. It could be agricultural only so you would only place a score in the un-shaded area to the right of the “Agricultural” sub-factor and it would look like this:

Areas Likely to be Affected Most / Sub-Score
Agricultural(4 points) / 4
Residential(12 points)
Business/Retail(8 points)
Industrial(12 points)
Factor Total / 4

If have a major highway where Chemical or Radiological shipments are transported and that highway goes through both Agricultural and Industrial areas but not through a residential or retail/business area, your sheet will look like this:

Areas Likely to be Affected Most / Sub-Score
Agricultural(4 points) / 4
Residential(12 points)
Business/Retail(8 points)
Industrial(12 points) / 12
Factor Total / 16

The Factor Total cell will automatically do the addition;you only need to enter numbers in white or un-shaded cells.

d.Potential Speed of Onset: or the time you have to warn the citizens of the hazard so they can take protective actions to protect themselves and possibly their property from the hazard.

II.Hazard definitions are for the most part self-explanatory. To ensure that all of the counties have the same understanding, below are definitions for a few of the hazards on the tool.

A.Power Failure: by any cause that lasts or is expected to last longer than eight (8) hours.

B.Terrorism: as was pointed out in the instructions this is a combination of several hazards listed in the SEO. It includes nuclear attack, conventional attack,sabotage, insurrection, cyber attack, and a bio/chemical attack. If your team determines that one of these hazards should be profiled on its own, please list it on one of the blank rows and complete the appropriate blank profile sheet.

C.Chemical and Radiological Transportation on either highway or rail..

D.Transportation: since we list chemical and radiological transportation as separate hazards, this hazard is for any rail and/or air transportation incident.

E.Radiological Fixed Sites: not for just Nuclear Power Plants but any fixed site with a radiological source where an incident could cause off-site consequences. Normally a medically licensed radiological source is not strong enough to cause off-site consequences. If you are not sure or don’t know if your county has such a source, you may contact Jon Schwarz, our Radiological Officer at 402-471-7420 or email at . If you have no sites in the county please check or X the box “Does Not Apply” on that Profile sheet.

III.RANKING

A.Once you have completed all of the profiles you should have a completed Summary sheet. If you wish you can sort the hazards highest to lowest by highlighting the “Total Score” column and using the sort icon (an A over a Z with an arrow to the right). Once you choose this you may get a dialogue box that asks if you wish to expand the sort, choose yes and your hazards should sort with the highest ranking on the top line. The ranking scores for the hazards are:

1.High – any hazard that ranks above 80 points

2.Medium – any hazard that ranks between 40 and 79

3.Low – any hazard that ranks 40 or lower

B.You can use these rankings as a tool to identify what scenarios you may need to focus on as you continue the planning process and can use the identified High ranking hazards as we proceed on to the Capability Assessment that we will roll out regionally this summer.

IV.Once you have completed the process, please send a copy of the entire Hazard Analysis including the Participants sheet, Summary sheet and all of the Profile sheets to Cindy Newsham by May 15th, either by emailing the completed workbook to , or by printing the entire workbook and mailing it to:

Cindy Newsham

1300 Military Road

Lincoln, NE 6850

Finally thank you for completing this tool. We at the State will compile the scores from all of the county hazard analysis to determine the High, Medium and Low hazards across the State and use that information to complete three processes.

First we will determine if there is a hazard scoring High that is not currently included in the State Hazard Mitigation Plan (SHMP) Risk Assessment Section and, if so, we will complete a detailed profile of that hazard to be included in an Annex to the SHMP and that information will be added to the Risk Assessment Section of the 2011 revision of the Plan.

Second we will do an Impact study on the High and perhaps some of the Medium hazards to determine who and how these hazards impact various areas like the public, responders, continuity of operations, property, infrastructure, environment, and economics. This Impact matrix will also become part of the SHMP annex and eventually the 2011 revision

Third we will use the information gathered from your assessments /regional response to that hazard. We will develop a matrix of resources needed for each hazard, identifying who within State governmenthas these resources and, if we find a resource not available in the necessary quantity, or at all, where we can acquire it when necessary.