3 ms·
If it can handle the same formulas, then I could imagine a market for a tool that takes an existing spreadsheet and does what you say - allows to set a probabil
by PeterisP 13y ago
If it can handle the same formulas, then I could imagine a market for a tool that takes an existing spreadsheet and does what you say - allows to set a probability distribution for any number, recalculates everything, and shows the distribution for resultcells on, say, mouseover.
Convenience matters in such things, and simply reading a 20x20 data table into any programming language already takes more time than just writing the formulas next to this table in excel.
- yummyfajitas 13y agoI'm sure you could write such a plugin for excel with DataNitro or some such. The code is roughly: outputs = [] for x in monte_carlo_input(param1_dist, param2_dist, ...): outputs.append( (x, f(x)) ) histogram/whatever(outputs) In contrast, the code to manually tweak formulas is simply: > f(10, 3, 0.07) 12 > f(12, 5, 0.09) -3.9