Examples of applications of equilibrium-based methods for multicomponent separations usually require the use of simulation packages, which do not allow students to follow the involved algorithms step by step. Excel spreadsheets with examples of six such rigorous methods have been used with MSc students of Chemical Engineering of the University of…

The benefits of using Microsoft Excel built-in functions in an undergraduate Multistage Separations course are analyzed based on 15 years of experience teaching mass transfer in Chemical Engineering programs at both the Bachelor's and Master's levels. Eight reasons for using spreadsheets in a Mass Transfer virtual course are given. Through the…

EXCEL spreadsheet algorithms were developed at Villanova University to efficiently and consistently retrieve information from ASPEN® flowsheets and used for grading work in senior design. The challenge is to take a large volume of data that is in the stream and unit operations reports and quickly and consistently calculate a list of key grading…

A sample class project utilizing Excel spreadsheets to develop a flash drum simulator is demonstrated. In addition to solving equations for mole and enthalpy balances, students are trained to carry out vapor-liquid equilibrium calculations. More importantly, students gain a solid understanding of the link between hand calculations and simulator…

Through the experiments described in this article, students become acquainted with the principles behind ternary liquid-liquid systems and/or Aqueous Two-Phase Systems (ATPS), and their characterization by the determination of the binodal curve, tie-lines, tie-line lengths and critical point, as well as in applying the non-random two-liquid model…

The objective of this work is to present a spreadsheet tool that illustrates an ideal case of dynamic matrix control (DMC) calculations. The ideal case presented in this work is a hypothetical single- input-single-output DMC control system for setpoint tracking, in the absence of disturbance and mismatch between the measured and predicted process…

This work aims to demonstrate the use of Excel spreadsheets for solving L-L extraction problems. The key to solving the problems successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the…

A simple classroom exercise is used to teach students about the law of propagation of uncertainty in experimental measurements and analysis. Students calculate the density of a rectangular wooden block with a hole from several measurements of mass and length using a ruler and scale. The ruler and scale give students experience with estimating…

A problem that illustrates two ways of computing the break-even radius of insulation is outlined. The problem is suitable for students who are taking an introductory module in heat transfer or transport phenomena and who have some previous knowledge of the numerical solution of non- linear algebraic equations. The potential for computer algebra,…

Phase thermodynamics is often perceived as a difficult subject with which many students never become fully comfortable. The Gibbsian geometrical framework can help students to gain a better understanding of phase equilibria. An exercise to interpret the vapor-liquid equilibrium of a binary azeotropic mixture, using the equilibrium condition based…

Chemical process simulation is one of the most fundamental skills that is expected from chemical engineers, yet relatively few graduates have the opportunity to learn, in depth, how a process simulator works, from programming the unit operations to the sequencing. The University of Calgary offers a "hands-on" postgraduate course in…

An Excel add-in--XSEOS--that implements several excess Gibbs free energy models and equations of state has been developed for educational use. Several traditional and modern thermodynamic models are available in the package with a user-friendly interface. XSEOS has open code, is freely available, and should be useful for instructors and students…

The outline for half of a one-credit-hour course in analysis of chemical engineering data is presented, along with a range of typical problems encountered later on in the chemical engineering curriculum that can be used to reinforce the data analysis skills learned in the course. This mini course allows students to be exposed to a variety of ChE…

Describes the development and instructional use of a Microsoft Excel spreadsheet template that facilitates analytical and Monte Carlo risk analysis of investment decisions. Discusses a variety of risk assessment methods followed by applications of the analytical and Monte Carlo methods. Uses a case study to illustrate use of the spreadsheet tool…

Described are the use of spreadsheet programs in chemical engineering calculations using Lotus 1-2-3 macros. Discusses the macro commands, subroutine operations, and solution of partial differential equation. Provides examples of the subroutine programs and spreadsheet solution. (YP)