Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB

Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB

Author: Victor J. Law

Publisher: CRC Press

Published: 2013-04-08

Total Pages: 247

ISBN-13: 1482201593

DOWNLOAD EBOOK

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 have been enhanced to create the current textbook, Numerical Methods for Chemical Engineers Using Excel®, VBA, and MATLAB®. Focusing on Excel gives the advantage of it being generally available, since it is present on every computer—PC and Mac—that has Microsoft Office installed. The VBA programming environment comes with Excel and greatly enhances the capabilities of Excel spreadsheets. While there is no perfect programming system, teaching this combination offers knowledge in a widely available program that is commonly used (Excel) as well as a popular academic software package (MATLAB). Chapters cover nonlinear equations, Visual Basic, linear algebra, ordinary differential equations, regression analysis, partial differential equations, and mathematical programming methods. Each chapter contains examples that show in detail how a particular numerical method or programming methodology can be implemented in Excel and/or VBA (or MATLAB in chapter 10). Most of the examples and problems presented in the text are related to chemical and biomolecular engineering and cover a broad range of application areas including thermodynamics, fluid flow, heat transfer, mass transfer, reaction kinetics, reactor design, process design, and process control. The chapters feature "Did You Know" boxes, used to remind readers of Excel features. They also contain end-of-chapter exercises, with solutions provided.


Book Synopsis Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB by : Victor J. Law

Download or read book Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB written by Victor J. Law and published by CRC Press. This book was released on 2013-04-08 with total page 247 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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 have been enhanced to create the current textbook, Numerical Methods for Chemical Engineers Using Excel®, VBA, and MATLAB®. Focusing on Excel gives the advantage of it being generally available, since it is present on every computer—PC and Mac—that has Microsoft Office installed. The VBA programming environment comes with Excel and greatly enhances the capabilities of Excel spreadsheets. While there is no perfect programming system, teaching this combination offers knowledge in a widely available program that is commonly used (Excel) as well as a popular academic software package (MATLAB). Chapters cover nonlinear equations, Visual Basic, linear algebra, ordinary differential equations, regression analysis, partial differential equations, and mathematical programming methods. Each chapter contains examples that show in detail how a particular numerical method or programming methodology can be implemented in Excel and/or VBA (or MATLAB in chapter 10). Most of the examples and problems presented in the text are related to chemical and biomolecular engineering and cover a broad range of application areas including thermodynamics, fluid flow, heat transfer, mass transfer, reaction kinetics, reactor design, process design, and process control. The chapters feature "Did You Know" boxes, used to remind readers of Excel features. They also contain end-of-chapter exercises, with solutions provided.

Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB

Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB

Author: Victor J. Law

Publisher: CRC Press

Published: 2013-03-05

Total Pages: 247

ISBN-13: 1466575352

DOWNLOAD EBOOK

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


Book Synopsis Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB by : Victor J. Law

Download or read book Numerical Methods for Chemical Engineers Using Excel, VBA, and MATLAB written by Victor J. Law and published by CRC Press. This book was released on 2013-03-05 with total page 247 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Numerical Methods for Chemical Engineers with MATLAB Applications

Numerical Methods for Chemical Engineers with MATLAB Applications

Author: A. Constantinides

Publisher: Prentice Hall

Published: 1999

Total Pages: 602

ISBN-13:

DOWNLOAD EBOOK

Master numerical methods using MATLAB, today's leading software for problem solving. This complete guide to numerical methods in chemical engineering is the first to take full advantage of MATLAB's powerful calculation environment. Every chapter contains several examples using general MATLAB functions that implement the method and can also be applied to many other problems in the same category. The authors begin by introducing the solution of nonlinear equations using several standard approaches, including methods of successive substitution and linear interpolation; the Wegstein method, the Newton-Raphson method; the Eigenvalue method; and synthetic division algorithms. With these fundamentals in hand, they move on to simultaneous linear algebraic equations, covering matrix and vector operations; Cramer's rule; Gauss methods; the Jacobi method; and the characteristic-value problem. Additional coverage includes: Finite difference methods, and interpolation of equally and unequally spaced points Numerical differentiation and integration, including differentiation by backward, forward, and central finite differences; Newton-Cotes formulas; and the Gauss Quadrature Two detailed chapters on ordinary and partial differential equations Linear and nonlinear regression analyses, including least squares, estimated vector of parameters, method of steepest descent, Gauss-Newton method, Marquardt Method, Newton Method, and multiple nonlinear regression The numerical methods covered here represent virtually all of those commonly used by practicing chemical engineers. The focus on MATLAB enables readers to accomplish more, with less complexity, than was possible with traditional FORTRAN. For those unfamiliar with MATLAB, a brief introduction is provided as an Appendix. Over 60+ MATLAB examples, methods, and function scripts are covered, and all of them are included on the book's CD


