LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why can the number of iterations repeat many times as a loop?? Jorge Luis Excel Discussion (Misc queries) 0 February 1st 08 04:15 PM
Anyone know how to display iterations from solver? Melic Excel Worksheet Functions 1 October 23rd 06 01:00 PM
Setting default number of iterations within ALL my excel spreadshe Gavin Bulman Excel Worksheet Functions 4 October 6th 06 04:38 PM
number of iterations as default Gavin Bulman Excel Worksheet Functions 0 October 6th 06 09:10 AM
Catching max iterations Stop of Solver in VBA wgaskill Excel Programming 9 November 24th 05 12:37 AM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"