Examples
Download all examples in Zip:
Examples.zipSimulación 5.0 with OptiSim - Optimization with monte carlo simulation
Example007.xlsx"Optimize portfolio"
Features demonstrated:
Simula_Normal, Optisim_Decision_Allocation, Simula_Correlation, Simula_Output, Simula_Stat_Template, Simula_Stat_Histogram
Example008.xlsx"Optimum order quantity"
Features demonstrated:
Simula_Normal, Optisim_Decision, Simula_Output, Simula_Stat_Template, Simula_Stat_Histogram, Simula_Stat_Mean
Example009.xlsx"Optimum order quantity with requirements"
Features demonstrated:
Simula_Normal, Optisim_Decision, Optisim_Requirement, Simula_Output, Simula_Stat_Template, Simula_Stat_Histogram, Simula_Stat_Mean
Example010.xlsx"Product mix - Requirement A"
Features demonstrated:
Simula_Normal, Simula_Triangular, Optisim_Decision, Optisim_Requirement, Simula_Output, Simula_Stat_Mean
Example011.xlsx"Product mix - Requirement B"
Features demonstrated:
Simula_Triangular, Optisim_Decision, Optisim_Requirement, Simula_Output, Simula_Stat_Mean
Example012.xlsx"Media Selection Model"
Features demonstrated:
Simula_Binomial, Simula_User_Defined_Discrete, Simula_IF, Optisim_Decision, Optisim_Requirement, Simula_Output, Simula_Stat_Mean, Optisim Minimize Final Value
Example013.xlsx"Jobs scheduling with best order"
Features demonstrated:
Simula_Triangular, Optisim_Decision_Order, Simula_Output, Optisim Maximum of Mean
Example014.xlsx"Credit Risk Model without Volatility Constraint A"
Features demonstrated:
Simula_Uniform, Simula_Triangular, Optisim_Decision, Optisim_Constraint, Simula_Output
Example015.xlsx"Credit Risk Model with Volatility Constraint B"
Features demonstrated:
Simula_Uniform, Simula_Triangular, Optisim_Decision, Optisim_Requirement, Simula_Output, Simula_Stat_SD
Example016.xlsx"Capital Budgeting with Financial Statements"
Features demonstrated:
Simula_Normal, Simula_LogNormal_Alternative, Simula_Triangular, Simula_User_Defined_Discrete, Simula_Bernoulli, Simula_Stat_Mean, Simula_Stat_Percentile, Simula_Correlation, Simula_Output
Simulación 5.0 - Monte carlo simulation
Example_006.xlsx"Inv. Portfolio Risk"
Features demonstrated:
Simula_Normal, Simula_Correlation, Simula_Output, Simula_Stats functions, Model settings override, Cell formating for variables, and output Report Template
Example_005.xlsx"Flight Payload"
Features demonstrated:
Simula_Correlation, Simula_User_Defined_Discrete_Alternative, Simula_Output, Simula_Stats functions, Cell Formating for variables, and output Report Template
Example_004.xlsx"Revenue of a store"
Features demonstrated:
Simula_User_Defined, Simula_User_Defined_Discrete, Simula_Output, Simula_Stats functions, Cell Formating for variables, and output Report Template
Example_003.xlsx"Covid pool testing"
Features demonstrated:
Simula_Bernoulli, Simula_Compound_Alternative, Simula_Output, Simula_Stats functions, Cell Formating for variables, and output Report Template
Example_002.xlsx"Exchange Rate"
Features demonstrated:
Simula_Triangular_Double, Simula_LogLaplace, Simula_User_Defined_Alternative, Distribution Fitting, Model Settings override, and output Report Template
Example_001.xlsx"Using Monte Carlo"
Features demonstrated:
Simula_Compound_Alternative, Simula_User_Defined_Discrete functions, Model Settings override and output Report Template
Feel free to send us your own model if you find Simulacion 5.0 useful and you want to share models created with it.