Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB

Contents

Preface

Author

Notes to the Instructor

Chapter 1 Roots of a Single Nonlinear Equation

1.1 Introduction

1.2 Algorithms for Solving f(x) = 0

1.2.1 Plotting the Equation

1.2.2 Fixed-Point Iteration (Direct Substitution)

1.2.3 Bisection

1.2.4 Newton’s Method

1.2.5 Secant Method

1.3 Using Excel^® to Solve Nonlinear Equations (Goal Seek)

1.4 A Note on In-Cell Iteration

Exercises

References

Chapter 2 Visual Basic^® for Applications Programming

2.1 Introduction

2.2 Algorithm Design

2.3 VBA Coding

2.4 Example VBA Project

2.5 Getting Help and Documentation on VBA

2.6 VBA Statements and Features

2.6.1 Assignment Statement

2.6.2 Expressions

2.6.2.1 ...