Spreadsheet: 883565d1732187095-request-for-help-developing-an-excel-solver-model-to-allocate-students-to-courses-student-allocation-pkow-
Sheet: Students (4)

ID | Gender | CourseID | Assessment Score | Dist to Cen1 | Dist to Cen2 | Dist to Cen3 | Mean | Centre 1 | Centre 2 | Centre 3 | Check | course#  at C1 | course#  at C2 | course#  at C3 | ci1xi1-z1 | ci2xi2-z2 | ci3xi3-z3 | 5(1-xi1) | 5(1-xi2) | 5(1-xi3) | -5(1-xi1) | -5(1-xi2) | -5(1-xi3)
S1 | Female | 1 | 1 | 15 | 15 | 15 |  | 1 | 0 | 0
S2 | Male | 1 | 6 | 15 | 15 | 15 |  | 1 | 0 | 0
S3 | Female | 1 | 11 | 25 | 25 | 25 |  | 1 | 0 | 0
[NAME] | Female | 1 | 10 | 5 | 5 | 5 |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Objective
S5 | Male | 1 | 37 | 70 | 70 | 70 |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Distance
S6 | Male | 1 | 20 | 67 | 67 | 67 |  | 0 | 0 | 0
S7 | Female | 1 | 11 | 10 | 10 | 10 |  | 1 | 0 | 0
S8 | Male | 2 | 19 | 25 | 25 | 25 |  | 0 | 0 | 0
S9 | Male | 2 | 1 | 10 | 10 | 10 |  | 0 | 0 | 0
S10 | Male | 2 | 19 | 25 | 25 | 25 |  | 0 | 0 | 0
S11 | Female | 2 | 18 | 46 | 46 | 46 |  | 0 | 0 | 0
S12 | Female | 2 | 73 | 64 | 64 | 64 |  | 0 | 0 | 0
S13 | Female | 3 | 1 | 15 | 15 | 15 |  | 0 | 1 | 0
S14 | Female | 3 | 11 | 25 | 25 | 25 |  | 0 | 1 | 0
S15 | Female | 3 | 19 | 30 | 30 | 30 |  | 0 | 1 | 0
S16 | Female | 3 | 41 | 9 | 9 | 9 |  | 0 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the number of a course assigned to the centre
S17 | Male | 3 | 68 | 11 | 11 | 11 |  | 0 | 1 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z1 | z2 | z3
S18 | Male | 3 | 64 | 51 | 51 | 51 |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 4
S19 | Male | 4 | 19 | 25 | 25 | 25 |  | 0 | 0 | 0
S20 | Male | 4 | 11 | 20 | 20 | 20 |  | 0 | 0 | 0
S21 | Male | 4 | 11 | 20 | 20 | 20 |  | 0 | 0 | 0
S22 | Female | 4 | 1 | 15 | 15 | 15 |  | 0 | 0 | 1
S23 | Female | 4 | 19 | 30 | 30 | 30 |  | 0 | 0 | 0
S24 | Male | 4 | 11 | 25 | 25 | 25 |  | 0 | 0 | 0
S25 | Male | 4 | 78 | 16 | 16 | 16 |  | 0 | 0 | 0
S26 | Male | 4 | 35 | 73 | 73 | 73 |  | 0 | 0 | 0
[NAME] | Male | 4 | 57 | 18 | 18 | 18 |  | 0 | 0 | 0
S28 | Female | 4 | 68 | 11 | 11 | 11 |  | 0 | 0 | 1
S29 | Female | 4 | 24 | 8 | 8 | 8 |  | 0 | 0 | 1
S30 | Female | 4 | 35 | 73 | 73 | 73 |  | 0 | 0 | 0
S31 | Male | 4 | 10 | 5 | 5 | 5 |  | 0 | 0 | 1
S32 | Male | 4 | 18 | 46 | 46 | 46 |  | 0 | 0 | 0
S33 | Male | 4 | 11 | 57 | 57 | 57 |  | 0 | 0 | 0
S34 | Male | 4 | 26 | 35 | 35 | 35 |  | 0 | 0 | 0
S35 | Male | 4 | 57 | 18 | 18 | 18 |  | 0 | 0 | 0
S36 | Male | 4 | 24 | 8 | 8 | 8 |  | 0 | 0 | 1
S37 | Female | 4 | 22 | 54 | 54 | 54 |  | 0 | 0 | 0
S38 | Female | 4 | 55 | 22 | 22 | 22 |  | 0 | 0 | 0
S39 | Female | 4 | 63 | 27 | 27 | 27 |  | 0 | 0 | 0
S40 | Female | 4 | 48 | 49 | 49 | 49 |  | 0 | 0 | 0
S41 | Female | 4 | 57 | 52 | 52 | 52 |  | 0 | 0 | 0
S42 | Male | 5 | 11 | 20 | 20 | 20 |  | 0 | 0 | 0
S43 | Female | 5 | 11 | 25 | 25 | 25 |  | 0 | 0 | 0
S44 | Female | 5 | 11 | 25 | 25 | 25 |  | 0 | 0 | 0
S45 | Male | 5 | 11 | 20 | 20 | 20 |  | 0 | 0 | 0
S46 | Male | 5 | 19 | 30 | 30 | 30 |  | 0 | 0 | 0
S47 | Female | 5 | 11 | 57 | 57 | 57 |  | 0 | 0 | 0
S48 | Female | 5 | 26 | 35 | 35 | 35 |  | 0 | 0 | 0
S49 | Male | 5 | 78 | 16 | 16 | 16 |  | 0 | 0 | 0
S50 | Male | 5 | 41 | 9 | 9 | 9 |  | 0 | 0 | 0
 | Total
 | Diff