Download or read book Numerical Methods for Chemical Engineers Using Excel VBA and MATLAB written by Victor J. Law and published by CRC Press. This book was released on 2013-03-05 with total page 249 pages. Available in PDF, EPUB and Kindle. Book excerpt: While teaching the Numerical Methods for Engineers course over the last 15 years, the author found a need for a new textbook, one that was less elementary, provided applications and problems better suited for chemical engineers, and contained instruction in Visual Basic for Applications (VBA). This led to six years of developing teaching notes that

Download or read book Numerical Methods for Chemical Engineers Using Excel VBA and MATLAB written by Victor J. Law and published by CRC Press. This book was released on 2013-03-05 with total page 249 pages. Available in PDF, EPUB and Kindle. Book excerpt: While teaching the Numerical Methods for Engineers course over the last 15 years, the author found a need for a new textbook, one that was less elementary, provided applications and problems better suited for chemical engineers, and contained instruction in Visual Basic® for Applications (VBA). This led to six years of developing teaching notes that have been enhanced to create the current textbook, Numerical Methods for Chemical Engineers Using Excel®, VBA, and MATLAB®. Focusing on Excel gives the advantage of it being generally available, since it is present on every computer—PC and Mac—that has Microsoft Office installed. The VBA programming environment comes with Excel and greatly enhances the capabilities of Excel spreadsheets. While there is no perfect programming system, teaching this combination offers knowledge in a widely available program that is commonly used (Excel) as well as a popular academic software package (MATLAB). Chapters cover nonlinear equations, Visual Basic, linear algebra, ordinary differential equations, regression analysis, partial differential equations, and mathematical programming methods. Each chapter contains examples that show in detail how a particular numerical method or programming methodology can be implemented in Excel and/or VBA (or MATLAB in chapter 10). Most of the examples and problems presented in the text are related to chemical and biomolecular engineering and cover a broad range of application areas including thermodynamics, fluid flow, heat transfer, mass transfer, reaction kinetics, reactor design, process design, and process control. The chapters feature "Did You Know" boxes, used to remind readers of Excel features. They also contain end-of-chapter exercises, with solutions provided.

Download or read book Numerical Techniques for Chemical and Biological Engineers Using MATLAB written by Said S.E.H. Elnashaie and published by Springer Science & Business Media. This book was released on 2007-03-12 with total page 595 pages. Available in PDF, EPUB and Kindle. Book excerpt: This interdisciplinary book presents numerical techniques needed for chemical and biological engineers using Matlab. The book begins by exploring general cases, and moves on to specific ones. The text includes a large number of detailed illustrations, exercises and industrial examples. The book provides detailed mathematics and engineering background in the appendixes, including an introduction to Matlab. The text will be useful to undergraduate students in chemical/biological engineering, and in applied mathematics and numerical analysis.

Download or read book Numerical Methods for Chemical Engineers with MATLAB Applications written by A. Constantinides and published by Prentice Hall. This book was released on 1999 with total page 602 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master numerical methods using MATLAB, today's leading software for problem solving. This complete guide to numerical methods in chemical engineering is the first to take full advantage of MATLAB's powerful calculation environment. Every chapter contains several examples using general MATLAB functions that implement the method and can also be applied to many other problems in the same category. The authors begin by introducing the solution of nonlinear equations using several standard approaches, including methods of successive substitution and linear interpolation; the Wegstein method, the Newton-Raphson method; the Eigenvalue method; and synthetic division algorithms. With these fundamentals in hand, they move on to simultaneous linear algebraic equations, covering matrix and vector operations; Cramer's rule; Gauss methods; the Jacobi method; and the characteristic-value problem. Additional coverage includes: Finite difference methods, and interpolation of equally and unequally spaced points Numerical differentiation and integration, including differentiation by backward, forward, and central finite differences; Newton-Cotes formulas; and the Gauss Quadrature Two detailed chapters on ordinary and partial differential equations Linear and nonlinear regression analyses, including least squares, estimated vector of parameters, method of steepest descent, Gauss-Newton method, Marquardt Method, Newton Method, and multiple nonlinear regression The numerical methods covered here represent virtually all of those commonly used by practicing chemical engineers. The focus on MATLAB enables readers to accomplish more, with less complexity, than was possible with traditional FORTRAN. For those unfamiliar with MATLAB, a brief introduction is provided as an Appendix. Over 60+ MATLAB examples, methods, and function scripts are covered, and all of them are included on the book's CD

