Text Home

Computer Programs

General Supplements

Instructor Supplements

Introductory Chemical Engineering Thermodynamics

J.R. Elliott
C. T. Lira

Prentice-Hall International Series in the Physical and Chemical Engineering Sciences ISBN (0-13-011386-7)


Hints on Binary and Ternary LLE using Excel

If the K values all go to unity or if you get some negative numbers that cause the iterations to crash, then the problem is usually that the initialization was not done properly.

If you are having problems with the iterations it is due to:
1) wrong procedure - unlikely if you have followed the procedure carefully.
2) wrong formula somewhere - unlikely since the formulas are simple to program.
3) wrong copy and paste steps - be careful to follow the instructions about pasting VALUES. Other than that the procedure is pretty straightforward.
4) POOR INITIALIZATION - This is the most common problem, and the easiest to fix. Although it is blame one of the the first three possible problems, initialization is usually the problem. After the first coexisting compositions have been found for particular system, you rarely have to reinitialize the compositions in the activity coefficient table, but you almost always have to reintialize the Kold values when the compositions change.

INITIALIZATION. This discussion is constructed for a system where components 1 and 2 have limited miscibility. After you set up a system by changing the components, be sure to initialize it by starting with one phase pure component 1, the OTHER phase pure component 2, and it is usually ok to add a little (1 mole%) of component 3. ONE MORE IMPORTANT POINT. Then update the Kold values by pasting VALUES of the Knew values. If you try to start off without updating the Kold values the very first step can be really way off, and the iterations may never recover.


lira@egr.msu.edu

updated 4/20/05 ,Copyright © 2000-5, Carl T. Lira, J. Richard Elliott. All rights reserved.