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.

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.
--
Dana DeLouis
Windows XP, Office 2003


"Gwyndalf" wrote in message
...
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.

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!!!

"Dana DeLouis" wrote:

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.
--
Dana DeLouis
Windows XP, Office 2003


"Gwyndalf" wrote in message
...
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.

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

"Gwyndalf" wrote:

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!!!

"Dana DeLouis" wrote:

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.
--
Dana DeLouis
Windows XP, Office 2003


"Gwyndalf" wrote in message
...
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.