Spreadsheet: 96301d1295709871-combination-of-assessment-for-a-final-score-assesment-combination-1
Sheet: Combination

Subject | Weightage | Assessment Scale
A | 0.3 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
B | 0.25 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
C | 0.2 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
D | 0.15 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
E | 0.1 | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1
Total | 1
 |  |  |  |  |  |  |  | Calculating criteria
 | Rating Combination |  |  |  |  |  |  | If Final Score target is less than 21
Final Score | A | B | C | D | E | Check |  | [NAME] | 0
1 | 1 | 1 | 1 | 1 | 1 | 1 |  | End | Final Score target +10
0.99 | 1 | 1 | 1 | 1 | 0.9 | 0.99
0.98 | 1 | 1 | 1 | 1 | 0.8 | 0.98 |  | If Final Score target is greater than 21
0.98 | 1 | 1 | 0.9 | 1 | 1 | 0.9800000000000001
0.97 | 1 | 1 | 1 | 1 | 0.7 | 0.97 |  | Start | Int(final score/10)*10-20
0.97 | 0.9 | 1 | 1 | 1 | 1 | 0.97 |  | End | Final Score target +10
0.97 | 0.01 | 1 | 1 | 0.8 | 1 | 0.6729999999999999 |  | Example
96 | 100 | 100 | 100 | 100 | 100 | 100 |  | Final score | 12
 |  |  |  |  |  |  |  | Start | 0
 |  |  |  |  |  |  |  | End | 22
Target | A | B | C | D | E | Check
91 | 70 | 100 | 100 | 100 | 100 |  |  | Final score | 30
91 | 80 | 100 | 90 | 100 | 90 |  |  | Start | 10
91 | 80 | 100 | 100 | 80 | 100 |  |  | End | 40
91 | 80 | 100 | 100 | 100 | 70
91 | 90 | 80 | 100 | 100 | 90
91 | 90 | 90 | 90 | 90 | 100
91 | 90 | 90 | 100 | 90 | 80
91 | 90 | 100 | 70 | 100 | 100
91 | 90 | 100 | 80 | 100 | 80
91 | 90 | 100 | 90 | 80 | 90
91 | 90 | 100 | 100 | 80 | 70
91 | 100 | 70 | 100 | 90 | 100
91 | 100 | 80 | 80 | 100 | 100
91 | 100 | 80 | 90 | 100 | 80
91 | 100 | 80 | 100 | 80 | 90
91 | 100 | 90 | 80 | 90 | 90
91 | 100 | 90 | 90 | 70 | 100
91 | 100 | 90 | 90 | 90 | 70
91 | 100 | 90 | 100 | 70 | 80
91 | 100 | 100 | 70 | 80 | 100
91 | 100 | 100 | 70 | 100 | 70
91 | 100 | 100 | 80 | 80 | 80
92 | 80 | 100 | 90 | 100 | 100
92 | 80 | 100 | 100 | 100 | 80
92 | 90 | 80 | 100 | 100 | 100
92 | 90 | 90 | 100 | 90 | 90
92 | 90 | 100 | 80 | 100 | 90
92 | 90 | 100 | 90 | 80 | 100
92 | 90 | 100 | 90 | 100 | 70
92 | 90 | 100 | 100 | 80 | 80
92 | 100 | 80 | 90 | 100 | 90
92 | 100 | 80 | 100 | 80 | 100
92 | 100 | 80 | 100 | 100 | 70
92 | 100 | 90 | 80 | 90 | 100
92 | 100 | 90 | 90 | 90 | 80
92 | 100 | 90 | 100 | 70 | 90
92 | 100 | 100 | 70 | 100 | 80
92 | 100 | 100 | 80 | 80 | 90
92 | 100 | 100 | 90 | 80 | 70
93 | 80 | 100 | 100 | 100 | 90
93 | 90 | 90 | 100 | 90 | 100
93 | 90 | 100 | 80 | 100 | 100
93 | 90 | 100 | 90 | 100 | 80
93 | 90 | 100 | 100 | 80 | 90
93 | 100 | 80 | 90 | 100 | 100
93 | 100 | 80 | 100 | 100 | 80
93 | 100 | 90 | 90 | 90 | 90
93 | 100 | 90 | 100 | 70 | 100
93 | 100 | 90 | 100 | 90 | 70
93 | 100 | 100 | 70 | 100 | 90
93 | 100 | 100 | 80 | 80 | 100
93 | 100 | 100 | 80 | 100 | 70
93 | 100 | 100 | 90 | 80 | 80
94 | 80 | 100 | 100 | 100 | 100
94 | 90 | 100 | 90 | 100 | 90
94 | 90 | 100 | 100 | 80 | 100
94 | 90 | 100 | 100 | 100 | 70
94 | 100 | 80 | 100 | 100 | 90
94 | 100 | 90 | 90 | 90 | 100
94 | 100 | 90 | 100 | 90 | 80
94 | 100 | 100 | 70 | 100 | 100
94 | 100 | 100 | 80 | 100 | 80
94 | 100 | 100 | 90 | 80 | 90
94 | 100 | 100 | 100 | 80 | 70
95 | 90 | 100 | 90 | 100 | 100
95 | 90 | 100 | 100 | 100 | 80
95 | 100 | 80 | 100 | 100 | 100
95 | 100 | 90 | 100 | 90 | 90
95 | 100 | 100 | 80 | 100 | 90
95 | 100 | 100 | 90 | 80 | 100
95 | 100 | 100 | 90 | 100 | 70
95 | 100 | 100 | 100 | 80 | 80
96 | 90 | 100 | 100 | 100 | 90
96 | 100 | 90 | 100 | 90 | 100
96 | 100 | 100 | 80 | 100 | 100
96 | 100 | 100 | 90 | 100 | 80
96 | 100 | 100 | 100 | 80 | 90