---
cid: po.bp.de.pa.design
hub: de
tags: [well-integrity, plug-and-abandonment, abandonment, decommissioning, permanent-barrier, NORSOK-D-010, OEUK, cement-plug, balanced-plug, barrier-rating, abandonment-cost]
facets: { discipline: drilling, property: well-integrity, method-type: analytical }
title: Plug and Abandonment Design
summary: "Whether an abandonment plan's cement plugs seal the well for good under NORSOK D-010 and OEUK guidance, and what the plan will cost."
slug: po.de.pa.design
type: worksheet
---

# Plug and Abandonment Design

## Description

Will the abandonment plan leave the well sealed for good, and what will it cost? You enter the well after the completion is pulled, the reservoir and rock, each cement plug's base, length, foundation and verification, the workstring, and the rig days and prices. You read off each plug's status against NORSOK D-010 and the OEUK guidelines, the green-to-red rating of the reservoir barriers, the shallowest depth a reservoir barrier can sit, each balanced plug's slurry, spacer and displacement, and the cost estimate.

**Parameters:**
- **The well after the completion is pulled**: the liner ID `PA_LinerID` (in) and the cement behind it from `PA_LinerTOC`, the intermediate casing's cement top `PA_IntTOC`, the depth it is cut at and pulled from `PA_Cut`, the surface casing ID `PA_SurfID` (in), its cement top `PA_SurfTOC` and its shoe `PA_SurfShoe`, and the top perforation `PA_PerfTop` (ft MD)
- **Reservoir and rock**: the reservoir pressure `PA_Pres` (psi), the gas gradient `PA_Gg` and the normal pore-pressure gradient `PA_Gn` (psi/ft), the fracture gradients below and above the surface shoe `PA_FG`, `PA_FGs` (ppg), and the fluid left between the plugs `PA_KillMW` (ppg)
- **Plugs**: for the primary `P1`, the secondary `P2` and the open-hole-to-surface plug `P3`, the base `PA_P…Base` (ft MD), the length `PA_P…Len` (ft), the foundation `PA_P…Fdn` (1 a tested bridge plug, 0 none) and the verification `PA_P…Ver` (0 tagged and pressure-tested, 1 not)
- **Placement and the minimum lengths**: the workstring OD and ID `PA_WsOD`, `PA_WsID` (in), the spacer ahead `PA_Ahead` (bbl), the slurry excess `PA_Excess`, and the minimum plug lengths with and without a foundation `PA_MinFdn`, `PA_MinOpen` (ft)
- **Rig time and materials**: the spread rate `PA_Spread` ($/day), the days to move in, pull the completion, set each plug, cut the casing and rig down `PA_MobDays`, `PA_PullDays`, `PA_PlugDays`, `PA_CutDays`, `PA_SiteDays`, the slurry's price `PA_CmtCost` ($/bbl), each bridge plug's `PA_BpCost`, the fixed costs `PA_Fixed` ($) and the contingency `PA_Cont`

**How to use it:** The reservoir, the rock and the prices are made up. Take the reservoir pressure from the last pressure survey, the fracture gradients from leak-off tests or the drilling records, the cement tops from the cement bond logs, each plug's verification from its tag and pressure test, and the rates from the rig and service contracts. The minimum lengths and the verification a regulator asks for can differ from NORSOK D-010's: enter its own. The permanent barriers are a table, one row per cement plug, each held to what NORSOK D-010 and the OEUK abandonment guidelines ask of a permanent barrier, paraphrased on the sheet. Each well that can flow from a reservoir needs two barriers between the reservoir and the surface, a primary and a secondary, plus one near the surface against the open hole. Each barrier seals the whole cross-section of the well, the annuli as well as the casing. It sits where the rock at its base can hold the highest pressure that could build up under it. It is long enough, and it is verified once set. Each requirement is an element with a status code, 0 met, 1 not verified and 2 failed. Read the checks: the reservoir check reads the category, green passing, yellow and orange warning, red failing; the depth check fails when a reservoir barrier sits above the shallowest depth; the surface check reads the open-hole-to-surface plug's status; and the placement check warns when a plug's slurry and spacer fill the workstring to surface, leaving nothing to displace. A depth chart draws the fracture pressure, a gas column from the reservoir, the fluid left in the well and the normal pore pressure; the depth where the first two cross is the shallowest a reservoir barrier can sit. The plug depths are put in TVD on the wellbore-schematic workbook's survey, so the plan and the schematic state the same depths.

**Method:** The shallowest base for a reservoir barrier is where a gas column from the reservoir meets the rock's fracture pressure: 0.052 FG z = Pres − Gg (TVDres − z), so z = (Pres − Gg TVDres) / (0.052 FG − Gg). For each plug the top is the base less the length, and both are put in TVD on the survey by minimum curvature. Four elements follow, each 0 when met and 2 when not. The length element holds the plug to the minimum for its foundation. The annulus element asks that the cement behind the casing start at or above the plug's top; for the surface plug, the 9⅝-in. casing must also be cut at or below the plug's base and above its own cement, so the plug seals the 13⅜-in. casing alone. The rock element compares 0.052 FG × TVD at the plug's base with the pressure under it: a gas column from the reservoir, Pres − Gg (TVDres − TVD), for a reservoir barrier, and the normal pore pressure Gn × TVD for the surface plug. The verification element is 0 when the plug is tagged and pressure-tested and 1 when it is not. The plug's status is its worst element, and the primary's and the secondary's statuses give the category: green with both met, yellow with one not verified, orange with one failed or neither verified, red with one failed and the other not met. Each plug is placed as a balanced plug through an open-ended workstring. Its slurry is the casing's capacity ID²/1029.4 over the plug's length with the excess, sized in its own cell. With the pipe in, the slurry stands as high inside as outside, H = V / (Ca + Cp), and the spacer behind is Vahead Cp / Ca. When the pipe is pulled the slurry fills the hole alone, V / Ch, and the displacement is Cp (base − H) less the spacer behind. The cost is the rig days, those listed plus one plug's days for each plug, at the spread rate, plus the slurry at its price, the bridge plugs and the fixed costs, with the contingency on the sum.

**Example:** The wellbore-schematic workbook's well, example well A-12: vertical to a kick-off at 2,500 ft, built at 1.5°/100 ft to 30° at 4,500 ft MD and held to TD at 10,000 ft MD (9,173 ft TVD). It has 13⅜-in. surface casing at 2,500 ft cemented to surface, 9⅝-in. casing at 7,200 ft with its cement top at 5,500 ft, and a 7-in. liner from 6,900 ft to 9,950 ft cemented over its length, perforated from 9,500 ft MD. The completion has been pulled. The primary barrier is 300 ft of cement on a bridge plug at 9,450 ft MD, 50 ft above the perforations. The secondary is a 500 ft plug from 7,600 ft MD in the liner, with no foundation. The 9⅝-in. casing is cut at 600 ft, free above its cement, and pulled, and the open-hole-to-surface plug is 350 ft from 600 ft MD in the surface casing. The reservoir holds 3,950 psi, the gas gradient is 0.10 psi/ft and the normal pore-pressure gradient 0.465 psi/ft. The rock fractures at 14.0 ppg below the surface shoe and 11.5 ppg above it, and the 9.0 ppg packer fluid stays in the well between the plugs. Each plug goes through 2⅞-in. tubing (ID 2.441 in.) behind 10 bbl of spacer with 10% excess. The minimum lengths are NORSOK D-010's 50 m on a tested foundation and 100 m without, as 164 and 328 ft. The rig spreads at $38,000 a day, over 2 days to move in, 2.5 to kill the well and pull the completion, 1.5 a plug, 1 to cut and pull the 9⅝-in. casing and 1.5 to cut the wellhead and rig down. The slurry costs $220 a barrel and a bridge plug $12,000, with $85,000 of fixed costs and a 15% contingency. The schematic gives the strings' ODs only; the casing weights, the reservoir and rock, and the plan and its prices are this sheet's choices.

