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

0 valoración promedio
( 0 valoraciones por Goodreads )
 
9781502527400: Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 3rd Edition

This latest edition expands Practical Numerical Methods with more VBA to boost Excel's power for modeling and analysis using the same numerical techniques found in more specialized math software. Visit the companion web site:

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

to access all of the book's Excel and VBA files, and learn how to customize your own Excel workbooks with:

  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 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 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, Primer on Chemical Reaction Engineering
  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

"Sinopsis" puede pertenecer a otra edición de este libro.

About the Author:

Richard Davis is a Jean G. Blehart Distinguished Professor of Chemical Engineering at the University of Minnesota Duluth. He earned Ph.D. and B.S. Chemical Engineering degrees from UCSB and BYU, respectively.

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 Chemical Engineering Honor Society Omega Chi Epsilon, and is active in AIChE and ASEE. 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.

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

Davis, Richard a.
ISBN 10: 1502527405 ISBN 13: 9781502527400
Nuevos Cantidad: > 20
Impresión bajo demanda
Librería
Pbshop
(Wood Dale, IL, Estados Unidos de America)
Valoración
[?]

Descripción 2014. PAP. Estado de conservación: New. New Book.Shipped from US within 10 to 14 business days.THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Nº de ref. de la librería IP-9781502527400

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 38,18
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Davis, Richard a.
Editorial: Createspace Independent Publishing Platform (2014)
ISBN 10: 1502527405 ISBN 13: 9781502527400
Nuevos Cantidad: > 20
Impresión bajo demanda
Librería
Books2Anywhere
(Fairford, GLOS, Reino Unido)
Valoración
[?]

Descripción Createspace Independent Publishing Platform, 2014. PAP. Estado de conservación: New. New Book. Delivered from our US warehouse in 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND.Established seller since 2000. Nº de ref. de la librería IP-9781502527400

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 40,31
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 10,21
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Davis, Richard A
Editorial: CreateSpace Independent Publis (2017)
ISBN 10: 1502527405 ISBN 13: 9781502527400
Nuevos Paperback Cantidad: 18
Impresión bajo demanda
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción CreateSpace Independent Publis, 2017. Paperback. Estado de conservación: New. Never used! This item is printed on demand. Nº de ref. de la librería 1502527405

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 51,59
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 1,69
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Davis, Richard A
Editorial: CreateSpace Independent Publis (2017)
ISBN 10: 1502527405 ISBN 13: 9781502527400
Nuevos Paperback Cantidad: 10
Impresión bajo demanda
Librería
Save With Sam
(North Miami, FL, Estados Unidos de America)
Valoración
[?]

