Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB PDF Download
Are you looking for read ebook online? Search for your book and save it on your Kindle device, PC, phones or tablets. Download Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB PDF full book. Access full book title Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB by Victor J. Law. Download full books in PDF and EPUB format.
Author: Victor J. Law
Publisher: CRC Press
ISBN: 1482201593
Category : Mathematics
Languages : en
Pages : 249
Get Book Here
Book Description
While teaching the Numerical Methods for Engineers course over the last 15 years, the author found a need for a new textbook, one that was less elementary, provided applications and problems better suited for chemical engineers, and contained instruction in Visual Basic for Applications (VBA). This led to six years of developing teaching notes that
Author: Victor J. Law
Publisher: CRC Press
ISBN: 1482201593
Category : Mathematics
Languages : en
Pages : 249
Get Book Here
Book Description
While teaching the Numerical Methods for Engineers course over the last 15 years, the author found a need for a new textbook, one that was less elementary, provided applications and problems better suited for chemical engineers, and contained instruction in Visual Basic for Applications (VBA). This led to six years of developing teaching notes that
Author: Richard A. Davis
Publisher: CreateSpace
ISBN: 9781495409653
Category : Technology & Engineering
Languages : en
Pages : 600
Get Book Here
Book Description
This latest 3rd edition expands the breadth of Practical Numerical Methods with over 100 VBA macros for extending Excel's power for engineering and scientific analysis. Engineers and scientists will find the enhanced coverage of computational tools applicable to a variety of problems in their own disciplines. ** The selection of software reflects Excel's status as the de facto computational tool used by practicing engineers. Engineers & scientists should become proficient at extending Excel's capabilities with VBA programming to boost their worksheets with time saving enhancements and powerful numerical techniques. ** Topics include an introduction to modeling, documentation, Excel & VBA, root-finding for linear & nonlinear systems of equations, multivariate optimization, experimental uncertainty propagation & analysis, least-squares regression & model validation, interpolation, integration, and ordinary & partial differential equations. ** A companion web site has links to digital files for downloading up to 200 illustrations & examples & the refined PNM3Suite workbook with VBA user-defined functions, macros, & user forms for advanced numerical techniques. Practice problems are also available from the web site (https: //www.d.umn.edu/ rdavis/PNM/PNMExcelVBA3/). Example files & macros are ready to be modified by users for their own needs. ** Chapter 1 includes a brief introduction to chemical reaction engineering that provides some background needed for problems involving mass & energy balances with reactions. ** The next two chapters introduce frequently overlooked features of Excel and VBA for engineering programming to apply numerical methods in Excel, as well as document results. The remaining chapters present powerful numerical techniques using Excel & VBA, including: ** General Methods: Sub & User-defined Function Procedures, Pseudo-random Number Generation, Sorting, Formula Graphing & Evaluation, Random Sampling, User forms ** Linear Equations: Gaussian Elimination with Maximum Column Pivoting, Error Correction, Crout Reduction, Thomas algorithm for tri-diagonal & Cholesky's method for symmetric matrices, Matrix functions, Jacobi & Gauss-Seidel Iteration, Wegstein & Steffenson's version of Aitkin's Delta Square methods, Power method for Eigenproblems ** Nonlinear Equations: Ordinary Fixed-Point Iteration, Bisection, Secant, Regula Falsi, Newton & Quasi-Newton, Continuation (homotopy), Goal Seek, Solver, Bairstow's method for polynomial roots ** Derivative Approximation: Finite Difference, Richardson's extrapolation, Jacobian, Sensitivity Analysis, Lagrange polynomials, splines ** Uncertainty Analysis: Jitter method for the Law of Propagation of Uncertainty, Monte Carlo with Latin-Hypercube sampling, Jack knife for regression parameter uncertainty ** Optimization: Graphical, Quadratic with acceleration, Powell, Golden Section, Luus-Jaakola, Solver (for linear and nonlinear programming), Parameter Scaling ** Least-squares Regression: multivariate linear models, Gauss-Newton, Levenberg-Marquardt, and Monte Carlo for nonlinear regression with parameter uncertainty, Rational Least Squares, Weighting ** Interpolation: Linear, Newton Divided Difference, Lagrange, Rational, Stineman, Cubic Spline, Constrained Splines, Bivariate 2-D, Data Smoothing ** Integration: Trapezoid, Improper, Midpoint, Romberg, Adaptive Gauss-Kronrod & Simpson, Splines, multiple integrals with Simpson, Kronrod, & Monte Carlo methods ** Initial-Value ODEs: Taylor Series, improved & modified Euler, implicit Trapezoidal for stiff problems, fixed & variable single step 4-5 order Runge-Kutta, Cash-Karp & Dormand-Prince, Adams-Bashforth-Moulton multi-step methods ** Boundary Value ODEs and PDEs: Shooting, Finite Difference, Collocation on Finite Elements, Quasilinearization, Method of Lines, semi-implicit Crank-Nicholson methods ** Tables for quick reference of Excel, VBA, and custom functions & macros for numerical m
Author: Michael B. Cutlip
Publisher: Prentice Hall
ISBN:
Category : Education
Languages : en
Pages : 502
Get Book Here
Book Description
"A companion book including interactive software for students and professional engineers who want to utilize problem-solving software to effectively and efficiently obtain solutions to realistic and complex problems. An Invaluable reference book that discusses and Illustrates practical numerical problem solving in the core subject areas of Chemical Engineering. Problem Solving in Chemical Engineering with Numerical Methods provides an extensive selection of problems that require numerical solutions from throughout the core subject areas of chemical engineering. Many are completely solved or partially solved using POLYMATH as the representative mathematical problem-solving software, Ten representative problems are also solved by Excel, Maple, Mathcad, MATLAB, and Mathematica. All problems are clearly organized and all necessary data are provided. Key equations are presented or derived. Practical aspects of efficient and effective numerical problem solving are emphasized. Many complete solutions are provided within the text and on the CD-ROM for use in problem-solving exercises."--BOOK JACKET.Title Summary field provided by Blackwell North America, Inc. All Rights Reserved
Author: Richard A. Davis
Publisher: CreateSpace
ISBN: 9781482070125
Category : Technology & Engineering
Languages : en
Pages : 604
Get Book Here
Book Description
A NEW 3rd third edition of this popular title is now available with updated and expanded coverage of Practical Numerical Methods Using Excel with VBA. For more information, visit www.d.umn.edu/~rdavis/PNM/PNMExcelVBA3. Excel is the de facto computational tool used by practicing engineers and scientists. Use this book to become proficient with VBA programming and boost your worksheets with time saving enhancements and powerful numerical techniques. Topics include an introduction to modeling, Excel and VBA programming, root-finding for systems of linear and nonlinear equations, derivative approximation, optimization, experimental uncertainty analysis, least-squares regression and model validation, interpolation, integration, and ordinary and partial differential equations. A companion web site has digital files for downloading illustrations, examples, and the PNM2Suite Excel workbook with VBA user-defined functions, macros, and user forms for advanced numerical techniques. Practice problems are available for each chapter at the web site (www.d.umn.edu/~rdavis/PNM/PNMExcelVBA2).
Author: Kenneth J. Beers
Publisher: Cambridge University Press
ISBN: 9780521859714
Category : Computers
Languages : en
Pages : 496
Get Book Here
Book Description
Applications of numerical mathematics and scientific computing to chemical engineering.
Author: Kamal I. M. Al-Malah
Publisher: McGraw Hill Professional
ISBN: 0071831290
Category : Technology & Engineering
Languages : en
Pages : 385
Get Book Here
Book Description
A practical, professional guide to MATLAB computational techniques and engineering applications MATLAB Numerical Methods with Chemical Engineering Applications shows you, step by step, how to use MATLAB® to model and simulate physical problems in the chemical engineering realm. Written for MATLAB 7.11, this hands-on resource contains concise explanations of essential MATLAB commands, as well as easy-to-follow instructions for using the programming features, graphical capabilities, and desktop interface. Every step needed toward the final solution is algorithmically explained via snapshots of the MATLAB platform in parallel with the text. End-of-chapter problems help you practice what you've learned. Master this powerful computational tool using this detailed, self-teaching guide. COVERAGE INCLUDES: MATLAB basics Matrices MATLAB scripting language: M-file Image and image analysis Curve-fitting Numerical integration Solving differential equations A system of algebraic equations Statistics Chemical engineering applications MATLAB Graphical User Interface Design Environment (GUIDE)
Author: Navid Mostoufi
Publisher: Academic Press
ISBN: 0128229349
Category : Technology & Engineering
Languages : en
Pages : 503
Get Book Here
Book Description
Applied Numerical Methods for Chemical Engineers emphasizes the derivation of a variety of numerical methods and their application to the solution of engineering problems, with special attention to problems in the chemical engineering field. These algorithms encompass linear and nonlinear algebraic equations, eigenvalue problems, finite difference methods, interpolation, differentiation and integration, ordinary differential equations, boundary value problems, partial differential equations, and linear and nonlinear regression analysis. MATLAB is adopted as the calculation environment throughout the book because of its ability to perform all the calculations in matrix form, its large library of built-in functions, its strong structural language, and its rich graphical visualization tools. Through this book, students and other users will learn about the basic features, advantages and disadvantages of various numerical methods, learn and practice many useful m-files developed for different numerical methods in addition to the MATLAB built-in solvers, develop and set up mathematical models for problems commonly encountered in chemical engineering, and solve chemical engineering related problems through examples and after-chapter problems with MATLAB by creating application m-files. - Clearly and concisely develops a variety of numerical methods and applies them to the solution of chemical engineering problems. These algorithms encompass linear and nonlinear algebraic equations, eigenvalue problems, finite difference methods, interpolation, linear and nonlinear regression analysis, differentiation and integration, ordinary differential equations, boundary value problems, and partial differential equations - Includes systematic development of the calculus of finite differences and its application to the integration of differential equations, and a detailed discussion of nonlinear regression analysis, with powerful programs for implementing multivariable nonlinear regression and statistical analysis of the results - Makes extensive use of MATLAB and Excel, with most of the methods discussed implemented into general MATLAB functions. All the MATLAB-language scripts developed are listed in the text and included in the book's companion website - Includes numerous real-world examples and homework problems drawn from the field of chemical and biochemical engineering
Author: Mark E. Davis
Publisher: Courier Corporation
ISBN: 0486782328
Category : Technology & Engineering
Languages : en
Pages : 276
Get Book Here
Book Description
This text introduces the quantitative treatment of differential equations arising from modeling physical phenomena in chemical engineering. Coverage includes recent topics such as ODE-IVPs, emphasizing numerical methods and modeling of 1984-era commercial mathematical software.
Author: Edward Gatzke
Publisher: Springer Nature
ISBN: 3030764494
Category : Biomedical engineering
Languages : en
Pages : 292
Get Book Here
Book Description
This textbook introduces the concepts and tools that biomedical and chemical engineering students need to know in order to translate engineering problems into a numerical representation using scientific fundamentals. Modeling concepts focus on problems that are directly related to biomedical and chemical engineering. A variety of computational tools are presented, including MATLAB, Excel, Mathcad, and COMSOL, and a brief introduction to each tool is accompanied by multiple computer lab experiences. The numerical methods covered are basic linear algebra and basic statistics, and traditional methods like Newton's method, Euler Integration, and trapezoidal integration. The book presents the reader with numerous examples and worked problems, and practice problems are included at the end of each chapter. Focuses on problems and methods unique to biomedical and chemical engineering; Presents modeling concepts drawn from chemical, mechanical, and materials engineering; Ancillary materials include lecture notes and slides and online videos that enable a flipped classroom or individual study.
Author: Santosh K Gupta
Publisher: New Age International
ISBN: 9788122406511
Category : Differential quations
Languages : en
Pages : 426
Get Book Here
Book Description
This Book Is Intended To Be A Text For Either A First Or A Second Course In Numerical Methods For Students In All Engineering Disciplines. Difficult Concepts, Which Usually Pose Problems To Students Are Explained In Detail And Illustrated With Solved Examples. Enough Elementary Material That Could Be Covered In The First-Level Course Is Included, For Example, Methods For Solving Linear And Nonlinear Algebraic Equations, Interpolation, Differentiation, Integration, And Simple Techniques For Integrating Odes And Pdes (Ordinary And Partial Differential Equations).Advanced Techniques And Concepts That Could Form Part Of A Second-Level Course Includegears Method For Solving Ode-Ivps (Initial Value Problems), Stiffness Of Ode- Ivps, Multiplicity Of Solutions, Convergence Characteristics, The Orthogonal Collocation Method For Solving Ode-Bvps (Boundary Value Problems) And Finite Element Techniques. An Extensive Set Of Graded Problems, Often With Hints, Has Been Included.Some Involve Simple Applications Of The Concepts And Can Be Solved Using A Calculator, While Several Are From Real-Life Situations And Require Writing Computer Programs Or Use Of Library Subroutines. Practice On These Is Expected To Build Up The Reader'S Confidence In Developing Large Computer Codes.
