Numerical methods for chemical engineers using Excel, VBA, and MATLAB. ([2013])

• Record Type: Book
• Further Information: Note: Victor J. Law.
• Authors: Law, Victor J
• Contents: Roots of a Single Nonlinear Equation; Introduction; Algorithms for Solving f (x ) = 0; Using Excel to Solve Nonlinear Equations (Goal Seek); A Note on In-Cell Iteration References; ; Visual Basic ® for Applications Programming; Introduction; Algorithm Design; VBA Coding; Example VBA Project; Getting Help and Documentation on VBA; VBA Statements and Features; Objects and OOP; Built-In Functions of VBA; Program Control; VBA Data Types; Subs and Functions; Input and Output; Array Data Structures; Alternative I/O Methods; Using Debugger; References; ; Linear Algebra and Systems of Linear Equations; Introduction; Notation; Vectors; Vector Operations; Matrices; Matrix Operations; Solving Systems of Linear Algebraic Equations; Linear Equations and Vector/Matrix Operations in Excel® ; More About Matrix.xla; SVD and Pseudo-Inverse of a Matrix; ; Numerical Differentiation and Integration; Numerical Differentiation; Numerical Integration; Curve Fitting for Integration; ; Ordinary Differential Equations (Initial Value Problems); Introduction; Euler-Type Methods; RK Methods; Stiff ODEs; Solving Systems of ODE-IVPs; Higher-Order ODEs; ; Ordinary Differential Equations (Boundary Value Problems); Introduction; Shooting Method; Split BVPs Using Finite Differences; More Complex Boundary Conditions with ODE-BVPs; Reference; ; Regression Analysis and Parameter Estimation; General Method of Least Squares; Linear Regression Analysis; How Good Is the Fit from a Statistical Perspective?; Regression Using Excel’s Regression Add-In; Numerical Differentiation and Integration Revisited; ; Partial Differential Equations; Introduction; Parabolic PDEs; Thomas Algorithm for Tridiagonal Systems; Method of Lines; Successive Overrelaxation for Elliptic PDEs; ; Linear Programming, Nonlinear Programming, Nonlinear Equations, and Nonlinear Regression Using Solver; Introduction; Linear Programming; Nonlinear Programming; Nonlinear Equations; Nonlinear Regression Analysis; ; Introduction to MATLAB® ; Introduction; MATLAB® Basics; MATLAB® Programming Language Statements; MATLAB® Function Arguments; Plotting in MATLAB® ; Example MATLAB® Programs; Closing Comment Regarding MATLAB® ; ; Appendix A: Additional Features of VBA; ; Index;
• Publisher Details: Boca Raton : CRC Press, Taylor & Francis Group
• Publication Date: 2013
• Copyright Date: 2013
• Extent: 1 online resource (xviii, 229 pages), illustrations
• Subjects: 660.02/12; Chemical engineering -- Mathematics -- Textbooks; Visual Basic for Applications (Computer program language); MATHEMATICS -- Applied; MEDICAL -- Biotechnology; SCIENCE -- Chemistry -- Industrial & Technical; Chemical engineering -- Mathematics; Electronic books; Textbooks
• Languages: English
• ISBNs: 9781628707465; 1628707461; 9781466575356; 1466575352; 9781482201598; 1482201593; 9781466579408; 1466579404; 9781466575363; 1466575360
• Related ISBNs: 9781466575349; 1466575344
• Notes: Note: Includes bibliographical references and index.; Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.