---
cid: po.bp.ipr.multilayer
hub: ipr
tags: [IPR, multilayer, commingled, crossflow, Vogel, productivity-index, inflow-performance, shut-in, layer-allocation]
facets: { discipline: reservoir, property: pi, model: vogel, method-type: analytical }
title: Multilayer Oil IPR With Crossflow at Shut-In
summary: "Splits a commingled well's rate among three sands at its flowing pressure and shows the crossflow between them at shut-in."
slug: po.ipr.multilayer
type: worksheet
---

# Multilayer Oil IPR With Crossflow at Shut-In

## Description

How much oil does a well commingling three sands make at its flowing pressure, how much comes from each sand, and what happens between them when it is shut in? You enter the oil and drainage area the sands share, each sand's pressure, permeability, net pay and skin, and the flowing pressure. You read off each sand's productivity index and rate, the well's rate, AOF and split by sand, the PI-weighted shut-in pressure, and the crossflow from the higher sands into the lower one.

**Parameters:**
- **The oil and the drainage area**, shared by the sands: the bubble point `IML_Pb` (psi), Bo `IML_Bo` (bbl/STB), μo `IML_Uo` (cp), and the drainage and wellbore radii `IML_re` and `IML_rw` (ft)
- **Each sand** (upper `U`, middle `M`, lower `L`): its average pressure at the datum `IML_PrU`, `IML_PrM`, `IML_PrL` (psi), permeability `IML_kU`… (mD), net pay `IML_hU`… (ft) and skin `IML_sU`…
- **Operating point and limit**: the flowing bottomhole pressure at the datum `IML_PwfOp` (psi) and the crossflow accepted at shut-in `IML_XfTol` (STB/d)

**How to use it:** Take each sand's pressure from a formation-tester survey (RFT or MDT) referred to one datum, its k·h and skin from a test of that sand alone (or a layered test), the oil's properties from the PVT report, and check the split against a production log. Where the sands hold different oils, their own Bo and μo change their PIs; the sheet takes one oil. A chart draws each sand's IPR and the well's, with the operating point, the shut-in pressure and the AOF. Three checks read the flow at the operating pressure, the crossflow at shut-in and whether the PI-weighted shut-in pressure balances.

**Method:** Each sand has its own pressure and its own productivity index, from its permeability, net pay and skin: the radial pseudosteady-state one, J = k·h/(141.2·Bo·μo·(ln(re/rw) − 0.75 + s)). At a common flowing pressure Pwf, each sand's rate is the composite IPR at MIN(Pwf, Pr): J·(Pr − Pwf) down to Pb, then Vogel's curve with its AOF at J·Pb/1.8 below it, or Vogel's curve alone from Pr when the sand is at or below its bubble point. The composite rate function stops at Pwf = Pr, so the sheet clamps the flowing pressure to the sand's and adds J·MIN(0, Pr − Pwf): a sand whose pressure is below the wellbore's doesn't produce, it takes fluid at its PI, the injectivity of a liquid-filled layer. The sheet adds the three rates in its own cells for the well's rate and the AOF, and each sand's share is its rate over the inflow from the sands that produce. Shut in, the wellbore pressure is where the three rates sum to zero; while every sand is on its straight part there, that is the PI-weighted pressure Σ(J·Pr)/ΣJ, and the sheet takes it and shows the net rate left at it. The higher sands then push oil into the lower one: the crossflow is the sum of the positive rates there, and the sand that takes it is the one with the most negative. The grid steps the flowing pressure from the highest sand pressure to zero in sixteen steps.

**Example:** The middle sand is the oil-inflow family's reference sand, the one the Composite Oil IPR, Fetkovich Oil IPR Fitted to a Multi-Rate Test, Klins-Clark Oil IPR, Productivity Index and Flow Efficiency and Skin Sensitivity of the IPR sheets start from: a vertical oil well on 160 acres (re = 1,490 ft, rw = 0.354 ft) in 50 ft of 20 mD sand, producing the reference black oil (Ahmed's oil 2, Pb = 2,620 psi, Bo = 1.467 rb/STB and μo = 0.302 cp at 4,000 psi) from a 4,000 psi reservoir, with a total skin of 5 from a buildup. The well also opens two more sands of the same oil in the same drainage area: an upper sand, 15 ft of 60 mD with a skin of 2, depleted to 2,400 psi by an offset producer, below its bubble point; and a lower sand, 30 ft of 8 mD with a skin of 3, at 4,300 psi. The pressures are referred to one datum, the mid-perforations. The well flows at 2,000 psi, and 50 STB/d of crossflow at shut-in is accepted.

