Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 3rd Edition
Author | : | |
Rating | : | 4.87 (645 Votes) |
Asin | : | 1502527405 |
Format Type | : | paperback |
Number of Pages | : | 620 Pages |
Publish Date | : | 2014-06-06 |
Language | : | English |
DESCRIPTION:
This new edition expands Practical Numerical Methods with more VBA to boost Excel's power for numerical modeling and analysis. The next two chapters cover frequently overlooked features of Excel (2010, 2013 and later) and VBA for implementing numerical methods in Excel, as well as documenting results. Customize the example files and macros to tackle your own problems using VBA in Excel. The remaining chapters present powerful numerical techniques using Excel and VBA to find roots to algebraic equations, approximate derivatives, optimize, model data by least-squares regression and interpolation, analyze risk and uncertainty, solve integrals and ordinary and partial differential equations: Numerical Methods & Mathematical Modeling: expert problem solving Excel: Documentation, Graphing, Worksheet Functions, Input Validation and Formatting, What-if AnalysisVBA: Editor and objects, Function and Sub Procedures, Data Types, Structured Programming, Arithmetic and Worksheet Functions, Flow Control, Arrays, Communication, Message and Input Boxes, User Forms, Reading/Writing Files, Debugging, Unit Conversions Linear Equations: Matrix Algebra, Gaussian Elimination and Crout Reduc
Blehart Distinguished Professor of Chemical Engineering at the University of Minnesota Duluth.Professor Davis has over two decades experience teaching a variety of courses including computational methods, unit operations of momentum, heat and mass transfer, chemical reactor design, engineering economics, bioprocessing and green engineering.His current teaching and research interests include process modeling and simulation applied to mineral processing, energy conversion, a
About the AuthorRichard Davis is a Jean G. He is the academic adviser to the local engineering student chapters of Tau Beta Pi, Omega Chi Epsilon, and the Society for Mining, Metallurgy, and Exploration.He is the recipient of the University’s Outstanding Adviser and Exceptional Teaching awards.. Blehart Distinguished Professor of Chemical Engineering at the University of Minnesota Duluth.Professor Davis has over two decades experience teaching a variety of courses including computational methods, unit operations of momentum, heat and mass transfer, chemical reactor design, engineering economics, bioprocessing and green engineering.His current teaching and research interests include process modeling and simulation applied to mineral processing, energy conversion, air pollution control, chemical process safety, and environmental management.Professor Davis serves as the Executive Secretary for the National Chemi
Highly Recommended! A truly excellent textbook, I can't fault it. Easily the best source I have used for learning to use Excel and VBA, particularly for engineering problems. I am a practicing chemical engineer with some prior knowledge of computer programming at a beginner level.