Back to Excel templates

Oil & Gas PVT Correlation Calculator: Standing, Vasquez-Beggs, Lee-Gonzalez-Eakin & Z-Factor

Full PVT correlation suite: Rs, Bo, dead and live oil viscosity, gas Z-factor and Bg, inputs for engineering workflows without volumetric Monte Carlo.

petrophysicsfoundation

TAGLINE

Full PVT correlation suite: Rs, Bo, dead and live oil viscosity, gas Z-factor, Bg and gas viscosity — inputs for engineering workflows without volumetric Monte Carlo.

WHO IT'S FOR

Reservoir and production engineers needing quick PVT property tables from API gravity, gas gravity, and temperature.

WHAT IT DOES

Generates oil PVT tables with Standing Pb and Bo, Vasquez-Beggs Rs and Bo (published coefficient sets with separator-gas correction), Beggs-Robinson dead and live oil viscosity, and gas Z-factor (Dranchuk-Abou-Kassem from Sutton pseudo-criticals, cross-checked against Hall-Yarborough), Bg and Lee-Gonzalez-Eakin gas viscosity vs pressure. Crossplot tabs compare the correlations with the sample lab data.

TABS INCLUDED (10)

• Instructions & Legend • Fluid Properties — API, gas gravity, temperature • Oil PVT Table — Rs, Bo, μ vs pressure • Standing Correlations • Vasquez-Beggs • Gas Z-Factor & Bg • Bo vs Rs Crossplot — Standing correlation QC • Viscosity Crossplot — live vs dead oil • Z vs P Crossplot — gas compressibility • Summary

KEY FORMULAS

Standing Pb and Bo; Vasquez-Beggs Rs and Bo; Beggs-Robinson μo; Dranchuk-Abou-Kassem Z; Lee-Gonzalez-Eakin μg; Bg = 0.02827×Z×T/P

TECHNICAL SPECS

• Excel 2016+; 500+ formulas; 10-point pressure table; no plugins • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas

ABOUT RESERVOIR RISK SOLUTIONS

Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com

PVTStandingVasquez-BeggsBoZ-factorBg

What you get

  • Instant workbook access after payment in your Excel Library
  • Formula-driven worksheet designed for petroleum workflows
  • No recurring fees and no plugin requirements

Licence

Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.

FAQ

Is this a one-time purchase?

Yes. Each workbook is sold as a one-time purchase with no recurring subscription.

How do I access purchased files?

After checkout, your file appears in Excel Library under your account for download.

Do these templates require macros or plugins?

No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.

Oil & Gas PVT Correlation Calculator: Standing, Vasquez-Beggs, Lee-Gonzalez-Eakin & Z-Factor
$59 + tax, where applicable · one-timeOpen Excel Library