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)
| Name | Refers to | Comment |
|---|---|---|
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 in | Needs 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. |
| File | GasMaterialBalance.xlsx, 78 KB |
| Category | Reservoir |
| For agents and tools | Descriptor (.md) |
More Reservoir Workbooks
Buildup Interpretation
PO Add-in + Microsoft 365What permeability, skin and p-star an oil buildup gives and whether it sees a fault, from gauge QC and the Bourdet derivative to Horner and the late slope.
CO2 Storage Screening
PO Add-in + Microsoft 365How much CO2 a saline formation can hold, how many wells it takes to inject it and whether the average pressure stays below the fracture limit.
Complete PVT Study
PO Add-in + Microsoft 365Picks the black-oil correlations that best match a lab PVT report and turns them into oil, gas and water tables and PVTO, PVDG and PVTW keywords.
DFIT Analysis
Microsoft 365Where a DFIT's fracture closed and at what stress, the net pressure and fluid efficiency at shut-in, and the pore pressure from after-closure flow.
DST and Multi-rate Test Analysis
PO Add-in + Microsoft 365What permeability, skin and p-star a two-cycle DST, a variable-rate drawdown and a water injector's falloff give, and where the injector starts to fracture.
Oil Material Balance
PO Add-in + Microsoft 365Takes an oil reservoir from its history to OOIP, drive indices and an aquifer match, then forecasts recovery below the bubble point.
Probabilistic Volumetrics
PO Add-in + Microsoft 365How much oil and gas a gas cap and oil leg hold and can recover, as one deterministic case and as P90, P50 and P10 ranges.
Reserves Screening Report
PO Add-in + Microsoft 365How much oil three wells have left in 1P, 2P and 3P screening cases, what it is worth and how it reconciles with last year's booking and production.
Which relative permeability and capillary pressure curves to give the simulator, from core plugs through Corey fits and J scaling to SWOF and SGOF tables.
Waterflood Design
Microsoft 365How much oil a layered five-spot waterflood recovers at an economic WOR, from a Corey fit to SCAL data through fractional flow to vertical sweep.
Waterflood Surveillance
Microsoft 365Whether an injector is plugging or fracturing, whether a pattern's voidage is replaced and where a producer's water comes from and how much oil is left.
Well Test Design
PO Add-in + Microsoft 365How long a planned well test must run to see radial flow and reach a target radius, whether the gauge resolves it and what an observation well would see.
Need a workbook we don't have? Suggest a Workbook













