Surface Gathering Diagram — Generated from a Network Table, with Live Labels

A diagram of a surface gathering system, drawn from a table. Wells with wellhead pictures, chokes, a manifold, production and test separators and the outlets they feed (gas to the compressor, oil export, water disposal) are joined by flowline connectors glued to the shapes, so dragging a shape in Excel keeps its lines attached. The Network sheet is the table the drawing was generated from — a row for every piece of equipment and every connector — so the diagram cannot show a link the table does not hold.

Surface Gathering Diagram Excel workbook
GatheringDiagram.xlsx
Surface Gathering Diagram — Generated from a Network Table, with Live Labels: Guide sheetSurface Gathering Diagram — Generated from a Network Table, with Live Labels: Inputs sheetSurface Gathering Diagram — Generated from a Network Table, with Live Labels: Gathering sheetSurface Gathering Diagram — Generated from a Network Table, with Live Labels: Network sheet

The numbers stay live. The text in the manifold, the separators, the outlets and above each choke is linked to a cell that calculates from the Inputs (wellhead pressure and temperature, oil, water and gas rates, choke size and the route each well is lined up to, and the manifold and separator pressures); the details of each well are cells beside its wellhead. Route a well to the other separator and the separators' and outlets' rates move with it. Every formula is plain Excel, so the workbook needs no add-in.

The pipework is fixed in the file. A column per stage — wells, chokes, manifold, separators, outlets — and each shape at the mean height of what feeds it lay the diagram out from the table, so a well, its choke and the next shape stay on one straight line wherever they can. Add a well or a separator to the table and generate the workbook again: the layout finds it a place. A workbook cannot redraw itself, so changing the table in the file does not move a flowline.

Input checks flag a set of inputs that cannot be a gathering system — a well routed to a separator that does not exist, a wellhead pressure below the manifold, a manifold below a separator — in red with the fix spelled out. The workbook does not calculate the network: the choke's pressure drop is the wellhead pressure less the manifold pressure and the rates are those entered.

Inputs

Named ranges you can edit — the labels recalculate from them. The wells, separators and routes come from the Network table and are not inputs.

Name Description Default Unit
GS_WHP, GS_WHT Wellhead pressure and temperature, per well 1250/980/1510/760, 148/141/155/133 psi, °F
GS_Oil, GS_Water, GS_Gas Oil and water rates and gas rate, per well W-1: 1850, 420, 2100 bbl/d, Mscf/d
GS_Choke Choke size, per well 24, 28, 20, 32 1/64 in
GS_Route Separator a well is lined up to: Production or Test W-3 on Test, the others Production —
GS_Pman Manifold pressure 420 psi
GS_SepP Separator pressure, per separator 250 (production), 265 (test) psi

4 sheets, shown with the values the file opens with

A
1 Surface gathering diagram — drawn from a network table, with live labels
2
3 What this is
4 A diagram of a surface gathering system: wells, chokes, a manifold, separators and the outlets they feed, with flowlines between them. It was generated from a table — the Network sheet — and the numbers on it stay live: the text in the manifold, the separators, the outlets and above each choke is linked to a cell that calculates from the Inputs, and the details of each well are cells beside its wellhead. Every formula is plain Excel, so no add-in is needed.
5
6 Using it
7 Inputs — each well's wellhead pressure and temperature, rates, choke size and route, the manifold pressure and each separator's pressure. Change one and the labels on the Gathering sheet change. Blue cells on a yellow background are the ones to edit; checks at the bottom flag inputs that cannot be a gathering system, in red with the fix spelled out, and the Gathering sheet says so on its third line.
8 Gathering — the diagram. Route a well to the other separator and the separators' rates and the outlets' rates move with it.
9 Network — the table the diagram came from: a row for every piece of equipment and for every connector, and the Label formula each piece of equipment shows. Shapes are named after their rows (a choke's label box after the choke), so the Selection Pane lists them the way the table does.
10
11 What is live and what is fixed
12 Live: every number — the labels, the per-well cells and the status line. Fixed: the pipework and the layout. The diagram is drawn when the workbook is generated, from the table, and a workbook cannot redraw itself: to add a well or a separator, or to change what feeds an outlet, change the table and generate the workbook again. The layout rule is a column per stage — wells, chokes, manifold, separators, outlets — with each shape at the mean height of what feeds it, so a well, its choke and the next shape stay on one straight line wherever they can.
13
14 Moving things
15 Drag a shape and its flowlines stay attached: they are glued to the shapes, not drawn between two points, and an elbow re-routes as the shape moves. Dragging does not change the table, and a regenerated workbook starts from the layout rule again.
16
17 What it does not do
18 It does not calculate the network: the pressure drop across a choke is the wellhead pressure less the manifold pressure, and the rates are what you enter — there is no hydraulics here. It does not move a flowline when the table changes, and it has one manifold. It is a diagram with live labels, not a simulator.
Opens inWorks in any Excel: formulas and named LAMBDAs only, no add-in needed.
FileGatheringDiagram.xlsx, 17 KB
CategoryProduction
For agents and tools Structure (.json) · Descriptor (.md)
Tags:
gathering-systemsurface-facilitiesgathering-diagramflowlinechokemanifoldseparatornetwork-diagramconnectors

Need a workbook we don't have? Suggest a Workbook