---
id: po.wb.de.drilling-program
title: Drilling Program
summary: "What mud weight, flow rate and trip speed each hole section of a vertical well can take, from pore and fracture pressure off a sonic log."
category: Drilling
requires:
  - excel-365
tags:
  - drilling
  - pore-pressure
  - fracture-gradient
  - hydraulics
  - hole-cleaning
  - surge
  - swab
  - mud-weight
---

## Description

What mud weight does each hole section need, will the pumps clean the hole without breaking the shoe down, and how fast can the string be tripped? You enter a shale sonic log and its normal trend, the casing seats and leak-off tests, the hole and string geometry, the Fann readings, flow, nozzles, ROP and stand times. You read off pore and fracture pressure and the mud program by depth, and for the selected section the pump pressure, shoe ECD, cuttings transport and the surge and swab trip-speed limits. Field units; no add-in needed.

**How to use it:** The log and geometry are synthetic. Replace the log, the seats and the leak-off tests on the Pore Pressure sheet, and the geometry and mud on the Sections sheet, with the planned case. Pick Intermediate or Production on the Sections sheet (default Production); the Hydraulics, Hole Cleaning, Surge Swab and Summary sheets show only that section. Set the section's flow and Fann readings on Sections, the nozzles and pump ratings on Hydraulics, the ROP and cleaning limits on Hole Cleaning and the stand times on Surge Swab. Review every verdict on the Summary, which combines all named checks in a fail-closed verdict. For resistivity Eaton, use the pore-pressure blueprint `po.bp.de.pore.pressure.eaton`.

**Method:** The sonic log gives the normal and measured transit times; the pore pressure follows Eaton's compaction method against the normal trend, and the fracture pressure the Eaton and Matthews-Kelly relations on the same log. Mud weights follow the maximum pore gradient over the open interval plus the trip margin, and the leak-off tests calibrate the model against a misfit tolerance. Hydraulics fits a power law to the 600/300-rpm readings and sums pipe, collar, nozzle and annular losses; the shoe ECD uses the losses above the previous shoe. Hole cleaning uses the flow, mud and rheology, with its static cuttings-density estimate kept separate from the ECD. Surge and swab use the same rheology and geometry with Burkhardt displacement over a five-point sweep from 20 to 180 ft/min: shoe surge is checked against the previous shoe's fracture pressure, and the minimum swab mud weight at the shoe, the bit and the drill-pipe/collar boundary against the maximum open-interval pore gradient. Segment geometry is constant and friction varies linearly with depth, so those boundaries hold the equivalent-mud-weight extrema. The sweep interpolates the speed limit, returns zero if no sample is safe and caps the limit at the highest sample if all are safe. Surface has pore and mud results only: the reference well has no surface-hole diameter or string, so surface hydraulics are not modelled.

**Example:** The 12.25-in intermediate hole spans 4,000–10,000 ft below 12.347-in ID surface casing; the 8.5-in production hole spans 10,000–13,000 ft below 9.625-in casing, 8.681-in ID to 8,000 ft and 8.535-in ID to the shoe. Each assumes 5-in drill pipe, 600 ft of collars and the bit at section TD; these are not measured operational data. The program gives 9.3 ppg surface mud, 10.5 ppg intermediate mud and 13.9 ppg production mud, with the pore limit at the maximum Eaton gradient over each open interval.

## Validity

The log and geometry are synthetic, not independent field validation. Surface-hole hydraulics are not modelled; the reference well gives no surface hole or string. Eaton's compaction method can under-read unloading; Gardner is unreliable in gas sands, salt and anhydrite. Replace and calibrate the log and fracture model to local data. The well is vertical; ECD excludes cuttings loading, gels, acceleration, temperature and transients. The steady-state tripping model is not a transient surge simulation. Cuttings transport and the density-limited ROP are screening estimates, not a coupled multiphase model. Validate a real program with the operator's approved methods.

Named alternatives, which the workbook does not compute and the add-in has no functions for: Herschel-Bulkley pipe and annulus losses, pump optimisation (nozzles and flow rate for maximum bit hydraulic horsepower or impact force), cuttings bed height in deviated hole, a dynamic surge model, Bowers's unloading pore pressure and the HPHT equivalent static density of the mud column.

## 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.
- Matthews, W.R. and Kelly, J. (1967). “How to Predict Formation Pressure and Fracture Gradient.” Oil and Gas Journal.
- Bourgoyne, A.T. et al. (1986). *Applied Drilling Engineering*. SPE Textbook Series Vol. 2, chapters 6 and 7.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| Surface sonic trend, sonic trend decay | µs/ft, 1/ft | 170, 0.00006 | `DPW_Dt0`, `DPW_DtC` |
| Surface shoe TVD, intermediate shoe TVD, production TD TVD | ft | 4000, 10000, 13000 | `DPW_Shoe1`, `DPW_Shoe2`, `DPW_TD` |
| Trip margin, kick margin | ppg | 0.3, 0.5 | `DPW_Trip`, `DPW_Kick` |
| Poisson ratio, first and second test equivalent weight | —, ppg, ppg | 0.4, 14.5, 15.3 | `DPW_Nu`, `DPW_Lot1`, `DPW_Lot2` |
| Open-hole diameter, intermediate and production | in | 12.25, 8.5 | `DSI_Hole`, `DSP_Hole` |
| Section to evaluate: Intermediate or Production | — | Production | `DP_Section` |
| Flow rate, intermediate and production | gpm | 500 each | `DSI_Q`, `DSP_Q` |
| Fann 600 rpm and Fann 300 rpm, per section (fit n and K) | lb/100 ft² | 58, 36 each section | `DSI_R600`, `DSI_R300`, `DSP_R600`, `DSP_R300` |
| Planned ROP | ft/h | 90 | `DC_ROP` |
| Run time per stand, pull time per stand | s | 45, 75 | `DT_TimeIn`, `DT_TimeOut` |

`DH_Q`, `DH_R600`, and `DH_R300` are calculated projections of the selected section, not editable inputs.

## Sheets

- `Guide` — what the workbook answers and the order to work through its sheets.
- `Pore Pressure` — the sonic log, Eaton's pore pressure, Gardner's overburden, Eaton's and Matthews-Kelly's fracture pressure calibrated to two leak-off tests, and the mud program, charted against depth.
- `Sections` — the section picker, and for the intermediate and production holes the previous casing, the open hole, the string, the section mud weight, the pressure limits and each section's flow and Fann readings.
- `Hydraulics` — for the selected section, the power-law fit, pipe, collar, nozzle and annular losses, pump pressure and power against the pump ratings, and the shoe ECD.
- `Hole Cleaning` — for the selected section, annular velocity, cuttings transport ratio and concentration, solids content, and the highest ROP the density limit allows.
- `Surge Swab` — for the selected section, Burkhardt surge and swab over a sweep of trip speeds, the shoe surge against fracture and the swab against pore pressure, and the trip-speed limits.
- `Summary` — the selected section's answers and every check under one fail-closed verdict.
- `Test Cases` — the worked example and other cases, with expected and computed results.

One chart: pore, fracture and mud weight against depth.

## Functions used

Catalog LAMBDAs for Eaton pore and fracture pressure, Matthews-Kelly fracture, Gardner density, overburden integration, power-law pipe and annular friction, nozzle hydraulics, ECD, cuttings transport, solids and Burkhardt displacement. All travel with the workbook.
