SCAL Relative Permeability Analyzer: Corey Exponents, Kr Crossplots & Hysteresis QC
Fit Corey exponents to lab Kr data by least squares with the end points honoured, see the true fit error, compare exponent pairs, and check hysteresis, crossover and a screening wettability indication.
TAGLINE
Fit Corey exponents to lab Kr data by least squares with the end points honoured, see the true fit error, compare exponent pairs, and check hysteresis, crossover and a screening wettability indication.
WHO IT'S FOR
Petrophysicists and reservoir engineers analyzing SCAL relative permeability data for simulation input and rock typing.
WHAT IT DOES
Takes Swc, Sor and the end-point Kr values from the lab table and fits the Corey exponents No and Nw by least squares on the log form of the Corey equation, with the end points honoured; an override column lets you impose your own values. Reports the true RMSE of Kro and Krw against every lab point, plots lab vs Corey curves with residuals, and tabulates combined RMSE for a matrix of No × Nw pairs with the best pair marked. Finds the Kro = Krw crossover saturation, gives a Craig rule-of-thumb wettability indication (screening only), and flags drainage/imbibition hysteresis gaps against a tolerance you set. Fractional flow and Welge analysis are not included.
TABS INCLUDED (10)
• Instructions & Legend • SCAL Input — lab Sw, Kro, Krw • Corey Fit — end points and exponents (lab/fitted, optional override, value used), RMSE, per-point fit table • Kr Crossplots — lab vs Corey Kro and Krw, residuals • Kro vs Krw Crossplot — relative permeability overlay • Hysteresis Crossplot — drainage vs imbibition Kro • Hysteresis QC — gap per point with tolerance input • Endpoint Summary — Swc, Sor, mobile oil range, kro*, krw*, crossover Sw, wettability indication • Sensitivity — Kro and Krw RMSE for No × Nw pairs, best pair marked • Summary — exponents, RMSEs, end points, crossover Sw
KEY FORMULAS
Corey Kro = Kro@Swc × ((1 − Sw − Sor)/(1 − Swc − Sor))^No; Krw = Krw@(1−Sor) × ((Sw − Swc)/(1 − Swc − Sor))^Nw; N = Σ(ln S_n · ln(kr/kr*)) / Σ(ln S_n)²; RMSE = √(mean((lab − Corey)²))
TECHNICAL SPECS
• Excel 2016+; 750+ formulas; 20-point Kr dataset; Kr crossplots & charts • 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.
