Excel For Scientists And Engineers Numerical Methods

Most scientists and engineers received some training in computer programming in their college days, but they (or their computer) may no longer have the capability to write or run programs in, for example, FORTRAN. This book shows how to implement numerical methods using Microsoft Excel, the most widely used spreadsheet software package.

This is a book about numerical methods. I have emphasized the methods and have kept the mathematical theory behind the methods to a minimum. In many cases, formulas are introduced with little or no description of the underlying theory. (I assume that the reader will be familiar with linear interpolation, simple calculus, regression, etc.) Other topics, such as cubic interpolation, methods for solving differential equations, and so on, are covered in more detail, and a few topics, such as Bairstow’s method for obtaining the roots of a regular polynomial, are discussed in detail.

In this book I have provided a wide range of Excel solutions to problems. In many cases I provide a series of examples that progress from a very simple implementation of the problem (useful for understanding the logic and construction of the spreadsheet or VBA code) to a more sophisticated one that is more general. Some of the VBA macros are simple “starting points” and I encourage the reader to modify them; others are (or at least I intended them to be) “finished products” that I hope users can employ on a regular basis.

Nearly 100% of the material in this book applies equally to the PC or Macintosh versions of Excel. In a few cases I have pointed out the different keystrokes requires for the Macintosh version.

TABLE OF CONTENT:
Chapter 1 Introducing Visual Basic for Applications
Chapter 2 Fundamentals of Programming with VBA
Chapter 3 Worksheet Functions for Working with Matrices
Chapter 4 Number Series
Chapter 5 Interpolation
Chapter 6 Differentiation
Chapter 7 Integration
Chapter 8 Roots of Equations
Chapter 9 Systems of Simultaneous Equations
Chapter 10 Numerical Integration of Ordinary Differential Equations part 2
Chapter 11 Numerical Integration of Ordinary Differential Equations part 2
Chapter 12 Partial Differential Equations
Chapter 13 Linear Regression and Curve Fitting
Chapter 14 Nonlinear Regression Using the Solver
Chapter 15 Random Numbers and the Monte Cario Method

Download here

password:knowfree.net