Inflow Performance & Nodal Analysis

Demonstrates IPR curves using Fetkovich and Vogel models, then overlays a single-phase VFP (tubing performance) curve to find the well operating point. The intersection of IPR and VFP is the most fundamental production engineering calculation.

Inflow Performance & Nodal Analysis Excel workbook

InflowPerformanceRelationship.xlsx

Inflow Performance & Nodal Analysis: IPR Curves — Fetkovich vs Vogel (IPR Curves)

Inflow Performance & Nodal Analysis: Vogel IPR Curve (IPR Curves)

Inflow Performance & Nodal Analysis: Nodal Analysis — IPR vs VFP (Nodal Analysis)

Inflow Performance & Nodal Analysis: Inputs sheet

Inflow Performance & Nodal Analysis: IPR Curves sheet

Inflow Performance & Nodal Analysis: Nodal Analysis sheet

Description Preview Requirements

Inputs

Named cells you can edit — every result recalculates from them.

Name	Description	Default	Unit
`IPR_Pres`	Reservoir Pressure (Pres)	3000	psi
`IPR_Pb`	Bubble Point (Pb)	2500	psi
`IPR_C`	Performance Coefficient (C)	0.0015	STB/(d·psi^2n)
`IPR_n`	Flow Exponent (n)	0.85	dimensionless
`IPR_J`	Productivity Index (J)	2.0	STB/d/psi
`VFP_Pwh`	Wellhead Pressure	200	psi
`VFP_RhoL`	Liquid Density	50	lb/ft3
`VFP_UL`	Liquid Viscosity	1.5	cP
`VFP_ID`	Tubing ID	2.992	in
`VFP_Len`	Tubing Length	8000	ft
`VFP_Rough`	Roughness	0.0006	in
`VFP_Angle`	Pipe Angle (from horizontal)	90	degrees

3 sheets, shown with the values the file opens with

	A	B	C
1	Inflow Performance — Inputs
2	Reservoir and well parameters for IPR and VFP calculations. The IPR Curves sheet compares Fetkovich and Vogel models. The Nodal Analysis sheet overlays IPR with a VFP curve to find the operating point.
3
4	Reservoir Properties
5	Reservoir Pressure (Pres)	3000	psi
6	Bubble Point (Pb)	2500	psi
7
8	Fetkovich Parameters
9	Performance Coefficient (C)	0.0015	STB/(d·psi^2n)
10	Flow Exponent (n)	0.85	dimensionless
11
12	Vogel Parameters
13	Productivity Index (J)	2	STB/d/psi
14
15	VFP / Tubing Properties
16	Wellhead Pressure	200	psi
17	Liquid Density	50	lb/ft3
18	Liquid Viscosity	1.5	cP
19	Tubing ID	2.992	in
20	Tubing Length	8000	ft
21	Roughness	0.0006	in
22	Pipe Angle (from horizontal)	90	degrees
23
24	Calculated AOF
25	AOF (Fetkovich)	1222.355109	STB/d

	A	B	C
1	IPR Curves — Fetkovich vs Vogel
2	Fetkovich uses backpressure equation (C, n parameters from well test). Vogel uses productivity index and accounts for two-phase flow below bubble point.
3
4	IPR Comparison Table
5	Pwf (psi)	q Fetkovich	q Vogel
6	3000	0	0
7	2800	214.2301293	400
8	2600	374.802151	800
9	2400	512.9257684	1196.444444
10	2200	634.3377977	1568
11	2000	741.6786247	1911.111111
12	1800	836.4700007	2225.777778
13	1600	919.6958913	2512
14	1400	992.0373403	2769.777778
15	1200	1053.985862	2999.111111
16	1000	1105.904813	3200
17	800	1148.065311	3372.444444
18	600	1180.668401	3516.444444
19	400	1203.859168	3632
20	200	1217.735781	3719.111111
21	0	1222.355109	3777.777778
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66

Fetkovich

Vogel

	A	B	C
