---
cid: po.bp.pp.rw.determination
hub: pp
tags: [petrophysics, water-resistivity, Rw, spontaneous-potential, SP, static-SP, Rwa, Pickett-plot, salinity, Arps, temperature-correction, mud-filtrate, quick-look]
facets: { discipline: reservoir, property: resistivity, method-type: empirical }
title: Formation Water Resistivity
summary: "Determines formation water resistivity four ways, from SP, apparent Rw, a Pickett plot and salinity, and cross-checks the results."
slug: po.pp.rw.determination
type: worksheet
---

# Formation Water Resistivity

## Description

What is the formation water resistivity Rw, on which every saturation on the log depends? You enter a log of SP, bulk density and deep resistivity, a clean water sand on it, the formation and reference temperatures, the mud filtrate's Rmf, the shale's SP baseline and a water sample's salinity. You read off Rw four ways, from the static SP, the minimum apparent water resistivity, a Pickett plot and the salinity, how far the four agree, and the one reported at formation and reference temperature.

**Parameters:**
- **Archie**: the tortuosity factor `RW_a`, the cementation exponent `RW_m`, and the saturation exponent `RW_n` for the Pickett plot's lines
- **Temperatures**: the formation temperature `RW_Tf` and the reference temperature `RW_Tref` of the Rmf reading and the salinity chart (°F)
- **Filtrate and SP**: `RW_Rmf` (ohm·m at the reference temperature), the equivalent-resistivity factor `RW_RmfeK`, and the shale baseline `RW_SPsh` (mV)
- **Matrix and fluid**: `RW_RhoMa`, `RW_RhoF` (g/cm³)
- **Water sand**: its top `RW_WTop` and base `RW_WBase` (ft)
- **Water sample**: its NaCl-equivalent salinity `RW_Ppm` (ppm)
- **Reported and limits**: the method `RW_Method` (1 SP, 2 minimum Rwa, 3 Pickett, 4 salinity), the agreement limit `RW_Tol`, the porosity span `RW_SpanMin` needed to fit m, the m tolerance `RW_MTol` and the largest scatter `RW_ScatMax` (decades)
- **Log**: each depth's SP, bulk density and deep resistivity in the log table

**How to use it:** The log is synthetic. Paste your depth, SP, bulk density and deep resistivity over the log table, environmentally corrected. Pick the shale baseline on a thick shale and the water sand where it is clean, thick and plainly wet, away from its shoulders. Take Rmf and its temperature from the mud report, and the formation temperature from a corrected bottom-hole temperature. A produced or tested water sample is the best Rw there is; correct its resistivity, or its salinity, to formation temperature. The chart is the Pickett plot: every log sample, with the lines of 100%, 50% and 25% water saturation that the Pickett Rw draws.

**Method:**

- **Static SP.** The water sand's mean SP less the shale baseline is the static SP. The mud filtrate's resistivity is carried from the mud report's temperature to formation temperature by Arps: R2 = R1 (T1 + 6.77) / (T2 + 6.77), °F. Rmf at formation temperature times 0.85 is Rmfe, the equivalent filtrate resistivity, for an Rmf above about 0.1 ohm·m at 75 °F. With K = 61 + 0.133 T, the SP equation gives Rweq = Rmfe 10^(SSP/K), taken as Rw for NaCl water.
- **Minimum Rwa.** The smallest apparent water resistivity Rwa = Rt φ^m / a over the water sand, with φ the density porosity (ρma − ρb)/(ρma − ρf).
- **Pickett plot.** A wet sand obeys log Rt = log(a Rw) − m log φ. `LINEST` of log Rt on log φ over the water sand gives the free slope, −m, and its R². Rw at the input m is 10 to the mean log Rwa, the least-squares line of slope −m through the water points, and the scatter is the standard deviation of log Rwa. The plot's lines are log Rt = log(a Rw / φ^m / Sw^n) at Sw = 1, 0.5 and 0.25.
- **Salinity.** The salinity chart's fit gives Rw at 75 °F, Rw = 0.0123 + 3647.5 / ppm^0.955, and Arps carries it to formation temperature.
- **Reported Rw.** One of the four is reported, at formation temperature and at the reference temperature. The spread is the largest less the smallest of the four over their mean.
- **Checks.** The agreement check warns when the spread is more than the limit. The Pickett check judges the free fit's m against the input m when the water sand spans enough porosity to fit it; when it does not, it judges the scatter of the water points about the line instead. The SP check warns when the SP is reversed or flat, which means the water is no saltier than the filtrate and the SP method does not hold.

**Example:** The default case is the Well-Log Display workbook's synthetic interval, 5,000 to 5,120 ft, every 2 ft. The water sand is its clean water sand, 5,077 to 5,100 ft, taken from 5,080 to 5,098 ft. The sample a foot inside its top still reads the tight streak above it at 2.9 ohm·m. The formation is at 145 °F, the mud report gives an Rmf of 0.58 ohm·m at 75 °F, the shale reads −15 mV, and the water sample is 75,000 ppm NaCl. Archie's a, m and n are 1, 2 and 2 on a 2.65 g/cm³ sandstone matrix with 1.0 g/cm³ filtrate. The Pickett plot is reported, and the four ways are allowed 20% of spread.

Arps carries the Rmf of 0.58 ohm·m at 75 °F to 0.58 × 81.77 / 151.77 = 0.3125 ohm·m at 145 °F, and Rmfe is 0.85 × 0.3125 = 0.2656 ohm·m. The water sand's ten samples average −73.4 mV, so the static SP is −73.4 − (−15) = −58.4 mV. K is 61 + 0.133 × 145 = 80.29, and Rw from SP is 0.2656 × 10^(−58.4/80.29) = 0.0498 ohm·m. The smallest Rwa in the sand is 0.0453 ohm·m, at 5,086 ft. The Pickett line at m = 2 gives 0.0484 ohm·m, with the points within 0.025 of a decade of it. The free fit reads m = 2.82 at an R² of 0.49, because the sand spans only 1.5 porosity units, so the check judges the scatter instead, which is within its limit. The 75,000 ppm sample is 0.0929 ohm·m at 75 °F and 0.0501 ohm·m at 145 °F. The four spread 10% over their mean of 0.0484, inside the 20% limit, and the Pickett Rw of 0.0484 ohm·m is 0.0899 ohm·m at 75 °F. A 40,000 ppm sample would read 0.0857 ohm·m and spread the four 71%, so the agreement check warns. A shale baseline of −80 mV makes the SP reversed and the SP check warns. Lower the span the fit needs to 1 porosity unit and the check judges the free fit instead: m = 2.82 is not the input 2, so it warns.

