---
id: po.wb.completion.wellbore-schematic
title: Completion Schematic — Live Wellbore from a Casing and Completion Table
category: Drilling
requires: []
tags:
  - completion-schematic
  - wellbore-diagram
  - well-schematic
  - casing-program
  - completion
  - cell-art
  - conditional-formatting
---

# Completion Schematic — Live Wellbore from a Casing and Completion Table

## Description

A completion schematic for a vertical well that redraws itself. Enter the casing program (OD, top,
shoe and top of cement for the conductor, surface casing, intermediate casing and production liner)
and the completion (tubing, safety valve, gas-lift mandrels, packer, two perforated intervals, PBTD
and TD) on the Inputs sheet; the Schematic sheet paints the wellbore against depth and labels each
component. Move a packer, a shoe, a perforation or a liner top and the drawing and its labels move
with it.

The drawing is cell art: blank cells painted by ordered conditional-format rules keyed on each row's
depth and the named inputs. Every formula is plain Excel, so the workbook needs no add-in, and the
Schematic sheet prints on one page.

The schematic is 100 rows tall and a depth window sets what each row covers. By default it is the
whole well at 100 ft a row; set the window top and base to zoom in on the completion interval, where
10 ft a row turns a 60 ft perforated interval from one row into six. Radial widths are not to scale,
as completion schematics never are.

Input checks flag a set of depths that cannot describe one well — shoes that do not deepen, a packer
below the perforations, mandrels below the packer, a window that runs upward — in red with the fix
spelled out. A depth of 0 in a row marked (0 = none) leaves that component out.

## Inputs

Named cells you can edit — the drawing and its labels recalculate from them.

| Name | Description | Default | Unit |
|---|---|---|---|
| `CS_WellName` | Well name shown in the title | Example well A-12 | — |
| `CS_WinTop`, `CS_WinBase` | Depth window top and base (base 0 = TD) | 0, 0 | ft |
| `CS_CondOD`, `CS_SurfOD`, `CS_IntOD`, `CS_LinerOD` | Casing and liner OD | 20, 13.375, 9.625, 7 | in |
| `CS_*Top`, `CS_*Shoe` | String top and shoe | shoes 120, 2500, 7200, 9950 | ft |
| `CS_SurfTOC`, `CS_IntTOC`, `CS_LinerTOC` | Top of cement behind the surface, intermediate and liner strings | 0, 5500, 6900 | ft |
| `CS_TubingOD`, `CS_EOT` | Tubing OD and end of tubing | 3.5, 9400 | in, ft |
| `CS_SSSV` | Subsurface safety valve (0 = none) | 1500 | ft |
| `CS_GLM1`–`CS_GLM3` | Gas-lift mandrels (0 = none) | 3000, 5200, 6500 | ft |
| `CS_Packer` | Production packer (0 = none) | 9300 | ft |
| `CS_Perf1Top`–`CS_Perf2Base` | Perforated intervals (second 0 = none) | 9500–9560, 9650–9700 | ft |
| `CS_PBTD`, `CS_TD` | Plug-back and total depth | 9850, 10000 | ft |

## Sheets

- `Guide`
- `Inputs`
- `Schematic`
- `Calc`

The Schematic sheet carries 47 conditional-format rules on the drawing and one on its status line, and no shapes or charts.

## Functions used

None — plain Excel formulas only.