The top perforation is at 8,740 ft TVD. The 3,950 psi reservoir puts a gas column of 3,076 psi at surface, which meets the 14.0 ppg fracture line at 4,898 ft TVD, so both reservoir barriers must sit deeper. The primary's base, at 9,450 ft MD, is 8,697 ft TVD. There the rock holds 6,331 psi against the 3,946 psi under it. The plug's 300 ft is over the 164 ft minimum on a bridge plug, and the liner's cement reaches above it to 6,900 ft. The secondary's base, at 7,600 ft MD, is 7,095 ft TVD, where the rock holds 5,165 psi against 3,785 psi. Its 500 ft is over the 328 ft minimum without a foundation, and the liner's cement covers it too. Both are intact, so the reservoir is green. The surface plug's base, at 600 ft, holds 359 psi against the 279 psi of normal pore pressure, and it sits on the 9⅝-in. stub cut at 600 ft, above that casing's cement. In the 6.184-in. liner the secondary takes 20.4 bbl of slurry. Through the 2⅞-in. tubing that column stands 585 ft with the pipe in and 550 ft once pulled, behind 2.0 bbl of spacer and 38.6 bbl of displacement. The primary takes 12.3 bbl and the surface plug 57.0 bbl, 89.7 bbl in all. The 11.5 rig days cost $437,000 and the materials $116,736. The contingency adds $83,060, for an estimate of $636,796. Leave the secondary untested and the reservoir is yellow. Shorten it to 250 ft, or have the liner's cement start at 7,300 ft below its top, and it is orange. A 6,500 psi reservoir moves the shallowest base to 8,959 ft TVD and makes both barriers fail the rock, so the reservoir is red. Cut the 9⅝-in. casing at 6,000 ft, inside its cement, and the surface plug fails. Set the surface plug from 400 ft and its slurry and spacer fill the tubing to surface.

## Validity

A screening design for one reservoir with flow potential; a well with more than one zone that can flow needs barriers for each, and a shallow gas zone or a water zone under pressure adds its own. The requirements are paraphrased from NORSOK D-010 and the OEUK guidelines, not quoted, and a regulator's own rules can set other minimum lengths, verification and surface-plug depths: enter its numbers. The plug lengths are in MD; the rock and pressure checks are at the plug's base in TVD, with the worst case of a gas column under it, and a single fracture gradient on each side of the surface shoe. The annulus check takes the cement top behind the casing at face value: whether that cement bonds is the bond log's call. Each plug sits in one casing size, and the balanced plug assumes one workstring size and a spacer of the mud's density; a tapered workstring needs the displacement by section. The cost estimate is a roll-up of days and prices, with no weather, waiting or remediation. Field units.

## References

- Standards Norway (2013). *NORSOK D-010, Well integrity in drilling and well operations*, Rev. 4 (permanent abandonment: primary, secondary and open-hole-to-surface barriers, cement plug lengths and verification).
- Oil & Gas UK (2018). *Guidelines for the Abandonment of Wells*, Issue 6 (permanent barriers across the full cross-section, their placement and verification).
- Norwegian Oil and Gas Association. Guideline 117, *Recommended Guidelines for Well Integrity* (the green, yellow, orange and red well categories).
- Nelson, E.B. and Guillot, D. (eds.) (2006). *Well Cementing*, 2nd ed. Schlumberger (the balanced-plug method).
- Bourgoyne, A.T., Millheim, K.K., Chenevert, M.E. and Young, F.S. (1986). *Applied Drilling Engineering*. SPE Textbook Series Vol. 2, ch. 3 (cement plugs).

## Functions used

`PO.WI.Barrier.Status`, `PO.WI.Barrier.Rating`, `PO.WI.PA.BalancedPlug`, `PO.DE.Cement.Volume`, `PO.CO.Schematic.Depths`, `PO.DE.Dir.DoglegSeverity`, `PO.DE.Dir.RatioFactor`, `PO.DE.Dir.MinCurv.dTVD`

## Spreadsheet: PADesign

