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. A book with 100 different VBA simulations in Excel I. GAMBLING 1: The Die Is Cast 2: Casting Six Dice 3: Roulette Machine 4: AnX-O Game 5: A Slot Machine 6: Gamblers' Ruin 7: Lottery Numbers 8: Winor 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: UnbiasedSampling 23: Transforming a LogNormal Distribution 24: Outlier Detection 25: Bootstrapping 26: Bean Machine Simulation 27: Correlated Distributions 28: Sorted Random Sampling 29: Frequencies III. MONTECARLO 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: Buyor 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 This book covers a variety of Excel simulations, from gambling to genetics. The 100 simulations covered offer an exciting and fun alternative to the usual Excel topics and include situations such as roulette, sex determination, population growth, and traffic patterns, among 95 others. Bill Jelen, MrExcel.com ------------------------------------------------------ Having taught programming and computer science since 1963 and seen a myriad of textbooks, it is a real pleasure to get Dr G. M. Verschuuren's book on Excel Simulations. It is definitely the best "Learn by examples" computerbook I have ever seen. Ole Hebin, Prof. Emeritus, University of Copenhagen and Northwestern ------------------------------------------------------ This book has an impressive breadth of examples from different areas. The writing is very straightforward and explanations seem very understandable for the beginning student. The companion website is an extraordinary resource! Dr. Bud Banis, Professor of Logistics, University of Missouri, St. Louis Dr. Gerard M. Verschuuren is a human geneticist who also earned a doctorate in the philosophy of science. He studied and worked at universities in Europe and the United States and wrote several biology textbooks in Dutch. During this time, he also used and programmed computer software, including Excel, to simulate scientific problems. Currently, he is semi-retired and spends most of his time as a writer, speaker, and consultant on the interface of science and computer programming.