Recently we released an update that supported running Excel’s Goalseek function within a Monte Carlo simulation. This proved very useful but led to the obvious question: how to optimize the result of a simulation - which isn’t possible using Goalseek.

It is possible to do this using some VBA code, but it’s not as easy to use as Goalseek. To make it easier to run this kind of analysis, we’ve put together a simple point-and-click linear optimizer for running simulations. The package and a more complete description are available from our library page:

Optimizing Simulation Variables

This is an early release and may contain some bugs. Please save your work before installing or running the optimizer! If you have any comments or questions about the optimizer, please let us know.