---
cid: po.bp.res.volumetrics.montecarlo
hub: res
tags: [reservoir, volumetrics, Monte-Carlo, probabilistic, P90, P50, P10, STOIIP, recoverable, uncertainty, Latin-hypercube, histogram, expectation-curve]
facets: { discipline: reservoir, property: oil-in-place, method-type: probabilistic }
title: Probabilistic Oil in Place by Monte Carlo
summary: "Samples six uncertain inputs to give P90, P50 and P10 oil in place and recoverable oil from a reproducible stratified sample."
slug: po.res.volumetrics.montecarlo
type: worksheet
---

# Probabilistic Oil in Place by Monte Carlo

## Description

How much oil might the structure hold, low, mid and high, once each input's uncertainty is counted? You give each of six inputs, the gross rock volume, net-to-gross, porosity, water saturation, Bo and the recovery factor, a distribution, and set the number of trials. You read off the P90, P50, P10 and mean of the oil in place and of the recoverable oil, P90 being the low case, from a stratified sample that recalculates to the same numbers every time.

**Parameters:**
- **Trials**: `VM_n`, a whole number from 10 to 1,000
- **Limits**: the fewest trials `VM_NMin`, the largest correlation between sampled inputs `VM_CorrMax`, and the P10/P90 range `VM_RatioMin` to `VM_RatioMax`
- **Distributions**: for each input, in the distribution table, its distribution (1 normal, 2 lognormal, 3 triangular, 4 uniform) and A, B and C (normal: mean, standard deviation; lognormal: mean and standard deviation of ln x; triangular: minimum, mode, maximum; uniform: minimum, maximum), and its permutation multiplier a and offset fraction c

**How to use it:** The ranges are made up for the example. Set each input's distribution from the field's own spread: the GRV from the low and high maps, NTG, porosity and Sw from the petrophysics across the wells, Bo from PVT, and the RF from analogues. Give each input its own multiplier and offset, and raise n to 1,000 for a final run.

Each input is drawn from its own distribution by a deterministic stratified sampler, and STOIIP and the recoverable oil are computed trial by trial. A histogram and an expectation curve draw the outcome. There is no `RAND` or `RANDARRAY`. Each input's strata are shuffled by its own fixed permutation, so the sheet recalculates to the same numbers every time and its percentiles can be quoted and checked.

Each input column is one formula that spills n rows, and STOIIP and the recoverable oil are one formula each over the first n rows of those columns (`TAKE(first:last, n)`). There is no volatile `OFFSET`, so a saved sheet opens on its saved values without recalculating. The sheet writes the same few cells at any n, so n can go to 1,000 without the sheet growing.

Four checks give PASS, WARN or FAIL. The sampling check fails when n is over 1,000 or shares a factor with an input's multiplier, and warns when n is under the limit. The independence check warns when two sampled inputs correlate by more than the limit. The base-case check warns when the deterministic case lies outside the P90 to P10. The spread check warns when P10/P90 lies outside the range expected.

**Method:**

- **Sampling.** For input j, the shift is b_j = MOD(ROUND(c_j n), n), and trial i draws the stratum π(i) = MOD(a_j (i − 1) + b_j, n) + 1 at u = (π(i) − 0.5)/n. The input is x = F⁻¹(u), the inverse of its distribution. When a_j shares no factor with n, π visits every stratum once.
- **Volumes.** Trial i's STOIIP is 7758 GRV NTG φ (1 − Sw)/Bo and its recoverable oil STOIIP × RF.
- **Percentiles.** The percentiles are `PERCENTILE.INC` at 0.1, 0.5 and 0.9: P90 is the 10th percentile, exceeded by 90% of the trials. The histogram bins the trials equally from the smallest to the largest. The expectation curve reads the volume exceeded with each probability p as the (1 − p) percentile.
- **Base case.** The base case takes each input at its mode, mean or midpoint (e^A for a lognormal).

