Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 5th Edition

With the latest fifth edition of this popular book you will learn how to supercharge Excel's computational power using VBA to perform advanced numerical calculations to find roots of systems of linear and nonlinear equations, determine eigenvalues and vectors, optimize multimodal objective functions, apply the calculus of derivatives, integrals, and differential equations, conduct uncertainty analysis, and model data by regression and interpolation.
This new edition builds on the success of previous editions with new content and updated features in Excel!
Practical Numerical Methods (PNM) shows engineers and scientists how to use VBA to boost Excel's power for modeling and analysis using the same numerical techniques found in specialized math software.
Visit the companion web site for more details and additional content:
https://z.umn.edu/pnm5
Download the book's Excel and VBA files and learn how to customize your own Excel workbooks: Get the PNMSuite: A refined macro-enabled Excel workbook with a suite of over 225 VBA user-defined functions, macros, and user-forms for learning VBA and implementing advanced numerical methods in Excel. Work through the hundreds of examples, illustrations, and animations from the book available in downloadable Excel files that demonstrate applied numerical methods in Excel and VBA. Customize the example Excel worksheets and VBA code to tackle your own problems. Try the practice problems for a self-guided study to sharpen your Excel and VBA skills.
The first chapter sets up the background for practical problem solving using numerical methods. The next two chapters cover frequently overlooked features of Excel and VBA for implementing numerical methods in Excel and documenting results. The remaining chapters present powerful numerical techniques using Excel and VBA to find roots to single and systems of linear and nonlinear equations, evaluate derivatives, perform optimization, model data by regression and interpolation, assess model fidelity, analyze risk and uncertainty, perform integration, and solve ordinary and partial differential equations.