U.S. Department of Energy - Energy Efficiency and Renewable Energy

Geothermal Technologies Office

Instructions for Installing the Excel Solver Add-In

First check to determine if Solver is already installed by clicking on 'Tools' on the main EXCEL toolbar and then on 'Add-Ins' on the dropdown menu, as indicated in figure 1 below.

A screen shot of the GETEM Excel spreadsheet showing the action of clicking on 'Tools' on the main EXCEL toolbar and then on 'Add-Ins' on the subsequent dropdown menu.

Figure 1.

The window shown in figure 2 will open and the box should be checked on the line Solver Add-In. If it is not, check the box, then click on the 'OK' button. Note that when GETEM was opened, the user was prompted regarding whether Enable or Disable Macros. If the user opted to Disable Macros, the file should be saved and then re-opened with the macro Enabled.

A screen shot of the GETEM Excel spreadsheet showing the window that results from the action of clicking on 'Tools' on the main EXCEL toolbar and then on 'Add-Ins' on the subsequent dropdown menu.

Figure 2.

If the macro will not run after completing these steps, click on the 'Macro' option on the dropdown menu from the main tool bar 'Tools' icon (see figure 1). Click first on the macro "BinaryOptimum", and then on the Edit button. This will open the Visual Basic editor. Click on the main editor tool bar "Tools" icon and then References option shown in figure 3.

A screen shot of the GETEM Excel spreadsheet showing the Visual Basic editor.

Figure 3.

The window shown in figure 4 will open. Confirm the box next to SOLVER is checked, then click OK to close this window. Next close the Visual Basic editor, which should return the user to the GETEM spreadsheet. At this point the macro to optimize the binary cycle performance by minimizing the LCOE should run.

A screen shot of the GETEM Excel spreadsheet showing the screen resulting from Tools and References from the Visual Basic editor screen.

Figure 4.