{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["1. Dashboard","Data Definitions","2. Solution Risk Reduction","3. Sol. Pri. Criteria & Weights","4. Cost Considerations","5. Solution Evaluation","6. Summary"],"not_rendered":{"macros":1,"defined_names":2,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"1. Dashboard","index":0,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[0,1,0,12],[1,1,3,11],[5,1,7,11],[9,1,9,5],[10,1,10,8],[15,1,15,8],[17,1,17,8],[17,10,17,12],[19,1,19,8],[19,10,19,12],[21,1,21,8],[21,10,21,12],[23,1,23,8],[23,10,23,12],[25,1,25,8],[25,10,25,12]]}
[null,"Solution Prioritization Workbook"]
[null,"The purpose of this workbook is to evaluate the benefits of solutions developed in the Solution Development module.  These solutions may provide risk reduction, as well as non-risk benefits.  Risk reduction is determined by using the solution portion of the Risk Assessment Workbook.  This workbook acts as a screening tool with which sites can select and prioritize solutions to carry forward to the Roadmap to Action module."]
[]
[]
[]
[null,"Input should be informed by the discussions and data collected in the associated Solution Prioritization Worksheet found on the Technical Resilience Navigator web application [link]. "]
[]
[]
[]
[null,"Navigating this Excel File"]
[null,"1. Review all steps in this Dashboard sheet before entering data in the Excel file.  On each sheet the various data columns and headers are color-coded as follows:"]
[null,null,"Cell color coding key:"]
[null,null,"Input","Not Input","Input Not Applicable"]
[]
[]
[null,"Regarding data entry:  if pasting data from another source, or from elsewhere in this file, always use Paste Special, and paste the data as values or unformatted text. This will prevent altering any cell formatting.\n\nRegarding automatic calculation:  if not running the workbook with macros enabled, please ensure that calculation of formulas is set to \"Automatic.\"  If macros are enabled, a macro will set formulas to calculate automatically upon opening the workbook."]
[]
[null,"3. Enter information on solutions compiled in Action 2 of the Solution Prioritization Worksheet.  To determine risk reduction for each solution, visit the Risk Assessment Workbook.  Sections on this sheet are outlined to indicate what should be copied to and pasted from that workbook."]
[]
[null,"4. On the Solution Prioritization Criteria & Weights sheet, enter criteria and associated weights to help prioritize solutions by factors beyond risk reduction, employing data from Action 3 of the Solution Prioritization Worksheet.  These may include items such as meeting organizational goals or requirements, and ease of implementation."]
[]
[null,"5. The Cost Considerations sheet asks users to provide rough estimates of initial and ongoing costs for solutions, using data from Action 3 of the Solution Prioritization Worksheet.  Users will define cost categories for their site to characterize solutions as \"High\", \"Moderate\", \"Low\", or \"Minimal.\""]
[]
[null,"6. The Solution Evaluation sheet asks users to review how well solutions meet non-risk criteria defined on the Solution Prioritization Criteria & Weights sheet, based on data from Action 4 of the Solution Prioritization Worksheet.  Once populated, the sheet will automatically calculate a score indicating the benefit potential of each solution. "]
[]
[null,"7. The Summary sheet enables users to group and sort solutions based on benefit potential and cost. It is also a location to mark which of the prioritized solutions the resilience planning team will carry-forward for further analysis. "]

