| |
|
|
|
|
|
RiskSim provides random number generator functions as inputs for your model, automates
Monte Carlo simulation, and creates charts.
Your spreadsheet model may include
various uncontrollable uncertainties as input assumptions (e.g., demand for a
new product, uncertain variable cost of production, competitor reaction), and
you can use simulation to determine the uncertainty associated with the model's
output (e.g., annual profit).
RiskSim automates the simulation by trying
thousands of what-ifs consistent with your assessment of the uncertainties.
|
|
|
|
|
 |
|
 |
|
|
|
Only US$59 |
|
Free Trial and
User Guide |
|
|
| Benefits: |
* |
Save time by using RiskSim to automate Monte
Carlo simulation. |
|
* |
Make informed decisions explicitly accounting
for uncertainty. |
|
* |
Use RiskSim's charts to explain your analysis
to colleagues. |
|
* |
Use Excel's formatting commands to customize
RiskSim's charts. |
|
* |
Easily use the single-file RiskSim add-in
with no complicated installation; simply open RiskSim.xla
whenever and wherever you need it.
|
|
(1) |
create a
spreadsheet model |
|
(2) |
optionally use
SensIt to identify critical inputs |
|
(3) |
enter one of
RiskSim's fourteen random number generator functions in each input cell of
your model |
|
(4) |
choose Tools | Risk Simulation
(Excel 2003 & 2011) or Add-Ins | Risk Simulation (Excel 2007, 2010, & 2013) |
|
(5) |
specify the model
output cell and the number of what-if trials (maximum 32,000) |
|
(6) |
interpret RiskSim's
histogram and cumulative distribution charts. |
Click each thumbnail below to see the full-size picture.
| Cumulative Chart |
|
Portion of Simulation Summary |
|
|
|
|
Random number generator functions include the following:
| |
RandBinomial
RandBiVarNormal
RandCumulative
RandDiscrete
RandExponential |
|
|
RandInteger
RandLogNormal
RandNormal
RandPoisson
RandSample |
|
|
RandTriangular
RandTruncBiVarNormal
RandTruncNormal
RandUniform |
To provide feedback or for additional information about TreePlan, SensIt, and
RiskSim,
please send e-mail to
Mike Middleton.
|
