---
cid: po.bp.dca.type.well
hub: dca
tags: [type-well, type-curve, decline, P10, P50, P90, percentiles, normalization, lateral-length, time-zero, Arps, weighted-fit, EUR, multi-well]
facets: { discipline: production, property: rate, model: arps, method-type: empirical }
title: Type Well Curves
summary: "What a new well in a play produces in the low, mid and high case, from P90, P50 and P10 type curves of offset wells, each fitted with Arps to an EUR."
slug: po.dca.type.well
type: worksheet
---

# Type Well Curves

## Description

What does a new well in this play produce, low, mid and high? You enter a set of wells' monthly oil rates by calendar month and their lateral lengths, a reference lateral and an economic-limit rate. Each well is scaled to the reference lateral and aligned at its own first month. You read off the P90, P50 and P10 type curves, each curve's Arps qi, Di, b and EUR, and how the curves' 24-month cumulatives compare with the wells' own.

**Parameters:**
- **Normalization**: the lateral length the wells are scaled to, `TW_RefLat` (ft)
- **Fits**: the late-time weight exponent `TW_WPow` (the weight is (month/24)^exponent; 0 weighs every month alike) and the economic-limit rate `TW_QEcon` (STB/d)
- **Limits**: the fewest wells a month's percentiles should rest on `TW_MinWells`, the largest fit mismatch `TW_FitMax`, and the largest gap between the P50 curve's 24-month cumulative and the wells' P50 `TW_CumBand`
- **Wells**: each well's lateral length (ft) and its oil rate (STB/d) in calendar months 1 to 30, 0 before it came online

**How to use it:** Take each well's monthly volume over its days on production, from its first full month; leave out wells with a frac hit, a long shut-in or a recompletion in their first 24 months, or the percentiles will mix two populations. Use wells of one landing zone, completion design and vintage, and at least eight to ten of them. Scale by lateral only where the play shows rate in proportion to completed length; otherwise type a reference lateral equal to the wells' own. Check that every month rests on enough wells, that each fit matches its curve, that the three EURs come in order, and that the P50 curve's cumulative is close to the wells' P50. The chart draws the three type curves and their three fits; it leaves the individual wells off, which keeps it to six series.

**Method:** A well's first month (time zero) is the first calendar month with a rate. Its rate in producing month k is its rate in calendar month first + k − 1, times the reference lateral over its own. The P90, P50 and P10 rates at month k are the wells' 10th, 50th and 90th percentiles, Excel's PERCENTILE.INC of the ten scaled rates at 0.1, 0.5 and 0.9: the values sorted and read at position p·(n − 1) from the first, interpolating between neighbours. The convention is the reserves one: P90 is the low case, the rate 90 % of the wells exceed that month (at 0.1), and P10 the high case (at 0.9). Statistical software names them the other way round. Each curve is fitted with Arps, q = qi/(1 + b·Di·t)^(1/b) with t in months, by a weighted least-squares fit in log rate with the late-time weights; Di per year is twelve times Di per month. The EUR is the Arps cumulative to the economic limit, times 365.25/12 days a month. A curve's 24-month cumulative is the sum of its monthly rates times the days in a month, and a well's the same over its scaled rates; the wells' cumulatives are summarised by the same percentile convention. A curve of percentiles is not one well: the P50 curve takes each month's median, which can be a different well from month to month.

**Example:** The default set is synthetic: ten tight-oil horizontals of one play, with laterals of 6,500 to 12,500 ft, brought online over the first seven of 30 calendar months. Each is an Arps hyperbolic in its own months (60 to 160 STB/d of qi per 1,000 ft of lateral, Di 1.65 to 2.25/yr, b 0.85 to 1.02) with a fixed ±4 % scatter, rounded to the barrel; the median well is close to the decline family's reference well (1,020 STB/d, 1.89/yr, 0.93 at 10,000 ft). The economic limit is 15 STB/d and the late-time weight exponent 1, as on the Decline Model Auto-Fit sheet.

All ten wells have 24 months or more, so every month rests on ten. The P90 (low) curve starts at 593 STB/d and fits qi 694.5 STB/d, Di 1.746/yr, b 0.874, for an EUR of 442 MSTB; the P50 starts at 858 STB/d, fits 989.9 STB/d, 1.912/yr, 0.922, EUR 676 MSTB; the P10 (high) starts at 1,208 STB/d, fits 1,411.8 STB/d, 2.186/yr, 0.999, EUR 1,069 MSTB. The P10 EUR is 2.42 times the P90's. Every fit is within 2.6 % of its curve. The wells' own 24-month cumulatives are 202.3 (P90), 278.9 (P50) and 379.7 MSTB (P10), mean 288.3 MSTB; the P50 curve's is 279.0 MSTB, 0.06 % off. These wells keep their rank from month to month, which is why the curves' cumulatives match the wells' so closely.

## Validity

The percentiles of a month are only as good as the wells behind it: with ten wells, P90 and P10 interpolate between the lowest two and the highest two. When later wells have fewer months, the late months rest on fewer wells and on the older ones (survivor bias); this sheet's defaults all reach 24 months, and its well check fails when a month rests on fewer than the fewest wells you set. Scaling by lateral length assumes rate in proportion to completed length; in many plays it isn't, and a power of the ratio or no scaling fits better. Arps fitted to 24 months says nothing certain about the tail: b near 1 gives a long one, and a terminal decline (the Modified Hyperbolic Decline sheet) is the usual guard. P10, P50 and P90 type curves are not probabilistic reserves categories of a single well; for a project's distribution, sample the curves' parameters in a Monte Carlo.

Named alternatives: the Decline Model Auto-Fit sheet to fit one well; the Modified Hyperbolic Decline sheet for a terminal decline on the P50 curve; the Field Rate from a Drilling Schedule and a Type Well sheet to turn a type well into a field forecast.

## References

- Arps, J.J. (1945). "Analysis of Decline Curves." *Transactions of the AIME* 160, 228–247.
- Society of Petroleum Evaluation Engineers (2016). *Monograph 4: Estimating Ultimate Recovery of Developed Wells in Low-Permeability Reservoirs*. SPEE (type wells, normalization and the P10/P50/P90 convention).
- Society of Petroleum Engineers (2018). *Petroleum Resources Management System* (PRMS), Section 2.2 (P90 as the low estimate).

## Functions used

`PO.DCA.Arps.WFit`, `PO.DCA.Arps.Rate`, `PO.DCA.Arps.EUR`, `PO.RES.MC.Percentiles`, `PO.Stats.RMSE`

## Spreadsheet: DcaTypeWell