Descripción CreateSpace Independent Publis, 2017. Paperback. Estado de conservación: New. Brand New! This item is printed on demand. Nº de ref. de la librería 1502527405

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 51,80
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,55
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Dr Richard A Davis
Editorial: Createspace Independent Publishing Platform (2014)
ISBN 10: 1502527405 ISBN 13: 9781502527400
Nuevos Paperback Cantidad: 10
Impresión bajo demanda
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción Createspace Independent Publishing Platform, 2014. Paperback. Estado de conservación: New. Language: English . Brand New Book ***** Print on Demand *****.This latest edition expands Practical Numerical Methods with more VBA to boost Excel s power for modeling and analysis using the same numerical techniques found in more specialized math software. Visit the companion web site: rdavis/PNM/PNMExcelVBA3 to access all of the book s Excel and VBA files, and learn how to customize your own Excel workbooks with: 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. More than 200 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. 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 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: Numerical Methods Mathematical Modeling: expert problem solving, Primer on Chemical Reaction Engineering Excel: Documentation, Graphing, Worksheet Functions, Input Validation and Formatting, What-if Analysis 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 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 Taylor Series Analysis: Finite Difference Derivative Approximation, Richardson s Extrapolation, Ridder s algorithm, Sensitivity 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 Optimization: Solver, Luus-Jaakola, Quadratic, Golden Section, Powell, Downhill Simplex, Firefly, Constraints, Scaling and Sensitivity Uncertainty and Risk Analysis: Bootstrap, Confidence Intervals, Law of Propagation, Monte Carlo Simulations with Latin Hypercube Sampling Least-squares Regression: Linear, Nonlinear, LINEST, Gauss-Newton, Levenberg-Marquardt, Validation and Assessment, Uncertainty Analysis, Weighted Regression Interpolation: Linear, Newton Divided Difference and Lagrange Polynomials, Rational, Bulirsh-Stoer, Pade, Stineman, Cubic, B, Akima and Constrained Hermite Splines, Bivariate Interpolation Integration: Graphical, Trapezoidal, Midpoint and transformation for Improper Integrals, Romberg, Adaptive Simpson and Gauss-Kronrod, Multiple Integrals by Simpson, Kronrod and Monte Carlo 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 Boundary-value Problems and Partial Differential Equations: Shooting, Finite Difference, Orthogonal Collocation, Quasilinearization, Method of Lines, Crank-Nicholson Review: Reference Tables of Excel and VBA Functions, User-defined Functions, Macros, User Forms. Nº de ref. de la librería APC9781502527400

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 60,42
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Dr Richard A Davis
Editorial: Createspace Independent Publishing Platform (2014)
ISBN 10: 1502527405 ISBN 13: 9781502527400
Nuevos Paperback Cantidad: 10
Impresión bajo demanda
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción Createspace Independent Publishing Platform, 2014. Paperback. Estado de conservación: New. Language: English . Brand New Book ***** Print on Demand *****. This latest edition expands Practical Numerical Methods with more VBA to boost Excel s power for modeling and analysis using the same numerical techniques found in more specialized math software. Visit the companion web site: rdavis/PNM/PNMExcelVBA3 to access all of the book s Excel and VBA files, and learn how to customize your own Excel workbooks with: 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. More than 200 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. 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 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: Numerical Methods Mathematical Modeling: expert problem solving, Primer on Chemical Reaction Engineering Excel: Documentation, Graphing, Worksheet Functions, Input Validation and Formatting, What-if Analysis 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 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 Taylor Series Analysis: Finite Difference Derivative Approximation, Richardson s Extrapolation, Ridder s algorithm, Sensitivity 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 Optimization: Solver, Luus-Jaakola, Quadratic, Golden Section, Powell, Downhill Simplex, Firefly, Constraints, Scaling and Sensitivity Uncertainty and Risk Analysis: Bootstrap, Confidence Intervals, Law of Propagation, Monte Carlo Simulations with Latin Hypercube Sampling Least-squares Regression: Linear, Nonlinear, LINEST, Gauss-Newton, Levenberg-Marquardt, Validation and Assessment, Uncertainty Analysis, Weighted Regression Interpolation: Linear, Newton Divided Difference and Lagrange Polynomials, Rational, Bulirsh-Stoer, Pade, Stineman, Cubic, B, Akima and Constrained Hermite Splines, Bivariate Interpolation Integration: Graphical, Trapezoidal, Midpoint and transformation for Improper Integrals, Romberg, Adaptive Simpson and Gauss-Kronrod, Multiple Integrals by Simpson, Kronrod and Monte Carlo 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 Boundary-value Problems and Partial Differential Equations: Shooting, Finite Difference, Orthogonal Collocation, Quasilinearization, Method of Lines, Crank-Nicholson Review: Reference Tables of Excel and VBA Functions, User-defined Functions, Macros, User Forms. Nº de ref. de la librería APC9781502527400

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 60,87
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Davis, Richard A
Editorial: CreateSpace Independent Publishing Platform
ISBN 10: 1502527405 ISBN 13: 9781502527400
Nuevos PAPERBACK Cantidad: > 20
Librería
Russell Books
(Victoria, BC, Canada)
Valoración
[?]

Descripción CreateSpace Independent Publishing Platform. PAPERBACK. Estado de conservación: New. 1502527405 Special order direct from the distributor. Nº de ref. de la librería ING9781502527400

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 59,15
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 5,96
De Canada a Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Richard A Davis
Editorial: CreateSpace Independent Publishing Platform (2014)
ISBN 10: 1502527405 ISBN 13: 9781502527400
Nuevos Paperback Cantidad: 2
Impresión bajo demanda
Librería
Revaluation Books
(Exeter, Reino Unido)
Valoración
[?]

Descripción CreateSpace Independent Publishing Platform, 2014. Paperback. Estado de conservación: Brand New. 3rd edition. 600 pages. 11.00x8.50x1.36 inches. This item is printed on demand. Nº de ref. de la librería x-1502527405

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 68,70
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 6,80
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío