This worksheet allows users to drill down below each Quality Characteristic to compare the risk scores for each solution option by Sub-characteristic. The format of the display is similar to the Tradeoff Analysis worksheet, and this one is read-only. It will reflect any filter relating to Impact levels set in the Tradeoff Analysis worksheet in cell D2.
By default, this worksheet is specific to the Quality Model set in the References worksheet in cells G1 to N27. If that model is changed, then this worksheet will also have to be changed to reflect the new model and the structure of Quality Characteristics and their corresponding Sub-characteristics. The worksheet will automatically cope with up to six solution options, but users changing this sheet should remember to update all six column so that any subsequent addition of new options will be accurately reflected on this page.
To update this worksheet, first unprotect the sheet (from the ‘Review’ ribbon) and insert or delete rows for the appropriate number of Characteristics and Sub-characteristics. Within a given Characteristic, an entire row, from Column D to Column P can be copied and pasted into a new row below to cater for an additional Sub-characteristic. For example, if a fourth Sub-characteristic is added to Functionality, cells D5:P5 can be copied and pasted into cells D6:P6. This will automatically pick up the name, scores and formats of the additional sub-characteristic. When you’ve finished, remember to protect the worksheet again to minimise the risk of unintended changes.