---
id: po.wb.pp.quick-look-interpretation
title: Quick-Look Petrophysical Interpretation
summary: "How much net pay one log interval holds and how permeable it is, from shale volume, porosity, Rw and water saturation to cutoffs and core permeability."
category: Petrophysics
requires:
  - excel-365
tags:
  - petrophysics
  - log-interpretation
---

## Description

How much net pay does this log interval hold, at what porosity and saturation, and how permeable is it? You paste the interval's gamma ray, SP, density, neutron, sonic and deep resistivity and the core plugs, and pick the shale lines, water resistivity and cutoffs. You read off shale volume and porosity, water saturation by Archie and four shaly-sand models, gross, net reservoir and net pay per zone, and a core-calibrated permeability. Depth in ft, resistivity in ohm m, permeability in mD; porosity, saturation and Vsh as fractions.

**How to use it:** Replace the blue log cells on the Logs sheet and the core cells on the Permeability sheet. The tables and formulas have fixed lengths: all 61 log depths must be numeric and increase uniformly by 2 ft, so resize the ranges and formulas before adding samples. Shaly saturation and permeability use a fixed 46-sample, 90-ft window at 2-ft spacing, starting at the editable window top on the Logs sheet (5010 ft by default); the selected window must lie inside the log, and the shifted core plugs inside the window. On the Water sheet compare the SP, minimum Rwa, Pickett and salinity estimates and select method 1-4 to link one, or keep the fixed Rw. Net pay uses the full interval but counts only the samples inside the typed gross window. Type the core-to-log depth shift by hand. Read the zone pay, Rw, porosity, permeability and every check on the Summary.

**Method:** Shale volume from the gamma-ray index and its Larionov (Tertiary and older rocks), Clavier and Steiber transforms; porosity from density, neutron-density and sonic (Wyllie and Raymer-Hunt-Gardner), each shale-corrected. Formation-water resistivity from four independent estimates: SP, minimum Rwa in the water sand, a Pickett plot and salinity, each brought to formation temperature. Water saturation by Archie, Sw = (a Rw/(phi^m Rt))^(1/n), and by Simandoux, Indonesia, Waxman-Smits and dual water. A sample is net reservoir when its Vsh and porosity pass their cutoffs, and net pay when its Archie Sw also passes. Permeability by Timur, Coates and Wyllie-Rose, each scaled to the core plugs, or by a core porosity-permeability fit. The computed curves and zone averages share the same log readings; the porosity bases differ, as set out under Validity.

**Example:** The shared synthetic log interval from 5000 to 5120 ft in 2 ft samples, with 15 synthetic core plugs. With clean and shale gamma-ray picks of 30/115 API, Rw = 0.05 ohm m (the default fixed Rw, kept so the other source examples stay comparable) and cutoffs Vsh = 0.4, porosity = 0.10 and Sw = 0.60, the interval holds 88 ft gross, 50 ft net reservoir and 26 ft net pay. The calibrated Timur permeability of the clean oil zone is 1,032.725487 mD, and its corrected density-neutron porosity averages 0.257258396. These numbers match the source calculations on identical inputs and are synthetic, not field measurements.

## Validity

Net pay uses shale-corrected density porosity and Archie Sw, while the permeability model uses uncorrected density porosity. The porosity log's density-neutron curve combines separately shale-corrected density and neutron; the Archie bed example uses uncorrected density. Do not compare these as though they were one porosity measurement. Each zone's pay on the Summary uses the net-pay basis. The depth-track charts are simple XY depth tracks, not a full multi-track LAS viewer, and omit specialised log-track features. Correct logs for environmental effects and calibrate shale volume, saturation and permeability to the same rock and fluids. The example and core are synthetic.

The workbook does not match the core to the log automatically: the core-to-log shift is typed, not fitted. Permeability is an estimate, not a well test. Archie assumes a clean formation; calibrate the shaly-sand alternatives against core.

## References

