---
cid: po.bp.de.pore.pressure.eaton
hub: de
tags: [drilling, pore-pressure, fracture-gradient, eaton, matthews-kelly, overburden, gardner, sonic, resistivity, normal-compaction-trend, leak-off-test, mud-weight-window, casing-seat, barite, weight-up]
facets: { discipline: drilling, property: pressure, method-type: analytical }
title: Pore Pressure and Mud-Weight Window
summary: "How heavy the mud must be in each hole section and whether the casing seats hold it, from pore and fracture pressure read off a shale log."
slug: po.de.pore.pressure.eaton
type: worksheet
---

# Pore Pressure and Mud-Weight Window

## Description

How heavy must the mud be in each hole section, and will the casing seats hold it? You enter a shale log with its normal-compaction trends, the casing seats and margins, two offset leak-off tests and the mud on hand. You read off the pore pressure by Eaton's method, the overburden, the fracture gradient by Eaton and by Matthews and Kelly, each section's mud weight, whether each seat holds the next section's mud, the narrowest window, and the barite and blend that make the production mud.

**Parameters:**
- **Logs and trends**: the log mode `PP_Mode` (1 sonic, 2 resistivity), the normal pore-pressure gradient `PP_Pn` (psi/ft), the sonic trend Δtn = Δt0·e^(−c·z) (`PP_Dt0` µs/ft, `PP_DtC` 1/ft), the resistivity trend Rn = R0·e^(b·z) (`PP_R0` ohm·m, `PP_RC` 1/ft), the bulk density above the first log depth `PP_RhoTop` (g/cm³), and Gardner's coefficient `PP_GA` and exponent `PP_GB`
- **Fracture gradient**: Eaton's Poisson's ratio `PP_Nu`, and Matthews and Kelly's Ki as a line in the equivalent depth, `PP_Ki0` + `PP_KiSlope`·Di
- **Casing seats and margins**: the surface and intermediate shoes `PP_Shoe1`, `PP_Shoe2` and TD `PP_TD` (ft TVD), the trip margin `PP_Trip` and the kick margin `PP_Kick` (ppg)
- **Leak-off tests**: two depths and results, `PP_Lot1Z`/`PP_Lot1` and `PP_Lot2Z`/`PP_Lot2` (ft, ppg), and the misfit accepted `PP_LotTol` (ppg)
- **Mud on hand**: the active system `PP_Active` (bbl), the barite density `PP_Barite` (ppg), the premix weight `PP_Premix` (ppg), the batch to blend `PP_Batch` (bbl) and the pit capacity `PP_Pits` (bbl)
- **Log table**: depth, shale transit time and shale resistivity at each point (ft, µs/ft, ohm·m)

**How to use it:** The logs are synthetic: on their trends to 8,000 ft, then slower and more conductive than them through a transition zone. Paste the shale points' depth, transit time and resistivity from your logs into the table, keeping the depths increasing, and drop sand and carbonate points. Pick each normal trend over a normally pressured interval, and calibrate ν, and the Ki line, to the area's leak-off and formation-integrity tests. The log mode picks whether pore pressure comes from the sonic or the resistivity; a mode other than 1 or 2 fails. The density for the overburden is taken from the sonic by Gardner's law in a column, since the example logs have no density log: with a density log, type the density into the Gardner column in place of its formula. Read the checks: the surface and intermediate seats fail when the next section's mud with the kick margin is over the fracture gradient at the shoe; the window warns where it narrows below the kick margin; the calibration warns when Eaton's line misses a leak-off test by more than the accepted misfit; a blend outside the two muds fails, and a weighted-up system larger than the pits warns. The mud-weight window chart draws pore pressure, the mud program, both fracture gradients and the overburden against depth, and a second chart draws the sonic against its trend.

**Method:** The normal trends are Δtn = Δt0·e^(−c·z) and Rn = R0·e^(b·z). Gardner's density is ρb = A·Vp^B with Vp = 10⁶/Δt ft/s. The overburden at each depth is Sv = Sv0 + 0.433528 ∫ρb dz, a trapezoid between log points, with Sv0 = 0.433528·ρtop·z at the first log depth; its mud weight is Sv/(0.052·z). Eaton's pore pressure, in ppg, is Pp = Sv − (Sv − Pn)(Δtn/Δto)³ from the sonic, or (Ro/Rn)^1.2 from the resistivity. Eaton's fracture gradient is FG = ν/(1 − ν)·(Sv − Pp) + Pp. Matthews and Kelly's is FG = Ki·(Sv − Pp) + Pp, with Ki read at the equivalent depth Di = z·(Sv − Pp)/(Sv − Pn), the depth at which normally pressured rock carries the same matrix stress. Eaton's line is calibrated against two offset leak-off tests. A value at a casing seat or a leak-off test is interpolated linearly between the log points either side of it. Each hole section's mud weight is the largest Pp + trip margin over the section, rounded up to 0.1 ppg, and the window at each depth is Eaton's fracture gradient less the section's mud weight. A leak-off test of result LOT matches Eaton's line at ν = (LOT − Pp)/(Sv + LOT − 2 Pp). A last block weights the intermediate mud up to the production weight with barite and blends a batch from it and a premix. Barite to weight V bbl from W1 to W2 is V (W2 − W1)/(ρa − W2) bbl, or 42 ρa per bbl in lbm, and a blend of Vf bbl at Wf from muds A and B takes Va = Vf (Wf − Wb)/(Wa − Wb).

**Example:** The drilling family's reference well, the one the casing-design and cement-volume sheets use: a vertical onshore well with 13⅜-in. surface casing at 4,000 ft, a 12¼-in. intermediate hole to 10,000 ft cased with 9⅝-in., and an 8½-in. production hole to 13,000 ft. Its shale log runs every 500 ft from 1,000 to 13,000 ft. The sonic trend is 170 e^(−0.00006 z) µs/ft and the resistivity trend 0.6 e^(0.00008 z) ohm·m. Above the log the rock is taken at 1.95 g/cm³, and the normal gradient is 0.465 psi/ft. Eaton's ν is 0.40, and Ki is 0.40 + 0.00003 per foot of equivalent depth. The margins are 0.3 ppg for trips and 0.5 ppg for a kick. The offset leak-off tests read 14.5 ppg at 4,000 ft and 15.3 ppg at 10,000 ft. On hand are 800 bbl of active mud, API barite at 35 ppg, a 16.0 ppg premix, a 400 bbl batch to blend, and 1,000 bbl of pits.

The normal pressure is 0.465/0.052 = 8.94 ppg. The overburden starts at 0.433528 × 1.95 × 1,000 = 845 psi and reaches 18.31 ppg at TD. At 13,000 ft the trend reads 77.9 µs/ft against a measured 98.0, so (77.9/98.0)³ = 0.503 and Pp = 18.31 − 9.37 × 0.503 = 13.60 ppg; Eaton's fracture gradient there is 13.60 + (0.4/0.6)(18.31 − 13.60) = 16.74 ppg. At the intermediate shoe Pp is 10.19 ppg, Eaton's fracture gradient 15.42 ppg and Matthews and Kelly's 15.36 ppg. At the surface shoe Eaton gives 14.41 ppg. The hole sections take 9.3, 10.5 and 13.9 ppg mud. The 13.9 ppg production mud with the 0.5 ppg kick margin, 14.4 ppg, is under the 15.42 ppg at the intermediate shoe, and the 10.5 ppg intermediate mud, 11.0 ppg with the margin, is under the 14.41 ppg at the surface shoe, so both seats hold. The narrowest window is 1.79 ppg, at 10,500 ft, just below the intermediate shoe. Eaton's line misses the 14.5 ppg leak-off test by −0.09 ppg and the 15.3 ppg one by +0.12 ppg, within the 0.3 ppg accepted, and the tests alone would set ν to 0.404 and 0.395. Weighting the 800 bbl from 10.5 to 13.9 ppg takes 189,498 lbm of barite (1,895 sacks) and adds 128.9 bbl, so the system grows to 929 bbl, inside the 1,000 bbl of pits. A 400 bbl batch of 13.9 ppg blends from 152.7 bbl of the active mud and 247.3 bbl of the 16.0 ppg premix.

