Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 3rd Edition

Note moyenne 0
( 0 avis fournis par GoodReads )
 
9781502527400: Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 3rd Edition
Présentation de l'éditeur :

The **NEW** 3rd edition expands Practical Numerical Methods with more VBA & Excel programming to boost Excel's power for numerical modeling & analysis. Excel is the de facto computational tool used by engineers & scientists worldwide. Learn how to customize your Excel workbooks with VBA using the same powerful numerical techniques found in specialized math software.

Visit the book's companion web site to access the Excel & VBA files:

www.d.umn.edu/~rdavis/PNM/PNMExcelVBA3

Download:

  1. The refined Excel PNM3Suite workbook with 120 VBA user-defined functions, macros & user forms for learning VBA & implementing advanced numerical techniques in Excel.
  2. Excel workbooks used to create the book's more than 200 practical examples demonstrating the power of the numerical methods in the book. Customize the examples & macros to tackle your own numerical problems using VBA in Excel.
  3. Hundreds of practice problems for self-guided study to sharpen your Excel & VBA skills.

The first chapter sets the stage for problem solving with numerical methods. The next two chapters cover frequently overlooked features of Excel & VBA for implementing numerical methods in Excel, as well as documenting results. The remaining chapters present powerful numerical techniques using Excel & VBA to find roots to algebraic equations, approximate derivatives, optimize, model data by least-squares regression & interpolation, analyze risk and uncertainty, solve integrals and ordinary & partial differential equations:

  1. Numerical Methods & Mathematical Modeling: expert problem solving
  2. Excel: Documentation, Graphing, Worksheet Functions, Input Validation & Formatting, What-if Analysis
  3. VBA: Editor and objects, Function & Sub Procedures, Data Types, Structured Programming, Arithmetic and Worksheet Functions, Flow Control, Arrays, Communication, Message & Input Boxes, User Forms, Reading/Writing Files, Debugging, Unit Conversions
  4. Linear Equations: Matrix Algebra, Gaussian Elimination and Crout Reduction with Pivoting, Thomas, Cholesky, Power, Jacobi, & Interpolation Methods for Eigenvalues & Eigenvectors, Jacobi & Gauss-Seidel Iteration, Relaxation
  5. Taylor Series Analysis: Finite Difference Derivative Approximation, Richardson's Extrapolation, Ridder's algorithm, Sensitivity
  6. Nonlinear Equations Root Finding: Methods of Bisection, Regula Falsi, Newton, Secant, Pade, Wegstein, Quasi-Newton, Aitkin/Steffensen, Homotopy, Bairstow (for polynomial roots), Goal Seek & Solver
  7. Optimization: Solver, Luus-Jaakola, Quadratic Interpolation, Golden Section, Powell, Firefly, Constraints, Scaling & Sensitivity
  8. Uncertainty & Risk Analysis: Law of Propagation, Monte Carlo Simulations with Latin Hypercube Sampling
  9. Least-squares Regression: Linear, Nonlinear, LINEST, Gauss-Newton, Levenberg-Marquardt, Validation and Assessment, Uncertainty Analysis, Weighted Regression
  10. Interpolation: Linear, Newton Divided Difference and Lagrange Polynomials, Rational, Bulirsh-Stoer Pade, Stineman, Cubic & Constrained Splines, Linear & Spline Bivariate Interpolation
  11. Integration: Graphical, Trapezoidal, Midpoint & transformation for Improper Integrals, Romberg, Adaptive Simpson & Gauss-Kronrod, Multiple Integrals by Simpson, Kronrod & Monte Carlo
  12. 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
  13. Boundary-value Problems & Partial Differential Equations: Shooting, Finite Difference, Orthogonal Collocation, Quasilinearization, Method of Lines, Crank-Nicholson
  14. Review: Reference Tables of Excel & VBA Functions, User-defined Functions, Macros, User Forms
  15. Primer on chemical reaction engineering

Présentation de l'éditeur :

The latest 3rd edition expands Practical Numerical Methods with more VBA to boost Excel's power for numerical modeling and analysis. Visit the companion web site to access the book's Excel and VBA files, and learn how to customize your Excel workbooks with the same numerical techniques found in specialized math software:

www.d.umn.edu/~rdavis/PNM/PNMExcelVBA3

