## Find a copy in the library

Finding libraries that hold this item...

## Details

Genre/Form: | Textbooks |
---|---|

Document Type: | Book |

All Authors / Contributors: |
Victor J Law |

ISBN: | 9781466575349 1466575344 |

OCLC Number: | 802325739 |

Description: | xviii, 229 pages : illustrations ; 24 cm |

Contents: | Roots of a Single Nonlinear Equation Introduction Algorithms for Solving f(x) = 0 Using Excel to Solve Nonlinear Equations (Goal Seek) A Note on In-Cell Iteration References Visual Basic(R) for Applications Programming Introduction Algorithm Design VBA Coding Example VBA Project Getting Help and Documentation on VBA VBA Statements and Features Objects and OOP Built-In Functions of VBA Program Control VBA Data Types Subs and Functions Input and Output Array Data Structures Alternative I/O Methods Using Debugger References Linear Algebra and Systems of Linear Equations Introduction Notation Vectors Vector Operations Matrices Matrix Operations Solving Systems of Linear Algebraic Equations Linear Equations and Vector/Matrix Operations in Excel(R) More About Matrix.xla SVD and Pseudo-Inverse of a Matrix Numerical Differentiation and Integration Numerical Differentiation Numerical Integration Curve Fitting for Integration Ordinary Differential Equations (Initial Value Problems) Introduction Euler-Type Methods RK Methods Stiff ODEs Solving Systems of ODE-IVPs Higher-Order ODEs Ordinary Differential Equations (Boundary Value Problems) Introduction Shooting Method Split BVPs Using Finite Differences More Complex Boundary Conditions with ODE-BVPs Reference Regression Analysis and Parameter Estimation General Method of Least Squares Linear Regression Analysis How Good Is the Fit from a Statistical Perspective? Regression Using Excel's Regression Add-In Numerical Differentiation and Integration Revisited Partial Differential Equations Introduction Parabolic PDEs Thomas Algorithm for Tridiagonal Systems Method of Lines Successive Overrelaxation for Elliptic PDEs Linear Programming, Nonlinear Programming, Nonlinear Equations, and Nonlinear Regression Using Solver Introduction Linear Programming Nonlinear Programming Nonlinear Equations Nonlinear Regression Analysis Introduction to MATLAB(R) Introduction MATLAB(R) Basics MATLAB(R) Programming Language Statements MATLAB(R) Function Arguments Plotting in MATLAB(R) Example MATLAB(R) Programs Closing Comment Regarding MATLAB(R) Appendix A: Additional Features of VBA Index |

Responsibility: | Victor J. Law. |

More information: |

### Abstract:

"Preface This book has been written using notes developed for the course Numerical Methods for Chemical Engineers at Tulane University. The author has written two previous textbooks; one on FORTRAN programming and one using the language Pascal. On a personal note, when I completed the Pascal book I asked my wife to break my fingers if I ever decided to write another book! Well, that was a long time ago and having been granted a sabbatical leave to write this book, my wife decided that she would look the other way. While there are many textbooks whose title would indicate that they are suitable for the course Numerical Methods for Chemical Engineers, every one that has been tried has been a failure in one way or another. Either they were too elementary and the applications and problems were not ideal or they did not offer instruction in Excel and Visual Basic for Applications (VBA). This led to the development, over a 5 year period, of detailed notes to be used in place of a textbook. These notes have been enhanced and put into textbook form to produce the present book. The primary reason for using Excel is that it is generally available software and it comes with every computer system (both PC and Mac) with Microsoft Office installed. VBA is a programming environment that comes with Excel and greatly enhances the capabilities of basic Excel spreadsheets. It is available on systems running Microsoft operating systems and Mac OS. Beware, however, that VBA is available only on the latest (2011) version of Microsoft Office for the Mac. Other programming software systems that are often used in chemical and biomolecular engineering numerical methods courses are the following:"--

## Reviews

*User-contributed reviews*

Add a review and share your thoughts with other readers.
Be the first.

Add a review and share your thoughts with other readers.
Be the first.

## Tags

## Similar Items

### Related Subjects:(8)

- Chemical engineering -- Mathematics -- Textbooks.
- Microsoft Excel (Computer file)
- Microsoft Visual Basic for applications.
- MATLAB.
- MATHEMATICS -- Applied.
- MEDICAL -- Biotechnology.
- SCIENCE -- Chemistry -- Industrial & Technical.
- Chemical engineering -- Mathematics.

### User lists with this item (1)

- YICLib-Leadership-2014(12 items)
by ghouse updated 2013-10-28