Microsoft Office Tutorials and References

In Depth Information

**Other Solver options**

lower the precision is. If you specify a setting that is less than the default 0.000001, it

results in a longer solution time.

The Max Time and Iterations boxes tell the Solver, in effect, how hard to work on the

solution. If the Solver reaches either the time limit or the number of iterations limit

before finding a solution, calculation stops, and Excel asks you whether you want to

continue. The default settings are usually sufficient for solving most problems, but if

you don’t reach a solution with these settings, you can try adjusting them.

●

●
The Integer Optimality (%) setting represents a percentage of error allowed for the

solution of integer-only constraints.

Figure 18-28
Fine-tune your optimization problems using the Solver Options dialog box.

This section only scratches the surface of optimization theory. There is extensive reading

available on the subject. For evidence, type nonlinear optimization into your browser’s

Search box and scan the results. You can also click the Help button at the bottom of the

Solver Parameters dialog box to display the Excel Help topic on the Solver.