Back to Excel templates

Water Saturation Analysis: Archie, Simandoux, Pickett Plot, Buckles & Indonesia Equation

Full Sw toolkit: dual-method calculation, Pickett crossplot with Sw iso-lines, Buckles BVW plot, cementation exponent sensitivity, and Indonesia shaly-sand comparison.

petrophysicsadvancedFeatured

TAGLINE

Full Sw toolkit: dual-method calculation, Pickett crossplot with Sw iso-lines, Buckles BVW plot, cementation exponent sensitivity, and Indonesia shaly-sand comparison.

WHO IT'S FOR

Petrophysicists and reservoir engineers performing water saturation calculations for well evaluation, reserve estimation, or fluid contact determination in clean or shaly sands.

WHAT IT DOES

Calculates formation water saturation using Archie (clean sands), Simandoux (shaly sands), and the Indonesia equation. Builds a Pickett plot with four Sw iso-lines for graphical interpretation, a Buckles BVW irreducible hyperbola plot, and a cementation exponent (m) sensitivity table showing how Sw changes across m=1.5–2.6.

TABS INCLUDED (8)

• Instructions • Inputs & Parameters — well data, Archie params, all 20 depth stations • Archie Sw — F, Ro, RI, Sw per station with colour-coded fluid zones • Simandoux Sw — shaly-sand correction with Vshale input • Pickett Plot — log(PHIE) vs log(Rt) with Sw=0.2/0.4/0.6/1.0 iso-lines • Buckles & BVW — Sw vs PHIE scatter with BVW irreducible hyperbola • Summary — fluid zone counts, average Sw (Archie and Simandoux), average BVW • Archie Parameter Sensitivity — cementation exponent (m) sensitivity, Indonesia vs Archie, Rw from SP log

KEY FEATURES

• Pickett plot iso-lines: colour-coded Sw=20%, 40%, 60%, 100% (log-log axes) • Buckles plot: BVW = PHIE × Sw with adjustable irreducible BVW line • m sensitivity: F, Ro, RI, Sw, and Sw% change for m=1.5–2.6 (base m=2.0 highlighted) • Indonesia equation comparison: side-by-side Sw vs Vshale for 7 clay volumes • Rw from SP log: SSP → Rwe → Rw derivation with formulas

TECHNICAL SPECS

• Excel 2016+ compatible • 1,200+ formulas across 8 tabs • 20-sample dataset classified by Simandoux Sw (oil / marginal / water) • MDT color scheme — input cells light blue, calculated light grey

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

water saturationArchieIndonesiaPickett plotBuckles

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.

Water Saturation Analysis: Archie, Simandoux, Pickett Plot, Buckles & Indonesia Equation
$79 + tax, where applicable · one-timeOpen Excel Library