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).
 
Search JabSto ::




Custom Search