---
cid: po.bp.mbe.oil.forecast
hub: mbe
tags: [MBE, oil, forecast, prediction, Tracy, Tarner, solution-gas-drive, bubble-point, GOR, recovery-factor, relative-permeability]
facets: { discipline: reservoir, phase: oil, property: recovery, method-type: analytical }
title: Oil Reservoir Forecast below the Bubble Point (Tarner-Tracy)
summary: "Forecasts oil recovery and the rising GOR of a solution-gas-drive reservoir below the bubble point by the Tarner-Tracy method."
slug: po.mbe.oil.forecast
type: worksheet
---

# Oil Reservoir Forecast below the Bubble Point (Tarner-Tracy)

## Description

How much oil will a solution-gas-drive reservoir give up as its pressure falls below the bubble point, and how fast will the gas-oil ratio climb? You enter the oil in place, the initial and bubble-point pressures with Boi and Rsi, the connate water and compressibilities, the oil and gas gravities and temperature for the PVT, Corey gas-oil relative permeability, an abandonment pressure and a gas-handling limit. You read off the cumulative oil and gas, oil saturation, producing GOR and recovery factor at each pressure step.

The sheet forecasts it with Tracy's form of Tarner's material-balance method. It steps the reservoir pressure down from the bubble point to an abandonment pressure in twelve equal steps. At each step it computes the black-oil PVT, Tracy's coefficients Φo and Φg, and the oil the step produces. The producing GOR at the end of a step depends on the oil saturation, which depends on the oil produced, so each step is solved by three explicit passes that the table shows side by side. Each step then gives the cumulative oil and gas, the oil saturation, the producing GOR and the recovery factor.

One chart draws the reservoir pressure and the producing GOR against the cumulative oil; a second draws the recovery factor against pressure. Three checks read the result. The pressure-range check fails when the abandonment pressure is not below the bubble point. The gas-handling check fails when the producing GOR passes the limit the wells and plant can handle, and names the pressure and recovery where it does. The convergence check warns when the third pass still moved the GOR by more than the limit.

**Parameters:**
- **Reservoir**: the original oil in place `OF_N` (MMSTB), the initial and bubble-point pressures `OF_Pi` and `OF_Pb` (psi), Boi `OF_Boi` (bbl/STB) and Rsi `OF_Rsi` (scf/STB) at Pi, the connate water saturation `OF_Swc`, and the water and pore-volume compressibilities `OF_cw` and `OF_cf` (1/psi). The Oil Material Balance (Havlena-Odeh) sheet gives N.
- **Correlations**: the stock-tank oil gravity `OF_API`, the solution gas gravity `OF_GasSG` and the reservoir temperature `OF_T` (°F)
- **Relative permeability**: Corey gas-oil curves from the critical gas saturation `OF_Sgc`, the residual oil saturation to gas `OF_Sorg`, the end point `OF_KrgMax` and the exponents `OF_NoExp` and `OF_NgExp`. The Corey Relative Permeability Curves and Honarpour Gas-Oil Relative Permeability sheets fit or estimate them.
- **Forecast and limits**: the abandonment pressure `OF_Pab` (psi), the producing GOR the wells and plant can handle `OF_GorMax` (scf/STB), and the GOR change in the third pass accepted as converged `OF_MoveTol`

**How to use it:** The default reservoir's PVT below the bubble point and its relative permeability are synthetic, from correlations. Type N from a material balance and Pb, Rsi and Boi from the PVT report. Paste a differential liberation, adjusted to separator conditions, over the PVT table's Rs, Bo and Bg columns, and measured viscosities over μo and μg. Fit the Corey parameters to gas-oil core floods or to the field's GOR history, the most uncertain input of the method. Keep the steps small where the GOR climbs fastest, just after the gas saturation passes Sgc.

**Method:** Below the bubble point, with no gas cap and no water influx, the material balance is N·Et = Np·(Bo − Rs·Bg) + Gp·Bg, with Et = Eo + Efw. Eo = (Bo − Boi) + (Rsi − Rs)·Bg is the oil and its dissolved gas, and Efw = Boi·(cw·Swc + cf)/(1 − Swc)·(Pi − p) keeps the rock and water expansion. Tracy divides by Et: N = Np·Φo + Gp·Φg, with Φo = (Bo − Rs·Bg)/Et and Φg = Bg/Et. The oil produced from Pi to Pb, Npb = N·(Bob − Boi + Efw)/Bob, starts the forecast, with all its gas still in solution.

From one pressure step to the next, ΔNp = (N − Np·Φo − Gp·Φg)/(Φo + R̄·Φg), with Np and Gp at the step before and R̄ the average of the producing GOR there and at this step. The oil saturation after the step is So = (1 − Swc)·(1 − Np/N)·Bo/Boi, and the producing GOR is R = Rs + (krg/kro)·μo·Bo/(μg·Bg). Corey's curves give krg = krg,max·((Sg − Sgc)/(1 − Swc − Sorg − Sgc))^ng above Sgc and 0 below it, and kro = ((So − Sorg)/(1 − Swc − Sorg))^no. Pass 1 takes R̄ from the last step's GOR alone; passes 2 and 3 take this step's GOR from the pass before. The third pass's ΔNp is the step's, its Gp grows by ΔNp·R̄, and the GOR is evaluated at the step's final So. The last column is the relative change between the GOR the third pass used and the GOR at the final So.

- **PVT:** Rs is Standing's correlation scaled so that it equals Rsi at Pb, Bo Standing's saturated-oil correlation at that Rs, Z Dranchuk-Abou-Kassem's with Sutton's pseudo-criticals, Bg from its definition, μo Beggs-Robinson's saturated-oil viscosity over Beal's dead oil, and μg Lee-Gonzalez-Eakin's.