Book Synopsis Numerical Methods for Chemical Engineers with MATLAB Applications by : A. Constantinides

Download or read book Numerical Methods for Chemical Engineers with MATLAB Applications written by A. Constantinides and published by Prentice Hall. This book was released on 1999 with total page 602 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master numerical methods using MATLAB, today's leading software for problem solving. This complete guide to numerical methods in chemical engineering is the first to take full advantage of MATLAB's powerful calculation environment. Every chapter contains several examples using general MATLAB functions that implement the method and can also be applied to many other problems in the same category. The authors begin by introducing the solution of nonlinear equations using several standard approaches, including methods of successive substitution and linear interpolation; the Wegstein method, the Newton-Raphson method; the Eigenvalue method; and synthetic division algorithms. With these fundamentals in hand, they move on to simultaneous linear algebraic equations, covering matrix and vector operations; Cramer's rule; Gauss methods; the Jacobi method; and the characteristic-value problem. Additional coverage includes: Finite difference methods, and interpolation of equally and unequally spaced points Numerical differentiation and integration, including differentiation by backward, forward, and central finite differences; Newton-Cotes formulas; and the Gauss Quadrature Two detailed chapters on ordinary and partial differential equations Linear and nonlinear regression analyses, including least squares, estimated vector of parameters, method of steepest descent, Gauss-Newton method, Marquardt Method, Newton Method, and multiple nonlinear regression The numerical methods covered here represent virtually all of those commonly used by practicing chemical engineers. The focus on MATLAB enables readers to accomplish more, with less complexity, than was possible with traditional FORTRAN. For those unfamiliar with MATLAB, a brief introduction is provided as an Appendix. Over 60+ MATLAB examples, methods, and function scripts are covered, and all of them are included on the book's CD

Excel for Scientists and Engineers

Excel for Scientists and Engineers

Author: E. Joseph Billo

Publisher: John Wiley & Sons

Published: 2007-04-06

Total Pages: 485

ISBN-13: 0471387347

DOWNLOAD EBOOK

Learn to fully harness the power of Microsoft Excel(r) to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's(r) capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's(r) capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: * Use worksheet functions to work with matrices * Find roots of equations and solve systems of simultaneous equations * Solve ordinary differential equations and partial differential equations * Perform linear and non-linear regression * Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: * All the spreadsheets, charts, and VBA code needed to perform the examples from the text * Solutions to most of the end-of-chapter problems * An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package.


Book Synopsis Excel for Scientists and Engineers by : E. Joseph Billo

Download or read book Excel for Scientists and Engineers written by E. Joseph Billo and published by John Wiley & Sons. This book was released on 2007-04-06 with total page 485 pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn to fully harness the power of Microsoft Excel(r) to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's(r) capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's(r) capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: * Use worksheet functions to work with matrices * Find roots of equations and solve systems of simultaneous equations * Solve ordinary differential equations and partial differential equations * Perform linear and non-linear regression * Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: * All the spreadsheets, charts, and VBA code needed to perform the examples from the text * Solutions to most of the end-of-chapter problems * An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package.

Practical Numerical Methods for Chemical Engineers

Practical Numerical Methods for Chemical Engineers

Author: Richard A. Davis

Publisher: CreateSpace

Published: 2014-10-02

Total Pages: 600

ISBN-13: 9781502527400

DOWNLOAD EBOOK