## Validity

Rw from SP holds for NaCl-dominant water and a filtrate fresher than the formation water, in a clean, thick, permeable sand. Shale in the sand, thin beds and hydrocarbons all reduce the SP, and the equivalent-resistivity step from Rweq to Rw needs Gen-9 type charts below about 0.08 ohm·m at 75 °F. Rwa holds only in a clean, wet sand: hydrocarbon raises it and shale lowers it. Its minimum picks the lowest reading, so it leans low. The Pickett plot fits m only across a range of porosity. In one clean sand the free fit means nothing, and m comes from core. A water sample is only as good as its recovery: mud-filtrate contamination freshens it. The salinity chart's fit is for NaCl. The log is synthetic. Field units.

Named alternatives: Gen-9 type charts for the Rweq-to-Rw step in very saline water; Dunlap or multiplier corrections for water with ions other than NaCl; m from core where the water sand spans too little porosity to fit it.

## References

- Arps, J.J. (1953). The Effect of Temperature on the Density and Electrical Resistivity of Sodium Chloride Solutions. *Journal of Petroleum Technology* 5(10), 17–20, SPE-953327-G.
- Pickett, G.R. (1966). A Review of Current Techniques for Determination of Water Saturation from Logs. *Journal of Petroleum Technology* 18(11), 1425–1433, SPE-1446-PA.
- Bassiouni, Z. (1994). *Theory, Measurement, and Interpretation of Well Logs*. SPE Textbook Series Vol. 4, ch. 6 and 15 (the SP and its static value, Rwa).
- Asquith, G. and Krygowski, D. (2004). *Basic Well Log Analysis*, 2nd ed. AAPG Methods in Exploration 16, ch. 3 and 6 (Rw from SP, the Pickett plot).
- Schlumberger (2009). *Log Interpretation Charts*, chart Gen-6 (resistivity of NaCl solutions against salinity and temperature).

## Functions used

`PO.PP.Porosity.FromDensity`, `PO.PP.Rw.Temperature`, `PO.PP.Rw.FromSsp`, `PO.PP.Rw.FromRwa`, `PO.PP.Rw.FromSalinity`

## Spreadsheet: RwDetermination

