Spreadsheet: 820540d1678155211-help-with-dependent-drop-down-lists-draft-work-book-risk-category
Sheet: Lookups

 |  |  |  | Critcal Risk |  |  |  |  |  | Top Event |  |  |  | Consequence
 |  |  |  | Where Found |  |  |  |  |  | Where Found |  |  |  | Where Found
 |  |  |  | Num Rows |  |  |  |  |  | Num Rows |  |  |  | Num Rows
Critical Risk |  |  |  | Critical Risk | Top Event | Sum of Top Event Fraction |  |  |  | Top Event | Consequence | Sum of Consequence Fraction |  | Consequence | Mitigation | Sum of Mitigration Fraction
Act of Nature |  |  |  | Act of Nature |  | 1 |  |  |  | Asbestos Exposure |  | 5 |  | Entrapment / Medical Issues |  | 1
Asset Failure |  |  |  |  | Lightning Strike | 1 |  |  |  |  | Business Reputation | 1 |  |  | Other emergency responses including [NAME] and FENZ | 0.25
Breach of Security |  |  |  | Asset Failure |  | 3 |  |  |  |  | Impact to  Operations | 1 |  |  | ICR Procedures | 0.25
Chronic & Acute Impact on Health |  |  |  |  | Building Light Fittings - Overheating | 0.9999999999999999 |  |  |  |  | Long-term Health Effects | 1 |  |  | AES Response | 0.25
High Risk Work |  |  |  |  | Elevator - Power Failure causing Elevator to stop | 1 |  |  |  |  | Shutting Down of sites | 1 |  |  | Elevator Phones | 0.25
Uncontrolled Release of Energy |  |  |  |  | Escalator - Steps shatter leaving a hole | 1 |  |  |  |  | WorkSafe NZ Notices / Prosecutions | 1
Vehicles |  |  |  | Breach of Security |  | 2 |  |  |  | Authorised person with malice intent - misusing Airport Access |  | 7
 |  |  |  |  | Authorised person with malice intent - misusing Airport Access | 0.9999999999999998 |  |  |  |  | Bypassing Border Controls (Smuggling in or out) | 1
 |  |  |  |  | Bomb/IED - explosion | 0.9999999999999999 |  |  |  |  | Financial Loss | 1
 |  |  |  | Chronic & Acute Impact on Health |  | 3 |  |  |  |  | Illicit items into NZ (consequential community / biosecurity harm) | 1
 |  |  |  |  | Asbestos Exposure | 1 |  |  |  |  | Loss of Licence to Operate | 1
 |  |  |  |  | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal | 0.9999999999999999 |  |  |  |  | People Smuggline | 1
 |  |  |  |  | COVID-19 Exposure - Frontline Operations contracting from Public | 1 |  |  |  |  | Reputational Damage | 1
 |  |  |  | High Risk Work |  | 5 |  |  |  |  | Taonga being removed from NZ | 1
 |  |  |  |  | [NAME] Environment | 1 |  |  |  | Bomb/IED - explosion |  | 6
 |  |  |  |  | Dangerous Goods - loss of containment | 0.9999999999999999 |  |  |  |  | Asset Damage | 1
 |  |  |  |  | Gun - uncontrolled release | 1 |  |  |  |  | Death / Mass Casuality | 1
 |  |  |  |  | High Voltage Electricity Work - uncontrolled release of electricity | 1 |  |  |  |  | Loss of Certification | 1
 |  |  |  |  | Hot Works - Uncontrolled release of energy / heat | 0.9999999999999998 |  |  |  |  | NZ inc Impact | 1
 |  |  |  | Uncontrolled Release of Energy |  | 2 |  |  |  |  | Reputation | 1
 |  |  |  |  | Electricity Work - Electrocution | 1 |  |  |  |  | Revenue Loss | 1
 |  |  |  |  | Fire | 0.9999999999999999 |  |  |  | Building Light Fittings - Overheating |  | 7
 |  |  |  | Vehicles |  | 3 |  |  |  |  | Asset Failure (building etc) | 1
 |  |  |  |  | [NAME] (airside) Moving Vehicle airside Road v Pedestrian | 0.9999999999999998 |  |  |  |  | Business Continuity | 1
 |  |  |  |  | [NAME] (landside) | 0.9999999999999998 |  |  |  |  | Cost to AIAL | 1
 |  |  |  |  | Vehicle v Vehicle (airside) | 0.9999999999999999 |  |  |  |  | Equipment Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Fire caused by heat source | 1
 |  |  |  |  |  |  |  |  |  |  | Injuries | 1
 |  |  |  |  |  |  |  |  |  |  | Reputational Damage | 1
 |  |  |  |  |  |  |  |  |  | [NAME] Environment |  | 4
 |  |  |  |  |  |  |  |  |  |  | Damage to reputation | 1
 |  |  |  |  |  |  |  |  |  |  | Financial Impact, Liability, Fines | 1
 |  |  |  |  |  |  |  |  |  |  | Injury / Death | 1
 |  |  |  |  |  |  |  |  |  |  | Trauma to community, family | 1
 |  |  |  |  |  |  |  |  |  | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal |  | 6
 |  |  |  |  |  |  |  |  |  |  | Illness / Death | 1
 |  |  |  |  |  |  |  |  |  |  | Operational Requirements / Part 139 | 1
 |  |  |  |  |  |  |  |  |  |  | Personal Exposure | 1
 |  |  |  |  |  |  |  |  |  |  | Regional Exposure | 1
 |  |  |  |  |  |  |  |  |  |  | Reputational | 1
 |  |  |  |  |  |  |  |  |  |  | Slips, Trips and [NAME] | 1
 |  |  |  |  |  |  |  |  |  | COVID-19 Exposure - Frontline Operations contracting from Public |  | 8
 |  |  |  |  |  |  |  |  |  |  | Damage to Business Reputation | 1
 |  |  |  |  |  |  |  |  |  |  | Financial Loss | 1
 |  |  |  |  |  |  |  |  |  |  | Further spread to other staff | 1
 |  |  |  |  |  |  |  |  |  |  | Loss of IP | 1
 |  |  |  |  |  |  |  |  |  |  | Operation Closure | 1
 |  |  |  |  |  |  |  |  |  |  | Regulatory non-compliance | 1
 |  |  |  |  |  |  |  |  |  |  | Severe Illness / Death | 1
 |  |  |  |  |  |  |  |  |  |  | Trauma to family and friends | 1
 |  |  |  |  |  |  |  |  |  | Dangerous Goods - loss of containment |  | 10
 |  |  |  |  |  |  |  |  |  |  | Aircraft operational delay / traffic disruption | 1
 |  |  |  |  |  |  |  |  |  |  | Breach of Resource Consent (CMA, [NAME], Rehab costs) | 1
 |  |  |  |  |  |  |  |  |  |  | Environmental Damage (water, land, air, radiation, wildlife) | 1
 |  |  |  |  |  |  |  |  |  |  | Fatality, Injury (burns, first aid) | 1
 |  |  |  |  |  |  |  |  |  |  | Fines, Loss of Income | 1
 |  |  |  |  |  |  |  |  |  |  | Fire and Explosion | 1
 |  |  |  |  |  |  |  |  |  |  | Health Consequences (impairment, loss of senses) | 1
 |  |  |  |  |  |  |  |  |  |  | Property Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Reputational Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Works / Process paused due to chemical loss | 1
 |  |  |  |  |  |  |  |  |  | Electricity Work - Electrocution |  | 8
 |  |  |  |  |  |  |  |  |  |  | Business Continuity | 1
 |  |  |  |  |  |  |  |  |  |  | Cost to AIAL | 1
 |  |  |  |  |  |  |  |  |  |  | Death, Injury, Serious Harm | 1
 |  |  |  |  |  |  |  |  |  |  | Explosion (Damage to property) | 1
 |  |  |  |  |  |  |  |  |  |  | Explosion (fire) | 1
 |  |  |  |  |  |  |  |  |  |  | Prosecution & Fines | 1
 |  |  |  |  |  |  |  |  |  |  | Reputation (media, confidence, political) | 1
 |  |  |  |  |  |  |  |  |  |  | Service Interruption | 1
 |  |  |  |  |  |  |  |  |  | Elevator - Power Failure causing Elevator to stop |  | 1
 |  |  |  |  |  |  |  |  |  |  | Entrapment / Medical Issues | 1
 |  |  |  |  |  |  |  |  |  | Escalator - Steps shatter leaving a hole |  | 3
 |  |  |  |  |  |  |  |  |  |  | Breakdown of Equipment | 1
 |  |  |  |  |  |  |  |  |  |  | Injury, Serious Injury | 1
 |  |  |  |  |  |  |  |  |  |  | Regulatory Compliance | 1
 |  |  |  |  |  |  |  |  |  | Fire |  | 6
 |  |  |  |  |  |  |  |  |  |  | Building/Infrastructure Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Financial Loss | 1
 |  |  |  |  |  |  |  |  |  |  | Injury / Death | 1
 |  |  |  |  |  |  |  |  |  |  | Interruption to Airport Operations | 1
 |  |  |  |  |  |  |  |  |  |  | Legal Issues | 1
 |  |  |  |  |  |  |  |  |  |  | Reputational Damage | 1
 |  |  |  |  |  |  |  |  |  | Gun - uncontrolled release |  | 3
 |  |  |  |  |  |  |  |  |  |  | Death and Injury (Single / Multiple) | 1
 |  |  |  |  |  |  |  |  |  |  | Equipment / Environment Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Safety observation | 1
 |  |  |  |  |  |  |  |  |  | High Voltage Electricity Work - uncontrolled release of electricity |  | 9
 |  |  |  |  |  |  |  |  |  |  | Business Interruption | 1
 |  |  |  |  |  |  |  |  |  |  | Equipment Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Explosion, Fire | 1
 |  |  |  |  |  |  |  |  |  |  | Financial Loss | 1
 |  |  |  |  |  |  |  |  |  |  | Investigation by Regulatory Body (WorkSafe NZ) | 1
 |  |  |  |  |  |  |  |  |  |  | Reputation damage | 1
 |  |  |  |  |  |  |  |  |  |  | [NAME], Death | 1
 |  |  |  |  |  |  |  |  |  |  | Surge / Comms equipment damage | 1
 |  |  |  |  |  |  |  |  |  |  | Unnecessary tripping of adjacent circuits | 1
 |  |  |  |  |  |  |  |  |  | Hot Works - Uncontrolled release of energy / heat |  | 7
 |  |  |  |  |  |  |  |  |  |  | Damage to infrastructure | 1
 |  |  |  |  |  |  |  |  |  |  | Death, Serious Harm | 1
 |  |  |  |  |  |  |  |  |  |  | Financial Loss | 1
 |  |  |  |  |  |  |  |  |  |  | Fire | 1
 |  |  |  |  |  |  |  |  |  |  | Operational Disruption | 1
 |  |  |  |  |  |  |  |  |  |  | Reputation damage | 1
 |  |  |  |  |  |  |  |  |  |  | Smoke | 1
 |  |  |  |  |  |  |  |  |  | Lightning Strike |  | 8
 |  |  |  |  |  |  |  |  |  |  | Asset\Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Building  Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Cost to AIAL | 1
 |  |  |  |  |  |  |  |  |  |  | Dislodgement of Debris | 1
 |  |  |  |  |  |  |  |  |  |  | Essential Environment Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Fire caused by acts of nature | 1
 |  |  |  |  |  |  |  |  |  |  | Injury to persons / death | 1
 |  |  |  |  |  |  |  |  |  |  | Interruption to Service, Outage, Power Surge | 1
 |  |  |  |  |  |  |  |  |  | [NAME] (airside) Moving Vehicle airside Road v Pedestrian |  | 7
 |  |  |  |  |  |  |  |  |  |  | Damage to Business Reputation | 1
 |  |  |  |  |  |  |  |  |  |  | Disruption to Operations | 1
 |  |  |  |  |  |  |  |  |  |  | Financial Loss | 1
 |  |  |  |  |  |  |  |  |  |  | Injury / Death | 1
 |  |  |  |  |  |  |  |  |  |  | Loss of IP (because they are hurt??) | 1
 |  |  |  |  |  |  |  |  |  |  | Prosecution legal | 1
 |  |  |  |  |  |  |  |  |  |  | Trauma to family and friends | 1
 |  |  |  |  |  |  |  |  |  | [NAME] (landside) |  | 7
 |  |  |  |  |  |  |  |  |  |  | Business Continuity | 1
 |  |  |  |  |  |  |  |  |  |  | Damage to Business Reputation | 1
 |  |  |  |  |  |  |  |  |  |  | Financial Loss | 1
 |  |  |  |  |  |  |  |  |  |  | Injury / Death | 1
 |  |  |  |  |  |  |  |  |  |  | Loss of IP | 1
 |  |  |  |  |  |  |  |  |  |  | Prosecution legal | 1
 |  |  |  |  |  |  |  |  |  |  | Trauma to family and friends | 1
 |  |  |  |  |  |  |  |  |  | Vehicle v Vehicle (airside) |  | 6
 |  |  |  |  |  |  |  |  |  |  | Environmental Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Financial Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Loss of life or injury | 1
 |  |  |  |  |  |  |  |  |  |  | Reputational Damage | 1
 |  |  |  |  |  |  |  |  |  |  | Structural Property Damage | 1
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 1