Simulación 4.0 

Home page  
Spanish version 
Download Simulacion4_0_Eng.xls (English version) 

Simulacion4_0.xls (Spanish version) 

(Important! Download the file into your disk before open it)


Details 

Simulación 4.0 was fully developed in VBA (Visual Basic for Applications) and it is compatible with Excel 97 and above. It has been created in order to bring a flexible simulation tool, easy to be used.
Features:
• 34 random number functions within the following distributions:
Continuous
Discrete
(As long as the simulation is not running, these functions return the expected value)
• Simulation with the Monte Carlo method, between 1  65,000 iterations.
• Integrated Menu and Toolbar.
• Up to 150 Inputs and 20 Outputs.
• Easy Block of inputs in order to run partial simulations.
• Definition of correlations between inputs.
• Determination of one approximate distribution for a known data series.
• Quick and easy install and uninstall.
• Simulation results presented in a new Excel Workbook with the following sheets:
Data This sheet presents the results for all of the variables in the n iterations.
Summary This sheet presents the main statistics for all the variables.
Statistics Contents main statistics, histogram and frequency chart for the selected variable.
Sensitivity This sheet contents correlation coefficient between one selected variable and the rest, regression line parameters between two selected variables, and “Tornado Graph”.
Installation:
The first time Simulación 4.0 is opened (enabling macros), with a simple click in the install command, the tool is ready to be used in any existent workbook or in a new one, without opening the file again.
Use:
• Toolbar
Simulación 4.0 creates a toolbar to access all the developed features.
Insert input It replaces the content of the cell with the desired random number generator function.
Note: The variable name must be quoted “”
Includes the "find distribution" submenu to determine an approximate distribution for a known data series.
Insert correlation This button adds to the active cell a function “Simula_correlation(Name1,Name2,Correlation coef.)” whose results is always the correlation coeficient.
Insert output This button adds to the active cell a function “Simula_output(Name)” whose results is always 0 (therefore it doesn’t affect the formula result)
Run Simulation This command starts the simulation process after the number of iterations is selected.
(At least one output and one input must be defined)
List variables This menu can be used to go through all the variables and correlations. It also permits to block the desired inputs.
• Menu
Activate toolbar Recreates the toolbar to discard any custom change and make it visible.
• Menu and toolbar
Uninstall Just a click is enough to uninstall this tool. Simulación 4.0 can be installed again by reopening the original file or through the addin menu.
Help This document….
About… Development:José Ricardo Varela. jvarela@cema.edu.ar 

