[Free ebook]100 Excel VBA Simulations: Using Excel VBA to Model Risk, Investments, Genetics. Growth, Gambling, and Monte Carlo Analysis-Dr. Gerard M. Verschuure
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.
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
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
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
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
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.
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.
Features & details
Product information
Publisher CreateSpace Independent Publishing Platform
Publication date November 18, 2016
Language English
Product Dimensions 8.5 x 0.5 x 11 inches
Shipping Weight 1.15 pounds
Book length 230
ISBN-10 1540445178
ISBN-13 978-1540445179
Best Sellers Rank 571082
#evba #etipfree #kingexcel
#eama #evba #etipfree
Publisher | CreateSpace Independent Publishing Platform |
---|---|
Publication date | November 18, 2016 |
Language | English |
Product Dimensions | 8.5 x 0.5 x 11 inches |
Shipping Weight | 1.15 pounds |
Book length | 230 |
ISBN-10 | 1540445178 |
ISBN-13 | 978-1540445179 |
Best Sellers Rank | 571082 |
No comments:
Post a Comment