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:
- The target value can be a number or a reference to a cell that contains a number,
- The add-in retains values previously entered in the dialog box, and
- 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 http://www.tushar-mehta.com/excel/software/goal_seek/index.htm
re: “took way too long”.
Only in the aspect of entering the data, correct ?
IOW: you didn’t improve the goal-seeking process, right ?
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.