## Validity

Eaton's method holds for shale under disequilibrium compaction (undercompaction): the log reads overpressure as porosity left in the shale. It under-reads overpressure from unloading (fluid expansion, gas generation, clay diagenesis), where Bowers's unloading method is the alternative; it is not on this sheet. The exponents 3 (sonic) and 1.2 (resistivity) are Eaton's Gulf Coast values and the trends are picked by eye; recalibrate them to measured pressures (RFT, MDT, kicks) where you have them. Gardner's law is for brine-saturated rock and overstates the density of gas sands, salt and anhydrite. The fracture gradients are for a relaxed basin: with tectonic stress use a minimum horizontal stress from a geomechanical model. Eaton's ν is an effective, leak-off-calibrated value, not a log's Poisson's ratio. Matthews and Kelly's Ki comes from their chart for the area; the sheet's straight line in Di is a stand-in to set from that chart. The mud weights are static. The equivalent static density of an HPHT mud column, which changes with temperature and pressure down the hole, is not modelled, and the circulating density is the Drilling Hydraulics and ECD sheet's. The weight-up assumes no mud is dumped and ideal mixing. Vertical well and field units.

## References

- Eaton, B.A. (1975). "The Equation for Geopressure Prediction from Well Logs." SPE-5544.
- Eaton, B.A. (1969). "Fracture Gradient Prediction and Its Application in Oilfield Operations." *Journal of Petroleum Technology* (October).
- Matthews, W.R. and Kelly, J. (1967). "How to Predict Formation Pressure and Fracture Gradient." *Oil and Gas Journal* (20 February).
- Gardner, G.H.F., Gardner, L.W. and Gregory, A.R. (1974). "Formation Velocity and Density — The Diagnostic Basics for Stratigraphic Traps." *Geophysics* 39, 770–780.
- Zhang, J. (2019). *Applied Petroleum Geomechanics*. Gulf Professional Publishing (pore pressure, overburden and fracture gradient).
- Bourgoyne, A.T., Millheim, K.K., Chenevert, M.E. and Young, F.S. (1986). *Applied Drilling Engineering*. SPE Textbook Series Vol. 2, ch. 2 (mud weighting) and ch. 6 (formation and fracture pressure).

## Functions used

`PO.DE.PP.Eaton`, `PO.GM.Density.Gardner`, `PO.GM.Stress.Overburden`, `PO.DE.FG.Eaton`, `PO.DE.FG.MatthewsKelly`, `PO.DE.Mud.WeightUp`, `PO.DE.Mud.Blend`

## Spreadsheet: PorePressureEaton

