---
cid: po.bp.pp.shf.fit
hub: pp
tags: [petrophysics, saturation-height, Leverett-J, J-function, capillary-pressure, free-water-level, FWL, height-above-FWL, transition-zone, power-law, rock-type, initial-water-saturation]
facets: { discipline: reservoir, property: saturation, method-type: empirical }
title: Saturation-Height Function by Leverett J
summary: "Fits a J-function saturation-height model to log samples and predicts Sw by height above the free-water level for three rock qualities."
slug: po.pp.shf.fit
type: worksheet
---

# Saturation-Height Function by Leverett J

## Description

What water saturation does each rock hold at each height above the free-water level, between wells and in a model where there is no log? You enter log samples above the FWL, Archie's parameters, the FWL, the fluid densities, interfacial tension and contact angle, a core poro-perm transform and three rock permeabilities. You read off a power-law Leverett-J function fitted to the log's own Sw, Sw against height above the FWL for each rock, and each rock's height to a chosen Sw.

**Parameters:**
- **Archie and picks**: `SH_a`, `SH_m`, `SH_n`, `SH_Rw` (ohm·m), `SH_GRcl`, `SH_GRsh` (API), `SH_RhoMa`, `SH_RhoF` (g/cm³), and the reservoir cutoffs `SH_VshCut` and `SH_PhiCut`
- **Sw reported**: the water saturation `SH_SwH` whose height above the FWL each rock reaches
- **Contact and fluids**: the free-water level `SH_FWL` (ft), the water and oil densities `SH_RhoW`, `SH_RhoO` (lb/ft³), and the oil-water interfacial tension `SH_Ift` (dyne/cm) and contact angle `SH_Theta` (°) at reservoir conditions
- **Core transform**: log10 k = `SH_PermA` + `SH_PermB` φ, from the Permeability from Logs sheet
- **Limits**: `SH_R2Min` and the largest scatter `SH_SwTol`
- **Rocks and samples**: the three rocks' permeability in the rock table, and each sample's depth, GR, bulk density and deep resistivity in the sample table

**How to use it:** The samples are synthetic. Paste reservoir samples above the FWL from your wells over the sample table: depth, GR, bulk density and deep resistivity. Set the FWL from pressure gradients, not from the deepest oil on the log. Take the permeability from your core transform or the Permeability from Logs sheet, and σ and θ from the lab at reservoir conditions. Fit one rock type at a time. The chart draws the three rocks' curves, Sw from 2 to 100 ft above the FWL, over the log's samples: read the height a rock reaches a given Sw from its curve, and use the function only inside the J the samples span.

**Method:**

