Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why can the number of iterations repeat many times as a loop?? | Excel Discussion (Misc queries) | |||
Anyone know how to display iterations from solver? | Excel Worksheet Functions | |||
Setting default number of iterations within ALL my excel spreadshe | Excel Worksheet Functions | |||
number of iterations as default | Excel Worksheet Functions | |||
Catching max iterations Stop of Solver in VBA | Excel Programming |