Back to Excel templates

Por-Perm Crossplot Interpreter — Rock Typing, RQI, FZI & Lorenz Plot

From core plugs to rock types in minutes — RQI classification, Lorenz heterogeneity, and permeability transform QC in one workbook.

petrophysicsadvancedFeatured

TITLE

Por-Perm Crossplot Interpreter — Rock Typing, RQI, FZI & Lorenz Plot

PRICE

$69 USD — one-time purchase

TAGLINE

From core plugs to rock types in minutes — RQI classification, Lorenz heterogeneity, and permeability transform QC in one workbook.

WHO IT'S FOR

Formation evaluation engineers, petrophysicists, and reservoir engineers who analyse core plug data and need to characterise reservoir quality, classify rock types, and build audit-ready permeability transforms.

WHAT IT DOES

Loads your core porosity–permeability data and automatically generates five interlocked crossplots: the classic Por-Perm scatter coloured by fluid zone, the RQI vs φz diagnostic (Amaefule et al. 1993), the Lorenz flow-capacity plot for heterogeneity quantification, the Winland R35 pore-throat map, and a Transform QC plot validating power-law vs Winland predictions against core.

TABS INCLUDED (12)

• Instructions & Legend • Core Data Input — raw core plug data entry • Por-Perm Crossplot — Gas/Oil/Water scatter + power-law overlay • RQI & Rock Typing — RT1–RT4 classification by RQI cutoff • FZI & Flow Units — FZI = RQI/φz, hydraulic flow unit table • Winland Pore Throat — R35 from Pittman equation • Permeability Transforms — power-law and linear regression options • Reservoir Heterogeneity — Lorenz coefficient and Dykstra-Parsons • RQI vs φz Crossplot — log-log with FZI iso-lines • Lorenz & SMLP — flow capacity cumulative curve • Transform QC & Depth Plots — predicted vs actual k crossplot • Multi-Crossplot Panel — summary view

KEY FORMULAS

k = a × φ^b (power-law); RQI = 0.0314√(k/φ); FZI = RQI/[φ/(1−φ)]; R35 = 10^(0.732+1.588logφ−1.864logk); Lorenz coefficient from cumulative kh/φh sort

TECHNICAL SPECS

• Excel 2016+ compatible — no plugins required • 2,100+ formulas, fully transparent • 40-sample dataset included (Gas/Oil/Water zones) • MDT professional color scheme throughout

SHOP COPY

Professional 12-tab workbook for porosity–permeability analysis, RQI/FZI rock typing, Lorenz heterogeneity, Winland R35 pore-throat sizing, and transform QC crossplots.

SUGGESTED TAGS

petrophysics, core analysis, porosity permeability, rock typing, RQI, FZI, Lorenz plot, Winland R35, formation evaluation, Excel template, petroleum engineering

ABOUT RESERVOIR RISK SOLUTIONS

Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com

petrophysicscore analysisRQIFZILorenzWinland R35

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

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.

Por-Perm Crossplot Interpreter — Rock Typing, RQI, FZI & Lorenz Plot
$69 + tax, where applicable · one-timeOpen Excel Library