![]() ![]() Use this book to become proficient with VBA programming and boost your worksheets with time saving enhancements and powerful numerical techniques found in specialized applications. The student 3rd edition builds on the popular success of earlier versions to expand the breadth of Practical Numerical Methods with more VBA macros that extend Excel's power for modeling and analysis.Įxcel is the computational tool most used by practicing engineers and scientists. Review: Summary Tables of Excel & VBA Functions, User-defined Functions, Macros, User Forms.Boundary-value Problems & Partial Differential Equations: Shooting, Finite Difference, Orthogonal Collocation, Quasilinearization, Method of Lines, Crank-Nicholson.Initial-value Problems: Single Step Euler & Backward Euler, Implicit Trapezoidal, Variable Step Runge-Kutta Cash Karp, Dormand-Prince, Multi-step Adams-Bashforth-Moulton, Differential-Algebraic Systems.Integration: Graphical, Trapezoidal, Midpoint for Improper Integrals, Romberg, Adaptive Simpson & Gauss-Kronrod, Multiple Integrals by Guass-Kronrod & Monte Carlo.Interpolation: Linear, Newton Divided Difference & Lagrange Polynomials, Rational, Stineman, Cubic & Constrained Splines, Linear & Spline Bivariate.Least-squares Regression: Linear & Nonlinear, LINEST, Gauss-Newton, Levenberg-Marquardt, Model Validation & Assessment, Parameter Uncertainty, Weighted Regression.Uncertainty Analysis: Law of Propagation, Monte Carlo Simulations with Latin Hypercube Sampling.Optimization: Solver, Luus-Jaakola, Quadratic Interpolation, Golden Section, Powell, Constraints, Scaling.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.Taylor Series Analysis: Finite Difference Derivative Approximations, Richardson's Extrapolation.Linear Equations: Matrix Algebra, Gaussian Elimination & Crout Reduction with Pivoting, Thomas, Cholesky, Power, Jacobi, & Interpolation Method for Eigenvalues & Eigenvectors, Jacobi & Gauss-Seidel Iteration, Relaxation.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.Introduction to Excel: Documentation, Graphing, Worksheet Functions, Validation & Formatting, What-if Analysis.Introduction to Numerical Methods & Mathematical Modeling.The remaining chapters present powerful numerical techniques using Excel & VBA. The next two chapters cover frequently overlooked features of Excel and VBA for engineering programming to apply numerical methods in Excel, as well as document results. The introduction includes a primer on chemical reaction engineering for problems involving mass and energy balances with reactions. Practice problems are available for each chapter at the web site (Example files and macros are ready to be modified by users for their own needs. Topics include an introduction to modeling, Excel and VBA programming, root-finding for systems of linear and nonlinear equations, eigenproblems, derivative approximation, optimization, experimental uncertainty analysis, least-squares regression and model validation, interpolation, integration, and ordinary & partial differential equations.Ī companion web site has digital files for downloading 200 illustrations, examples, and the refined PNM3Suite workbook with 120 VBA user-defined functions, macros, and user forms for advanced numerical techniques. Use this book to become proficient with VBA programming and boost your worksheets with time saving enhancements and powerful numerical techniques. Engineers and scientists will find the enhanced coverage of computational tools applicable to a wider variety of problems in their own disciplines.Įxcel is the de facto computational tool used by practicing engineers and scientists. The 3rd edition builds on the popular success of earlier versions to expand the breadth of Practical Numerical Methods with more VBA macros that extend Excel's power for modeling and analysis. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |