Specifies the maximum number of feasible solutions that the Solver will pursue when you select the Evolutionary method for solving the problem. Specifies the maximum number of subproblems that the Solver takes on when using the Evolutionary method to solve the problem. Specifies the maximum number of times that the Solver will recalculate the worksheet when finding the solution. Specifies the maximum number of seconds that the Solver will spend on finding the solution. Specifies the percentage of integer optimality criteria that the Solver applies in solving the problem.
Select this check box to have the Solver ignore any constraints you specify that use integers. Select this check box to have the Solver show the results for the iterations followed in solving the problem. Select this check box to have the Solver automatically scale the results when solving the problem. Specify a lower number (between 0 and 1) to reduce the time it takes the Solver to return a solution to your problem. The number that you enter in this text box determines whether the value in a constraint cell meets the specified value or the upper or lower limit you have set. Specifies the precision of the constraints. Excel then opens the Options dialog box with the All Methods tab selected where you can make all necessary changes. To change the solution options, click the Options button in the Solver Parameters dialog box. In some situations, however, you may want to change some of the Solver options before you begin the solution process. Click the Solve button to have the Solver solve the problem as you’ve defined it in the Solver Parameters dialog box.įor most of the problems, the default options used by the Solver are adequate.(Optional) Select LP Simplex or Evolutionary from the Select a Solving Method drop-down list to use either one of these methods solving nonsmooth problems.To use the LP Simplex method (for Linear Programming following the Simplex algorithm) or Evolutionary engine for solving non-smooth problems, you need to follow Step 7. (Optional) Deselect the Make Unconstrained Variables Non-Negative check box if you want to allow negative values when the variable cells are not subject to constraints.īy default, the Solver Add-in employs the GRG (Generalized Reduced Gradient) Nonlinear method in solving the model whose parameters you’re setting known as a very efficient way to solve smooth nonlinear problems.After you finish defining constraints for the target cell and changing values in the model, click OK to close the Add Constraint dialog box and return to the Solver Parameters dialog box (which now lists your constraints in the Subject to the Constraints list box). Then, repeat Step 5 to add a new constraint. To continue adding constraints for other cells used by the Solver, click the Add button to add the constraint and clear the text boxes in the Add Constraint dialog box.