**Example:** The default case is the oil leg of the volumetrics family's synthetic field, the one the Volumetric Oil in Place sheet computes. The gross rock volume is triangular from 95,000 to 150,000 acre·ft about that sheet's 118,800. NTG is triangular from 0.65 to 0.85 about 0.75, and porosity normal at 0.22 ± 0.02. Sw is normal at 0.25 ± 0.04, Bo uniform from 1.20 to 1.30 bbl/STB, and the RF triangular from 25% to 45% about 35%. The multipliers are 7, 11, 13, 17, 19 and 23, with offsets of 0, 0.101, 0.211, 0.307, 0.401 and 0.503 of n, as the stratified sampler's notes give for the first six inputs. n is 300: below about 250 the lattice's columns begin to correlate (0.086 at n = 200), and at 300 the trial table stays short enough to read; the sheet is validated up to n = 1,000.

At n = 300 none of the six multipliers shares a factor with n, and the largest correlation between two sampled inputs is 0.040. STOIIP's P90, P50 and P10 are 76.02, 92.46 and 111.72 MMSTB, with a mean of 93.18 and a P10/P90 of 1.47, inside the 1.2 to 5 expected. The recoverable oil's are 24.65, 32.14 and 41.01 MMSTB, with a mean of 32.63. The base case, each input at its mode or mean, is the oil sheet's 91.24 MMSTB (31.94 recoverable): 0.99 times the P50, between the P90 and the P10, and exceeded by 53.7% of the trials. The mean lies above it because the gross rock volume's triangle leans high, its mean 121,267 acre·ft against its mode of 118,800. The trials run from 53.97 to 158.92 MMSTB. At n = 1,000 the percentiles move by less than 0.6%, to 75.61, 92.49 and 111.47 MMSTB (24.69, 32.21 and 41.06 recoverable), and the largest correlation falls to 0.016. At n = 200 the lattice's columns correlate by 0.086 and the independence check warns. At n = 50 the sampling check warns, and at n = 700, which 7 divides, it fails.

## Validity

The inputs are sampled independently: each column is shuffled on its own, and nothing ties porosity to water saturation, or area to thickness, as a real field often does. Positive correlations widen the outcome, so an independent run understates its spread. The add-in has no correlated sampler. The sample is a fixed Latin-hypercube lattice, not a random draw: repeated runs are identical, not independent replicates. The stratified sample's error is much smaller than a random one's of the same size, but the extreme tails are cut at the outer strata, at u = 0.5/n and 1 − 0.5/n. With n under about 100 the P90 and P10 are coarse. The distributions are the user's: a triangular with too narrow a range is the commonest source of overconfidence, which the spread check flags. The recovery factor is an assumption, so the recoverable oil is a resource range until a development plan supports it. The field is synthetic. Field units.

Named alternatives: the Volumetric Oil in Place sheet for the deterministic case from the map and contacts; the Recovery Factor by Drive Mechanism sheet to set the recovery factor's range; correlated sampling of porosity with water saturation, or area with thickness, which this sheet does not do.

## References

- 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.
- Capen, E.C. (1976). The Difficulty of Assessing Uncertainty. *Journal of Petroleum Technology* 28(8), SPE-5579-PA.
- Society of Petroleum Engineers (2018). *Petroleum Resources Management System (PRMS)*, revised June 2018, section 4.2 (probabilistic methods).

## Functions used

`PO.RES.MC.Sample`, `PO.RES.Vol.STOIIP`, `PO.RES.Vol.Recoverable`, `PO.RES.MC.Percentiles`

## Spreadsheet: MonteCarlo

