Spreadsheet: 883573d1732195501-request-for-help-developing-an-excel-solver-model-to-allocate-students-to-courses-student-allocation_-hydr9-
Sheet: Students

ID | Gender | CourseID | Assessment Score | Distance To 1 | Distance To 2 | Distance To 3 | Mean | Centre 1-1 | [NAME] | Centre 3-1 | Centre 1-2 | [NAME] | Centre 3-2 | Centre 1-3 | [NAME] | Centre 3-3 | Check |  |  | Data-course1 | Data-course2 | Data-course3 |  | Constr-1 | Constr-2 | Constr-3
S1 | Male | 1 | 11 | 68 | 41 | 64 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Objective
S2 | Male | 1 | 19 | 79 | 57 | 14 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Distance
S3 | Female | 1 | 1 | 66 | 73 | 5 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Female | 1 | 11 | 16 | 25 | 85 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S5 | Female | 2 | 11 | 68 | 73 | 73 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S6 | Male | 3 | 19 | 36 | 95 | 20 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S7 | Female | 2 | 1 | 79 | 51 | 50 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S8 | Male | 3 | 1 | 46 | 59 | 75 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S9 | Male | 1 | 11 | 92 | 31 | 52 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S10 | Male | 2 | 6 | 56 | 37 | 3 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S11 | Male | 2 | 11 | 12 | 34 | 30 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S12 | Male | 3 | 11 | 86 | 18 | 77 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S13 | Female | 1 | 11 | 95 | 4 | 86 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S14 | Female | 1 | 11 | 45 | 62 | 21 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S15 | Female | 2 | 19 | 16 | 38 | 80 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S16 | Female | 2 | 1 | 87 | 69 | 47 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S17 | Female | 1 | 19 | 56 | 5 | 19 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S18 | Male | 3 | 19 | 75 | 89 | 51 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S19 | Male | 3 | 19 | 10 | 53 | 3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S20 | Male | 1 | 11 | 60 | 11 | 37 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S21 | Male | 3 | 78 | 51 | 36 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S22 | Male | 3 | 35 | 12 | 61 | 82 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S23 | Female | 2 | 10 | 33 | 98 | 68 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S24 | Female | 3 | 18 | 5 | 72 | 77 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S25 | Female | 1 | 11 | 35 | 67 | 82 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
S26 | Female | 2 | 41 | 60 | 71 | 16 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
[NAME] | Female | 2 | 26 | 56 | 27 | 73 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
S28 | Male | 3 | 57 | 31 | 39 | 60 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S29 | Female | 3 | 68 | 34 | 87 | 79 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
S30 | Female | 2 | 24 | 84 | 78 | 11 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 | Total
 | Diff |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10 |  | Min students
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10 |  | [NAME] students
 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Force Course
 |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0
 |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1