Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
webquery and solver macros | Excel Discussion (Misc queries) | |||
Solver does not work from Macros | Setting up and Configuration of Excel | |||
Excel Solver Issue | Excel Discussion (Misc queries) | |||
Trouble with Solver | Excel Discussion (Misc queries) | |||
Using Solver with VBA | Excel Discussion (Misc queries) |