Forum Discussion

Schwibach's avatar
Schwibach
Copper Contributor
Jan 30, 2021

Optimisation problem (assigning group members) solvable with VBA, Solver?

Hello,    I have a rather interesting problem, I think.   I have 25 different groups and about 400 people who I need to assign to the groups. Every person has individual preferences that will le...
Macros and VBA
mathetes's avatar
mathetes
Silver Contributor
Jan 30, 2021

Schwibach 

 

You wrote:

I have set up a table with random values with 5 groups and 10 students for testing purposes.

 

The table gives all the individual utilities for each group assignment and I have one column with the selected group and then one column with the individual values for the selected group and the sum of the utilities.

 

Were you intending to attach a copy of that spreadsheet? It would make it far more likely that someone would help if your test workbook were available to, you know, test possible solutions.

Schwibach's avatar
Schwibach
Copper Contributor
Jan 30, 2021

mathetes 

 

Thank you for your reply and the advice.

 

I attached my spreadsheet.

In columns M and N I have the an outline of what I would like to get as a result.


Is there maybe a way to create all possible variations, cycle through them and write over columns M and N in case the current variation produces a higher sum value and does not violate any restrictions?

Resources