This NEW 3rd edition builds on the popular success of prior editions to expand the breadth of Practical Numerical Methods with more VBA macros that boost Excel's power for modeling and analysis. Engineers & scientists will find enhanced coverage of computational tools applicable to a wider variety of problems in their own disciplines. Excel is the de facto computational tool used by practicing engineers & scientists. Use this book to become proficient with VBA programming & customize your workbooks with time saving enhancements & powerful numerical techniques. Topics include an introduction to modeling, Excel & VBA programming, root-finding for systems of linear & nonlinear equations, eigenproblems, derivative approximation, optimization, experimental uncertainty analysis, least-squares regression & model validation, interpolation, integration, ordinary & partial differential equations. A companion web site has digital files for downloading 200 illustrations, examples, & the refined PNM3Suite workbook with 100 VBA user-defined functions, macros, & user forms for advanced numerical techniques. End-of-chapter practice problems for self-study are also available at the site (www.d.umn.edu/~rdavis/PNM/PNMExcelVBA3). Example files & macros are ready to be modified by users for their own needs. The introduction includes a primer on chemical reaction engineering for problems involving mass & energy balances with reactions. The next two chapters cover frequently overlooked features of Excel & VBA to apply numerical methods in Excel, as well as document results. The remaining chapters present powerful numerical techniques using Excel & VBA. Introduction to Numerical Methods & Mathematical Modeling Introduction to Excel: Documentation, Graphing, Worksheet Functions, Validation & Formatting, What-if Analysis VBA: Editor, Functions & Sub Procedures, Data Types, Structured Programming, Arithmetic & Worksheet Functions, Flow Control, Arrays, Communication, Message & Input Boxes, User Forms, Reading/Writing Files, Debugging Linear Equations: Matrix Algebra, Gaussian Elimination & Crout Reduction with Pivoting, Thomas, Cholesky, Power, Jacobi, & Interpolation Method for Eigenvalues & Eigenvectors, Jacobi & Gauss-Seidel Iteration, Relaxation Taylor Series Analysis: Finite Difference Derivative Approximations, Richardson's Extrapolation Nonlinear Equations: Root Finding, Bisection, Regula Falsi, Newton & Secant Methods, Wegstein, Quasi-Newton, Aitkin & Steffensen, Homotopy, Goal Seek & Solver, Bairstow's Method for Polynomial Roots Optimization: Solver, Luus-Jaakola, Quadratic Interpolation, Golden Section, Powell, Constraints, Scaling Uncertainty Analysis: Law of Propagation, Monte Carlo Simulations with Latin Hypercube Sampling Least-squares Regression: Linear & Nonlinear, LINEST, Gauss-Newton, Levenberg-Marquardt, Model Validation & Assessment, Parameter & Model Uncertainty Analysis, Weighted Regression Interpolation: Linear, Newton Divided Difference & Lagrange Polynomials, Rational, Stineman, Cubic & Constrained Splines, Linear & Spline Bivariate Interpolation Integration: Graphical, Trapezoidal, Midpoint for Improper Integrals, Romberg, Adaptive Simpson & Gauss-Kronrod, Multiple Integrals by Simpson, Guass-Kronrod & Monte Carlo Initial-value Problems: Single Step Euler & Backward Euler, Implicit Trapezoidal for Stiffness, Variable Step Runge-Kutta Cash Karp, Dormand-Prince, Multi-step Adams-Bashforth-Moulton, Differential-Algebraic Systems Boundary-value Problems & Partial Differential Equations: Shooting, Finite Difference, Orthogonal Collocation, Quasilinearization, Method of Lines, Crank-Nicholson Review: Summary Tables of Excel & VBA Functions, User-defined Functions, Macros, User Forms


Book Synopsis Practical Numerical Methods for Chemical Engineers by : Richard A. Davis

