{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Step 1 and 2","Step 3 to 6","Steps 10 - 11  Pop Conseq","Steps 12 - 13 Env Conseq","Step 14 Max Conseq","Step 16  ERC","Step 17 RTF","Step 19 Vulnerability","Step 20 Risk "],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Guide for Assessing Community Emergency Response Needs and Capabilities for Hazardous Materials Releases:  Worksheets"]
[]
[null,"This file is designed to follow the 20 steps outlined in the “Guide for Assessing Community Emergency Response Needs and Capabilities for Hazardous Materials Releases. \""]
[null," "]
[null,"Separate tabs have been developed for the major steps and cell equations perform most of the calculations.  "]
[null,"Steps 1 and 2 help the assessor determine the current Tier level of their Emergency Response organization.  The Tier level is aligned with the FEMA resource types.  "]
[null,"Steps 3 though 6 assist the assessor in selecting the proper Jurisdictional Class.  The Jurisdictional Class as used here and adaption of the DHS Jurisdictional Class definitions.   The Jurisdictional Class selected determines a minimum Tier level response and if the current Tier Level capability is lower than required, this is the first gap identified in this assessment.  The assumption is made that this gap would be addressed before proceeding with the balance of the assessment.  It should be noted that while the balance of the assessment could be completed with a lower-than-needed Tier level, many more gaps will be identified.   "]
[null,"Steps 7 through 9 are focused on capturing the hazardous materials present in the jurisdiction for which response may be necessary; these are used to complete the table entries for Step 10 and those following."]
[null,"For tabs beginning with Step 10, and continuing to Step 20, the focus is to evaluate the risk equation, as defined in Section I.D, for each accident scenario being assessed in the local or regional planning area.  In the example there are 4 facility accident scenarios and 15 transport accident scenarios.   They have been linked so that if the scenario is changed in Step 10, all the other tabs are automatically updated.  "]
[]
[null,"The cells where information needs to be inserted are shaded in light blue.  Once all the entries have been made for each step, the worksheet will automatically evaluate the risk equation."]
[]
[null,"In order to use these worksheets most effectively, the user  should  save the example under a different name , open the newly named file and adjust the scenarios so they are applicable to the local area or region.  "]
[null,"If more scenarios are required, they can be inserted by right clicking on a row number (the number that begins each row), moving the cursor down to “insert” and then clicking again.  The cell formulas from the row above blank row must then be cut and pasted into the new row.  This process needs to be continued for each tab that contains a scenario, always making sure all the cell formulas are copied down into the new row. "]
[null,"For worksheets beginning with 'Steps 10 - 12 Pop Conseq', extra scenario lines with the formulas included have been included after the last facility scenario and last route scenario.  A user could either change the scenarios shown or add additional scenarios by inserting additional lines and copying the lines with the formula to the newly inserted lines.  It is suggested that the user keep this file as a master, save it to a new file name and then modify the new file.  "]
[]
[null,"For worksheets beginning with 'Steps 10 - 12 Pop Conseq', those cells shaded in light blue must be entered by the user, "]
[null,"all others will either be copied from previous sheets or calculated when the information is entered into the shaded cells"]

