Fluid Model Setup
Spreadsheet
17 rows x 6 columns
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Fluid Model Setup | |||||
| 2 | Property Table | |||||
| 3 | ||||||
| 4 | Component | Tc (K) | Pc (Pa) | omega | Mw (kg/mol) | zi |
| 5 | nitrogen | 126.2 | 3400000 | 0.037 | 0.02801 | 0.02 |
| 6 | CO2 | 304.21 | 7383000 | 0.224 | 0.04401 | 0.01 |
| 7 | methane | 190.56 | 4599000 | 0.011 | 0.01604 | 0.6 |
| 8 | ethane | 305.32 | 4872000 | 0.099 | 0.03007 | 0.08 |
| 9 | propane | 369.83 | 4248000 | 0.152 | 0.0441 | 0.05 |
| 10 | n-butane | 425.12 | 3796000 | 0.2 | 0.05812 | 0.04 |
| 11 | n-pentane | 469.7 | 3370000 | 0.252 | 0.07215 | 0.03 |
| 12 | n-hexane | 507.6 | 3025000 | 0.301 | 0.08618 | 0.02 |
| 13 | C7 (SCN) | 547.5555556 | 3124014.397 | 0.28 | 0.096 | 0.15 |
| 14 | ||||||
| 15 | Mixture Properties | |||||
| 16 | Sum zi | 1 | ||||
| 17 | Mixture Mw | 0.0358478 | kg/mol |
Description
Build a fluid property table combining database components, SCN (Single Carbon Number) pseudo-components, and mixture molecular weight. This is the foundational step for all EoS calculations.
The property table (columns B:E) is referenced by all downstream calculations (Flash, BubbleP, Z-factor, etc.).
Workflow:
- Use
Component.Propsto look up database components (returns Tc, Pc, omega, Mw as a row) - Use
SCN.Propsfor C7+ pseudo-components from the Katz-Firoozabadi table - Enter mole fractions in column F
- Calculate mixture molecular weight
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Fluid Model Setup
- 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.