---
cid: po.bp.dca.wor.diagnostics
hub: dca
tags: [DCA, WOR, water-oil-ratio, Chan, diagnostics, coning, channeling, water-control, economic-limit, EUR, surveillance]
facets: { discipline: production, method-type: empirical }
title: Water-Oil Ratio Diagnostics
summary: "Whether a well's water is coning or channelling, and how much oil it makes before its log WOR trend reaches the economic WOR."
slug: po.dca.wor.diagnostics
type: worksheet
---

# Water-Oil Ratio Diagnostics

## Description

Where is a producer's water coming from, and how much more oil will the well make before the water makes it uneconomic? You enter the well's monthly oil and water rates from water breakthrough, its price, royalty, tax and costs, and the oil in place it drains. You read off on Chan's plot whether the water is coning or channelling, the economic WOR, and where the log WOR trend meets it: the well's EUR, the oil still to come and the recovery factor.

**Parameters:**
- **History**: the well's monthly time from breakthrough (days) and its oil and water rates (STB/d), in the history table
- **Start**: the cumulative oil at water breakthrough, `WOR_Np0` (STB), and the first month of the trend's fit, `WOR_FitFrom`
- **Chan**: the WOR′ slope below which the water reads as coning, `WOR_SlopeConing` (0)
- **Economics**: the oil price `WOR_Price` ($/STB), the royalty `WOR_Royalty` and production tax `WOR_Tax`, the variable cost per barrel of oil `WOR_Opex`, the fixed well cost per month `WOR_Fixed`, and the lifting and water-handling cost per barrel of liquid `WOR_Lift`
- **Recovery**: the oil initially in place the well drains, `WOR_N` (STB)
- **Limits**: the lowest R² of a trend to extrapolate, `WOR_R2Min`

**How to use it:** The default history is a synthetic well. Paste your well's monthly time from breakthrough and its oil and water rates over the history table's rows; smooth noisy rates first. Set the cumulative oil at breakthrough from the well's production, the fit's first month where the log WOR plot turns straight, the costs from the lease operating statement, and the oil in place from a volumetric estimate or a decline-based one. The first chart is Chan's plot: the WOR and its time derivative WOR′ on log-log axes, whose late slope says whether the water is coning or channelling. The second draws the WOR against cumulative oil on a logarithmic WOR axis, with the trend from the fit's first month to the economic WOR. The water-source check reads coning when the late WOR′ slope is below the coning threshold and warns of channelling otherwise. The trend check fails when log WOR does not rise with cumulative oil, and warns when the fit's R² is below the limit. The economic-limit check warns when the well is already past its economic WOR.

**Method:** WOR = qw/qo. Chan's WOR′ at an interior month is the three-point derivative, the neighbouring slopes each weighted by the other interval; at the ends it is the one-sided slope. The late slope on log-log axes runs from the history's middle month to its second-to-last: log₁₀(WOR′ₗ/WOR′ₘ)/log₁₀(tₗ/tₘ). A falling WOR′ (a negative slope) is coning; a rising one is channelling.

The cumulative oil is Np₀ plus each month's qo Δt. Over the months from the fit's first month to the last, log₁₀ WOR = a + b Np by least squares. The well's liquid rate is held at its last month's qL, so its lifting cost is fixed. The economic-limit oil rate, the rate at which the well's oil no longer pays for its liquid, is qo,ec = (Fixed + qL · 30.4375 · Lift)/(Price (1 − Royalty)(1 − Tax) − Opex)/30.4375, and the economic WOR is qL/qo,ec − 1. The trend meets it at Np,ec = (log₁₀ WORec − a)/b, and the recovery factor is Np,ec/N.

**Example:** The default history is the downhole-water-sink ESP sizing sheet's well: 24 months of 1,500 STB/d of liquid whose WOR climbs from 0.20 to 0.98 as 0.2·√(t/30), a coning signature. The well had made 400,000 STB by water breakthrough. Oil sells at $70/STB with a 12.5% royalty and a 5% production tax; treating and transport cost $6 per barrel of oil, the well $25,000 a month, and lifting and water handling $3 per barrel of liquid. The well drains 8 MMSTB, and the trend is fitted from month 12.