{"sheet":"Step 1 and 2","index":1,"n_rows":121,"n_cols":9,"rows_kept":121,"cut":false,"hidden":false,"merged":[[109,0,109,7],[81,0,81,7],[21,0,21,7],[26,0,26,7],[34,0,34,7],[38,0,38,7],[43,0,43,7],[50,0,50,7],[53,0,53,7],[58,0,58,7],[64,0,64,7],[71,0,71,7],[75,0,75,7],[103,0,103,7],[104,0,104,7],[87,0,87,7],[100,0,100,7],[101,0,101,7],[102,0,102,7],[108,0,108,7],[1,1,6,7],[8,1,13,7],[105,0,105,7],[106,0,106,7],[107,0,107,7],[19,7,20,7],[20,0,20,1],[19,0,19,1],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[110,0,110,7],[118,0,118,7],[119,0,119,7],[120,0,120,7],[111,0,111,7],[112,0,112,7],[113,0,113,7],[114,0,114,7],[115,0,115,7],[116,0,116,7],[117,0,117,7]]}
[]
[null,"The purpose of this tab is to determine the Capability Tier level  for your local or regional  emergency response organization.  The assessment is made by answering the applicable questions for each Resource Type Capability as either Y or N and then looking at the bottom of he table to see the capability level where all the requirements have been met.  The data entries are shaded in light blue.  To meet the baseline requirements,  27 yes answers should appear in the proper  rows.  You can see the rows by looking at the entries with 1 under the Base column."]
[]
[]
[]
[]
[]
[]
[null,"There are some entries like Decontamination and Sustainability where the \"Y\" entry is made for the row that most describes your capability.  Thus, if you are currently capable of decontaminating 500 patients per hour, it follows that you can satisfy the requirements to decontaminate 100 patients per hour.  Thus, there is no need to put a \"Y\" entry for the 100 and 250 patient per hour rows; they will be automatically satisfied when you place a \"Y\" under 500 patients per hour.  Note that if you fill out the form inconsistently, saying \"N\" to 100 patients per hour and \"Y\" to 500 patients per hour, the \"N\" overrides the \"Y\" and you get an incorrect total."]
[]
[]
[]
[]
[]
[]
[]
[null,"You have to fill out the Tier Level on row 85 that best meets your current capability.  "]
[null,"Capability1 Tier","Capability Level","Base",1,2,3,4]
[null,"FEMA Resource Type (Equivalent)",null,"N/A","N/A","III","II","I"]
["Highest Team Certification2",null,"Y/N","Ops","Ops/ Tech","Tech","Tech","Tech"]
["(Operations or Technician)",null,"Assessor Determined"]
["Field Testing3"]
[null,"Presumptive Identification – Chemical","Y",null,{"$f":"+IF($C23=\"Y\",1,0)","v":1},1,1,1]
[null,"Presumptive Identification – Radiological","Y",null,1,1,1,1]
[null,"Presumptive Identification – Biological","N",null,null,null,0,0]
[null,"Presumptive Identification – Spec. Chemicals6","N",null,null,null,null,{"$f":"+IF($C26=\"Y\",1,0)","v":0}]
["Air Monitoring3"]
[null,"Atmospheric Monitoring – Oxygen","Y",{"$f":"+IF($C28=\"Y\",1,0)","v":1},{"$f":"+IF($C28=\"Y\",1,0)","v":1},1,1,1]
[null,"Atmospheric Monitoring – Explosive Gas","Y",{"$f":"+IF($C29=\"Y\",1,0)","v":1},1,1,1,1]
[null,"Atmospheric Monitoring – CO ","Y",{"$f":"+IF($C30=\"Y\",1,0)","v":1},1,1,1,1]
[null,"Atmospheric Monitoring – H2S","Y",{"$f":"+IF($C31=\"Y\",1,0)","v":1},1,1,1,1]
[null,"Atmospheric Monitoring – Flammable Diff. 7","Y",null,null,1,1,1]
[null,"Atmospheric Monitoring – Identify TIC8","N",null,null,null,0,0]
[null,"Atmospheric Monitoring – Identify Conc.9","N",null,null,null,null,{"$f":"+IF($C34=\"Y\",1,0)","v":0}]
["Sampling3"]
[null,"Sampling – Solid","Y",null,{"$f":"+IF($C36=\"Y\",1,0)","v":1},{"$f":"+IF($C36=\"Y\",1,0)","v":1},{"$f":"+IF($C36=\"Y\",1,0)","v":1},{"$f":"+IF($C36=\"Y\",1,0)","v":1}]
[null,"Sampling – Liquid","N",null,null,"O",{"$f":"+IF($C37=\"Y\",1,0)","v":0},{"$f":"+IF($C37=\"Y\",1,0)","v":0}]
[null,"Sampling – Air/Vapor","N",null,null,"O","O",{"$f":"+IF($C38=\"Y\",1,0)","v":0}]
["Radiation Monitoring3"]
[null,"Survey – Gamma","Y",null,{"$f":"+IF($C40=\"Y\",1,0)","v":1},{"$f":"+IF($C40=\"Y\",1,0)","v":1},{"$f":"+IF($C40=\"Y\",1,0)","v":1},{"$f":"+IF($C40=\"Y\",1,0)","v":1}]
[null,"Survey – Gamma + Beta","N",null,null,null,{"$f":"+IF($C41=\"Y\",1,0)","v":0},{"$f":"+IF($C41=\"Y\",1,0)","v":0}]
[null,"Survey – Gamma, Beta, & Alpha","N",null,null,null,null,{"$f":"+IF($C42=\"Y\",1,0)","v":0}]
[null,"Personal Dosimeters10","Y",null,null,{"$f":"+IF($C43=\"Y\",1,0)","v":1},{"$f":"+IF($C43=\"Y\",1,0)","v":1},{"$f":"+IF($C43=\"Y\",1,0)","v":1}]
["Protective Ensembles3"]
[null,"Liquid Splash-Protective CPC11","Y",{"$f":"+IF($C45=\"Y\",1,0)","v":1},{"$f":"+IF($C45=\"Y\",1,0)","v":1},{"$f":"+IF($C45=\"Y\",1,0)","v":1},{"$f":"+IF($C45=\"Y\",1,0)","v":1},{"$f":"+IF($C45=\"Y\",1,0)","v":1}]
[null,"Vapor-Protective CPC12","Y",null,null,null,{"$f":"+IF($C46=\"Y\",1,0)","v":1},1]
[null,"Flash Fire Vapor-Protective CPC13","Y",null,null,null,null,{"$f":"+IF($C47=\"Y\",1,0)","v":1}]
[null,"Level C PPE14","Y",{"$f":"+IF($C48=\"Y\",1,0)","v":1},{"$f":"+IF($C48=\"Y\",1,0)","v":1},1,1,1]
[null,"Level B PPE14","Y",null,null,"X","X","X"]
[null,"Level A PPE14","Y",null,null,"X","X","X"]
["Technical Reference3"]
[null,"Printed & Electronic","Y",{"$f":"+IF($C52=\"Y\",1,0)","v":1},1,1,1,1]
[null,"Dispersion Modeling with Map Overlays","Y",null,null,1,1,1]
["Special Capabilities3"]
[null,"Specialized Equipment based upon Local Risk","Y",null,null,{"$f":"+IF($C55=\"Y\",1,0)","v":1},1,1]
[null,"Heat Sensing Capability","Y",null,null,null,1,1]
[null,"Light Amplification Capability","Y",null,null,null,1,1]
[null,"Digital Imaging Documentation Capability","Y",null,null,null,null,{"$f":"+IF($C58=\"Y\",1,0)","v":1}]
["Intervention3"]
[null,"Dike, Dam, & Absorption Capability","Y",{"$f":"+IF($C60=\"Y\",1,0)","v":1},1,1,1,1]
[null,"Liquid Leak Intervention","N",null,null,null,0,0]
[null,"Neutralize, Plug, & Patch Capability","N",null,null,null,0,0]
[null,"Vapor Leak Intervention","N",null,null,null,0,0]
[null,"Advanced Intervention Capabilities15","N",null,null,null,null,{"$f":"+IF($C64=\"Y\",1,0)","v":0}]
["Decontamination3"]
[null,"Team Decontamination – Known","Y",{"$f":"+IF($C66=\"Y\",1,0)","v":1},1,1,1,1]
[null,"Team Decontamination – Known & Unknown","N",null,null,null,0,0]
[null,"Team Decontamination – Advanced","N",null,null,null,null,{"$f":"+IF($C68=\"Y\",1,0)","v":0}]
[null,"Casualty Decontamination (100 patients/hr)","Y",null,null,{"$f":"+IF($C69=\"Y\",1,0)","v":1},1,1,{"$f":"IF(AND(C69<>\"\",OR(C70=\"Y\",C71=\"Y\")),\"Do not enter a value on this line if you entered a 'Y' below.\",\"\")","v":""}]
[null,"Casualty Decontamination (250 patients/hr)",null,null,null,null,0,0,{"$f":"IF(AND(C70<>\"\",C71=\"Y\"),\"Do not enter a value on this line if you entered a 'Y' below.\",\"\")","v":""}]
[null,"Casualty Decontamination (500+ patients/hr)",null,null,null,null,0,{"$f":"+IF($C71=\"Y\",1,0)","v":0}]
["Communications3"]
[null,"In-Suit, Wireless Voice","Y",{"$f":"+IF($C73=\"Y\",1,0)","v":1},1,1,1,1]
[null,"Wireless Data","Y",null,null,null,1,1]
[null,"Secure Wireless Voice","N",null,null,null,null,{"$f":"+IF($C75=\"Y\",1,0)","v":0}]
["Staffing4"]
[null,"Hazmat Incident Commander","Y",{"$f":"+IF($C77=\"Y\",1,0)","v":1},1,1,1,1]
[null,"Hazmat Safety Officer","Y",1,1,1,1,1]
[null,"Technician Level Capability","Y",{"$f":"+IF($C79=\"Y\",1,0)","v":1},null,null,null,1]
[null,"Minimum of 2 out, 2 in, 2 to decon","Y",null,{"$f":"+IF($C80=\"Y\",1,0)","v":1},1,1,1]
[null,"More than 6 Hazmat Technicians","Y",null,null,{"$f":"+IF($C81=\"Y\",1,0)","v":1},1,1]
["Training3"]
[null,"Awareness Level (NFPA 472)","Y",1,1,1,1,1]
[null,"Operations Level (NFPA 472)","Y",1,1,1,1,1]
[null,"Technician Level (NFPA 472)","Y",null,1,1,1,1]
[null,"Specialist Level (NFPA 472)"]
[null,"Incident Commander (NFPA 472)","Y",{"$f":"+IF($C87=\"Y\",1,0)","v":1},1,1,1,1]
["Sustainability5"]
[null,"No Technician-level Entries",null,{"$f":"+IF($C89=\"Y\",1,IF($C90=\"Y\",1,IF($C91=\"Y\",1,IF($C92=\"Y\",1,IF($C93=\"Y\",1,0)))))","v":1}]
[null,"Less than 3 Entries within 24 hour period",null,null,{"$f":"+IF($C90=\"Y\",1,IF($C91=\"Y\",1,IF($C92=\"Y\",1,IF($C93=\"Y\",1,0))))","v":1}]
[null,"3 Entries within 24 hour period",null,null,null,{"$f":"+IF($C91=\"Y\",1,IF($C92=\"Y\",1,IF($C93=\"Y\",1,0)))","v":1},null,null,{"$f":"IF(AND(C91<>\"\",OR(C92=\"Y\",C93=\"Y\")),\"Do not enter a value on this line if you entered a 'Y' below.\",\"\")","v":""}]
[null,"5 Entries within 24 hour period16","Y",null,null,null,{"$f":"+IF($C92=\"Y\",1,IF($C93=\"Y\",1,0))","v":1},null,{"$f":"IF(AND(C92<>\"\",C93=\"Y\"),\"Do not enter a value on this line if you entered a 'Y' below.\",\"\")","v":""}]
[null,"10 Entries within 24 hour period16",null,null,null,null,null,{"$f":"+IF($C93=\"Y\",1,0)","v":0}]
[null,"Casualty Decon for 6 hour period17",null,{"$f":"+IF($C94=\"Y\",1,IF($C95=\"Y\",1,IF($C96=\"Y\",1,0)))","v":1},{"$f":"+IF($C94=\"Y\",1,IF($C95=\"Y\",1,IF($C96=\"Y\",1,0)))","v":1},null,null,null,{"$f":"IF(AND(C94<>\"\",OR(C95=\"Y\",C96=\"Y\")),\"Do not enter a value on this line if you entered a 'Y' below.\",\"\")","v":""}]
[null,"Casualty Decon for 12 hour period17","Y",null,null,{"$f":"+IF($C95=\"Y\",1,IF($C96=\"Y\",1,0))","v":1},{"$f":"+IF($C95=\"Y\",1,IF($C96=\"Y\",1,0))","v":1},null,{"$f":"IF(AND(C95<>\"\",C96=\"Y\"),\"Do not enter a value on this line if you entered a 'Y' below.\",\"\")","v":""}]
[null,"Casualty Decon for 12+ hour period17",null,null,null,null,null,0]
[null,"Number met",null,{"$f":"SUM(D89:D96,D83:D87,D77:D81,D73:D75:D66,D60:D71,D55:D64,D52:D58,D45:D53,D40:D50,D36:D43,D28:D38,D23:D34,D26)","v":27},{"$f":"SUM(E89:E96,E83:E87,E77:E81,E73:E75:E66,E60:E71,E55:E64,E52:E58,E45:E53,E40:E50,E36:E43,E28:E38,E23:E34,E26)","v":34},{"$f":"SUM(F89:F96,F83:F87,F77:F81,F73:F75:F66,F60:F71,F55:F64,F52:F58,F45:F53,F40:F50,F36:F43,F28:F38,F23:F34,F26)","v":45},{"$f":"SUM(G89:G96,G83:G87,G77:G81,G73:G75:G66,G60:G71,G55:G64,G52:G58,G45:G53,G40:G50,G36:G43,G28:G38,G23:G34,G26)","v":52},{"$f":"SUM(H89:H96,H83:H87,H77:H81,H73:H75:H66,H60:H71,H55:H64,H52:H58,H45:H53,H40:H50,H36:H43,H28:H38,H23:H34,H26)","v":55}]
[null,"Number for full compliance with Tire Level",null,27,34,45,70,90]
[null,"Meets Tier level requirements",null,{"$f":"+IF(D98>D97,\"Base N\",\"Base Y\")","v":"Base Y"},{"$f":"+IF(E98>E97,\"Tier 1 N\",\"Tier 1 Y\")","v":"Tier 1 Y"},{"$f":"+IF(F98>F97,\"Tier 2 N\",\"Tier 2 Y\")","v":"Tier 2 Y"},{"$f":"+IF(G98>G97,\"Tier 3 N\",\"Tier 3 Y\")","v":"Tier 3 N"},{"$f":"+IF(H98>H97,\"Tier 4 N\",\"Tier 4 Y\")","v":"Tier 4 N"}]
[null,"Tier Level Capability",2]
["Key"]
["X – Required minimum capability"]
["O – Optional capability"]
["Notes"]
["1Capability Value – the value to insert into the risk equation for capability.  The higher the value, the greater the capability mitigates the risk."]
["2Certification – Based upon 29 CFR 1910.120Q or NFPA Standard 472 (2008 Edition) as determined by jurisdiction."]
["3Metric – From FEMA 508-4 Typed Resource Definitions for Fire and Hazardous Materials Resources (20 July 2005).  Limitations include (1) focused solely on Hazmat Entry Team vice complete Hazmat Response Capability required to manage casualties as well as conduct testing, monitoring, and sampling and (2) focused on National level resources exceeding minimum standards (hence the addition of Baseline and Tier 1 capability sets).  "]
["4Staffing – Additional details provided due to the increase of scope to include Operations-level units, casualty decontamination operations, & Hazmat Response Teams below the FEMA Type III resource definition."]
["5Sustainability – Additional capabilities listed to include Operations-level capability & sustained entries over FEMA 508-4 minimum."]
["6Specialized Chemicals – As defined by FEMA 508-4 (20 July 2005)."]
["7Flammable Gas Differentiation – As defined by FEMA 508-4 (20 July 2005)."]
["8Presumptive Identification of Toxic Industrial Chemicals (TIC) – As defined by FEMA 508-4 (20 July 2005)."]
["9Presumptive Identification of Hazardous Material Concentration – As defined by FEMA 508-4 (20 July 2005)."]
["10Personal Dosimeters – As defined by FEMA 508-4 (20 July 2005)."]
["11Liquid Splash-Protective CPC – As defined by FEMA 508-4 (20 July 2005)."]
["12Vapor-Protective CPC – As defined by FEMA 508-4 (20 July 2005)."]
["13Flash Fire Vapor-Protective CPC – As defined by FEMA 508-4 (20 July 2005)."]
["14Level A-C PPE – As defined by 29 CFR 1910.120Q."]
["15Advanced Intervention Capabilities – As defined by FEMA 508-4 (20 July 2005)."]
["16Entry Capabilities – Expanded beyond FEMA 508-4 minimum."]
["17Casualty Decontamination Capabilities – Additional metric due to expansion of scope from Hazmat Entry to Hazmat Response."]

