OIP/GIP Volumetric Calculator — Monte Carlo Uncertainty, Gas PVT & P10/P50/P90 Ranges
Deterministic OOIP/OGIP for four zones, probabilistic P10/P50/P90 from Monte Carlo simulation, and a Bg vs pressure PVT table — complete volumetric toolkit.
TITLE
OIP/GIP Volumetric Calculator — Monte Carlo Uncertainty, Gas PVT & P10/P50/P90 Ranges
PRICE
$69 USD — one-time purchase
TAGLINE
Deterministic OOIP/OGIP for four zones, probabilistic P10/P50/P90 from Monte Carlo simulation, and a Bg vs pressure PVT table — complete volumetric toolkit.
WHO IT'S FOR
Reservoir engineers and geoscientists performing volumetric reserve calculations for well proposals, field development plans, or SPE-PRMS reserve reports requiring probabilistic estimates.
WHAT IT DOES
Calculates OOIP and OGIP for up to 4 zones using standard volumetric equations. Generates P10/P50/P90 uncertainty ranges from parameter ranges. Runs a 50-iteration Monte Carlo simulation using triangular and normal distributions for area, net pay, porosity, NTG, Sw, and Bo. Builds a Bg vs pressure PVT table using the Hall-Yarborough z-factor approximation.
TABS INCLUDED (9)
• Instructions • Zone Parameters — A, h, phi, NTG, Swi, Boi per zone • OOIP Calculation — OOIP, RF, and recoverable oil by zone + total • OGIP Calculation — OGIP, Bg, and recoverable gas by zone + total • Summary — combined volumetric summary with fluid type breakdown • P10 P50 P90 Ranges — parameter ranges and resulting OOIP probability cases • NTG & RF Sensitivity — OOIP sensitivity to NTG and recovery factor • Gas PVT & Bg Table — Bg (RCF/SCF and RB/MSCF) for 13 pressure steps • Monte Carlo OOIP — 50-run simulation with P90/P50/P10 summary
KEY FEATURES
• Monte Carlo: area (triangular), net pay (log-normal), porosity (normal), NTG (triangular), Sw (normal), Bo (normal) — 50 runs sorted and ranked • Gas PVT: pseudo-critical properties from Standing correlation; Hall-Yarborough z-factor • NTG sensitivity: 5×5 table showing OOIP across NTG 0.70–1.00 × RF 25%–45%
TECHNICAL SPECS
• Excel 2016+ compatible • 142 formulas across 9 tabs • 4-zone dataset: Zone A (412 acres, 38.5 ft), Zone B, Zone C oil zones + gas cap • MDT color scheme
SHOP COPY
9-tab volumetric workbook: deterministic OOIP/OGIP for 4 zones, Monte Carlo P10/P50/P90 OOIP simulation, gas PVT Bg table, P10/P50/P90 from parameter uncertainty.
SUGGESTED TAGS
OOIP, OGIP, volumetric, Monte Carlo, P10 P50 P90, gas PVT, Bg, reserve calculation, petroleum engineering, Excel template, reservoir engineering
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com
What you get
- Instant workbook access after payment in your Excel Library
- Formula-driven worksheet designed for petroleum workflows
- No recurring fees and no plugin requirements
FAQ
Is this a one-time purchase?
Yes. Each workbook is sold as a one-time purchase with no recurring subscription.
How do I access purchased files?
After checkout, your file appears in Excel Library under your account for download.
Do these templates require macros or plugins?
No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.