Chan's late WOR′ slope is −0.503, as on the downhole-water-sink sheet: WOR′ falls with time, the signature of bottom-water coning. Hand check: log₁₀(6.9485 × 10⁻⁴ / 9.6384 × 10⁻⁴)/log₁₀(690/360) = −0.1421/0.2826 = −0.503. By the last month the well has made 1,058,386 STB at a WOR of 0.98. From month 12 the log WOR trend rises 5.116 × 10⁻⁷ decades per barrel, with R² 0.994. The well's netback is $52.19 per barrel of oil, and its fixed cost with the liquid's handling $161,969 a month, so it stops paying at 102.0 STB/d of oil: an economic WOR of 13.7, a 93.2% water cut. The trend reaches it at 3.29 MMSTB, another 2.23 MMSTB, 41.1% of the 8 MMSTB the well drains. Fitted over all 24 months, R² falls to 0.893 and the trend check warns, and the EUR falls to 2.25 MMSTB; from month 18 it is 3.63 MMSTB. At $30 per barrel of liquid the well stops paying at 878 STB/d, a WOR of 0.71, already passed.

## Validity

Chan's plot is a qualitative screen on noisy data: read it on smoothed rates, and with the well's completion and workover history. A WOR′ that falls after breakthrough is coning; one that keeps rising is channelling behind pipe, through a high-permeability streak or a casing leak, and calls for a squeeze or a plug, not a reserves extrapolation. The log WOR against cumulative oil trend is empirical: it holds while the well's liquid rate, its completion and the flood around it stay as they are. A coning well's WOR grows more slowly than the line suggests, so a trend fitted later in the history gives a larger EUR; set the fit's start where the plot has turned straight, and cross-check the EUR with an Arps decline forecast or a material balance. The economic limit is a before-income-tax operating limit at the last month's liquid rate. Field units.

## References

- Chan, K.S. (1995). Water Control Diagnostic Plots. SPE-30775-MS.
- Ershaghi, I. and Omoregie, O. (1978). A Method for Extrapolation of Cut vs Recovery Curves. *Journal of Petroleum Technology* 30(2), 203–204.
- Craig, F.F. (1971). *The Reservoir Engineering Aspects of Waterflooding*. SPE Monograph 3.
- Mian, M.A. (2011). *Project Economics and Decision Analysis*, Vol. 1, 2nd ed. PennWell.

## Functions used

`PO.PE.Chan.WORDerivative`, `PO.RES.Reserves.EconLimit`

## Spreadsheet: WorDiagnostics

