Complete Oil PVT Table

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

Spreadsheet Preview

24 rows x 6 columns

Required Functions

PO.PVT.Pb.ByStanding

Calculates oil bubble point pressure using Standing (1947) correlation, [psi].

PO.PVT.Bo.UnSat.ByDefinition

Calculates oil formation volume factor for undersaturated oil, P > Pb, [bbl/STB].

PO.PVT.Bo.Sat.ByStanding

Calculates oil formation volume factor using Standing (1947) correlation, P <= Pb, [bbl/STB].

PO.PVT.Co.UnSat.ByVasquezBeggs

Calculates oil compressibility using Vasquez and Beggs (1980) correlation, P > Pb, [1/psi].

PO.PVT.Uo.UnSat.ByVasquezBeggs

Calculates oil viscosity for undersaturated conditions using Vasquez and Beggs (1980) correlation, P > Pb, [cP].

PO.PVT.Uo.Sat.ByBeggsRobinson

Calculates oil viscosity with solution gas using Beggs and Robinson (1975) correlation, P <= Pb, [cP].

PO.PVT.Uo.Dead.ByEgbogah

Calculates dead oil viscosity using Egbogah (1983) correlation, [cP].

PO.PVT.Rs.ByStanding

Calculates solution gas-oil ratio using Standing correlation (1981), P <= Pb, [scf/STB].

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.

Related Theory

Oil Viscosity Correlations

Empirical correlations for predicting crude oil viscosity at dead, saturated, and undersaturated conditions

Oil Formation Volume Factor (Bo) Correlations

PVT correlations for oil formation volume factor including Standing, Vazquez-Beggs, Glasø, Al-Marhoun, Petrosky-Farshad, and Dindoruk-Christman methods.

Bubble Point Pressure Correlations

Empirical correlations for predicting the saturation pressure of crude oil from surface-measured fluid properties

Oil Compressibility Correlations

Empirical correlations for predicting isothermal compressibility of crude oil at saturated and undersaturated conditions

Solution Gas-Oil Ratio (Rs) Correlations

PVT correlations for solution gas-oil ratio including Standing, Vazquez-Beggs, Glasø, Al-Marhoun, Petrosky-Farshad, and Dindoruk-Christman methods.

oilpvttablebubble pointRsBoCoviscositycomplete

Need a custom calculation? Request a Blueprint