Solver Adding Constraints

[legolas97]

Hi, I'm trying to optimize floor planning. I want the maximum number of people coming on any given day to be minimized, and to use minimum number of floors possible on any given day. Assume there are 5 groups of people and I can tell them what day of the week they have to come.

Second step would be if these groups are coming multiple times in a week.

I have currently tried using solver and got this ^ but as you can see the solution is far short of what I'm hoping for.

 

[legolas97]

How can I add a constraint like Group 1 cannot come with group 2?

 

[legolas97]

Hi is this something that's not feasible?

 

[BSALV]

this is feasible as worksheet not as an image, so can you give an example with the XL2BB-tool or with a link.
Group1 not together with Group2 = binary variables for each group (and each day) and the sum <=1
The number of variables (especially binary) becomes soon too high ...
I don't see any relationship between your capacity and your groups.

 

[legolas97]

this is feasible as worksheet not as an image, so can you give an example with the XL2BB-tool or with a link.
Group1 not together with Group2 = binary variables for each group (and each day) and the sum <=1
The number of variables (especially binary) becomes soon too high ...
I don't see any relationship between your capacity and your groups.

Hi I'm not able to add the xl2bb tool, in fact both that and the solver tool are no longer appearing on the ribbon.

I'm attaching a link to the excel file for your reference.

easyupload.io

easyupload.io

easyupload.io

 

[legolas97]

Basically group 1 can come to school 1 time a week, 2 times, 3 times, 4 times or 5 times.

And its also possible that group 1 cannot sit with group 2 for instance.

Like I said the objective is to reduce the space requirement given this. With the assumption that we can tell each group when they have to come.

 

[BSALV]

i have no idea what you're optimizing.
Can you explain the whole story because what you do and what you say doesn't match.

 

[legolas97]

i have no idea what you're optimizing.
Can you explain the whole story because what you do and what you say doesn't match.

Ok let me retry.

I'm optimizing from a real estate perspective.
We have an academy for which we've leased out some land.

Students come to the academy in groups.
I want to be able to use minimal number of floors by telling them on what days to come.
So on any given day I want the minimum number of students turning up.

So then I can contract/reduce the area I'm currently leasing.