ln(1,490/0.354) − 0.75 = 7.595, and 141.2 × 1.467 × 0.302 = 62.556, so the sands' PIs are 900/(62.556 × 9.595) = 1.4994 (upper), 1,000/(62.556 × 12.595) = 1.2692 (middle, the reference sand's) and 240/(62.556 × 10.595) = 0.36211 STB/d/psi (lower): 3.1307 in all. Shut in, the wellbore sits at (1.4994 × 2,400 + 1.2692 × 4,000 + 0.36211 × 4,300)/3.1307 = 3,268.4 psi, above the bubble point, so the PI-weighted pressure is exact (net 0). There the middle sand pushes 928.6 and the lower 373.6 STB/d into the upper sand, 1,302.1 STB/d of crossflow: the shut-in check warns. At 2,000 psi every sand flows. The upper sand, below its bubble point, is on Vogel's curve from 2,400 psi: 1,999.2 × (1 − 0.2 × 0.8333 − 0.8 × 0.6944) = 555.3 STB/d. The middle sand makes 1.2692 × 1,380 = 1,751.5 STB/d on its straight line to 2,620 psi and 1,847.4 × 0.3812 = 704.1 on Vogel's curve below, 2,455.6; the lower 608.3 + 200.9 = 809.2. The well makes 3,820.2 STB/d: 14.5 %, 64.3 % and 21.2 % from the three sands. The AOF is 6,733.5 STB/d.

## Validity

The PI is the radial pseudosteady-state one for each sand alone, with no vertical communication between them in the reservoir, only through the wellbore: commingled sands separated by shale. Sands in vertical communication behave as one layer with an average permeability. Each sand's pressure is taken at the datum; the head of the oil between the sands' depths (about 0.35 psi/ft) has to be added to or taken from their gauge pressures first. A sand taking fluid is taken at its PI, its injectivity for the oil that crosses into it, which holds for a liquid-filled sand above its bubble point; the depleted upper sand here has free gas, so the crossflow into it is an estimate. The PI-weighted shut-in pressure is exact only when every sand is on its straight line there; when a producing sand is below its bubble point at that pressure, the net rate left over says how far off it is, and the shut-in pressure is then where the well's curve crosses zero.

Named alternatives: the steady-state PI for steady-state sands and the transient-flow PI for a sand still in transient flow; the Composite Oil IPR sheet for one sand; a production log to measure the split; and a layered reservoir model when the sands cross-flow in the reservoir.

## References

- Vogel, J.V. (1968). "Inflow Performance Relationships for Solution-Gas Drive Wells." *JPT* 20(1), 83–92.
- Fetkovich, M.J., Bradley, M.D., Works, A.M. and Thrasher, T.S. (1990). "Depletion Performance of Layered Reservoirs Without Crossflow." *SPE Formation Evaluation* 5(3), 310–318.
- Lefkovits, H.C., Hazebroek, P., Allen, E.E. and Matthews, C.S. (1961). "A Study of the Behavior of Bounded Reservoirs Composed of Stratified Layers." *SPE Journal* 1(1), 43–58.
- Economides, M.J., Hill, A.D., Ehlig-Economides, C. and Zhu, D. (2013). *Petroleum Production Systems*, 2nd ed. Prentice Hall, ch. 3 and 5 (composite IPR, multilayer wells).
- Ahmed, T. (2019). *Reservoir Engineering Handbook*, 5th ed. Gulf Professional Publishing (oil 2).

## Functions used

`PO.IPR.VW.PSS.PI`, `PO.IPR.VW.PSS.Rate.ByVogel`

