---
cid: po.bp.de.cement.volumes
hub: de
tags: [drilling, cementing, slurry-volume, excess, sacks, mix-water, displacement, pump-strokes, bump-plug, lead, tail, spacer, thickening-time, fracture-gradient]
facets: { discipline: drilling, property: cementing, method-type: analytical }
title: Primary Cement Job Design
summary: "How much cement and displacement a two-slurry primary cement job takes, and whether the placed column breaks the formation down."
slug: po.de.cement.volumes
type: worksheet
---

# Primary Cement Job Design

## Description

How much cement does a two-slurry primary cement job take, how many strokes bump the plug, and will the column break the formation down? You enter the hole and casing, the lead and tail slurries and the spacer, the mud, the pump and the limits. You read off each slurry's volume, sacks and mix water, the displacement and strokes to bump, the bump pressure against the burst rating, and the annulus pressure at the end of placement against the fracture and pore pressure.

**Parameters:**
- **Hole and casing**: the open hole `CMT_Hole`, the casing OD `CMT_OD`, its ID above and below the crossover `CMT_IdTop`/`CMT_IdBot`, and the previous casing's ID `CMT_PrevId` (in); the crossover `CMT_Xover`, the float collar `CMT_FC`, the shoe `CMT_Shoe` and the previous shoe `CMT_PrevShoe` (ft)
- **Slurries and spacer**: the tops of the lead and the tail `CMT_LeadTop`, `CMT_TailTop` (ft), their open-hole excess `CMT_LeadEx`, `CMT_TailEx`, density `CMT_LeadW`, `CMT_TailW` (ppg), yield `CMT_LeadY`, `CMT_TailY` (ft³/sk) and mix water `CMT_LeadWat`, `CMT_TailWat` (gal/sk); the spacer's volume `CMT_SpV` (bbl) and density `CMT_SpW` (ppg)
- **Mud, pump and limits**: the mud `CMT_MW` (ppg), the pump output `CMT_PumpOut` (bbl/stk), the surface lines `CMT_Lines` (bbl), the rate `CMT_Rate` (bbl/min), the bump overpressure `CMT_Bump` (psi), the fracture and pore pressure at the shoe and at the top of the open hole `CMT_FgShoe`, `CMT_FgTop`, `CMT_PpShoe`, `CMT_PpTop` (ppg), the thickening times `CMT_LeadTT`, `CMT_TailTT` and the margin under them `CMT_TTMargin` (min), and the casing's burst rating `CMT_Pburst` (psi) and design factor `CMT_DFb`

**How to use it:** The slurries are made up for the example. Take each slurry's density, yield, mix water and thickening time from the lab's slurry report for this job's temperature, and the hole size from a caliper: with a caliper average for the hole, cut the excess to what the caliper does not see. Take the fracture gradient from the shoe test above and the pore-pressure sheet below, and the pump output from the rig's pump at its running efficiency. The lead and the tail are sized one volume each, with the open hole and its excess, the overlap inside the previous casing and the shoe track, and their sacks and mix water follow from each slurry's yield and water. The displacement runs to the float collar through a tapered string. The job time is set against each slurry's thickening time. The annulus pressure at the end of placement, the highest static pressure the open hole sees while the heavier slurries go in, is checked against the fracture gradient at the shoe and at the top of the open hole, and against the pore pressure at the shoe: the column fails at or over the fracture gradient at either point, and under the pore pressure at the shoe. A slurry that is not in place a margin before its thickening time fails, and so does a bump pressure over the casing's burst rating divided by its design factor. A depth chart draws the annulus column at each fluid boundary against the mud alone and the open hole's fracture and pore pressure.

**Method:** Each slurry's volume is a capacity times a length: (Dh² − OD²)/1029.4 bbl/ft for the open hole, times (1 + excess); (IDprev² − OD²)/1029.4 for the overlap; and ID²/1029.4 for the shoe track. The lead fills the open hole from the tail's top up to the previous shoe and the overlap above it, and the tail fills the open hole from the shoe to its top, plus the shoe track. Sacks are the volume × 5.6146 ft³/bbl over the yield, and mix water the sacks × water over 42 gal/bbl. The displacement is the upper bore, IDupper²/1029.4 × crossover depth, plus the lower bore to the float collar and the lines, which the cement displacement function takes as its extra volume; the strokes are that over the pump output. The spacer rises above the lead in the cased annulus, a height of its volume over (IDprev² − OD²)/1029.4. At the end of placement the annulus holds, from the top, mud, spacer, lead and tail, each at its height for a gauge hole. Its pressure at each boundary is the sum of 0.052 × density × height above. Inside the casing is mud to the float collar and tail in the shoe track. The final pump pressure is the static difference between the annulus and the inside at the shoe, and the bump pressure adds the bump overpressure. The lead is pumped from the start, so its exposure is the whole job, spacer to bump, at the rate; the tail's runs from its own start. The fracture and pore pressure across the open hole are drawn as a mud weight straight between the two shoes.

