Saves the Solver problem specifications on the worksheet. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select the Solver.x ...
Begins a Solver solution run. Equivalent to clicking Solve in the Solver Parameters dialog box. Before you use this function, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the To ...
...
...
If your download doesn't start within the next 5 seconds, please click here. ...
Add a constraint Change or delete a constraint In the Solver Parameters dialog box, under Subject to the Constraints, click Add. In the Cell Reference box, enter the cell reference or name of the cell range whose value(s) you want to constrain. You can u ...
A constraint such as A1:A5 = integer, where A1:A5 are decision variable cells, requires that the solution values for A1 through A5 must be integers or whole numbers, such as-1, 0 or 2, to within a small tolerance (determined by the Constraint Precision op ...
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 ...