| The Premium Solver
requires that cells containing decision variables and constraint
left hand sides are on the active worksheet. But the Premium
Solver Platform allows you to define decision variables and
constraint left hand sides on any worksheet of a
workbook. For example, we can split the EXAMPLE1 model into two
parts, as shown to the right. Worksheet
Example1 contains the decision variables, and the
coefficients and SUMPRODUCT formula for the objective.
Worksheet Inventory contains the constraint left hand
sides (formulas), coefficients and right hand sides. The
constraint formulas on worksheet Inventory refer to the
variables as Example1!$D9:$F9. |
Click on the multi-worksheet
EXAMPLE1 model to see it full size. |
| Starting on worksheet Example1,
we can display the Solver Parameters dialog, click Add or
Change, then simply point and click across worksheets to
select the constraint left and right hand sides on worksheet
Inventory. |
Click on the Change Constraint
dialog to see it full size. |
| The resulting Solver Parameters
dialog is shown to the right. You could define another,
different Solver model on worksheet Inventory, and this
model could refer to variable and constraint cells on worksheets
Example1 and Inventory. The Premium Solver Platform keeps track
of all the models. By default, there is
one model per worksheet, and the variable, constraint and
objective cell selections for this model are saved “behind the
scenes.” The model displayed in the Solver Parameters dialog is
the one for the worksheet that is active when you select Tools
Premium Solver. But you can create additional named models
if you use PSI functions for optimization. |
Click on the Solver Parameters
dialog to see it full size. |