{"sheet":"Step 3 to 6","index":2,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[28,2,28,6],[1,1,4,8],[6,1,6,8],[8,1,10,8],[12,1,12,8]]}
[]
[null,"The purpose of these three steps is to determine the Jurisdictional Class (DHS) that best matches the goals for your local or regional emergency response  team.   Table 3 shows the Jurisdictional Class based on the population characteristics of the local or regional area.  Tables  4 though  8 in the Guide suggest response goals associated with those Jurisdictional Classes.  The assessor or assessment  team addressing the response group's Jurisdictional Class has the option of picking a different Jurisdictional Class based on the goals instead of the population characteristics in Table 3.    "]
[]
[]
[]
[]
[null,"Once the Jurisdictional Class is chosen, then the response capabilities tiers for Assessment, Management, Rescue and Control are specified in Table 9.  "]
[]
[null,"Note that if the Capability Tiers' performance levels  identified in Steps 1 and 2 do not meet the requirements in Table 9, then a gap is identified.  The planner has the option of addressing that gap before proceeding.  If the choice is to proceed with the assessment recognizing the gap, then  it follows that the gaps defied in Steps 10 through 20 will be larger than if the gap is addressed before proceeding."]
[]
[]
[]
[null,"As was the case in the previous tab, the lightly shaded blue areas are to be filled out by the assessor.  "]
[]
[]
[null,"Table 3 in Guide"]
[null,"Jurisdictional Class","Population Threshold","Population Density Threshold"]
[null,1,"> 1.5 Million","> 10,000 people/mi2"]
[null,2,"500,000 to 1.5 Million","> 5,000 people/mi2"]
[null,3,"100,000 to 500,000","> 2,500 people/mi2"]
[null,4,"10,000 to 100,000","> 1,000 people/mi2"]
[null,5,"< 10,000"]
[]
["Step 4","Assigned Jurisdictional Class (Table Above)",null,5]
["Step 5","Adjusted Jurisdictional Class (other factors)",null,4]
[]
[null,"Table 9  Response Capability Tiers Based on Jurisdictional Type"]
[null,"Target Outcome","Class 5","Class 4","Class 3","Class 2","Class 1"]
[null,null,"Required Capability Tier Level"]
[null,"Assess",0,0,0,0,0]
[null,"Manage",1,2,3,4,4]
[null,"Rescue",0,0,0,0,0]
[null,"Control",1,2,3,4,4]
[]
["Step 6","Gaps","Can you perform at the Tier Level Specified in the above table based on the Step 5 Jurisdictional Class assigned (Yes/No)?",null,null,null,null,null,"Yes "]
[null,null,"If No, adjust the Jurisdictional Class to one that you can meet - enter value:",null,null,null,null,null,4]
[null,null,"(This value will be carried to Steps 16 and 17)"]
[]
[null,"Note: if the  Required Capability for the Jurisdictional Class is less than the Capability in Step 1, the first priority should be to correct this gap"]
[null,"before proceeding to the rest of the evaluation. The analysis will assume that this gap has been eliminated for the following steps."]

{"sheet":"Steps 10 - 11  Pop Conseq","index":3,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[23,1,24,1],[23,0,24,0],[1,1,2,6],[4,1,9,6],[11,1,13,6],[15,1,19,6]]}
[]
[null,"This is the start of the evaluation of the risk equation shown in Section 1.D of the Guide.  It begins in Step 10 and continues until the risk metric equation value is obtained in Step 20.  "]
[]
[]
[null,"This worksheet tab focuses totally on the consequences of the release.  These consequences can be estimated using a code (model) such as ALOHA that is used to calculate the aerial extent of the plume, using some criteria like the ERPG-2 concentration, and then multiplying that area by the population density to get an estimate of the number of people exposed to above the EPRG-2 level.  Alternatively an assessor could just enter and estimated number of exposed people.  This might be reasonable in a very rural area with sparse population.  Since the scenarios are to be compared based on risk, what is needed is a relative risk level and an absolute risk level.  "]
[]
[]
[]
[]
[]
[]
[null,"The estimate of consequence could be very conservatively estimated by using a representative population density for the region and then estimating the ERPG-2 plume area and assuming everyone within the area is fatally injured - a very conservative estimate but acceptable if all the scenarios use the same consequence measure.  "]
[]
[]
[]
[null,"The entries in the table below are given as an example and typically the assessor or assessment team using this Guide would fill in their own scenarios.  The expectation is that they would simply replace the entries shown .  If more scenario lines are needed, just add lines by moving to cursor the row number and the very left of the row, right clicking and clicking on insert.  The formulas from the previous row would then be copied down into the new row.   The consequence calculation example is described in greater detail in Appendix C of the Guide."]
[]
[]
[]
[]
[null,"Cells shaded in blue must be calculated and filled in "]
[]
["Consequence Calculation"]
["Facility or Route","Hazard","quantity of material ","damage radius or radii for ellipse","Damaged Area","Population Density","Population Consequence"]
[null,null,"kgs","meters","Acres","people/mi2","people"]
["Facility z","Fire (Ethylene Oxide)",40000,80,{"$f":"+PI()*D26^2/4*0.0002471044","v":1.242082188335542},500,{"$f":"+E26/640*F26","v":0.97037670963714218}]
["Facility z","Explosion (Ethylene Oxide)",40000,479,{"$f":"+PI()*D27^2/4*0.0002471044","v":44.528840527171113},500,34.788156661852433]
["Facility z","Toxic Gas (Chlorine) (L)",20000," 525 - 4000",{"$f":"+PI()*525*4000*0.0002471044","v":1630.2328721903989},500,1273.6194313987492]
["Facility z","Toxic Gas (Chlorine) (S)",20000,"142 - 1000",{"$f":"+PI()*142*1000*0.0002471044","v":110.23479421477936},500,86.120932980296374]
["step 10-11 facility","step 10 - 11 hazard","step 10-11 value","step 10-11 value","step 10-11 value","step 10-11 value",{"$error":"#VALUE!"}]
["Roads x","Fire  (Gasoline)",40000,80,{"$f":"+PI()*D31^2/4*0.0002471044","v":1.242082188335542},1200,2.3289041031291413]
["Roads x","Toxic Gas (Ammonia) (L)",20000," 525 - 4000",{"$f":"+PI()*525*4000*0.0002471044","v":1630.2328721903989},1200,{"$f":"+E32/640*F32","v":3056.6866353569981}]
["Roads x","Toxic Gas (Ammonia) (S)",20000,"64 - 688",{"$f":"+PI()*64*688*0.0002471044","v":34.182101822994113},1200,64.09144091811396]
["Roads x","Toxic Liquid (37% HCl) (L)",20000,"73 - 781",{"$f":"+PI()*73*781*0.0002471044","v":44.259269877233905},1200,82.98613101981357]
["Roads x","Toxic Liquid (37% HCl) (S)",20000,"24 - 287",{"$f":"+PI()*24*287*0.0002471044","v":5.347163820784508},1200,10.025932163970953]
["Roads y","Fire  (Gasoline)",28000,80,{"$f":"+PI()*D36^2/4*0.0002471044","v":1.242082188335542},1000,{"$f":"+E36/640*F36","v":1.9407534192742844}]
["Roads u","Fire  (Gasoline)",28000,80,{"$f":"+PI()*D37^2/4*0.0002471044","v":1.242082188335542},1200,2.3289041031291413]
["Roads u","Toxic Liquid (37% HCl) (L)",20000,"73 - 781",{"$f":"+PI()*73*781*0.0002471044","v":44.259269877233905},1200,82.98613101981357]
["Roads u","Toxic Liquid (37% HCl) (S)",20000,"24 - 287",{"$f":"+PI()*24*287*0.0002471044","v":5.347163820784508},1200,10.025932163970953]
["Road w","Fire  (Gasoline)",28000,80,{"$f":"+PI()*D40^2/4*0.0002471044","v":1.242082188335542},1200,2.3289041031291413]
["Road w","Toxic Gas (Ammonia) (L)",20000," 525 - 4000",{"$f":"+PI()*525*4000*0.0002471044","v":1630.2328721903989},1200,3056.6866353569981]
["Road w","Toxic Gas (Ammonia) (S)",20000,479,{"$f":"+PI()*64*688*0.0002471044","v":34.182101822994113},1200,64.09144091811396]
["Railroad s","BLEVE (Ethylene Oxide)",80000,500,{"$f":"+PI()*D43^2/4*0.0002471044","v":48.51883548185711},1200,90.972816528482085]
["Railroad s","Toxic Gas (Chlorine) (L)",80000,"1000 - 14000",{"$f":"+PI()*1000*14000*0.0002471044","v":10868.219147935992},1200,{"$f":"+E44/640*F44","v":20377.910902379987}]
["Railroad s","Toxic Gas (Chlorine)  (S)",80000,"330 - 4200",{"$f":"+PI()*330*4200*0.0002471044","v":1075.9536956456632},1200,2017.4131793356185]
["step 10-12 route","step 10 - 11 hazard","step 10-11 value","step 10-11 value","step 10-11 value","step 10-11 value",{"$f":"A46=+E46/640*F46","v":{"$error":"#VALUE!"}}]