- Archie, G.E. (1942). The Electrical Resistivity Log as an Aid in Determining Some Reservoir Characteristics. *Trans. AIME* 146, 54-62.
- Wyllie, M.R.J. and Rose, W.D. (1950). Some Theoretical Considerations Related to the Quantitative Evaluation of the Physical Characteristics of Reservoir Rock from Electrical Log Data. *Trans. AIME* 189, 105-118.
- Wyllie, M.R.J., Gregory, A.R. and Gardner, L.W. (1956). Elastic Wave Velocities in Heterogeneous and Porous Media. *Geophysics* 21(1), 41-70.
- Pickett, G.R. (1966). A Review of Current Techniques for Determination of Water Saturation from Logs. *JPT* 18(11), 1425-1433.
- Timur, A. (1968). An Investigation of Permeability, Porosity, and Residual Water Saturation Relationships for Sandstone Reservoirs. *The Log Analyst* 9(4).
- Waxman, M.H. and Smits, L.J.M. (1968). Electrical Conductivities in Oil-Bearing Shaly Sands. *SPE Journal* 8(2), 107-122.
- Poupon, A. and Leveaux, J. (1971). Evaluation of Water Saturation in Shaly Formations. SPWLA 12th Annual Logging Symposium.
- Raymer, L.L., Hunt, E.R. and Gardner, J.S. (1980). An Improved Sonic Transit Time-to-Porosity Transform. SPWLA 21st Annual Logging Symposium.
- Clavier, C., Coates, G. and Dumanoir, J. (1984). Theoretical and Experimental Bases for the Dual-Water Model for Interpretation of Shaly Sands. *SPE Journal* 24(2), 153-168.
- Asquith, G. and Krygowski, D. (2004). *Basic Well Log Analysis*, 2nd ed. AAPG Methods in Exploration 16.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| Clean gamma ray | API | 30 | `QLP_GRcl` |
| Shale gamma ray | API | 115 | `QLP_GRsh` |
| Matrix density | g/cm3 | 2.65 | `QLP_RhoMa` |
| Fluid density | g/cm3 | 1 | `QLP_RhoF` |
| Saturation and permeability window top | ft | 5010 | `QLP_WindowTop` |
| Tortuosity | — | 1 | `QLR_a` |
| Cementation exponent | — | 2 | `QLR_m` |
| Saturation exponent | — | 2 | `QLR_n` |
| Rw source (1 SP, 2 Rwa, 3 Pickett, 4 salinity, 5 fixed) | — | 5 | `QLR_Method` |
| Fixed Rw at formation temperature | ohm m | 0.05 | `QLR_FixedRw` |
| Maximum shale volume | fraction | 0.4 | `QLN_VshCut` |
| Minimum corrected density porosity | fraction | 0.1 | `QLN_PhiCut` |
| Maximum water saturation | fraction | 0.6 | `QLN_SwCut` |
| Core depth shift added to core depth | ft | -3 | `QLK_Shift` |
| Method (1 Timur, 2 Coates, 3 Wyllie-Rose, 4 core) | — | 1 | `QLK_Method` |

## Sheets

- `Guide` — the workflow and which porosity feeds which calculation.
- `Logs` — the pasted log curves with the shale picks and porosity constants; shale volume by five transforms, density, neutron, density-neutron and sonic porosity, the zone porosity, and a depth track of shale volume and porosity.
- `Water` — formation-water resistivity from SP, minimum Rwa, Pickett and salinity, calibrated in the water sand, and the selected Rw.
- `Saturation` — Archie, Simandoux, Indonesia, Waxman-Smits and dual-water saturation over the selected window, with zone averages and a depth track.
- `Pay` — the cutoffs, the sample-by-sample reservoir and pay flags, gross, net reservoir and net pay, and a depth track of Vsh, porosity and Sw.
- `Permeability` — the core plugs on depth after the typed shift, Timur, Coates and Wyllie-Rose calibrated to the core, the core porosity-permeability fit, and the zone permeability.
- `Summary` — Rw, net pay, pay porosity, oil-zone permeability, the zone pay table and every check.
- `Test Cases` — the worked example and other cases, with expected and computed results.

## Functions used

`PO.PP.Vsh.GammaRayIndex`, `PO.PP.Vsh.Larionov.Tertiary`, `PO.PP.Vsh.Larionov.Older`, `PO.PP.Vsh.Clavier`, `PO.PP.Vsh.Steiber`, `PO.PP.Porosity.FromDensity`, `PO.PP.Porosity.FromNeutronDensity`, `PO.PP.Porosity.FromSonic.Wyllie`, `PO.PP.Porosity.FromSonic.RHG`, `PO.PP.Rw.Temperature`, `PO.PP.Rw.FromSsp`, `PO.PP.Rw.FromRwa`, `PO.PP.Rw.FromSalinity`, `PO.PP.Sw.Archie`, `PO.PP.Sw.Simandoux`, `PO.PP.Sw.Indonesia`, `PO.PP.Qv.FromCEC`, `PO.PP.Sw.WaxmanSmits`, `PO.PP.Sw.DualWater`, `PO.PP.Pay.NetPay`, `PO.PP.Cutoff.PermFromCore`, `PO.PP.Perm.Timur`, `PO.PP.Perm.Coates`, `PO.PP.Perm.WyllieRose`, `PO.PP.Perm.PoroPermFit`.
