---
cid: po.bp.res.waterflood.dykstraparsons
hub: res
tags: [reservoir, waterflood, Dykstra-Parsons, Stiles, vertical-sweep, heterogeneity, layered-reservoir, areal-sweep, recovery, water-oil-ratio]
facets: { discipline: reservoir, method-type: analytical }
title: Waterflood Vertical Sweep in a Layered Reservoir
summary: "Predicts the vertical sweep and oil recovered by a waterflood in a layered reservoir up to an economic WOR by Dykstra-Parsons and Stiles."
slug: po.res.waterflood.dykstraparsons
type: worksheet
---

# Waterflood Vertical Sweep in a Layered Reservoir

## Description

How much of a layered reservoir has a waterflood swept by the time the producer's water-oil ratio reaches the level at which it stops paying, and how much oil is that? You enter each layer's permeability and thickness, the end-point relative permeabilities and viscosities, the pattern and the economic WOR. You read off the Dykstra-Parsons permeability variation V, the vertical sweep by Dykstra-Parsons and by Stiles at the economic WOR, and the oil recovered there.

**Parameters:**
- **Mobility**: the end-point relative permeabilities `WFD_Krw` (at the residual oil) and `WFD_Kro` (at the connate water), and the viscosities `WFD_Muw` and `WFD_Muo` (cp)
- **Fluids and rock**: `WFD_Bo` and `WFD_Bw` (bbl/STB), the connate water `WFD_Swi`, the residual oil `WFD_Sor` and the porosity `WFD_Phi`
- **Pattern**: the five-spot's area `WFD_Area` (acres); its thickness is the layers' sum
- **Economic limit**: the surface water-oil ratio `WFD_WorEc` at which the producer stops paying
- **Limits**: `WFD_VMax` for V, `WFD_HTol` for the spread of the layer thicknesses, and `WFD_AgreeTol` for the gap between the methods
- **Layers**: each layer's permeability (mD) and thickness (ft), top to base, in the layer table (`WFD_k`, `WFD_h`)

**How to use it:** The flood is synthetic. Take each layer's permeability from core or a calibrated log transform, in layers of equal thickness; split a thick layer into several of the same permeability rather than enter one thick one, and give each a slightly different value. Take the end points from the SCAL, the viscosities and formation volume factors from PVT, and the economic WOR from the producer's operating cost (the Water-Oil Ratio Diagnostics sheet derives one).

The sheet returns V and, at each layer's breakthrough, the Dykstra-Parsons vertical coverage and water-oil ratio, and beside them Stiles' swept fraction and water cut at the same breakthroughs. Both are read at the economic WOR, interpolated in log WOR between the breakthroughs that bracket it. The oil recovered there is the pattern's STOIIP times the displacement efficiency, Craig's five-spot areal sweep at breakthrough and the vertical coverage. A table lists every breakthrough, most permeable layer first, and the chart draws both methods' sweep against the surface WOR on a logarithmic axis, with each method's point at the economic WOR.

Six checks give PASS, WARN or FAIL. The saturation check fails when Swi and Sor leave no movable oil. The layer check fails on a permeability of zero or less, or on two layers of the same permeability, which share a breakthrough and leave the table a row short. The thickness check warns when the layers are not of equal thickness, as Dykstra-Parsons assumes. The heterogeneity check warns when V is above the limit. The economic WOR check warns when the economic WOR lies outside the breakthroughs' range. The method agreement check warns when the two methods' sweeps differ by more than the limit.

**Method:**