{"sheet":"Steps 12 - 13 Env Conseq","index":4,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,3,6],[5,1,7,6],[9,1,10,6],[30,0,31,0],[30,1,31,1],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3]]}
[]
[null,"The assessor can choose to estimate the environmental consequences of all, some or no scenarios.  If the assessor or assessment team does not see much potential for environmental damage from a given release then the entries should reflect no damage. "]
[]
[]
[]
[null,"The purpose of this tab is not to complicate the analysis but rather force the assessor or assessment team to consider environmental damage where it is judged to be appropriate to do so.   In the example below, the areas used are the same as used in the population consequence calculation in Steps 10 and 11.  This need not be the case. "]
[]
[]
[]
[null,"The blue shaded areas are to be filled in, the scenarios are copied from tab \"Steps 10 - 11 Pop Conseq\" and will automatically be updated in the scenario list is changed on that tab "]
[]
[]
[]
[null,null,"These two tables are taken from Table C-2 in the Guide."]
[]
[null,null,"Table A  Value per Building Unit by Population Type and Building Type"]
[null,null,"Population Type",null,"Residential","Commercial","Industrial"]
[null,null,"Rural",null,150000,1200000,2400000]
[null,null,"Suburban",null,1200000,12000000,24000000]
[null,null,"Urban",null,8000000,50000000,100000000]
[]
[]
[null,null,"Table B  Value per Acre for Damaged Land by Land Type"]
[null,null,"Land Damage / acre",null,"$ Value","Wetland / Acre","$ Value"]
[null,null,"Fallow Land",null,200,"Unused",50000]
[null,null,"Low Crop Value",null,1000,"Low Value ",100000]
[null,null,"High Crop Value",null,400000,"High Value",400000]
[]
[null,null,null,null,"                            Cells shaded in blue must be calculated and filled in,",null,null," others calculated or passed from another worksheet"]
["See Table C-3 and C-4 for additional details regarding the Environmental Consequence Calculation"]
["Facility or Route","Hazard","Quantity of Material ","Damage Radius or Radii for Ellipse","Damaged Area","Typical Type  Infrastructure Damaged","Land Area Damaged","Number of Infrastructure Units in Hazard Zone","Land Damage Value from Table A Above","Infrastructure Damage","Environmentally Sensitive Land Area Damaged","Typical Type of Land Damaged","Land Damage Value from Table B Above","Environmental Consequence"]
[null,null,"kgs","meters","Acres",null,"Acres","#",null,"$","Acres",null,null,"$"]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B26","v":"Fire (Ethylene Oxide)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C26","v":40000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D26","v":80},{"$f":"+'Steps 10 - 11  Pop Conseq'!E26","v":1.242082188335542},"Commercial/Rural",1,5,{"$f":"+F$18","v":1200000},{"$f":"ROUND(I33*G33*H33,-6)","v":6000000},{"$f":"+E33*0.2","v":0.24841643766710841},"Wetland/Low Value",{"$f":"+G$26","v":100000},{"$f":"+MIN(ROUND(K33*M33,-4),10000000)","v":20000}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B27","v":"Explosion (Ethylene Oxide)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C27","v":40000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D27","v":479},{"$f":"+'Steps 10 - 11  Pop Conseq'!E27","v":44.528840527171113},"Commercial/Rural",2,10,{"$f":"+F$18","v":1200000},{"$f":"ROUND(I34*G34*H34,-6)","v":24000000},{"$f":"+E34*0.2","v":8.9057681054342233},"Wetland/Low Value",{"$f":"+G$26","v":100000},{"$f":"+MIN(ROUND(K34*M34,-4),10000000)","v":890000}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B28","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C28","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D28","v":" 525 - 4000"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E28","v":1630.2328721903989},"Commercial/Rural",4,20,{"$f":"+F$18","v":1200000},{"$f":"ROUND(I35*G35*H35,-6)","v":96000000},326.0465744380798,"Wetland/Low Value",{"$f":"+G$26","v":100000},{"$f":"+MIN(ROUND(K35*M35,-4),10000000)","v":10000000}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B29","v":"Toxic Gas (Chlorine) (S)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C29","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D29","v":"142 - 1000"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E29","v":110.23479421477936},"Commercial/Rural",1,5,{"$f":"+F$18","v":1200000},{"$f":"ROUND(I36*G36*H36,-6)","v":6000000},22.046958842955874,"Wetland/Low Value",{"$f":"+G$26","v":100000},{"$f":"+MIN(ROUND(K36*M36,-4),10000000)","v":2200000}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A30","v":"step 10-11 facility"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B30","v":"step 10 - 11 hazard"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C30","v":"step 10-11 value"},{"$f":"+'Steps 10 - 11  Pop Conseq'!D30","v":"step 10-11 value"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E30","v":"step 10-11 value"},"step 12 13 value","step 12 13 value","step 12 13 value","step 12 13 value",{"$f":"ROUND(I37*G37*H37,-6)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"step 12 13 value","step 12 13 value",{"$f":"+MIN(ROUND(K37*M37,-4),10000000)","v":{"$error":"#VALUE!"}}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C31","v":40000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D31","v":80},{"$f":"+'Steps 10 - 11  Pop Conseq'!E31","v":1.242082188335542},"Resident / Rural",0.5,1,{"$f":"+E$18","v":150000},{"$f":"+I38*H38","v":150000},1,"Wetland/Low Value",{"$f":"+G$26","v":100000},{"$f":"+G38*M38","v":50000}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C32","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D32","v":" 525 - 4000"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E32","v":1630.2328721903989},"Resident / Rural",{"$f":"+PI()*132*132*0.0002471044*0.1","v":1.3526275030974055},2,150000,300000,{"$f":"+PI()*132*132*0.0002471044","v":13.526275030974054},"Wetland/Low Value",100000,135262.75030974054]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C33","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D33","v":"64 - 688"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E33","v":34.182101822994113},"Resident / Rural",{"$f":"+G39/10","v":0.13526275030974055},2,150000,300000,{"$f":"+K39/10","v":1.3526275030974053},"Wetland/Low Value",100000,13526.275030974055]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C34","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D34","v":"73 - 781"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E34","v":44.259269877233905},"Resident / Rural",0.91722263404991355,2,150000,300000,9.1999999999999993,"Wetland/Low Value",100000,91722.263404991361]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C35","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D35","v":"24 - 287"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E35","v":5.347163820784508},"Resident / Rural",{"$f":"+G41/10","v":9.1722263404991358E-2},1,150000,150000,0.9,"Wetland/Low Value",100000,9172.2263404991354]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C36","v":28000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D36","v":80},{"$f":"+'Steps 10 - 11  Pop Conseq'!E36","v":1.242082188335542},"Resident / Rural",0.5,1,150000,150000,1,"Wetland/Low Value",100000,50000]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C37","v":28000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D37","v":80},{"$f":"+'Steps 10 - 11  Pop Conseq'!E37","v":1.242082188335542},"Resident / Rural",0.5,1,150000,150000,1,"Wetland/Low Value",100000,50000]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C38","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D38","v":"73 - 781"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E38","v":44.259269877233905},"Resident / Rural",0.91722263404991355,4,150000,600000,9.1999999999999993,"Wetland/Low Value",100000,91722.263404991361]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C39","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D39","v":"24 - 287"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E39","v":5.347163820784508},"Resident / Rural",{"$f":"+G45/10","v":9.1722263404991358E-2},4,150000,600000,0.9,"Wetland/Low Value",100000,9172.2263404991354]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C40","v":28000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D40","v":80},{"$f":"+'Steps 10 - 11  Pop Conseq'!E40","v":1.242082188335542},"Resident / Rural",0.5,1,150000,150000,1,"Wetland/Low Value",100000,50000]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C41","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D41","v":" 525 - 4000"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E41","v":1630.2328721903989},"Resident / Rural",{"$f":"+PI()*132*132*0.0002471044*0.1","v":1.3526275030974055},2,150000,300000,{"$f":"+PI()*132*132*0.0002471044","v":13.526275030974054},"Wetland/Low Value",100000,135262.75030974054]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C42","v":20000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D42","v":479},{"$f":"+'Steps 10 - 11  Pop Conseq'!E42","v":34.182101822994113},"Resident / Rural",{"$f":"+G48/10","v":0.13526275030974055},1,150000,150000,{"$f":"+K48/10","v":1.3526275030974053},"Wetland/Low Value",100000,13526.275030974055]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C43","v":80000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D43","v":500},{"$f":"+'Steps 10 - 11  Pop Conseq'!E43","v":48.51883548185711},"Resident / Rural",1,2,150000,300000,1,"Wetland/Low Value",100000,100000]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C44","v":80000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D44","v":"1000 - 14000"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E44","v":10868.219147935992},"Resident / Rural",{"$f":"+PI()*367*367*0.0002471044*0.1","v":10.455925491545365},20,150000,3000000,{"$f":"+PI()*367*367*0.0002471044","v":104.55925491545364},"Wetland/Low Value",100000,1045592.5491545364]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C45","v":80000},{"$f":"+'Steps 10 - 11  Pop Conseq'!D45","v":"330 - 4200"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E45","v":1075.9536956456632},"Resident / Rural",{"$f":"+G51/10","v":1.0455925491545366},2,150000,300000,{"$f":"+K51/10","v":10.455925491545363},"Wetland/Low Value",100000,104559.25491545365]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A46","v":"step 10-12 route"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B46","v":"step 10 - 11 hazard"},{"$f":"+'Steps 10 - 11  Pop Conseq'!C46","v":"step 10-11 value"},{"$f":"+'Steps 10 - 11  Pop Conseq'!D46","v":"step 10-11 value"},{"$f":"+'Steps 10 - 11  Pop Conseq'!E46","v":"step 10-11 value"},"step 12 13 value","step 12 13 value","step 12 13 value","step 12 13 value",{"$f":"ROUND(I53*G53*H53,-6)","v":{"$error":"#VALUE!"}},{"$f":"+E53*0.2","v":{"$error":"#VALUE!"}},"step 12 13 value","step 12 13 value",{"$error":"#VALUE!"}]

{"sheet":"Step 14 Max Conseq","index":5,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,1,3,5],[5,1,6,5]]}
[]
[null,"The purpose of this tab is to estimate the  maximum consequence measure for each scenario by looking at the consequence measure for population, land use, and environmental damage and selecting the maximum.  The consequence measures used are shown in the two preceding tabs."]
[]
[]
[]
[null,"Everything on this tab should be determined based on the entries made for Steps 10 through 13. There are no user entries required on this tab."]
[]
[]
[]
[null,"For more details, see the discussion of Table 13"]
[null,"Population Measures","Consequence Measure","> this value"]
[null,"None",1,0]
[null,"1 to 9",2,1]
[null,"10 to 99",3,10]
[null,"100 to 999",4,100]
[null,"> 999",5,1000]
[]
[null,"For more details see discussion of Table 13 - the environmental damage columns"]
[null,"Economic Damage","Consequence Measure","> this value"]
[null,"Less than a Million",1,0]
[null,"1 to 10 Million",2,999999]
[null,"> 10 to 100 Million",3,9999999]
[null,"> 100 to 1 Billion",4,99999999]
[null,"> 1 Billion",5,999999999]
[]
[]
[]
["Consequence Measure"]
["Facility or Route","Hazard","Population Consequence","infrastructure damage","Consequence Environmental","Maximum Consequences"]
[null,null,"[C]","[C]","[C]","[C]"]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B26","v":"Fire (Ethylene Oxide)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G26>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G26>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G26>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G26>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!J33>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J33>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J33>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J33>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":2},{"$f":"IF('Steps 12 - 13 Env Conseq'!N33>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N33>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N33>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N33>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"MAX(C31:E31)","v":2}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B27","v":"Explosion (Ethylene Oxide)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G27>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G27>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G27>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G27>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!J34>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J34>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J34>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J34>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!N34>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N34>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N34>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N34>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B28","v":"Toxic Gas (Chlorine) (L)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G28>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G28>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G28>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G28>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":5},{"$f":"IF('Steps 12 - 13 Env Conseq'!J35>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J35>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J35>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J35>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!N35>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N35>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N35>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N35>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":3},5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B29","v":"Toxic Gas (Chlorine) (S)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G29>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G29>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G29>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G29>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!J36>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J36>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J36>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J36>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":2},{"$f":"IF('Steps 12 - 13 Env Conseq'!N36>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N36>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N36>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N36>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":2},3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A30","v":"step 10-11 facility"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B30","v":"step 10 - 11 hazard"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G30>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G30>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G30>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G30>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":{"$error":"#VALUE!"}},{"$f":"IF('Steps 12 - 13 Env Conseq'!J37>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J37>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J37>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J37>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":{"$error":"#VALUE!"}},{"$f":"IF('Steps 12 - 13 Env Conseq'!N37>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N37>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N37>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N37>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":{"$error":"#VALUE!"}},{"$f":"MAX(C35:E35)","v":{"$error":"#VALUE!"}}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G31>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G31>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G31>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G31>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":2},{"$f":"IF('Steps 12 - 13 Env Conseq'!J38>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J38>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J38>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J38>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N38>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N38>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N38>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N38>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},2]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},5,{"$f":"IF('Steps 12 - 13 Env Conseq'!J39>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J39>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J39>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J39>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N39>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N39>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N39>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N39>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},3,{"$f":"IF('Steps 12 - 13 Env Conseq'!J40>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J40>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J40>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J40>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N40>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N40>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N40>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N40>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G34>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G34>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G34>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G34>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!J41>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J41>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J41>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J41>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N41>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N41>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N41>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N41>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G35>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G35>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G35>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G35>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!J42>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J42>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J42>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J42>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N42>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N42>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N42>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N42>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"MAX(C40:E40)","v":3}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G36>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G36>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G36>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G36>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":2},{"$f":"IF('Steps 12 - 13 Env Conseq'!J43>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J43>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J43>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J43>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N43>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N43>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N43>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N43>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},2]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G37>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G37>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G37>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G37>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":2},{"$f":"IF('Steps 12 - 13 Env Conseq'!J44>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J44>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J44>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J44>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N44>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N44>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N44>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N44>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},2]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G38>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G38>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G38>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G38>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!J45>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J45>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J45>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J45>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N45>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N45>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N45>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N45>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G39>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G39>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G39>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G39>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!J46>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J46>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J46>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J46>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N46>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N46>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N46>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N46>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G40>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G40>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G40>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G40>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":2},{"$f":"IF('Steps 12 - 13 Env Conseq'!J47>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J47>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J47>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J47>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N47>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N47>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N47>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N47>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},2]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G41>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G41>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G41>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G41>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":5},{"$f":"IF('Steps 12 - 13 Env Conseq'!J48>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J48>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J48>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J48>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N48>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N48>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N48>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N48>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G42>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G42>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G42>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G42>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!J49>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J49>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J49>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J49>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N49>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N49>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N49>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N49>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G43>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G43>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G43>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G43>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":3},{"$f":"IF('Steps 12 - 13 Env Conseq'!J50>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J50>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J50>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J50>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N50>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N50>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N50>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N50>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G44>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G44>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G44>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G44>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":5},{"$f":"IF('Steps 12 - 13 Env Conseq'!J51>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J51>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J51>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J51>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":2},{"$f":"IF('Steps 12 - 13 Env Conseq'!N51>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N51>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N51>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N51>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":2},5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G45>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G45>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G45>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G45>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":5},{"$f":"IF('Steps 12 - 13 Env Conseq'!J52>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J52>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J52>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J52>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},{"$f":"IF('Steps 12 - 13 Env Conseq'!N52>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N52>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N52>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N52>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":1},5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A46","v":"step 10-12 route"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B46","v":"step 10 - 11 hazard"},{"$f":"IF('Steps 10 - 11  Pop Conseq'!G46>'Step 14 Max Conseq'!D$16,'Step 14 Max Conseq'!C$16,IF('Steps 10 - 11  Pop Conseq'!G46>'Step 14 Max Conseq'!D$15,'Step 14 Max Conseq'!C$15,IF('Steps 10 - 11  Pop Conseq'!G46>'Step 14 Max Conseq'!D$14,'Step 14 Max Conseq'!C$14,IF('Steps 10 - 11  Pop Conseq'!G46>'Step 14 Max Conseq'!D$13,'Step 14 Max Conseq'!C$13,'Step 14 Max Conseq'!C$12))))","v":{"$error":"#VALUE!"}},{"$f":"IF('Steps 12 - 13 Env Conseq'!J53>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!J53>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!J53>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!J53>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":{"$error":"#VALUE!"}},{"$f":"IF('Steps 12 - 13 Env Conseq'!N53>'Step 14 Max Conseq'!D$24,'Step 14 Max Conseq'!C$24,IF('Steps 12 - 13 Env Conseq'!N53>'Step 14 Max Conseq'!D$23,'Step 14 Max Conseq'!C$23,IF('Steps 12 - 13 Env Conseq'!N53>'Step 14 Max Conseq'!D$22,'Step 14 Max Conseq'!C$22,IF('Steps 12 - 13 Env Conseq'!N53>'Step 14 Max Conseq'!D$21,'Step 14 Max Conseq'!C$21,+C$20))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"+'Step 14 Max Conseq'!D31","v":2},{"$f":"+'Steps 12 - 13 Env Conseq'!N33","v":20000}]

