Z
zealot
Hello!
I am using solver the first time so I am a bit frustrated by thi
application. I am using it to find the best combination of variables
and B – both of which control the formulas in separate columns.
have put constraint on A to be between 4 and 10 and B between 30 and 6
– so there are a lot of possible combinations of these parameter
(e.g. 4;40, 7;45 and so forth). However, when I press the Solve butto
the Solver just flicks for two or 5 combinations – from what
can see in he progress window in the lower left hand corner and he
gives off its result. Most of the times the result was not the bes
combination. Is there a problem with the tool or I should use anothe
one to rotate through the various pairs of variables between th
constraints that I use?
Any kind of feedback is appreciated,
Dim
I am using solver the first time so I am a bit frustrated by thi
application. I am using it to find the best combination of variables
and B – both of which control the formulas in separate columns.
have put constraint on A to be between 4 and 10 and B between 30 and 6
– so there are a lot of possible combinations of these parameter
(e.g. 4;40, 7;45 and so forth). However, when I press the Solve butto
the Solver just flicks for two or 5 combinations – from what
can see in he progress window in the lower left hand corner and he
gives off its result. Most of the times the result was not the bes
combination. Is there a problem with the tool or I should use anothe
one to rotate through the various pairs of variables between th
constraints that I use?
Any kind of feedback is appreciated,
Dim