Gas Material Balance


Description

How much gas is in place, how much will it give up, and is the reservoir really a volumetric tank? You enter the pressure surveys with Z and cumulative gas, water production, rock and water properties, the aquifer geometry and the wells. You read off the p/z OGIP and reserves, the Cole and overpressure diagnostics, an aquifer-supported OGIP with its spread, and a depletion forecast of rate, pressure and recovery over time. Field units; the example reservoir and aquifer are synthetic and do not match.

How to use it: Replace the surveys (time, pressure, Z and cumulative gas) on the Surveys and p-z sheet; the first row takes the initial pressure and Z. Enter the measured water production and the rock and water properties on the Cole diagnostic sheet, and review the PVT and rock data. Read the standard and modified p/z on the Geopressure sheet. On the Aquifer sheet, justify the aquifer history and geometry and inspect the OGIP spread. Review every diagnostic before using the Depletion forecast, and read the headlines and checks on the Summary.

Method: The p/z intercept gives OGIP; the initial and abandonment p/z give the recovery. Cole uses F = Gp Bg + Wp Bw, Eg = Bg - Bgi and Et = Eg + Efw; a rising F/Et trend suggests water drive, overpressure or an overstated initial pressure, a flat one depletion. The geopressure correction compares p/z with (p/z)(1 - ce(Pi - P)), with ce including rock and water compressibility. Fetkovich computes Wi, J, Wei and a stepwise We from the aquifer geometry and boundary pressure. The gas balance F = G Eg + We gives G = (F - We)/Eg, with Bg and Eg in rb/scf and G in scf. The forecast uses the p/z OGIP, DAK Z, 20 pressure steps, pseudo-steady-state deliverability and a plateau cap; each step's time uses the average of its two rates.

Example: At 4,500 psi and Z 0.92, five annual surveys reach 3,000 psi and 28 Bscf. Regression gives 76.802 Bscf OGIP and 68.791 Bscf reserves at 500 psi and Z 0.98. The aquifer's five observed production steps average 47.562 Bscf gas-only OGIP with a 22.40% spread, beyond the 5 % accepted as a match, so this aquifer does not explain the history; the extra year is excluded from the match statistics. The independent overpressured reference gives 131.420 and 100.118 Bscf standard and modified OGIP. Under volumetric depletion the forecast gives 68.331 Bscf at abandonment after 15.498 years.

Validity

The p/z and forecast assume a volumetric tank; a straight line does not rule out an aquifer. Cole and modified p/z depend on the compressibilities and on stable pressure surveys. The Fetkovich gas-only balance omits rock and connate-water expansion; unlike Cole, it uses Eg, not Et, and is not the oil balance. The extra aquifer year repeats the last pressure and production; it is not a survey. The 9,500 psi geopressure example is independent of the reservoir analysed. The forecast assumes no influx and constant well properties, even when the drive checks warn; DAK initial Z differs from survey Z. A gas target outside zero to the abandonment recovery has no target pressure and fails its check. The history needs zero initial time and gas, positive pressure and Z, increasing times and nondecreasing gas. Any failing or unavailable check fails the overall verdict.

References

  • Dake, L.P. (1978). Fundamentals of Reservoir Engineering. Elsevier, chapters 3 and 9.
  • Fetkovich, M.J. (1971). A Simplified Approach to Water Influx Calculations - Finite Aquifer Systems. Journal of Petroleum Technology 23(7), 814-828.
  • Ramagost, B.P. and Farshad, F.F. (1981). P/Z Abnormally Pressured Gas Reservoirs. SPE 10125.
  • Ahmed, T. (2010). Reservoir Engineering Handbook, 4th ed. Gulf Professional Publishing, chapter 13.

Inputs

