View Single Post
  #9   Report Post  
Rick
 
Posts: n/a
Default

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