Menu | <<<< | >>>> | [3. Install
Solver] – Click to complete model configuration
|
|
|
After the configuration
buttons have been clicked and the cell information entered (in color) has
been entered, the buttons are removed.
If you want to invoke the option of configuring some target cells to
be greater or equal to zero, do so next.
As each configuration button is clicked, cells that will contain
solution information are added to the {Current solution status} sheet. The final step in configuration is to click
the [3. Install Solver] button which installs the Solver using information
from the {Solver parameters} sheet, removes the {Solver parameters} sheet,
removes any remaining configuration buttons, and saves the model. At this point if you want to reconfigure
the model, you must start over again by creating the model workbooks from the
{Variables} sheet of the equation-parameter workbook. There is another button
(not shown here) [Use previous configuration]. Each time a model is configured, the Solver
installed, and the model saved, the configuration (selection of the green and
red cells) is saved. Then if the model
is re-built and you want to use the SAME configuration, you can simply click
the [Use previous configuration] button instead of buttons 1 and 2 to call up
the last configuration for use.
Clicking the [3. Install Solver] button again adds the Solver and
saves the configuration. This process
saves time if you have a complicated configuration which you want to use
every time you re-build or re-assemble the model (with different coefficients
or equations structures perhaps). There is also a
possibility for still another button [Other configurations]. This button is added when a Module1.xls
sheet has been added to the model directory. This sheet can contain a VBA program that
you develop which will run when this button is clicked (for example, the
program might carry out an extra special configuration for certain types of
solutions, such as a free trade agreement). If the model directory does not contain a
Module1.xls sheet, then this button will not be installed. |