Numerical Calculations for Process Engineering Using Excel VBA provides numerical treatment of process engineering problems with VBA programming and Excel spreadsheets. The problems are solving material and energy balances, optimising reactors and modelling multiple-factor processes. The book includes both basic and advanced codes for numerical calculations. The basic methods are presented in different variations tailored to particular applications. Some macros are combined with each other to solve engineering problems. Examples include combining the bisection method and binary search to optimise an implicit correlation, combining golden section search with Euler’s method to optimise a reactor and combining bisection code and Euler’s method to solve steady-state heat distribution. The text also includes nonconventional examples such as harmony search and network analysis. The examples include solutions to common engineering problems such as adiabatic flame temperature, plug flow reactor conversion, batch reactor, heat diffusion and pinch analysis of heat exchanger networks. The VBA code is presented with mathematical equations and flowcharts, enabling the audience to adopt the solutions to different problems. The book contains many demonstrations of numerical techniques to guide users. It also includes useful summaries of VBA commands/functions and Excel-predefined functions accessible in VBA. While the book is developed primarily for undergraduate students, the book is a helpful resource for postgraduate students and engineers.

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.

"Numerical calculations for process engineering using Excel/VBA provides numerical treatment of process engineering problems with VBA programming and Excel spreadsheets. The problems are solving material & energy balances, optimising reactors and modelling multiple-factor processes. The book includes both basic and advanced codes for numerical calculations. The basic methods were presented in different variations tailored to particular applications. Some macros are combined with each other's to solve engineering problems. Examples include combining the bisection method and binary search to optimise an implicit correlation, combining golden section search with Euler's method to optimise a reactor, and combining bisection code and Euler's method to solve steady-state heat distribution. The text also includes non-conventional examples such as harmony search and network analysis. The examples include solutions to common engineering problems such as adiabatic flame temperature, plug flow reactor conversion, batch reactor, heat diffusion and pinch analysis of heat exchanger networks. The VBA codes are presented with mathematical equations and flowcharts, enabling the audience to adopt the solutions to different problems. The book contains many demonstrations of numerical techniques to guide users. It also includes useful summaries of VBA commands/functions and Excel-predefined functions accessible in VBA. While the book is developed with a primary aim for undergraduate students, the book is a helpful resource for postgraduate students and engineers"--

This work contains edited papers from the Fourth Conference on the Foundations of Computer-aided Process Design.

The Definitive, Up-to-Date, Student-Friendly Guide to Separation Process Engineering—With More Mass Transfer Coverage and a New Chapter on Crystallization Separation Process Engineering, Fourth Edition, is the most comprehensive, accessible guide available on modern separation processes and the fundamentals of mass transfer. In this completely updated edition, Phillip C. Wankat teaches each key concept through detailed, realistic examples using real data—including up-to-date simulation practice and spreadsheet-based exercises. Wankat thoroughly covers each separation process, including flash, column, and batch distillation; exact calculations and shortcut methods for multicomponent distillation; staged and packed column design; absorption; stripping; and more. This edition provides expanded coverage of mass transfer and diffusion, so faculty can cover separations and mass transfer in one course. Detailed discussions of liquid-liquid extraction, adsorption, chromatography, and ion exchange prepare students for advanced work. Wankat presents coverage of membrane separations, including gas permeation, reverse osmosis, ultrafiltration, pervaporation, and applications. An updated chapter on economics and energy conservation in distillation adds coverage of equipment costs. This edition contains more than 300 new, up-to-date homework problems, extensively tested in undergraduate courses at Purdue University and the University of Canterbury (New Zealand). Coverage includes New chapter on crystallization from solution, including equilibrium, chemical purity, crystal size distribution, and pharmaceutical applications Thirteen up-to-date Aspen Plus process simulation labs, adaptable to any simulator Eight detailed Aspen Chromatography labs Extensive new coverage of ternary stage-by-stage distillation calculations Fraction collection and multicomponent calculations for simple batch distillation New mass transfer analysis sections on numerical solution for variable diffusivity Mass transfer to expanding or contracting objects, including ternary mass transfer Expanded coverage of pervaporation Updated Excel spreadsheets offering more practice with distillation, diffusion, mass transfer, and membrane separation problems

Learn to program and design user interfaces using Excel 2007. This introductory text explains how to develop programs using VBA within the Microsoft Excel environment. The text does not assume any previous programming experience. The new edition has been revised to bring it up-to-date with the Office 2007 environment. MARKET For students and professionals in General Engineering or Computer Science fields.

Accompanied by CD-ROM: Simulation of process flowsheets.