|How It Works|
SimVoi provides random number generator functions as inputs for your model, automates
Monte Carlo simulation, computes value of information, and displays the results.
Your spreadsheet model may include various uncontrollable uncertainties as input assumptions. Examples are demand for a new product, uncertain variable cost of production, and competitor reaction. You can use simulation to determine the uncertainty associated with the model’s output (e.g., annual profit).
SimVoi automates the simulation by trying thousands of what-ifs consistent with your assessment of the uncertainties and displays the results in histograms, cumulative charts, bivariate scatter plots, and value of information charts.
You can purchase SimVoi risk-free with our 90-day Money-Back Guarantee.
Single-license SimVoi Pro $79
- Save time by using SimVoi to automate Monte Carlo simulation.
- Two ways to run SimVoi: quick launch for temporary use, or permanent installation.
- Make informed decisions explicitly accounting for uncertainty.
- Measure the value of obtaining information about uncertain assumptions.
- Use Excel’s formatting commands to customize SimVoi’s charts.
- Use SimVoi’s tables and charts to explain your analysis to clients and colleagues.
- SimVoi provides results for multiple variables on a single simulation run.
- SimVoi can process more than a million trials for your simulation in an Excel XLSX workbook.
- SimVoi creates bivariate XY Scatter charts for each pair of variables.
- SimVoi estimates value of information for each uncertain input variable of your model.
- SimVoi uses decision-analytic value-of-information to provide sensitivity analysis.
How It Works
- Create a what-if spreadsheet model,
- optionally, use SensIt to identify critical input assumptions,
- enter one of SimVoi’s fourteen random number generator functions in each input cell of your model,
- choose Tools | SimVoi (Mac Excel 2011) or Add-Ins | SimVoi (Excel 2010 & 2013),
- specify the model output cell, number of what-if trials, and other options,
- interpret SimVoi’s histograms, cumulative charts, and bivariate scatter plots, and
- optionally, use SimVoi’s value of information tables and charts for sensitivity analysis.
For a larger version of a tree diagram, click the image.
To return from the larger version, use the browser Back button.