|     | A                                                                                                                                                                                                                            | B                                                                                                                           | C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | D                                      | E                                                             | F                    | G                                          | H            | I            | J            |
|-----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------|---------------------------------------------------------------|----------------------|--------------------------------------------|--------------|--------------|--------------|
| 1   | Formation Water Resistivity                                                                                                                                                                                                  |                                                                                                                             | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                        |                                                               |                      |                                            |              |              |              |
| 2   | Blue cells on yellow are inputs. Set Archie's a, m and n, the temperatures, the filtrate's Rmf, the shale's SP, the water sand and the water's salinity; paste your own SP, density and deep resistivity over the log below. |                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 3   | Archie's Parameters, the Temperatures, the Filtrate, the Water Sand and the Water Sample                                                                                                                                     |                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 4   | Tortuosity factor a                                                                                                                                                                                                          | 1                                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 5   | Cementation exponent m                                                                                                                                                                                                       | 2                                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 6   | Saturation exponent n (the Pickett plot's lines of constant Sw)                                                                                                                                                              | 2                                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 7   | Formation temperature                                                                                                                                                                                                        | 145                                                                                                                         | °F                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                        |                                                               |                      |                                            |              |              |              |
| 8   | Reference temperature of the Rmf reading and the salinity chart                                                                                                                                                              | 75                                                                                                                          | °F                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                        |                                                               |                      |                                            |              |              |              |
| 9   | Mud-filtrate resistivity at the reference temperature (mud report)                                                                                                                                                           | 0.58                                                                                                                        | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 10  | Rmfe per Rmf (0.85 for Rmf over 0.1 ohm·m at 75 °F)                                                                                                                                                                          | 0.85                                                                                                                        | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 11  | Shale baseline SP, read in a thick shale                                                                                                                                                                                     | -15                                                                                                                         | mV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                        |                                                               |                      |                                            |              |              |              |
| 12  | Matrix density (sandstone)                                                                                                                                                                                                   | 2.65                                                                                                                        | g/cm³                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 13  | Fluid density (fresh mud filtrate)                                                                                                                                                                                           | 1                                                                                                                           | g/cm³                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 14  | Water sand top (5,077 ft, three feet inside)                                                                                                                                                                                 | 5080                                                                                                                        | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                        |                                                               |                      |                                            |              |              |              |
| 15  | Water sand base (5,100 ft, two feet inside)                                                                                                                                                                                  | 5098                                                                                                                        | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                        |                                                               |                      |                                            |              |              |              |
| 16  | Water sample salinity, NaCl equivalent                                                                                                                                                                                       | 75000                                                                                                                       | ppm                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                        |                                                               |                      |                                            |              |              |              |
| 17  | Rw reported (1 SP, 2 minimum Rwa, 3 Pickett, 4 salinity)                                                                                                                                                                     | 3                                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 18  | Agreement limit of the four Rw values, spread over their mean                                                                                                                                                                | 0.2                                                                                                                         | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 19  | Porosity span of the water sand needed to fit m                                                                                                                                                                              | 0.05                                                                                                                        | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 20  | Agreement limit of a fitted m with the input m                                                                                                                                                                               | 0.3                                                                                                                         | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 21  | Largest scatter of log Rwa about the Pickett line                                                                                                                                                                            | 0.05                                                                                                                        | cycles                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                        |                                                               |                      |                                            |              |              |              |
| 25  | Rw by Each Way, the One Reported, and the Checks                                                                                                                                                                             |                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 26  | Water sand mean porosity                                                                                                                                                                                                     | =AVERAGEIFS($E$67:$E$127,$G$67:$G$127,1)                                                                                    | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 27  | Water sand porosity span, largest less smallest                                                                                                                                                                              | =MAXIFS($E$67:$E$127,$G$67:$G$127,1)-MINIFS($E$67:$E$127,$G$67:$G$127,1)                                                    | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 28  | Water sand samples                                                                                                                                                                                                           | =SUM($G$67:$G$127)                                                                                                          | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 29  | Rmf at formation temperature (Arps)                                                                                                                                                                                          | =PO.PP.Rw.Temperature(RW_Rmf,RW_Tref,RW_Tf)                                                                                 | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 30  | Equivalent filtrate resistivity Rmfe                                                                                                                                                                                         | =RW_RmfeK*RW_RmfT                                                                                                           | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 31  | Water sand mean SP                                                                                                                                                                                                           | =AVERAGEIFS($B$67:$B$127,$G$67:$G$127,1)                                                                                    | mV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                        |                                                               |                      |                                            |              |              |              |
| 32  | Static SP, the sand's deflection from the shale baseline                                                                                                                                                                     | =RW_WSP-RW_SPsh                                                                                                             | mV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                                        |                                                               |                      |                                            |              |              |              |
| 33  | Rw from the static SP (Rweq, NaCl water)                                                                                                                                                                                     | =PO.PP.Rw.FromSsp(RW_SSP,RW_Rmfe,RW_Tf)                                                                                     | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 34  | Rw as the water sand's minimum Rwa = Rt φ^m / a                                                                                                                                                                              | =PO.PP.Rw.FromRwa(FILTER($D$67:$D$127,$G$67:$G$127=1),FILTER($E$67:$E$127,$G$67:$G$127=1),RW_a,RW_m)                        | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 35  | Pickett free fit, m (minus the LINEST slope of log Rt on log φ)                                                                                                                                                              | =-INDEX(LINEST(FILTER($I$67:$I$127,$G$67:$G$127=1),FILTER($H$67:$H$127,$G$67:$G$127=1)),1)                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 36  | Pickett free fit, R²                                                                                                                                                                                                         | =RSQ(FILTER($I$67:$I$127,$G$67:$G$127=1),FILTER($H$67:$H$127,$G$67:$G$127=1))                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 37  | Rw from the Pickett line of slope −m through the water sand                                                                                                                                                                  | =10^AVERAGEIFS($J$67:$J$127,$G$67:$G$127,1)                                                                                 | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 38  | Scatter of log Rwa about that line (standard deviation)                                                                                                                                                                      | =STDEV.S(FILTER($J$67:$J$127,$G$67:$G$127=1))                                                                               | cycles                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                        |                                                               |                      |                                            |              |              |              |
| 39  | Rw of the water sample at the reference temperature                                                                                                                                                                          | =PO.PP.Rw.FromSalinity(RW_Ppm)                                                                                              | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 40  | Rw from salinity at formation temperature (Arps)                                                                                                                                                                             | =PO.PP.Rw.Temperature(RW_RwRef,RW_Tref,RW_Tf)                                                                               | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 41  | Rw reported, from                                                                                                                                                                                                            | =""&CHOOSE(RW_Method,"static SP","minimum Rwa","Pickett plot","water salinity")                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 42  | Formation-water resistivity Rw at formation temperature                                                                                                                                                                      | =CHOOSE(RW_Method,RW_RwSP,RW_RwRwa,RW_RwPk,RW_RwSal)                                                                        | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 43  | That Rw at the reference temperature (Arps)                                                                                                                                                                                  | =PO.PP.Rw.Temperature(RW_Rw,RW_Tf,RW_Tref)                                                                                  | ohm·m                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                        |                                                               |                      |                                            |              |              |              |
| 44  | Spread of the four Rw values over their mean                                                                                                                                                                                 | =(MAX(RW_RwSP,RW_RwRwa,RW_RwPk,RW_RwSal)-MIN(RW_RwSP,RW_RwRwa,RW_RwPk,RW_RwSal))/AVERAGE(RW_RwSP,RW_RwRwa,RW_RwPk,RW_RwSal) | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                        |                                                               |                      |                                            |              |              |              |
| 45  | Agreement check                                                                                                                                                                                                              | =IF(RW_Spread<=RW_Tol,"PASS","WARN")                                                                                        | =IF(RW_Spread<=RW_Tol,"SP, Rwa, Pickett and salinity give Rw within "&FIXED(RW_Spread*100,0)&"% of each other, inside the "&FIXED(RW_Tol*100,0)&"% limit","SP, Rwa, Pickett and salinity spread "&FIXED(RW_Spread*100,0)&"% in Rw: check the water sand is clean and wet, the SP baseline, Rmf and the sample")                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 46  | Pickett check                                                                                                                                                                                                                | =IF(RW_Span>=RW_SpanMin,IF(ABS(RW_PkM-RW_m)<=RW_MTol,"PASS","WARN"),IF(RW_Scatter<=RW_ScatMax,"PASS","WARN"))               | =IF(RW_Span>=RW_SpanMin,IF(ABS(RW_PkM-RW_m)<=RW_MTol,"the water points fit m = "&FIXED(RW_PkM,2)&", as the input","the water points fit m = "&FIXED(RW_PkM,2)&", not the input "&FIXED(RW_m,2)&": revisit m, or the zone is not all wet"),IF(RW_Scatter<=RW_ScatMax,"the water sand spans only "&FIXED(RW_Span*100,1)&" p.u., too little to fit m, so the line is drawn at the input m; its points lie within "&FIXED(RW_Scatter,2)&" of a decade of it","the water sand's points scatter "&FIXED(RW_Scatter,2)&" of a decade about the line: the zone is not all clean and wet")) |                                        |                                                               |                      |                                            |              |              |              |
| 47  | SP check                                                                                                                                                                                                                     | =IF(RW_SSP<0,"PASS","WARN")                                                                                                 | =IF(RW_SSP<0,"the sand reads "&FIXED(-RW_SSP,1)&" mV negative of the shale: the water is saltier than the filtrate, as the SP method assumes","the SP is reversed or flat: the water is as fresh as the filtrate or fresher, and Rw from SP does not hold")                                                                                                                                                                                                                                                                                                                        |                                        |                                                               |                      |                                            |              |              |              |
| 49  | How to use it: paste your depth, SP, bulk density and deep resistivity over the log table, pick the shale baseline and a clean, thick water sand, and take Rmf and its temperature from the mud report.                      |                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 50  | The log is synthetic, the log display workbook's interval. A Pickett plot fits m only across a range of porosity; in one clean sand, take m from core and let the plot give Rw.                                              |                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 52  | Pickett Plot Lines of Constant Sw (Rw from the Pickett line, slope −m)                                                                                                                                                       |                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 53  | φ (%)                                                                                                                                                                                                                        | log φ (—)                                                                                                                   | log Rt, Sw = 100% (—)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | log Rt, Sw = 50% (—)                   | log Rt, Sw = 25% (—)                                          |                      |                                            |              |              |              |
| 54  | 0.04                                                                                                                                                                                                                         | =LOG10(A54)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A54^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A54^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A54^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 55  | 0.06                                                                                                                                                                                                                         | =LOG10(A55)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A55^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A55^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A55^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 56  | 0.08                                                                                                                                                                                                                         | =LOG10(A56)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A56^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A56^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A56^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 57  | 0.1                                                                                                                                                                                                                          | =LOG10(A57)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A57^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A57^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A57^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 58  | 0.15                                                                                                                                                                                                                         | =LOG10(A58)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A58^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A58^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A58^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 59  | 0.2                                                                                                                                                                                                                          | =LOG10(A59)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A59^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A59^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A59^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 60  | 0.25                                                                                                                                                                                                                         | =LOG10(A60)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A60^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A60^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A60^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 61  | 0.3                                                                                                                                                                                                                          | =LOG10(A61)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A61^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A61^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A61^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 62  | 0.35                                                                                                                                                                                                                         | =LOG10(A62)                                                                                                                 | =LOG10(RW_a*RW_RwPk/A62^RW_m/1^RW_n)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =LOG10(RW_a*RW_RwPk/A62^RW_m/0.5^RW_n) | =LOG10(RW_a*RW_RwPk/A62^RW_m/0.25^RW_n)                       |                      |                                            |              |              |              |
| 65  | Log: Readings, Rwa and the Pickett Plot's Logarithms (the log display workbook's interval every 2 ft)                                                                                                                        |                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                        |                                                               |                      |                                            |              |              |              |
| 66  | Depth (ft)                                                                                                                                                                                                                   | SP (mV)                                                                                                                     | RHOB (g/cm³)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Rt (ohm·m)                             | φ density (%)                                                 | Rwa (ohm·m)          | Water sand                                 | log φ (—)    | log Rt (—)   | log Rwa (—)  |
| 67  | 5000                                                                                                                                                                                                                         | -14.7                                                                                                                       | 2.479                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.43                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C67,RW_RhoF))  | =D67*E67^RW_m/RW_a   | =IF(AND(A67>=RW_WTop,A67<=RW_WBase),1,0)   | =LOG10(E67)  | =LOG10(D67)  | =LOG10(F67)  |
| 68  | 5002                                                                                                                                                                                                                         | -14.6                                                                                                                       | 2.482                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.44                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C68,RW_RhoF))  | =D68*E68^RW_m/RW_a   | =IF(AND(A68>=RW_WTop,A68<=RW_WBase),1,0)   | =LOG10(E68)  | =LOG10(D68)  | =LOG10(F68)  |
| 69  | 5004                                                                                                                                                                                                                         | -14.8                                                                                                                       | 2.475                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.46                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C69,RW_RhoF))  | =D69*E69^RW_m/RW_a   | =IF(AND(A69>=RW_WTop,A69<=RW_WBase),1,0)   | =LOG10(E69)  | =LOG10(D69)  | =LOG10(F69)  |
| 70  | 5006                                                                                                                                                                                                                         | -15.6                                                                                                                       | 2.481                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.38                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C70,RW_RhoF))  | =D70*E70^RW_m/RW_a   | =IF(AND(A70>=RW_WTop,A70<=RW_WBase),1,0)   | =LOG10(E70)  | =LOG10(D70)  | =LOG10(F70)  |
| 71  | 5008                                                                                                                                                                                                                         | -14.2                                                                                                                       | 2.476                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.46                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C71,RW_RhoF))  | =D71*E71^RW_m/RW_a   | =IF(AND(A71>=RW_WTop,A71<=RW_WBase),1,0)   | =LOG10(E71)  | =LOG10(D71)  | =LOG10(F71)  |
| 72  | 5010                                                                                                                                                                                                                         | -20.7                                                                                                                       | 2.462                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 3.27                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C72,RW_RhoF))  | =D72*E72^RW_m/RW_a   | =IF(AND(A72>=RW_WTop,A72<=RW_WBase),1,0)   | =LOG10(E72)  | =LOG10(D72)  | =LOG10(F72)  |
| 73  | 5012                                                                                                                                                                                                                         | -46                                                                                                                         | 2.339                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 10                                     | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C73,RW_RhoF))  | =D73*E73^RW_m/RW_a   | =IF(AND(A73>=RW_WTop,A73<=RW_WBase),1,0)   | =LOG10(E73)  | =LOG10(D73)  | =LOG10(F73)  |
| 74  | 5014                                                                                                                                                                                                                         | -73.7                                                                                                                       | 2.237                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 41.2                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C74,RW_RhoF))  | =D74*E74^RW_m/RW_a   | =IF(AND(A74>=RW_WTop,A74<=RW_WBase),1,0)   | =LOG10(E74)  | =LOG10(D74)  | =LOG10(F74)  |
| 75  | 5016                                                                                                                                                                                                                         | -76.9                                                                                                                       | 2.209                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 46.3                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C75,RW_RhoF))  | =D75*E75^RW_m/RW_a   | =IF(AND(A75>=RW_WTop,A75<=RW_WBase),1,0)   | =LOG10(E75)  | =LOG10(D75)  | =LOG10(F75)  |
| 76  | 5018                                                                                                                                                                                                                         | -79.2                                                                                                                       | 2.212                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 50.6                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C76,RW_RhoF))  | =D76*E76^RW_m/RW_a   | =IF(AND(A76>=RW_WTop,A76<=RW_WBase),1,0)   | =LOG10(E76)  | =LOG10(D76)  | =LOG10(F76)  |
| 77  | 5020                                                                                                                                                                                                                         | -77.5                                                                                                                       | 2.21                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 44.8                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C77,RW_RhoF))  | =D77*E77^RW_m/RW_a   | =IF(AND(A77>=RW_WTop,A77<=RW_WBase),1,0)   | =LOG10(E77)  | =LOG10(D77)  | =LOG10(F77)  |
| 78  | 5022                                                                                                                                                                                                                         | -78.2                                                                                                                       | 2.214                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 52.3                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C78,RW_RhoF))  | =D78*E78^RW_m/RW_a   | =IF(AND(A78>=RW_WTop,A78<=RW_WBase),1,0)   | =LOG10(E78)  | =LOG10(D78)  | =LOG10(F78)  |
| 79  | 5024                                                                                                                                                                                                                         | -78.6                                                                                                                       | 2.209                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 46.1                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C79,RW_RhoF))  | =D79*E79^RW_m/RW_a   | =IF(AND(A79>=RW_WTop,A79<=RW_WBase),1,0)   | =LOG10(E79)  | =LOG10(D79)  | =LOG10(F79)  |
| 80  | 5026                                                                                                                                                                                                                         | -78.1                                                                                                                       | 2.21                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 47.4                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C80,RW_RhoF))  | =D80*E80^RW_m/RW_a   | =IF(AND(A80>=RW_WTop,A80<=RW_WBase),1,0)   | =LOG10(E80)  | =LOG10(D80)  | =LOG10(F80)  |
| 81  | 5028                                                                                                                                                                                                                         | -78.1                                                                                                                       | 2.216                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 48.3                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C81,RW_RhoF))  | =D81*E81^RW_m/RW_a   | =IF(AND(A81>=RW_WTop,A81<=RW_WBase),1,0)   | =LOG10(E81)  | =LOG10(D81)  | =LOG10(F81)  |
| 82  | 5030                                                                                                                                                                                                                         | -77.5                                                                                                                       | 2.208                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 46.7                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C82,RW_RhoF))  | =D82*E82^RW_m/RW_a   | =IF(AND(A82>=RW_WTop,A82<=RW_WBase),1,0)   | =LOG10(E82)  | =LOG10(D82)  | =LOG10(F82)  |
| 83  | 5032                                                                                                                                                                                                                         | -74.3                                                                                                                       | 2.234                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 37.3                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C83,RW_RhoF))  | =D83*E83^RW_m/RW_a   | =IF(AND(A83>=RW_WTop,A83<=RW_WBase),1,0)   | =LOG10(E83)  | =LOG10(D83)  | =LOG10(F83)  |
| 84  | 5034                                                                                                                                                                                                                         | -45.4                                                                                                                       | 2.344                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 10.3                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C84,RW_RhoF))  | =D84*E84^RW_m/RW_a   | =IF(AND(A84>=RW_WTop,A84<=RW_WBase),1,0)   | =LOG10(E84)  | =LOG10(D84)  | =LOG10(F84)  |
| 85  | 5036                                                                                                                                                                                                                         | -20.9                                                                                                                       | 2.463                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 3.25                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C85,RW_RhoF))  | =D85*E85^RW_m/RW_a   | =IF(AND(A85>=RW_WTop,A85<=RW_WBase),1,0)   | =LOG10(E85)  | =LOG10(D85)  | =LOG10(F85)  |
| 86  | 5038                                                                                                                                                                                                                         | -17.8                                                                                                                       | 2.461                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.57                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C86,RW_RhoF))  | =D86*E86^RW_m/RW_a   | =IF(AND(A86>=RW_WTop,A86<=RW_WBase),1,0)   | =LOG10(E86)  | =LOG10(D86)  | =LOG10(F86)  |
| 87  | 5040                                                                                                                                                                                                                         | -33.9                                                                                                                       | 2.41                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 6.84                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C87,RW_RhoF))  | =D87*E87^RW_m/RW_a   | =IF(AND(A87>=RW_WTop,A87<=RW_WBase),1,0)   | =LOG10(E87)  | =LOG10(D87)  | =LOG10(F87)  |
| 88  | 5042                                                                                                                                                                                                                         | -48.2                                                                                                                       | 2.338                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14.8                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C88,RW_RhoF))  | =D88*E88^RW_m/RW_a   | =IF(AND(A88>=RW_WTop,A88<=RW_WBase),1,0)   | =LOG10(E88)  | =LOG10(D88)  | =LOG10(F88)  |
| 89  | 5044                                                                                                                                                                                                                         | -52.5                                                                                                                       | 2.33                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 18.3                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C89,RW_RhoF))  | =D89*E89^RW_m/RW_a   | =IF(AND(A89>=RW_WTop,A89<=RW_WBase),1,0)   | =LOG10(E89)  | =LOG10(D89)  | =LOG10(F89)  |
| 90  | 5046                                                                                                                                                                                                                         | -51.3                                                                                                                       | 2.329                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 15.5                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C90,RW_RhoF))  | =D90*E90^RW_m/RW_a   | =IF(AND(A90>=RW_WTop,A90<=RW_WBase),1,0)   | =LOG10(E90)  | =LOG10(D90)  | =LOG10(F90)  |
| 91  | 5048                                                                                                                                                                                                                         | -51.1                                                                                                                       | 2.333                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 10.3                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C91,RW_RhoF))  | =D91*E91^RW_m/RW_a   | =IF(AND(A91>=RW_WTop,A91<=RW_WBase),1,0)   | =LOG10(E91)  | =LOG10(D91)  | =LOG10(F91)  |
| 92  | 5050                                                                                                                                                                                                                         | -50.7                                                                                                                       | 2.335                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.01                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C92,RW_RhoF))  | =D92*E92^RW_m/RW_a   | =IF(AND(A92>=RW_WTop,A92<=RW_WBase),1,0)   | =LOG10(E92)  | =LOG10(D92)  | =LOG10(F92)  |
| 93  | 5052                                                                                                                                                                                                                         | -49.6                                                                                                                       | 2.336                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.15                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C93,RW_RhoF))  | =D93*E93^RW_m/RW_a   | =IF(AND(A93>=RW_WTop,A93<=RW_WBase),1,0)   | =LOG10(E93)  | =LOG10(D93)  | =LOG10(F93)  |
| 94  | 5054                                                                                                                                                                                                                         | -49.6                                                                                                                       | 2.345                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.15                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C94,RW_RhoF))  | =D94*E94^RW_m/RW_a   | =IF(AND(A94>=RW_WTop,A94<=RW_WBase),1,0)   | =LOG10(E94)  | =LOG10(D94)  | =LOG10(F94)  |
| 95  | 5056                                                                                                                                                                                                                         | -46.7                                                                                                                       | 2.345                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.18                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C95,RW_RhoF))  | =D95*E95^RW_m/RW_a   | =IF(AND(A95>=RW_WTop,A95<=RW_WBase),1,0)   | =LOG10(E95)  | =LOG10(D95)  | =LOG10(F95)  |
| 96  | 5058                                                                                                                                                                                                                         | -33.5                                                                                                                       | 2.412                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.66                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C96,RW_RhoF))  | =D96*E96^RW_m/RW_a   | =IF(AND(A96>=RW_WTop,A96<=RW_WBase),1,0)   | =LOG10(E96)  | =LOG10(D96)  | =LOG10(F96)  |
| 97  | 5060                                                                                                                                                                                                                         | -16.4                                                                                                                       | 2.467                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.19                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C97,RW_RhoF))  | =D97*E97^RW_m/RW_a   | =IF(AND(A97>=RW_WTop,A97<=RW_WBase),1,0)   | =LOG10(E97)  | =LOG10(D97)  | =LOG10(F97)  |
| 98  | 5062                                                                                                                                                                                                                         | -16                                                                                                                         | 2.483                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.66                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C98,RW_RhoF))  | =D98*E98^RW_m/RW_a   | =IF(AND(A98>=RW_WTop,A98<=RW_WBase),1,0)   | =LOG10(E98)  | =LOG10(D98)  | =LOG10(F98)  |
| 99  | 5064                                                                                                                                                                                                                         | -14.7                                                                                                                       | 2.474                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.24                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C99,RW_RhoF))  | =D99*E99^RW_m/RW_a   | =IF(AND(A99>=RW_WTop,A99<=RW_WBase),1,0)   | =LOG10(E99)  | =LOG10(D99)  | =LOG10(F99)  |
| 100 | 5066                                                                                                                                                                                                                         | -15.5                                                                                                                       | 2.485                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.56                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C100,RW_RhoF)) | =D100*E100^RW_m/RW_a | =IF(AND(A100>=RW_WTop,A100<=RW_WBase),1,0) | =LOG10(E100) | =LOG10(D100) | =LOG10(F100) |
| 101 | 5068                                                                                                                                                                                                                         | -14.5                                                                                                                       | 2.48                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 2.45                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C101,RW_RhoF)) | =D101*E101^RW_m/RW_a | =IF(AND(A101>=RW_WTop,A101<=RW_WBase),1,0) | =LOG10(E101) | =LOG10(D101) | =LOG10(F101) |
| 102 | 5070                                                                                                                                                                                                                         | -17.1                                                                                                                       | 2.488                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 3.74                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C102,RW_RhoF)) | =D102*E102^RW_m/RW_a | =IF(AND(A102>=RW_WTop,A102<=RW_WBase),1,0) | =LOG10(E102) | =LOG10(D102) | =LOG10(F102) |
| 103 | 5072                                                                                                                                                                                                                         | -22.6                                                                                                                       | 2.53                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 29.3                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C103,RW_RhoF)) | =D103*E103^RW_m/RW_a | =IF(AND(A103>=RW_WTop,A103<=RW_WBase),1,0) | =LOG10(E103) | =LOG10(D103) | =LOG10(F103) |
| 104 | 5074                                                                                                                                                                                                                         | -29.6                                                                                                                       | 2.567                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 259                                    | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C104,RW_RhoF)) | =D104*E104^RW_m/RW_a | =IF(AND(A104>=RW_WTop,A104<=RW_WBase),1,0) | =LOG10(E104) | =LOG10(D104) | =LOG10(F104) |
| 105 | 5076                                                                                                                                                                                                                         | -40.5                                                                                                                       | 2.502                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 98.6                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C105,RW_RhoF)) | =D105*E105^RW_m/RW_a | =IF(AND(A105>=RW_WTop,A105<=RW_WBase),1,0) | =LOG10(E105) | =LOG10(D105) | =LOG10(F105) |
| 106 | 5078                                                                                                                                                                                                                         | -64.1                                                                                                                       | 2.306                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.92                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C106,RW_RhoF)) | =D106*E106^RW_m/RW_a | =IF(AND(A106>=RW_WTop,A106<=RW_WBase),1,0) | =LOG10(E106) | =LOG10(D106) | =LOG10(F106) |
| 107 | 5080                                                                                                                                                                                                                         | -73.3                                                                                                                       | 2.245                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.885                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C107,RW_RhoF)) | =D107*E107^RW_m/RW_a | =IF(AND(A107>=RW_WTop,A107<=RW_WBase),1,0) | =LOG10(E107) | =LOG10(D107) | =LOG10(F107) |
| 108 | 5082                                                                                                                                                                                                                         | -73.4                                                                                                                       | 2.227                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.742                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C108,RW_RhoF)) | =D108*E108^RW_m/RW_a | =IF(AND(A108>=RW_WTop,A108<=RW_WBase),1,0) | =LOG10(E108) | =LOG10(D108) | =LOG10(F108) |
| 109 | 5084                                                                                                                                                                                                                         | -75.3                                                                                                                       | 2.233                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.751                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C109,RW_RhoF)) | =D109*E109^RW_m/RW_a | =IF(AND(A109>=RW_WTop,A109<=RW_WBase),1,0) | =LOG10(E109) | =LOG10(D109) | =LOG10(F109) |
| 110 | 5086                                                                                                                                                                                                                         | -72.9                                                                                                                       | 2.228                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.693                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C110,RW_RhoF)) | =D110*E110^RW_m/RW_a | =IF(AND(A110>=RW_WTop,A110<=RW_WBase),1,0) | =LOG10(E110) | =LOG10(D110) | =LOG10(F110) |
| 111 | 5088                                                                                                                                                                                                                         | -74.6                                                                                                                       | 2.235                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.812                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C111,RW_RhoF)) | =D111*E111^RW_m/RW_a | =IF(AND(A111>=RW_WTop,A111<=RW_WBase),1,0) | =LOG10(E111) | =LOG10(D111) | =LOG10(F111) |
| 112 | 5090                                                                                                                                                                                                                         | -73.7                                                                                                                       | 2.224                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.681                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C112,RW_RhoF)) | =D112*E112^RW_m/RW_a | =IF(AND(A112>=RW_WTop,A112<=RW_WBase),1,0) | =LOG10(E112) | =LOG10(D112) | =LOG10(F112) |
| 113 | 5092                                                                                                                                                                                                                         | -74.3                                                                                                                       | 2.233                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.769                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C113,RW_RhoF)) | =D113*E113^RW_m/RW_a | =IF(AND(A113>=RW_WTop,A113<=RW_WBase),1,0) | =LOG10(E113) | =LOG10(D113) | =LOG10(F113) |
| 114 | 5094                                                                                                                                                                                                                         | -73.1                                                                                                                       | 2.229                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.727                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C114,RW_RhoF)) | =D114*E114^RW_m/RW_a | =IF(AND(A114>=RW_WTop,A114<=RW_WBase),1,0) | =LOG10(E114) | =LOG10(D114) | =LOG10(F114) |
| 115 | 5096                                                                                                                                                                                                                         | -74                                                                                                                         | 2.229                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.784                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C115,RW_RhoF)) | =D115*E115^RW_m/RW_a | =IF(AND(A115>=RW_WTop,A115<=RW_WBase),1,0) | =LOG10(E115) | =LOG10(D115) | =LOG10(F115) |
| 116 | 5098                                                                                                                                                                                                                         | -69.4                                                                                                                       | 2.248                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.767                                  | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C116,RW_RhoF)) | =D116*E116^RW_m/RW_a | =IF(AND(A116>=RW_WTop,A116<=RW_WBase),1,0) | =LOG10(E116) | =LOG10(D116) | =LOG10(F116) |
| 117 | 5100                                                                                                                                                                                                                         | -43.6                                                                                                                       | 2.355                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.39                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C117,RW_RhoF)) | =D117*E117^RW_m/RW_a | =IF(AND(A117>=RW_WTop,A117<=RW_WBase),1,0) | =LOG10(E117) | =LOG10(D117) | =LOG10(F117) |
| 118 | 5102                                                                                                                                                                                                                         | -19.9                                                                                                                       | 2.461                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.25                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C118,RW_RhoF)) | =D118*E118^RW_m/RW_a | =IF(AND(A118>=RW_WTop,A118<=RW_WBase),1,0) | =LOG10(E118) | =LOG10(D118) | =LOG10(F118) |
| 119 | 5104                                                                                                                                                                                                                         | -14.9                                                                                                                       | 2.473                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.28                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C119,RW_RhoF)) | =D119*E119^RW_m/RW_a | =IF(AND(A119>=RW_WTop,A119<=RW_WBase),1,0) | =LOG10(E119) | =LOG10(D119) | =LOG10(F119) |
| 120 | 5106                                                                                                                                                                                                                         | -15.2                                                                                                                       | 2.485                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.52                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C120,RW_RhoF)) | =D120*E120^RW_m/RW_a | =IF(AND(A120>=RW_WTop,A120<=RW_WBase),1,0) | =LOG10(E120) | =LOG10(D120) | =LOG10(F120) |
| 121 | 5108                                                                                                                                                                                                                         | -14.1                                                                                                                       | 2.475                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.4                                    | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C121,RW_RhoF)) | =D121*E121^RW_m/RW_a | =IF(AND(A121>=RW_WTop,A121<=RW_WBase),1,0) | =LOG10(E121) | =LOG10(D121) | =LOG10(F121) |
| 122 | 5110                                                                                                                                                                                                                         | -16.2                                                                                                                       | 2.482                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.51                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C122,RW_RhoF)) | =D122*E122^RW_m/RW_a | =IF(AND(A122>=RW_WTop,A122<=RW_WBase),1,0) | =LOG10(E122) | =LOG10(D122) | =LOG10(F122) |
| 123 | 5112                                                                                                                                                                                                                         | -13.9                                                                                                                       | 2.477                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.27                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C123,RW_RhoF)) | =D123*E123^RW_m/RW_a | =IF(AND(A123>=RW_WTop,A123<=RW_WBase),1,0) | =LOG10(E123) | =LOG10(D123) | =LOG10(F123) |
| 124 | 5114                                                                                                                                                                                                                         | -15.5                                                                                                                       | 2.485                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.69                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C124,RW_RhoF)) | =D124*E124^RW_m/RW_a | =IF(AND(A124>=RW_WTop,A124<=RW_WBase),1,0) | =LOG10(E124) | =LOG10(D124) | =LOG10(F124) |
| 125 | 5116                                                                                                                                                                                                                         | -15                                                                                                                         | 2.475                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.27                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C125,RW_RhoF)) | =D125*E125^RW_m/RW_a | =IF(AND(A125>=RW_WTop,A125<=RW_WBase),1,0) | =LOG10(E125) | =LOG10(D125) | =LOG10(F125) |
| 126 | 5118                                                                                                                                                                                                                         | -15.5                                                                                                                       | 2.483                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.5                                    | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C126,RW_RhoF)) | =D126*E126^RW_m/RW_a | =IF(AND(A126>=RW_WTop,A126<=RW_WBase),1,0) | =LOG10(E126) | =LOG10(D126) | =LOG10(F126) |
| 127 | 5120                                                                                                                                                                                                                         | -14.6                                                                                                                       | 2.482                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 2.38                                   | =MAX(0.001,PO.PP.Porosity.FromDensity(RW_RhoMa,C127,RW_RhoF)) | =D127*E127^RW_m/RW_a | =IF(AND(A127>=RW_WTop,A127<=RW_WBase),1,0) | =LOG10(E127) | =LOG10(D127) | =LOG10(F127) |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| 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.Rw.Temperature | =LAMBDA(R_ref, T_ref_F, T_F, R_ref*(T_ref_F+6.77)/(T_F+6.77)) | Arps (1953) temperature correction of a water or mud resistivity, R = R_ref (T_ref + 6.77) / (T + 6.77), degF. |
| PO.PP.Rw.FromSsp | =LAMBDA(SSP, Rmf_eq, T_F, Rmf_eq*10^(SSP/(61+0.133*T_F))) | Equivalent formation-water resistivity from the static SP, for NaCl-dominant water. |
| PO.PP.Rw.FromRwa | =LAMBDA(Rt_ohmm, Phi_frac, a_tort, m_cem, MIN(Rt_ohmm*Phi_frac^m_cem/a_tort)) | Rw as the minimum apparent water resistivity, Rwa = Rt phi^m / a, over a clean water-bearing interval. |
| PO.PP.Rw.FromSalinity | =LAMBDA(NaCl_ppm, 0.0123+3647.5/NaCl_ppm^0.955) | NaCl solution resistivity at 75 degF from salinity in ppm, Rw75 = 0.0123 + 3647.5 / ppm^0.955 (the fitted form of the resistivity-salinity chart). |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| RW_a | $B$4 | Tortuosity factor a |
| RW_m | $B$5 | Cementation exponent m |
| RW_n | $B$6 | Saturation exponent n (the Pickett plot's lines of constant Sw) |
| RW_Tf | $B$7 | Formation temperature, °F |
| RW_Tref | $B$8 | Reference temperature of the Rmf reading and the salinity chart, °F |
| RW_Rmf | $B$9 | Mud-filtrate resistivity at the reference temperature (mud report), ohm·m |
| RW_RmfeK | $B$10 | Rmfe per Rmf (0.85 for Rmf over 0.1 ohm·m at 75 °F) |
| RW_SPsh | $B$11 | Shale baseline SP, read in a thick shale, mV |
| RW_RhoMa | $B$12 | Matrix density (sandstone), g/cm³ |
| RW_RhoF | $B$13 | Fluid density (fresh mud filtrate), g/cm³ |
| RW_WTop | $B$14 | Water sand top (5,077 ft, three feet inside), ft |
| RW_WBase | $B$15 | Water sand base (5,100 ft, two feet inside), ft |
| RW_Ppm | $B$16 | Water sample salinity, NaCl equivalent, ppm |
| RW_Method | $B$17 | Rw reported (1 SP, 2 minimum Rwa, 3 Pickett, 4 salinity) |
| RW_Tol | $B$18 | Agreement limit of the four Rw values, spread over their mean, % |
| RW_SpanMin | $B$19 | Porosity span of the water sand needed to fit m, % |
| RW_MTol | $B$20 | Agreement limit of a fitted m with the input m |
| RW_ScatMax | $B$21 | Largest scatter of log Rwa about the Pickett line, cycles |
| RW_Inputs | $B$4:$B$21 | Archie's a, m and n, the formation and reference temperatures, Rmf and its equivalent factor, the shale SP baseline, the matrix and fluid densities, the water sand's top and base, the water's salinity, the Rw reported and the check limits |
| RW_WPhi | $B$26 | Water sand mean porosity, % |
| RW_Span | $B$27 | Water sand porosity span, largest less smallest, % |
| RW_WN | $B$28 | Water sand samples |
| RW_RmfT | $B$29 | Rmf at formation temperature (Arps), ohm·m |
| RW_Rmfe | $B$30 | Equivalent filtrate resistivity Rmfe, ohm·m |
| RW_WSP | $B$31 | Water sand mean SP, mV |
| RW_SSP | $B$32 | Static SP, the sand's deflection from the shale baseline, mV |
| RW_RwSP | $B$33 | Rw from the static SP (Rweq, NaCl water), ohm·m |
| RW_RwRwa | $B$34 | Rw as the water sand's minimum Rwa = Rt φ^m / a, ohm·m |
| RW_PkM | $B$35 | Pickett free fit, m (minus the LINEST slope of log Rt on log φ) |
| RW_PkR2 | $B$36 | Pickett free fit, R² |
| RW_RwPk | $B$37 | Rw from the Pickett line of slope −m through the water sand, ohm·m |
| RW_Scatter | $B$38 | Scatter of log Rwa about that line (standard deviation), cycles |
| RW_RwRef | $B$39 | Rw of the water sample at the reference temperature, ohm·m |
| RW_RwSal | $B$40 | Rw from salinity at formation temperature (Arps), ohm·m |
| RW_MethodWords | $B$41 | Rw reported, from |
| RW_Rw | $B$42 | Formation-water resistivity Rw at formation temperature, ohm·m |
| RW_Rw75 | $B$43 | That Rw at the reference temperature (Arps), ohm·m |
| RW_Spread | $B$44 | Spread of the four Rw values over their mean, % |
| RW_AgreeCheck | $B$45 | Agreement check verdict |
| RW_AgreeCheckNote | $C$45 | Agreement check comment |
| RW_PickettCheck | $B$46 | Pickett check verdict |
| RW_PickettCheckNote | $C$46 | Pickett check comment |
| RW_SpCheck | $B$47 | SP check verdict |
| RW_SpCheckNote | $C$47 | SP check comment |
| RW_Results | $B$26:$B$47 | The water sand's porosity, span and samples, Rmf at temperature, Rmfe, the static SP and Rw from it, the minimum Rwa, the Pickett fit, its Rw and scatter, Rw from salinity, the Rw reported at formation and reference temperature, spread and three checks |
| RW_Curve | $A$54:$E$62 | Porosities across the plot, their logarithm, and the log of Rt on the Pickett lines of 100%, 50% and 25% water saturation |
| RW_Log | $A$67:$J$127 | Each depth's SP, bulk density and deep resistivity, its density porosity and Rwa, whether it is in the water sand, and log φ, log Rt and log Rwa |

---

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

