Spreadsheet: 883812d1732539841-request-for-help-developing-an-excel-solver-model-to-allocate-students-to-courses-student-allocation_-hydr_mod-
Sheet: Students

ID | Gender | Score | D To 1 | D To 2 | D To 3 | D To 4 | D To 5 | D To 6 | D To 7 | D To 8 | D To 9 | D To 10 | D To 11 | D To 12 | D To 13 | D To 14 | Mean | C 1 | C 2 | C 3 | C 4 | C 5 | C 6 | C 7 | C 8 | C 9 | C 10 | C 11 | C 12 | C 13 | C 14 | Check
S1 | M | 61 | 56 | 41 | 59 | 33 | 46 | 64 | 88 | 35 | 63 | 95 | 18 | 95 | 52 | 24 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  | Objective
S2 | M | 70 | 76 | 74 | 19 | 38 | 61 | 54 | 72 | 11 | 16 | 56 | 94 | 98 | 92 | 70 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Total Distance
S3 | F | 25 | 12 | 31 | 80 | 90 | 80 | 90 | 63 | 86 | 76 | 72 | 85 | 31 | 57 | 3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  | Total Score
[NAME] | M | 74 | 70 | 18 | 69 | 49 | 65 | 4 | 97 | 8 | 22 | 74 | 90 | 9 | 13 | 27 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Average Distance
S5 | M | 65 | 64 | 19 | 37 | 95 | 73 | 47 | 79 | 34 | 10 | 93 | 33 | 94 | 4 | 35 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
S6 | M | 53 | 39 | 35 | 43 | 69 | 43 | 86 | 13 | 92 | 20 | 18 | 69 | 50 | 48 | 70 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Min score
S7 | F | 9 | 37 | 44 | 49 | 62 | 38 | 14 | 58 | 61 | 81 | 85 | 41 | 15 | 89 | 70 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | [NAME] dist
S8 | F | 49 | 29 | 13 | 58 | 49 | 92 | 58 | 6 | 26 | 33 | 66 | 60 | 9 | 62 | 54 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S9 | M | 25 | 58 | 83 | 29 | 16 | 40 | 17 | 98 | 13 | 53 | 3 | 60 | 69 | 93 | 66 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S10 | M | 42 | 83 | 17 | 25 | 49 | 40 | 96 | 34 | 29 | 23 | 77 | 67 | 33 | 49 | 61 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S11 | M | 30 | 92 | 66 | 38 | 14 | 30 | 83 | 57 | 52 | 10 | 85 | 67 | 74 | 22 | 65 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
S12 | M | 5 | 82 | 34 | 2 | 66 | 95 | 19 | 66 | 89 | 96 | 17 | 97 | 93 | 80 | 76 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S13 | F | 61 | 14 | 78 | 37 | 95 | 77 | 6 | 33 | 97 | 73 | 59 | 60 | 69 | 83 | 21 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S14 | F | 59 | 86 | 38 | 6 | 7 | 31 | 7 | 52 | 82 | 72 | 15 | 44 | 45 | 50 | 89 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S15 | F | 17 | 91 | 3 | 76 | 64 | 71 | 81 | 26 | 62 | 92 | 37 | 73 | 40 | 4 | 90 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S16 | M | 7 | 4 | 74 | 19 | 73 | 63 | 33 | 75 | 37 | 44 | 44 | 96 | 48 | 12 | 49 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S17 | F | 57 | 66 | 7 | 61 | 67 | 66 | 48 | 33 | 68 | 27 | 9 | 7 | 77 | 60 | 17 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S18 | M | 38 | 48 | 96 | 9 | 96 | 44 | 92 | 6 | 8 | 82 | 9 | 40 | 13 | 81 | 18 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S19 | M | 13 | 9 | 32 | 19 | 90 | 50 | 96 | 96 | 28 | 49 | 52 | 43 | 19 | 30 | 51 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S20 | F | 9 | 92 | 50 | 86 | 29 | 64 | 6 | 18 | 56 | 49 | 34 | 93 | 54 | 72 | 74 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S21 | M | 70 | 55 | 18 | 70 | 31 | 62 | 11 | 39 | 84 | 2 | 91 | 19 | 66 | 18 | 17 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
S22 | M | 9 | 23 | 49 | 7 | 86 | 17 | 19 | 86 | 96 | 72 | 88 | 11 | 56 | 58 | 86 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S23 | M | 37 | 74 | 21 | 16 | 80 | 50 | 26 | 63 | 32 | 53 | 10 | 11 | 9 | 90 | 70 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S24 | F | 72 | 17 | 14 | 20 | 75 | 76 | 19 | 41 | 26 | 65 | 47 | 98 | 43 | 98 | 87 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S25 | F | 72 | 37 | 68 | 94 | 19 | 76 | 57 | 46 | 10 | 34 | 54 | 10 | 91 | 15 | 72 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S26 | F | 12 | 29 | 27 | 61 | 63 | 67 | 65 | 95 | 72 | 78 | 30 | 28 | 71 | 48 | 98 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | M | 12 | 80 | 58 | 33 | 25 | 33 | 69 | 41 | 59 | 5 | 92 | 13 | 36 | 33 | 51 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
S28 | F | 32 | 17 | 84 | 89 | 29 | 56 | 18 | 16 | 47 | 75 | 74 | 17 | 29 | 54 | 21 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S29 | M | 6 | 54 | 44 | 73 | 38 | 21 | 63 | 43 | 52 | 44 | 18 | 25 | 32 | 11 | 77 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
S30 | M | 36 | 19 | 38 | 46 | 56 | 2 | 41 | 86 | 36 | 76 | 68 | 53 | 66 | 63 | 97 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S31 | M | 28 | 29 | 19 | 33 | 14 | 62 | 62 | 15 | 16 | 68 | 16 | 86 | 47 | 91 | 6 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
S32 | F | 58 | 78 | 64 | 37 | 57 | 6 | 88 | 32 | 74 | 12 | 21 | 79 | 93 | 15 | 77 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S33 | F | 69 | 75 | 41 | 36 | 28 | 93 | 68 | 73 | 4 | 85 | 8 | 98 | 6 | 9 | 78 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S34 | M | 55 | 21 | 49 | 21 | 58 | 10 | 17 | 61 | 40 | 91 | 25 | 9 | 30 | 88 | 29 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S35 | F | 25 | 7 | 34 | 69 | 64 | 5 | 15 | 90 | 53 | 40 | 15 | 95 | 32 | 39 | 62 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S36 | M | 17 | 22 | 88 | 54 | 22 | 94 | 87 | 86 | 22 | 79 | 93 | 22 | 2 | 65 | 52 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S37 | F | 12 | 81 | 28 | 92 | 21 | 84 | 66 | 70 | 74 | 23 | 25 | 6 | 86 | 33 | 30 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S38 | M | 19 | 91 | 64 | 90 | 23 | 15 | 56 | 88 | 30 | 65 | 57 | 32 | 6 | 39 | 77 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S39 | F | 75 | 78 | 41 | 21 | 71 | 80 | 37 | 33 | 7 | 39 | 7 | 85 | 98 | 8 | 37 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
S40 | M | 36 | 61 | 81 | 61 | 76 | 24 | 75 | 78 | 76 | 15 | 12 | 36 | 6 | 28 | 70 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S41 | F | 51 | 12 | 97 | 25 | 72 | 16 | 91 | 23 | 4 | 84 | 34 | 44 | 54 | 94 | 91 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S42 | F | 11 | 7 | 25 | 37 | 39 | 91 | 10 | 36 | 26 | 28 | 63 | 52 | 73 | 60 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
S43 | M | 28 | 7 | 90 | 48 | 35 | 26 | 41 | 40 | 7 | 51 | 79 | 42 | 83 | 39 | 16 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S44 | F | 46 | 77 | 6 | 88 | 61 | 49 | 83 | 23 | 32 | 57 | 58 | 63 | 37 | 46 | 98 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S45 | M | 66 | 6 | 67 | 45 | 77 | 14 | 89 | 58 | 89 | 38 | 63 | 95 | 4 | 79 | 52 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S46 | F | 68 | 64 | 6 | 26 | 61 | 81 | 61 | 39 | 4 | 41 | 56 | 57 | 46 | 2 | 76 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
S47 | M | 41 | 45 | 81 | 95 | 81 | 94 | 32 | 32 | 54 | 62 | 48 | 86 | 52 | 71 | 67 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S48 | M | 38 | 31 | 87 | 72 | 40 | 83 | 10 | 57 | 97 | 55 | 40 | 45 | 33 | 58 | 36 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
S49 | F | 31 | 35 | 35 | 61 | 7 | 81 | 19 | 75 | 44 | 98 | 60 | 3 | 30 | 62 | 29 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S50 | F | 42 | 12 | 74 | 58 | 85 | 18 | 86 | 11 | 89 | 10 | 27 | 46 | 86 | 31 | 97 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 |  |  |  | Open centre
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dist for centre
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Min student
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | [NAME] student