---
cid: po.bp.pp.permeability.estimate
hub: pp
tags: [petrophysics, permeability, Timur, Coates, Wyllie-Rose, Tixier, irreducible-water, bulk-volume-water, core, poro-perm, calibration, depth-shift, kh]
facets: { discipline: reservoir, property: permeability, method-type: empirical }
title: Permeability from Logs
summary: "Estimates permeability from logs by Timur, Coates and Wyllie-Rose and calibrates each against core to show how far it can be trusted."
slug: po.pp.permeability.estimate
type: worksheet
---

# Permeability from Logs

## Description

What is the zone's permeability, and how far can a log estimate of it be trusted? You enter a log of gamma ray and bulk density, the picks and cutoffs, the irreducible bulk volume water, core plugs with their core-to-log depth shift, and the zone. You read off permeability by Timur, Coates and Wyllie-Rose and by a core poro-perm transform, each method's bias and scatter about core once calibrated to it, and the zone's mean permeability and kh.

**Parameters:**
- **Picks and rock**: `PE_GRcl`, `PE_GRsh` (API), `PE_RhoMa`, `PE_RhoF` (g/cm³), and the reservoir cutoffs `PE_VshCut` and `PE_PhiCut`
- **Irreducible water**: the bulk volume water at irreducible saturation `PE_Bvi` (v/v)
- **Wyllie-Rose**: the coefficient `PE_WrC`, the porosity exponent `PE_WrP` and the Swirr exponent `PE_WrS`
- **Core and zone**: the core-to-log depth shift `PE_Shift` (ft, added to the core depth), the zone top `PE_ZTop` and base `PE_ZBase` (ft), and the method reported `PE_Method` (1 Timur, 2 Coates, 3 Wyllie-Rose, 4 core transform)
- **Limits**: the scatter about core `PE_LogTol` (decades), the porosity miss on depth `PE_PhiTol` and the poro-perm fit's `PE_R2Min`
- **Log and core**: each depth's GR and bulk density in the log table, and each plug's core depth, porosity and permeability in the core table

**How to use it:** The log and the core are synthetic. Paste your depth, GR and bulk density over the log table, and your routine-core porosity and permeability over the core table at the core's depths. Shift the core onto the log by matching a core gamma or the porosity by eye; the sheet only checks the match. Take Bvi from the oil leg's bulk volume water well above the transition zone, or from NMR. Calibrate against core of the same rock type, and against a well test's kh where there is one. Pick the method to report from the calibration table: the smallest scatter about core, not the smallest bias.

**Method:**

- **Porosity and Swirr.** φ is the density porosity (ρma − ρb)/(ρma − ρf). Swirr is a constant irreducible bulk volume of water over porosity, Swirr = Bvi / φ, at most 1.
- **The three forms.** Timur: k = 0.136 φ^4.4 / Swirr^2, with φ and Swirr in percent. Coates: k = (100 φ² (1 − Swirr) / Swirr)². The general Wyllie-Rose form: k = (C φ^P / Swirr^Q)², by default with Tixier's constants, 250 φ³ / Swirr.
- **The core transform.** log10 k = A + B φ, the log-linear poro-perm transform fitted by least squares to the plugs' porosity and permeability, and applied to the log's porosity.
- **Calibration.** Each plug's log depth is its core depth plus the shift, and the log's porosity there is the sample at or above that depth. Each method is compared with the plugs on a log scale. Its bias is the mean of log10(k method / k core) over the plugs, its calibration factor 10^−bias, and its scatter √(mean (log10 ratio − bias)²), the RMS of what is left. The transform's scatter is about core with no bias removed.
- **The zone.** The log's permeability is set to 0 outside reservoir. The zone's mean is over its reservoir samples, given by every method, calibrated, and by the one chosen, and kh is Σ k h over them. The chart draws permeability against porosity for the core plugs, the core transform and the three calibrated methods.
- **Checks.** The depth match check warns when the plugs' porosity misses the log's by more than the limit on the shift: the core is off depth. The core transform check warns when the poro-perm fit's R² is below the limit, a sign of several rock types. The calibration check warns when the chosen method still scatters about core by more than the limit after calibration.

**Example:** The default case is the Well-Log Display workbook's synthetic interval from 5,010 to 5,100 ft, every 2 ft, with its picks and cutoffs. The zone is the clean oil sand, 5,013 to 5,033 ft. The irreducible bulk volume water is 0.032, the oil sand's own φ Sw, and Wyllie-Rose takes Tixier's 250, 3 and 1. The core is the interval's fifteen synthetic plugs, marked 3 ft deeper than the log reads them, so the shift is −3 ft. Timur is reported, calibrated. The core may miss the log's porosity by half a porosity unit on depth, a calibrated method may scatter 0.3 of a decade about core, and the poro-perm fit needs an R² of 0.9.

On the −3 ft shift the plugs' porosity meets the log's within 0.3 porosity units on average. The core transform is log10 k = −2.04 + 19.67 φ at an R² of 0.985. At the plugs Timur reads 0.20 of a decade high, Coates 0.36 high and Wyllie-Rose 0.005 low. Their calibration factors are 0.628, 0.438 and 1.012, and calibrated, they scatter about core by 0.27, 0.34 and 0.43 of a decade. The transform scatters by 0.16. Wyllie-Rose has the smallest bias but the most scatter: it falls too steeply with porosity, too low in the tight streak and too high in the shaly sands. In the zone the porosity is 26.3% and Swirr 12.2%. Calibrated Timur gives 1,033 mD, Coates 1,104 mD and Wyllie-Rose 1,438 mD, and the transform 1,413 mD. The zone's kh by Timur is 20,655 mD·ft over 20 ft, and Timur meets core within 0.27 of a decade, inside the 0.3 allowed. With no shift the plugs miss the log's porosity by 0.9 porosity units on average, over the half unit allowed, and the depth check warns; the calibration made off depth gives the zone 923 mD by Timur. Reported by the core transform, the zone is 1,413 mD. Coates scatters 0.34 of a decade, over the 0.3 limit, and the calibration check warns.

## Validity

The Timur, Coates and Wyllie-Rose forms hold in clean, water-wet sandstones at irreducible water saturation; their constants are fitted to particular sandstones and need calibrating to core of the rock in hand. Swirr = Bvi / φ assumes one irreducible bulk volume water, which holds within a rock type of one grain size. In a transition zone or a wet sand the log's own Sw is not Swirr, which is why Bvi is used. A one-line poro-perm transform holds within one rock type. Core permeability is air permeability at low stress; correct it for Klinkenberg and stress before comparing it with a well test. The log's resolution averages thin beds that core resolves. The sheet does not match the core to the log automatically: the shift is typed, and the sheet checks it by porosity. The log and core are synthetic. Field units.

Named alternatives: a transform per rock type for a field with several, by flow units or a hydraulic-unit split (Amaefule et al., 1993); a well test's kh to calibrate the log permeability at reservoir conditions; the Porosity from Logs sheet for a shale-corrected or density-neutron porosity.

## References

- Timur, A. (1968). An Investigation of Permeability, Porosity, and Residual Water Saturation Relationships for Sandstone Reservoirs. *The Log Analyst* 9(4), SPWLA-1968-vIXn4a2.
- Coates, G.R. and Dumanoir, J.L. (1974). A New Approach to Improved Log-Derived Permeability. *The Log Analyst* 15(1), SPWLA-1974-vXVn1a2.
- 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. *Journal of Petroleum Technology* 2(4), 105–118, SPE-950105-G.
- Amaefule, J.O., Altunbay, M., Tiab, D., Kersey, D.G. and Keelan, D.K. (1993). Enhanced Reservoir Description: Using Core and Log Data to Identify Hydraulic (Flow) Units and Predict Permeability in Uncored Intervals/Wells. SPE-26436-MS.
- Asquith, G. and Krygowski, D. (2004). *Basic Well Log Analysis*, 2nd ed. AAPG Methods in Exploration 16, ch. 6 (permeability from logs).

## Functions used

`PO.PP.Vsh.GammaRayIndex`, `PO.PP.Porosity.FromDensity`, `PO.PP.Perm.Timur`, `PO.PP.Perm.Coates`, `PO.PP.Perm.WyllieRose`, `PO.PP.Perm.PoroPermFit`

## Spreadsheet: PermeabilityLogs

