Back to Excel templates

Gas Condensate PVT Screening: Dew Point, CGR, Z-Factor & Bg Table

Screen rich gas and condensate fluids: Nemeth-Kennedy dew point from composition, Hall-Yarborough z and a Bg table, and screening estimates of CGR and retrograde liquid dropout below the dew point.

reservoir engineeringintermediate

TAGLINE

Screen rich gas and condensate fluids: Nemeth-Kennedy dew point from composition, Hall-Yarborough z and a Bg table, and screening estimates of CGR and retrograde liquid dropout below the dew point.

WHO IT'S FOR

Reservoir engineers and production chemists screening gas-condensate and rich gas PVT behavior.

WHAT IT DOES

Estimates dew point pressure from the well-stream composition with the Nemeth-Kennedy (1967) correlation, with range and state checks. Calculates z by Hall-Yarborough using Standing condensate-gas pseudo-criticals and the Wichert-Aziz CO2/H2S correction, and builds a Bg table over 16 pressures. Below the dew point it gives screening estimates of produced CGR and retrograde liquid dropout (correlations, not an equation-of-state or CVD study). Crossplot tabs chart z, CGR and phase state against pressure from the computed tables.

TABS INCLUDED (9)

• Instructions & Legend • Fluid Input — well-stream composition, C7+ MW and SG, separator GOR, API, gas gravity, reservoir pressure and temperature • Dew Point Estimate — Nemeth-Kennedy terms laid out one by one, with range and state checks • CGR vs Pressure — initial CGR and screening CGR below the dew point, with chart • Z-Factor & Bg Table — Hall-Yarborough z and Bg at 16 pressures • Z vs P Crossplot — gas compressibility • CGR vs Z Crossplot — condensate screening with phase flags • Retrograde Dropout — screening liquid dropout curve anchored on the dew point • Summary — dew point, margin to initial pressure, state at Pi, well-stream gravity, z and Bg at Pi, maximum dropout

KEY FORMULAS

Nemeth-Kennedy ln Pd from composition, C7+ MW and SG, and temperature; Hall-Yarborough z with Standing pseudo-criticals and Wichert-Aziz correction; Bg = 0.02827 × z × T / p; well-stream gravity from separator recombination; initial CGR = 10⁶ / GOR

TECHNICAL SPECS

• Excel 2016+; 700+ formulas; 16-point pressure table; CGR and z charts • 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

gas condensatedew pointCGRretrogradeZ-factor

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.

Gas Condensate PVT Screening: Dew Point, CGR, Z-Factor & Bg Table
$79 + tax, where applicable · one-timeOpen Excel Library