SolverTable Help
SolverTable add-in for Excel 2010
This add-in is a natural extension to the Solver add-in developed by Frontline Systems. SolverTable performs sensitivity analysis for an Excel optimization model, and, in most cases, its output is more relevant and understandable than the optional sensitivity output provided by Solver itself.
SolverTable is very easy to use, as I describe below. All it requires is an existing optimization model. That is, there must be a spreadsheet model already built, and Solver must be installed. This document explains how to use SolverTable, and it illustrates the procedure with several screen shots.
Sections of this Help file
Versions of SolverTable
Loading SolverTable
Unloading SolverTable
An example file
Running SolverTable
Creating a one-way table
Creating a two-way table
Being creative
Other Notes
Versions of SolverTable
I developed SolverTable in the late 1990s, and I have been enhancing and modifying it ever since. It has always presented a challenge because it invokes Solver, and Solver has some behind-the-scene idiosyncrasies that make it difficult to program for. This caused problems (for a few users, certainly not for all users) with SolverTable for Excel 2003 and earlier, and for Excel 2007. These problems are documented on my www.kelley.iu.edu/albrightbooks/free_downloads.htm Web site. To combat these, I rewrote the add-in for Premium Solver and Risk Solver Platform, two advanced versions of Solver, and renamed it SolverTablePremium. This version has worked fine for just about everyone, the reason being the different API (application programming interface) used by these versions of Solver. The only problem is that you have to purchase these advanced versions of Solver; they do not ship with Office.
The current version of SolverTable was rewritten explicitly for Excel 2010, but it should work fine with Excel 2007. The only difference is that Solver for Excel 2010 includes Evolutionary Solver and a MultiStart option for GRG
This add-in is a natural extension to the Solver add-in developed by Frontline Systems. SolverTable performs sensitivity analysis for an Excel optimization model, and, in most cases, its output is more relevant and understandable than the optional sensitivity output provided by Solver itself.
SolverTable is very easy to use, as I describe below. All it requires is an existing optimization model. That is, there must be a spreadsheet model already built, and Solver must be installed. This document explains how to use SolverTable, and it illustrates the procedure with several screen shots.
Sections of this Help file
Versions of SolverTable
Loading SolverTable
Unloading SolverTable
An example file
Running SolverTable
Creating a one-way table
Creating a two-way table
Being creative
Other Notes
Versions of SolverTable
I developed SolverTable in the late 1990s, and I have been enhancing and modifying it ever since. It has always presented a challenge because it invokes Solver, and Solver has some behind-the-scene idiosyncrasies that make it difficult to program for. This caused problems (for a few users, certainly not for all users) with SolverTable for Excel 2003 and earlier, and for Excel 2007. These problems are documented on my www.kelley.iu.edu/albrightbooks/free_downloads.htm Web site. To combat these, I rewrote the add-in for Premium Solver and Risk Solver Platform, two advanced versions of Solver, and renamed it SolverTablePremium. This version has worked fine for just about everyone, the reason being the different API (application programming interface) used by these versions of Solver. The only problem is that you have to purchase these advanced versions of Solver; they do not ship with Office.
The current version of SolverTable was rewritten explicitly for Excel 2010, but it should work fine with Excel 2007. The only difference is that Solver for Excel 2010 includes Evolutionary Solver and a MultiStart option for GRG