Download or read book Excel for Scientists and Engineers written by E. Joseph Billo and published by John Wiley & Sons. This book was released on 2007-03-16 with total page 480 pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package

Download or read book Introduction to Chemical Engineering Computing written by Bruce A. Finlayson and published by John Wiley & Sons. This book was released on 2012-07-31 with total page 415 pages. Available in PDF, EPUB and Kindle. Book excerpt: Step-by-step instructions enable chemical engineers to master key software programs and solve complex problems Today, both students and professionals in chemical engineering must solve increasingly complex problems dealing with refineries, fuel cells, microreactors, and pharmaceutical plants, to name a few. With this book as their guide, readers learn to solve these problems using their computers and Excel®, MATLAB, Aspen Plus, and COMSOL Multiphysics. Moreover, they learn how to check their solutions and validate their results to make sure they have solved the problems correctly. Now in its Second Edition, Introduction to Chemical Engineering Computing is based on the author's firsthand teaching experience. As a result, the emphasis is on problem solving. Simple introductions help readers become conversant with each program and then tackle a broad range of problems in chemical engineering, including: Equations of state Chemical reaction equilibria Mass balances with recycle streams Thermodynamics and simulation of mass transfer equipment Process simulation Fluid flow in two and three dimensions All the chapters contain clear instructions, figures, and examples to guide readers through all the programs and types of chemical engineering problems. Problems at the end of each chapter, ranging from simple to difficult, allow readers to gradually build their skills, whether they solve the problems themselves or in teams. In addition, the book's accompanying website lists the core principles learned from each problem, both from a chemical engineering and a computational perspective. Covering a broad range of disciplines and problems within chemical engineering, Introduction to Chemical Engineering Computing is recommended for both undergraduate and graduate students as well as practicing engineers who want to know how to choose the right computer software program and tackle almost any chemical engineering problem.

Download or read book Numerical Methods for Chemical Engineering written by Kenneth J. Beers and published by Cambridge University Press. This book was released on 2007 with total page 496 pages. Available in PDF, EPUB and Kindle. Book excerpt: Applications of numerical mathematics and scientific computing to chemical engineering.

Download or read book Problem Solving in Chemical Engineering with Numerical Methods written by Michael B. Cutlip and published by Prentice Hall. This book was released on 1999 with total page 502 pages. Available in PDF, EPUB and Kindle. Book excerpt: "A companion book including interactive software for students and professional engineers who want to utilize problem-solving software to effectively and efficiently obtain solutions to realistic and complex problems. An Invaluable reference book that discusses and Illustrates practical numerical problem solving in the core subject areas of Chemical Engineering. Problem Solving in Chemical Engineering with Numerical Methods provides an extensive selection of problems that require numerical solutions from throughout the core subject areas of chemical engineering. Many are completely solved or partially solved using POLYMATH as the representative mathematical problem-solving software, Ten representative problems are also solved by Excel, Maple, Mathcad, MATLAB, and Mathematica. All problems are clearly organized and all necessary data are provided. Key equations are presented or derived. Practical aspects of efficient and effective numerical problem solving are emphasized. Many complete solutions are provided within the text and on the CD-ROM for use in problem-solving exercises."--BOOK JACKET.Title Summary field provided by Blackwell North America, Inc. All Rights Reserved

Download or read book Advanced Excel for Scientific Data Analysis written by Robert De Levie and published by Oxford University Press, USA. This book was released on 2004 with total page 631 pages. Available in PDF, EPUB and Kindle. Book excerpt: This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).

