We see that javascript is disabled or not supported by your browser - javascript is needed for important actions on the site. Read more

What's New - Home - Login

Member $avings: $81,648,224.56 | Books Available: 769,195 | Members Online: 120

Swap Used Books - Buy New Books at Great Prices!

How To Swap Books Sign Up Search submenu

PBS Market (New Books)

Gift Buying Guide

Book Browser Advanced Search Books Posted Today Member Book Reviews Award Winning Books NYT Best Sellers Amazon Best Sellers Most Traveled Copies Club Wish List

Discussion Forums Book Lists

Club Lists My Book Lists My Watched Lists Create a List

Blog Donations

School Donation Program In Memory of... Military Donation Program Friends of PBS

Box-O-Books Maps The Eclectic Pen Fun Stuff

20 Questions Sudoku Bookmark Creator

Top 100

Requests Posts Swappers Referrers Reviewers

Pulse of PBS Spread The Word

Invite Friends Bookmarks Facebook Page Facebook App More Ways...

Photo Gallery Recipes Club Tag Cloud Member Testimonials

Help Center submenu

How To Swap Books Browse Help Docs Ask the Librarian PBS Member Icons Live Help

Kiosk

PBS Market (New Books) Go Shopping Buy Credits Buy PBS Money Upgrade Membership Gift Certificates Transfer Credits

Need Help?

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

Practical Numerical Methods for Chemical Engineers Using Excel with VBA 3rd Edition
Author: Richard A Davis

This latest 3rd edition has all of the features that users loved about the earlier editions, and expands the breadth of Practical Numerical Methods with more VBA macros to extend Excel's power for modeling & analysis. Engineers and scientists will find the enhanced coverage of computational tools applicable to a wider variety of problems in the... more »ir 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, Excel & VBA programming, root-finding for systems of equations, optimization, experimental uncertainty propagation, least-squares regression & model validation, interpolation, integration, & ordinary and partial differential equations. ** A companion web site has links to digital files for downloading up to 200 illustrations, examples & the refined PNM3Suite workbook with more than 100 VBA user-defined functions, macros, & user forms for advanced numerical techniques. Practice problems are also available from the web site (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, User Forms, Pseudo-random Number Generation, Sorting, Formula Graphing & Evaluation, Random Sampling ** 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, 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: multivariable linear and nonlinear models, Gauss-Newton, Levenberg-Marquardt, and Monte Carlo methods 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 methods.

ISBN-13: 9781502527400
ISBN-10: 1502527405
Publication Date: 10/2/2014
Pages: 600
Edition: 3
Rating:

0 stars, based on 0 rating

Publisher: CreateSpace Independent Publishing Platform
Book Type: Paperback
Members Wishing: 0
Reviews: Amazon | Write a Review

Genres:

Chemical

Back to the Top ↑

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

Loading...