Download:

  1. A refined macro-enabled Excel workbook with a suite of over 170 VBA user-defined functions, macros and user forms for learning VBA and implementing advanced numerical techniques in Excel.
  2. More than 200 practical example and animation workbook files from the book that demonstrate the power of numerical methods. Customize the example files and macros to tackle your own problems using VBA in Excel.
  3. Hundreds of practice problems for self-guided study to sharpen your Excel and VBA skills.

The first chapter sets the stage for problem solving with numerical methods. The next two chapters cover frequently overlooked features of Excel (2007, 2010, 2013 and later) and VBA for implementing numerical methods in Excel, as well as documenting results. 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 & ordinary & partial differential equations:

  1. Numerical Methods & Mathematical Modeling: expert problem solving
  2. Excel: Documentation, Graphing, Worksheet Functions, Input Validation and Formatting, What-if Analysis
  3. VBA: 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
  4. Linear Equations: Matrix Algebra, Gaussian Elimination and Crout Reduction with Pivoting, Thomas, Cholesky, Power, Jacobi, and Interpolation Methods for Eigenvalues and Eigenvectors, Jacobi and Gauss-Seidel Iteration, Relaxation
  5. Taylor Series Analysis: Finite Difference Derivative Approximation, Richardson's Extrapolation, Ridder's algorithm, Sensitivity
  6. Nonlinear Equations Root Finding: Methods of Bisection, Regula Falsi, Newton, Secant, Pade, Wegstein, Quasi-Newton, Aitkin/Steffensen, Homotopy, Bairstow (for polynomial roots), Goal Seek and Solver
  7. Optimization: Solver, Luus-Jaakola, Quadratic, Golden Section, Powell, Downhill Simplex, Firefly, Constraints, Scaling and Sensitivity
  8. Uncertainty and Risk Analysis: Bootstrap, Confidence Intervals, Law of Propagation, Monte Carlo Simulations with Latin Hypercube Sampling
  9. Least-squares Regression: Linear, Nonlinear, LINEST, Gauss-Newton, Levenberg-Marquardt, Validation and Assessment, Uncertainty Analysis, Weighted Regression
  10. Interpolation: Linear, Newton Divided Difference and Lagrange Polynomials, Rational, Bulirsh-Stoer, Pade, Stineman, Cubic, B, Akima and Constrained Hermite Splines, Bivariate Interpolation
  11. Integration: Graphical, Trapezoidal, Midpoint and transformation for Improper Integrals, Romberg, Adaptive Simpson and Gauss-Kronrod, Multiple Integrals by Simpson, Kronrod and Monte Carlo
  12. Initial-value Problems: Single Step Euler and Backward Euler, Implicit Trapezoidal for Stiffness, Variable Step Runge-Kutta Cash-Karp, Dormand-Prince, Multi-step Adams-Bashforth-Moulton, Differential-Algebraic Systems
  13. Boundary-value Problems and Partial Differential Equations: Shooting, Finite Difference, Orthogonal Collocation, Quasilinearization, Method of Lines, Crank-Nicholson
  14. Review: Reference Tables of Excel and VBA Functions, User-defined Functions, Macros, User Forms
  15. Primer on chemical reaction engineering

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Acheter neuf Afficher le livre
EUR 94,41

Autre devise

Frais de port : EUR 6,94
De Royaume-Uni vers Etats-Unis

Destinations, frais et délais

Ajouter au panier

Meilleurs résultats de recherche sur AbeBooks

1.

Richard A Davis
Edité par CreateSpace Independent Publishing Platform (2014)
ISBN 10 : 1502527405 ISBN 13 : 9781502527400
Neuf(s) Paperback Quantité : 1
impression à la demande
Vendeur
Revaluation Books
(Exeter, Royaume-Uni)
Evaluation vendeur
[?]

Description du livre CreateSpace Independent Publishing Platform, 2014. Paperback. État : Brand New. 3rd edition. 600 pages. 11.00x8.50x1.36 inches. This item is printed on demand. N° de réf. du libraire zk1502527405

Plus d'informations sur ce vendeur | Poser une question au libraire

Acheter neuf
EUR 94,41
Autre devise

Ajouter au panier

Frais de port : EUR 6,94
De Royaume-Uni vers Etats-Unis
Destinations, frais et délais