Why is solver so slow

Bear in mind that the Solver searches for an optimal solution within an N-dimensional "feasible space" whose boundaries are determined by the constraints. It often pays to add constraints , as long as they are not redundant -- i. Although the Solver must do more work on every iteration to process the extra constraints, often the result is that the solution process takes fewer iterations, for an overall time savings. Free Trial. Frontline's Premium Solver products can usually solve problems much faster than the standard Microsoft Excel Solver -- up to times faster in some cases.

Given the improved performance and low prices of new PC hardware, a faster computer is often a good investment. Even so, the methods discussed here should help reduce the time taken to solve your problem with any set of hardware and software. Quite strange just ran another one and it took 6 seconds. Hi all, Never mind. The example i was using is non linear. Initially i was using evolutionary was taking a long time switched to grg nonlinear.

You must log in or register to reply here. Similar threads J. Question Excel Slover function runs slow in larger sheets, despite no change to the actual calculation.

Joe00 Jul 8, Excel Questions. Replies 2 Views Jul 8, Joe Question Using Excel solver or other method with a common objective in multiple cells by changing the same variables, subject to constraints. Replies 3 Views Dec 16, offthelip. Question Excel Workbook - Too Slow.

I think that calculation method might always be handled at the application level even if solver is controlling it. Good thought though, thanks! KDavis, it's possible. Should this mean I'm not pressing up against system or bit application limits? Add a comment. Active Oldest Votes. Improve this answer. Rubin S. Rubin 1. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.