{"sheet":"Step 16  ERC","index":6,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,6],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[3,1,4,6],[9,2,9,6],[9,1,10,1],[13,2,13,6],[11,2,11,6]]}
[]
[null,"Like the previous tab, all the entries under this tab should be automatically filled out based on the entries in steps 6,  and steps 10 though 14 ."]
[]
[null,"Table 16 specifies the required Tier level response for the  scenario consequence level determined in tab \"Step 14 Max Conseq\" and the Tier level capabilities were determined in steps 6 though 10 so the gap, if any, can not be calculated without additional data entries by the assessor.  "]
[]
[]
[]
[]
[null,"For more details see discussion of Table 16 Required Tier Response Capabilities in Chapter VI"]
[null,"Potential Consequences","Total Population "]
[null,null,"< 10,000","10,000 - < 100,000","100,000 - < 500,000","500,000 - 1.5 million","> 1.5 million"]
[null,null,"Jurisdiction Class"]
[null,null,5,4,3,2,1]
[null,null,"Required Tier Level Response"]
[null,1,0,0,0,1,1]
[null,2,0,1,1,2,3]
[null,3,1,1,2,3,4]
[null,4,2,2,3,4,4]
[null,5,3,4,4,4,4]
[]
[null,"Jurisdictional Class Assigned in Step 6",{"$f":"+'Step 3 to 6'!I36","v":4}]
[null,"Tier Level Capability from Step 2",{"$f":"+'Step 1 and 2'!C100","v":2}]
[]
[null,"See discussion of Table 17 in Planning Guide"]
[null,"Basis for Assigning Value",null,"Emergency Response Capability [ERC] "]
[null,"Response meets Required Desired Tier Level Response ",null,1]
[null,"Response is one Tier Level below the Required Desired Tier Level Response ",null,3]
[null,"Response is two or more Tier Levels below Desired Tier Level Response ",null,5]
[]
[]
[null,"Facility or Route","Hazard","Maximum Consequences ","Tier Level Response","Tier Level Capability","Capability Gap"]
[null,null,null,"From Step 14","From Jurisdictional Class Table above","From Step 1","From Table Above"]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B26","v":"Fire (Ethylene Oxide)"},{"$f":"+'Step 14 Max Conseq'!F31","v":2},{"$f":"VLOOKUP(D33,$B$15:$G$19,7-C$21,FALSE)","v":1},{"$f":"+C$22","v":2},{"$f":"+IF((E33-F33)>1,D$28,IF((E33-F33)>0,D$27,D$26))","v":1}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B27","v":"Explosion (Ethylene Oxide)"},{"$f":"+'Step 14 Max Conseq'!F32","v":3},{"$f":"VLOOKUP(D34,$B$15:$G$19,7-C$21,FALSE)","v":1},{"$f":"+C$22","v":2},{"$f":"+IF((E34-F34)>1,D$28,IF((E34-F34)>0,D$27,D$26))","v":1}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B28","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+'Step 14 Max Conseq'!F33","v":5},4,{"$f":"+C$22","v":2},{"$f":"+IF((E35-F35)>1,D$28,IF((E35-F35)>0,D$27,D$26))","v":5}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B29","v":"Toxic Gas (Chlorine) (S)"},{"$f":"+'Step 14 Max Conseq'!F34","v":3},1,{"$f":"+C$22","v":2},{"$f":"+IF((E36-F36)>1,D$28,IF((E36-F36)>0,D$27,D$26))","v":1}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A30","v":"step 10-11 facility"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B30","v":"step 10 - 11 hazard"},{"$f":"+'Step 14 Max Conseq'!F35","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(D37,$B$15:$G$19,7-C$21,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"+C$22","v":2},{"$f":"+IF((E37-F37)>1,D$28,IF((E37-F37)>0,D$27,D$26))","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},{"$f":"+'Step 14 Max Conseq'!F36","v":2},{"$f":"VLOOKUP(D38,$B$15:$G$19,7-C$21,FALSE)","v":1},{"$f":"+C$22","v":2},{"$f":"+IF((E38-F38)>1,D$28,IF((E38-F38)>0,D$27,D$26))","v":1}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},{"$f":"+'Step 14 Max Conseq'!F37","v":5},4,2,5]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},{"$f":"+'Step 14 Max Conseq'!F38","v":3},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},{"$f":"+'Step 14 Max Conseq'!F39","v":3},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},{"$f":"+'Step 14 Max Conseq'!F41","v":2},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},{"$f":"+'Step 14 Max Conseq'!F41","v":2},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},{"$f":"+'Step 14 Max Conseq'!F42","v":2},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},{"$f":"+'Step 14 Max Conseq'!F43","v":3},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},{"$f":"+'Step 14 Max Conseq'!F44","v":3},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},{"$f":"+'Step 14 Max Conseq'!F45","v":2},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},{"$f":"+'Step 14 Max Conseq'!F46","v":5},4,2,5]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},{"$f":"+'Step 14 Max Conseq'!F47","v":3},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},{"$f":"+'Step 14 Max Conseq'!F48","v":3},1,2,1]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+'Step 14 Max Conseq'!F49","v":5},4,2,5]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},{"$f":"+'Step 14 Max Conseq'!F50","v":5},4,2,5]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A46","v":"step 10-12 route"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B46","v":"step 10 - 11 hazard"},{"$f":"+'Step 14 Max Conseq'!F51","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(D53,$B$15:$G$19,7-C$21,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"+C$22","v":2},{"$f":"+IF((E53-F53)>1,D$28,IF((E53-F53)>0,D$27,D$26))","v":{"$error":"#VALUE!"}}]