**Example:** The reservoir is the one the Oil Material Balance (Havlena-Odeh) sheet analyses: N = 282.8 MMSTB, its regression OOIP, 3,685 psi initially with a 1,500 psi bubble point, Boi 1.3102 bbl/STB, Rsi 600 scf/STB, Swc 24 %, cw 3.62 × 10⁻⁶ and cf 4.95 × 10⁻⁶ 1/psi. Below the bubble point the sheet takes a 40 °API oil and a 0.80 gravity gas at 160 °F. Standing's correlation gives 444 scf/STB at 1,500 psi, so Rs is scaled by 1.3515, and Bob is 1.3457 bbl/STB, close to the 1.34 that the material balance sheet's Bo history reaches at Pb. The Corey curves take Sgc 5 %, Sorg 15 %, krg,max 0.8, no = 3 and ng = 2. The forecast runs to 300 psi in twelve steps of 100 psi.

Above the bubble point the reservoir gave up 12.07 MMSTB, 4.27 % of N. Below it, the GOR first falls to 561 scf/STB at 1,400 psi, as gas comes out of solution but stays below Sgc, then climbs to 2,179 scf/STB at 1,100 psi and peaks at 7,953 scf/STB at 400 psi. At 300 psi the reservoir has produced 70.51 MMSTB, a recovery of 24.9 %, and 136.8 Bscf of gas, a cumulative GOR of 1,941 scf/STB, leaving So at 47.4 %. The peak GOR is within the 10,000 scf/STB limit. The third pass moved the GOR by at most 4.1 %, at 1,200 psi, within the 5 % tolerance. Solving every step to full convergence gives 70.39 MMSTB, 24.89 %, so three passes are within 0.2 %. A gas plant that takes only 3,000 scf/STB stops the forecast at 1,000 psi, at 18.3 % recovery. A critical gas saturation of 10 % holds the gas back longer: recovery rises to 28.0 %, but the GOR jumps faster once the gas flows and the third pass still moves it by 11.5 %, past the tolerance, and the convergence check warns.

## Validity

A tank model of a solution-gas-drive reservoir: one average pressure, no gas cap, no water influx or injection, and the produced gas leaving as fast as the relative permeability lets it. Gravity segregation, which builds a secondary gas cap and lowers the producing GOR, is not modelled, so the forecast is a lower bound on recovery for a thick or steeply dipping reservoir. The relative permeability ratio krg/kro is the method's weakest input; calibrate it to the field's early GOR history before trusting the late forecast. Tracy's coefficients swing widely just below the bubble point, where Et is small: keep the steps small there. The method gives oil and gas against pressure, not against time; tie it to time through the wells' inflow (the Composite Oil IPR sheet) or a decline (the Arps Decline Forecast sheet). For a gas cap or water influx, history-match first with the Oil Material Balance (Havlena-Odeh) and Aquifer Model Matching sheets.

Named alternatives: Muskat's differential form of the same balance, Tarner's original trial-and-error form, or a black-oil simulation when the reservoir has a gas cap, an aquifer or strong segregation.

## References

- Tarner, J. (1944). How Different Size Gas Caps and Pressure Maintenance Programs Affect Amount of Recoverable Oil. *Oil Weekly* 144(2), 32–44.
- Tracy, G.W. (1955). Simplified Form of the Material Balance Equation. *Transactions of the AIME* 204, 243–246.
- Craft, B.C. and Hawkins, M.F. (1991). *Applied Petroleum Reservoir Engineering*, 2nd ed., revised by R.E. Terry. Prentice Hall, Ch. 4 (solution-gas-drive reservoirs).
- Ahmed, T. (2010). *Reservoir Engineering Handbook*, 4th ed. Gulf Professional Publishing, Ch. 15 (Tracy's and Tarner's methods).
- Standing, M.B. (1947). A Pressure-Volume-Temperature Correlation for Mixtures of California Oils and Gases. *Drilling and Production Practice*, API.
- Beggs, H.D. and Robinson, J.R. (1975). Estimating the Viscosity of Crude Oil Systems. *Journal of Petroleum Technology* 27(9), 1140–1141.

## Functions used

`PO.PVT.Rs.ByStanding`, `PO.PVT.Bo.Sat.ByStanding`, `PO.PVT.Uo.Dead.ByBeal`, `PO.PVT.Ppc.BySutton`, `PO.PVT.Tpc.BySutton`, `PO.PVT.Z.ByDAK`, `PO.PVT.Bg.ByDefinition`, `PO.PVT.Uo.Sat.ByBeggsRobinson`, `PO.PVT.Ug.ByLGE`, `PO.MBE.Exp.Eo`, `PO.MBE.Exp.Efw`, `PO.MBE.Exp.Et`

## Spreadsheet: MbeOilForecast