{"sheet":"Data Definitions","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"hidden":true}
[null,"HIDDEN SHEET.  THIS SHEET ALLOWS GLOBAL CHANGES TO THESE VALUES."]
[]
[]
[null,"Primary supply systems(s) addressed"]
[null,"Elec"]
[null,"NGas"]
[null,"Water"]
[null,"Elec & NGas"]
[null,"Elec & Water"]
[null,"NGas & Water"]
[null,"Elec, NGas, & Water"]

{"sheet":"2. Solution Risk Reduction","index":2,"n_rows":56,"n_cols":21,"rows_kept":56,"merged":[[3,1,3,10],[3,12,3,13]]}
[null,"Describe solutions and assess any risk reduction potential of each"]
[null,"Enter solutions regardless of whether they reduce components of risk, using data from Action 2 of the Solution Prioritization Worksheet"]
[null,null,"**Note that Risk Assessment workbook can evaluate 20 solutions.  To evaluate more than 20 solutions, use multiple copies of that workbook."]
[null,"Copy and paste (as values) into Solution Evaluation sheet of Risk Assessment workbook**",{"$nulls":10},"Copy and paste (as values) from Solution Evaluation sheet of Risk Assessment workbook",{"$nulls":4},"Legend"]
[null,"Solution #","Solution","Facilities","Critical load(s)","Hazard/scenario scope","Primary supply systems(s) addressed","Does solution reduce consequence?","Consequence adjustment","Does solution reduce vulnerability?","Vulnerability adjustment",null,"Original site-wide weighted risk","New site-wide weighted risk","Residual risk","Risk-reduction efficacy",null,"Residual risk","Risk-reduction efficacy","Breakpoints","Score for solution potential calculations"]
[null,"Do not change","Enter and describe solution","List facility or facilities benefiting from solution","List critical load(s) benefiting from solution","Describe if solution only applies to certain risk assessment scenarios for the critical load(s)","Choose from drop-down, noting that solutions may potentially address both water and energy","Choose from drop-down","Describe how (if at all) solution changes consequence (as will be modeled in Risk Assessment workbook)","Choose from drop-down","Describe how (if at all) solution changes vulnerability (as will be modeled in Risk Assessment workbook)",null,"Copy from Risk Assessment workbook","Copy from Risk Assessment workbook","Calculated Value","Calculated Value",null,"Calculated value","Do not change","Do not change","Do not change"]
[null,1,"Friction damper","Building 123","Cooling for Data Center X, water for training facility","Dual-impact (seismic)","Water","No",null,"Yes","Addresses design vulnerability to seismic hazards.",null,{"v":138.493712,"d":"138.5"},{"v":138.02312,"d":"138.0"},{"$f":"IF(ISBLANK(M7),\"\",+N7/M7)","v":{"v":0.9966020695582195,"d":"100%"}},{"$f":"IF(ISNUMBER(O7)=FALSE,\"\",IF(O7>$T$7,$S$7,IF(O7>$T$8,$S$8,IF(O7>=$T$9,$S$9,$S$10))))","v":"Minor"},null,{"$f":"\"> \"&T7*100&\"%\"","v":"> 50%"},"Minor",{"v":0.5,"d":"50%"},1]
[null,2,"Conductivity controller","Building 123","Cooling for Data Center X, water for training facility","All","Water","No",null,"Yes","Redundant system (water) qualifies for longer duration outages (1-month).",null,{"v":138.493712,"d":"138.5"},{"v":138.23616800000002,"d":"138.2"},{"$f":"IF(ISBLANK(M8),\"\",+N8/M8)","v":{"v":0.9981403921067552,"d":"100%"}},{"$f":"IF(ISNUMBER(O8)=FALSE,\"\",IF(O8>$T$7,$S$7,IF(O8>$T$8,$S$8,IF(O8>=$T$9,$S$9,$S$10))))","v":"Minor"},null,{"$f":"\"> \"&T8*100&\"% to \"&T7*100&\"%\"","v":"> 20% to 50%"},"Moderate",{"v":0.2,"d":"20%"},2]
[null,3,"Test and exercise mission duplication capability for data processing and analysis function.  Improve process to reduce time required to initiate capability.","Building 123","Cooling for Data Center X, water for training facility, IT plug loads for Data Center X","All","Elec & Water","Yes","Reduces time required (from 48 down to 16 hours) for initiation of mission duplication capability and increases likelihood of success (via tests and exercises).","No",null,null,{"v":138.493712,"d":"138.5"},{"v":40.076048,"d":"40.1"},{"v":0.2893708849395271,"d":"29%"},"Moderate",null,{"$f":"T9*100&\"% to \"&T8*100&\"%\"","v":"5% to 20%"},"Significant",{"v":0.05,"d":"5%"},3]
[null,4,"Solution set:  friction damper + conductivity controller + enhancement of mission duplication capability.","Building 123","Cooling for Data Center X, water for training facility, IT plug loads for Data Center X","All","Elec & Water","Yes","Reduces time required (from 48 down to 16 hours) for initiation of mission duplication capability and increases likelihood of success (via tests and exercises).","Yes","Addresses design vulnerability to seismic hazards, redundant system (water) qualifies for longer duration outages (1-month).",null,{"v":138.493712,"d":"138.5"},{"v":39.91124,"d":"39.9"},{"v":0.2881808814540259,"d":"29%"},"Moderate",null,{"$f":"\"< \"&T9*100&\"%\"","v":"< 5%"},"Major",null,4]
[null,5,{"$nulls":12},"",""]
[null,6,{"$nulls":12},"",""]
[null,7,{"$nulls":12},"",""]
[null,8,{"$nulls":12},"",""]
[null,9,{"$nulls":12},"",""]
[null,10,{"$nulls":12},"",""]
[null,11,{"$nulls":12},"",""]
[null,12,null,null,"",{"$nulls":9},"",""]
[null,13,null,null,"",{"$nulls":9},"",""]
[null,14,null,null,"",{"$nulls":9},"",""]
[null,15,null,null,"",{"$nulls":9},"",""]
[null,16,null,null,"",{"$nulls":9},"",""]
[null,17,null,null,"",{"$nulls":9},"",""]
[null,18,null,null,"",{"$nulls":9},"",""]
[null,19,null,null,"",{"$nulls":9},"",""]
[null,20,null,null,"",{"$nulls":9},"",""]
[null,21,null,null,"",{"$nulls":9},"",""]
[null,22,null,null,"",{"$nulls":9},"",""]
[null,23,null,null,"",{"$nulls":9},"",""]
[null,24,null,null,"",{"$nulls":9},"",""]
[null,25,null,null,"",{"$nulls":9},"",""]
[null,26,{"$nulls":12},"",""]
[null,27,{"$nulls":12},"",""]
[null,28,{"$nulls":12},"",""]
[null,29,{"$nulls":12},"",""]
[null,30,{"$nulls":12},"",""]
[null,31,{"$nulls":12},"",""]
[null,32,{"$nulls":12},"",""]
[null,33,{"$nulls":12},"",""]
[null,34,{"$nulls":12},"",""]
[null,35,{"$nulls":12},"",""]
[null,36,{"$nulls":12},"",""]
[null,37,{"$nulls":12},"",""]
[null,38,{"$nulls":12},"",""]
[null,39,{"$nulls":12},"",""]
[null,40,{"$nulls":12},"",""]
[null,41,{"$nulls":12},"",""]
[null,42,{"$nulls":12},"",""]
[null,43,{"$nulls":12},"",""]
[null,44,{"$nulls":12},"",""]
[null,45,{"$nulls":12},"",""]
[null,46,{"$nulls":12},"",""]
[null,47,{"$nulls":12},"",""]
[null,48,{"$nulls":12},"",""]
[null,49,{"$nulls":12},"",""]
[null,50,{"$nulls":12},"",""]

{"sheet":"3. Sol. Pri. Criteria & Weights","index":3,"n_rows":24,"n_cols":8,"rows_kept":24,"merged":[[13,1,13,5],[22,1,22,5]]}
[null,"Enter any solution prioritization criteria beyond risk-reduction, and enter weights for all criteria"]
[null,"See Action 3 of the Solution Prioritization Worksheet for input data"]
[]
[null,"Criteria #","Criteria","Criteria weights",{"$nulls":3}," "]
[null,"Do not change","Briefly describe each criterion","Enter values from 0 to 1"]
[null,1,"Risk-reduction efficacy",0.85]
[null,2,"Satisfaction of organization requirements",0.15]
[null,3]
[null,4]
[null,5]
[null,6]
[null,null,"Total",{"$f":"SUM(D6:D11)","v":1},{"$f":"IF(D12<>1,\"Sum of criteria weights must equal 1\",\"\")","v":""}]
[]
[null,"In addition to risk-reduction efficacy, possible solution prioritization criteria may include items such as:"]
[null,"● Time required to implement projects"]
[null,"● Ease of implementation"]
[null,"● Availability of funding"]
[null,"● Alignment with existing projects and/or site priorities"]
[null,"● Ability to meet multiple objectives"]
[null,"● Satisfaction of organization requirements"]
[]
[null,"Items that should NOT be included as criteria include:"]
[null,"● Life, health, and safety.  These items should already be reflected in the criticality weighting factors used in the Risk Assessment workbook."]
[null,"● Solution cost.  Costs are separately incorporated into the analysis."]

{"sheet":"4. Cost Considerations","index":4,"n_rows":56,"n_cols":13,"rows_kept":56}
[]
[null,"Enter estimated initial and ongoing annual costs associate with each solution"]
[null,"See Action 3 of the Solution Prioritization Worksheet for input data"]
[{"$nulls":6},"HIDE"]
[null,"Solution #","Solution","Estimated initial cost","Estimated ongoing annual costs",{"$f":"\"Estimated \"&$I$7&\"-year total cost\"","v":"Estimated 10-year total cost"},"Cost category",null,"Choose number of years for total cost analysis",null,{"$f":"\"Enter dollar value breakpoints for \"&I7&\"-year total cost categories\"","v":"Enter dollar value breakpoints for 10-year total cost categories"},{"$f":"\"Estimated \"&$I$7&\"-year total cost\"","v":"Estimated 10-year total cost"},"Cost category"]
[null,"Do not change","Autofilled from previous sheet","Enter a rough cost estimate","Enter a rough cost estimate","Calculated value","Calculated value",null,"Choose from drop-down",null,"Enter cost category breakpoints relevant to site","Calculated value","Do not change"]
[null,1,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B7,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B7,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Friction damper"},{"v":900000,"d":"$900,000"},{"v":40000,"d":"$40,000"},{"$f":"IF(C7=\"\",\"\",D7+($I$7*E7))","v":{"v":1300000,"d":"$1,300,000"}},{"$f":"IF(ISNUMBER(F7)=FALSE,\"\",IF(F7>$K$7,$M$7,IF(F7>$K$8,$M$8,IF(F7>=$K$9,$M$9,$M$10))))","v":"High"},null,10,null,{"v":500000,"d":"$500,000"},{"$f":"\"> $\"&K7/1000&\"K\"","v":"> $500K"},"High"]
[null,2,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B8,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B8,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Conductivity controller"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"$f":"IF(C8=\"\",\"\",D8+($I$7*E8))","v":{"v":110000,"d":"$110,000"}},{"$f":"IF(ISNUMBER(F8)=FALSE,\"\",IF(F8>$K$7,$M$7,IF(F8>$K$8,$M$8,IF(F8>=$K$9,$M$9,$M$10))))","v":"Low"},{"$nulls":3},{"v":250000,"d":"$250,000"},{"$f":"\"> $\"&K8/1000&\"K to $\"&K7/1000&\"K\"","v":"> $250K to $500K"},"Moderate"]
[null,3,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B9,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B9,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Test and exercise mission duplication capability for data processing and analysis function.  Improve process to reduce time required to initiate capability."},{"v":50000,"d":"$50,000"},{"v":15000,"d":"$15,000"},{"v":200000,"d":"$200,000"},"Low",{"$nulls":3},{"v":100000,"d":"$100,000"},{"$f":"\"$\"&K9/1000&\"K to $\"&K8/1000&\"K\"","v":"$100K to $250K"},"Low"]
[null,4,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B10,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B10,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Solution set:  friction damper + conductivity controller + enhancement of mission duplication capability."},{"v":960000,"d":"$960,000"},{"v":65000,"d":"$65,000"},{"v":1610000,"d":"$1,610,000"},"High",{"$nulls":4},{"$f":"\"< $\"&K9/1000&\"K\"","v":"< $100K"},"Minimal"]
[null,5,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B11,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B11,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,6,{"$nulls":3},"",""]
[null,7,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B13,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B13,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,8,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B14,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B14,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,9,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B15,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B15,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,10,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B16,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B16,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,11,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B17,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B17,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,12,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B18,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B18,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,13,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B19,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B19,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,14,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B20,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B20,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,15,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B21,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B21,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,16,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B22,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B22,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,17,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B23,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B23,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,18,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B24,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B24,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,19,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B25,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B25,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,20,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B26,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B26,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,21,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B27,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B27,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,22,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B28,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B28,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,23,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B29,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B29,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,24,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B30,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B30,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,25,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B31,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B31,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,26,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B32,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B32,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,27,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B33,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B33,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,28,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B34,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B34,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,29,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B35,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B35,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,30,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B36,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B36,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,31,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B37,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B37,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,32,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B38,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B38,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,33,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B39,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B39,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,34,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B40,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B40,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,35,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B41,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B41,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,36,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B42,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B42,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,37,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B43,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B43,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,38,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B44,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B44,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,39,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B45,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B45,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,40,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B46,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B46,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,41,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B47,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B47,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,42,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B48,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B48,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,43,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B49,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B49,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,44,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B50,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B50,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,45,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B51,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B51,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,46,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B52,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B52,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,47,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B53,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B53,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,48,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B54,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B54,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,49,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B55,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B55,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]
[null,50,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B56,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B56,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},null,null,"",""]

