Play Fairway Screening Scorecard: Geologic Chance, Resource Parameters & Play Ranking
Score plays on trap, reservoir, charge, and seal elements, then rank them by risked resource (play chance × volumetric recoverable resource): play-level screening, not single-prospect COS/EMV.
TAGLINE
Score plays on trap, reservoir, charge, and seal elements, then rank them by risked resource (play chance × volumetric recoverable resource): play-level screening, not single-prospect COS/EMV.
WHO IT'S FOR
Exploration managers and new ventures teams ranking plays at portfolio scale before prospect-level risking.
WHAT IT DOES
Scores trap/reservoir/charge/seal elements per play and multiplies them into a play chance. Estimates each play's unrisked recoverable resource volumetrically from area, net pay, porosity, water saturation, formation volume factor and recovery factor (gas converted at 6 Mcf/bbl), and ranks plays by risked resource = play chance × resource. Assigns Tier 1/2/3 from two chance thresholds you set, and shows for each play how much the play chance swings when one element moves by ±0.10. Each play carries a single resource value, not a range.
TABS INCLUDED (11)
• Instructions & Legend • Play Register — play name, phase, lead count • Element Scores — trap, reservoir, charge, seal (0–1) • Play Chance — play chance and Tier 1/2/3 from threshold inputs • Resource Parameters — area, net pay, RF, porosity, Sw, FVF; unrisked recoverable resource (MMBOE) • Play Ranking — risked resource (MMBOE) and rank, with chart • Tornado Drivers — play-chance swing per element and the dominant element per play • Trap vs Reservoir Crossplot — play positioning, marker scatter • Geo Chance vs Score Crossplot — play chance vs risked resource, marker scatter • Element Score Chart — element scores by play • Summary — tier counts and total risked resource
KEY FORMULAS
Play chance = P(trap) × P(reservoir) × P(charge) × P(seal); oil resource = 7758 × A × h × φ × (1 − Sw) / Bo × RF; gas resource via Bg, converted at 6 Mcf/bbl; risked resource = play chance × resource; tornado swing = (MIN(1, e + 0.1) − MAX(0, e − 0.1)) × product of the other three elements
TECHNICAL SPECS
• Excel 2016+; 110+ formulas; 4 sample plays • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.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
Licence
Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.
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.
