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.
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 engineers and production chemists screening gas-condensate and rich gas PVT behavior.
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.
• 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
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
• Excel 2016+; 700+ formulas; 16-point pressure table; CGR and z charts • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
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.
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.