Microsoft Office Tutorials and References
In Depth Information
EXTENDING THE EXAMPLE
When you click Change, the Change Constraint dialog box appears. Click the Cell Reference button;
the selected cells will appear on the spreadsheet with a moving marquee around them (see Figure D-34).
Highlight the new group of cells; when the new range appears in the Cell Reference field, click OK. The
Solver Parameters window appears with the constraint changed.
FIGURE D-34
Adding cells H21 and H22 to the Trucks constraint cell range
You also need to update or add the following constraints:
￿
Update $J$16:$J$20 >
0 to $J$16:$J$22 >
0.
¼
¼
￿
Update $H$16:$H$20
integer to $H$16:$H$22
integer. When changing integer constraints,
¼
¼
you must click
in the middle field of the Change Constraint dialog box; otherwise, you will
receive an error message.
int
￿
Update $J$16:$J$20
integer to $J$16:$J$22
integer.
¼
¼
￿
Add constraint $L$21 >
$G$21 (see Figure D-35).
¼
￿
Add constraint $L$22 >
$G$22.
¼
FIGURE D-35
Adding a constraint using the Add Constraint dialog box
 
Search JabSto ::




Custom Search