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- 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

Excel Solver-Interpreting the Answer Report

The Answer Report, which is available whenever a solution has been found, provides basic information about the decision variables and constraints in the model.  It also gives you a quick way to determine which constraints are “binding” or satisfied with e ...

admin - 04/07/2015 - 14:59

Excel Solver- Interpreting the Limits Report

The Limits Report provides a specialized kind of “sensitivity analysis” information.  It is created by re-running the Solver model with each decision variable in turn as the objective (both maximizing and minimizing), and all other variables held fixed.  ...

admin - 04/07/2015 - 14:59

Excel Solver- Interpreting the Population Report

The Population Report gives you summary information about the entire population of candidate solutions maintained by the Evolutionary Solving method at the end of the solution process.  The Population Report can give you insight into the performance of th ...

admin - 04/07/2015 - 15:00

Pages