100 Excel VBA Simulations

by Dr. Gerard M. Verschuuren


Order the book from Amazon here: www.Amazon.com
Order the book from Barnes & Noble here: www.bn.com


A book with 100 different VBA simulations in Excel

I.	GAMBLING
	1: The Die Is Cast
	2: Casting Six Dice
	3: Roulette Machine
	4: An X-O Game
	5: A Slot Machine
	6: Gamblers’ Ruin
	7: Lottery Numbers
	8: Win or Lose?
	9: A Letter Game
	10: A Three-Way Circuit
	11: Flocking Behavior
II.	STATISTICS
	12: Samples
	13: A Normal Distribution
	14: Distribution Simulations
	15: Discrete Distributions
	16: Peaks
	17: Confidence Margins
	18: Sample Size and Confidence Interval
	19: Random Repeats
	20: Flipping a Fair Coin?
	21: Simulation of Sick Cases
	22: Unbiased Sampling
	23: Transforming a LogNormal Distribution
	24: Outlier Detection
	25: Bootstrapping
	26: Bean Machine Simulation
	27: Correlated Distributions
	28: Sorted Random Sampling
	29: Frequencies
III.	MONTE CARLO SIMULATIONS
	30: The Law of Large Numbers
	31: Brownian Motion
	32: Ehrenfest Urn
	33: Random Walk
	34: A Data Table with Memory
	35: Juror Selection in Court
	36: Running Project Costs
	37: Forecasting Profits
	38: Uncertainty in Sales
	39: Exchange Rate Fluctuations
IV.	GENETICS
	40: Shuffling Chromosomes
	41: Sex Determination
	42: Mendelian Laws
	43: The Hardy-Weinberg Law
	44: Genetic Drift
	45: Two Selective Forces
	46: Differential Fitness
	47: Molecular Clock
	48: DNA Sequencing
V.	SCIENCE
	49: Matrix Elimination
	50: Integration with Simulation
	51: Two Monte Carlo Integrations
	52: Monte Carlo Approach of Pi
	53: A Population Pyramid
	54: Predator-Prey Cycle
	55: Taking Medication

	56: The Course of an Epidemic
	57: Boltzmann Equation for Sigmoidal Curves
	58: Interpolation
	59: A Rigid Pendulum
	60: A Piston Sinusoid
	61: The Brusselator Model
	62: A Hawk-Dove Game
VI.	BUSINESS
	63: Prognosis of Sales
	64: Cycle Percentiles
	65: Cost Estimates
	66: A Filtering Table
	67: Profit Changes
	68: Risk Analysis
	69: Scenarios
	70: Market Growth
	71: A Traffic Situation
	72: Quality Control
	73: Waiting Time Simulation
	74: Project Delays
VII.	FINANCE
	75: Buy or Sell Stock?
	76: Moving Averages
	77: Automatic Totals and Subtotals
	78: Fluctuations of APR
	79: Net Present Value
	80: A Loan with Balance and Principal
	81: S&P500 Performance
	82: Stock Market
	83: Stock Volatility
	84: Return on Investment
	85: Value at Risk
	86: Asian Options
VIII.	MISCELLANEA
	87: Cracking a Password
	88: Encrypting Text
	89: Encrypting a Spreadsheet
	90: Numbering Records
	91: Sizing Bins for Frequencies
	92: Creating Calendars
	93: Populating a Jagged Array
	94: Filtering a Database
	95: Formatting Phone Numbers
	96: Creating Gradients
	97: Aligning Multiple Charts
	98: Temperature Fluctuations
	99: Working with Fiscal Years
	100: Time Calculations
IX.	APPENDIX
	Data Tables
	Simulation Controls
	If Statements
	Value Type Variables
	Ranges vs. Cells
	FormulaR1C1
	Arrays
	Error Handling
X.	INDEX