Solver Iterations-how to change number
Thanks,
I found the problem in the troubleshooting. I didn't know if it was
something I would find there or if it was a trick that one of you experts
would know (the first time I trolled this site the result to my problem was a
clever little wrinkle). It turns out I got tired of looking right before I
got to it.
For anyone else stumbling onto this thread in the future, the problem I was
seeing was a "...could not find a feasible solution" message after a few
iterations. The solver would eventually work if I redid it a few times,
restarting with the previous run's results for my variables.
The solution was to check the "Use automatic scaling" box. I have a problem
where my variables range from 1 mil to 10 mil and when I start with all of
them at zero the range is too wide for the solver to deal with.
Thanks again for the help. Know there wasn't a special "trick" helped a lot.
Rick
|