TM Goal Seek

TM Goal Seek enhances the existing user interface to Excel’s Goal Seek feature. The built in Goal Seek is a simple optimization tool that suffices for a large number of scenarios. The UI, unfortunately, is extremely unwieldy and unfriendly. TM Goal Seek is a simple add-in that is easier to use than the default dialog box because of three critical benefits:

  1. The target value can be a number or a reference to a cell that contains a number,
  2. The add-in retains values previously entered in the dialog box, and
  3. One can interact with the worksheet even with the dialog box open.

The motivation to develop the add-in came from work I was doing for a client who managed gambling sites not on gamstop that involved risk analysis on multiple investment scenarios of financial derivative trades. The default Goal Seek interface took way too long.

The current version of the add-in will expire on May 1, 2013.

For more see http://www.tushar-mehta.com/excel/software/goal_seek/index.htm

Tushar Mehta

2 thoughts on “TM Goal Seek

  1. re: “took way too long”.
    Only in the aspect of entering the data, correct ?
    IOW: you didn’t improve the goal-seeking process, right ?

  2. That’s correct, MSimms. If one wants a “better” approach, there’s always Solver. ;-)

    I do plan to add more capabilities to the add-in in the area of a better UI. One example is optimizing the the rows in a table by applying Goal Seek on a row-by-row basis, i.e.,

    Target-Cell Target-Value by-changing-cell
    Row 1
    Row 2
    Row 3
    etc.


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.