---
cid: po.bp.dca.rta.flowing.material.balance
hub: dca
tags: [rate-transient, normalized-rate, material-balance-time, flowing-material-balance, contacted-volume, derivative, flow-regime, linear-flow, boundary-dominated, decline]
facets: { discipline: production, property: volume, method-type: analytical }
title: Rate-Transient Analysis and Flowing Material Balance
summary: "How much oil a well has contacted, from its rates normalized by drawdown against material-balance time, and whether it has reached boundary-dominated flow."
slug: po.dca.rta.flowing.material.balance
type: worksheet
---

# Rate-Transient Analysis and Flowing Material Balance

## Description

How much oil has the well contacted, and is there enough data to say? You enter the initial reservoir pressure, the total compressibility and each month's oil rate and flowing bottomhole pressure. The sheet sets each rate, normalized by its drawdown, against material-balance time, so a well whose flowing pressure changed reads as if it had produced at one rate. You read off the flow regime month by month, the first boundary-dominated month and the oil in place the well has contacted.

**Parameters:**
- **Reservoir**: the initial reservoir pressure `FMB_Pi` (psi) and the total compressibility `FMB_Ct` (1/psi)
- **Reading**: the derivative slope read as boundary-dominated `FMB_SlopeBdf`, and a typed first boundary-dominated month `FMB_MUser` (0 takes the sheet's pick)
- **Line**: the least R² `FMB_R2Min` and the fewest months `FMB_MinPts` the line should rest on
- **Months**: the oil rate (STB/d) and flowing bottomhole pressure (psi) of each of 24 months

**How to use it:** Compute monthly rates as each month's volume over its days on production, type the bottomhole flowing pressure of each month (gauge, or computed from the wellhead), and take out shut-in and partial months first (the Production Data Cleaning sheet). The rate-normalized pressure Δp/q and its derivative go on log-log axes: the derivative rises at a slope of ½ in linear flow and of 1 once the well feels its boundaries. The sheet reads that slope month by month and picks the first boundary-dominated month; read the derivative over several months, not one, and type the pick by hand when the derivative is noisy. Check that every month draws down enough, that the months after the pick are boundary-dominated, and that the flowing material balance line is straight over enough months. Then read the contacted oil in place with b_pss, N·ct and R², and the √tc line of the transient months before the pick. Three charts draw the diagnostic, the normalized rate against tc with the line's q/Δp (both per 1,000 psi of drawdown, so the log axis starts above 1), and the flowing material balance itself.

**Method:** Time is the month times 365.25/12 days. Np is cumulated month by month as each month's rate times its days, and material-balance time is tc = Np/q. The normalized rate is q/Δp = q/(pi − pwf), and Δp/q is its inverse. The derivative tc·d(Δp/q)/dtc at a month is Bourdet's three-point form in x = ln tc with its two neighbours, ((Δy₁/Δx₁)·Δx₂ + (Δy₂/Δx₂)·Δx₁)/(Δx₁ + Δx₂), so the first and last months have none. Its log-log slope at a month is ln(d₊/d₋)/ln(tc₊/tc₋) over the two neighbours, read from month 3 to month 22. In linear flow Δp/q = b + m·√tc and the derivative is (m/2)·√tc, a slope of ½; in boundary-dominated flow Δp/q = b_pss + tc/(N·ct) and the derivative is tc/(N·ct), a slope of 1. The pick is the first month whose slope reaches the boundary-dominated slope you set. The flowing material balance takes the months from the one used and fits Δp/q against tc by least squares: N = 1/(slope·ct), with b_pss the intercept and N·ct the line's reach on the Agarwal-Gardner Np/Δp axis. The months before it give the √tc line by Excel's SLOPE and INTERCEPT.

**Example:** The default is a tight-oil horizontal in the decline family's reservoir (5,000 psi, 1.5 × 10⁻⁵ 1/psi, the Decline and Flow-Regime Diagnostics sheet's), whose flowing pressure was drawn down from 3,000 to 1,000 psi over its first five months and then held. Its rates are synthetic. The well's constant-rate response is linear flow, Δp/q = 0.8 + 0.6197·√t, to t = 540 days, then boundary-dominated, Δp/q = 8 + t/75, with N = 5 MMSTB and N·ct = 75 STB/psi; the slope 0.6197 = 2·√540/75 joins the two in value and in slope. Each month's rate puts its point on that response in material-balance time at that month's pressure, to a tenth of a barrel. So the raw rate rises from 435.5 to 485.3 STB/d over months 2 to 5, while q/Δp falls every month.