Download or read book Optimization Concepts and Applications in Engineering written by Ashok D. Belegundu and published by Cambridge University Press. This book was released on 2011-03-28 with total page 481 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this revised and enhanced second edition of Optimization Concepts and Applications in Engineering, the already robust pedagogy has been enhanced with more detailed explanations, an increased number of solved examples and end-of-chapter problems. The source codes are now available free on multiple platforms. It is vitally important to meet or exceed previous quality and reliability standards while at the same time reducing resource consumption. This textbook addresses this critical imperative integrating theory, modeling, the development of numerical methods, and problem solving, thus preparing the student to apply optimization to real-world problems. This text covers a broad variety of optimization problems using: unconstrained, constrained, gradient, and non-gradient techniques; duality concepts; multiobjective optimization; linear, integer, geometric, and dynamic programming with applications; and finite element-based optimization. It is ideal for advanced undergraduate or graduate courses and for practising engineers in all engineering disciplines, as well as in applied mathematics.

Download or read book Numerical Methods with VBA Programming written by James Hiestand and published by Jones & Bartlett Publishers. This book was released on 2008-12-26 with total page 302 pages. Available in PDF, EPUB and Kindle. Book excerpt: Numerical Methods with VBA Programming provides a unique and unified treatment of numerical methods and VBA computer programming, topics that naturally support one another within the study of engineering and science. This engaging text incorporates real-world scenarios to motivate technical material, helping students understand and retain difficult and key concepts. Such examples include comparing a two-point boundary value problem to determining when you should leave for the airport to catch a scheduled flight. Numerical examples are accompanied by closed-form solutions to demonstrate their correctness. Within the programming sections, tips are included that go beyond language basics to make programming more accessible for students. A unique section suggest ways in which the starting values for non-linear equations may be estimated. Flow charts for many of the numerical techniques discussed provide general guidance to students without revealing all of the details. Useful appendices provide summaries of Excel and VBA commands, Excel functions accessible in VBA, basics of differentiation, and more!

Download or read book Introduction to Modeling and Numerical Methods for Biomedical and Chemical Engineers written by Edward Gatzke and published by Springer Nature. This book was released on with total page 292 pages. Available in PDF, EPUB and Kindle. Book excerpt: This textbook introduces the concepts and tools that biomedical and chemical engineering students need to know in order to translate engineering problems into a numerical representation using scientific fundamentals. Modeling concepts focus on problems that are directly related to biomedical and chemical engineering. A variety of computational tools are presented, including MATLAB, Excel, Mathcad, and COMSOL, and a brief introduction to each tool is accompanied by multiple computer lab experiences. The numerical methods covered are basic linear algebra and basic statistics, and traditional methods like Newton's method, Euler Integration, and trapezoidal integration. The book presents the reader with numerous examples and worked problems, and practice problems are included at the end of each chapter. Focuses on problems and methods unique to biomedical and chemical engineering; Presents modeling concepts drawn from chemical, mechanical, and materials engineering; Ancillary materials include lecture notes and slides and online videos that enable a flipped classroom or individual study.

Download or read book Numerical Methods for Large Eigenvalue Problems written by Yousef Saad and published by SIAM. This book was released on 2011-01-01 with total page 292 pages. Available in PDF, EPUB and Kindle. Book excerpt: This revised edition discusses numerical methods for computing eigenvalues and eigenvectors of large sparse matrices. It provides an in-depth view of the numerical methods that are applicable for solving matrix eigenvalue problems that arise in various engineering and scientific applications. Each chapter was updated by shortening or deleting outdated topics, adding topics of more recent interest, and adapting the Notes and References section. Significant changes have been made to Chapters 6 through 8, which describe algorithms and their implementations and now include topics such as the implicit restart techniques, the Jacobi-Davidson method, and automatic multilevel substructuring.

