O'Reilly logo

Separation Process Engineering: Includes Mass Transfer Analysis, Third Edition by Phillip C. Wankat

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

2.B.1 Regression of Binary VLE with Excel

McCabe-Thiele calculations are easiest to do on spreadsheets if the y versus x VLE data are expressed in an equation. The form y = f(x) is most convenient for flash distillation and for distillation columns (see Chapter 4) if stepping off stages from the bottom of the column up. The form x = g(y) is most convenient for distillation columns if stepping off stages from the top down. Built-in functions in Excel will determine polynomials that fit the data, although the fit will usually not be perfect. This will be illustrated for fitting the ethanol-water equilibrium data in Table 2-1 in the form yE = f (xE). (Note: An additional data point xE = 0.5079, yE = 0.6564 was added to the numbers in the table.) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required