View Single Post
  #10   Report Post  
Dana DeLouis
 
Posts: n/a
Default

Sounds like you may be using other functions that "Jump." (ie Max, Min,
VLookUp, If ...) Feel free to send me your workbook. I'd be interested
in seeing a real world "gear ratio" problem. Thanks. :)

--
Dana DeLouis
Win XP & Office 2003


"Rick" wrote in message
...
I tried changing the system around based on the IF statement advice. No
improvement.
For some reason, Solver changes one variable (which happens to have a
binary
constraint) and makes five attempts without changing anything else. It
doesn't even change this one back to zero.
Isn't a binary constraint really a form of an IF statement? If zero, than
something. If one, then something else. It is not linear.

"Dana DeLouis" wrote:

Just to add. You may want to change your initial starting values. By
starting from different numbers, Solver may find a different local
minimum
(or maximum). Make sure your model doesn't use any IF statements, as
this
is one common source of problems for Solver.

--
Dana DeLouis
Win XP & Office 2003


"Rick" wrote in message
...
More information: I just found some information in the help system
stating
"When the relative change in the target cell value is less than the
number
in
the Convergence box for the last five iterations, Solver stops."
This seems to be what's happening. By selecting "Show Iteration
Results"
in
the Options window I can see the five iterations. And nothing is
changing
from one attempt to the next. I'm even looking at the numbers out 25
places.

Why isn't at least one variable changed?

<snip