---
cid: po.bp.res.hall.plot
hub: res
tags: [reservoir, waterflood, Hall-plot, injectivity, injector, surveillance, voidage-replacement, VRR, skin, fracturing, plugging]
facets: { discipline: reservoir, method-type: analytical }
title: Injector Hall Plot and Voidage Replacement
summary: "Tracks whether an injector still takes water as before on a Hall plot and reports the pattern's monthly voidage replacement ratio."
slug: po.res.hall.plot
type: worksheet
---

# Injector Hall Plot and Voidage Replacement

## Description

Is the injector still taking water as it did, and is the pattern getting back what it gives up? You paste the injector's monthly days on injection, bottomhole pressure and rate, the pattern's monthly oil, water and gas, and the month after which the slope may have changed. You read off the Hall slope before and after that month, the skin each slope implies, a flag for plugging or a fracture opening, and the pattern's voidage replacement ratio (VRR), month by month and cumulative.

**Parameters:**
- **Injector**: the permeability `HALL_K` (mD), the net thickness taking water `HALL_H` (ft), the wellbore radius `HALL_Rw` and the drainage radius `HALL_Re` (ft), and the water viscosity `HALL_Muw` (cp)
- **Pressures**: the average reservoir pressure `HALL_Pe` and the bottomhole fracture pressure `HALL_Pfrac` (psi)
- **Fluids**: `HALL_Bo` and `HALL_Bw` (bbl/STB), `HALL_Bg` (bbl/Mscf) and the solution GOR `HALL_Rs` (scf/STB)
- **Split**: the months in the first segment, `HALL_Split`
- **Limits**: `HALL_SlopeTol` for the slope change, and `HALL_VrrLo` and `HALL_VrrHi` for the cumulative VRR
- **Injection**: each month's days on injection, average bottomhole pressure and average rate, in the injection table (`HALL_dt`, `HALL_Pwf`, `HALL_Q`)
- **Production**: each month's oil and water (STB) and gas (Mscf) produced, and any gas injected, in the production table

**How to use it:** The injector and pattern are synthetic. Paste the injector's monthly days on injection, average bottomhole pressure and rate, over the injection table's rows; a wellhead pressure plus the hydrostatic head less the tubing friction stands in for a bottomhole one. Set the reservoir pressure from the latest survey, and the split at the month you suspect a change, from the plot's bend or a workover date. Paste the pattern's allocated oil, water and gas, and any gas injected, over the production table.

The Hall plot draws the Hall integral, the sum of (pwf − pe) Δt, against the cumulative water injected, with the first segment's line carried across the whole history so that a bend shows. A second chart draws the monthly and cumulative VRR. The ratio of the two segments' slopes flags plugging, when the slope rises, or a fracture opening, when it falls.

Four checks give PASS, WARN or FAIL. The segment check fails when the split leaves either segment under two months. The slope-change check warns when the second segment's slope differs from the first's by more than the limit, naming plugging or fracturing. The fracture-pressure check warns when the highest bottomhole pressure reaches the fracture pressure. The voidage check warns when the cumulative VRR is outside its band.

**Method:** In each month the Hall integral grows by (pwf − pe) Δt and the cumulative injection by q Δt. Each segment's slope is the least-squares slope of the integral against the cumulative injection over its rows; a running sum restarted at the segment has the same slope. Under steady radial flow the slope is 141.2 Bw μw (ln(re/rw) + s)/(k h), so the skin a slope implies is s = slope · k h/(141.2 Bw μw) − ln(re/rw). The slope ratio is the second segment's over the first's.

VRR = (Wi Bw + Gi Bg)/(Np Bo + (Gp − Np Rs) Bg + Wp Bw), each period's, and the cumulative ratio divides the running sums. The gas volumes are in Mscf, so Rs enters in Mscf/STB.

**Example:** The default case is a synthetic injector in a 50 mD sand, 20 ft taking water, with a 0.3 ft wellbore and a 660 ft drainage radius, injecting 0.50 cp water at Bw 1.02 into a pattern held at 2,000 psi. Its first year's pressures follow the radial-flow Hall slope at skin 0, about 1,000 STB/d at 2,530 to 2,580 psi. In the second year the slope is that of skin −3, as a fracture opening leaves it: about 1,450 STB/d at 2,470 to 2,500 psi. A step-rate test put the fracture pressure at 2,575 psi. The pattern's producers make about 700 STB/d of oil, falling, with water rising from 140 to 440 STB/d and a GOR near 650 scf/STB against an Rs of 550; Bo is 1.20 and Bg 0.90 bbl/Mscf.

