NOTE You can click the Help button in the dialog box to get more information about other options. In the Solver Parameters dialog box, click Options. In the Solver Options dialog box, on the Evolutionary tab, choose one or more of the following options: ...
In the Solver Parameters dialog box, click Reset All. In the confirmation dialog, click OK. The By Changing Variable Cells box and the Constraints list box are cleared, the Set Objective box is set to the active cell, and all Solver options are reset to t ...
In the Solver Parameters dialog box, click Load/Save. When you save a model, enter the reference for the first cell of a vertical range of empty cells in which you want to save the model specifications. When you load a model, enter the reference for the e ...
If Solver stops with a solution (set of values for the decision variables) that is different from what you expect, or what you believe is correct, please follow the suggestions below. You can usually narrow down the problem to one of a few possibilities. ...
This means that Solver has found the optimal or “best” solution under the circumstances. The exact meaning depends on whether you are solving a linear, smooth nonlinear, or integer programming problem, as outlined below. This message doesn’t appear for ...
This means that Solver has found a series of “best” solutions that satisfy the constraints, and that have very similar objective function values; however, no single solution strictly satisfies Solver’s test for optimality. The exact meaning depends on wh ...
This means that Solver has found solutions that satisfy the constraints, but it has been unable to further improve the objective, even though the tests for optimality (“Solver found a solution”) and convergence (“Solver converged to the current solution”) ...
This message appears when (i) Solver has completed the maximum number of iterations, or trial solutions, allowed in the Iterations box in the Solver Options dialog and (ii) you clicked the Stop button when Solver displayed the Show Trial Solution dialog. ...
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. ...
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 ...