Full Sw toolkit: dual-method calculation, Pickett crossplot with Sw iso-lines, Buckles BVW plot, cementation exponent sensitivity, and Indonesia shaly-sand comparison.
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, average Sw (Archie and Simandoux), average BVW • Archie Parameter Sensitivity — cementation exponent (m) sensitivity, 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 • 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
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
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.
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.