The radial-flow slope at skin 0 is 0.5542 psi·d/bbl. Over the first twelve months the Hall slope is 0.5542, skin 0.0; over the second twelve it is 0.3382, skin −3.0. It fell 39% after month 12, and the slope-change check warns of a fracture opening. Pwf reached 2,582 psi in month 5, above the 2,575 psi fracture pressure, and that check warns too: the injector was near fracturing from the start. Over all 24 months the slope is 0.4170. The injector put away 890,110 STB. The VRR held near 0.95 in the first year and rose to 1.2 to 1.3 in the second, as the fractured well took more water; the cumulative VRR is 1.10, above the band, and warns that water is leaving the pattern or the zone. With the split at month 18 the first segment mixes both years, its slope falls to 0.4709 and its skin to −1.16, and the change reads 28%: set the split at the bend.

## Validity

The skin conversion assumes steady radial flow of water at the average reservoir pressure, as the Hall analysis does; early in a flood, before fill-up, the slope reflects the transient and reads high. A slope change can also come from a change in the reservoir pressure the integral is taken against, or from a polymer or gel treatment (the slope ratio is then the resistance factor, Buell et al.). Monthly averages hide shut-ins and rate swings within the month; use days on injection, not calendar days. VRR uses one set of formation volume factors; for a pattern well above or below its bubble point, or with a changing Rs, use the period's own. A VRR away from 1 is read with the pattern's pressure trend: out-of-zone injection shows as a VRR above 1 with no pressure rise. Field units.

Named alternatives: a step-rate test for the fracture pressure itself, on the Injection Falloff and Step-Rate Test sheet; Buell, Kazemi and Poettmann's reading of the Hall slope ratio as a polymer's resistance factor.

## References

- Hall, H.N. (1963). How to Analyze Waterflood Injection Well Performance. *World Oil*, October, 128–130.
- Buell, R.S., Kazemi, H. and Poettmann, F.H. (1990). Analyzing Injectivity of Polymer Solutions with the Hall Plot. *SPE Reservoir Engineering* 5(1), 41–46.
- Craig, F.F. (1971). *The Reservoir Engineering Aspects of Waterflooding*. SPE Monograph 3.
- Ahmed, T. (2010). *Reservoir Engineering Handbook*, 4th ed. Gulf Professional Publishing.

## Functions used

`PO.RES.Waterflood.Hall`, `PO.RES.Waterflood.VRR`

## Spreadsheet: HallPlot