1	Nodal Analysis — IPR + VFP
2	The operating point is where IPR (inflow) intersects VFP (outflow). IPR shows what the reservoir can deliver; VFP shows what the tubing requires. The intersection determines the well's production rate and flowing bottomhole pressure.
3
4	Nodal Analysis Table
5	q (STB/d)	Pwf_IPR (psi)	Pwf_VFP (psi)
6	12.2	2993.337571	2977.792326
7	16.0	2990.867147	2977.796792
8	20.9	2987.472281	2977.80264
9	27.3	2982.817686	2977.810278
10	35.7	2976.429501	2977.820257
11	46.7	2967.649797	2977.833307
12	61.0	2955.58092	2977.850357
13	79.7	2938.949851	2977.872658
14	104.2	2916.014036	2977.901798
15	136.2	2884.276564	2978.050114
16	178.1	2840.212269	2978.20726
17	232.8	2778.682006	2978.457174
18	304.3	2692.083599	2978.855705
19	397.7	2568.661559	2979.493226
20	519.9	2389.177404	2980.516185
21	679.6	2118.652238	2982.162747
22	888.3	1678.532716	2984.821844
23	1161.2	725.9774891	2989.131317
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

IPR (Fetkovich) VFP (Tubing)

Name	Refers To	Comment
IPR_AOF	Inputs!$B$25
IPR_C	Inputs!$B$9
IPR_J	Inputs!$B$13
IPR_Pb	Inputs!$B$6
IPR_Pres	Inputs!$B$5
IPR_n	Inputs!$B$10
VFP_Angle	Inputs!$B$22
VFP_ID	Inputs!$B$19
VFP_Len	Inputs!$B$20
VFP_Pwh	Inputs!$B$16
VFP_RhoL	Inputs!$B$17
VFP_Rough	Inputs!$B$21
VFP_UL	Inputs!$B$18

Opens in	Needs the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates.
Functions used	PO.IPR.VW.PSS.AOF.ByFetkovich PO.IPR.VW.PSS.Rate.ByFetkovich PO.IPR.VW.PSS.Rate.ByVogel PO.VFP.Liq.Pin
File	InflowPerformanceRelationship.xlsx, 17 KB
Category	Production
For agents and tools	Structure (.json) · Descriptor (.md)

More Production Workbooks

Decline Curve Analysis — Arps with EUR

PO Add-in

Complete Arps decline analysis: forecast rate and cumulative production over 20 years, calculate EUR at economic limit, and compare b-exponent sensitivity (b=0, 0.5, 1.0). Named input cells for qi, Di, b, and economic limit rate.

Decline Model Comparison — Arps, Duong, PLE

PO Add-in

Side-by-side comparison of three decline models with EUR analysis. Named inputs for all model parameters. 21 time steps out to 360 months with model spread analysis.

Field Production Profile — Buildup-Plateau-Decline

PO Add-in

Three-phase field production profile with formula-derived phase transitions. Named input cells for buildup time, plateau duration, plateau rate, and decline parameters. 25 time steps out to 120 months.

Inverted ESP Sizing — Downhole Water Sink

PO Add-in

Sizes an electric submersible pump that runs inverted in a downhole water sink (DWS) or downhole water loop (DWL) completion: water drained below the oil–water contact is pumped down through an isolation packer and re-injected into the base of the same aquifer. Nothing is lifted to surface, so the system curve is drainage drawdown plus injection build-up plus a short friction path — for a hydrostatically connected aquifer, a straight line through the origin.

Single-Phase Liquid Pipe Flow

PO Add-in

Single-phase liquid flow in vertical tubing with named inputs and rate sensitivity analysis. Shows friction loss, gravity head, Reynolds number, and required BHP at 14 rate points.

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

Excel 2016+

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.

Tapered Rod String Analysis

PO Add-in

Static loads, stress and stretch for a sucker rod string made of up to four rod sizes. Each taper is one row, top taper first; unused rows are left blank. For each taper it returns the rod area, the weight in air and in the well fluid, the load and stress at the top of the taper and the taper's stretch. For the string it returns the static peak and minimum polished rod loads, the highest rod stress and the total stretch.

Tags:

iprfetkovichvogelvfpnodal-analysisoperating-pointaof