|     | A                                                                                                                                                                                                           | B                                                                       | C                                                                                                                                                                                                                                                                                                                                            | D                                                                      | E                                                                      | F                                                                      | G                                                                      | H                        | I                                    | J                               | K                      | L                   | M                                                      | N                  | O         | P                                | Q                                                   |
|-----|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------|------------------------------------------------------------------------|------------------------------------------------------------------------|------------------------------------------------------------------------|--------------------------|--------------------------------------|---------------------------------|------------------------|---------------------|--------------------------------------------------------|--------------------|-----------|----------------------------------|-----------------------------------------------------|
| 1   | Plug and Abandonment Design                                                                                                                                                                                 |                                                                         | Petroleum Office                                                                                                                                                                                                                                                                                                                             |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 2   | Blue cells on yellow are inputs. Enter the strings, the reservoir and the rock, each plug's base, length, foundation and verification, the workstring and the rig's rates; overwrite the survey with yours. |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 3   | Well A-12 After the Completion Is Pulled                                                                                                                                                                    |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 4   | 7-in. 29 lb/ft production liner inside diameter                                                                                                                                                             | 6.184                                                                   | in                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 5   | Top of cement behind the liner (its top at 6,900 ft)                                                                                                                                                        | 6900                                                                    | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 6   | Top of cement behind the 9⅝-in. intermediate casing                                                                                                                                                         | 5500                                                                    | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 7   | Depth the 9⅝-in. casing is cut at and pulled from                                                                                                                                                           | 600                                                                     | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 8   | 13⅜-in. 72 lb/ft surface casing inside diameter                                                                                                                                                             | 12.347                                                                  | in                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 9   | Top of cement behind the surface casing                                                                                                                                                                     | 0                                                                       | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 10  | Surface casing shoe                                                                                                                                                                                         | 2500                                                                    | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 11  | Top perforation, the top of the reservoir's inflow                                                                                                                                                          | 9500                                                                    | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 12  | Reservoir and Rock                                                                                                                                                                                          |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 13  | Reservoir pressure at the top perforation                                                                                                                                                                   | 3950                                                                    | psi                                                                                                                                                                                                                                                                                                                                          |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 14  | Gas gradient (a gas column under a barrier, the worst case)                                                                                                                                                 | 0.1                                                                     | psi/ft                                                                                                                                                                                                                                                                                                                                       |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 15  | Fracture gradient below the surface casing shoe                                                                                                                                                             | 14                                                                      | ppg                                                                                                                                                                                                                                                                                                                                          |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 16  | Fracture gradient above the surface casing shoe                                                                                                                                                             | 11.5                                                                    | ppg                                                                                                                                                                                                                                                                                                                                          |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 17  | Normal pore-pressure gradient of the shallow formations                                                                                                                                                     | 0.465                                                                   | psi/ft                                                                                                                                                                                                                                                                                                                                       |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 18  | Fluid left in the well between the plugs                                                                                                                                                                    | 9                                                                       | ppg                                                                                                                                                                                                                                                                                                                                          |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 19  | Plug: Reservoir, primary (on a bridge plug above the perforations)                                                                                                                                          |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 20  | Plug base (MD)                                                                                                                                                                                              | 9450                                                                    | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 21  | Plug length                                                                                                                                                                                                 | 300                                                                     | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 22  | Foundation: 1 on a tested bridge plug, 0 none                                                                                                                                                               | 1                                                                       | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 23  | Verification: 0 tagged and pressure-tested, 1 not verified                                                                                                                                                  | 0                                                                       | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 24  | Plug: Reservoir, secondary (in the liner)                                                                                                                                                                   |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 25  | Plug base (MD)                                                                                                                                                                                              | 7600                                                                    | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 26  | Plug length                                                                                                                                                                                                 | 500                                                                     | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 27  | Foundation: 1 on a tested bridge plug, 0 none                                                                                                                                                               | 0                                                                       | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 28  | Verification: 0 tagged and pressure-tested, 1 not verified                                                                                                                                                  | 0                                                                       | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 29  | Plug: Open hole to surface (in the surface casing)                                                                                                                                                          |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 30  | Plug base (MD)                                                                                                                                                                                              | 600                                                                     | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 31  | Plug length                                                                                                                                                                                                 | 350                                                                     | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 32  | Foundation: 1 on a tested bridge plug, 0 none                                                                                                                                                               | 0                                                                       | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 33  | Verification: 0 tagged and pressure-tested, 1 not verified                                                                                                                                                  | 0                                                                       | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 34  | Placement and the Minimum Lengths                                                                                                                                                                           |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 35  | Workstring outside diameter (2⅞-in. tubing)                                                                                                                                                                 | 2.875                                                                   | in                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 36  | Workstring inside diameter                                                                                                                                                                                  | 2.441                                                                   | in                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 37  | Spacer pumped ahead of the cement                                                                                                                                                                           | 10                                                                      | bbl                                                                                                                                                                                                                                                                                                                                          |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 38  | Slurry excess over the plug's volume                                                                                                                                                                        | 0.1                                                                     | %                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 39  | Minimum plug length on a tested foundation (50 m)                                                                                                                                                           | 164                                                                     | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 40  | Minimum plug length without one (100 m)                                                                                                                                                                     | 328                                                                     | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 41  | Rig Time and Materials                                                                                                                                                                                      |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 42  | Spread rate: the rig and its services                                                                                                                                                                       | 38000                                                                   | $/day                                                                                                                                                                                                                                                                                                                                        |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 43  | Move in and rig up                                                                                                                                                                                          | 2                                                                       | days                                                                                                                                                                                                                                                                                                                                         |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 44  | Kill the well and pull the completion                                                                                                                                                                       | 2.5                                                                     | days                                                                                                                                                                                                                                                                                                                                         |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 45  | Each plug: run, place, wait on cement, tag and test                                                                                                                                                         | 1.5                                                                     | days                                                                                                                                                                                                                                                                                                                                         |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 46  | Cut and pull the 9⅝-in. casing                                                                                                                                                                              | 1                                                                       | days                                                                                                                                                                                                                                                                                                                                         |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 47  | Cut the wellhead below ground and rig down                                                                                                                                                                  | 1.5                                                                     | days                                                                                                                                                                                                                                                                                                                                         |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 48  | Cement slurry, mixed and pumped                                                                                                                                                                             | 220                                                                     | $/bbl                                                                                                                                                                                                                                                                                                                                        |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 49  | Each bridge plug                                                                                                                                                                                            | 12000                                                                   | $                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 50  | Wellhead removal, site restoration and waste                                                                                                                                                                | 85000                                                                   | $                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 51  | Contingency                                                                                                                                                                                                 | 0.15                                                                    | %                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 52  | The Barriers' Status, the Shallowest Reservoir Barrier and the Cost                                                                                                                                         |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 53  | Top perforation TVD                                                                                                                                                                                         | =PO.CO.Schematic.Depths(PA_PerfTop,PA_SvMD,PA_SvInc,PA_SvAzi,PA_SvTVD)  | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 54  | Surface casing shoe TVD                                                                                                                                                                                     | =PO.CO.Schematic.Depths(PA_SurfShoe,PA_SvMD,PA_SvInc,PA_SvAzi,PA_SvTVD) | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 55  | Shallowest barrier base (the rock holds a gas column)                                                                                                                                                       | =(PA_Pres-PA_Gg*PA_ResTVD)/(PA_Psi*PA_FG-PA_Gg)                         | ft                                                                                                                                                                                                                                                                                                                                           |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 56  | Primary reservoir barrier                                                                                                                                                                                   | =""&CHOOSE(PA_Primary+1,"Intact","Not verified","Failed")               |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 57  | Primary barrier status code                                                                                                                                                                                 | =P101                                                                   | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 58  | Secondary reservoir barrier                                                                                                                                                                                 | =""&CHOOSE(PA_Secondary+1,"Intact","Not verified","Failed")             |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 59  | Secondary barrier status code                                                                                                                                                                               | =P102                                                                   | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 60  | Reservoir integrity category (1 green to 4 red)                                                                                                                                                             | =PO.WI.Barrier.Rating(PA_Primary,PA_Secondary)                          | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 61  | Open-hole-to-surface barrier status code                                                                                                                                                                    | =P103                                                                   | —                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 62  | Cement slurry, all plugs                                                                                                                                                                                    | =SUM(B107:B109)                                                         | bbl                                                                                                                                                                                                                                                                                                                                          |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 63  | Rig days                                                                                                                                                                                                    | =SUM(B113:B120)                                                         | days                                                                                                                                                                                                                                                                                                                                         |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 64  | Rig time at the spread rate                                                                                                                                                                                 | =SUM(C113:C120)                                                         | $                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 65  | Materials and services                                                                                                                                                                                      | =SUM(D113:D120)                                                         | $                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 66  | Contingency                                                                                                                                                                                                 | =(PA_TimeCost+PA_Materials)*PA_Cont                                     | $                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 67  | Abandonment cost estimate                                                                                                                                                                                   | =PA_TimeCost+PA_Materials+PA_ContCost                                   | $                                                                                                                                                                                                                                                                                                                                            |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 68  | Reservoir barriers check                                                                                                                                                                                    | =CHOOSE(PA_Rating,"PASS","WARN","WARN","FAIL")                          | =CHOOSE(PA_Rating,"green, both reservoir barriers meet every requirement","yellow, one reservoir barrier is not verified and the other meets every requirement","orange, one reservoir barrier fails a requirement, or neither is verified","red, one reservoir barrier fails a requirement and the other fails one too or is not verified") |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 69  | Reservoir barrier depth check                                                                                                                                                                               | =IF(AND(E101>=PA_MinBase,E102>=PA_MinBase),"PASS","FAIL")               | =IF(AND(E101>=PA_MinBase,E102>=PA_MinBase),"both reservoir barriers sit below "&TEXT(PA_MinBase,"0")&" ft TVD, where the rock holds a gas column from the reservoir","a reservoir barrier sits above "&TEXT(PA_MinBase,"0")&" ft TVD, where the rock can't hold a gas column from the reservoir: set it deeper")                             |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 70  | Open-hole-to-surface check                                                                                                                                                                                  | =CHOOSE(PA_Surface+1,"PASS","WARN","FAIL")                              | =CHOOSE(PA_Surface+1,"the open-hole-to-surface barrier meets every requirement","the open-hole-to-surface barrier is not verified","the open-hole-to-surface barrier fails a requirement")                                                                                                                                                   |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 71  | Placement check                                                                                                                                                                                             | =IF(COUNTIF(G107:G109,"<=0")=0,"PASS","WARN")                           | =IF(COUNTIF(G107:G109,"<=0")=0,"every plug balances with the workstring's end at its base","a plug's slurry and spacer fill the workstring to surface, leaving nothing to displace: set it deeper or place it in stages")                                                                                                                    |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 73  | How to use it: take the reservoir pressure from the last survey, the fracture gradients from leak-off tests or the drilling records, and each plug's verification from its tag and pressure test.           |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 74  | A screening design: a well with more than one zone that can flow needs barriers for each, and a regulator's own rules can ask for more than the minimums here.                                              |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 76  | What a Permanent Barrier Has to Do (NORSOK D-010 and the OEUK guidelines, paraphrased)                                                                                                                      |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 77  | Two permanent barriers, a primary and a secondary, between each reservoir that can flow and the surface, and one more barrier near the surface.                                                             |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 78  | Each barrier seals the whole cross-section of the well, the annuli as well, so the cement behind the casing has to reach over the plug.                                                                     |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 79  | Each sits where the rock at its base is strong enough for the highest pressure that could build up under it.                                                                                                |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 80  | A cement plug in casing is at least 50 m long on a tested foundation, 100 m otherwise (NORSOK D-010); both are inputs here.                                                                                 |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 81  | Each barrier is verified once set: tagged for its position and pressure-tested.                                                                                                                             |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 83  | Constants                                                                                                                                                                                                   |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 84  | Pressure gradient of 1 ppg of fluid                                                                                                                                                                         | 0.052                                                                   | psi/ft/ppg                                                                                                                                                                                                                                                                                                                                   |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 86  | Survey (the wellbore-schematic workbook's well A-12), TVD by Minimum Curvature                                                                                                                              |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 87  | MD (ft)                                                                                                                                                                                                     | Inclination (°)                                                         | Azimuth (°)                                                                                                                                                                                                                                                                                                                                  | Dogleg severity (°/100 ft)                                             | Ratio factor (—)                                                       | TVD (ft)                                                               |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 88  | 0                                                                                                                                                                                                           | 0                                                                       | 135                                                                                                                                                                                                                                                                                                                                          | =0                                                                     | =1                                                                     | =A88                                                                   |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 89  | 1000                                                                                                                                                                                                        | 0                                                                       | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B88,C88,B89,C89,A89-A88)                     | =PO.DE.Dir.RatioFactor(D89*(A89-A88)/100)                              | =F88+PO.DE.Dir.MinCurv.dTVD(B88,B89,A89-A88,E89)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 90  | 2500                                                                                                                                                                                                        | 0                                                                       | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B89,C89,B90,C90,A90-A89)                     | =PO.DE.Dir.RatioFactor(D90*(A90-A89)/100)                              | =F89+PO.DE.Dir.MinCurv.dTVD(B89,B90,A90-A89,E90)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 91  | 3000                                                                                                                                                                                                        | 7.5                                                                     | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B90,C90,B91,C91,A91-A90)                     | =PO.DE.Dir.RatioFactor(D91*(A91-A90)/100)                              | =F90+PO.DE.Dir.MinCurv.dTVD(B90,B91,A91-A90,E91)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 92  | 3500                                                                                                                                                                                                        | 15                                                                      | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B91,C91,B92,C92,A92-A91)                     | =PO.DE.Dir.RatioFactor(D92*(A92-A91)/100)                              | =F91+PO.DE.Dir.MinCurv.dTVD(B91,B92,A92-A91,E92)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 93  | 4000                                                                                                                                                                                                        | 22.5                                                                    | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B92,C92,B93,C93,A93-A92)                     | =PO.DE.Dir.RatioFactor(D93*(A93-A92)/100)                              | =F92+PO.DE.Dir.MinCurv.dTVD(B92,B93,A93-A92,E93)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 94  | 4500                                                                                                                                                                                                        | 30                                                                      | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B93,C93,B94,C94,A94-A93)                     | =PO.DE.Dir.RatioFactor(D94*(A94-A93)/100)                              | =F93+PO.DE.Dir.MinCurv.dTVD(B93,B94,A94-A93,E94)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 95  | 6000                                                                                                                                                                                                        | 30                                                                      | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B94,C94,B95,C95,A95-A94)                     | =PO.DE.Dir.RatioFactor(D95*(A95-A94)/100)                              | =F94+PO.DE.Dir.MinCurv.dTVD(B94,B95,A95-A94,E95)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 96  | 8000                                                                                                                                                                                                        | 30                                                                      | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B95,C95,B96,C96,A96-A95)                     | =PO.DE.Dir.RatioFactor(D96*(A96-A95)/100)                              | =F95+PO.DE.Dir.MinCurv.dTVD(B95,B96,A96-A95,E96)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 97  | 10000                                                                                                                                                                                                       | 30                                                                      | 135                                                                                                                                                                                                                                                                                                                                          | =PO.DE.Dir.DoglegSeverity(B96,C96,B97,C97,A97-A96)                     | =PO.DE.Dir.RatioFactor(D97*(A97-A96)/100)                              | =F96+PO.DE.Dir.MinCurv.dTVD(B96,B97,A97-A96,E97)                       |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 99  | Barrier Plan: One Row per Permanent Barrier (0 met, 1 not verified, 2 failed)                                                                                                                               |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 100 | Permanent barrier                                                                                                                                                                                           | Base, MD (ft)                                                           | Length (ft)                                                                                                                                                                                                                                                                                                                                  | Top, MD (ft)                                                           | Base, TVD (ft)                                                         | Top, TVD (ft)                                                          | Casing ID (in)                                                         | Cement behind from (ft)  | Minimum length (ft)                  | Pressure under it (psi)         | Rock at its base (psi) | Length              | Annulus                                                | Rock               | Verified  | Status code                      | Status                                              |
| 101 | Reservoir, primary (on a bridge plug above the perforations)                                                                                                                                                | =PA_P1Base                                                              | =PA_P1Len                                                                                                                                                                                                                                                                                                                                    | =B101-C101                                                             | =PO.CO.Schematic.Depths(B101,PA_SvMD,PA_SvInc,PA_SvAzi,PA_SvTVD)       | =PO.CO.Schematic.Depths(D101,PA_SvMD,PA_SvInc,PA_SvAzi,PA_SvTVD)       | =PA_LinerID                                                            | =PA_LinerTOC             | =IF(PA_P1Fdn=1,PA_MinFdn,PA_MinOpen) | =PA_Pres-PA_Gg*(PA_ResTVD-E101) | =PA_Psi*PA_FG*E101     | =IF(C101>=I101,0,2) | =IF(H101<=D101,0,2)                                    | =IF(K101>J101,0,2) | =PA_P1Ver | =PO.WI.Barrier.Status(L101:O101) | =""&CHOOSE(P101+1,"Intact","Not verified","Failed") |
| 102 | Reservoir, secondary (in the liner)                                                                                                                                                                         | =PA_P2Base                                                              | =PA_P2Len                                                                                                                                                                                                                                                                                                                                    | =B102-C102                                                             | =PO.CO.Schematic.Depths(B102,PA_SvMD,PA_SvInc,PA_SvAzi,PA_SvTVD)       | =PO.CO.Schematic.Depths(D102,PA_SvMD,PA_SvInc,PA_SvAzi,PA_SvTVD)       | =PA_LinerID                                                            | =PA_LinerTOC             | =IF(PA_P2Fdn=1,PA_MinFdn,PA_MinOpen) | =PA_Pres-PA_Gg*(PA_ResTVD-E102) | =PA_Psi*PA_FG*E102     | =IF(C102>=I102,0,2) | =IF(H102<=D102,0,2)                                    | =IF(K102>J102,0,2) | =PA_P2Ver | =PO.WI.Barrier.Status(L102:O102) | =""&CHOOSE(P102+1,"Intact","Not verified","Failed") |
| 103 | Open hole to surface (in the surface casing)                                                                                                                                                                | =PA_P3Base                                                              | =PA_P3Len                                                                                                                                                                                                                                                                                                                                    | =B103-C103                                                             | =PO.CO.Schematic.Depths(B103,PA_SvMD,PA_SvInc,PA_SvAzi,PA_SvTVD)       | =PO.CO.Schematic.Depths(D103,PA_SvMD,PA_SvInc,PA_SvAzi,PA_SvTVD)       | =PA_SurfID                                                             | =PA_SurfTOC              | =IF(PA_P3Fdn=1,PA_MinFdn,PA_MinOpen) | =PA_Gn*E103                     | =PA_Psi*PA_FGs*E103    | =IF(C103>=I103,0,2) | =IF(AND(H103<=D103,B103<=PA_Cut,PA_Cut<PA_IntTOC),0,2) | =IF(K103>J103,0,2) | =PA_P3Ver | =PO.WI.Barrier.Status(L103:O103) | =""&CHOOSE(P103+1,"Intact","Not verified","Failed") |
| 105 | Balanced Cement Plugs (slurry by PO.DE.Cement.Volume, then PO.WI.PA.BalancedPlug)                                                                                                                           |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 106 | Plug                                                                                                                                                                                                        | Slurry (bbl)                                                            | Spacer ahead (bbl)                                                                                                                                                                                                                                                                                                                           | Spacer behind (bbl)                                                    | Height, pipe in (ft)                                                   | Height, pipe out (ft)                                                  | Displacement (bbl)                                                     | Column top, pipe in (ft) | Cement top, pipe out (ft)            |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 107 | Reservoir, primary (on a bridge plug above the perforations)                                                                                                                                                | =INDEX(PO.DE.Cement.Volume(G101,0,0,0,C101,0,0,PA_Excess),1,1)          | =PA_Ahead                                                                                                                                                                                                                                                                                                                                    | =INDEX(PO.WI.PA.BalancedPlug(B107,C107,G101,PA_WsOD,PA_WsID,B101),1,1) | =INDEX(PO.WI.PA.BalancedPlug(B107,C107,G101,PA_WsOD,PA_WsID,B101),1,2) | =INDEX(PO.WI.PA.BalancedPlug(B107,C107,G101,PA_WsOD,PA_WsID,B101),1,3) | =INDEX(PO.WI.PA.BalancedPlug(B107,C107,G101,PA_WsOD,PA_WsID,B101),1,4) | =B101-E107               | =B101-F107                           |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 108 | Reservoir, secondary (in the liner)                                                                                                                                                                         | =INDEX(PO.DE.Cement.Volume(G102,0,0,0,C102,0,0,PA_Excess),1,1)          | =PA_Ahead                                                                                                                                                                                                                                                                                                                                    | =INDEX(PO.WI.PA.BalancedPlug(B108,C108,G102,PA_WsOD,PA_WsID,B102),1,1) | =INDEX(PO.WI.PA.BalancedPlug(B108,C108,G102,PA_WsOD,PA_WsID,B102),1,2) | =INDEX(PO.WI.PA.BalancedPlug(B108,C108,G102,PA_WsOD,PA_WsID,B102),1,3) | =INDEX(PO.WI.PA.BalancedPlug(B108,C108,G102,PA_WsOD,PA_WsID,B102),1,4) | =B102-E108               | =B102-F108                           |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 109 | Open hole to surface (in the surface casing)                                                                                                                                                                | =INDEX(PO.DE.Cement.Volume(G103,0,0,0,C103,0,0,PA_Excess),1,1)          | =PA_Ahead                                                                                                                                                                                                                                                                                                                                    | =INDEX(PO.WI.PA.BalancedPlug(B109,C109,G103,PA_WsOD,PA_WsID,B103),1,1) | =INDEX(PO.WI.PA.BalancedPlug(B109,C109,G103,PA_WsOD,PA_WsID,B103),1,2) | =INDEX(PO.WI.PA.BalancedPlug(B109,C109,G103,PA_WsOD,PA_WsID,B103),1,3) | =INDEX(PO.WI.PA.BalancedPlug(B109,C109,G103,PA_WsOD,PA_WsID,B103),1,4) | =B103-E109               | =B103-F109                           |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 111 | Cost Estimate: Rig Days at the Spread Rate, Plus Materials                                                                                                                                                  |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 112 | Item                                                                                                                                                                                                        | Rig days (days)                                                         | Rig time ($)                                                                                                                                                                                                                                                                                                                                 | Materials ($)                                                          | Total ($)                                                              |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 113 | Move in and rig up                                                                                                                                                                                          | =PA_MobDays                                                             | =B113*PA_Spread                                                                                                                                                                                                                                                                                                                              | =0                                                                     | =C113+D113                                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 114 | Kill the well and pull the completion                                                                                                                                                                       | =PA_PullDays                                                            | =B114*PA_Spread                                                                                                                                                                                                                                                                                                                              | =0                                                                     | =C114+D114                                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 115 | Set the plugs: run, place, wait on cement, tag and test                                                                                                                                                     | =PA_PlugDays*ROWS(PA_Plan)                                              | =B115*PA_Spread                                                                                                                                                                                                                                                                                                                              | =0                                                                     | =C115+D115                                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 116 | Cut and pull the 9⅝-in. casing                                                                                                                                                                              | =PA_CutDays                                                             | =B116*PA_Spread                                                                                                                                                                                                                                                                                                                              | =0                                                                     | =C116+D116                                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 117 | Cut the wellhead below ground and rig down                                                                                                                                                                  | =PA_SiteDays                                                            | =B117*PA_Spread                                                                                                                                                                                                                                                                                                                              | =0                                                                     | =C117+D117                                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 118 | Cement slurry                                                                                                                                                                                               | =0                                                                      | =B118*PA_Spread                                                                                                                                                                                                                                                                                                                              | =PA_Slurry*PA_CmtCost                                                  | =C118+D118                                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 119 | Bridge plugs                                                                                                                                                                                                | =0                                                                      | =B119*PA_Spread                                                                                                                                                                                                                                                                                                                              | =(PA_P1Fdn+PA_P2Fdn+PA_P3Fdn)*PA_BpCost                                | =C119+D119                                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 120 | Wellhead removal, site restoration and waste                                                                                                                                                                | =0                                                                      | =B120*PA_Spread                                                                                                                                                                                                                                                                                                                              | =PA_Fixed                                                              | =C120+D120                                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 122 | Pressure with Depth: Where a Reservoir Barrier Can Sit                                                                                                                                                      |                                                                         |                                                                                                                                                                                                                                                                                                                                              |                                                                        |                                                                        |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 123 | TVD (ft)                                                                                                                                                                                                    | Fracture pressure (psi)                                                 | Gas from the reservoir (psi)                                                                                                                                                                                                                                                                                                                 | Fluid between the plugs (psi)                                          | Normal pore pressure (psi)                                             |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 124 | =PA_ResTVD*0/20                                                                                                                                                                                             | =PA_Psi*IF(A124<PA_ShoeTVD,PA_FGs,PA_FG)*A124                           | =PA_Pres-PA_Gg*(PA_ResTVD-A124)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A124                                                 | =PA_Gn*A124                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 125 | =PA_ResTVD*1/20                                                                                                                                                                                             | =PA_Psi*IF(A125<PA_ShoeTVD,PA_FGs,PA_FG)*A125                           | =PA_Pres-PA_Gg*(PA_ResTVD-A125)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A125                                                 | =PA_Gn*A125                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 126 | =PA_ResTVD*2/20                                                                                                                                                                                             | =PA_Psi*IF(A126<PA_ShoeTVD,PA_FGs,PA_FG)*A126                           | =PA_Pres-PA_Gg*(PA_ResTVD-A126)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A126                                                 | =PA_Gn*A126                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 127 | =PA_ResTVD*3/20                                                                                                                                                                                             | =PA_Psi*IF(A127<PA_ShoeTVD,PA_FGs,PA_FG)*A127                           | =PA_Pres-PA_Gg*(PA_ResTVD-A127)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A127                                                 | =PA_Gn*A127                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 128 | =PA_ResTVD*4/20                                                                                                                                                                                             | =PA_Psi*IF(A128<PA_ShoeTVD,PA_FGs,PA_FG)*A128                           | =PA_Pres-PA_Gg*(PA_ResTVD-A128)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A128                                                 | =PA_Gn*A128                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 129 | =PA_ResTVD*5/20                                                                                                                                                                                             | =PA_Psi*IF(A129<PA_ShoeTVD,PA_FGs,PA_FG)*A129                           | =PA_Pres-PA_Gg*(PA_ResTVD-A129)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A129                                                 | =PA_Gn*A129                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 130 | =PA_ResTVD*6/20                                                                                                                                                                                             | =PA_Psi*IF(A130<PA_ShoeTVD,PA_FGs,PA_FG)*A130                           | =PA_Pres-PA_Gg*(PA_ResTVD-A130)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A130                                                 | =PA_Gn*A130                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 131 | =PA_ResTVD*7/20                                                                                                                                                                                             | =PA_Psi*IF(A131<PA_ShoeTVD,PA_FGs,PA_FG)*A131                           | =PA_Pres-PA_Gg*(PA_ResTVD-A131)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A131                                                 | =PA_Gn*A131                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 132 | =PA_ResTVD*8/20                                                                                                                                                                                             | =PA_Psi*IF(A132<PA_ShoeTVD,PA_FGs,PA_FG)*A132                           | =PA_Pres-PA_Gg*(PA_ResTVD-A132)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A132                                                 | =PA_Gn*A132                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 133 | =PA_ResTVD*9/20                                                                                                                                                                                             | =PA_Psi*IF(A133<PA_ShoeTVD,PA_FGs,PA_FG)*A133                           | =PA_Pres-PA_Gg*(PA_ResTVD-A133)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A133                                                 | =PA_Gn*A133                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 134 | =PA_ResTVD*10/20                                                                                                                                                                                            | =PA_Psi*IF(A134<PA_ShoeTVD,PA_FGs,PA_FG)*A134                           | =PA_Pres-PA_Gg*(PA_ResTVD-A134)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A134                                                 | =PA_Gn*A134                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 135 | =PA_ResTVD*11/20                                                                                                                                                                                            | =PA_Psi*IF(A135<PA_ShoeTVD,PA_FGs,PA_FG)*A135                           | =PA_Pres-PA_Gg*(PA_ResTVD-A135)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A135                                                 | =PA_Gn*A135                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 136 | =PA_ResTVD*12/20                                                                                                                                                                                            | =PA_Psi*IF(A136<PA_ShoeTVD,PA_FGs,PA_FG)*A136                           | =PA_Pres-PA_Gg*(PA_ResTVD-A136)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A136                                                 | =PA_Gn*A136                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 137 | =PA_ResTVD*13/20                                                                                                                                                                                            | =PA_Psi*IF(A137<PA_ShoeTVD,PA_FGs,PA_FG)*A137                           | =PA_Pres-PA_Gg*(PA_ResTVD-A137)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A137                                                 | =PA_Gn*A137                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 138 | =PA_ResTVD*14/20                                                                                                                                                                                            | =PA_Psi*IF(A138<PA_ShoeTVD,PA_FGs,PA_FG)*A138                           | =PA_Pres-PA_Gg*(PA_ResTVD-A138)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A138                                                 | =PA_Gn*A138                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 139 | =PA_ResTVD*15/20                                                                                                                                                                                            | =PA_Psi*IF(A139<PA_ShoeTVD,PA_FGs,PA_FG)*A139                           | =PA_Pres-PA_Gg*(PA_ResTVD-A139)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A139                                                 | =PA_Gn*A139                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 140 | =PA_ResTVD*16/20                                                                                                                                                                                            | =PA_Psi*IF(A140<PA_ShoeTVD,PA_FGs,PA_FG)*A140                           | =PA_Pres-PA_Gg*(PA_ResTVD-A140)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A140                                                 | =PA_Gn*A140                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 141 | =PA_ResTVD*17/20                                                                                                                                                                                            | =PA_Psi*IF(A141<PA_ShoeTVD,PA_FGs,PA_FG)*A141                           | =PA_Pres-PA_Gg*(PA_ResTVD-A141)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A141                                                 | =PA_Gn*A141                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 142 | =PA_ResTVD*18/20                                                                                                                                                                                            | =PA_Psi*IF(A142<PA_ShoeTVD,PA_FGs,PA_FG)*A142                           | =PA_Pres-PA_Gg*(PA_ResTVD-A142)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A142                                                 | =PA_Gn*A142                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 143 | =PA_ResTVD*19/20                                                                                                                                                                                            | =PA_Psi*IF(A143<PA_ShoeTVD,PA_FGs,PA_FG)*A143                           | =PA_Pres-PA_Gg*(PA_ResTVD-A143)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A143                                                 | =PA_Gn*A143                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |
| 144 | =PA_ResTVD*20/20                                                                                                                                                                                            | =PA_Psi*IF(A144<PA_ShoeTVD,PA_FGs,PA_FG)*A144                           | =PA_Pres-PA_Gg*(PA_ResTVD-A144)                                                                                                                                                                                                                                                                                                              | =PA_Psi*PA_KillMW*A144                                                 | =PA_Gn*A144                                                            |                                                                        |                                                                        |                          |                                      |                                 |                        |                     |                                                        |                    |           |                                  |                                                     |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.DE.Dir.DoglegSeverity | =LAMBDA(Inc1_deg, Azi1_deg, Inc2_deg, Azi2_deg, dMD_ft, DEGREES(2 * ASIN(SQRT(MIN(1, SIN(RADIANS(Inc2_deg - Inc1_deg) / 2)^2 + SIN(RADIANS(Inc1_deg)) * SIN(RADIANS(Inc2_deg)) * SIN(RADIANS(Azi2_deg - Azi1_deg) / 2)^2)))) * 100 / dMD_ft) | Dogleg severity in degrees per 100 ft between two directional surveys, from the inclinations, azimuths and course length. |
| PO.DE.Dir.RatioFactor | =LAMBDA(Dogleg_deg, IF(Dogleg_deg < 0.000001, 1, 2 / RADIANS(Dogleg_deg) * TAN(RADIANS(Dogleg_deg) / 2))) | Minimum curvature ratio factor from the dogleg angle over a course, degrees (1 for a straight course). |
| PO.DE.Dir.MinCurv.dTVD | =LAMBDA(Inc1_deg, Inc2_deg, dMD_ft, RF, dMD_ft / 2 * (COS(RADIANS(Inc1_deg)) + COS(RADIANS(Inc2_deg))) * RF) | Minimum curvature TVD increment, ft, over a course. |
| PO.CO.Schematic.Depths | =LAMBDA(MD_ft, Survey_MD, Survey_Inc, Survey_Azi, Survey_TVD, LET(n, COUNT(Survey_MD), k, IF(MD_ft < INDEX(Survey_MD, 1), 0, MATCH(MD_ft, Survey_MD, 1)), lo, MAX(1, MIN(k, n - 1)), hi, lo + 1, md_lo, INDEX(Survey_MD, lo), md_hi, INDEX(Survey_MD, hi), inc_lo, RADIANS(INDEX(Survey_Inc, lo)), inc_hi, RADIANS(INDEX(Survey_Inc, hi)), azi_lo, RADIANS(INDEX(Survey_Azi, lo)), azi_hi, RADIANS(INDEX(Survey_Azi, hi)), tvd_lo, INDEX(Survey_TVD, lo), dogleg, 2 * ASIN(SQRT(MIN(1, SIN((inc_hi - inc_lo) / 2)^2 + SIN(inc_lo) * SIN(inc_hi) * SIN((azi_hi - azi_lo) / 2)^2))), frac, (MD_ft - md_lo) / (md_hi - md_lo), cos_at, IF(dogleg < 0.000000001, COS(inc_lo), (SIN((1 - frac) * dogleg) * COS(inc_lo) + SIN(frac * dogleg) * COS(inc_hi)) / SIN(dogleg)), part, frac * dogleg, ratio, IF(part < 0.000000001, 1, 2 / part * TAN(part / 2)), IF(k = 0, tvd_lo - (md_lo - MD_ft), IF(k >= n, INDEX(Survey_TVD, hi) + (MD_ft - md_hi) * COS(inc_hi), tvd_lo + (MD_ft - md_lo) / 2 * (COS(inc_lo) + cos_at) * ratio)))) | TVD, ft, of a measured depth on a survey: minimum-curvature interpolation between the two stations around it, vertical above the first and straight on below the last. |
| 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.WI.PA.BalancedPlug | =LAMBDA(Slurry_bbl, Ahead_bbl, PlugHoleID_in, StringOD_in, StringID_in, Base_ft, LET(capA, (PlugHoleID_in^2 - StringOD_in^2)/1029.4, capP, StringID_in^2/1029.4, hIn, Slurry_bbl/(capA + capP), behind, Ahead_bbl*capP/capA, HSTACK(behind, hIn, Slurry_bbl/(PlugHoleID_in^2/1029.4), capP*(Base_ft - hIn) - behind))) | Balanced cement plug: {spacer behind bbl, plug height with the pipe in ft, height after pulling out ft, displacement bbl}. |
| PO.WI.Barrier.Status | =LAMBDA(Elements, IF(COUNT(Elements) = 0, 2, MAX(0, MIN(2, MAX(Elements))))) | Status of a well barrier envelope from its elements' statuses (0 intact, 1 degraded or not verified, 2 failed): the worst element governs, and an envelope with no element is failed. |
| PO.WI.Barrier.Rating | =LAMBDA(Primary, Secondary, LET(worst, MAX(Primary, Secondary), best, MIN(Primary, Secondary), IF(worst <= 0, 1, IF(worst = 1, IF(best <= 0, 2, 3), IF(best <= 0, 3, 4))))) | Well integrity category from the primary and secondary barrier statuses (0 intact, 1 degraded, 2 failed): 1 green, 2 yellow, 3 orange, 4 red. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| PA_LinerID | $B$4 | 7-in. 29 lb/ft production liner inside diameter, in |
| PA_LinerTOC | $B$5 | Top of cement behind the liner (its top at 6,900 ft), ft |
| PA_IntTOC | $B$6 | Top of cement behind the 9⅝-in. intermediate casing, ft |
| PA_Cut | $B$7 | Depth the 9⅝-in. casing is cut at and pulled from, ft |
| PA_SurfID | $B$8 | 13⅜-in. 72 lb/ft surface casing inside diameter, in |
| PA_SurfTOC | $B$9 | Top of cement behind the surface casing, ft |
| PA_SurfShoe | $B$10 | Surface casing shoe, ft |
| PA_PerfTop | $B$11 | Top perforation, the top of the reservoir's inflow, ft |
| PA_Pres | $B$13 | Reservoir pressure at the top perforation, psi |
| PA_Gg | $B$14 | Gas gradient (a gas column under a barrier, the worst case), psi/ft |
| PA_FG | $B$15 | Fracture gradient below the surface casing shoe, ppg |
| PA_FGs | $B$16 | Fracture gradient above the surface casing shoe, ppg |
| PA_Gn | $B$17 | Normal pore-pressure gradient of the shallow formations, psi/ft |
| PA_KillMW | $B$18 | Fluid left in the well between the plugs, ppg |
| PA_P1Base | $B$20 | Plug base (MD), ft |
| PA_P1Len | $B$21 | Plug length, ft |
| PA_P1Fdn | $B$22 | Foundation: 1 on a tested bridge plug, 0 none |
| PA_P1Ver | $B$23 | Verification: 0 tagged and pressure-tested, 1 not verified |
| PA_P2Base | $B$25 | Plug base (MD), ft |
| PA_P2Len | $B$26 | Plug length, ft |
| PA_P2Fdn | $B$27 | Foundation: 1 on a tested bridge plug, 0 none |
| PA_P2Ver | $B$28 | Verification: 0 tagged and pressure-tested, 1 not verified |
| PA_P3Base | $B$30 | Plug base (MD), ft |
| PA_P3Len | $B$31 | Plug length, ft |
| PA_P3Fdn | $B$32 | Foundation: 1 on a tested bridge plug, 0 none |
| PA_P3Ver | $B$33 | Verification: 0 tagged and pressure-tested, 1 not verified |
| PA_WsOD | $B$35 | Workstring outside diameter (2⅞-in. tubing), in |
| PA_WsID | $B$36 | Workstring inside diameter, in |
| PA_Ahead | $B$37 | Spacer pumped ahead of the cement, bbl |
| PA_Excess | $B$38 | Slurry excess over the plug's volume, % |
| PA_MinFdn | $B$39 | Minimum plug length on a tested foundation (50 m), ft |
| PA_MinOpen | $B$40 | Minimum plug length without one (100 m), ft |
| PA_Spread | $B$42 | Spread rate: the rig and its services, $/day |
| PA_MobDays | $B$43 | Move in and rig up, days |
| PA_PullDays | $B$44 | Kill the well and pull the completion, days |
| PA_PlugDays | $B$45 | Each plug: run, place, wait on cement, tag and test, days |
| PA_CutDays | $B$46 | Cut and pull the 9⅝-in. casing, days |
| PA_SiteDays | $B$47 | Cut the wellhead below ground and rig down, days |
| PA_CmtCost | $B$48 | Cement slurry, mixed and pumped, $/bbl |
| PA_BpCost | $B$49 | Each bridge plug, $ |
| PA_Fixed | $B$50 | Wellhead removal, site restoration and waste, $ |
| PA_Cont | $B$51 | Contingency, % |
| PA_Inputs | $B$4:$B$51 | The liner, intermediate and surface casing, their cement, the cut, the reservoir pressure and the rock's gradients, each plug's base, length, foundation and verification, the workstring, the minimum lengths and the rig time and prices |
| PA_ResTVD | $B$53 | Top perforation TVD, ft |
| PA_ShoeTVD | $B$54 | Surface casing shoe TVD, ft |
| PA_MinBase | $B$55 | Shallowest barrier base (the rock holds a gas column), ft |
| PA_PrimaryWords | $B$56 | Primary reservoir barrier |
| PA_Primary | $B$57 | Primary barrier status code |
| PA_SecondaryWords | $B$58 | Secondary reservoir barrier |
| PA_Secondary | $B$59 | Secondary barrier status code |
| PA_Rating | $B$60 | Reservoir integrity category (1 green to 4 red) |
| PA_Surface | $B$61 | Open-hole-to-surface barrier status code |
| PA_Slurry | $B$62 | Cement slurry, all plugs, bbl |
| PA_Days | $B$63 | Rig days, days |
| PA_TimeCost | $B$64 | Rig time at the spread rate, $ |
| PA_Materials | $B$65 | Materials and services, $ |
| PA_ContCost | $B$66 | Contingency, $ |
| PA_Total | $B$67 | Abandonment cost estimate, $ |
| PA_ReservoirCheck | $B$68 | Reservoir barriers check verdict |
| PA_ReservoirCheckNote | $C$68 | Reservoir barriers check comment |
| PA_DepthCheck | $B$69 | Reservoir barrier depth check verdict |
| PA_DepthCheckNote | $C$69 | Reservoir barrier depth check comment |
| PA_SurfaceCheck | $B$70 | Open-hole-to-surface check verdict |
| PA_SurfaceCheckNote | $C$70 | Open-hole-to-surface check comment |
| PA_PlacementCheck | $B$71 | Placement check verdict |
| PA_PlacementCheckNote | $C$71 | Placement check comment |
| PA_Results | $B$53:$B$71 | The reservoir and shoe TVDs, the shallowest reservoir barrier, the barriers' status and the reservoir's category, the slurry, the rig days, the cost estimate and the four checks |
| PA_Psi | $B$84 | Pressure gradient of 1 ppg of fluid, psi/ft/ppg |
| PA_Survey | $A$88:$C$97 | Survey stations: measured depth, inclination, azimuth |
| PA_SurveyTvd | $D$88:$F$97 | Each station's dogleg severity over the course above it, its ratio factor and its TVD by minimum curvature |
| PA_SvMD | $A$88:$A$97 | Survey station measured depths, ft |
| PA_SvInc | $B$88:$B$97 | Survey station inclinations, deg |
| PA_SvAzi | $C$88:$C$97 | Survey station azimuths, deg |
| PA_SvTVD | $F$88:$F$97 | Survey station TVDs by minimum curvature, ft |
| PA_Plan | $A$101:$Q$103 | Each permanent barrier's depths in MD and TVD, its casing and cement, its minimum length, the pressure under it and the rock's strength, its four elements and its status |
| PA_Placement | $A$107:$I$109 | Each plug's slurry, the spacer ahead and behind, the column heights with the pipe in and pulled, the displacement and the tops in MD |
| PA_Cost | $A$113:$E$120 | Each operation's rig days and their cost at the spread rate, and each material's cost |
| PA_Curve | $A$124:$E$144 | Each TVD to the reservoir: the fracture pressure, a gas column from the reservoir, the fluid left in the well and the normal pore pressure |

---

## Related Blueprints
- [Casing Design](/blueprint/po.de.casing.design.md)
- [Directional Survey Calculator](/blueprint/po.de.directional.survey.md)
- [Primary Cement Job Design](/blueprint/po.de.cement.volumes.md)
- [Tubing Stress and Movement](/blueprint/po.de.tubing.stress.md)
- [Hole Cleaning and Solids Control](/blueprint/po.de.holecleaning.solids.md)
- [Pore Pressure and Mud-Weight Window](/blueprint/po.de.pore.pressure.eaton.md)