|     | A                                                                                                                                                                                                      | B                                                                 | C                                                                                                                                                                                                                                                        | D                                                         | E                                                         | F                                                         | G                                                         | H                                                         | I                                                         | J                                                         | K                                                         | L                 | M                         | N                                  | O                                  | P                                   | Q                                                  | R                                                  | S                                                  |
|-----|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------|-----------------------------------------------------------|-----------------------------------------------------------|-----------------------------------------------------------|-----------------------------------------------------------|-----------------------------------------------------------|-----------------------------------------------------------|-----------------------------------------------------------|-------------------|---------------------------|------------------------------------|------------------------------------|-------------------------------------|----------------------------------------------------|----------------------------------------------------|----------------------------------------------------|
| 1   | Type Well Curves                                                                                                                                                                                       |                                                                   | Petroleum Office                                                                                                                                                                                                                                         |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 2   | Blue cells on yellow are inputs. Type each well's lateral and monthly rates; the wells are scaled, aligned at their first month and summarised as P10, P50 and P90 type curves, each fitted with Arps. |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 3   | Normalization, Fit and Limits                                                                                                                                                                          |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 4   | Lateral length the wells are scaled to                                                                                                                                                                 | 10000                                                             | ft                                                                                                                                                                                                                                                       |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 5   | Fits' late-time weight exponent (0 weighs months alike)                                                                                                                                                | 1                                                                 | —                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 6   | Economic-limit oil rate                                                                                                                                                                                | 15                                                                | STB/d                                                                                                                                                                                                                                                    |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 7   | Fewest wells a month's percentiles should rest on                                                                                                                                                      | 8                                                                 | wells                                                                                                                                                                                                                                                    |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 8   | Largest fit mismatch allowed (RMSE over mean rate)                                                                                                                                                     | 0.1                                                               | %                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 9   | Largest gap, P50 curve's cumulative to the wells' P50                                                                                                                                                  | 0.15                                                              | %                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 10  | Type Curves Fitted With Arps (time in months)                                                                                                                                                          |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 11  | P90 is the low case: 90% of the wells produce more than it that month (PERCENTILE.INC at 0.1, as PO.RES.MC.Percentiles). P10 is the high case.                                                         |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 12  | Type curve                                                                                                                                                                                             | qi (STB/d)                                                        | Di (1/month)                                                                                                                                                                                                                                             | Di (1/yr)                                                 | b (—)                                                     | EUR (MSTB)                                                | 24-month cum (MSTB)                                       | RMSE over mean (%)                                        |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 13  | P90 (low)                                                                                                                                                                                              | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P90,TW_W),1)                      | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P90,TW_W),2)                                                                                                                                                                                                             | =C13*TW_MoYr                                              | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P90,TW_W),TW_BPos)        | =PO.DCA.Arps.EUR(B13,C13,E13,TW_QEcon)*TW_DMo/1000        | =SUM(TW_P90)*TW_DMo/1000                                  | =PO.Stats.RMSE(TW_P90,TW_FitP90)/AVERAGE(TW_P90)          |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 14  | P50                                                                                                                                                                                                    | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P50,TW_W),1)                      | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P50,TW_W),2)                                                                                                                                                                                                             | =C14*TW_MoYr                                              | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P50,TW_W),TW_BPos)        | =PO.DCA.Arps.EUR(B14,C14,E14,TW_QEcon)*TW_DMo/1000        | =SUM(TW_P50)*TW_DMo/1000                                  | =PO.Stats.RMSE(TW_P50,TW_FitP50)/AVERAGE(TW_P50)          |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 15  | P10 (high)                                                                                                                                                                                             | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P10,TW_W),1)                      | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P10,TW_W),2)                                                                                                                                                                                                             | =C15*TW_MoYr                                              | =INDEX(PO.DCA.Arps.WFit(TW_K,TW_P10,TW_W),TW_BPos)        | =PO.DCA.Arps.EUR(B15,C15,E15,TW_QEcon)*TW_DMo/1000        | =SUM(TW_P10)*TW_DMo/1000                                  | =PO.Stats.RMSE(TW_P10,TW_FitP10)/AVERAGE(TW_P10)          |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 17  | Wells and Spread                                                                                                                                                                                       |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 18  | Wells in the set                                                                                                                                                                                       | =COUNT(TW_Lat)                                                    | wells                                                                                                                                                                                                                                                    |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 19  | Fewest wells behind any month's percentiles                                                                                                                                                            | =MIN(TW_Count)                                                    | wells                                                                                                                                                                                                                                                    |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 20  | Wells' own 24-month cumulative, P90 (low)                                                                                                                                                              | =INDEX(PO.RES.MC.Percentiles(TW_Cums),1)                          | MSTB                                                                                                                                                                                                                                                     |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 21  | Wells' own 24-month cumulative, P50                                                                                                                                                                    | =INDEX(PO.RES.MC.Percentiles(TW_Cums),2)                          | MSTB                                                                                                                                                                                                                                                     |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 22  | Wells' own 24-month cumulative, P10 (high)                                                                                                                                                             | =INDEX(PO.RES.MC.Percentiles(TW_Cums),TW_P10Pos)                  | MSTB                                                                                                                                                                                                                                                     |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 23  | Wells' own 24-month cumulative, mean                                                                                                                                                                   | =INDEX(PO.RES.MC.Percentiles(TW_Cums),TW_MeanPos)                 | MSTB                                                                                                                                                                                                                                                     |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 24  | EUR spread, P10 over P90                                                                                                                                                                               | =TW_P10EUR/TW_P90EUR                                              | —                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 25  | P50 curve's 24-month cum over the wells' P50, less 1                                                                                                                                                   | =TW_P50Cum/TW_CumP50-1                                            | %                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 26  | Worst fit's RMSE over its mean rate                                                                                                                                                                    | =MAX(TW_P90Err,TW_P50Err,TW_P10Err)                               | %                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 27  | Well count check                                                                                                                                                                                       | =IF(TW_NMin<TW_MinWells,"FAIL","PASS")                            | =IF(TW_NMin<TW_MinWells,"a month rests on only "&TW_NMin&" wells, fewer than "&TW_MinWells&"; its percentiles are a guess","every month rests on at least "&TW_NMin&" wells")                                                                            |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 28  | Fit check                                                                                                                                                                                              | =IF(TW_WorstErr<=TW_FitMax,"PASS","WARN")                         | =IF(TW_WorstErr<=TW_FitMax,"every Arps fit is within "&FIXED(TW_WorstErr*100,1)&"% of its curve","a fit misses its curve by "&FIXED(TW_WorstErr*100,1)&"%; refit before booking")                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 29  | Percentile order check                                                                                                                                                                                 | =IF(AND(TW_P90EUR<=TW_P50EUR,TW_P50EUR<=TW_P10EUR),"PASS","WARN") | =IF(AND(TW_P90EUR<=TW_P50EUR,TW_P50EUR<=TW_P10EUR),"EUR "&FIXED(TW_P90EUR,0)&" (P90, low) to "&FIXED(TW_P10EUR,0)&" MSTB (P10, high)","the fitted EURs cross; the tails decide it, so check the fits' b")                                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 30  | Cumulative check                                                                                                                                                                                       | =IF(ABS(TW_CumGap)<=TW_CumBand,"PASS","WARN")                     | =IF(ABS(TW_CumGap)<=TW_CumBand,"the P50 curve's 24-month cumulative is within "&FIXED(ABS(TW_CumGap)*100,1)&"% of the wells' P50","the P50 curve's cumulative is "&FIXED(TW_CumGap*100,1)&"% off the wells' P50; a curve of percentiles is no one well") |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 32  | Calculation Constants                                                                                                                                                                                  |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 33  | Months in a year                                                                                                                                                                                       | 12                                                                | months/yr                                                                                                                                                                                                                                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 34  | Days in a month, 365.25/12                                                                                                                                                                             | 30.4375                                                           | days/month                                                                                                                                                                                                                                               |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 35  | Percentile of the P90 (low) curve                                                                                                                                                                      | 0.1                                                               | —                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 36  | Percentile of the P50 curve                                                                                                                                                                            | 0.5                                                               | —                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 37  | Percentile of the P10 (high) curve                                                                                                                                                                     | 0.9                                                               | —                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 38  | Position of b in PO.DCA.Arps.WFit's output                                                                                                                                                             | 3                                                                 | —                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 39  | Position of P10 in PO.RES.MC.Percentiles' output                                                                                                                                                       | 3                                                                 | —                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 40  | Position of the mean in PO.RES.MC.Percentiles' output                                                                                                                                                  | 4                                                                 | —                                                                                                                                                                                                                                                        |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 41  | The Wells                                                                                                                                                                                              |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 42  | The first month is the first calendar month with a rate; the 24-month cumulative is of the scaled, aligned rates.                                                                                      |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 43  | Well                                                                                                                                                                                                   | Lateral (ft)                                                      | First month (month)                                                                                                                                                                                                                                      | Producing (months)                                        | 24-month cum (MSTB)                                       |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 44  | A-1                                                                                                                                                                                                    | 7500                                                              | =MINIFS(TW_M,B58:B87,">0")                                                                                                                                                                                                                               | =COUNTIF(B58:B87,">0")                                    | =SUM(B92:B115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 45  | A-2                                                                                                                                                                                                    | 10000                                                             | =MINIFS(TW_M,C58:C87,">0")                                                                                                                                                                                                                               | =COUNTIF(C58:C87,">0")                                    | =SUM(C92:C115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 46  | A-3                                                                                                                                                                                                    | 9000                                                              | =MINIFS(TW_M,D58:D87,">0")                                                                                                                                                                                                                               | =COUNTIF(D58:D87,">0")                                    | =SUM(D92:D115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 47  | A-4                                                                                                                                                                                                    | 12500                                                             | =MINIFS(TW_M,E58:E87,">0")                                                                                                                                                                                                                               | =COUNTIF(E58:E87,">0")                                    | =SUM(E92:E115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 48  | A-5                                                                                                                                                                                                    | 8000                                                              | =MINIFS(TW_M,F58:F87,">0")                                                                                                                                                                                                                               | =COUNTIF(F58:F87,">0")                                    | =SUM(F92:F115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 49  | B-1                                                                                                                                                                                                    | 10500                                                             | =MINIFS(TW_M,G58:G87,">0")                                                                                                                                                                                                                               | =COUNTIF(G58:G87,">0")                                    | =SUM(G92:G115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 50  | B-2                                                                                                                                                                                                    | 6500                                                              | =MINIFS(TW_M,H58:H87,">0")                                                                                                                                                                                                                               | =COUNTIF(H58:H87,">0")                                    | =SUM(H92:H115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 51  | B-3                                                                                                                                                                                                    | 11000                                                             | =MINIFS(TW_M,I58:I87,">0")                                                                                                                                                                                                                               | =COUNTIF(I58:I87,">0")                                    | =SUM(I92:I115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 52  | B-4                                                                                                                                                                                                    | 10000                                                             | =MINIFS(TW_M,J58:J87,">0")                                                                                                                                                                                                                               | =COUNTIF(J58:J87,">0")                                    | =SUM(J92:J115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 53  | B-5                                                                                                                                                                                                    | 9500                                                              | =MINIFS(TW_M,K58:K87,">0")                                                                                                                                                                                                                               | =COUNTIF(K58:K87,">0")                                    | =SUM(K92:K115)*TW_DMo/1000                                |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 55  | Oil Rate by Calendar Month                                                                                                                                                                             |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 56  | The rates are synthetic, ten wells of one play. How to use it: each month's volume over its days on production, 0 before a well's first month.                                                         |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 57  | Month (month)                                                                                                                                                                                          | A-1 (STB/d)                                                       | A-2 (STB/d)                                                                                                                                                                                                                                              | A-3 (STB/d)                                               | A-4 (STB/d)                                               | A-5 (STB/d)                                               | B-1 (STB/d)                                               | B-2 (STB/d)                                               | B-3 (STB/d)                                               | B-4 (STB/d)                                               | B-5 (STB/d)                                               |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 58  | 1                                                                                                                                                                                                      | 562                                                               | 886                                                                                                                                                                                                                                                      | 0                                                         | 0                                                         | 0                                                         | 0                                                         | 0                                                         | 0                                                         | 0                                                         | 0                                                         |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 59  | 2                                                                                                                                                                                                      | 526                                                               | 738                                                                                                                                                                                                                                                      | 947                                                       | 0                                                         | 0                                                         | 0                                                         | 0                                                         | 0                                                         | 0                                                         | 0                                                         |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 60  | 3                                                                                                                                                                                                      | 439                                                               | 697                                                                                                                                                                                                                                                      | 855                                                       | 1038                                                      | 480                                                       | 0                                                         | 0                                                         | 0                                                         | 0                                                         | 0                                                         |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 61  | 4                                                                                                                                                                                                      | 413                                                               | 609                                                                                                                                                                                                                                                      | 711                                                       | 895                                                       | 452                                                       | 1255                                                      | 0                                                         | 0                                                         | 0                                                         | 0                                                         |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 62  | 5                                                                                                                                                                                                      | 357                                                               | 575                                                                                                                                                                                                                                                      | 655                                                       | 838                                                       | 378                                                       | 1033                                                      | 449                                                       | 1063                                                      | 0                                                         | 0                                                         |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 63  | 6                                                                                                                                                                                                      | 348                                                               | 496                                                                                                                                                                                                                                                      | 580                                                       | 719                                                       | 356                                                       | 967                                                       | 413                                                       | 915                                                       | 1321                                                      | 0                                                         |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 64  | 7                                                                                                                                                                                                      | 312                                                               | 472                                                                                                                                                                                                                                                      | 556                                                       | 693                                                       | 309                                                       | 840                                                       | 349                                                       | 857                                                       | 1211                                                      | 505                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 65  | 8                                                                                                                                                                                                      | 301                                                               | 429                                                                                                                                                                                                                                                      | 485                                                       | 592                                                       | 301                                                       | 790                                                       | 325                                                       | 735                                                       | 995                                                       | 427                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 66  | 9                                                                                                                                                                                                      | 265                                                               | 420                                                                                                                                                                                                                                                      | 476                                                       | 568                                                       | 270                                                       | 679                                                       | 291                                                       | 710                                                       | 926                                                       | 408                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 67  | 10                                                                                                                                                                                                     | 255                                                               | 374                                                                                                                                                                                                                                                      | 412                                                       | 500                                                       | 261                                                       | 644                                                       | 281                                                       | 607                                                       | 796                                                       | 359                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 68  | 11                                                                                                                                                                                                     | 235                                                               | 373                                                                                                                                                                                                                                                      | 401                                                       | 494                                                       | 229                                                       | 584                                                       | 247                                                       | 584                                                       | 771                                                       | 342                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 69  | 12                                                                                                                                                                                                     | 233                                                               | 328                                                                                                                                                                                                                                                      | 357                                                       | 448                                                       | 221                                                       | 571                                                       | 244                                                       | 515                                                       | 689                                                       | 296                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 70  | 13                                                                                                                                                                                                     | 210                                                               | 323                                                                                                                                                                                                                                                      | 356                                                       | 438                                                       | 203                                                       | 508                                                       | 212                                                       | 510                                                       | 663                                                       | 282                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 71  | 14                                                                                                                                                                                                     | 211                                                               | 292                                                                                                                                                                                                                                                      | 326                                                       | 388                                                       | 201                                                       | 507                                                       | 207                                                       | 464                                                       | 582                                                       | 257                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 72  | 15                                                                                                                                                                                                     | 187                                                               | 295                                                                                                                                                                                                                                                      | 321                                                       | 378                                                       | 181                                                       | 446                                                       | 185                                                       | 454                                                       | 561                                                       | 252                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 73  | 16                                                                                                                                                                                                     | 186                                                               | 273                                                                                                                                                                                                                                                      | 287                                                       | 351                                                       | 182                                                       | 439                                                       | 185                                                       | 404                                                       | 517                                                       | 225                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 74  | 17                                                                                                                                                                                                     | 168                                                               | 271                                                                                                                                                                                                                                                      | 282                                                       | 350                                                       | 161                                                       | 396                                                       | 170                                                       | 394                                                       | 512                                                       | 224                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 75  | 18                                                                                                                                                                                                     | 171                                                               | 244                                                                                                                                                                                                                                                      | 263                                                       | 317                                                       | 160                                                       | 400                                                       | 168                                                       | 366                                                       | 461                                                       | 197                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 76  | 19                                                                                                                                                                                                     | 159                                                               | 241                                                                                                                                                                                                                                                      | 264                                                       | 321                                                       | 145                                                       | 370                                                       | 151                                                       | 366                                                       | 464                                                       | 194                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 77  | 20                                                                                                                                                                                                     | 159                                                               | 227                                                                                                                                                                                                                                                      | 240                                                       | 286                                                       | 147                                                       | 368                                                       | 148                                                       | 332                                                       | 412                                                       | 175                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 78  | 21                                                                                                                                                                                                     | 144                                                               | 230                                                                                                                                                                                                                                                      | 245                                                       | 285                                                       | 137                                                       | 332                                                       | 138                                                       | 337                                                       | 409                                                       | 177                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 79  | 22                                                                                                                                                                                                     | 143                                                               | 210                                                                                                                                                                                                                                                      | 219                                                       | 259                                                       | 136                                                       | 328                                                       | 139                                                       | 301                                                       | 372                                                       | 163                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 80  | 23                                                                                                                                                                                                     | 135                                                               | 215                                                                                                                                                                                                                                                      | 219                                                       | 265                                                       | 123                                                       | 309                                                       | 127                                                       | 300                                                       | 378                                                       | 162                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 81  | 24                                                                                                                                                                                                     | 137                                                               | 194                                                                                                                                                                                                                                                      | 201                                                       | 247                                                       | 122                                                       | 312                                                       | 129                                                       | 274                                                       | 352                                                       | 146                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 82  | 25                                                                                                                                                                                                     | 125                                                               | 195                                                                                                                                                                                                                                                      | 206                                                       | 247                                                       | 115                                                       | 286                                                       | 116                                                       | 280                                                       | 352                                                       | 144                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 83  | 26                                                                                                                                                                                                     | 129                                                               | 179                                                                                                                                                                                                                                                      | 193                                                       | 224                                                       | 117                                                       | 293                                                       | 116                                                       | 262                                                       | 319                                                       | 135                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 84  | 27                                                                                                                                                                                                     | 116                                                               | 185                                                                                                                                                                                                                                                      | 194                                                       | 223                                                       | 107                                                       | 264                                                       | 106                                                       | 263                                                       | 317                                                       | 137                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 85  | 28                                                                                                                                                                                                     | 117                                                               | 174                                                                                                                                                                                                                                                      | 176                                                       | 211                                                       | 110                                                       | 266                                                       | 109                                                       | 239                                                       | 300                                                       | 125                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 86  | 29                                                                                                                                                                                                     | 108                                                               | 175                                                                                                                                                                                                                                                      | 176                                                       | 215                                                       | 99                                                        | 245                                                       | 102                                                       | 238                                                       | 305                                                       | 128                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 87  | 30                                                                                                                                                                                                     | 111                                                               | 160                                                                                                                                                                                                                                                      | 167                                                       | 198                                                       | 100                                                       | 252                                                       | 103                                                       | 226                                                       | 281                                                       | 115                                                       |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 88  | Scaled to the Lateral and Aligned at Each Well's First Month                                                                                                                                           |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 89  | Each rate is scaled by the reference lateral over the well's own. P90, P50 and P10 are the 10th, 50th and 90th percentiles of the wells that month.                                                    |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 90  | The weight is (month/24)^exponent, so the fits lean on the late months that set the EUR.                                                                                                               |                                                                   |                                                                                                                                                                                                                                                          |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                                                           |                   |                           |                                    |                                    |                                     |                                                    |                                                    |                                                    |
| 91  | Month (month)                                                                                                                                                                                          | A-1 (STB/d)                                                       | A-2 (STB/d)                                                                                                                                                                                                                                              | A-3 (STB/d)                                               | A-4 (STB/d)                                               | A-5 (STB/d)                                               | B-1 (STB/d)                                               | B-2 (STB/d)                                               | B-3 (STB/d)                                               | B-4 (STB/d)                                               | B-5 (STB/d)                                               | Wells (wells)     | Weight                    | P90 (STB/d)                        | P50 (STB/d)                        | P10 (STB/d)                         | P90 fit (STB/d)                                    | P50 fit (STB/d)                                    | P10 fit (STB/d)                                    |
| 92  | =1                                                                                                                                                                                                     | =IF(A92<=D44,INDEX(B58:B87,C44+A92-1)*TW_RefLat/B44,"")           | =IF(A92<=D45,INDEX(C58:C87,C45+A92-1)*TW_RefLat/B45,"")                                                                                                                                                                                                  | =IF(A92<=D46,INDEX(D58:D87,C46+A92-1)*TW_RefLat/B46,"")   | =IF(A92<=D47,INDEX(E58:E87,C47+A92-1)*TW_RefLat/B47,"")   | =IF(A92<=D48,INDEX(F58:F87,C48+A92-1)*TW_RefLat/B48,"")   | =IF(A92<=D49,INDEX(G58:G87,C49+A92-1)*TW_RefLat/B49,"")   | =IF(A92<=D50,INDEX(H58:H87,C50+A92-1)*TW_RefLat/B50,"")   | =IF(A92<=D51,INDEX(I58:I87,C51+A92-1)*TW_RefLat/B51,"")   | =IF(A92<=D52,INDEX(J58:J87,C52+A92-1)*TW_RefLat/B52,"")   | =IF(A92<=D53,INDEX(K58:K87,C53+A92-1)*TW_RefLat/B53,"")   | =COUNT(B92:K92)   | =(A92/MAX(TW_K))^TW_WPow  | =PERCENTILE.INC(B92:K92,TW_PLow)   | =PERCENTILE.INC(B92:K92,TW_PMid)   | =PERCENTILE.INC(B92:K92,TW_PHigh)   | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A92)  | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A92)  | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A92)  |
| 93  | =2                                                                                                                                                                                                     | =IF(A93<=D44,INDEX(B58:B87,C44+A93-1)*TW_RefLat/B44,"")           | =IF(A93<=D45,INDEX(C58:C87,C45+A93-1)*TW_RefLat/B45,"")                                                                                                                                                                                                  | =IF(A93<=D46,INDEX(D58:D87,C46+A93-1)*TW_RefLat/B46,"")   | =IF(A93<=D47,INDEX(E58:E87,C47+A93-1)*TW_RefLat/B47,"")   | =IF(A93<=D48,INDEX(F58:F87,C48+A93-1)*TW_RefLat/B48,"")   | =IF(A93<=D49,INDEX(G58:G87,C49+A93-1)*TW_RefLat/B49,"")   | =IF(A93<=D50,INDEX(H58:H87,C50+A93-1)*TW_RefLat/B50,"")   | =IF(A93<=D51,INDEX(I58:I87,C51+A93-1)*TW_RefLat/B51,"")   | =IF(A93<=D52,INDEX(J58:J87,C52+A93-1)*TW_RefLat/B52,"")   | =IF(A93<=D53,INDEX(K58:K87,C53+A93-1)*TW_RefLat/B53,"")   | =COUNT(B93:K93)   | =(A93/MAX(TW_K))^TW_WPow  | =PERCENTILE.INC(B93:K93,TW_PLow)   | =PERCENTILE.INC(B93:K93,TW_PMid)   | =PERCENTILE.INC(B93:K93,TW_PHigh)   | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A93)  | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A93)  | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A93)  |
| 94  | =3                                                                                                                                                                                                     | =IF(A94<=D44,INDEX(B58:B87,C44+A94-1)*TW_RefLat/B44,"")           | =IF(A94<=D45,INDEX(C58:C87,C45+A94-1)*TW_RefLat/B45,"")                                                                                                                                                                                                  | =IF(A94<=D46,INDEX(D58:D87,C46+A94-1)*TW_RefLat/B46,"")   | =IF(A94<=D47,INDEX(E58:E87,C47+A94-1)*TW_RefLat/B47,"")   | =IF(A94<=D48,INDEX(F58:F87,C48+A94-1)*TW_RefLat/B48,"")   | =IF(A94<=D49,INDEX(G58:G87,C49+A94-1)*TW_RefLat/B49,"")   | =IF(A94<=D50,INDEX(H58:H87,C50+A94-1)*TW_RefLat/B50,"")   | =IF(A94<=D51,INDEX(I58:I87,C51+A94-1)*TW_RefLat/B51,"")   | =IF(A94<=D52,INDEX(J58:J87,C52+A94-1)*TW_RefLat/B52,"")   | =IF(A94<=D53,INDEX(K58:K87,C53+A94-1)*TW_RefLat/B53,"")   | =COUNT(B94:K94)   | =(A94/MAX(TW_K))^TW_WPow  | =PERCENTILE.INC(B94:K94,TW_PLow)   | =PERCENTILE.INC(B94:K94,TW_PMid)   | =PERCENTILE.INC(B94:K94,TW_PHigh)   | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A94)  | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A94)  | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A94)  |
| 95  | =4                                                                                                                                                                                                     | =IF(A95<=D44,INDEX(B58:B87,C44+A95-1)*TW_RefLat/B44,"")           | =IF(A95<=D45,INDEX(C58:C87,C45+A95-1)*TW_RefLat/B45,"")                                                                                                                                                                                                  | =IF(A95<=D46,INDEX(D58:D87,C46+A95-1)*TW_RefLat/B46,"")   | =IF(A95<=D47,INDEX(E58:E87,C47+A95-1)*TW_RefLat/B47,"")   | =IF(A95<=D48,INDEX(F58:F87,C48+A95-1)*TW_RefLat/B48,"")   | =IF(A95<=D49,INDEX(G58:G87,C49+A95-1)*TW_RefLat/B49,"")   | =IF(A95<=D50,INDEX(H58:H87,C50+A95-1)*TW_RefLat/B50,"")   | =IF(A95<=D51,INDEX(I58:I87,C51+A95-1)*TW_RefLat/B51,"")   | =IF(A95<=D52,INDEX(J58:J87,C52+A95-1)*TW_RefLat/B52,"")   | =IF(A95<=D53,INDEX(K58:K87,C53+A95-1)*TW_RefLat/B53,"")   | =COUNT(B95:K95)   | =(A95/MAX(TW_K))^TW_WPow  | =PERCENTILE.INC(B95:K95,TW_PLow)   | =PERCENTILE.INC(B95:K95,TW_PMid)   | =PERCENTILE.INC(B95:K95,TW_PHigh)   | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A95)  | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A95)  | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A95)  |
| 96  | =5                                                                                                                                                                                                     | =IF(A96<=D44,INDEX(B58:B87,C44+A96-1)*TW_RefLat/B44,"")           | =IF(A96<=D45,INDEX(C58:C87,C45+A96-1)*TW_RefLat/B45,"")                                                                                                                                                                                                  | =IF(A96<=D46,INDEX(D58:D87,C46+A96-1)*TW_RefLat/B46,"")   | =IF(A96<=D47,INDEX(E58:E87,C47+A96-1)*TW_RefLat/B47,"")   | =IF(A96<=D48,INDEX(F58:F87,C48+A96-1)*TW_RefLat/B48,"")   | =IF(A96<=D49,INDEX(G58:G87,C49+A96-1)*TW_RefLat/B49,"")   | =IF(A96<=D50,INDEX(H58:H87,C50+A96-1)*TW_RefLat/B50,"")   | =IF(A96<=D51,INDEX(I58:I87,C51+A96-1)*TW_RefLat/B51,"")   | =IF(A96<=D52,INDEX(J58:J87,C52+A96-1)*TW_RefLat/B52,"")   | =IF(A96<=D53,INDEX(K58:K87,C53+A96-1)*TW_RefLat/B53,"")   | =COUNT(B96:K96)   | =(A96/MAX(TW_K))^TW_WPow  | =PERCENTILE.INC(B96:K96,TW_PLow)   | =PERCENTILE.INC(B96:K96,TW_PMid)   | =PERCENTILE.INC(B96:K96,TW_PHigh)   | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A96)  | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A96)  | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A96)  |
| 97  | =6                                                                                                                                                                                                     | =IF(A97<=D44,INDEX(B58:B87,C44+A97-1)*TW_RefLat/B44,"")           | =IF(A97<=D45,INDEX(C58:C87,C45+A97-1)*TW_RefLat/B45,"")                                                                                                                                                                                                  | =IF(A97<=D46,INDEX(D58:D87,C46+A97-1)*TW_RefLat/B46,"")   | =IF(A97<=D47,INDEX(E58:E87,C47+A97-1)*TW_RefLat/B47,"")   | =IF(A97<=D48,INDEX(F58:F87,C48+A97-1)*TW_RefLat/B48,"")   | =IF(A97<=D49,INDEX(G58:G87,C49+A97-1)*TW_RefLat/B49,"")   | =IF(A97<=D50,INDEX(H58:H87,C50+A97-1)*TW_RefLat/B50,"")   | =IF(A97<=D51,INDEX(I58:I87,C51+A97-1)*TW_RefLat/B51,"")   | =IF(A97<=D52,INDEX(J58:J87,C52+A97-1)*TW_RefLat/B52,"")   | =IF(A97<=D53,INDEX(K58:K87,C53+A97-1)*TW_RefLat/B53,"")   | =COUNT(B97:K97)   | =(A97/MAX(TW_K))^TW_WPow  | =PERCENTILE.INC(B97:K97,TW_PLow)   | =PERCENTILE.INC(B97:K97,TW_PMid)   | =PERCENTILE.INC(B97:K97,TW_PHigh)   | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A97)  | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A97)  | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A97)  |
| 98  | =7                                                                                                                                                                                                     | =IF(A98<=D44,INDEX(B58:B87,C44+A98-1)*TW_RefLat/B44,"")           | =IF(A98<=D45,INDEX(C58:C87,C45+A98-1)*TW_RefLat/B45,"")                                                                                                                                                                                                  | =IF(A98<=D46,INDEX(D58:D87,C46+A98-1)*TW_RefLat/B46,"")   | =IF(A98<=D47,INDEX(E58:E87,C47+A98-1)*TW_RefLat/B47,"")   | =IF(A98<=D48,INDEX(F58:F87,C48+A98-1)*TW_RefLat/B48,"")   | =IF(A98<=D49,INDEX(G58:G87,C49+A98-1)*TW_RefLat/B49,"")   | =IF(A98<=D50,INDEX(H58:H87,C50+A98-1)*TW_RefLat/B50,"")   | =IF(A98<=D51,INDEX(I58:I87,C51+A98-1)*TW_RefLat/B51,"")   | =IF(A98<=D52,INDEX(J58:J87,C52+A98-1)*TW_RefLat/B52,"")   | =IF(A98<=D53,INDEX(K58:K87,C53+A98-1)*TW_RefLat/B53,"")   | =COUNT(B98:K98)   | =(A98/MAX(TW_K))^TW_WPow  | =PERCENTILE.INC(B98:K98,TW_PLow)   | =PERCENTILE.INC(B98:K98,TW_PMid)   | =PERCENTILE.INC(B98:K98,TW_PHigh)   | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A98)  | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A98)  | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A98)  |
| 99  | =8                                                                                                                                                                                                     | =IF(A99<=D44,INDEX(B58:B87,C44+A99-1)*TW_RefLat/B44,"")           | =IF(A99<=D45,INDEX(C58:C87,C45+A99-1)*TW_RefLat/B45,"")                                                                                                                                                                                                  | =IF(A99<=D46,INDEX(D58:D87,C46+A99-1)*TW_RefLat/B46,"")   | =IF(A99<=D47,INDEX(E58:E87,C47+A99-1)*TW_RefLat/B47,"")   | =IF(A99<=D48,INDEX(F58:F87,C48+A99-1)*TW_RefLat/B48,"")   | =IF(A99<=D49,INDEX(G58:G87,C49+A99-1)*TW_RefLat/B49,"")   | =IF(A99<=D50,INDEX(H58:H87,C50+A99-1)*TW_RefLat/B50,"")   | =IF(A99<=D51,INDEX(I58:I87,C51+A99-1)*TW_RefLat/B51,"")   | =IF(A99<=D52,INDEX(J58:J87,C52+A99-1)*TW_RefLat/B52,"")   | =IF(A99<=D53,INDEX(K58:K87,C53+A99-1)*TW_RefLat/B53,"")   | =COUNT(B99:K99)   | =(A99/MAX(TW_K))^TW_WPow  | =PERCENTILE.INC(B99:K99,TW_PLow)   | =PERCENTILE.INC(B99:K99,TW_PMid)   | =PERCENTILE.INC(B99:K99,TW_PHigh)   | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A99)  | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A99)  | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A99)  |
| 100 | =9                                                                                                                                                                                                     | =IF(A100<=D44,INDEX(B58:B87,C44+A100-1)*TW_RefLat/B44,"")         | =IF(A100<=D45,INDEX(C58:C87,C45+A100-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A100<=D46,INDEX(D58:D87,C46+A100-1)*TW_RefLat/B46,"") | =IF(A100<=D47,INDEX(E58:E87,C47+A100-1)*TW_RefLat/B47,"") | =IF(A100<=D48,INDEX(F58:F87,C48+A100-1)*TW_RefLat/B48,"") | =IF(A100<=D49,INDEX(G58:G87,C49+A100-1)*TW_RefLat/B49,"") | =IF(A100<=D50,INDEX(H58:H87,C50+A100-1)*TW_RefLat/B50,"") | =IF(A100<=D51,INDEX(I58:I87,C51+A100-1)*TW_RefLat/B51,"") | =IF(A100<=D52,INDEX(J58:J87,C52+A100-1)*TW_RefLat/B52,"") | =IF(A100<=D53,INDEX(K58:K87,C53+A100-1)*TW_RefLat/B53,"") | =COUNT(B100:K100) | =(A100/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B100:K100,TW_PLow) | =PERCENTILE.INC(B100:K100,TW_PMid) | =PERCENTILE.INC(B100:K100,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A100) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A100) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A100) |
| 101 | =10                                                                                                                                                                                                    | =IF(A101<=D44,INDEX(B58:B87,C44+A101-1)*TW_RefLat/B44,"")         | =IF(A101<=D45,INDEX(C58:C87,C45+A101-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A101<=D46,INDEX(D58:D87,C46+A101-1)*TW_RefLat/B46,"") | =IF(A101<=D47,INDEX(E58:E87,C47+A101-1)*TW_RefLat/B47,"") | =IF(A101<=D48,INDEX(F58:F87,C48+A101-1)*TW_RefLat/B48,"") | =IF(A101<=D49,INDEX(G58:G87,C49+A101-1)*TW_RefLat/B49,"") | =IF(A101<=D50,INDEX(H58:H87,C50+A101-1)*TW_RefLat/B50,"") | =IF(A101<=D51,INDEX(I58:I87,C51+A101-1)*TW_RefLat/B51,"") | =IF(A101<=D52,INDEX(J58:J87,C52+A101-1)*TW_RefLat/B52,"") | =IF(A101<=D53,INDEX(K58:K87,C53+A101-1)*TW_RefLat/B53,"") | =COUNT(B101:K101) | =(A101/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B101:K101,TW_PLow) | =PERCENTILE.INC(B101:K101,TW_PMid) | =PERCENTILE.INC(B101:K101,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A101) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A101) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A101) |
| 102 | =11                                                                                                                                                                                                    | =IF(A102<=D44,INDEX(B58:B87,C44+A102-1)*TW_RefLat/B44,"")         | =IF(A102<=D45,INDEX(C58:C87,C45+A102-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A102<=D46,INDEX(D58:D87,C46+A102-1)*TW_RefLat/B46,"") | =IF(A102<=D47,INDEX(E58:E87,C47+A102-1)*TW_RefLat/B47,"") | =IF(A102<=D48,INDEX(F58:F87,C48+A102-1)*TW_RefLat/B48,"") | =IF(A102<=D49,INDEX(G58:G87,C49+A102-1)*TW_RefLat/B49,"") | =IF(A102<=D50,INDEX(H58:H87,C50+A102-1)*TW_RefLat/B50,"") | =IF(A102<=D51,INDEX(I58:I87,C51+A102-1)*TW_RefLat/B51,"") | =IF(A102<=D52,INDEX(J58:J87,C52+A102-1)*TW_RefLat/B52,"") | =IF(A102<=D53,INDEX(K58:K87,C53+A102-1)*TW_RefLat/B53,"") | =COUNT(B102:K102) | =(A102/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B102:K102,TW_PLow) | =PERCENTILE.INC(B102:K102,TW_PMid) | =PERCENTILE.INC(B102:K102,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A102) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A102) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A102) |
| 103 | =12                                                                                                                                                                                                    | =IF(A103<=D44,INDEX(B58:B87,C44+A103-1)*TW_RefLat/B44,"")         | =IF(A103<=D45,INDEX(C58:C87,C45+A103-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A103<=D46,INDEX(D58:D87,C46+A103-1)*TW_RefLat/B46,"") | =IF(A103<=D47,INDEX(E58:E87,C47+A103-1)*TW_RefLat/B47,"") | =IF(A103<=D48,INDEX(F58:F87,C48+A103-1)*TW_RefLat/B48,"") | =IF(A103<=D49,INDEX(G58:G87,C49+A103-1)*TW_RefLat/B49,"") | =IF(A103<=D50,INDEX(H58:H87,C50+A103-1)*TW_RefLat/B50,"") | =IF(A103<=D51,INDEX(I58:I87,C51+A103-1)*TW_RefLat/B51,"") | =IF(A103<=D52,INDEX(J58:J87,C52+A103-1)*TW_RefLat/B52,"") | =IF(A103<=D53,INDEX(K58:K87,C53+A103-1)*TW_RefLat/B53,"") | =COUNT(B103:K103) | =(A103/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B103:K103,TW_PLow) | =PERCENTILE.INC(B103:K103,TW_PMid) | =PERCENTILE.INC(B103:K103,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A103) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A103) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A103) |
| 104 | =13                                                                                                                                                                                                    | =IF(A104<=D44,INDEX(B58:B87,C44+A104-1)*TW_RefLat/B44,"")         | =IF(A104<=D45,INDEX(C58:C87,C45+A104-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A104<=D46,INDEX(D58:D87,C46+A104-1)*TW_RefLat/B46,"") | =IF(A104<=D47,INDEX(E58:E87,C47+A104-1)*TW_RefLat/B47,"") | =IF(A104<=D48,INDEX(F58:F87,C48+A104-1)*TW_RefLat/B48,"") | =IF(A104<=D49,INDEX(G58:G87,C49+A104-1)*TW_RefLat/B49,"") | =IF(A104<=D50,INDEX(H58:H87,C50+A104-1)*TW_RefLat/B50,"") | =IF(A104<=D51,INDEX(I58:I87,C51+A104-1)*TW_RefLat/B51,"") | =IF(A104<=D52,INDEX(J58:J87,C52+A104-1)*TW_RefLat/B52,"") | =IF(A104<=D53,INDEX(K58:K87,C53+A104-1)*TW_RefLat/B53,"") | =COUNT(B104:K104) | =(A104/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B104:K104,TW_PLow) | =PERCENTILE.INC(B104:K104,TW_PMid) | =PERCENTILE.INC(B104:K104,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A104) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A104) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A104) |
| 105 | =14                                                                                                                                                                                                    | =IF(A105<=D44,INDEX(B58:B87,C44+A105-1)*TW_RefLat/B44,"")         | =IF(A105<=D45,INDEX(C58:C87,C45+A105-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A105<=D46,INDEX(D58:D87,C46+A105-1)*TW_RefLat/B46,"") | =IF(A105<=D47,INDEX(E58:E87,C47+A105-1)*TW_RefLat/B47,"") | =IF(A105<=D48,INDEX(F58:F87,C48+A105-1)*TW_RefLat/B48,"") | =IF(A105<=D49,INDEX(G58:G87,C49+A105-1)*TW_RefLat/B49,"") | =IF(A105<=D50,INDEX(H58:H87,C50+A105-1)*TW_RefLat/B50,"") | =IF(A105<=D51,INDEX(I58:I87,C51+A105-1)*TW_RefLat/B51,"") | =IF(A105<=D52,INDEX(J58:J87,C52+A105-1)*TW_RefLat/B52,"") | =IF(A105<=D53,INDEX(K58:K87,C53+A105-1)*TW_RefLat/B53,"") | =COUNT(B105:K105) | =(A105/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B105:K105,TW_PLow) | =PERCENTILE.INC(B105:K105,TW_PMid) | =PERCENTILE.INC(B105:K105,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A105) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A105) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A105) |
| 106 | =15                                                                                                                                                                                                    | =IF(A106<=D44,INDEX(B58:B87,C44+A106-1)*TW_RefLat/B44,"")         | =IF(A106<=D45,INDEX(C58:C87,C45+A106-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A106<=D46,INDEX(D58:D87,C46+A106-1)*TW_RefLat/B46,"") | =IF(A106<=D47,INDEX(E58:E87,C47+A106-1)*TW_RefLat/B47,"") | =IF(A106<=D48,INDEX(F58:F87,C48+A106-1)*TW_RefLat/B48,"") | =IF(A106<=D49,INDEX(G58:G87,C49+A106-1)*TW_RefLat/B49,"") | =IF(A106<=D50,INDEX(H58:H87,C50+A106-1)*TW_RefLat/B50,"") | =IF(A106<=D51,INDEX(I58:I87,C51+A106-1)*TW_RefLat/B51,"") | =IF(A106<=D52,INDEX(J58:J87,C52+A106-1)*TW_RefLat/B52,"") | =IF(A106<=D53,INDEX(K58:K87,C53+A106-1)*TW_RefLat/B53,"") | =COUNT(B106:K106) | =(A106/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B106:K106,TW_PLow) | =PERCENTILE.INC(B106:K106,TW_PMid) | =PERCENTILE.INC(B106:K106,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A106) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A106) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A106) |
| 107 | =16                                                                                                                                                                                                    | =IF(A107<=D44,INDEX(B58:B87,C44+A107-1)*TW_RefLat/B44,"")         | =IF(A107<=D45,INDEX(C58:C87,C45+A107-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A107<=D46,INDEX(D58:D87,C46+A107-1)*TW_RefLat/B46,"") | =IF(A107<=D47,INDEX(E58:E87,C47+A107-1)*TW_RefLat/B47,"") | =IF(A107<=D48,INDEX(F58:F87,C48+A107-1)*TW_RefLat/B48,"") | =IF(A107<=D49,INDEX(G58:G87,C49+A107-1)*TW_RefLat/B49,"") | =IF(A107<=D50,INDEX(H58:H87,C50+A107-1)*TW_RefLat/B50,"") | =IF(A107<=D51,INDEX(I58:I87,C51+A107-1)*TW_RefLat/B51,"") | =IF(A107<=D52,INDEX(J58:J87,C52+A107-1)*TW_RefLat/B52,"") | =IF(A107<=D53,INDEX(K58:K87,C53+A107-1)*TW_RefLat/B53,"") | =COUNT(B107:K107) | =(A107/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B107:K107,TW_PLow) | =PERCENTILE.INC(B107:K107,TW_PMid) | =PERCENTILE.INC(B107:K107,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A107) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A107) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A107) |
| 108 | =17                                                                                                                                                                                                    | =IF(A108<=D44,INDEX(B58:B87,C44+A108-1)*TW_RefLat/B44,"")         | =IF(A108<=D45,INDEX(C58:C87,C45+A108-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A108<=D46,INDEX(D58:D87,C46+A108-1)*TW_RefLat/B46,"") | =IF(A108<=D47,INDEX(E58:E87,C47+A108-1)*TW_RefLat/B47,"") | =IF(A108<=D48,INDEX(F58:F87,C48+A108-1)*TW_RefLat/B48,"") | =IF(A108<=D49,INDEX(G58:G87,C49+A108-1)*TW_RefLat/B49,"") | =IF(A108<=D50,INDEX(H58:H87,C50+A108-1)*TW_RefLat/B50,"") | =IF(A108<=D51,INDEX(I58:I87,C51+A108-1)*TW_RefLat/B51,"") | =IF(A108<=D52,INDEX(J58:J87,C52+A108-1)*TW_RefLat/B52,"") | =IF(A108<=D53,INDEX(K58:K87,C53+A108-1)*TW_RefLat/B53,"") | =COUNT(B108:K108) | =(A108/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B108:K108,TW_PLow) | =PERCENTILE.INC(B108:K108,TW_PMid) | =PERCENTILE.INC(B108:K108,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A108) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A108) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A108) |
| 109 | =18                                                                                                                                                                                                    | =IF(A109<=D44,INDEX(B58:B87,C44+A109-1)*TW_RefLat/B44,"")         | =IF(A109<=D45,INDEX(C58:C87,C45+A109-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A109<=D46,INDEX(D58:D87,C46+A109-1)*TW_RefLat/B46,"") | =IF(A109<=D47,INDEX(E58:E87,C47+A109-1)*TW_RefLat/B47,"") | =IF(A109<=D48,INDEX(F58:F87,C48+A109-1)*TW_RefLat/B48,"") | =IF(A109<=D49,INDEX(G58:G87,C49+A109-1)*TW_RefLat/B49,"") | =IF(A109<=D50,INDEX(H58:H87,C50+A109-1)*TW_RefLat/B50,"") | =IF(A109<=D51,INDEX(I58:I87,C51+A109-1)*TW_RefLat/B51,"") | =IF(A109<=D52,INDEX(J58:J87,C52+A109-1)*TW_RefLat/B52,"") | =IF(A109<=D53,INDEX(K58:K87,C53+A109-1)*TW_RefLat/B53,"") | =COUNT(B109:K109) | =(A109/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B109:K109,TW_PLow) | =PERCENTILE.INC(B109:K109,TW_PMid) | =PERCENTILE.INC(B109:K109,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A109) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A109) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A109) |
| 110 | =19                                                                                                                                                                                                    | =IF(A110<=D44,INDEX(B58:B87,C44+A110-1)*TW_RefLat/B44,"")         | =IF(A110<=D45,INDEX(C58:C87,C45+A110-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A110<=D46,INDEX(D58:D87,C46+A110-1)*TW_RefLat/B46,"") | =IF(A110<=D47,INDEX(E58:E87,C47+A110-1)*TW_RefLat/B47,"") | =IF(A110<=D48,INDEX(F58:F87,C48+A110-1)*TW_RefLat/B48,"") | =IF(A110<=D49,INDEX(G58:G87,C49+A110-1)*TW_RefLat/B49,"") | =IF(A110<=D50,INDEX(H58:H87,C50+A110-1)*TW_RefLat/B50,"") | =IF(A110<=D51,INDEX(I58:I87,C51+A110-1)*TW_RefLat/B51,"") | =IF(A110<=D52,INDEX(J58:J87,C52+A110-1)*TW_RefLat/B52,"") | =IF(A110<=D53,INDEX(K58:K87,C53+A110-1)*TW_RefLat/B53,"") | =COUNT(B110:K110) | =(A110/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B110:K110,TW_PLow) | =PERCENTILE.INC(B110:K110,TW_PMid) | =PERCENTILE.INC(B110:K110,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A110) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A110) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A110) |
| 111 | =20                                                                                                                                                                                                    | =IF(A111<=D44,INDEX(B58:B87,C44+A111-1)*TW_RefLat/B44,"")         | =IF(A111<=D45,INDEX(C58:C87,C45+A111-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A111<=D46,INDEX(D58:D87,C46+A111-1)*TW_RefLat/B46,"") | =IF(A111<=D47,INDEX(E58:E87,C47+A111-1)*TW_RefLat/B47,"") | =IF(A111<=D48,INDEX(F58:F87,C48+A111-1)*TW_RefLat/B48,"") | =IF(A111<=D49,INDEX(G58:G87,C49+A111-1)*TW_RefLat/B49,"") | =IF(A111<=D50,INDEX(H58:H87,C50+A111-1)*TW_RefLat/B50,"") | =IF(A111<=D51,INDEX(I58:I87,C51+A111-1)*TW_RefLat/B51,"") | =IF(A111<=D52,INDEX(J58:J87,C52+A111-1)*TW_RefLat/B52,"") | =IF(A111<=D53,INDEX(K58:K87,C53+A111-1)*TW_RefLat/B53,"") | =COUNT(B111:K111) | =(A111/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B111:K111,TW_PLow) | =PERCENTILE.INC(B111:K111,TW_PMid) | =PERCENTILE.INC(B111:K111,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A111) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A111) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A111) |
| 112 | =21                                                                                                                                                                                                    | =IF(A112<=D44,INDEX(B58:B87,C44+A112-1)*TW_RefLat/B44,"")         | =IF(A112<=D45,INDEX(C58:C87,C45+A112-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A112<=D46,INDEX(D58:D87,C46+A112-1)*TW_RefLat/B46,"") | =IF(A112<=D47,INDEX(E58:E87,C47+A112-1)*TW_RefLat/B47,"") | =IF(A112<=D48,INDEX(F58:F87,C48+A112-1)*TW_RefLat/B48,"") | =IF(A112<=D49,INDEX(G58:G87,C49+A112-1)*TW_RefLat/B49,"") | =IF(A112<=D50,INDEX(H58:H87,C50+A112-1)*TW_RefLat/B50,"") | =IF(A112<=D51,INDEX(I58:I87,C51+A112-1)*TW_RefLat/B51,"") | =IF(A112<=D52,INDEX(J58:J87,C52+A112-1)*TW_RefLat/B52,"") | =IF(A112<=D53,INDEX(K58:K87,C53+A112-1)*TW_RefLat/B53,"") | =COUNT(B112:K112) | =(A112/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B112:K112,TW_PLow) | =PERCENTILE.INC(B112:K112,TW_PMid) | =PERCENTILE.INC(B112:K112,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A112) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A112) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A112) |
| 113 | =22                                                                                                                                                                                                    | =IF(A113<=D44,INDEX(B58:B87,C44+A113-1)*TW_RefLat/B44,"")         | =IF(A113<=D45,INDEX(C58:C87,C45+A113-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A113<=D46,INDEX(D58:D87,C46+A113-1)*TW_RefLat/B46,"") | =IF(A113<=D47,INDEX(E58:E87,C47+A113-1)*TW_RefLat/B47,"") | =IF(A113<=D48,INDEX(F58:F87,C48+A113-1)*TW_RefLat/B48,"") | =IF(A113<=D49,INDEX(G58:G87,C49+A113-1)*TW_RefLat/B49,"") | =IF(A113<=D50,INDEX(H58:H87,C50+A113-1)*TW_RefLat/B50,"") | =IF(A113<=D51,INDEX(I58:I87,C51+A113-1)*TW_RefLat/B51,"") | =IF(A113<=D52,INDEX(J58:J87,C52+A113-1)*TW_RefLat/B52,"") | =IF(A113<=D53,INDEX(K58:K87,C53+A113-1)*TW_RefLat/B53,"") | =COUNT(B113:K113) | =(A113/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B113:K113,TW_PLow) | =PERCENTILE.INC(B113:K113,TW_PMid) | =PERCENTILE.INC(B113:K113,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A113) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A113) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A113) |
| 114 | =23                                                                                                                                                                                                    | =IF(A114<=D44,INDEX(B58:B87,C44+A114-1)*TW_RefLat/B44,"")         | =IF(A114<=D45,INDEX(C58:C87,C45+A114-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A114<=D46,INDEX(D58:D87,C46+A114-1)*TW_RefLat/B46,"") | =IF(A114<=D47,INDEX(E58:E87,C47+A114-1)*TW_RefLat/B47,"") | =IF(A114<=D48,INDEX(F58:F87,C48+A114-1)*TW_RefLat/B48,"") | =IF(A114<=D49,INDEX(G58:G87,C49+A114-1)*TW_RefLat/B49,"") | =IF(A114<=D50,INDEX(H58:H87,C50+A114-1)*TW_RefLat/B50,"") | =IF(A114<=D51,INDEX(I58:I87,C51+A114-1)*TW_RefLat/B51,"") | =IF(A114<=D52,INDEX(J58:J87,C52+A114-1)*TW_RefLat/B52,"") | =IF(A114<=D53,INDEX(K58:K87,C53+A114-1)*TW_RefLat/B53,"") | =COUNT(B114:K114) | =(A114/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B114:K114,TW_PLow) | =PERCENTILE.INC(B114:K114,TW_PMid) | =PERCENTILE.INC(B114:K114,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A114) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A114) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A114) |
| 115 | =24                                                                                                                                                                                                    | =IF(A115<=D44,INDEX(B58:B87,C44+A115-1)*TW_RefLat/B44,"")         | =IF(A115<=D45,INDEX(C58:C87,C45+A115-1)*TW_RefLat/B45,"")                                                                                                                                                                                                | =IF(A115<=D46,INDEX(D58:D87,C46+A115-1)*TW_RefLat/B46,"") | =IF(A115<=D47,INDEX(E58:E87,C47+A115-1)*TW_RefLat/B47,"") | =IF(A115<=D48,INDEX(F58:F87,C48+A115-1)*TW_RefLat/B48,"") | =IF(A115<=D49,INDEX(G58:G87,C49+A115-1)*TW_RefLat/B49,"") | =IF(A115<=D50,INDEX(H58:H87,C50+A115-1)*TW_RefLat/B50,"") | =IF(A115<=D51,INDEX(I58:I87,C51+A115-1)*TW_RefLat/B51,"") | =IF(A115<=D52,INDEX(J58:J87,C52+A115-1)*TW_RefLat/B52,"") | =IF(A115<=D53,INDEX(K58:K87,C53+A115-1)*TW_RefLat/B53,"") | =COUNT(B115:K115) | =(A115/MAX(TW_K))^TW_WPow | =PERCENTILE.INC(B115:K115,TW_PLow) | =PERCENTILE.INC(B115:K115,TW_PMid) | =PERCENTILE.INC(B115:K115,TW_PHigh) | =PO.DCA.Arps.Rate(TW_P90Qi,TW_P90DiM,TW_P90B,A115) | =PO.DCA.Arps.Rate(TW_P50Qi,TW_P50DiM,TW_P50B,A115) | =PO.DCA.Arps.Rate(TW_P10Qi,TW_P10DiM,TW_P10B,A115) |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.RES.MC.Percentiles | =LAMBDA(X, HSTACK(PERCENTILE.INC(X, 0.1), PERCENTILE.INC(X, 0.5), PERCENTILE.INC(X, 0.9), AVERAGE(X))) | P90, P50, P10 (petroleum convention: P90 the low case, exceeded 90% of the time) and the mean of a column of outcomes; linear interpolation as PERCENTILE.INC. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| TW_RefLat | $B$4 | Lateral length the wells are scaled to, ft |
| TW_WPow | $B$5 | Fits' late-time weight exponent (0 weighs months alike) |
| TW_QEcon | $B$6 | Economic-limit oil rate, STB/d |
| TW_MinWells | $B$7 | Fewest wells a month's percentiles should rest on, wells |
| TW_FitMax | $B$8 | Largest fit mismatch allowed (RMSE over mean rate), % |
| TW_CumBand | $B$9 | Largest gap, P50 curve's cumulative to the wells' P50, % |
| TW_Inputs | $B$4:$B$9 | The lateral the wells are scaled to, the fits' late-time weight exponent, the economic limit, the fewest wells a month needs, the fit mismatch allowed and the cumulative gap allowed |
| TW_MoYr | $B$33 | Months in a year, months/yr |
| TW_DMo | $B$34 | Days in a month, 365.25/12, days/month |
| TW_PLow | $B$35 | Percentile of the P90 (low) curve |
| TW_PMid | $B$36 | Percentile of the P50 curve |
| TW_PHigh | $B$37 | Percentile of the P10 (high) curve |
| TW_BPos | $B$38 | Position of b in PO.DCA.Arps.WFit's output |
| TW_P10Pos | $B$39 | Position of P10 in PO.RES.MC.Percentiles' output |
| TW_MeanPos | $B$40 | Position of the mean in PO.RES.MC.Percentiles' output |
| TW_Wells | $A$44:$E$53 | Each well's name and lateral length, its first producing calendar month, its producing months and its scaled 24-month cumulative |
| TW_Lat | $B$44:$B$53 | Each well's lateral length, ft |
| TW_Cums | $E$44:$E$53 | Each well's scaled 24-month cumulative, MSTB |
| TW_Calendar | $A$58:$K$87 | Each well's oil rate in each calendar month, 0 before it came online |
| TW_M | $A$58:$A$87 | Calendar months, 1 to 30 |
| TW_Aligned | $A$92:$S$115 | Each producing month, each well's rate scaled to the reference lateral, the wells that month, the fits' weight, the P90, P50 and P10 rates and the three Arps fits |
| TW_K | $A$92:$A$115 | Producing months, 1 to 24 |
| TW_Count | $L$92:$L$115 | Wells with a rate in each producing month |
| TW_W | $M$92:$M$115 | The fits' weight for each month |
| TW_P90 | $N$92:$N$115 | The P90 (low) type curve's rate each month, STB/d |
| TW_FitP90 | $Q$92:$Q$115 | The P90 (low) Arps fit's rate each month, STB/d |
| TW_P50 | $O$92:$O$115 | The P50 type curve's rate each month, STB/d |
| TW_FitP50 | $R$92:$R$115 | The P50 Arps fit's rate each month, STB/d |
| TW_P10 | $P$92:$P$115 | The P10 (high) type curve's rate each month, STB/d |
| TW_FitP10 | $S$92:$S$115 | The P10 (high) Arps fit's rate each month, STB/d |
| TW_Fits | $A$13:$H$15 | Each type curve's Arps qi, Di per month and per year and b, its EUR to the economic limit, its 24-month cumulative and its fit's RMSE over its mean rate |
| TW_P90Qi | $B$13 | P90 type curve's fitted qi, STB/d |
| TW_P90DiM | $C$13 | P90 type curve's fitted Di, 1/month |
| TW_P90Di | $D$13 | P90 type curve's fitted Di, 1/yr |
| TW_P90B | $E$13 | P90 type curve's fitted b |
| TW_P90EUR | $F$13 | P90 type curve's EUR to the economic limit, MSTB |
| TW_P90Cum | $G$13 | P90 type curve's 24-month cumulative, MSTB |
| TW_P90Err | $H$13 | P90 fit's RMSE over the curve's mean rate |
| TW_P50Qi | $B$14 | P50 type curve's fitted qi, STB/d |
| TW_P50DiM | $C$14 | P50 type curve's fitted Di, 1/month |
| TW_P50Di | $D$14 | P50 type curve's fitted Di, 1/yr |
| TW_P50B | $E$14 | P50 type curve's fitted b |
| TW_P50EUR | $F$14 | P50 type curve's EUR to the economic limit, MSTB |
| TW_P50Cum | $G$14 | P50 type curve's 24-month cumulative, MSTB |
| TW_P50Err | $H$14 | P50 fit's RMSE over the curve's mean rate |
| TW_P10Qi | $B$15 | P10 type curve's fitted qi, STB/d |
| TW_P10DiM | $C$15 | P10 type curve's fitted Di, 1/month |
| TW_P10Di | $D$15 | P10 type curve's fitted Di, 1/yr |
| TW_P10B | $E$15 | P10 type curve's fitted b |
| TW_P10EUR | $F$15 | P10 type curve's EUR to the economic limit, MSTB |
| TW_P10Cum | $G$15 | P10 type curve's 24-month cumulative, MSTB |
| TW_P10Err | $H$15 | P10 fit's RMSE over the curve's mean rate |
| TW_NWells | $B$18 | Wells in the set, wells |
| TW_NMin | $B$19 | Fewest wells behind any month's percentiles, wells |
| TW_CumP90 | $B$20 | Wells' own 24-month cumulative, P90 (low), MSTB |
| TW_CumP50 | $B$21 | Wells' own 24-month cumulative, P50, MSTB |
| TW_CumP10 | $B$22 | Wells' own 24-month cumulative, P10 (high), MSTB |
| TW_CumMean | $B$23 | Wells' own 24-month cumulative, mean, MSTB |
| TW_EurRatio | $B$24 | EUR spread, P10 over P90 |
| TW_CumGap | $B$25 | P50 curve's 24-month cum over the wells' P50, less 1, % |
| TW_WorstErr | $B$26 | Worst fit's RMSE over its mean rate, % |
| TW_WellsCheck | $B$27 | Well count check verdict |
| TW_WellsCheckNote | $C$27 | Well count check comment |
| TW_FitCheck | $B$28 | Fit check verdict |
| TW_FitCheckNote | $C$28 | Fit check comment |
| TW_OrderCheck | $B$29 | Percentile order check verdict |
| TW_OrderCheckNote | $C$29 | Percentile order check comment |
| TW_CumCheck | $B$30 | Cumulative check verdict |
| TW_CumCheckNote | $C$30 | Cumulative check comment |
| TW_Results | $B$18:$B$30 | The wells in the set and the fewest behind any month, the wells' own 24-month cumulative percentiles and mean, the EUR spread, the P50 curve's gap to the wells' P50, the worst fit, and the four checks |

---

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