Download or read book Practical Numerical Methods for Chemical Engineers written by Richard A. Davis and published by CreateSpace. This book was released on 2014-10-02 with total page 600 pages. Available in PDF, EPUB and Kindle. Book excerpt: This NEW 3rd edition builds on the popular success of prior editions to expand the breadth of Practical Numerical Methods with more VBA macros that boost Excel's power for modeling and analysis. Engineers & scientists will find enhanced coverage of computational tools applicable to a wider variety of problems in their own disciplines. Excel is the de facto computational tool used by practicing engineers & scientists. Use this book to become proficient with VBA programming & customize your workbooks with time saving enhancements & powerful numerical techniques. Topics include an introduction to modeling, Excel & VBA programming, root-finding for systems of linear & nonlinear equations, eigenproblems, derivative approximation, optimization, experimental uncertainty analysis, least-squares regression & model validation, interpolation, integration, ordinary & partial differential equations. A companion web site has digital files for downloading 200 illustrations, examples, & the refined PNM3Suite workbook with 100 VBA user-defined functions, macros, & user forms for advanced numerical techniques. End-of-chapter practice problems for self-study are also available at the site (www.d.umn.edu/~rdavis/PNM/PNMExcelVBA3). Example files & macros are ready to be modified by users for their own needs. The introduction includes a primer on chemical reaction engineering for problems involving mass & energy balances with reactions. The next two chapters cover frequently overlooked features of Excel & VBA to apply numerical methods in Excel, as well as document results. The remaining chapters present powerful numerical techniques using Excel & VBA. Introduction to Numerical Methods & Mathematical Modeling Introduction to Excel: Documentation, Graphing, Worksheet Functions, Validation & Formatting, What-if Analysis VBA: Editor, Functions & Sub Procedures, Data Types, Structured Programming, Arithmetic & Worksheet Functions, Flow Control, Arrays, Communication, Message & Input Boxes, User Forms, Reading/Writing Files, Debugging Linear Equations: Matrix Algebra, Gaussian Elimination & Crout Reduction with Pivoting, Thomas, Cholesky, Power, Jacobi, & Interpolation Method for Eigenvalues & Eigenvectors, Jacobi & Gauss-Seidel Iteration, Relaxation Taylor Series Analysis: Finite Difference Derivative Approximations, Richardson's Extrapolation Nonlinear Equations: Root Finding, Bisection, Regula Falsi, Newton & Secant Methods, Wegstein, Quasi-Newton, Aitkin & Steffensen, Homotopy, Goal Seek & Solver, Bairstow's Method for Polynomial Roots Optimization: Solver, Luus-Jaakola, Quadratic Interpolation, Golden Section, Powell, Constraints, Scaling Uncertainty Analysis: Law of Propagation, Monte Carlo Simulations with Latin Hypercube Sampling Least-squares Regression: Linear & Nonlinear, LINEST, Gauss-Newton, Levenberg-Marquardt, Model Validation & Assessment, Parameter & Model Uncertainty Analysis, Weighted Regression Interpolation: Linear, Newton Divided Difference & Lagrange Polynomials, Rational, Stineman, Cubic & Constrained Splines, Linear & Spline Bivariate Interpolation Integration: Graphical, Trapezoidal, Midpoint for Improper Integrals, Romberg, Adaptive Simpson & Gauss-Kronrod, Multiple Integrals by Simpson, Guass-Kronrod & Monte Carlo Initial-value Problems: Single Step Euler & Backward Euler, Implicit Trapezoidal for Stiffness, Variable Step Runge-Kutta Cash Karp, Dormand-Prince, Multi-step Adams-Bashforth-Moulton, Differential-Algebraic Systems Boundary-value Problems & Partial Differential Equations: Shooting, Finite Difference, Orthogonal Collocation, Quasilinearization, Method of Lines, Crank-Nicholson Review: Summary Tables of Excel & VBA Functions, User-defined Functions, Macros, User Forms

Introduction to Chemical Engineering Computing

Introduction to Chemical Engineering Computing

Author: Bruce A. Finlayson

Publisher: John Wiley & Sons

Published: 2014-03-05

Total Pages: 502

ISBN-13: 1118888375

DOWNLOAD EBOOK

Step-by-step instructions enable chemical engineers to master key software programs and solve complex problems Today, both students and professionals in chemical engineering must solve increasingly complex problems dealing with refineries, fuel cells, microreactors, and pharmaceutical plants, to name a few. With this book as their guide, readers learn to solve these problems using their computers and Excel, MATLAB, Aspen Plus, and COMSOL Multiphysics. Moreover, they learn how to check their solutions and validate their results to make sure they have solved the problems correctly. Now in its Second Edition, Introduction to Chemical Engineering Computing is based on the author’s firsthand teaching experience. As a result, the emphasis is on problem solving. Simple introductions help readers become conversant with each program and then tackle a broad range of problems in chemical engineering, including: Equations of state Chemical reaction equilibria Mass balances with recycle streams Thermodynamics and simulation of mass transfer equipment Process simulation Fluid flow in two and three dimensions All the chapters contain clear instructions, figures, and examples to guide readers through all the programs and types of chemical engineering problems. Problems at the end of each chapter, ranging from simple to difficult, allow readers to gradually build their skills, whether they solve the problems themselves or in teams. In addition, the book’s accompanying website lists the core principles learned from each problem, both from a chemical engineering and a computational perspective. Covering a broad range of disciplines and problems within chemical engineering, Introduction to Chemical Engineering Computing is recommended for both undergraduate and graduate students as well as practicing engineers who want to know how to choose the right computer software program and tackle almost any chemical engineering problem.


Book Synopsis Introduction to Chemical Engineering Computing by : Bruce A. Finlayson

