Set solver constraints so variables are either 1 OR 0.

[Gwyndalf]

I have an array which consists of some 100 variables but each can only be 1
or zero. (0.3 of a vehicle is meaningless!!!) If I place the constraints of

=0 and <=1 and INT(all seperate line entries) the solver still wastes many

iterations with decimal numbers resulting in a long time to work out the
solution. The variables are used to specify the numbers of vehicle types
needed to tramsport a certain number of passengers. Each vehicle has a
different capacity and a different cost. I wish to find the cheapest
solution hence the variables array.

Can anyone offer a solution to the subject problem? Many Thanks.

 

[Dana DeLouis]

each can only be 1 or zero.

the constraints of >=0 and <=1 and INT(all separate line entries).

One option would be to use the following instead.
For one of the constraints, add that A1:A100 are "bin." (The last item in
the pull-down menu).
bin means "Binary", which is the integer 0 or 1, and is designed to be a
little more efficient then the above code.
Hopefully this will help.

 

[Gwyndalf]

Thanks for taking the time to reply.
The solver still comes up with decimal values despite using bin as the
constraint - I suspect that I must be thick!!!

 

[slebo]

Did you ever get an answer? I am having the same exact problem.