|     | A                                                                                                                                                                                                                                        | B                                                                                                 | C                                                                                                                                                                                                                                                                                                             | D                                                            | E                                                             | F                                             | G                          | H                                                 | I                                                    | J                                                                           | K                                 | L                                      |
|-----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------|---------------------------------------------------------------|-----------------------------------------------|----------------------------|---------------------------------------------------|------------------------------------------------------|-----------------------------------------------------------------------------|-----------------------------------|----------------------------------------|
| 1   | Permeability from Logs                                                                                                                                                                                                                   |                                                                                                   | Petroleum Office                                                                                                                                                                                                                                                                                              |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 2   | Blue cells on yellow are inputs. Set the picks, the matrix and fluid, the irreducible bulk volume water, the Wyllie-Rose constants, the core's depth shift, the zone and the method; paste your own log and plugs over the tables below. |                                                                                                   |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 3   | The Picks, the Rock, the Wyllie-Rose Constants, the Core's Shift, the Zone and the Limits                                                                                                                                                |                                                                                                   |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 4   | Clean-sand gamma ray (Vsh = 0)                                                                                                                                                                                                           | 30                                                                                                | API                                                                                                                                                                                                                                                                                                           |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 5   | Shale gamma ray (Vsh = 1)                                                                                                                                                                                                                | 115                                                                                               | API                                                                                                                                                                                                                                                                                                           |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 6   | Matrix density (sandstone)                                                                                                                                                                                                               | 2.65                                                                                              | g/cm³                                                                                                                                                                                                                                                                                                         |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 7   | Fluid density (fresh mud filtrate)                                                                                                                                                                                                       | 1                                                                                                 | g/cm³                                                                                                                                                                                                                                                                                                         |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 8   | Shale-volume cutoff for reservoir                                                                                                                                                                                                        | 0.4                                                                                               | v/v                                                                                                                                                                                                                                                                                                           |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 9   | Porosity cutoff for reservoir                                                                                                                                                                                                            | 0.1                                                                                               | %                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 10  | Irreducible bulk volume water φ Swirr (the oil sand's)                                                                                                                                                                                   | 0.032                                                                                             | v/v                                                                                                                                                                                                                                                                                                           |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 11  | Wyllie-Rose coefficient (Tixier: 250)                                                                                                                                                                                                    | 250                                                                                               | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 12  | Wyllie-Rose porosity exponent (Tixier: 3)                                                                                                                                                                                                | 3                                                                                                 | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 13  | Wyllie-Rose Swirr exponent (Tixier: 1)                                                                                                                                                                                                   | 1                                                                                                 | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 14  | Core-to-log depth shift, added to the core depth                                                                                                                                                                                         | -3                                                                                                | ft                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 15  | Zone top (the clean oil sand, a foot inside)                                                                                                                                                                                             | 5013                                                                                              | ft                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 16  | Zone base (a foot inside the bed's base)                                                                                                                                                                                                 | 5033                                                                                              | ft                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 17  | Method reported (1 Timur, 2 Coates, 3 Wyllie-Rose, 4 transform)                                                                                                                                                                          | 1                                                                                                 | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 18  | Largest scatter of a calibrated method about core, in decades                                                                                                                                                                            | 0.3                                                                                               | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 19  | Largest mean miss of core porosity from the log's, on depth                                                                                                                                                                              | 0.005                                                                                             | %                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 20  | Lowest R² of the core poro-perm fit                                                                                                                                                                                                      | 0.9                                                                                               | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 25  | The Core on Depth, the Core Transform, Each Method against Core, and the Zone's Permeability                                                                                                                                             |                                                                                                   |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 26  | Log sample spacing                                                                                                                                                                                                                       | =(MAX($A$94:$A$139)-MIN($A$94:$A$139))/(COUNT($A$94:$A$139)-1)                                    | ft                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 27  | Zone mean porosity (reservoir samples)                                                                                                                                                                                                   | =AVERAGEIFS($E$94:$E$139,$A$94:$A$139,">="&PE_ZTop,$A$94:$A$139,"<="&PE_ZBase,$F$94:$F$139,1)     | %                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 28  | Zone mean Swirr = Bvi / φ                                                                                                                                                                                                                | =AVERAGEIFS($G$94:$G$139,$A$94:$A$139,">="&PE_ZTop,$A$94:$A$139,"<="&PE_ZBase,$F$94:$F$139,1)     | %                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 29  | Mean miss of core porosity from the log's, on depth                                                                                                                                                                                      | =SUMPRODUCT(ABS($B$60:$B$74-$E$60:$E$74))/COUNT($B$60:$B$74)                                      | %                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 30  | Core transform log10 k = A + B φ, A                                                                                                                                                                                                      | =INDEX(PO.PP.Perm.PoroPermFit($B$60:$B$74,$C$60:$C$74),1)                                         | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 31  | Core transform, B                                                                                                                                                                                                                        | =INDEX(PO.PP.Perm.PoroPermFit($B$60:$B$74,$C$60:$C$74),2)                                         | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 32  | Core transform, R²                                                                                                                                                                                                                       | =RSQ(LOG10($C$60:$C$74),$B$60:$B$74)                                                              | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 33  | Timur, mean log10 of log over core at the plugs (bias)                                                                                                                                                                                   | =SUMPRODUCT(LOG10($G$60:$G$74)-LOG10($C$60:$C$74))/COUNT($C$60:$C$74)                             | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 34  | Timur, calibration factor 10^−bias                                                                                                                                                                                                       | =10^-PE_BiasT                                                                                     | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 35  | Coates, mean log10 of log over core at the plugs (bias)                                                                                                                                                                                  | =SUMPRODUCT(LOG10($H$60:$H$74)-LOG10($C$60:$C$74))/COUNT($C$60:$C$74)                             | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 36  | Coates, calibration factor 10^−bias                                                                                                                                                                                                      | =10^-PE_BiasC                                                                                     | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 37  | Wyllie-Rose, mean log10 of log over core at the plugs (bias)                                                                                                                                                                             | =SUMPRODUCT(LOG10($I$60:$I$74)-LOG10($C$60:$C$74))/COUNT($C$60:$C$74)                             | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 38  | Wyllie-Rose, calibration factor 10^−bias                                                                                                                                                                                                 | =10^-PE_BiasW                                                                                     | —                                                                                                                                                                                                                                                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 39  | Timur, scatter about core (RMS)                                                                                                                                                                                                          | =SQRT(SUMPRODUCT((LOG10($G$60:$G$74)-LOG10($C$60:$C$74)-PE_BiasT)^2)/COUNT($C$60:$C$74))          | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 40  | Coates, scatter about core (RMS)                                                                                                                                                                                                         | =SQRT(SUMPRODUCT((LOG10($H$60:$H$74)-LOG10($C$60:$C$74)-PE_BiasC)^2)/COUNT($C$60:$C$74))          | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 41  | Wyllie-Rose, scatter about core (RMS)                                                                                                                                                                                                    | =SQRT(SUMPRODUCT((LOG10($I$60:$I$74)-LOG10($C$60:$C$74)-PE_BiasW)^2)/COUNT($C$60:$C$74))          | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 42  | Core transform, scatter about core (RMS)                                                                                                                                                                                                 | =SQRT(SUMPRODUCT((LOG10($J$60:$J$74)-LOG10($C$60:$C$74)-0)^2)/COUNT($C$60:$C$74))                 | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 43  | Zone mean permeability, Timur, calibrated                                                                                                                                                                                                | =AVERAGEIFS($H$94:$H$139,$A$94:$A$139,">="&PE_ZTop,$A$94:$A$139,"<="&PE_ZBase,$F$94:$F$139,1)     | mD                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 44  | Zone mean permeability, Coates, calibrated                                                                                                                                                                                               | =AVERAGEIFS($I$94:$I$139,$A$94:$A$139,">="&PE_ZTop,$A$94:$A$139,"<="&PE_ZBase,$F$94:$F$139,1)     | mD                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 45  | Zone mean permeability, Wyllie-Rose, calibrated                                                                                                                                                                                          | =AVERAGEIFS($J$94:$J$139,$A$94:$A$139,">="&PE_ZTop,$A$94:$A$139,"<="&PE_ZBase,$F$94:$F$139,1)     | mD                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 46  | Zone mean permeability, Core transform                                                                                                                                                                                                   | =AVERAGEIFS($K$94:$K$139,$A$94:$A$139,">="&PE_ZTop,$A$94:$A$139,"<="&PE_ZBase,$F$94:$F$139,1)     | mD                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 47  | Permeability reported, by                                                                                                                                                                                                                | =""&CHOOSE(PE_Method,"Timur","Coates","Wyllie-Rose","Core transform")                             |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 48  | Zone mean permeability by that method                                                                                                                                                                                                    | =CHOOSE(PE_Method,PE_ZKT,PE_ZKC,PE_ZKW,PE_ZKX)                                                    | mD                                                                                                                                                                                                                                                                                                            |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 49  | Zone permeability-thickness kh                                                                                                                                                                                                           | =SUMIFS($L$94:$L$139,$A$94:$A$139,">="&PE_ZTop,$A$94:$A$139,"<="&PE_ZBase,$F$94:$F$139,1)*PE_Step | mD·ft                                                                                                                                                                                                                                                                                                         |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 50  | That method's scatter about core                                                                                                                                                                                                         | =CHOOSE(PE_Method,PE_RmsT,PE_RmsC,PE_RmsW,PE_RmsX)                                                | cycles                                                                                                                                                                                                                                                                                                        |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 51  | Depth match check                                                                                                                                                                                                                        | =IF(PE_PhiMiss<=PE_PhiTol,"PASS","WARN")                                                          | =IF(PE_PhiMiss<=PE_PhiTol,"on a "&FIXED(PE_Shift,1)&" ft shift the plugs' porosity meets the log's within "&FIXED(PE_PhiMiss*100,1)&" p.u.","on a "&FIXED(PE_Shift,1)&" ft shift the plugs miss the log's porosity by "&FIXED(PE_PhiMiss*100,1)&" p.u. on average: put the core on depth before calibrating") |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 52  | Core transform check                                                                                                                                                                                                                     | =IF(PE_R2>=PE_R2Min,"PASS","WARN")                                                                | =IF(PE_R2>=PE_R2Min,"the core's log10 k = "&FIXED(PE_A,2)&" + "&FIXED(PE_B,2)&" φ fits with R² "&FIXED(PE_R2,2)&"","the core's poro-perm fit has R² "&FIXED(PE_R2,2)&": split the plugs by rock type before using one transform")                                                                             |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 53  | Calibration check                                                                                                                                                                                                                        | =IF(PE_Rms<=PE_LogTol,"PASS","WARN")                                                              | =IF(PE_Rms<=PE_LogTol,""&PE_MethodWords&" meets core within "&FIXED(PE_Rms,2)&" of a decade once calibrated",""&PE_MethodWords&" scatters "&FIXED(PE_Rms,2)&" of a decade about core even when calibrated: use the core transform or another method")                                                         |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 55  | How to use it: paste your depth, GR and bulk density over the log table and your plugs over the core table; shift the core onto the log by eye or by a gamma-ray match, and take Bvi from the oil leg's bulk volume water.               |                                                                                                   |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 56  | The log and core are synthetic, the log display workbook's interval. Log permeability is an estimate: calibrate it to core of the same rock type, and to a well test's kh where there is one.                                            |                                                                                                   |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 58  | Core Plugs on Depth, and Each Method at the Plug                                                                                                                                                                                         |                                                                                                   |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 59  | Core depth (ft)                                                                                                                                                                                                                          | φ core (%)                                                                                        | k core (mD)                                                                                                                                                                                                                                                                                                   | Log depth (ft)                                               | φ log (%)                                                     | Swirr (%)                                     | Timur (mD)                 | Coates (mD)                                       | Wyllie-Rose (mD)                                     | Transform (mD)                                                              |                                   |                                        |
| 60  | 5017                                                                                                                                                                                                                                     | 0.254                                                                                             | 1130                                                                                                                                                                                                                                                                                                          | =A60+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D60,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E60)                            | =PO.PP.Perm.Timur(E60,F60) | =PO.PP.Perm.Coates(E60,F60)                       | =PO.PP.Perm.WyllieRose(E60,F60,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E60)                                                         |                                   |                                        |
| 61  | 5019                                                                                                                                                                                                                                     | 0.263                                                                                             | 1330                                                                                                                                                                                                                                                                                                          | =A61+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D61,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E61)                            | =PO.PP.Perm.Timur(E61,F61) | =PO.PP.Perm.Coates(E61,F61)                       | =PO.PP.Perm.WyllieRose(E61,F61,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E61)                                                         |                                   |                                        |
| 62  | 5021                                                                                                                                                                                                                                     | 0.269                                                                                             | 1110                                                                                                                                                                                                                                                                                                          | =A62+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D62,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E62)                            | =PO.PP.Perm.Timur(E62,F62) | =PO.PP.Perm.Coates(E62,F62)                       | =PO.PP.Perm.WyllieRose(E62,F62,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E62)                                                         |                                   |                                        |
| 63  | 5025                                                                                                                                                                                                                                     | 0.261                                                                                             | 1790                                                                                                                                                                                                                                                                                                          | =A63+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D63,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E63)                            | =PO.PP.Perm.Timur(E63,F63) | =PO.PP.Perm.Coates(E63,F63)                       | =PO.PP.Perm.WyllieRose(E63,F63,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E63)                                                         |                                   |                                        |
| 64  | 5029                                                                                                                                                                                                                                     | 0.27                                                                                              | 1380                                                                                                                                                                                                                                                                                                          | =A64+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D64,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E64)                            | =PO.PP.Perm.Timur(E64,F64) | =PO.PP.Perm.Coates(E64,F64)                       | =PO.PP.Perm.WyllieRose(E64,F64,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E64)                                                         |                                   |                                        |
| 65  | 5033                                                                                                                                                                                                                                     | 0.264                                                                                             | 1110                                                                                                                                                                                                                                                                                                          | =A65+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D65,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E65)                            | =PO.PP.Perm.Timur(E65,F65) | =PO.PP.Perm.Coates(E65,F65)                       | =PO.PP.Perm.WyllieRose(E65,F65,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E65)                                                         |                                   |                                        |
| 66  | 5045                                                                                                                                                                                                                                     | 0.193                                                                                             | 90                                                                                                                                                                                                                                                                                                            | =A66+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D66,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E66)                            | =PO.PP.Perm.Timur(E66,F66) | =PO.PP.Perm.Coates(E66,F66)                       | =PO.PP.Perm.WyllieRose(E66,F66,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E66)                                                         |                                   |                                        |
| 67  | 5049                                                                                                                                                                                                                                     | 0.191                                                                                             | 36                                                                                                                                                                                                                                                                                                            | =A67+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D67,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E67)                            | =PO.PP.Perm.Timur(E67,F67) | =PO.PP.Perm.Coates(E67,F67)                       | =PO.PP.Perm.WyllieRose(E67,F67,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E67)                                                         |                                   |                                        |
| 68  | 5055                                                                                                                                                                                                                                     | 0.194                                                                                             | 68                                                                                                                                                                                                                                                                                                            | =A68+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D68,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E68)                            | =PO.PP.Perm.Timur(E68,F68) | =PO.PP.Perm.Coates(E68,F68)                       | =PO.PP.Perm.WyllieRose(E68,F68,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E68)                                                         |                                   |                                        |
| 69  | 5059                                                                                                                                                                                                                                     | 0.182                                                                                             | 47                                                                                                                                                                                                                                                                                                            | =A69+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D69,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E69)                            | =PO.PP.Perm.Timur(E69,F69) | =PO.PP.Perm.Coates(E69,F69)                       | =PO.PP.Perm.WyllieRose(E69,F69,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E69)                                                         |                                   |                                        |
| 70  | 5077                                                                                                                                                                                                                                     | 0.053                                                                                             | 0.08                                                                                                                                                                                                                                                                                                          | =A70+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D70,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E70)                            | =PO.PP.Perm.Timur(E70,F70) | =PO.PP.Perm.Coates(E70,F70)                       | =PO.PP.Perm.WyllieRose(E70,F70,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E70)                                                         |                                   |                                        |
| 71  | 5085                                                                                                                                                                                                                                     | 0.253                                                                                             | 1150                                                                                                                                                                                                                                                                                                          | =A71+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D71,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E71)                            | =PO.PP.Perm.Timur(E71,F71) | =PO.PP.Perm.Coates(E71,F71)                       | =PO.PP.Perm.WyllieRose(E71,F71,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E71)                                                         |                                   |                                        |
| 72  | 5089                                                                                                                                                                                                                                     | 0.259                                                                                             | 1040                                                                                                                                                                                                                                                                                                          | =A72+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D72,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E72)                            | =PO.PP.Perm.Timur(E72,F72) | =PO.PP.Perm.Coates(E72,F72)                       | =PO.PP.Perm.WyllieRose(E72,F72,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E72)                                                         |                                   |                                        |
| 73  | 5093                                                                                                                                                                                                                                     | 0.255                                                                                             | 630                                                                                                                                                                                                                                                                                                           | =A73+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D73,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E73)                            | =PO.PP.Perm.Timur(E73,F73) | =PO.PP.Perm.Coates(E73,F73)                       | =PO.PP.Perm.WyllieRose(E73,F73,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E73)                                                         |                                   |                                        |
| 74  | 5097                                                                                                                                                                                                                                     | 0.258                                                                                             | 1590                                                                                                                                                                                                                                                                                                          | =A74+PE_Shift                                                | =INDEX($E$94:$E$139,MATCH(D74,$A$94:$A$139,1))                | =MIN(1,PE_Bvi/E74)                            | =PO.PP.Perm.Timur(E74,F74) | =PO.PP.Perm.Coates(E74,F74)                       | =PO.PP.Perm.WyllieRose(E74,F74,PE_WrC,PE_WrP,PE_WrS) | =10^(PE_A+PE_B*E74)                                                         |                                   |                                        |
| 77  | Permeability against Porosity by Method (calibrated, Swirr = Bvi / φ)                                                                                                                                                                    |                                                                                                   |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 78  | φ (%)                                                                                                                                                                                                                                    | Swirr (%)                                                                                         | Timur, cal. (mD)                                                                                                                                                                                                                                                                                              | Coates, cal. (mD)                                            | Wyllie-Rose, cal. (mD)                                        | Core transform (mD)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 79  | 0.05                                                                                                                                                                                                                                     | =MIN(1,PE_Bvi/A79)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A79,B79)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A79,B79)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A79,B79,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A79)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 80  | 0.075                                                                                                                                                                                                                                    | =MIN(1,PE_Bvi/A80)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A80,B80)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A80,B80)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A80,B80,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A80)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 81  | 0.1                                                                                                                                                                                                                                      | =MIN(1,PE_Bvi/A81)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A81,B81)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A81,B81)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A81,B81,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A81)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 82  | 0.125                                                                                                                                                                                                                                    | =MIN(1,PE_Bvi/A82)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A82,B82)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A82,B82)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A82,B82,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A82)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 83  | 0.15                                                                                                                                                                                                                                     | =MIN(1,PE_Bvi/A83)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A83,B83)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A83,B83)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A83,B83,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A83)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 84  | 0.175                                                                                                                                                                                                                                    | =MIN(1,PE_Bvi/A84)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A84,B84)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A84,B84)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A84,B84,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A84)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 85  | 0.2                                                                                                                                                                                                                                      | =MIN(1,PE_Bvi/A85)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A85,B85)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A85,B85)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A85,B85,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A85)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 86  | 0.225                                                                                                                                                                                                                                    | =MIN(1,PE_Bvi/A86)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A86,B86)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A86,B86)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A86,B86,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A86)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 87  | 0.25                                                                                                                                                                                                                                     | =MIN(1,PE_Bvi/A87)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A87,B87)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A87,B87)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A87,B87,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A87)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 88  | 0.275                                                                                                                                                                                                                                    | =MIN(1,PE_Bvi/A88)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A88,B88)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A88,B88)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A88,B88,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A88)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 89  | 0.3                                                                                                                                                                                                                                      | =MIN(1,PE_Bvi/A89)                                                                                | =PE_CalT*PO.PP.Perm.Timur(A89,B89)                                                                                                                                                                                                                                                                            | =PE_CalC*PO.PP.Perm.Coates(A89,B89)                          | =PE_CalW*PO.PP.Perm.WyllieRose(A89,B89,PE_WrC,PE_WrP,PE_WrS)  | =10^(PE_A+PE_B*A89)                           |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 92  | Log: Readings and Permeability by Method (the log display workbook's interval, 5,010 to 5,100 ft every 2 ft)                                                                                                                             |                                                                                                   |                                                                                                                                                                                                                                                                                                               |                                                              |                                                               |                                               |                            |                                                   |                                                      |                                                                             |                                   |                                        |
| 93  | Depth (ft)                                                                                                                                                                                                                               | GR (API)                                                                                          | RHOB (g/cm³)                                                                                                                                                                                                                                                                                                  | Vsh (v/v)                                                    | φ density (%)                                                 | Reservoir                                     | Swirr (%)                  | Timur, cal. (mD)                                  | Coates, cal. (mD)                                    | Wyllie-Rose, cal. (mD)                                                      | Transform (mD)                    | Reported (mD)                          |
| 94  | 5010                                                                                                                                                                                                                                     | 108.4                                                                                             | 2.462                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B94,PE_GRcl,PE_GRsh)))  | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C94,PE_RhoF))  | =IF(AND(D94<=PE_VshCut,E94>=PE_PhiCut),1,0)   | =MIN(1,PE_Bvi/E94)         | =IF(F94=1,PE_CalT*PO.PP.Perm.Timur(E94,G94),0)    | =IF(F94=1,PE_CalC*PO.PP.Perm.Coates(E94,G94),0)      | =IF(F94=1,PE_CalW*PO.PP.Perm.WyllieRose(E94,G94,PE_WrC,PE_WrP,PE_WrS),0)    | =IF(F94=1,10^(PE_A+PE_B*E94),0)   | =CHOOSE(PE_Method,H94,I94,J94,K94)     |
| 95  | 5012                                                                                                                                                                                                                                     | 73.9                                                                                              | 2.339                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B95,PE_GRcl,PE_GRsh)))  | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C95,PE_RhoF))  | =IF(AND(D95<=PE_VshCut,E95>=PE_PhiCut),1,0)   | =MIN(1,PE_Bvi/E95)         | =IF(F95=1,PE_CalT*PO.PP.Perm.Timur(E95,G95),0)    | =IF(F95=1,PE_CalC*PO.PP.Perm.Coates(E95,G95),0)      | =IF(F95=1,PE_CalW*PO.PP.Perm.WyllieRose(E95,G95,PE_WrC,PE_WrP,PE_WrS),0)    | =IF(F95=1,10^(PE_A+PE_B*E95),0)   | =CHOOSE(PE_Method,H95,I95,J95,K95)     |
| 96  | 5014                                                                                                                                                                                                                                     | 35.2                                                                                              | 2.237                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B96,PE_GRcl,PE_GRsh)))  | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C96,PE_RhoF))  | =IF(AND(D96<=PE_VshCut,E96>=PE_PhiCut),1,0)   | =MIN(1,PE_Bvi/E96)         | =IF(F96=1,PE_CalT*PO.PP.Perm.Timur(E96,G96),0)    | =IF(F96=1,PE_CalC*PO.PP.Perm.Coates(E96,G96),0)      | =IF(F96=1,PE_CalW*PO.PP.Perm.WyllieRose(E96,G96,PE_WrC,PE_WrP,PE_WrS),0)    | =IF(F96=1,10^(PE_A+PE_B*E96),0)   | =CHOOSE(PE_Method,H96,I96,J96,K96)     |
| 97  | 5016                                                                                                                                                                                                                                     | 36.1                                                                                              | 2.209                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B97,PE_GRcl,PE_GRsh)))  | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C97,PE_RhoF))  | =IF(AND(D97<=PE_VshCut,E97>=PE_PhiCut),1,0)   | =MIN(1,PE_Bvi/E97)         | =IF(F97=1,PE_CalT*PO.PP.Perm.Timur(E97,G97),0)    | =IF(F97=1,PE_CalC*PO.PP.Perm.Coates(E97,G97),0)      | =IF(F97=1,PE_CalW*PO.PP.Perm.WyllieRose(E97,G97,PE_WrC,PE_WrP,PE_WrS),0)    | =IF(F97=1,10^(PE_A+PE_B*E97),0)   | =CHOOSE(PE_Method,H97,I97,J97,K97)     |
| 98  | 5018                                                                                                                                                                                                                                     | 29.5                                                                                              | 2.212                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B98,PE_GRcl,PE_GRsh)))  | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C98,PE_RhoF))  | =IF(AND(D98<=PE_VshCut,E98>=PE_PhiCut),1,0)   | =MIN(1,PE_Bvi/E98)         | =IF(F98=1,PE_CalT*PO.PP.Perm.Timur(E98,G98),0)    | =IF(F98=1,PE_CalC*PO.PP.Perm.Coates(E98,G98),0)      | =IF(F98=1,PE_CalW*PO.PP.Perm.WyllieRose(E98,G98,PE_WrC,PE_WrP,PE_WrS),0)    | =IF(F98=1,10^(PE_A+PE_B*E98),0)   | =CHOOSE(PE_Method,H98,I98,J98,K98)     |
| 99  | 5020                                                                                                                                                                                                                                     | 33.4                                                                                              | 2.21                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B99,PE_GRcl,PE_GRsh)))  | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C99,PE_RhoF))  | =IF(AND(D99<=PE_VshCut,E99>=PE_PhiCut),1,0)   | =MIN(1,PE_Bvi/E99)         | =IF(F99=1,PE_CalT*PO.PP.Perm.Timur(E99,G99),0)    | =IF(F99=1,PE_CalC*PO.PP.Perm.Coates(E99,G99),0)      | =IF(F99=1,PE_CalW*PO.PP.Perm.WyllieRose(E99,G99,PE_WrC,PE_WrP,PE_WrS),0)    | =IF(F99=1,10^(PE_A+PE_B*E99),0)   | =CHOOSE(PE_Method,H99,I99,J99,K99)     |
| 100 | 5022                                                                                                                                                                                                                                     | 31.1                                                                                              | 2.214                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B100,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C100,PE_RhoF)) | =IF(AND(D100<=PE_VshCut,E100>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E100)        | =IF(F100=1,PE_CalT*PO.PP.Perm.Timur(E100,G100),0) | =IF(F100=1,PE_CalC*PO.PP.Perm.Coates(E100,G100),0)   | =IF(F100=1,PE_CalW*PO.PP.Perm.WyllieRose(E100,G100,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F100=1,10^(PE_A+PE_B*E100),0) | =CHOOSE(PE_Method,H100,I100,J100,K100) |
| 101 | 5024                                                                                                                                                                                                                                     | 35                                                                                                | 2.209                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B101,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C101,PE_RhoF)) | =IF(AND(D101<=PE_VshCut,E101>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E101)        | =IF(F101=1,PE_CalT*PO.PP.Perm.Timur(E101,G101),0) | =IF(F101=1,PE_CalC*PO.PP.Perm.Coates(E101,G101),0)   | =IF(F101=1,PE_CalW*PO.PP.Perm.WyllieRose(E101,G101,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F101=1,10^(PE_A+PE_B*E101),0) | =CHOOSE(PE_Method,H101,I101,J101,K101) |
| 102 | 5026                                                                                                                                                                                                                                     | 29.8                                                                                              | 2.21                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B102,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C102,PE_RhoF)) | =IF(AND(D102<=PE_VshCut,E102>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E102)        | =IF(F102=1,PE_CalT*PO.PP.Perm.Timur(E102,G102),0) | =IF(F102=1,PE_CalC*PO.PP.Perm.Coates(E102,G102),0)   | =IF(F102=1,PE_CalW*PO.PP.Perm.WyllieRose(E102,G102,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F102=1,10^(PE_A+PE_B*E102),0) | =CHOOSE(PE_Method,H102,I102,J102,K102) |
| 103 | 5028                                                                                                                                                                                                                                     | 34                                                                                                | 2.216                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B103,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C103,PE_RhoF)) | =IF(AND(D103<=PE_VshCut,E103>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E103)        | =IF(F103=1,PE_CalT*PO.PP.Perm.Timur(E103,G103),0) | =IF(F103=1,PE_CalC*PO.PP.Perm.Coates(E103,G103),0)   | =IF(F103=1,PE_CalW*PO.PP.Perm.WyllieRose(E103,G103,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F103=1,10^(PE_A+PE_B*E103),0) | =CHOOSE(PE_Method,H103,I103,J103,K103) |
| 104 | 5030                                                                                                                                                                                                                                     | 34                                                                                                | 2.208                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B104,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C104,PE_RhoF)) | =IF(AND(D104<=PE_VshCut,E104>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E104)        | =IF(F104=1,PE_CalT*PO.PP.Perm.Timur(E104,G104),0) | =IF(F104=1,PE_CalC*PO.PP.Perm.Coates(E104,G104),0)   | =IF(F104=1,PE_CalW*PO.PP.Perm.WyllieRose(E104,G104,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F104=1,10^(PE_A+PE_B*E104),0) | =CHOOSE(PE_Method,H104,I104,J104,K104) |
| 105 | 5032                                                                                                                                                                                                                                     | 37.5                                                                                              | 2.234                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B105,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C105,PE_RhoF)) | =IF(AND(D105<=PE_VshCut,E105>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E105)        | =IF(F105=1,PE_CalT*PO.PP.Perm.Timur(E105,G105),0) | =IF(F105=1,PE_CalC*PO.PP.Perm.Coates(E105,G105),0)   | =IF(F105=1,PE_CalW*PO.PP.Perm.WyllieRose(E105,G105,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F105=1,10^(PE_A+PE_B*E105),0) | =CHOOSE(PE_Method,H105,I105,J105,K105) |
| 106 | 5034                                                                                                                                                                                                                                     | 74.7                                                                                              | 2.344                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B106,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C106,PE_RhoF)) | =IF(AND(D106<=PE_VshCut,E106>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E106)        | =IF(F106=1,PE_CalT*PO.PP.Perm.Timur(E106,G106),0) | =IF(F106=1,PE_CalC*PO.PP.Perm.Coates(E106,G106),0)   | =IF(F106=1,PE_CalW*PO.PP.Perm.WyllieRose(E106,G106,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F106=1,10^(PE_A+PE_B*E106),0) | =CHOOSE(PE_Method,H106,I106,J106,K106) |
| 107 | 5036                                                                                                                                                                                                                                     | 108.7                                                                                             | 2.463                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B107,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C107,PE_RhoF)) | =IF(AND(D107<=PE_VshCut,E107>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E107)        | =IF(F107=1,PE_CalT*PO.PP.Perm.Timur(E107,G107),0) | =IF(F107=1,PE_CalC*PO.PP.Perm.Coates(E107,G107),0)   | =IF(F107=1,PE_CalW*PO.PP.Perm.WyllieRose(E107,G107,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F107=1,10^(PE_A+PE_B*E107),0) | =CHOOSE(PE_Method,H107,I107,J107,K107) |
| 108 | 5038                                                                                                                                                                                                                                     | 112.2                                                                                             | 2.461                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B108,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C108,PE_RhoF)) | =IF(AND(D108<=PE_VshCut,E108>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E108)        | =IF(F108=1,PE_CalT*PO.PP.Perm.Timur(E108,G108),0) | =IF(F108=1,PE_CalC*PO.PP.Perm.Coates(E108,G108),0)   | =IF(F108=1,PE_CalW*PO.PP.Perm.WyllieRose(E108,G108,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F108=1,10^(PE_A+PE_B*E108),0) | =CHOOSE(PE_Method,H108,I108,J108,K108) |
| 109 | 5040                                                                                                                                                                                                                                     | 85.4                                                                                              | 2.41                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B109,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C109,PE_RhoF)) | =IF(AND(D109<=PE_VshCut,E109>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E109)        | =IF(F109=1,PE_CalT*PO.PP.Perm.Timur(E109,G109),0) | =IF(F109=1,PE_CalC*PO.PP.Perm.Coates(E109,G109),0)   | =IF(F109=1,PE_CalW*PO.PP.Perm.WyllieRose(E109,G109,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F109=1,10^(PE_A+PE_B*E109),0) | =CHOOSE(PE_Method,H109,I109,J109,K109) |
| 110 | 5042                                                                                                                                                                                                                                     | 69.7                                                                                              | 2.338                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B110,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C110,PE_RhoF)) | =IF(AND(D110<=PE_VshCut,E110>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E110)        | =IF(F110=1,PE_CalT*PO.PP.Perm.Timur(E110,G110),0) | =IF(F110=1,PE_CalC*PO.PP.Perm.Coates(E110,G110),0)   | =IF(F110=1,PE_CalW*PO.PP.Perm.WyllieRose(E110,G110,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F110=1,10^(PE_A+PE_B*E110),0) | =CHOOSE(PE_Method,H110,I110,J110,K110) |
| 111 | 5044                                                                                                                                                                                                                                     | 59.9                                                                                              | 2.33                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B111,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C111,PE_RhoF)) | =IF(AND(D111<=PE_VshCut,E111>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E111)        | =IF(F111=1,PE_CalT*PO.PP.Perm.Timur(E111,G111),0) | =IF(F111=1,PE_CalC*PO.PP.Perm.Coates(E111,G111),0)   | =IF(F111=1,PE_CalW*PO.PP.Perm.WyllieRose(E111,G111,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F111=1,10^(PE_A+PE_B*E111),0) | =CHOOSE(PE_Method,H111,I111,J111,K111) |
| 112 | 5046                                                                                                                                                                                                                                     | 62.8                                                                                              | 2.329                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B112,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C112,PE_RhoF)) | =IF(AND(D112<=PE_VshCut,E112>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E112)        | =IF(F112=1,PE_CalT*PO.PP.Perm.Timur(E112,G112),0) | =IF(F112=1,PE_CalC*PO.PP.Perm.Coates(E112,G112),0)   | =IF(F112=1,PE_CalW*PO.PP.Perm.WyllieRose(E112,G112,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F112=1,10^(PE_A+PE_B*E112),0) | =CHOOSE(PE_Method,H112,I112,J112,K112) |
| 113 | 5048                                                                                                                                                                                                                                     | 60.8                                                                                              | 2.333                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B113,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C113,PE_RhoF)) | =IF(AND(D113<=PE_VshCut,E113>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E113)        | =IF(F113=1,PE_CalT*PO.PP.Perm.Timur(E113,G113),0) | =IF(F113=1,PE_CalC*PO.PP.Perm.Coates(E113,G113),0)   | =IF(F113=1,PE_CalW*PO.PP.Perm.WyllieRose(E113,G113,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F113=1,10^(PE_A+PE_B*E113),0) | =CHOOSE(PE_Method,H113,I113,J113,K113) |
| 114 | 5050                                                                                                                                                                                                                                     | 65.4                                                                                              | 2.335                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B114,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C114,PE_RhoF)) | =IF(AND(D114<=PE_VshCut,E114>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E114)        | =IF(F114=1,PE_CalT*PO.PP.Perm.Timur(E114,G114),0) | =IF(F114=1,PE_CalC*PO.PP.Perm.Coates(E114,G114),0)   | =IF(F114=1,PE_CalW*PO.PP.Perm.WyllieRose(E114,G114,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F114=1,10^(PE_A+PE_B*E114),0) | =CHOOSE(PE_Method,H114,I114,J114,K114) |
| 115 | 5052                                                                                                                                                                                                                                     | 61.1                                                                                              | 2.336                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B115,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C115,PE_RhoF)) | =IF(AND(D115<=PE_VshCut,E115>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E115)        | =IF(F115=1,PE_CalT*PO.PP.Perm.Timur(E115,G115),0) | =IF(F115=1,PE_CalC*PO.PP.Perm.Coates(E115,G115),0)   | =IF(F115=1,PE_CalW*PO.PP.Perm.WyllieRose(E115,G115,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F115=1,10^(PE_A+PE_B*E115),0) | =CHOOSE(PE_Method,H115,I115,J115,K115) |
| 116 | 5054                                                                                                                                                                                                                                     | 64.1                                                                                              | 2.345                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B116,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C116,PE_RhoF)) | =IF(AND(D116<=PE_VshCut,E116>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E116)        | =IF(F116=1,PE_CalT*PO.PP.Perm.Timur(E116,G116),0) | =IF(F116=1,PE_CalC*PO.PP.Perm.Coates(E116,G116),0)   | =IF(F116=1,PE_CalW*PO.PP.Perm.WyllieRose(E116,G116,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F116=1,10^(PE_A+PE_B*E116),0) | =CHOOSE(PE_Method,H116,I116,J116,K116) |
| 117 | 5056                                                                                                                                                                                                                                     | 68.7                                                                                              | 2.345                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B117,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C117,PE_RhoF)) | =IF(AND(D117<=PE_VshCut,E117>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E117)        | =IF(F117=1,PE_CalT*PO.PP.Perm.Timur(E117,G117),0) | =IF(F117=1,PE_CalC*PO.PP.Perm.Coates(E117,G117),0)   | =IF(F117=1,PE_CalW*PO.PP.Perm.WyllieRose(E117,G117,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F117=1,10^(PE_A+PE_B*E117),0) | =CHOOSE(PE_Method,H117,I117,J117,K117) |
| 118 | 5058                                                                                                                                                                                                                                     | 87.1                                                                                              | 2.412                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B118,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C118,PE_RhoF)) | =IF(AND(D118<=PE_VshCut,E118>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E118)        | =IF(F118=1,PE_CalT*PO.PP.Perm.Timur(E118,G118),0) | =IF(F118=1,PE_CalC*PO.PP.Perm.Coates(E118,G118),0)   | =IF(F118=1,PE_CalW*PO.PP.Perm.WyllieRose(E118,G118,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F118=1,10^(PE_A+PE_B*E118),0) | =CHOOSE(PE_Method,H118,I118,J118,K118) |
| 119 | 5060                                                                                                                                                                                                                                     | 111.4                                                                                             | 2.467                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B119,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C119,PE_RhoF)) | =IF(AND(D119<=PE_VshCut,E119>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E119)        | =IF(F119=1,PE_CalT*PO.PP.Perm.Timur(E119,G119),0) | =IF(F119=1,PE_CalC*PO.PP.Perm.Coates(E119,G119),0)   | =IF(F119=1,PE_CalW*PO.PP.Perm.WyllieRose(E119,G119,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F119=1,10^(PE_A+PE_B*E119),0) | =CHOOSE(PE_Method,H119,I119,J119,K119) |
| 120 | 5062                                                                                                                                                                                                                                     | 113.6                                                                                             | 2.483                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B120,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C120,PE_RhoF)) | =IF(AND(D120<=PE_VshCut,E120>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E120)        | =IF(F120=1,PE_CalT*PO.PP.Perm.Timur(E120,G120),0) | =IF(F120=1,PE_CalC*PO.PP.Perm.Coates(E120,G120),0)   | =IF(F120=1,PE_CalW*PO.PP.Perm.WyllieRose(E120,G120,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F120=1,10^(PE_A+PE_B*E120),0) | =CHOOSE(PE_Method,H120,I120,J120,K120) |
| 121 | 5064                                                                                                                                                                                                                                     | 116.6                                                                                             | 2.474                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B121,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C121,PE_RhoF)) | =IF(AND(D121<=PE_VshCut,E121>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E121)        | =IF(F121=1,PE_CalT*PO.PP.Perm.Timur(E121,G121),0) | =IF(F121=1,PE_CalC*PO.PP.Perm.Coates(E121,G121),0)   | =IF(F121=1,PE_CalW*PO.PP.Perm.WyllieRose(E121,G121,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F121=1,10^(PE_A+PE_B*E121),0) | =CHOOSE(PE_Method,H121,I121,J121,K121) |
| 122 | 5066                                                                                                                                                                                                                                     | 111.2                                                                                             | 2.485                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B122,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C122,PE_RhoF)) | =IF(AND(D122<=PE_VshCut,E122>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E122)        | =IF(F122=1,PE_CalT*PO.PP.Perm.Timur(E122,G122),0) | =IF(F122=1,PE_CalC*PO.PP.Perm.Coates(E122,G122),0)   | =IF(F122=1,PE_CalW*PO.PP.Perm.WyllieRose(E122,G122,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F122=1,10^(PE_A+PE_B*E122),0) | =CHOOSE(PE_Method,H122,I122,J122,K122) |
| 123 | 5068                                                                                                                                                                                                                                     | 117.9                                                                                             | 2.48                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B123,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C123,PE_RhoF)) | =IF(AND(D123<=PE_VshCut,E123>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E123)        | =IF(F123=1,PE_CalT*PO.PP.Perm.Timur(E123,G123),0) | =IF(F123=1,PE_CalC*PO.PP.Perm.Coates(E123,G123),0)   | =IF(F123=1,PE_CalW*PO.PP.Perm.WyllieRose(E123,G123,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F123=1,10^(PE_A+PE_B*E123),0) | =CHOOSE(PE_Method,H123,I123,J123,K123) |
| 124 | 5070                                                                                                                                                                                                                                     | 106.2                                                                                             | 2.488                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B124,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C124,PE_RhoF)) | =IF(AND(D124<=PE_VshCut,E124>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E124)        | =IF(F124=1,PE_CalT*PO.PP.Perm.Timur(E124,G124),0) | =IF(F124=1,PE_CalC*PO.PP.Perm.Coates(E124,G124),0)   | =IF(F124=1,PE_CalW*PO.PP.Perm.WyllieRose(E124,G124,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F124=1,10^(PE_A+PE_B*E124),0) | =CHOOSE(PE_Method,H124,I124,J124,K124) |
| 125 | 5072                                                                                                                                                                                                                                     | 69.6                                                                                              | 2.53                                                                                                                                                                                                                                                                                                          | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B125,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C125,PE_RhoF)) | =IF(AND(D125<=PE_VshCut,E125>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E125)        | =IF(F125=1,PE_CalT*PO.PP.Perm.Timur(E125,G125),0) | =IF(F125=1,PE_CalC*PO.PP.Perm.Coates(E125,G125),0)   | =IF(F125=1,PE_CalW*PO.PP.Perm.WyllieRose(E125,G125,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F125=1,10^(PE_A+PE_B*E125),0) | =CHOOSE(PE_Method,H125,I125,J125,K125) |
| 126 | 5074                                                                                                                                                                                                                                     | 28.7                                                                                              | 2.567                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B126,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C126,PE_RhoF)) | =IF(AND(D126<=PE_VshCut,E126>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E126)        | =IF(F126=1,PE_CalT*PO.PP.Perm.Timur(E126,G126),0) | =IF(F126=1,PE_CalC*PO.PP.Perm.Coates(E126,G126),0)   | =IF(F126=1,PE_CalW*PO.PP.Perm.WyllieRose(E126,G126,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F126=1,10^(PE_A+PE_B*E126),0) | =CHOOSE(PE_Method,H126,I126,J126,K126) |
| 127 | 5076                                                                                                                                                                                                                                     | 28.4                                                                                              | 2.502                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B127,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C127,PE_RhoF)) | =IF(AND(D127<=PE_VshCut,E127>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E127)        | =IF(F127=1,PE_CalT*PO.PP.Perm.Timur(E127,G127),0) | =IF(F127=1,PE_CalC*PO.PP.Perm.Coates(E127,G127),0)   | =IF(F127=1,PE_CalW*PO.PP.Perm.WyllieRose(E127,G127,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F127=1,10^(PE_A+PE_B*E127),0) | =CHOOSE(PE_Method,H127,I127,J127,K127) |
| 128 | 5078                                                                                                                                                                                                                                     | 31.9                                                                                              | 2.306                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B128,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C128,PE_RhoF)) | =IF(AND(D128<=PE_VshCut,E128>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E128)        | =IF(F128=1,PE_CalT*PO.PP.Perm.Timur(E128,G128),0) | =IF(F128=1,PE_CalC*PO.PP.Perm.Coates(E128,G128),0)   | =IF(F128=1,PE_CalW*PO.PP.Perm.WyllieRose(E128,G128,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F128=1,10^(PE_A+PE_B*E128),0) | =CHOOSE(PE_Method,H128,I128,J128,K128) |
| 129 | 5080                                                                                                                                                                                                                                     | 36                                                                                                | 2.245                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B129,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C129,PE_RhoF)) | =IF(AND(D129<=PE_VshCut,E129>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E129)        | =IF(F129=1,PE_CalT*PO.PP.Perm.Timur(E129,G129),0) | =IF(F129=1,PE_CalC*PO.PP.Perm.Coates(E129,G129),0)   | =IF(F129=1,PE_CalW*PO.PP.Perm.WyllieRose(E129,G129,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F129=1,10^(PE_A+PE_B*E129),0) | =CHOOSE(PE_Method,H129,I129,J129,K129) |
| 130 | 5082                                                                                                                                                                                                                                     | 38.7                                                                                              | 2.227                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B130,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C130,PE_RhoF)) | =IF(AND(D130<=PE_VshCut,E130>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E130)        | =IF(F130=1,PE_CalT*PO.PP.Perm.Timur(E130,G130),0) | =IF(F130=1,PE_CalC*PO.PP.Perm.Coates(E130,G130),0)   | =IF(F130=1,PE_CalW*PO.PP.Perm.WyllieRose(E130,G130,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F130=1,10^(PE_A+PE_B*E130),0) | =CHOOSE(PE_Method,H130,I130,J130,K130) |
| 131 | 5084                                                                                                                                                                                                                                     | 34.6                                                                                              | 2.233                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B131,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C131,PE_RhoF)) | =IF(AND(D131<=PE_VshCut,E131>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E131)        | =IF(F131=1,PE_CalT*PO.PP.Perm.Timur(E131,G131),0) | =IF(F131=1,PE_CalC*PO.PP.Perm.Coates(E131,G131),0)   | =IF(F131=1,PE_CalW*PO.PP.Perm.WyllieRose(E131,G131,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F131=1,10^(PE_A+PE_B*E131),0) | =CHOOSE(PE_Method,H131,I131,J131,K131) |
| 132 | 5086                                                                                                                                                                                                                                     | 37.5                                                                                              | 2.228                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B132,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C132,PE_RhoF)) | =IF(AND(D132<=PE_VshCut,E132>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E132)        | =IF(F132=1,PE_CalT*PO.PP.Perm.Timur(E132,G132),0) | =IF(F132=1,PE_CalC*PO.PP.Perm.Coates(E132,G132),0)   | =IF(F132=1,PE_CalW*PO.PP.Perm.WyllieRose(E132,G132,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F132=1,10^(PE_A+PE_B*E132),0) | =CHOOSE(PE_Method,H132,I132,J132,K132) |
| 133 | 5088                                                                                                                                                                                                                                     | 35.5                                                                                              | 2.235                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B133,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C133,PE_RhoF)) | =IF(AND(D133<=PE_VshCut,E133>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E133)        | =IF(F133=1,PE_CalT*PO.PP.Perm.Timur(E133,G133),0) | =IF(F133=1,PE_CalC*PO.PP.Perm.Coates(E133,G133),0)   | =IF(F133=1,PE_CalW*PO.PP.Perm.WyllieRose(E133,G133,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F133=1,10^(PE_A+PE_B*E133),0) | =CHOOSE(PE_Method,H133,I133,J133,K133) |
| 134 | 5090                                                                                                                                                                                                                                     | 38.7                                                                                              | 2.224                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B134,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C134,PE_RhoF)) | =IF(AND(D134<=PE_VshCut,E134>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E134)        | =IF(F134=1,PE_CalT*PO.PP.Perm.Timur(E134,G134),0) | =IF(F134=1,PE_CalC*PO.PP.Perm.Coates(E134,G134),0)   | =IF(F134=1,PE_CalW*PO.PP.Perm.WyllieRose(E134,G134,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F134=1,10^(PE_A+PE_B*E134),0) | =CHOOSE(PE_Method,H134,I134,J134,K134) |
| 135 | 5092                                                                                                                                                                                                                                     | 32.3                                                                                              | 2.233                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B135,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C135,PE_RhoF)) | =IF(AND(D135<=PE_VshCut,E135>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E135)        | =IF(F135=1,PE_CalT*PO.PP.Perm.Timur(E135,G135),0) | =IF(F135=1,PE_CalC*PO.PP.Perm.Coates(E135,G135),0)   | =IF(F135=1,PE_CalW*PO.PP.Perm.WyllieRose(E135,G135,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F135=1,10^(PE_A+PE_B*E135),0) | =CHOOSE(PE_Method,H135,I135,J135,K135) |
| 136 | 5094                                                                                                                                                                                                                                     | 39.2                                                                                              | 2.229                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B136,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C136,PE_RhoF)) | =IF(AND(D136<=PE_VshCut,E136>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E136)        | =IF(F136=1,PE_CalT*PO.PP.Perm.Timur(E136,G136),0) | =IF(F136=1,PE_CalC*PO.PP.Perm.Coates(E136,G136),0)   | =IF(F136=1,PE_CalW*PO.PP.Perm.WyllieRose(E136,G136,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F136=1,10^(PE_A+PE_B*E136),0) | =CHOOSE(PE_Method,H136,I136,J136,K136) |
| 137 | 5096                                                                                                                                                                                                                                     | 34.9                                                                                              | 2.229                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B137,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C137,PE_RhoF)) | =IF(AND(D137<=PE_VshCut,E137>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E137)        | =IF(F137=1,PE_CalT*PO.PP.Perm.Timur(E137,G137),0) | =IF(F137=1,PE_CalC*PO.PP.Perm.Coates(E137,G137),0)   | =IF(F137=1,PE_CalW*PO.PP.Perm.WyllieRose(E137,G137,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F137=1,10^(PE_A+PE_B*E137),0) | =CHOOSE(PE_Method,H137,I137,J137,K137) |
| 138 | 5098                                                                                                                                                                                                                                     | 42                                                                                                | 2.248                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B138,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C138,PE_RhoF)) | =IF(AND(D138<=PE_VshCut,E138>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E138)        | =IF(F138=1,PE_CalT*PO.PP.Perm.Timur(E138,G138),0) | =IF(F138=1,PE_CalC*PO.PP.Perm.Coates(E138,G138),0)   | =IF(F138=1,PE_CalW*PO.PP.Perm.WyllieRose(E138,G138,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F138=1,10^(PE_A+PE_B*E138),0) | =CHOOSE(PE_Method,H138,I138,J138,K138) |
| 139 | 5100                                                                                                                                                                                                                                     | 74                                                                                                | 2.355                                                                                                                                                                                                                                                                                                         | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B139,PE_GRcl,PE_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(PE_RhoMa,C139,PE_RhoF)) | =IF(AND(D139<=PE_VshCut,E139>=PE_PhiCut),1,0) | =MIN(1,PE_Bvi/E139)        | =IF(F139=1,PE_CalT*PO.PP.Perm.Timur(E139,G139),0) | =IF(F139=1,PE_CalC*PO.PP.Perm.Coates(E139,G139),0)   | =IF(F139=1,PE_CalW*PO.PP.Perm.WyllieRose(E139,G139,PE_WrC,PE_WrP,PE_WrS),0) | =IF(F139=1,10^(PE_A+PE_B*E139),0) | =CHOOSE(PE_Method,H139,I139,J139,K139) |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.PP.Vsh.GammaRayIndex | =LAMBDA(GR, GR_cl, GR_sh, (GR-GR_cl)/(GR_sh-GR_cl)) | Linear gamma-ray shale index, IGR = (GR - GRclean) / (GRshale - GRclean). |
| PO.PP.Porosity.FromDensity | =LAMBDA(Rho_ma, Rho_b, Rho_f, (Rho_ma-Rho_b)/(Rho_ma-Rho_f)) | Porosity from a density log, (matrix density - bulk density) / (matrix density - fluid density). |
| PO.PP.Perm.Timur | =LAMBDA(Phi, Swirr, 0.136*(100*Phi)^4.4/(100*Swirr)^2) | Timur (1968) permeability, k = 0.136 phi^4.4 / Swirr^2 with phi and Swirr in percent, mD (arguments as fractions). |
| PO.PP.Perm.Coates | =LAMBDA(Phi, Swirr, 10000*Phi^4*((1-Swirr)/Swirr)^2) | Coates free-fluid permeability, k = (100 phi^2 (1 - Swirr) / Swirr)^2, mD (fractions). |
| PO.PP.Perm.WyllieRose | =LAMBDA(Phi, Swirr, Coef, Exp_Phi, Exp_Sw, Coef^2*Phi^(2*Exp_Phi)/Swirr^(2*Exp_Sw)) | Wyllie-Rose (1950) general permeability form, k = (Coef phi^Exp_Phi / Swirr^Exp_Sw)^2, mD (fractions). |
| PO.PP.Perm.PoroPermFit | =LAMBDA(Phi_core, K_core, LET(lk, LOG10(K_core), HSTACK(INTERCEPT(lk, Phi_core), SLOPE(lk, Phi_core), RSQ(lk, Phi_core)))) | Log-linear poro-perm transform fitted to core points, log10(k) = A + B phi: {A, B, R2}. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| PE_GRcl | $B$4 | Clean-sand gamma ray (Vsh = 0), API |
| PE_GRsh | $B$5 | Shale gamma ray (Vsh = 1), API |
| PE_RhoMa | $B$6 | Matrix density (sandstone), g/cm³ |
| PE_RhoF | $B$7 | Fluid density (fresh mud filtrate), g/cm³ |
| PE_VshCut | $B$8 | Shale-volume cutoff for reservoir, v/v |
| PE_PhiCut | $B$9 | Porosity cutoff for reservoir, % |
| PE_Bvi | $B$10 | Irreducible bulk volume water φ Swirr (the oil sand's), v/v |
| PE_WrC | $B$11 | Wyllie-Rose coefficient (Tixier: 250) |
| PE_WrP | $B$12 | Wyllie-Rose porosity exponent (Tixier: 3) |
| PE_WrS | $B$13 | Wyllie-Rose Swirr exponent (Tixier: 1) |
| PE_Shift | $B$14 | Core-to-log depth shift, added to the core depth, ft |
| PE_ZTop | $B$15 | Zone top (the clean oil sand, a foot inside), ft |
| PE_ZBase | $B$16 | Zone base (a foot inside the bed's base), ft |
| PE_Method | $B$17 | Method reported (1 Timur, 2 Coates, 3 Wyllie-Rose, 4 transform) |
| PE_LogTol | $B$18 | Largest scatter of a calibrated method about core, in decades, cycles |
| PE_PhiTol | $B$19 | Largest mean miss of core porosity from the log's, on depth, % |
| PE_R2Min | $B$20 | Lowest R² of the core poro-perm fit |
| PE_Inputs | $B$4:$B$20 | The gamma-ray picks, matrix and fluid densities, the reservoir cutoffs, the irreducible bulk volume water, the Wyllie-Rose constants, the core's depth shift, the zone, the method reported and the check limits |
| PE_Step | $B$26 | Log sample spacing, ft |
| PE_ZPhi | $B$27 | Zone mean porosity (reservoir samples), % |
| PE_ZSwi | $B$28 | Zone mean Swirr = Bvi / φ, % |
| PE_PhiMiss | $B$29 | Mean miss of core porosity from the log's, on depth, % |
| PE_A | $B$30 | Core transform log10 k = A + B φ, A |
| PE_B | $B$31 | Core transform, B |
| PE_R2 | $B$32 | Core transform, R² |
| PE_BiasT | $B$33 | Timur, mean log10 of log over core at the plugs (bias), cycles |
| PE_CalT | $B$34 | Timur, calibration factor 10^−bias |
| PE_BiasC | $B$35 | Coates, mean log10 of log over core at the plugs (bias), cycles |
| PE_CalC | $B$36 | Coates, calibration factor 10^−bias |
| PE_BiasW | $B$37 | Wyllie-Rose, mean log10 of log over core at the plugs (bias), cycles |
| PE_CalW | $B$38 | Wyllie-Rose, calibration factor 10^−bias |
| PE_RmsT | $B$39 | Timur, scatter about core (RMS), cycles |
| PE_RmsC | $B$40 | Coates, scatter about core (RMS), cycles |
| PE_RmsW | $B$41 | Wyllie-Rose, scatter about core (RMS), cycles |
| PE_RmsX | $B$42 | Core transform, scatter about core (RMS), cycles |
| PE_ZKT | $B$43 | Zone mean permeability, Timur, calibrated, mD |
| PE_ZKC | $B$44 | Zone mean permeability, Coates, calibrated, mD |
| PE_ZKW | $B$45 | Zone mean permeability, Wyllie-Rose, calibrated, mD |
| PE_ZKX | $B$46 | Zone mean permeability, Core transform, mD |
| PE_MethodWords | $B$47 | Permeability reported, by |
| PE_ZK | $B$48 | Zone mean permeability by that method, mD |
| PE_KH | $B$49 | Zone permeability-thickness kh, mD·ft |
| PE_Rms | $B$50 | That method's scatter about core, cycles |
| PE_DepthCheck | $B$51 | Depth match check verdict |
| PE_DepthCheckNote | $C$51 | Depth match check comment |
| PE_FitCheck | $B$52 | Core transform check verdict |
| PE_FitCheckNote | $C$52 | Core transform check comment |
| PE_CalCheck | $B$53 | Calibration check verdict |
| PE_CalCheckNote | $C$53 | Calibration check comment |
| PE_Results | $B$26:$B$53 | The sample spacing, the zone's porosity and Swirr, the core's porosity miss on depth, the core transform, each method's bias, calibration factor and scatter about core, the zone's permeability by each and by the one reported, its kh and three checks |
| PE_Core | $A$60:$J$74 | Each plug's core depth, porosity and permeability, its log depth on the shift, the log's porosity and Swirr there, and Timur, Coates, Wyllie-Rose and the core transform at it |
| PE_Curve | $A$79:$F$89 | Porosities across the plot, Swirr at each, and the calibrated Timur, Coates and Wyllie-Rose permeability and the core transform's |
| PE_Log | $A$94:$L$139 | Each depth's GR and bulk density, its Vsh, porosity and reservoir flag, Swirr, the calibrated Timur, Coates and Wyllie-Rose permeability, the core transform's and the one reported, 0 outside reservoir |

---

## Related Blueprints
- [Net Pay and Cutoffs over an Interval](/blueprint/po.pp.netpay.cutoffs.md)
- [Saturation-Height Function by Leverett J](/blueprint/po.pp.shf.fit.md)
- [Archie Water Saturation and Bulk Volume Water](/blueprint/po.pp.sw.archie.md)
- [Shaly-Sand Water Saturation](/blueprint/po.pp.sw.shaly.md)
- [Shale Volume from Gamma Ray](/blueprint/po.pp.vshale.gr.md)
- [Formation Water Resistivity](/blueprint/po.pp.rw.determination.md)