- **Height to capillary pressure.** Each reservoir sample above the FWL has a height, h = FWL − depth, and that height is a reservoir capillary pressure. One psi of reservoir capillary pressure holds water up 144 / (ρw − ρo) ft (the capillary-pressure-to-height conversion at 1 psi, with the reservoir's σ cos θ in both places), so Pc = h / that.
- **Leverett J.** J = 0.2166 Pc / (σ cos θ) √(k/φ), with Pc in psi, σ in dyne/cm and k in mD. The sample's φ is the density porosity, its k = 10^(A + B φ) from the core transform, and its Sw is Archie's, at most 1.
- **The fit.** A sample is fitted when it is reservoir by Vsh and porosity, above the FWL and below Sw = 1. `LINEST` of ln Sw on ln J over those gives b, the slope, and ln a, the intercept, of the power law Sw = a J^b, with RSQ for R². The scatter is the RMS of the fitted Sw less the log's.
- **Rocks.** A rock's φ is (log10 k − A)/B, and its Sw at a height is a J^b at that height's J, at most 1. The J at the reported Sw is (Sw / a)^(1/b); the Leverett capillary pressure turns that J into the rock's Pc, and the capillary-pressure-to-height conversion turns the Pc into its height.
- **Checks.** The shape check fails when Sw does not fall as J rises, which means the samples are not one rock's transition or the FWL is wrong. The fit check warns when the R² is below the limit or the log Sw scatters about the function by more than the limit. The extrapolation check warns when the chosen Sw falls outside the J the samples span.

**Example:** The default case is this sheet's own copy of the petrophysics family's synthetic interval, one clean oil sand whose base is the free-water level at 5,050 ft, so the sand carries a real transition zone and every sample is the same rock type. The samples are that sand, 5,014 to 5,048 ft, every 2 ft: eighteen samples, a foot inside the sand's top and a foot above the FWL. The transition zone is generated from the Brooks–Corey (Corey) saturation–capillary-pressure relation written in the Leverett J, Se(J) = min(1, (Jd/J)^λ) and Sw = Swirr + (1 − Swirr)·Se, with the irreducible water saturation Swirr = 0.12, the pore-size distribution index λ = 1.0 and the entry Leverett J, Jd = 0.16; the sand reads 32 API and 2.21 g/cm³, and each sample's deep resistivity is Archie inverted from the zone's Sw, so the sheet reads the zone back out of the log. Archie's a, m and n are 1, 2 and 2 with Rw 0.05 ohm·m, as on the Archie Water Saturation and Bulk Volume Water sheet. The water is 65.5 lb/ft³ and the oil 50 lb/ft³, with 26 dyne/cm and 30° between them. The core transform is the Permeability from Logs sheet's, log10 k = −2.04 + 19.67 φ. The rocks are 1,000, 100 and 10 mD, and the height is reported at 20% Sw.

One psi holds water up 144 / 15.5 = 9.29 ft. All eighteen samples are fitted: one clean sand, one rock type. Their mean Sw is 29.0% and their J runs from 0.159, at 5,048 ft, 2 ft above the FWL, to 2.836 at 5,014 ft, 36 ft above it. The fit is Sw = 0.2832 J^−0.5859 at an R² of 0.977, with the log Sw within 3.6 saturation units of it. The transition zone is the sand's 34 ft above the FWL: Sw falls from 96.6% two feet above the water level to 16.6% at 5,030 ft, where it is near the irreducible 12% the shape flattens to, and the deep resistivity falls with it, from 26 ohm·m at the top of the sand to 0.76 ohm·m at the FWL. At 20% Sw, J is 1.81, inside the samples' range. Rock 1, 1,000 mD at 25.6% porosity, reaches it 28.0 ft above the FWL; Rock 2, 100 mD at 20.5%, at 79.3 ft, and rock 3, 10 mD at 15.5%, at 217.4 ft: the J function's reach, a poorer rock holding far more water at the same height. Rock 1 holds 9.5% water at 100 ft. Report the height to 90% Sw and its J of 0.139 lies below the samples', so the extrapolation check warns; 50% Sw, at J 0.38, still falls inside.

## Validity

A Leverett-J function holds within one rock type, where J brings plugs or beds of different k and φ onto one curve. Across rock types it does not, and each needs its own fit; this sheet's default case is one clean sand, so its fit is one rock's transition zone. The power law Sw = a J^b has no entry pressure and no irreducible water: it never reaches 100% at the FWL and falls without limit with height. Use it between the lowest and highest J the samples span. The log Sw is Archie's, which reads too wet in shaly beds, and the permeability is a core transform's estimate. Both carry into J. The fit is to log Sw in one well; core capillary pressure or more wells should confirm it. The sheet does not fit a Skelt-Harrison function. The samples are synthetic. Field units.

Named alternatives: above the samples' J, a form with Swirr (Sw = Swirr + a J^b) or Thomeer's is safer; Skelt-Harrison's function, fitted directly to log and core data (Harrison and Jing, 2001); a function fitted to core capillary pressure.

## References

- Leverett, M.C. (1941). Capillary Behavior in Porous Solids. *Transactions of the AIME* 142(1), 152–169, SPE-941152-G.
- Brooks, R.H. and Core, A.T. (1966). *The Application of the Capillary Pressure Approach to Interpreting Petroleum Production Data*. Dallas: Society of Petroleum Engineers of AIME.
- Harrison, B. and Jing, X.D. (2001). Saturation Height Methods and Their Impact on Volumetric Hydrocarbon in Place Estimates. SPE-71326-MS.
- Cuddy, S., Allinson, G. and Steele, R. (1993). A Simple, Convincing Model for Calculating Water Saturations in Southern North Sea Gas Fields. SPWLA 34th Annual Logging Symposium, paper H.
- Amyx, J.W., Bass, D.M. and Whiting, R.L. (1960). *Petroleum Reservoir Engineering: Physical Properties*. McGraw-Hill, ch. 2 (the J-function).

## Functions used

`PO.PP.Vsh.GammaRayIndex`, `PO.PP.Porosity.FromDensity`, `PO.PP.Sw.Archie`, `PO.SCAL.PcToHeight`, `PO.SCAL.Leverett.J`, `PO.SCAL.Leverett.Pc`

## Spreadsheet: ShfFit

|    | A                                                                                                                                                                                                                        | B                                                                                                                                                | C                                                                                                                                                                                                                                                                                                                            | D                                                                                 | E                                                           | F                                                            | G                                                     | H                                                            | I                    | J                           | K               | L                                                | M        | N         | O                      |
|----|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------|-------------------------------------------------------------|--------------------------------------------------------------|-------------------------------------------------------|--------------------------------------------------------------|----------------------|-----------------------------|-----------------|--------------------------------------------------|----------|-----------|------------------------|
| 1  | Saturation-Height Function by Leverett J                                                                                                                                                                                 |                                                                                                                                                  | Petroleum Office                                                                                                                                                                                                                                                                                                             |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 2  | Blue cells on yellow are inputs. Set Archie's parameters, the picks, the FWL, the fluids, the core transform and three rocks; paste your own samples above the FWL over the table below.                                 |                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 3  | Archie's Parameters, the Picks, the FWL, the Fluids, the Core Transform and the Limits                                                                                                                                   |                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 4  | Tortuosity factor a                                                                                                                                                                                                      | 1                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 5  | Cementation exponent m                                                                                                                                                                                                   | 2                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 6  | Saturation exponent n                                                                                                                                                                                                    | 2                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 7  | Formation-water resistivity at formation temperature                                                                                                                                                                     | 0.05                                                                                                                                             | ohm·m                                                                                                                                                                                                                                                                                                                        |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 8  | Clean-sand gamma ray (Vsh = 0)                                                                                                                                                                                           | 30                                                                                                                                               | API                                                                                                                                                                                                                                                                                                                          |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 9  | Shale gamma ray (Vsh = 1)                                                                                                                                                                                                | 115                                                                                                                                              | API                                                                                                                                                                                                                                                                                                                          |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 10 | Matrix density (sandstone)                                                                                                                                                                                               | 2.65                                                                                                                                             | g/cm³                                                                                                                                                                                                                                                                                                                        |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 11 | Fluid density (fresh mud filtrate)                                                                                                                                                                                       | 1                                                                                                                                                | g/cm³                                                                                                                                                                                                                                                                                                                        |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 12 | Shale-volume cutoff for reservoir                                                                                                                                                                                        | 0.4                                                                                                                                              | v/v                                                                                                                                                                                                                                                                                                                          |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 13 | Porosity cutoff for reservoir                                                                                                                                                                                            | 0.1                                                                                                                                              | %                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 14 | Water saturation whose height above the FWL is reported                                                                                                                                                                  | 0.2                                                                                                                                              | %                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 15 | Free-water level (the base of the clean oil sand)                                                                                                                                                                        | 5050                                                                                                                                             | ft                                                                                                                                                                                                                                                                                                                           |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 16 | Formation water density                                                                                                                                                                                                  | 65.5                                                                                                                                             | lb/ft³                                                                                                                                                                                                                                                                                                                       |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 17 | Oil density at reservoir conditions                                                                                                                                                                                      | 50                                                                                                                                               | lb/ft³                                                                                                                                                                                                                                                                                                                       |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 18 | Oil-water interfacial tension at reservoir conditions                                                                                                                                                                    | 26                                                                                                                                               | dyne/cm                                                                                                                                                                                                                                                                                                                      |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 19 | Oil-water contact angle at reservoir conditions                                                                                                                                                                          | 30                                                                                                                                               | °                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 20 | Core transform log10 k = A + B φ, A (the permeability sheet's)                                                                                                                                                           | -2.04                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 21 | Core transform, B                                                                                                                                                                                                        | 19.67                                                                                                                                            | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 22 | Lowest R² of the fit                                                                                                                                                                                                     | 0.8                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 23 | Largest scatter of log Sw about the fitted function (RMS)                                                                                                                                                                | 0.05                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 28 | The Fit, Its Scatter, and Each Rock's Height to an Sw                                                                                                                                                                    |                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 29 | Height one psi of reservoir capillary pressure holds water up                                                                                                                                                            | =PO.SCAL.PcToHeight(1,SH_Ift,SH_Theta,SH_Ift,SH_Theta,SH_RhoW,SH_RhoO)                                                                           | ft/psi                                                                                                                                                                                                                                                                                                                       |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 30 | Samples fitted (reservoir, above the FWL, hydrocarbon-bearing)                                                                                                                                                           | =SUM($H$75:$H$92)                                                                                                                                | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 31 | Fitted samples' mean Sw from the log (Archie)                                                                                                                                                                            | =SUMPRODUCT($H$75:$H$92,$G$75:$G$92)/SH_NFit                                                                                                     | %                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 32 | Fitted samples' J, smallest                                                                                                                                                                                              | =MINIFS($L$75:$L$92,$H$75:$H$92,1)                                                                                                               | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 33 | Fitted samples' J, largest                                                                                                                                                                                               | =MAXIFS($L$75:$L$92,$H$75:$H$92,1)                                                                                                               | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 34 | Sw = a J^b, the exponent b (LINEST slope of ln Sw on ln J)                                                                                                                                                               | =INDEX(LINEST(FILTER($N$75:$N$92,$H$75:$H$92=1),FILTER($M$75:$M$92,$H$75:$H$92=1)),1)                                                            | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 35 | Sw = a J^b, the coefficient a (Sw at J = 1)                                                                                                                                                                              | =EXP(INDEX(LINEST(FILTER($N$75:$N$92,$H$75:$H$92=1),FILTER($M$75:$M$92,$H$75:$H$92=1)),2))                                                       | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 36 | R² of the fit                                                                                                                                                                                                            | =RSQ(FILTER($N$75:$N$92,$H$75:$H$92=1),FILTER($M$75:$M$92,$H$75:$H$92=1))                                                                        | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 37 | Scatter of log Sw about the function (RMS)                                                                                                                                                                               | =SQRT(SUMPRODUCT($H$75:$H$92,($O$75:$O$92-$G$75:$G$92)^2)/SH_NFit)                                                                               | %                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 38 | J at the reported Sw, (Sw / a)^(1/b)                                                                                                                                                                                     | =(SH_SwH/SH_aJ)^(1/SH_b)                                                                                                                         | —                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 39 | Rock 1, height above the FWL where Sw falls to the reported Sw                                                                                                                                                           | =LET(LabPc_psi,PO.SCAL.Leverett.Pc(SH_JH,B52,C52,SH_Ift,SH_Theta),PO.SCAL.PcToHeight(LabPc_psi,SH_Ift,SH_Theta,SH_Ift,SH_Theta,SH_RhoW,SH_RhoO)) | ft                                                                                                                                                                                                                                                                                                                           |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 40 | Rock 2, height above the FWL where Sw falls to the reported Sw                                                                                                                                                           | =LET(LabPc_psi,PO.SCAL.Leverett.Pc(SH_JH,B53,C53,SH_Ift,SH_Theta),PO.SCAL.PcToHeight(LabPc_psi,SH_Ift,SH_Theta,SH_Ift,SH_Theta,SH_RhoW,SH_RhoO)) | ft                                                                                                                                                                                                                                                                                                                           |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 41 | Rock 3, height above the FWL where Sw falls to the reported Sw                                                                                                                                                           | =LET(LabPc_psi,PO.SCAL.Leverett.Pc(SH_JH,B54,C54,SH_Ift,SH_Theta),PO.SCAL.PcToHeight(LabPc_psi,SH_Ift,SH_Theta,SH_Ift,SH_Theta,SH_RhoW,SH_RhoO)) | ft                                                                                                                                                                                                                                                                                                                           |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 42 | Rock 1, Sw at 100 ft above the FWL                                                                                                                                                                                       | =B70                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                            |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 43 | Function shape check                                                                                                                                                                                                     | =IF(SH_NFit<=2,"FAIL",IF(SH_b<0,"PASS","FAIL"))                                                                                                  | =IF(SH_NFit<=2,"the fit needs three samples or more above the FWL",IF(SH_b<0,"Sw falls as J rises, b = "&FIXED(SH_b,2)&", over J from "&FIXED(SH_JMin,2)&" to "&FIXED(SH_JMax,2)&"","Sw rises with J, b = "&FIXED(SH_b,2)&": the samples are not one rock's transition, or the FWL is wrong"))                               |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 44 | Fit check                                                                                                                                                                                                                | =IF(AND(SH_R2>=SH_R2Min,SH_Rms<=SH_SwTol),"PASS","WARN")                                                                                         | =IF(AND(SH_R2>=SH_R2Min,SH_Rms<=SH_SwTol),"R² "&FIXED(SH_R2,2)&", and log Sw lies within "&FIXED(SH_Rms*100,1)&" saturation units of the function (RMS)","R² "&FIXED(SH_R2,2)&" and "&FIXED(SH_Rms*100,1)&" saturation units RMS: one J curve does not hold these samples; split them by rock type, or check k and the FWL") |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 45 | Extrapolation check                                                                                                                                                                                                      | =IF(AND(SH_JH>=SH_JMin,SH_JH<=SH_JMax),"PASS","WARN")                                                                                            | =IF(AND(SH_JH>=SH_JMin,SH_JH<=SH_JMax),"an Sw of "&FIXED(SH_SwH*100,0)&"% falls at J = "&FIXED(SH_JH,2)&", inside the fitted samples' J","an Sw of "&FIXED(SH_SwH*100,0)&"% falls at J = "&FIXED(SH_JH,2)&", outside the samples' "&FIXED(SH_JMin,2)&" to "&FIXED(SH_JMax,2)&": the heights to it are extrapolated")         |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 47 | How to use it: paste the depth, GR, bulk density and deep resistivity of reservoir samples above the FWL over the table, set the FWL from pressure gradients, take k from your core transform, and σ and θ from the lab. |                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 48 | The samples are synthetic: this sheet's own copy of the family's interval, one clean oil sand down to the FWL, so every sample is the same rock type and the fit is one rock's transition zone.                          |                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 50 | Three Rock Qualities (porosity from the core transform)                                                                                                                                                                  |                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 51 | Rock                                                                                                                                                                                                                     | k (mD)                                                                                                                                           | φ (%)                                                                                                                                                                                                                                                                                                                        |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 52 | Rock 1                                                                                                                                                                                                                   | 1000                                                                                                                                             | =(LOG10(B52)-SH_PermA)/SH_PermB                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 53 | Rock 2                                                                                                                                                                                                                   | 100                                                                                                                                              | =(LOG10(B53)-SH_PermA)/SH_PermB                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 54 | Rock 3                                                                                                                                                                                                                   | 10                                                                                                                                               | =(LOG10(B54)-SH_PermA)/SH_PermB                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 57 | Sw against Height above the FWL by Rock (Sw = a J^b, at most 1)                                                                                                                                                          |                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 58 | Height above FWL (ft)                                                                                                                                                                                                    | Sw, Rock 1 (%)                                                                                                                                   | Sw, Rock 2 (%)                                                                                                                                                                                                                                                                                                               | Sw, Rock 3 (%)                                                                    |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 59 | 2                                                                                                                                                                                                                        | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A59/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A59/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A59/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 60 | 4                                                                                                                                                                                                                        | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A60/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A60/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A60/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 61 | 6                                                                                                                                                                                                                        | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A61/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A61/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A61/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 62 | 8                                                                                                                                                                                                                        | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A62/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A62/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A62/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 63 | 10                                                                                                                                                                                                                       | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A63/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A63/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A63/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 64 | 15                                                                                                                                                                                                                       | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A64/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A64/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A64/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 65 | 20                                                                                                                                                                                                                       | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A65/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A65/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A65/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 66 | 30                                                                                                                                                                                                                       | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A66/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A66/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A66/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 67 | 40                                                                                                                                                                                                                       | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A67/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A67/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A67/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 68 | 60                                                                                                                                                                                                                       | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A68/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A68/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A68/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 69 | 80                                                                                                                                                                                                                       | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A69/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A69/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A69/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 70 | 100                                                                                                                                                                                                                      | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A70/SH_HPerPsi,$B$52,$C$52,SH_Ift,SH_Theta)^SH_b)                                                                | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A70/SH_HPerPsi,$B$53,$C$53,SH_Ift,SH_Theta)^SH_b)                                                                                                                                                                                                                                            | =MIN(1,SH_aJ*PO.SCAL.Leverett.J(A70/SH_HPerPsi,$B$54,$C$54,SH_Ift,SH_Theta)^SH_b) |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 73 | The Clean Oil Sand's Transition Zone above the FWL (every 2 ft)                                                                                                                                                          |                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                              |                                                                                   |                                                             |                                                              |                                                       |                                                              |                      |                             |                 |                                                  |          |           |                        |
| 74 | Depth (ft)                                                                                                                                                                                                               | GR (API)                                                                                                                                         | RHOB (g/cm³)                                                                                                                                                                                                                                                                                                                 | Rt (ohm·m)                                                                        | Vsh (v/v)                                                   | φ (%)                                                        | Sw, Archie (%)                                        | Fitted                                                       | Height (ft)          | k (mD)                      | Pc (psi)        | J (—)                                            | ln J (—) | ln Sw (—) | Sw, fitted (%)         |
| 75 | 5014                                                                                                                                                                                                                     | 28.9                                                                                                                                             | 2.217                                                                                                                                                                                                                                                                                                                        | 26.1                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B75,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C75,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F75,SH_Rw,D75)) | =IF(AND(E75<=SH_VshCut,F75>=SH_PhiCut,A75<SH_FWL,G75<1),1,0) | =MAX(0.1,SH_FWL-A75) | =10^(SH_PermA+SH_PermB*F75) | =I75/SH_HPerPsi | =PO.SCAL.Leverett.J(K75,J75,F75,SH_Ift,SH_Theta) | =LN(L75) | =LN(G75)  | =MIN(1,SH_aJ*L75^SH_b) |
| 76 | 5016                                                                                                                                                                                                                     | 35.5                                                                                                                                             | 2.207                                                                                                                                                                                                                                                                                                                        | 23.7                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B76,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C76,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F76,SH_Rw,D76)) | =IF(AND(E76<=SH_VshCut,F76>=SH_PhiCut,A76<SH_FWL,G76<1),1,0) | =MAX(0.1,SH_FWL-A76) | =10^(SH_PermA+SH_PermB*F76) | =I76/SH_HPerPsi | =PO.SCAL.Leverett.J(K76,J76,F76,SH_Ift,SH_Theta) | =LN(L76) | =LN(G76)  | =MIN(1,SH_aJ*L76^SH_b) |
| 77 | 5018                                                                                                                                                                                                                     | 29.4                                                                                                                                             | 2.212                                                                                                                                                                                                                                                                                                                        | 24.2                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B77,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C77,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F77,SH_Rw,D77)) | =IF(AND(E77<=SH_VshCut,F77>=SH_PhiCut,A77<SH_FWL,G77<1),1,0) | =MAX(0.1,SH_FWL-A77) | =10^(SH_PermA+SH_PermB*F77) | =I77/SH_HPerPsi | =PO.SCAL.Leverett.J(K77,J77,F77,SH_Ift,SH_Theta) | =LN(L77) | =LN(G77)  | =MIN(1,SH_aJ*L77^SH_b) |
| 78 | 5020                                                                                                                                                                                                                     | 33.4                                                                                                                                             | 2.21                                                                                                                                                                                                                                                                                                                         | 20.6                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B78,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C78,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F78,SH_Rw,D78)) | =IF(AND(E78<=SH_VshCut,F78>=SH_PhiCut,A78<SH_FWL,G78<1),1,0) | =MAX(0.1,SH_FWL-A78) | =10^(SH_PermA+SH_PermB*F78) | =I78/SH_HPerPsi | =PO.SCAL.Leverett.J(K78,J78,F78,SH_Ift,SH_Theta) | =LN(L78) | =LN(G78)  | =MIN(1,SH_aJ*L78^SH_b) |
| 79 | 5022                                                                                                                                                                                                                     | 31.1                                                                                                                                             | 2.214                                                                                                                                                                                                                                                                                                                        | 22.6                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B79,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C79,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F79,SH_Rw,D79)) | =IF(AND(E79<=SH_VshCut,F79>=SH_PhiCut,A79<SH_FWL,G79<1),1,0) | =MAX(0.1,SH_FWL-A79) | =10^(SH_PermA+SH_PermB*F79) | =I79/SH_HPerPsi | =PO.SCAL.Leverett.J(K79,J79,F79,SH_Ift,SH_Theta) | =LN(L79) | =LN(G79)  | =MIN(1,SH_aJ*L79^SH_b) |
| 80 | 5024                                                                                                                                                                                                                     | 35                                                                                                                                               | 2.209                                                                                                                                                                                                                                                                                                                        | 19.3                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B80,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C80,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F80,SH_Rw,D80)) | =IF(AND(E80<=SH_VshCut,F80>=SH_PhiCut,A80<SH_FWL,G80<1),1,0) | =MAX(0.1,SH_FWL-A80) | =10^(SH_PermA+SH_PermB*F80) | =I80/SH_HPerPsi | =PO.SCAL.Leverett.J(K80,J80,F80,SH_Ift,SH_Theta) | =LN(L80) | =LN(G80)  | =MIN(1,SH_aJ*L80^SH_b) |
| 81 | 5026                                                                                                                                                                                                                     | 29.8                                                                                                                                             | 2.21                                                                                                                                                                                                                                                                                                                         | 18.6                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B81,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C81,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F81,SH_Rw,D81)) | =IF(AND(E81<=SH_VshCut,F81>=SH_PhiCut,A81<SH_FWL,G81<1),1,0) | =MAX(0.1,SH_FWL-A81) | =10^(SH_PermA+SH_PermB*F81) | =I81/SH_HPerPsi | =PO.SCAL.Leverett.J(K81,J81,F81,SH_Ift,SH_Theta) | =LN(L81) | =LN(G81)  | =MIN(1,SH_aJ*L81^SH_b) |
| 82 | 5028                                                                                                                                                                                                                     | 33.9                                                                                                                                             | 2.215                                                                                                                                                                                                                                                                                                                        | 17.2                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B82,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C82,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F82,SH_Rw,D82)) | =IF(AND(E82<=SH_VshCut,F82>=SH_PhiCut,A82<SH_FWL,G82<1),1,0) | =MAX(0.1,SH_FWL-A82) | =10^(SH_PermA+SH_PermB*F82) | =I82/SH_HPerPsi | =PO.SCAL.Leverett.J(K82,J82,F82,SH_Ift,SH_Theta) | =LN(L82) | =LN(G82)  | =MIN(1,SH_aJ*L82^SH_b) |
| 83 | 5030                                                                                                                                                                                                                     | 33.5                                                                                                                                             | 2.206                                                                                                                                                                                                                                                                                                                        | 16.6                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B83,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C83,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F83,SH_Rw,D83)) | =IF(AND(E83<=SH_VshCut,F83>=SH_PhiCut,A83<SH_FWL,G83<1),1,0) | =MAX(0.1,SH_FWL-A83) | =10^(SH_PermA+SH_PermB*F83) | =I83/SH_HPerPsi | =PO.SCAL.Leverett.J(K83,J83,F83,SH_Ift,SH_Theta) | =LN(L83) | =LN(G83)  | =MIN(1,SH_aJ*L83^SH_b) |
| 84 | 5032                                                                                                                                                                                                                     | 31.2                                                                                                                                             | 2.213                                                                                                                                                                                                                                                                                                                        | 14.2                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B84,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C84,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F84,SH_Rw,D84)) | =IF(AND(E84<=SH_VshCut,F84>=SH_PhiCut,A84<SH_FWL,G84<1),1,0) | =MAX(0.1,SH_FWL-A84) | =10^(SH_PermA+SH_PermB*F84) | =I84/SH_HPerPsi | =PO.SCAL.Leverett.J(K84,J84,F84,SH_Ift,SH_Theta) | =LN(L84) | =LN(G84)  | =MIN(1,SH_aJ*L84^SH_b) |
| 85 | 5034                                                                                                                                                                                                                     | 33.2                                                                                                                                             | 2.209                                                                                                                                                                                                                                                                                                                        | 12.8                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B85,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C85,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F85,SH_Rw,D85)) | =IF(AND(E85<=SH_VshCut,F85>=SH_PhiCut,A85<SH_FWL,G85<1),1,0) | =MAX(0.1,SH_FWL-A85) | =10^(SH_PermA+SH_PermB*F85) | =I85/SH_HPerPsi | =PO.SCAL.Leverett.J(K85,J85,F85,SH_Ift,SH_Theta) | =LN(L85) | =LN(G85)  | =MIN(1,SH_aJ*L85^SH_b) |
| 86 | 5036                                                                                                                                                                                                                     | 32.3                                                                                                                                             | 2.214                                                                                                                                                                                                                                                                                                                        | 12                                                                                | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B86,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C86,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F86,SH_Rw,D86)) | =IF(AND(E86<=SH_VshCut,F86>=SH_PhiCut,A86<SH_FWL,G86<1),1,0) | =MAX(0.1,SH_FWL-A86) | =10^(SH_PermA+SH_PermB*F86) | =I86/SH_HPerPsi | =PO.SCAL.Leverett.J(K86,J86,F86,SH_Ift,SH_Theta) | =LN(L86) | =LN(G86)  | =MIN(1,SH_aJ*L86^SH_b) |
| 87 | 5038                                                                                                                                                                                                                     | 33.8                                                                                                                                             | 2.204                                                                                                                                                                                                                                                                                                                        | 9.48                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B87,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C87,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F87,SH_Rw,D87)) | =IF(AND(E87<=SH_VshCut,F87>=SH_PhiCut,A87<SH_FWL,G87<1),1,0) | =MAX(0.1,SH_FWL-A87) | =10^(SH_PermA+SH_PermB*F87) | =I87/SH_HPerPsi | =PO.SCAL.Leverett.J(K87,J87,F87,SH_Ift,SH_Theta) | =LN(L87) | =LN(G87)  | =MIN(1,SH_aJ*L87^SH_b) |
| 88 | 5040                                                                                                                                                                                                                     | 29                                                                                                                                               | 2.216                                                                                                                                                                                                                                                                                                                        | 7.89                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B88,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C88,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F88,SH_Rw,D88)) | =IF(AND(E88<=SH_VshCut,F88>=SH_PhiCut,A88<SH_FWL,G88<1),1,0) | =MAX(0.1,SH_FWL-A88) | =10^(SH_PermA+SH_PermB*F88) | =I88/SH_HPerPsi | =PO.SCAL.Leverett.J(K88,J88,F88,SH_Ift,SH_Theta) | =LN(L88) | =LN(G88)  | =MIN(1,SH_aJ*L88^SH_b) |
| 89 | 5042                                                                                                                                                                                                                     | 35.7                                                                                                                                             | 2.207                                                                                                                                                                                                                                                                                                                        | 6.08                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B89,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C89,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F89,SH_Rw,D89)) | =IF(AND(E89<=SH_VshCut,F89>=SH_PhiCut,A89<SH_FWL,G89<1),1,0) | =MAX(0.1,SH_FWL-A89) | =10^(SH_PermA+SH_PermB*F89) | =I89/SH_HPerPsi | =PO.SCAL.Leverett.J(K89,J89,F89,SH_Ift,SH_Theta) | =LN(L89) | =LN(G89)  | =MIN(1,SH_aJ*L89^SH_b) |
| 90 | 5044                                                                                                                                                                                                                     | 29.6                                                                                                                                             | 2.209                                                                                                                                                                                                                                                                                                                        | 4.33                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B90,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C90,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F90,SH_Rw,D90)) | =IF(AND(E90<=SH_VshCut,F90>=SH_PhiCut,A90<SH_FWL,G90<1),1,0) | =MAX(0.1,SH_FWL-A90) | =10^(SH_PermA+SH_PermB*F90) | =I90/SH_HPerPsi | =PO.SCAL.Leverett.J(K90,J90,F90,SH_Ift,SH_Theta) | =LN(L90) | =LN(G90)  | =MIN(1,SH_aJ*L90^SH_b) |
| 91 | 5046                                                                                                                                                                                                                     | 32.7                                                                                                                                             | 2.208                                                                                                                                                                                                                                                                                                                        | 2.13                                                                              | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B91,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C91,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F91,SH_Rw,D91)) | =IF(AND(E91<=SH_VshCut,F91>=SH_PhiCut,A91<SH_FWL,G91<1),1,0) | =MAX(0.1,SH_FWL-A91) | =10^(SH_PermA+SH_PermB*F91) | =I91/SH_HPerPsi | =PO.SCAL.Leverett.J(K91,J91,F91,SH_Ift,SH_Theta) | =LN(L91) | =LN(G91)  | =MIN(1,SH_aJ*L91^SH_b) |
| 92 | 5048                                                                                                                                                                                                                     | 30.3                                                                                                                                             | 2.211                                                                                                                                                                                                                                                                                                                        | 0.756                                                                             | =MAX(0,MIN(1,PO.PP.Vsh.GammaRayIndex(B92,SH_GRcl,SH_GRsh))) | =MAX(0.001,PO.PP.Porosity.FromDensity(SH_RhoMa,C92,SH_RhoF)) | =MIN(1,PO.PP.Sw.Archie(SH_a,SH_m,SH_n,F92,SH_Rw,D92)) | =IF(AND(E92<=SH_VshCut,F92>=SH_PhiCut,A92<SH_FWL,G92<1),1,0) | =MAX(0.1,SH_FWL-A92) | =10^(SH_PermA+SH_PermB*F92) | =I92/SH_HPerPsi | =PO.SCAL.Leverett.J(K92,J92,F92,SH_Ift,SH_Theta) | =LN(L92) | =LN(G92)  | =MIN(1,SH_aJ*L92^SH_b) |

