---
id: po.wb.res.volumetrics-probabilistic
title: Probabilistic Volumetrics
summary: "How 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."
category: Reservoir
requires:
  - po-addin
  - excel-365
tags:
  - volumetrics
  - Monte-Carlo
  - probabilistic
  - p90
  - p50
  - p10
  - STOIIP
  - GIIP
  - recoverable
  - gross-rock-volume
  - depth-area
  - gas-cap
  - condensate
  - recovery-factor
  - Arps
  - Guthrie-Greenberger
  - analogue
  - aggregation
  - Latin-hypercube
  - expectation-curve
  - uncertainty
  - reserves
---

## 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.DepthArea`, `PO.RES.Vol.STOIIP`, `PO.RES.Vol.GIIP`, `PO.RES.Vol.Recoverable`, `PO.RES.RF.Analogue`, `PO.RES.MC.Sample`, `PO.RES.MC.Percentiles`, `PO.PVT.Ppc.BySutton`, `PO.PVT.Tpc.BySutton`, `PO.PVT.Z.ByDAK` and `PO.PVT.Bg.ByDefinition`.