{"sheet":"Step 17 RTF","index":7,"n_rows":128,"n_cols":8,"rows_kept":128,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,2,15,6],[20,2,20,6],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4]]}
[null,null,null,null,null,"Selected Jurisdiciton Level"]
[null,"In Steps 6 - 9 the Jurisdiction Level you selected as a goal is copied here.  No assessor entry is required.  ",null,null,null,4]
[]
[]
[null,null,"Response Time Factor [RTF]","Description"]
[null,null,1,"Meets or exceeds desired response time"]
[null,null,2,"Response time is within 125 percent of desired response time"]
[null,null,3,"Response time is within 150 percent of desired response time"]
[null,null,4,"Response time is within 200 percent of the desired response time "]
[null,null,5,"Response time is more than double the desired response time "]
[]
[]
[null,"Response Times and Response Levels"]
[null,"Jurisdiction Type",5,4,3,2,1]
[null,"Number of Accident Sites",1,1,1,2,3]
[null,"Time","minutes"]
[1,"Assess",5,5,5,5,5]
[2,"Manage",60,45,30,30,30]
[3,"Rescue",60,10,10,10,10]
[4,"Control  ",90,60,45,30,30]
[null,null,"Minimum Tier Level Response and Access Additional Number of Tier 3/4 Teams Required"]
[6,"Required non-Ambulatory rescues",5,10,100,200,500]
[7,"Incident Commander Tier",1,2,3,4,4]
[8,"Control Team Tier",1,2,3,4,4]
[9,"Access to Tier 3/4 Teams (#)",1,1,2,4,4]
[]
[null,"Jurisdiction Level Selected Step 6",null,{"$f":"+'Step 3 to 6'!I36","v":4}]
[null,"                                                                                   Cells shaded in blue must be calculated and filled in,",null,null," others calculated or passed from another worksheet"]
["First Responder Performance"]
["Facility or Route","Hazard","Selected Jurisdiction Level ","First Responder Time Goal based on CARVER Scale for Accident","Average Response Time For First Responder (assessor) to Arrive on Scene","Percentage of Response Time Goal","First Responder [RTF]"]
[null,null,null,"min","min","%"]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B26","v":"Fire (Ethylene Oxide)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$17,$A$17:$G$20,8-$D$27,FALSE)","v":5},5,{"$f":"+E32/D32","v":1},{"$f":"IF(F32<1.01,1,IF(F32<1.26,2,IF(F32<1.51,3,IF(F32<2.01,4,5))))","v":1}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B27","v":"Explosion (Ethylene Oxide)"},{"$f":"+F$2","v":4},5,5,1,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B28","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+F$2","v":4},5,5,1,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B29","v":"Toxic Gas (Chlorine) (S)"},{"$f":"+F$2","v":4},5,5,1,1]
[null,null,{"$f":"+F$2","v":4},5,null,0,1]
["insert additional lines for facility scenarios "]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP(B$17,$B$17:$G$20,6-C38,FALSE)","v":5},10,{"$f":"+E38/D38","v":2},{"$f":"IF(F38<1.01,1,IF(F38<1.26,2,IF(F38<1.51,3,IF(F38<2.01,4,5))))","v":4}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},4,5,10,2,{"$f":"IF(F48<1.01,1,IF(F48<1.26,2,IF(F48<1.51,3,IF(F48<2.01,4,5))))","v":4}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},4,5,10,{"$f":"+E50/D50","v":2},4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},4,5,10,2,4]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},4,5,10,2,4]
[]
[]
["Incident Commander Performance"]
["Facility or Route","Hazard","Selected Jurisdiction Level ","Incident Commander Response Time Goal based on Tier Level",{"$f":"+CONCATENATE(\"Average Response Time for Incident Commander capable of responding at the Tier \",VLOOKUP(A23,A22:G25,8-D27,FALSE),\" to Arrive at Scene\")","v":"Average Response Time for Incident Commander capable of responding at the Tier 2 to Arrive at Scene"},"Percentage of Response Time Goal","Rescue Team [RTF]"]
[null,null,null,null,"min","min","%"]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B26","v":"Fire (Ethylene Oxide)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$18,$A$17:$G$20,8-$D$27,FALSE)","v":45},15,{"$f":"+E58/D58","v":0.33333333333333331},{"$f":"IF(F58<1.01,1,IF(F58<1.26,2,IF(F58<1.51,3,IF(F58<2.01,4,5))))","v":1}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B27","v":"Explosion (Ethylene Oxide)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$18,$A$17:$G$20,8-$D$27,FALSE)","v":45},15,0.33333333333333331,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B28","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+F$2","v":4},45,15,0.33333333333333331,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B29","v":"Toxic Gas (Chlorine) (S)"},{"$f":"+F$2","v":4},45,15,0.33333333333333331,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A30","v":"step 10-11 facility"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B30","v":"step 10 - 11 hazard"},{"$f":"+F$2","v":4},45,"step 17 value",{"$f":"+E62/D62","v":{"$error":"#VALUE!"}},{"$f":"IF(F62<1.01,1,IF(F62<1.26,2,IF(F62<1.51,3,IF(F62<2.01,4,5))))","v":{"$error":"#VALUE!"}}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$18,$A$17:$G$20,8-$D$27,FALSE)","v":45},30,{"$f":"+E63/D63","v":0.66666666666666663},{"$f":"IF(F63<1.01,1,IF(F63<1.26,2,IF(F63<1.51,3,IF(F63<2.01,4,5))))","v":1}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},4,45,30,0.66666666666666663,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},4,45,30,0.66666666666666663,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},4,45,30,0.66666666666666663,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},4,45,30,0.66666666666666663,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},4,45,15,0.33333333333333331,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},4,45,20,0.44444444444444442,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},4,45,20,0.44444444444444442,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},4,45,20,0.44444444444444442,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},4,45,20,0.44444444444444442,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},4,45,15,0.33333333333333331,{"$f":"IF(F73<1.01,1,IF(F73<1.26,2,IF(F73<1.51,3,IF(F73<2.01,4,5))))","v":1}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},4,45,15,0.33333333333333331,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},4,45,15,{"$f":"+E75/D75","v":0.33333333333333331},1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},4,45,15,0.33333333333333331,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},4,45,15,0.33333333333333331,1]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A46","v":"step 10-12 route"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B46","v":"step 10 - 11 hazard"},{"$f":"+F$2","v":4},45,"step 17 value",{"$f":"+E78/D78","v":{"$error":"#VALUE!"}},{"$f":"IF(F78<1.01,1,IF(F78<1.26,2,IF(F78<1.51,3,IF(F78<2.01,4,5))))","v":{"$error":"#VALUE!"}}]
[]
["Rescue Time Performance"]
["Facility or Route","Hazard","Selected Jurisdiction Level ","Rescue Team Response Time Goal based on Tier Level",{"$f":"CONCATENATE(\"Average Response Time for Rescue Team Capable of Rescuing \",VLOOKUP(A22,A22:G25,8-D27,FALSE), \" People/hr to Arrive at Scene\")","v":"Average Response Time for Rescue Team Capable of Rescuing 10 People/hr to Arrive at Scene"},"Percentage of Response Time Goal","Control Team [RTF]"]
[null,null,null,null,"min","min","%"]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B26","v":"Fire (Ethylene Oxide)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$19,$A$17:$G$20,8-$D$27,FALSE)","v":10},15,{"$f":"+E83/D83","v":1.5},{"$f":"IF(F83<1.01,1,IF(F83<1.26,2,IF(F83<1.51,3,IF(F83<2.01,4,5))))","v":3}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B27","v":"Explosion (Ethylene Oxide)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$19,$A$17:$G$20,8-$D$27,FALSE)","v":10},15,1.5,3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B28","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+F$2","v":4},10,15,1.5,3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B29","v":"Toxic Gas (Chlorine) (S)"},{"$f":"+F$2","v":4},10,15,1.5,3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A30","v":"step 10-11 facility"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B30","v":"step 10 - 11 hazard"},{"$f":"+F$2","v":4},10,15,{"$f":"+E87/D87","v":1.5},{"$f":"IF(F87<1.01,1,IF(F87<1.26,2,IF(F87<1.51,3,IF(F87<2.01,4,5))))","v":3}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$19,$A$17:$G$20,8-$D$27,FALSE)","v":10},45,{"$f":"+E88/D88","v":4.5},{"$f":"IF(F88<1.01,1,IF(F88<1.26,2,IF(F88<1.51,3,IF(F88<2.01,4,5))))","v":5}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},4,10,30,3,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},4,10,30,3,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},4,10,30,3,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},4,10,30,3,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},4,10,45,4.5,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A46","v":"step 10-12 route"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B46","v":"step 10 - 11 hazard"},{"$f":"+F$2","v":4},10,"step 17 value",{"$f":"+E103/D103","v":{"$error":"#VALUE!"}},{"$f":"IF(F103<1.01,1,IF(F103<1.26,2,IF(F103<1.51,3,IF(F103<2.01,4,5))))","v":{"$error":"#VALUE!"}}]
[]
["Control Team Time Performance"]
["Facility or Route","Hazard","Selected Jurisdiction Level ","Control Team Response Time Goal based on Tier Level",{"$f":"+CONCATENATE(\"Average Response Time for Tier Level \", VLOOKUP(A24,A22:G25,8-D27,FALSE),\" Control Team having access to \",VLOOKUP(A25,A22:G25,8-D27,FALSE),\" Tier 3/4 team to Arrive at Scene\")","v":"Average Response Time for Tier Level 2 Control Team having access to 1 Tier 3/4 team to Arrive at Scene"},"Percentage of Response Time Goal","Control Team [RTF]","Maximum [RTF]"]
[null,null,null,null,"min","min","%"]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B26","v":"Fire (Ethylene Oxide)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$20,$A$17:$G$20,8-$D$27,FALSE)","v":60},15,{"$f":"+E108/D108","v":0.25},{"$f":"IF(F108<1.01,1,IF(F108<1.26,2,IF(F108<1.51,3,IF(F108<2.01,4,5))))","v":1},{"$f":"MAX(G32,G58,G83,G108)","v":3}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B27","v":"Explosion (Ethylene Oxide)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$20,$A$17:$G$20,8-$D$27,FALSE)","v":60},15,0.25,1,3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B28","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+F$2","v":4},60,15,0.25,1,3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B29","v":"Toxic Gas (Chlorine) (S)"},{"$f":"+F$2","v":4},60,15,0.25,1,3]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A30","v":"step 10-11 facility"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B30","v":"step 10 - 11 hazard"},{"$f":"+F$2","v":4},60,"step 17 value",{"$f":"+E112/D112","v":{"$error":"#VALUE!"}},{"$f":"IF(F112<1.01,1,IF(F112<1.26,2,IF(F112<1.51,3,IF(F112<2.01,4,5))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},{"$f":"+F$2","v":4},{"$f":"VLOOKUP($A$20,$A$17:$G$20,8-$D$27,FALSE)","v":60},45,{"$f":"+E113/D113","v":0.75},{"$f":"IF(F113<1.01,1,IF(F113<1.26,2,IF(F113<1.51,3,IF(F113<2.01,4,5))))","v":1},5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},4,60,30,0.5,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},4,60,30,0.5,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},4,60,30,0.5,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},4,60,30,0.5,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},4,60,45,0.75,1,5]
[{"$f":"+'Steps 10 - 11  Pop Conseq'!A46","v":"step 10-12 route"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B46","v":"step 10 - 11 hazard"},4,60,"step 17 value",{"$f":"+E128/D128","v":{"$error":"#VALUE!"}},{"$f":"IF(F128<1.01,1,IF(F128<1.26,2,IF(F128<1.51,3,IF(F128<2.01,4,5))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]

{"sheet":"Step 19 Vulnerability","index":8,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[33,1,34,1],[33,2,34,2],[42,1,43,1],[42,2,43,2],[1,1,4,6],[6,1,7,6],[9,1,16,6],[18,1,18,6]]}
[]
[null,"The details of the Vulnerability Calculation are shown in Appendix B of the Guide.  The facility vulnerability calculation differs from the transportation vulnerability calculation because  whereas a facility is a known entity, hazmat vehicles can be traveling through the region and unless some type of survey is done, the assessor will have no knowledge of most hazmat shipments until a transportation accident occurs."]
[]
[]
[]
[]
[null,"The type, likelihood  and magnitude of a release from a facility can probably be obtained through discussions with the facility's safety manger.   Similar discussions could be held with pipeline personnel if there is a product or gas pipeline traversing the region.   "]
[]
[]
[null,"The vulnerability to a transportation accident depends on the total number of miles driven in the region for each type of hazardous material.  For rail, the assessor can ascertain the types of hazmat traveling through the area by asking railroad officials responsible  for the trains traversing the area.  For highway, there is no substitute for local knowledge obtained by monitoring hazardous material flows.  If such information has not been collected, one can always defer to the to the Hazardous Material Commodity Flow Survey Reports published by the Census Bureau.   For example if there is a major interstate running through the region, in the absence of all other knowledge, if the assessor  knows the number of  Class 3 hazmat trucks per day on a specific highway, for planning purposes one can estimate the number of class 8 vehicles passing on that highway by using the ratio of Class 3 to Class 8 from the Census report and applying the ratio to the known Class 3 shipments on that highway.   Clearly there is no substitute for good knowledge about hazmat flows in the region."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"As was the case with the previous tabs, the areas colored in light blue must be filled out by the assessor or assessment team.  "]
[]
[]
[null,"Vulnerability Calculation"]
[null,"See Discussion of Table 20 Vulnerability Levels in the Guide for additional details"]
[null,"Vulnerability Level","Numerical  Value","Approximate Likelihood Range/Year"]
[null,"Very High",5,">1 per year"]
[null,"High",4,"1 to 10-2"]
[null,"Moderate",3,"10-2 to 10-4"]
[null,"Low",2,"10-4 to 10-6"]
[null,"Very Low",1,"<10-6"]
[]
[null,"The Vulnerability Calculation Discussion can be found in Appendix B of the Guide"]
[null,"                            Cells shaded in blue must be calculated and filled in,",null,null," others calculated or passed from another worksheet"]
[null,"Facility Vulnerability Calculation"]
[null,"Facility or Route","Hazard","Y/N","Accident Release Probability","Vulnerability"]
[null,null,null,"[H]","1/year","[V]"]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},"Fire (Ethylene Oxide)",1,0.1,{"$f":"IF(E36>1,5,IF(E36>0.01,4,IF(E36>0.0001,3,IF(E36>0.000001,2,1))))","v":4}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},"Fire (Ethylene Oxide)",1,1.0000000000000001E-5,{"$f":"IF(E37>1,5,IF(E37>0.01,4,IF(E37>0.0001,3,IF(E37>0.000001,2,1))))","v":2}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},"Fire (Ethylene Oxide)",1,1E-3,3]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},"Fire (Ethylene Oxide)",1,0.1,{"$f":"IF(E39>1,5,IF(E39>0.01,4,IF(E39>0.0001,3,IF(E39>0.000001,2,1))))","v":4}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A30","v":"step 10-11 facility"},"Fire (Ethylene Oxide)","value step 19","value step 19",{"$f":"IF(E40>1,5,IF(E40>0.01,4,IF(E40>0.0001,3,IF(E40>0.000001,2,1))))","v":5}]
[]
[null,"Route Vulnerability"]
[null,"Facility or Route","Hazard","Y=1/N=0","Annual Number of Shipments","Total Trip Distance in Region","Accident Rate","Release (L or S) per Accident","Accident Release Probability","Vulner-ability"]
[null,null,null,"[H]","#","miles","1/106 miles","1/accident","1/year","[V]"]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},1,500,100,1.65,0.2,{"$f":"+E45*F45*G45*H45/1000000","v":1.6500000000000001E-2},{"$f":"IF(I45>1,5,IF(I45>0.01,4,IF(I45>0.0001,3,IF(I45>0.000001,2,1))))","v":4}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},1,100,40,1.65,0.01,6.6000000000000005E-5,2]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},1,100,40,1.65,0.02,1.3200000000000001E-4,3]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},1,25,60,1.65,0.01,2.4749999999999999E-5,2]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},1,25,60,1.65,0.02,4.9499999999999997E-5,2]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},1,200,50,3,0.2,6.0000000000000001E-3,3]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},1,12,25,1.65,0.2,9.8999999999999994E-5,2]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},1,25,60,1.65,0.01,2.4749999999999999E-5,2]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},1,25,60,1.65,0.02,4.9499999999999997E-5,2]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},1,100,30,1.65,0.2,9.8999999999999999E-4,3]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},1,80,40,1.65,0.01,5.2800000000000003E-5,2]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},1,80,40,1.65,0.02,1.0560000000000001E-4,3]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},1,250,100,3,0.02,1.5E-3,3]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},1,50,100,3,0.01,1.4999999999999999E-4,3]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},1,50,100,3,0.02,2.9999999999999997E-4,3]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A46","v":"step 10-12 route"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B46","v":"step 10 - 11 hazard"},"value step 19","value step 19","value step 19","value step 19","value step 19",{"$f":"+E60*F60*G60*H60/1000000","v":{"$error":"#VALUE!"}},{"$f":"IF(I60>1,5,IF(I60>0.01,4,IF(I60>0.0001,3,IF(I60>0.000001,2,1))))","v":{"$error":"#VALUE!"}}]

