Complete Oil PVT Table
Spreadsheet
24 rows x 6 columns
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Complete Oil PVT Table - Standing Correlation | |||||
| 2 | Fluid Properties | |||||
| 3 | Gas Gravity | 0.75 | (air=1) | |||
| 4 | API Gravity | 35 | °API | |||
| 5 | Temperature | 200 | °F | |||
| 6 | ||||||
| 7 | Calculated Bubble Point | |||||
| 8 | ||||||
| 9 | Pb (Standing) | 3097.515712 | psia | |||
| 10 | ||||||
| 11 | ||||||
| 12 | Rs at Pb | 750 | scf/STB | |||
| 13 | Oil PVT Table | |||||
| 14 | P (psia) | Rs (scf/STB) | Bo (rb/STB) | Co (1/psi) | Uo (cp) | Phase |
| 15 | 5000 | 750 | 1.409432821 | 1.06267E-05 | 0.6018656767 | Undersaturated |
| 16 | 4500 | 750 | 1.414597082 | 1.180744444E-05 | 0.5698162282 | Undersaturated |
| 17 | 4000 | 750 | 1.421079027 | 1.3283375E-05 | 0.5403661986 | Undersaturated |
| 18 | 3500 | 867.7469436 | 1.502320678 | 0.4556059684 | Saturated | |
| 19 | 3000 | 720.7574796 | 1.422492461 | 0.5063340439 | Saturated | |
| 20 | 2500 | 578.7019392 | 1.347299055 | 0.5725555093 | Saturated | |
| 21 | 2000 | 442.3594221 | 1.27718494 | 0.6629404611 | Saturated | |
| 22 | 1500 | 312.8592812 | 1.212745365 | 0.7940618774 | Saturated | |
| 23 | 1000 | 192.0150047 | 1.154850705 | 1.00155643 | Saturated | |
| 24 | 500 | 83.34797494 | 1.105025105 | 1.373819553 | Saturated |
Description
Complete oil PVT property table from undersaturated through saturated conditions. Includes bubble point, solution GOR, oil FVF, oil compressibility, and oil viscosity across the full pressure range.
Properties calculated:
- Pb: Bubble point pressure
- Rs: Solution gas-oil ratio (constant above Pb)
- Bo: Oil formation volume factor
- Co: Oil compressibility (above Pb only)
- Uo: Oil viscosity
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Complete Oil PVT Table
- 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.