## Spreadsheet: IprMultilayer

|    | A                                                                                                                                                                                       | B                                                                                               | C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | D                                                                                                     | E                                                                                                         | F                                | G                                                                                         |
|----|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------|----------------------------------|-------------------------------------------------------------------------------------------|
| 1  | Multilayer Oil IPR With Crossflow at Shut-In                                                                                                                                            |                                                                                                 | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 2  | Blue cells on yellow are inputs. Type each sand's pressure, permeability, pay and skin; each layer's PI, the well's rate split by layer and the crossflow when it is shut in follow.    |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 3  | The Oil and the Drainage Area (Shared by the Layers)                                                                                                                                    |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 4  | Bubble point pressure, Pb                                                                                                                                                               | 2620                                                                                            | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 5  | Oil formation volume factor, Bo                                                                                                                                                         | 1.467                                                                                           | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 6  | Oil viscosity, μo                                                                                                                                                                       | 0.302                                                                                           | cp                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 7  | Drainage radius, re                                                                                                                                                                     | 1490                                                                                            | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 8  | Wellbore radius, rw                                                                                                                                                                     | 0.354                                                                                           | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 9  | Upper sand                                                                                                                                                                              |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 10 | Upper sand: average pressure at the datum                                                                                                                                               | 2400                                                                                            | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 11 | Upper sand: permeability                                                                                                                                                                | 60                                                                                              | mD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 12 | Upper sand: net pay                                                                                                                                                                     | 15                                                                                              | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 13 | Upper sand: skin                                                                                                                                                                        | 2                                                                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 14 | Middle sand                                                                                                                                                                             |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 15 | Middle sand: average pressure at the datum                                                                                                                                              | 4000                                                                                            | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 16 | Middle sand: permeability                                                                                                                                                               | 20                                                                                              | mD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 17 | Middle sand: net pay                                                                                                                                                                    | 50                                                                                              | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 18 | Middle sand: skin                                                                                                                                                                       | 5                                                                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 19 | Lower sand                                                                                                                                                                              |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 20 | Lower sand: average pressure at the datum                                                                                                                                               | 4300                                                                                            | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 21 | Lower sand: permeability                                                                                                                                                                | 8                                                                                               | mD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 22 | Lower sand: net pay                                                                                                                                                                     | 30                                                                                              | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 23 | Lower sand: skin                                                                                                                                                                        | 3                                                                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 24 | Operating Point and Limit                                                                                                                                                               |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 25 | Flowing bottomhole pressure at the datum                                                                                                                                                | 2000                                                                                            | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 26 | Crossflow at shut-in accepted                                                                                                                                                           | 50                                                                                              | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 28 | Productivity Index of Each Layer                                                                                                                                                        |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 29 | Upper sand: liquid PI, J                                                                                                                                                                | =PO.IPR.VW.PSS.PI(IML_kU,IML_hU,IML_Bo,IML_Uo,IML_re,IML_rw,IML_sU)                             | STB/d/psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 30 | Middle sand: liquid PI, J                                                                                                                                                               | =PO.IPR.VW.PSS.PI(IML_kM,IML_hM,IML_Bo,IML_Uo,IML_re,IML_rw,IML_sM)                             | STB/d/psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 31 | Lower sand: liquid PI, J                                                                                                                                                                | =PO.IPR.VW.PSS.PI(IML_kL,IML_hL,IML_Bo,IML_Uo,IML_re,IML_rw,IML_sL)                             | STB/d/psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 32 | The well's PI, the layers' sum                                                                                                                                                          | =IML_JU+IML_JM+IML_JL                                                                           | STB/d/psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 33 | Shut In: the Wellbore Pressure and the Crossflow                                                                                                                                        |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 34 | Shut-in wellbore pressure, PI-weighted, Σ(J·Pr)/ΣJ                                                                                                                                      | =(IML_JU*IML_PrU+IML_JM*IML_PrM+IML_JL*IML_PrL)/IML_J                                           | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 35 | Net rate into the wellbore at that pressure                                                                                                                                             | =SUM(D57:D59)                                                                                   | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 36 | Crossflow at shut-in, from the higher sands                                                                                                                                             | =SUMIF(D57:D59,">0")                                                                            | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 37 | The sand that takes it                                                                                                                                                                  | =""&IF(IML_Xf<IML_NetTol,"None",INDEX(A57:A59,MATCH(MIN(D57:D59),D57:D59,0)))                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 38 | Flowing: the Well's Rate and Its Split                                                                                                                                                  |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 39 | Oil rate at the flowing pressure, the layers' sum                                                                                                                                       | =E60                                                                                            | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 40 | Absolute open flow, the layers' sum at Pwf = 0                                                                                                                                          | =G60                                                                                            | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 41 | Inflow from the sands that produce                                                                                                                                                      | =SUMIF(E57:E59,">0")                                                                            | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 42 | Rate the sands below the wellbore take                                                                                                                                                  | =-SUMIF(E57:E59,"<0")                                                                           | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 43 | The sand that takes it while flowing                                                                                                                                                    | =""&IF(IML_Take<IML_NetTol,"None",INDEX(A57:A59,MATCH(MIN(E57:E59),E57:E59,0)))                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 44 | Largest contributor                                                                                                                                                                     | =""&INDEX(A57:A59,MATCH(MAX(E57:E59),E57:E59,0))                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 45 | Its share of the inflow                                                                                                                                                                 | =MAX(F57:F59)                                                                                   | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 46 | Highest layer pressure, the top of the grid                                                                                                                                             | =MAX(IML_PrU,IML_PrM,IML_PrL)                                                                   | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 47 | Flow check                                                                                                                                                                              | =IF(IML_q<=0,"FAIL",IF(IML_Take>0,"WARN","PASS"))                                               | =IF(IML_q<=0,"at "&TEXT(IML_PwfOp,"#,##0")&" psi the well makes no oil, above its "&TEXT(IML_Pws,"#,##0")&" psi shut-in pressure: the sands only cross-flow",IF(IML_Take>0,"the well makes "&TEXT(IML_q,"#,##0")&" STB/d, but at "&TEXT(IML_PwfOp,"#,##0")&" psi the "&LOWER(IML_Taker)&" takes "&TEXT(IML_Take,"#,##0")&" STB/d from the other sands: draw it down below its pressure","every sand flows at "&TEXT(IML_PwfOp,"#,##0")&" psi, "&TEXT(IML_q,"#,##0")&" STB/d in all, "&TEXT(IML_TopShare,"0%")&" from the "&LOWER(IML_Top))) |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 48 | Shut-in crossflow check                                                                                                                                                                 | =IF(IML_Xf<=IML_XfTol,"PASS","WARN")                                                            | =IF(IML_Xf<=IML_XfTol,"shut in, the sands cross-flow "&TEXT(IML_Xf,"#,##0")&" STB/d, within the "&TEXT(IML_XfTol,"#,##0")&" STB/d accepted","shut in at "&TEXT(IML_Pws,"#,##0")&" psi, the higher sands push "&TEXT(IML_Xf,"#,##0")&" STB/d into the "&LOWER(IML_Thief)&": isolate it or keep the well on")                                                                                                                                                                                                                                 |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 49 | Shut-in pressure check                                                                                                                                                                  | =IF(ABS(IML_NetWs)<IML_NetTol,"PASS","WARN")                                                    | =IF(ABS(IML_NetWs)<IML_NetTol,"every sand is on its straight line at the shut-in pressure, so the PI-weighted pressure is exact","a producing sand is below its bubble point at the PI-weighted pressure, which leaves "&FIXED(IML_NetWs,2)&" STB/d unbalanced, "&FIXED(IML_NetWs/IML_J,2)&" psi: read the shut-in pressure off the curve where the well's rate is 0")                                                                                                                                                                      |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 51 | How to use it: each sand's pressure from an RFT or MDT survey referred to one datum, k·h and skin from a test of that sand alone, and the split from a production log.                  |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 52 | Each layer's rate is the composite Vogel IPR at the flowing pressure, clamped to its own pressure, plus J·(Pr − Pwf) below 0 when the wellbore is above it: the layer then takes fluid. |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 53 | Shut in, the wellbore sits at the PI-weighted pressure and the higher sands drain into the lower: the depleted upper sand here.                                                         |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 55 | Each Layer: Shut In, at the Flowing Pressure and at Pwf = 0                                                                                                                             |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 56 | Layer                                                                                                                                                                                   | Pressure (psi)                                                                                  | J (STB/d/psi)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Shut in (STB/d)                                                                                       | At the Pwf (STB/d)                                                                                        | Share of inflow (%)              | At Pwf = 0 (STB/d)                                                                        |
| 57 | Upper sand                                                                                                                                                                              | =IML_PrU                                                                                        | =IML_JU                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN(IML_Pws,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-IML_Pws) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN(IML_PwfOp,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-IML_PwfOp) | =IF(IML_Gross>0,E57/IML_Gross,0) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN(0,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-0) |
| 58 | Middle sand                                                                                                                                                                             | =IML_PrM                                                                                        | =IML_JM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN(IML_Pws,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-IML_Pws) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN(IML_PwfOp,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-IML_PwfOp) | =IF(IML_Gross>0,E58/IML_Gross,0) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN(0,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-0) |
| 59 | Lower sand                                                                                                                                                                              | =IML_PrL                                                                                        | =IML_JL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN(IML_Pws,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-IML_Pws) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN(IML_PwfOp,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-IML_PwfOp) | =IF(IML_Gross>0,E59/IML_Gross,0) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN(0,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-0) |
| 60 | Well                                                                                                                                                                                    | =IML_Pws                                                                                        | =IML_J                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | =SUM(D57:D59)                                                                                         | =SUM(E57:E59)                                                                                             | =IF(IML_Gross>0,E60/IML_Gross,0) | =SUM(G57:G59)                                                                             |
| 62 | The Well's Key Points                                                                                                                                                                   |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 63 | Point                                                                                                                                                                                   | Oil rate (STB/d)                                                                                | Flowing pressure (psi)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 64 | Operating point                                                                                                                                                                         | =IML_q                                                                                          | =IML_PwfOp                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 65 | Shut in                                                                                                                                                                                 | =0                                                                                              | =IML_Pws                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 66 | AOF                                                                                                                                                                                     | =IML_AOF                                                                                        | =0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 68 | IPR of Each Layer and of the Well, From the Highest Layer Pressure to Zero                                                                                                              |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 69 | Flowing pressure (psi)                                                                                                                                                                  | Upper sand (STB/d)                                                                              | Middle sand (STB/d)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Lower sand (STB/d)                                                                                    | Well (STB/d)                                                                                              |                                  |                                                                                           |
| 70 | =IML_PrMax*16/16                                                                                                                                                                        | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A70,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A70) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A70,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A70)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A70,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A70)       | =SUM(B70:D70)                                                                                             |                                  |                                                                                           |
| 71 | =IML_PrMax*15/16                                                                                                                                                                        | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A71,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A71) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A71,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A71)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A71,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A71)       | =SUM(B71:D71)                                                                                             |                                  |                                                                                           |
| 72 | =IML_PrMax*14/16                                                                                                                                                                        | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A72,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A72) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A72,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A72)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A72,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A72)       | =SUM(B72:D72)                                                                                             |                                  |                                                                                           |
| 73 | =IML_PrMax*13/16                                                                                                                                                                        | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A73,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A73) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A73,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A73)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A73,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A73)       | =SUM(B73:D73)                                                                                             |                                  |                                                                                           |
| 74 | =IML_PrMax*12/16                                                                                                                                                                        | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A74,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A74) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A74,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A74)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A74,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A74)       | =SUM(B74:D74)                                                                                             |                                  |                                                                                           |
| 75 | =IML_PrMax*11/16                                                                                                                                                                        | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A75,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A75) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A75,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A75)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A75,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A75)       | =SUM(B75:D75)                                                                                             |                                  |                                                                                           |
| 76 | =IML_PrMax*10/16                                                                                                                                                                        | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A76,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A76) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A76,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A76)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A76,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A76)       | =SUM(B76:D76)                                                                                             |                                  |                                                                                           |
| 77 | =IML_PrMax*9/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A77,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A77) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A77,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A77)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A77,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A77)       | =SUM(B77:D77)                                                                                             |                                  |                                                                                           |
| 78 | =IML_PrMax*8/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A78,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A78) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A78,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A78)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A78,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A78)       | =SUM(B78:D78)                                                                                             |                                  |                                                                                           |
| 79 | =IML_PrMax*7/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A79,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A79) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A79,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A79)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A79,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A79)       | =SUM(B79:D79)                                                                                             |                                  |                                                                                           |
| 80 | =IML_PrMax*6/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A80,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A80) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A80,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A80)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A80,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A80)       | =SUM(B80:D80)                                                                                             |                                  |                                                                                           |
| 81 | =IML_PrMax*5/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A81,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A81) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A81,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A81)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A81,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A81)       | =SUM(B81:D81)                                                                                             |                                  |                                                                                           |
| 82 | =IML_PrMax*4/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A82,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A82) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A82,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A82)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A82,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A82)       | =SUM(B82:D82)                                                                                             |                                  |                                                                                           |
| 83 | =IML_PrMax*3/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A83,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A83) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A83,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A83)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A83,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A83)       | =SUM(B83:D83)                                                                                             |                                  |                                                                                           |
| 84 | =IML_PrMax*2/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A84,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A84) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A84,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A84)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A84,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A84)       | =SUM(B84:D84)                                                                                             |                                  |                                                                                           |
| 85 | =IML_PrMax*1/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A85,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A85) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A85,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A85)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A85,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A85)       | =SUM(B85:D85)                                                                                             |                                  |                                                                                           |
| 86 | =IML_PrMax*0/16                                                                                                                                                                         | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JU,IML_PrU,MIN($A86,IML_PrU),IML_Pb)+IML_JU*MIN(0,IML_PrU-$A86) | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JM,IML_PrM,MIN($A86,IML_PrM),IML_Pb)+IML_JM*MIN(0,IML_PrM-$A86)                                                                                                                                                                                                                                                                                                                                                                                                                                             | =PO.IPR.VW.PSS.Rate.ByVogel(IML_JL,IML_PrL,MIN($A86,IML_PrL),IML_Pb)+IML_JL*MIN(0,IML_PrL-$A86)       | =SUM(B86:D86)                                                                                             |                                  |                                                                                           |
| 88 | Constants                                                                                                                                                                               |                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                       |                                                                                                           |                                  |                                                                                           |
| 89 | Net rate below which the shut-in pressure balances                                                                                                                                      | 1                                                                                               | STB/d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                       |                                                                                                           |                                  |                                                                                           |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| IML_Pb | $B$4 | Bubble point pressure, Pb, psi |
| IML_Bo | $B$5 | Oil formation volume factor, Bo, bbl/STB |
| IML_Uo | $B$6 | Oil viscosity, μo, cp |
| IML_re | $B$7 | Drainage radius, re, ft |
| IML_rw | $B$8 | Wellbore radius, rw, ft |
| IML_PrU | $B$10 | Upper sand: average pressure at the datum, psi |
| IML_kU | $B$11 | Upper sand: permeability, mD |
| IML_hU | $B$12 | Upper sand: net pay, ft |
| IML_sU | $B$13 | Upper sand: skin |
| IML_PrM | $B$15 | Middle sand: average pressure at the datum, psi |
| IML_kM | $B$16 | Middle sand: permeability, mD |
| IML_hM | $B$17 | Middle sand: net pay, ft |
| IML_sM | $B$18 | Middle sand: skin |
| IML_PrL | $B$20 | Lower sand: average pressure at the datum, psi |
| IML_kL | $B$21 | Lower sand: permeability, mD |
| IML_hL | $B$22 | Lower sand: net pay, ft |
| IML_sL | $B$23 | Lower sand: skin |
| IML_PwfOp | $B$25 | Flowing bottomhole pressure at the datum, psi |
| IML_XfTol | $B$26 | Crossflow at shut-in accepted, STB/d |
| IML_Inputs | $B$4:$B$26 | The oil's bubble point, Bo and viscosity, the drainage and wellbore radii, each sand's pressure, permeability, net pay and skin, the flowing pressure and the crossflow accepted at shut-in |
| IML_JU | $B$29 | Upper sand: liquid PI, J, STB/d/psi |
| IML_JM | $B$30 | Middle sand: liquid PI, J, STB/d/psi |
| IML_JL | $B$31 | Lower sand: liquid PI, J, STB/d/psi |
| IML_J | $B$32 | The well's PI, the layers' sum, STB/d/psi |
| IML_Pws | $B$34 | Shut-in wellbore pressure, PI-weighted, Σ(J·Pr)/ΣJ, psi |
| IML_NetWs | $B$35 | Net rate into the wellbore at that pressure, STB/d |
| IML_Xf | $B$36 | Crossflow at shut-in, from the higher sands, STB/d |
| IML_Thief | $B$37 | The sand that takes it |
| IML_q | $B$39 | Oil rate at the flowing pressure, the layers' sum, STB/d |
| IML_AOF | $B$40 | Absolute open flow, the layers' sum at Pwf = 0, STB/d |
| IML_Gross | $B$41 | Inflow from the sands that produce, STB/d |
| IML_Take | $B$42 | Rate the sands below the wellbore take, STB/d |
| IML_Taker | $B$43 | The sand that takes it while flowing |
| IML_Top | $B$44 | Largest contributor |
| IML_TopShare | $B$45 | Its share of the inflow, % |
| IML_PrMax | $B$46 | Highest layer pressure, the top of the grid, psi |
| IML_FlowCheck | $B$47 | Flow check verdict |
| IML_FlowCheckNote | $C$47 | Flow check comment |
| IML_XfCheck | $B$48 | Shut-in crossflow check verdict |
| IML_XfCheckNote | $C$48 | Shut-in crossflow check comment |
| IML_WsCheck | $B$49 | Shut-in pressure check verdict |
| IML_WsCheckNote | $C$49 | Shut-in pressure check comment |
| IML_Results | $B$29:$B$49 | Each layer's PI and the well's, the PI-weighted shut-in pressure, the crossflow at shut-in and the sand that takes it, the well's rate, AOF and inflow, the rate the sands take while flowing, the largest contributor, and the three checks |
| IML_Layers | $A$57:$G$60 | Each sand's pressure and PI, its rate shut in (negative: it takes fluid), at the flowing pressure and its share, and at Pwf = 0, with the well's totals |
| IML_qWsU | $D$57 | Upper sand: rate with the well shut in, STB/d (negative: it takes fluid) |
| IML_qU | $E$57 | Upper sand: rate at the flowing pressure, STB/d |
| IML_qWsM | $D$58 | Middle sand: rate with the well shut in, STB/d (negative: it takes fluid) |
| IML_qM | $E$58 | Middle sand: rate at the flowing pressure, STB/d |
| IML_qWsL | $D$59 | Lower sand: rate with the well shut in, STB/d (negative: it takes fluid) |
| IML_qL | $E$59 | Lower sand: rate at the flowing pressure, STB/d |
| IML_Points | $A$64:$C$66 | The operating point, the shut-in pressure and the AOF, the chart's markers |
| IML_Curve | $A$70:$E$86 | The flowing pressure in sixteen steps from the highest layer pressure to zero, each layer's rate (negative: it takes fluid) and the well's |
| IML_NetTol | $B$89 | Net rate below which the shut-in pressure balances, STB/d |

---

## Related Blueprints
- [Skin Sensitivity of the IPR](/blueprint/po.ipr.skin.sensitivity.md)
- [Composite Oil IPR](/blueprint/po.ipr.composite.curve.md)
- [Klins-Clark Oil IPR](/blueprint/po.ipr.klins.curve.md)
- [Productivity Index by Flow Regime](/blueprint/po.ipr.flowregime.compare.md)
- [Productivity Index and Flow Efficiency](/blueprint/po.ipr.pi.calculation.md)
- [Horizontal Well Productivity Index](/blueprint/po.ipr.horizontal.compare.md)

