1. Home
  2. Docs
  3. SARM 8.9 User Guide
  4. The SARM Spreadsheet Tool
  5. Tradeoff Analysis

Tradeoff Analysis

This worksheet is the main destination for SARM and the focus of the trade-off analysis activity in Part 2 of the SARM Process.  It contains a lot of information, and guidance on how to navigate it, and use it to reach a decision or recommendation, is provided in the page linked above.

Although the worksheet contains a wealth of information, there are only three input fields, cell D2, cell G2 and cell K2.  The first of these allows the user to select one of the five levels of Impact in the Risk Model.  It will then filter all of the information that lies behind the worksheet (and behind the ‘Stakeholder Views‘ and ‘Charts‘ worksheets) so that the display only takes account of scenarios that have the selected level of risk or higher.  By default, it is set to Negligible, which is the lowest level of impact, and so the worksheet will reflect risk information from all scenarios.  Changing this option enables the team to test the sensitivity of the information on which their decision or recommendation is based.  It might be that a different decision would be indicated when considering, for example, only those scenarios that have Major or Catastrophic impact.

Cell G2 allows the user to change the mathematical basis on which ‘Quality Characteristic Burden’ risk scores are calculated.  Two options are provided: Averaging by Sub-characteristic and Averaging by Scenario.  Either may be valid in particular circumstances, but each may lead to slightly different results being shown under Quality Characteristic Burden and Aggregate Risk Burden.  With ‘Averaging by Sub-characteristic’ the average burden for each quality characteristic is calculated by taking the average risk score for each sub-characteristic that belongs to that characteristic and producing the average across that set.  This gives equal weight to each sub-characteristic (but not necessarily to each scenario, as there may be different numbers of scenarios associated with each sub-characteristic).  The alternative approach, ‘Averaging by Scenario’, calculates the average risk score for a given characteristic by taking the total risk scores across all scenarios that fall within any of the sub-characteristics that belong to that characteristic, and dividing it by the number of such scenarios.  This therefore gives equal weight to each scenario within that characteristic (but not necessarily to each sub-characteristic, as there may be different numbers of scenarios associated with each sub-characteristic).

Cell K2 is only of relevance if you have associated some scenarios to intangible benefits in the ‘Benefits‘ worksheet.  It applies a filter based on your selection of one of the four intangible benefits, and will limit visibility to just those scenarios that have been associated with the selected benefit.  In this way, it is easy to see how the competing solution options fare in terms of each of the four intangible benefits.  By default, the filter is set to off.

Conducting a thorough analysis of the information may also involve switching between this worksheet and the ‘Sub-characteristics‘ and  ‘Charts‘ worksheets to help the team really understand the risk profile and distribution across the scenario / solution landscape.

How can we help?