**Example:** The drilling family's reference well, the one the pore-pressure and casing-design sheets use: the 9⅝-in. string of the casing sheet, 47 lb/ft (ID 8.681 in.) above 53.5 lb/ft (ID 8.535 in.) from 8,000 ft, in a 12¼-in. hole from below the 13⅜-in. 72 lb/ft surface shoe (ID 12.347 in.) at 4,000 ft to the shoe at 10,000 ft, with the float collar at 9,920 ft. The lead rises from 8,000 ft to 3,500 ft, 500 ft inside the surface casing, at 50 % excess; the tail fills the last 2,000 ft at 30 % excess and the 80 ft shoe track. The lead is 12.5 ppg (2.10 ft³/sk, 11.9 gal/sk) and the tail 15.8 ppg (1.15 ft³/sk, 5.0 gal/sk), behind 40 bbl of 11.5 ppg spacer, and the job is displaced with the 10.5 ppg intermediate mud at 8 bbl/min through 2 bbl of lines with a 0.1 bbl/stk pump. The plug is bumped 500 psi over the final pressure. The pore-pressure sheet gives 15.4 ppg of fracture gradient and 10.2 ppg of pore pressure at the shoe. At the surface shoe the offset leak-off test is 14.5 ppg and the pore pressure 8.9 ppg. The thickening times are 300 min for the lead and 210 min for the tail, kept 60 min clear, and the upper casing bursts at 9,440 psi with a design factor of 1.1.

The lead takes 334.7 bbl of open hole at 50 % excess and 29.0 bbl of overlap, 363.7 bbl or 973 sacks. The tail takes 145.0 bbl at 30 % and 5.7 bbl of shoe track, 150.7 bbl or 736 sacks. Together they need 363 bbl of mix water. Displacement is 585.7 bbl down the upper bore, 135.9 bbl down the lower bore to the collar and 2 bbl of lines, 723.5 bbl or 7,235 strokes. The spacer stands 688 ft tall above the lead. At the end of the job the annulus puts 6,515 psi on the shoe, 12.53 ppg against a 15.4 ppg fracture gradient and 10.2 ppg of pore pressure. At the top of the open hole it is 10.92 ppg against the 14.5 ppg leak-off test. Inside, mud to the collar and tail in the shoe track make 5,482 psi, so the final pump pressure is 1,033 psi and the plug bumps at 1,533 psi, well under the 9,440 psi burst rating over 1.1. The whole job takes 160 min at 8 bbl/min, and the tail is in place 109 min after it starts, both inside their thickening times by more than the 60 min margin.

## Validity

The volumes are for a gauge hole plus a flat excess, and the excess fills washouts, so the tops of cement in the column are where the design puts them, not where an enlarged hole would. The pressures are static: friction while pumping adds to the annulus pressure (the circulating density), and the free fall of heavy cement down the casing (the U-tube) can run the pumps ahead of the returns; the dynamic U-tube is not modelled. The end of placement is the highest static pressure the open hole sees when every slurry is heavier than the mud it displaces. Centraliser spacing to API 10D is not covered. Cement's loss of hydrostatic pressure as it gels (a flow risk after placement) is not modelled. The fracture and pore pressure between the shoes are straight lines in mud weight; for a full profile use the Pore Pressure and Mud-Weight Window sheet. Mud compressibility and casing ballooning in the displacement are left out. Vertical well and field units.

## References

- Nelson, E.B. and Guillot, D. (eds.) (2006). *Well Cementing*, 2nd ed. Schlumberger (job design volumes, displacement and plug bumping, placement pressures).
- Bourgoyne, A.T., Millheim, K.K., Chenevert, M.E. and Young, F.S. (1986). *Applied Drilling Engineering*. SPE Textbook Series Vol. 2, ch. 3 (cementing).
- Lapeyrouse, N.J. (2002). *Formulas and Calculations for Drilling, Production and Workover*, 2nd ed. Gulf Professional Publishing, ch. 4 (cementing calculations).

## Functions used