The derivative's slope reads 0.48 to 0.50 over months 3 to 10, 0.54 and 0.69 at months 11 and 12, and 0.90 at month 13 (tc = 584 days), so the pick is month 13. The 12 months from there climb at a mean slope of 0.99: boundary-dominated. Over them the flowing material balance is a straight line (R² 1.0000) with b_pss = 7.999 psi/(STB/d) and N·ct = 75.00 STB/psi, so N = 75.00/1.5 × 10⁻⁵ = 5.00 MMSTB contacted. Over every month, linear flow included, it would be 4.38 MMSTB: transient months pull the volume down. The 12 transient months lie on Δp/q = 0.7999 + 0.6197·√tc, the response the rates were built on. The raw rate rises in 3 months and q/Δp in none, and every month draws down by at least 2,000 psi.

## Validity

The flowing material balance needs boundary-dominated flow, a slightly compressible undersaturated oil and a constant compressibility; material-balance time makes a varying rate exact for the boundary-dominated line, and approximate in transient flow. The volume grows while the drainage area still grows, so before the derivative turns to a slope of 1 it is a lower bound. A derivative is noisy on real monthly data: read its slope over several months, and type the pick when one month jumps. The derivative here takes each month's nearest neighbours, with no smoothing window; the Decline and Flow-Regime Diagnostics sheet has one. The volume N = 1/(slope·ct) takes Bo/Boi = 1, the oil's formation volume factor constant at its initial value, as it is above the bubble point to within the oil's compressibility. Below the bubble point the oil's expansion changes and a multiphase or variable-Bo form is needed. For gas the line is drawn in p/Z or in pseudo-pressure with pseudo-time. Blasingame's type curves, and the rate-integral and integral-derivative they match on, are not on this sheet; it stops at the straight lines.

Named alternatives: the Decline and Flow-Regime Diagnostics sheet for b(t) and β on a constant-pressure well; a tank material balance with measured average pressures; the flowing material balance and normalized rate functions on their own.

## References

- Agarwal, R.G., Gardner, D.C., Kleinsteiber, S.W. and Fussell, D.D. (1999). "Analyzing Well Production Data Using Combined-Type-Curve and Decline-Curve Analysis Concepts." *SPE Reservoir Evaluation & Engineering* 2(5), 478–486 (SPE-57916).
- Mattar, L. and Anderson, D. (2005). "Dynamic Material Balance (Oil or Gas-in-Place Without Shut-Ins)." CIPC 2005-113.
- Palacio, J.C. and Blasingame, T.A. (1993). "Decline-Curve Analysis Using Type Curves: Analysis of Gas Well Production Data." SPE-25909 (material-balance time).
- Bourdet, D., Ayoub, J.A. and Pirard, Y.M. (1989). "Use of Pressure Derivative in Well-Test Interpretation." *SPE Formation Evaluation* 4(2), 293–302.
- Wattenbarger, R.A., El-Banbi, A.H., Villegas, M.E. and Maggard, J.B. (1998). "Production Analysis of Linear Flow Into Fractured Tight Gas Wells." SPE-39931.

## Functions used

`PO.RTA.NormalizedRate`, `PO.RTA.FlowingMB`

## Spreadsheet: RtaFlowingMaterialBalance