{"sheet":"Step 20 Risk ","index":9,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,8,9,8],[1,1,1,8],[3,1,4,8]]}
[]
[null,"If all the previous tabs have been completed, this result shown here are automatically calculated, no assessor input is required.  "]
[]
[null,"As stated in the introduction, there are two ways to use this form, one is to look at the individual columns and see which ones are high. In general, these might be areas for possible improvement.  The second use is to look at the high risk scenarios and identify ways to lower the risk levels for thise specific scenarios.    "]
[]
[]
[]
[]
[null,"Facility or Route","Hazard","Y/N","Vulner-ability","Consequence (Population / Environment)","Response Time Factor","Emergency Response Capacity","Risk Measure"]
[null,null,null,"[H]","[V]","[C]","[RCF]","[ERC]"]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A26","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B26","v":"Fire (Ethylene Oxide)"},{"$f":"+'Step 19 Vulnerability'!D45","v":1},{"$f":"+'Step 19 Vulnerability'!F36","v":4},{"$f":"+'Step 14 Max Conseq'!F31","v":2},{"$f":"+'Step 17 RTF'!H108","v":3},{"$f":"+'Step 16  ERC'!G33","v":1},{"$f":"ROUNDUP(+D11*E11*F11*G11*H11,0)","v":24}]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A27","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B27","v":"Explosion (Ethylene Oxide)"},{"$f":"+'Step 19 Vulnerability'!D46","v":1},{"$f":"+'Step 19 Vulnerability'!F37","v":2},{"$f":"+'Step 14 Max Conseq'!F32","v":3},{"$f":"+'Step 17 RTF'!H109","v":3},{"$f":"+'Step 16  ERC'!G34","v":1},18]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A28","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B28","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+'Step 19 Vulnerability'!D47","v":1},{"$f":"+'Step 19 Vulnerability'!F38","v":3},{"$f":"+'Step 14 Max Conseq'!F33","v":5},{"$f":"+'Step 17 RTF'!H110","v":3},{"$f":"+'Step 16  ERC'!G35","v":5},225]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A29","v":"Facility z"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B29","v":"Toxic Gas (Chlorine) (S)"},{"$f":"+'Step 19 Vulnerability'!D48","v":1},{"$f":"+'Step 19 Vulnerability'!F39","v":4},{"$f":"+'Step 14 Max Conseq'!F34","v":3},{"$f":"+'Step 17 RTF'!H111","v":3},{"$f":"+'Step 16  ERC'!G36","v":1},36,null,375]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A30","v":"step 10-11 facility"},null,null,null,null,null,null,null,null,250]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A31","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B31","v":"Fire  (Gasoline)"},{"$f":"+'Step 19 Vulnerability'!D45","v":1},{"$f":"+'Step 19 Vulnerability'!J45","v":4},{"$f":"+'Step 14 Max Conseq'!F36","v":2},{"$f":"+'Step 17 RTF'!H113","v":5},{"$f":"+'Step 16  ERC'!G38","v":1},40,null,225]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A32","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B32","v":"Toxic Gas (Ammonia) (L)"},{"$f":"+'Step 19 Vulnerability'!D46","v":1},{"$f":"+'Step 19 Vulnerability'!J46","v":2},{"$f":"+'Step 14 Max Conseq'!F37","v":5},{"$f":"+'Step 17 RTF'!H114","v":5},{"$f":"+'Step 16  ERC'!G39","v":5},250,null,75]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A33","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B33","v":"Toxic Gas (Ammonia) (S)"},{"$f":"+'Step 19 Vulnerability'!D47","v":1},{"$f":"+'Step 19 Vulnerability'!J47","v":3},{"$f":"+'Step 14 Max Conseq'!F38","v":3},{"$f":"+'Step 17 RTF'!H115","v":5},{"$f":"+'Step 16  ERC'!G40","v":1},45,null,50]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A34","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B34","v":"Toxic Liquid (37% HCl) (L)"},{"$f":"+'Step 19 Vulnerability'!D48","v":1},{"$f":"+'Step 19 Vulnerability'!J48","v":2},{"$f":"+'Step 14 Max Conseq'!F39","v":3},{"$f":"+'Step 17 RTF'!H116","v":5},{"$f":"+'Step 16  ERC'!G41","v":1},30,null,45]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A35","v":"Roads x"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B35","v":"Toxic Liquid (37% HCl) (S)"},{"$f":"+'Step 19 Vulnerability'!D49","v":1},{"$f":"+'Step 19 Vulnerability'!J49","v":2},{"$f":"+'Step 14 Max Conseq'!F40","v":3},{"$f":"+'Step 17 RTF'!H117","v":5},{"$f":"+'Step 16  ERC'!G42","v":1},{"$f":"ROUNDUP(+D20*E20*F20*G20*H20,0)","v":30},null,40]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A36","v":"Roads y"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B36","v":"Fire  (Gasoline)"},{"$f":"+'Step 19 Vulnerability'!D50","v":1},{"$f":"+'Step 19 Vulnerability'!J50","v":3},{"$f":"+'Step 14 Max Conseq'!F41","v":2},{"$f":"+'Step 17 RTF'!H118","v":5},{"$f":"+'Step 16  ERC'!G43","v":1},30,null,36]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A37","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B37","v":"Fire  (Gasoline)"},{"$f":"+'Step 19 Vulnerability'!D51","v":1},{"$f":"+'Step 19 Vulnerability'!J51","v":2},{"$f":"+'Step 14 Max Conseq'!F42","v":2},{"$f":"+'Step 17 RTF'!H119","v":5},{"$f":"+'Step 16  ERC'!G44","v":1},20,null,30]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A38","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B38","v":"Toxic Liquid (37% HCl) (L)"},{"$f":"+'Step 19 Vulnerability'!D52","v":1},{"$f":"+'Step 19 Vulnerability'!J52","v":2},{"$f":"+'Step 14 Max Conseq'!F43","v":3},{"$f":"+'Step 17 RTF'!H120","v":5},{"$f":"+'Step 16  ERC'!G45","v":1},30,null,24]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A39","v":"Roads u"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B39","v":"Toxic Liquid (37% HCl) (S)"},{"$f":"+'Step 19 Vulnerability'!D53","v":1},{"$f":"+'Step 19 Vulnerability'!J53","v":2},{"$f":"+'Step 14 Max Conseq'!F44","v":3},{"$f":"+'Step 17 RTF'!H121","v":5},{"$f":"+'Step 16  ERC'!G46","v":1},30,null,20]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A40","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B40","v":"Fire  (Gasoline)"},{"$f":"+'Step 19 Vulnerability'!D54","v":1},{"$f":"+'Step 19 Vulnerability'!J54","v":3},{"$f":"+'Step 14 Max Conseq'!F45","v":2},{"$f":"+'Step 17 RTF'!H122","v":5},{"$f":"+'Step 16  ERC'!G47","v":1},30,null,18]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A41","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B41","v":"Toxic Gas (Ammonia) (L)"},{"$f":"+'Step 19 Vulnerability'!D55","v":1},{"$f":"+'Step 19 Vulnerability'!J55","v":2},{"$f":"+'Step 14 Max Conseq'!F46","v":5},{"$f":"+'Step 17 RTF'!H123","v":5},{"$f":"+'Step 16  ERC'!G48","v":5},250,null,null,"this graph must be edited by hand "]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A42","v":"Road w"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B42","v":"Toxic Gas (Ammonia) (S)"},{"$f":"+'Step 19 Vulnerability'!D56","v":1},{"$f":"+'Step 19 Vulnerability'!J56","v":3},{"$f":"+'Step 14 Max Conseq'!F47","v":3},{"$f":"+'Step 17 RTF'!H124","v":5},{"$f":"+'Step 16  ERC'!G49","v":1},45,null,null,"using the risk measure data"]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A43","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B43","v":"BLEVE (Ethylene Oxide)"},{"$f":"+'Step 19 Vulnerability'!D57","v":1},{"$f":"+'Step 19 Vulnerability'!J57","v":3},{"$f":"+'Step 14 Max Conseq'!F48","v":3},{"$f":"+'Step 17 RTF'!H125","v":5},{"$f":"+'Step 16  ERC'!G50","v":1},45]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A44","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B44","v":"Toxic Gas (Chlorine) (L)"},{"$f":"+'Step 19 Vulnerability'!D58","v":1},{"$f":"+'Step 19 Vulnerability'!J58","v":3},{"$f":"+'Step 14 Max Conseq'!F49","v":5},{"$f":"+'Step 17 RTF'!H126","v":5},{"$f":"+'Step 16  ERC'!G51","v":5},375]
[null,{"$f":"+'Steps 10 - 11  Pop Conseq'!A45","v":"Railroad s"},{"$f":"+'Steps 10 - 11  Pop Conseq'!B45","v":"Toxic Gas (Chlorine)  (S)"},{"$f":"+'Step 19 Vulnerability'!D59","v":1},{"$f":"+'Step 19 Vulnerability'!J59","v":3},{"$f":"+'Step 14 Max Conseq'!F50","v":5},{"$f":"+'Step 17 RTF'!H127","v":5},{"$f":"+'Step 16  ERC'!G52","v":5},375]