SAMM Toolbox - incorrect references to answer sets in the SAMM roadmap #180
Description
While using the SAMM toolbox and specifically the roadmap functionality I noticed a bug. Some of the answers do not match the correct answer set.
The effect of this is that the new scores and gap scores are calculated incorrectly.
For example:
In the interview tab I select "Yes, some of them" for V-RT-A-1-1
In the roadmap this will result in "Yes, some of them" in all the phases.
Although, when selecting the dropdown for phase 1, I get a different set of possible answers
Selecting one of those will result in a lower score, as the given answer can't be matched to the original list of possible answers
Digging into the Excel spreadsheet logic and unhiding some of the hidden columns, I found the issue.
The data validation is referencing incorrect answer sets in one or more columns.
Row 111 (V-RT-A-1-1) is using the data validation =I_DM_B_3_1 instead of =V_RT_A_1_1
The list of rows I found this issue for (and fixed in my own roadmap)
- V-AA-A-1-1
- V-AA-B-1-1
- V-AA-B-2-1
- V-AA-B-3-1
- V-RT-A-1-1
- V-RT-A-2-1
- V-RT-A-3-1
- V-RT-B-1-1
- V-RT-B-2-1
- V-RT-B-3-1
- V-ST-A-1-1
- V-ST-A-2-1
- V-ST-A-3-1
- V-ST-B-1-1
- V-ST-B-2-1
- V-ST-B-3-1