|    | A                                                                                                                                                                                                                      | B                                                                                    | C                                                                                                                                                                                                                                                                                                               | D                                                   | E                                                                                                                                                                                                                                                                 | F                                                  | G                                             | H                                              | I                                                                             | J                                                                                                                                                                                                                            | K             | L                    |
|----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------|-----------------------------------------------|------------------------------------------------|-------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|----------------------|
| 1  | Oil Reservoir Forecast below the Bubble Point (Tarner-Tracy)                                                                                                                                                           |                                                                                      | Petroleum Office                                                                                                                                                                                                                                                                                                |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 2  | Blue cells on yellow are inputs. Set N from a material balance and the PVT and relative permeability from your fluid and core; the forecast steps from Pb to abandonment.                                              |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 4  | Reservoir (the Havlena-Odeh Analysis)                                                                                                                                                                                  |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 5  | Original oil in place, N                                                                                                                                                                                               | 282.8                                                                                | MMSTB                                                                                                                                                                                                                                                                                                           |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 6  | Initial reservoir pressure                                                                                                                                                                                             | 3685                                                                                 | psi                                                                                                                                                                                                                                                                                                             |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 7  | Bubble-point pressure                                                                                                                                                                                                  | 1500                                                                                 | psi                                                                                                                                                                                                                                                                                                             |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 8  | Initial oil formation volume factor                                                                                                                                                                                    | 1.3102                                                                               | bbl/STB                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 9  | Initial solution gas-oil ratio                                                                                                                                                                                         | 600                                                                                  | scf/STB                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 10 | Connate water saturation                                                                                                                                                                                               | 0.24                                                                                 | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 11 | Water compressibility                                                                                                                                                                                                  | 0.00000362                                                                           | 1/psi                                                                                                                                                                                                                                                                                                           |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 12 | Formation (pore-volume) compressibility                                                                                                                                                                                | 0.00000495                                                                           | 1/psi                                                                                                                                                                                                                                                                                                           |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 13 | Oil and Gas for the Correlations                                                                                                                                                                                       |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 14 | Stock-tank oil gravity                                                                                                                                                                                                 | 40                                                                                   | °API                                                                                                                                                                                                                                                                                                            |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 15 | Solution gas specific gravity                                                                                                                                                                                          | 0.8                                                                                  | air = 1                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 16 | Reservoir temperature                                                                                                                                                                                                  | 160                                                                                  | °F                                                                                                                                                                                                                                                                                                              |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 17 | Gas-Oil Relative Permeability (Corey)                                                                                                                                                                                  |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 18 | Critical gas saturation                                                                                                                                                                                                | 0.05                                                                                 | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 19 | Residual oil saturation to gas                                                                                                                                                                                         | 0.15                                                                                 | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 20 | Gas relative permeability at residual oil                                                                                                                                                                              | 0.8                                                                                  | —                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 21 | Corey exponent for oil                                                                                                                                                                                                 | 3                                                                                    | —                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 22 | Corey exponent for gas                                                                                                                                                                                                 | 2                                                                                    | —                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 23 | Forecast and Limits                                                                                                                                                                                                    |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 24 | Abandonment reservoir pressure                                                                                                                                                                                         | 300                                                                                  | psi                                                                                                                                                                                                                                                                                                             |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 25 | Producing GOR the wells and plant can handle                                                                                                                                                                           | 10000                                                                                | scf/STB                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 26 | GOR change in the last pass accepted as converged                                                                                                                                                                      | 0.05                                                                                 | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 28 | Constants                                                                                                                                                                                                              |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 29 | Rankine at 0 °F                                                                                                                                                                                                        | 459.67                                                                               | °R                                                                                                                                                                                                                                                                                                              |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 30 | Cubic feet per barrel                                                                                                                                                                                                  | 5.615                                                                                | ft³/bbl                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 31 | Pressure steps, bubble point to abandonment                                                                                                                                                                            | 12                                                                                   | —                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 33 | Fluid at the Bubble Point and the Oil Produced above It                                                                                                                                                                |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 34 | Standing's Rs at Pb, before matching                                                                                                                                                                                   | =PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,OF_Pb,OF_T)                                    | scf/STB                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 35 | Rs match factor, Rsi over Standing's Rs at Pb                                                                                                                                                                          | =OF_Rsi/OF_RsStd                                                                     | —                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 36 | Oil formation volume factor at Pb (Standing)                                                                                                                                                                           | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,OF_Rsi,OF_T)                               | bbl/STB                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 37 | Dead-oil viscosity (Beal)                                                                                                                                                                                              | =PO.PVT.Uo.Dead.ByBeal(OF_API,OF_T)                                                  | cp                                                                                                                                                                                                                                                                                                              |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 38 | Pseudo-critical pressure of the gas (Sutton)                                                                                                                                                                           | =PO.PVT.Ppc.BySutton(OF_GasSG)                                                       | psi                                                                                                                                                                                                                                                                                                             |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 39 | Pseudo-critical temperature of the gas (Sutton)                                                                                                                                                                        | =PO.PVT.Tpc.BySutton(OF_GasSG)                                                       | °R                                                                                                                                                                                                                                                                                                              |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 40 | Oil produced from Pi down to Pb, Npb                                                                                                                                                                                   | =OF_N*(OF_Bob-OF_Boi+PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-OF_Pb))/OF_Bob | MMSTB                                                                                                                                                                                                                                                                                                           |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 41 | Forecast at Abandonment and the Checks                                                                                                                                                                                 |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 42 | Recovery factor at the bubble point                                                                                                                                                                                    | =OF_Npb/OF_N                                                                         | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 43 | Cumulative oil at abandonment, Np                                                                                                                                                                                      | =G92                                                                                 | MMSTB                                                                                                                                                                                                                                                                                                           |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 44 | Recovery factor at abandonment                                                                                                                                                                                         | =K92                                                                                 | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 45 | Cumulative gas at abandonment, Gp                                                                                                                                                                                      | =H92                                                                                 | Bscf                                                                                                                                                                                                                                                                                                            |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 46 | Cumulative producing GOR at abandonment, Rp                                                                                                                                                                            | =OF_Gp/OF_Np*1000                                                                    | scf/STB                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 47 | Producing GOR at abandonment                                                                                                                                                                                           | =J92                                                                                 | scf/STB                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 48 | Highest producing GOR                                                                                                                                                                                                  | =MAX(J80:J92)                                                                        | scf/STB                                                                                                                                                                                                                                                                                                         |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 49 | Oil saturation at abandonment                                                                                                                                                                                          | =I92                                                                                 | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 50 | Highest pressure step whose GOR passes the limit                                                                                                                                                                       | =IF(OF_GorPeak<=OF_GorMax,"not reached",MAXIFS(A80:A92,J80:J92,">"&OF_GorMax))       | psi                                                                                                                                                                                                                                                                                                             |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 51 | Recovery factor before the GOR passes the limit                                                                                                                                                                        | =MAXIFS(K80:K92,J80:J92,"<="&OF_GorMax)                                              | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 52 | Largest GOR change in the third pass                                                                                                                                                                                   | =MAX(L81:L92)                                                                        | %                                                                                                                                                                                                                                                                                                               |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 53 | Pressure-range check                                                                                                                                                                                                   | =IF(OF_Pab>=OF_Pb,"FAIL","PASS")                                                     | =IF(OF_Pab>=OF_Pb,"abandonment at "&FIXED(OF_Pab,0)&" psi is not below the "&FIXED(OF_Pb,0)&" psi bubble point: there is nothing to forecast",""&OF_Steps&" steps of "&FIXED((OF_Pb-OF_Pab)/OF_Steps,0)&" psi from the bubble point to "&FIXED(OF_Pab,0)&" psi")                                                |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 54 | Gas-handling check                                                                                                                                                                                                     | =IF(OF_GorPeak<=OF_GorMax,"PASS","FAIL")                                             | =IF(OF_GorPeak<=OF_GorMax,"the producing GOR peaks at "&FIXED(OF_GorPeak,0)&" scf/STB, within the "&FIXED(OF_GorMax,0)&" the wells and plant handle","the GOR passes "&FIXED(OF_GorMax,0)&" scf/STB by "&FIXED(OF_pGor,0)&" psi, at "&FIXED(OF_RFGor*100,1)&"% recovery: gas handling ends the forecast first") |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 55 | Convergence check                                                                                                                                                                                                      | =IF(OF_Move<=OF_MoveTol,"PASS","WARN")                                               | =IF(OF_Move<=OF_MoveTol,"the third pass moved the GOR by "&FIXED(OF_Move*100,1)&"% at most: the steps have converged","the third pass still moved the GOR by "&FIXED(OF_Move*100,1)&"%: take smaller steps (a higher Pab) or another pass")                                                                     |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 57 | How to use it: type N from a material balance, Pb, Rsi and Boi from the PVT report, and the Corey end points from gas-oil core floods; to use lab PVT, paste it over the PVT table's Rs, Bo, Bg and viscosity columns. |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 58 | Each step is solved three times: pass 1 takes the last step's GOR, passes 2 and 3 the GOR the pass before found. The third pass's ΔNp is the step's; its last column is how far the GOR still moved.                   |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 60 | Black-Oil PVT and Tracy's Coefficients at Each Pressure Step                                                                                                                                                           |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 61 | Rs is Standing's scaled to Rsi at Pb, Bo Standing's, Z Dranchuk-Abou-Kassem's, μo Beggs-Robinson's and μg Lee-Gonzalez-Eakin's. Φo = (Bo − Rs·Bg)/Et and Φg = Bg/Et.                                                   |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 62 | Pressure (psi)                                                                                                                                                                                                         | Z-factor (DAK)                                                                       | Rs (scf/STB)                                                                                                                                                                                                                                                                                                    | Bo (bbl/STB)                                        | Bg (bbl/Mscf)                                                                                                                                                                                                                                                     | μo (cp)                                            | μg (cp)                                       | Eo (bbl/STB)                                   | Et = Eo + Efw (bbl/STB)                                                       | Φo (—)                                                                                                                                                                                                                       | Φg (STB/Mscf) |                      |
| 63 | =OF_Pb                                                                                                                                                                                                                 | =PO.PVT.Z.ByDAK(A63/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A63,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C63,OF_T) | =PO.PVT.Bg.ByDefinition(A63,OF_T+OF_R0,B63)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C63,OF_Uod)         | =PO.PVT.Ug.ByLGE(B63,OF_GasSG,A63,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D63,OF_Boi,C63,OF_Rsi,E63/1000) | =PO.MBE.Exp.Et(H63,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A63),0) | =(D63-C63*E63/1000)/I63                                                                                                                                                                                                      | =E63/I63      |                      |
| 64 | =OF_Pb-(OF_Pb-OF_Pab)*1/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A64/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A64,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C64,OF_T) | =PO.PVT.Bg.ByDefinition(A64,OF_T+OF_R0,B64)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C64,OF_Uod)         | =PO.PVT.Ug.ByLGE(B64,OF_GasSG,A64,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D64,OF_Boi,C64,OF_Rsi,E64/1000) | =PO.MBE.Exp.Et(H64,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A64),0) | =(D64-C64*E64/1000)/I64                                                                                                                                                                                                      | =E64/I64      |                      |
| 65 | =OF_Pb-(OF_Pb-OF_Pab)*2/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A65/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A65,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C65,OF_T) | =PO.PVT.Bg.ByDefinition(A65,OF_T+OF_R0,B65)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C65,OF_Uod)         | =PO.PVT.Ug.ByLGE(B65,OF_GasSG,A65,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D65,OF_Boi,C65,OF_Rsi,E65/1000) | =PO.MBE.Exp.Et(H65,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A65),0) | =(D65-C65*E65/1000)/I65                                                                                                                                                                                                      | =E65/I65      |                      |
| 66 | =OF_Pb-(OF_Pb-OF_Pab)*3/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A66/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A66,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C66,OF_T) | =PO.PVT.Bg.ByDefinition(A66,OF_T+OF_R0,B66)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C66,OF_Uod)         | =PO.PVT.Ug.ByLGE(B66,OF_GasSG,A66,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D66,OF_Boi,C66,OF_Rsi,E66/1000) | =PO.MBE.Exp.Et(H66,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A66),0) | =(D66-C66*E66/1000)/I66                                                                                                                                                                                                      | =E66/I66      |                      |
| 67 | =OF_Pb-(OF_Pb-OF_Pab)*4/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A67/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A67,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C67,OF_T) | =PO.PVT.Bg.ByDefinition(A67,OF_T+OF_R0,B67)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C67,OF_Uod)         | =PO.PVT.Ug.ByLGE(B67,OF_GasSG,A67,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D67,OF_Boi,C67,OF_Rsi,E67/1000) | =PO.MBE.Exp.Et(H67,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A67),0) | =(D67-C67*E67/1000)/I67                                                                                                                                                                                                      | =E67/I67      |                      |
| 68 | =OF_Pb-(OF_Pb-OF_Pab)*5/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A68/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A68,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C68,OF_T) | =PO.PVT.Bg.ByDefinition(A68,OF_T+OF_R0,B68)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C68,OF_Uod)         | =PO.PVT.Ug.ByLGE(B68,OF_GasSG,A68,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D68,OF_Boi,C68,OF_Rsi,E68/1000) | =PO.MBE.Exp.Et(H68,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A68),0) | =(D68-C68*E68/1000)/I68                                                                                                                                                                                                      | =E68/I68      |                      |
| 69 | =OF_Pb-(OF_Pb-OF_Pab)*6/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A69/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A69,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C69,OF_T) | =PO.PVT.Bg.ByDefinition(A69,OF_T+OF_R0,B69)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C69,OF_Uod)         | =PO.PVT.Ug.ByLGE(B69,OF_GasSG,A69,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D69,OF_Boi,C69,OF_Rsi,E69/1000) | =PO.MBE.Exp.Et(H69,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A69),0) | =(D69-C69*E69/1000)/I69                                                                                                                                                                                                      | =E69/I69      |                      |
| 70 | =OF_Pb-(OF_Pb-OF_Pab)*7/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A70/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A70,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C70,OF_T) | =PO.PVT.Bg.ByDefinition(A70,OF_T+OF_R0,B70)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C70,OF_Uod)         | =PO.PVT.Ug.ByLGE(B70,OF_GasSG,A70,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D70,OF_Boi,C70,OF_Rsi,E70/1000) | =PO.MBE.Exp.Et(H70,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A70),0) | =(D70-C70*E70/1000)/I70                                                                                                                                                                                                      | =E70/I70      |                      |
| 71 | =OF_Pb-(OF_Pb-OF_Pab)*8/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A71/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A71,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C71,OF_T) | =PO.PVT.Bg.ByDefinition(A71,OF_T+OF_R0,B71)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C71,OF_Uod)         | =PO.PVT.Ug.ByLGE(B71,OF_GasSG,A71,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D71,OF_Boi,C71,OF_Rsi,E71/1000) | =PO.MBE.Exp.Et(H71,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A71),0) | =(D71-C71*E71/1000)/I71                                                                                                                                                                                                      | =E71/I71      |                      |
| 72 | =OF_Pb-(OF_Pb-OF_Pab)*9/OF_Steps                                                                                                                                                                                       | =PO.PVT.Z.ByDAK(A72/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A72,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C72,OF_T) | =PO.PVT.Bg.ByDefinition(A72,OF_T+OF_R0,B72)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C72,OF_Uod)         | =PO.PVT.Ug.ByLGE(B72,OF_GasSG,A72,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D72,OF_Boi,C72,OF_Rsi,E72/1000) | =PO.MBE.Exp.Et(H72,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A72),0) | =(D72-C72*E72/1000)/I72                                                                                                                                                                                                      | =E72/I72      |                      |
| 73 | =OF_Pb-(OF_Pb-OF_Pab)*10/OF_Steps                                                                                                                                                                                      | =PO.PVT.Z.ByDAK(A73/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A73,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C73,OF_T) | =PO.PVT.Bg.ByDefinition(A73,OF_T+OF_R0,B73)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C73,OF_Uod)         | =PO.PVT.Ug.ByLGE(B73,OF_GasSG,A73,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D73,OF_Boi,C73,OF_Rsi,E73/1000) | =PO.MBE.Exp.Et(H73,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A73),0) | =(D73-C73*E73/1000)/I73                                                                                                                                                                                                      | =E73/I73      |                      |
| 74 | =OF_Pb-(OF_Pb-OF_Pab)*11/OF_Steps                                                                                                                                                                                      | =PO.PVT.Z.ByDAK(A74/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A74,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C74,OF_T) | =PO.PVT.Bg.ByDefinition(A74,OF_T+OF_R0,B74)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C74,OF_Uod)         | =PO.PVT.Ug.ByLGE(B74,OF_GasSG,A74,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D74,OF_Boi,C74,OF_Rsi,E74/1000) | =PO.MBE.Exp.Et(H74,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A74),0) | =(D74-C74*E74/1000)/I74                                                                                                                                                                                                      | =E74/I74      |                      |
| 75 | =OF_Pb-(OF_Pb-OF_Pab)*12/OF_Steps                                                                                                                                                                                      | =PO.PVT.Z.ByDAK(A75/OF_Ppc,(OF_T+OF_R0)/OF_Tpc)                                      | =OF_RsFactor*PO.PVT.Rs.ByStanding(OF_GasSG,OF_API,A75,OF_T)                                                                                                                                                                                                                                                     | =PO.PVT.Bo.Sat.ByStanding(OF_GasSG,OF_API,C75,OF_T) | =PO.PVT.Bg.ByDefinition(A75,OF_T+OF_R0,B75)/OF_CfPerBbl*1000                                                                                                                                                                                                      | =PO.PVT.Uo.Sat.ByBeggsRobinson(C75,OF_Uod)         | =PO.PVT.Ug.ByLGE(B75,OF_GasSG,A75,OF_T+OF_R0) | =PO.MBE.Exp.Eo(D75,OF_Boi,C75,OF_Rsi,E75/1000) | =PO.MBE.Exp.Et(H75,0,PO.MBE.Exp.Efw(OF_Boi,OF_cw,OF_cf,OF_Swc,0,OF_Pi-A75),0) | =(D75-C75*E75/1000)/I75                                                                                                                                                                                                      | =E75/I75      |                      |
| 77 | Tracy's Forecast, Pressure Step by Step                                                                                                                                                                                |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 78 | Each row is one pressure step: three passes on ΔNp and the GOR, then the step's cumulative oil and gas, oil saturation, producing GOR and recovery.                                                                    |                                                                                      |                                                                                                                                                                                                                                                                                                                 |                                                     |                                                                                                                                                                                                                                                                   |                                                    |                                               |                                                |                                                                               |                                                                                                                                                                                                                              |               |                      |
| 79 | Pressure (psi)                                                                                                                                                                                                         | ΔNp, pass 1 (MMSTB)                                                                  | GOR, pass 1 (scf/STB)                                                                                                                                                                                                                                                                                           | ΔNp, pass 2 (MMSTB)                                 | GOR, pass 2 (scf/STB)                                                                                                                                                                                                                                             | ΔNp, pass 3 (MMSTB)                                | Np (MMSTB)                                    | Gp (Bscf)                                      | So (%)                                                                        | Producing GOR (scf/STB)                                                                                                                                                                                                      | Recovery (%)  | Last-pass change (%) |
| 80 | =A63                                                                                                                                                                                                                   | —                                                                                    | —                                                                                                                                                                                                                                                                                                               | —                                                   | —                                                                                                                                                                                                                                                                 | —                                                  | =OF_Npb                                       | =G80*OF_Rsi/1000                               | =(1-OF_Swc)*(1-(G80)/OF_N)*D63/OF_Boi                                         | =LET(oilsat,I80,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C63+krgas/kroil*F63*D63/(G63*E63/1000)) | =G80/OF_N     | —                    |
| 81 | =A64                                                                                                                                                                                                                   | =(OF_N-G80*J64-H80*K64)/(J64+(J80+J80)/2*K64/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G80+B81)/OF_N)*D64/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C64+krgas/kroil*F64*D64/(G64*E64/1000))                                               | =(OF_N-G80*J64-H80*K64)/(J64+(J80+C81)/2*K64/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G80+D81)/OF_N)*D64/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C64+krgas/kroil*F64*D64/(G64*E64/1000)) | =(OF_N-G80*J64-H80*K64)/(J64+(J80+E81)/2*K64/1000) | =G80+F81                                      | =H80+F81*(J80+E81)/2/1000                      | =(1-OF_Swc)*(1-(G81)/OF_N)*D64/OF_Boi                                         | =LET(oilsat,I81,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C64+krgas/kroil*F64*D64/(G64*E64/1000)) | =G81/OF_N     | =ABS(J81-E81)/J81    |
| 82 | =A65                                                                                                                                                                                                                   | =(OF_N-G81*J65-H81*K65)/(J65+(J81+J81)/2*K65/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G81+B82)/OF_N)*D65/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C65+krgas/kroil*F65*D65/(G65*E65/1000))                                               | =(OF_N-G81*J65-H81*K65)/(J65+(J81+C82)/2*K65/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G81+D82)/OF_N)*D65/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C65+krgas/kroil*F65*D65/(G65*E65/1000)) | =(OF_N-G81*J65-H81*K65)/(J65+(J81+E82)/2*K65/1000) | =G81+F82                                      | =H81+F82*(J81+E82)/2/1000                      | =(1-OF_Swc)*(1-(G82)/OF_N)*D65/OF_Boi                                         | =LET(oilsat,I82,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C65+krgas/kroil*F65*D65/(G65*E65/1000)) | =G82/OF_N     | =ABS(J82-E82)/J82    |
| 83 | =A66                                                                                                                                                                                                                   | =(OF_N-G82*J66-H82*K66)/(J66+(J82+J82)/2*K66/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G82+B83)/OF_N)*D66/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C66+krgas/kroil*F66*D66/(G66*E66/1000))                                               | =(OF_N-G82*J66-H82*K66)/(J66+(J82+C83)/2*K66/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G82+D83)/OF_N)*D66/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C66+krgas/kroil*F66*D66/(G66*E66/1000)) | =(OF_N-G82*J66-H82*K66)/(J66+(J82+E83)/2*K66/1000) | =G82+F83                                      | =H82+F83*(J82+E83)/2/1000                      | =(1-OF_Swc)*(1-(G83)/OF_N)*D66/OF_Boi                                         | =LET(oilsat,I83,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C66+krgas/kroil*F66*D66/(G66*E66/1000)) | =G83/OF_N     | =ABS(J83-E83)/J83    |
| 84 | =A67                                                                                                                                                                                                                   | =(OF_N-G83*J67-H83*K67)/(J67+(J83+J83)/2*K67/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G83+B84)/OF_N)*D67/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C67+krgas/kroil*F67*D67/(G67*E67/1000))                                               | =(OF_N-G83*J67-H83*K67)/(J67+(J83+C84)/2*K67/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G83+D84)/OF_N)*D67/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C67+krgas/kroil*F67*D67/(G67*E67/1000)) | =(OF_N-G83*J67-H83*K67)/(J67+(J83+E84)/2*K67/1000) | =G83+F84                                      | =H83+F84*(J83+E84)/2/1000                      | =(1-OF_Swc)*(1-(G84)/OF_N)*D67/OF_Boi                                         | =LET(oilsat,I84,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C67+krgas/kroil*F67*D67/(G67*E67/1000)) | =G84/OF_N     | =ABS(J84-E84)/J84    |
| 85 | =A68                                                                                                                                                                                                                   | =(OF_N-G84*J68-H84*K68)/(J68+(J84+J84)/2*K68/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G84+B85)/OF_N)*D68/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C68+krgas/kroil*F68*D68/(G68*E68/1000))                                               | =(OF_N-G84*J68-H84*K68)/(J68+(J84+C85)/2*K68/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G84+D85)/OF_N)*D68/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C68+krgas/kroil*F68*D68/(G68*E68/1000)) | =(OF_N-G84*J68-H84*K68)/(J68+(J84+E85)/2*K68/1000) | =G84+F85                                      | =H84+F85*(J84+E85)/2/1000                      | =(1-OF_Swc)*(1-(G85)/OF_N)*D68/OF_Boi                                         | =LET(oilsat,I85,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C68+krgas/kroil*F68*D68/(G68*E68/1000)) | =G85/OF_N     | =ABS(J85-E85)/J85    |
| 86 | =A69                                                                                                                                                                                                                   | =(OF_N-G85*J69-H85*K69)/(J69+(J85+J85)/2*K69/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G85+B86)/OF_N)*D69/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C69+krgas/kroil*F69*D69/(G69*E69/1000))                                               | =(OF_N-G85*J69-H85*K69)/(J69+(J85+C86)/2*K69/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G85+D86)/OF_N)*D69/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C69+krgas/kroil*F69*D69/(G69*E69/1000)) | =(OF_N-G85*J69-H85*K69)/(J69+(J85+E86)/2*K69/1000) | =G85+F86                                      | =H85+F86*(J85+E86)/2/1000                      | =(1-OF_Swc)*(1-(G86)/OF_N)*D69/OF_Boi                                         | =LET(oilsat,I86,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C69+krgas/kroil*F69*D69/(G69*E69/1000)) | =G86/OF_N     | =ABS(J86-E86)/J86    |
| 87 | =A70                                                                                                                                                                                                                   | =(OF_N-G86*J70-H86*K70)/(J70+(J86+J86)/2*K70/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G86+B87)/OF_N)*D70/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C70+krgas/kroil*F70*D70/(G70*E70/1000))                                               | =(OF_N-G86*J70-H86*K70)/(J70+(J86+C87)/2*K70/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G86+D87)/OF_N)*D70/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C70+krgas/kroil*F70*D70/(G70*E70/1000)) | =(OF_N-G86*J70-H86*K70)/(J70+(J86+E87)/2*K70/1000) | =G86+F87                                      | =H86+F87*(J86+E87)/2/1000                      | =(1-OF_Swc)*(1-(G87)/OF_N)*D70/OF_Boi                                         | =LET(oilsat,I87,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C70+krgas/kroil*F70*D70/(G70*E70/1000)) | =G87/OF_N     | =ABS(J87-E87)/J87    |
| 88 | =A71                                                                                                                                                                                                                   | =(OF_N-G87*J71-H87*K71)/(J71+(J87+J87)/2*K71/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G87+B88)/OF_N)*D71/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C71+krgas/kroil*F71*D71/(G71*E71/1000))                                               | =(OF_N-G87*J71-H87*K71)/(J71+(J87+C88)/2*K71/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G87+D88)/OF_N)*D71/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C71+krgas/kroil*F71*D71/(G71*E71/1000)) | =(OF_N-G87*J71-H87*K71)/(J71+(J87+E88)/2*K71/1000) | =G87+F88                                      | =H87+F88*(J87+E88)/2/1000                      | =(1-OF_Swc)*(1-(G88)/OF_N)*D71/OF_Boi                                         | =LET(oilsat,I88,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C71+krgas/kroil*F71*D71/(G71*E71/1000)) | =G88/OF_N     | =ABS(J88-E88)/J88    |
| 89 | =A72                                                                                                                                                                                                                   | =(OF_N-G88*J72-H88*K72)/(J72+(J88+J88)/2*K72/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G88+B89)/OF_N)*D72/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C72+krgas/kroil*F72*D72/(G72*E72/1000))                                               | =(OF_N-G88*J72-H88*K72)/(J72+(J88+C89)/2*K72/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G88+D89)/OF_N)*D72/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C72+krgas/kroil*F72*D72/(G72*E72/1000)) | =(OF_N-G88*J72-H88*K72)/(J72+(J88+E89)/2*K72/1000) | =G88+F89                                      | =H88+F89*(J88+E89)/2/1000                      | =(1-OF_Swc)*(1-(G89)/OF_N)*D72/OF_Boi                                         | =LET(oilsat,I89,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C72+krgas/kroil*F72*D72/(G72*E72/1000)) | =G89/OF_N     | =ABS(J89-E89)/J89    |
| 90 | =A73                                                                                                                                                                                                                   | =(OF_N-G89*J73-H89*K73)/(J73+(J89+J89)/2*K73/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G89+B90)/OF_N)*D73/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C73+krgas/kroil*F73*D73/(G73*E73/1000))                                               | =(OF_N-G89*J73-H89*K73)/(J73+(J89+C90)/2*K73/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G89+D90)/OF_N)*D73/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C73+krgas/kroil*F73*D73/(G73*E73/1000)) | =(OF_N-G89*J73-H89*K73)/(J73+(J89+E90)/2*K73/1000) | =G89+F90                                      | =H89+F90*(J89+E90)/2/1000                      | =(1-OF_Swc)*(1-(G90)/OF_N)*D73/OF_Boi                                         | =LET(oilsat,I90,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C73+krgas/kroil*F73*D73/(G73*E73/1000)) | =G90/OF_N     | =ABS(J90-E90)/J90    |
| 91 | =A74                                                                                                                                                                                                                   | =(OF_N-G90*J74-H90*K74)/(J74+(J90+J90)/2*K74/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G90+B91)/OF_N)*D74/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C74+krgas/kroil*F74*D74/(G74*E74/1000))                                               | =(OF_N-G90*J74-H90*K74)/(J74+(J90+C91)/2*K74/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G90+D91)/OF_N)*D74/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C74+krgas/kroil*F74*D74/(G74*E74/1000)) | =(OF_N-G90*J74-H90*K74)/(J74+(J90+E91)/2*K74/1000) | =G90+F91                                      | =H90+F91*(J90+E91)/2/1000                      | =(1-OF_Swc)*(1-(G91)/OF_N)*D74/OF_Boi                                         | =LET(oilsat,I91,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C74+krgas/kroil*F74*D74/(G74*E74/1000)) | =G91/OF_N     | =ABS(J91-E91)/J91    |
| 92 | =A75                                                                                                                                                                                                                   | =(OF_N-G91*J75-H91*K75)/(J75+(J91+J91)/2*K75/1000)                                   | =LET(oilsat,(1-OF_Swc)*(1-(G91+B92)/OF_N)*D75/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C75+krgas/kroil*F75*D75/(G75*E75/1000))                                               | =(OF_N-G91*J75-H91*K75)/(J75+(J91+C92)/2*K75/1000)  | =LET(oilsat,(1-OF_Swc)*(1-(G91+D92)/OF_N)*D75/OF_Boi,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C75+krgas/kroil*F75*D75/(G75*E75/1000)) | =(OF_N-G91*J75-H91*K75)/(J75+(J91+E92)/2*K75/1000) | =G91+F92                                      | =H91+F92*(J91+E92)/2/1000                      | =(1-OF_Swc)*(1-(G92)/OF_N)*D75/OF_Boi                                         | =LET(oilsat,I92,gassat,1-OF_Swc-oilsat,krgas,IF(gassat>OF_Sgc,OF_KrgMax*((gassat-OF_Sgc)/(1-OF_Swc-OF_Sorg-OF_Sgc))^OF_NgExp,0),kroil,((oilsat-OF_Sorg)/(1-OF_Swc-OF_Sorg))^OF_NoExp,C75+krgas/kroil*F75*D75/(G75*E75/1000)) | =G92/OF_N     | =ABS(J92-E92)/J92    |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| OF_N | $B$5 | Original oil in place, N, MMSTB |
| OF_Pi | $B$6 | Initial reservoir pressure, psi |
| OF_Pb | $B$7 | Bubble-point pressure, psi |
| OF_Boi | $B$8 | Initial oil formation volume factor, bbl/STB |
| OF_Rsi | $B$9 | Initial solution gas-oil ratio, scf/STB |
| OF_Swc | $B$10 | Connate water saturation, % |
| OF_cw | $B$11 | Water compressibility, 1/psi |
| OF_cf | $B$12 | Formation (pore-volume) compressibility, 1/psi |
| OF_API | $B$14 | Stock-tank oil gravity, °API |
| OF_GasSG | $B$15 | Solution gas specific gravity, air = 1 |
| OF_T | $B$16 | Reservoir temperature, °F |
| OF_Sgc | $B$18 | Critical gas saturation, % |
| OF_Sorg | $B$19 | Residual oil saturation to gas, % |
| OF_KrgMax | $B$20 | Gas relative permeability at residual oil |
| OF_NoExp | $B$21 | Corey exponent for oil |
| OF_NgExp | $B$22 | Corey exponent for gas |
| OF_Pab | $B$24 | Abandonment reservoir pressure, psi |
| OF_GorMax | $B$25 | Producing GOR the wells and plant can handle, scf/STB |
| OF_MoveTol | $B$26 | GOR change in the last pass accepted as converged, % |
| OF_Inputs | $B$5:$B$26 | The OOIP and initial conditions, the oil and gas for the correlations, the Corey curves, the abandonment pressure and the check limits |
| OF_R0 | $B$29 | Rankine at 0 °F, °R |
| OF_CfPerBbl | $B$30 | Cubic feet per barrel, ft³/bbl |
| OF_Steps | $B$31 | Pressure steps, bubble point to abandonment |
| OF_RsStd | $B$34 | Standing's Rs at Pb, before matching, scf/STB |
| OF_RsFactor | $B$35 | Rs match factor, Rsi over Standing's Rs at Pb |
| OF_Bob | $B$36 | Oil formation volume factor at Pb (Standing), bbl/STB |
| OF_Uod | $B$37 | Dead-oil viscosity (Beal), cp |
| OF_Ppc | $B$38 | Pseudo-critical pressure of the gas (Sutton), psi |
| OF_Tpc | $B$39 | Pseudo-critical temperature of the gas (Sutton), °R |
| OF_Npb | $B$40 | Oil produced from Pi down to Pb, Npb, MMSTB |
| OF_Initial_Results | $B$34:$B$40 | Standing's Rs at Pb and the match factor, Bob, the dead-oil viscosity, the gas's pseudo-criticals and the oil produced above Pb |
| OF_RFb | $B$42 | Recovery factor at the bubble point, % |
| OF_Np | $B$43 | Cumulative oil at abandonment, Np, MMSTB |
| OF_RF | $B$44 | Recovery factor at abandonment, % |
| OF_Gp | $B$45 | Cumulative gas at abandonment, Gp, Bscf |
| OF_Rp | $B$46 | Cumulative producing GOR at abandonment, Rp, scf/STB |
| OF_GorAb | $B$47 | Producing GOR at abandonment, scf/STB |
| OF_GorPeak | $B$48 | Highest producing GOR, scf/STB |
| OF_SoAb | $B$49 | Oil saturation at abandonment, % |
| OF_pGor | $B$50 | Highest pressure step whose GOR passes the limit, psi |
| OF_RFGor | $B$51 | Recovery factor before the GOR passes the limit, % |
| OF_Move | $B$52 | Largest GOR change in the third pass, % |
| OF_RangeCheck | $B$53 | Pressure-range check verdict |
| OF_RangeCheckNote | $C$53 | Pressure-range check comment |
| OF_GasCheck | $B$54 | Gas-handling check verdict |
| OF_GasCheckNote | $C$54 | Gas-handling check comment |
| OF_PassCheck | $B$55 | Convergence check verdict |
| OF_PassCheckNote | $C$55 | Convergence check comment |
| OF_Results | $B$42:$B$55 | Recovery at Pb and at abandonment, Np, Gp, Rp, the GOR at abandonment and its peak, So, the GOR limit and the three checks |
| OF_Pvt | $A$63:$K$75 | Each step's pressure, Z, Rs, Bo, Bg, oil and gas viscosity, Eo, Et and Tracy's Φo and Φg |
| OF_Forecast | $A$80:$L$92 | Each step's three passes on ΔNp and the GOR, its Np, Gp, So, producing GOR, recovery and the last pass's GOR change |

---

## Related Blueprints
- [Gas Reservoir Production Forecast](/blueprint/po.mbe.gas.forecast.md)
- [Oil Material Balance (Havlena-Odeh)](/blueprint/po.mbe.oil.havlena.odeh.md)
- [PVT Fluid Report Through Depletion](/blueprint/po.pvt.fluid.report.md)
- [Gas Water-Drive Diagnostic (Cole Plot)](/blueprint/po.mbe.gas.waterdrive.diagnostic.md)
- [Aquifer Model Matching](/blueprint/po.mbe.aquifer.matching.md)
- [Volumetric Gas in Place](/blueprint/po.res.volumetrics.giip.md)

