Back to Excel templates

Shale Volume & Net Pay Calculator — Vshale Methods, Cutoff Sensitivity & Thomas-Stieber Analysis

Four Vshale methods, a 5×5 cutoff sensitivity heat map, and Thomas-Stieber shale distribution analysis — all from your GR and porosity logs.

petrophysicsintermediate

TITLE

Shale Volume & Net Pay Calculator — Vshale Methods, Cutoff Sensitivity & Thomas-Stieber Analysis

PRICE

$59 USD — one-time purchase

TAGLINE

Four Vshale methods, a 5×5 cutoff sensitivity heat map, and Thomas-Stieber shale distribution analysis — all from your GR and porosity logs.

WHO IT'S FOR

Petrophysicists and formation evaluation engineers performing shale volume and net pay determination for reservoir characterisation or field development planning.

WHAT IT DOES

Calculates Vshale by four standard methods simultaneously, automatically flags net pay vs. your adjustable cutoffs, generates a colour-coded sensitivity heat map showing how net pay % changes across a 5×5 Vsh×Sw cutoff matrix, and classifies shale distribution type using the Thomas-Stieber method.

TABS INCLUDED (7)

• Instructions • Log Data Input — depth, GR, RHOB, NPHI, RT, PHIE, Sw, Net Pay flag • Vshale Calculation — Linear GR, Larionov-T, Larionov-O, Clavier — all four computed per depth • Net Pay Analysis — Pay/Marginal/Non-Pay flags with adjustable cutoffs • Cutoff Sensitivity — 5×5 heat map (Vsh≤0.30–0.70 × Sw≤0.40–0.80), base case highlighted • Vsh Method Crossplot — depth plot comparing four Vshale methods • Summary Dashboard — NTG, net pay footage, average properties

KEY FEATURES

• Cutoff sensitivity: each cell shows net pay % for that Vsh/Sw combination — colour-coded green/orange/red • Thomas-Stieber: structural / dispersed / laminated shale by PHIE/PHIT ratio • Thomas-Stieber interpretation guide: TS ratio ranges and permeability impact • Larionov-Tertiary recommended as default (most conservative) • All cutoffs in yellow cells — change once, all flags update instantly

TECHNICAL SPECS

• Excel 2016+ compatible • 633 formulas across 7 tabs • 25-sample log dataset pre-loaded • MDT professional color scheme

SHOP COPY

7-tab shale volume and net pay workbook with four Vshale methods, a 5×5 cutoff sensitivity heat map, Thomas-Stieber shale distribution analysis, and NTG summary.

SUGGESTED TAGS

shale volume, net pay, Vshale, GR log, Thomas-Stieber, cutoff sensitivity, petrophysics, formation evaluation, Larionov, Clavier, Excel template, petroleum 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

Vshalenet payThomas-Stiebercutoff sensitivitypetrophysics

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.

Shale Volume & Net Pay Calculator — Vshale Methods, Cutoff Sensitivity & Thomas-Stieber Analysis
$59 + tax, where applicable · one-timeOpen Excel Library