1. Home
  2. Docs
  3. New SARM 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.

Cells A28 and B28 are the only input cells in the worksheet. They enable the user to cause the table below, that contains a row for each requirement, to highlight only those requirements that relate to a selected quality characteristic or stakeholder. By default, both fields are set to the value “All”. A28 can be set, instead, to one of the Quality Characteristics. If one is chosen, the colour settings of the rows below are altered – with only the requirements that contribute to the chosen Quality Characteristic keeping their colour. The other requirements retain their values but do not show any colour. Thus the user can quickly focus their attention on those requirements that make up the selected quality characteristic. Cell B28 works in exactly the same way, except for Stakeholders. And if both cells are set to individual values, rather than “All”, the table will highlight only those requirements that contribute to both the selected Quality Characteristic and the selected Stakeholder.

The use of the word “All” in the dropdowns can be changed by editing cell E14 of the References worksheet.

Conducting a thorough analysis of the information may also involve switching between this worksheet and the ‘Tradeoff Details‘ worksheet to help the team really understand the risk profile and distribution across the requirement / solution landscape.

How can we help?