- **Mobility and heterogeneity.** The mobility ratio is M = (krw/μw)/(kro/μo). V = 1 − e^(−σ), where σ is the sample standard deviation of ln k: the log-normal line's (k₅₀ − k₈₄.₁)/k₅₀.
- **Dykstra-Parsons.** With the layers sorted so that k₁ ≥ … ≥ kₙ, when layer j breaks through every layer i > j is flooded to xᵢ = (M − √(M² + (kᵢ/kⱼ)(1 − M²)))/(M − 1). The vertical coverage is Cⱼ = (j + Σ xᵢ)/n and the reservoir WOR = Σᵢ≤ⱼ kᵢ / Σᵢ>ⱼ kᵢ/(M + xᵢ(1 − M)); the surface WOR is that times Bo/Bw.
- **Stiles.** Stiles treats the displacement as unit mobility: with Cⱼ the cumulative kh and Hⱼ the cumulative thickness, the swept fraction is (Hⱼ + (Cₜ − Cⱼ)/kⱼ)/Hₜ, and the surface water cut is A Cⱼ/(A Cⱼ + Cₜ − Cⱼ) with A = M Bo/Bw; its surface WOR is fw/(1 − fw).
- **At the economic WOR.** The sweep at the economic WOR interpolates linearly in ln WOR between the bracketing breakthroughs, and takes the nearest breakthrough's beyond either end.
- **Oil recovered.** The displacement efficiency is ED = (1 − Swi − Sor)/(1 − Swi). Craig's five-spot areal sweep at breakthrough is EA = 0.54602036 + 0.03170817/M + 0.30222997/e^M − 0.00509693 M. STOIIP = 7758 A h φ (1 − Swi)/Bo, and the oil recovered is STOIIP × ED × EA × C.

**Example:** The default case is one synthetic 40-acre five-spot over ten layers of 5 ft, 50 ft in all, at 20% porosity, 25% connate water and 30% residual oil. The layers, top to base, are 135, 520, 72, 245, 18, 340, 100, 50, 180 and 32 mD. The water's end point is 0.30 and its viscosity 0.50 cp; the oil's are 0.85 and 1.80 cp. Bo is 1.20 and Bw 1.02 bbl/STB, and the producer stops paying at a surface WOR of 20, a 95% water cut.

M is 1.271 and V 0.655, under the 0.70 limit: a moderately heterogeneous sand. Ten layers break through at surface WORs from 0.61 to 123; the economic WOR of 20 falls between the sixth and seventh. There the Dykstra-Parsons coverage is 82.4% and Stiles' swept fraction 81.9%, 0.5 points apart, inside the 5-point limit. The pattern holds 1.94 MMSTB; with ED 60% and EA 64.9%, the flood recovers 0.623 MMSTB at the economic WOR, 32.1% of the oil in place (0.619 MMSTB by Stiles). With a lighter oil of 0.50 cp, M falls to 0.353, EA rises to 84.6% and the coverage at the same WOR to 89.5%: 0.881 MMSTB, 45.4%. An economic WOR of 200, beyond the last breakthrough's 123, warns, and takes the last breakthrough's 95.3%. A residual oil of 80% fails the saturation check.

## Validity

Both methods are layer-cake models: the layers are not in communication, so there is no crossflow, no gravity and no capillary pressure, and each layer's displacement is piston-like, oil ahead of the front and residual oil behind it. Dykstra-Parsons takes layers of equal thickness, and its coverage and WOR are those at the moment each layer breaks through; between breakthroughs the sheet interpolates. Stiles ignores the mobility ratio in the advance of the fronts and uses it only in the water cut, so it drifts from Dykstra-Parsons as M moves away from 1. Craig's areal sweep is the five-spot's at breakthrough, a floor for the sweep at the economic WOR. With crossflow between the layers the vertical sweep is better than either method gives. Field units.

Named alternatives: for the areal sweep after breakthrough, Dyes, Caudle and Erickson's correlation (1954) or Craig's, and for other patterns their own curves; with crossflow, a simulation, or the Waterflood Fractional Flow Analysis sheet for one layer; the Water-Oil Ratio Diagnostics sheet for the economic WOR.

## References

- Dykstra, H. and Parsons, R.L. (1950). The Prediction of Oil Recovery by Waterflooding. *Secondary Recovery of Oil in the United States*, 2nd ed., API, 160–174.
- Stiles, W.E. (1949). Use of Permeability Distribution in Water Flood Calculations. *Trans. AIME* 186, 9–13.
- Craig, F.F. (1971). *The Reservoir Engineering Aspects of Waterflooding*. SPE Monograph 3.
- Willhite, G.P. (1986). *Waterflooding*. SPE Textbook Series 3.
- Ahmed, T. (2010). *Reservoir Engineering Handbook*, 4th ed. Gulf Professional Publishing (the five-spot areal sweep at breakthrough).

