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

Critical Risk | Top Event | Consequence | Uncontrolled Risk Rating | Controlled Risk Ranking | Mitigation | Heirarchy | Control2 | Heirarchy2 | Control3 | Heirarchy4 | Control4 | Heirarchy6 | Control5 | Heirarchy8 | Control6 | Heirarchy82 | Control7 | Heirarchy3 | Control8 | Heirarchy33 | Control9 | Heirarchy35 | Control10 | Heirarchy37 | Control11 | Heirarchy39 | Control12 | Top Event Fraction | Consequence Fraction | Mitigration Fraction
Vehicles | [NAME] (airside) Moving Vehicle airside Road v Pedestrian | Injury / Death |  |  | [NAME] D.D.C |  | First Aid kits in car |  | Training (first aid) |  | User reporting |  | Emergency Services response
Vehicles | [NAME] (airside) Moving Vehicle airside Road v Pedestrian | Prosecution legal |  |  | CCTV Footage |  | Scene Investigation |  | Legal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/COUNTIFS([Critical Risk],[@[Critical Risk]],[Top Event],[@[Top Event]],[Consequence],[@Consequence]],,[Risk Rating],[@Risk Rating])
Vehicles | [NAME] (airside) Moving Vehicle airside Road v Pedestrian | Disruption to Operations |  |  | Traffic Management by AOT, AP12/32, ASO |  | Traffic Contigency plans |  | NOGGIN |  | AEP/EOC
Vehicles | [NAME] (airside) Moving Vehicle airside Road v Pedestrian | Damage to Business Reputation |  |  | Crisis Management Team |  | Comms Team (media)
Vehicles | [NAME] (airside) Moving Vehicle airside Road v Pedestrian | Financial Loss |  |  | Insurance
Vehicles | [NAME] (airside) Moving Vehicle airside Road v Pedestrian | Loss of IP (because they are hurt??) |  |  | Setting up backups / support |  | Knowledge Capturing
Vehicles | [NAME] (airside) Moving Vehicle airside Road v Pedestrian | Trauma to family and friends |  |  | OCP
Vehicles | Vehicle v Vehicle (airside) | Loss of life or injury | High | High | Airside Driving Rules |  | Defensive [NAME] |  | Airbag |  | Seatbelt |  | Emergency Services Response |  | Vehicle Maintenance
Vehicles | Vehicle v Vehicle (airside) | Structural Property Damage | High | High | Airside Driving Rules |  | Design Standards |  | Emergency Service Response |  | ES Personnel |  | Fire Protection System |  | Bollards and Barriers
Vehicles | Vehicle v Vehicle (airside) | [NAME] | High | High | Emergency Response |  | Additional Vehicle Accessories |  | Design Standards |  | Airside Driving Rules
Vehicles | Vehicle v Vehicle (airside) | Financial Damage | High | High | Exclusion Damage |  | Insurance
Vehicles | Vehicle v Vehicle (airside) | Environmental Damage | High | High | Emergency Response |  | Storm Water Ponds |  | AIMS |  | Design |  | [NAME]
Vehicles | Vehicle v Vehicle (airside) | Reputational Damage | High | High | Comms Team |  | Crisis Management Team
Vehicles | [NAME] (landside) | Injury / Death |  |  | Driving Training D.D.C |  | First Aid Kits in car |  | Emergency Services Response
Vehicles | [NAME] (landside) | Prosecution legal |  |  | CCTV Footage |  | [NAME] |  | Lawyer
Vehicles | [NAME] (landside) | Business Continuity |  |  | Roading Contingency |  | ATOC / TMS |  | AEP / EOC
Vehicles | [NAME] (landside) | Damage to Business Reputation |  |  | Crisis Management Team |  | Comms Team
Vehicles | [NAME] (landside) | Financial loss |  |  | Insurance
Vehicles | [NAME] (landside) | Loss of IP |  |  | Setting up redundancies |  | Knowledge Capturing
Vehicles | [NAME] (landside) | Trauma to family and friends |  |  | OCP
High Risk Work | [NAME] Environment | Injury / Death |  |  | Advise Airport Operations |  | Evacuation carried out by spotter |  | Rescue Training |  | Block off area |  | Notify AES for large spills (>2m2) |  | Natural ventilation
High Risk Work | [NAME] Environment | Damage to reputation |  |  | Legal team regulations |  | Follow up gas levels in the area |  | Contaminant Extraction |  | Notify Council if spill into stormwater ponds |  | Environmental and sustainabiity team
High Risk Work | [NAME] Environment | Financial Impact, Liability, Fines |  |  | Legal team regulations |  | Follow up gas levels in the area |  | Contaminant Extraction |  | Notify Council if spill into stormwater ponds |  | Environmental and sustainabiity team
High Risk Work | [NAME] Environment | Trauma to community, family |  |  | Counselling EAP, team support
High Risk Work | Gun - uncontrolled release | Death and Injury (Single / Multiple) | High | Medium | AES AMB EOC AEP Police Moass Casuality Plan |  | [NAME] Gunshot Patch Tourneq kits |  | Lone worker checks |  | [NAME]
High Risk Work | Gun - uncontrolled release | Equipment / Environment Damage | High | Medium
High Risk Work | Gun - uncontrolled release | Safety observation | High | Medium | Logs |  | Risk Manager entries
High Risk Work | Dangerous Goods - loss of containment | Property Damage |  |  | [NAME] |  | Fire Suppression and Protection
High Risk Work | Dangerous Goods - loss of containment | Environmental Damage (water, land, air, radiation, wildlife) |  |  | [NAME] |  | Specialist advise to mitigate |  | Emergency Stop Valves | Engineering | Containment Ponds
High Risk Work | Dangerous Goods - loss of containment | Reputational Damage |  |  | [NAME] |  | Legal and Comms
High Risk Work | Dangerous Goods - loss of containment | Fatality, Injury (burns, first aid) |  |  | [NAME]
High Risk Work | Dangerous Goods - loss of containment | Works / Process paused due to chemical loss |  |  | [NAME] |  | Contigency Planning |  | Accredited Supplier
High Risk Work | Dangerous Goods - loss of containment | Aircraft operational delay / traffic disruption |  |  | [NAME] |  | Contigency Planning
High Risk Work | Dangerous Goods - loss of containment | Fire and Explosion |  |  | [NAME] |  | Specific Fire engineering system
High Risk Work | Dangerous Goods - loss of containment | Breach of Resource Consent (CMA, [NAME], Rehab costs) |  |  | Engage specalistist for mitigations
High Risk Work | Dangerous Goods - loss of containment | Health Consequences (impairment, loss of senses) |  |  | [NAME] |  | Eye Wash Facilities |  | First Aid Kits
High Risk Work | Dangerous Goods - loss of containment | Fines, Loss of Income |  |  | [NAME] |  | Insurance and Legal
High Risk Work | Hot Works - Uncontrolled release of energy / heat | Fire |  |  | Emergency Management |  | Safety Watch |  | AES |  | Hand-held fire equipment |  | Sprinkler System |  | Fire Detection
High Risk Work | Hot Works - Uncontrolled release of energy / heat | Smoke | High | High | Ventilation |  | Extraction System
High Risk Work | Hot Works - Uncontrolled release of energy / heat | Damage to infrastructure | High | High | Emergency Management |  | Ventilation |  | Fire System Isolation |  | Extraction System
High Risk Work | Hot Works - Uncontrolled release of energy / heat | Operational Disruption | High | High | Communication between Departments |  | EOC Coordination
High Risk Work | Hot Works - Uncontrolled release of energy / heat | Reputation damage | High | High | Legal Team |  | Comms Team
High Risk Work | Hot Works - Uncontrolled release of energy / heat | Financial Loss | High | High | Sprinkler System |  | Insurance
High Risk Work | Hot Works - Uncontrolled release of energy / heat | Death, Serious Harm | High | High | HSW Awareness / Induction |  | Safety Watch / Training |  | AES
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | Explosion, Fire |  |  | PPE |  | Lone Worker Procedure |  | Smoke Detectors |  | Fire Stopping
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | [NAME], Death |  |  | PPE |  | Yellow, Black exclusion zone |  | Explosion Vent
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | Business Interruption |  |  | Backup generators |  | Security of Supply
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | Equipment Damage |  |  | Remove oil from circuit breaker |  | New technology equipment |  | architectural detection
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | Reputation damage
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | Financial Loss
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | Surge / Comms equipment damage |  |  | Discrimination |  | Surge Protection
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | Unnecessary tripping of adjacent circuits |  |  | Discrimination |  | Protection Scheme
High Risk Work | High Voltage Electricity Work - uncontrolled release of electricity | Investigation by Regulatory Body (WorkSafe NZ) |  |  | SMS for Electricity |  | Paperwork and process in place
Asset Failure | Escalator - Steps shatter leaving a hole | Injury, Serious Injury |  |  | Cordon off Broken Escalator
Asset Failure | Escalator - Steps shatter leaving a hole | Injury, Serious Injury |  |  | AES Medical Response
Asset Failure | Escalator - Steps shatter leaving a hole | Injury, Serious Injury |  |  | ICR Response
Asset Failure | Escalator - Steps shatter leaving a hole | Injury, Serious Injury |  |  | [NAME]
Asset Failure | Escalator - Steps shatter leaving a hole | Breakdown of Equipment |  |  | Cordon off Broken Escalator
Asset Failure | Escalator - Steps shatter leaving a hole | Breakdown of Equipment |  |  | [NAME]
Asset Failure | Escalator - Steps shatter leaving a hole | Regulatory Compliance |  |  | [NAME]
Asset Failure | Elevator - Power Failure causing Elevator to stop | Entrapment / Medical Issues |  |  | Other emergency responses including [NAME] and FENZ |  | Schindler Tech Response
Asset Failure | Elevator - Power Failure causing Elevator to stop | Entrapment / Medical Issues |  |  | ICR Procedures
Asset Failure | Elevator - Power Failure causing Elevator to stop | Entrapment / Medical Issues |  |  | AES Response
Asset Failure | Elevator - Power Failure causing Elevator to stop | Entrapment / Medical Issues |  |  | Elevator Phones
Asset Failure | Building Light Fittings - Overheating | Fire caused by heat source |  |  | Manual Call Points
Asset Failure | Building Light Fittings - Overheating | Fire caused by heat source |  |  | Site Famil
Asset Failure | Building Light Fittings - Overheating | Fire caused by heat source |  |  | Training (AES Evac)
Asset Failure | Building Light Fittings - Overheating | Fire caused by heat source |  |  | Emergency Response Plan
Asset Failure | Building Light Fittings - Overheating | Fire caused by heat source |  |  | Fire detection & protection
Asset Failure | Building Light Fittings - Overheating | Equipment Damage |  |  | AES
Asset Failure | Building Light Fittings - Overheating | Asset Failure (building etc) |  |  | Periodic review of AMP
Asset Failure | Building Light Fittings - Overheating | Asset Failure (building etc) |  |  | Back up equipment
Asset Failure | Building Light Fittings - Overheating | Asset Failure (building etc) |  |  | AES
Asset Failure | Building Light Fittings - Overheating | Injuries |  |  | Up to date EVAC procedures
Asset Failure | Building Light Fittings - Overheating | Injuries |  |  | Training
Asset Failure | Building Light Fittings - Overheating | Reputational Damage |  |  | Post Incident Review
Asset Failure | Building Light Fittings - Overheating | Reputational Damage |  |  | Media, Comms Team
Asset Failure | Building Light Fittings - Overheating | Business Continuity |  |  | Legal Team
Asset Failure | Building Light Fittings - Overheating | Cost to AIAL |  |  | Insurance
Uncontrolled Release of Energy | Electricity Work - Electrocution | Death, Injury, Serious Harm |  |  |  | FFB Electrical Rated PPE and Equipment |  | AES |  | Correct PPE |  | ACC, Rehab |  | Protection (electrical) |  |  | Location & Training for defibs |  | Location & Training for defibs |  | Location & Training for defibs |  | Location & Training for defibs |  | Location & Training for defibs |  | Location & Training for defibs
Uncontrolled Release of Energy | Electricity Work - Electrocution | Explosion (Damage to property) |  |  |  | FFB Electrical Rated PPE and Equipment |  | [NAME]
Uncontrolled Release of Energy | Electricity Work - Electrocution | Explosion (fire) |  |  |  | Emergency Plans |  | AES |  | Correct PPE |  | Escape Route |  | Fire Detection
Uncontrolled Release of Energy | Electricity Work - Electrocution | Service Interruption |  |  |  | Emergency Plans |  | Protection Coordination
Uncontrolled Release of Energy | Electricity Work - Electrocution | Business Continuity |  |  |  | Emergency Plans |  | Post Incident Investigation |  | Response Action Plan
Uncontrolled Release of Energy | Electricity Work - Electrocution | Reputation (media, confidence, political) |  |  |  | Legal |  | Media |  | Comms
Uncontrolled Release of Energy | Electricity Work - Electrocution | Prosecution & Fines |  |  |  | Post Incident Investigations |  | Legal |  | Media |  | Ensure processes (SMS etc) are updated
Uncontrolled Release of Energy | Electricity Work - Electrocution | Cost to AIAL |  |  |  | Insurance
Uncontrolled Release of Energy | Fire | Building/Infrastructure Damage
Uncontrolled Release of Energy | Fire | Injury / Death |  |  | EOC |  | AEP |  | AES Medical Response
Uncontrolled Release of Energy | Fire | Interruption to Airport Operations |  |  | Cleaners |  | EOC |  | CMT
Uncontrolled Release of Energy | Fire | Reputational Damage
Uncontrolled Release of Energy | Fire | Legal Issues |  |  | Insurance
Uncontrolled Release of Energy | Fire | Financial Loss |  |  | Insurance
Breach of Security | Bomb/IED - explosion | Death / Mass Casuality |  |  | [NAME] |  | AEP |  | Exercises |  | Lockdown Procedures |  | Emergency Services |  | Evacuation Processes
Breach of Security | Bomb/IED - explosion | Asset Damage |  |  | Roading / Bollard / Barrier / Design |  | Safety in Design and Upgrades ([NAME] work) |  | Capital Infrastructure Security Design Reviews |  | Knowledge of Isolation Points |  | Building System Protection |  | Excercises
Breach of Security | Bomb/IED - explosion | Revenue Loss |  |  | BCP |  | Crisis Management Team |  | Exercises |  | Insc. |  | Legal |  | Comms
Breach of Security | Bomb/IED - explosion | Reputation |  |  | BCP |  | Crisis Management Team |  | Exercises |  | Insc. |  | Legal |  | Comms
Breach of Security | Bomb/IED - explosion | Loss of Certification |  |  | BCP |  | Crisis Management Team |  | Exercises |  | Insc. |  | Legal |  | Comms
Breach of Security | Bomb/IED - explosion | NZ inc Impact |  |  | BCP |  | Crisis Management Team |  | Exercises |  | Insc. |  | Legal |  | Comms
Breach of Security | Authorised person with malice intent - misusing Airport Access | Bypassing Border Controls (Smuggling in or out) |  |  | [NAME]
Breach of Security | Authorised person with malice intent - misusing Airport Access | People Smuggline |  |  | [NAME] |  | Customs Emigration control
Breach of Security | Authorised person with malice intent - misusing Airport Access | Illicit items into NZ (consequential community / biosecurity harm) |  |  | [NAME]
Breach of Security | Authorised person with malice intent - misusing Airport Access | Taonga being removed from NZ |  |  | [NAME]
Breach of Security | Authorised person with malice intent - misusing Airport Access | Loss of Licence to Operate |  |  | Security Awareness of Staff and Reporting |  | SOP Documentation |  | Inspections and Audits |  | Legal
Breach of Security | Authorised person with malice intent - misusing Airport Access | Reputational Damage |  |  | Comms |  | Legal
Breach of Security | Authorised person with malice intent - misusing Airport Access | Financial Loss |  |  | Legal
Chronic & Acute Impact on Health | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal | Personal Exposure |  |  | [NAME] to Release |  | Cleaning |  | Chemical Training |  | Haz / Bio disposal |  | SOPs |  | Containment
Chronic & Acute Impact on Health | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal | Slips, Trips and [NAME] |  |  | [NAME] to Release |  | Cleaning |  | Chemical Training |  | Haz / Bio disposal |  | SOPs |  | Containment
Chronic & Acute Impact on Health | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal | Illness / Death |  |  | [NAME] to Release |  | Cleaning |  | Chemical Training |  | Haz / Bio disposal |  | SOPs |  | Containment
Chronic & Acute Impact on Health | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal | Regional Exposure |  |  | [NAME] to Release |  | Cleaning |  | Chemical Training |  | Haz / Bio disposal |  | SOPs |  | Containment
Chronic & Acute Impact on Health | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal | Reputational |  |  | [NAME] to Release |  | Cleaning |  | Chemical Training |  | Haz / Bio disposal |  | SOPs |  | Containment
Chronic & Acute Impact on Health | [NAME]  - uncontrolled release of virus / bacteria / pathogen from a person or animal | Operational Requirements / Part 139 |  |  | [NAME] to Release |  | Cleaning |  | Chemical Training |  | Haz / Bio disposal |  | SOPs |  | Containment
Chronic & Acute Impact on Health | COVID-19 Exposure - Frontline Operations contracting from Public | Severe Illness / Death |  |  | Medical Treatment |  | Isolation |  | Regular 14 days testing |  | MoH guidelines
Chronic & Acute Impact on Health | COVID-19 Exposure - Frontline Operations contracting from Public | Loss of IP |  |  | Training of generalists |  | Isolation |  | Knowledge capturing |  | Remote Working |  | Regular 14 days testing
Chronic & Acute Impact on Health | COVID-19 Exposure - Frontline Operations contracting from Public | Trauma to family and friends |  |  | OCP / Victim Support |  | [NAME] |  | Vulnerable Workers Register |  | MoH guidelines
Chronic & Acute Impact on Health | COVID-19 Exposure - Frontline Operations contracting from Public | Regulatory non-compliance |  |  | Testing & Case Management Policy |  | HSW Policy |  | Govt Relations / Lawyer |  | Vulnerable Workers Register |  | MoH Guidelines
Chronic & Acute Impact on Health | COVID-19 Exposure - Frontline Operations contracting from Public | Financial Loss |  |  | Re-evaluate Priorities |  | Banking / Financial Support |  | Budget Cuts |  | Redundancies
Chronic & Acute Impact on Health | COVID-19 Exposure - Frontline Operations contracting from Public | Damage to Business Reputation |  |  | Cleaning requirements |  | Regular 14 day testing |  | Crisis Management Team |  | Comms Team - media |  | Vulnerable Workers Register |  | MoH Guidelines
Chronic & Acute Impact on Health | COVID-19 Exposure - Frontline Operations contracting from Public | Further spread to other staff |  |  | Isolation |  | Regular 14 day testing |  | [NAME] |  | Vulnerable Workers Register |  | MoH Guidelines
Chronic & Acute Impact on Health | COVID-19 Exposure - Frontline Operations contracting from Public | Operation Closure |  |  | Business Continuity Planning
Chronic & Acute Impact on Health | Asbestos Exposure | Long-term Health Effects |  |  | Decontamination Process |  | Emergency Reponse |  | PPE |  | Health Monitoring
Chronic & Acute Impact on Health | Asbestos Exposure | Shutting Down of sites |  |  | Air Monitoring |  | Cordon off area and signage |  | Evacuation |  | WorkSafe NZ notification |  | AIAL approved specialised asbestos contractors
Chronic & Acute Impact on Health | Asbestos Exposure | Impact to  Operations |  |  | Airport Operations Management |  | Asbestos Management Plan |  | Communications Plan |  | SMS 05 Event Reporting Procedure |  | AIAL approved specialised asbestos contractors
Chronic & Acute Impact on Health | Asbestos Exposure | WorkSafe NZ Notices / Prosecutions |  |  | Legal Team
Chronic & Acute Impact on Health | Asbestos Exposure | Business Reputation |  |  | Comms Team
Act of Nature | Lightning Strike | Fire caused by acts of nature |  |  | Static Earth Bonding |  | ICR |  | Fire Evacuation |  | AES |  | Fire Detection and Suppression
Act of Nature | Lightning Strike | Building  Damage |  |  | Inspection after lightning |  | Counterpoised system on AGL |  | Lightning Protection design and installation |  | Contigency runway |  | Lightning Protection System (Rods, Tapes)
Act of Nature | Lightning Strike | Asset\Damage |  |  | AES and ICR |  | Aircraft Design
Act of Nature | Lightning Strike | Interruption to Service, Outage, Power Surge |  |  | Appropriate Spares |  | Mobile / backup generators |  | Limit exposed equipment on roof |  | Systems resilience |  | Underground services |  | Appropriate surge protection and design
Act of Nature | Lightning Strike | Dislodgement of Debris |  |  | Emergency Procedures |  | Access Restrictions |  | Building Design
Act of Nature | Lightning Strike | Injury to persons / death |  |  | Emergency Procedures |  | Access Restrictions |  | Warning Comms
Act of Nature | Lightning Strike | Essential Environment Damage |  |  | Spare Equipment |  | Surge Protection |  | Correct Earthing
Act of Nature | Lightning Strike | Cost to AIAL |  |  | Insurance