3
I have an Excel model of medium complexity that I'm trying to do some sensitivity analysis on. The ideal would be to have, for each of a set of inputs, run over a range of possible values and store the resulting output values (so maybe changing one input value at a time, but at the next level would be nice to change multiple ones at once).
I know there are plugins for this - solver.net seems pretty sweet - but I rebel at spending $1000 for what is a conceptually simple issue. For now I am following the manual algorithm of change-the-value, see-the-new-value, copy-paste, repeat. Which sucks.
Do folks have recommended tips/techniques/macros for how to automate this process?
Are you using Excel's Solver add-in? – Mehper C. Palavuzlar – 2011-10-27T17:17:19.673
Not a tip for automation, but in the past I've found Excel's What-If Analysis feature very useful for this kind of analysis. http://office.microsoft.com/en-us/excel-help/introduction-to-what-if-analysis-HA010243164.aspx
– Excellll – 2011-10-27T17:34:14.207