Error message

The page you requested does not exist. For your convenience, a search was performed using the query category catalog excel products.

Search results

Excel Solver- Solver stopped at user’s request (6).

This message appears only if you press ESC to display the Show Trial Solution dialog, and then click the Stop button.  When you do this, no reports are available in the Solver Results dialog. ...

admin - 04/07/2015 - 14:49

Excel Solver- The problem is too large for Solver to handle (8).

This message appears when Solver determines that your model is too large for the Solving method you have selected.  All Solving methods are limited to 200 decision variables; the GRG Nonlinear and Evolutionary Solving methods are also limited to 100 const ...

admin - 04/07/2015 - 14:51

Excel Solver- Stop chosen when the maximum time limit was reached (10).

This message appears when (i) Solver has run for the maximum time (number of seconds) allowed in the Maximum Time box in the Solver Options dialog and (ii) you clicked the Stop button when Solver displayed the Show Trial Solution dialog. You may increase ...

admin - 04/07/2015 - 14:52

Excel Solver- Integer Constraints and the Integer Optimality Tolerance

Users who solve problems with integer constraints occasionally report that “Solver claims it found an optimal solution, but I manually found an even better solution.”  Solver now stops with the message “Solver found an integer solution within tolerance” i ...

admin - 04/07/2015 - 14:56

Excel Solver- Limitations on Smooth Nonlinear Optimization

Nonlinear optimization problems are intrinsically more difficult to solve than linear problems, and there are fewer guarantees about what kind of solution Solver can find.  If your smooth nonlinear problem is convex, Solver will normally find the globally ...

admin - 04/07/2015 - 14:57

Excel Solver- Multistart Methods for Global Optimization

Solver’s multistart methods for global optimization can overcome some of the limitations of the GRG Solving method alone, but they are not a panacea.  The multistart methods will automatically run the GRG method from a number of starting points and will d ...

admin - 04/07/2015 - 14:57

Pages