|     | A                                                                                                                                                                                                                 | B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | C                                                                                                                                                                                                                                                                                                                                                                               | D                                                                 | E                      | F                                               | G                                                                          | H                   | I                                                                                      | J                                | K                                 | L                       | M                                       | N                | O                                                           | P            |
|-----|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------|------------------------|-------------------------------------------------|----------------------------------------------------------------------------|---------------------|----------------------------------------------------------------------------------------|----------------------------------|-----------------------------------|-------------------------|-----------------------------------------|------------------|-------------------------------------------------------------|--------------|
| 1   | Pore Pressure and Mud-Weight Window                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 2   | Blue cells on yellow are inputs. Paste the shale log readings into the table at the foot; the trends, the casing seats and the leak-off tests are above.                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 3   | Logs and Normal-Compaction Trends                                                                                                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 4   | Log the pore pressure is read from: 1 sonic, 2 resistivity                                                                                                                                                        | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                               |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 5   | Normal (hydrostatic) pore-pressure gradient                                                                                                                                                                       | 0.465                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | psi/ft                                                                                                                                                                                                                                                                                                                                                                          |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 6   | Sonic normal trend at the surface, Δtn = Δt0·e^(−c·z)                                                                                                                                                             | 170                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | µs/ft                                                                                                                                                                                                                                                                                                                                                                           |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 7   | Sonic normal trend's decay with depth, c                                                                                                                                                                          | 0.00006                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 1/ft                                                                                                                                                                                                                                                                                                                                                                            |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 8   | Resistivity normal trend at the surface, Rn = R0·e^(b·z)                                                                                                                                                          | 0.6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | ohm·m                                                                                                                                                                                                                                                                                                                                                                           |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 9   | Resistivity normal trend's growth with depth, b                                                                                                                                                                   | 0.00008                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 1/ft                                                                                                                                                                                                                                                                                                                                                                            |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 10  | Bulk density above the first log depth                                                                                                                                                                            | 1.95                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | g/cm³                                                                                                                                                                                                                                                                                                                                                                           |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 11  | Gardner coefficient (velocity in ft/s)                                                                                                                                                                            | 0.23                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                               |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 12  | Gardner exponent                                                                                                                                                                                                  | 0.25                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                               |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 13  | Fracture Gradient                                                                                                                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 14  | Poisson's ratio for Eaton, calibrated to leak-off tests                                                                                                                                                           | 0.4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | —                                                                                                                                                                                                                                                                                                                                                                               |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 15  | Matthews-Kelly Ki at zero equivalent depth                                                                                                                                                                        | 0.4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | —                                                                                                                                                                                                                                                                                                                                                                               |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 16  | Matthews-Kelly Ki's rise per foot of equivalent depth                                                                                                                                                             | 0.00003                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 1/ft                                                                                                                                                                                                                                                                                                                                                                            |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 17  | Casing Seats and Mud Margins                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 18  | Surface casing shoe (TVD)                                                                                                                                                                                         | 4000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | ft                                                                                                                                                                                                                                                                                                                                                                              |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 19  | Intermediate casing shoe (TVD)                                                                                                                                                                                    | 10000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | ft                                                                                                                                                                                                                                                                                                                                                                              |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 20  | Total depth of the production hole (TVD)                                                                                                                                                                          | 13000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | ft                                                                                                                                                                                                                                                                                                                                                                              |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 21  | Trip margin over the pore pressure                                                                                                                                                                                | 0.3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 22  | Kick margin under the fracture gradient                                                                                                                                                                           | 0.5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 24  | Leak-Off Tests (Offset Wells)                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 25  | Depth of leak-off test 1 (TVD)                                                                                                                                                                                    | 4000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | ft                                                                                                                                                                                                                                                                                                                                                                              |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 26  | Leak-off test 1, as an equivalent mud weight                                                                                                                                                                      | 14.5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 27  | Depth of leak-off test 2 (TVD)                                                                                                                                                                                    | 10000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | ft                                                                                                                                                                                                                                                                                                                                                                              |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 28  | Leak-off test 2, as an equivalent mud weight                                                                                                                                                                      | 15.3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 29  | Largest misfit to a leak-off test accepted                                                                                                                                                                        | 0.3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 31  | Mud on Hand                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 32  | Active system at the intermediate mud weight                                                                                                                                                                      | 800                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | bbl                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 33  | Weighting agent density (API barite)                                                                                                                                                                              | 35                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 34  | Weight of the premixed heavy mud in storage                                                                                                                                                                       | 16                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 35  | Batch of production mud to blend                                                                                                                                                                                  | 400                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | bbl                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 36  | Surface pit capacity                                                                                                                                                                                              | 1000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | bbl                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 38  | Overburden and Normal Pressure                                                                                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 39  | Normal pore pressure as a mud weight                                                                                                                                                                              | =PP_Pn/PP_Psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 40  | Overburden at the first log depth                                                                                                                                                                                 | =PP_RhoTop*PP_GccPsi*A87                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | psi                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 41  | Overburden at TD, as a mud weight                                                                                                                                                                                 | =INDEX($H$87:$H$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($H$87:$H$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($H$87:$H$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_TD-INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))                      | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 42  | Log check                                                                                                                                                                                                         | =IF(PP_Mode=1,"PASS",IF(PP_Mode=2,"PASS","FAIL"))                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PP_Mode=1,"pore pressure from the sonic",IF(PP_Mode=2,"pore pressure from the resistivity","enter 1 (sonic) or 2 (resistivity)"))                                                                                                                                                                                                                                           |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 43  | Pore and Fracture Pressure at the Casing Seats                                                                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 44  | Pore pressure at the intermediate shoe                                                                                                                                                                            | =INDEX($I$87:$I$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($I$87:$I$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($I$87:$I$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Shoe2-INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 45  | Pore pressure at TD                                                                                                                                                                                               | =INDEX($I$87:$I$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($I$87:$I$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($I$87:$I$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_TD-INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))                      | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 46  | Fracture gradient at the surface shoe (Eaton)                                                                                                                                                                     | =INDEX($J$87:$J$111,MIN(MATCH(PP_Shoe1,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($J$87:$J$111,MIN(MATCH(PP_Shoe1,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($J$87:$J$111,MIN(MATCH(PP_Shoe1,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Shoe1-INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe1,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe1,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe1,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 47  | Fracture gradient at the intermediate shoe (Eaton)                                                                                                                                                                | =INDEX($J$87:$J$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($J$87:$J$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($J$87:$J$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Shoe2-INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 48  | Intermediate-shoe frac gradient (Matthews-Kelly)                                                                                                                                                                  | =INDEX($M$87:$M$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($M$87:$M$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($M$87:$M$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Shoe2-INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Shoe2,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 49  | Fracture gradient at TD (Eaton)                                                                                                                                                                                   | =INDEX($J$87:$J$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($J$87:$J$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($J$87:$J$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_TD-INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_TD,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))                      | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 50  | Mud Weights and the Window                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 51  | Mud weight, surface hole                                                                                                                                                                                          | =ROUNDUP(MAXIFS($N$87:$N$111,$A$87:$A$111,"<="&PP_Shoe1),1)                                                                                                                                                                                                                                                                                                                                                                                                                                       | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 52  | Mud weight, intermediate hole                                                                                                                                                                                     | =ROUNDUP(MAXIFS($N$87:$N$111,$A$87:$A$111,">"&PP_Shoe1,$A$87:$A$111,"<="&PP_Shoe2),1)                                                                                                                                                                                                                                                                                                                                                                                                             | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 53  | Mud weight, production hole                                                                                                                                                                                       | =ROUNDUP(MAXIFS($N$87:$N$111,$A$87:$A$111,">"&PP_Shoe2,$A$87:$A$111,"<="&PP_TD),1)                                                                                                                                                                                                                                                                                                                                                                                                                | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 54  | Narrowest window, fracture gradient less mud weight                                                                                                                                                               | =MIN($P$87:$P$111)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 55  | Depth of the narrowest window                                                                                                                                                                                     | =INDEX($A$87:$A$111,MATCH(PP_Window,$P$87:$P$111,0))                                                                                                                                                                                                                                                                                                                                                                                                                                              | ft                                                                                                                                                                                                                                                                                                                                                                              |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 56  | Surface seat check                                                                                                                                                                                                | =IF(PP_MW2+PP_Kick<=PP_FgShoe1,"PASS","FAIL")                                                                                                                                                                                                                                                                                                                                                                                                                                                     | =IF(PP_MW2+PP_Kick<=PP_FgShoe1,"the intermediate mud with the kick margin is under the fracture gradient at the surface shoe","the intermediate mud with the kick margin is over the fracture gradient at the surface shoe: set the surface casing deeper")                                                                                                                     |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 57  | Intermediate seat check                                                                                                                                                                                           | =IF(PP_MW3+PP_Kick<=PP_FgShoe,"PASS","FAIL")                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =IF(PP_MW3+PP_Kick<=PP_FgShoe,""&TEXT(PP_MW3,"0.0")&" ppg production mud with the kick margin is under the "&TEXT(PP_FgShoe,"0.0")&" ppg fracture gradient at the intermediate shoe",""&TEXT(PP_MW3,"0.0")&" ppg production mud with the kick margin is over the "&TEXT(PP_FgShoe,"0.0")&" ppg fracture gradient at the intermediate shoe: set the intermediate casing deeper") |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 58  | Window check                                                                                                                                                                                                      | =IF(PP_Window>=PP_Kick,"PASS","WARN")                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(PP_Window>=PP_Kick,"the window is at least the kick margin at every log depth","the window narrows to "&TEXT(PP_Window,"0.00")&" ppg at "&TEXT(PP_WindowZ,"#,##0")&" ft, under the kick margin")                                                                                                                                                                            |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 60  | Calibration to the Leak-Off Tests                                                                                                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 61  | Pore pressure at leak-off test 1                                                                                                                                                                                  | =INDEX($I$87:$I$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($I$87:$I$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($I$87:$I$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Lot1Z-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 62  | Overburden at leak-off test 1                                                                                                                                                                                     | =INDEX($H$87:$H$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($H$87:$H$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($H$87:$H$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Lot1Z-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 63  | Eaton fracture gradient at leak-off test 1                                                                                                                                                                        | =INDEX($J$87:$J$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($J$87:$J$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($J$87:$J$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Lot1Z-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot1Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 64  | Misfit, Eaton less leak-off test 1                                                                                                                                                                                | =PP_Fg1-PP_Lot1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 65  | Poisson's ratio that matches leak-off test 1                                                                                                                                                                      | =(PP_Lot1-PP_Pp1)/(PP_Sv1+PP_Lot1-2*PP_Pp1)                                                                                                                                                                                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                               |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 66  | Pore pressure at leak-off test 2                                                                                                                                                                                  | =INDEX($I$87:$I$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($I$87:$I$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($I$87:$I$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Lot2Z-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 67  | Overburden at leak-off test 2                                                                                                                                                                                     | =INDEX($H$87:$H$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($H$87:$H$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($H$87:$H$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Lot2Z-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 68  | Eaton fracture gradient at leak-off test 2                                                                                                                                                                        | =INDEX($J$87:$J$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))+(INDEX($J$87:$J$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($J$87:$J$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))*(PP_Lot2Z-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)))/(INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1)+1)-INDEX($A$87:$A$111,MIN(MATCH(PP_Lot2Z,$A$87:$A$111,1),ROWS($A$87:$A$111)-1))) | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 69  | Misfit, Eaton less leak-off test 2                                                                                                                                                                                | =PP_Fg2-PP_Lot2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | ppg                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 70  | Poisson's ratio that matches leak-off test 2                                                                                                                                                                      | =(PP_Lot2-PP_Pp2)/(PP_Sv2+PP_Lot2-2*PP_Pp2)                                                                                                                                                                                                                                                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                               |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 71  | Calibration check                                                                                                                                                                                                 | =IF(MAX(ABS(PP_Miss1),ABS(PP_Miss2))<=PP_LotTol,"PASS","WARN")                                                                                                                                                                                                                                                                                                                                                                                                                                    | =IF(MAX(ABS(PP_Miss1),ABS(PP_Miss2))<=PP_LotTol,"Eaton's line is within the accepted misfit of both leak-off tests","Eaton's line misses a leak-off test by more than the accepted misfit: set ν nearer "&TEXT(AVERAGE(PP_NuFit1,PP_NuFit2),"0.00"))                                                                                                                            |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 73  | Weighting Up to the Production Mud                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 74  | Barite (lbm)                                                                                                                                                                                                      | 100 lb sacks (sk)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Volume added (bbl)                                                                                                                                                                                                                                                                                                                                                              | System after (bbl)                                                |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 75  | =INDEX(PO.DE.Mud.WeightUp(PP_Active,PP_MW2,PP_MW3,PP_Barite),1,1)                                                                                                                                                 | =INDEX(PO.DE.Mud.WeightUp(PP_Active,PP_MW2,PP_MW3,PP_Barite),1,2)                                                                                                                                                                                                                                                                                                                                                                                                                                 | =INDEX(PO.DE.Mud.WeightUp(PP_Active,PP_MW2,PP_MW3,PP_Barite),1,3)                                                                                                                                                                                                                                                                                                               | =INDEX(PO.DE.Mud.WeightUp(PP_Active,PP_MW2,PP_MW3,PP_Barite),1,4) |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 77  | Blend: active mud in the batch                                                                                                                                                                                    | =INDEX(PO.DE.Mud.Blend(PP_Batch,PP_MW2,PP_Premix,PP_MW3),1,1)                                                                                                                                                                                                                                                                                                                                                                                                                                     | bbl                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 78  | Blend: premix in the batch                                                                                                                                                                                        | =INDEX(PO.DE.Mud.Blend(PP_Batch,PP_MW2,PP_Premix,PP_MW3),1,2)                                                                                                                                                                                                                                                                                                                                                                                                                                     | bbl                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 79  | Active system after weighting up                                                                                                                                                                                  | =D75                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | bbl                                                                                                                                                                                                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 80  | Blend check                                                                                                                                                                                                       | =IF(AND(PP_BlendA>=0,PP_BlendB>=0),"PASS","FAIL")                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(AND(PP_BlendA>=0,PP_BlendB>=0),"the production weight lies between the active mud and the premix","the production weight is outside the two muds: blend from a heavier premix")                                                                                                                                                                                             |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 81  | Pit check                                                                                                                                                                                                         | =IF(PP_After<=PP_Pits,"PASS","WARN")                                                                                                                                                                                                                                                                                                                                                                                                                                                              | =IF(PP_After<=PP_Pits,"the weighted-up system fits the pits","the weighted-up system overflows the pits: dump "&TEXT(PP_After-PP_Pits,"#,##0")&" bbl before weighting up")                                                                                                                                                                                                      |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 83  | How to use it: paste the shale points' depth, transit time and resistivity from the logs into the table, pick each normal trend over a normally pressured interval, and calibrate ν to the area's leak-off tests. |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 84  | The logs are synthetic: on their trends to 8,000 ft, then slower and more conductive than them through a transition zone.                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 85  | Log, Overburden, Pore and Fracture Pressure by Depth                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 86  | Depth TVD (ft)                                                                                                                                                                                                    | Shale Δt (µs/ft)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Shale Rt (ohm·m)                                                                                                                                                                                                                                                                                                                                                                | Normal Δt (µs/ft)                                                 | Normal Rt (ohm·m)      | Gardner ρb (g/cm³)                              | Overburden (psi)                                                           | Overburden (ppg)    | Pore pressure (ppg)                                                                    | Frac, Eaton (ppg)                | Equivalent depth (ft)             | Ki (—)                  | Frac, M-K (ppg)                         | Mud needed (ppg) | Mud program (ppg)                                           | Window (ppg) |
| 87  | 1000                                                                                                                                                                                                              | 160.1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.65                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A87)                                          | =PP_R0*EXP(PP_RC*A87)  | =PO.GM.Density.Gardner(PP_Mic/B87,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A87,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G87/(PP_Psi*A87)   | =PO.DE.PP.Eaton(H87,PP_PnEmw,IF(PP_Mode=2,C87,B87),IF(PP_Mode=2,E87,D87),PP_Mode)      | =PO.DE.FG.Eaton(H87,I87,PP_Nu)   | =A87*(H87-I87)/(H87-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K87  | =PO.DE.FG.MatthewsKelly(H87,I87,L87)    | =I87+PP_Trip     | =IF(A87<=PP_Shoe1,PP_MW1,IF(A87<=PP_Shoe2,PP_MW2,PP_MW3))   | =J87-O87     |
| 88  | 1500                                                                                                                                                                                                              | 155.4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.68                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A88)                                          | =PP_R0*EXP(PP_RC*A88)  | =PO.GM.Density.Gardner(PP_Mic/B88,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A88,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G88/(PP_Psi*A88)   | =PO.DE.PP.Eaton(H88,PP_PnEmw,IF(PP_Mode=2,C88,B88),IF(PP_Mode=2,E88,D88),PP_Mode)      | =PO.DE.FG.Eaton(H88,I88,PP_Nu)   | =A88*(H88-I88)/(H88-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K88  | =PO.DE.FG.MatthewsKelly(H88,I88,L88)    | =I88+PP_Trip     | =IF(A88<=PP_Shoe1,PP_MW1,IF(A88<=PP_Shoe2,PP_MW2,PP_MW3))   | =J88-O88     |
| 89  | 2000                                                                                                                                                                                                              | 150.8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.7                                                                                                                                                                                                                                                                                                                                                                             | =PP_Dt0*EXP(-PP_DtC*A89)                                          | =PP_R0*EXP(PP_RC*A89)  | =PO.GM.Density.Gardner(PP_Mic/B89,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A89,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G89/(PP_Psi*A89)   | =PO.DE.PP.Eaton(H89,PP_PnEmw,IF(PP_Mode=2,C89,B89),IF(PP_Mode=2,E89,D89),PP_Mode)      | =PO.DE.FG.Eaton(H89,I89,PP_Nu)   | =A89*(H89-I89)/(H89-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K89  | =PO.DE.FG.MatthewsKelly(H89,I89,L89)    | =I89+PP_Trip     | =IF(A89<=PP_Shoe1,PP_MW1,IF(A89<=PP_Shoe2,PP_MW2,PP_MW3))   | =J89-O89     |
| 90  | 2500                                                                                                                                                                                                              | 146.3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.73                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A90)                                          | =PP_R0*EXP(PP_RC*A90)  | =PO.GM.Density.Gardner(PP_Mic/B90,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A90,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G90/(PP_Psi*A90)   | =PO.DE.PP.Eaton(H90,PP_PnEmw,IF(PP_Mode=2,C90,B90),IF(PP_Mode=2,E90,D90),PP_Mode)      | =PO.DE.FG.Eaton(H90,I90,PP_Nu)   | =A90*(H90-I90)/(H90-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K90  | =PO.DE.FG.MatthewsKelly(H90,I90,L90)    | =I90+PP_Trip     | =IF(A90<=PP_Shoe1,PP_MW1,IF(A90<=PP_Shoe2,PP_MW2,PP_MW3))   | =J90-O90     |
| 91  | 3000                                                                                                                                                                                                              | 142                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 0.76                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A91)                                          | =PP_R0*EXP(PP_RC*A91)  | =PO.GM.Density.Gardner(PP_Mic/B91,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A91,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G91/(PP_Psi*A91)   | =PO.DE.PP.Eaton(H91,PP_PnEmw,IF(PP_Mode=2,C91,B91),IF(PP_Mode=2,E91,D91),PP_Mode)      | =PO.DE.FG.Eaton(H91,I91,PP_Nu)   | =A91*(H91-I91)/(H91-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K91  | =PO.DE.FG.MatthewsKelly(H91,I91,L91)    | =I91+PP_Trip     | =IF(A91<=PP_Shoe1,PP_MW1,IF(A91<=PP_Shoe2,PP_MW2,PP_MW3))   | =J91-O91     |
| 92  | 3500                                                                                                                                                                                                              | 137.8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.79                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A92)                                          | =PP_R0*EXP(PP_RC*A92)  | =PO.GM.Density.Gardner(PP_Mic/B92,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A92,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G92/(PP_Psi*A92)   | =PO.DE.PP.Eaton(H92,PP_PnEmw,IF(PP_Mode=2,C92,B92),IF(PP_Mode=2,E92,D92),PP_Mode)      | =PO.DE.FG.Eaton(H92,I92,PP_Nu)   | =A92*(H92-I92)/(H92-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K92  | =PO.DE.FG.MatthewsKelly(H92,I92,L92)    | =I92+PP_Trip     | =IF(A92<=PP_Shoe1,PP_MW1,IF(A92<=PP_Shoe2,PP_MW2,PP_MW3))   | =J92-O92     |
| 93  | 4000                                                                                                                                                                                                              | 133.7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.83                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A93)                                          | =PP_R0*EXP(PP_RC*A93)  | =PO.GM.Density.Gardner(PP_Mic/B93,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A93,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G93/(PP_Psi*A93)   | =PO.DE.PP.Eaton(H93,PP_PnEmw,IF(PP_Mode=2,C93,B93),IF(PP_Mode=2,E93,D93),PP_Mode)      | =PO.DE.FG.Eaton(H93,I93,PP_Nu)   | =A93*(H93-I93)/(H93-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K93  | =PO.DE.FG.MatthewsKelly(H93,I93,L93)    | =I93+PP_Trip     | =IF(A93<=PP_Shoe1,PP_MW1,IF(A93<=PP_Shoe2,PP_MW2,PP_MW3))   | =J93-O93     |
| 94  | 4500                                                                                                                                                                                                              | 129.8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.86                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A94)                                          | =PP_R0*EXP(PP_RC*A94)  | =PO.GM.Density.Gardner(PP_Mic/B94,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A94,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G94/(PP_Psi*A94)   | =PO.DE.PP.Eaton(H94,PP_PnEmw,IF(PP_Mode=2,C94,B94),IF(PP_Mode=2,E94,D94),PP_Mode)      | =PO.DE.FG.Eaton(H94,I94,PP_Nu)   | =A94*(H94-I94)/(H94-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K94  | =PO.DE.FG.MatthewsKelly(H94,I94,L94)    | =I94+PP_Trip     | =IF(A94<=PP_Shoe1,PP_MW1,IF(A94<=PP_Shoe2,PP_MW2,PP_MW3))   | =J94-O94     |
| 95  | 5000                                                                                                                                                                                                              | 125.9                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.9                                                                                                                                                                                                                                                                                                                                                                             | =PP_Dt0*EXP(-PP_DtC*A95)                                          | =PP_R0*EXP(PP_RC*A95)  | =PO.GM.Density.Gardner(PP_Mic/B95,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A95,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G95/(PP_Psi*A95)   | =PO.DE.PP.Eaton(H95,PP_PnEmw,IF(PP_Mode=2,C95,B95),IF(PP_Mode=2,E95,D95),PP_Mode)      | =PO.DE.FG.Eaton(H95,I95,PP_Nu)   | =A95*(H95-I95)/(H95-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K95  | =PO.DE.FG.MatthewsKelly(H95,I95,L95)    | =I95+PP_Trip     | =IF(A95<=PP_Shoe1,PP_MW1,IF(A95<=PP_Shoe2,PP_MW2,PP_MW3))   | =J95-O95     |
| 96  | 5500                                                                                                                                                                                                              | 122.2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.93                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A96)                                          | =PP_R0*EXP(PP_RC*A96)  | =PO.GM.Density.Gardner(PP_Mic/B96,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A96,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G96/(PP_Psi*A96)   | =PO.DE.PP.Eaton(H96,PP_PnEmw,IF(PP_Mode=2,C96,B96),IF(PP_Mode=2,E96,D96),PP_Mode)      | =PO.DE.FG.Eaton(H96,I96,PP_Nu)   | =A96*(H96-I96)/(H96-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K96  | =PO.DE.FG.MatthewsKelly(H96,I96,L96)    | =I96+PP_Trip     | =IF(A96<=PP_Shoe1,PP_MW1,IF(A96<=PP_Shoe2,PP_MW2,PP_MW3))   | =J96-O96     |
| 97  | 6000                                                                                                                                                                                                              | 118.6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 0.97                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A97)                                          | =PP_R0*EXP(PP_RC*A97)  | =PO.GM.Density.Gardner(PP_Mic/B97,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A97,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G97/(PP_Psi*A97)   | =PO.DE.PP.Eaton(H97,PP_PnEmw,IF(PP_Mode=2,C97,B97),IF(PP_Mode=2,E97,D97),PP_Mode)      | =PO.DE.FG.Eaton(H97,I97,PP_Nu)   | =A97*(H97-I97)/(H97-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K97  | =PO.DE.FG.MatthewsKelly(H97,I97,L97)    | =I97+PP_Trip     | =IF(A97<=PP_Shoe1,PP_MW1,IF(A97<=PP_Shoe2,PP_MW2,PP_MW3))   | =J97-O97     |
| 98  | 6500                                                                                                                                                                                                              | 115.1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 1.01                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A98)                                          | =PP_R0*EXP(PP_RC*A98)  | =PO.GM.Density.Gardner(PP_Mic/B98,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A98,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G98/(PP_Psi*A98)   | =PO.DE.PP.Eaton(H98,PP_PnEmw,IF(PP_Mode=2,C98,B98),IF(PP_Mode=2,E98,D98),PP_Mode)      | =PO.DE.FG.Eaton(H98,I98,PP_Nu)   | =A98*(H98-I98)/(H98-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K98  | =PO.DE.FG.MatthewsKelly(H98,I98,L98)    | =I98+PP_Trip     | =IF(A98<=PP_Shoe1,PP_MW1,IF(A98<=PP_Shoe2,PP_MW2,PP_MW3))   | =J98-O98     |
| 99  | 7000                                                                                                                                                                                                              | 111.7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 1.05                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A99)                                          | =PP_R0*EXP(PP_RC*A99)  | =PO.GM.Density.Gardner(PP_Mic/B99,PP_GA,PP_GB)  | =INDEX(PO.GM.Stress.Overburden(A99,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1)  | =G99/(PP_Psi*A99)   | =PO.DE.PP.Eaton(H99,PP_PnEmw,IF(PP_Mode=2,C99,B99),IF(PP_Mode=2,E99,D99),PP_Mode)      | =PO.DE.FG.Eaton(H99,I99,PP_Nu)   | =A99*(H99-I99)/(H99-PP_PnEmw)     | =PP_Ki0+PP_KiSlope*K99  | =PO.DE.FG.MatthewsKelly(H99,I99,L99)    | =I99+PP_Trip     | =IF(A99<=PP_Shoe1,PP_MW1,IF(A99<=PP_Shoe2,PP_MW2,PP_MW3))   | =J99-O99     |
| 100 | 7500                                                                                                                                                                                                              | 108.4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 1.09                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A100)                                         | =PP_R0*EXP(PP_RC*A100) | =PO.GM.Density.Gardner(PP_Mic/B100,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A100,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G100/(PP_Psi*A100) | =PO.DE.PP.Eaton(H100,PP_PnEmw,IF(PP_Mode=2,C100,B100),IF(PP_Mode=2,E100,D100),PP_Mode) | =PO.DE.FG.Eaton(H100,I100,PP_Nu) | =A100*(H100-I100)/(H100-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K100 | =PO.DE.FG.MatthewsKelly(H100,I100,L100) | =I100+PP_Trip    | =IF(A100<=PP_Shoe1,PP_MW1,IF(A100<=PP_Shoe2,PP_MW2,PP_MW3)) | =J100-O100   |
| 101 | 8000                                                                                                                                                                                                              | 105.2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 1.14                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A101)                                         | =PP_R0*EXP(PP_RC*A101) | =PO.GM.Density.Gardner(PP_Mic/B101,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A101,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G101/(PP_Psi*A101) | =PO.DE.PP.Eaton(H101,PP_PnEmw,IF(PP_Mode=2,C101,B101),IF(PP_Mode=2,E101,D101),PP_Mode) | =PO.DE.FG.Eaton(H101,I101,PP_Nu) | =A101*(H101-I101)/(H101-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K101 | =PO.DE.FG.MatthewsKelly(H101,I101,L101) | =I101+PP_Trip    | =IF(A101<=PP_Shoe1,PP_MW1,IF(A101<=PP_Shoe2,PP_MW2,PP_MW3)) | =J101-O101   |
| 102 | 8500                                                                                                                                                                                                              | 102.7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 1.17                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A102)                                         | =PP_R0*EXP(PP_RC*A102) | =PO.GM.Density.Gardner(PP_Mic/B102,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A102,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G102/(PP_Psi*A102) | =PO.DE.PP.Eaton(H102,PP_PnEmw,IF(PP_Mode=2,C102,B102),IF(PP_Mode=2,E102,D102),PP_Mode) | =PO.DE.FG.Eaton(H102,I102,PP_Nu) | =A102*(H102-I102)/(H102-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K102 | =PO.DE.FG.MatthewsKelly(H102,I102,L102) | =I102+PP_Trip    | =IF(A102<=PP_Shoe1,PP_MW1,IF(A102<=PP_Shoe2,PP_MW2,PP_MW3)) | =J102-O102   |
| 103 | 9000                                                                                                                                                                                                              | 100.8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 1.18                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A103)                                         | =PP_R0*EXP(PP_RC*A103) | =PO.GM.Density.Gardner(PP_Mic/B103,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A103,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G103/(PP_Psi*A103) | =PO.DE.PP.Eaton(H103,PP_PnEmw,IF(PP_Mode=2,C103,B103),IF(PP_Mode=2,E103,D103),PP_Mode) | =PO.DE.FG.Eaton(H103,I103,PP_Nu) | =A103*(H103-I103)/(H103-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K103 | =PO.DE.FG.MatthewsKelly(H103,I103,L103) | =I103+PP_Trip    | =IF(A103<=PP_Shoe1,PP_MW1,IF(A103<=PP_Shoe2,PP_MW2,PP_MW3)) | =J103-O103   |
| 104 | 9500                                                                                                                                                                                                              | 99.4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.18                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A104)                                         | =PP_R0*EXP(PP_RC*A104) | =PO.GM.Density.Gardner(PP_Mic/B104,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A104,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G104/(PP_Psi*A104) | =PO.DE.PP.Eaton(H104,PP_PnEmw,IF(PP_Mode=2,C104,B104),IF(PP_Mode=2,E104,D104),PP_Mode) | =PO.DE.FG.Eaton(H104,I104,PP_Nu) | =A104*(H104-I104)/(H104-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K104 | =PO.DE.FG.MatthewsKelly(H104,I104,L104) | =I104+PP_Trip    | =IF(A104<=PP_Shoe1,PP_MW1,IF(A104<=PP_Shoe2,PP_MW2,PP_MW3)) | =J104-O104   |
| 105 | 10000                                                                                                                                                                                                             | 98                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 1.18                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A105)                                         | =PP_R0*EXP(PP_RC*A105) | =PO.GM.Density.Gardner(PP_Mic/B105,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A105,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G105/(PP_Psi*A105) | =PO.DE.PP.Eaton(H105,PP_PnEmw,IF(PP_Mode=2,C105,B105),IF(PP_Mode=2,E105,D105),PP_Mode) | =PO.DE.FG.Eaton(H105,I105,PP_Nu) | =A105*(H105-I105)/(H105-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K105 | =PO.DE.FG.MatthewsKelly(H105,I105,L105) | =I105+PP_Trip    | =IF(A105<=PP_Shoe1,PP_MW1,IF(A105<=PP_Shoe2,PP_MW2,PP_MW3)) | =J105-O105   |
| 106 | 10500                                                                                                                                                                                                             | 98.1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.14                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A106)                                         | =PP_R0*EXP(PP_RC*A106) | =PO.GM.Density.Gardner(PP_Mic/B106,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A106,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G106/(PP_Psi*A106) | =PO.DE.PP.Eaton(H106,PP_PnEmw,IF(PP_Mode=2,C106,B106),IF(PP_Mode=2,E106,D106),PP_Mode) | =PO.DE.FG.Eaton(H106,I106,PP_Nu) | =A106*(H106-I106)/(H106-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K106 | =PO.DE.FG.MatthewsKelly(H106,I106,L106) | =I106+PP_Trip    | =IF(A106<=PP_Shoe1,PP_MW1,IF(A106<=PP_Shoe2,PP_MW2,PP_MW3)) | =J106-O106   |
| 107 | 11000                                                                                                                                                                                                             | 98.9                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.08                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A107)                                         | =PP_R0*EXP(PP_RC*A107) | =PO.GM.Density.Gardner(PP_Mic/B107,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A107,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G107/(PP_Psi*A107) | =PO.DE.PP.Eaton(H107,PP_PnEmw,IF(PP_Mode=2,C107,B107),IF(PP_Mode=2,E107,D107),PP_Mode) | =PO.DE.FG.Eaton(H107,I107,PP_Nu) | =A107*(H107-I107)/(H107-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K107 | =PO.DE.FG.MatthewsKelly(H107,I107,L107) | =I107+PP_Trip    | =IF(A107<=PP_Shoe1,PP_MW1,IF(A107<=PP_Shoe2,PP_MW2,PP_MW3)) | =J107-O107   |
| 108 | 11500                                                                                                                                                                                                             | 99.7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1.02                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A108)                                         | =PP_R0*EXP(PP_RC*A108) | =PO.GM.Density.Gardner(PP_Mic/B108,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A108,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G108/(PP_Psi*A108) | =PO.DE.PP.Eaton(H108,PP_PnEmw,IF(PP_Mode=2,C108,B108),IF(PP_Mode=2,E108,D108),PP_Mode) | =PO.DE.FG.Eaton(H108,I108,PP_Nu) | =A108*(H108-I108)/(H108-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K108 | =PO.DE.FG.MatthewsKelly(H108,I108,L108) | =I108+PP_Trip    | =IF(A108<=PP_Shoe1,PP_MW1,IF(A108<=PP_Shoe2,PP_MW2,PP_MW3)) | =J108-O108   |
| 109 | 12000                                                                                                                                                                                                             | 99.6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.99                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A109)                                         | =PP_R0*EXP(PP_RC*A109) | =PO.GM.Density.Gardner(PP_Mic/B109,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A109,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G109/(PP_Psi*A109) | =PO.DE.PP.Eaton(H109,PP_PnEmw,IF(PP_Mode=2,C109,B109),IF(PP_Mode=2,E109,D109),PP_Mode) | =PO.DE.FG.Eaton(H109,I109,PP_Nu) | =A109*(H109-I109)/(H109-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K109 | =PO.DE.FG.MatthewsKelly(H109,I109,L109) | =I109+PP_Trip    | =IF(A109<=PP_Shoe1,PP_MW1,IF(A109<=PP_Shoe2,PP_MW2,PP_MW3)) | =J109-O109   |
| 110 | 12500                                                                                                                                                                                                             | 99.1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 0.96                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A110)                                         | =PP_R0*EXP(PP_RC*A110) | =PO.GM.Density.Gardner(PP_Mic/B110,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A110,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G110/(PP_Psi*A110) | =PO.DE.PP.Eaton(H110,PP_PnEmw,IF(PP_Mode=2,C110,B110),IF(PP_Mode=2,E110,D110),PP_Mode) | =PO.DE.FG.Eaton(H110,I110,PP_Nu) | =A110*(H110-I110)/(H110-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K110 | =PO.DE.FG.MatthewsKelly(H110,I110,L110) | =I110+PP_Trip    | =IF(A110<=PP_Shoe1,PP_MW1,IF(A110<=PP_Shoe2,PP_MW2,PP_MW3)) | =J110-O110   |
| 111 | 13000                                                                                                                                                                                                             | 98                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 0.96                                                                                                                                                                                                                                                                                                                                                                            | =PP_Dt0*EXP(-PP_DtC*A111)                                         | =PP_R0*EXP(PP_RC*A111) | =PO.GM.Density.Gardner(PP_Mic/B111,PP_GA,PP_GB) | =INDEX(PO.GM.Stress.Overburden(A111,$A$87:$A$111,$F$87:$F$111,PP_Sv0),1,1) | =G111/(PP_Psi*A111) | =PO.DE.PP.Eaton(H111,PP_PnEmw,IF(PP_Mode=2,C111,B111),IF(PP_Mode=2,E111,D111),PP_Mode) | =PO.DE.FG.Eaton(H111,I111,PP_Nu) | =A111*(H111-I111)/(H111-PP_PnEmw) | =PP_Ki0+PP_KiSlope*K111 | =PO.DE.FG.MatthewsKelly(H111,I111,L111) | =I111+PP_Trip    | =IF(A111<=PP_Shoe1,PP_MW1,IF(A111<=PP_Shoe2,PP_MW2,PP_MW3)) | =J111-O111   |
| 113 | Constants                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                 |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 114 | Pressure gradient of 1 ppg of mud                                                                                                                                                                                 | 0.052                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | psi/ft/ppg                                                                                                                                                                                                                                                                                                                                                                      |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 115 | Pressure gradient of 1 g/cm³ of rock                                                                                                                                                                              | 0.433528                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | psi/ft per g/cm³                                                                                                                                                                                                                                                                                                                                                                |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |
| 116 | Microseconds in a second, for velocity from transit time                                                                                                                                                          | 1000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | µs/s                                                                                                                                                                                                                                                                                                                                                                            |                                                                   |                        |                                                 |                                                                            |                     |                                                                                        |                                  |                                   |                         |                                         |                  |                                                             |              |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.DE.PP.Eaton | =LAMBDA(Sv, Pn, Observed, Normal, Mode, LET(ratio, IF(Mode=1, Normal/Observed, Observed/Normal), expo, IF(Mode=1, 3, 1.2), IF(OR(Mode=1, Mode=2), Sv-(Sv-Pn)*ratio^expo, NA()))) | Eaton pore pressure from the ratio of a log to its normal-compaction trend. Mode 1 sonic (exponent 3), Mode 2 resistivity (exponent 1.2). Same unit as Sv and Pn. |
| PO.DE.FG.Eaton | =LAMBDA(Sv, Pp, Nu, Nu/(1-Nu)*(Sv-Pp)+Pp) | Eaton fracture gradient from Poisson's ratio: FG = nu/(1 - nu) (Sv - Pp) + Pp, in the unit of Sv and Pp. |
| PO.DE.FG.MatthewsKelly | =LAMBDA(Sv, Pp, Ki, Ki*(Sv-Pp)+Pp) | Matthews-Kelly fracture gradient from the matrix-stress coefficient: FG = Ki (Sv - Pp) + Pp, in the unit of Sv and Pp. |
| PO.DE.Mud.WeightUp | =LAMBDA(V_bbl, MW_start_ppg, MW_target_ppg, Rho_agent_ppg, LET(added, V_bbl*(MW_target_ppg-MW_start_ppg)/(Rho_agent_ppg-MW_target_ppg), mass, 42*Rho_agent_ppg*added, HSTACK(mass, mass/100, added, V_bbl+added))) | Barite (or another weighting agent) to raise a mud system to a target weight, and the volume it adds: {lb, 100-lb sacks, bbl added, final bbl}. |
| PO.DE.Mud.Blend | =LAMBDA(V_final_bbl, MW_a_ppg, MW_b_ppg, MW_target_ppg, LET(vol_a, V_final_bbl*(MW_target_ppg-MW_b_ppg)/(MW_a_ppg-MW_b_ppg), HSTACK(vol_a, V_final_bbl-vol_a))) | Volumes of a heavy and a light mud that blend to a target weight and final volume: {bbl of mud A, bbl of mud B}. |
| PO.GM.Density.Gardner | =LAMBDA(Vp, A, B, A*Vp^B) | Bulk density from P-wave velocity by Gardner's power law, rho = A Vp^B (g/cc; A 0.23 and B 0.25 with Vp in ft/s). |
| PO.GM.Stress.Overburden | =LAMBDA(Z_ft, TVD_ft, Rho_gcc, Sv0_psi, LET(n, ROWS(TVD_ft), i, SEQUENCE(n), shift, --(i=TRANSPOSE(i)+1), d_prev, MMULT(shift, TVD_ft), r_prev, MMULT(shift, Rho_gcc), d_end, IF(TVD_ft<Z_ft, TVD_ft, Z_ft), width, IF(i>1, IF(d_end>d_prev, d_end-d_prev, 0), 0), r_end, r_prev+(Rho_gcc-r_prev)*IF(TVD_ft>d_prev, (d_end-d_prev)/(TVD_ft-d_prev), 0), d_last, INDEX(TVD_ft, n), tail, IF(Z_ft>d_last, (Z_ft-d_last)*INDEX(Rho_gcc, n), 0), sv, Sv0_psi+0.433528*(SUM(width*(r_prev+r_end)/2)+tail), IF(Z_ft<INDEX(TVD_ft, 1), NA(), HSTACK(sv, sv/Z_ft, sv/Z_ft/0.052)))) | Overburden stress at a depth by integrating a bulk-density log (trapezoids) below the stress at its first depth: {Sv psi, psi/ft, ppg}. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| PP_Mode | $B$4 | Log the pore pressure is read from: 1 sonic, 2 resistivity |
| PP_Pn | $B$5 | Normal (hydrostatic) pore-pressure gradient, psi/ft |
| PP_Dt0 | $B$6 | Sonic normal trend at the surface, Δtn = Δt0·e^(−c·z), µs/ft |
| PP_DtC | $B$7 | Sonic normal trend's decay with depth, c, 1/ft |
| PP_R0 | $B$8 | Resistivity normal trend at the surface, Rn = R0·e^(b·z), ohm·m |
| PP_RC | $B$9 | Resistivity normal trend's growth with depth, b, 1/ft |
| PP_RhoTop | $B$10 | Bulk density above the first log depth, g/cm³ |
| PP_GA | $B$11 | Gardner coefficient (velocity in ft/s) |
| PP_GB | $B$12 | Gardner exponent |
| PP_Nu | $B$14 | Poisson's ratio for Eaton, calibrated to leak-off tests |
| PP_Ki0 | $B$15 | Matthews-Kelly Ki at zero equivalent depth |
| PP_KiSlope | $B$16 | Matthews-Kelly Ki's rise per foot of equivalent depth, 1/ft |
| PP_Shoe1 | $B$18 | Surface casing shoe (TVD), ft |
| PP_Shoe2 | $B$19 | Intermediate casing shoe (TVD), ft |
| PP_TD | $B$20 | Total depth of the production hole (TVD), ft |
| PP_Trip | $B$21 | Trip margin over the pore pressure, ppg |
| PP_Kick | $B$22 | Kick margin under the fracture gradient, ppg |
| PP_Inputs | $B$4:$B$22 | The log the pore pressure is read from, the normal gradient, the two logs' normal-compaction trends, the density above the log, Gardner's constants, the fracture-gradient constants, the casing seats, TD and the two margins |
| PP_Lot1Z | $B$25 | Depth of leak-off test 1 (TVD), ft |
| PP_Lot1 | $B$26 | Leak-off test 1, as an equivalent mud weight, ppg |
| PP_Lot2Z | $B$27 | Depth of leak-off test 2 (TVD), ft |
| PP_Lot2 | $B$28 | Leak-off test 2, as an equivalent mud weight, ppg |
| PP_LotTol | $B$29 | Largest misfit to a leak-off test accepted, ppg |
| PP_Lot_Inputs | $B$25:$B$29 | Two offset leak-off tests, their depths, and the misfit the calibration accepts |
| PP_Active | $B$32 | Active system at the intermediate mud weight, bbl |
| PP_Barite | $B$33 | Weighting agent density (API barite), ppg |
| PP_Premix | $B$34 | Weight of the premixed heavy mud in storage, ppg |
| PP_Batch | $B$35 | Batch of production mud to blend, bbl |
| PP_Pits | $B$36 | Surface pit capacity, bbl |
| PP_Mud_Inputs | $B$32:$B$36 | The active system, the barite, the premix, the blend batch and the pit capacity |
| PP_PnEmw | $B$39 | Normal pore pressure as a mud weight, ppg |
| PP_Sv0 | $B$40 | Overburden at the first log depth, psi |
| PP_SvTD | $B$41 | Overburden at TD, as a mud weight, ppg |
| PP_LogCheck | $B$42 | Log check verdict |
| PP_LogCheckNote | $C$42 | Log check comment |
| PP_PpShoe | $B$44 | Pore pressure at the intermediate shoe, ppg |
| PP_PpTD | $B$45 | Pore pressure at TD, ppg |
| PP_FgShoe1 | $B$46 | Fracture gradient at the surface shoe (Eaton), ppg |
| PP_FgShoe | $B$47 | Fracture gradient at the intermediate shoe (Eaton), ppg |
| PP_MkShoe | $B$48 | Intermediate-shoe frac gradient (Matthews-Kelly), ppg |
| PP_FgTD | $B$49 | Fracture gradient at TD (Eaton), ppg |
| PP_MW1 | $B$51 | Mud weight, surface hole, ppg |
| PP_MW2 | $B$52 | Mud weight, intermediate hole, ppg |
| PP_MW3 | $B$53 | Mud weight, production hole, ppg |
| PP_Window | $B$54 | Narrowest window, fracture gradient less mud weight, ppg |
| PP_WindowZ | $B$55 | Depth of the narrowest window, ft |
| PP_Seat1Check | $B$56 | Surface seat check verdict |
| PP_Seat1CheckNote | $C$56 | Surface seat check comment |
| PP_Seat2Check | $B$57 | Intermediate seat check verdict |
| PP_Seat2CheckNote | $C$57 | Intermediate seat check comment |
| PP_WindowCheck | $B$58 | Window check verdict |
| PP_WindowCheckNote | $C$58 | Window check comment |
| PP_Results | $B$39:$B$58 | The normal pressure, the overburden, the pore pressure and fracture gradients at the casing seats and TD, each hole section's mud weight, the narrowest window and the three checks |
| PP_Pp1 | $B$61 | Pore pressure at leak-off test 1, ppg |
| PP_Sv1 | $B$62 | Overburden at leak-off test 1, ppg |
| PP_Fg1 | $B$63 | Eaton fracture gradient at leak-off test 1, ppg |
| PP_Miss1 | $B$64 | Misfit, Eaton less leak-off test 1, ppg |
| PP_NuFit1 | $B$65 | Poisson's ratio that matches leak-off test 1 |
| PP_Pp2 | $B$66 | Pore pressure at leak-off test 2, ppg |
| PP_Sv2 | $B$67 | Overburden at leak-off test 2, ppg |
| PP_Fg2 | $B$68 | Eaton fracture gradient at leak-off test 2, ppg |
| PP_Miss2 | $B$69 | Misfit, Eaton less leak-off test 2, ppg |
| PP_NuFit2 | $B$70 | Poisson's ratio that matches leak-off test 2 |
| PP_CalCheck | $B$71 | Calibration check verdict |
| PP_CalCheckNote | $C$71 | Calibration check comment |
| PP_Lot_Results | $B$61:$B$71 | The pore pressure, overburden and Eaton fracture gradient at each leak-off test, the misfit, the Poisson's ratio that matches it, and the calibration check |
| PP_WeightUp | $A$75:$D$75 | Barite to weight the active system from the intermediate to the production mud weight: lbm, sacks, volume added, system after |
| PP_BlendA | $B$77 | Blend: active mud in the batch, bbl |
| PP_BlendB | $B$78 | Blend: premix in the batch, bbl |
| PP_After | $B$79 | Active system after weighting up, bbl |
| PP_BlendCheck | $B$80 | Blend check verdict |
| PP_BlendCheckNote | $C$80 | Blend check comment |
| PP_PitCheck | $B$81 | Pit check verdict |
| PP_PitCheckNote | $C$81 | Pit check comment |
| PP_Mud_Results | $B$77:$B$81 | The blend's two volumes, the system after weighting up, and the blend and pit checks |
| PP_Curve | $A$87:$P$111 | Each shale point's depth, transit time and resistivity, the two normal trends, the Gardner density, the overburden, the pore pressure, both fracture gradients, the mud needed, the mud program and the window |
| PP_Psi | $B$114 | Pressure gradient of 1 ppg of mud, psi/ft/ppg |
| PP_GccPsi | $B$115 | Pressure gradient of 1 g/cm³ of rock, psi/ft per g/cm³ |
| PP_Mic | $B$116 | Microseconds in a second, for velocity from transit time, µs/s |

---

## Related Blueprints
- [Surge and Swab Trip Speed](/blueprint/po.de.surge.swab.md)
- [Primary Cement Job Design](/blueprint/po.de.cement.volumes.md)
- [BOP Accumulator Sizing](/blueprint/po.de.wellcontrol.accumulator.md)
- [Casing Design](/blueprint/po.de.casing.design.md)
- [Hole Cleaning and Solids Control](/blueprint/po.de.holecleaning.solids.md)
- [Well Control Kill Sheet](/blueprint/po.de.wellcontrol.killsheet.md)

