Full Sw toolkit: dual-method calculation, Pickett crossplot with Sw iso-lines, Buckles BVW plot, cementation exponent sensitivity, and Indonesia shaly-sand comparison.
Water Saturation Analysis — Archie, Simandoux, Pickett Plot, Buckles & Indonesia Equation
$79 USD — one-time purchase
Full Sw toolkit: dual-method calculation, Pickett crossplot with Sw iso-lines, Buckles BVW plot, cementation exponent sensitivity, and Indonesia shaly-sand comparison.
Petrophysicists and reservoir engineers performing water saturation calculations for well evaluation, reserve estimation, or fluid contact determination in clean or shaly sands.
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.
• 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, avg Sw, avg PHIE by zone • Archie Parameter Sensitivity — m/n sensitivity table, Indonesia vs Archie, Rw from SP log
• 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
• Excel 2016+ compatible • 507 formulas across 8 tabs • 20-sample dataset (Oil/Water/Transition zones) • MDT color scheme — input cells light blue, calculated light grey
8-tab water saturation workbook: Archie, Simandoux, and Indonesia methods; Pickett plot with Sw iso-lines; Buckles BVW plot; m/n sensitivity matrix; and Rw from SP derivation.
water saturation, Archie equation, Simandoux, Pickett plot, Buckles plot, Indonesia equation, Sw, petrophysics, cementation exponent, Excel template, petroleum engineering
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com
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.