Download SimulAr User Manual

SimulAr: Monte Carlo Simulation in Excel
The window "Display input, output and correlated variables" consists of three labels, the
first one to visualize inputs variables, the second one to show output variables and the last one to
show correlated variables. SimulAr picks up from all sheets in the active workbook variables that
have been inserted in your model. This is very important because it enables you to design the
decision model not only by thinking the model in just one sheet of the active workbook but also by
facilitating you to include different variables in different sheets. This advantage grants SimulAr a
bigger flexibility allowing adapting the model to the user's necessities.
The three labels contain six columns. The first one is indicative of the number that SimulAr
assigns to variables. The second one indicates the variable name and it is empty in case a name has
not been assigned. Columns three and four reflect the sheet name and cell reference of the variable
respectively. The next column shows the cell formula. The last one displays the cell value in the
moment you have selected this option.
At the bottom of the window you can see the number of variables inserted for each type and
the number of sheets the active workbook contains. Clicking on the option "Looking for cell when
selecting the variable" allows you to go directly to the sheet and cell where the variable was
inserted. This function is useful when you are working with different sheets or when you can't see
all of the inserted variables in the Excel screen.
51