skip to main content
Alan Lane
  • Home
  • Excel
  • Tutorials
  • Discuss
  • Practice
  • Links
  • Wish List
  • Errata
  • Safety
  • Home
  • Excel
  • Tutorials
  • Discuss
  • Practice
  • Links
  • Wish List
  • Errata
  • Safety

Excel

Spreadsheets

Most awesome! You've found the Excel spreadsheets used in almost every book example. The analysis of equilibrium stage separation processes usually involves coupled, non-linear, algebraic equations: material and energy balances, phase equilibrium relationships, and miscellaneous process specifications. These can be tedious if not impossible to solve by hand. Fortunately, the Excel Solver tool uses efficient iterative methods to solve fairly complex problems. Please download these simulations and modify to your heart's delight! If you totally mess up a spreadsheet, you can always come back here and download it again.
Tool Box (Chapter 2)

PFDs, mole and energy balances, phase equilibrium, spreadsheets.
VLE Data

​VLE data for most chemicals used in the book or practice problems. These are generated using Raoult's law for ideal solutions and ChemCAD if not ideal.
Single Stage (Chapter 3)

Mathematical and graphical analysis of a single equilibrium stage.
Partial Evaporator (Chapter 4)

Single stage evaporator with energy balance.
Partial Condenser (Chapter 4)

Single stage condenser with energy balance.
Adiabatic Flash (Chapter 4)

Adiabatic flash pot with energy balance.
NIST (Chapter 4)

Single equilibrium stage with energy balance using NIST enthalpies.
Multiple Stages (Chapter 5)
Several equilibrium stages in series. I start with 2 stages without recycle, then with recycle, then five stages (all solved with the "brute force" method. Concept of "stepping off the stages" introduced.
Lewis (Chapter 6)

Stage by stage analysis of distillation column - Lewis method. This is a "new and improved" version that allows you to include mixed feeds.
McCabe-Thiele (Chapter 7)

Graphical design of distillation column - McCabe-Thiele method.
Rigorous (Chapter 8)

Stage by stage analysis of distillation column with energy balances.
Variations (Chapter 9)

Multiple feeds to a distillation column.
Open Steam (Chapter 9)

Direct steam injection instead of using a reboiler.
Side Stream (Chapter 9)

Multiple products from a distillation column.
mixed feed

   Similar to Excel "Lewis" except you can specify % liquid in feed.
BHO (Chapter 10)
Distillation of butane/hexane/octane. Several solution methods demonstrated. Note that in Example 10.1, I accidently switch to BTX notation but the results are correct. (See Errata)
BHOD (Chapter 10)

Distillation of butane, hexane, octane, and decane.
BTX (Chapter 10)

Distillation of benzene, toluene, o-xylene.
BTEX (Chapter 10)

Distillation of benzene, toluene, ethyl benzene, o-xylene.
EW (Chapter 11)

Distillation of non-ideal pair ethanol and water.
Absorber (Chapter 12/13)

Stage by stage analysis of absorbers.
Stripper (Chapter 12/13)

Stage by stage analysis of strippers.
Absorber Graphical (Chapter 14)

Graphical design of absorbers.
Stripper Graphical (Chapter 14)

Graphical design of strippers.
Absorber Rigorous (Chapter 15)

Rigorous design of absorber (adiabatic and multi-component).
Murphree (Chapter 16)

Estimation of required stages using Murphree efficiency.
Solvent Extraction (Chapter 17-19)
1, 2, 3-stage extraction of acetic acid from water using isopropyl acetate with a polynomial fit of LLE.
MTBE Extraction (17)
Single-stage extraction of acetic acid from water using methyl tert-butyl ether (MTBE). Generation of LLE graphs and polynomial equations is demonstrated.
NRTL (17)
Single-stage extraction of acetic acid from water using isopropyl acetate. LLE is generated using the NRTL activity coefficient.

Contact Us

Picture
Accessibility | Equal Opportunity | UA Disclaimer | Site Disclaimer | Privacy
Copyright © 2020 | The University of Alabama | Tuscaloosa, AL 35487 | (205) 348-6010
Website provided by the Center for Instructional Technology, Office of Information Technology