---
cid: po.bp.res.volumetrics.stoiip
hub: res
tags: [reservoir, volumetrics, STOIIP, OOIP, oil-in-place, gross-rock-volume, GRV, depth-area, net-to-gross, recovery-factor, reserves, contacts]
facets: { discipline: reservoir, property: oil-in-place, method-type: analytical }
title: Volumetric Oil in Place
summary: "Calculates STOIIP and recoverable oil for an oil leg from a depth-area table between contacts or from area and thickness."
slug: po.res.volumetrics.stoiip
type: worksheet
---

# Volumetric Oil in Place

## Description

How much oil does the structure hold, and how much of it will come out? You enter the top-reservoir depth-area table and the gas-oil and oil-water contacts, or an area, a thickness and a geometric factor, then the net-to-gross, porosity, water saturation, Bo and a recovery factor. You read off the oil leg's gross rock volume by both methods and the geometric factor the map implies, the stock-tank oil initially in place (STOIIP) and the recoverable oil.

**Parameters:**
- **Method**: `VO_Method` (1 the depth-area table, 2 area × thickness) and the depth-area rule `VO_DARule` (1 trapezoidal, 2 pyramidal, 3 pyramidal where a slice's smaller area is at most half its larger)
- **Contacts**: `VO_GOC` and `VO_OWC` (ft TVDSS); a GOC at or above the crest means no gas cap
- **Area × thickness**: the area inside the OWC `VO_Area` (acres), the gross oil column `VO_H` (ft) and the geometric factor `VO_Factor`
- **Rock and fluid**: `VO_NTG`, `VO_Phi`, `VO_Sw` and `VO_Bo` (bbl/STB)
- **Recovery**: the recovery factor `VO_RF`
- **Limits**: `VO_Tol` for the two volumes' difference, and the analogues' range `VO_RFMin` to `VO_RFMax`
- **Contours**: each top-reservoir depth and the area it encloses, crest first, in the contour table

**How to use it:** The field is synthetic. Paste your top-reservoir contours over the table, crest first and on past the OWC: each depth and the area it encloses, planimetered or from the mapping package. Set the contacts from pressure gradients or logs, NTG, porosity and Sw from the petrophysics of the oil leg, and Bo from PVT at the initial pressure. Take the RF from an analogue (the Recovery Factor by Drive Mechanism sheet) or a forecast.

A contact rarely falls on a contour. Each contact's area is interpolated between the contours either side of it, and the table is clipped at the contact before it is integrated. The table also integrates the map down to every contour, and the chart draws the STOIIP an OWC at each depth would give.

Three checks give PASS, WARN or FAIL. The contacts check fails when the OWC is not below the GOC or lies below the deepest contour. The gross rock volume check warns when area × thickness differs from the table by more than the limit, and gives the geometric factor the map implies. The recovery factor check warns when the RF lies outside the analogues' range.

**Method:**

- **Contacts.** A contact's area is A_i + (C − d_i)/(d_{i+1} − d_i) (A_{i+1} − A_i), between the contours either side of it. Clipped at a contact, each contour keeps its depth and area above the contact and takes the contact's below, so the depth-area integration runs from the crest to the contact.
- **Gross rock volume.** The oil leg's GRV is the volume above the OWC less the volume above the GOC. By the other method it is A h F. The factor the map implies is the table's GRV over the area at the OWC times the oil column.
- **In place and recoverable.** STOIIP = 7758 GRV NTG φ (1 − Sw)/Bo, 7758 being the barrels in an acre-foot, and the recoverable oil is STOIIP × RF.

**Example:** The default case is the volumetrics family's synthetic field, which the gas-in-place and Monte Carlo sheets share. It is a four-way dip closure with its crest at 7,000 ft, a gas cap down to a GOC at 7,080 ft and an oil leg down to an OWC at 7,180 ft. The reservoir is thicker than the 180 ft hydrocarbon column. Its contours enclose 260 acres at 7,040 ft and 2,720 acres at 7,240 ft, the spill. The sand is 75% net with 22% porosity and 25% water in the oil leg; Bo is 1.25 bbl/STB and the recovery factor 35%.

The GOC at 7,080 ft falls on a contour and encloses 620 acres. The OWC at 7,180 ft falls between the 7,160 and 7,200 ft contours and encloses 1,820 acres. Above the GOC the map holds 20,553 acre·ft, the crest's slice by the pyramidal rule, and above the OWC 139,353, so the oil leg is 118,800 acre·ft. Area × thickness, 1,820 acres × 100 ft × 0.65, gives 118,300, 0.4% less and within the 10% limit; the map implies a factor of 0.653. Each acre-foot holds 7758 × 0.75 × 0.22 × 0.75 / 1.25 = 768 STB, so STOIIP is 91.24 MMSTB, and at 35%, inside the analogues' 10% to 60%, the recoverable oil is 31.94 MMSTB. The area × thickness method (method 2) gives 90.86 MMSTB, and the pyramidal rule throughout 118,074 acre·ft and 90.69 MMSTB. With no gas cap, the GOC at the crest, the 180 ft column holds 139,353 acre·ft and 107.03 MMSTB; area × thickness, still set for the 100 ft leg, falls 15.1% short, and the check warns. An OWC at 7,260 ft lies below the map and fails the contacts check, and a recovery factor of 5% warns.

## Validity

The volumetric method is as good as its map, contacts and averages. The top map alone bounds the rock only when the reservoir is thicker than the hydrocarbon column; a thinner one needs a base map, or an isopach integrated instead, and its volume below the base taken off. The area between contours is taken as linear in depth, and the depth-area rule decides how each slice tapers: the trapezoidal rule overstates a dome's crest, which is why rule 3 uses the pyramidal one there. NTG, porosity and Sw are single averages; a layered reservoir is better summed zone by zone. The recovery factor is an assumption, not a result: the recoverable oil is a resource estimate until a development plan and a forecast support it, and SPE-PRMS asks for both before it is called reserves. The field is synthetic. Field units.

Named alternatives: the Probabilistic Oil in Place by Monte Carlo sheet for the uncertainty in each input; the Volumetric Gas in Place sheet for the gas cap above the GOC; the Recovery Factor by Drive Mechanism sheet for the recovery factor; an isopach map integrated in place of the top map for a reservoir thinner than its column.

## References

- Craft, B.C. and Hawkins, M.F. (1991). *Applied Petroleum Reservoir Engineering*, 2nd ed., revised by Terry, R.E. Prentice Hall, ch. 1 and 3.
- Ahmed, T. (2019). *Reservoir Engineering Handbook*, 5th ed. Gulf Professional Publishing, ch. 4 (volumetric estimates).
- Dake, L.P. (1978). *Fundamentals of Reservoir Engineering*. Elsevier, ch. 1.
- Society of Petroleum Engineers (2018). *Petroleum Resources Management System (PRMS)*, revised June 2018.

## Functions used

`PO.RES.Vol.GRV.DepthArea`, `PO.RES.Vol.GRV`, `PO.RES.Vol.STOIIP`, `PO.RES.Vol.Recoverable`

## Spreadsheet: Stoiip

|    | A                                                                                                                                                                                                           | B                                                                                  | C                                                                                                                                                                                                                                                                                                                                                                                                                             | D                                  | E                                                                       | F                | G                            | H                                                                       | I                | J                            |
|----|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------|-------------------------------------------------------------------------|------------------|------------------------------|-------------------------------------------------------------------------|------------------|------------------------------|
| 1  | Volumetric Oil in Place                                                                                                                                                                                     |                                                                                    | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                              |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 2  | Blue cells on yellow are inputs. Set the contacts, the rock and fluid properties and a recovery factor; paste your own top-reservoir contours over the table below.                                         |                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                               |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 3  | The Method, the Contacts, the Rock and Fluid, and the Limits                                                                                                                                                |                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                               |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 4  | Gross rock volume: 1 depth-area table, 2 area × thickness                                                                                                                                                   | 1                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 5  | Depth-area rule: 1 trapezoidal, 2 pyramidal, 3 mixed                                                                                                                                                        | 3                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 6  | Gas-oil contact (at or above the crest for no gas cap)                                                                                                                                                      | 7080                                                                               | ft                                                                                                                                                                                                                                                                                                                                                                                                                            |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 7  | Oil-water contact                                                                                                                                                                                           | 7180                                                                               | ft                                                                                                                                                                                                                                                                                                                                                                                                                            |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 8  | Area × thickness: area inside the OWC                                                                                                                                                                       | 1820                                                                               | acres                                                                                                                                                                                                                                                                                                                                                                                                                         |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 9  | Area × thickness: gross oil column                                                                                                                                                                          | 100                                                                                | ft                                                                                                                                                                                                                                                                                                                                                                                                                            |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 10 | Area × thickness: geometric factor (1 for a slab)                                                                                                                                                           | 0.65                                                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 11 | Net-to-gross ratio                                                                                                                                                                                          | 0.75                                                                               | v/v                                                                                                                                                                                                                                                                                                                                                                                                                           |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 12 | Porosity of the net rock                                                                                                                                                                                    | 0.22                                                                               | %                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 13 | Initial water saturation of the oil leg                                                                                                                                                                     | 0.25                                                                               | %                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 14 | Initial oil formation volume factor                                                                                                                                                                         | 1.25                                                                               | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                       |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 15 | Recovery factor                                                                                                                                                                                             | 0.35                                                                               | %                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 16 | Largest difference between the two gross rock volumes                                                                                                                                                       | 0.1                                                                                | %                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 17 | Recovery factor range of the analogues, lowest                                                                                                                                                              | 0.1                                                                                | %                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 18 | Recovery factor range of the analogues, highest                                                                                                                                                             | 0.6                                                                                | %                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 20 | Gross Rock Volume, Oil in Place and Recoverable Oil                                                                                                                                                         |                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                               |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 21 | Area enclosed at the GOC (interpolated between contours)                                                                                                                                                    | =SUM($E$43:$E$49)                                                                  | acres                                                                                                                                                                                                                                                                                                                                                                                                                         |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 22 | Area enclosed at the OWC (interpolated between contours)                                                                                                                                                    | =SUM($H$43:$H$49)                                                                  | acres                                                                                                                                                                                                                                                                                                                                                                                                                         |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 23 | Gross rock volume above the GOC (the gas cap)                                                                                                                                                               | =PO.RES.Vol.GRV.DepthArea($F$43:$F$49,$G$43:$G$49,VO_DARule)                       | acre·ft                                                                                                                                                                                                                                                                                                                                                                                                                       |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 24 | Gross rock volume above the OWC                                                                                                                                                                             | =PO.RES.Vol.GRV.DepthArea($I$43:$I$49,$J$43:$J$49,VO_DARule)                       | acre·ft                                                                                                                                                                                                                                                                                                                                                                                                                       |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 25 | Oil-leg gross rock volume, depth-area table                                                                                                                                                                 | =VO_GRVOwc-VO_GRVGoc                                                               | acre·ft                                                                                                                                                                                                                                                                                                                                                                                                                       |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 26 | Oil-leg gross rock volume, area × thickness × factor                                                                                                                                                        | =PO.RES.Vol.GRV(VO_Area,VO_H,VO_Factor)                                            | acre·ft                                                                                                                                                                                                                                                                                                                                                                                                                       |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 27 | Area × thickness against the table                                                                                                                                                                          | =VO_GRVah/VO_GRVda-1                                                               | %                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 28 | Oil column, OWC less the GOC or the crest                                                                                                                                                                   | =VO_OWC-MAX(VO_GOC,$A$43)                                                          | ft                                                                                                                                                                                                                                                                                                                                                                                                                            |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 29 | Geometric factor the map implies                                                                                                                                                                            | =VO_GRVda/(VO_AOWC*VO_Column)                                                      | —                                                                                                                                                                                                                                                                                                                                                                                                                             |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 30 | Oil-leg gross rock volume used                                                                                                                                                                              | =IF(VO_Method=2,VO_GRVah,VO_GRVda)                                                 | acre·ft                                                                                                                                                                                                                                                                                                                                                                                                                       |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 31 | Oil in place per acre-foot of rock, 7758 NTG φ (1 − Sw)/Bo                                                                                                                                                  | =PO.RES.Vol.STOIIP(1,VO_NTG,VO_Phi,VO_Sw,VO_Bo)                                    | STB/acre·ft                                                                                                                                                                                                                                                                                                                                                                                                                   |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 32 | Stock-tank oil initially in place, STOIIP                                                                                                                                                                   | =PO.RES.Vol.STOIIP(VO_GRV,VO_NTG,VO_Phi,VO_Sw,VO_Bo)                               | MMSTB                                                                                                                                                                                                                                                                                                                                                                                                                         |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 33 | Recoverable oil at the recovery factor                                                                                                                                                                      | =PO.RES.Vol.Recoverable(VO_STOIIP,VO_RF)                                           | MMSTB                                                                                                                                                                                                                                                                                                                                                                                                                         |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 34 | Contacts check                                                                                                                                                                                              | =IF(VO_OWC<=VO_GOC,"FAIL",IF(VO_OWC>$A$49,"FAIL",IF(VO_GOC<=$A$43,"PASS","PASS"))) | =IF(VO_OWC<=VO_GOC,"the OWC is not below the GOC, so there is no oil leg",IF(VO_OWC>$A$49,"the OWC lies below the deepest contour, "&FIXED($A$49,0)&" ft: extend the map to it",IF(VO_GOC<=$A$43,"no gas cap, and a "&FIXED(VO_Column,0)&" ft oil column above the OWC at "&FIXED(VO_OWC,0)&" ft","a "&FIXED(VO_Column,0)&" ft oil column between the GOC at "&FIXED(VO_GOC,0)&" ft and the OWC at "&FIXED(VO_OWC,0)&" ft"))) |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 35 | Gross rock volume check                                                                                                                                                                                     | =IF(ABS(VO_Diff)<=VO_Tol,"PASS","WARN")                                            | =IF(ABS(VO_Diff)<=VO_Tol,"area × thickness is within "&FIXED(ABS(VO_Diff)*100,1)&"% of the depth-area volume","area × thickness differs from the depth-area volume by "&FIXED(VO_Diff*100,1)&"%: the map implies a geometric factor of "&FIXED(VO_FactorMap,2))                                                                                                                                                               |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 36 | Recovery factor check                                                                                                                                                                                       | =IF(AND(VO_RF>=VO_RFMin,VO_RF<=VO_RFMax),"PASS","WARN")                            | =IF(AND(VO_RF>=VO_RFMin,VO_RF<=VO_RFMax),"a recovery factor of "&FIXED(VO_RF*100,0)&"% lies within the analogues' "&FIXED(VO_RFMin*100,0)&" to "&FIXED(VO_RFMax*100,0)&"%","a recovery factor of "&FIXED(VO_RF*100,0)&"% lies outside the analogues' "&FIXED(VO_RFMin*100,0)&" to "&FIXED(VO_RFMax*100,0)&"%: support it with an analogue or a forecast")                                                                     |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 38 | How to use it: paste your top-reservoir depths and the areas they enclose over the table, crest first and down past the OWC; set the contacts from pressure gradients and the properties from logs and PVT. |                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                               |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 39 | The field is synthetic and the reservoir thicker than the hydrocarbon column, so the top map alone bounds the rock; a thinner one needs a base map, and its volume taken off.                               |                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                               |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 41 | Top-Reservoir Contours, the Volume above Each, and the Table Clipped at Each Contact                                                                                                                        |                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                               |                                    |                                                                         |                  |                              |                                                                         |                  |                              |
| 42 | Depth (ft)                                                                                                                                                                                                  | Area (acres)                                                                       | GRV above (acre·ft)                                                                                                                                                                                                                                                                                                                                                                                                           | STOIIP, OWC here (MMSTB)           | GOC area term (acres)                                                   | To GOC (ft)      | Area to GOC (acres)          | OWC area term (acres)                                                   | To OWC (ft)      | Area to OWC (acres)          |
| 43 | 7000                                                                                                                                                                                                        | 0                                                                                  | =0                                                                                                                                                                                                                                                                                                                                                                                                                            | =MAX(0,C43-VO_GRVGoc)*VO_PerAcreFt | =IF(AND(A43<VO_GOC,A44>=VO_GOC),B43+(VO_GOC-A43)/(A44-A43)*(B44-B43),0) | =MIN(A43,VO_GOC) | =IF(A43<=VO_GOC,B43,VO_AGOC) | =IF(AND(A43<VO_OWC,A44>=VO_OWC),B43+(VO_OWC-A43)/(A44-A43)*(B44-B43),0) | =MIN(A43,VO_OWC) | =IF(A43<=VO_OWC,B43,VO_AOWC) |
| 44 | 7040                                                                                                                                                                                                        | 260                                                                                | =PO.RES.Vol.GRV.DepthArea($A$43:A44,$B$43:B44,VO_DARule)                                                                                                                                                                                                                                                                                                                                                                      | =MAX(0,C44-VO_GRVGoc)*VO_PerAcreFt | =IF(AND(A44<VO_GOC,A45>=VO_GOC),B44+(VO_GOC-A44)/(A45-A44)*(B45-B44),0) | =MIN(A44,VO_GOC) | =IF(A44<=VO_GOC,B44,VO_AGOC) | =IF(AND(A44<VO_OWC,A45>=VO_OWC),B44+(VO_OWC-A44)/(A45-A44)*(B45-B44),0) | =MIN(A44,VO_OWC) | =IF(A44<=VO_OWC,B44,VO_AOWC) |
| 45 | 7080                                                                                                                                                                                                        | 620                                                                                | =PO.RES.Vol.GRV.DepthArea($A$43:A45,$B$43:B45,VO_DARule)                                                                                                                                                                                                                                                                                                                                                                      | =MAX(0,C45-VO_GRVGoc)*VO_PerAcreFt | =IF(AND(A45<VO_GOC,A46>=VO_GOC),B45+(VO_GOC-A45)/(A46-A45)*(B46-B45),0) | =MIN(A45,VO_GOC) | =IF(A45<=VO_GOC,B45,VO_AGOC) | =IF(AND(A45<VO_OWC,A46>=VO_OWC),B45+(VO_OWC-A45)/(A46-A45)*(B46-B45),0) | =MIN(A45,VO_OWC) | =IF(A45<=VO_OWC,B45,VO_AOWC) |
| 46 | 7120                                                                                                                                                                                                        | 1050                                                                               | =PO.RES.Vol.GRV.DepthArea($A$43:A46,$B$43:B46,VO_DARule)                                                                                                                                                                                                                                                                                                                                                                      | =MAX(0,C46-VO_GRVGoc)*VO_PerAcreFt | =IF(AND(A46<VO_GOC,A47>=VO_GOC),B46+(VO_GOC-A46)/(A47-A46)*(B47-B46),0) | =MIN(A46,VO_GOC) | =IF(A46<=VO_GOC,B46,VO_AGOC) | =IF(AND(A46<VO_OWC,A47>=VO_OWC),B46+(VO_OWC-A46)/(A47-A46)*(B47-B46),0) | =MIN(A46,VO_OWC) | =IF(A46<=VO_OWC,B46,VO_AOWC) |
| 47 | 7160                                                                                                                                                                                                        | 1540                                                                               | =PO.RES.Vol.GRV.DepthArea($A$43:A47,$B$43:B47,VO_DARule)                                                                                                                                                                                                                                                                                                                                                                      | =MAX(0,C47-VO_GRVGoc)*VO_PerAcreFt | =IF(AND(A47<VO_GOC,A48>=VO_GOC),B47+(VO_GOC-A47)/(A48-A47)*(B48-B47),0) | =MIN(A47,VO_GOC) | =IF(A47<=VO_GOC,B47,VO_AGOC) | =IF(AND(A47<VO_OWC,A48>=VO_OWC),B47+(VO_OWC-A47)/(A48-A47)*(B48-B47),0) | =MIN(A47,VO_OWC) | =IF(A47<=VO_OWC,B47,VO_AOWC) |
| 48 | 7200                                                                                                                                                                                                        | 2100                                                                               | =PO.RES.Vol.GRV.DepthArea($A$43:A48,$B$43:B48,VO_DARule)                                                                                                                                                                                                                                                                                                                                                                      | =MAX(0,C48-VO_GRVGoc)*VO_PerAcreFt | =IF(AND(A48<VO_GOC,A49>=VO_GOC),B48+(VO_GOC-A48)/(A49-A48)*(B49-B48),0) | =MIN(A48,VO_GOC) | =IF(A48<=VO_GOC,B48,VO_AGOC) | =IF(AND(A48<VO_OWC,A49>=VO_OWC),B48+(VO_OWC-A48)/(A49-A48)*(B49-B48),0) | =MIN(A48,VO_OWC) | =IF(A48<=VO_OWC,B48,VO_AOWC) |
| 49 | 7240                                                                                                                                                                                                        | 2720                                                                               | =PO.RES.Vol.GRV.DepthArea($A$43:A49,$B$43:B49,VO_DARule)                                                                                                                                                                                                                                                                                                                                                                      | =MAX(0,C49-VO_GRVGoc)*VO_PerAcreFt | =0                                                                      | =MIN(A49,VO_GOC) | =IF(A49<=VO_GOC,B49,VO_AGOC) | =0                                                                      | =MIN(A49,VO_OWC) | =IF(A49<=VO_OWC,B49,VO_AOWC) |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.RES.Vol.GRV | =LAMBDA(Area, H, Factor, IF(OR(Factor<=0, Factor>1), NA(), Area*H*Factor)) | Gross rock volume, acre-ft: area (acres) x gross thickness (ft) x a geometric factor (1 for a slab, below 1 for a dome or wedge). |
| PO.RES.Vol.GRV.DepthArea | =LAMBDA(Depth, Area, Mode, LET(i, SEQUENCE(ROWS(Depth)), shift, --(i=TRANSPOSE(i)+1), d_prev, MMULT(shift, Depth), a_prev, MMULT(shift, Area), dh, ABS(Depth-d_prev)*(i>1), trap, dh*(Area+a_prev)/2, pyr, dh*(Area+a_prev+SQRT(Area*a_prev))/3, lo, (Area+a_prev-ABS(Area-a_prev))/2, hi, (Area+a_prev+ABS(Area-a_prev))/2, IF(Mode=1, SUM(trap), IF(Mode=2, SUM(pyr), IF(Mode=3, SUM(IF(lo<=0.5*hi, pyr, trap)), NA()))))) | Gross rock volume, acre-ft, from a depth-area (or isopach) table: Mode 1 trapezoid, 2 pyramidal frustum, 3 pyramidal where the smaller area is at most half the larger, trapezoid otherwise. |
| PO.RES.Vol.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 |
|------|----------|---------|
| VO_Method | $B$4 | Gross rock volume: 1 depth-area table, 2 area × thickness |
| VO_DARule | $B$5 | Depth-area rule: 1 trapezoidal, 2 pyramidal, 3 mixed |
| VO_GOC | $B$6 | Gas-oil contact (at or above the crest for no gas cap), ft |
| VO_OWC | $B$7 | Oil-water contact, ft |
| VO_Area | $B$8 | Area × thickness: area inside the OWC, acres |
| VO_H | $B$9 | Area × thickness: gross oil column, ft |
| VO_Factor | $B$10 | Area × thickness: geometric factor (1 for a slab) |
| VO_NTG | $B$11 | Net-to-gross ratio, v/v |
| VO_Phi | $B$12 | Porosity of the net rock, % |
| VO_Sw | $B$13 | Initial water saturation of the oil leg, % |
| VO_Bo | $B$14 | Initial oil formation volume factor, bbl/STB |
| VO_RF | $B$15 | Recovery factor, % |
| VO_Tol | $B$16 | Largest difference between the two gross rock volumes, % |
| VO_RFMin | $B$17 | Recovery factor range of the analogues, lowest, % |
| VO_RFMax | $B$18 | Recovery factor range of the analogues, highest, % |
| VO_Inputs | $B$4:$B$18 | The GRV method and depth-area rule, the gas-oil and oil-water contacts, the area-thickness inputs, net-to-gross, porosity, water saturation, Bo, the recovery factor and the check limits |
| VO_AGOC | $B$21 | Area enclosed at the GOC (interpolated between contours), acres |
| VO_AOWC | $B$22 | Area enclosed at the OWC (interpolated between contours), acres |
| VO_GRVGoc | $B$23 | Gross rock volume above the GOC (the gas cap), acre·ft |
| VO_GRVOwc | $B$24 | Gross rock volume above the OWC, acre·ft |
| VO_GRVda | $B$25 | Oil-leg gross rock volume, depth-area table, acre·ft |
| VO_GRVah | $B$26 | Oil-leg gross rock volume, area × thickness × factor, acre·ft |
| VO_Diff | $B$27 | Area × thickness against the table, % |
| VO_Column | $B$28 | Oil column, OWC less the GOC or the crest, ft |
| VO_FactorMap | $B$29 | Geometric factor the map implies |
| VO_GRV | $B$30 | Oil-leg gross rock volume used, acre·ft |
| VO_PerAcreFt | $B$31 | Oil in place per acre-foot of rock, 7758 NTG φ (1 − Sw)/Bo, STB/acre·ft |
| VO_STOIIP | $B$32 | Stock-tank oil initially in place, STOIIP, MMSTB |
| VO_Rec | $B$33 | Recoverable oil at the recovery factor, MMSTB |
| VO_ContactCheck | $B$34 | Contacts check verdict |
| VO_ContactCheckNote | $C$34 | Contacts check comment |
| VO_GrvCheck | $B$35 | Gross rock volume check verdict |
| VO_GrvCheckNote | $C$35 | Gross rock volume check comment |
| VO_RFCheck | $B$36 | Recovery factor check verdict |
| VO_RFCheckNote | $C$36 | Recovery factor check comment |
| VO_Results | $B$21:$B$36 | The areas at the contacts, the gross rock volumes above them, the oil leg's by both methods and their difference, the oil column and the factor the map implies, the volume used, STOIIP per acre-foot, STOIIP, the recoverable oil and three checks |
| VO_Curve | $A$43:$J$49 | Each contour's depth and area, the gross rock volume above it, the STOIIP an OWC there would give, and the table interpolated and clipped at the GOC and the OWC |

---

## Related Blueprints
- [Volumetric Gas in Place](/blueprint/po.res.volumetrics.giip.md)
- [Probabilistic Oil in Place by Monte Carlo](/blueprint/po.res.volumetrics.montecarlo.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)
- [CO2 Storage Capacity of a Saline Formation](/blueprint/po.res.ccs.storage.capacity.md)

