Friday, February 14, 2020

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

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

February 14, 2020 VBA ebooks,

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

DOWNLOAD

Description

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
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

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

About the Author

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.