## 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.Sw.Archie | =LAMBDA(a, m, n, Phi, Rw, Rt, ((a/Phi^m)*(Rw/Rt))^(1/n)) | Water saturation from the general Archie equation, Sw = ((a/phi^m)*(Rw/Rt))^(1/n). |
| PO.SCAL.PcToHeight | =LAMBDA(Pc, ift_lab, theta_lab, ift_res, theta_res, rho_w, rho_o, LET(lab_term, ift_lab*COS(RADIANS(theta_lab)), res_term, ift_res*COS(RADIANS(theta_res)), drho, rho_w-rho_o, IF(OR(drho<=0, lab_term<=0, res_term<0), NA(), 144*Pc*res_term/lab_term/drho))) | Height above the free water level of a laboratory capillary pressure: Pc_res = Pc·(σcosθ)res/(σcosθ)lab, h = 144·Pc_res/(ρw − ρo); #N/A when ρw ≤ ρo, [ft]. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| SH_a | $B$4 | Tortuosity factor a |
| SH_m | $B$5 | Cementation exponent m |
| SH_n | $B$6 | Saturation exponent n |
| SH_Rw | $B$7 | Formation-water resistivity at formation temperature, ohm·m |
| SH_GRcl | $B$8 | Clean-sand gamma ray (Vsh = 0), API |
| SH_GRsh | $B$9 | Shale gamma ray (Vsh = 1), API |
| SH_RhoMa | $B$10 | Matrix density (sandstone), g/cm³ |
| SH_RhoF | $B$11 | Fluid density (fresh mud filtrate), g/cm³ |
| SH_VshCut | $B$12 | Shale-volume cutoff for reservoir, v/v |
| SH_PhiCut | $B$13 | Porosity cutoff for reservoir, % |
| SH_SwH | $B$14 | Water saturation whose height above the FWL is reported, % |
| SH_FWL | $B$15 | Free-water level (the base of the clean oil sand), ft |
| SH_RhoW | $B$16 | Formation water density, lb/ft³ |
| SH_RhoO | $B$17 | Oil density at reservoir conditions, lb/ft³ |
| SH_Ift | $B$18 | Oil-water interfacial tension at reservoir conditions, dyne/cm |
| SH_Theta | $B$19 | Oil-water contact angle at reservoir conditions, ° |
| SH_PermA | $B$20 | Core transform log10 k = A + B φ, A (the permeability sheet's) |
| SH_PermB | $B$21 | Core transform, B |
| SH_R2Min | $B$22 | Lowest R² of the fit |
| SH_SwTol | $B$23 | Largest scatter of log Sw about the fitted function (RMS), % |
| SH_Inputs | $B$4:$B$23 | Archie's a, m, n and Rw, the gamma-ray picks, the matrix and fluid densities, the cutoffs, the Sw reported, the free-water level, the water and oil densities, the oil-water interfacial tension and contact angle, the core transform and the check limits |
| SH_HPerPsi | $B$29 | Height one psi of reservoir capillary pressure holds water up, ft/psi |
| SH_NFit | $B$30 | Samples fitted (reservoir, above the FWL, hydrocarbon-bearing) |
| SH_MeanSw | $B$31 | Fitted samples' mean Sw from the log (Archie), % |
| SH_JMin | $B$32 | Fitted samples' J, smallest |
| SH_JMax | $B$33 | Fitted samples' J, largest |
| SH_b | $B$34 | Sw = a J^b, the exponent b (LINEST slope of ln Sw on ln J) |
| SH_aJ | $B$35 | Sw = a J^b, the coefficient a (Sw at J = 1) |
| SH_R2 | $B$36 | R² of the fit |
| SH_Rms | $B$37 | Scatter of log Sw about the function (RMS), % |
| SH_JH | $B$38 | J at the reported Sw, (Sw / a)^(1/b) |
| SH_H1 | $B$39 | Rock 1, height above the FWL where Sw falls to the reported Sw, ft |
| SH_H2 | $B$40 | Rock 2, height above the FWL where Sw falls to the reported Sw, ft |
| SH_H3 | $B$41 | Rock 3, height above the FWL where Sw falls to the reported Sw, ft |
| SH_Sw100 | $B$42 | Rock 1, Sw at 100 ft above the FWL, % |
| SH_ShapeCheck | $B$43 | Function shape check verdict |
| SH_ShapeCheckNote | $C$43 | Function shape check comment |
| SH_FitCheck | $B$44 | Fit check verdict |
| SH_FitCheckNote | $C$44 | Fit check comment |
| SH_RangeCheck | $B$45 | Extrapolation check verdict |
| SH_RangeCheckNote | $C$45 | Extrapolation check comment |
| SH_Results | $B$29:$B$45 | The height per psi, the samples fitted, their mean Sw and J range, the power law's b, a and R², its scatter, J at the reported Sw and each rock's height to it, rock 1's Sw at 100 ft, and three checks |
| SH_Rocks | $A$52:$C$54 | Each rock's name, permeability and the porosity the core transform gives it |
| SH_Curve | $A$59:$D$70 | Heights above the free-water level and the fitted Sw of each rock at them |
| SH_Samples | $A$75:$O$92 | Each sample's depth, GR, bulk density and deep resistivity, its Vsh, porosity, Archie Sw and fit flag, its height above the FWL, k, reservoir Pc and J, ln J, ln Sw and the fitted Sw |

---

## Related Blueprints
- [Net Pay and Cutoffs over an Interval](/blueprint/po.pp.netpay.cutoffs.md)
- [Shaly-Sand Water Saturation](/blueprint/po.pp.sw.shaly.md)
- [Archie Water Saturation and Bulk Volume Water](/blueprint/po.pp.sw.archie.md)
- [Permeability from Logs](/blueprint/po.pp.permeability.estimate.md)
- [Shale Volume from Gamma Ray](/blueprint/po.pp.vshale.gr.md)
- [Formation Water Resistivity](/blueprint/po.pp.rw.determination.md)

