100 Excel VBA Simulations

100 Excel VBA Simulations: Using Excel VBA to Model Risk, Investments, Genetics. Growth, Gambling, and Monte Carlo Analysis

Covering a variety of Excel simulations by using Visual Basic (VBA), from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook. The simulations covered offer a fun alternative to the usual Excel topics and include situations such as roulette, password cracking, sex determination, population growth, and traffic patterns, among many others.

Table of Contents

Part I. Gambling
Chapter Chapter 1: The Die Is Cast
Chapter Chapter 2: Casting Six Dice
Chapter Chapter 3: Roulette Machine
Chapter Chapter 4: An X-O Game
Chapter Chapter 5: A Slot Machine
Chapter Chapter 6: Gamblers’ Ruin
Chapter Chapter 7: Lottery Numbers
Chapter Chapter 8: Win Or Lose?
Chapter Chapter 9: A Letter Game
Chapter Chapter 10: A Three-Way Circuit
Chapter Chapter 11: Flock Behavior

Part II. Statistics
Chapter Chapter 12: Samples
Chapter Chapter 13: A Normal Distribution
Chapter Chapter 14: Distribution Simulations
Chapter Chapter 15: Discrete Distributions
Chapter Chapter 16: Peaks
Chapter Chapter 17: Confidence Margins
Chapter Chapter 18: Sample Size And Confidence Interval
Chapter Chapter 19: Random Repeats
Chapter Chapter 20: Flipping A Fair Coin?
Chapter Chapter 21: Simulation Of Sick Cases
Chapter Chapter 22: Unbiased Sampling
Chapter Chapter 23: Transforming A Lognormal Distribution
Chapter Chapter 24: Outlier Detection
Chapter Chapter 25: Bootstrapping
Chapter Chapter 26: Bean Machine Simulation
Chapter Chapter 27: Correlated Distributions
Chapter Chapter 28: Sorted Random Sampling
Chapter Chapter 29: Frequencies

Part III. Monte Carlo Simulations
Chapter Chapter 30: The Law Of Large Numbers
Chapter Chapter 31: Brownian Motion
Chapter Chapter 32: Ehrenfest Urn
Chapter Chapter 33: Random Walk
Chapter Chapter 34: A Data Table With Memory
Chapter Chapter 35: Juror Selection In Court
Chapter Chapter 36: Running Project Costs
Chapter Chapter 37: Forecasting Profits
Chapter Chapter 38: Uncertainty In Sales
Chapter Chapter 39: Exchange Rate Fluctuations

Part IV. Genetics
Chapter Chapter 40: Shuffling Chromosomes
Chapter Chapter 41: Sex Determination
Chapter Chapter 42: Mendelian Laws
Chapter Chapter 43: The Hardy-Weinberg Law
Chapter Chapter 44: Genetic Drift
Chapter Chapter 45: Two Selective Forces
Chapter Chapter 46: Differential Fitness
Chapter Chapter 47: Molecular Clock
Chapter Chapter 48: Dna Sequencing

Part V. Science
Chapter Chapter 49: Matrix Elimination
Chapter Chapter 50: Integration With Simulation
Chapter Chapter 51: Two Monte Carlo Integrations
Chapter Chapter 52: Monte Carlo Approach Of Pi
Chapter Chapter 53: A Population Pyramid
Chapter Chapter 54: Predator-Prey Cycle
Chapter Chapter 55: Taking Medication
Chapter Chapter 56: The Course Of An Epidemic
Chapter Chapter 57: Boltzmann Equation For Sigmoidal Curves
Chapter Chapter 58: Interpolation
Chapter Chapter 59: A Rigid Pendulum
Chapter Chapter 60: A Piston Sinusoid
Chapter Chapter 61: The Brusselator Model
Chapter Chapter 62: A Hawk-Dove Game

Part VI. Business
Chapter Chapter 63: Prognosis Of Sales
Chapter Chapter 64: Cycle Percentiles
Chapter Chapter 65: Cost Estimates
Chapter Chapter 66: A Filtering Table
Chapter Chapter 67: Profit Changes
Chapter Chapter 68: Risk Analysis
Chapter Chapter 69: Scenarios
Chapter Chapter 70: Market Growth
Chapter Chapter 71: A Traffic Situation
Chapter Chapter 72: Quality Control
Chapter Chapter 73: Waiting Time Simulation
Chapter Chapter 74: Project Delays

Part VII. Finance
Chapter Chapter 75: Buy Or Sell Stock
Chapter Chapter 76: Moving Averages
Chapter Chapter 77: Automatic Totals And Subtotals
Chapter Chapter 78: Fluctuations Of Apr
Chapter Chapter 79: Net Present Value
Chapter Chapter 80: Loan With Balance And Principal
Chapter Chapter 81: S&P500 Performance
Chapter Chapter 82: Stock Market
Chapter Chapter 83: Stock Volatility
Chapter Chapter 84: Return On Investment
Chapter Chapter 85: Value At Risk
Chapter Chapter 86: Asian Options

Part VIII. Miscellanea
Chapter Chapter 87: Cracking A Password
Chapter Chapter 88: Encrypting Text
Chapter Chapter 89: Encrypting A Spreadsheet
Chapter Chapter 90: Numbering Records
Chapter Chapter 91: Sizing Bins For Frequencies
Chapter Chapter 92: Creating Calendars
Chapter Chapter 93: Populating A Jagged Array
Chapter Chapter 94: Filtering A Database
Chapter Chapter 95: Formatting Phone Numbers
Chapter Chapter 96: Creating Gradients
Chapter Chapter 97: Aligning Multiple Charts
Chapter Chapter 98: Temperature Fluctuations
Chapter Chapter 99: Working With Fiscal Years
Chapter Chapter 100: Time Calculations