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