|     | A                                                                                                                                                                                                                              | B                                                                                                                                                                                                                                     | C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | D                   | E                                                                                | F                                                                                | G                                                                                                                                                    | H                                                                                                                                                    |
|-----|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------------|----------------------------------------------------------------------------------|----------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------|
| 1   | Injector Hall Plot and Voidage Replacement                                                                                                                                                                                     |                                                                                                                                                                                                                                       | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 2   | Blue cells on yellow are inputs. Paste the injector's monthly days, pressure and rate and the pattern's production, and pick the month the slope may have changed.                                                             |                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 3   | The Injector, the Reservoir Pressure, the Fluids, the Split Month and the Limits                                                                                                                                               |                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 4   | Permeability                                                                                                                                                                                                                   | 50                                                                                                                                                                                                                                    | mD                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 5   | Net thickness taking water                                                                                                                                                                                                     | 20                                                                                                                                                                                                                                    | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 6   | Wellbore radius                                                                                                                                                                                                                | 0.3                                                                                                                                                                                                                                   | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 7   | Drainage radius (half the injector-producer spacing)                                                                                                                                                                           | 660                                                                                                                                                                                                                                   | ft                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 8   | Water viscosity at reservoir conditions                                                                                                                                                                                        | 0.5                                                                                                                                                                                                                                   | cp                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 9   | Average reservoir pressure in the pattern                                                                                                                                                                                      | 2000                                                                                                                                                                                                                                  | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 10  | Bottomhole fracture pressure (from a step-rate test)                                                                                                                                                                           | 2575                                                                                                                                                                                                                                  | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 11  | Oil formation volume factor                                                                                                                                                                                                    | 1.2                                                                                                                                                                                                                                   | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 12  | Water formation volume factor (produced and injected)                                                                                                                                                                          | 1.02                                                                                                                                                                                                                                  | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 13  | Gas formation volume factor                                                                                                                                                                                                    | 0.9                                                                                                                                                                                                                                   | bbl/Mscf                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 14  | Solution gas-oil ratio                                                                                                                                                                                                         | 550                                                                                                                                                                                                                                   | scf/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 15  | Months in the first segment (the slope may change after it)                                                                                                                                                                    | 12                                                                                                                                                                                                                                    | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 16  | Largest change in the Hall slope read as no change                                                                                                                                                                             | 0.2                                                                                                                                                                                                                                   | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 17  | Cumulative VRR check, lowest                                                                                                                                                                                                   | 0.95                                                                                                                                                                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 18  | Cumulative VRR check, highest                                                                                                                                                                                                  | 1.05                                                                                                                                                                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 19  | Constants                                                                                                                                                                                                                      |                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 20  | Radial-flow constant of Darcy's law in field units                                                                                                                                                                             | 141.2                                                                                                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 21  | The Hall function's mode for the slope                                                                                                                                                                                         | 3                                                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 22  | Standard cubic feet in an Mscf                                                                                                                                                                                                 | 1000                                                                                                                                                                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 28  | Hall Slopes, the Skin They Imply, the Slope Change and the Voidage Replacement                                                                                                                                                 |                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 29  | Months of injection reported                                                                                                                                                                                                   | =COUNT(HALL_dt)                                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 30  | Radial-flow Hall slope at skin 0, 141.2 Bw μ ln(re/rw)/(k h)                                                                                                                                                                   | =HALL_Darcy*HALL_Bw*HALL_Muw*LN(HALL_Re/HALL_Rw)/(HALL_K*HALL_H)                                                                                                                                                                      | psi·d/bbl                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 31  | Hall slope over all months                                                                                                                                                                                                     | =PO.RES.Waterflood.Hall(HALL_dt,HALL_Pwf,HALL_Pe,HALL_Q,HALL_ModeSlope)                                                                                                                                                               | psi·d/bbl                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 32  | Hall slope, first segment                                                                                                                                                                                                      | =PO.RES.Waterflood.Hall(TAKE(HALL_dt,HALL_Split),TAKE(HALL_Pwf,HALL_Split),HALL_Pe,TAKE(HALL_Q,HALL_Split),HALL_ModeSlope)                                                                                                            | psi·d/bbl                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 33  | Hall slope, second segment                                                                                                                                                                                                     | =PO.RES.Waterflood.Hall(DROP(TAKE(HALL_dt,HALL_N),HALL_Split),DROP(TAKE(HALL_Pwf,HALL_N),HALL_Split),HALL_Pe,DROP(TAKE(HALL_Q,HALL_N),HALL_Split),HALL_ModeSlope)                                                                     | psi·d/bbl                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 34  | Second segment's slope over the first's                                                                                                                                                                                        | =HALL_SlopeLate/HALL_SlopeEarly                                                                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 35  | Skin implied by the first segment                                                                                                                                                                                              | =HALL_SlopeEarly*HALL_K*HALL_H/(HALL_Darcy*HALL_Bw*HALL_Muw)-LN(HALL_Re/HALL_Rw)                                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 36  | Skin implied by the second segment                                                                                                                                                                                             | =HALL_SlopeLate*HALL_K*HALL_H/(HALL_Darcy*HALL_Bw*HALL_Muw)-LN(HALL_Re/HALL_Rw)                                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 37  | First segment's intercept, for its trend line                                                                                                                                                                                  | =INTERCEPT(PO.RES.Waterflood.Hall(TAKE(HALL_dt,HALL_Split),TAKE(HALL_Pwf,HALL_Split),HALL_Pe,TAKE(HALL_Q,HALL_Split),1),PO.RES.Waterflood.Hall(TAKE(HALL_dt,HALL_Split),TAKE(HALL_Pwf,HALL_Split),HALL_Pe,TAKE(HALL_Q,HALL_Split),2)) | psi·d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 38  | Highest bottomhole injection pressure                                                                                                                                                                                          | =MAX(HALL_Pwf)                                                                                                                                                                                                                        | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 39  | Water injected, all months                                                                                                                                                                                                     | =F76                                                                                                                                                                                                                                  | STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 40  | Voidage replacement ratio, last month                                                                                                                                                                                          | =G103                                                                                                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 41  | Voidage replacement ratio, cumulative                                                                                                                                                                                          | =H103                                                                                                                                                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 42  | Segment check                                                                                                                                                                                                                  | =IF(OR(HALL_Split<2,HALL_Split>HALL_N-2),"FAIL","PASS")                                                                                                                                                                               | =IF(OR(HALL_Split<2,HALL_Split>HALL_N-2),"the split at month "&HALL_Split&" leaves a segment under two months: no slope can be read",""&HALL_Split&" months before the split and "&(HALL_N-HALL_Split)&" after it")                                                                                                                                                                                                                                                                                                                                                               |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 43  | Slope-change check                                                                                                                                                                                                             | =IF(HALL_Ratio<1-HALL_SlopeTol,"WARN",IF(HALL_Ratio>1+HALL_SlopeTol,"WARN","PASS"))                                                                                                                                                   | =IF(HALL_Ratio<1-HALL_SlopeTol,"the Hall slope fell "&FIXED((1-HALL_Ratio)*100,0)&"% after month "&HALL_Split&" (skin "&FIXED(HALL_SkinEarly,1)&" to "&FIXED(HALL_SkinLate,1)&"): a fracture is opening, or the well was stimulated",IF(HALL_Ratio>1+HALL_SlopeTol,"the Hall slope rose "&FIXED((HALL_Ratio-1)*100,0)&"% after month "&HALL_Split&" (skin "&FIXED(HALL_SkinEarly,1)&" to "&FIXED(HALL_SkinLate,1)&"): the well is plugging; check the water quality","the Hall slope changed "&FIXED((HALL_Ratio-1)*100,0)&"% after month "&HALL_Split&": the injectivity held")) |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 44  | Fracture-pressure check                                                                                                                                                                                                        | =IF(HALL_PwfMax<HALL_Pfrac,"PASS","WARN")                                                                                                                                                                                             | =IF(HALL_PwfMax<HALL_Pfrac,"the highest Pwf, "&FIXED(HALL_PwfMax,0)&" psi, stays below the "&FIXED(HALL_Pfrac,0)&" psi fracture pressure","Pwf reached "&FIXED(HALL_PwfMax,0)&" psi, at or above the "&FIXED(HALL_Pfrac,0)&" psi fracture pressure: the injector has been fracturing the rock")                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 45  | Voidage check                                                                                                                                                                                                                  | =IF(HALL_VrrCum<HALL_VrrLo,"WARN",IF(HALL_VrrCum>HALL_VrrHi,"WARN","PASS"))                                                                                                                                                           | =IF(HALL_VrrCum<HALL_VrrLo,"the cumulative VRR is "&FIXED(HALL_VrrCum,2)&", below "&FIXED(HALL_VrrLo,2)&": the pattern is under-injected and its pressure will fall",IF(HALL_VrrCum>HALL_VrrHi,"the cumulative VRR is "&FIXED(HALL_VrrCum,2)&", above "&FIXED(HALL_VrrHi,2)&": water is leaving the pattern or the zone, or its pressure is rising","the cumulative VRR is "&FIXED(HALL_VrrCum,2)&", within "&FIXED(HALL_VrrLo,2)&" to "&FIXED(HALL_VrrHi,2)))                                                                                                                    |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 47  | How to use it: paste the injector's monthly days on injection, average bottomhole pressure (or wellhead plus hydrostatic less friction) and rate, the pattern's oil, water and gas, and set the split at the suspected change. |                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 48  | The injector and pattern are synthetic. The skin assumes steady radial flow at the average reservoir pressure; a VRR off 1 is read with the pattern's pressure trend.                                                          |                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 51  | The Injector's Monthly Report and Its Hall Plot (EXAMPLE)                                                                                                                                                                      |                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 52  | Month                                                                                                                                                                                                                          | Days on injection (days)                                                                                                                                                                                                              | Pwf (psi)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | Rate (STB/d)        | Hall integral (psi·d)                                                            | Water injected (STB)                                                             | First-segment trend (psi·d)                                                                                                                          |                                                                                                                                                      |
| 53  | 1                                                                                                                                                                                                                              | 31                                                                                                                                                                                                                                    | 2527                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 950                 | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),1)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),1)  | =HALL_Icpt+HALL_SlopeEarly*F53                                                                                                                       |                                                                                                                                                      |
| 54  | 2                                                                                                                                                                                                                              | 28                                                                                                                                                                                                                                    | 2554                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1000                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),2)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),2)  | =HALL_Icpt+HALL_SlopeEarly*F54                                                                                                                       |                                                                                                                                                      |
| 55  | 3                                                                                                                                                                                                                              | 31                                                                                                                                                                                                                                    | 2565                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1020                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),3)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),3)  | =HALL_Icpt+HALL_SlopeEarly*F55                                                                                                                       |                                                                                                                                                      |
| 56  | 4                                                                                                                                                                                                                              | 30                                                                                                                                                                                                                                    | 2543                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 980                 | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),4)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),4)  | =HALL_Icpt+HALL_SlopeEarly*F56                                                                                                                       |                                                                                                                                                      |
| 57  | 5                                                                                                                                                                                                                              | 31                                                                                                                                                                                                                                    | 2582                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1050                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),5)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),5)  | =HALL_Icpt+HALL_SlopeEarly*F57                                                                                                                       |                                                                                                                                                      |
| 58  | 6                                                                                                                                                                                                                              | 30                                                                                                                                                                                                                                    | 2554                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1000                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),6)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),6)  | =HALL_Icpt+HALL_SlopeEarly*F58                                                                                                                       |                                                                                                                                                      |
| 59  | 7                                                                                                                                                                                                                              | 31                                                                                                                                                                                                                                    | 2549                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 990                 | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),7)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),7)  | =HALL_Icpt+HALL_SlopeEarly*F59                                                                                                                       |                                                                                                                                                      |
| 60  | 8                                                                                                                                                                                                                              | 31                                                                                                                                                                                                                                    | 2571                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1030                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),8)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),8)  | =HALL_Icpt+HALL_SlopeEarly*F60                                                                                                                       |                                                                                                                                                      |
| 61  | 9                                                                                                                                                                                                                              | 30                                                                                                                                                                                                                                    | 2560                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1010                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),9)  | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),9)  | =HALL_Icpt+HALL_SlopeEarly*F61                                                                                                                       |                                                                                                                                                      |
| 62  | 10                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2554                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1000                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),10) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),10) | =HALL_Icpt+HALL_SlopeEarly*F62                                                                                                                       |                                                                                                                                                      |
| 63  | 11                                                                                                                                                                                                                             | 30                                                                                                                                                                                                                                    | 2538                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 970                 | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),11) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),11) | =HALL_Icpt+HALL_SlopeEarly*F63                                                                                                                       |                                                                                                                                                      |
| 64  | 12                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2576                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1040                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),12) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),12) | =HALL_Icpt+HALL_SlopeEarly*F64                                                                                                                       |                                                                                                                                                      |
| 65  | 13                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2467                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1380                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),13) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),13) | =HALL_Icpt+HALL_SlopeEarly*F65                                                                                                                       |                                                                                                                                                      |
| 66  | 14                                                                                                                                                                                                                             | 28                                                                                                                                                                                                                                    | 2477                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1410                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),14) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),14) | =HALL_Icpt+HALL_SlopeEarly*F66                                                                                                                       |                                                                                                                                                      |
| 67  | 15                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2473                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1400                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),15) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),15) | =HALL_Icpt+HALL_SlopeEarly*F67                                                                                                                       |                                                                                                                                                      |
| 68  | 16                                                                                                                                                                                                                             | 30                                                                                                                                                                                                                                    | 2484                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1430                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),16) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),16) | =HALL_Icpt+HALL_SlopeEarly*F68                                                                                                                       |                                                                                                                                                      |
| 69  | 17                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2480                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1420                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),17) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),17) | =HALL_Icpt+HALL_SlopeEarly*F69                                                                                                                       |                                                                                                                                                      |
| 70  | 18                                                                                                                                                                                                                             | 30                                                                                                                                                                                                                                    | 2490                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1450                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),18) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),18) | =HALL_Icpt+HALL_SlopeEarly*F70                                                                                                                       |                                                                                                                                                      |
| 71  | 19                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2487                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1440                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),19) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),19) | =HALL_Icpt+HALL_SlopeEarly*F71                                                                                                                       |                                                                                                                                                      |
| 72  | 20                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2494                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1460                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),20) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),20) | =HALL_Icpt+HALL_SlopeEarly*F72                                                                                                                       |                                                                                                                                                      |
| 73  | 21                                                                                                                                                                                                                             | 30                                                                                                                                                                                                                                    | 2484                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1430                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),21) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),21) | =HALL_Icpt+HALL_SlopeEarly*F73                                                                                                                       |                                                                                                                                                      |
| 74  | 22                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2497                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1470                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),22) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),22) | =HALL_Icpt+HALL_SlopeEarly*F74                                                                                                                       |                                                                                                                                                      |
| 75  | 23                                                                                                                                                                                                                             | 30                                                                                                                                                                                                                                    | 2490                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1450                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),23) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),23) | =HALL_Icpt+HALL_SlopeEarly*F75                                                                                                                       |                                                                                                                                                      |
| 76  | 24                                                                                                                                                                                                                             | 31                                                                                                                                                                                                                                    | 2501                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 1480                | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,1),24) | =INDEX(PO.RES.Waterflood.Hall($B$53:$B$76,$C$53:$C$76,HALL_Pe,$D$53:$D$76,2),24) | =HALL_Icpt+HALL_SlopeEarly*F76                                                                                                                       |                                                                                                                                                      |
| 78  | The Pattern's Monthly Production and Voidage Replacement (EXAMPLE)                                                                                                                                                             |                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                     |                                                                                  |                                                                                  |                                                                                                                                                      |                                                                                                                                                      |
| 79  | Month                                                                                                                                                                                                                          | Oil produced (STB)                                                                                                                                                                                                                    | Water produced (STB)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Gas produced (Mscf) | Gas injected (Mscf)                                                              | Water injected (STB)                                                             | VRR, month                                                                                                                                           | VRR, cumulative                                                                                                                                      |
| 80  | 1                                                                                                                                                                                                                              | 22320                                                                                                                                                                                                                                 | 4340                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14285               | 0                                                                                | =B53*D53                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),1)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),1)  |
| 81  | 2                                                                                                                                                                                                                              | 20076                                                                                                                                                                                                                                 | 4032                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 12909               | 0                                                                                | =B54*D54                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),2)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),2)  |
| 82  | 3                                                                                                                                                                                                                              | 22134                                                                                                                                                                                                                                 | 4588                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14299               | 0                                                                                | =B55*D55                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),3)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),3)  |
| 83  | 4                                                                                                                                                                                                                              | 21330                                                                                                                                                                                                                                 | 4560                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 13843               | 0                                                                                | =B56*D56                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),4)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),4)  |
| 84  | 5                                                                                                                                                                                                                              | 21948                                                                                                                                                                                                                                 | 4836                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14310               | 0                                                                                | =B57*D57                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),5)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),5)  |
| 85  | 6                                                                                                                                                                                                                              | 21150                                                                                                                                                                                                                                 | 4800                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 13853               | 0                                                                                | =B58*D58                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),6)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),6)  |
| 86  | 7                                                                                                                                                                                                                              | 21762                                                                                                                                                                                                                                 | 5084                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14319               | 0                                                                                | =B59*D59                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),7)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),7)  |
| 87  | 8                                                                                                                                                                                                                              | 21669                                                                                                                                                                                                                                 | 5208                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14323               | 0                                                                                | =B60*D60                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),8)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),8)  |
| 88  | 9                                                                                                                                                                                                                              | 20880                                                                                                                                                                                                                                 | 5160                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 13864               | 0                                                                                | =B61*D61                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),9)  | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),9)  |
| 89  | 10                                                                                                                                                                                                                             | 21483                                                                                                                                                                                                                                 | 5456                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14329               | 0                                                                                | =B62*D62                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),10) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),10) |
| 90  | 11                                                                                                                                                                                                                             | 20700                                                                                                                                                                                                                                 | 5400                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 13869               | 0                                                                                | =B63*D63                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),11) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),11) |
| 91  | 12                                                                                                                                                                                                                             | 21297                                                                                                                                                                                                                                 | 5704                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14333               | 0                                                                                | =B64*D64                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),12) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),12) |
| 92  | 13                                                                                                                                                                                                                             | 21390                                                                                                                                                                                                                                 | 6200                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14460               | 0                                                                                | =B65*D65                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),13) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),13) |
| 93  | 14                                                                                                                                                                                                                             | 19096                                                                                                                                                                                                                                 | 6216                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 12966               | 0                                                                                | =B66*D66                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),14) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),14) |
| 94  | 15                                                                                                                                                                                                                             | 20894                                                                                                                                                                                                                                 | 7564                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14250               | 0                                                                                | =B67*D67                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),15) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),15) |
| 95  | 16                                                                                                                                                                                                                             | 19980                                                                                                                                                                                                                                 | 7980                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 13686               | 0                                                                                | =B68*D68                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),16) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),16) |
| 96  | 17                                                                                                                                                                                                                             | 20398                                                                                                                                                                                                                                 | 8928                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 14034               | 0                                                                                | =B69*D69                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),17) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),17) |
| 97  | 18                                                                                                                                                                                                                             | 19500                                                                                                                                                                                                                                 | 9300                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | 13474               | 0                                                                                | =B70*D70                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),18) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),18) |
| 98  | 19                                                                                                                                                                                                                             | 19902                                                                                                                                                                                                                                 | 10292                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 13812               | 0                                                                                | =B71*D71                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),19) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),19) |
| 99  | 20                                                                                                                                                                                                                             | 19654                                                                                                                                                                                                                                 | 10974                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 13699               | 0                                                                                | =B72*D72                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),20) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),20) |
| 100 | 21                                                                                                                                                                                                                             | 18780                                                                                                                                                                                                                                 | 11280                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 13146               | 0                                                                                | =B73*D73                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),21) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),21) |
| 101 | 22                                                                                                                                                                                                                             | 19158                                                                                                                                                                                                                                 | 12338                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 13468               | 0                                                                                | =B74*D74                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),22) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),22) |
| 102 | 23                                                                                                                                                                                                                             | 18300                                                                                                                                                                                                                                 | 12600                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 12920               | 0                                                                                | =B75*D75                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),23) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),23) |
| 103 | 24                                                                                                                                                                                                                             | 18662                                                                                                                                                                                                                                 | 13702                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | 13231               | 0                                                                                | =B76*D76                                                                         | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,1),24) | =INDEX(PO.RES.Waterflood.VRR($B$80:$B$103,$C$80:$C$103,$D$80:$D$103,HALL_Bo,HALL_Bw,HALL_Bg,HALL_Rs/HALL_ScfPerMscf,$F$80:$F$103,$E$80:$E$103,2),24) |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.RES.Waterflood.Hall | =LAMBDA(dt, Pwf, Pe, Q, Mode, LET(hall, SCAN(0, (Pwf-Pe)*dt, LAMBDA(acc, v, acc+v)), wi, SCAN(0, Q*dt, LAMBDA(acc, v, acc+v)), IF(Mode=1, hall, IF(Mode=2, wi, IF(Mode=3, SLOPE(hall, wi), NA()))))) | Hall plot of an injector: Mode 1 Hall integral, psi-d; 2 cumulative injection, bbl; 3 Hall slope, psi-d/bbl, by least squares |
| PO.RES.Waterflood.VRR | =LAMBDA(Np, Wp, Gp, Bo, Bw, Bg, Rs, Wi, Gi, Mode, LET(inj, Wi*Bw+Gi*Bg, wd, Np*Bo+(Gp-Np*Rs)*Bg+Wp*Bw, IF(Mode=1, inj/wd, IF(Mode=2, SCAN(0, inj, LAMBDA(acc, v, acc+v))/SCAN(0, wd, LAMBDA(acc, v, acc+v)), NA())))) | Voidage replacement ratio in reservoir barrels, injected over withdrawn: Mode 1 per period, 2 cumulative |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| HALL_K | $B$4 | Permeability, mD |
| HALL_H | $B$5 | Net thickness taking water, ft |
| HALL_Rw | $B$6 | Wellbore radius, ft |
| HALL_Re | $B$7 | Drainage radius (half the injector-producer spacing), ft |
| HALL_Muw | $B$8 | Water viscosity at reservoir conditions, cp |
| HALL_Pe | $B$9 | Average reservoir pressure in the pattern, psi |
| HALL_Pfrac | $B$10 | Bottomhole fracture pressure (from a step-rate test), psi |
| HALL_Bo | $B$11 | Oil formation volume factor, bbl/STB |
| HALL_Bw | $B$12 | Water formation volume factor (produced and injected), bbl/STB |
| HALL_Bg | $B$13 | Gas formation volume factor, bbl/Mscf |
| HALL_Rs | $B$14 | Solution gas-oil ratio, scf/STB |
| HALL_Split | $B$15 | Months in the first segment (the slope may change after it) |
| HALL_SlopeTol | $B$16 | Largest change in the Hall slope read as no change, % |
| HALL_VrrLo | $B$17 | Cumulative VRR check, lowest |
| HALL_VrrHi | $B$18 | Cumulative VRR check, highest |
| HALL_Inputs | $B$4:$B$18 | The injector's k, h, rw and re, the water viscosity, the reservoir and fracture pressures, Bo, Bw, Bg and Rs, the split month and the check limits |
| HALL_Darcy | $B$20 | Radial-flow constant of Darcy's law in field units |
| HALL_ModeSlope | $B$21 | The Hall function's mode for the slope |
| HALL_ScfPerMscf | $B$22 | Standard cubic feet in an Mscf |
| HALL_N | $B$29 | Months of injection reported |
| HALL_Ideal | $B$30 | Radial-flow Hall slope at skin 0, 141.2 Bw μ ln(re/rw)/(k h), psi·d/bbl |
| HALL_SlopeAll | $B$31 | Hall slope over all months, psi·d/bbl |
| HALL_SlopeEarly | $B$32 | Hall slope, first segment, psi·d/bbl |
| HALL_SlopeLate | $B$33 | Hall slope, second segment, psi·d/bbl |
| HALL_Ratio | $B$34 | Second segment's slope over the first's |
| HALL_SkinEarly | $B$35 | Skin implied by the first segment |
| HALL_SkinLate | $B$36 | Skin implied by the second segment |
| HALL_Icpt | $B$37 | First segment's intercept, for its trend line, psi·d |
| HALL_PwfMax | $B$38 | Highest bottomhole injection pressure, psi |
| HALL_Wi | $B$39 | Water injected, all months, STB |
| HALL_VrrLast | $B$40 | Voidage replacement ratio, last month |
| HALL_VrrCum | $B$41 | Voidage replacement ratio, cumulative |
| HALL_SplitCheck | $B$42 | Segment check verdict |
| HALL_SplitCheckNote | $C$42 | Segment check comment |
| HALL_SlopeCheck | $B$43 | Slope-change check verdict |
| HALL_SlopeCheckNote | $C$43 | Slope-change check comment |
| HALL_FracCheck | $B$44 | Fracture-pressure check verdict |
| HALL_FracCheckNote | $C$44 | Fracture-pressure check comment |
| HALL_VrrCheck | $B$45 | Voidage check verdict |
| HALL_VrrCheckNote | $C$45 | Voidage check comment |
| HALL_Results | $B$29:$B$45 | The months, the radial-flow slope, the Hall slope over all months and each segment, their ratio and skins, the highest Pwf, the water injected, the VRR and four checks |
| HALL_Curve | $A$53:$G$76 | Each month's days, bottomhole pressure and rate, the Hall integral, the cumulative injection and the first segment's trend |
| HALL_dt | $B$53:$B$76 | Days on injection in each month |
| HALL_Pwf | $C$53:$C$76 | Average bottomhole injection pressure in each month, psi |
| HALL_Q | $D$53:$D$76 | Average injection rate in each month, STB/d |
| HALL_VrrCurve | $A$80:$H$103 | Each month's oil, water and gas produced, gas and water injected, and the monthly and cumulative VRR |

---

## Related Blueprints
- [Waterflood Vertical Sweep in a Layered Reservoir](/blueprint/po.res.waterflood.dykstraparsons.md)
- [Volumetric Oil in Place](/blueprint/po.res.volumetrics.stoiip.md)
- [Volumetric Gas in Place](/blueprint/po.res.volumetrics.giip.md)
- [Recovery Factor by Drive Mechanism](/blueprint/po.res.recovery.factor.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)

