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.