Spreadsheet: 883496d1732114278-request-for-help-developing-an-excel-solver-model-to-allocate-students-to-courses-student-allocation-pkow-
Sheet: Centres (2)

 |  |  | Objective =
 | [NAME] | Address | [NAME] | Area |  | Centre | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | S1 | Address 1 |  | 5 |  |  | 68 | 90 | 97 | 86 | 22 | 38 | 93 | 98 | 36 | 56 | 48 | 48 | 87 | 48 | 53 | 24 | 49 | 63 | 15 | 25
 | S2 | Address 2 |  | 1 |  |  | 4 | 60 | 47 | 70 | 69 | 60 | 6 | 28 | 21 | 84 | 44 | 76 | 39 | 26 | 53 | 66 | 96 | 24 | 23 | 3
 | S3 | Address 3 |  | 4 |  |  | 23 | 37 | 34 | 34 | 79 | 25 | 41 | 81 | 21 | 81 | 49 | 2 | 6 | 81 | 90 | 30 | 56 | 89 | 24 | 41
 | [NAME] | Address 4 |  | 9 |  |  | 31 | 32 | 60 | 95 | 51 | 33 | 75 | 75 | 13 | 61 | 58 | 73 | 27 | 94 | 5 | 65 | 50 | 92 | 72 | 45
 | S5 | Address 5 |  | 2 |  |  | 83 | 2 | 83 | 59 | 99 | 67 | 59 | 68 | 45 | 55 | 73 | 19 | 47 | 6 | 4 | 48 | 6 | 16 | 19 | 62
 | S6 | Address 6 |  | 11 |  |  | 37 | 90 | 71 | 43 | 58 | 50 | 17 | 78 | 65 | 82 | 8 | 12 | 95 | 26 | 54 | 63 | 83 | 53 | 13 | 11
 | S7 | Address 7 |  | 12 |  |  | 49 | 100 | 77 | 45 | 22 | 99 | 48 | 77 | 79 | 50 | 42 | 12 | 31 | 94 | 66 | 88 | 35 | 85 | 3 | 72
 | S8 | Address 8 |  | 3 |  |  | 87 | 22 | 11 | 67 | 98 | 42 | 53 | 79 | 37 | 24 | 15 | 77 | 50 | 8 | 54 | 50 | 96 | 96 | 80 | 46
 | S9 | Address 9 |  | 7 |  |  | 15 | 39 | 51 | 57 | 87 | 27 | 4 | 69 | 59 | 65 | 51 | 80 | 40 | 62 | 58 | 27 | 19 | 96 | 54 | 26
 | S10 | Address 10 |  | 8 |  |  | 35 | 95 | 64 | 89 | 80 | 18 | 72 | 13 | 76 | 51 | 78 | 44 | 84 | 89 | 75 | 12 | 9 | 85 | 83 | 73
 | S11 | Address 11 |  | 6 |  |  | 8 | 15 | 63 | 88 | 75 | 33 | 39 | 28 | 43 | 65 | 35 | 56 | 70 | 12 | 23 | 48 | 10 | 27 | 7 | 58
 | S12 | Address 12 |  | 10 |  |  | 20 | 9 | 58 | 79 | 89 | 83 | 82 | 83 | 59 | 45 | 98 | 51 | 71 | 79 | 46 | 69 | 29 | 86 | 37 | 64
 | S13 | Address 13 |  | 13 |  |  | 60 | 4 | 41 | 44 | 26 | 86 | 88 | 14 | 58 | 17 | 66 | 86 | 2 | 57 | 54 | 68 | 95 | 13 | 32 | 63
 |  |  |  | objective 2 |  |  | Calcuated with OpenSolver (260 variables)
 |  |  |  |  |  | centre | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | sums - students
 |  |  |  |  | S1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  | S2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  |  | S3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | S5 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | S6 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | S7 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  | S8 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | S9 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | S10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  |  | S11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  | S12 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | S13 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | sums - centres