|    | A                                                                                                                                                                                                          | B                                                                                                                                       | C                                                                                                                                                                                                                                                                                                                                                                               | D            | E                    | F                  | G                                      | H                  | I           | J                                                                             | K                        | L                            | M                  |
|----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------|----------------------|--------------------|----------------------------------------|--------------------|-------------|-------------------------------------------------------------------------------|--------------------------|------------------------------|--------------------|
| 1  | Rate-Transient Analysis and Flowing Material Balance                                                                                                                                                       |                                                                                                                                         | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 2  | Blue cells on yellow are inputs. Type the well's monthly rates and flowing pressures; the derivative reads where boundary-dominated flow starts, and the flowing material balance gives the oil contacted. |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 3  | Reservoir and Reading Settings                                                                                                                                                                             |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 4  | Initial reservoir pressure                                                                                                                                                                                 | 5000                                                                                                                                    | psi                                                                                                                                                                                                                                                                                                                                                                             |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 5  | Total compressibility                                                                                                                                                                                      | 0.000015                                                                                                                                | 1/psi                                                                                                                                                                                                                                                                                                                                                                           |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 6  | Derivative slope read as boundary-dominated flow                                                                                                                                                           | 0.9                                                                                                                                     | —                                                                                                                                                                                                                                                                                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 7  | First boundary-dominated month, typed (0 takes the pick)                                                                                                                                                   | 0                                                                                                                                       | month                                                                                                                                                                                                                                                                                                                                                                           |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 8  | Least R² the flowing material balance should reach                                                                                                                                                         | 0.98                                                                                                                                    | —                                                                                                                                                                                                                                                                                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 9  | Fewest months the line should rest on                                                                                                                                                                      | 6                                                                                                                                       | —                                                                                                                                                                                                                                                                                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 10 | Flow Regime, Read From the Derivative                                                                                                                                                                      |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 11 | First month the derivative's slope reaches the limit                                                                                                                                                       | =MINIFS(FMB_T,K43:K66,">="&FMB_SlopeBdf)                                                                                                | month                                                                                                                                                                                                                                                                                                                                                                           |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 12 | First boundary-dominated month used                                                                                                                                                                        | =IF(FMB_MUser>0,FMB_MUser,FMB_MPick)                                                                                                    | month                                                                                                                                                                                                                                                                                                                                                                           |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 13 | Material-balance time there, tc                                                                                                                                                                            | =INDEX(FMB_Tc,FMB_MBdf)                                                                                                                 | days                                                                                                                                                                                                                                                                                                                                                                            |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 14 | Months on the flowing material balance line                                                                                                                                                                | =COUNTIF(FMB_T,">="&FMB_MBdf)                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 15 | Derivative's mean log-log slope over those months                                                                                                                                                          | =AVERAGEIFS(K43:K66,FMB_T,">="&FMB_MBdf)                                                                                                | —                                                                                                                                                                                                                                                                                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 16 | Flowing Material Balance                                                                                                                                                                                   |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 17 | Contacted oil in place                                                                                                                                                                                     | =PO.RTA.FlowingMB(FILTER(FMB_Np,FMB_T>=FMB_MBdf),FILTER(FMB_Q,FMB_T>=FMB_MBdf),FMB_Pi,FILTER(FMB_Pwf,FMB_T>=FMB_MBdf),FMB_Ct)/1000/1000 | MMSTB                                                                                                                                                                                                                                                                                                                                                                           |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 18 | Contacted oil in place, every month, transient too                                                                                                                                                         | =PO.RTA.FlowingMB(FMB_Np,FMB_Q,FMB_Pi,FMB_Pwf,FMB_Ct)/1000/1000                                                                         | MMSTB                                                                                                                                                                                                                                                                                                                                                                           |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 19 | Intercept, b_pss                                                                                                                                                                                           | =INTERCEPT(FILTER(FMB_Rnp,FMB_T>=FMB_MBdf),FILTER(FMB_Tc,FMB_T>=FMB_MBdf))                                                              | psi/(STB/d)                                                                                                                                                                                                                                                                                                                                                                     |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 20 | N·ct, where q/Δp would reach zero on the Np/Δp axis                                                                                                                                                        | =FMB_OOIP*1000*1000*FMB_Ct                                                                                                              | STB/psi                                                                                                                                                                                                                                                                                                                                                                         |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 21 | Flowing material balance R²                                                                                                                                                                                | =RSQ(FILTER(FMB_Rnp,FMB_T>=FMB_MBdf),FILTER(FMB_Tc,FMB_T>=FMB_MBdf))                                                                    | —                                                                                                                                                                                                                                                                                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 22 | Transient Months Before It, Δp/q Against √tc                                                                                                                                                               |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 23 | Linear-flow slope                                                                                                                                                                                          | =SLOPE(FILTER(FMB_Rnp,FMB_T<FMB_MBdf),FILTER(FMB_RootTc,FMB_T<FMB_MBdf))                                                                | psi/(STB/d)/√day                                                                                                                                                                                                                                                                                                                                                                |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 24 | Linear-flow intercept                                                                                                                                                                                      | =INTERCEPT(FILTER(FMB_Rnp,FMB_T<FMB_MBdf),FILTER(FMB_RootTc,FMB_T<FMB_MBdf))                                                            | psi/(STB/d)                                                                                                                                                                                                                                                                                                                                                                     |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 25 | What the Normalization Changes                                                                                                                                                                             |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 26 | Months the raw oil rate rises                                                                                                                                                                              | =SUMPRODUCT((B44:B66>B43:B65)*1)                                                                                                        | —                                                                                                                                                                                                                                                                                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 27 | Months the normalized rate q/Δp rises                                                                                                                                                                      | =SUMPRODUCT((G44:G66>G43:G65)*1)                                                                                                        | —                                                                                                                                                                                                                                                                                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 28 | Drawdown check                                                                                                                                                                                             | =IF(MAX(FMB_Pwf)>=FMB_Pi,"FAIL","PASS")                                                                                                 | =IF(MAX(FMB_Pwf)>=FMB_Pi,"a flowing pressure of "&FIXED(MAX(FMB_Pwf),0)&" psi is not below the initial "&FIXED(FMB_Pi,0)&" psi, so q/Δp has no meaning","every month draws down from "&FIXED(FMB_Pi,0)&" psi, the least by "&FIXED(FMB_Pi-MAX(FMB_Pwf),0)&" psi")                                                                                                               |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 29 | Flow regime check                                                                                                                                                                                          | =IF(FMB_SlopeLate>=FMB_SlopeBdf,"PASS","WARN")                                                                                          | =IF(FMB_SlopeLate>=FMB_SlopeBdf,"the derivative climbs at a slope of "&FIXED(FMB_SlopeLate,2)&" from month "&FMB_MBdf&", boundary-dominated","the derivative climbs at only "&FIXED(FMB_SlopeLate,2)&" from month "&FMB_MBdf&": not yet boundary-dominated, so the volume is a lower bound")                                                                                    |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 30 | Flowing material balance check                                                                                                                                                                             | =IF(FMB_NBdf<FMB_MinPts,"FAIL",IF(FMB_FmbR2>=FMB_R2Min,"PASS","WARN"))                                                                  | =IF(FMB_NBdf<FMB_MinPts,"only "&FMB_NBdf&" months from month "&FMB_MBdf&", fewer than the "&FMB_MinPts&" the line should rest on",IF(FMB_FmbR2>=FMB_R2Min,""&FMB_NBdf&" months on a straight line (R² "&FIXED(FMB_FmbR2*100,2)&"%), "&FIXED(FMB_OOIP,2)&" MMSTB contacted","the line bends (R² "&FIXED(FMB_FmbR2*100,2)&"%): start it later or check the months for shut-ins")) |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 32 | Flowing Material Balance Line                                                                                                                                                                              |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 33 | Δp/q = b_pss + tc/(N·ct), drawn from tc = 0 to the last month's material-balance time.                                                                                                                     |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 34 | End                                                                                                                                                                                                        | MB time, tc (days)                                                                                                                      | Δp/q (psi/(STB/d))                                                                                                                                                                                                                                                                                                                                                              |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 35 | At tc = 0, the intercept b_pss                                                                                                                                                                             | =0                                                                                                                                      | =FMB_Bpss+B35/FMB_NCt                                                                                                                                                                                                                                                                                                                                                           |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 36 | At the last month                                                                                                                                                                                          | =MAX(FMB_Tc)                                                                                                                            | =FMB_Bpss+B36/FMB_NCt                                                                                                                                                                                                                                                                                                                                                           |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 39 | The Well's Months and Rate-Transient Variables                                                                                                                                                             |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 40 | The rates are synthetic: linear flow to tc = 540 days, then boundary-dominated with 5 MMSTB contacted. How to use it: monthly volumes over days on production with the measured flowing pressures.         |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 41 | Np sums each month's rate times its days; tc = Np/q. The derivative is tc·d(Δp/q)/dtc from each month's neighbours, and its slope is read on log-log axes.                                                 |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 42 | Time (month)                                                                                                                                                                                               | Oil rate (STB/d)                                                                                                                        | Flowing pressure (psi)                                                                                                                                                                                                                                                                                                                                                          | Time (days)  | Cumulative, Np (STB) | MB time, tc (days) | q/Δp (STB/d/psi)                       | Δp/q (psi/(STB/d)) | √tc (√days) | Derivative (psi/(STB/d))                                                      | Derivative slope         | Line, per 1,000 psi          | q/Δp per 1,000 psi |
| 43 | 1                                                                                                                                                                                                          | 474.1                                                                                                                                   | 3000                                                                                                                                                                                                                                                                                                                                                                            | =A43*FMB_DMo | =B43*D43             | =E43/B43           | =PO.RTA.NormalizedRate(B43,FMB_Pi,C43) | =1/G43             | =SQRT(F43)  | End month                                                                     | Not read                 | =1000/(FMB_Bpss+F43/FMB_NCt) | =G43*1000          |
| 44 | 2                                                                                                                                                                                                          | 435.5                                                                                                                                   | 2500                                                                                                                                                                                                                                                                                                                                                                            | =A44*FMB_DMo | =E43+B44*(D44-D43)   | =E44/B44           | =PO.RTA.NormalizedRate(B44,FMB_Pi,C44) | =1/G44             | =SQRT(F44)  | =LET(dl,LN(F44/F43),dr,LN(F45/F44),((H44-H43)/dl*dr+(H45-H44)/dr*dl)/(dl+dr)) | Not read                 | =1000/(FMB_Bpss+F44/FMB_NCt) | =G44*1000          |
| 45 | 3                                                                                                                                                                                                          | 442.8                                                                                                                                   | 2000                                                                                                                                                                                                                                                                                                                                                                            | =A45*FMB_DMo | =E44+B45*(D45-D44)   | =E45/B45           | =PO.RTA.NormalizedRate(B45,FMB_Pi,C45) | =1/G45             | =SQRT(F45)  | =LET(dl,LN(F45/F44),dr,LN(F46/F45),((H45-H44)/dl*dr+(H46-H45)/dr*dl)/(dl+dr)) | =LN(J46/J44)/LN(F46/F44) | =1000/(FMB_Bpss+F45/FMB_NCt) | =G45*1000          |
| 46 | 4                                                                                                                                                                                                          | 462.1                                                                                                                                   | 1500                                                                                                                                                                                                                                                                                                                                                                            | =A46*FMB_DMo | =E45+B46*(D46-D45)   | =E46/B46           | =PO.RTA.NormalizedRate(B46,FMB_Pi,C46) | =1/G46             | =SQRT(F46)  | =LET(dl,LN(F46/F45),dr,LN(F47/F46),((H46-H45)/dl*dr+(H47-H46)/dr*dl)/(dl+dr)) | =LN(J47/J45)/LN(F47/F45) | =1000/(FMB_Bpss+F46/FMB_NCt) | =G46*1000          |
| 47 | 5                                                                                                                                                                                                          | 485.3                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A47*FMB_DMo | =E46+B47*(D47-D46)   | =E47/B47           | =PO.RTA.NormalizedRate(B47,FMB_Pi,C47) | =1/G47             | =SQRT(F47)  | =LET(dl,LN(F47/F46),dr,LN(F48/F47),((H47-H46)/dl*dr+(H48-H47)/dr*dl)/(dl+dr)) | =LN(J48/J46)/LN(F48/F46) | =1000/(FMB_Bpss+F47/FMB_NCt) | =G47*1000          |
| 48 | 6                                                                                                                                                                                                          | 421.7                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A48*FMB_DMo | =E47+B48*(D48-D47)   | =E48/B48           | =PO.RTA.NormalizedRate(B48,FMB_Pi,C48) | =1/G48             | =SQRT(F48)  | =LET(dl,LN(F48/F47),dr,LN(F49/F48),((H48-H47)/dl*dr+(H49-H48)/dr*dl)/(dl+dr)) | =LN(J49/J47)/LN(F49/F47) | =1000/(FMB_Bpss+F48/FMB_NCt) | =G48*1000          |
| 49 | 7                                                                                                                                                                                                          | 377.5                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A49*FMB_DMo | =E48+B49*(D49-D48)   | =E49/B49           | =PO.RTA.NormalizedRate(B49,FMB_Pi,C49) | =1/G49             | =SQRT(F49)  | =LET(dl,LN(F49/F48),dr,LN(F50/F49),((H49-H48)/dl*dr+(H50-H49)/dr*dl)/(dl+dr)) | =LN(J50/J48)/LN(F50/F48) | =1000/(FMB_Bpss+F49/FMB_NCt) | =G49*1000          |
| 50 | 8                                                                                                                                                                                                          | 344.6                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A50*FMB_DMo | =E49+B50*(D50-D49)   | =E50/B50           | =PO.RTA.NormalizedRate(B50,FMB_Pi,C50) | =1/G50             | =SQRT(F50)  | =LET(dl,LN(F50/F49),dr,LN(F51/F50),((H50-H49)/dl*dr+(H51-H50)/dr*dl)/(dl+dr)) | =LN(J51/J49)/LN(F51/F49) | =1000/(FMB_Bpss+F50/FMB_NCt) | =G50*1000          |
| 51 | 9                                                                                                                                                                                                          | 318.9                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A51*FMB_DMo | =E50+B51*(D51-D50)   | =E51/B51           | =PO.RTA.NormalizedRate(B51,FMB_Pi,C51) | =1/G51             | =SQRT(F51)  | =LET(dl,LN(F51/F50),dr,LN(F52/F51),((H51-H50)/dl*dr+(H52-H51)/dr*dl)/(dl+dr)) | =LN(J52/J50)/LN(F52/F50) | =1000/(FMB_Bpss+F51/FMB_NCt) | =G51*1000          |
| 52 | 10                                                                                                                                                                                                         | 298.1                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A52*FMB_DMo | =E51+B52*(D52-D51)   | =E52/B52           | =PO.RTA.NormalizedRate(B52,FMB_Pi,C52) | =1/G52             | =SQRT(F52)  | =LET(dl,LN(F52/F51),dr,LN(F53/F52),((H52-H51)/dl*dr+(H53-H52)/dr*dl)/(dl+dr)) | =LN(J53/J51)/LN(F53/F51) | =1000/(FMB_Bpss+F52/FMB_NCt) | =G52*1000          |
| 53 | 11                                                                                                                                                                                                         | 280.9                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A53*FMB_DMo | =E52+B53*(D53-D52)   | =E53/B53           | =PO.RTA.NormalizedRate(B53,FMB_Pi,C53) | =1/G53             | =SQRT(F53)  | =LET(dl,LN(F53/F52),dr,LN(F54/F53),((H53-H52)/dl*dr+(H54-H53)/dr*dl)/(dl+dr)) | =LN(J54/J52)/LN(F54/F52) | =1000/(FMB_Bpss+F53/FMB_NCt) | =G53*1000          |
| 54 | 12                                                                                                                                                                                                         | 266.3                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A54*FMB_DMo | =E53+B54*(D54-D53)   | =E54/B54           | =PO.RTA.NormalizedRate(B54,FMB_Pi,C54) | =1/G54             | =SQRT(F54)  | =LET(dl,LN(F54/F53),dr,LN(F55/F54),((H54-H53)/dl*dr+(H55-H54)/dr*dl)/(dl+dr)) | =LN(J55/J53)/LN(F55/F53) | =1000/(FMB_Bpss+F54/FMB_NCt) | =G54*1000          |
| 55 | 13                                                                                                                                                                                                         | 253.4                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A55*FMB_DMo | =E54+B55*(D55-D54)   | =E55/B55           | =PO.RTA.NormalizedRate(B55,FMB_Pi,C55) | =1/G55             | =SQRT(F55)  | =LET(dl,LN(F55/F54),dr,LN(F56/F55),((H55-H54)/dl*dr+(H56-H55)/dr*dl)/(dl+dr)) | =LN(J56/J54)/LN(F56/F54) | =1000/(FMB_Bpss+F55/FMB_NCt) | =G55*1000          |
| 56 | 14                                                                                                                                                                                                         | 241.2                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A56*FMB_DMo | =E55+B56*(D56-D55)   | =E56/B56           | =PO.RTA.NormalizedRate(B56,FMB_Pi,C56) | =1/G56             | =SQRT(F56)  | =LET(dl,LN(F56/F55),dr,LN(F57/F56),((H56-H55)/dl*dr+(H57-H56)/dr*dl)/(dl+dr)) | =LN(J57/J55)/LN(F57/F55) | =1000/(FMB_Bpss+F56/FMB_NCt) | =G56*1000          |
| 57 | 15                                                                                                                                                                                                         | 229.5                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A57*FMB_DMo | =E56+B57*(D57-D56)   | =E57/B57           | =PO.RTA.NormalizedRate(B57,FMB_Pi,C57) | =1/G57             | =SQRT(F57)  | =LET(dl,LN(F57/F56),dr,LN(F58/F57),((H57-H56)/dl*dr+(H58-H57)/dr*dl)/(dl+dr)) | =LN(J58/J56)/LN(F58/F56) | =1000/(FMB_Bpss+F57/FMB_NCt) | =G57*1000          |
| 58 | 16                                                                                                                                                                                                         | 218.4                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A58*FMB_DMo | =E57+B58*(D58-D57)   | =E58/B58           | =PO.RTA.NormalizedRate(B58,FMB_Pi,C58) | =1/G58             | =SQRT(F58)  | =LET(dl,LN(F58/F57),dr,LN(F59/F58),((H58-H57)/dl*dr+(H59-H58)/dr*dl)/(dl+dr)) | =LN(J59/J57)/LN(F59/F57) | =1000/(FMB_Bpss+F58/FMB_NCt) | =G58*1000          |
| 59 | 17                                                                                                                                                                                                         | 207.9                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A59*FMB_DMo | =E58+B59*(D59-D58)   | =E59/B59           | =PO.RTA.NormalizedRate(B59,FMB_Pi,C59) | =1/G59             | =SQRT(F59)  | =LET(dl,LN(F59/F58),dr,LN(F60/F59),((H59-H58)/dl*dr+(H60-H59)/dr*dl)/(dl+dr)) | =LN(J60/J58)/LN(F60/F58) | =1000/(FMB_Bpss+F59/FMB_NCt) | =G59*1000          |
| 60 | 18                                                                                                                                                                                                         | 197.9                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A60*FMB_DMo | =E59+B60*(D60-D59)   | =E60/B60           | =PO.RTA.NormalizedRate(B60,FMB_Pi,C60) | =1/G60             | =SQRT(F60)  | =LET(dl,LN(F60/F59),dr,LN(F61/F60),((H60-H59)/dl*dr+(H61-H60)/dr*dl)/(dl+dr)) | =LN(J61/J59)/LN(F61/F59) | =1000/(FMB_Bpss+F60/FMB_NCt) | =G60*1000          |
| 61 | 19                                                                                                                                                                                                         | 188.3                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A61*FMB_DMo | =E60+B61*(D61-D60)   | =E61/B61           | =PO.RTA.NormalizedRate(B61,FMB_Pi,C61) | =1/G61             | =SQRT(F61)  | =LET(dl,LN(F61/F60),dr,LN(F62/F61),((H61-H60)/dl*dr+(H62-H61)/dr*dl)/(dl+dr)) | =LN(J62/J60)/LN(F62/F60) | =1000/(FMB_Bpss+F61/FMB_NCt) | =G61*1000          |
| 62 | 20                                                                                                                                                                                                         | 179.2                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A62*FMB_DMo | =E61+B62*(D62-D61)   | =E62/B62           | =PO.RTA.NormalizedRate(B62,FMB_Pi,C62) | =1/G62             | =SQRT(F62)  | =LET(dl,LN(F62/F61),dr,LN(F63/F62),((H62-H61)/dl*dr+(H63-H62)/dr*dl)/(dl+dr)) | =LN(J63/J61)/LN(F63/F61) | =1000/(FMB_Bpss+F62/FMB_NCt) | =G62*1000          |
| 63 | 21                                                                                                                                                                                                         | 170.6                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A63*FMB_DMo | =E62+B63*(D63-D62)   | =E63/B63           | =PO.RTA.NormalizedRate(B63,FMB_Pi,C63) | =1/G63             | =SQRT(F63)  | =LET(dl,LN(F63/F62),dr,LN(F64/F63),((H63-H62)/dl*dr+(H64-H63)/dr*dl)/(dl+dr)) | =LN(J64/J62)/LN(F64/F62) | =1000/(FMB_Bpss+F63/FMB_NCt) | =G63*1000          |
| 64 | 22                                                                                                                                                                                                         | 162.3                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A64*FMB_DMo | =E63+B64*(D64-D63)   | =E64/B64           | =PO.RTA.NormalizedRate(B64,FMB_Pi,C64) | =1/G64             | =SQRT(F64)  | =LET(dl,LN(F64/F63),dr,LN(F65/F64),((H64-H63)/dl*dr+(H65-H64)/dr*dl)/(dl+dr)) | =LN(J65/J63)/LN(F65/F63) | =1000/(FMB_Bpss+F64/FMB_NCt) | =G64*1000          |
| 65 | 23                                                                                                                                                                                                         | 154.5                                                                                                                                   | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A65*FMB_DMo | =E64+B65*(D65-D64)   | =E65/B65           | =PO.RTA.NormalizedRate(B65,FMB_Pi,C65) | =1/G65             | =SQRT(F65)  | =LET(dl,LN(F65/F64),dr,LN(F66/F65),((H65-H64)/dl*dr+(H66-H65)/dr*dl)/(dl+dr)) | Not read                 | =1000/(FMB_Bpss+F65/FMB_NCt) | =G65*1000          |
| 66 | 24                                                                                                                                                                                                         | 147                                                                                                                                     | 1000                                                                                                                                                                                                                                                                                                                                                                            | =A66*FMB_DMo | =E65+B66*(D66-D65)   | =E66/B66           | =PO.RTA.NormalizedRate(B66,FMB_Pi,C66) | =1/G66             | =SQRT(F66)  | End month                                                                     | Not read                 | =1000/(FMB_Bpss+F66/FMB_NCt) | =G66*1000          |
| 68 | Calculation Constants                                                                                                                                                                                      |                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                 |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |
| 69 | Days in a month, 365.25/12                                                                                                                                                                                 | 30.4375                                                                                                                                 | days/month                                                                                                                                                                                                                                                                                                                                                                      |              |                      |                    |                                        |                    |             |                                                                               |                          |                              |                    |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.RTA.NormalizedRate | =LAMBDA(q, p_i, p_wf, IF((q<=0)+(p_i<=p_wf), NA(), q/(p_i-p_wf))) | Pressure-normalized rate q/(p_i - p_wf), STB/d/psi: the rate over the drawdown from the initial reservoir pressure. Works on single values or whole columns. For gas pass pseudo-pressures m(p_i), m(p_wf). |
| PO.RTA.FlowingMB | =LAMBDA(n_p, q, p_i, p_wf, ct, IF((ct<=0)+(SLOPE((p_i-p_wf)/q, n_p/q)<=0), NA(), 1/(SLOPE((p_i-p_wf)/q, n_p/q)*ct))) | Contacted oil in place, STB, by flowing material balance: fits (p_i - p_wf)/q against material-balance time Np/q and returns 1/(slope*ct). Np in STB, q in STB/d, pressures in psi, ct in 1/psi; boundary-dominated points only. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| FMB_Pi | $B$4 | Initial reservoir pressure, psi |
| FMB_Ct | $B$5 | Total compressibility, 1/psi |
| FMB_SlopeBdf | $B$6 | Derivative slope read as boundary-dominated flow |
| FMB_MUser | $B$7 | First boundary-dominated month, typed (0 takes the pick), month |
| FMB_R2Min | $B$8 | Least R² the flowing material balance should reach |
| FMB_MinPts | $B$9 | Fewest months the line should rest on |
| FMB_Inputs | $B$4:$B$9 | The initial reservoir pressure, the total compressibility, the derivative slope read as boundary-dominated, a typed first boundary-dominated month, the least R² and the fewest months for the line |
| FMB_MPick | $B$11 | First month the derivative's slope reaches the limit, month |
| FMB_MBdf | $B$12 | First boundary-dominated month used, month |
| FMB_TcBdf | $B$13 | Material-balance time there, tc, days |
| FMB_NBdf | $B$14 | Months on the flowing material balance line |
| FMB_SlopeLate | $B$15 | Derivative's mean log-log slope over those months |
| FMB_OOIP | $B$17 | Contacted oil in place, MMSTB |
| FMB_OOIPAll | $B$18 | Contacted oil in place, every month, transient too, MMSTB |
| FMB_Bpss | $B$19 | Intercept, b_pss, psi/(STB/d) |
| FMB_NCt | $B$20 | N·ct, where q/Δp would reach zero on the Np/Δp axis, STB/psi |
| FMB_FmbR2 | $B$21 | Flowing material balance R² |
| FMB_LinSlope | $B$23 | Linear-flow slope, psi/(STB/d)/√day |
| FMB_LinInt | $B$24 | Linear-flow intercept, psi/(STB/d) |
| FMB_QRise | $B$26 | Months the raw oil rate rises |
| FMB_NRise | $B$27 | Months the normalized rate q/Δp rises |
| FMB_PressureCheck | $B$28 | Drawdown check verdict |
| FMB_PressureCheckNote | $C$28 | Drawdown check comment |
| FMB_RegimeCheck | $B$29 | Flow regime check verdict |
| FMB_RegimeCheckNote | $C$29 | Flow regime check comment |
| FMB_LineCheck | $B$30 | Flowing material balance check verdict |
| FMB_LineCheckNote | $C$30 | Flowing material balance check comment |
| FMB_Results | $B$11:$B$30 | Derivative's boundary-dominated onset, month used, its material-balance time, months on the line, their derivative log-log slope, contacted OIP over them and all months, b_pss, N·ct, R², transient √tc line, months raw and normalized rates rise, 3 checks |
| FMB_Line | $A$35:$C$36 | The flowing material balance line, Δp/q = b_pss + tc/(N·ct), at tc = 0 and at the last month's material-balance time |
| FMB_History | $A$43:$M$66 | Each month's time, oil rate and flowing pressure, time in days, cumulative and material-balance time, normalized rate and inverse, √tc, the derivative of Δp/q in ln tc and its log-log slope, and the FMB line's and measured q/Δp in STB/d per 1,000 psi |
| FMB_T | $A$43:$A$66 | Months, 1 to 24 |
| FMB_Q | $B$43:$B$66 | Oil rates, STB/d |
| FMB_Pwf | $C$43:$C$66 | Flowing bottomhole pressures, psi |
| FMB_Np | $E$43:$E$66 | Cumulative oil to each month, STB |
| FMB_Tc | $F$43:$F$66 | Material-balance time Np/q, days |
| FMB_Rnp | $H$43:$H$66 | Rate-normalized pressure (pi - pwf)/q, psi/(STB/d) |
| FMB_RootTc | $I$43:$I$66 | Square root of material-balance time, √days |
| FMB_Curve | $F$44:$J$65 | Rate-Normalized Pressure and Derivative |
| FMB_Rate_Curve | $F$43:$M$66 | Normalized Rate Against Material-Balance Time |
| FMB_Fmb_Curve | $B$35:$H$36 | Flowing Material Balance, Δp/q Against tc |
| FMB_DMo | $B$69 | Days in a month, 365.25/12, days/month |

---

## Related Blueprints
- [Decline and Flow-Regime Diagnostics](/blueprint/po.dca.diagnostics.analysis.md)
- [Decline Model Comparison](/blueprint/po.dca.models.compare.md)
- [Water-Oil Ratio Diagnostics](/blueprint/po.dca.wor.diagnostics.md)
- [Modified Hyperbolic Decline](/blueprint/po.dca.modhyp.forecast.md)
- [Production Data Cleaning](/blueprint/po.dca.data.cleaning.md)
- [Duong Decline Forecast](/blueprint/po.dca.duong.forecast.md)

