Book Description
Numerical Methods with VBA Programming provides a unique and unified treatment of numerical methods and VBA computer programming, topics that naturally support one another within the study of engineering and science. This engaging text incorporates realworld scenarios to motivate technical material, helping students understand and retain difficult and key concepts. Such examples include comparing a twopoint boundary value problem to determining when you should leave for the airport to catch a scheduled flight. Numerical examples are accompanied by closedform solutions to demonstrate their correctness. Within the programming sections, tips are included that go beyond language basics to make programming more accessible for students. A unique section suggest ways in which the starting values for nonlinear equations may be estimated. Flow charts for many of the numerical techniques discussed provide general guidance to students without revealing all of the details. Useful appendices provide summaries of Excel and VBA commands, Excel functions accessible in VBA, basics of differentiation, and more!Table of Contents
 Cover Page
 Title Page
 Copyright Page
 Dedication Page
 Contents
 Preface
 Chapter 1  Introduction

Chapter 2  Programming Basics: Arithmetic, Input/Output, and All That
 2.1 General Remarks
 2.2 Parts of a Computer Program
 2.3 Opening VBA
 2.4 VBA Statements
 2.5 Input/Output
 2.6 A Simple Program
 2.7 Documentation
 2.8 Running VBA
 2.9 Flowcharts
 2.10 Variable Types
 2.11 Example: The Real Roots of a Quadratic Equation
 2.12 UserDefined Types—Complex Variable Type
 2.13 Debugging
 2.14 File Saving and Security Level
 2.15 A Word of Encouragement
 2.16 Chapter 2 Exercises
 Chapter 3  Errors, Series, and Uncertainty
 Chapter 4  Decisions and Loops: Which Is Bigger? How Many Times?
 Chapter 5  Numerical Integration
 Chapter 6  Subprograms and Functions: Useful Specialists

Chapter 7  Roots of Nonlinear Equations: Finding Zero
 7.1 What Is a Root?
 7.2 The NewtonRaphson Method
 7.3 The Secant Rule
 7.4 Estimating Starting Values
 7.5 TwoEquation NewtonRaphson Method
 7.6 General Nonlinear Equation Sets
 7.7 Multiple Equations with the Secant Rule
 7.8 Flowchart: Two Equations with the Secant Rule
 7.9 The Excel Solver
 7.10 Chapter 7 Exercises

Chapter 8  Ordinary Differential Equations: Take One Step Forward
 8.1 The Basic Idea
 8.2 Example: Vehicle Velocity
 8.3 Application of the Euler Method
 8.4 Other Euler Methods
 8.5 SecondOrder Equations
 8.6 The FourthOrder RungeKutta Method
 8.6.1 The Example Again
 8.7 Another Example with Coupled Equations
 8.8 TwoPoint Boundary Value Problems
 8.9 A PredictorCorrector Method
 8.10 The CashKarp RungeKutta Method
 8.10.1 VBA Program Results
 8.11 Stability
 8.12 Stiff Differential Equations
 8.13 Ordinary Differential Equation Methods and Numerical Integration
 8.14 Program Step Control—Trapping
 8.15 Chapter 8 Exercises

Chapter 9  Sets of Linear Equations
 9.1 Lots of Linear Equations
 9.2 Gaussian Elimination with Partial Pivoting
 9.3 GaussianSeidel Iteration
 9.4 Comparison of Gaussian Elimination and GaussianSeidel
 9.5 Matrix Inverses
 9.6 GaussianJordan Method
 9.7 Overdetermined Sets of Linear Equations
 9.8 Excel Inverses and Linear Equation Solutions
 9.9 Chapter 9 Exercises

Chapter 10  Arrays: Variables with a Family Name
 10.1 OneDimensional Arrays
 10.2 Example: Grade Averaging
 10.3 Dynamic Dimensioning
 10.4 Example: Sorting an Array
 10.5 Multidimensional Arrays
 10.6 Gaussian Elimination Flowchart
 10.7 GaussianSeidel Flowchart
 10.8 GaussianJordan Flowchart
 10.9 Romberg Integration Flowchart
 10.10 Thomas Algorithm Flowchart
 10.11 Chapter 10 Exercises
 Chapter 11  Curve Fitting
 Chapter 12  Elliptic Partial Differential Equations
 Appendix A Excel Basics
 Appendix B Computer Representation of Numbers
 Appendix C VBA Command Summary
 Appendix D Glossary
 Appendix E Numerical Methods with the Casio fx115MS Calculator
 Appendix F Excel Functions in VBA
 Appendix G Differentiation Fundamentals
 Appendix H CashKarp RungeKutta VBA Program for Two Ordinary Differential Equations
 Bibliography
 Index
Product Information
 Title: Numerical Methods with VBA Programming
 Author(s):
 Release date: October 2010
 Publisher(s): Jones & Bartlett Learning
 ISBN: 9781449613013