Download SimulAr User Manual

SimulAr: Monte Carlo Simulation in Excel
CONTENTS
Page
Introduction
4
User license agreement
4
System requirements
4
Installation instructions
6
Launching SimulAr
10
SimulAr Toolbar
12
Model building
13
Define input variables
13
Insert input variables directly in Excel
28
Define output variables
34
Define correlations between input variables (correlation matrix)
36
Add additional variables to an existent correlation matrix
41
Validate matrix consistency
45
Display input, output, sensitivity, optimization and correlated variables
49
Locking input variables
52
Running the simulation
54
Simulation time
57
Display simulation results
59
Display output variable histogram
60
Sensitibity analysis
63
Generate a simulation output variable report in Excel
65
Generate report for all simulation output variables in Excel
67
Fit distributions to data
67
Sensitivity Analysis: What if…? Sensitivity Variables
70
Optimization Analysis. Optimization Variables
74
Delete input, output, sensitivity and optimization variables
79
Appendix I: Module Office Web Components v10.0 Install
81
2