Simulacion4_0_Eng.xls (English version)
Simulacion4_0.xls (Spanish version)
(Important! Download the file into your disk before open it)
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.
• 34 random number functions within the following distributions:
(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:
This sheet presents the results for all of the variables in the n iterations.
This sheet presents the main statistics for all the variables.
Contents main statistics, histogram and frequency chart for the selected variable.
This sheet contents correlation coefficient between one selected variable and the rest, regression line parameters between two selected variables, and “Tornado Graph”.
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.
Simulación 4.0 creates a toolbar to access all the developed features.
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" sub-menu to determine an approximate distribution for a known data series.
This button adds to the active cell a function “Simula_correlation(Name1,Name2,Correlation coef.)” whose results is always the correlation coeficient.
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)
This command starts the simulation process after the number of iterations is selected.
(At least one output and one input must be defined)
This menu can be used to go through all the variables and correlations. It also permits to block the desired inputs.
Re-creates the toolbar to discard any custom change and make it visible.
• Menu and toolbar
Just a click is enough to uninstall this tool. Simulación 4.0 can be installed again by re-opening the original file or through the add-in menu.
Development:José Ricardo Varela. firstname.lastname@example.org