Waterflood Fractional Flow Analysis
Spreadsheet
39 rows x 5 columns
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Waterflood Fractional Flow | ||||
| 2 | Reservoir & Fluid Properties | ||||
| 3 | Swi | 0.2 | fraction | ||
| 4 | Sorw | 0.25 | fraction | ||
| 5 | Krow @ Swi | 1 | dimensionless | ||
| 6 | Krw @ Sorw | 0.35 | dimensionless | ||
| 7 | No (oil exponent) | 2.5 | dimensionless | ||
| 8 | Nw (water exponent) | 2 | dimensionless | ||
| 9 | Oil viscosity, μo | 5 | cp | ||
| 10 | Water viscosity, μw | 0.5 | cp | ||
| 11 | |||||
| 12 | Displacement Parameters | ||||
| 13 | Endpoint mobility ratio, M | 3.5 | dimensionless | ||
| 14 | Mobile oil saturation | 0.55 | fraction | ||
| 15 | Ultimate displacement eff. | 0.6875 | fraction | ||
| 16 | |||||
| 17 | Fractional Flow Table | ||||
| 18 | Sw | Krow | Krw | fw | Welge slope |
| 19 | 0.2 | 1 | 0 | 0 | 0 |
| 20 | 0.25 | 0.7879856109 | 0.002892561983 | 0.03540852267 | 0.7081704534 |
| 21 | 0.3 | 0.6055145184 | 0.01157024793 | 0.1604267227 | 1.604267227 |
| 22 | 0.35 | 0.4510692842 | 0.02603305785 | 0.365941283 | 2.439608554 |
| 23 | 0.4 | 0.3230452705 | 0.04628099174 | 0.588925192 | 2.94462596 |
| 24 | 0.45 | 0.2197335707 | 0.07231404959 | 0.7669534263 | 3.067813705 |
| 25 | 0.5 | 0.1392974922 | 0.1041322314 | 0.8820132514 | 2.940044171 |
| 26 | 0.55 | 0.07973853741 | 0.1417355372 | 0.9467377852 | 2.704965101 |
| 27 | 0.6 | 0.03884377447 | 0.1851239669 | 0.9794486457 | 2.448621614 |
| 28 | 0.65 | 0.01409591513 | 0.2342975207 | 0.9940197328 | 2.20893274 |
| 29 | 0.7 | 0.002491829294 | 0.2892561983 | 0.9991392805 | 1.998278561 |
| 30 | 0.75 | 0 | 0.35 | 1 | 1.818181818 |
| 31 | |||||
| 32 | Welge Tangent Analysis | ||||
| 33 | BT tangent slope | 3.067813705 | 1/PV | ||
| 34 | BT front saturation, Sw_f | 0.45 | fraction | ||
| 35 | BT water cut, fw_f | 0.7669534263 | fraction | ||
| 36 | PV injected at BT | 0.3259650344 | PV | ||
| 37 | Avg Sw behind front at BT | 0.5259650344 | fraction | ||
| 38 | BT oil recovery factor | 0.407456293 | fraction | ||
| 39 | Ultimate recovery factor | 0.6875 | fraction |
Description
Buckley-Leverett fractional flow analysis for waterflood performance prediction. Computes water fractional flow curve from Corey relative permeability and fluid viscosities, applies the Welge tangent construction to determine breakthrough saturation and oil recovery factor.
Buckley-Leverett theory. The fractional flow equation fw = 1/(1 + (kro/krw)·(μw/μo)) assumes incompressible, immiscible, horizontal displacement with no capillary or gravity effects. The Welge tangent construction accounts for the saturation shock (piston-like displacement front) that forms when the fw curve has an inflection point.
Mobility ratio. M = (Krw_end·μo)/(Krow_end·μw). With default parameters: M = (0.35×5.0)/(1.0×0.5) = 3.5. Values above 1 indicate unfavorable displacement — water fingers through oil, causing early breakthrough and high water cut before significant oil recovery. Typical light oil waterfloods have M = 1–5; heavy oil can exceed M = 50.
Welge tangent resolution. The BT saturation is approximate (±0.05) due to the saturation table step size. For higher resolution, reduce the Sw step or add rows near the expected BT region. The exact BT point satisfies dfw/dSw = fw/(Sw−Swi) simultaneously.
Recovery factors. BT recovery is the oil recovered when water first arrives at the producer — after this, water cut rises rapidly. Ultimate recovery assumes infinite PV injected (economically unrealistic). Practical recovery lies between these bounds, determined by the economic water cut limit (typically fw = 0.95–0.99).
Reference: Buckley, S.E. and Leverett, M.C. (1942). "Mechanism of Fluid Displacement in Sands." Trans. AIME 146: 107–116. Welge, H.J. (1952). "A Simplified Method for Computing Oil Recovery by Gas or Water Drive." Trans. AIME 195: 91–98.
Workflow
- Reservoir & Fluid Properties (rows 3–10): Corey model endpoints (Swi, Sorw, Krow_Swi, Krw_Sorw), exponents (No, Nw), and fluid viscosities (μo, μw). Default parameters represent a moderately unfavorable waterflood (M ≈ 3.5) in a medium-viscosity oil reservoir.
- Displacement Parameters (rows 12–15): Endpoint mobility ratio M = (Krw_Sorw·μo)/(Krow_Swi·μw) characterizes displacement efficiency — M > 1 is unfavorable (early breakthrough, low recovery), M < 1 is favorable. Mobile oil saturation and ultimate displacement efficiency set the theoretical maximum recovery.
- Fractional Flow Table (rows 17–30): Water saturation sweep from Swi to 1−Sorw in 0.05 steps. Columns: Sw, Krow (from PO.SCAL.Corey.Krow), Krw (from PO.SCAL.Corey.Krw), fw (water cut via LAMBDA), and Welge tangent slope fw/(Sw−Swi). The fw LAMBDA uses the mobility-weighted form (Krw/μw)/(Krw/μw + Krow/μo) to avoid division by zero at endpoints.
- Welge Tangent Analysis (rows 32–39): The Welge construction finds the breakthrough front saturation Sw_f where a straight line from (Swi, 0) is tangent to the fw curve — this occurs at the maximum of the Welge slope column. PV injected at BT = 1/slope. Average Sw behind front from the Welge material balance: Sw_avg = Sw_f + (1−fw_f)/slope. BT and ultimate oil recovery factors expressed as fraction of OOIP.
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Waterflood Fractional Flow Analysis
- Click on the blueprint to preview the spreadsheet template
- Click Insert to place it into your worksheet. Modify the input values to match your data.