The Sensitivity Report provides classical sensitivity analysis information for both linear and nonlinear programming problems, including dual values (in both cases) and range information (for linear problems only). The dual values for (nonbasic) variable ...
This message appears when Solver recalculates your worksheet using a new set of values for the decision variable cells, and discovers an error value such as #VALUE!, #NUM!, #DIV/0! or #NAME? in the objective cell or one of the constraint cells. Inspectin ...
It is helpful to understand what the GRG Nonlinear Solving method can and cannot do, and what each of the possible Solver Result Messages means for this Solver engine. At best, the GRG Solving method alone – like virtually all “classical” nonlinear optimi ...
This message appears when Solver could not find any combination of values for the decision variables that allows all of the constraints to be satisfied simultaneously. If you are using the Simplex LP Solving method, and the model is well scaled, Solver h ...
This message appears when Solver is able to increase (if you are trying to Maximize) or decrease (for Minimize) without limit the value in the Objective cell, while still satisfying the constraints. Remember that, if you’ve selected Minimize, the objectiv ...
In the Solver Parameters dialog box, click Options. In the Solver Options dialog box, on the GRG Nonlinear tab, choose one or more of the following options: Convergence In the Convergence box, type the amount of relative change that you want to allow in t ...
This message appears if you’ve selected the Simplex LP Solving method, but Solver’s numeric tests to ensure that the objective and constraints are indeed linear functions of the decision variables were not satisfied. If you receive this message, select an ...
It is helpful to understand what the Evolutionary Solving method can and cannot do, and what each of the possible Solver Result Messages means for this method. At best, the Evolutionary method – like other genetic or evolutionary algorithms – will be abl ...
If you press ESC while Solver is solving, the Show Trial Solution dialog box appears. Do one of the following: Click Stop to stop the solution process. The Solver Results dialog appears with a message that Solver stopped at your request. Click Continue t ...
Solver’s basic purpose is to find a solution – that is, values for the decision variables in your model – that satisfies all of the constraints and maximizes or minimizes the objective cell value (if there is one). The kind of solution you can expect, an ...