Numerical Calculations for Process Engineering Using Excel VBA

✍ Scribed by Chi M. Phan

• Publisher: CRC Press
• Year: 2023
• Tongue: English
• Leaves: 159
• Edition: 1
• Category: Library

✦ Synopsis

Numerical Calculations for Process Engineering Using Excel VBA provides numerical treatment of process engineering problems with VBA programming and Excel spreadsheets. The problems are solving material and energy balances, optimising reactors and modelling multiple-factor processes. The book includes both basic and advanced codes for numerical calculations. The basic methods are presented in different variations tailored to particular applications. Some macros are combined with each other to solve engineering problems. Examples include combining the bisection method and binary search to optimise an implicit correlation, combining golden section search with Euler’s method to optimise a reactor and combining bisection code and Euler’s method to solve steady-state heat distribution. The text also includes nonconventional examples such as harmony search and network analysis. The examples include solutions to common engineering problems such as adiabatic flame temperature, plug flow reactor conversion, batch reactor, heat diffusion and pinch analysis of heat exchanger networks. The VBA code is presented with mathematical equations and flowcharts, enabling the audience to adopt the solutions to different problems. The book contains many demonstrations of numerical techniques to guide users. It also includes useful summaries of VBA commands/functions and Excel-predefined functions accessible in VBA.

While the book is developed primarily for undergraduate students, the book is a helpful resource for postgraduate students and engineers.

✦ Table of Contents

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