1st Edition
Numerical Calculations for Process Engineering Using Excel VBA
By Chi M. Phan
Copyright 2024
158 Pages
31 B/W Illustrations
by
CRC Press
158 Pages
31 B/W Illustrations
by
CRC Press
158 Pages
31 B/W Illustrations
by
CRC Press
Also available as eBook on:
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... Read more
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
Biography
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.
