Gas Z-Factor Comparison
Spreadsheet
15 rows x 6 columns
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Gas Z-Factor Comparison | |||||
| 2 | Inputs | |||||
| 3 | Gas Gravity | 0.65 | (air=1) | |||
| 4 | Temperature | 200 | °F | |||
| 5 | Pseudocritical Properties | |||||
| 6 | Ppc | 668 | psia | |||
| 7 | Tpc | 373 | °R | |||
| 8 | Pressure Table | |||||
| 9 | P (psia) | Ppr | Tpr | Z (DAK) | Z (Brill-Beggs) | Difference |
| 10 | 500 | 0.748502994 | 1.769436997 | 0.9595150809 | 0.9640202727 | 0.00450519172 |
| 11 | 1000 | 1.497005988 | 1.769436997 | 0.9255825971 | 0.9297699386 | 0.004187341478 |
| 12 | 1500 | 2.245508982 | 1.769436997 | 0.9007771789 | 0.9014358918 | 0.0006587129012 |
| 13 | 2000 | 2.994011976 | 1.769436997 | 0.887135982 | 0.8824290556 | 0.004706926436 |
| 14 | 2500 | 3.74251497 | 1.769436997 | 0.8852855861 | 0.8745036217 | 0.01078196442 |
| 15 | 3000 | 4.491017964 | 1.769436997 | 0.8942673057 | 0.8778818399 | 0.0163854658 |
Description
Compare gas compressibility factor (Z) calculations using different correlations. Shows DAK (Dranchuk-Abou-Kassem) and Brill-Beggs methods side by side.
Usage: Enter gas properties and pseudocritical values. Results show Z-factor from both correlations for comparison.
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Gas Z-Factor Comparison
- 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.