Numerical Calculations for Process Engineering Using Excel VBA

Short Blurb
This book provides numerical treatment of process engineering problems with VBA programming and Excel spreadsheets including both basic and advanced codes for numerical calculations. The VBA codes are presented with mathematical equations and flowcharts including self-practising exercises.
Seasonal Blurb
This book provides numerical treatment of process engineering problems with VBA programming and Excel spreadsheets including both basic and advanced codes for numerical calculations. Examples include bisection method and binary search to optimise an implicit correlation, combining golden section search with Euler's method to optimise a reactor's residence time, and combining bisection code and Euler's method to solve steady-state heat distribution. The VBA codes are presented with mathematical equations and flowcharts including self-practising exercises. This book is aimed at professionals and senior undergraduate students in chemical engineering.
Standard Blurb
This book provides numerical treatment of process engineering problems with VBA programming and Excel spreadsheets including both basic and advanced codes for numerical calculations. Examples include bisection method and binary search to optimise an implicit correlation, combining golden section search with Euler's method to optimise a reactor's residence time, and combining bisection code and Euler's method to solve steady-state heat distribution. The VBA codes are presented with mathematical equations and flowcharts including self-practising exercises.
Focusses on step-by-step demonstration/explanation for many engineering problems using Excel VBA
Outlines a connection between the physical process and numerical calculations
Illustrates advanced combinations of VBA macros to solve problems
Includes examples in solving/optimizing problems related to the energy, food, and water transition
Provides solution to well-known engineering problems, which normally require complicated software
This book is aimed at professionals and senior undergraduate students in chemical engineering.