{"sheet":"5. Solution Evaluation","index":5,"n_rows":56,"n_cols":22,"rows_kept":56}
[null,"Rate solutions as to how well they meet any additional, non-risk criteria"]
[null,"See Action 4 of Solution Prioritization Worksheet for input data"]
[{"$nulls":3},"Criteria weights"]
[{"$nulls":3},{"$f":"IF(D5=\"\",0,INDEX('3. Sol. Pri. Criteria & Weights'!$D$6:$D$11,MATCH(D5,'3. Sol. Pri. Criteria & Weights'!$C$6:$C$11,0)))","v":0.85},"HIDE",{"$f":"IF(F5=\"\",0,INDEX('3. Sol. Pri. Criteria & Weights'!$D$6:$D$11,MATCH(F5,'3. Sol. Pri. Criteria & Weights'!$C$6:$C$11,0)))","v":0.15},"HIDE",{"$f":"IF(H5=\"\",0,INDEX('3. Sol. Pri. Criteria & Weights'!$D$6:$D$11,MATCH(H5,'3. Sol. Pri. Criteria & Weights'!$C$6:$C$11,0)))","v":0},"HIDE",{"$f":"IF(J5=\"\",0,INDEX('3. Sol. Pri. Criteria & Weights'!$D$6:$D$11,MATCH(J5,'3. Sol. Pri. Criteria & Weights'!$C$6:$C$11,0)))","v":0},"HIDE",{"$f":"IF(L5=\"\",0,INDEX('3. Sol. Pri. Criteria & Weights'!$D$6:$D$11,MATCH(L5,'3. Sol. Pri. Criteria & Weights'!$C$6:$C$11,0)))","v":0},"HIDE",{"$f":"IF(N5=\"\",0,INDEX('3. Sol. Pri. Criteria & Weights'!$D$6:$D$11,MATCH(N5,'3. Sol. Pri. Criteria & Weights'!$C$6:$C$11,0)))","v":0},"HIDE"]
[null,"Solution #","Solution",{"$f":"IF(ISBLANK(+'3. Sol. Pri. Criteria & Weights'!C6),\"\",+'3. Sol. Pri. Criteria & Weights'!C6)","v":"Risk-reduction efficacy"},{"$f":"IF(D5=\"\",\"\",D5&\" score\")","v":"Risk-reduction efficacy score"},{"$f":"IF(ISBLANK(+'3. Sol. Pri. Criteria & Weights'!C7),\"\",+'3. Sol. Pri. Criteria & Weights'!C7)","v":"Satisfaction of organization requirements"},{"$f":"IF(F5=\"\",\"\",F5&\" score\")","v":"Satisfaction of organization requirements score"},{"$f":"IF(ISBLANK(+'3. Sol. Pri. Criteria & Weights'!C8),\"\",+'3. Sol. Pri. Criteria & Weights'!C8)","v":""},{"$f":"IF(H5=\"\",\"\",H5&\" score\")","v":""},{"$f":"IF(ISBLANK(+'3. Sol. Pri. Criteria & Weights'!C9),\"\",+'3. Sol. Pri. Criteria & Weights'!C9)","v":""},{"$f":"IF(J5=\"\",\"\",J5&\" score\")","v":""},{"$f":"IF(ISBLANK(+'3. Sol. Pri. Criteria & Weights'!C10),\"\",+'3. Sol. Pri. Criteria & Weights'!C10)","v":""},{"$f":"IF(L5=\"\",\"\",L5&\" score\")","v":""},{"$f":"IF(ISBLANK(+'3. Sol. Pri. Criteria & Weights'!C11),\"\",+'3. Sol. Pri. Criteria & Weights'!C11)","v":""},{"$f":"IF(N5=\"\",\"\",N5&\" score\")","v":""},"Solution benefit potential calculation","Solution benefit potential","Cost category",null,"How well solution meets non-risk criteria","Response","Scores"]
[null,"Do not change","Autofilled from previous sheet","Autofilled from previous sheet","Calculated value","Choose from drop-down","Calculated value","Choose from drop-down","Calculated value","Choose from drop-down","Calculated value","Choose from drop-down","Calculated value","Choose from drop-down","Calculated value","Calculated based on risk reduction and other criteria (weighted)","Calculated value","Calculated value",null,"Solution does not address this criterion","Not well",1]
[null,1,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B7,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B7,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Friction damper"},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B7,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B7,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Minor"},{"$f":"IF(D7=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D7,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":1},"Not well",{"$f":"IF(F7=\"\",0,INDEX($V$6:$V$9,MATCH(F7,$U$6:$U$9,0)))","v":1},null,{"$f":"IF(H7=\"\",0,INDEX($V$6:$V$9,MATCH(H7,$U$6:$U$9,0)))","v":0},null,{"$f":"IF(J7=\"\",0,INDEX($V$6:$V$9,MATCH(J7,$U$6:$U$9,0)))","v":0},null,{"$f":"IF(L7=\"\",0,INDEX($V$6:$V$9,MATCH(L7,$U$6:$U$9,0)))","v":0},null,{"$f":"IF(N7=\"\",0,INDEX($V$6:$V$9,MATCH(N7,$U$6:$U$9,0)))","v":0},{"$f":"IF(C7=\"\",\"\",D$4*E7+F$4*G7+H$4*I7+J$4*K7+L$4*M7+N$4*O7)","v":1},{"$f":"IF(ISNUMBER(P7)=FALSE,\"\",IF(P7>=$U$14,$T$15,IF(P7>=$U$13,$T$14,IF(P7>=$U$12,$T$13,$T$12))))","v":"Low potential for benefit"},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B7,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B7,'4. Cost Considerations'!$B$7:$B$56,0)))","v":"High"},null,"Solution addresses some part of criterion, but only partially","Moderately well",2]
[null,2,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B8,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B8,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Conductivity controller"},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B8,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B8,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Minor"},{"$f":"IF(D8=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D8,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":1},"Well",{"$f":"IF(F8=\"\",0,INDEX($V$6:$V$9,MATCH(F8,$U$6:$U$9,0)))","v":3},null,{"$f":"IF(H8=\"\",0,INDEX($V$6:$V$9,MATCH(H8,$U$6:$U$9,0)))","v":0},null,{"$f":"IF(J8=\"\",0,INDEX($V$6:$V$9,MATCH(J8,$U$6:$U$9,0)))","v":0},null,{"$f":"IF(L8=\"\",0,INDEX($V$6:$V$9,MATCH(L8,$U$6:$U$9,0)))","v":0},null,{"$f":"IF(N8=\"\",0,INDEX($V$6:$V$9,MATCH(N8,$U$6:$U$9,0)))","v":0},{"$f":"IF(C8=\"\",\"\",D$4*E8+F$4*G8+H$4*I8+J$4*K8+L$4*M8+N$4*O8)","v":1.2999999999999998},"Low potential for benefit",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B8,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B8,'4. Cost Considerations'!$B$7:$B$56,0)))","v":"Low"},null,"Solution addresses criterion","Well",3]
[null,3,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B9,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B9,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Test and exercise mission duplication capability for data processing and analysis function.  Improve process to reduce time required to initiate capability."},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B9,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B9,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Moderate"},{"$f":"IF(D9=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D9,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":2},"Not well",1,null,0,null,0,null,0,null,0,1.8499999999999999,"Moderate potential for benefit",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B9,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B9,'4. Cost Considerations'!$B$7:$B$56,0)))","v":"Low"},null,"Solution could not address criterion any better","Very well",4]
[null,4,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B10,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B10,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Solution set:  friction damper + conductivity controller + enhancement of mission duplication capability."},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B10,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B10,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Moderate"},{"$f":"IF(D10=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D10,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":2},"Moderately well",2,null,0,null,0,null,0,null,0,2,"Moderate potential for benefit",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B10,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B10,'4. Cost Considerations'!$B$7:$B$56,0)))","v":"High"}]
[null,5,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B11,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B11,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B11,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B11,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D11=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D11,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B11,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B11,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},null,"Solution benefit potential","Breakpoints","Ranges"]
[null,6,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B12,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B12,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B12,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B12,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D12=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D12,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B12,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B12,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},null,"Low potential for benefit",1.5,{"$f":"\" < \"&U12","v":" < 1.5"}]
[null,7,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B13,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B13,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B13,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B13,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D13=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D13,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B13,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B13,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},null,"Moderate potential for benefit",2.5,{"$f":"U12&\" to < \"&U13","v":"1.5 to < 2.5"}]
[null,8,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B14,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B14,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B14,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B14,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D14=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D14,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B14,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B14,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},null,"High potential for benefit",3.5,{"$f":"U13&\" to < \"&U14","v":"2.5 to < 3.5"}]
[null,9,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B15,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B15,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B15,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B15,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D15=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D15,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B15,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B15,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},null,"Very high potential for benefit",4,{"$f":"U14&\" to \"&U15","v":"3.5 to 4"}]
[null,10,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B16,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B16,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B16,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B16,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D16=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D16,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B16,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B16,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,11,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B17,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B17,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B17,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B17,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D17=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D17,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B17,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B17,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,12,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B18,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B18,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B18,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B18,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D18=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D18,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B18,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B18,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,13,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B19,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B19,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B19,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B19,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D19=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D19,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B19,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B19,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,14,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B20,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B20,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B20,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B20,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D20=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D20,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B20,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B20,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,15,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B21,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B21,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B21,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B21,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D21=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D21,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B21,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B21,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,16,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B22,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B22,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B22,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B22,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D22=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D22,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B22,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B22,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,17,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B23,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B23,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B23,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B23,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D23=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D23,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B23,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B23,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,18,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B24,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B24,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B24,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B24,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D24=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D24,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B24,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B24,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,19,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B25,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B25,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B25,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B25,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D25=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D25,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B25,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B25,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,20,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B26,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B26,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B26,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B26,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D26=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D26,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B26,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B26,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,21,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B27,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B27,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B27,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B27,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D27=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D27,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B27,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B27,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,22,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B28,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B28,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B28,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B28,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D28=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D28,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B28,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B28,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,23,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B29,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B29,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B29,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B29,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D29=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D29,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B29,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B29,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,24,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B30,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B30,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B30,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B30,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D30=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D30,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B30,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B30,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,25,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B31,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B31,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B31,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B31,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D31=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D31,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B31,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B31,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,26,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B32,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B32,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B32,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B32,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D32=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D32,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B32,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B32,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,27,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B33,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B33,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B33,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B33,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D33=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D33,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B33,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B33,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,28,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B34,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B34,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B34,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B34,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D34=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D34,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B34,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B34,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,29,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B35,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B35,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B35,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B35,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D35=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D35,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B35,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B35,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,30,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B36,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B36,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B36,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B36,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D36=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D36,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B36,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B36,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,31,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B37,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B37,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B37,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B37,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D37=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D37,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B37,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B37,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,32,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B38,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B38,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B38,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B38,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D38=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D38,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B38,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B38,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,33,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B39,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B39,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B39,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B39,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D39=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D39,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"",{"$f":"IF(ISNUMBER(P39)=FALSE,\"\",IF(P39>=$U$14,$T$15,IF(P39>=$U$13,$T$14,IF(P39>=$U$12,$T$13,$T$12))))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B39,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B39,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,34,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B40,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B40,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B40,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B40,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D40=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D40,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B40,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B40,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,35,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B41,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B41,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B41,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B41,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D41=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D41,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B41,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B41,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,36,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B42,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B42,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B42,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B42,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D42=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D42,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B42,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B42,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,37,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B43,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B43,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B43,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B43,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D43=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D43,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B43,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B43,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,38,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B44,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B44,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B44,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B44,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D44=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D44,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B44,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B44,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,39,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B45,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B45,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B45,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B45,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D45=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D45,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B45,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B45,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,40,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B46,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B46,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B46,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B46,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D46=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D46,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B46,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B46,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,41,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B47,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B47,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B47,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B47,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D47=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D47,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B47,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B47,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,42,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B48,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B48,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B48,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B48,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D48=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D48,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B48,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B48,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,43,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B49,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B49,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B49,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B49,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D49=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D49,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B49,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B49,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,44,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B50,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B50,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B50,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B50,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D50=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D50,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B50,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B50,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,45,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B51,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B51,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B51,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B51,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D51=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D51,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B51,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B51,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,46,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B52,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B52,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B52,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B52,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D52=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D52,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B52,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B52,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,47,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B53,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B53,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B53,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B53,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D53=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D53,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B53,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B53,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,48,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B54,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B54,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B54,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B54,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D54=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D54,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B54,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B54,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,49,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B55,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B55,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B55,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B55,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D55=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D55,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B55,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B55,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]
[null,50,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B56,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B56,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B56,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$P$7:$P$56,MATCH(B56,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(D56=\"\",0,INDEX('2. Solution Risk Reduction'!$U$7:$U$10,MATCH(D56,'2. Solution Risk Reduction'!$S$7:$S$10,0)))","v":0},null,0,null,0,null,0,null,0,null,0,"","",{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B56,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B56,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""}]

{"sheet":"6. Summary","index":6,"n_rows":56,"n_cols":14,"rows_kept":56}
[]
[null,"Using the Excel Filter drop-downs, sort and filter solutions as desired to help determine which to carry forward to the Roadmap to Action module"]
[null,null,"To create a custom sort by both cost category and solution benefit potential, set a desired sort order in the table to the right",{"$nulls":5},{"$f":"LEFT(TEXT(G8,),1)","v":""},null,"Choose cost categories and solution benefit potential to set desired sort order"]
[{"$nulls":13},"HIDE"]
[null,"Solution #","Solution",{"$f":"'4. Cost Considerations'!F5","v":"Estimated 10-year total cost"},"Cost category","Solution benefit potential","Desired sort order",{"$f":"\"Desired sort order and \"&'4. Cost Considerations'!I7&\"-year total cost\"","v":"Desired sort order and 10-year total cost"},"Carry forward to Roadmap to Action",null,"Desired sort order","Cost category","Solution benefit potential","Multi-column match assist column"]
[null,"Do not change","Autofilled from previous sheet","Autofilled from previous sheet","Autofilled from previous sheet","Autofilled from previous sheet","Calculated value","Calculated value","Choose from drop-down",null,"Do not change","Choose from drop-down","Choose from drop-down","Do not change"]
[null,1,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B7,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B7,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Friction damper"},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B7,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B7,'4. Cost Considerations'!$B$7:$B$56,0)))","v":{"v":1300000,"d":"$1,300,000"}},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B7,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B7,'4. Cost Considerations'!$B$7:$B$56,0)))","v":"High"},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B7,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B7,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":"Low potential for benefit"},{"$f":"IF(C7=\"\",\"\",IF(ISNA(MATCH(E7&F7,$N$7:$N$22,0)),999,INDEX($K$7:$K$22,MATCH(E7&F7,$N$7:$N$22,0))))","v":16},{"$f":"IF(C7=\"\",\"\",IF(LEN(G7)=2,G7&\"_\"&D7,\"0\"&G7&\"_\"&D7))","v":"16_1300000"},"No",null,1,{"$f":"'4. Cost Considerations'!$M$10","v":"Minimal"},{"$f":"'5. Solution Evaluation'!$T$15","v":"Very high potential for benefit"},{"$f":"L7&M7","v":"MinimalVery high potential for benefit"}]
[null,2,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B8,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B8,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Conductivity controller"},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B8,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B8,'4. Cost Considerations'!$B$7:$B$56,0)))","v":{"v":110000,"d":"$110,000"}},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B8,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B8,'4. Cost Considerations'!$B$7:$B$56,0)))","v":"Low"},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B8,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B8,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":"Low potential for benefit"},14,"14_110000","Yes",null,2,"Low",{"$f":"'5. Solution Evaluation'!$T$15","v":"Very high potential for benefit"},{"$f":"L8&M8","v":"LowVery high potential for benefit"}]
[null,3,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B9,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B9,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Test and exercise mission duplication capability for data processing and analysis function.  Improve process to reduce time required to initiate capability."},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B9,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B9,'4. Cost Considerations'!$B$7:$B$56,0)))","v":{"v":200000,"d":"$200,000"}},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B9,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B9,'4. Cost Considerations'!$B$7:$B$56,0)))","v":"Low"},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B9,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B9,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":"Moderate potential for benefit"},10,"10_200000","Yes",null,3,{"$f":"'4. Cost Considerations'!$M$8","v":"Moderate"},{"$f":"'5. Solution Evaluation'!$T$15","v":"Very high potential for benefit"},"ModerateVery high potential for benefit"]
[null,4,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B10,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B10,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":"Solution set:  friction damper + conductivity controller + enhancement of mission duplication capability."},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B10,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B10,'4. Cost Considerations'!$B$7:$B$56,0)))","v":{"v":1610000,"d":"$1,610,000"}},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B10,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B10,'4. Cost Considerations'!$B$7:$B$56,0)))","v":"High"},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B10,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B10,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":"Moderate potential for benefit"},12,"12_1610000","No",null,4,{"$f":"'4. Cost Considerations'!$M$7","v":"High"},{"$f":"'5. Solution Evaluation'!$T$15","v":"Very high potential for benefit"},"HighVery high potential for benefit"]
[null,5,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B11,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B11,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B11,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B11,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B11,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B11,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B11,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B11,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,5,{"$f":"'4. Cost Considerations'!$M$10","v":"Minimal"},{"$f":"'5. Solution Evaluation'!$T$14","v":"High potential for benefit"},"MinimalHigh potential for benefit"]
[null,6,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B12,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B12,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B12,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B12,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B12,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B12,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B12,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B12,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,6,"Low",{"$f":"'5. Solution Evaluation'!$T$14","v":"High potential for benefit"},"LowHigh potential for benefit"]
[null,7,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B13,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B13,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B13,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B13,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B13,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B13,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B13,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B13,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,7,{"$f":"'4. Cost Considerations'!$M$8","v":"Moderate"},{"$f":"'5. Solution Evaluation'!$T$14","v":"High potential for benefit"},"ModerateHigh potential for benefit"]
[null,8,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B14,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B14,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B14,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B14,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B14,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B14,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B14,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B14,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,8,{"$f":"'4. Cost Considerations'!$M$7","v":"High"},{"$f":"'5. Solution Evaluation'!$T$14","v":"High potential for benefit"},"HighHigh potential for benefit"]
[null,9,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B15,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B15,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B15,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B15,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B15,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B15,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B15,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B15,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,9,{"$f":"'4. Cost Considerations'!$M$10","v":"Minimal"},{"$f":"'5. Solution Evaluation'!$T$13","v":"Moderate potential for benefit"},"MinimalModerate potential for benefit"]
[null,10,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B16,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B16,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B16,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B16,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B16,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B16,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B16,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B16,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,10,{"$f":"'4. Cost Considerations'!$M$9","v":"Low"},{"$f":"'5. Solution Evaluation'!$T$13","v":"Moderate potential for benefit"},"LowModerate potential for benefit"]
[null,11,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B17,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B17,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B17,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B17,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B17,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B17,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B17,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B17,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,11,{"$f":"'4. Cost Considerations'!$M$8","v":"Moderate"},{"$f":"'5. Solution Evaluation'!$T$13","v":"Moderate potential for benefit"},"ModerateModerate potential for benefit"]
[null,12,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B18,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B18,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B18,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B18,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B18,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B18,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B18,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B18,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,12,{"$f":"'4. Cost Considerations'!$M$7","v":"High"},{"$f":"'5. Solution Evaluation'!$T$13","v":"Moderate potential for benefit"},"HighModerate potential for benefit"]
[null,13,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B19,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B19,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B19,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B19,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B19,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B19,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B19,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B19,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,13,{"$f":"'4. Cost Considerations'!$M$10","v":"Minimal"},{"$f":"'5. Solution Evaluation'!$T$12","v":"Low potential for benefit"},"MinimalLow potential for benefit"]
[null,14,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B20,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B20,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B20,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B20,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B20,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B20,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B20,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B20,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,14,{"$f":"'4. Cost Considerations'!$M$9","v":"Low"},{"$f":"'5. Solution Evaluation'!$T$12","v":"Low potential for benefit"},"LowLow potential for benefit"]
[null,15,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B21,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B21,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B21,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B21,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B21,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B21,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B21,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B21,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,15,{"$f":"'4. Cost Considerations'!$M$8","v":"Moderate"},{"$f":"'5. Solution Evaluation'!$T$12","v":"Low potential for benefit"},"ModerateLow potential for benefit"]
[null,16,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B22,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B22,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B22,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B22,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B22,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B22,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B22,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B22,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"","",null,null,16,{"$f":"'4. Cost Considerations'!$M$7","v":"High"},{"$f":"'5. Solution Evaluation'!$T$12","v":"Low potential for benefit"},"HighLow potential for benefit"]
[null,17,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B23,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B23,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B23,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B23,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B23,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B23,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B23,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B23,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,18,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B24,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B24,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B24,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B24,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B24,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B24,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B24,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B24,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,19,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B25,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B25,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B25,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B25,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B25,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B25,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B25,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B25,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,20,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B26,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B26,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B26,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B26,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B26,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B26,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B26,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B26,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,21,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B27,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B27,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B27,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B27,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B27,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B27,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B27,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B27,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,22,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B28,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B28,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B28,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B28,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B28,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B28,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B28,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B28,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,23,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B29,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B29,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B29,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B29,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B29,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B29,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B29,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B29,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,24,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B30,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B30,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B30,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B30,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B30,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B30,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B30,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B30,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,25,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B31,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B31,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B31,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B31,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B31,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B31,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B31,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B31,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,26,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B32,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B32,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B32,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B32,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B32,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B32,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B32,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B32,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,27,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B33,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B33,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B33,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B33,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B33,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B33,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B33,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B33,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,28,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B34,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B34,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B34,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B34,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B34,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B34,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B34,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B34,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,29,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B35,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B35,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B35,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B35,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B35,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B35,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B35,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B35,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,30,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B36,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B36,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B36,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B36,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B36,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B36,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B36,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B36,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,31,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B37,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B37,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B37,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B37,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B37,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B37,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B37,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B37,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,32,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B38,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B38,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B38,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B38,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B38,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B38,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B38,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B38,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,33,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B39,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B39,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B39,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B39,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B39,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B39,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B39,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B39,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},{"$f":"IF(C39=\"\",\"\",IF(ISNA(MATCH(E39&F39,$N$7:$N$22,0)),999,INDEX($K$7:$K$22,MATCH(E39&F39,$N$7:$N$22,0))))","v":""},{"$f":"IF(C39=\"\",\"\",IF(LEN(G39)=2,G39&\"_\"&D39,\"0\"&G39&\"_\"&D39))","v":""}]
[null,34,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B40,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B40,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B40,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B40,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B40,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B40,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B40,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B40,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,35,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B41,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B41,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B41,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B41,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B41,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B41,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B41,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B41,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,36,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B42,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B42,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B42,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B42,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B42,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B42,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B42,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B42,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,37,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B43,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B43,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B43,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B43,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B43,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B43,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B43,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B43,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,38,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B44,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B44,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B44,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B44,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B44,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B44,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B44,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B44,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,39,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B45,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B45,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B45,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B45,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B45,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B45,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B45,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B45,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,40,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B46,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B46,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B46,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B46,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B46,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B46,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B46,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B46,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,41,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B47,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B47,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B47,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B47,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B47,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B47,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B47,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B47,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,42,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B48,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B48,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B48,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B48,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B48,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B48,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B48,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B48,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,43,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B49,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B49,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B49,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B49,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B49,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B49,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B49,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B49,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,44,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B50,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B50,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B50,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B50,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B50,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B50,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B50,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B50,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,45,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B51,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B51,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B51,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B51,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B51,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B51,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B51,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B51,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,46,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B52,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B52,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B52,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B52,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B52,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B52,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B52,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B52,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,47,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B53,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B53,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B53,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B53,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B53,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B53,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B53,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B53,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,48,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B54,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B54,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B54,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B54,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B54,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B54,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B54,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B54,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,49,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B55,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B55,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B55,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B55,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B55,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B55,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B55,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B55,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]
[null,50,{"$f":"IF(ISBLANK(INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B56,'2. Solution Risk Reduction'!$B$7:$B$56,0))),\"\",INDEX('2. Solution Risk Reduction'!$C$7:$C$56,MATCH(B56,'2. Solution Risk Reduction'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B56,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$F$7:$F$56,MATCH(B56,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B56,'4. Cost Considerations'!$B$7:$B$56,0))=\"\",\"\",INDEX('4. Cost Considerations'!$G$7:$G$56,MATCH(B56,'4. Cost Considerations'!$B$7:$B$56,0)))","v":""},{"$f":"IF(INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B56,'5. Solution Evaluation'!$B$7:$B$56,0))=\"\",\"\",INDEX('5. Solution Evaluation'!$Q$7:$Q$56,MATCH(B56,'5. Solution Evaluation'!$B$7:$B$56,0)))","v":""},"",""]