Input Unit Default Name
Initial pressure, initial Z-factor, abandonment pressure, abandonment Z-factor, single-survey OGIP scatter limit psi, fraction 4500, 0.92, 500, 0.98, 0.05 GMP_Pi, GMP_Zi, GMP_Pab, GMP_Zab, GMP_ScatterMax
Pressure surveys: time, pressure, Z-factor and Gp year, psi, Bscf six survey rows GMP_Surveys
Reservoir temperature, connate water saturation, water and formation compressibility, water formation volume factor, flatness tolerance F, fraction, 1/psi, rb/STB 160, 0.2, 3E-6, 4E-6, 1.02, 0.02 GMC_T, GMC_Swi, GMC_cw, GMC_cf, GMC_Bw, GMC_TrendMax
Gas solubility slope dRsw/dp, OGIP scatter accepted as a straight line scf/STB/psi, fraction 0, 0.05 GMH_dRsw, GMH_ScatterMax
Reference initial pressure, initial Z-factor, temperature and formation compressibility (independent overpressured reference) psi, fraction, F, 1/psi 9500, 1.35, 280, 1.5E-5 GMH_RefPi, GMH_Refzi, GMH_RefT, GMH_Refcf
Aquifer permeability, thickness, porosity, outer radius, reservoir radius, encroachment angle, aquifer total compressibility, water viscosity mD, ft, degrees, 1/psi, cP 50, 50, 0.2, 15000, 3000, 360, 7E-6, 0.5 GMA_k, GMA_h, GMA_phi, GMA_ra, GMA_rr, GMA_theta, GMA_ct, GMA_Uw
OGIP spread accepted as a match fraction 0.05 GMA_SpreadMax
Gas specific gravity, permeability, net pay, drainage radius, wellbore radius, skin, producing wells fraction, mD, ft 0.75, 5, 50, 1490, 0.354, 0, 3 GMF_SG, GMF_k, GMF_h, GMF_re, GMF_rw, GMF_S, GMF_Wells
Flowing bottomhole pressure limit, plateau rate (all wells), cumulative gas target psi, Mscf/d, Bscf 300, 20000, 40 GMF_Pwf, GMF_Plateau, GMF_GpT

Sheets

  • Guide — what the workbook answers, the order to work through its sheets and its assumptions.
  • Surveys and p-z — the initial and abandonment conditions, the pressure surveys, the p/z regression to OGIP and reserves, each survey's OGIP scatter and the survey checks, with the p/z plot.
  • Cole diagnostic — the linked surveys with water production, the gas and formation-water expansion terms, the F/Et ratios and the drive verdict, with the Cole plot.
  • Geopressure — standard and modified p/z on the shared surveys with each OGIP and its straight-line check, and the separate 9,500 psi overpressured reference.
  • Aquifer — the Fetkovich aquifer size, influx and gas-only OGIP at each survey step with their spread; the sixth year holds the last pressure and production constant.
  • Depletion forecast — pseudo-critical properties, DAK Z, gas viscosity and well deliverability, a 20-step pressure, Z, production, rate and time profile, and the recovery, plateau and target pressure.
  • Summary — the history, aquifer and forecast headlines and every check under one verdict.
  • Test Cases — the worked example and other cases, with expected and computed results.

Charts show p/z regression, Cole ratios, standard and modified p/z, aquifer gas balance, and forecast rate and pressure versus time.

Functions used

PO.MBE.Gas.PzPO.MBE.Gas.OGIPPO.MBE.Gas.OGIP.RegPO.MBE.Gas.URFPO.MBE.Gas.RFPO.MBE.Gas.ModPzPO.MBE.Gas.ModOGIPPO.MBE.Gas.PredGpPO.MBE.Gas.PredPPO.MBE.F.GasPO.MBE.Exp.Eg.GasPO.MBE.Exp.EfwPO.MBE.Ce.GeopressuredPO.MBE.Aq.Fet.WiPO.MBE.Aq.Fet.JPO.MBE.Aq.Fet.WeiPO.MBE.Aq.Fet.WePO.MBE.Aq.Fet.PaPO.PVT.Bg.ByDefinitionPO.PVT.Ppc.BySuttonPO.PVT.Tpc.BySuttonPO.PVT.Z.ByDAKPO.PVT.Ug.ByLGEPO.IPR.GW.PSS.Rate

Names (172)