|    | A                                                                                                                                                                                          | B                                                                               | C                                                                                                                                                                                                                                                                                                                                         | D                                                           | E                                                           | F                                                           | G                                                           | H                                                                                                                                                | I                                                                          | J                                                             | K                                  | L                        | M                                                                                                                                                                                                                                                                                                                                |
|----|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------|-------------------------------------------------------------|-------------------------------------------------------------|-------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------|---------------------------------------------------------------|------------------------------------|--------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 1  | Probabilistic Oil in Place by Monte Carlo                                                                                                                                                  |                                                                                 | Petroleum Office                                                                                                                                                                                                                                                                                                                          |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 2  | Blue cells on yellow are inputs. Set the number of trials and each input's distribution; the trials spill below and recalculate to the same numbers every time.                            |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 3  | The Number of Trials and the Limits                                                                                                                                                        |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 4  | Number of trials, 10 to 1,000                                                                                                                                                              | 300                                                                             | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 5  | Fewest trials for stable percentiles                                                                                                                                                       | 100                                                                             | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 6  | Largest correlation between two sampled inputs                                                                                                                                             | 0.05                                                                            | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 7  | STOIIP P10/P90 ratio, lowest expected                                                                                                                                                      | 1.2                                                                             | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 8  | STOIIP P10/P90 ratio, highest expected                                                                                                                                                     | 5                                                                               | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 9  | Constants                                                                                                                                                                                  |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 10 | Position of P10 in the percentile function's output                                                                                                                                        | 3                                                                               | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 11 | Position of the mean in the percentile function's output                                                                                                                                   | 4                                                                               | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 13 | Input Distributions (1 normal, 2 lognormal, 3 triangular, 4 uniform) and Their Permutations                                                                                                |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 14 | Input                                                                                                                                                                                      | Distribution                                                                    | A                                                                                                                                                                                                                                                                                                                                         | B                                                           | C                                                           | Multiplier a                                                | Offset c                                                    | Shift b                                                                                                                                          | Base case                                                                  | Mean                                                          | Sample mean                        | Valid a                  | Largest r                                                                                                                                                                                                                                                                                                                        |
| 15 | Gross rock volume (acre·ft)                                                                                                                                                                | 3                                                                               | 95000                                                                                                                                                                                                                                                                                                                                     | 118800                                                      | 150000                                                      | 7                                                           | 0                                                           | =MOD(ROUND(G15*VM_n,0),VM_n)                                                                                                                     | =CHOOSE(B15,C15,EXP(C15),D15,(C15+D15)/2)                                  | =CHOOSE(B15,C15,EXP(C15+D15^2/2),(C15+D15+E15)/3,(C15+D15)/2) | =AVERAGE(TAKE($B$82:$B$1081,VM_n)) | =IF(GCD(F15,VM_n)=1,1,0) | =0                                                                                                                                                                                                                                                                                                                               |
| 16 | Net-to-gross ratio                                                                                                                                                                         | 3                                                                               | 0.65                                                                                                                                                                                                                                                                                                                                      | 0.75                                                        | 0.85                                                        | 11                                                          | 0.101                                                       | =MOD(ROUND(G16*VM_n,0),VM_n)                                                                                                                     | =CHOOSE(B16,C16,EXP(C16),D16,(C16+D16)/2)                                  | =CHOOSE(B16,C16,EXP(C16+D16^2/2),(C16+D16+E16)/3,(C16+D16)/2) | =AVERAGE(TAKE($C$82:$C$1081,VM_n)) | =IF(GCD(F16,VM_n)=1,1,0) | =MAX(ABS(CORREL(TAKE($C$82:$C$1081,VM_n),TAKE($B$82:$B$1081,VM_n))))                                                                                                                                                                                                                                                             |
| 17 | Porosity                                                                                                                                                                                   | 1                                                                               | 0.22                                                                                                                                                                                                                                                                                                                                      | 0.02                                                        | 0                                                           | 13                                                          | 0.211                                                       | =MOD(ROUND(G17*VM_n,0),VM_n)                                                                                                                     | =CHOOSE(B17,C17,EXP(C17),D17,(C17+D17)/2)                                  | =CHOOSE(B17,C17,EXP(C17+D17^2/2),(C17+D17+E17)/3,(C17+D17)/2) | =AVERAGE(TAKE($D$82:$D$1081,VM_n)) | =IF(GCD(F17,VM_n)=1,1,0) | =MAX(ABS(CORREL(TAKE($D$82:$D$1081,VM_n),TAKE($B$82:$B$1081,VM_n))),ABS(CORREL(TAKE($D$82:$D$1081,VM_n),TAKE($C$82:$C$1081,VM_n))))                                                                                                                                                                                              |
| 18 | Water saturation                                                                                                                                                                           | 1                                                                               | 0.25                                                                                                                                                                                                                                                                                                                                      | 0.04                                                        | 0                                                           | 17                                                          | 0.307                                                       | =MOD(ROUND(G18*VM_n,0),VM_n)                                                                                                                     | =CHOOSE(B18,C18,EXP(C18),D18,(C18+D18)/2)                                  | =CHOOSE(B18,C18,EXP(C18+D18^2/2),(C18+D18+E18)/3,(C18+D18)/2) | =AVERAGE(TAKE($E$82:$E$1081,VM_n)) | =IF(GCD(F18,VM_n)=1,1,0) | =MAX(ABS(CORREL(TAKE($E$82:$E$1081,VM_n),TAKE($B$82:$B$1081,VM_n))),ABS(CORREL(TAKE($E$82:$E$1081,VM_n),TAKE($C$82:$C$1081,VM_n))),ABS(CORREL(TAKE($E$82:$E$1081,VM_n),TAKE($D$82:$D$1081,VM_n))))                                                                                                                               |
| 19 | Oil FVF, Bo (bbl/STB)                                                                                                                                                                      | 4                                                                               | 1.2                                                                                                                                                                                                                                                                                                                                       | 1.3                                                         | 0                                                           | 19                                                          | 0.401                                                       | =MOD(ROUND(G19*VM_n,0),VM_n)                                                                                                                     | =CHOOSE(B19,C19,EXP(C19),D19,(C19+D19)/2)                                  | =CHOOSE(B19,C19,EXP(C19+D19^2/2),(C19+D19+E19)/3,(C19+D19)/2) | =AVERAGE(TAKE($F$82:$F$1081,VM_n)) | =IF(GCD(F19,VM_n)=1,1,0) | =MAX(ABS(CORREL(TAKE($F$82:$F$1081,VM_n),TAKE($B$82:$B$1081,VM_n))),ABS(CORREL(TAKE($F$82:$F$1081,VM_n),TAKE($C$82:$C$1081,VM_n))),ABS(CORREL(TAKE($F$82:$F$1081,VM_n),TAKE($D$82:$D$1081,VM_n))),ABS(CORREL(TAKE($F$82:$F$1081,VM_n),TAKE($E$82:$E$1081,VM_n))))                                                                |
| 20 | Recovery factor                                                                                                                                                                            | 3                                                                               | 0.25                                                                                                                                                                                                                                                                                                                                      | 0.35                                                        | 0.45                                                        | 23                                                          | 0.503                                                       | =MOD(ROUND(G20*VM_n,0),VM_n)                                                                                                                     | =CHOOSE(B20,C20,EXP(C20),D20,(C20+D20)/2)                                  | =CHOOSE(B20,C20,EXP(C20+D20^2/2),(C20+D20+E20)/3,(C20+D20)/2) | =AVERAGE(TAKE($G$82:$G$1081,VM_n)) | =IF(GCD(F20,VM_n)=1,1,0) | =MAX(ABS(CORREL(TAKE($G$82:$G$1081,VM_n),TAKE($B$82:$B$1081,VM_n))),ABS(CORREL(TAKE($G$82:$G$1081,VM_n),TAKE($C$82:$C$1081,VM_n))),ABS(CORREL(TAKE($G$82:$G$1081,VM_n),TAKE($D$82:$D$1081,VM_n))),ABS(CORREL(TAKE($G$82:$G$1081,VM_n),TAKE($E$82:$E$1081,VM_n))),ABS(CORREL(TAKE($G$82:$G$1081,VM_n),TAKE($F$82:$F$1081,VM_n)))) |
| 22 | P90, P50 and P10 of Oil in Place and Recoverable Oil (P90 the low case)                                                                                                                    |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 23 | Inputs whose multiplier shares no factor with n                                                                                                                                            | =SUM(L15:L20)                                                                   | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 24 | Largest correlation between two sampled inputs                                                                                                                                             | =MAX(M15:M20)                                                                   | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 25 | STOIIP, P90 (exceeded with 90% probability)                                                                                                                                                | =INDEX(PO.RES.MC.Percentiles(TAKE($H$82:$H$1081,VM_n)),1)                       | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 26 | STOIIP, P50                                                                                                                                                                                | =INDEX(PO.RES.MC.Percentiles(TAKE($H$82:$H$1081,VM_n)),2)                       | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 27 | STOIIP, P10 (exceeded with 10% probability)                                                                                                                                                | =INDEX(PO.RES.MC.Percentiles(TAKE($H$82:$H$1081,VM_n)),VM_P10Pos)               | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 28 | STOIIP, mean                                                                                                                                                                               | =INDEX(PO.RES.MC.Percentiles(TAKE($H$82:$H$1081,VM_n)),VM_MeanPos)              | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 29 | Recoverable oil, P90                                                                                                                                                                       | =INDEX(PO.RES.MC.Percentiles(TAKE($I$82:$I$1081,VM_n)),1)                       | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 30 | Recoverable oil, P50                                                                                                                                                                       | =INDEX(PO.RES.MC.Percentiles(TAKE($I$82:$I$1081,VM_n)),2)                       | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 31 | Recoverable oil, P10                                                                                                                                                                       | =INDEX(PO.RES.MC.Percentiles(TAKE($I$82:$I$1081,VM_n)),VM_P10Pos)               | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 32 | Recoverable oil, mean                                                                                                                                                                      | =INDEX(PO.RES.MC.Percentiles(TAKE($I$82:$I$1081,VM_n)),VM_MeanPos)              | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 33 | STOIIP P10/P90 ratio, the spread                                                                                                                                                           | =VM_P10/VM_P90                                                                  | —                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 34 | STOIIP of the base case (each input at its mode or mean)                                                                                                                                   | =PO.RES.Vol.STOIIP(I15,I16,I17,I18,I19)                                         | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 35 | Recoverable oil of the base case                                                                                                                                                           | =PO.RES.Vol.Recoverable(VM_Base,I20)                                            | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 36 | Probability of exceeding the base-case STOIIP                                                                                                                                              | =COUNTIF(TAKE($H$82:$H$1081,VM_n),">="&VM_Base)/VM_n                            | %                                                                                                                                                                                                                                                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 37 | STOIIP, smallest trial                                                                                                                                                                     | =MIN(TAKE($H$82:$H$1081,VM_n))                                                  | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 38 | STOIIP, largest trial                                                                                                                                                                      | =MAX(TAKE($H$82:$H$1081,VM_n))                                                  | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 39 | Histogram bin width                                                                                                                                                                        | =(VM_Max-VM_Min)/ROWS(A51:A62)                                                  | MMSTB                                                                                                                                                                                                                                                                                                                                     |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 40 | Sampling check                                                                                                                                                                             | =IF(OR(VM_n>1000,VM_Valid<ROWS(A15:A20)),"FAIL",IF(VM_n<VM_NMin,"WARN","PASS")) | =IF(OR(VM_n>1000,VM_Valid<ROWS(A15:A20)),"n must be at most 1,000 and share no factor with any input's multiplier a; change n or a",IF(VM_n<VM_NMin,""&FIXED(VM_n,0)&" trials, fewer than "&FIXED(VM_NMin,0)&": the tail percentiles are coarse",""&FIXED(VM_n,0)&" stratified trials, each input's strata visited once"))                |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 41 | Independence check                                                                                                                                                                         | =IF(VM_MaxCorr<=VM_CorrMax,"PASS","WARN")                                       | =IF(VM_MaxCorr<=VM_CorrMax,"no two sampled inputs correlate by more than "&FIXED(VM_MaxCorr,2)&", as the model assumes","two sampled inputs correlate by "&FIXED(VM_MaxCorr,2)&": give each input its own multiplier and offset")                                                                                                         |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 42 | Base case check                                                                                                                                                                            | =IF(AND(VM_Base>=VM_P90,VM_Base<=VM_P10),"PASS","WARN")                         | =IF(AND(VM_Base>=VM_P90,VM_Base<=VM_P10),"the base case, "&FIXED(VM_Base/VM_P50,2)&" times the P50, lies between the P90 and the P10","the base case lies outside the P90 to P10: the distributions are skewed away from the base inputs")                                                                                                |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 43 | Spread check                                                                                                                                                                               | =IF(AND(VM_Ratio>=VM_RatioMin,VM_Ratio<=VM_RatioMax),"PASS","WARN")             | =IF(AND(VM_Ratio>=VM_RatioMin,VM_Ratio<=VM_RatioMax),"a P10/P90 of "&FIXED(VM_Ratio,2)&", within the "&FIXED(VM_RatioMin,1)&" to "&FIXED(VM_RatioMax,1)&" expected","a P10/P90 of "&FIXED(VM_Ratio,2)&", outside the "&FIXED(VM_RatioMin,1)&" to "&FIXED(VM_RatioMax,1)&" expected: check the ranges are neither too tight nor too wide") |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 45 | How to use it: set each input's range from the field's spread (maps, logs, core, PVT, analogues), give each input its own multiplier a and offset c, and raise n to 1,000 for a final run. |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 46 | The inputs are sampled independently: porosity with water saturation, or area with thickness, are not correlated here. The add-in has no correlated sampler.                               |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 49 | STOIIP Histogram (equal bins from the smallest trial to the largest)                                                                                                                       |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 50 | Upper edge (MMSTB)                                                                                                                                                                         | Bin middle (MMSTB)                                                              | Trials                                                                                                                                                                                                                                                                                                                                    | Frequency (%)                                               | Cumulative (%)                                              |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 51 | =VM_Min+1*VM_BinW                                                                                                                                                                          | =A51-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A51)                                                                                                                                                                                                                                                                                              | =C51/VM_n                                                   | =SUM($D$51:D51)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 52 | =VM_Min+2*VM_BinW                                                                                                                                                                          | =A52-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A52)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A51)                                                                                                                                                                                                                                                  | =C52/VM_n                                                   | =SUM($D$51:D52)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 53 | =VM_Min+3*VM_BinW                                                                                                                                                                          | =A53-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A53)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A52)                                                                                                                                                                                                                                                  | =C53/VM_n                                                   | =SUM($D$51:D53)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 54 | =VM_Min+4*VM_BinW                                                                                                                                                                          | =A54-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A54)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A53)                                                                                                                                                                                                                                                  | =C54/VM_n                                                   | =SUM($D$51:D54)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 55 | =VM_Min+5*VM_BinW                                                                                                                                                                          | =A55-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A55)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A54)                                                                                                                                                                                                                                                  | =C55/VM_n                                                   | =SUM($D$51:D55)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 56 | =VM_Min+6*VM_BinW                                                                                                                                                                          | =A56-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A56)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A55)                                                                                                                                                                                                                                                  | =C56/VM_n                                                   | =SUM($D$51:D56)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 57 | =VM_Min+7*VM_BinW                                                                                                                                                                          | =A57-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A57)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A56)                                                                                                                                                                                                                                                  | =C57/VM_n                                                   | =SUM($D$51:D57)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 58 | =VM_Min+8*VM_BinW                                                                                                                                                                          | =A58-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A58)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A57)                                                                                                                                                                                                                                                  | =C58/VM_n                                                   | =SUM($D$51:D58)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 59 | =VM_Min+9*VM_BinW                                                                                                                                                                          | =A59-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A59)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A58)                                                                                                                                                                                                                                                  | =C59/VM_n                                                   | =SUM($D$51:D59)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 60 | =VM_Min+10*VM_BinW                                                                                                                                                                         | =A60-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A60)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A59)                                                                                                                                                                                                                                                  | =C60/VM_n                                                   | =SUM($D$51:D60)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 61 | =VM_Min+11*VM_BinW                                                                                                                                                                         | =A61-VM_BinW/2                                                                  | =COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A61)-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A60)                                                                                                                                                                                                                                                  | =C61/VM_n                                                   | =SUM($D$51:D61)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 62 | =VM_Min+12*VM_BinW                                                                                                                                                                         | =A62-VM_BinW/2                                                                  | =VM_n-COUNTIFS(TAKE($H$82:$H$1081,VM_n),"<="&A61)                                                                                                                                                                                                                                                                                         | =C62/VM_n                                                   | =SUM($D$51:D62)                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 64 | Expectation Curve (the volume exceeded with each probability)                                                                                                                              |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 65 | Probability of exceeding (%)                                                                                                                                                               | STOIIP (MMSTB)                                                                  | Recoverable (MMSTB)                                                                                                                                                                                                                                                                                                                       |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 66 | 0.99                                                                                                                                                                                       | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A66)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A66)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 67 | 0.95                                                                                                                                                                                       | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A67)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A67)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 68 | 0.9                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A68)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A68)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 69 | 0.8                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A69)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A69)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 70 | 0.7                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A70)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A70)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 71 | 0.6                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A71)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A71)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 72 | 0.5                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A72)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A72)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 73 | 0.4                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A73)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A73)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 74 | 0.3                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A74)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A74)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 75 | 0.2                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A75)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A75)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 76 | 0.1                                                                                                                                                                                        | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A76)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A76)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 77 | 0.05                                                                                                                                                                                       | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A77)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A77)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 78 | 0.01                                                                                                                                                                                       | =PERCENTILE.INC(TAKE($H$82:$H$1081,VM_n),1-A78)                                 | =PERCENTILE.INC(TAKE($I$82:$I$1081,VM_n),1-A78)                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 80 | Trials (each column spills n rows down from its first)                                                                                                                                     |                                                                                 |                                                                                                                                                                                                                                                                                                                                           |                                                             |                                                             |                                                             |                                                             |                                                                                                                                                  |                                                                            |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 81 | Trial                                                                                                                                                                                      | GRV (acre·ft)                                                                   | NTG (v/v)                                                                                                                                                                                                                                                                                                                                 | φ (v/v)                                                     | Sw (v/v)                                                    | Bo (bbl/STB)                                                | RF (v/v)                                                    | STOIIP (STB)                                                                                                                                     | Recoverable (STB)                                                          |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |
| 82 | =SEQUENCE(VM_n)                                                                                                                                                                            | =PO.RES.MC.Sample($B$15,$C$15,$D$15,$E$15,VM_n,$F$15,$H$15)                     | =PO.RES.MC.Sample($B$16,$C$16,$D$16,$E$16,VM_n,$F$16,$H$16)                                                                                                                                                                                                                                                                               | =PO.RES.MC.Sample($B$17,$C$17,$D$17,$E$17,VM_n,$F$17,$H$17) | =PO.RES.MC.Sample($B$18,$C$18,$D$18,$E$18,VM_n,$F$18,$H$18) | =PO.RES.MC.Sample($B$19,$C$19,$D$19,$E$19,VM_n,$F$19,$H$19) | =PO.RES.MC.Sample($B$20,$C$20,$D$20,$E$20,VM_n,$F$20,$H$20) | =PO.RES.Vol.STOIIP(TAKE($B$82:$B$1081,VM_n),TAKE($C$82:$C$1081,VM_n),TAKE($D$82:$D$1081,VM_n),TAKE($E$82:$E$1081,VM_n),TAKE($F$82:$F$1081,VM_n)) | =PO.RES.Vol.Recoverable(TAKE($H$82:$H$1081,VM_n),TAKE($G$82:$G$1081,VM_n)) |                                                               |                                    |                          |                                                                                                                                                                                                                                                                                                                                  |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.RES.MC.Sample | =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.MC.Percentiles | =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.Vol.STOIIP | =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). |
| PO.RES.Vol.Recoverable | =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. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| VM_n | $B$4 | Number of trials, 10 to 1,000 |
| VM_NMin | $B$5 | Fewest trials for stable percentiles |
| VM_CorrMax | $B$6 | Largest correlation between two sampled inputs |
| VM_RatioMin | $B$7 | STOIIP P10/P90 ratio, lowest expected |
| VM_RatioMax | $B$8 | STOIIP P10/P90 ratio, highest expected |
| VM_Inputs | $B$4:$B$8 | The number of trials, the fewest for stable percentiles, the largest correlation between sampled inputs, and the range of P10/P90 ratios expected |
| VM_P10Pos | $B$10 | Position of P10 in the percentile function's output |
| VM_MeanPos | $B$11 | Position of the mean in the percentile function's output |
| VM_Distributions | $A$15:$M$20 | Each input's distribution, A (mean, mean of ln, min), B (sd, sd of ln, mode, max), C (triangular max), permutation multiplier and offset, then its shift, base case, mean, sample mean, multiplier check and largest correlation |
| VM_Valid | $B$23 | Inputs whose multiplier shares no factor with n |
| VM_MaxCorr | $B$24 | Largest correlation between two sampled inputs |
| VM_P90 | $B$25 | STOIIP, P90 (exceeded with 90% probability), MMSTB |
| VM_P50 | $B$26 | STOIIP, P50, MMSTB |
| VM_P10 | $B$27 | STOIIP, P10 (exceeded with 10% probability), MMSTB |
| VM_Mean | $B$28 | STOIIP, mean, MMSTB |
| VM_RecP90 | $B$29 | Recoverable oil, P90, MMSTB |
| VM_RecP50 | $B$30 | Recoverable oil, P50, MMSTB |
| VM_RecP10 | $B$31 | Recoverable oil, P10, MMSTB |
| VM_RecMean | $B$32 | Recoverable oil, mean, MMSTB |
| VM_Ratio | $B$33 | STOIIP P10/P90 ratio, the spread |
| VM_Base | $B$34 | STOIIP of the base case (each input at its mode or mean), MMSTB |
| VM_BaseRec | $B$35 | Recoverable oil of the base case, MMSTB |
| VM_PBase | $B$36 | Probability of exceeding the base-case STOIIP, % |
| VM_Min | $B$37 | STOIIP, smallest trial, MMSTB |
| VM_Max | $B$38 | STOIIP, largest trial, MMSTB |
| VM_BinW | $B$39 | Histogram bin width, MMSTB |
| VM_SampleCheck | $B$40 | Sampling check verdict |
| VM_SampleCheckNote | $C$40 | Sampling check comment |
| VM_IndependenceCheck | $B$41 | Independence check verdict |
| VM_IndependenceCheckNote | $C$41 | Independence check comment |
| VM_BaseCheck | $B$42 | Base case check verdict |
| VM_BaseCheckNote | $C$42 | Base case check comment |
| VM_SpreadCheck | $B$43 | Spread check verdict |
| VM_SpreadCheckNote | $C$43 | Spread check comment |
| VM_Results | $B$23:$B$43 | The multiplier count, the largest input correlation, STOIIP and recoverable P90, P50, P10 and mean, the P10/P90 ratio, the base case and its exceedance probability, the smallest and largest trial, the bin width and four checks |
| VM_Histogram | $A$51:$E$62 | Each STOIIP bin's upper edge and middle, its count of trials, its frequency and the cumulative frequency |
| VM_Curve | $A$66:$C$78 | Probabilities of exceeding, and the STOIIP and recoverable oil exceeded with each |

---

## Related Blueprints
- [CO2 Storage Capacity of a Saline Formation](/blueprint/po.res.ccs.storage.capacity.md)
- [Volumetric Oil in Place](/blueprint/po.res.volumetrics.stoiip.md)
- [Volumetric Gas in Place](/blueprint/po.res.volumetrics.giip.md)
- [Recovery Factor by Drive Mechanism](/blueprint/po.res.recovery.factor.md)
- [Waterflood Vertical Sweep in a Layered Reservoir](/blueprint/po.res.waterflood.dykstraparsons.md)
- [Injector Hall Plot and Voidage Replacement](/blueprint/po.res.hall.plot.md)

