Capillary Pressure & Saturation Height Model: J-Function, Leverett & FWL Calibration
Convert lab Pc–Sw data to a saturation-height model with J-function normalization, FWL calibration, and Leverett crossplots, auditable capillary pressure workbook.
TAGLINE
Convert lab Pc–Sw data to a saturation-height model with J-function normalization, FWL check against log Sw, and Leverett crossplots — auditable capillary pressure workbook.
WHO IT'S FOR
Petrophysicists, reservoir engineers, and geologists building saturation-height models from SCAL data and calibrating fluid contacts.
WHAT IT DOES
Loads lab capillary pressure vs water saturation, fits a Leverett J-function (J = a·Sw*^−b) to the lab data, scales lab Pc to reservoir interfacial tension and contact angle, and builds Sw against height above the free water level (Sw = 1 at and below the FWL). A QC tab compares model Sw with log Sw at the depths you enter.
TABS INCLUDED (11)
• Instructions & Legend • Assumptions — fluid gradients, FWL, reference φ and k • Lab Data Input — measured Pc vs Sw (30 points) • J-Function — normalized capillary pressure • Sat Height Model — Sw vs height above FWL • FWL Calibration — model vs log Sw at entered depths • Leverett Plot — J vs Sw crossplot • Pc vs Height Crossplot — lab height calibration • Sw QC Crossplot — model vs log Sw with 1:1 line • Multi-Crossplot Panel — summary diagnostics • Summary — key outputs and QC flags
KEY FORMULAS
Pc = 0.433×Δρ×h; J = 0.21645×Pc×√(k/φ)/(σ cosθ); Sw = Swirr + (1 − Swirr)×(J/a)^(−1/b)
TECHNICAL SPECS
• Excel 2016+; 500+ formulas; 30-point lab dataset; no VBA • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
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
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.