Download or read book A Step by Step Approach to the Modeling of Chemical Engineering Processes written by Liliane Maria Ferrareso Lona and published by Springer. This book was released on 2017-12-15 with total page 183 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book treats modeling and simulation in a simple way, that builds on the existing knowledge and intuition of students. They will learn how to build a model and solve it using Excel. Most chemical engineering students feel a shiver down the spine when they see a set of complex mathematical equations generated from the modeling of a chemical engineering system. This is because they usually do not understand how to achieve this mathematical model, or they do not know how to solve the equations system without spending a lot of time and effort. Trying to understand how to generate a set of mathematical equations to represent a physical system (to model) and solve these equations (to simulate) is not a simple task. A model, most of the time, takes into account all phenomena studied during a Chemical Engineering course. In the same way, there is a multitude of numerical methods that can be used to solve the same set of equations generated from the modeling, and many different computational languages can be adopted to implement the numerical methods. As a consequence of this comprehensiveness and combinatorial explosion of possibilities, most books that deal with this subject are very extensive and embracing, making need for a lot of time and effort to go through this subject. It is expected that with this book the chemical engineering student and the future chemical engineer feel motivated to solve different practical problems involving chemical processes, knowing they can do that in an easy and fast way, with no need of expensive software.

Download or read book Chemical Engineering Computation with MATLAB written by Yeong Koo Yeo and published by CRC Press. This book was released on 2020-12-15 with total page 849 pages. Available in PDF, EPUB and Kindle. Book excerpt: Chemical Engineering Computation with MATLAB®, Second Edition continues to present basic to advanced levels of problem-solving techniques using MATLAB as the computation environment. The Second Edition provides even more examples and problems extracted from core chemical engineering subject areas and all code is updated to MATLAB version 2020. It also includes a new chapter on computational intelligence and: Offers exercises and extensive problem-solving instruction and solutions for various problems Features solutions developed using fundamental principles to construct mathematical models and an equation-oriented approach to generate numerical results Delivers a wealth of examples to demonstrate the implementation of various problem-solving approaches and methodologies for problem formulation, problem solving, analysis, and presentation, as well as visualization and documentation of results Includes an appendix offering an introduction to MATLAB for readers unfamiliar with the program, which will allow them to write their own MATLAB programs and follow the examples in the book Provides aid with advanced problems that are often encountered in graduate research and industrial operations, such as nonlinear regression, parameter estimation in differential systems, two-point boundary value problems and partial differential equations and optimization This essential textbook readies engineering students, researchers, and professionals to be proficient in the use of MATLAB to solve sophisticated real-world problems within the interdisciplinary field of chemical engineering. The text features a solutions manual, lecture slides, and MATLAB program files._

Download or read book Numerical Methods for Engineers and Scientists written by Amos Gilat and published by John Wiley & Sons. This book was released on 2008 with total page 490 pages. Available in PDF, EPUB and Kindle. Book excerpt: Following a unique approach, this innovative book integrates the learning of numerical methods with practicing computer programming and using software tools in applications. It covers the fundamentals while emphasizing the most essential methods throughout the pages. Readers are also given the opportunity to enhance their programming skills using MATLAB to implement algorithms. They'll discover how to use this tool to solve problems in science and engineering.

Download or read book Numerical Calculation for Physics Laboratory Projects Using Microsoft EXCEL written by Shinil Cho and published by Morgan & Claypool Publishers. This book was released on 2019-10-31 with total page 162 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book covers essential Microsoft EXCEL®'s computational skills while analyzing introductory physics projects. Topics of numerical analysis include; multiple graphs on the same sheet, calculation of descriptive statistical parameters, a 3-point interpolation, the Euler and the Runge-Kutter methods to solve equations of motion, the Fourier transform to calculate the normal modes of a double pendulum, matrix calculations to solve coupled linear equations of a DC circuit, animation of waves and Lissajous figures, electric and magnetic field calculations from the Poisson equation and its 3D surface graphs, variational calculus such as Fermat's least traveling time principle and the least action principle. Nelson's stochastic quantum dynamics is also introduced to draw quantum particle trajectories.