## Functions used

`PO.RES.Waterflood.DykstraParsons`, `PO.RES.Waterflood.Stiles`, `PO.RES.Vol.STOIIP`

## Spreadsheet: DykstraParsons

|    | A                                                                                                                                                                                                                | B                                                                                                                                                                         | C                                                                                                                                                                                                                                                                                                                                       | D                  | E                                                       | F                                                       | G                    |
|----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------|---------------------------------------------------------|---------------------------------------------------------|----------------------|
| 1  | Waterflood Vertical Sweep in a Layered Reservoir                                                                                                                                                                 |                                                                                                                                                                           | Petroleum Office                                                                                                                                                                                                                                                                                                                        |                    |                                                         |                                                         |                      |
| 2  | Blue cells on yellow are inputs. Enter each layer's permeability and thickness, the end-point mobilities and the economic WOR; read the coverage and the oil recovered there.                                    |                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                         |                    |                                                         |                                                         |                      |
| 3  | The Fluids and End Points, the Pattern, the Economic WOR and the Limits                                                                                                                                          |                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                         |                    |                                                         |                                                         |                      |
| 4  | Water relative permeability at the residual oil (end point)                                                                                                                                                      | 0.3                                                                                                                                                                       | frac                                                                                                                                                                                                                                                                                                                                    |                    |                                                         |                                                         |                      |
| 5  | Oil relative permeability at the connate water (end point)                                                                                                                                                       | 0.85                                                                                                                                                                      | frac                                                                                                                                                                                                                                                                                                                                    |                    |                                                         |                                                         |                      |
| 6  | Water viscosity at reservoir conditions                                                                                                                                                                          | 0.5                                                                                                                                                                       | cp                                                                                                                                                                                                                                                                                                                                      |                    |                                                         |                                                         |                      |
| 7  | Oil viscosity at reservoir conditions                                                                                                                                                                            | 1.8                                                                                                                                                                       | cp                                                                                                                                                                                                                                                                                                                                      |                    |                                                         |                                                         |                      |
| 8  | Oil formation volume factor                                                                                                                                                                                      | 1.2                                                                                                                                                                       | bbl/STB                                                                                                                                                                                                                                                                                                                                 |                    |                                                         |                                                         |                      |
| 9  | Water formation volume factor                                                                                                                                                                                    | 1.02                                                                                                                                                                      | bbl/STB                                                                                                                                                                                                                                                                                                                                 |                    |                                                         |                                                         |                      |
| 10 | Connate (initial) water saturation                                                                                                                                                                               | 0.25                                                                                                                                                                      | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 11 | Residual oil saturation to the waterflood                                                                                                                                                                        | 0.3                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 12 | Pattern area (one five-spot)                                                                                                                                                                                     | 40                                                                                                                                                                        | acres                                                                                                                                                                                                                                                                                                                                   |                    |                                                         |                                                         |                      |
| 13 | Porosity                                                                                                                                                                                                         | 0.2                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 14 | Economic water-oil ratio at the surface                                                                                                                                                                          | 20                                                                                                                                                                        | bbl/STB                                                                                                                                                                                                                                                                                                                                 |                    |                                                         |                                                         |                      |
| 15 | Largest permeability variation V for a plain waterflood                                                                                                                                                          | 0.7                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 16 | Largest spread of the layer thicknesses about their mean                                                                                                                                                         | 0.1                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 17 | Largest gap between the Dykstra-Parsons and Stiles sweeps                                                                                                                                                        | 0.05                                                                                                                                                                      | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 18 | Constants: Craig's Five-Spot Areal Sweep at Breakthrough, and the Function's Mode                                                                                                                                |                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                         |                    |                                                         |                                                         |                      |
| 19 | Areal sweep at breakthrough, constant term                                                                                                                                                                       | 0.54602036                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 20 | Areal sweep at breakthrough, coefficient of 1/M                                                                                                                                                                  | 0.03170817                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 21 | Areal sweep at breakthrough, coefficient of exp(-M)                                                                                                                                                              | 0.30222997                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 22 | Areal sweep at breakthrough, coefficient of M                                                                                                                                                                    | 0.00509693                                                                                                                                                                | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 23 | The Dykstra-Parsons function's mode for the WOR                                                                                                                                                                  | 3                                                                                                                                                                         | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 25 | Mobility, Heterogeneity, Sweep at the Economic WOR and the Oil Recovered There                                                                                                                                   |                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                         |                    |                                                         |                                                         |                      |
| 26 | End-point mobility ratio M = (krw/μw)/(kro/μo)                                                                                                                                                                   | =(WFD_Krw/WFD_Muw)/(WFD_Kro/WFD_Muo)                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 27 | Dykstra-Parsons permeability variation V                                                                                                                                                                         | =PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,1)                                                                                                                          | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 28 | Stiles' ratio A = M Bo/Bw, for surface rates                                                                                                                                                                     | =WFD_M*WFD_Bo/WFD_Bw                                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 29 | Layer breakthroughs the functions return                                                                                                                                                                         | =ROWS(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2))                                                                                                                    | —                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 30 | Net thickness, the layers' sum                                                                                                                                                                                   | =SUM(WFD_h)                                                                                                                                                               | ft                                                                                                                                                                                                                                                                                                                                      |                    |                                                         |                                                         |                      |
| 31 | Stock-tank oil initially in place in the pattern                                                                                                                                                                 | =PO.RES.Vol.STOIIP(WFD_Area*WFD_Hnet,1,WFD_Phi,WFD_Swi,WFD_Bo)                                                                                                            | MMSTB                                                                                                                                                                                                                                                                                                                                   |                    |                                                         |                                                         |                      |
| 32 | Displacement efficiency ED = (1 − Swi − Sor)/(1 − Swi)                                                                                                                                                           | =(1-WFD_Swi-WFD_Sor)/(1-WFD_Swi)                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 33 | Areal sweep at breakthrough, five-spot (Craig)                                                                                                                                                                   | =WFD_EaA+WFD_EaB/WFD_M+WFD_EaC/EXP(WFD_M)-WFD_EaD*WFD_M                                                                                                                   | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 34 | Vertical coverage at the economic WOR, Dykstra-Parsons                                                                                                                                                           | =IF(WFD_WorEc<=D65,B65,IF(WFD_WorEc>=D73,B73,SUMPRODUCT((D65:D72<=WFD_WorEc)*(D66:D73>WFD_WorEc)*(B65:B72+(B66:B73-B65:B72)*LN(WFD_WorEc/D65:D72)/LN(D66:D73/D65:D72))))) | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 35 | Swept fraction at the economic WOR, Stiles                                                                                                                                                                       | =IF(WFD_WorEc<=G65,E65,IF(WFD_WorEc>=G73,E73,SUMPRODUCT((G65:G72<=WFD_WorEc)*(G66:G73>WFD_WorEc)*(E65:E72+(E66:E73-E65:E72)*LN(WFD_WorEc/G65:G72)/LN(G66:G73/G65:G72))))) | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 36 | Dykstra-Parsons less Stiles                                                                                                                                                                                      | =WFD_Cdp-WFD_Rst                                                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 37 | Oil recovered at the economic WOR, Dykstra-Parsons                                                                                                                                                               | =WFD_N*WFD_ED*WFD_EA*WFD_Cdp                                                                                                                                              | MMSTB                                                                                                                                                                                                                                                                                                                                   |                    |                                                         |                                                         |                      |
| 38 | Recovery factor at the economic WOR, Dykstra-Parsons                                                                                                                                                             | =WFD_Np/WFD_N                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 39 | Oil recovered at the economic WOR, Stiles                                                                                                                                                                        | =WFD_N*WFD_ED*WFD_EA*WFD_Rst                                                                                                                                              | MMSTB                                                                                                                                                                                                                                                                                                                                   |                    |                                                         |                                                         |                      |
| 40 | Saturation check                                                                                                                                                                                                 | =IF(WFD_Swi+WFD_Sor>=1,"FAIL","PASS")                                                                                                                                     | =IF(WFD_Swi+WFD_Sor>=1,"Swi and Sor add to "&FIXED((WFD_Swi+WFD_Sor)*100,0)&"%: no oil is movable",""&FIXED(WFD_ED*100,1)&"% of the oil in the swept rock is displaced")                                                                                                                                                                |                    |                                                         |                                                         |                      |
| 41 | Layer check                                                                                                                                                                                                      | =IF(MIN(WFD_k)<=0,"FAIL",IF(WFD_Bt<COUNT(WFD_k)-1,"FAIL","PASS"))                                                                                                         | =IF(MIN(WFD_k)<=0,"a layer's permeability is zero or less: give every layer a positive k",IF(WFD_Bt<COUNT(WFD_k)-1,"two layers have the same permeability, so the table has fewer breakthroughs than rows: change one slightly",""&COUNT(WFD_k)&" layers of distinct permeability, "&WFD_Bt&" breakthroughs before the last"))          |                    |                                                         |                                                         |                      |
| 42 | Thickness check                                                                                                                                                                                                  | =IF((MAX(WFD_h)-MIN(WFD_h))/AVERAGE(WFD_h)<=WFD_HTol,"PASS","WARN")                                                                                                       | =IF((MAX(WFD_h)-MIN(WFD_h))/AVERAGE(WFD_h)<=WFD_HTol,"the layers are of equal thickness, as Dykstra-Parsons assumes","the layer thicknesses spread "&FIXED((MAX(WFD_h)-MIN(WFD_h))/AVERAGE(WFD_h)*100,0)&"% about their mean: Dykstra-Parsons assumes equal layers; split thick ones or rely on Stiles")                                |                    |                                                         |                                                         |                      |
| 43 | Heterogeneity check                                                                                                                                                                                              | =IF(WFD_V<=WFD_VMax,"PASS","WARN")                                                                                                                                        | =IF(WFD_V<=WFD_VMax,"V = "&FIXED(WFD_V,2)&", within the "&FIXED(WFD_VMax,2)&" a plain waterflood sweeps","V = "&FIXED(WFD_V,2)&", above "&FIXED(WFD_VMax,2)&": the thief layers will cycle water; consider profile control")                                                                                                            |                    |                                                         |                                                         |                      |
| 44 | Economic WOR check                                                                                                                                                                                               | =IF(AND(WFD_WorEc>=D65,WFD_WorEc<=D73),"PASS","WARN")                                                                                                                     | =IF(AND(WFD_WorEc>=D65,WFD_WorEc<=D73),"the economic WOR of "&FIXED(WFD_WorEc,1)&" lies between the first and last breakthroughs' "&FIXED(D65,2)&" and "&FIXED(D73,1),"the economic WOR of "&FIXED(WFD_WorEc,1)&" lies outside the breakthroughs' "&FIXED(D65,2)&" to "&FIXED(D73,1)&": the sweep there is the nearest breakthrough's") |                    |                                                         |                                                         |                      |
| 45 | Method agreement check                                                                                                                                                                                           | =IF(ABS(WFD_Gap)<=WFD_AgreeTol,"PASS","WARN")                                                                                                                             | =IF(ABS(WFD_Gap)<=WFD_AgreeTol,"Dykstra-Parsons and Stiles agree within "&FIXED(ABS(WFD_Gap)*100,1)&" points at the economic WOR","Dykstra-Parsons and Stiles differ by "&FIXED(WFD_Gap*100,1)&" points: Stiles ignores the mobility ratio, so trust Dykstra-Parsons when M is far from 1")                                             |                    |                                                         |                                                         |                      |
| 47 | How to use it: take each layer's permeability from core or a log transform, in layers of equal thickness, the end points and viscosities from SCAL and PVT, and the economic WOR from the well's operating cost. |                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                         |                    |                                                         |                                                         |                      |
| 48 | The flood is synthetic. Both methods are layer-cake models with no crossflow; the areal sweep is the five-spot's at breakthrough, a floor for the sweep at the economic WOR.                                     |                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                         |                    |                                                         |                                                         |                      |
| 50 | Layers, Top to Base (Equal Thickness for Dykstra-Parsons; Any Order)                                                                                                                                             |                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                         |                    |                                                         |                                                         |                      |
| 51 | Layer                                                                                                                                                                                                            | Permeability (mD)                                                                                                                                                         | Thickness (ft)                                                                                                                                                                                                                                                                                                                          |                    |                                                         |                                                         |                      |
| 52 | Layer 1                                                                                                                                                                                                          | 135                                                                                                                                                                       | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 53 | Layer 2                                                                                                                                                                                                          | 520                                                                                                                                                                       | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 54 | Layer 3                                                                                                                                                                                                          | 72                                                                                                                                                                        | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 55 | Layer 4                                                                                                                                                                                                          | 245                                                                                                                                                                       | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 56 | Layer 5                                                                                                                                                                                                          | 18                                                                                                                                                                        | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 57 | Layer 6                                                                                                                                                                                                          | 340                                                                                                                                                                       | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 58 | Layer 7                                                                                                                                                                                                          | 100                                                                                                                                                                       | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 59 | Layer 8                                                                                                                                                                                                          | 50                                                                                                                                                                        | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 60 | Layer 9                                                                                                                                                                                                          | 180                                                                                                                                                                       | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 61 | Layer 10                                                                                                                                                                                                         | 32                                                                                                                                                                        | 5                                                                                                                                                                                                                                                                                                                                       |                    |                                                         |                                                         |                      |
| 63 | Sweep at Each Layer's Breakthrough, Most Permeable First (nothing to edit)                                                                                                                                       |                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                         |                    |                                                         |                                                         |                      |
| 64 | Layers broken through                                                                                                                                                                                            | D-P coverage (%)                                                                                                                                                          | D-P WOR in situ (—)                                                                                                                                                                                                                                                                                                                     | D-P WOR (bbl/STB)  | Stiles swept (%)                                        | Stiles water cut (%)                                    | Stiles WOR (bbl/STB) |
| 65 | 1 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),1)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),1)                                                                                                                                                                                                                                                                     | =C65*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),1) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),1) | =F65/(1-F65)         |
| 66 | 2 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),2)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),2)                                                                                                                                                                                                                                                                     | =C66*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),2) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),2) | =F66/(1-F66)         |
| 67 | 3 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),3)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),3)                                                                                                                                                                                                                                                                     | =C67*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),3) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),3) | =F67/(1-F67)         |
| 68 | 4 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),4)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),4)                                                                                                                                                                                                                                                                     | =C68*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),4) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),4) | =F68/(1-F68)         |
| 69 | 5 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),5)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),5)                                                                                                                                                                                                                                                                     | =C69*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),5) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),5) | =F69/(1-F69)         |
| 70 | 6 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),6)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),6)                                                                                                                                                                                                                                                                     | =C70*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),6) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),6) | =F70/(1-F70)         |
| 71 | 7 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),7)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),7)                                                                                                                                                                                                                                                                     | =C71*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),7) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),7) | =F71/(1-F71)         |
| 72 | 8 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),8)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),8)                                                                                                                                                                                                                                                                     | =C72*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),8) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),8) | =F72/(1-F72)         |
| 73 | 9 flooded                                                                                                                                                                                                        | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,2),9)                                                                                                                 | =INDEX(PO.RES.Waterflood.DykstraParsons(WFD_k,WFD_M,WFD_ModeWor),9)                                                                                                                                                                                                                                                                     | =C73*WFD_Bo/WFD_Bw | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,1),9) | =INDEX(PO.RES.Waterflood.Stiles(WFD_k,WFD_h,WFD_A,2),9) | =F73/(1-F73)         |
| 75 | Layers broken through                                                                                                                                                                                            | D-P coverage (%)                                                                                                                                                          | D-P WOR in situ (—)                                                                                                                                                                                                                                                                                                                     | D-P WOR (bbl/STB)  | Stiles swept (%)                                        | Stiles water cut (%)                                    | Stiles WOR (bbl/STB) |
| 76 | At the economic WOR                                                                                                                                                                                              | =WFD_Cdp                                                                                                                                                                  | =WFD_WorEc*WFD_Bw/WFD_Bo                                                                                                                                                                                                                                                                                                                | =WFD_WorEc         | =WFD_Rst                                                | =WFD_WorEc/(1+WFD_WorEc)                                | =WFD_WorEc           |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.RES.Waterflood.DykstraParsons | =LAMBDA(k, Mob, Mode, LET(n, ROWS(k), Vdp, 1-EXP(-STDEV.S(LN(k))), ks, SORT(k, , -1), kr, TRANSPOSE(ks), ratio, kr/ks, below, IF(ratio<1, ratio, 1), x, IF(ratio>=1, 1, IF(Mob=1, below, (Mob-SQRT(Mob^2+below*(1-Mob^2)))/(Mob-1))), ones, SEQUENCE(n, 1, 1, 0), cov, MMULT(x, ones)/n, wat, MMULT((ratio>=1)*kr, ones), oil, MMULT((ratio<1)*kr/(Mob+x*(1-Mob)), ones), open, oil>0, IF(Mode=1, Vdp, IF(Mode=2, FILTER(cov, open), IF(Mode=3, FILTER(wat/IF(open, oil, 1), open), NA()))))) | Dykstra-Parsons layered waterflood: Mode 1 permeability variation V, 2 vertical coverage, 3 reservoir WOR, at each layer breakthrough |
| PO.RES.Waterflood.Stiles | =LAMBDA(k, h, A_wo, Mode, LET(f, (TRANSPOSE(k)>=k)*1, kh_cum, MMULT(f, k*h), h_cum, MMULT(f, h), kh_tot, SUM(k*h), h_tot, SUM(h), swept, (h_cum+(kh_tot-kh_cum)/k)/h_tot, fw, A_wo*kh_cum/(A_wo*kh_cum+kh_tot-kh_cum), IF(Mode=1, SORT(swept), IF(Mode=2, SORT(fw), NA())))) | Stiles layered waterflood at each layer breakthrough, highest permeability first: Mode 1 fraction of the floodable volume swept, 2 surface water cut |
| PO.RES.Vol.STOIIP | =LAMBDA(GRV, NTG, Phi, Sw, Bo, 7758*GRV*NTG*Phi*(1-Sw)/Bo) | Stock-tank oil initially in place, STB: 7758 x GRV (acre-ft) x NTG x porosity x (1 - Sw) / Bo (rb/STB). |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| WFD_Krw | $B$4 | Water relative permeability at the residual oil (end point), frac |
| WFD_Kro | $B$5 | Oil relative permeability at the connate water (end point), frac |
| WFD_Muw | $B$6 | Water viscosity at reservoir conditions, cp |
| WFD_Muo | $B$7 | Oil viscosity at reservoir conditions, cp |
| WFD_Bo | $B$8 | Oil formation volume factor, bbl/STB |
| WFD_Bw | $B$9 | Water formation volume factor, bbl/STB |
| WFD_Swi | $B$10 | Connate (initial) water saturation, % |
| WFD_Sor | $B$11 | Residual oil saturation to the waterflood, % |
| WFD_Area | $B$12 | Pattern area (one five-spot), acres |
| WFD_Phi | $B$13 | Porosity, % |
| WFD_WorEc | $B$14 | Economic water-oil ratio at the surface, bbl/STB |
| WFD_VMax | $B$15 | Largest permeability variation V for a plain waterflood |
| WFD_HTol | $B$16 | Largest spread of the layer thicknesses about their mean, % |
| WFD_AgreeTol | $B$17 | Largest gap between the Dykstra-Parsons and Stiles sweeps, % |
| WFD_Inputs | $B$4:$B$17 | The end-point relative permeabilities and viscosities, Bo and Bw, the connate water and residual oil, the pattern's area and porosity, the economic surface WOR and the check limits |
| WFD_EaA | $B$19 | Areal sweep at breakthrough, constant term |
| WFD_EaB | $B$20 | Areal sweep at breakthrough, coefficient of 1/M |
| WFD_EaC | $B$21 | Areal sweep at breakthrough, coefficient of exp(-M) |
| WFD_EaD | $B$22 | Areal sweep at breakthrough, coefficient of M |
| WFD_ModeWor | $B$23 | The Dykstra-Parsons function's mode for the WOR |
| WFD_M | $B$26 | End-point mobility ratio M = (krw/μw)/(kro/μo) |
| WFD_V | $B$27 | Dykstra-Parsons permeability variation V |
| WFD_A | $B$28 | Stiles' ratio A = M Bo/Bw, for surface rates |
| WFD_Bt | $B$29 | Layer breakthroughs the functions return |
| WFD_Hnet | $B$30 | Net thickness, the layers' sum, ft |
| WFD_N | $B$31 | Stock-tank oil initially in place in the pattern, MMSTB |
| WFD_ED | $B$32 | Displacement efficiency ED = (1 − Swi − Sor)/(1 − Swi), % |
| WFD_EA | $B$33 | Areal sweep at breakthrough, five-spot (Craig), % |
| WFD_Cdp | $B$34 | Vertical coverage at the economic WOR, Dykstra-Parsons, % |
| WFD_Rst | $B$35 | Swept fraction at the economic WOR, Stiles, % |
| WFD_Gap | $B$36 | Dykstra-Parsons less Stiles, % |
| WFD_Np | $B$37 | Oil recovered at the economic WOR, Dykstra-Parsons, MMSTB |
| WFD_RF | $B$38 | Recovery factor at the economic WOR, Dykstra-Parsons, % |
| WFD_NpSt | $B$39 | Oil recovered at the economic WOR, Stiles, MMSTB |
| WFD_SatCheck | $B$40 | Saturation check verdict |
| WFD_SatCheckNote | $C$40 | Saturation check comment |
| WFD_LayerCheck | $B$41 | Layer check verdict |
| WFD_LayerCheckNote | $C$41 | Layer check comment |
| WFD_ThicknessCheck | $B$42 | Thickness check verdict |
| WFD_ThicknessCheckNote | $C$42 | Thickness check comment |
| WFD_HeterogeneityCheck | $B$43 | Heterogeneity check verdict |
| WFD_HeterogeneityCheckNote | $C$43 | Heterogeneity check comment |
| WFD_RangeCheck | $B$44 | Economic WOR check verdict |
| WFD_RangeCheckNote | $C$44 | Economic WOR check comment |
| WFD_AgreementCheck | $B$45 | Method agreement check verdict |
| WFD_AgreementCheckNote | $C$45 | Method agreement check comment |
| WFD_Results | $B$26:$B$45 | M, V, Stiles' A, the breakthroughs, the net thickness and STOIIP, the displacement and areal sweep, each method's sweep at the economic WOR, the oil recovered there and six checks |
| WFD_Layers | $A$52:$C$61 | Each layer's permeability and thickness, top to base |
| WFD_k | $B$52:$B$61 | Layer permeabilities, mD |
| WFD_h | $C$52:$C$61 | Layer thicknesses, ft |
| WFD_Curve | $A$65:$G$73 | At each layer breakthrough: the Dykstra-Parsons coverage and WOR, and Stiles' swept fraction, water cut and WOR |
| WFD_Marker | $A$76:$G$76 | Both methods' sweep at the economic WOR, for the chart's markers |

---

## Related Blueprints
- [Injector Hall Plot and Voidage Replacement](/blueprint/po.res.hall.plot.md)
- [Volumetric Oil in Place](/blueprint/po.res.volumetrics.stoiip.md)
- [Recovery Factor by Drive Mechanism](/blueprint/po.res.recovery.factor.md)
- [Volumetric Gas in Place](/blueprint/po.res.volumetrics.giip.md)
- [Probabilistic Oil in Place by Monte Carlo](/blueprint/po.res.volumetrics.montecarlo.md)
- [CO2 Storage Capacity of a Saline Formation](/blueprint/po.res.ccs.storage.capacity.md)

