Solver Frustration
 

Hello!

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


Any kind of feedback is appreciated,

Dima

Solver Frustration
 

Can you :
a) give the formula
b) define "best" in your context
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"zealot" wrote in message
...

Hello!

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


Any kind of feedback is appreciated,

Dima




--
zealot