Membrane Separations Technology: Single-Stage, Multistage, and Differential Permeation

The objective is to determine the membrane area for concurrent flow where the feedstream F = L 1 is at its bubble point; that is, where V 1 = 0.
This procedure may be modified to accept a positive value for V 1 other than zero and a composition ( y 1) i. This composition would be entered at E7 = O7 and copied for the entire column. Columns K through R would be left blank, although column O would be made equal to column E.
| Column | Equation or Designator | Spreadsheet Formula |
|---|---|---|
| A | L 1 = F | (fixed) |
| B | V 1 | (fixed) |
| C | ( x 1) i = ( x F) i | (fixed) |
| D | ( x 1) j = (( x F) j | (fixed) |
| E | ( y 1) i via bubble-point determination for L 1 | =O5 |
| F | Skip | |
| G | P i | (given) |
| H | P j | (given) |
| I | P L | (fixed) |
| J | P V | (fixed) |
| K | Skip | |
| L | V ? | (trial and error) |
| M | K i = P iP L/( V ? + P iP V) | G7*17/(L7+G7*J7) |
| N | K j = P jP i/( V ? + P jP v) | H7*17/L7+H7*J7) |
| O | y i = K ix i, where it also follows that y i |