Phase Envelope
Spreadsheet
21 rows x 6 columns
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Phase Envelope | |||||
| 2 | Peng-Robinson EoS | |||||
| 3 | ||||||
| 4 | Property Table | |||||
| 5 | Component | Tc (K) | Pc (Pa) | omega | Mw (kg/mol) | zi |
| 6 | methane | 190.56 | 4599000 | 0.011 | 0.01604 | 0.7 |
| 7 | ethane | 305.32 | 4872000 | 0.099 | 0.03007 | 0.15 |
| 8 | propane | 369.83 | 4248000 | 0.152 | 0.0441 | 0.1 |
| 9 | n-butane | 425.12 | 3796000 | 0.2 | 0.05812 | 0.05 |
| 10 | ||||||
| 11 | Special Points | |||||
| 12 | Cricondenbar P | 9638354.592 | Pa | |||
| 13 | Cricondenbar T | 265.5097677 | K | |||
| 14 | Cricondentherm T | 297.7702066 | K | |||
| 15 | Cricondentherm P | 5965514.257 | Pa | |||
| 16 | Critical P | 9638354.592 | Pa | |||
| 17 | Critical T | 265.5097677 | K | |||
| 18 | ||||||
| 19 | Bubble Curve | Dew Curve | ||||
| 20 | T (K) | P (Pa) | T (K) | P (Pa) | ||
| 21 | 115.116934 | 100000 | 216.1550226 | 100000 |
Description
Generates a phase envelope (P-T diagram boundaries) for a natural gas mixture using Peng-Robinson EoS. Returns:
- Bubble curve (T, P arrays): boundary where liquid begins to vaporize
- Dew curve (T, P arrays): boundary where vapor begins to condense
- Special points: cricondenbar (max P), cricondentherm (max T), critical point
The array outputs (bubble_T, bubble_P, etc.) can be used directly for charting in Excel.
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Phase Envelope
- Click on the blueprint to preview the spreadsheet template
- Click Insert to place it into your worksheet. Modify the input values to match your data.