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,713,388.61 | Books Available: 747,703 | Members Online: 35

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, 2nd Edition

Practical Numerical Methods for Chemical Engineers Using Excel with VBA 2nd Edition
Author: Richard A. Davis

Practical Numerical Methods (2nd edition) introduces computational techniques for solving numerical problems. Chemical engineers, scientists, and engineers from other disciplines will find the coverage of computational tools applicable to a wide variety of problems in their own disciplines. The selection of software for implementing numerical... more » methods reflects the current status of Excel as the de facto standard computational tool used by practicing engineers. Engineers and scientists should become proficient at extending Excel?s capabilities with Visual Basic for Applications (VBA) programs to boost their Excel worksheets with time saving enhancements and powerful numerical techniques. Coverage of topics includes an introduction to modeling, the basics of Excel and VBA programming, root-finding for linear and nonlinear systems of equations, multivariate optimization, experimental uncertainty propagation and analysis, linear and non-linear least-squares regression and model validation, interpolation, integration, and ordinary and partial differential equations. A companion web site has down-loadable digital files for over 160 illustrations and examples and more than 60 VBA user-defined functions and macros for advanced numerical techniques. Practice problems are also available from the web site (http://www.d.umn.edu/~rdavis/PNM/PNMExcelVBA2/). Example files and macros may be modified by the user to solve new problems. The first chapter also includes a brief introduction to chemical reaction engineering that provide the background needed for problems involving mass and energy balances with reactions. Two chapters introduce frequently overlooked features of Excel and VBA programming for applying numerical methods in Excel, as well as documenting results (versions Excel 2007, 2010, and 2013 and higher) The remaining chapters present powerful numerical techniques using Excel and VBA, including: * General Methods: Wichmann-Hill pseudo-random number generation, Heap Sorting, formula plotting, Random Sampling * Roots of Linear Equations: Gaussian Elimination, Crout Reduction, Thompson's method for tridiagonal matrices, Cholesky for symmetric matrices, Matrix algebra, Jacobi and Gauss-Seidel Iteration, and Steffenson's method * Roots of Nonlinear Equations: Fixed-Point Ordinary Iteration (Successive Substitution), Bisection, Secant, Regula Falsi, Newton and Quasi-Newton, Continuation (homotopy), Goal Seek, Solver, and Bairstow's method for polynomials * Derivative Approximation: Finite Difference, Richardson's extrapolation, Jacobian, Sensitivity Analysis, Lagrange polynomials, and piecewise polynomial Splines * Uncertainty Analysis: Jitter method for the Law of Propagation of Uncertainty, Monte Carlo with Latin-Hypercube sampling, and Jackknife for regression parameter uncertainty * Optimization: Graphical, Quadratic with acceleration, Powell, Golden Section, Luus-Jaakola, Solver (for linear and nonlinear programming), and parameter Scaling * Least-squares Regression: Regression Analysis for multivariate linear models, Gauss-Newton, Levenberg-Marquardt, Solver, Optimization methods, and Rational least-squares * Interpolation: Linear, Newton divided difference, La Grange, Rational, Stineman, Cubic Spline, Constrained Splines, and data Smoothing. * Integration: Trapezoidal, Midpoint, Romberg, Simpson, Adaptive Gauss-Kronrod, Splines, and multiple integration, including Monte Carlo * Initial-Value ODEs: Single step Euler, implicit Trapezoid for stiff problems, Modified Euler, Fourth-order Runge-Kutta, Cash-Karp, Merson, Fehlberg, Dormand-Prince, and Adams-Bashforth-Moulton multistep methods * Boundary Value ODEs and PDEs: Shooting, Finite Difference, Collocation on Finite Elements, Method of Lines, and semi-implicit Crank-Nicholson methods * Tables of Excel and VBA functions for numerical methods and summaries of the VBA macros are included as appendices for quick reference

ISBN-13: 9781482070125
ISBN-10: 148207012X
Publication Date: 9/25/2013
Pages: 598
Edition: 2
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, 2nd Edition

Loading...