Assessing Excel VBA Suitability for Monte Carlo Simulation

Assessing Excel VBA Suitability for Monte Carlo Simulation

Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC...

Full description

Bibliographic Details
Main Author:	Alexei Botchkarev
Format:	Article
Language:	English
Published:	Bond University
Series:	Spreadsheets in Education
Online Access:	http://sie.scholasticahq.com/article/4629-assessing-excel-vba-suitability-for-monte-carlo-simulation.pdf

Similar Items

Optimal Production Scheduling using VBA on Microsoft Excel
by: Pornrat Thumrongvut
Published: (2019-02-01)

The Study of Programming Code Protection and Security for Excel VBA Project of Microsoft Excel
by: Hung-Chi Lin, et al.
Published: (2011)

Excel VBA-Based Solution to Pipe Flow Measurement Problem
by: Selami Demir, et al.

Excel VBA Macro for the Robust Design of Static Multiple Responses
by: Chih-Kai Yang, et al.
Published: (2011)

Design an Office Automation System for General Affairs by Excel VBA
by: WEI,CHIH-HENG, et al.
Published: (2017)

Developing the Students’ Ability in Understanding Mathematics and Self-confidence with VBA for Excel
by: Martin Bernard, et al.
Published: (2019-01-01)

Design a Business Valuation Module by Excel VBA-The Case of S Company
by: Yu, Chia-Ling, et al.
Published: (2017)

Profit Forecast Model Using Monte Carlo Simulation in Excel
by: Petru BALOGH, et al.
Published: (2014-01-01)

THE STUDENTS’ MATHEMATICAL ABSTRACTION ABILITY THROUGH REALISTIC MATHEMATICS EDUCATION WITH VBA-MICROSOFT EXCEL
by: Nelly Fitriani, et al.
Published: (2018-09-01)

Penetrômetro de impacto stolf - programa computacional de dados em EXCEL-VBA
by: Rubismar Stolf, et al.
Published: (2014-06-01)

Construction of the Multimedia Teaching Platform of Cost Accounting Course Based on EXCEL VBA Program
by: Zhiyong Zhang
Published: (2018-04-01)

EXCEL VBA - Based Management System for New Construction Projects and Facility Maintenance Projects
by: Liu, Ming-Sung, et al.
Published: (2018)

The Application of 3D software and Excel VBA in Seismic Reinforced Concrete Frame details
by: DAI ZHANG-LONG, et al.
Published: (2015)

Analyzing and displaying data from a PV system : Excel VBA programming and MATLAB data analysis
by: Krebs, Alexandre, et al.
Published: (2020)

An Excel Spreadsheet and VBA Macro for Model Selection and Predictor Importance Using All-Possible-Subsets Regression
by: Michael Brusco

Multivariate Monte-Carlo Simulation and Economic Valuation of Complex Financial Contracts: An Excel Based Implementation.
by: Timothy J Kyng, et al.

Multivariate Monte-Carlo Simulation and Economic Valuation of Complex Financial Contracts: An Excel Based Implementation.
by: Timothy J Kyng, et al.
Published: (2014-03-01)

Monte Carlo Simulations
by: Soisson F.
Published: (2011-05-01)

Monte Carlo Path Simulation and the Multilevel Monte Carlo Method
by: Janzon, Krister
Published: (2018)

Simulates research the different investment attribute investor most suitable investment portfolio by Monte Carlo
by: Chien Hua Chen, et al.
Published: (2008)

Solution to Secondary Sedimentation Problem by Spreadsheet and VBA
by: Selami Demir

Decision Assistance in Risk Assessment – Monte Carlo Simulations
by: Emil BURTESCU
Published: (2012-01-01)

Optimization of Monte Carlo simulations
by: Bryskhe, Henrik
Published: (2009)

The Phonon Monte Carlo Simulation
Published: (2015)

Monte Carlo Simulation and Integration
by: Lin, Xichen
Published: (2018)

Monte Carlo Simulation of Sputtering
by: Tseng-Lung Huang, et al.
Published: (1993)

The Study of Using Excel VBA to Construct Short-term Production Schedule in the Final Testing of DRAM FactoryScheduling in the Final Testing of DRAM Factory
by: ChueiHsin Peng, et al.
Published: (2005)

An Overview of the Conceptual Simulation Modelling for Optimizing Funds Allocation in Health Care: Hip and Knee Replacement Case
by: Alexei Botchkarev
Published: (2021-06-01)

Landslide risk assessment analysis using Monte Carlo simulation
by: Ikhwan Zulkefly, Mohd. Kamal
Published: (2012)

Monte Carlo vs. Fuzzy Monte Carlo Simulation for Uncertainty and Global Sensitivity Analysis
by: Young-Jin Kim
Published: (2017-03-01)

Monte Carlo Simulations for Chemical Systems
by: Rönnby, Karl
Published: (2016)

OPTIMISATION OF MONTE CARLO BURNUP SIMULATIONS
by: Dufek Jan, et al.
Published: (2021-01-01)

Spintronics Simulation with Monte Carlo Method
by: İbrahim SAVRAN
Published: (2011-08-01)

Monte Carlo simulation for soot dynamics
by: Zhou Kun
Published: (2012-01-01)

Monte Carlo simulations in radiotherapy dosimetry
by: Pedro Andreo
Published: (2018-06-01)

Monte Carlo Simulation of an American Option
by: Gikiri Thuo
Published: (2007-04-01)

Monte Carlo simulation of Touschek effect
by: Aimin Xiao, et al.
Published: (2010-07-01)

Bootstrap, an alternative to Monte Carlo simulation
by: Yang, Z.R, et al.
Published: (1998)

Monte Carlo simulation of grain growth
by: Paulo Blikstein, et al.
Published: (1999-07-01)

Monte Carlo simulation in risk estimation.
Published: (2013)