Basin Entry Screening Matrix: Multi-Criteria Play Ranking & Portfolio Gate Scorecard

Weighted multi-criteria matrix for basin entry decisions: resource, cost, infrastructure, and regulatory scores with proceed/hold/exit gates.

Corporate development and exploration strategy teams evaluating basin entry and portfolio gate decisions.

Applies weighted criteria (resource, cost, infrastructure, geopolitical) to rank plays and assign proceed/hold/exit gate recommendations. Weights are normalised automatically if they do not sum to 1, with a flag that says so; scores and thresholds are validated, and a hold threshold at or above the proceed threshold is flagged. Two crossplot tabs show the play scores as marker scatter plots, linked live to the score tables.

• Instructions & Legend • Scoring Weights — four criterion weights with sum check and normalisation flag • Play Scores — 0–100 score per criterion per play • Weighted Matrix — weighted score and percentile rank • Gate Thresholds — proceed and hold thresholds with consistency check • Portfolio Rank — gate, rank and gate counts • Resource vs Cost Crossplot — resource score vs cost score by play • Score vs Percentile Crossplot — weighted score vs percentile rank • Portfolio Score Chart • Summary — plays to proceed, hold and exit, top play, weight check

Weighted score = Σ(criterion × weight) / Σ(weights); gate = PROCEED if score ≥ proceed threshold, HOLD if ≥ hold threshold, else EXIT

• Excel 2016+; 75+ formulas; 4-play sample; weight sum check • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas

Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com