Download or read book Introduction to Chemical Engineering Computing written by Bruce A. Finlayson and published by John Wiley & Sons. This book was released on 2014-03-05 with total page 502 pages. Available in PDF, EPUB and Kindle. Book excerpt: Step-by-step instructions enable chemical engineers to master key software programs and solve complex problems Today, both students and professionals in chemical engineering must solve increasingly complex problems dealing with refineries, fuel cells, microreactors, and pharmaceutical plants, to name a few. With this book as their guide, readers learn to solve these problems using their computers and Excel, MATLAB, Aspen Plus, and COMSOL Multiphysics. Moreover, they learn how to check their solutions and validate their results to make sure they have solved the problems correctly. Now in its Second Edition, Introduction to Chemical Engineering Computing is based on the author’s firsthand teaching experience. As a result, the emphasis is on problem solving. Simple introductions help readers become conversant with each program and then tackle a broad range of problems in chemical engineering, including: Equations of state Chemical reaction equilibria Mass balances with recycle streams Thermodynamics and simulation of mass transfer equipment Process simulation Fluid flow in two and three dimensions All the chapters contain clear instructions, figures, and examples to guide readers through all the programs and types of chemical engineering problems. Problems at the end of each chapter, ranging from simple to difficult, allow readers to gradually build their skills, whether they solve the problems themselves or in teams. In addition, the book’s accompanying website lists the core principles learned from each problem, both from a chemical engineering and a computational perspective. Covering a broad range of disciplines and problems within chemical engineering, Introduction to Chemical Engineering Computing is recommended for both undergraduate and graduate students as well as practicing engineers who want to know how to choose the right computer software program and tackle almost any chemical engineering problem.

Numerical Methods for Chemical Engineering

Numerical Methods for Chemical Engineering

Author: Kenneth J. Beers

Publisher: Cambridge University Press

Published: 2007

Total Pages: 496

ISBN-13: 9780521859714

DOWNLOAD EBOOK

Applications of numerical mathematics and scientific computing to chemical engineering.


Book Synopsis Numerical Methods for Chemical Engineering by : Kenneth J. Beers

Download or read book Numerical Methods for Chemical Engineering written by Kenneth J. Beers and published by Cambridge University Press. This book was released on 2007 with total page 496 pages. Available in PDF, EPUB and Kindle. Book excerpt: Applications of numerical mathematics and scientific computing to chemical engineering.

Practical Numerical Methods for Chemical Engineers

Practical Numerical Methods for Chemical Engineers

Author: Richard A. Davis

Publisher: CreateSpace

Published: 2014-09-24

Total Pages: 600

ISBN-13: 9781495409653

DOWNLOAD EBOOK

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


Book Synopsis Practical Numerical Methods for Chemical Engineers by : Richard A. Davis

Download or read book Practical Numerical Methods for Chemical Engineers written by Richard A. Davis and published by CreateSpace. This book was released on 2014-09-24 with total page 600 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Applied Numerical Methods Using MATLAB

Applied Numerical Methods Using MATLAB

Author: Won Y. Yang

Publisher: John Wiley & Sons

Published: 2005-05-20

Total Pages: 526

ISBN-13: 0471705187

DOWNLOAD EBOOK

In recent years, with the introduction of new media products, there has been a shift in the use of programming languages from FORTRAN or C to MATLAB for implementing numerical methods. This book makes use of the powerful MATLAB software to avoid complex derivations, and to teach the fundamental concepts using the software to solve practical problems. Over the years, many textbooks have been written on the subject of numerical methods. Based on their course experience, the authors use a more practical approach and link every method to real engineering and/or science problems. The main benefit is that engineers don't have to know the mathematical theory in order to apply the numerical methods for solving their real-life problems. An Instructor's Manual presenting detailed solutions to all the problems in the book is available online.


Book Synopsis Applied Numerical Methods Using MATLAB by : Won Y. Yang

Download or read book Applied Numerical Methods Using MATLAB written by Won Y. Yang and published by John Wiley & Sons. This book was released on 2005-05-20 with total page 526 pages. Available in PDF, EPUB and Kindle. Book excerpt: In recent years, with the introduction of new media products, there has been a shift in the use of programming languages from FORTRAN or C to MATLAB for implementing numerical methods. This book makes use of the powerful MATLAB software to avoid complex derivations, and to teach the fundamental concepts using the software to solve practical problems. Over the years, many textbooks have been written on the subject of numerical methods. Based on their course experience, the authors use a more practical approach and link every method to real engineering and/or science problems. The main benefit is that engineers don't have to know the mathematical theory in order to apply the numerical methods for solving their real-life problems. An Instructor's Manual presenting detailed solutions to all the problems in the book is available online.

Advanced Excel for Scientific Data Analysis

Advanced Excel for Scientific Data Analysis

Author: Robert De Levie

Publisher: Oxford University Press, USA

Published: 2004

Total Pages: 631

ISBN-13: 0195152751

DOWNLOAD EBOOK

This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).


Book Synopsis Advanced Excel for Scientific Data Analysis by : Robert De Levie

Download or read book Advanced Excel for Scientific Data Analysis written by Robert De Levie and published by Oxford University Press, USA. This book was released on 2004 with total page 631 pages. Available in PDF, EPUB and Kindle. Book excerpt: This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).