NameRefers toComment
GMA_Bgi Aquifer!$B$14 Initial gas formation volume factor, bbl/Mscf
GMA_DaysYear Aquifer!$B$15 Days per survey year, days/year
GMA_DepletionCheck Aquifer!$B$27 Aquifer depletion verdict
GMA_DepletionCheckNote Aquifer!$C$27 Aquifer depletion comment
GMA_History Aquifer!$A$33:$I$39 Gas history, aquifer influx and gas-only expansion balance
GMA_J Aquifer!$B$19 Aquifer productivity index, rb/d/psi
GMA_MatchCheck Aquifer!$B$26 Gas balance match verdict
GMA_MatchCheckNote Aquifer!$C$26 Gas balance match comment
GMA_OGIP Aquifer!$B$24 Gas OGIP, average across observed steps, Bscf
GMA_Pi Aquifer!$B$13 Initial pressure (surveys), psi
GMA_Results Aquifer!$B$18:$B$27 Aquifer size, influx, gas OGIP and checks
GMA_Spread Aquifer!$B$25 Gas OGIP spread across observed steps, %
GMA_SpreadMax Aquifer!$B$12 OGIP spread accepted as a match, %
GMA_Uw Aquifer!$B$11 Water viscosity, cp
GMA_We Aquifer!$B$21 Water influx at last time, rb
GMA_WeFrac Aquifer!$B$23 Influx as share of Wei, %
GMA_Wei Aquifer!$B$20 Maximum encroachable water, rb
GMA_Wi Aquifer!$B$18 Initial water in the aquifer, rb
GMA_ct Aquifer!$B$10 Aquifer total compressibility, 1/psi
GMA_dPa Aquifer!$B$22 Aquifer pressure drop, psi
GMA_h Aquifer!$B$5 Aquifer thickness, ft
GMA_k Aquifer!$B$4 Aquifer permeability, mD
GMA_phi Aquifer!$B$6 Aquifer porosity, %
GMA_ra Aquifer!$B$7 Aquifer outer radius, ft
GMA_rr Aquifer!$B$8 Reservoir radius, ft
GMA_theta Aquifer!$B$9 Encroachment angle, °
GMC_Bgi 'Cole diagnostic'!$B$15 Initial gas formation volume factor, bbl/Mscf
GMC_Bw 'Cole diagnostic'!$B$8 Water formation volume factor, bbl/STB
GMC_CfPerBbl 'Cole diagnostic'!$B$11 Cubic feet per barrel, ft3/bbl
GMC_DriveCheck 'Cole diagnostic'!$B$22 Drive mechanism verdict
GMC_DriveCheckNote 'Cole diagnostic'!$C$22 Drive mechanism comment
GMC_Excess 'Cole diagnostic'!$B$21 p/z OGIP above last F / Et, %
GMC_FEg 'Cole diagnostic'!$B$17 F / Eg at last survey, Bscf
GMC_FEt 'Cole diagnostic'!$B$18 F / Et at last survey, Bscf
GMC_OgipPz 'Cole diagnostic'!$B$16 OGIP from p/z regression, Bscf
GMC_R0 'Cole diagnostic'!$B$10 Rankine at zero Fahrenheit, °R
GMC_Results 'Cole diagnostic'!$B$15:$B$22 Gas expansion, Cole ratios and drive verdict
GMC_ScfPerBscf 'Cole diagnostic'!$B$12 Standard cubic feet per Bscf, scf/Bscf
GMC_Surveys 'Cole diagnostic'!$A$31:$L$36 Linked surveys and Cole terms
GMC_Swi 'Cole diagnostic'!$B$5 Connate water saturation, %
GMC_T 'Cole diagnostic'!$B$4 Reservoir temperature, °F
GMC_Trend 'Cole diagnostic'!$B$20 F / Et fitted change, %
GMC_TrendEg 'Cole diagnostic'!$B$19 F / Eg fitted change, %
GMC_TrendMax 'Cole diagnostic'!$B$9 Flatness tolerance, %
GMC_cf 'Cole diagnostic'!$B$7 Formation compressibility, 1/psi
GMC_cw 'Cole diagnostic'!$B$6 Water compressibility, 1/psi
GMF_DaysYear 'Depletion forecast'!$B$24 Days per year, days/year
GMF_DeliverabilityCheck 'Depletion forecast'!$B$69 Deliverability check verdict
GMF_DeliverabilityCheckNote 'Depletion forecast'!$C$69 Deliverability check comment
GMF_GpAb 'Depletion forecast'!$B$62 Gas recovered at abandonment, Bscf
GMF_GpT 'Depletion forecast'!$B$19 Cumulative gas target, Bscf
GMF_Initial_Results 'Depletion forecast'!$B$27:$B$31 Pseudo-critical properties, DAK Z, viscosity and deliverability
GMF_Inputs 'Depletion forecast'!$B$5:$B$19 Linked reservoir conditions and well deliverability inputs
GMF_Mscf 'Depletion forecast'!$B$23 Mscf per Bscf, Mscf/Bscf
GMF_OGIP 'Depletion forecast'!$B$5 Original gas in place (p/z), Bscf
GMF_Pab 'Depletion forecast'!$B$7 Abandonment pressure, psi
GMF_Pi 'Depletion forecast'!$B$6 Initial reservoir pressure, psi
GMF_Plateau 'Depletion forecast'!$B$18 Plateau rate, all wells, Mscf/d
GMF_Ppc 'Depletion forecast'!$B$27 Pseudo-critical pressure (Sutton), psi
GMF_Profile 'Depletion forecast'!$A$38:$J$58 Pressure, Z, production, rate and time profile
GMF_Pwf 'Depletion forecast'!$B$17 Flowing bottomhole pressure limit, psi
GMF_R0 'Depletion forecast'!$B$21 Rankine at zero Fahrenheit, °R
GMF_RF 'Depletion forecast'!$B$63 Recovery factor at abandonment, %
GMF_Results 'Depletion forecast'!$B$61:$B$69 Recovery, plateau, target pressure and deliverability check
GMF_S 'Depletion forecast'!$B$15 Skin
GMF_SG 'Depletion forecast'!$B$9 Gas specific gravity, air = 1
GMF_T 'Depletion forecast'!$B$8 Reservoir temperature, °F
GMF_TargetCheck 'Depletion forecast'!$B$70 Forecast target range verdict
GMF_TargetCheckNote 'Depletion forecast'!$C$70 Forecast target range comment
GMF_TargetStatus 'Depletion forecast'!$B$70 Forecast target validity
GMF_TargetStatusNote 'Depletion forecast'!$C$70 Forecast target validity comment
GMF_Tpc 'Depletion forecast'!$B$28 Pseudo-critical temperature (Sutton), °R
GMF_Ugi 'Depletion forecast'!$B$30 Initial gas viscosity (Lee-Gonzalez-Eakin), cp
GMF_Wells 'Depletion forecast'!$B$16 Producing wells
GMF_h 'Depletion forecast'!$B$12 Net pay, ft
GMF_k 'Depletion forecast'!$B$11 Permeability, mD
GMF_pT 'Depletion forecast'!$B$68 Pressure at target Gp, psi
GMF_pT1 'Depletion forecast'!$B$67 Pressure at target Gp, first pass, psi
GMF_q0 'Depletion forecast'!$B$31 Deliverability at Pi, all wells, Mscf/d
GMF_qAb 'Depletion forecast'!$B$66 Rate at abandonment, Mscf/d
GMF_re 'Depletion forecast'!$B$13 Drainage radius, ft
GMF_rw 'Depletion forecast'!$B$14 Wellbore radius, ft
GMF_scf 'Depletion forecast'!$B$22 Standard cubic feet per Bscf, scf/Bscf
GMF_tAb 'Depletion forecast'!$B$64 Time to abandonment, years
GMF_tPlateau 'Depletion forecast'!$B$65 Plateau length (to pressure step), years
GMF_zab 'Depletion forecast'!$B$61 Z-factor at abandonment (DAK)
GMF_zi 'Depletion forecast'!$B$29 Initial Z-factor (DAK, not survey Z)
GMH_Bw Geopressure!$B$12 Water formation volume factor, bbl/STB
GMH_Curve Geopressure!$C$31:$G$36 Standard and Modified p/z
GMH_History Geopressure!$A$31:$I$36 Linked surveys and standard and modified p/z results
GMH_Inputs Geopressure!$B$4:$B$12 Correction inputs and linked reservoir properties
GMH_ModScatter Geopressure!$B$19 Modified OGIP scatter, %
GMH_ModifiedCheck Geopressure!$B$20 Modified straight-line check verdict
GMH_ModifiedCheckNote Geopressure!$C$20 Modified straight-line check comment
GMH_OGIPmod Geopressure!$B$16 OGIP, modified p/z (survey average), Bscf
GMH_OGIPstd Geopressure!$B$15 OGIP, standard p/z (survey average), Bscf
GMH_Over Geopressure!$B$17 Standard p/z overestimate, %
GMH_Pi Geopressure!$B$6 Initial pressure (surveys), psi
GMH_RefBw Geopressure!$B$48 Reference water formation volume factor, bbl/STB
GMH_RefModScatter Geopressure!$B$66 Reference modified OGIP scatter, %
GMH_RefModifiedCheck Geopressure!$B$67 Reference modified straight-line check verdict
GMH_RefModifiedCheckNote Geopressure!$C$67 Reference modified straight-line check comment
GMH_RefOGIPmod Geopressure!$B$63 Reference OGIP, modified, Bscf
GMH_RefOGIPstd Geopressure!$B$62 Reference OGIP, standard, Bscf
GMH_RefOver Geopressure!$B$64 Reference standard overestimate, %
GMH_RefPi Geopressure!$B$42 Reference initial pressure, psi
GMH_RefScatterMax Geopressure!$B$50 Reference scatter limit, %
GMH_RefStandardCheck Geopressure!$B$68 Reference standard p/z check verdict
GMH_RefStandardCheckNote Geopressure!$C$68 Reference standard p/z check comment
GMH_RefStdFall Geopressure!$B$65 Reference standard OGIP fall, %
GMH_RefSw Geopressure!$B$47 Reference water saturation, %
GMH_RefT Geopressure!$B$44 Reference temperature, °F
GMH_Refcf Geopressure!$B$46 Reference formation compressibility, 1/psi
GMH_Refcw Geopressure!$B$45 Reference water compressibility, 1/psi
GMH_RefdRsw Geopressure!$B$49 Reference gas solubility slope, scf/STB/psi
GMH_Reference_History Geopressure!$A$54:$C$59 Independent blueprint pressure, Z and cumulative gas surveys
GMH_Reference_Inputs Geopressure!$B$42:$B$50 Independent overpressured reference inputs
GMH_Reference_Results Geopressure!$B$62:$B$68 Independent reference OGIP and checks
GMH_Refzi Geopressure!$B$43 Reference initial Z-factor
GMH_Results Geopressure!$B$15:$B$21 Standard and modified OGIP and straight-line checks
GMH_ScatterMax Geopressure!$B$5 OGIP scatter accepted as a straight line, %
GMH_StandardCheck Geopressure!$B$21 Standard p/z check verdict
GMH_StandardCheckNote Geopressure!$C$21 Standard p/z check comment
GMH_StdFall Geopressure!$B$18 Standard OGIP fall, first to last, %
GMH_Sw Geopressure!$B$11 Water saturation, %
GMH_T Geopressure!$B$8 Temperature, °F
GMH_cf Geopressure!$B$10 Formation compressibility, 1/psi
GMH_cw Geopressure!$B$9 Water compressibility, 1/psi
GMH_dRsw Geopressure!$B$4 Gas solubility slope dRsw/dp, scf/STB/psi
GMH_zi Geopressure!$B$7 Initial Z-factor (surveys)
GMP_Curve 'Surveys and p-z'!$D$31:$E$36 p/z plot: Surveys
GMP_HistoryCheck 'Surveys and p-z'!$B$22 Survey validity verdict
GMP_HistoryCheckNote 'Surveys and p-z'!$C$22 Survey validity comment
GMP_Inputs 'Surveys and p-z'!$B$4:$B$8 Initial and abandonment conditions and scatter limit
GMP_LineCheck 'Surveys and p-z'!$B$21 Straight-line check verdict
GMP_LineCheckNote 'Surveys and p-z'!$C$21 Straight-line check comment
GMP_OGIP 'Surveys and p-z'!$B$12 OGIP, p/z regression, Bscf
GMP_Pab 'Surveys and p-z'!$B$6 Abandonment pressure, psi
GMP_Pi 'Surveys and p-z'!$B$4 Initial pressure, psi
GMP_PzFit 'Surveys and p-z'!$B$13 Fitted p/z at zero production, psi
GMP_Pzab 'Surveys and p-z'!$B$16 Abandonment p/z, psi
GMP_Pzi 'Surveys and p-z'!$B$15 Initial p/z, psi
GMP_Remaining 'Surveys and p-z'!$B$19 Remaining reserves, Bscf
GMP_Reserves 'Surveys and p-z'!$B$18 Recoverable reserves, Bscf
GMP_Results 'Surveys and p-z'!$B$12:$B$22 Regression, reserves, scatter and survey checks
GMP_Scatter 'Surveys and p-z'!$B$20 Single-survey OGIP scatter, %
GMP_ScatterMax 'Surveys and p-z'!$B$8 Single-survey OGIP scatter limit, %
GMP_Slope 'Surveys and p-z'!$B$14 Fitted slope, psi/Bscf
GMP_SurveyCells 'Surveys and p-z'!$B$10 Required numeric survey cells
GMP_Surveys 'Surveys and p-z'!$A$31:$D$36 Time, pressure, Z and cumulative gas at each survey
GMP_URF 'Surveys and p-z'!$B$17 Ultimate recovery factor, %
GMP_Zab 'Surveys and p-z'!$B$7 Abandonment Z-factor
GMP_Zi 'Surveys and p-z'!$B$5 Initial Z-factor
GMP_scf 'Surveys and p-z'!$B$9 Standard cubic feet per Bscf, scf/Bscf
GMX_AqOGIP Summary!$B$13 Gas-only aquifer balance OGIP, Bscf
GMX_AqSpread Summary!$B$14 Gas-only aquifer balance spread, %
GMX_Checks Summary!$B$24:$B$34 Every check of the workbook
GMX_Cole Summary!$B$9 Cole F / Et at last survey, Bscf
GMX_DakZ Summary!$B$20 Initial Z, DAK
GMX_GpAb Summary!$B$17 Forecast gas at abandonment, Bscf
GMX_Modified Summary!$B$11 Modified p/z OGIP, Bscf
GMX_OGIP Summary!$B$7 OGIP, p/z regression, Bscf
GMX_Overall Summary!$B$4 All checks verdict
GMX_OverallNote Summary!$C$4 All checks comment
GMX_Reserves Summary!$B$8 Reserves at abandonment, survey Z, Bscf
GMX_Results Summary!$B$7:$B$20 History, aquifer and volumetric forecast headlines
GMX_SurveyZ Summary!$B$19 Initial Z, survey
GMX_Trend Summary!$B$10 Cole F / Et trend, %
GMX_Verdict Summary!$B$4 Overall verdict; missing and error checks fail
GMX_VerdictNote Summary!$C$4 Overall verdict; missing and error checks fail comment
GMX_We Summary!$B$12 Aquifer influx at last time, rb
GMX_tAb Summary!$B$18 Time to abandonment, years

Details

Opens inNeeds the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates. Needs Microsoft 365 or Excel 2024: it uses functions Excel 2016 doesn't have, such as named LAMBDAs, which show #NAME? there.
FileGasMaterialBalance.xlsx, 78 KB
CategoryReservoir
For agents and tools Descriptor (.md)
Tags:
MBEgasmaterial-balanceOGIPgeopressuredaquiferFetkovichforecastrecovery-factor

Need a workbook we don't have? Suggest a Workbook