|    | A                                                                                                                                                                                      | B                                                                                                                              | C                                                                                                                                                                                                                                                                                                                                                                                 | D             | E                                                      | F                    | G           |
|----|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|--------------------------------------------------------|----------------------|-------------|
| 1  | Water-Oil Ratio Diagnostics                                                                                                                                                            |                                                                                                                                | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                  |               |                                                        |                      |             |
| 2  | Blue cells on yellow are inputs. The history is EXAMPLE data: paste the well's. Set the cumulative oil at breakthrough, the month the trend starts and the well's costs.               |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 3  | Breakthrough, the Trend Window, the Well's Economics and the Limits                                                                                                                    |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 4  | Cumulative oil at water breakthrough (the history's start)                                                                                                                             | 400000                                                                                                                         | STB                                                                                                                                                                                                                                                                                                                                                                               |               |                                                        |                      |             |
| 5  | First month of the log WOR trend (to the last month)                                                                                                                                   | 12                                                                                                                             | —                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 6  | Chan: WOR′ slope below which it is coning                                                                                                                                              | 0                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 7  | Realised oil price                                                                                                                                                                     | 70                                                                                                                             | $/STB                                                                                                                                                                                                                                                                                                                                                                             |               |                                                        |                      |             |
| 8  | Royalty share of the revenue                                                                                                                                                           | 0.125                                                                                                                          | %                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 9  | Production tax on the revenue after royalty                                                                                                                                            | 0.05                                                                                                                           | %                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 10 | Variable cost per barrel of oil (treating and transport)                                                                                                                               | 6                                                                                                                              | $/STB                                                                                                                                                                                                                                                                                                                                                                             |               |                                                        |                      |             |
| 11 | Fixed well cost per month                                                                                                                                                              | 25000                                                                                                                          | $/well-month                                                                                                                                                                                                                                                                                                                                                                      |               |                                                        |                      |             |
| 12 | Lifting and water-handling cost per barrel of liquid                                                                                                                                   | 3                                                                                                                              | $/STB                                                                                                                                                                                                                                                                                                                                                                             |               |                                                        |                      |             |
| 13 | Oil initially in place drained by the well                                                                                                                                             | 8000000                                                                                                                        | STB                                                                                                                                                                                                                                                                                                                                                                               |               |                                                        |                      |             |
| 14 | Lowest R² for a log WOR trend to extrapolate                                                                                                                                           | 0.95                                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 15 | Constants                                                                                                                                                                              |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 16 | Average days in a month                                                                                                                                                                | 30.4375                                                                                                                        | days                                                                                                                                                                                                                                                                                                                                                                              |               |                                                        |                      |             |
| 21 | Chan's Diagnosis, the Log WOR Trend, the Economic WOR and the Oil Recovered There                                                                                                      |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 22 | Months of history                                                                                                                                                                      | =COUNT($A$47:$A$70)                                                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 23 | Late WOR′ slope on log-log axes (Chan)                                                                                                                                                 | =LOG10(E69/E58)/LOG10(A69/A58)                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 24 | WOR at the last month                                                                                                                                                                  | =D70                                                                                                                           | bbl/STB                                                                                                                                                                                                                                                                                                                                                                           |               |                                                        |                      |             |
| 25 | Cumulative oil at the last month                                                                                                                                                       | =F70                                                                                                                           | STB                                                                                                                                                                                                                                                                                                                                                                               |               |                                                        |                      |             |
| 26 | Log WOR trend slope, log₁₀ WOR per barrel of oil                                                                                                                                       | =SLOPE(DROP(TAKE($G$47:$G$70,WOR_Months),WOR_FitFrom-1),DROP(TAKE($F$47:$F$70,WOR_Months),WOR_FitFrom-1))                      | 1/STB                                                                                                                                                                                                                                                                                                                                                                             |               |                                                        |                      |             |
| 27 | Log WOR trend intercept, log₁₀ WOR at zero oil                                                                                                                                         | =INTERCEPT(DROP(TAKE($G$47:$G$70,WOR_Months),WOR_FitFrom-1),DROP(TAKE($F$47:$F$70,WOR_Months),WOR_FitFrom-1))                  | —                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 28 | R² of the trend                                                                                                                                                                        | =RSQ(DROP(TAKE($G$47:$G$70,WOR_Months),WOR_FitFrom-1),DROP(TAKE($F$47:$F$70,WOR_Months),WOR_FitFrom-1))                        | —                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 29 | Liquid rate at the last month (held from here)                                                                                                                                         | =B70+C70                                                                                                                       | STB/d                                                                                                                                                                                                                                                                                                                                                                             |               |                                                        |                      |             |
| 30 | Economic-limit oil rate                                                                                                                                                                | =PO.RES.Reserves.EconLimit(WOR_Price,WOR_Royalty,WOR_Tax,WOR_Opex,WOR_Fixed+WOR_QL*WOR_DaysPerMonth*WOR_Lift)/WOR_DaysPerMonth | STB/d                                                                                                                                                                                                                                                                                                                                                                             |               |                                                        |                      |             |
| 31 | Economic water-oil ratio, qL/qo − 1                                                                                                                                                    | =WOR_QL/WOR_QoEc-1                                                                                                             | bbl/STB                                                                                                                                                                                                                                                                                                                                                                           |               |                                                        |                      |             |
| 32 | Water cut at the economic WOR                                                                                                                                                          | =WOR_WorEc/(1+WOR_WorEc)                                                                                                       | %                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 33 | Cumulative oil at the economic WOR (the trend's EUR)                                                                                                                                   | =(LOG10(WOR_WorEc)-WOR_A)/WOR_B                                                                                                | STB                                                                                                                                                                                                                                                                                                                                                                               |               |                                                        |                      |             |
| 34 | Oil still to come at the economic WOR                                                                                                                                                  | =WOR_NpEc-WOR_NpLast                                                                                                           | STB                                                                                                                                                                                                                                                                                                                                                                               |               |                                                        |                      |             |
| 35 | Recovery factor at the economic WOR                                                                                                                                                    | =WOR_NpEc/WOR_N                                                                                                                | %                                                                                                                                                                                                                                                                                                                                                                                 |               |                                                        |                      |             |
| 36 | Water-source check (Chan)                                                                                                                                                              | =IF(WOR_ChanSlope<WOR_SlopeConing,"PASS","WARN")                                                                               | =IF(WOR_ChanSlope<WOR_SlopeConing,"the late WOR′ slope is "&FIXED(WOR_ChanSlope,2)&", below "&FIXED(WOR_SlopeConing,2)&": bottom-water coning, so the WOR trend is the reservoir's","the late WOR′ slope is "&FIXED(WOR_ChanSlope,2)&", not below "&FIXED(WOR_SlopeConing,2)&": channelling? Fix it before trusting the trend")                                                   |               |                                                        |                      |             |
| 37 | Trend check                                                                                                                                                                            | =IF(WOR_B<=0,"FAIL",IF(WOR_R2<WOR_R2Min,"WARN","PASS"))                                                                        | =IF(WOR_B<=0,"log WOR does not rise with cumulative oil from month "&WOR_FitFrom&": there is no trend to extrapolate",IF(WOR_R2<WOR_R2Min,"the trend from month "&WOR_FitFrom&" has R² "&FIXED(WOR_R2,2)&", below "&FIXED(WOR_R2Min,2)&": start it later, once the WOR settles","the trend from month "&WOR_FitFrom&" has R² "&FIXED(WOR_R2,2)&", at least "&FIXED(WOR_R2Min,2))) |               |                                                        |                      |             |
| 38 | Economic-limit check                                                                                                                                                                   | =IF(WOR_WorEc<=WOR_WorLast,"WARN","PASS")                                                                                      | =IF(WOR_WorEc<=WOR_WorLast,"the economic WOR of "&FIXED(WOR_WorEc,1)&" is already passed ("&FIXED(WOR_WorLast,2)&" last month): the well no longer pays at these costs","the WOR climbs from "&FIXED(WOR_WorLast,2)&" to the economic "&FIXED(WOR_WorEc,1)&", at "&FIXED(WOR_QoEc,0)&" STB/d of oil")                                                                             |               |                                                        |                      |             |
| 40 | How to use it: paste the well's monthly time from breakthrough and its oil and water rates, set the cumulative oil at breakthrough, and start the trend once the WOR plot is straight. |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 41 | The history is the DWS well's synthetic coning signature. A log WOR trend holds while the well's liquid rate and the flood's pattern stay as they are.                                 |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 44 | The Well's Production History from Water Breakthrough (EXAMPLE)                                                                                                                        |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 45 | How to use it: paste the well's monthly time, oil and water rates from water breakthrough on, over these rows.                                                                         |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 46 | Time (days)                                                                                                                                                                            | Oil (STB/d)                                                                                                                    | Water (STB/d)                                                                                                                                                                                                                                                                                                                                                                     | WOR (bbl/STB) | WOR′ (1/day)                                           | Cumulative oil (STB) | Log₁₀ WOR   |
| 47 | 30                                                                                                                                                                                     | 1250                                                                                                                           | 250                                                                                                                                                                                                                                                                                                                                                                               | =C47/B47      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A47) | =WOR_Np0+B47*A47     | =LOG10(D47) |
| 48 | 60                                                                                                                                                                                     | 1169.3                                                                                                                         | 330.7                                                                                                                                                                                                                                                                                                                                                                             | =C48/B48      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A48) | =F47+B48*(A48-A47)   | =LOG10(D48) |
| 49 | 90                                                                                                                                                                                     | 1114.1                                                                                                                         | 385.9                                                                                                                                                                                                                                                                                                                                                                             | =C49/B49      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A49) | =F48+B49*(A49-A48)   | =LOG10(D49) |
| 50 | 120                                                                                                                                                                                    | 1071.4                                                                                                                         | 428.6                                                                                                                                                                                                                                                                                                                                                                             | =C50/B50      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A50) | =F49+B50*(A50-A49)   | =LOG10(D50) |
| 51 | 150                                                                                                                                                                                    | 1036.5                                                                                                                         | 463.5                                                                                                                                                                                                                                                                                                                                                                             | =C51/B51      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A51) | =F50+B51*(A51-A50)   | =LOG10(D51) |
| 52 | 180                                                                                                                                                                                    | 1006.8                                                                                                                         | 493.2                                                                                                                                                                                                                                                                                                                                                                             | =C52/B52      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A52) | =F51+B52*(A52-A51)   | =LOG10(D52) |
| 53 | 210                                                                                                                                                                                    | 980.9                                                                                                                          | 519.1                                                                                                                                                                                                                                                                                                                                                                             | =C53/B53      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A53) | =F52+B53*(A53-A52)   | =LOG10(D53) |
| 54 | 240                                                                                                                                                                                    | 958                                                                                                                            | 542                                                                                                                                                                                                                                                                                                                                                                               | =C54/B54      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A54) | =F53+B54*(A54-A53)   | =LOG10(D54) |
| 55 | 270                                                                                                                                                                                    | 937.5                                                                                                                          | 562.5                                                                                                                                                                                                                                                                                                                                                                             | =C55/B55      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A55) | =F54+B55*(A55-A54)   | =LOG10(D55) |
| 56 | 300                                                                                                                                                                                    | 918.9                                                                                                                          | 581.1                                                                                                                                                                                                                                                                                                                                                                             | =C56/B56      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A56) | =F55+B56*(A56-A55)   | =LOG10(D56) |
| 57 | 330                                                                                                                                                                                    | 901.8                                                                                                                          | 598.2                                                                                                                                                                                                                                                                                                                                                                             | =C57/B57      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A57) | =F56+B57*(A57-A56)   | =LOG10(D57) |
| 58 | 360                                                                                                                                                                                    | 886.1                                                                                                                          | 613.9                                                                                                                                                                                                                                                                                                                                                                             | =C58/B58      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A58) | =F57+B58*(A58-A57)   | =LOG10(D58) |
| 59 | 390                                                                                                                                                                                    | 871.5                                                                                                                          | 628.5                                                                                                                                                                                                                                                                                                                                                                             | =C59/B59      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A59) | =F58+B59*(A59-A58)   | =LOG10(D59) |
| 60 | 420                                                                                                                                                                                    | 858                                                                                                                            | 642                                                                                                                                                                                                                                                                                                                                                                               | =C60/B60      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A60) | =F59+B60*(A60-A59)   | =LOG10(D60) |
| 61 | 450                                                                                                                                                                                    | 845.3                                                                                                                          | 654.7                                                                                                                                                                                                                                                                                                                                                                             | =C61/B61      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A61) | =F60+B61*(A61-A60)   | =LOG10(D61) |
| 62 | 480                                                                                                                                                                                    | 833.3                                                                                                                          | 666.7                                                                                                                                                                                                                                                                                                                                                                             | =C62/B62      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A62) | =F61+B62*(A62-A61)   | =LOG10(D62) |
| 63 | 510                                                                                                                                                                                    | 822.1                                                                                                                          | 677.9                                                                                                                                                                                                                                                                                                                                                                             | =C63/B63      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A63) | =F62+B63*(A63-A62)   | =LOG10(D63) |
| 64 | 540                                                                                                                                                                                    | 811.5                                                                                                                          | 688.5                                                                                                                                                                                                                                                                                                                                                                             | =C64/B64      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A64) | =F63+B64*(A64-A63)   | =LOG10(D64) |
| 65 | 570                                                                                                                                                                                    | 801.4                                                                                                                          | 698.6                                                                                                                                                                                                                                                                                                                                                                             | =C65/B65      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A65) | =F64+B65*(A65-A64)   | =LOG10(D65) |
| 66 | 600                                                                                                                                                                                    | 791.8                                                                                                                          | 708.2                                                                                                                                                                                                                                                                                                                                                                             | =C66/B66      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A66) | =F65+B66*(A66-A65)   | =LOG10(D66) |
| 67 | 630                                                                                                                                                                                    | 782.7                                                                                                                          | 717.3                                                                                                                                                                                                                                                                                                                                                                             | =C67/B67      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A67) | =F66+B67*(A67-A66)   | =LOG10(D67) |
| 68 | 660                                                                                                                                                                                    | 774                                                                                                                            | 726                                                                                                                                                                                                                                                                                                                                                                               | =C68/B68      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A68) | =F67+B68*(A68-A67)   | =LOG10(D68) |
| 69 | 690                                                                                                                                                                                    | 765.6                                                                                                                          | 734.4                                                                                                                                                                                                                                                                                                                                                                             | =C69/B69      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A69) | =F68+B69*(A69-A68)   | =LOG10(D69) |
| 70 | 720                                                                                                                                                                                    | 757.7                                                                                                                          | 742.3                                                                                                                                                                                                                                                                                                                                                                             | =C70/B70      | =PO.PE.Chan.WORDerivative($A$47:$A$70,$D$47:$D$70,A70) | =F69+B70*(A70-A69)   | =LOG10(D70) |
| 72 | The Log WOR Trend, Fitted and Extrapolated (nothing to edit)                                                                                                                           |                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                        |                      |             |
| 73 | Point on the trend                                                                                                                                                                     | Cumulative oil (STB)                                                                                                           | WOR on the trend (bbl/STB)                                                                                                                                                                                                                                                                                                                                                        |               |                                                        |                      |             |
| 74 | Start of the fit                                                                                                                                                                       | =MIN(DROP(TAKE($F$47:$F$70,WOR_Months),WOR_FitFrom-1))                                                                         | =10^(WOR_A+WOR_B*B74)                                                                                                                                                                                                                                                                                                                                                             |               |                                                        |                      |             |
| 75 | Last month                                                                                                                                                                             | =WOR_NpLast                                                                                                                    | =10^(WOR_A+WOR_B*B75)                                                                                                                                                                                                                                                                                                                                                             |               |                                                        |                      |             |
| 76 | Economic WOR                                                                                                                                                                           | =WOR_NpEc                                                                                                                      | =WOR_WorEc                                                                                                                                                                                                                                                                                                                                                                        |               |                                                        |                      |             |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.PE.Chan.WORDerivative | =LAMBDA(time, wor, at, LET(n, COUNT(time), k, MATCH(at, time, 0), k_lo, MAX(1, k-1), k_hi, MIN(n, k+1), t_k, INDEX(time, k), t_lo, INDEX(time, k_lo), t_hi, INDEX(time, k_hi), w_k, INDEX(wor, k), w_lo, INDEX(wor, k_lo), w_hi, INDEX(wor, k_hi), IF(k=1, (w_hi-w_k)/(t_hi-t_k), IF(k=n, (w_k-w_lo)/(t_k-t_lo), ((w_k-w_lo)/(t_k-t_lo)*(t_hi-t_k)+(w_hi-w_k)/(t_hi-t_k)*(t_k-t_lo))/(t_hi-t_lo))))) | Chan (1995) WOR′: the time derivative of the water-oil ratio at one point of a production history, a three-point difference weighted by the neighbouring intervals, [1/time unit]. |
| PO.RES.Reserves.EconLimit | =LAMBDA(Price, Royalty, Tax, Opex, Fixed, LET(netback, Price*(1-Royalty)*(1-Tax)-Opex, IF(netback>0, Fixed/netback, NA()))) | Economic-limit rate: fixed cost per period over the netback per unit after royalty, production tax and variable opex; #N/A if the netback is not positive |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| WOR_Np0 | $B$4 | Cumulative oil at water breakthrough (the history's start), STB |
| WOR_FitFrom | $B$5 | First month of the log WOR trend (to the last month) |
| WOR_SlopeConing | $B$6 | Chan: WOR′ slope below which it is coning |
| WOR_Price | $B$7 | Realised oil price, $/STB |
| WOR_Royalty | $B$8 | Royalty share of the revenue, % |
| WOR_Tax | $B$9 | Production tax on the revenue after royalty, % |
| WOR_Opex | $B$10 | Variable cost per barrel of oil (treating and transport), $/STB |
| WOR_Fixed | $B$11 | Fixed well cost per month, $/well-month |
| WOR_Lift | $B$12 | Lifting and water-handling cost per barrel of liquid, $/STB |
| WOR_N | $B$13 | Oil initially in place drained by the well, STB |
| WOR_R2Min | $B$14 | Lowest R² for a log WOR trend to extrapolate |
| WOR_Inputs | $B$4:$B$14 | The cumulative oil at breakthrough, the trend's first month, the Chan coning slope, the oil price, royalty, tax and costs, the oil in place and the fit limit |
| WOR_DaysPerMonth | $B$16 | Average days in a month, days |
| WOR_Months | $B$22 | Months of history |
| WOR_ChanSlope | $B$23 | Late WOR′ slope on log-log axes (Chan) |
| WOR_WorLast | $B$24 | WOR at the last month, bbl/STB |
| WOR_NpLast | $B$25 | Cumulative oil at the last month, STB |
| WOR_B | $B$26 | Log WOR trend slope, log₁₀ WOR per barrel of oil, 1/STB |
| WOR_A | $B$27 | Log WOR trend intercept, log₁₀ WOR at zero oil |
| WOR_R2 | $B$28 | R² of the trend |
| WOR_QL | $B$29 | Liquid rate at the last month (held from here), STB/d |
| WOR_QoEc | $B$30 | Economic-limit oil rate, STB/d |
| WOR_WorEc | $B$31 | Economic water-oil ratio, qL/qo − 1, bbl/STB |
| WOR_FwEc | $B$32 | Water cut at the economic WOR, % |
| WOR_NpEc | $B$33 | Cumulative oil at the economic WOR (the trend's EUR), STB |
| WOR_Rem | $B$34 | Oil still to come at the economic WOR, STB |
| WOR_RF | $B$35 | Recovery factor at the economic WOR, % |
| WOR_ChanCheck | $B$36 | Water-source check (Chan) verdict |
| WOR_ChanCheckNote | $C$36 | Water-source check (Chan) comment |
| WOR_TrendCheck | $B$37 | Trend check verdict |
| WOR_TrendCheckNote | $C$37 | Trend check comment |
| WOR_EconCheck | $B$38 | Economic-limit check verdict |
| WOR_EconCheckNote | $C$38 | Economic-limit check comment |
| WOR_Results | $B$22:$B$38 | The months, Chan's late slope, the last WOR and cumulative oil, the log WOR trend and its R², the economic oil rate and WOR, the oil recovered there and three checks |
| WOR_History | $A$47:$G$70 | The well's monthly time, oil and water rates, its WOR and Chan's WOR′, the cumulative oil and log WOR |
| WOR_Trend | $A$74:$C$76 | The fitted log WOR trend at the fit's start, at the last month and at the economic WOR |
| WOR_ChanCurve | $A$47:$E$70 | Chan Water-Control Diagnostic |
| WOR_TrendCurve | $C$47:$F$70 | Water-Oil Ratio against Cumulative Oil |

---

## Related Blueprints
- [Decline Model Comparison](/blueprint/po.dca.models.compare.md)
- [Modified Hyperbolic Decline](/blueprint/po.dca.modhyp.forecast.md)
- [Duong Decline Forecast](/blueprint/po.dca.duong.forecast.md)
- [Arps EUR Sensitivity](/blueprint/po.dca.eur.sensitivity.md)
- [Arps Decline Forecast](/blueprint/po.dca.arps.forecast.md)
- [Production Data Cleaning](/blueprint/po.dca.data.cleaning.md)

