Microsoft Office Tutorials and References

In Depth Information

**USING EXCEL SOLVER**

$J$16:$J$20

integer

¼

$J$16:$J$20 >

0

¼

$J21 <

$F$6

¼

$L$16 >

$G$16

¼

$L$17 >

$G$17

¼

$L$18 >

$G$18

¼

$L$19 >

$G$19

¼

$L$20 >

$G$20

¼

You should also click the Options button in the Solver Parameters window and check the Options dialog

box shown in Figure D-21. You can use this dialog box to set the maximum amount of time and iterations you

want Solver to run before stopping. Leave both options at 100 for now, but remember that Solver may need

more time and iterations for more complex problems. To get the best solution, you should set the Integer

Optimality (%) to zero. Click OK to close the dialog box.

FIGURE D-21

Solver Options dialog box with Integer Optimality set to 0

You are ready to run Solver to find the optimal solution. Click Solve at the bottom of the Solver

Parameters window. Solver might require only a few seconds or more than a minute to run all the possible

iterations

the status bar at the bottom of the Excel window displays iterations and possible solutions

continuously until Solver finds an optimal solution or runs out of time (see Figure D-22).

—