[Free ebook]100 Excel VBA Simulations: Using Excel VBA to Model Risk, Investments, Genetics. Growth, Gambling, and Monte Carlo Analysis-Dr. Gerard M. Verschuure - EBOOK VBA EXCEL

EVBA.info ( Ebook VBA Excel ) Welcome EVBA.info - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Free Courses, Living Skills ...

# [Free ebook]100 Excel VBA Simulations: Using Excel VBA to Model Risk, Investments, Genetics. Growth, Gambling, and Monte Carlo Analysis-Dr. Gerard M. Verschuure

### Product description

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.

### From the Inside Flap

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
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
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
88: Encrypting Text
90: Numbering Records
91: Sizing Bins for Frequencies
92: Creating Calendars
93: Populating a Jagged Array
94: Filtering a Database
95: Formatting Phone Numbers
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

### From the Back Cover

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