This worksheet contains reference information that is used by the rest of the SARM spreadsheet tool. There is no need to refer to this worksheet if you wish to use the tool ‘out of the box’. However, if you wish to make changes to any of the models or language used in the tool, then this is the worksheet where you can specify your changes. By default this worksheet is fully protected to avoid unintended changes, so if you wish to make changes you will first need to unprotect the worksheet by selecting ‘Unprotect Sheet’ in the Review tab.
The names of the attributes in the Stakeholder Model can be changed in cells B34, B35 and B36. Changes here will therefore be reflected in the ‘Stakeholder Analysis‘ worksheet and also the relevant portions of the ‘Tradeoff Analysis‘ worksheet. The names of the classes are in cells C34 to C40, and the mapping from the Stakeholder Classes to Stakeholder Salience is contain in the table from cell C34 to D40. Although you can change the names of the classes, you are not able to change here the underlying structure of the model (the logic which connects the values of the three attributes to the resulting class). Cells B38 and B39 determine the values in the dropdowns in the ‘Stakeholder Analysis’ worksheet.
The Quality Model is defined in cells G1 to N27. Row 1 is used to define the names of up to eight Quality Characteristics. If there are fewer than eight, the right-hand column headers should be left blank. Row 2 should be left unchanged, as these names are used in table lookups to populate the drop-down lists in the ‘Scenarios & Stakeholders‘ worksheet. Rows 3 to 27 are used to list the sub-characteristics that belong to each Quality Characteristic. These should be listed from the top down.
For the drop-down list of sub-characteristics to work properly, you also need to update ranges specified in the Name Manager. To do this navigate to the Formulas tab in Excel and select the Name Manager (make sure that the worksheet is unprotected before you do this). Select the entry for Characteristic1 and change the cell range in Refers to field so that it corresponds to the list of sub-characteristics for that characteristic. So if, for example, the first characteristic has 5 sub-characteristics, the value in the Refers to field should be “=References!$G$3:$G$7″. Repeat this process in the Name Manager for each of the characteristics and their sub-characteristics.
A change to the Quality Model also demands a change to the Sub-characteristics worksheet, which allows users to see tradeoff analysis results by Sub-characteristic. See here for details of how to make these changes.
There is sufficient capacity in the worksheet to change the default SARM Quality Model to those described in, for example, ISO 25010, ISO 25011 or the SABSA Business Attributes or High Level General Business Attributes models. You should make sure you are licensed to use any new models you choose to adopt with SARM.
The Risk Model is defined in cells B8 to C22, with the Impact dimension defined in cells B8 to C13, and Likelihood in B17 to C22. The C column contains the names of the levels of impact and likelihood, while the D column contains the corresponding numeric values. Cells F12 and F13 automatically calculate the minimum and maximum values of risk impact, and do not need to be changed. These are used to determine the range of colours used when displaying risk values in the ‘Tradeoff Analysis‘ and ‘Charts‘ worksheets.
Cost Benefit Analysis
You can also change the way in which the optional cost benefit analysis works in this worksheet. Changes here will affect the ‘Benefits‘ and ‘Cost Benefit Analysis‘ worksheets. Cells B43 and B44 contain the two options that are presented to the user in the dropdown list in cell F5 of the ‘Benefits’ worksheet.
Cells D18 to D22 determine the relationship between the Estimated Benefit and the Maximum Benefit for each scenario / solution option combination according to the likelihood of that solution option being able to achieve the given scenario satisfactorily.
Cells B29 to C31 determine the Exit Difficulty options that are presented in the dropdown list for each solution option in the costs section of the ‘Cost Benefit Analysis’ worksheet, and their corresponding increase to the Development cost.