![]() In Cell J2, I calculated a simple cost of the assignment as the cum of the individual student costs.Īt this point, I moved to solver to optimize my student assignment. In Column I, I calculated the size of the classes. In Column H, I listed out the possible classes: 1, 2, and 3. ![]() In column F, I have assigned a cost to each student's assignment as follows: =IF(given class = first choice, 0, if(given class = second choice, 1, 2). In Column E, I have assigned each student to a class based on their indicated preference. I have put the names of the students in column A, the first choices in column B, the second choices in column C, and the third choices in column D. We have a group of students who have each indicated an order of preference between three available classes. Here is the basic situation (apologies, I am not able to upload the file at this time): I put together a simplified version just to test, but I'm not getting the results I expected from solver. I built out a cost function to use in simulated annealing in matlab, but I'm trying to see if I can do the same thing directly in Excel (with less code writing). I am trying to optimize the allocation of students to courses in a school based on a number of parameters and constraints. I've recently started exploring solver, but I've hit a wall with using it on this particular problem.
0 Comments
Leave a Reply. |