Hi Experts,
I have a requirement as follows.The below sheet shows the value from 1.a to 9.a
When I select High in 1.a then the value should be 1.4 and when selecting 2.a as medium then it should multiply the value of SD 2 (15* 1.a weight), similarly for other questions too.
1.a | Reason1 | High | NA | NA | High - Weight = 1.4
Medium - Weight = 1.2
Low - Weight = 1 |
2.a | Reason2 | Major | 100 | 100 | Major (100) - System will be unavailable for 1 or more business days during operating hours
Medium (15*1.a Weight) - System will be unavailable or experience intermittent availability for 4 hours or more during operating periods
Minor (5*1.a Weight) - System will be unavailable or experience intermittent availability between 1 - 4 hours during operating periods
No impact (0) - No Impact or System will be unavailable or experience intermittent availability for less than 0.5 hours during operating periods or outside operating periods
Note: Response score is calculated using the formula Response Score * Weight of SD1 Question |
3.a | Reason3 | SBU | 15 | 20 | Enterprise (20) - Weight = 1.4; More than 50% of population is affected, 2 or more SBU's are affected, 2 or more locations
SBU (15) - Weight = 1.2; 1 SBU is affected, 5 or more departments, More than 25% of the population
Department (10) - Weight = 1.1; Less than 5 Departments
Users (0) – Weight = 1; Not applicable or Less than 10 Users |
4.a | Reason4 | Several Features | 6 | 21 | Extensive (15 * 3.a Weight) - Changes on the user interface including change in screen flow/major functionalities. Training required.
Several Features (5 * 3.a Weight) - No user interface changes but new functionalities may be introduced. Training required.
Look & Feel (2 * 3.a Weight) - Cosmetic changes but the same actions/screen flow. Training not applicable.
Minor (0) - Change not visible to the end users. Training is not applicable.
Note: Response score is calculated using the formula Response Score * Weight of 3.a Question |
5.a | Reason5 | Yes Major | 21 | 21 | Yes Major (15 * 1.a Weight) - Degradation >= 20%
Yes Minor (5 * 1.a Weight) - Degradation < 20%
No (0) - No Degradation
Note: Response score is calculated using the formula Response Score * Weight of SD1 Question |
6.a | Reason6 | Yes Minor | 2 | 5 | Yes Major (5) - Multiple documents
Yes Minor (2) - One document
No (0) - No updates required |
7.a | reason7 | No | 0 | 12 | Yes Major (15) - Multiple HP Applications
Yes Minor (5) - One HP Application
No (0) - No updates required |
8.a | Reason8 | Yes | 0 | 100 | Yes (0) - Low
No (100) - High |
9.a | Reason 9 | No | 0 | 100 | Yes (100) - High
No (0) - Low |
Based on this questions the impact should be calculated. If the score of above questions are then the Risk field should be High if value is between 80-100 .
Change Category | Major | | Scoring Reference | | | Impact | Range | High | 80-100++ | Medium | 50-79 | Low | 0-49 |
|
| | | | | | |
IT Area | Max Rating | Total Rating | Impact Rating | | | |
Team 1 | 379 | 144 | High | | | |
A New field to be created which captures the risk value.
AdChoices