Description
How much oil and gas does a closure with a gas cap and an oil leg hold, and what range belongs in a resource report? You enter a top-reservoir depth-area table, the gas-oil and oil-water contacts, the rock, fluid and recovery inputs, and a spread for each of ten uncertain inputs. You read off STOIIP, GIIP and the recoverable volumes per segment and for the field, as a deterministic case and as mean, P90, P50 and P10, in field units.
How to use it: The field is synthetic. Paste your contours, crest first, and set the contacts from pressure gradients, the rock from petrophysics and the gas from a separator test. Pick the recovery-factor correlation for your drive and check it against the analogue range. Set each spread from the field's own range (maps, logs, PVT, analogues), give any extra input its own multiplier and offset, and run n = 1,000 for a final report. Read the field's recoverable P90, P50 and P10 on the Resources sheet, and the roll-up there to see how far the summed segment percentiles are from the field's.
Method: The gas cap's gross rock volume is the depth-area table integrated from the crest to the GOC, and the oil leg's is the volume above the OWC less the gas cap's, each contact's area interpolated between contours. Bg = 0.02827 z T/P, with z from Dranchuk-Abou-Kassem on Sutton's pseudo-critical properties. GIIP = 43560 GRV NTG phi (1 - Sw)/Bg and STOIIP = 7758 GRV NTG phi (1 - Sw)/Bo; recoverable = in place x RF, with the oil RF from the Arps or Guthrie-Greenberger analogue correlations. A BOE of gas is 1/(1/6000 + CGR/10^6) scf, its condensate included. Each input column is a Latin-hypercube lattice, one value per stratum, shuffled by its own multiplier and offset. Trial i's STOIIP, GIIP and recoverable volumes follow, and the field is oil + gas/BOE factor, trial by trial. P90, P50 and P10 are percentiles of the trials, P90 the low case. The roll-up sums the trials, not the percentiles: percentiles do not add, means do, and the sheet shows both. Dependence: the two segments share one NTG and one porosity per trial (the same sand, fully dependent); every other input, the two GRVs included, is sampled independently.
Example: The volumetrics family's synthetic four-way closure (crest 7,000 ft, GOC 7,080 ft, OWC 7,180 ft; 75% net, 22% porosity). Gas cap: 20,553 acre-ft, z 0.886, Bg 0.005089 ft3/scf, GIIP 23.22 Bscf, 0.58 MMSTB of condensate and 17.42 Bscf recoverable at 75%. Oil leg: 118,800 acre-ft, STOIIP 91.24 MMSTB and 31.94 MMSTB recoverable at 35%. The field holds 95.69 MMBOE in place and 35.27 MMBOE recoverable at 5,217 scf/BOE. Arps water drive gives an oil recovery factor of 41.0% (Guthrie-Greenberger 41.1%, inside the 35 to 75% of water-drive analogues), 37.42 MMSTB. At n = 300 the STOIIP P90, P50 and P10 are 76.02, 92.46 and 111.72 MMSTB, the same as the Monte Carlo volumetrics blueprint on these inputs, and the GIIP's are 18.68, 23.60 and 29.53 Bscf. The field's recoverable P90, P50 and P10 are 27.86, 35.65 and 44.89 MMBOE; the segments' P90s added give 27.23 and their P10s 45.27, so the field's P90 is 2.3% higher and its P10 0.8% lower than the sums. The largest correlation between two of the ten sampled columns is 0.040, within the 0.05 allowed, and the case is consistent throughout. At n = 1,000 the STOIIP percentiles move by under 0.6% and the field's recoverable P90 and P10 are 27.62 and 44.78 MMBOE. At n = 200 the columns correlate by 0.13, so the inputs are no longer independent; at n = 700, which 7 divides, a multiplier shares a factor with n, its strata are no longer each visited once, and the sheet rejects the sample. Solution-gas drive gives 18.5%, well short of the assumed 35%, and the sheet warns. An OWC at 7,260 ft lies below the deepest contour (7,240 ft) and the sheet asks for a longer map.
Validity
A volumetric estimate is as good as its map, contacts and averages; the top map alone bounds the rock only when the reservoir is thicker than the hydrocarbon column, and Bg is taken at the GOC for the whole gas cap. The recovery-factor correlations are regressions on sandstone fields: a starting value against analogues, not a forecast; gas-cap drive has none. The sample is a fixed lattice, not a random draw: repeated runs are identical, the tails are cut at the outer strata, and below n = 300 the ten columns correlate by more than 0.05 (0.13 at 200), so the inputs stop being independent. The segments share NTG and porosity but nothing else: positive dependence (GRV with GRV through the depth conversion, porosity with Sw) widens the field's range, so this run understates it. The workbook does not sample correlated inputs: the stratified sampler draws each input on its own, and the add-in has no function for correlated sampling. The BOE factor is a reporting convention, and recoverable volumes are resources, not reserves, until a development plan supports them (SPE-PRMS). The blueprints' area x thickness cross-check and permeability sensitivity are left to them. Alternatives: a full uncertainty run on a geological model, or correlated Monte Carlo outside the workbook.
References
- Society of Petroleum Engineers (2018). Petroleum Resources Management System (PRMS), revised June 2018, sections 4.2 and 4.3 (probabilistic methods and aggregation).
- Murtha, J.A. (1994). Incorporating Historical Data into Monte Carlo Simulation. SPE Computer Applications 6(2), SPE-26245-PA.
- McKay, M.D., Beckman, R.J. and Conover, W.J. (1979). A Comparison of Three Methods for Selecting Values of Input Variables in the Analysis of Output from a Computer Code. Technometrics 21(2), 239-245.
- Craft, B.C. and Hawkins, M.F. (1991). Applied Petroleum Reservoir Engineering, 2nd ed., revised by Terry, R.E. Prentice Hall, ch. 1.
- Arps, J.J. et al. (1967). A Statistical Study of Recovery Efficiency. API Bulletin D14.
Inputs
| Input | Unit | Default | Name |
|---|---|---|---|
| Depth-area rule (Trapezoidal, Pyramidal or Mixed, from a list) | — | Mixed | DET_Rule |
| Gas-oil contact | ft | 7080 | DET_GOC |
| Oil-water contact | ft | 7180 | DET_OWC |
| Net-to-gross ratio, both segments | fraction | 0.75 | DET_NTG |
| Porosity of the net rock, both segments | fraction | 0.22 | DET_Phi |
| Water saturation of the oil leg | fraction | 0.25 | DET_SwOil |
| Initial oil formation volume factor | bbl/STB | 1.25 | DET_Bo |
| Oil recovery factor | % | 35 | DET_RFOil |
| Water saturation of the gas cap | fraction | 0.2 | DET_SwGas |
| Reservoir pressure at the GOC | psia | 3200 | DET_P |
| Reservoir temperature | °F | 190 | DET_T |
| Gas specific gravity | air = 1 | 0.7 | DET_SG |
| Condensate yield of the gas | STB/MMscf | 25 | DET_CGR |
| Gas recovery factor | % | 75 | DET_RFGas |
| Gas counted as one barrel of oil equivalent | scf/BOE | 6000 | DET_BoeScf |
| Contour table: depth and area enclosed | ft, acres | 7 contours | — |
| Recovery factor correlation (Arps solution-gas drive, Arps water drive or Guthrie-Greenberger, from a list) | — | Arps water drive | RCF_Mode |
| Permeability | mD | 150 | RCF_K |
| Oil viscosity, initial (at the bubble point) | cp | 0.9 | RCF_Muo |
| Water viscosity, initial (water drive, Arps) | cp | 0.35 | RCF_Muw |
| Abandonment pressure (Arps) | psia | 1000 | RCF_Pa |
| Largest gap between the correlation and the assumed factor | % | 10 | RCF_Tol |
| Largest gap between the two water-drive correlations | % | 5 | RCF_AgreeTol |
| Number of trials, 10 to 1,000 | — | 300 | MCS_n |
| Fewest trials for stable percentiles | — | 100 | MCS_NMin |
| Largest correlation between two sampled inputs | — | 0.05 | MCS_CorrMax |
| In-place P10/P90 ratio, lowest expected | — | 1.2 | MCS_RatioMin |
| In-place P10/P90 ratio, highest expected | — | 5 | MCS_RatioMax |
| Distribution table: ten inputs, each with a distribution (list), spread, multiplier and offset | — | centred on the Deterministic sheet | — |
Sheets
Guide— what the workbook does, where the inputs are and how the sheets connect.Deterministic— one top-reservoir depth-area table clipped at each contact, Bg at the GOC, GIIP, condensate, STOIIP, the recoverable volumes and the field in barrels of oil equivalent.Recovery— the oil recovery factor from Arps or Guthrie-Greenberger, picked from a list, against the analogue range for its drive.Monte Carlo— ten inputs sampled by a reproducible stratified sampler, centred on the deterministic case.Resources— mean, P90, P50 and P10 by segment and for the field, the roll-up, the expectation curves and a P90/P50/P10 chart.Summary— the answers and every check under one verdict.Test Cases— the worked example and other cases, with expected and computed results.
Two charts: recoverable P90, P50 and P10 by segment, and the expectation curves.
Functions used
PO.RES.Vol.GRV.DepthAreaPO.RES.Vol.STOIIPPO.RES.Vol.GIIPPO.RES.Vol.RecoverablePO.RES.RF.AnaloguePO.RES.MC.SamplePO.RES.MC.PercentilesPO.PVT.Ppc.BySuttonPO.PVT.Tpc.BySuttonPO.PVT.Z.ByDAKPO.PVT.Bg.ByDefinition
Names (159)
| Name | Refers to | Comment |
|---|---|---|
PO.RES.MC.PercentilesLAMBDA |
=LAMBDA(X, HSTACK(PERCENTILE.INC(X, 0.1), PERCENTILE.INC(X, 0.5), PERCENTILE.INC(X, 0.9), AVERAGE(X))) |
P90, P50, P10 (petroleum convention: P90 the low case, exceeded 90% of the time) and the mean of a column of outcomes; linear interpolation as PERCENTILE.INC. |
PO.RES.MC.SampleLAMBDA |
=LAMBDA(Dist, Dist_A, Dist_B, Dist_C, n, Mult, Shift, IF(GCD(Mult, n)<>1, NA(), LET(u, (MOD(Mult*(SEQUENCE(n)-1)+Shift, n)+0.5)/n, IF(Dist=1, NORM.INV(u, Dist_A, Dist_B), IF(Dist=2, LOGNORM.INV(u, Dist_A, Dist_B), IF(Dist=3, IF(u<(Dist_B-Dist_A)/(Dist_C-Dist_A), Dist_A+SQRT(u*(Dist_C-Dist_A)*(Dist_B-Dist_A)), Dist_C-SQRT((1-u)*(Dist_C-Dist_A)*(Dist_C-Dist_B))), IF(Dist=4, Dist_A+u*(Dist_B-Dist_A), NA()))))))) |
Deterministic stratified (Latin-hypercube) sample of n values: Dist 1 normal, 2 lognormal, 3 triangular, 4 uniform; strata shuffled by MOD(Mult*(i-1)+Shift, n). Inputs independent. |
PO.RES.RF.AnalogueLAMBDA |
=LAMBDA(Mode, Phi, Sw, Bo, k, Mu_o, Mu_w, P_ref, P_a, H, IF(Mode=1, 0.41815*(Phi*(1-Sw)/Bo)^0.1611*(k/1000/Mu_o)^0.0979*Sw^0.3722*(P_ref/P_a)^0.1741, IF(Mode=2, 0.54898*(Phi*(1-Sw)/Bo)^0.0422*(k/1000*Mu_w/Mu_o)^0.077*Sw^(-0.1903)*(P_ref/P_a)^(-0.2159), IF(Mode=3, 0.2719*LOG10(k)+0.25569*Sw-0.1355*LOG10(Mu_o)-1.538*Phi-0.00035*H+0.11403, NA())))) |
Oil recovery factor (fraction) from analogue correlations: Mode 1 Arps (API 1967) solution-gas drive, 2 Arps water drive, 3 Guthrie-Greenberger (1955) water drive. k in mD. |
PO.RES.Vol.GIIPLAMBDA |
=LAMBDA(GRV, NTG, Phi, Sw, Bg, 43560*GRV*NTG*Phi*(1-Sw)/Bg) |
Gas initially in place, scf: 43560 x GRV (acre-ft) x NTG x porosity x (1 - Sw) / Bg (rcf/scf). |
PO.RES.Vol.GRVLAMBDA |
=LAMBDA(Area, H, Factor, IF(OR(Factor<=0, Factor>1), NA(), Area*H*Factor)) |
Gross rock volume, acre-ft: area (acres) x gross thickness (ft) x a geometric factor (1 for a slab, below 1 for a dome or wedge). |
PO.RES.Vol.GRV.DepthAreaLAMBDA |
=LAMBDA(Depth, Area, Mode, LET(i, SEQUENCE(ROWS(Depth)), shift, --(i=TRANSPOSE(i)+1), d_prev, MMULT(shift, Depth), a_prev, MMULT(shift, Area), dh, ABS(Depth-d_prev)*(i>1), trap, dh*(Area+a_prev)/2, pyr, dh*(Area+a_prev+SQRT(Area*a_prev))/3, lo, (Area+a_prev-ABS(Area-a_prev))/2, hi, (Area+a_prev+ABS(Area-a_prev))/2, IF(Mode=1, SUM(trap), IF(Mode=2, SUM(pyr), IF(Mode=3, SUM(IF(lo<=0.5*hi, pyr, trap)), NA()))))) |
Gross rock volume, acre-ft, from a depth-area (or isopach) table: Mode 1 trapezoid, 2 pyramidal frustum, 3 pyramidal where the smaller area is at most half the larger, trapezoid otherwise. |
PO.RES.Vol.RecoverableLAMBDA |
=LAMBDA(InPlace, RF, IF(OR(RF<0, RF>1), NA(), InPlace*RF)) |
Recoverable volume: a volume in place (STOIIP or GIIP, any unit) x a recovery factor between 0 and 1; same unit as the volume in place. |
PO.RES.Vol.STOIIPLAMBDA |
=LAMBDA(GRV, NTG, Phi, Sw, Bo, 7758*GRV*NTG*Phi*(1-Sw)/Bo) |
Stock-tank oil initially in place, STB: 7758 x GRV (acre-ft) x NTG x porosity x (1 - Sw) / Bo (rb/STB). |
DET_AGOC |
Deterministic!$B$38 |
Area enclosed at the GOC (interpolated between contours), acres |
DET_AOWC |
Deterministic!$B$46 |
Area enclosed at the OWC (interpolated between contours), acres |
DET_Bg |
Deterministic!$B$35 |
Gas formation volume factor at the GOC, Bg, ft³/scf |
DET_Bo |
Deterministic!$B$10 |
Initial oil formation volume factor, bbl/STB |
DET_BoeScf |
Deterministic!$B$18 |
Gas counted as one barrel of oil equivalent, scf/BOE |
DET_CGR |
Deterministic!$B$16 |
Condensate yield of the gas, STB/MMscf |
DET_ColumnGas |
Deterministic!$B$39 |
Gas column, GOC less the crest, ft |
DET_ColumnOil |
Deterministic!$B$47 |
Oil column, OWC less the GOC or the crest, ft |
DET_Cond |
Deterministic!$B$42 |
Condensate in place, GIIP × the yield, MMSTB |
DET_ContactCheck |
Deterministic!$B$57 |
Contacts check verdict |
DET_ContactCheckNote |
Deterministic!$C$57 |
Contacts check comment |
DET_Contours |
Deterministic!$A$63:$H$69 |
Each contour's depth and the area it encloses, then the GOC's and the OWC's area terms and the table clipped at each |
DET_GIIP |
Deterministic!$B$41 |
Gas initially in place, GIIP, Bscf |
DET_GOC |
Deterministic!$B$5 |
Gas-oil contact, ft |
DET_GRVGas |
Deterministic!$B$40 |
Gas-cap gross rock volume, depth-area table, acre·ft |
DET_GRVOil |
Deterministic!$B$49 |
Oil-leg gross rock volume, above the OWC less the gas cap, acre·ft |
DET_GRVOwc |
Deterministic!$B$48 |
Gross rock volume above the OWC, acre·ft |
DET_HCIIP |
Deterministic!$B$55 |
Field in place, STOIIP + GIIP / that, MMBOE |
DET_Inputs |
Deterministic!$B$4:$B$18 |
The depth-area rule, the contacts, net-to-gross and porosity, each segment's water saturation and recovery factor, Bo, the gas at the GOC, its condensate yield and the oil-equivalent factor |
DET_Mega |
Deterministic!$B$22 |
Standard cubic feet in a million, scf/MMscf |
DET_NTG |
Deterministic!$B$7 |
Net-to-gross ratio, both segments, v/v |
DET_OWC |
Deterministic!$B$6 |
Oil-water contact, ft |
DET_P |
Deterministic!$B$13 |
Reservoir pressure at the GOC, psia |
DET_Phi |
Deterministic!$B$8 |
Porosity of the net rock, both segments, % |
DET_Ppc |
Deterministic!$B$30 |
Pseudo-critical pressure (Sutton), psia |
DET_Ppr |
Deterministic!$B$32 |
Pseudo-reduced pressure |
DET_PprMax |
Deterministic!$B$24 |
DAK's range, highest pseudo-reduced pressure |
DET_PprMin |
Deterministic!$B$23 |
DAK's range, lowest pseudo-reduced pressure |
DET_R0 |
Deterministic!$B$21 |
Rankine offset, °F to °R, °R |
DET_RFGas |
Deterministic!$B$17 |
Gas recovery factor, % |
DET_RFOil |
Deterministic!$B$11 |
Oil recovery factor, % |
DET_RecBoe |
Deterministic!$B$56 |
Field recoverable, oil + recoverable gas / that, MMBOE |
DET_RecGas |
Deterministic!$B$43 |
Recoverable gas at the recovery factor, Bscf |
DET_RecOil |
Deterministic!$B$51 |
Recoverable oil at the recovery factor, MMSTB |
DET_Results |
Deterministic!$B$29:$B$58 |
The rule's code, Bg at the GOC, each segment's area, column, gross rock volume, in place and recoverable volumes, the field in barrels of oil equivalent, and two checks |
DET_Rule |
Deterministic!$B$4 |
Depth-area rule (Mixed: pyramidal for a tapering slice) |
DET_RuleCode |
Deterministic!$B$29 |
Depth-area rule: 1 trapezoidal, 2 pyramidal, 3 mixed |
DET_SG |
Deterministic!$B$15 |
Gas specific gravity, air = 1 |
DET_STOIIP |
Deterministic!$B$50 |
Stock-tank oil initially in place, STOIIP, MMSTB |
DET_ScfPerBoe |
Deterministic!$B$54 |
Gas a BOE with its condensate, 1/(1/BOE factor + yield/10⁶), scf/BOE |
DET_SwGas |
Deterministic!$B$12 |
Water saturation of the gas cap, % |
DET_SwOil |
Deterministic!$B$9 |
Water saturation of the oil leg, % |
DET_T |
Deterministic!$B$14 |
Reservoir temperature, °F |
DET_Tpc |
Deterministic!$B$31 |
Pseudo-critical temperature (Sutton), °R |
DET_Tpr |
Deterministic!$B$33 |
Pseudo-reduced temperature |
DET_TprMax |
Deterministic!$B$26 |
DAK's range, highest pseudo-reduced temperature |
DET_TprMin |
Deterministic!$B$25 |
DAK's range, lowest pseudo-reduced temperature |
DET_Z |
Deterministic!$B$34 |
Gas z-factor at the GOC (DAK) |
DET_ZCheck |
Deterministic!$B$58 |
z-factor range check verdict |
DET_ZCheckNote |
Deterministic!$C$58 |
z-factor range check comment |
MCS_Base |
'Monte Carlo'!$B$28 |
Oil leg STOIIP of the base case (each input at its mode or mean), MMSTB |
MCS_CorrMax |
'Monte Carlo'!$B$6 |
Largest correlation between two sampled inputs |
MCS_Distributions |
'Monte Carlo'!$A$14:$L$23 |
Each input's distribution and code, A, B, C, permutation multiplier and offset, then its shift, base case, mean and validity |
MCS_GBase |
'Monte Carlo'!$B$29 |
Gas cap GIIP of the base case, Bscf |
MCS_IndependenceCheck |
'Monte Carlo'!$B$31 |
Independence check verdict |
MCS_IndependenceCheckNote |
'Monte Carlo'!$C$31 |
Independence check comment |
MCS_Inputs |
'Monte Carlo'!$B$4:$B$8 |
The number of trials, the fewest for stable percentiles, the largest input correlation, and the range of P10/P90 ratios expected |
MCS_MaxCorr |
'Monte Carlo'!$B$27 |
Largest correlation between two sampled inputs |
MCS_NMin |
'Monte Carlo'!$B$5 |
Fewest trials for stable percentiles |
MCS_P10Pos |
'Monte Carlo'!$B$9 |
Position of P10 in PO.RES.MC.Percentiles' output |
MCS_RFCheck |
'Monte Carlo'!$B$32 |
Recovery factor range check verdict |
MCS_RFCheckNote |
'Monte Carlo'!$C$32 |
Recovery factor range check comment |
MCS_RatioMax |
'Monte Carlo'!$B$8 |
In-place P10/P90 ratio, highest expected |
MCS_RatioMin |
'Monte Carlo'!$B$7 |
In-place P10/P90 ratio, lowest expected |
MCS_Results |
'Monte Carlo'!$B$26:$B$32 |
The inputs valid, the largest correlation between sampled inputs, the base cases and three checks |
MCS_SampleCheck |
'Monte Carlo'!$B$30 |
Sampling check verdict |
MCS_SampleCheckNote |
'Monte Carlo'!$C$30 |
Sampling check comment |
MCS_Valid |
'Monte Carlo'!$B$26 |
Inputs valid (no shared factor with n, each mode inside its triangle) |
MCS_n |
'Monte Carlo'!$B$4 |
Number of trials, 10 to 1,000 |
PVS_Checks |
Summary!$B$15:$B$26 |
Every check of the workbook, read from its sheet |
PVS_GP50 |
Summary!$B$8 |
Gas cap GIIP, P50, Bscf |
PVS_Overall |
Summary!$B$4 |
Volumetrics check verdict |
PVS_OverallNote |
Summary!$C$4 |
Volumetrics check comment |
PVS_P50 |
Summary!$B$7 |
Oil leg STOIIP, P50, MMSTB |
PVS_RFCorr |
Summary!$B$12 |
Oil recovery factor of the correlation picked, % |
PVS_Resource_Results |
Summary!$B$7:$B$12 |
STOIIP and GIIP at P50, the field's recoverable P90, P50 and P10, and the correlated oil recovery factor |
PVS_TP10 |
Summary!$B$11 |
Field recoverable, P10, MMBOE |
PVS_TP50 |
Summary!$B$10 |
Field recoverable, P50, MMBOE |
PVS_TP90 |
Summary!$B$9 |
Field recoverable, P90, MMBOE |
PVS_Verdict |
Summary!$B$4 |
One verdict over every check of the workbook |
PVS_VerdictNote |
Summary!$C$4 |
One verdict over every check of the workbook comment |
RCF_AgreeTol |
Recovery!$B$10 |
Largest gap between the two water-drive correlations, % |
RCF_AgreementCheck |
Recovery!$B$29 |
Water-drive agreement check verdict |
RCF_AgreementCheckNote |
Recovery!$C$29 |
Water-drive agreement check comment |
RCF_Analogues |
Recovery!$A$36:$E$38 |
Each drive mechanism's lowest and highest analogue recovery factor, and the recoverable oil at each |
RCF_AssumedCheck |
Recovery!$B$30 |
Assumed factor check verdict |
RCF_AssumedCheckNote |
Recovery!$C$30 |
Assumed factor check comment |
RCF_Code |
Recovery!$B$17 |
Correlation: 1 Arps gas, 2 Arps water, 3 Guthrie-Greenberger |
RCF_Corr |
Recovery!$B$22 |
Recovery factor of the correlation picked, % |
RCF_Gap |
Recovery!$B$26 |
Correlation less the factor the Deterministic sheet assumes, % |
RCF_Gg |
Recovery!$B$20 |
Recovery factor, Guthrie-Greenberger water drive, % |
RCF_H |
Recovery!$B$13 |
Net pay, the oil column × net-to-gross (Deterministic), ft |
RCF_High |
Recovery!$B$24 |
Analogue range for its drive, highest, % |
RCF_Inputs |
Recovery!$B$4:$B$10 |
The correlation, permeability, viscosities, abandonment pressure and the check limits |
RCF_K |
Recovery!$B$5 |
Permeability, mD |
RCF_Low |
Recovery!$B$23 |
Analogue range for its drive, lowest, % |
RCF_Mode |
Recovery!$B$4 |
Recovery factor correlation |
RCF_ModeGG |
Recovery!$B$14 |
PO.RES.RF.Analogue's mode for Guthrie-Greenberger |
RCF_Muo |
Recovery!$B$6 |
Oil viscosity, initial (at the bubble point), cp |
RCF_Muw |
Recovery!$B$7 |
Water viscosity, initial (water drive, Arps), cp |
RCF_Pa |
Recovery!$B$8 |
Abandonment pressure (Arps), psia |
RCF_PressureCheck |
Recovery!$B$27 |
Pressure check verdict |
RCF_PressureCheckNote |
Recovery!$C$27 |
Pressure check comment |
RCF_RangeCheck |
Recovery!$B$28 |
Analogue range check verdict |
RCF_RangeCheckNote |
Recovery!$C$28 |
Analogue range check comment |
RCF_Rec |
Recovery!$B$25 |
Recoverable oil at the correlation's factor, MMSTB |
RCF_Results |
Recovery!$B$17:$B$30 |
The correlation's code, the three recovery factors and the water-drive gap, the one picked, its drive's analogue range, the recoverable oil, the gap to the assumed factor and four checks |
RCF_Sgd |
Recovery!$B$18 |
Recovery factor, Arps solution-gas drive, % |
RCF_Tol |
Recovery!$B$9 |
Largest gap between the correlation and the assumed factor, % |
RCF_Wd |
Recovery!$B$19 |
Recovery factor, Arps water drive, % |
RCF_WdGap |
Recovery!$B$21 |
Arps less Guthrie-Greenberger, % |
RPT_BaseCheck |
Resources!$B$25 |
Base case check verdict |
RPT_BaseCheckNote |
Resources!$C$25 |
Base case check comment |
RPT_Curve |
Resources!$A$34:$D$46 |
Probabilities of exceeding, and the recoverable oil equivalent of each segment and of the field exceeded with each |
RPT_GMean |
Resources!$C$7 |
Gas cap: gas in place, GIIP, Mean |
RPT_GP10 |
Resources!$F$7 |
Gas cap: gas in place, GIIP, P10 |
RPT_GP50 |
Resources!$E$7 |
Gas cap: gas in place, GIIP, P50 |
RPT_GP90 |
Resources!$D$7 |
Gas cap: gas in place, GIIP, P90 |
RPT_GPBase |
Resources!$B$22 |
Probability of exceeding the deterministic GIIP, % |
RPT_GRatio |
Resources!$B$20 |
Gas cap GIIP P10/P90 |
RPT_GRecMean |
Resources!$C$8 |
Gas cap: recoverable gas, Mean |
RPT_GRecP10 |
Resources!$F$8 |
Gas cap: recoverable gas, P10 |
RPT_GRecP50 |
Resources!$E$8 |
Gas cap: recoverable gas, P50 |
RPT_GRecP90 |
Resources!$D$8 |
Gas cap: recoverable gas, P90 |
RPT_Gap10 |
Resources!$B$24 |
Field P10 against the segments' P10s added, % |
RPT_Gap90 |
Resources!$B$23 |
Field P90 against the segments' P90s added, % |
RPT_HMean |
Resources!$C$9 |
Field: hydrocarbons in place, Mean |
RPT_HP10 |
Resources!$F$9 |
Field: hydrocarbons in place, P10 |
RPT_HP50 |
Resources!$E$9 |
Field: hydrocarbons in place, P50 |
RPT_HP90 |
Resources!$D$9 |
Field: hydrocarbons in place, P90 |
RPT_Mean |
Resources!$C$5 |
Oil leg: oil in place, STOIIP, Mean |
RPT_P10 |
Resources!$F$5 |
Oil leg: oil in place, STOIIP, P10 |
RPT_P50 |
Resources!$E$5 |
Oil leg: oil in place, STOIIP, P50 |
RPT_P90 |
Resources!$D$5 |
Oil leg: oil in place, STOIIP, P90 |
RPT_PBase |
Resources!$B$21 |
Probability of exceeding the deterministic STOIIP, % |
RPT_Ratio |
Resources!$B$19 |
Oil leg STOIIP P10/P90 |
RPT_RecMean |
Resources!$C$6 |
Oil leg: recoverable oil, Mean |
RPT_RecP10 |
Resources!$F$6 |
Oil leg: recoverable oil, P10 |
RPT_RecP50 |
Resources!$E$6 |
Oil leg: recoverable oil, P50 |
RPT_RecP90 |
Resources!$D$6 |
Oil leg: recoverable oil, P90 |
RPT_Report |
Resources!$A$5:$F$10 |
Each segment's oil or gas in place and recoverable, and the field's in barrels of oil equivalent: deterministic, mean, P90, P50 and P10 |
RPT_Results |
Resources!$B$19:$B$27 |
The P10/P90 spreads, the chance of beating the deterministic STOIIP and GIIP, the field's P90 and P10 against the segments' added, and three checks |
RPT_RollUp |
Resources!$A$14:$E$17 |
The recoverable oil equivalent of each segment, their percentiles added, and the field's from the trials summed: mean, P90, P50 and P10 |
RPT_RollUpCheck |
Resources!$B$27 |
Roll-up check verdict |
RPT_RollUpCheckNote |
Resources!$C$27 |
Roll-up check comment |
RPT_SpreadCheck |
Resources!$B$26 |
Spread check verdict |
RPT_SpreadCheckNote |
Resources!$C$26 |
Spread check comment |
RPT_TMean |
Resources!$C$10 |
Field: recoverable hydrocarbons, Mean |
RPT_TP10 |
Resources!$F$10 |
Field: recoverable hydrocarbons, P10 |
RPT_TP50 |
Resources!$E$10 |
Field: recoverable hydrocarbons, P50 |
RPT_TP90 |
Resources!$D$10 |
Field: recoverable hydrocarbons, P90 |
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 | ProbabilisticVolumetrics.xlsx, 144 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.
Gas Material Balance
PO Add-in + Microsoft 365How much gas a reservoir holds and will recover, from its p/z history checked for water drive and overpressure to a volumetric depletion forecast.
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.
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








