Spreadsheet: 883698d1732351347-request-for-help-developing-an-excel-solver-model-to-allocate-students-to-courses-student-allocation-pkow-
Sheet: Students (6)

ID | Gender | CourseID | Assessment Score | Dist to Cen1 | Dist to Cen2 | Dist to Cen3 | Mean | Centre 1 | Centre 2 | Centre 3 | Check | Score 1 | Score 2 | Score 3
S1 | Female | 4 | 11 | 68 | 41 | 64 |  | 0 | 0 | 0 |  |  |  |  | Scores of the selected students are shown for test purposes only, not the part of the model
S2 | Male | 4 | 19 | 79 | 57 | 14 |  | 0 | 0 | 1
S3 | Female | 4 | 1 | 66 | 73 | 5 |  | 0 | 0 | 1
[NAME] | Female | 4 | 11 | 16 | 25 | 85 |  | 0 | 0 | 0 |  |  |  |  |  |  | Distance
S5 | Male | 4 | 11 | 68 | 73 | 73 |  | 0 | 0 | 0 |  |  |  |  |  |  | Total score
S6 | Male | 4 | 19 | 36 | 95 | 20 |  | 0 | 0 | 0
S7 | Female | 4 | 1 | 79 | 51 | 50 |  | 0 | 0 | 0 |  |  |  |  |  |  | "Correctional coefficient" M | 100
S8 | Male | 4 | 1 | 46 | 59 | 75 |  | 0 | 0 | 0 |  |  |  |  |  |  | objective: M*distance-Total score
S9 | Male | 4 | 11 | 92 | 31 | 52 |  | 0 | 0 | 0
S10 | Male | 4 | 6 | 56 | 37 | 3 |  | 0 | 0 | 1
S11 | Female | 4 | 11 | 12 | 34 | 30 |  | 1 | 0 | 0 |  |  |  |  |  | Minimizing the distance and maximizing the score (built-in Solver)
S12 | Female | 4 | 11 | 86 | 18 | 77 |  | 0 | 1 | 0 |  |  |  |  |  | A "tricky" objective function in S10 is used
S13 | Female | 4 | 11 | 95 | 4 | 86 |  | 0 | 1 | 0 |  |  |  |  |  | The total score turned out to be 665
S14 | Female | 4 | 11 | 45 | 62 | 21 |  | 0 | 0 | 0
S15 | Female | 4 | 19 | 16 | 38 | 80 |  | 1 | 0 | 0
S16 | Female | 4 | 1 | 87 | 69 | 47 |  | 0 | 0 | 0
S17 | Male | 4 | 19 | 56 | 5 | 19 |  | 0 | 1 | 0
S18 | Male | 4 | 19 | 75 | 89 | 51 |  | 0 | 0 | 0
S19 | Male | 4 | 19 | 10 | 53 | 3 |  | 0 | 0 | 1
S20 | Male | 4 | 11 | 60 | 11 | 37 |  | 0 | 1 | 0
S21 | Male | 4 | 78 | 51 | 36 | 10 |  | 0 | 0 | 1
S22 | Female | 4 | 35 | 12 | 61 | 82 |  | 1 | 0 | 0
S23 | Female | 4 | 10 | 33 | 98 | 68 |  | 0 | 0 | 0
S24 | Male | 4 | 18 | 5 | 72 | 77 |  | 1 | 0 | 0
S25 | Male | 4 | 11 | 35 | 67 | 82 |  | 0 | 0 | 0
S26 | Male | 4 | 41 | 60 | 71 | 16 |  | 0 | 0 | 1
[NAME] | Male | 4 | 26 | 56 | 27 | 73 |  | 0 | 0 | 0
S28 | Female | 4 | 57 | 31 | 39 | 60 |  | 0 | 0 | 0
S29 | Female | 4 | 68 | 34 | 87 | 79 |  | 0 | 0 | 0
S30 | Female | 4 | 24 | 84 | 46 | 59 |  | 0 | 0 | 0
S31 | Male | 4 | 10 | 5 | 92 | 31 |  | 1 | 0 | 0
S32 | Male | 4 | 18 | 46 | 56 | 37 |  | 0 | 0 | 0
S33 | Male | 4 | 11 | 57 | 12 | 34 |  | 0 | 1 | 0
S34 | Male | 4 | 26 | 35 | 86 | 18 |  | 0 | 0 | 0
S35 | Male | 4 | 57 | 18 | 95 | 4 |  | 0 | 0 | 1
S36 | Male | 4 | 24 | 75 | 89 | 8 |  | 0 | 0 | 1
S37 | Female | 4 | 22 | 10 | 53 | 54 |  | 1 | 0 | 0
S38 | Female | 4 | 55 | 60 | 11 | 22 |  | 0 | 1 | 0
S39 | Female | 4 | 63 | 51 | 36 | 27 |  | 0 | 0 | 0
S40 | Female | 4 | 48 | 56 | 37 | 49 |  | 0 | 0 | 0
S41 | Female | 4 | 57 | 12 | 34 | 52 |  | 1 | 0 | 0
S42 | Male | 4 | 11 | 68 | 41 | 20 |  | 0 | 0 | 0
S43 | Female | 4 | 11 | 79 | 57 | 25 |  | 0 | 0 | 0
S44 | Female | 4 | 11 | 66 | 68 | 41 |  | 0 | 0 | 0
S45 | Male | 4 | 11 | 16 | 79 | 57 |  | 0 | 0 | 0
S46 | Male | 4 | 19 | 68 | 66 | 73 |  | 0 | 0 | 0
S47 | Female | 4 | 11 | 36 | 16 | 25 |  | 0 | 1 | 0
S48 | Female | 4 | 26 | 35 | 68 | 73 |  | 0 | 0 | 0
S49 | Male | 4 | 78 | 16 | 36 | 95 |  | 1 | 0 | 0
S50 | Male | 4 | 41 | 9 | 10 | 53 |  | 0 | 1 | 0
 | Total
 | Diff |  |  |  |  |  |  | Students allocated to centres