Numerical Calculations for Process Engineering Using Excel VBA

ISBN-13: 9781032428284 / Twarda / 2023 / 128 str.

Chi M. Phan

Opis

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.

Spis treści

1. Introduction to Excel and VBA  2. Roots of an Equation  3. Applications of Roots of an Equation  4. One-Dimensional Optimisation  5. Linear Programming  6. Roots of Systems of Linear Equations  7. Application of Systems of Linear Equations  8. Solving Systems of Non-Linear Equations  9. Solving Ordinary Differential Equations  10. Applications of ODEs  11. Integration  12. Network Analysis

O autorze

Chi M. Phan (PhD, BEng) has taught in the Department of Chemical Engineering at Curtin University for over 15 years. He has taught classes in process analysis, process calculations, process modelling and simulations. In addition to Curtin University, he taught at the University of Newcastle (Australia) and the University of Hyogo (Japan). He has developed many numerical models for his research in surface science.