Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Change how Solver finds solutions
- On the Tools menu, click Solver.
If the Solver command is not available on the Tools menu, you need to install the Solver add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.).
How?
- On the Tools menu, click Add-Ins.
-
If the add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) you want to use is not listed in the Add-Ins available box, click Browse, and then locate the add-in.
- In the Add-Ins available box, select the check box next to the add-in you want to load, and then click OK.
- If necessary, follow the instructions in the setup program.
- In the Solver Parameters dialog box, click Options.
- In the Solver Options dialog box, set one or more of the following options:
Solution time and iterations
- In the Max Time box, type the number of seconds that you want to allow for the solution time.
- In the Iterations box, enter the maximum number of iterations that you want to allow.
Note If the solution process reaches the maximum time or number of iterations before Solver finds a solution, Solver displays the Show Trial Solution dialog box.
Degree of precision
- In the Precision box, type the degree of precision that you want— the smaller the number, the higher the precision.
Integer tolerance
- In the Tolerance box, type the percentage of error you want to allow in the solution.
Degree of convergence
- In the Convergence box, type the amount of relative change you want to allow in the last five iterations before Solver stops with a solution— the smaller the number, the less relative change that is allowed.
Note You can use the Help button on the dialog box to get more information about other options.
- Click OK.
- In the Solver Parameters dialog box, click Solve or Close.
|