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 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

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

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

Leave a Reply

Your email address will not be published.