recent
أخبار ساخنة

# Numerical methods for chemical engineers using Excel, VBA, and MATLAB by VICTOR J. LAw pdf download

Numerical methods for chemical engineers using Excel, VBA, and MATLAB by VICTOR J. LAw pdf.

Numerical methods for chemical engineers using Excel, VBA, and MATLAB by VICTOR J. LAw free pdf download.

Contents:
Chapter 1 Roots of a Single Nonlinear Equation
Chapter 2 Visual Basic® for Applications Programming
Chapter 3 Linear Algebra and Systems of Linear Equations
Chapter 4 Numerical Differentiation and Integration
Chapter 5 Ordinary Differential Equations (Initial Value Problems)
Chapter 6 Ordinary Differential Equations (Boundary Value Problems)
Chapter 7 Regression Analysis and Parameter Estimation
Chapter 8 Partial Differential Equations
Chapter 9 Linear Programming, Nonlinear Programming, Nonlinear Equations, and Nonlinear Regression Using Solver
Chapter 10 Introduction to MATLAB®

This book has been written using notes developed for the course Numerical Methods for Chemical Engineers at Tulane University. The author has written two previous textbooks: one on FORTRAN® programming and one using the language Pascal. On a personal note, when I completed the Pascal book, I asked my wife to break my fingers if I ever decided to write another book! Well, that was a long time ago, and having been granted a sabbatical leave to write this book, my wife decided that she would look the other way.

While there are many textbooks whose title would indicate that they are suitable for the course Numerical Methods for Chemical Engineers, every one that has been tried has been a failure in one way or another. Either they were too elementary and the applications and problems were not ideal or they did not offer instruction in Excel® and Visual Basic® for Applications (VBA). This led to the development, over a 6-year period, of detailed notes to be used in place of a textbook. These notes have been enhanced and put into textbook form to produce the present book.

The primary reason for using Excel is that it is generally available software, and it comes with every computer system (both PC and Mac) with Microsoft Office® installed. VBA is a programming environment that comes with Excel and greatly enhances the capabilities of basic Excel spreadsheets. It is available on systems running Microsoft operating systems and Mac OS. Beware, however, that VBA is available only on the latest (2011) version of Microsoft Office for the Mac. Other programming software systems that are often used in chemical and biomolecular engineering numerical methods courses are the following:
MATLAB®
Mathematica®
C/C++
FORTRAN
PolyMath
C/C++ and FORTRAN are compiler-based programming languages. Courses that deal with them must devote large amounts of time to learning the language itself rather than emphasizing problem solving.

The first three examples are programming environments with relatively easyto-use interfaces. Mathematica and MathCad offer powerful built-in methods for solving many common problem types, and both are particularly suited to symbolic problem solving (such as performing analytical differentiation or integration and solving differential equations). MATLAB is by far the most popular of the “proprietary” packages, and at least two textbooks have been written that combine chemical engineering problem solving with the MATLAB system. A significant difficulty with using MATLAB is that it requires rather expensive licenses. In all likelihood, MATLAB will not be available to practicing engineers in industry. This adds to the attractiveness of using Excel with VBA.

PolyMath is a specialized software package and has its roots in academia. It is especially suitable for a number of chemical engineering applications, and at least one textbook has been written using PolyMath as the base programming tool.

Obviously, there is no panacea when choosing which programming system to use, and any choice will have both backers and detractors. As a compromise, MATLAB is introduced in the last chapter of this text. This introduction is sufficient for students to grasp the basics of MATLAB and how it differs from using Excel and VBA.

Also, MATLAB programming is easily mastered by those who know VBA. The vast majority of problems presented in this text, including in-class examples, homework problems, and exam problems, are related to chemical and biomolecular engineering. Application areas include (but are not limited to)
Material and energy balances
Thermodynamics
Fluid flow
Heat transfer
Mass transfer
Reaction kinetics (including biokinetics)
Reactor design and reaction engineering
Process design
Process control
In the course taught by the author, exams (including most of the final exam) are of the “take-home” variety. It is not practical to give a timed, in-class exam when numerical methods and using a computer are involved. In order to encourage individual work, each student is given a unique set of input data so that no two students are expected to get the same “answers.”

In the text, when mentioning a topic for which there is neither time nor space to elaborate, the statement “Google it” appears. This is not a plug for any specific search engine but an easy way for the author to suggest getting more information if the reader’s interest is sparked. Another feature is the use of “Did You Know” boxes.

Related books:

Download Numerical methods for chemical engineers using Excel, VBA, and MATLAB by VICTOR J. LAw in free pdf format.
Ahmed Elsyed