Spreadsheet: 96302d1295709871-combination-of-assessment-for-a-final-score-assesmet-combination-2
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
 | Rating Combination
Final Score | A | B | C | D | E | Check |  | Check all value from 0 to 100
1 | 1 | 1 | 1 | 1 | 1 | 1 |  | for all rating combinations
0.99 | 1 | 1 | 1 | 1 | 0.9 | 0.99 |  | 10000000000 | checks to try
0.98 | 1 | 1 | 1 | 1 | 0.8 | 0.98 |  | Takes some time
0.98 | 1 | 1 | 0.9 | 1 | 1 | 0.9800000000000001
0.97 | 1 | 1 | 1 | 1 | 0.7 | 0.97
0.97 | 0.9 | 1 | 1 | 1 | 1 | 0.97
0.97 | 0.01 | 1 | 1 | 0.8 | 1 | 0.6729999999999999
11 | 0 | 0 | 100 | 0 | 0 | 20
Target | A | B | C | D | E | Check
1 | 0 | 0 | 0 | 0 | 10 | 1
2 | 0 | 0 | 0 | 0 | 20 | 2
2 | 0 | 0 | 10 | 0 | 0 | 2
3 | 0 | 0 | 0 | 20 | 0 | 3
3 | 0 | 0 | 10 | 0 | 10 | 3
3 | 10 | 0 | 0 | 0 | 0 | 3
4 | 0 | 0 | 0 | 20 | 10 | 4
4 | 0 | 0 | 10 | 0 | 20 | 4
4 | 0 | 0 | 20 | 0 | 0
4 | 0 | 10 | 0 | 10 | 0
4 | 10 | 0 | 0 | 0 | 10
5 | 0 | 0 | 0 | 20 | 20
5 | 0 | 0 | 10 | 20 | 0
5 | 0 | 0 | 20 | 0 | 10
5 | 0 | 10 | 0 | 10 | 10
5 | 0 | 20 | 0 | 0 | 0
5 | 10 | 0 | 0 | 0 | 20
5 | 10 | 0 | 10 | 0 | 0
6 | 0 | 0 | 10 | 20 | 10
6 | 0 | 0 | 20 | 0 | 20
6 | 0 | 0 | 30 | 0 | 0
6 | 0 | 10 | 0 | 10 | 20
6 | 0 | 10 | 10 | 10 | 0
6 | 0 | 20 | 0 | 0 | 10
6 | 10 | 0 | 0 | 20 | 0
6 | 10 | 0 | 10 | 0 | 10
6 | 20 | 0 | 0 | 0 | 0
7 | 0 | 0 | 10 | 20 | 20
7 | 0 | 0 | 20 | 20 | 0
7 | 0 | 0 | 30 | 0 | 10
7 | 0 | 10 | 10 | 10 | 10
7 | 0 | 20 | 0 | 0 | 20
7 | 0 | 20 | 10 | 0 | 0
7 | 10 | 0 | 0 | 20 | 10
7 | 10 | 0 | 10 | 0 | 20
7 | 10 | 0 | 20 | 0 | 0
7 | 10 | 10 | 0 | 10 | 0
7 | 20 | 0 | 0 | 0 | 10
8 | 0 | 0 | 20 | 20 | 10
8 | 0 | 0 | 30 | 0 | 20
8 | 0 | 0 | 40 | 0 | 0
8 | 0 | 10 | 10 | 10 | 20
8 | 0 | 10 | 20 | 10 | 0
8 | 0 | 20 | 0 | 20 | 0
8 | 0 | 20 | 10 | 0 | 10
8 | 10 | 0 | 0 | 20 | 20
8 | 10 | 0 | 10 | 20 | 0
8 | 10 | 0 | 20 | 0 | 10
8 | 10 | 10 | 0 | 10 | 10
8 | 10 | 20 | 0 | 0 | 0
8 | 20 | 0 | 0 | 0 | 20
8 | 20 | 0 | 10 | 0 | 0
9 | 0 | 0 | 20 | 20 | 20
9 | 0 | 0 | 30 | 20 | 0
9 | 0 | 0 | 40 | 0 | 10
9 | 0 | 10 | 20 | 10 | 10
9 | 0 | 20 | 0 | 20 | 10
9 | 0 | 20 | 10 | 0 | 20
9 | 0 | 20 | 20 | 0 | 0
9 | 10 | 0 | 10 | 20 | 10
9 | 10 | 0 | 20 | 0 | 20
9 | 10 | 0 | 30 | 0 | 0
9 | 10 | 10 | 0 | 10 | 20
9 | 10 | 10 | 10 | 10 | 0
9 | 10 | 20 | 0 | 0 | 10
9 | 20 | 0 | 0 | 20 | 0
9 | 20 | 0 | 10 | 0 | 10
10 | 0 | 0 | 20 | 20 | 30
10 | 0 | 0 | 30 | 20 | 10
10 | 0 | 0 | 40 | 0 | 20
10 | 0 | 0 | 50 | 0 | 0
10 | 0 | 10 | 0 | 30 | 30
10 | 0 | 10 | 10 | 30 | 10
10 | 0 | 10 | 20 | 10 | 20
10 | 0 | 10 | 30 | 10 | 0
10 | 0 | 20 | 0 | 20 | 20
10 | 0 | 20 | 10 | 0 | 30
10 | 0 | 20 | 10 | 20 | 0
10 | 0 | 20 | 20 | 0 | 10
10 | 0 | 30 | 0 | 10 | 10
10 | 10 | 0 | 10 | 20 | 20
10 | 10 | 0 | 20 | 0 | 30
10 | 10 | 0 | 20 | 20 | 0
10 | 10 | 0 | 30 | 0 | 10
10 | 10 | 10 | 0 | 10 | 30
10 | 10 | 10 | 0 | 30 | 0
10 | 10 | 10 | 10 | 10 | 10
10 | 10 | 20 | 0 | 0 | 20
10 | 10 | 20 | 10 | 0 | 0
10 | 20 | 0 | 0 | 20 | 10
10 | 20 | 0 | 10 | 0 | 20
10 | 20 | 0 | 20 | 0 | 0
10 | 20 | 10 | 0 | 10 | 0
10 | 30 | 0 | 0 | 0 | 10
11 | 0 | 0 | 30 | 20 | 20
11 | 0 | 0 | 40 | 0 | 30
11 | 0 | 0 | 40 | 20 | 0
11 | 0 | 0 | 50 | 0 | 10
11 | 0 | 10 | 10 | 30 | 20
11 | 0 | 10 | 20 | 10 | 30
11 | 0 | 10 | 20 | 30 | 0
11 | 0 | 10 | 30 | 10 | 10
11 | 0 | 20 | 0 | 20 | 30
11 | 0 | 20 | 10 | 20 | 10
11 | 0 | 20 | 20 | 0 | 20
11 | 0 | 20 | 30 | 0 | 0
11 | 0 | 30 | 0 | 10 | 20
11 | 0 | 30 | 10 | 10 | 0
11 | 10 | 0 | 10 | 20 | 30
11 | 10 | 0 | 20 | 20 | 10
11 | 10 | 0 | 30 | 0 | 20
11 | 10 | 0 | 40 | 0 | 0
11 | 10 | 10 | 0 | 30 | 10
11 | 10 | 10 | 10 | 10 | 20
11 | 10 | 10 | 20 | 10 | 0
11 | 10 | 20 | 0 | 0 | 30
11 | 10 | 20 | 0 | 20 | 0
11 | 10 | 20 | 10 | 0 | 10
11 | 20 | 0 | 0 | 20 | 20
11 | 20 | 0 | 10 | 0 | 30
11 | 20 | 0 | 10 | 20 | 0
11 | 20 | 0 | 20 | 0 | 10
11 | 20 | 10 | 0 | 10 | 10
11 | 20 | 20 | 0 | 0 | 0
11 | 30 | 0 | 0 | 0 | 20
11 | 30 | 0 | 10 | 0 | 0