`PO.DE.Cement.Volume`, `PO.DE.Cement.Displacement`, `PO.DE.PipeCapacity`, `PO.DE.AnnularCapacity`, `PO.DE.Hydrostatic`

## Spreadsheet: CementVolumes

|    | A                                                                                                                                                                                                           | B                                                                                                                                                            | C                                                                                                                                                                                                                                                                        | D                                                                                                                                                            | E                                                                                                                                                            | F                                         |
|----|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------|
| 1  | Primary Cement Job Design                                                                                                                                                                                   |                                                                                                                                                              | Petroleum Office                                                                                                                                                                                                                                                         |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 2  | Blue cells on yellow are inputs. Enter the hole and casing, the two slurries and where they sit, and the mud, pump and limits.                                                                              |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 3  | Hole and Casing                                                                                                                                                                                             |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 4  | Open-hole diameter (bit size)                                                                                                                                                                               | 12.25                                                                                                                                                        | in                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 5  | Casing outside diameter                                                                                                                                                                                     | 9.625                                                                                                                                                        | in                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 6  | Casing inside diameter above the crossover                                                                                                                                                                  | 8.681                                                                                                                                                        | in                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 7  | Casing inside diameter below it, to the shoe                                                                                                                                                                | 8.535                                                                                                                                                        | in                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 8  | Crossover depth                                                                                                                                                                                             | 8000                                                                                                                                                         | ft                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 9  | Float collar depth                                                                                                                                                                                          | 9920                                                                                                                                                         | ft                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 10 | Casing shoe depth                                                                                                                                                                                           | 10000                                                                                                                                                        | ft                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 11 | Previous casing's inside diameter                                                                                                                                                                           | 12.347                                                                                                                                                       | in                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 12 | Previous casing's shoe, the top of the open hole                                                                                                                                                            | 4000                                                                                                                                                         | ft                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 13 | Slurries and Spacer                                                                                                                                                                                         |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 14 | Top of the lead slurry, the top of cement                                                                                                                                                                   | 3500                                                                                                                                                         | ft                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 15 | Top of the tail slurry                                                                                                                                                                                      | 8000                                                                                                                                                         | ft                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 16 | Lead slurry's open-hole excess                                                                                                                                                                              | 0.5                                                                                                                                                          | %                                                                                                                                                                                                                                                                        |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 17 | Tail slurry's open-hole excess                                                                                                                                                                              | 0.3                                                                                                                                                          | %                                                                                                                                                                                                                                                                        |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 18 | Lead slurry density                                                                                                                                                                                         | 12.5                                                                                                                                                         | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 19 | Lead slurry yield                                                                                                                                                                                           | 2.1                                                                                                                                                          | ft³/sk                                                                                                                                                                                                                                                                   |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 20 | Lead mix water                                                                                                                                                                                              | 11.9                                                                                                                                                         | gal/sk                                                                                                                                                                                                                                                                   |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 21 | Tail slurry density                                                                                                                                                                                         | 15.8                                                                                                                                                         | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 22 | Tail slurry yield                                                                                                                                                                                           | 1.15                                                                                                                                                         | ft³/sk                                                                                                                                                                                                                                                                   |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 23 | Tail mix water                                                                                                                                                                                              | 5                                                                                                                                                            | gal/sk                                                                                                                                                                                                                                                                   |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 24 | Spacer pumped ahead of the lead                                                                                                                                                                             | 40                                                                                                                                                           | bbl                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 25 | Spacer density                                                                                                                                                                                              | 11.5                                                                                                                                                         | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 26 | Mud, Pump and Limits                                                                                                                                                                                        |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 27 | Mud in the hole, and the displacement fluid                                                                                                                                                                 | 10.5                                                                                                                                                         | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 28 | Pump output at the running efficiency                                                                                                                                                                       | 0.1                                                                                                                                                          | bbl/stk                                                                                                                                                                                                                                                                  |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 29 | Surface lines to the cement head                                                                                                                                                                            | 2                                                                                                                                                            | bbl                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 30 | Mixing and displacement rate                                                                                                                                                                                | 8                                                                                                                                                            | bbl/min                                                                                                                                                                                                                                                                  |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 31 | Pressure over the final pressure to bump the plug                                                                                                                                                           | 500                                                                                                                                                          | psi                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 32 | Fracture gradient at the shoe (pore-pressure sheet)                                                                                                                                                         | 15.4                                                                                                                                                         | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 33 | Fracture gradient at the top of the open hole (leak-off test)                                                                                                                                               | 14.5                                                                                                                                                         | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 34 | Pore pressure at the shoe (pore-pressure sheet)                                                                                                                                                             | 10.2                                                                                                                                                         | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 35 | Pore pressure at the top of the open hole                                                                                                                                                                   | 8.9                                                                                                                                                          | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 36 | Lead slurry's thickening time                                                                                                                                                                               | 300                                                                                                                                                          | min                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 37 | Tail slurry's thickening time                                                                                                                                                                               | 210                                                                                                                                                          | min                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 38 | Margin kept under the thickening time                                                                                                                                                                       | 60                                                                                                                                                           | min                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 39 | Burst rating of the upper section (casing sheet)                                                                                                                                                            | 9440                                                                                                                                                         | psi                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 40 | Minimum burst design factor                                                                                                                                                                                 | 1.1                                                                                                                                                          | —                                                                                                                                                                                                                                                                        |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 42 | Slurry Volumes                                                                                                                                                                                              |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 43 | Slurry                                                                                                                                                                                                      | Total (bbl)                                                                                                                                                  | Open hole (bbl)                                                                                                                                                                                                                                                          | Overlap (bbl)                                                                                                                                                | Shoe track (bbl)                                                                                                                                             |                                           |
| 44 | Lead                                                                                                                                                                                                        | =INDEX(PO.DE.Cement.Volume(CMT_Hole,CMT_OD,CMT_IdBot,CMT_PrevId,CMT_TailTop-MAX(CMT_LeadTop,CMT_PrevShoe),MAX(0,CMT_PrevShoe-CMT_LeadTop),0,CMT_LeadEx),1,1) | =INDEX(PO.DE.Cement.Volume(CMT_Hole,CMT_OD,CMT_IdBot,CMT_PrevId,CMT_TailTop-MAX(CMT_LeadTop,CMT_PrevShoe),MAX(0,CMT_PrevShoe-CMT_LeadTop),0,CMT_LeadEx),1,2)                                                                                                             | =INDEX(PO.DE.Cement.Volume(CMT_Hole,CMT_OD,CMT_IdBot,CMT_PrevId,CMT_TailTop-MAX(CMT_LeadTop,CMT_PrevShoe),MAX(0,CMT_PrevShoe-CMT_LeadTop),0,CMT_LeadEx),1,3) | =INDEX(PO.DE.Cement.Volume(CMT_Hole,CMT_OD,CMT_IdBot,CMT_PrevId,CMT_TailTop-MAX(CMT_LeadTop,CMT_PrevShoe),MAX(0,CMT_PrevShoe-CMT_LeadTop),0,CMT_LeadEx),1,4) |                                           |
| 45 | Tail                                                                                                                                                                                                        | =INDEX(PO.DE.Cement.Volume(CMT_Hole,CMT_OD,CMT_IdBot,CMT_PrevId,CMT_Shoe-CMT_TailTop,0,CMT_Shoe-CMT_FC,CMT_TailEx),1,1)                                      | =INDEX(PO.DE.Cement.Volume(CMT_Hole,CMT_OD,CMT_IdBot,CMT_PrevId,CMT_Shoe-CMT_TailTop,0,CMT_Shoe-CMT_FC,CMT_TailEx),1,2)                                                                                                                                                  | =INDEX(PO.DE.Cement.Volume(CMT_Hole,CMT_OD,CMT_IdBot,CMT_PrevId,CMT_Shoe-CMT_TailTop,0,CMT_Shoe-CMT_FC,CMT_TailEx),1,3)                                      | =INDEX(PO.DE.Cement.Volume(CMT_Hole,CMT_OD,CMT_IdBot,CMT_PrevId,CMT_Shoe-CMT_TailTop,0,CMT_Shoe-CMT_FC,CMT_TailEx),1,4)                                      |                                           |
| 47 | Sacks and Mix Water                                                                                                                                                                                         |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 48 | Lead slurry                                                                                                                                                                                                 | =B44                                                                                                                                                         | bbl                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 49 | Lead sacks                                                                                                                                                                                                  | =CMT_LeadV*CMT_Ft3Bbl/CMT_LeadY                                                                                                                              | sk                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 50 | Tail slurry                                                                                                                                                                                                 | =B45                                                                                                                                                         | bbl                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 51 | Tail sacks                                                                                                                                                                                                  | =CMT_TailV*CMT_Ft3Bbl/CMT_TailY                                                                                                                              | sk                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 52 | Mix water, both slurries                                                                                                                                                                                    | =(CMT_LeadSk*CMT_LeadWat+CMT_TailSk*CMT_TailWat)/CMT_GalBbl                                                                                                  | bbl                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 53 | Displacement and Plug Bump                                                                                                                                                                                  |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 54 | Lower section's bore, crossover to the float collar                                                                                                                                                         | =PO.DE.PipeCapacity(CMT_IdBot)*(CMT_FC-CMT_Xover)                                                                                                            | bbl                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 55 | Displacement to the float collar                                                                                                                                                                            | =INDEX(PO.DE.Cement.Displacement(CMT_IdTop,CMT_Xover,CMT_Lines+CMT_BoreLow,CMT_PumpOut),1,1)                                                                 | bbl                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 56 | Strokes to bump the plug                                                                                                                                                                                    | =INDEX(PO.DE.Cement.Displacement(CMT_IdTop,CMT_Xover,CMT_Lines+CMT_BoreLow,CMT_PumpOut),1,2)                                                                 | stk                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 57 | Spacer height above the lead (cased annulus)                                                                                                                                                                | =CMT_SpV/PO.DE.AnnularCapacity(CMT_PrevId,CMT_OD)                                                                                                            | ft                                                                                                                                                                                                                                                                       |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 58 | Annulus pressure at the shoe at the end of the job                                                                                                                                                          | =F82                                                                                                                                                         | psi                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 59 | Pressure inside at the shoe: mud to the collar, tail below                                                                                                                                                  | =PO.DE.Hydrostatic(CMT_MW,CMT_FC)+PO.DE.Hydrostatic(CMT_TailW,CMT_Shoe-CMT_FC)                                                                               | psi                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 60 | Final pump pressure (static, no friction)                                                                                                                                                                   | =CMT_Pann-CMT_Pin                                                                                                                                            | psi                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 61 | Plug-bump pressure                                                                                                                                                                                          | =CMT_Pfinal+CMT_Bump                                                                                                                                         | psi                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 62 | Job time, spacer to bump (the lead's exposure)                                                                                                                                                              | =(CMT_SpV+CMT_LeadV+CMT_TailV+CMT_DispV)/CMT_Rate                                                                                                            | min                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 63 | Job time, tail to bump (the tail's exposure)                                                                                                                                                                | =(CMT_TailV+CMT_DispV)/CMT_Rate                                                                                                                              | min                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 64 | Annulus at the End of Placement                                                                                                                                                                             |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 65 | Equivalent mud weight at the shoe                                                                                                                                                                           | =CMT_Pann/(CMT_Psi*CMT_Shoe)                                                                                                                                 | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 66 | Equivalent mud weight at the top of the open hole                                                                                                                                                           | =F80/(CMT_Psi*CMT_PrevShoe)                                                                                                                                  | ppg                                                                                                                                                                                                                                                                      |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 67 | Fracture check at the shoe                                                                                                                                                                                  | =IF(CMT_EmwShoe<CMT_FgShoe,"PASS","FAIL")                                                                                                                    | =IF(CMT_EmwShoe<CMT_FgShoe,""&TEXT(CMT_EmwShoe,"0.00")&" ppg at the shoe is under its "&TEXT(CMT_FgShoe,"0.0")&" ppg fracture gradient",""&TEXT(CMT_EmwShoe,"0.00")&" ppg at the shoe is at or over its fracture gradient: lighten the lead or lower the top of cement") |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 68 | Fracture check at the top of the open hole                                                                                                                                                                  | =IF(CMT_EmwTop<CMT_FgTop,"PASS","FAIL")                                                                                                                      | =IF(CMT_EmwTop<CMT_FgTop,"the top of the open hole stays under its fracture gradient","the top of the open hole reaches its fracture gradient: lighten the lead")                                                                                                        |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 69 | Overbalance check                                                                                                                                                                                           | =IF(CMT_EmwShoe>CMT_PpShoe,"PASS","FAIL")                                                                                                                    | =IF(CMT_EmwShoe>CMT_PpShoe,"the column stays over the pore pressure at the shoe","the column is under the pore pressure at the shoe: the well can flow as the cement sets")                                                                                              |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 70 | Thickening time check                                                                                                                                                                                       | =IF(AND(CMT_LeadTime<=CMT_LeadTT-CMT_TTMargin,CMT_TailTime<=CMT_TailTT-CMT_TTMargin),"PASS","FAIL")                                                          | =IF(AND(CMT_LeadTime<=CMT_LeadTT-CMT_TTMargin,CMT_TailTime<=CMT_TailTT-CMT_TTMargin),"both slurries are in place with the margin to spare","a slurry can set before it is in place: retard it or pump faster")                                                           |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 71 | Bump check                                                                                                                                                                                                  | =IF(CMT_Pbump<=CMT_Pburst/CMT_DFb,"PASS","FAIL")                                                                                                             | =IF(CMT_Pbump<=CMT_Pburst/CMT_DFb,"the bump pressure is under the casing's burst rating over its design factor","the bump pressure is over the casing's burst rating over its design factor: bump with less")                                                            |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 73 | How to use it: take the hole size from a caliper (and cut the excess), the slurry densities, yields, water and thickening times from the lab's slurry report, and the fracture gradient from the shoe test. |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 74 | The slurries' tops are for a gauge hole; the excess fills washouts. The column is static: friction adds to the pressures while pumping.                                                                     |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 75 | Annulus Pressure at the End of Placement                                                                                                                                                                    |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 76 | Point                                                                                                                                                                                                       | Depth TVD (ft)                                                                                                                                               | Mud alone (psi)                                                                                                                                                                                                                                                          | Fracture (psi)                                                                                                                                               | Pore (psi)                                                                                                                                                   | Annulus (psi)                             |
| 77 | Surface                                                                                                                                                                                                     | =0                                                                                                                                                           | =PO.DE.Hydrostatic(CMT_MW,B77)                                                                                                                                                                                                                                           |                                                                                                                                                              |                                                                                                                                                              | =0                                        |
| 78 | Top of spacer                                                                                                                                                                                               | =CMT_LeadTop-CMT_SpH                                                                                                                                         | =PO.DE.Hydrostatic(CMT_MW,B78)                                                                                                                                                                                                                                           |                                                                                                                                                              |                                                                                                                                                              | =F77+PO.DE.Hydrostatic(CMT_MW,B78-B77)    |
| 79 | Top of lead                                                                                                                                                                                                 | =CMT_LeadTop                                                                                                                                                 | =PO.DE.Hydrostatic(CMT_MW,B79)                                                                                                                                                                                                                                           |                                                                                                                                                              |                                                                                                                                                              | =F78+PO.DE.Hydrostatic(CMT_SpW,B79-B78)   |
| 80 | Previous shoe                                                                                                                                                                                               | =CMT_PrevShoe                                                                                                                                                | =PO.DE.Hydrostatic(CMT_MW,B80)                                                                                                                                                                                                                                           | =CMT_Psi*B80*(CMT_FgTop+(CMT_FgShoe-CMT_FgTop)*(B80-CMT_PrevShoe)/(CMT_Shoe-CMT_PrevShoe))                                                                   | =CMT_Psi*B80*(CMT_PpTop+(CMT_PpShoe-CMT_PpTop)*(B80-CMT_PrevShoe)/(CMT_Shoe-CMT_PrevShoe))                                                                   | =F79+PO.DE.Hydrostatic(CMT_LeadW,B80-B79) |
| 81 | Top of tail                                                                                                                                                                                                 | =CMT_TailTop                                                                                                                                                 | =PO.DE.Hydrostatic(CMT_MW,B81)                                                                                                                                                                                                                                           | =CMT_Psi*B81*(CMT_FgTop+(CMT_FgShoe-CMT_FgTop)*(B81-CMT_PrevShoe)/(CMT_Shoe-CMT_PrevShoe))                                                                   | =CMT_Psi*B81*(CMT_PpTop+(CMT_PpShoe-CMT_PpTop)*(B81-CMT_PrevShoe)/(CMT_Shoe-CMT_PrevShoe))                                                                   | =F80+PO.DE.Hydrostatic(CMT_LeadW,B81-B80) |
| 82 | Shoe                                                                                                                                                                                                        | =CMT_Shoe                                                                                                                                                    | =PO.DE.Hydrostatic(CMT_MW,B82)                                                                                                                                                                                                                                           | =CMT_Psi*B82*(CMT_FgTop+(CMT_FgShoe-CMT_FgTop)*(B82-CMT_PrevShoe)/(CMT_Shoe-CMT_PrevShoe))                                                                   | =CMT_Psi*B82*(CMT_PpTop+(CMT_PpShoe-CMT_PpTop)*(B82-CMT_PrevShoe)/(CMT_Shoe-CMT_PrevShoe))                                                                   | =F81+PO.DE.Hydrostatic(CMT_TailW,B82-B81) |
| 84 | Constants                                                                                                                                                                                                   |                                                                                                                                                              |                                                                                                                                                                                                                                                                          |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 85 | Pressure gradient of 1 ppg of mud                                                                                                                                                                           | 0.052                                                                                                                                                        | psi/ft/ppg                                                                                                                                                                                                                                                               |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 86 | Cubic feet in a barrel                                                                                                                                                                                      | 5.614583                                                                                                                                                     | ft³/bbl                                                                                                                                                                                                                                                                  |                                                                                                                                                              |                                                                                                                                                              |                                           |
| 87 | Gallons in a barrel                                                                                                                                                                                         | 42                                                                                                                                                           | gal/bbl                                                                                                                                                                                                                                                                  |                                                                                                                                                              |                                                                                                                                                              |                                           |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.DE.Cement.Volume | =LAMBDA(Dh_in, OD_in, ID_in, PrevID_in, OH_ft, CH_ft, Shoe_ft, Excess, LET(voh, (Dh_in^2 - OD_in^2)/1029.4*OH_ft*(1 + Excess), vch, (PrevID_in^2 - OD_in^2)/1029.4*CH_ft, vsh, ID_in^2/1029.4*Shoe_ft, HSTACK(voh + vch + vsh, voh, vch, vsh))) | Slurry volume of one cement stage, bbl: open-hole annulus with excess, cased overlap and shoe track, as {total, open hole, overlap, shoe track}. |
| PO.DE.Cement.Displacement | =LAMBDA(CasingID_in, FC_ft, Extra_bbl, PumpOut_bblstk, LET(vol, CasingID_in^2/1029.4*FC_ft + Extra_bbl, HSTACK(vol, vol/PumpOut_bblstk))) | Cement displacement volume to the float collar, bbl, and the pump strokes to bump the plug: {bbl, strokes}. |
| PO.DE.PipeCapacity | =LAMBDA(ID_in, ID_in^2 / 1029.4) | Internal capacity of a pipe, bbl/ft, from its inside diameter. |
| PO.DE.AnnularCapacity | =LAMBDA(Dh_in, Dp_in, (Dh_in^2 - Dp_in^2) / 1029.4) | Annular capacity, bbl/ft, from the hole and pipe diameters. |
| PO.DE.Hydrostatic | =LAMBDA(MW_ppg, TVD_ft, 0.052 * MW_ppg * TVD_ft) | Hydrostatic pressure, psi, of a mud column of the given weight and true vertical depth. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| CMT_Hole | $B$4 | Open-hole diameter (bit size), in |
| CMT_OD | $B$5 | Casing outside diameter, in |
| CMT_IdTop | $B$6 | Casing inside diameter above the crossover, in |
| CMT_IdBot | $B$7 | Casing inside diameter below it, to the shoe, in |
| CMT_Xover | $B$8 | Crossover depth, ft |
| CMT_FC | $B$9 | Float collar depth, ft |
| CMT_Shoe | $B$10 | Casing shoe depth, ft |
| CMT_PrevId | $B$11 | Previous casing's inside diameter, in |
| CMT_PrevShoe | $B$12 | Previous casing's shoe, the top of the open hole, ft |
| CMT_LeadTop | $B$14 | Top of the lead slurry, the top of cement, ft |
| CMT_TailTop | $B$15 | Top of the tail slurry, ft |
| CMT_LeadEx | $B$16 | Lead slurry's open-hole excess, % |
| CMT_TailEx | $B$17 | Tail slurry's open-hole excess, % |
| CMT_LeadW | $B$18 | Lead slurry density, ppg |
| CMT_LeadY | $B$19 | Lead slurry yield, ft³/sk |
| CMT_LeadWat | $B$20 | Lead mix water, gal/sk |
| CMT_TailW | $B$21 | Tail slurry density, ppg |
| CMT_TailY | $B$22 | Tail slurry yield, ft³/sk |
| CMT_TailWat | $B$23 | Tail mix water, gal/sk |
| CMT_SpV | $B$24 | Spacer pumped ahead of the lead, bbl |
| CMT_SpW | $B$25 | Spacer density, ppg |
| CMT_MW | $B$27 | Mud in the hole, and the displacement fluid, ppg |
| CMT_PumpOut | $B$28 | Pump output at the running efficiency, bbl/stk |
| CMT_Lines | $B$29 | Surface lines to the cement head, bbl |
| CMT_Rate | $B$30 | Mixing and displacement rate, bbl/min |
| CMT_Bump | $B$31 | Pressure over the final pressure to bump the plug, psi |
| CMT_FgShoe | $B$32 | Fracture gradient at the shoe (pore-pressure sheet), ppg |
| CMT_FgTop | $B$33 | Fracture gradient at the top of the open hole (leak-off test), ppg |
| CMT_PpShoe | $B$34 | Pore pressure at the shoe (pore-pressure sheet), ppg |
| CMT_PpTop | $B$35 | Pore pressure at the top of the open hole, ppg |
| CMT_LeadTT | $B$36 | Lead slurry's thickening time, min |
| CMT_TailTT | $B$37 | Tail slurry's thickening time, min |
| CMT_TTMargin | $B$38 | Margin kept under the thickening time, min |
| CMT_Pburst | $B$39 | Burst rating of the upper section (casing sheet), psi |
| CMT_DFb | $B$40 | Minimum burst design factor |
| CMT_Inputs | $B$4:$B$40 | The hole and the tapered casing, the previous shoe, the two slurries and the spacer, the mud, the pump, the bump pressure, the pore and fracture pressures, the thickening times and the casing's burst rating |
| CMT_Slurries | $A$44:$E$45 | Each slurry's total volume and its open-hole (with excess), overlap and shoe-track parts |
| CMT_LeadV | $B$48 | Lead slurry, bbl |
| CMT_LeadSk | $B$49 | Lead sacks, sk |
| CMT_TailV | $B$50 | Tail slurry, bbl |
| CMT_TailSk | $B$51 | Tail sacks, sk |
| CMT_Water | $B$52 | Mix water, both slurries, bbl |
| CMT_BoreLow | $B$54 | Lower section's bore, crossover to the float collar, bbl |
| CMT_DispV | $B$55 | Displacement to the float collar, bbl |
| CMT_Strokes | $B$56 | Strokes to bump the plug, stk |
| CMT_SpH | $B$57 | Spacer height above the lead (cased annulus), ft |
| CMT_Pann | $B$58 | Annulus pressure at the shoe at the end of the job, psi |
| CMT_Pin | $B$59 | Pressure inside at the shoe: mud to the collar, tail below, psi |
| CMT_Pfinal | $B$60 | Final pump pressure (static, no friction), psi |
| CMT_Pbump | $B$61 | Plug-bump pressure, psi |
| CMT_LeadTime | $B$62 | Job time, spacer to bump (the lead's exposure), min |
| CMT_TailTime | $B$63 | Job time, tail to bump (the tail's exposure), min |
| CMT_EmwShoe | $B$65 | Equivalent mud weight at the shoe, ppg |
| CMT_EmwTop | $B$66 | Equivalent mud weight at the top of the open hole, ppg |
| CMT_FracShoeCheck | $B$67 | Fracture check at the shoe verdict |
| CMT_FracShoeCheckNote | $C$67 | Fracture check at the shoe comment |
| CMT_FracTopCheck | $B$68 | Fracture check at the top of the open hole verdict |
| CMT_FracTopCheckNote | $C$68 | Fracture check at the top of the open hole comment |
| CMT_OverbalanceCheck | $B$69 | Overbalance check verdict |
| CMT_OverbalanceCheckNote | $C$69 | Overbalance check comment |
| CMT_TimeCheck | $B$70 | Thickening time check verdict |
| CMT_TimeCheckNote | $C$70 | Thickening time check comment |
| CMT_BumpCheck | $B$71 | Bump check verdict |
| CMT_BumpCheckNote | $C$71 | Bump check comment |
| CMT_Results | $B$48:$B$71 | The slurry volumes, sacks and mix water, the displacement and strokes, the spacer height, the annulus and inside pressures, the final and bump pressures, the job times, the equivalent mud weights and the five checks |
| CMT_Profile | $A$77:$F$82 | Each fluid boundary in the annulus at the end of placement, its depth, the mud alone, the open hole's fracture and pore pressure, and the annulus pressure |
| CMT_Psi | $B$85 | Pressure gradient of 1 ppg of mud, psi/ft/ppg |
| CMT_Ft3Bbl | $B$86 | Cubic feet in a barrel, ft³/bbl |
| CMT_GalBbl | $B$87 | Gallons in a barrel, gal/bbl |

---

## Related Blueprints
- [Well Control Kill Sheet](/blueprint/po.de.wellcontrol.killsheet.md)
- [Hole Cleaning and Solids Control](/blueprint/po.de.holecleaning.solids.md)
- [Plug and Abandonment Design](/blueprint/po.de.pa.design.md)
- [Surge and Swab Trip Speed](/blueprint/po.de.surge.swab.md)
- [Pore Pressure and Mud-Weight Window](/blueprint/po.de.pore.pressure.eaton.md)
- [BOP Accumulator Sizing](/blueprint/po.de.wellcontrol.accumulator.md)

