{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Foreword","Project Level of Risk","Project Risk Documentation","RMP","RMP User's Guide","Assumptions","Contingency","High Risk","Medium Risk","Low Risk","Cost Ranges","Contingency ranges","RBS"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":51,"comments":0,"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":"Foreword","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Project Risk Management Plan Workbook (RMP) – Foreword"]
[]
["Project delivery success can be increased by establishing and maintaining a risk register over the project lifecycle.  The risk register will document identified risks and provides an analysis of the risk impact.  The register also serves as an active risk management tool that defines and tracks risk mitigation strategies and actions."]
[]
["It is the goal of MDT to intentionally manage risk on all design projects.  Project Risk Management can be scaled to fit each project.  "]
[]
["This workbook contains many tools for performing risk management.  Each tool is contained in a separate worksheet.  The primary tools are the Project Level of Risk table and the RMP.  The Project Level of Risk table is to be used for determining the potential for risk.  The RMP is the risk register and management document for capturing potential risk and associated mitigation.  The Risk Checklist is the risk register and tracking document for low risk projects."]
[]
["Please refer to the Project Risk Management Guidelines for more information on performing risk management and risk management requirements."]
[]
["Table of Contents"]
["Foreword"]
["Project Level of Risk table"]
["Project Risk Documentation form for LOW risk projects"]
["Risk Management Plan (RMP) worksheet"]
["RMP User's Guide"]
["Assumptions sheet"]
["Contingency"]
["Contingency ranges graph - all risk levels"]
["High Risk graph"]
["Medium Risk graph"]
["Low Risk graph"]
["Cost Ranges"]
["Risk Breakdown Structure table"]
[]
[]
[]
[]
["MDT would like to acknowledge WSDOT's efforts in Risk Management and extend our sincere appreciation for their willingness to share the knowledge, tools, and guidance used as the basis for this workbook."]

{"sheet":"Project Level of Risk","index":1,"n_rows":88,"n_cols":5,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Project Level of Risk"]
[]
[null,"Project Area","LOW RISK","MEDIUM RISK","HIGH RISK"]
[1,"Proposed Scope of Work","Preservation","Rehabilitation or reconstruction work with no added capacity","New highways; major relocations"]
[2,"Proposed Scope of Work","Overlay, minor widening, mill/fill","Minor roadway relocations","New interchanges"]
[3,"Proposed Scope of Work","Traffic signal rehabilitation","Slides, subsidence","Capacity adding/major widening"]
[4,"Proposed Scope of Work","Minor spot safety improvement","New facilities","Major reconstruction"]
[5,"Proposed Scope of Work","RR at grade crossings","Intersection safety improvement","New facilities "]
[6,"Proposed Scope of Work",null,"ADA work"]
[7,"Proposed Scope of Work",null,"New traffic signal installation"]
[8,"Proposed Scope of Work",null,"Experimental feature included that may cause design changes or project delay"]
[9,"Project Location and Local Coordination","Rural","Urban or rural","Urban or rural"]
[10,"Project Location and Local Coordination","Project included in local plan or Transportation Improvement Program (TIP)","Reservation","Controversial or complex City, County, or Tribal agreements needed"]
[11,"Project Location and Local Coordination",null,"City, County, or Tribal agreements needed","TIP or local plan coordination anticipated"]
[12,"Project Location and Local Coordination",null,"TIP or local plan coordination needed to ensure consistency"]
[13,"Funding Considerations","No unusual funding constraints or special funding attachments","UPP","NHPB"]
[14,"Funding Considerations",null,"STPB","STPU"]
[15,"Funding Considerations",null,"STPU","STPS – Reconstruction"]
[16,"Funding Considerations",null,"STPS – Pavement preservation only","TA – Complex projects"]
[17,"Funding Considerations",null,"TA","CMAQ – Reconstruction"]
[18,"Funding Considerations",null,"CMAQ","NHFP"]
[19,"Funding Considerations",null,"NHFP","Special funding (earmarks, program caps, discretionary)"]
[20,"Funding Considerations",null,"ER"]
[21,"Funding Considerations",null,"Special funding (includes local matching and multiple sources)"]
[22,"Work Zone Safety and Mobility","Level 3","Level 1 or 2","Level 1 (Significant)"]
[23,"Work Zone Safety and Mobility","Short construction duration","Moderate construction duration","Complex sequencing"]
[24,"Work Zone Safety and Mobility","Minimal traffic disruptions","Moderate traffic disruptions","Significant traffic disruptions"]
[25,"Work Zone Safety and Mobility",null,null,"Long-term detours"]
[26,"Topography","Flat terrain:","Rolling terrain: ","Mountainous terrain:"]
[27,"Topography","Generally flat, fairly flat","Flat and rolling or gently rolling","Gorges, steep terrain, confined area"]
[28,"Geotechnical Considerations","Little or no involvement","Geotechnical involvement:","Heavy geotechnical involvement with possible:"]
[29,"Geotechnical Considerations",null,"Roadway projects will require digouts or alignment changes","Retaining structures, complex bridge foundations, rock slopes, landslides, high seismic areas"]
[30,"Geotechnical Considerations",null,"Abutment work"]
[31,"Geotechnical Considerations",null,"No major geotechnical work, generally standard bridge foundations (driven piles)"]
[32,"Hydraulic Involvement","Little or no involvement","Location Hydraulics Study Report required","Major culvert replacements"]
[33,"Hydraulic Involvement",null,"Curb & Gutter with sump work","Bridge replacement – complex modelling"]
[34,"Hydraulic Involvement",null,"Culvert extensions or straightforward replacements","Extensive reports anticipated"]
[35,"Hydraulic Involvement",null,"Bridge surface runoff","Floodplain permits require additional mapping (CLOMR/LOMR)"]
[36,"Hydraulic Involvement",null,"Bridge replacement – not complex Floodplain permits may be required","Significant irrigation design and coordination"]
[37,"Hydraulic Involvement",null,"Some irrigation involvement"]
[38,"Bridge Work","No major bridge work","Bridge replacement or major rehabilitation","Complex bridge construction:"]
[39,"Bridge Work","Minor rail upgrades or surfacing treatments","Major deck rehabilitation ","Unusual or non-conventional design"]
[40,"Bridge Work",null,"Seismic retrofitting","Complex superstructure"]
[41,"Bridge Work",null,"Generally standard foundation work","Complex foundation work"]
[42,"Traffic Considerations","Standard striping and signing","Traffic or safety analysis needed","New flashing signs or traffic signals"]
[43,"Traffic Considerations",null,"Signal replacements/upgrades","Overhead signs"]
[44,"Traffic Considerations",null,"Lighting","Substantial intersection re-design, e.g. roundabout"]
[45,"Traffic Considerations",null,"Electrical work"]
[46,"Traffic Considerations",null,"Geometric design"]
[47,"Right-of-Way Involvement","Little or none","Right-of-Way (R/W) plans needed","Extensive R/W acquisition plans necessary"]
[48,"Right-of-Way Involvement","Construction permits only","R/W acquisition expected","Potential for condemnations"]
[49,"Right-of-Way Involvement","Notifications only","No claims or condemnation expected","Relocations or displacements "]
[50,"Right-of-Way Involvement","Maintain existing access control","Simple or no relocations or displacements","Reservation/Tribal involvement"]
[51,"Right-of-Way Involvement","Sidewalk or approach agreement","Access Control changes","New Access Control"]
[52,"Utilities Involvement","Little or none","Some utility relocations, most prior to construction","Major utility relocations"]
[53,"Utilities Involvement","Minor adjustments","No major utility relocations","Multiple utility coordination"]
[54,"Utilities Involvement","No relocations"]
[55,"Railroad Involvement","Low likelihood of requiring agreement","Occasional flagger involvement","RR flaggers at all times"]
[56,"Railroad Involvement",">50ft from Railroad (RR)","Project areas within 50ft of RR","Major RR agreement"]
[57,"Railroad Involvement",null,"Minor R/W or RR agreements possible","R/W acquisition and/or utility involvement with RR"]
[58,"Railroad Involvement",null,null,"Structure over RR facilities"]
[59,"Survey","Very little or none required","Design survey, control/or cadastral survey","Complex design survey requirements"]
[60,"Public Involvement","Level A","Level B","Level C"]
[61,"Public Involvement","No public controversy","Involvement of public, public officials, stakeholders and local agencies is moderate due to noncontroversial project type","Controversial (lack of consensus) and high profile projects"]
[62,"Public Involvement",null,"General communication about project progress is required","Local agency heavily involved"]
[63,"Public Involvement",null,null,"Major coordination among numerous stakeholders is required"]
[64,"Public Involvement",null,null,"Tribal involvement"]
[65,"Environmental Considerations","Listed Categorical Exclusion covered under Programmatic Agreement with FHWA.  (i.e., FHWA concurrence not required)","Non-listed Categorical Exclusion, Listed Categorical Exclusion not covered under the Programmatic Agreement with FHWA, or Build/No-build Environmental Assessment","Environmental Assessment with complex, multiple alternative analyses or Environment Impact Study "]
[66,"Environmental Considerations","·      Minimal oversight or regulation from external agencies","·      Cultural Resources (historical, archaeological) involvement","·      Full 4(f) Evaluation"]
[67,"Environmental Considerations","·      Minor environmental impacts","·      Section 106 determination of adverse effect ","·      Individual Section 404 Permit"]
[68,"Environmental Considerations",null,"·      De Minimis or Programmatic 4(f) Evaluation","·      Other agencies (such as FHWA, COE, EPA, USFWS, Fish, Wildlife & Parks, DEQ, DNRC) are heavily involved"]
[69,"Environmental Considerations",null,"·      Acquisition of land under the protection of LWCF (Section 6(f))","·      Traffic noise mitigation required"]
[70,"Environmental Considerations",null,"·      Section 404 Nationwide permit required","·      Threatened and Endangered Species USFWS formal consultation "]
[71,"Environmental Considerations",null,"·      May impact a designated or proposed Wild and Scenic River","·      Montana Sage Grouse Oversight Team approval or mitigation required"]
[72,"Environmental Considerations",null,"·      Traffic noise analysis required","·      Remediation of hazardous materials required"]
[73,"Environmental Considerations",null,"·      Threatened and Endangered Species USFWS informal consultation ","·      Compensatory wetland or stream mitigation required but not available"]
[74,"Environmental Considerations",null,"·      Bald and Golden Eagle Act conservation measures needed","·      Substantial Tribal involvement"]
[75,"Environmental Considerations",null,"·      Does not conform to State Implementation Plan for air quality"]
[76,"Environmental Considerations",null,"·      Compensatory wetland/stream mitigation required"]
[77,"Environmental Considerations",null,"·      SPA 124 notification"]
[78,"Environmental Considerations",null,"·      Likely presence of hazardous materials"]
[79,"Environmental Considerations",null,"·      Coordination with other State Agency commissions (e.g. river closures)"]
[80,"Environmental Considerations",null,"·      Migratory Bird Treaty Act conservation measures needed"]
[81,"Environmental Considerations",null,"·      Montana Sage Grouse consultation letter needed"]
[82,"Environmental Considerations",null,"·      Moderate Tribal involvement (e.g. ALCO permit)"]
[83,"Project Delivery","No anticipated concerns meeting ready date","Ready date is very close to planned finish date; project delivery could be delayed","Politically important; construction date promises or expectations; schedule delays are a concern"]
[84,"Project Delivery",null,"Accelerated schedule"]

{"sheet":"Project Risk Documentation","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Project Risk Documentation\nfor Low Risk Projects"]
[]
["Risk Review Participants:"]
[]
["Risk Review Date(s):"]
[]
[]
["Project Area","Potential High Risk Element from Risk Level Table","Threat or Opportunity","Risk Management Strategy","Active or Resolved"]
[]
[]
[]
[]
[]
["Project Area","Potential Medium Risk Element from Risk Level Table","Threat or Opportunity","Risk Management Strategy","Active or Resolved"]

{"sheet":"RMP","index":3,"n_rows":203,"n_cols":65,"rows_kept":203,"cut":false,"hidden":false,"merged":[[65,42,71,42],[71,19,71,23],[65,37,71,37],[65,41,71,41],[57,37,63,37],[63,19,63,23],[65,6,71,6],[70,36,71,36],[69,14,71,14],[66,7,70,7],[69,10,71,10],[65,9,71,9],[57,14,59,14],[57,9,63,9],[65,3,71,3],[65,39,71,39],[65,40,71,40],[69,16,71,16],[65,14,67,14],[65,8,71,8],[65,17,69,17],[61,16,63,16],[57,15,63,15],[65,10,67,10],[65,38,71,38],[65,15,71,15],[65,16,67,16],[61,10,63,10],[57,16,59,16],[65,11,71,11],[65,36,69,36],[41,41,47,41],[49,41,55,41],[57,41,63,41],[49,42,55,42],[41,42,47,42],[41,16,43,16],[45,16,47,16],[41,15,47,15],[49,11,55,11],[57,11,63,11],[49,14,51,14],[53,14,55,14],[53,16,55,16],[49,16,51,16],[25,42,31,42],[33,39,39,39],[33,40,39,40],[25,40,31,40],[25,41,31,41],[33,41,39,41],[25,39,31,39],[33,3,39,3],[25,14,27,14],[37,10,39,10],[33,8,39,8],[33,9,39,9],[33,14,35,14],[37,14,39,14],[25,11,31,11],[25,9,31,9],[33,11,39,11],[33,10,35,10],[33,42,39,42],[1,1,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[6,10,6,13],[2,6,2,7],[3,6,3,7],[5,1,5,5],[5,6,5,7],[4,10,4,13],[5,10,5,13],[4,6,4,7],[1,6,1,9],[2,10,2,13],[3,10,3,13],[1,10,1,16],[6,1,6,6],[1,19,6,23],[57,38,63,38],[49,37,55,37],[55,19,55,23],[7,15,7,23],[7,36,7,37],[25,37,31,37],[25,17,29,17],[41,17,45,17],[33,38,39,38],[49,38,55,38],[33,16,35,16],[37,16,39,16],[33,15,39,15],[7,38,7,40],[41,40,47,40],[41,39,47,39],[31,19,31,23],[39,19,39,23],[25,16,27,16],[57,36,61,36],[62,36,63,36],[49,40,55,40],[57,39,63,39],[57,1,63,1],[57,42,63,42],[49,39,55,39],[57,40,63,40],[57,6,63,6],[49,10,51,10],[57,17,61,17],[61,14,63,14],[54,36,55,36],[49,15,55,15],[49,17,53,17],[49,36,53,36],[53,10,55,10],[50,7,54,7],[57,8,63,8],[58,7,62,7],[49,8,55,8],[57,4,63,4],[49,9,55,9],[57,10,59,10],[57,3,63,3],[49,3,55,3],[8,17,8,23],[24,17,24,23],[41,38,47,38],[29,16,31,16],[33,17,37,17],[47,19,47,23],[41,37,47,37],[41,2,47,2],[25,38,31,38],[25,36,29,36],[30,36,31,36],[33,36,37,36],[38,36,39,36],[41,36,45,36],[33,37,39,37],[46,36,47,36],[41,8,47,8],[45,14,47,14],[41,9,47,9],[41,10,43,10],[8,24,8,28],[8,29,8,33],[7,1,7,9],[25,8,31,8],[29,5,31,5],[25,5,26,5],[25,6,31,6],[29,14,31,14],[25,2,31,2],[25,3,31,3],[42,7,46,7],[41,5,42,5],[26,7,30,7],[41,3,47,3],[7,10,7,14],[8,12,8,13],[25,10,27,10],[29,10,31,10],[41,6,47,6],[45,10,47,10],[41,14,43,14],[41,11,47,11],[33,2,39,2],[34,7,38,7],[35,5,39,5],[33,1,39,1],[73,41,79,41],[73,42,79,42],[73,17,77,17],[73,37,79,37],[73,38,79,38],[79,19,79,23],[73,39,79,39],[73,14,75,14],[73,15,79,15],[73,36,77,36],[78,36,79,36],[73,16,75,16],[73,40,79,40],[73,4,79,4],[73,11,79,11],[77,14,79,14],[77,16,79,16],[73,6,79,6],[73,8,79,8],[25,1,31,1],[41,1,47,1],[73,9,79,9],[73,10,75,10],[74,7,78,7],[77,10,79,10],[73,1,79,1],[73,2,79,2],[73,3,79,3],[49,6,55,6],[25,15,31,15],[33,5,34,5],[33,6,39,6],[65,1,71,1],[65,2,71,2],[49,1,55,1],[49,2,55,2],[57,2,63,2],[81,42,87,42],[81,17,85,17],[81,37,87,37],[81,38,87,38],[87,19,87,23],[85,14,87,14],[85,16,87,16],[81,39,87,39],[81,14,83,14],[81,15,87,15],[81,36,85,36],[86,36,87,36],[81,1,87,1],[81,2,87,2],[81,3,87,3],[81,5,82,5],[89,1,95,1],[89,2,95,2],[89,3,95,3],[89,5,90,5],[91,5,95,5],[89,4,95,4],[89,11,95,11],[81,6,87,6],[81,8,87,8],[89,42,95,42],[89,17,93,17],[89,37,95,37],[89,38,95,38],[95,19,95,23],[93,14,95,14],[93,16,95,16],[89,6,95,6],[89,8,95,8],[89,9,95,9],[89,10,91,10],[90,7,94,7],[93,10,95,10],[81,16,83,16],[81,40,87,40],[81,41,87,41],[81,9,87,9],[81,10,83,10],[82,7,86,7],[85,10,87,10],[81,11,87,11],[101,14,103,14],[101,16,103,16],[97,39,103,39],[97,14,99,14],[97,15,103,15],[97,16,99,16],[97,36,101,36],[102,36,103,36],[89,36,93,36],[94,36,95,36],[89,39,95,39],[89,14,91,14],[89,15,95,15],[89,16,91,16],[97,40,103,40],[97,41,103,41],[97,42,103,42],[97,17,101,17],[97,37,103,37],[97,38,103,38],[103,19,103,23],[89,40,95,40],[89,41,95,41],[105,11,111,11],[97,11,103,11],[105,1,111,1],[105,2,111,2],[105,3,111,3],[105,5,106,5],[107,5,111,5],[97,1,103,1],[97,2,103,2],[97,3,103,3],[97,5,98,5],[99,5,103,5],[97,6,103,6],[97,8,103,8],[97,9,103,9],[97,10,99,10],[98,7,102,7],[101,10,103,10],[105,6,111,6],[105,8,111,8],[105,9,111,9],[105,10,107,10],[106,7,110,7],[109,10,111,10],[105,14,107,14],[105,15,111,15],[105,41,111,41],[105,42,111,42],[105,17,109,17],[105,37,111,37],[105,38,111,38],[111,19,111,23],[105,36,109,36],[110,36,111,36],[105,16,107,16],[6,38,6,39],[6,41,6,42],[97,4,103,4],[105,4,111,4],[75,5,79,5],[73,5,74,5],[25,4,31,4],[33,4,39,4],[41,4,47,4],[49,4,55,4],[65,4,71,4],[43,5,47,5],[49,5,50,5],[59,5,63,5],[51,5,55,5],[57,5,58,5],[83,5,87,5],[81,4,87,4],[65,5,66,5],[67,5,71,5],[105,39,111,39],[105,40,111,40],[109,14,111,14],[109,16,111,16]]}
[]
[null,"Project No. and Name",null,null,null,null,"STPP 99-1(29)5\nNE of Montana Line - N.",null,null,null,"RISK MANAGEMENT SUMMARY RESULTS",null,null,null,null,null,null,"# Risks Identified","RELATIVE\nRISK","Proactive Risk Management: Develop an action response strategy; assign risk owners to implement action; monitor and record effectiveness of the risk response action.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk Breakdown Structure                               (functional assignment)","Planned Response Cost","Likely Cost Avoidance","Risk Breakdown Structure                               (functional assignment)","Planned Response Cost","Likely Cost Avoidance"]
[null,"Estimate Date ",null,null,null,null,"2008-09-23",null,"Target letting date","2011-05-01","Planned and Actual",null,null,null,"MIN","MAX","LIKELY",null,{"$f":"(R115+S115)/R3","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Right-of-Way",{"$f":"AX114","v":0},{"$f":"AY114","v":0},"Stakeholders",{"$f":"BF114","v":0},{"$f":"BG114","v":0}]
[null,"Project UPN ",null,null,null,null,"UPN",null,"Estimated Constr. Duration",1,"Planned Cost to Respond",null,null,null,null,null,{"$f":"AR116","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Environmental",{"$f":"AZ114","v":0},{"$f":"BA114","v":0},"Unforeseen Events",{"$f":"BH114","v":0},{"$f":"BI114","v":0}]
[null,"Last Review Date",null,null,null,null,{"$f":"TODAY()","v":"2018-07-06"},null,"Estimated PE Cost",1,"Est. $ of Cost Avoided (via risk management)",null,null,null,{"$f":"AS114","v":0},{"$f":"AS115","v":0},{"$f":"AS116","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineering",{"$f":"BB114","v":0},{"$f":"BC114","v":0},"Market Conditions",{"$f":"BJ114","v":0},{"$f":"BK114","v":0}]
[null,"Project Manager",null,null,null,null,"Joe Designer",null,"Estimated R/W Cost",1,"Actual Cost to Respond",null,null,null,null,null,{"$f":"AT116","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic",{"$f":"BD114","v":0},{"$f":"BE114","v":0},"Utilities",{"$f":"BL114","v":0},{"$f":"BM114","v":0}]
[null,"NOTE:  All costs in $",null,null,null,null,null,"M","Estimated CN Cost",1,"Est. Actual $ Cost Avoided (via risk mgmt)",null,null,null,{"$f":"AU114","v":0},{"$f":"AU115","v":0},{"$f":"AU116","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Monetary Impact of\n Signficant Project Risks",{"$f":"SUM(O34,O42,O50,O58,O66,O74,O82,O90,O98,O106)","v":0},null,"Estimated Time Impact of\n Signficant Project Risks",{"$f":"SUM(O38,O46,O54,O62,O70,O78,O86,O94,O102,O110)","v":0},null,"Response Cost & Cost Avoidance                            (based on most likely values)",null,null,null,null,null,"Filter"]
[null,"Risk Identification",null,null,null,null,null,null,null,null,"Quantitative Analysis",null,null,null,null,"Qualitative Display of Most Likely Impact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Response",null,"Monitoring and Control",null,null,"Critical Issue",null,"Estimated Response $ Entered","Calculated Est. Cost Avoidance","Actual Response $ Entered","Calculated Actual Cost Avoidance",null,null,{"$f":"D10","v":"ROW"},null,{"$f":"D11","v":"ENV"},null,{"$f":"D12","v":"ENG"},null,{"$f":"D13","v":"TRF"},null,{"$f":"D14","v":"STK"},null,{"$f":"D15","v":"UNF"},null,{"$f":"D16","v":"MKT"},null,{"$f":"D17","v":"UTL"}]
[null,"Risk #","Status","RBS Group","RBS Code Number","Project Phase | Date Identified","Functional Assignment","Summary Description Threat and/or Opportunity","Description of Risk Event                                                                  (Cause-Risk-Impact)      \n   \nClearly state the cause, the risk, and the impact.                       ","Risk Trigger","Type","Probability","Risk Impact                          ($K or M)\n(Month)",null,"Expected Impact ($K)                                                                            [most likely X probability]","Probability","Impact","Risk Matrix",null,null,null,null,null,null,"relative impact of COSTS",null,null,null,null,"SCHEDULES",null,null,null,null,"Threats","Opportunities"," Priority  |           Strategy","Response Actions \nACTION TO BE TAKEN\n including advantages and disadvantages include date","Risk Response Owner","Risk Review Dates","Date, Status, and Review Comments (Do not delete prior comments, therefore providing a history)"," Near or Long Term?",null,"Planned Cost to Respond [$K or M]                                               (enter single number estimate)","Est Cost Avoided [$K/M]                          (Expected Value of Risk) - (Est. Cost to Respond)","Actual Cost to Respond [$K or M]","Est. Actual Costs Avoided [$K or M]",null,"Project activitiy","Planned Response Cost","Est Cost Avoidance","Planned Response Cost","Est Cost Avoidance","Planned Response Cost","Est Cost Avoidance","Planned Response Cost","Est Cost Avoidance","Planned Response Cost","Est Cost Avoidance","Planned Response Cost","Est Cost Avoidance","Planned Response Cost","Est Cost Avoidance","Planned Response Cost","Est Cost Avoidance"]
[null,null,"Active","ROW",null,"Planning","Bridge","Threat","Zero",0,null,0.8,"Positive correlation",null,{"$f":"0.1*$J$7","v":0.1},"Very High","Very High",null,{"$f":"0.3*(J$4+(J$3-G$3)/30.5)","v":9.6442622950819672},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avoid",null,null,null,null,"NEAR",null,null,null,null,null,null,"ENG Doc. Pkg"]
[null,null,"Dormant","ENV",null,"Survey","Consult.","Opportunity","Positive",1,"Schedule",0.6,"Negative correlation",null,{"$f":"0.05*$J$7","v":0.05},"High","High",null,{"$f":"0.25*(J$4+(J$3-G$3)/30.5)","v":8.0368852459016402},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfer",null,null,null,null,"LONG",null,null,null,null,null,null,"NEPA/SEPA Re-evaluation"]
[null,null,"Retired","ENG",null,"Design","TA",null,"Negative",null,"Cost",0.4,null,null,{"$f":"0.02*$J$7","v":0.02},"Medium","Medium",null,{"$f":"0.15*(J$4+(J$3-G$3)/30.5)","v":4.8221311475409836},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mitigate",null,null,null,null,null,null,null,null,null,null,null,"ROW Plan and Approval "]
[null,null,null,"TRF",null,"ROW","District",null,null,null,null,0.2,null,null,{"$f":"0.008*$J$7","v":8.0000000000000002E-3},"Low","Low",null,{"$f":"0.1*(J$4+(J$3-G$3)/30.5)","v":3.2147540983606562},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accept",null,null,null,null,null,null,null,null,null,null,null,"Final Wetland Mit. Report"]
[null,null,null,"STK",null,"Construction","Environmental",null,"K",null,null,0,null,null,{"$f":"0.005*$J$7","v":5.0000000000000001E-3},"Very Low","Very Low",null,{"$f":"0.05*(J$4+(J$3-G$3)/30.5)","v":1.6073770491803281},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exploit",null,null,null,null,null,null,null,null,null,null,null,"Permitting "]
[null,null,null,"UNF",null,null,"Helena",null,"M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Share"]
[null,null,null,"MKT",null,null,"MSU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enhance"]
[null,null,null,"UTL",null,null,"Safety"]
[null,null,null,null,null,null,"Traffic"]
[null,null,null,null,null,null,"R/W"]
[null,null,null,null,null,null,"Utilities"]
[null,null,null,null,null,null,"Geotech"]
[null,null,null,null,null,null,"Survey"]
[null,null,null,null,null,null,"Construction"]
[null,null,null,null,null,null,"Legal"]
[null,"(1)","(2)","(3)","(3a)","(4)","(5)","(6)","(7)","(8)","(9)","(10)","(11)","(11a)","(12)","(13)","(14)","(15)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(16)","(17)","(18)","(19)","(20)","(21)",null,"(22)","(23)","(24)","(25)",null,"PSE"]
[null,"EXAMPLE","Active","ROW",3,"2010-02-13","Design","Threat","Because the mitigation ratio has not been finalized and there could be additional impacts to wetlands, the amount of R/W needed for the mitigation area may significantly increase, resulting in additional R/W costs and potential acquisition delays.","If Wetland impact is larger than 1/2 acre and ratio exceeds 4:1.","Cost",0.7,"MIN",1,{"$f":"IF(C26=\"Retired\",0,L26*(N26+4*N28+N27)/6)","v":4.7833333333333332},{"$f":"IF(C26=\"Retired\",\"NO RISK\",IF(L26>(L$10-0.01),P$10,IF(L26>(L$11-0.01),P$11,IF(L26>(L$12-0.01),P$12,IF(L26>(L$13-0.01),P$13,IF(L26>(L$14),P$14,\"NO RISK\"))))))","v":"High"},{"$f":"IF(C26=\"Retired\",\"NO RISK\",IF(ABS(N28)>O$10,Q$10,IF(ABS(N28)>O$11,Q$11,IF(ABS(N28)>O$12,Q$12,IF(ABS(N28)>O$13,Q$13,IF(ABS(N28)>O$14,Q$14,\"NO RISK\"))))))","v":"Very High"},"Probability","VH",{"$f":"IF(AND(Q26=\"VERY LOW\",Q30=\"very low\",P26=\"VERY high\"),\"$,Mo\",IF(AND(Q26=\"VERY LOW\",P26=\"VERY high\"),\"$\",IF(AND(Q30=\"very low\",P26=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"LOW\",Q30=\"low\",P26=\"VERY high\"),\"$,Mo\",IF(AND(Q26=\"LOW\",P26=\"VERY high\"),\"$\",IF(AND(Q30=\"low\",P26=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"medium\",Q30=\"medium\",P26=\"VERY high\"),\"$,Mo\",IF(AND(Q26=\"medium\",P26=\"VERY high\"),\"$\",IF(AND(Q30=\"medium\",P26=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"high\",Q30=\"high\",P26=\"VERY high\"),\"$,Mo\",IF(AND(Q26=\"high\",P26=\"VERY high\"),\"$\",IF(AND(Q30=\"high\",P26=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"VERY high\",Q30=\"VERY high\",P26=\"VERY high\"),\"$,Mo\",IF(AND(Q26=\"VERY high\",P26=\"VERY high\"),\"$\",IF(AND(Q30=\"VERY high\",P26=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T26=\"$\",(T26=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U26=\"$\",(U26=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V26=\"$\",(V26=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W26=\"$\",(W26=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X26=\"$\",(X26=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T26=\"Mo\",(T26=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U26=\"Mo\",(U26=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V26=\"Mo\",(V26=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W26=\"Mo\",(W26=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X26=\"Mo\",(X26=\"$,Mo\")),60,0)","v":0},null,null,"Avoid","Finalize design to identify all wetlands that are impacted.  Early coordination with the outside agencies to determine mitigation ratio.","Design Leader/Enviro. mgr","2006-Dec-2        2007-Jan-2","As of Nov. 15, 2005 there are only two potential areas where there could be additional wetland impacts. As of Dec. 2, 2005 agency has initially determined that mitigation ration would be 4:1.","NEAR","EXAMPLE",null,{"$f":"IF(AK26=\"Accept\",0,(N26*L26)-AR28)","v":0.7},null,{"$f":"IF(AT28=0,0,(N26*L26)-AT28)","v":0},{"$f":"O26-AT28","v":4.7833333333333332},"PSE - Nooksack River Bridge",{"$f":"IF($D26=\"ROW\",$AR28,\" \")","v":0},{"$f":"IF($D26=\"ROW\",$AS28,\" \")","v":4.8999999999999995},{"$f":"IF($D26=\"ENV\",$AR28,\" \")","v":" "},{"$f":"IF($D26=\"ENV\",$AS28,\" \")","v":" "},{"$f":"IF($D26=\"ENG\",$AR28,\" \")","v":" "},{"$f":"IF($D26=\"ENG\",$AS28,\" \")","v":" "},{"$f":"IF($D26=\"TRF\",$AR28,\" \")","v":" "},{"$f":"IF($D26=\"TRF\",$AS28,\" \")","v":" "},{"$f":"IF($D26=\"STK\",$AR28,\" \")","v":" "},{"$f":"IF($D26=\"STK\",$AS28,\" \")","v":" "},{"$f":"IF($D26=\"UNF\",$AR28,\" \")","v":" "},{"$f":"IF($D26=\"UNF\",$AS28,\" \")","v":" "},{"$f":"IF($D26=\"MKT\",$AR28,\" \")","v":" "},{"$f":"IF($D26=\"MKT\",$AS28,\" \")","v":" "},{"$f":"IF($D26=\"UTL\",$AR28,\" \")","v":" "},{"$f":"IF($D26=\"UTL\",$AS28,\" \")","v":" "}]
[null,null,null,null,null,null,null,"Wetland mitigation may require additional R/W",null,null,null,null,"MAX",12,null,null,null,null,"H",{"$f":"IF(AND(Q26=\"VERY LOW\",Q30=\"very low\",P26=\"high\"),\"$,Mo\",IF(AND(Q26=\"VERY LOW\",P26=\"high\"),\"$\",IF(AND(Q30=\"very low\",P26=\"high\"),\"Mo\",\"\")))","v":"Mo"},{"$f":"IF(AND(Q26=\"LOW\",Q30=\"low\",P26=\"high\"),\"$,Mo\",IF(AND(Q26=\"LOW\",P26=\"high\"),\"$\",IF(AND(Q30=\"low\",P26=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"medium\",Q30=\"medium\",P26=\"high\"),\"$,Mo\",IF(AND(Q26=\"medium\",P26=\"high\"),\"$\",IF(AND(Q30=\"medium\",P26=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"high\",Q30=\"high\",P26=\"high\"),\"$,Mo\",IF(AND(Q26=\"high\",P26=\"high\"),\"$\",IF(AND(Q30=\"high\",P26=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"VERY high\",Q30=\"VERY high\",P26=\"high\"),\"$,Mo\",IF(AND(Q26=\"VERY high\",P26=\"high\"),\"$\",IF(AND(Q30=\"VERY high\",P26=\"high\"),\"Mo\",\"\")))","v":"$"},{"$f":"IF(OR(T27=\"$\",(T27=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U27=\"$\",(U27=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V27=\"$\",(V27=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W27=\"$\",(W27=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X27=\"$\",(X27=\"$,Mo\")),64,0)","v":64},{"$f":"IF(OR(T27=\"Mo\",(T27=\"$,Mo\")),4,0)","v":4},{"$f":"IF(OR(U27=\"Mo\",(U27=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V27=\"Mo\",(V27=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W27=\"Mo\",(W27=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X27=\"Mo\",(X27=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O26>0,O26,0)","v":4.7833333333333332},{"$f":"IF(O26<0,O26,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK26=\"Accept\",0,(N27*L26)-AR28)","v":8.3999999999999986},null,{"$f":"IF(AT28=0,0,(N27*L26)-AT28)","v":0},null,"ROW Acquisition/Relocation - South section & Nooksack","EXAMPLE                                    EXAMPLE                                                EXAMPLE                                                  EXAMPLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",7,null,null,null,null,"M",{"$f":"IF(AND(Q26=\"VERY LOW\",Q30=\"very low\",P26=\"medium\"),\"$,Mo\",IF(AND(Q26=\"VERY LOW\",P26=\"medium\"),\"$\",IF(AND(Q30=\"very low\",P26=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"LOW\",Q30=\"low\",P26=\"medium\"),\"$,Mo\",IF(AND(Q26=\"LOW\",P26=\"medium\"),\"$\",IF(AND(Q30=\"low\",P26=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"medium\",Q30=\"medium\",P26=\"medium\"),\"$,Mo\",IF(AND(Q26=\"medium\",P26=\"medium\"),\"$\",IF(AND(Q30=\"medium\",P26=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"high\",Q30=\"high\",P26=\"medium\"),\"$,Mo\",IF(AND(Q26=\"high\",P26=\"medium\"),\"$\",IF(AND(Q30=\"high\",P26=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"VERY high\",Q30=\"VERY high\",P26=\"medium\"),\"$,Mo\",IF(AND(Q26=\"VERY high\",P26=\"medium\"),\"$\",IF(AND(Q30=\"VERY high\",P26=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T28=\"$\",(T28=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U28=\"$\",(U28=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V28=\"$\",(V28=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W28=\"$\",(W28=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X28=\"$\",(X28=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T28=\"Mo\",(T28=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U28=\"Mo\",(U28=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V28=\"Mo\",(V28=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W28=\"Mo\",(W28=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X28=\"Mo\",(X28=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK26=\"Accept\",0,(N28*L26)-AR28)","v":4.8999999999999995},null,{"$f":"IF(AT28=0,0,(N28*L26)-AT28)","v":0},null,"ROW Acquisition/Relocation - North section"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q26=\"VERY LOW\",Q30=\"very low\",P26=\"LOW\"),\"$,Mo\",IF(AND(Q26=\"VERY LOW\",P26=\"LOW\"),\"$\",IF(AND(Q30=\"very low\",P26=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"LOW\",Q30=\"low\",P26=\"LOW\"),\"$,Mo\",IF(AND(Q26=\"LOW\",P26=\"LOW\"),\"$\",IF(AND(Q30=\"low\",P26=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"medium\",Q30=\"medium\",P26=\"LOW\"),\"$,Mo\",IF(AND(Q26=\"medium\",P26=\"LOW\"),\"$\",IF(AND(Q30=\"medium\",P26=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"high\",Q30=\"high\",P26=\"LOW\"),\"$,Mo\",IF(AND(Q26=\"high\",P26=\"LOW\"),\"$\",IF(AND(Q30=\"high\",P26=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"VERY high\",Q30=\"VERY high\",P26=\"low\"),\"$,Mo\",IF(AND(Q26=\"VERY high\",P26=\"low\"),\"$\",IF(AND(Q30=\"VERY high\",P26=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T29=\"$\",(T29=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U29=\"$\",(U29=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V29=\"$\",(V29=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W29=\"$\",(W29=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X29=\"$\",(X29=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T29=\"Mo\",(T29=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U29=\"Mo\",(U29=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V29=\"Mo\",(V29=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W29=\"Mo\",(W29=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X29=\"Mo\",(X29=\"$,Mo\")),32,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ad / Bid / Award - South Section"]
[null,null,null,null,null,"Design",null,null,null,null,"Schedule",null,"MIN",0,{"$f":"IF(C26=\"Retired\",0,L26*(N30+4*N32+N31)/6)","v":1.8666666666666665},null,{"$f":"IF(C26=\"Retired\",\"NO RISK\",IF(ABS(N32)>S$10,Q$10,IF(ABS(N32)>S$11,Q$11,IF(ABS(N32)>S$12,Q$12,IF(ABS(N32)>S$13,Q$13,IF(ABS(N32)>S$14,Q$14,\"NO RISK\"))))))","v":"Very Low"},null,"VL",{"$f":"IF(AND(Q26=\"VERY LOW\",Q30=\"very low\",P26=\"VERY LOW\"),\"$,Mo\",IF(AND(Q26=\"VERY LOW\",P26=\"VERY LOW\"),\"$\",IF(AND(Q30=\"very low\",P26=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"LOW\",Q30=\"low\",P26=\"VERY LOW\"),\"$,Mo\",IF(AND(Q26=\"LOW\",P26=\"VERY LOW\"),\"$\",IF(AND(Q30=\"low\",P26=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"medium\",Q30=\"medium\",P26=\"VERY LOW\"),\"$,Mo\",IF(AND(Q26=\"medium\",P26=\"VERY LOW\"),\"$\",IF(AND(Q30=\"medium\",P26=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"high\",Q30=\"high\",P26=\"VERY LOW\"),\"$,Mo\",IF(AND(Q26=\"high\",P26=\"VERY LOW\"),\"$\",IF(AND(Q30=\"high\",P26=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q26=\"VERY high\",Q30=\"VERY high\",P26=\"VERY LOW\"),\"$,Mo\",IF(AND(Q26=\"VERY high\",P26=\"VERY LOW\"),\"$\",IF(AND(Q30=\"VERY high\",P26=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T30=\"$\",(T30=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U30=\"$\",(U30=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V30=\"$\",(V30=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W30=\"$\",(W30=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X30=\"$\",(X30=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T30=\"Mo\",(T30=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U30=\"Mo\",(U30=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V30=\"Mo\",(V30=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W30=\"Mo\",(W30=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X30=\"Mo\",(X30=\"$,Mo\")),16,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ad / Bid / Award - North Section"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",4,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y26:AC30)","v":64},null,null,null,null,{"$f":"SUM(AD26:AH30)","v":4},null,null,{"$f":"IF(O30>0,O30,0)","v":1.8666666666666665},{"$f":"IF(O30<0,O30,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Utility Agreements & Relocation - South Section"]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",3,null,null,null,{"$f":"AA31","v":64},{"$f":"AF31","v":4},"Impact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utility Agreements & Relocation - North Section"]
[null,null,null,null,null,null,null,null,null,null,null,0.9]
[null,1,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C34=\"Retired\",0,L34*(N36))","v":0},{"$f":"IF(C34=\"Retired\",\"NO RISK\",IF(L34>(L$10-0.01),P$10,IF(L34>(L$11-0.01),P$11,IF(L34>(L$12-0.01),P$12,IF(L34>(L$13-0.01),P$13,IF(L34>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C34=\"Retired\",\"NO RISK\",IF(ABS(N36)>O$10,Q$10,IF(ABS(N36)>O$11,Q$11,IF(ABS(N36)>O$12,Q$12,IF(ABS(N36)>O$13,Q$13,IF(ABS(N36)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q34=\"VERY LOW\",Q38=\"very low\",P34=\"VERY high\"),\"$,Mo\",IF(AND(Q34=\"VERY LOW\",P34=\"VERY high\"),\"$\",IF(AND(Q38=\"very low\",P34=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"LOW\",Q38=\"low\",P34=\"VERY high\"),\"$,Mo\",IF(AND(Q34=\"LOW\",P34=\"VERY high\"),\"$\",IF(AND(Q38=\"low\",P34=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"medium\",Q38=\"medium\",P34=\"VERY high\"),\"$,Mo\",IF(AND(Q34=\"medium\",P34=\"VERY high\"),\"$\",IF(AND(Q38=\"medium\",P34=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"high\",Q38=\"high\",P34=\"VERY high\"),\"$,Mo\",IF(AND(Q34=\"high\",P34=\"VERY high\"),\"$\",IF(AND(Q38=\"high\",P34=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"VERY high\",Q38=\"VERY high\",P34=\"VERY high\"),\"$,Mo\",IF(AND(Q34=\"VERY high\",P34=\"VERY high\"),\"$\",IF(AND(Q38=\"VERY high\",P34=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T34=\"$\",(T34=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U34=\"$\",(U34=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V34=\"$\",(V34=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W34=\"$\",(W34=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X34=\"$\",(X34=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T34=\"Mo\",(T34=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U34=\"Mo\",(U34=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V34=\"Mo\",(V34=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W34=\"Mo\",(W34=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X34=\"Mo\",(X34=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK34=\"Acceptance\",0,(N34*L34)-AR36)","v":0},null,{"$f":"IF(AT36=0,0,(N34*L34)-AT36)","v":0},{"$f":"O34-AT34","v":0},"Bridge Construction",{"$f":"IF($D34=\"ROW\",$AR36,\" \")","v":" "},{"$f":"IF($D34=\"ROW\",$AS36,\" \")","v":" "},{"$f":"IF($D34=\"ENV\",$AR36,\" \")","v":" "},{"$f":"IF($D34=\"ENV\",$AS36,\" \")","v":" "},{"$f":"IF($D34=\"ENG\",$AR36,\" \")","v":" "},{"$f":"IF($D34=\"ENG\",$AS36,\" \")","v":" "},{"$f":"IF($D34=\"TRF\",$AR36,\" \")","v":" "},{"$f":"IF($D34=\"TRF\",$AS36,\" \")","v":" "},{"$f":"IF($D34=\"STK\",$AR36,\" \")","v":" "},{"$f":"IF($D34=\"STK\",$AS36,\" \")","v":" "},{"$f":"IF($D34=\"UNF\",$AR36,\" \")","v":" "},{"$f":"IF($D34=\"UNF\",$AS36,\" \")","v":" "},{"$f":"IF($D34=\"MKT\",$AR36,\" \")","v":" "},{"$f":"IF($D34=\"MKT\",$AS36,\" \")","v":" "},{"$f":"IF($D34=\"UTL\",$AR36,\" \")","v":" "},{"$f":"IF($D34=\"UTL\",$AS36,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q34=\"VERY LOW\",Q38=\"very low\",P34=\"high\"),\"$,Mo\",IF(AND(Q34=\"VERY LOW\",P34=\"high\"),\"$\",IF(AND(Q38=\"very low\",P34=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"LOW\",Q38=\"low\",P34=\"high\"),\"$,Mo\",IF(AND(Q34=\"LOW\",P34=\"high\"),\"$\",IF(AND(Q38=\"low\",P34=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"medium\",Q38=\"medium\",P34=\"high\"),\"$,Mo\",IF(AND(Q34=\"medium\",P34=\"high\"),\"$\",IF(AND(Q38=\"medium\",P34=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"high\",Q38=\"high\",P34=\"high\"),\"$,Mo\",IF(AND(Q34=\"high\",P34=\"high\"),\"$\",IF(AND(Q38=\"high\",P34=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"VERY high\",Q38=\"VERY high\",P34=\"high\"),\"$,Mo\",IF(AND(Q34=\"VERY high\",P34=\"high\"),\"$\",IF(AND(Q38=\"VERY high\",P34=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T35=\"$\",(T35=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U35=\"$\",(U35=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V35=\"$\",(V35=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W35=\"$\",(W35=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X35=\"$\",(X35=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T35=\"Mo\",(T35=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U35=\"Mo\",(U35=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V35=\"Mo\",(V35=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W35=\"Mo\",(W35=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X35=\"Mo\",(X35=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O34>0,O34,0)","v":0},{"$f":"IF(O34<0,O34,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK34=\"Acceptance\",0,(N35*L34)-AR36)","v":0},null,{"$f":"IF(AT36=0,0,(N35*L34)-AT36)","v":0},null,"ROW Plan/Utility/Ad/Bid/Award/CN - Nooksack River Bridge ","RISK 1  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q34=\"VERY LOW\",Q38=\"very low\",P34=\"medium\"),\"$,Mo\",IF(AND(Q34=\"VERY LOW\",P34=\"medium\"),\"$\",IF(AND(Q38=\"very low\",P34=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"LOW\",Q38=\"low\",P34=\"medium\"),\"$,Mo\",IF(AND(Q34=\"LOW\",P34=\"medium\"),\"$\",IF(AND(Q38=\"low\",P34=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"medium\",Q38=\"medium\",P34=\"medium\"),\"$,Mo\",IF(AND(Q34=\"medium\",P34=\"medium\"),\"$\",IF(AND(Q38=\"medium\",P34=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"high\",Q38=\"high\",P34=\"medium\"),\"$,Mo\",IF(AND(Q34=\"high\",P34=\"medium\"),\"$\",IF(AND(Q38=\"high\",P34=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"VERY high\",Q38=\"VERY high\",P34=\"medium\"),\"$,Mo\",IF(AND(Q34=\"VERY high\",P34=\"medium\"),\"$\",IF(AND(Q38=\"VERY high\",P34=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T36=\"$\",(T36=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U36=\"$\",(U36=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V36=\"$\",(V36=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W36=\"$\",(W36=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X36=\"$\",(X36=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T36=\"Mo\",(T36=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U36=\"Mo\",(U36=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V36=\"Mo\",(V36=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W36=\"Mo\",(W36=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X36=\"Mo\",(X36=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK34=\"Acceptance\",0,(N36*L34)-AR36)","v":0},null,{"$f":"IF(AT36=0,0,(N36*L34)-AT36)","v":0},null,"Roadway Construction - North Section "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q34=\"VERY LOW\",Q38=\"very low\",P34=\"LOW\"),\"$,Mo\",IF(AND(Q34=\"VERY LOW\",P34=\"LOW\"),\"$\",IF(AND(Q38=\"very low\",P34=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"LOW\",Q38=\"low\",P34=\"LOW\"),\"$,Mo\",IF(AND(Q34=\"LOW\",P34=\"LOW\"),\"$\",IF(AND(Q38=\"low\",P34=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"medium\",Q38=\"medium\",P34=\"LOW\"),\"$,Mo\",IF(AND(Q34=\"medium\",P34=\"LOW\"),\"$\",IF(AND(Q38=\"medium\",P34=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"high\",Q38=\"high\",P34=\"LOW\"),\"$,Mo\",IF(AND(Q34=\"high\",P34=\"LOW\"),\"$\",IF(AND(Q38=\"high\",P34=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"VERY high\",Q38=\"VERY high\",P34=\"low\"),\"$,Mo\",IF(AND(Q34=\"VERY high\",P34=\"low\"),\"$\",IF(AND(Q38=\"VERY high\",P34=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T37=\"$\",(T37=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U37=\"$\",(U37=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V37=\"$\",(V37=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W37=\"$\",(W37=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X37=\"$\",(X37=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T37=\"Mo\",(T37=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U37=\"Mo\",(U37=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V37=\"Mo\",(V37=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W37=\"Mo\",(W37=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X37=\"Mo\",(X37=\"$,Mo\")),32,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C34=\"Retired\",0,L34*(N40))","v":0},null,{"$f":"IF(C34=\"Retired\",\"NO RISK\",IF(ABS(N40)>S$10,Q$10,IF(ABS(N40)>S$11,Q$11,IF(ABS(N40)>S$12,Q$12,IF(ABS(N40)>S$13,Q$13,IF(ABS(N40)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q34=\"VERY LOW\",Q38=\"very low\",P34=\"VERY LOW\"),\"$,Mo\",IF(AND(Q34=\"VERY LOW\",P34=\"VERY LOW\"),\"$\",IF(AND(Q38=\"very low\",P34=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"LOW\",Q38=\"low\",P34=\"VERY LOW\"),\"$,Mo\",IF(AND(Q34=\"LOW\",P34=\"VERY LOW\"),\"$\",IF(AND(Q38=\"low\",P34=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"medium\",Q38=\"medium\",P34=\"VERY LOW\"),\"$,Mo\",IF(AND(Q34=\"medium\",P34=\"VERY LOW\"),\"$\",IF(AND(Q38=\"medium\",P34=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"high\",Q38=\"high\",P34=\"VERY LOW\"),\"$,Mo\",IF(AND(Q34=\"high\",P34=\"VERY LOW\"),\"$\",IF(AND(Q38=\"high\",P34=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q34=\"VERY high\",Q38=\"VERY high\",P34=\"VERY LOW\"),\"$,Mo\",IF(AND(Q34=\"VERY high\",P34=\"VERY LOW\"),\"$\",IF(AND(Q38=\"VERY high\",P34=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T38=\"$\",(T38=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U38=\"$\",(U38=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V38=\"$\",(V38=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W38=\"$\",(W38=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X38=\"$\",(X38=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T38=\"Mo\",(T38=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U38=\"Mo\",(U38=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V38=\"Mo\",(V38=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W38=\"Mo\",(W38=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X38=\"Mo\",(X38=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y34:AC38)","v":0},null,null,null,null,{"$f":"SUM(AD34:AH38)","v":0},null,null,{"$f":"IF(O38>0,O38,0)","v":0},{"$f":"IF(O38<0,O38,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA39","v":0},{"$f":"AF39","v":0},"Impact"]
[]
[null,2,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C42=\"Retired\",0,L42*(N42+4*N44+N43)/6)","v":0},{"$f":"IF(C42=\"Retired\",\"NO RISK\",IF(L42>(L$10-0.01),P$10,IF(L42>(L$11-0.01),P$11,IF(L42>(L$12-0.01),P$12,IF(L42>(L$13-0.01),P$13,IF(L42>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C42=\"Retired\",\"NO RISK\",IF(ABS(N44)>O$10,Q$10,IF(ABS(N44)>O$11,Q$11,IF(ABS(N44)>O$12,Q$12,IF(ABS(N44)>O$13,Q$13,IF(ABS(N44)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q42=\"VERY LOW\",Q46=\"very low\",P42=\"VERY high\"),\"$,Mo\",IF(AND(Q42=\"VERY LOW\",P42=\"VERY high\"),\"$\",IF(AND(Q46=\"very low\",P42=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"LOW\",Q46=\"low\",P42=\"VERY high\"),\"$,Mo\",IF(AND(Q42=\"LOW\",P42=\"VERY high\"),\"$\",IF(AND(Q46=\"low\",P42=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"medium\",Q46=\"medium\",P42=\"VERY high\"),\"$,Mo\",IF(AND(Q42=\"medium\",P42=\"VERY high\"),\"$\",IF(AND(Q46=\"medium\",P42=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"high\",Q46=\"high\",P42=\"VERY high\"),\"$,Mo\",IF(AND(Q42=\"high\",P42=\"VERY high\"),\"$\",IF(AND(Q46=\"high\",P42=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"VERY high\",Q46=\"VERY high\",P42=\"VERY high\"),\"$,Mo\",IF(AND(Q42=\"VERY high\",P42=\"VERY high\"),\"$\",IF(AND(Q46=\"VERY high\",P42=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T42=\"$\",(T42=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U42=\"$\",(U42=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V42=\"$\",(V42=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W42=\"$\",(W42=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X42=\"$\",(X42=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T42=\"Mo\",(T42=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U42=\"Mo\",(U42=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V42=\"Mo\",(V42=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W42=\"Mo\",(W42=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X42=\"Mo\",(X42=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK42=\"Accept\",0,(N42*L42)-AR44)","v":0},null,{"$f":"IF(AT44=0,0,(N42*L42)-AT44)","v":0},{"$f":"O42-AT42","v":0},"Bridge Construction",{"$f":"IF($D42=\"ROW\",$AR44,\" \")","v":" "},{"$f":"IF($D42=\"ROW\",$AS44,\" \")","v":" "},{"$f":"IF($D42=\"ENV\",$AR44,\" \")","v":" "},{"$f":"IF($D42=\"ENV\",$AS44,\" \")","v":" "},{"$f":"IF($D42=\"ENG\",$AR44,\" \")","v":" "},{"$f":"IF($D42=\"ENG\",$AS44,\" \")","v":" "},{"$f":"IF($D42=\"TRF\",$AR44,\" \")","v":" "},{"$f":"IF($D42=\"TRF\",$AS44,\" \")","v":" "},{"$f":"IF($D42=\"STK\",$AR44,\" \")","v":" "},{"$f":"IF($D42=\"STK\",$AS44,\" \")","v":" "},{"$f":"IF($D42=\"UNF\",$AR44,\" \")","v":" "},{"$f":"IF($D42=\"UNF\",$AS44,\" \")","v":" "},{"$f":"IF($D42=\"MKT\",$AR44,\" \")","v":" "},{"$f":"IF($D42=\"MKT\",$AS44,\" \")","v":" "},{"$f":"IF($D42=\"UTL\",$AR44,\" \")","v":" "},{"$f":"IF($D42=\"UTL\",$AS44,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q42=\"VERY LOW\",Q46=\"very low\",P42=\"high\"),\"$,Mo\",IF(AND(Q42=\"VERY LOW\",P42=\"high\"),\"$\",IF(AND(Q46=\"very low\",P42=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"LOW\",Q46=\"low\",P42=\"high\"),\"$,Mo\",IF(AND(Q42=\"LOW\",P42=\"high\"),\"$\",IF(AND(Q46=\"low\",P42=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"medium\",Q46=\"medium\",P42=\"high\"),\"$,Mo\",IF(AND(Q42=\"medium\",P42=\"high\"),\"$\",IF(AND(Q46=\"medium\",P42=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"high\",Q46=\"high\",P42=\"high\"),\"$,Mo\",IF(AND(Q42=\"high\",P42=\"high\"),\"$\",IF(AND(Q46=\"high\",P42=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"VERY high\",Q46=\"VERY high\",P42=\"high\"),\"$,Mo\",IF(AND(Q42=\"VERY high\",P42=\"high\"),\"$\",IF(AND(Q46=\"VERY high\",P42=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T43=\"$\",(T43=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U43=\"$\",(U43=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V43=\"$\",(V43=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W43=\"$\",(W43=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X43=\"$\",(X43=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T43=\"Mo\",(T43=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U43=\"Mo\",(U43=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V43=\"Mo\",(V43=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W43=\"Mo\",(W43=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X43=\"Mo\",(X43=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O42>0,O42,0)","v":0},{"$f":"IF(O42<0,O42,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK42=\"Accept\",0,(N43*L42)-AR44)","v":0},null,{"$f":"IF(AT44=0,0,(N43*L42)-AT44)","v":0},null,"ROW Plan/Utility/Ad/Bid/Award/CN - Nooksack River Bridge ","RISK 2  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q42=\"VERY LOW\",Q46=\"very low\",P42=\"medium\"),\"$,Mo\",IF(AND(Q42=\"VERY LOW\",P42=\"medium\"),\"$\",IF(AND(Q46=\"very low\",P42=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"LOW\",Q46=\"low\",P42=\"medium\"),\"$,Mo\",IF(AND(Q42=\"LOW\",P42=\"medium\"),\"$\",IF(AND(Q46=\"low\",P42=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"medium\",Q46=\"medium\",P42=\"medium\"),\"$,Mo\",IF(AND(Q42=\"medium\",P42=\"medium\"),\"$\",IF(AND(Q46=\"medium\",P42=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"high\",Q46=\"high\",P42=\"medium\"),\"$,Mo\",IF(AND(Q42=\"high\",P42=\"medium\"),\"$\",IF(AND(Q46=\"high\",P42=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"VERY high\",Q46=\"VERY high\",P42=\"medium\"),\"$,Mo\",IF(AND(Q42=\"VERY high\",P42=\"medium\"),\"$\",IF(AND(Q46=\"VERY high\",P42=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T44=\"$\",(T44=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U44=\"$\",(U44=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V44=\"$\",(V44=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W44=\"$\",(W44=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X44=\"$\",(X44=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T44=\"Mo\",(T44=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U44=\"Mo\",(U44=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V44=\"Mo\",(V44=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W44=\"Mo\",(W44=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X44=\"Mo\",(X44=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK42=\"Accept\",0,(N44*L42)-AR44)","v":0},null,{"$f":"IF(AT44=0,0,(N44*L42)-AT44)","v":0},null,"Roadway Construction - North Section "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q42=\"VERY LOW\",Q46=\"very low\",P42=\"LOW\"),\"$,Mo\",IF(AND(Q42=\"VERY LOW\",P42=\"LOW\"),\"$\",IF(AND(Q46=\"very low\",P42=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"LOW\",Q46=\"low\",P42=\"LOW\"),\"$,Mo\",IF(AND(Q42=\"LOW\",P42=\"LOW\"),\"$\",IF(AND(Q46=\"low\",P42=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"medium\",Q46=\"medium\",P42=\"LOW\"),\"$,Mo\",IF(AND(Q42=\"medium\",P42=\"LOW\"),\"$\",IF(AND(Q46=\"medium\",P42=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"high\",Q46=\"high\",P42=\"LOW\"),\"$,Mo\",IF(AND(Q42=\"high\",P42=\"LOW\"),\"$\",IF(AND(Q46=\"high\",P42=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"VERY high\",Q46=\"VERY high\",P42=\"low\"),\"$,Mo\",IF(AND(Q42=\"VERY high\",P42=\"low\"),\"$\",IF(AND(Q46=\"VERY high\",P42=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T45=\"$\",(T45=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U45=\"$\",(U45=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V45=\"$\",(V45=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W45=\"$\",(W45=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X45=\"$\",(X45=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T45=\"Mo\",(T45=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U45=\"Mo\",(U45=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V45=\"Mo\",(V45=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W45=\"Mo\",(W45=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X45=\"Mo\",(X45=\"$,Mo\")),32,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C42=\"Retired\",0,L42*(N46+4*N48+N47)/6)","v":0},null,{"$f":"IF(C42=\"Retired\",\"NO RISK\",IF(ABS(N48)>S$10,Q$10,IF(ABS(N48)>S$11,Q$11,IF(ABS(N48)>S$12,Q$12,IF(ABS(N48)>S$13,Q$13,IF(ABS(N48)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q42=\"VERY LOW\",Q46=\"very low\",P42=\"VERY LOW\"),\"$,Mo\",IF(AND(Q42=\"VERY LOW\",P42=\"VERY LOW\"),\"$\",IF(AND(Q46=\"very low\",P42=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"LOW\",Q46=\"low\",P42=\"VERY LOW\"),\"$,Mo\",IF(AND(Q42=\"LOW\",P42=\"VERY LOW\"),\"$\",IF(AND(Q46=\"low\",P42=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"medium\",Q46=\"medium\",P42=\"VERY LOW\"),\"$,Mo\",IF(AND(Q42=\"medium\",P42=\"VERY LOW\"),\"$\",IF(AND(Q46=\"medium\",P42=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"high\",Q46=\"high\",P42=\"VERY LOW\"),\"$,Mo\",IF(AND(Q42=\"high\",P42=\"VERY LOW\"),\"$\",IF(AND(Q46=\"high\",P42=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q42=\"VERY high\",Q46=\"VERY high\",P42=\"VERY LOW\"),\"$,Mo\",IF(AND(Q42=\"VERY high\",P42=\"VERY LOW\"),\"$\",IF(AND(Q46=\"VERY high\",P42=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T46=\"$\",(T46=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U46=\"$\",(U46=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V46=\"$\",(V46=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W46=\"$\",(W46=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X46=\"$\",(X46=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T46=\"Mo\",(T46=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U46=\"Mo\",(U46=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V46=\"Mo\",(V46=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W46=\"Mo\",(W46=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X46=\"Mo\",(X46=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y42:AC46)","v":0},null,null,null,null,{"$f":"SUM(AD42:AH46)","v":0},null,null,{"$f":"IF(O46>0,O46,0)","v":0},{"$f":"IF(O46<0,O46,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA47","v":0},{"$f":"AF47","v":0},"Impact"]
[]
[null,3,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C50=\"Retired\",0,L50*(N50+4*N52+N51)/6)","v":0},{"$f":"IF(C50=\"Retired\",\"NO RISK\",IF(L50>(L$10-0.01),P$10,IF(L50>(L$11-0.01),P$11,IF(L50>(L$12-0.01),P$12,IF(L50>(L$13-0.01),P$13,IF(L50>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C50=\"Retired\",\"NO RISK\",IF(ABS(N52)>O$10,Q$10,IF(ABS(N52)>O$11,Q$11,IF(ABS(N52)>O$12,Q$12,IF(ABS(N52)>O$13,Q$13,IF(ABS(N52)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q50=\"VERY LOW\",Q54=\"very low\",P50=\"VERY high\"),\"$,Mo\",IF(AND(Q50=\"VERY LOW\",P50=\"VERY high\"),\"$\",IF(AND(Q54=\"very low\",P50=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"LOW\",Q54=\"low\",P50=\"VERY high\"),\"$,Mo\",IF(AND(Q50=\"LOW\",P50=\"VERY high\"),\"$\",IF(AND(Q54=\"low\",P50=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"medium\",Q54=\"medium\",P50=\"VERY high\"),\"$,Mo\",IF(AND(Q50=\"medium\",P50=\"VERY high\"),\"$\",IF(AND(Q54=\"medium\",P50=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"high\",Q54=\"high\",P50=\"VERY high\"),\"$,Mo\",IF(AND(Q50=\"high\",P50=\"VERY high\"),\"$\",IF(AND(Q54=\"high\",P50=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"VERY high\",Q54=\"VERY high\",P50=\"VERY high\"),\"$,Mo\",IF(AND(Q50=\"VERY high\",P50=\"VERY high\"),\"$\",IF(AND(Q54=\"VERY high\",P50=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T50=\"$\",(T50=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U50=\"$\",(U50=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V50=\"$\",(V50=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W50=\"$\",(W50=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X50=\"$\",(X50=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T50=\"Mo\",(T50=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U50=\"Mo\",(U50=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V50=\"Mo\",(V50=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W50=\"Mo\",(W50=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X50=\"Mo\",(X50=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK50=\"Accept\",0,(N50*L50)-AR52)","v":0},null,{"$f":"IF(AT52=0,0,(N50*L50)-AT52)","v":0},{"$f":"O50-AT50","v":0},null,{"$f":"IF($D50=\"ROW\",$AR52,\" \")","v":" "},{"$f":"IF($D50=\"ROW\",$AS52,\" \")","v":" "},{"$f":"IF($D50=\"ENV\",$AR52,\" \")","v":" "},{"$f":"IF($D50=\"ENV\",$AS52,\" \")","v":" "},{"$f":"IF($D50=\"ENG\",$AR52,\" \")","v":" "},{"$f":"IF($D50=\"ENG\",$AS52,\" \")","v":" "},{"$f":"IF($D50=\"TRF\",$AR52,\" \")","v":" "},{"$f":"IF($D50=\"TRF\",$AS52,\" \")","v":" "},{"$f":"IF($D50=\"STK\",$AR52,\" \")","v":" "},{"$f":"IF($D50=\"STK\",$AS52,\" \")","v":" "},{"$f":"IF($D50=\"UNF\",$AR52,\" \")","v":" "},{"$f":"IF($D50=\"UNF\",$AS52,\" \")","v":" "},{"$f":"IF($D50=\"MKT\",$AR52,\" \")","v":" "},{"$f":"IF($D50=\"MKT\",$AS52,\" \")","v":" "},{"$f":"IF($D50=\"UTL\",$AR52,\" \")","v":" "},{"$f":"IF($D50=\"UTL\",$AS52,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q50=\"VERY LOW\",Q54=\"very low\",P50=\"high\"),\"$,Mo\",IF(AND(Q50=\"VERY LOW\",P50=\"high\"),\"$\",IF(AND(Q54=\"very low\",P50=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"LOW\",Q54=\"low\",P50=\"high\"),\"$,Mo\",IF(AND(Q50=\"LOW\",P50=\"high\"),\"$\",IF(AND(Q54=\"low\",P50=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"medium\",Q54=\"medium\",P50=\"high\"),\"$,Mo\",IF(AND(Q50=\"medium\",P50=\"high\"),\"$\",IF(AND(Q54=\"medium\",P50=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"high\",Q54=\"high\",P50=\"high\"),\"$,Mo\",IF(AND(Q50=\"high\",P50=\"high\"),\"$\",IF(AND(Q54=\"high\",P50=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"VERY high\",Q54=\"VERY high\",P50=\"high\"),\"$,Mo\",IF(AND(Q50=\"VERY high\",P50=\"high\"),\"$\",IF(AND(Q54=\"VERY high\",P50=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T51=\"$\",(T51=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U51=\"$\",(U51=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V51=\"$\",(V51=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W51=\"$\",(W51=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X51=\"$\",(X51=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T51=\"Mo\",(T51=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U51=\"Mo\",(U51=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V51=\"Mo\",(V51=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W51=\"Mo\",(W51=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X51=\"Mo\",(X51=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O50>0,O50,0)","v":0},{"$f":"IF(O50<0,O50,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK50=\"Accept\",0,(N51*L50)-AR52)","v":0},null,{"$f":"IF(AT52=0,0,(N51*L50)-AT52)","v":0},null,null,"RISK 3  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q50=\"VERY LOW\",Q54=\"very low\",P50=\"medium\"),\"$,Mo\",IF(AND(Q50=\"VERY LOW\",P50=\"medium\"),\"$\",IF(AND(Q54=\"very low\",P50=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"LOW\",Q54=\"low\",P50=\"medium\"),\"$,Mo\",IF(AND(Q50=\"LOW\",P50=\"medium\"),\"$\",IF(AND(Q54=\"low\",P50=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"medium\",Q54=\"medium\",P50=\"medium\"),\"$,Mo\",IF(AND(Q50=\"medium\",P50=\"medium\"),\"$\",IF(AND(Q54=\"medium\",P50=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"high\",Q54=\"high\",P50=\"medium\"),\"$,Mo\",IF(AND(Q50=\"high\",P50=\"medium\"),\"$\",IF(AND(Q54=\"high\",P50=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"VERY high\",Q54=\"VERY high\",P50=\"medium\"),\"$,Mo\",IF(AND(Q50=\"VERY high\",P50=\"medium\"),\"$\",IF(AND(Q54=\"VERY high\",P50=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T52=\"$\",(T52=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U52=\"$\",(U52=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V52=\"$\",(V52=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W52=\"$\",(W52=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X52=\"$\",(X52=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T52=\"Mo\",(T52=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U52=\"Mo\",(U52=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V52=\"Mo\",(V52=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W52=\"Mo\",(W52=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X52=\"Mo\",(X52=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK50=\"Accept\",0,(N52*L50)-AR52)","v":0},null,{"$f":"IF(AT52=0,0,(N52*L50)-AT52)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q50=\"VERY LOW\",Q54=\"very low\",P50=\"LOW\"),\"$,Mo\",IF(AND(Q50=\"VERY LOW\",P50=\"LOW\"),\"$\",IF(AND(Q54=\"very low\",P50=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"LOW\",Q54=\"low\",P50=\"LOW\"),\"$,Mo\",IF(AND(Q50=\"LOW\",P50=\"LOW\"),\"$\",IF(AND(Q54=\"low\",P50=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"medium\",Q54=\"medium\",P50=\"LOW\"),\"$,Mo\",IF(AND(Q50=\"medium\",P50=\"LOW\"),\"$\",IF(AND(Q54=\"medium\",P50=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"high\",Q54=\"high\",P50=\"LOW\"),\"$,Mo\",IF(AND(Q50=\"high\",P50=\"LOW\"),\"$\",IF(AND(Q54=\"high\",P50=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"VERY high\",Q54=\"VERY high\",P50=\"low\"),\"$,Mo\",IF(AND(Q50=\"VERY high\",P50=\"low\"),\"$\",IF(AND(Q54=\"VERY high\",P50=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T53=\"$\",(T53=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U53=\"$\",(U53=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V53=\"$\",(V53=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W53=\"$\",(W53=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X53=\"$\",(X53=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T53=\"Mo\",(T53=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U53=\"Mo\",(U53=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V53=\"Mo\",(V53=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W53=\"Mo\",(W53=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X53=\"Mo\",(X53=\"$,Mo\")),32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C50=\"Retired\",0,L50*(N54+4*N56+N55)/6)","v":0},null,{"$f":"IF(C50=\"Retired\",\"NO RISK\",IF(ABS(N56)>S$10,Q$10,IF(ABS(N56)>S$11,Q$11,IF(ABS(N56)>S$12,Q$12,IF(ABS(N56)>S$13,Q$13,IF(ABS(N56)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q50=\"VERY LOW\",Q54=\"very low\",P50=\"VERY LOW\"),\"$,Mo\",IF(AND(Q50=\"VERY LOW\",P50=\"VERY LOW\"),\"$\",IF(AND(Q54=\"very low\",P50=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"LOW\",Q54=\"low\",P50=\"VERY LOW\"),\"$,Mo\",IF(AND(Q50=\"LOW\",P50=\"VERY LOW\"),\"$\",IF(AND(Q54=\"low\",P50=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"medium\",Q54=\"medium\",P50=\"VERY LOW\"),\"$,Mo\",IF(AND(Q50=\"medium\",P50=\"VERY LOW\"),\"$\",IF(AND(Q54=\"medium\",P50=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"high\",Q54=\"high\",P50=\"VERY LOW\"),\"$,Mo\",IF(AND(Q50=\"high\",P50=\"VERY LOW\"),\"$\",IF(AND(Q54=\"high\",P50=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q50=\"VERY high\",Q54=\"VERY high\",P50=\"VERY LOW\"),\"$,Mo\",IF(AND(Q50=\"VERY high\",P50=\"VERY LOW\"),\"$\",IF(AND(Q54=\"VERY high\",P50=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T54=\"$\",(T54=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U54=\"$\",(U54=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V54=\"$\",(V54=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W54=\"$\",(W54=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X54=\"$\",(X54=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T54=\"Mo\",(T54=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U54=\"Mo\",(U54=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V54=\"Mo\",(V54=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W54=\"Mo\",(W54=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X54=\"Mo\",(X54=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y50:AC54)","v":0},null,null,null,null,{"$f":"SUM(AD50:AH54)","v":0},null,null,{"$f":"IF(O54>0,O54,0)","v":0},{"$f":"IF(O54<0,O54,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA55","v":0},{"$f":"AF55","v":0},"Impact"]
[]
[null,4,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C58=\"Retired\",0,L58*(N58+4*N60+N59)/6)","v":0},{"$f":"IF(C58=\"Retired\",\"NO RISK\",IF(L58>(L$10-0.01),P$10,IF(L58>(L$11-0.01),P$11,IF(L58>(L$12-0.01),P$12,IF(L58>(L$13-0.01),P$13,IF(L58>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C58=\"Retired\",\"NO RISK\",IF(ABS(N60)>O$10,Q$10,IF(ABS(N60)>O$11,Q$11,IF(ABS(N60)>O$12,Q$12,IF(ABS(N60)>O$13,Q$13,IF(ABS(N60)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q58=\"VERY LOW\",Q62=\"very low\",P58=\"VERY high\"),\"$,Mo\",IF(AND(Q58=\"VERY LOW\",P58=\"VERY high\"),\"$\",IF(AND(Q62=\"very low\",P58=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"LOW\",Q62=\"low\",P58=\"VERY high\"),\"$,Mo\",IF(AND(Q58=\"LOW\",P58=\"VERY high\"),\"$\",IF(AND(Q62=\"low\",P58=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"medium\",Q62=\"medium\",P58=\"VERY high\"),\"$,Mo\",IF(AND(Q58=\"medium\",P58=\"VERY high\"),\"$\",IF(AND(Q62=\"medium\",P58=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"high\",Q62=\"high\",P58=\"VERY high\"),\"$,Mo\",IF(AND(Q58=\"high\",P58=\"VERY high\"),\"$\",IF(AND(Q62=\"high\",P58=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"VERY high\",Q62=\"VERY high\",P58=\"VERY high\"),\"$,Mo\",IF(AND(Q58=\"VERY high\",P58=\"VERY high\"),\"$\",IF(AND(Q62=\"VERY high\",P58=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T58=\"$\",(T58=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U58=\"$\",(U58=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V58=\"$\",(V58=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W58=\"$\",(W58=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X58=\"$\",(X58=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T58=\"Mo\",(T58=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U58=\"Mo\",(U58=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V58=\"Mo\",(V58=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W58=\"Mo\",(W58=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X58=\"Mo\",(X58=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK58=\"Accept\",0,(N58*L58)-AR60)","v":0},null,{"$f":"IF(AT60=0,0,(N58*L58)-AT60)","v":0},{"$f":"O58-AT58","v":0},null,{"$f":"IF($D58=\"ROW\",$AR60,\" \")","v":" "},{"$f":"IF($D58=\"ROW\",$AS60,\" \")","v":" "},{"$f":"IF($D58=\"ENV\",$AR60,\" \")","v":" "},{"$f":"IF($D58=\"ENV\",$AS60,\" \")","v":" "},{"$f":"IF($D58=\"ENG\",$AR60,\" \")","v":" "},{"$f":"IF($D58=\"ENG\",$AS60,\" \")","v":" "},{"$f":"IF($D58=\"TRF\",$AR60,\" \")","v":" "},{"$f":"IF($D58=\"TRF\",$AS60,\" \")","v":" "},{"$f":"IF($D58=\"STK\",$AR60,\" \")","v":" "},{"$f":"IF($D58=\"STK\",$AS60,\" \")","v":" "},{"$f":"IF($D58=\"UNF\",$AR60,\" \")","v":" "},{"$f":"IF($D58=\"UNF\",$AS60,\" \")","v":" "},{"$f":"IF($D58=\"MKT\",$AR60,\" \")","v":" "},{"$f":"IF($D58=\"MKT\",$AS60,\" \")","v":" "},{"$f":"IF($D58=\"UTL\",$AR60,\" \")","v":" "},{"$f":"IF($D58=\"UTL\",$AS60,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q58=\"VERY LOW\",Q62=\"very low\",P58=\"high\"),\"$,Mo\",IF(AND(Q58=\"VERY LOW\",P58=\"high\"),\"$\",IF(AND(Q62=\"very low\",P58=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"LOW\",Q62=\"low\",P58=\"high\"),\"$,Mo\",IF(AND(Q58=\"LOW\",P58=\"high\"),\"$\",IF(AND(Q62=\"low\",P58=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"medium\",Q62=\"medium\",P58=\"high\"),\"$,Mo\",IF(AND(Q58=\"medium\",P58=\"high\"),\"$\",IF(AND(Q62=\"medium\",P58=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"high\",Q62=\"high\",P58=\"high\"),\"$,Mo\",IF(AND(Q58=\"high\",P58=\"high\"),\"$\",IF(AND(Q62=\"high\",P58=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"VERY high\",Q62=\"VERY high\",P58=\"high\"),\"$,Mo\",IF(AND(Q58=\"VERY high\",P58=\"high\"),\"$\",IF(AND(Q62=\"VERY high\",P58=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T59=\"$\",(T59=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U59=\"$\",(U59=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V59=\"$\",(V59=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W59=\"$\",(W59=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X59=\"$\",(X59=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T59=\"Mo\",(T59=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U59=\"Mo\",(U59=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V59=\"Mo\",(V59=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W59=\"Mo\",(W59=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X59=\"Mo\",(X59=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O58>0,O58,0)","v":0},{"$f":"IF(O58<0,O58,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK58=\"Accept\",0,(N59*L58)-AR60)","v":0},null,{"$f":"IF(AT60=0,0,(N59*L58)-AT60)","v":0},null,null,"RISK 4  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q58=\"VERY LOW\",Q62=\"very low\",P58=\"medium\"),\"$,Mo\",IF(AND(Q58=\"VERY LOW\",P58=\"medium\"),\"$\",IF(AND(Q62=\"very low\",P58=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"LOW\",Q62=\"low\",P58=\"medium\"),\"$,Mo\",IF(AND(Q58=\"LOW\",P58=\"medium\"),\"$\",IF(AND(Q62=\"low\",P58=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"medium\",Q62=\"medium\",P58=\"medium\"),\"$,Mo\",IF(AND(Q58=\"medium\",P58=\"medium\"),\"$\",IF(AND(Q62=\"medium\",P58=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"high\",Q62=\"high\",P58=\"medium\"),\"$,Mo\",IF(AND(Q58=\"high\",P58=\"medium\"),\"$\",IF(AND(Q62=\"high\",P58=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"VERY high\",Q62=\"VERY high\",P58=\"medium\"),\"$,Mo\",IF(AND(Q58=\"VERY high\",P58=\"medium\"),\"$\",IF(AND(Q62=\"VERY high\",P58=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T60=\"$\",(T60=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U60=\"$\",(U60=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V60=\"$\",(V60=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W60=\"$\",(W60=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X60=\"$\",(X60=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T60=\"Mo\",(T60=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U60=\"Mo\",(U60=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V60=\"Mo\",(V60=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W60=\"Mo\",(W60=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X60=\"Mo\",(X60=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK58=\"Accept\",0,(N60*L58)-AR60)","v":0},null,{"$f":"IF(AT60=0,0,(N60*L58)-AT60)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q58=\"VERY LOW\",Q62=\"very low\",P58=\"LOW\"),\"$,Mo\",IF(AND(Q58=\"VERY LOW\",P58=\"LOW\"),\"$\",IF(AND(Q62=\"very low\",P58=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"LOW\",Q62=\"low\",P58=\"LOW\"),\"$,Mo\",IF(AND(Q58=\"LOW\",P58=\"LOW\"),\"$\",IF(AND(Q62=\"low\",P58=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"medium\",Q62=\"medium\",P58=\"LOW\"),\"$,Mo\",IF(AND(Q58=\"medium\",P58=\"LOW\"),\"$\",IF(AND(Q62=\"medium\",P58=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"high\",Q62=\"high\",P58=\"LOW\"),\"$,Mo\",IF(AND(Q58=\"high\",P58=\"LOW\"),\"$\",IF(AND(Q62=\"high\",P58=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"VERY high\",Q62=\"VERY high\",P58=\"low\"),\"$,Mo\",IF(AND(Q58=\"VERY high\",P58=\"low\"),\"$\",IF(AND(Q62=\"VERY high\",P58=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T61=\"$\",(T61=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U61=\"$\",(U61=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V61=\"$\",(V61=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W61=\"$\",(W61=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X61=\"$\",(X61=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T61=\"Mo\",(T61=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U61=\"Mo\",(U61=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V61=\"Mo\",(V61=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W61=\"Mo\",(W61=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X61=\"Mo\",(X61=\"$,Mo\")),32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C58=\"Retired\",0,L58*(N62+4*N64+N63)/6)","v":0},null,{"$f":"IF(C58=\"Retired\",\"NO RISK\",IF(ABS(N64)>S$10,Q$10,IF(ABS(N64)>S$11,Q$11,IF(ABS(N64)>S$12,Q$12,IF(ABS(N64)>S$13,Q$13,IF(ABS(N64)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q58=\"VERY LOW\",Q62=\"very low\",P58=\"VERY LOW\"),\"$,Mo\",IF(AND(Q58=\"VERY LOW\",P58=\"VERY LOW\"),\"$\",IF(AND(Q62=\"very low\",P58=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"LOW\",Q62=\"low\",P58=\"VERY LOW\"),\"$,Mo\",IF(AND(Q58=\"LOW\",P58=\"VERY LOW\"),\"$\",IF(AND(Q62=\"low\",P58=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"medium\",Q62=\"medium\",P58=\"VERY LOW\"),\"$,Mo\",IF(AND(Q58=\"medium\",P58=\"VERY LOW\"),\"$\",IF(AND(Q62=\"medium\",P58=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"high\",Q62=\"high\",P58=\"VERY LOW\"),\"$,Mo\",IF(AND(Q58=\"high\",P58=\"VERY LOW\"),\"$\",IF(AND(Q62=\"high\",P58=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q58=\"VERY high\",Q62=\"VERY high\",P58=\"VERY LOW\"),\"$,Mo\",IF(AND(Q58=\"VERY high\",P58=\"VERY LOW\"),\"$\",IF(AND(Q62=\"VERY high\",P58=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T62=\"$\",(T62=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U62=\"$\",(U62=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V62=\"$\",(V62=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W62=\"$\",(W62=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X62=\"$\",(X62=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T62=\"Mo\",(T62=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U62=\"Mo\",(U62=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V62=\"Mo\",(V62=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W62=\"Mo\",(W62=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X62=\"Mo\",(X62=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y58:AC62)","v":0},null,null,null,null,{"$f":"SUM(AD58:AH62)","v":0},null,null,{"$f":"IF(O62>0,O62,0)","v":0},{"$f":"IF(O62<0,O62,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA63","v":0},{"$f":"AF63","v":0},"Impact"]
[]
[null,5,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C66=\"Retired\",0,L66*(N66+4*N68+N67)/6)","v":0},{"$f":"IF(C66=\"Retired\",\"NO RISK\",IF(L66>(L$10-0.01),P$10,IF(L66>(L$11-0.01),P$11,IF(L66>(L$12-0.01),P$12,IF(L66>(L$13-0.01),P$13,IF(L66>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C66=\"Retired\",\"NO RISK\",IF(ABS(N68)>O$10,Q$10,IF(ABS(N68)>O$11,Q$11,IF(ABS(N68)>O$12,Q$12,IF(ABS(N68)>O$13,Q$13,IF(ABS(N68)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q66=\"VERY LOW\",Q70=\"very low\",P66=\"VERY high\"),\"$,Mo\",IF(AND(Q66=\"VERY LOW\",P66=\"VERY high\"),\"$\",IF(AND(Q70=\"very low\",P66=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"LOW\",Q70=\"low\",P66=\"VERY high\"),\"$,Mo\",IF(AND(Q66=\"LOW\",P66=\"VERY high\"),\"$\",IF(AND(Q70=\"low\",P66=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"medium\",Q70=\"medium\",P66=\"VERY high\"),\"$,Mo\",IF(AND(Q66=\"medium\",P66=\"VERY high\"),\"$\",IF(AND(Q70=\"medium\",P66=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"high\",Q70=\"high\",P66=\"VERY high\"),\"$,Mo\",IF(AND(Q66=\"high\",P66=\"VERY high\"),\"$\",IF(AND(Q70=\"high\",P66=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"VERY high\",Q70=\"VERY high\",P66=\"VERY high\"),\"$,Mo\",IF(AND(Q66=\"VERY high\",P66=\"VERY high\"),\"$\",IF(AND(Q70=\"VERY high\",P66=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T66=\"$\",(T66=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U66=\"$\",(U66=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V66=\"$\",(V66=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W66=\"$\",(W66=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X66=\"$\",(X66=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T66=\"Mo\",(T66=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U66=\"Mo\",(U66=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V66=\"Mo\",(V66=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W66=\"Mo\",(W66=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X66=\"Mo\",(X66=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK66=\"Accept\",0,(N66*L66)-AR68)","v":0},null,{"$f":"IF(AT68=0,0,(N66*L66)-AT68)","v":0},{"$f":"O66-AT66","v":0},null,{"$f":"IF($D66=\"ROW\",$AR68,\" \")","v":" "},{"$f":"IF($D66=\"ROW\",$AS68,\" \")","v":" "},{"$f":"IF($D66=\"ENV\",$AR68,\" \")","v":" "},{"$f":"IF($D66=\"ENV\",$AS68,\" \")","v":" "},{"$f":"IF($D66=\"ENG\",$AR68,\" \")","v":" "},{"$f":"IF($D66=\"ENG\",$AS68,\" \")","v":" "},{"$f":"IF($D66=\"TRF\",$AR68,\" \")","v":" "},{"$f":"IF($D66=\"TRF\",$AS68,\" \")","v":" "},{"$f":"IF($D66=\"STK\",$AR68,\" \")","v":" "},{"$f":"IF($D66=\"STK\",$AS68,\" \")","v":" "},{"$f":"IF($D66=\"UNF\",$AR68,\" \")","v":" "},{"$f":"IF($D66=\"UNF\",$AS68,\" \")","v":" "},{"$f":"IF($D66=\"MKT\",$AR68,\" \")","v":" "},{"$f":"IF($D66=\"MKT\",$AS68,\" \")","v":" "},{"$f":"IF($D66=\"UTL\",$AR68,\" \")","v":" "},{"$f":"IF($D66=\"UTL\",$AS68,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q66=\"VERY LOW\",Q70=\"very low\",P66=\"high\"),\"$,Mo\",IF(AND(Q66=\"VERY LOW\",P66=\"high\"),\"$\",IF(AND(Q70=\"very low\",P66=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"LOW\",Q70=\"low\",P66=\"high\"),\"$,Mo\",IF(AND(Q66=\"LOW\",P66=\"high\"),\"$\",IF(AND(Q70=\"low\",P66=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"medium\",Q70=\"medium\",P66=\"high\"),\"$,Mo\",IF(AND(Q66=\"medium\",P66=\"high\"),\"$\",IF(AND(Q70=\"medium\",P66=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"high\",Q70=\"high\",P66=\"high\"),\"$,Mo\",IF(AND(Q66=\"high\",P66=\"high\"),\"$\",IF(AND(Q70=\"high\",P66=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"VERY high\",Q70=\"VERY high\",P66=\"high\"),\"$,Mo\",IF(AND(Q66=\"VERY high\",P66=\"high\"),\"$\",IF(AND(Q70=\"VERY high\",P66=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T67=\"$\",(T67=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U67=\"$\",(U67=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V67=\"$\",(V67=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W67=\"$\",(W67=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X67=\"$\",(X67=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T67=\"Mo\",(T67=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U67=\"Mo\",(U67=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V67=\"Mo\",(V67=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W67=\"Mo\",(W67=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X67=\"Mo\",(X67=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O66>0,O66,0)","v":0},{"$f":"IF(O66<0,O66,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK66=\"Accept\",0,(N67*L66)-AR68)","v":0},null,{"$f":"IF(AT68=0,0,(N67*L66)-AT68)","v":0},null,null,"RISK 5  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q66=\"VERY LOW\",Q70=\"very low\",P66=\"medium\"),\"$,Mo\",IF(AND(Q66=\"VERY LOW\",P66=\"medium\"),\"$\",IF(AND(Q70=\"very low\",P66=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"LOW\",Q70=\"low\",P66=\"medium\"),\"$,Mo\",IF(AND(Q66=\"LOW\",P66=\"medium\"),\"$\",IF(AND(Q70=\"low\",P66=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"medium\",Q70=\"medium\",P66=\"medium\"),\"$,Mo\",IF(AND(Q66=\"medium\",P66=\"medium\"),\"$\",IF(AND(Q70=\"medium\",P66=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"high\",Q70=\"high\",P66=\"medium\"),\"$,Mo\",IF(AND(Q66=\"high\",P66=\"medium\"),\"$\",IF(AND(Q70=\"high\",P66=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"VERY high\",Q70=\"VERY high\",P66=\"medium\"),\"$,Mo\",IF(AND(Q66=\"VERY high\",P66=\"medium\"),\"$\",IF(AND(Q70=\"VERY high\",P66=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T68=\"$\",(T68=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U68=\"$\",(U68=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V68=\"$\",(V68=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W68=\"$\",(W68=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X68=\"$\",(X68=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T68=\"Mo\",(T68=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U68=\"Mo\",(U68=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V68=\"Mo\",(V68=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W68=\"Mo\",(W68=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X68=\"Mo\",(X68=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK66=\"Accept\",0,(N68*L66)-AR68)","v":0},null,{"$f":"IF(AT68=0,0,(N68*L66)-AT68)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q66=\"VERY LOW\",Q70=\"very low\",P66=\"LOW\"),\"$,Mo\",IF(AND(Q66=\"VERY LOW\",P66=\"LOW\"),\"$\",IF(AND(Q70=\"very low\",P66=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"LOW\",Q70=\"low\",P66=\"LOW\"),\"$,Mo\",IF(AND(Q66=\"LOW\",P66=\"LOW\"),\"$\",IF(AND(Q70=\"low\",P66=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"medium\",Q70=\"medium\",P66=\"LOW\"),\"$,Mo\",IF(AND(Q66=\"medium\",P66=\"LOW\"),\"$\",IF(AND(Q70=\"medium\",P66=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"high\",Q70=\"high\",P66=\"LOW\"),\"$,Mo\",IF(AND(Q66=\"high\",P66=\"LOW\"),\"$\",IF(AND(Q70=\"high\",P66=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"VERY high\",Q70=\"VERY high\",P66=\"low\"),\"$,Mo\",IF(AND(Q66=\"VERY high\",P66=\"low\"),\"$\",IF(AND(Q70=\"VERY high\",P66=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T69=\"$\",(T69=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U69=\"$\",(U69=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V69=\"$\",(V69=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W69=\"$\",(W69=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X69=\"$\",(X69=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T69=\"Mo\",(T69=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U69=\"Mo\",(U69=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V69=\"Mo\",(V69=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W69=\"Mo\",(W69=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X69=\"Mo\",(X69=\"$,Mo\")),32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C66=\"Retired\",0,L66*(N70+4*N72+N71)/6)","v":0},null,{"$f":"IF(C66=\"Retired\",\"NO RISK\",IF(ABS(N72)>S$10,Q$10,IF(ABS(N72)>S$11,Q$11,IF(ABS(N72)>S$12,Q$12,IF(ABS(N72)>S$13,Q$13,IF(ABS(N72)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q66=\"VERY LOW\",Q70=\"very low\",P66=\"VERY LOW\"),\"$,Mo\",IF(AND(Q66=\"VERY LOW\",P66=\"VERY LOW\"),\"$\",IF(AND(Q70=\"very low\",P66=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"LOW\",Q70=\"low\",P66=\"VERY LOW\"),\"$,Mo\",IF(AND(Q66=\"LOW\",P66=\"VERY LOW\"),\"$\",IF(AND(Q70=\"low\",P66=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"medium\",Q70=\"medium\",P66=\"VERY LOW\"),\"$,Mo\",IF(AND(Q66=\"medium\",P66=\"VERY LOW\"),\"$\",IF(AND(Q70=\"medium\",P66=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"high\",Q70=\"high\",P66=\"VERY LOW\"),\"$,Mo\",IF(AND(Q66=\"high\",P66=\"VERY LOW\"),\"$\",IF(AND(Q70=\"high\",P66=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q66=\"VERY high\",Q70=\"VERY high\",P66=\"VERY LOW\"),\"$,Mo\",IF(AND(Q66=\"VERY high\",P66=\"VERY LOW\"),\"$\",IF(AND(Q70=\"VERY high\",P66=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T70=\"$\",(T70=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U70=\"$\",(U70=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V70=\"$\",(V70=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W70=\"$\",(W70=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X70=\"$\",(X70=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T70=\"Mo\",(T70=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U70=\"Mo\",(U70=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V70=\"Mo\",(V70=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W70=\"Mo\",(W70=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X70=\"Mo\",(X70=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y66:AC70)","v":0},null,null,null,null,{"$f":"SUM(AD66:AH70)","v":0},null,null,{"$f":"IF(O70>0,O70,0)","v":0},{"$f":"IF(O70<0,O70,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA71","v":0},{"$f":"AF71","v":0},"Impact"]
[]
[null,6,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C74=\"Retired\",0,L74*(N74+4*N76+N75)/6)","v":0},{"$f":"IF(C74=\"Retired\",\"NO RISK\",IF(L74>(L$10-0.01),P$10,IF(L74>(L$11-0.01),P$11,IF(L74>(L$12-0.01),P$12,IF(L74>(L$13-0.01),P$13,IF(L74>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C74=\"Retired\",\"NO RISK\",IF(ABS(N76)>O$10,Q$10,IF(ABS(N76)>O$11,Q$11,IF(ABS(N76)>O$12,Q$12,IF(ABS(N76)>O$13,Q$13,IF(ABS(N76)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q74=\"VERY LOW\",Q78=\"very low\",P74=\"VERY high\"),\"$,Mo\",IF(AND(Q74=\"VERY LOW\",P74=\"VERY high\"),\"$\",IF(AND(Q78=\"very low\",P74=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"LOW\",Q78=\"low\",P74=\"VERY high\"),\"$,Mo\",IF(AND(Q74=\"LOW\",P74=\"VERY high\"),\"$\",IF(AND(Q78=\"low\",P74=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"medium\",Q78=\"medium\",P74=\"VERY high\"),\"$,Mo\",IF(AND(Q74=\"medium\",P74=\"VERY high\"),\"$\",IF(AND(Q78=\"medium\",P74=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"high\",Q78=\"high\",P74=\"VERY high\"),\"$,Mo\",IF(AND(Q74=\"high\",P74=\"VERY high\"),\"$\",IF(AND(Q78=\"high\",P74=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"VERY high\",Q78=\"VERY high\",P74=\"VERY high\"),\"$,Mo\",IF(AND(Q74=\"VERY high\",P74=\"VERY high\"),\"$\",IF(AND(Q78=\"VERY high\",P74=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T74=\"$\",(T74=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U74=\"$\",(U74=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V74=\"$\",(V74=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W74=\"$\",(W74=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X74=\"$\",(X74=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T74=\"Mo\",(T74=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U74=\"Mo\",(U74=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V74=\"Mo\",(V74=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W74=\"Mo\",(W74=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X74=\"Mo\",(X74=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK74=\"Accept\",0,(N74*L74)-AR76)","v":0},null,{"$f":"IF(AT76=0,0,(N74*L74)-AT76)","v":0},{"$f":"O74-AT74","v":0},"Functional Assignment",{"$f":"IF($D74=\"ROW\",$AR76,\" \")","v":" "},{"$f":"IF($D74=\"ROW\",$AS76,\" \")","v":" "},{"$f":"IF($D74=\"ENV\",$AR76,\" \")","v":" "},{"$f":"IF($D74=\"ENV\",$AS76,\" \")","v":" "},{"$f":"IF($D74=\"ENG\",$AR76,\" \")","v":" "},{"$f":"IF($D74=\"ENG\",$AS76,\" \")","v":" "},{"$f":"IF($D74=\"TRF\",$AR76,\" \")","v":" "},{"$f":"IF($D74=\"TRF\",$AS76,\" \")","v":" "},{"$f":"IF($D74=\"STK\",$AR76,\" \")","v":" "},{"$f":"IF($D74=\"STK\",$AS76,\" \")","v":" "},{"$f":"IF($D74=\"UNF\",$AR76,\" \")","v":" "},{"$f":"IF($D74=\"UNF\",$AS76,\" \")","v":" "},{"$f":"IF($D74=\"MKT\",$AR76,\" \")","v":" "},{"$f":"IF($D74=\"MKT\",$AS76,\" \")","v":" "},{"$f":"IF($D74=\"UTL\",$AR76,\" \")","v":" "},{"$f":"IF($D74=\"UTL\",$AS76,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q74=\"VERY LOW\",Q78=\"very low\",P74=\"high\"),\"$,Mo\",IF(AND(Q74=\"VERY LOW\",P74=\"high\"),\"$\",IF(AND(Q78=\"very low\",P74=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"LOW\",Q78=\"low\",P74=\"high\"),\"$,Mo\",IF(AND(Q74=\"LOW\",P74=\"high\"),\"$\",IF(AND(Q78=\"low\",P74=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"medium\",Q78=\"medium\",P74=\"high\"),\"$,Mo\",IF(AND(Q74=\"medium\",P74=\"high\"),\"$\",IF(AND(Q78=\"medium\",P74=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"high\",Q78=\"high\",P74=\"high\"),\"$,Mo\",IF(AND(Q74=\"high\",P74=\"high\"),\"$\",IF(AND(Q78=\"high\",P74=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"VERY high\",Q78=\"VERY high\",P74=\"high\"),\"$,Mo\",IF(AND(Q74=\"VERY high\",P74=\"high\"),\"$\",IF(AND(Q78=\"VERY high\",P74=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T75=\"$\",(T75=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U75=\"$\",(U75=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V75=\"$\",(V75=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W75=\"$\",(W75=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X75=\"$\",(X75=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T75=\"Mo\",(T75=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U75=\"Mo\",(U75=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V75=\"Mo\",(V75=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W75=\"Mo\",(W75=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X75=\"Mo\",(X75=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O74>0,O74,0)","v":0},{"$f":"IF(O74<0,O74,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK74=\"Accept\",0,(N75*L74)-AR76)","v":0},null,{"$f":"IF(AT76=0,0,(N75*L74)-AT76)","v":0},null,null,"RISK 6  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q74=\"VERY LOW\",Q78=\"very low\",P74=\"medium\"),\"$,Mo\",IF(AND(Q74=\"VERY LOW\",P74=\"medium\"),\"$\",IF(AND(Q78=\"very low\",P74=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"LOW\",Q78=\"low\",P74=\"medium\"),\"$,Mo\",IF(AND(Q74=\"LOW\",P74=\"medium\"),\"$\",IF(AND(Q78=\"low\",P74=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"medium\",Q78=\"medium\",P74=\"medium\"),\"$,Mo\",IF(AND(Q74=\"medium\",P74=\"medium\"),\"$\",IF(AND(Q78=\"medium\",P74=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"high\",Q78=\"high\",P74=\"medium\"),\"$,Mo\",IF(AND(Q74=\"high\",P74=\"medium\"),\"$\",IF(AND(Q78=\"high\",P74=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"VERY high\",Q78=\"VERY high\",P74=\"medium\"),\"$,Mo\",IF(AND(Q74=\"VERY high\",P74=\"medium\"),\"$\",IF(AND(Q78=\"VERY high\",P74=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T76=\"$\",(T76=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U76=\"$\",(U76=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V76=\"$\",(V76=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W76=\"$\",(W76=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X76=\"$\",(X76=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T76=\"Mo\",(T76=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U76=\"Mo\",(U76=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V76=\"Mo\",(V76=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W76=\"Mo\",(W76=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X76=\"Mo\",(X76=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK74=\"Accept\",0,(N76*L74)-AR76)","v":0},null,{"$f":"IF(AT76=0,0,(N76*L74)-AT76)","v":0},null,"ROW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q74=\"VERY LOW\",Q78=\"very low\",P74=\"LOW\"),\"$,Mo\",IF(AND(Q74=\"VERY LOW\",P74=\"LOW\"),\"$\",IF(AND(Q78=\"very low\",P74=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"LOW\",Q78=\"low\",P74=\"LOW\"),\"$,Mo\",IF(AND(Q74=\"LOW\",P74=\"LOW\"),\"$\",IF(AND(Q78=\"low\",P74=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"medium\",Q78=\"medium\",P74=\"LOW\"),\"$,Mo\",IF(AND(Q74=\"medium\",P74=\"LOW\"),\"$\",IF(AND(Q78=\"medium\",P74=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"high\",Q78=\"high\",P74=\"LOW\"),\"$,Mo\",IF(AND(Q74=\"high\",P74=\"LOW\"),\"$\",IF(AND(Q78=\"high\",P74=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"VERY high\",Q78=\"VERY high\",P74=\"low\"),\"$,Mo\",IF(AND(Q74=\"VERY high\",P74=\"low\"),\"$\",IF(AND(Q78=\"VERY high\",P74=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T77=\"$\",(T77=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U77=\"$\",(U77=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V77=\"$\",(V77=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W77=\"$\",(W77=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X77=\"$\",(X77=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T77=\"Mo\",(T77=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U77=\"Mo\",(U77=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V77=\"Mo\",(V77=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W77=\"Mo\",(W77=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X77=\"Mo\",(X77=\"$,Mo\")),32,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV"]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C74=\"Retired\",0,L74*(N78+4*N80+N79)/6)","v":0},null,{"$f":"IF(C74=\"Retired\",\"NO RISK\",IF(ABS(N80)>S$10,Q$10,IF(ABS(N80)>S$11,Q$11,IF(ABS(N80)>S$12,Q$12,IF(ABS(N80)>S$13,Q$13,IF(ABS(N80)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q74=\"VERY LOW\",Q78=\"very low\",P74=\"VERY LOW\"),\"$,Mo\",IF(AND(Q74=\"VERY LOW\",P74=\"VERY LOW\"),\"$\",IF(AND(Q78=\"very low\",P74=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"LOW\",Q78=\"low\",P74=\"VERY LOW\"),\"$,Mo\",IF(AND(Q74=\"LOW\",P74=\"VERY LOW\"),\"$\",IF(AND(Q78=\"low\",P74=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"medium\",Q78=\"medium\",P74=\"VERY LOW\"),\"$,Mo\",IF(AND(Q74=\"medium\",P74=\"VERY LOW\"),\"$\",IF(AND(Q78=\"medium\",P74=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"high\",Q78=\"high\",P74=\"VERY LOW\"),\"$,Mo\",IF(AND(Q74=\"high\",P74=\"VERY LOW\"),\"$\",IF(AND(Q78=\"high\",P74=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q74=\"VERY high\",Q78=\"VERY high\",P74=\"VERY LOW\"),\"$,Mo\",IF(AND(Q74=\"VERY high\",P74=\"VERY LOW\"),\"$\",IF(AND(Q78=\"VERY high\",P74=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T78=\"$\",(T78=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U78=\"$\",(U78=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V78=\"$\",(V78=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W78=\"$\",(W78=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X78=\"$\",(X78=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T78=\"Mo\",(T78=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U78=\"Mo\",(U78=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V78=\"Mo\",(V78=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W78=\"Mo\",(W78=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X78=\"Mo\",(X78=\"$,Mo\")),16,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENG"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y74:AC78)","v":0},null,null,null,null,{"$f":"SUM(AD74:AH78)","v":0},null,null,{"$f":"IF(O78>0,O78,0)","v":0},{"$f":"IF(O78<0,O78,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"TRF"]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA79","v":0},{"$f":"AF79","v":0},"Impact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"utility"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STK"]
[null,7,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C82=\"Retired\",0,L82*(N82+4*N84+N83)/6)","v":0},{"$f":"IF(C82=\"Retired\",\"NO RISK\",IF(L82>(L$10-0.01),P$10,IF(L82>(L$11-0.01),P$11,IF(L82>(L$12-0.01),P$12,IF(L82>(L$13-0.01),P$13,IF(L82>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C82=\"Retired\",\"NO RISK\",IF(ABS(N84)>O$10,Q$10,IF(ABS(N84)>O$11,Q$11,IF(ABS(N84)>O$12,Q$12,IF(ABS(N84)>O$13,Q$13,IF(ABS(N84)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q82=\"VERY LOW\",Q86=\"very low\",P82=\"VERY high\"),\"$,Mo\",IF(AND(Q82=\"VERY LOW\",P82=\"VERY high\"),\"$\",IF(AND(Q86=\"very low\",P82=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"LOW\",Q86=\"low\",P82=\"VERY high\"),\"$,Mo\",IF(AND(Q82=\"LOW\",P82=\"VERY high\"),\"$\",IF(AND(Q86=\"low\",P82=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"medium\",Q86=\"medium\",P82=\"VERY high\"),\"$,Mo\",IF(AND(Q82=\"medium\",P82=\"VERY high\"),\"$\",IF(AND(Q86=\"medium\",P82=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"high\",Q86=\"high\",P82=\"VERY high\"),\"$,Mo\",IF(AND(Q82=\"high\",P82=\"VERY high\"),\"$\",IF(AND(Q86=\"high\",P82=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"VERY high\",Q86=\"VERY high\",P82=\"VERY high\"),\"$,Mo\",IF(AND(Q82=\"VERY high\",P82=\"VERY high\"),\"$\",IF(AND(Q86=\"VERY high\",P82=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T82=\"$\",(T82=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U82=\"$\",(U82=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V82=\"$\",(V82=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W82=\"$\",(W82=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X82=\"$\",(X82=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T82=\"Mo\",(T82=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U82=\"Mo\",(U82=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V82=\"Mo\",(V82=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W82=\"Mo\",(W82=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X82=\"Mo\",(X82=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK82=\"Accept\",0,(N82*L82)-AR84)","v":0},null,{"$f":"IF(AT84=0,0,(N82*L82)-AT84)","v":0},{"$f":"O82-AT82","v":0},"UNF",{"$f":"IF($D82=\"ROW\",$AR84,\" \")","v":" "},{"$f":"IF($D82=\"ROW\",$AS84,\" \")","v":" "},{"$f":"IF($D82=\"ENV\",$AR84,\" \")","v":" "},{"$f":"IF($D82=\"ENV\",$AS84,\" \")","v":" "},{"$f":"IF($D82=\"ENG\",$AR84,\" \")","v":" "},{"$f":"IF($D82=\"ENG\",$AS84,\" \")","v":" "},{"$f":"IF($D82=\"TRF\",$AR84,\" \")","v":" "},{"$f":"IF($D82=\"TRF\",$AS84,\" \")","v":" "},{"$f":"IF($D82=\"STK\",$AR84,\" \")","v":" "},{"$f":"IF($D82=\"STK\",$AS84,\" \")","v":" "},{"$f":"IF($D82=\"UNF\",$AR84,\" \")","v":" "},{"$f":"IF($D82=\"UNF\",$AS84,\" \")","v":" "},{"$f":"IF($D82=\"MKT\",$AR84,\" \")","v":" "},{"$f":"IF($D82=\"MKT\",$AS84,\" \")","v":" "},{"$f":"IF($D82=\"UTL\",$AR84,\" \")","v":" "},{"$f":"IF($D82=\"UTL\",$AS84,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q82=\"VERY LOW\",Q86=\"very low\",P82=\"high\"),\"$,Mo\",IF(AND(Q82=\"VERY LOW\",P82=\"high\"),\"$\",IF(AND(Q86=\"very low\",P82=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"LOW\",Q86=\"low\",P82=\"high\"),\"$,Mo\",IF(AND(Q82=\"LOW\",P82=\"high\"),\"$\",IF(AND(Q86=\"low\",P82=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"medium\",Q86=\"medium\",P82=\"high\"),\"$,Mo\",IF(AND(Q82=\"medium\",P82=\"high\"),\"$\",IF(AND(Q86=\"medium\",P82=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"high\",Q86=\"high\",P82=\"high\"),\"$,Mo\",IF(AND(Q82=\"high\",P82=\"high\"),\"$\",IF(AND(Q86=\"high\",P82=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"VERY high\",Q86=\"VERY high\",P82=\"high\"),\"$,Mo\",IF(AND(Q82=\"VERY high\",P82=\"high\"),\"$\",IF(AND(Q86=\"VERY high\",P82=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T83=\"$\",(T83=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U83=\"$\",(U83=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V83=\"$\",(V83=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W83=\"$\",(W83=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X83=\"$\",(X83=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T83=\"Mo\",(T83=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U83=\"Mo\",(U83=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V83=\"Mo\",(V83=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W83=\"Mo\",(W83=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X83=\"Mo\",(X83=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O82>0,O82,0)","v":0},{"$f":"IF(O82<0,O82,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK82=\"Accept\",0,(N83*L82)-AR84)","v":0},null,{"$f":"IF(AT84=0,0,(N83*L82)-AT84)","v":0},null,"MKT","RISK 7  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q82=\"VERY LOW\",Q86=\"very low\",P82=\"medium\"),\"$,Mo\",IF(AND(Q82=\"VERY LOW\",P82=\"medium\"),\"$\",IF(AND(Q86=\"very low\",P82=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"LOW\",Q86=\"low\",P82=\"medium\"),\"$,Mo\",IF(AND(Q82=\"LOW\",P82=\"medium\"),\"$\",IF(AND(Q86=\"low\",P82=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"medium\",Q86=\"medium\",P82=\"medium\"),\"$,Mo\",IF(AND(Q82=\"medium\",P82=\"medium\"),\"$\",IF(AND(Q86=\"medium\",P82=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"high\",Q86=\"high\",P82=\"medium\"),\"$,Mo\",IF(AND(Q82=\"high\",P82=\"medium\"),\"$\",IF(AND(Q86=\"high\",P82=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"VERY high\",Q86=\"VERY high\",P82=\"medium\"),\"$,Mo\",IF(AND(Q82=\"VERY high\",P82=\"medium\"),\"$\",IF(AND(Q86=\"VERY high\",P82=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T84=\"$\",(T84=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U84=\"$\",(U84=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V84=\"$\",(V84=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W84=\"$\",(W84=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X84=\"$\",(X84=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T84=\"Mo\",(T84=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U84=\"Mo\",(U84=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V84=\"Mo\",(V84=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W84=\"Mo\",(W84=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X84=\"Mo\",(X84=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK82=\"Accept\",0,(N84*L82)-AR84)","v":0},null,{"$f":"IF(AT84=0,0,(N84*L82)-AT84)","v":0},null,"UTL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q82=\"VERY LOW\",Q86=\"very low\",P82=\"LOW\"),\"$,Mo\",IF(AND(Q82=\"VERY LOW\",P82=\"LOW\"),\"$\",IF(AND(Q86=\"very low\",P82=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"LOW\",Q86=\"low\",P82=\"LOW\"),\"$,Mo\",IF(AND(Q82=\"LOW\",P82=\"LOW\"),\"$\",IF(AND(Q86=\"low\",P82=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"medium\",Q86=\"medium\",P82=\"LOW\"),\"$,Mo\",IF(AND(Q82=\"medium\",P82=\"LOW\"),\"$\",IF(AND(Q86=\"medium\",P82=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"high\",Q86=\"high\",P82=\"LOW\"),\"$,Mo\",IF(AND(Q82=\"high\",P82=\"LOW\"),\"$\",IF(AND(Q86=\"high\",P82=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"VERY high\",Q86=\"VERY high\",P82=\"low\"),\"$,Mo\",IF(AND(Q82=\"VERY high\",P82=\"low\"),\"$\",IF(AND(Q86=\"VERY high\",P82=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T85=\"$\",(T85=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U85=\"$\",(U85=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V85=\"$\",(V85=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W85=\"$\",(W85=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X85=\"$\",(X85=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T85=\"Mo\",(T85=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U85=\"Mo\",(U85=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V85=\"Mo\",(V85=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W85=\"Mo\",(W85=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X85=\"Mo\",(X85=\"$,Mo\")),32,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"construction"]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C82=\"Retired\",0,L82*(N86+4*N88+N87)/6)","v":0},null,{"$f":"IF(C82=\"Retired\",\"NO RISK\",IF(ABS(N88)>S$10,Q$10,IF(ABS(N88)>S$11,Q$11,IF(ABS(N88)>S$12,Q$12,IF(ABS(N88)>S$13,Q$13,IF(ABS(N88)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q82=\"VERY LOW\",Q86=\"very low\",P82=\"VERY LOW\"),\"$,Mo\",IF(AND(Q82=\"VERY LOW\",P82=\"VERY LOW\"),\"$\",IF(AND(Q86=\"very low\",P82=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"LOW\",Q86=\"low\",P82=\"VERY LOW\"),\"$,Mo\",IF(AND(Q82=\"LOW\",P82=\"VERY LOW\"),\"$\",IF(AND(Q86=\"low\",P82=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"medium\",Q86=\"medium\",P82=\"VERY LOW\"),\"$,Mo\",IF(AND(Q82=\"medium\",P82=\"VERY LOW\"),\"$\",IF(AND(Q86=\"medium\",P82=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"high\",Q86=\"high\",P82=\"VERY LOW\"),\"$,Mo\",IF(AND(Q82=\"high\",P82=\"VERY LOW\"),\"$\",IF(AND(Q86=\"high\",P82=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q82=\"VERY high\",Q86=\"VERY high\",P82=\"VERY LOW\"),\"$,Mo\",IF(AND(Q82=\"VERY high\",P82=\"VERY LOW\"),\"$\",IF(AND(Q86=\"VERY high\",P82=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T86=\"$\",(T86=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U86=\"$\",(U86=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V86=\"$\",(V86=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W86=\"$\",(W86=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X86=\"$\",(X86=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T86=\"Mo\",(T86=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U86=\"Mo\",(U86=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V86=\"Mo\",(V86=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W86=\"Mo\",(W86=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X86=\"Mo\",(X86=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y82:AC86)","v":0},null,null,null,null,{"$f":"SUM(AD82:AH86)","v":0},null,null,{"$f":"IF(O86>0,O86,0)","v":0},{"$f":"IF(O86<0,O86,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA87","v":0},{"$f":"AF87","v":0},"Impact"]
[]
[null,8,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C90=\"Retired\",0,L90*(N90+4*N92+N91)/6)","v":0},{"$f":"IF(C90=\"Retired\",\"NO RISK\",IF(L90>(L$10-0.01),P$10,IF(L90>(L$11-0.01),P$11,IF(L90>(L$12-0.01),P$12,IF(L90>(L$13-0.01),P$13,IF(L90>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C90=\"Retired\",\"NO RISK\",IF(ABS(N92)>O$10,Q$10,IF(ABS(N92)>O$11,Q$11,IF(ABS(N92)>O$12,Q$12,IF(ABS(N92)>O$13,Q$13,IF(ABS(N92)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q90=\"VERY LOW\",Q94=\"very low\",P90=\"VERY high\"),\"$,Mo\",IF(AND(Q90=\"VERY LOW\",P90=\"VERY high\"),\"$\",IF(AND(Q94=\"very low\",P90=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"LOW\",Q94=\"low\",P90=\"VERY high\"),\"$,Mo\",IF(AND(Q90=\"LOW\",P90=\"VERY high\"),\"$\",IF(AND(Q94=\"low\",P90=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"medium\",Q94=\"medium\",P90=\"VERY high\"),\"$,Mo\",IF(AND(Q90=\"medium\",P90=\"VERY high\"),\"$\",IF(AND(Q94=\"medium\",P90=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"high\",Q94=\"high\",P90=\"VERY high\"),\"$,Mo\",IF(AND(Q90=\"high\",P90=\"VERY high\"),\"$\",IF(AND(Q94=\"high\",P90=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"VERY high\",Q94=\"VERY high\",P90=\"VERY high\"),\"$,Mo\",IF(AND(Q90=\"VERY high\",P90=\"VERY high\"),\"$\",IF(AND(Q94=\"VERY high\",P90=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T90=\"$\",(T90=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U90=\"$\",(U90=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V90=\"$\",(V90=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W90=\"$\",(W90=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X90=\"$\",(X90=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T90=\"Mo\",(T90=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U90=\"Mo\",(U90=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V90=\"Mo\",(V90=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W90=\"Mo\",(W90=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X90=\"Mo\",(X90=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK90=\"Accept\",0,(N90*L90)-AR92)","v":0},null,{"$f":"IF(AT92=0,0,(N90*L90)-AT92)","v":0},{"$f":"O90-AT90","v":0},null,{"$f":"IF($D90=\"ROW\",$AR92,\" \")","v":" "},{"$f":"IF($D90=\"ROW\",$AS92,\" \")","v":" "},{"$f":"IF($D90=\"ENV\",$AR92,\" \")","v":" "},{"$f":"IF($D90=\"ENV\",$AS92,\" \")","v":" "},{"$f":"IF($D90=\"ENG\",$AR92,\" \")","v":" "},{"$f":"IF($D90=\"ENG\",$AS92,\" \")","v":" "},{"$f":"IF($D90=\"TRF\",$AR92,\" \")","v":" "},{"$f":"IF($D90=\"TRF\",$AS92,\" \")","v":" "},{"$f":"IF($D90=\"STK\",$AR92,\" \")","v":" "},{"$f":"IF($D90=\"STK\",$AS92,\" \")","v":" "},{"$f":"IF($D90=\"UNF\",$AR92,\" \")","v":" "},{"$f":"IF($D90=\"UNF\",$AS92,\" \")","v":" "},{"$f":"IF($D90=\"MKT\",$AR92,\" \")","v":" "},{"$f":"IF($D90=\"MKT\",$AS92,\" \")","v":" "},{"$f":"IF($D90=\"UTL\",$AR92,\" \")","v":" "},{"$f":"IF($D90=\"UTL\",$AS92,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q90=\"VERY LOW\",Q94=\"very low\",P90=\"high\"),\"$,Mo\",IF(AND(Q90=\"VERY LOW\",P90=\"high\"),\"$\",IF(AND(Q94=\"very low\",P90=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"LOW\",Q94=\"low\",P90=\"high\"),\"$,Mo\",IF(AND(Q90=\"LOW\",P90=\"high\"),\"$\",IF(AND(Q94=\"low\",P90=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"medium\",Q94=\"medium\",P90=\"high\"),\"$,Mo\",IF(AND(Q90=\"medium\",P90=\"high\"),\"$\",IF(AND(Q94=\"medium\",P90=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"high\",Q94=\"high\",P90=\"high\"),\"$,Mo\",IF(AND(Q90=\"high\",P90=\"high\"),\"$\",IF(AND(Q94=\"high\",P90=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"VERY high\",Q94=\"VERY high\",P90=\"high\"),\"$,Mo\",IF(AND(Q90=\"VERY high\",P90=\"high\"),\"$\",IF(AND(Q94=\"VERY high\",P90=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T91=\"$\",(T91=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U91=\"$\",(U91=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V91=\"$\",(V91=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W91=\"$\",(W91=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X91=\"$\",(X91=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T91=\"Mo\",(T91=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U91=\"Mo\",(U91=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V91=\"Mo\",(V91=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W91=\"Mo\",(W91=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X91=\"Mo\",(X91=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O90>0,O90,0)","v":0},{"$f":"IF(O90<0,O90,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK90=\"Accept\",0,(N91*L90)-AR92)","v":0},null,{"$f":"IF(AT92=0,0,(N91*L90)-AT92)","v":0},null,null,"RISK 8  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q90=\"VERY LOW\",Q94=\"very low\",P90=\"medium\"),\"$,Mo\",IF(AND(Q90=\"VERY LOW\",P90=\"medium\"),\"$\",IF(AND(Q94=\"very low\",P90=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"LOW\",Q94=\"low\",P90=\"medium\"),\"$,Mo\",IF(AND(Q90=\"LOW\",P90=\"medium\"),\"$\",IF(AND(Q94=\"low\",P90=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"medium\",Q94=\"medium\",P90=\"medium\"),\"$,Mo\",IF(AND(Q90=\"medium\",P90=\"medium\"),\"$\",IF(AND(Q94=\"medium\",P90=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"high\",Q94=\"high\",P90=\"medium\"),\"$,Mo\",IF(AND(Q90=\"high\",P90=\"medium\"),\"$\",IF(AND(Q94=\"high\",P90=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"VERY high\",Q94=\"VERY high\",P90=\"medium\"),\"$,Mo\",IF(AND(Q90=\"VERY high\",P90=\"medium\"),\"$\",IF(AND(Q94=\"VERY high\",P90=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T92=\"$\",(T92=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U92=\"$\",(U92=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V92=\"$\",(V92=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W92=\"$\",(W92=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X92=\"$\",(X92=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T92=\"Mo\",(T92=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U92=\"Mo\",(U92=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V92=\"Mo\",(V92=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W92=\"Mo\",(W92=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X92=\"Mo\",(X92=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK90=\"Accept\",0,(N92*L90)-AR92)","v":0},null,{"$f":"IF(AT92=0,0,(N92*L90)-AT92)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q90=\"VERY LOW\",Q94=\"very low\",P90=\"LOW\"),\"$,Mo\",IF(AND(Q90=\"VERY LOW\",P90=\"LOW\"),\"$\",IF(AND(Q94=\"very low\",P90=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"LOW\",Q94=\"low\",P90=\"LOW\"),\"$,Mo\",IF(AND(Q90=\"LOW\",P90=\"LOW\"),\"$\",IF(AND(Q94=\"low\",P90=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"medium\",Q94=\"medium\",P90=\"LOW\"),\"$,Mo\",IF(AND(Q90=\"medium\",P90=\"LOW\"),\"$\",IF(AND(Q94=\"medium\",P90=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"high\",Q94=\"high\",P90=\"LOW\"),\"$,Mo\",IF(AND(Q90=\"high\",P90=\"LOW\"),\"$\",IF(AND(Q94=\"high\",P90=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"VERY high\",Q94=\"VERY high\",P90=\"low\"),\"$,Mo\",IF(AND(Q90=\"VERY high\",P90=\"low\"),\"$\",IF(AND(Q94=\"VERY high\",P90=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T93=\"$\",(T93=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U93=\"$\",(U93=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V93=\"$\",(V93=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W93=\"$\",(W93=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X93=\"$\",(X93=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T93=\"Mo\",(T93=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U93=\"Mo\",(U93=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V93=\"Mo\",(V93=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W93=\"Mo\",(W93=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X93=\"Mo\",(X93=\"$,Mo\")),32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C90=\"Retired\",0,L90*(N94+4*N96+N95)/6)","v":0},null,{"$f":"IF(C90=\"Retired\",\"NO RISK\",IF(ABS(N96)>S$10,Q$10,IF(ABS(N96)>S$11,Q$11,IF(ABS(N96)>S$12,Q$12,IF(ABS(N96)>S$13,Q$13,IF(ABS(N96)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q90=\"VERY LOW\",Q94=\"very low\",P90=\"VERY LOW\"),\"$,Mo\",IF(AND(Q90=\"VERY LOW\",P90=\"VERY LOW\"),\"$\",IF(AND(Q94=\"very low\",P90=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"LOW\",Q94=\"low\",P90=\"VERY LOW\"),\"$,Mo\",IF(AND(Q90=\"LOW\",P90=\"VERY LOW\"),\"$\",IF(AND(Q94=\"low\",P90=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"medium\",Q94=\"medium\",P90=\"VERY LOW\"),\"$,Mo\",IF(AND(Q90=\"medium\",P90=\"VERY LOW\"),\"$\",IF(AND(Q94=\"medium\",P90=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"high\",Q94=\"high\",P90=\"VERY LOW\"),\"$,Mo\",IF(AND(Q90=\"high\",P90=\"VERY LOW\"),\"$\",IF(AND(Q94=\"high\",P90=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q90=\"VERY high\",Q94=\"VERY high\",P90=\"VERY LOW\"),\"$,Mo\",IF(AND(Q90=\"VERY high\",P90=\"VERY LOW\"),\"$\",IF(AND(Q94=\"VERY high\",P90=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T94=\"$\",(T94=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U94=\"$\",(U94=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V94=\"$\",(V94=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W94=\"$\",(W94=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X94=\"$\",(X94=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T94=\"Mo\",(T94=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U94=\"Mo\",(U94=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V94=\"Mo\",(V94=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W94=\"Mo\",(W94=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X94=\"Mo\",(X94=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y90:AC94)","v":0},null,null,null,null,{"$f":"SUM(AD90:AH94)","v":0},null,null,{"$f":"IF(O94>0,O94,0)","v":0},{"$f":"IF(O94<0,O94,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA95","v":0},{"$f":"AF95","v":0},"Impact"]
[]
[null,9,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C98=\"Retired\",0,L98*(N98+4*N100+N99)/6)","v":0},{"$f":"IF(C98=\"Retired\",\"NO RISK\",IF(L98>(L$10-0.01),P$10,IF(L98>(L$11-0.01),P$11,IF(L98>(L$12-0.01),P$12,IF(L98>(L$13-0.01),P$13,IF(L98>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C98=\"Retired\",\"NO RISK\",IF(ABS(N100)>O$10,Q$10,IF(ABS(N100)>O$11,Q$11,IF(ABS(N100)>O$12,Q$12,IF(ABS(N100)>O$13,Q$13,IF(ABS(N100)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q98=\"VERY LOW\",Q102=\"very low\",P98=\"VERY high\"),\"$,Mo\",IF(AND(Q98=\"VERY LOW\",P98=\"VERY high\"),\"$\",IF(AND(Q102=\"very low\",P98=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"LOW\",Q102=\"low\",P98=\"VERY high\"),\"$,Mo\",IF(AND(Q98=\"LOW\",P98=\"VERY high\"),\"$\",IF(AND(Q102=\"low\",P98=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"medium\",Q102=\"medium\",P98=\"VERY high\"),\"$,Mo\",IF(AND(Q98=\"medium\",P98=\"VERY high\"),\"$\",IF(AND(Q102=\"medium\",P98=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"high\",Q102=\"high\",P98=\"VERY high\"),\"$,Mo\",IF(AND(Q98=\"high\",P98=\"VERY high\"),\"$\",IF(AND(Q102=\"high\",P98=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"VERY high\",Q102=\"VERY high\",P98=\"VERY high\"),\"$,Mo\",IF(AND(Q98=\"VERY high\",P98=\"VERY high\"),\"$\",IF(AND(Q102=\"VERY high\",P98=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T98=\"$\",(T98=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U98=\"$\",(U98=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V98=\"$\",(V98=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W98=\"$\",(W98=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X98=\"$\",(X98=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T98=\"Mo\",(T98=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U98=\"Mo\",(U98=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V98=\"Mo\",(V98=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W98=\"Mo\",(W98=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X98=\"Mo\",(X98=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK98=\"Accept\",0,(N98*L98)-AR100)","v":0},null,{"$f":"IF(AT100=0,0,(N98*L98)-AT100)","v":0},{"$f":"O98-AT98","v":0},null,{"$f":"IF($D98=\"ROW\",$AR100,\" \")","v":" "},{"$f":"IF($D98=\"ROW\",$AS100,\" \")","v":" "},{"$f":"IF($D98=\"ENV\",$AR100,\" \")","v":" "},{"$f":"IF($D98=\"ENV\",$AS100,\" \")","v":" "},{"$f":"IF($D98=\"ENG\",$AR100,\" \")","v":" "},{"$f":"IF($D98=\"ENG\",$AS100,\" \")","v":" "},{"$f":"IF($D98=\"TRF\",$AR100,\" \")","v":" "},{"$f":"IF($D98=\"TRF\",$AS100,\" \")","v":" "},{"$f":"IF($D98=\"STK\",$AR100,\" \")","v":" "},{"$f":"IF($D98=\"STK\",$AS100,\" \")","v":" "},{"$f":"IF($D98=\"UNF\",$AR100,\" \")","v":" "},{"$f":"IF($D98=\"UNF\",$AS100,\" \")","v":" "},{"$f":"IF($D98=\"MKT\",$AR100,\" \")","v":" "},{"$f":"IF($D98=\"MKT\",$AS100,\" \")","v":" "},{"$f":"IF($D98=\"UTL\",$AR100,\" \")","v":" "},{"$f":"IF($D98=\"UTL\",$AS100,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q98=\"VERY LOW\",Q102=\"very low\",P98=\"high\"),\"$,Mo\",IF(AND(Q98=\"VERY LOW\",P98=\"high\"),\"$\",IF(AND(Q102=\"very low\",P98=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"LOW\",Q102=\"low\",P98=\"high\"),\"$,Mo\",IF(AND(Q98=\"LOW\",P98=\"high\"),\"$\",IF(AND(Q102=\"low\",P98=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"medium\",Q102=\"medium\",P98=\"high\"),\"$,Mo\",IF(AND(Q98=\"medium\",P98=\"high\"),\"$\",IF(AND(Q102=\"medium\",P98=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"high\",Q102=\"high\",P98=\"high\"),\"$,Mo\",IF(AND(Q98=\"high\",P98=\"high\"),\"$\",IF(AND(Q102=\"high\",P98=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"VERY high\",Q102=\"VERY high\",P98=\"high\"),\"$,Mo\",IF(AND(Q98=\"VERY high\",P98=\"high\"),\"$\",IF(AND(Q102=\"VERY high\",P98=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T99=\"$\",(T99=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U99=\"$\",(U99=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V99=\"$\",(V99=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W99=\"$\",(W99=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X99=\"$\",(X99=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T99=\"Mo\",(T99=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U99=\"Mo\",(U99=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V99=\"Mo\",(V99=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W99=\"Mo\",(W99=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X99=\"Mo\",(X99=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O98>0,O98,0)","v":0},{"$f":"IF(O98<0,O98,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK98=\"Accept\",0,(N99*L98)-AR100)","v":0},null,{"$f":"IF(AT100=0,0,(N99*L98)-AT100)","v":0},null,null,"RISK 9  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q98=\"VERY LOW\",Q102=\"very low\",P98=\"medium\"),\"$,Mo\",IF(AND(Q98=\"VERY LOW\",P98=\"medium\"),\"$\",IF(AND(Q102=\"very low\",P98=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"LOW\",Q102=\"low\",P98=\"medium\"),\"$,Mo\",IF(AND(Q98=\"LOW\",P98=\"medium\"),\"$\",IF(AND(Q102=\"low\",P98=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"medium\",Q102=\"medium\",P98=\"medium\"),\"$,Mo\",IF(AND(Q98=\"medium\",P98=\"medium\"),\"$\",IF(AND(Q102=\"medium\",P98=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"high\",Q102=\"high\",P98=\"medium\"),\"$,Mo\",IF(AND(Q98=\"high\",P98=\"medium\"),\"$\",IF(AND(Q102=\"high\",P98=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"VERY high\",Q102=\"VERY high\",P98=\"medium\"),\"$,Mo\",IF(AND(Q98=\"VERY high\",P98=\"medium\"),\"$\",IF(AND(Q102=\"VERY high\",P98=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T100=\"$\",(T100=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U100=\"$\",(U100=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V100=\"$\",(V100=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W100=\"$\",(W100=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X100=\"$\",(X100=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T100=\"Mo\",(T100=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U100=\"Mo\",(U100=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V100=\"Mo\",(V100=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W100=\"Mo\",(W100=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X100=\"Mo\",(X100=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK98=\"Accept\",0,(N100*L98)-AR100)","v":0},null,{"$f":"IF(AT100=0,0,(N100*L98)-AT100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q98=\"VERY LOW\",Q102=\"very low\",P98=\"LOW\"),\"$,Mo\",IF(AND(Q98=\"VERY LOW\",P98=\"LOW\"),\"$\",IF(AND(Q102=\"very low\",P98=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"LOW\",Q102=\"low\",P98=\"LOW\"),\"$,Mo\",IF(AND(Q98=\"LOW\",P98=\"LOW\"),\"$\",IF(AND(Q102=\"low\",P98=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"medium\",Q102=\"medium\",P98=\"LOW\"),\"$,Mo\",IF(AND(Q98=\"medium\",P98=\"LOW\"),\"$\",IF(AND(Q102=\"medium\",P98=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"high\",Q102=\"high\",P98=\"LOW\"),\"$,Mo\",IF(AND(Q98=\"high\",P98=\"LOW\"),\"$\",IF(AND(Q102=\"high\",P98=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"VERY high\",Q102=\"VERY high\",P98=\"low\"),\"$,Mo\",IF(AND(Q98=\"VERY high\",P98=\"low\"),\"$\",IF(AND(Q102=\"VERY high\",P98=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T101=\"$\",(T101=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U101=\"$\",(U101=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V101=\"$\",(V101=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W101=\"$\",(W101=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X101=\"$\",(X101=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T101=\"Mo\",(T101=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U101=\"Mo\",(U101=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V101=\"Mo\",(V101=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W101=\"Mo\",(W101=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X101=\"Mo\",(X101=\"$,Mo\")),32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C98=\"Retired\",0,L98*(N102+4*N104+N103)/6)","v":0},null,{"$f":"IF(C98=\"Retired\",\"NO RISK\",IF(ABS(N104)>S$10,Q$10,IF(ABS(N104)>S$11,Q$11,IF(ABS(N104)>S$12,Q$12,IF(ABS(N104)>S$13,Q$13,IF(ABS(N104)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q98=\"VERY LOW\",Q102=\"very low\",P98=\"VERY LOW\"),\"$,Mo\",IF(AND(Q98=\"VERY LOW\",P98=\"VERY LOW\"),\"$\",IF(AND(Q102=\"very low\",P98=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"LOW\",Q102=\"low\",P98=\"VERY LOW\"),\"$,Mo\",IF(AND(Q98=\"LOW\",P98=\"VERY LOW\"),\"$\",IF(AND(Q102=\"low\",P98=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"medium\",Q102=\"medium\",P98=\"VERY LOW\"),\"$,Mo\",IF(AND(Q98=\"medium\",P98=\"VERY LOW\"),\"$\",IF(AND(Q102=\"medium\",P98=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"high\",Q102=\"high\",P98=\"VERY LOW\"),\"$,Mo\",IF(AND(Q98=\"high\",P98=\"VERY LOW\"),\"$\",IF(AND(Q102=\"high\",P98=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q98=\"VERY high\",Q102=\"VERY high\",P98=\"VERY LOW\"),\"$,Mo\",IF(AND(Q98=\"VERY high\",P98=\"VERY LOW\"),\"$\",IF(AND(Q102=\"VERY high\",P98=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T102=\"$\",(T102=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U102=\"$\",(U102=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V102=\"$\",(V102=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W102=\"$\",(W102=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X102=\"$\",(X102=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T102=\"Mo\",(T102=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U102=\"Mo\",(U102=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V102=\"Mo\",(V102=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W102=\"Mo\",(W102=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X102=\"Mo\",(X102=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y98:AC102)","v":0},null,null,null,null,{"$f":"SUM(AD98:AH102)","v":0},null,null,{"$f":"IF(O102>0,O102,0)","v":0},{"$f":"IF(O102<0,O102,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA103","v":0},{"$f":"AF103","v":0},"Impact"]
[]
[null,10,"Active",null,null,null,"Design","Threat",null,null,"Cost",null,"MIN",null,{"$f":"IF(C106=\"Retired\",0,L106*(N106+4*N108+N107)/6)","v":0},{"$f":"IF(C106=\"Retired\",\"NO RISK\",IF(L106>(L$10-0.01),P$10,IF(L106>(L$11-0.01),P$11,IF(L106>(L$12-0.01),P$12,IF(L106>(L$13-0.01),P$13,IF(L106>(L$14),P$14,\"NO RISK\"))))))","v":"NO RISK"},{"$f":"IF(C106=\"Retired\",\"NO RISK\",IF(ABS(N108)>O$10,Q$10,IF(ABS(N108)>O$11,Q$11,IF(ABS(N108)>O$12,Q$12,IF(ABS(N108)>O$13,Q$13,IF(ABS(N108)>O$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},"Probability","VH",{"$f":"IF(AND(Q106=\"VERY LOW\",Q110=\"very low\",P106=\"VERY high\"),\"$,Mo\",IF(AND(Q106=\"VERY LOW\",P106=\"VERY high\"),\"$\",IF(AND(Q110=\"very low\",P106=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"LOW\",Q110=\"low\",P106=\"VERY high\"),\"$,Mo\",IF(AND(Q106=\"LOW\",P106=\"VERY high\"),\"$\",IF(AND(Q110=\"low\",P106=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"medium\",Q110=\"medium\",P106=\"VERY high\"),\"$,Mo\",IF(AND(Q106=\"medium\",P106=\"VERY high\"),\"$\",IF(AND(Q110=\"medium\",P106=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"high\",Q110=\"high\",P106=\"VERY high\"),\"$,Mo\",IF(AND(Q106=\"high\",P106=\"VERY high\"),\"$\",IF(AND(Q110=\"high\",P106=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"VERY high\",Q110=\"VERY high\",P106=\"VERY high\"),\"$,Mo\",IF(AND(Q106=\"VERY high\",P106=\"VERY high\"),\"$\",IF(AND(Q110=\"VERY high\",P106=\"VERY high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T106=\"$\",(T106=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U106=\"$\",(U106=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V106=\"$\",(V106=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W106=\"$\",(W106=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X106=\"$\",(X106=\"$,Mo\")),80,0)","v":0},{"$f":"IF(OR(T106=\"Mo\",(T106=\"$,Mo\")),5,0)","v":0},{"$f":"IF(OR(U106=\"Mo\",(U106=\"$,Mo\")),10,0)","v":0},{"$f":"IF(OR(V106=\"Mo\",(V106=\"$,Mo\")),20,0)","v":0},{"$f":"IF(OR(W106=\"Mo\",(W106=\"$,Mo\")),40,0)","v":0},{"$f":"IF(OR(X106=\"Mo\",(X106=\"$,Mo\")),60,0)","v":0},null,null,null,null,null,null,null,"NEAR",null,null,{"$f":"IF(AK106=\"Accept\",0,(N106*L106)-AR108)","v":0},null,{"$f":"IF(AT108=0,0,(N106*L106)-AT108)","v":0},{"$f":"O106-AT106","v":0},null,{"$f":"IF($D106=\"ROW\",$AR108,\" \")","v":" "},{"$f":"IF($D106=\"ROW\",$AS108,\" \")","v":" "},{"$f":"IF($D106=\"ENV\",$AR108,\" \")","v":" "},{"$f":"IF($D106=\"ENV\",$AS108,\" \")","v":" "},{"$f":"IF($D106=\"ENG\",$AR108,\" \")","v":" "},{"$f":"IF($D106=\"ENG\",$AS108,\" \")","v":" "},{"$f":"IF($D106=\"TRF\",$AR108,\" \")","v":" "},{"$f":"IF($D106=\"TRF\",$AS108,\" \")","v":" "},{"$f":"IF($D106=\"STK\",$AR108,\" \")","v":" "},{"$f":"IF($D106=\"STK\",$AS108,\" \")","v":" "},{"$f":"IF($D106=\"UNF\",$AR108,\" \")","v":" "},{"$f":"IF($D106=\"UNF\",$AS108,\" \")","v":" "},{"$f":"IF($D106=\"MKT\",$AR108,\" \")","v":" "},{"$f":"IF($D106=\"MKT\",$AS108,\" \")","v":" "},{"$f":"IF($D106=\"UTL\",$AR108,\" \")","v":" "},{"$f":"IF($D106=\"UTL\",$AS108,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,null,"H",{"$f":"IF(AND(Q106=\"VERY LOW\",Q110=\"very low\",P106=\"high\"),\"$,Mo\",IF(AND(Q106=\"VERY LOW\",P106=\"high\"),\"$\",IF(AND(Q110=\"very low\",P106=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"LOW\",Q110=\"low\",P106=\"high\"),\"$,Mo\",IF(AND(Q106=\"LOW\",P106=\"high\"),\"$\",IF(AND(Q110=\"low\",P106=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"medium\",Q110=\"medium\",P106=\"high\"),\"$,Mo\",IF(AND(Q106=\"medium\",P106=\"high\"),\"$\",IF(AND(Q110=\"medium\",P106=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"high\",Q110=\"high\",P106=\"high\"),\"$,Mo\",IF(AND(Q106=\"high\",P106=\"high\"),\"$\",IF(AND(Q110=\"high\",P106=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"VERY high\",Q110=\"VERY high\",P106=\"high\"),\"$,Mo\",IF(AND(Q106=\"VERY high\",P106=\"high\"),\"$\",IF(AND(Q110=\"VERY high\",P106=\"high\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T107=\"$\",(T107=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U107=\"$\",(U107=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V107=\"$\",(V107=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W107=\"$\",(W107=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X107=\"$\",(X107=\"$,Mo\")),64,0)","v":0},{"$f":"IF(OR(T107=\"Mo\",(T107=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(U107=\"Mo\",(U107=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(V107=\"Mo\",(V107=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(W107=\"Mo\",(W107=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(X107=\"Mo\",(X107=\"$,Mo\")),64,0)","v":0},{"$f":"IF(O106>0,O106,0)","v":0},{"$f":"IF(O106<0,O106,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(AK106=\"Accept\",0,(N107*L106)-AR108)","v":0},null,{"$f":"IF(AT108=0,0,(N107*L106)-AT108)","v":0},null,null,"RISK 10  >>>>>>>>>>>>>>>>"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Most Likely",null,null,null,null,null,"M",{"$f":"IF(AND(Q106=\"VERY LOW\",Q110=\"very low\",P106=\"medium\"),\"$,Mo\",IF(AND(Q106=\"VERY LOW\",P106=\"medium\"),\"$\",IF(AND(Q110=\"very low\",P106=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"LOW\",Q110=\"low\",P106=\"medium\"),\"$,Mo\",IF(AND(Q106=\"LOW\",P106=\"medium\"),\"$\",IF(AND(Q110=\"low\",P106=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"medium\",Q110=\"medium\",P106=\"medium\"),\"$,Mo\",IF(AND(Q106=\"medium\",P106=\"medium\"),\"$\",IF(AND(Q110=\"medium\",P106=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"high\",Q110=\"high\",P106=\"medium\"),\"$,Mo\",IF(AND(Q106=\"high\",P106=\"medium\"),\"$\",IF(AND(Q110=\"high\",P106=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"VERY high\",Q110=\"VERY high\",P106=\"medium\"),\"$,Mo\",IF(AND(Q106=\"VERY high\",P106=\"medium\"),\"$\",IF(AND(Q110=\"VERY high\",P106=\"medium\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T108=\"$\",(T108=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U108=\"$\",(U108=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V108=\"$\",(V108=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W108=\"$\",(W108=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X108=\"$\",(X108=\"$,Mo\")),48,0)","v":0},{"$f":"IF(OR(T108=\"Mo\",(T108=\"$,Mo\")),3,0)","v":0},{"$f":"IF(OR(U108=\"Mo\",(U108=\"$,Mo\")),6,0)","v":0},{"$f":"IF(OR(V108=\"Mo\",(V108=\"$,Mo\")),12,0)","v":0},{"$f":"IF(OR(W108=\"Mo\",(W108=\"$,Mo\")),24,0)","v":0},{"$f":"IF(OR(X108=\"Mo\",(X108=\"$,Mo\")),48,0)","v":0},null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AK106=\"Accept\",0,(N108*L106)-AR108)","v":0},null,{"$f":"IF(AT108=0,0,(N108*L106)-AT108)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(Q106=\"VERY LOW\",Q110=\"very low\",P106=\"LOW\"),\"$,Mo\",IF(AND(Q106=\"VERY LOW\",P106=\"LOW\"),\"$\",IF(AND(Q110=\"very low\",P106=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"LOW\",Q110=\"low\",P106=\"LOW\"),\"$,Mo\",IF(AND(Q106=\"LOW\",P106=\"LOW\"),\"$\",IF(AND(Q110=\"low\",P106=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"medium\",Q110=\"medium\",P106=\"LOW\"),\"$,Mo\",IF(AND(Q106=\"medium\",P106=\"LOW\"),\"$\",IF(AND(Q110=\"medium\",P106=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"high\",Q110=\"high\",P106=\"LOW\"),\"$,Mo\",IF(AND(Q106=\"high\",P106=\"LOW\"),\"$\",IF(AND(Q110=\"high\",P106=\"LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"VERY high\",Q110=\"VERY high\",P106=\"low\"),\"$,Mo\",IF(AND(Q106=\"VERY high\",P106=\"low\"),\"$\",IF(AND(Q110=\"VERY high\",P106=\"low\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T109=\"$\",(T109=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U109=\"$\",(U109=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V109=\"$\",(V109=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W109=\"$\",(W109=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X109=\"$\",(X109=\"$,Mo\")),32,0)","v":0},{"$f":"IF(OR(T109=\"Mo\",(T109=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(U109=\"Mo\",(U109=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(V109=\"Mo\",(V109=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(W109=\"Mo\",(W109=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(X109=\"Mo\",(X109=\"$,Mo\")),32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Schedule",null,"MIN",null,{"$f":"IF(C106=\"Retired\",0,L106*(N110+4*N112+N111)/6)","v":0},null,{"$f":"IF(C106=\"Retired\",\"NO RISK\",IF(ABS(N112)>S$10,Q$10,IF(ABS(N112)>S$11,Q$11,IF(ABS(N112)>S$12,Q$12,IF(ABS(N112)>S$13,Q$13,IF(ABS(N112)>S$14,Q$14,\"NO RISK\"))))))","v":"NO RISK"},null,"VL",{"$f":"IF(AND(Q106=\"VERY LOW\",Q110=\"very low\",P106=\"VERY LOW\"),\"$,Mo\",IF(AND(Q106=\"VERY LOW\",P106=\"VERY LOW\"),\"$\",IF(AND(Q110=\"very low\",P106=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"LOW\",Q110=\"low\",P106=\"VERY LOW\"),\"$,Mo\",IF(AND(Q106=\"LOW\",P106=\"VERY LOW\"),\"$\",IF(AND(Q110=\"low\",P106=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"medium\",Q110=\"medium\",P106=\"VERY LOW\"),\"$,Mo\",IF(AND(Q106=\"medium\",P106=\"VERY LOW\"),\"$\",IF(AND(Q110=\"medium\",P106=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"high\",Q110=\"high\",P106=\"VERY LOW\"),\"$,Mo\",IF(AND(Q106=\"high\",P106=\"VERY LOW\"),\"$\",IF(AND(Q110=\"high\",P106=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(AND(Q106=\"VERY high\",Q110=\"VERY high\",P106=\"VERY LOW\"),\"$,Mo\",IF(AND(Q106=\"VERY high\",P106=\"VERY LOW\"),\"$\",IF(AND(Q110=\"VERY high\",P106=\"VERY LOW\"),\"Mo\",\"\")))","v":""},{"$f":"IF(OR(T110=\"$\",(T110=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U110=\"$\",(U110=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V110=\"$\",(V110=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W110=\"$\",(W110=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X110=\"$\",(X110=\"$,Mo\")),16,0)","v":0},{"$f":"IF(OR(T110=\"Mo\",(T110=\"$,Mo\")),1,0)","v":0},{"$f":"IF(OR(U110=\"Mo\",(U110=\"$,Mo\")),2,0)","v":0},{"$f":"IF(OR(V110=\"Mo\",(V110=\"$,Mo\")),4,0)","v":0},{"$f":"IF(OR(W110=\"Mo\",(W110=\"$,Mo\")),8,0)","v":0},{"$f":"IF(OR(X110=\"Mo\",(X110=\"$,Mo\")),16,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAX",null,null,null,null,"Relative risk",null,"VL","L","M","H","VH",null,null,{"$f":"SUM(Y106:AC110)","v":0},null,null,null,null,{"$f":"SUM(AD106:AH110)","v":0},null,null,{"$f":"IF(O110>0,O110,0)","v":0},{"$f":"IF(O110<0,O110,0)","v":0}]
[null,null,null,null,null,null,null,"Threat",null,null,null,null,"Most Likely",null,null,null,null,{"$f":"AA111","v":0},{"$f":"AF111","v":0},"Impact"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"min",{"$f":"SUM(N34,N42,N50,N58,N66,N74,N82,N90,N98,N106)","v":0},"Leverage",{"$f":"SUM(AJ35,AJ43,AJ51,AJ59,AJ67,AJ75,AJ83,AJ91,AJ99,AJ107)","v":0},{"$f":"SUM(AJ39,AJ47,AJ55,AJ63,AJ71,AJ79,AJ87,AJ95,AJ103,AJ111)","v":0},"Months","Relative risk",null,null,"Probability X Impact",null,null,null,null,"Matrix to determine relative risk: Cost and Schedule:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(AS106,AS98,AS90,AS82,AS74,AS66,AS58,AS50,AS42,AS34)","v":0},null,{"$f":"SUM(AU106,AU98,AU90,AU82,AU74,AU66,AU58,AU50,AU42,AU34)","v":0},null,null,{"$f":"SUM(AX34:AX73)","v":0},{"$f":"SUM(AY34:AY72)","v":0},{"$f":"SUM(AZ34:AZ72)","v":0},{"$f":"SUM(BA34:BA72)","v":0},{"$f":"SUM(BB34:BB73)","v":0},{"$f":"SUM(BC34:BC72)","v":0},{"$f":"SUM(BD34:BD72)","v":0},{"$f":"SUM(BE34:BE72)","v":0},{"$f":"SUM(BF34:BF72)","v":0},0,0,0,0,0,0,0]
[null,"Instructions for inserting additional risks:",null,null,null,null,null,null,null,null,null,"max",{"$f":"SUM(N35,N43,N51,N59,N67,N75,N83,N91,N99,N107)","v":0},"Exposure",{"$f":"SUM(AI35,AI43,AI51,AI59,AI67,AI75,AI83,AI91,AI99,AI107)","v":0},{"$f":"SUM(AI39,AI47,AI55,AI63,AI71,AI79,AI87,AI95,AI103,AI111)","v":0},"Months",{"$f":"R40+R48+R56+R64+R72+R80+R88+R96+R104+R112","v":0},{"$f":"S40+S48+S56+S64+S72+S80+S88+S96+S104+S112","v":0},null,"Probability factors = 1,2,3,4,5 (VL to VH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AS107,AS99,AS91,AS83,AS75,AS67,AS59,AS51,AS43,AS35)","v":0},null,{"$f":"SUM(AU107,AU99,AU91,AU83,AU75,AU67,AU59,AU51,AU43,AU35)","v":0},null,null,{"$f":"AW76","v":"ROW"},null,{"$f":"AW77","v":"ENV"},null,{"$f":"AW78","v":"ENG"},null,{"$f":"AW79","v":"TRF"},null,{"$f":"AW81","v":"STK"},null,{"$f":"AW82","v":"UNF"},null,{"$f":"AW83","v":"MKT"},null,{"$f":"AW84","v":"UTL"}]
[null,1,null,"Save file",null,null,null,null,null,null,null,"most likely",{"$f":"SUM(N36,N44,N52,N60,N68,N76,N84,N92,N100,N108)","v":0},"Most likely",{"$f":"SUM(O34, O42, O50, O58, O66,O74,O82,O90,O98,O106)","v":0},{"$f":"SUM(O38,O46,O54,O62,O70,O78,O86,O94,O102,O110)","v":0},"Months","cost","schedule",null,"Impact factors = 1,2,4,8,16 (VL to VH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR108,AR100,AR92,AR84,AR76,AR68,AR60,AR52,AR44,AR36)","v":0},{"$f":"SUM(AS108,AS100,AS92,AS84,AS76,AS68,AS60,AS52,AS44,AS36)","v":0},{"$f":"SUM(AT108,AT100,AT92,AT84,AT76,AT68,AT60,AT52,AT44,AT36)","v":0},{"$f":"SUM(AU108,AU100,AU92,AU84,AU76,AU68,AU60,AU52,AU44,AU36)","v":0}]
[null,2,null,"Go to \"Review\" menu tab at top of workbook",null,null,null,null,null,null,null,null,"^",null,"^","^",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"^","^","^","^"]
[null,3,null,"Click on Share Workbook",null,null,null,null,null,null,null,null,"Total",null,"Est","Est",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total","Total","Total","Total"]
[null,4,null,"De-select the box to allow changes by other users.  Click on OK.",null,null,null,null,null,null,null,null,"Est",null,"Exp Value","Exp Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Est","Calculated","Actual","Calculated"]
[null,null,null,"Click on Yes in the dialog box.",null,null,null,null,null,null,null,null,"Cost",null,"of","of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost","Est","Cost","Est"]
[null,5,null,"De-select the Show Ink and Show All Comments options on the menu bar",null,null,null,null,null,null,null,null,"Impacts",null,"Cost","Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to","Cost","to","Cost"]
[null,6,null,"Place the cursor over the group of rows to copy.",null,null,null,null,null,null,null,null,"(range)",null,"Impacts","Impacts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Respond","Avoided","Respond","Avoided"]
[null,null,null,"Include the narrow, shaded row at the top of the group.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"most","(range)",null,"(range)"]
[null,null,null,"Don't include the narrow, shaded row at the bottom of the group.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"likely"]
[null,null,null,"For example, to add a blank row at the bottom, select rows 105-112 with the cursor on the row numbers."]
[null,null,null,"Eight rows should be highlighted to add one risk."]
[null,7,null,"Use CTRL C to copy the rows"]
[null,8,null,"Hover over row number for the narrow, shaded row that will become the bottom of the new group."]
[null,null,null,"For example, hover over 105 to insert above risk element 10."]
[null,null,null,"Right click and select Insert Copied Rows."]
[null,9,null,"Renumber the Risk Elements to include the added rows."]
[null,10,null,"Update the summation cells at the bottom of the worksheet by adding in the appropriate columns from the new rows."]
[null,null,null,"Add the cells to the formula in increments of 8."]
[null,11,null,"Go back to Share Workbook and select the option to allow changes"]
[null,12,null,"Click OK twice"]
[null,13,null,"Click on the options to Show All Comments and Show Ink"]
[null,14,null,"Save file"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"ROW"]
[null,null,null,null,null,null,null,"ENV"]
[null,null,null,null,null,null,null,"ENG"]
[null,null,null,null,null,null,null,"TRF"]
[null,null,null,null,null,null,null,"STK"]
[null,null,null,null,null,null,null,"UNF"]
[null,null,null,null,null,null,null,"MKT"]
[null,null,null,null,null,null,null,"UTL"]

{"sheet":"RMP User's Guide","index":4,"n_rows":84,"n_cols":3,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["Project Risk Management Plan Worksheet (RMP) – User’s Guide"]
["A convenient tool for tracking risk management of projects.",null,"Assumed risk tolerance levels in this model:"]
["The top part of the risk management plan spreadsheet (rows 1 thru 6) require the user to enter project information in boxes shaded yellow; information that must be entered includes: Project No. and Name, Estimate date, Project UPN, Last review date (will automatically call up today's date), Project Manager, Magnitude of project costs: All costs on spreadsheet will be reported in $ K or M, Target letting date, Estimated construction duration in months, Estimated PE Cost ($K or M), Estimated R/W Cost ($K or M), Estimated CN Cost ($K or M).",null,"Formulas that are built into the RMP worksheet assume a risk-averse position for focusing risk management.  Risk impact is weighed heavier than the propability of that risk occurring. "]
["Risk Management is a key component of Project Management.",null,"Probability range definitions and relative risk factor"]
["Risk Management is comprised of the following steps:",null,"Very High: > 80% chance                5 rating"]
["1) Risk Management Planning (this is a part of the project management plan)",null,"High: 60 - 80% chance                    4 rating"]
["The remaining steps are captured in the RMP spreadsheet:",null,"Medium: 40 - 60% chance               3 rating"]
["2) Risk Identification (this is the first column sections of the spreadsheet)",null,"Low: 20 - 40% chance                     2 rating"]
["3) Qualitative Risk Analysis (depicted with the risk matrix red-yellow-green chart)",null,"Very Low: < 20% chance                 1 rating"]
["4) Quantitative Risk Analysis (captured in four column sections following risk identification)"]
["5) Risk Response (strategy: avoid/transfer/mitigate/accept) and (action to be taken)",null,"Potential impact definitions and relative risk factor"]
["6) Risk Monitoring and Control (who owns the risk and will track the response to it?)",null,"Very High: > 80% chance              16  rating"]
["Risk Identification: focus on significant risks that affect project objectives.  Risk identification occurs througout project development as old risks are successfully mitigated and retired new ones can emerge.",null,"High: 60 - 80% chance                    8 rating\nMedium: 40 - 60% chance               4 rating"]
["The Risk Identification section includes:",null,"Low: 20 - 40% chance                     2 rating"]
["(1)   Risk #  (the spreadsheet is setup for 10 - more can be added if desired)",null,"Very Low: < 20% chance                 1 rating"]
["(2)   Status of the risk event, there are three status scenarios to choose from:  "]
["     Active, when the risk is being actively monitored and controlled",null,"Definitions of Expected Impact on major project objectives"]
["   Dormant, when the risk is low priority but may become high priority in the future",null,"Expected Impact = Probability x Impact"]
["    Retired, when the risk is demised for any reason. ",null,"Relative impact on COST"]
["(3)   RBS Group = Risk Breakdown Structure category (the RBS is found in the Risk Management Guidance and on-line)\n(3a) RBS code number is in Appendix B of the Risk Management Guidelines",null,"\nVery High: > 10% increase/decrease in CN; \nHigh: 5 - 10% increase/decrease in CN\nMedium: 1 - 5% increase/decrease in CN"]
["(4)   Date Identified and Project Phase, represents the date when the risk was first identified and the phase of the project when the risk was first identified.  Valid entries for the project phase are:  Planning, Survey, Design, ROW, and Construction.",null,"Low: 0.5 - 1% increase/decrease in CN\nVery Low: insignificant change to cost"]
["(5)   Functional assignment: Bridge, Consulting, CTEP, District, Environmental, Helena, MSU, Safety, Traffic, R/W, Utilities, Geotech,Survey, Construction, Legal.",null,"Relative impact on SCHEDULE"]
["(6)   Summary Description (threat/opportunity).",null,"Very High: Remaining schedule (including construction time) changes by 30%"]
["· Threat = if event occurs it negatively impacts objectives (increase cost or schedule)",null,"High: Remaining schedule extended or shortened by 20-30%"]
["· Opportunity = if event occurs it positively impacts objectives (decrease cost or schedule)",null,"Medium: Remaining schedule extended/shortened by 10-20%"]
["(7)   Detailed Description of Risk Event  presents a specific, detailed risk description.  Take some time and thought to fill this out thoroughly - so that others reading it, who are not familiar with the project, can understand the risk event being described.  Defining the cause, the risk, and the impact will assist with the response strategies.",null,"Low: Remaining schedule extended/shortened by 1-10%\nVery low: Insignificant change in remaining schedule"]
["(8)   Risk Trigger presents symptoms and warning signs that a risk event is about to occur.  This information is used to determine when to implement the Risk Response Strategies."]
["Risk Analysis Strategy prioritizes risks based on the “Probability and Impact Risk Matrix.” The section has two major segments:  Quantitative Analysis and Qualitative Display of Most Likely Impact."]
[]
["§         (9) - (15) Includes Qualitative depiction of Quantitative Analysis of most likely impacts.  The key features are: impact affects cost, schedule or both?  Probability of occurrence and the impact range (min, max, most likely) if it does occur."]
["§         (9) Type of risk (does it affect cost and/or schedule?)"]
["§         (10) Probability of Occurrence:  Input the likelihood of this risk event occurring.","High risk"]
["§         (11) Risk Impact in $K or M and/or Months; (min, max, most likely).  Note: use negative values for opportunities.  Beware of optimistic bias when developing these values.  It's okay to be wrong in the end, so don't dwell too long on the numbers.  Most likely value will equal the mean in a normal distribution where there is a 50% chance of taking on a value that is greater and a 50% chance of a value that is less.  However, it's more common that more will go wrong.  In this case, you end up with a lognormal curve where the mode is less than the mean.","High risk"]
["§         (12) Expected value of impact: Calculated for you using most likely figure times the input probability.","High risk"]
["§         (13) Qualitative description of probability (automatically populated based on % that is entered)   This can be hand-entered if numbers aren't entered in 11.\nVery High is >= 80%\nHigh is >= 60%\nMedium is >= 40%\nLow is >= 20%\nVery low is > 0%","Medium risk"]
["§         (14) Qualitative description of impact (based on figures for risk event and project cost) using most likely figure by comparing the absolute value of the input most likely cost to the construction estimate.\nVery High is > 10% of CN\nHigh is > 5% of CN\nMedium is > 2% of CN\nLow is > .8% of CN\nVery low is > .5% of CN","Medium risk"]
["§         (15) Qualitative graphic display of risk event (red/yellow/green risk matrix)."]
[]
["Risk Response Strategy (16) - (18)"]
["(16) The project manager and Project Team identify which strategy is best for each risk, and then design specific actions to implement that strategy, and determine who owns the risk and will make sure risk response action is taken. These strategies and actions include:"]
["·        Avoid:  The team changes the project plan to eliminate the risk or to protect the project objectives from its impact. The team might achieve this by changing scope, adding time, or adding resources (thus relaxing the so-called “triple constraint”). These changes may require WSDOT upper management approval."]
["·        Transfer: The team transfers the financial impact of risk by contracting out some aspect of the work. Transference reduces the risk only if the contractor is more able to  taking steps to reduce the risk and does so."]
["·        Mitigate:  The team seeks to reduce the probability or consequences of a risk event to an acceptable threshold. They accomplish this via many different means that are specific to the project and the risk. Mitigation steps, although costly and time-consuming, may still be preferable to going forward with the unmitigated risk."]
["·        Accept:  The project manager and the project team decide to accept certain risks. They do not change the project plan to deal with a risk, or identify any response strategy other than agreeing to address the risk if it occurs."]
["After all risks are analyzed, use the matrix results to prioritize risk response.  Risk events in the red will be top priority, yellow will be next, and green will be lowest.  Risks with the highest probability of occurrence and highest impact should be top priority.  The relative risk number can help with assigning priorities."]
["(17) Describe specifically what action will be taken and by whom."]
["(18) RISK OWNER Enter the name of the person responsbile for monitoring the risk event and insuring that the risk response action is effectively implemented."]
[]
["Risk Monitoring and Control Strategy (Columns 19-21) To ensure risk response actions are followed through and monitoring and reporting of the effect of the risk response action occurs, the Risk review dates should be identified as well as that status of each review.  The list of project risks and the risk priorities change as the project matures, new risks develop, or anticipated risks disappear.  Periodic project risk reviews repeat the tasks of identification, analysis, and response strategies.  The project manager regularly schedules project risk reviews, and ensures that project risk is an agenda item at all Project Team meetings. Risk ratings and prioritization commonly change during the project lifecycle."]
["If an unanticipated risk emerges, or a risk’s impact is greater than expected, the planned response strategy and actions may not be adequate. The project manager and the Project Team must perform additional response strategies and actions to control the risk."]
["Risk control involves:"]
["q       Choosing alternative response strategies"]
["q       Implementing a contingency plan"]
["q       Taking corrective actions"]
["q       Re-planning the project"]
["The risk owner assigned to each risk reports periodically to the project manager on the effectiveness of the plan, any unanticipated effects, and any mid-course correction that the Project Team must take to mitigate the risk. "]
[]
["Monitoring and Control - Risk Management Performance Measurements                                                                                                     Response Cost and Cost Avoidance (Columns 22-25) provides a convenient and succinct record of risk management, monitoring and control.  It is very important for project managers and project teams to understand that response to a risk is a pro-active endeavour.  The primary benefit of risk management is to pre-empt the threat and/or maximize the opportunity by taking action as soon as possible after the risk event has been identified.  Risk management is not a recovery plan that is implemented after a risk event occurs but is an action plan to be utilized long before the risk event occurs."]
[]
["(Column 22) Planned Cost to Respond  – This is the amount the project manager plans to spend to respond to the risk.  The action taken to minimize the threat or maximize the opportunity typically will have some dollar cost associated with it.  The amount spent to respond should of course be less than the estimated value of the risk event."]
["NOTE: Even if your response action is successful, in many cases a residual risk remains."]
[]
["(Column 23) Estimated Cost Avoided – (MIN.) – This is a calculated figure as follows:"]
["Cost is avoided by reducing/evading impact of a threat or exploiting an opportunity."]
["Planned Cost Avoidance = (Risk Impact Value X Probability of Occurrence) – Planned Cost to Respond"]
["                    (Column 23) = (Column 10 X Column 11) – Column 22"]
["Note: For column 10 the figure used will be estimated from the workshop uncertainty forecasts."]
["Note: For column 11 the figure used will be the most likely impact as identified in the workshop."]
["The calculated planned cost avoidance figure represents an estimated amount of cost burden the project has successfully avoided by taking action to pro-actively respond to the risk event."]
["AFTER THE PROJECT IS COMPLETED"]
["(Column 24) Actual Cost to Respond – This is the amount actually spent to respond to the risk.  Once the project is complete, the actual cost to avoid, mitigate, or transfer the risk is known and can be entered."]
["(Column 25) Estimated Actual Cost Avoidance – (MIN.) – calculated as follows:"]
[]
["Actual Cost Avoidance = (Risk Impact Value X Probability of Occurrence) – Actual Cost to Respond"]
["                    (Column 23) = (Column 10 X Column 11) – Column 24"]
["Note: For column 10 the figure used will be estimated from the workshop uncertainty forecasts."]
["Note: For column 11 the figure used will be the most likely impact as identified in the workshop."]
["The actual cost avoidance figure represents an estimated amount of the actual cost savings based on the estimated cost of the risk minus the actual cost to avoid the risk.  "]
["NOTE: Even if your response action is successful, in many cases a residual risk remains."]
[]
["GENERAL NOTES:"]
["·          The RMP spreadsheet, for purposes of simplicity, assumes zero residual risk.  As noted above in many cases there may be residual risk after the response and the project manager will need to insure the project team is aware of this."]
["·          The last four columns in the spreadsheet provide a metric of the effectiveness of the risk response efforts.  This allows the project manager to monitor and control risk management throughout the life of the project."]
["·          The RMP spreadsheet also serves as a nice project performance measurement tool."]

{"sheet":"Assumptions","index":5,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Comments/Assumptions Tracking Page"]
["UPN:","UPN"]
["Project:","STPP 99-1(29)5\nNE of Montana Line - N."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk Identification"]
["Date","Risk Management Step","Comments/Assumptions",null,"Notes:",null,null,null,null,null,null,null,null,null,"Risk Analysis"]
[null,null,null,null,"Comments box will expand as you type.  ",null,null,null,null,null,null,null,null,null,"Risk Response"]
[null,null,null,null,"Page is preset to print one page wide.",null,null,null,null,null,null,null,null,null,"Risk Monitoring and Control"]

{"sheet":"Contingency","index":6,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[34,1,34,2],[23,4,23,5],[23,6,23,7],[21,2,21,7],[22,2,22,3],[22,4,22,5],[22,6,22,7],[23,2,23,3],[35,1,35,2],[37,1,37,2],[38,1,38,2],[40,1,40,2],[41,1,41,2]]}
["Steps for determining contingency"]
[]
["STEP 1.","Overall Project Risk","Fill in yellow boxes."]
[]
[null,"Project risk",{"$f":"RMP!R115+RMP!S115","v":0}]
[null,"Number of cost risks identified",null,"(Number of $ symbols on RMP tab)"]
[null,"Number of schedule risks identified",null,"(Number of Mo symbols on RMP tab)"]
[null,"Average relative cost risk",{"$f":"RMP!R115/C6","v":{"$error":"#DIV/0!"}},{"$f":"IF(C8>19,E12,IF(C8>8,E13,E14))","v":{"$error":"#DIV/0!"}}]
[null,"Average relative schedule risk",{"$f":"RMP!S115/C7","v":{"$error":"#DIV/0!"}},{"$f":"IF(C9>19,E12,IF(C9>8,E13,E14))","v":{"$error":"#DIV/0!"}}]
[null,"Overall risk level",{"$f":"C5/(C6+C7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C10>19,E12,IF(C10>8,E13,E14))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Number of symbols in red boxes",null,{"$f":"C12/(C6+C7)","v":{"$error":"#DIV/0!"}},"HIGH risk"]
[null,"Number of symbols in yellow boxes",null,{"$f":"C13/(C7+C8)","v":{"$error":"#DIV/0!"}},"MEDIUM risk"]
[null,"Number of symbols in green boxes",null,{"$f":"C14/(C8+C9)","v":{"$error":"#DIV/0!"}},"LOW risk"]
[]
["STEP 2.","Determine Project Level of Risk",null,"Project Level of Risk table",null,"Low Risk Project",null,null,null,null,null,"LOW"]
[null,null,null,null,null,"Medium Risk Project",null,null,null,null,null,"MEDIUM"]
[null,null,null,null,null,"High Risk Project",null,null,null,null,null,"HIGH"]
["STEP 3.","Determine Contingency"]
["A.","Get an idea of a typical contingency range using the project stage and complexity level from the table below:"]
[]
[null,null,"% Contingency Range by Project Level of Risk (High, Medium, Low)"]
[null,null,"High Risk",null,"Medium Risk",null,"Low Risk"]
[null,"% Plan"]
["Project Stage","Completion","High Range","Low Range","High Range","Low Range","High Range","Low Range"]
["Planning/Nom/OT","0-5%",110,40,80,30,45,20]
["PFR","0-15%",100,40,60,25,40,15]
["AGR","10-40%",80,35,40,20,40,10]
["SOW","30-70%",70,30,35,15,30,10]
["PIH","60-90%",55,20,25,10,20,5]
["FPR","85-100%",20,5,10,3,5,0]
["Construction","(Misc. work)",20,5,10,0,5,0]
[]
["B.","Further refine the contingency factor by weighing the overall project risk and interpolating off the related linked chart:"]
[null,"High Risk contingency ranges",null,null,null,null,null,null,null,null,null,{"$f":"CELL(\"filename\")","v":"\\\\mdthq\\mdtshares\\WebAppData\\External\\CADD\\report_templates_guidance\\[RMP_MDT.XLSM]Contingency ranges"}]
[]
[]
[null,"Medium Risk contingency ranges"]
[]
[]
[null,"Low Risk contingency ranges"]

{"sheet":"High Risk","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,3,3,4]]}
[]
["High Risk Project Contingency Ranges"]
[]
[]
[null,"% Plans complete",null,"High Range","Low Range"]
["Planning","0-5%",0.05,110,40]
["PFR","0-15%",0.1,100,40]
["AGR","10-40%",0.3,80,35]
["SOW","30-70%",0.6,70,30]
["PIH","60-90%",0.85,55,20]
["FPR","85-100%",0.95,20,5]
["Construction","(Misc. work)",1,20,5]

{"sheet":"Medium Risk","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,3,3,4]]}
[]
["Medium Risk Projects Contingency Ranges"]
[]
[]
[null,"% Plans complete",null,"High Range","Low Range"]
["Planning","0-5%",0.05,80,30]
["PFR","0-15%",0.1,60,25]
["AGR","10-40%",0.3,40,20]
["SOW","30-70%",0.6,35,15]
["PIH","60-90%",0.85,25,10]
["FPR","85-100%",0.95,10,3]
["Construction","(Misc. work)",1,10,0]

{"sheet":"Low Risk","index":9,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,1],[3,3,3,4]]}
[]
["Low Risk Projects Contingency Ranges"]
[]
[null,null,null,"Contingency Range (%)"]
[null,"% Plans complete",null,"High Range","Low Range"]
["Planning","0-5%",0.05,45,20]
["PFR","0-15%",0.1,40,15]
["AGR","10-40%",0.3,40,10]
["SOW","30-70%",0.6,30,10]
["PIH","60-90%",0.85,20,5]
["FPR","85-100%",0.95,5,0]
["Construction","(Misc. work)",1,5,0]

{"sheet":"Cost Ranges","index":10,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,2,7],[3,2,3,3],[3,4,3,5],[3,6,3,7],[4,2,4,3],[4,4,4,5],[4,6,4,7]]}
["Estimated Project Cost Range"]
[]
[null,null,"% Contingency Range by Project Level of Risk (High, Medium, Low)"]
[null,null,"High Risk",null,"Medium Risk",null,"Low Risk"]
[]
["Project Stage","% Plan Completion","High Range","Low Range","High Range","Low Range","High Range","Low Range"]
["Planning/Nom/OT","0-5%",1.1000000000000001,0.4,0.8,0.3,0.45,0.2]
["PFR","0-15%",1,0.4,0.6,0.25,0.4,0.15]
["AGR","10-40%",0.8,0.35,0.4,0.2,0.4,0.1]
["SOW","30-70%",0.7,0.3,0.35,0.15,0.3,0.1]
["PIH","60-90%",0.55000000000000004,0.2,0.25,0.1,0.2,0.05]
["FPR","85-100%",0.2,0.05,0.1,0.3,0.05,0]
["Construction","(Misc. work)",0.2,0.05,0.1,0,0.05,0]
[]
[]
[]
["Date",null,"Enter today's date"]
["Project stage",null,"Pick stage from dropdown list"]
["Project Level of Risk",null,"Pick risk level from dropdown list"]
["Base Estimate ($)",null,"Enter base estimate (include allowances, remove contingency or risk factor)"]
["Contingency (%)",null,"Enter project-specific contingency or risk factor from risk analysis"]
["Estimate Range Low",null,"Enter value from table.  If Contingency < table value for low range, use Contingency - 5%"]
["Estimate Range High",null,"Enter value from table.  If Contingency > table value for high range, use Contingency + 10%"]
[]
["Project cost range low amount",{"$f":"B20*(1+B22)","v":0}]
["Project cost range high amount",{"$f":"B20*(1+B23)","v":0}]
["TCP cost estimate amount",{"$f":"B20*(1+B21)","v":0}]
["Cost estimate range",{"$f":"ROUND(B25,4-(1+INT(LOG10(ABS(B25)))))","v":{"$error":"#NUM!"}},"to",{"$f":"ROUND(B26,4-(1+INT(LOG10(ABS(B26)))))","v":{"$error":"#NUM!"}}]

{"sheet":"Contingency ranges","index":11,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,3,2,8],[4,3,4,4],[4,5,4,6],[4,7,4,8],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
["STEP 3.","Assign Contingency"]
[]
[null,null,null,"% Contingency Range by Project Level of Risk (High, Medium, Low)",null,null,null,null,null,"step 1","Average relative cost risk",{"$f":"Contingency!D8","v":{"$error":"#DIV/0!"}}]
[null,null,null,"High Risk",null,"Medium Risk",null,"Low Risk",null,null,"Average relative schedule risk",{"$f":"Contingency!D9","v":{"$error":"#DIV/0!"}}]
[null,"% Plan","% Plan",null,null,null,null,null,null,null,"Overall risk level",{"$f":"Contingency!D10","v":{"$error":"#DIV/0!"}}]
["Project Stage","Completion","Completion","High Range","Low Range","High Range","Low Range","High Range","Low Range"]
["Planning","0-5%",0.05,110,40,80,30,45,20,"step 2","Complexity Determination:",null,"(from previous worksheet)"]
["PFR","0-15%",0.1,100,40,60,25,40,15]
["AGR","10-40%",0.3,80,35,40,20,40,10,"step 3","Select the appropriate design stage and"]
["SOW","30-70%",0.6,70,30,35,15,30,10,null,"corresponding level of plan completion from table."]
["PIH","60-90%",0.85,55,20,25,10,20,5]
["FPR","85-100%",0.95,20,5,10,3,5,0,null,"Select the % contingency from table or graph."]
["Construction","(Misc. work)",1,20,5,10,0,5,0,null,"Interpolate between the values based on"]
[null,null,null,null,null,null,null,null,null,null,"risk level and project knowledge."]

{"sheet":"RBS","index":12,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,7,5,7],[4,8,5,8],[4,9,5,9],[1,5,1,6],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[]
[null,"Risk Breakdown Structure Categories",null,null,null,"Back to RMP"]
[]
[null,null,"ROW","ENV","ENG","TRF","STK","UNF","MKT","UTL"]
[null,null,"Right-of-Way","Environmental","Engineering/ Construction","Traffic","Stakeholders","Unforeseen Events","Market Conditions","Utilities"]
[]
[null,1,"Disagreement on highway access","Permits /agency actions delayed","Sufficiency of plans and specifications","Design change","Objections from local communities","Forest fires","Labor","Coordination with local utilities efforts"]
[null,2,"Objections to R/W appraisal","Agency disputes not resolved in a timely manner","Change in seismic criteria","Traffic growth","Late changes requested by stakeholders","Weather related incidents","Fuel","Utility negotiations"]
[null,3,"Acquisition issues","New information required for permits","Soil  and other geotechnical conditions / mat’l availability","Land use changes/ developments","New stakeholders demanding new work","Earthquake","Materials","Delay caused by utility conflict"]
[null,4,"Volatile real estate market","Environmental regulations change","Soil contamination",null,"Threats of lawsuit    ","Man-made disasters","Land","Railroad involvement"]
[null,5,null,"Additional environmental analysis required","Contractors / subcontractors capability",null,"Stakeholders choose time and/or cost over quality","Economic changes / funding availability"]
[null,6,null,"Design changes initiated by Resource Agency","Work zone safety and mobility",null,"Tribal Employment Rights Office (TERO) fee"]
[null,7,null,"Tribal issues","Site specific requirements",null,"Overlapping Governmental Jurisdictions"]
[null,8,null,null,"Drainage / hydraulic issues "]
[null,9,"Staffing issues","Staffing issues","Staffing issues","Staffing issues",null,null,null,"Staffing issues"]
[null,10,"Other","Other","Other","Other","Other","Other","Other","Other"]