Numerical Calculations for Process Engineering Using Excel VBA

Cover
Half Title
Title
Copyright
Contents
Preface
About the Author
Chapter 1 Introduction to Excel and VBA
	1.1 Microsoft Excel
		1.1.1 Visual Basic for Applications
		1.1.2 Objects in Excel
		1.1.3 Sub and Function Procedures in VBA
	1.2 Key Characteristics of VBA Programming
		1.2.1 Variables in VBA
		1.2.2 Static and Dynamic Arrays
		1.2.3 Returning Multiple Values in a Spreadsheet
		1.2.4 For . . . Next Loop Structure
		1.2.5 Do . . . Loop Structures
		1.2.6 Options in VBA Code
		1.2.7 Get, Set or Change Spreadsheet Cell Value
		1.2.8 Spreadsheet Functions
	1.3 Avoiding Errors in VBA Procedures
		1.3.1 Errors
		1.3.2 Endless Loop
		1.3.3 Displacing Immediate Value
		1.3.4 Breakpoints
	1.4 Useful Excel Tools for Engineering
Chapter 2 Roots of an Equation
	2.1 Introduction
	2.2 Bisection Method
		2.2.1 Bisection Method with Control Error in Variable
		2.2.2 Bisection Method with Scanning
		2.2.3 Failures of the Bisection Method
	2.3 Newton’s and Secant Methods
	2.4 The Regula Falsi Method
	2.5 Concluding Remarks
	2.6 Further Examples for Self-Practice
Chapter 3 Applications of Roots of an Equation
	3.1 Introduction
	3.2 Advanced Example: Adiabatic Flame Temperature
	3.3 Advanced Example: Tear Analysis for Material Balances with a Recycle Stream
	3.4 Advanced Example: Determining the Vapour Fraction from Internal Energy and Specific Volume
	3.5 Further Examples for Self-Practice
Chapter 4 One-Dimensional Optimisation
	4.1 Introduction
	4.2 Region Elimination
	4.3 Quadratic Interpolation
	4.4 Optimisation with Scanning
	4.5 Advanced Example: A Combination of Binary Search and Bisection Method
	4.6 Further Examples for Self-Practice
Chapter 5 Linear Programming
	5.1 Introduction
	5.2 Simplex Algorithm
	5.3 Advanced Example: Pinch Analysis of Heat Exchanger Network
	5.4 Further Examples for Self-Practice
Chapter 6 Roots of Systems of Linear Equations
	6.1 Introduction
	6.2 Successive Substitution Methods
	6.3 Successive Substitution Methods with a Relaxation Constant
	6.4 Concluding Remarks
	6.5 Further Examples for Self-Practice
Chapter 7 Applications of Systems of Linear Equations
	7.1 Introduction
	7.2 Input Validation
	7.3 Advanced Example: A Combination of Bisection and Jacobi Methods
	7.4 Advanced Example: 2-Dimensional Steady-State Heat Transfer
	7.5 Advanced Example: Unsteady-State Heat Transfer after Microwave Heating
Chapter 8 Solving Systems of Non-Linear Equations
	8.1 Introduction
	8.2 Newton’s and Secant Methods
	8.3 Advanced Example: Tear Analysis with Two Independent Unknowns
	8.4 Advanced Example: Tear Analysis with Stochastic Optimisation
	8.5 Further Examples for Self-Practice
Chapter 9 Solving Ordinary Differential Equations
	9.1 Introduction
	9.2 One-Step Methods with a Constant Step Size
		9.2.1 Second-Order Methods
		9.2.2 Fourth-Order Methods
	9.3 One-Step Methods with an Adaptive Step Size
	9.4 Justification of the Selected Step Size
	9.5 Concluding Remarks
Chapter 10 Applications of ODEs
	10.1 Introduction
	10.2 Advanced Example: Optimisation of a Semi-Batch Reactor
	10.3 Advanced Example: Boundary Value ODEs
	10.4 Further Examples for Self-Practice
Chapter 11 Integration
	11.1 Introduction
	11.2 Area under a Curve from Discrete Data Points
	11.3 Advanced Example: Plug Flow Reactor Performance
Chapter 12 Network Analysis
	12.1 Introduction
	12.2 Converting a Network to Table Form
	12.3 Advanced Example: Shortest Pathway Problem
	12.4 Advanced Example: Travelling-Salesman Problem
	12.5 Example for Self-Practice
Appendices
	List of Useful VBA Functions Which Returns a Numerical Value
	Other Useful VBA Functions
	List of Useful Worksheet Functions (Using the WorkSheetFunction Object in VBA)
References
Index