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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
Since there are large differences in the time it takes to find a solution and the kinds of solutions – globally optimal, locally optimal, or simply “good” – that you can expect for different types of problems, it pays to understand the differences between ...
A nonlinear function is any function of the variables that is not linear, i.e. which cannot be written in the algebraic form: a 1 x 1 + a 2 x 2 +... + a n x n Examples are =1/C1, =LOG(C1), and =C1^2, where C1 is a decision variable. All of these are call ...
If you are using the Evolutionary Solving method, this message appears when (i) Solver has explored the number of subproblems allowed by the Maximum Subproblems option in the Solver Options dialog and (ii) you clicked the Stop button when Solver displayed ...
If you are using the GRG Nonlinear Solving method and you’ve selected the Use Multistart check box in the Solver Options dialog, this message appears when the multistart method’s Bayesian test has determined that all of the locally optimal solutions have ...