Page 682 - Excel 2013 All-in-One For Dummies

664 Using the Solver
Figure 1-14:
Modifying the solution options in the Options dialog box.
Table 1-1
Option
Constraint Precision
Use Automatic Scaling
Show Iteration Results
Ignore Integer Constraints Integer Optimality (%) Max Time (seconds) Iterations
Max Subproblems Max Feasible Solutions
The Solver Option Settings
Function
Specifies the precision of the constraints. 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. Specify a lower number (between 0 and 1) to reduce the time it takes the Solver to return a solution to your problem.
Select this check box to have the Solver automatically scale the results when solving the problem.
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 ignore any constraints you specify that use integers.
Specifies the percentage of integer optimality criteria that the Solver applies in solving the problem.
Specifies the maximum number of seconds that the Solver will spend on finding the solution.
Specifies the maximum number of times that the Solver will recalculate the worksheet when finding the solution.
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 feasible solutions that the
Solver will pursue when you select the Evolutionary method for solving the problem.