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

17.A.3 Countercurrent Flow Spreadsheet and VBA Program

This calculation is trial-and-error since yr,N must be guessed. A loop using Eq. (17-78) to converge on the correct value for yr,N is used with an arbitrary number of trials M (in this example M = 5). The spreadsheet inputs the required values. All calculations of the equations in Section 17.7.4 are done in the Visual Basic program. The spreadsheet is shown with values for the separation of oxygen and nitrogen in Example 17-11. Note that a very poor first guess for yr,N = 0.001 (not shown here) converged with M = 10 to the correct yin.

Image

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