Description
Has this oil well's rate fallen below its decline, or its gas-oil ratio (GOR), water-oil ratio (WOR) or observed productivity index (PI) moved enough to look into? You enter monthly oil rates, four well tests and your screening limits. You read off an exponential decline fit, each trend against its limit and the candidate reason, beside four independent references: an Arps forecast, a waterflood producer's WOR, vertical oil inflow and gas-well loading. These synthetic examples are not a matched field.
How to use it: Replace the yellow inputs and synthetic observations with consistent measurements. On the Well trends sheet, calculate oil rate from produced volume and producing days, checking allocation and downtime; enter the true first producing month (1–7 in this layout), all required rates, and the four tests' GOR, water cut and reservoir and flowing pressures. Invalid tests or first months fail the data check; calculation-safe substitute rates are not results. For PI, use representative reservoir and stabilized flowing pressures above the bubble point with positive drawdown. Each reference sheet has its own inputs; changing one does not change the others. Gas loading is not inferred from the oil well's GOR. The Summary combines the candidate reasons and every check for review, not automatic intervention.
Method: Well trends uses A-3's 30 synthetic type-well oil rates and month-30 GOR and water cut. The tests at the selected first month and months 12, 21 and 30, the fluid trajectories, the pressures and the imposed month-30 rate loss are invented; yellow rate and test formulas are editable, and pressures depend on rates. A log-rate fit to the first 24 producing months gives an exponential Arps baseline (b = 0) with nonnegative decline. The latest rate is compared with the fit, and GOR, WOR and observed PI with the first test. WOR = water cut / (1 - water cut); PI = oil rate / pressure drawdown. Thresholds are screening choices, not diagnostic limits.
The Arps reference is an independent decline example. The DWS waterflood reference uses Chan's derivative and extrapolates log WOR to an economic limit at constant liquid rate and costs. The separate single-phase inflow model computes PI, the skin split and the potential gain on damage removal, not A-3's observed PI. The independent gas example compares Turner, Coleman and Li critical rates along the tubing and against gas decline.
Example: With the independent reference defaults (the WOR trend from month 12 and the Arps reference's nominal decline of 1.89 per year), the 24-month WOR history gives an economic cumulative oil of approximately 3,287,690.6 STB, while the separate Arps reference gives an EUR of approximately 720.162 MSTB. These are synthetic reference results, not a forecast for A-3.
Validity
Illustrative pressures exceed the 2620 psi bubble point; test conditions and pressure uncertainty can mimic a PI trend. The exponential fit screens, it does not forecast reserves; fit representative production and investigate outliers. A rate, GOR, WOR or PI flag does not prove a cause. Chan signatures are empirical and WOR extrapolation may not persist. Inflow assumes single-phase pseudosteady radial flow; skin decomposition does not prove treatment response. Loading assumes the entered water properties, fixed wellhead pressure and Arps decline; confirm with a stabilized gas test and flowing gradient. Review uncertainty and economics before action.
References
- Arps, J.J. (1945). Analysis of Decline Curves. Transactions of the AIME, 160, 228-247.
- Chan, K.S. (1995). Water Control Diagnostic Plots. SPE 30775.
- Turner, R.G., Hubbard, M.G. and Dukler, A.E. (1969). Analysis and Prediction of Minimum Flow Rate for the Continuous Removal of Liquids from Gas Wells. SPE 2198.
Inputs
| Input | Unit | Default | Name |
|---|---|---|---|
| First month (Well trends fit table) | month | 2 | PSH_Start1 |
| Rate below fitted decline, GOR rise over first test, WOR rise over first test, observed PI fall from first test | fraction | 0.20, 0.25, 0.50, 0.20 | PSH_RateDrop, PSH_GorRise, PSH_WorRise, PSH_PiDrop |
| Bubble point for test validity | psi | 2620 | PSH_Pb |
| Initial oil rate, nominal decline per year, hyperbolic exponent, economic-limit oil rate (Arps reference) | STB/d, 1/year, fraction, STB/d | 1020, 1.89, 0.93, 15 | PSA_qi, PSA_Di, PSA_b, PSA_QEcon |
| Grid step unit, grid step, largest history mismatch | text, months or days, fraction | Monthly, 7, 0.1 | PSA_Basis, PSA_Step, PSA_FitMax |
| Oil at breakthrough, first month of trend, Chan slope threshold | STB, month, fraction | 400000, 12, 0 | PSW_Np0, PSW_FitFrom, PSW_SlopeConing |
| Oil price, royalty, production tax, variable oil cost, fixed monthly cost, liquid handling cost | $/STB, fraction, fraction, $/STB, $/month, $/STB | 70, 0.125, 0.05, 6, 25000, 3 | PSW_Price, PSW_Royalty, PSW_Tax, PSW_Opex, PSW_Fixed, PSW_Lift |
| Oil initially in place, minimum trend R squared | STB, fraction | 8000000, 0.95 | PSW_N, PSW_R2Min |
| Permeability, net pay, oil formation volume factor, oil viscosity, drainage radius, wellbore radius, total skin | mD, ft, rb/STB, cP, ft, ft, fraction | 20, 50, 1.467, 0.302, 1490, 0.354, 5 | PSI_k, PSI_h, PSI_Bo, PSI_Uo, PSI_re, PSI_rw, PSI_s |
| Average reservoir pressure, flowing pressure above bubble point, stabilized test PI | psi, psi, STB/d/psi | 4000, 3000, 1.27 | PSI_Pr, PSI_Pwf, PSI_JTest |
| Open interval, top of pay to top of open interval, vertical to horizontal permeability, perforation skin | ft, ft, fraction, skin | 40, 0, 0.1, 0.5 | PSI_hp, PSI_htop, PSI_kvkh, PSI_sp |
| Altered-zone permeability and radius | mD, ft | 8, 2 | PSI_ks, PSI_rs |
| PI mismatch tolerance, Hawkins versus split tolerance, damage skin screening threshold | fraction, skin, skin | 0.1, 0.5, 1 | PSI_JTol, PSI_sTol, PSI_sdMax |
| Gas specific gravity, depth of perforations, tubing inner diameter, tubing relative roughness | fraction, ft, in, fraction | 0.7, 7500, 2.441, 0.0006 | PSL_SGg, PSL_TVD, PSL_ID, PSL_Rough |
| Flowing wellhead pressure, flowing wellhead temperature, temperature at perforations | psia, F, F | 1200, 100, 160 | PSL_Pwh, PSL_Twh, PSL_Tbh |
| Liquid density, liquid-gas surface tension | lb/ft3, dyne/cm | 67, 60 | PSL_RhoL, PSL_IFT |
| Gas rate today, nominal decline rate, Arps exponent | MMscf/d, 1/year, fraction | 8.21, 0.35, 0.5 | PSL_Qg, PSL_Di, PSL_b |
| Turner velocity adjustment, lead time for lift | fraction, years | 1.2, 2 | PSL_TurnerF, PSL_Lead |
Editable tables: Well trends B25:B54 contains 30 monthly oil rates, and C59:F62 contains four GOR, water-cut, reservoir-pressure and flowing-pressure tests. The Arps reference A36:A59 and C36:C59 contain 24 history times and oil rates. WOR diagnostics A51:C74 contains 24 independent time, oil and water observations. Inflow reference A61:A73 contains the skin sweep. Each reference has its own inputs; changing one does not change the others.
Sheets
Guide— synthetic scope, workflow and interpretation.Well trends— one oil well's rate, GOR, WOR and observed-PI histories, the exponential decline fit and the candidate reason.Arps reference— an independent calibrated Arps decline history and forecast to the economic limit.WOR diagnostics— an independent DWS waterflood producer's Chan derivative and its WOR extrapolated to an economic limit.Inflow reference— an independent vertical oil well's PI, skin split and skin sensitivity.Gas loading— an independent gas well's tubing profile, Turner, Coleman and Li critical rates, and decline.Summary— candidate reasons, reference highlights and every named check; a fail overrides a warning.Test Cases— the worked example and other cases, with expected and computed results.
Functions used
PO.DCA.Arps.RatePO.DCA.Convert.NominalToEffectivePO.Stats.RMSEPO.IPR.VW.PSS.PIPO.IPR.VW.PSS.RatePO.IPR.RwaPO.PVT.Z.ByDAKPO.PVT.Ppc.BySuttonPO.PVT.Tpc.BySuttonPO.PVT.Bg.ByDefinitionPO.PVT.Ug.ByLGEPO.VFP.Gas.PinPO.FA.Erosion.VmixPO.DCA.Arps.SecantEffPO.PE.Chan.WORDerivativePO.RES.Reserves.EconLimitPO.CO.Damage.HawkinsPO.CO.Damage.DecompositionPO.CO.Damage.FlowPO.PE.Loading.TurnerRatePO.PE.Loading.LiRate
Names (182)
| Name | Refers to | Comment |
|---|---|---|
PO.CO.Damage.DecompositionLAMBDA |
=LAMBDA(s_t, s_p, h, h_p, h_top, r_w, kv_kh, IF((h<=0)+(h_p<=0)+(h_p>h)+(h_top<0)+(h_top+h_p>h)+(r_w<=0)+(kv_kh<=0), NA(), LET(hp_d, h_p/h, ht_d, h_top/h, r_d, r_w/h*SQRT(kv_kh), a_term, 1/(ht_d+hp_d/4), b_term, 1/(ht_d+3*hp_d/4), s_c, (1/hp_d-1)*LN(PI()/(2*r_d))+1/hp_d*LN(hp_d/(2+hp_d)*SQRT((a_term-1)/(b_term-1))), hp_d*(s_t-s_c)-s_p))) |
Damage skin s_d left in a test's total skin s_t: (h_p/h)*(s_t - s_c) - s_p (Saidikowski), s_c the Papatzacos partial-penetration skin of h_p ft open h_top ft below the top of h ft of pay, s_p the perforation skin. |
PO.CO.Damage.FlowLAMBDA |
=LAMBDA(j_actual, j_ideal, measure, IF((j_actual<=0)+(j_ideal<=0), NA(), IF(measure="FE", j_actual/j_ideal, IF(measure="DR", j_ideal/j_actual, IF(measure="DF", 1-j_actual/j_ideal, NA()))))) |
Flow efficiency of a well from its PI j_actual and its undamaged PI j_ideal: measure "FE" gives j_actual/j_ideal, "DR" the damage ratio j_ideal/j_actual, "DF" the damage factor 1 - j_actual/j_ideal. |
PO.CO.Damage.HawkinsLAMBDA |
=LAMBDA(k, k_s, r_s, r_w, IF((k<=0)+(k_s<=0)+(r_w<=0)+(r_s<r_w), NA(), (k/k_s-1)*LN(r_s/r_w))) |
Hawkins (1956) skin of an altered zone round the wellbore: (k/k_s - 1)*ln(r_s/r_w). k formation and k_s altered-zone permeability (mD), r_s altered-zone and r_w wellbore radius (ft). Positive when damaged, negative when stimulated. |
PO.DCA.Arps.SecantEffLAMBDA |
=LAMBDA(Di, b, IF(OR(Di<0, b<0), NA(), IF(b=0, 1-EXP(-Di), 1-(1+b*Di)^(-1/b)))) |
Secant effective decline (fraction per period) of an Arps hyperbolic: 1 - (1 + b*Di)^(-1/b), or 1 - exp(-Di) for b = 0. Di is the nominal decline per period (1/yr gives the effective annual decline) and b the exponent. |
PO.PE.Chan.WORDerivativeLAMBDA |
=LAMBDA(time, wor, at, LET(n, COUNT(time), k, MATCH(at, time, 0), k_lo, MAX(1, k-1), k_hi, MIN(n, k+1), t_k, INDEX(time, k), t_lo, INDEX(time, k_lo), t_hi, INDEX(time, k_hi), w_k, INDEX(wor, k), w_lo, INDEX(wor, k_lo), w_hi, INDEX(wor, k_hi), IF(k=1, (w_hi-w_k)/(t_hi-t_k), IF(k=n, (w_k-w_lo)/(t_k-t_lo), ((w_k-w_lo)/(t_k-t_lo)*(t_hi-t_k)+(w_hi-w_k)/(t_hi-t_k)*(t_k-t_lo))/(t_hi-t_lo))))) |
Chan (1995) WOR′: the time derivative of the water-oil ratio at one point of a production history, a three-point difference weighted by the neighbouring intervals, [1/time unit]. |
PO.PE.Loading.LiRateLAMBDA |
=LAMBDA(p_psia, t_degF, sg_gas, tubingID_in, sigma_dyncm, rhoL_lbft3, IF(OR(p_psia<=0, t_degF<=-459.67, sg_gas<=0, tubingID_in<=0, sigma_dyncm<=0, rhoL_lbft3<=0), NA(), LET(tr, t_degF+459.67, z, PO.PVT.Z.ByDAK(p_psia/PO.PVT.Ppc.BySutton(sg_gas), tr/PO.PVT.Tpc.BySutton(sg_gas)), rho_g, PO.PVT.Rho.Gas.ByDefinition(p_psia, tr, sg_gas, z)*62.428, IF(rhoL_lbft3<=rho_g, NA(), 3.06*p_psia*0.72907*sigma_dyncm^0.25*(rhoL_lbft3-rho_g)^0.25/rho_g^0.5*PI()*tubingID_in^2/576/(tr*z))))) |
Li critical gas rate to unload liquid (flat-droplet model), MMscf/d: p_psia and t_degF where it is read, gas gravity sg_gas, tubingID_in, the liquid's sigma_dyncm and rhoL_lbft3. Same order as PO.PE.Loading.TurnerRate. |
PO.PE.Loading.TurnerRateLAMBDA |
=LAMBDA(p, t, sg_g, tubing_id, sigma, rho_l, factor, IF(OR(p<=0, t<=-459.67, sg_g<=0, tubing_id<=0, sigma<=0, rho_l<=0, factor<=0), NA(), LET(tr, t+459.67, z, PO.PVT.Z.ByDAK(p/PO.PVT.Ppc.BySutton(sg_g), tr/PO.PVT.Tpc.BySutton(sg_g)), rho_g, PO.PVT.Rho.Gas.ByDefinition(p, tr, sg_g, z)*62.428, IF(rho_l<=rho_g, NA(), 3.06*p*factor*1.593*sigma^0.25*(rho_l-rho_g)^0.25/rho_g^0.5*PI()*tubing_id^2/576/(tr*z))))) |
Turner critical gas rate to unload liquid, MMscf/d: p (psia) and t (°F) where it is read, usually the wellhead, gas gravity sg_g, tubing_id (in), the liquid's sigma (dyne/cm) and rho_l (lb/ft³), and factor (1.2 Turner, 1 Coleman). |
PO.RES.Reserves.EconLimitLAMBDA |
=LAMBDA(Price, Royalty, Tax, Opex, Fixed, LET(netback, Price*(1-Royalty)*(1-Tax)-Opex, IF(netback>0, Fixed/netback, NA()))) |
Economic-limit rate: fixed cost per period over the netback per unit after royalty, production tax and variable opex; #N/A if the netback is not positive |
PSA_BCheck |
'Arps reference'!$B$28 |
Exponent verdict |
PSA_BCheckNote |
'Arps reference'!$C$28 |
Exponent comment |
PSA_Basis |
'Arps reference'!$B$9 |
Grid step unit |
PSA_DMo |
'Arps reference'!$B$128 |
Days in a month, 365.25/12, days/month |
PSA_DeSec |
'Arps reference'!$B$15 |
Secant effective decline, %/yr |
PSA_Di |
'Arps reference'!$B$5 |
Nominal decline per year, 1/yr |
PSA_EUR |
'Arps reference'!$B$20 |
EUR to economic limit, MSTB |
PSA_FitCheck |
'Arps reference'!$B$29 |
History match verdict |
PSA_FitCheckNote |
'Arps reference'!$C$29 |
History match comment |
PSA_FitMax |
'Arps reference'!$B$11 |
Largest history mismatch, % |
PSA_Forecast |
'Arps reference'!$A$64:$F$76 |
Month, Year, Oil (STB/d), Cumulative (MSTB), EUR (MSTB), Limit (STB/d) |
PSA_GridCheck |
'Arps reference'!$B$30 |
Grid extent verdict |
PSA_GridCheckNote |
'Arps reference'!$C$30 |
Grid extent comment |
PSA_HistQ |
'Arps reference'!$C$36:$C$59 |
History oil rates, STB/d |
PSA_HistT |
'Arps reference'!$A$36:$A$59 |
History times, months |
PSA_History |
'Arps reference'!$A$36:$D$59 |
Time (month), Time (yr), Oil rate (STB/d), Arps (STB/d) |
PSA_Inputs |
'Arps reference'!$B$4:$B$11 |
Arps parameters, economic limit, grid and fit tolerance |
PSA_MoYr |
'Arps reference'!$B$127 |
Months in a year, months/yr |
PSA_Np10 |
'Arps reference'!$B$21 |
Cumulative at ten years, MSTB |
PSA_QEcon |
'Arps reference'!$B$7 |
Economic-limit oil rate, STB/d |
PSA_RelErr |
'Arps reference'!$B$25 |
RMSE over mean rate, % |
PSA_Results |
'Arps reference'!$B$14:$B$30 |
Decline, economic limit, history fit and checks |
PSA_Rows |
'Arps reference'!$B$129 |
Rows of the forecast grid after the first |
PSA_Step |
'Arps reference'!$B$10 |
Grid step |
PSA_TLim |
'Arps reference'!$B$19 |
Time to economic limit, years |
PSA_b |
'Arps reference'!$B$6 |
Hyperbolic exponent |
PSA_qi |
'Arps reference'!$B$4 |
Initial oil rate, STB/d |
PSH_DataCheck |
'Well trends'!$B$16 |
Test validity verdict |
PSH_DataCheckNote |
'Well trends'!$C$16 |
Test validity comment |
PSH_Di1 |
'Well trends'!$D$10 |
Exponential monthly decline |
PSH_Fits |
'Well trends'!$A$10:$G$10 |
Well, First month (month), Fit rate at month zero (STB/d), Fit Di (1/month), Fit b (—), Screening reason, Safe first month |
PSH_GorRise |
'Well trends'!$B$5 |
GOR rise over first test, % |
PSH_Inputs |
'Well trends'!$B$4:$B$7 |
Selected screening thresholds, not diagnostic limits |
PSH_Pb |
'Well trends'!$B$19 |
Bubble point for test validity, psi |
PSH_PiDrop |
'Well trends'!$B$7 |
Observed PI fall from first test, % |
PSH_QNow1 |
'Well trends'!$B$54 |
Last oil rate, STB/d |
PSH_Qi1 |
'Well trends'!$C$10 |
Rate at month zero from exponential fit |
PSH_RateDrop |
'Well trends'!$B$4 |
Rate below fitted decline, % |
PSH_Rates |
'Well trends'!$A$25:$C$54 |
Month, A-3 oil (STB/d), A-3 log |
PSH_Reason1 |
'Well trends'!$F$10 |
Candidate reason |
PSH_Start1 |
'Well trends'!$B$10 |
First producing calendar month |
PSH_Tests |
'Well trends'!$A$59:$I$62 |
Well, Month, GOR (scf/STB), Water cut, Pr (psi), Pwf (psi), WOR, Observed PI, Invalid test |
PSH_TrendCheck |
'Well trends'!$B$17 |
Oil-well trend screen verdict |
PSH_TrendCheckNote |
'Well trends'!$C$17 |
Oil-well trend screen comment |
PSH_WorRise |
'Well trends'!$B$6 |
WOR rise over first test, % |
PSH_b1 |
'Well trends'!$E$10 |
Exponential Arps exponent |
PSI_Bo |
'Inflow reference'!$B$6 |
Oil formation volume factor, bbl/STB |
PSI_DamCheck |
'Inflow reference'!$B$49 |
Damage verdict |
PSI_DamCheckNote |
'Inflow reference'!$C$49 |
Damage comment |
PSI_FE |
'Inflow reference'!$B$29 |
Flow efficiency, % |
PSI_Gain |
'Inflow reference'!$B$46 |
PI gain, % |
PSI_Inputs |
'Inflow reference'!$B$4:$B$24 |
Independent reservoir, fluid, well, completion and check inputs |
PSI_J |
'Inflow reference'!$B$27 |
PI at skin, STB/d/psi |
PSI_JCheck |
'Inflow reference'!$B$47 |
Test PI verdict |
PSI_JCheckNote |
'Inflow reference'!$C$47 |
Test PI comment |
PSI_JTest |
'Inflow reference'!$B$13 |
Stabilized test PI, STB/d/psi |
PSI_JTol |
'Inflow reference'!$B$22 |
PI mismatch tolerance, % |
PSI_JTreat |
'Inflow reference'!$B$45 |
PI after damage removal, STB/d/psi |
PSI_Points |
'Inflow reference'!$A$56:$C$57 |
Point, Skin, PI (STB/d/psi) |
PSI_Pr |
'Inflow reference'!$B$11 |
Average reservoir pressure, psi |
PSI_Pwf |
'Inflow reference'!$B$12 |
Flowing pressure above bubble point, psi |
PSI_Results |
'Inflow reference'!$B$27:$B$49 |
Model PI, skin decomposition, treatment sensitivity and checks |
PSI_SkinSweep |
'Inflow reference'!$A$61:$D$73 |
Skin, PI (STB/d/psi), Flow efficiency, Oil (STB/d) |
PSI_Uo |
'Inflow reference'!$B$7 |
Oil viscosity, cp |
PSI_ZoneCheck |
'Inflow reference'!$B$48 |
Altered zone verdict |
PSI_ZoneCheckNote |
'Inflow reference'!$C$48 |
Altered zone comment |
PSI_h |
'Inflow reference'!$B$5 |
Net pay, ft |
PSI_hp |
'Inflow reference'!$B$15 |
Open interval, ft |
PSI_htop |
'Inflow reference'!$B$16 |
Top of pay to top of open interval, ft |
PSI_k |
'Inflow reference'!$B$4 |
Permeability, mD |
PSI_ks |
'Inflow reference'!$B$19 |
Altered-zone permeability, mD |
PSI_kvkh |
'Inflow reference'!$B$17 |
Vertical to horizontal permeability |
PSI_q |
'Inflow reference'!$B$33 |
Oil rate, STB/d |
PSI_re |
'Inflow reference'!$B$8 |
Drainage radius, ft |
PSI_rs |
'Inflow reference'!$B$20 |
Altered-zone radius, ft |
PSI_rw |
'Inflow reference'!$B$9 |
Wellbore radius, ft |
PSI_s |
'Inflow reference'!$B$10 |
Total skin |
PSI_sHawk |
'Inflow reference'!$B$42 |
Altered-zone Hawkins skin |
PSI_sLeft |
'Inflow reference'!$B$44 |
Skin after damage removal |
PSI_sTol |
'Inflow reference'!$B$23 |
Hawkins versus split tolerance |
PSI_sd |
'Inflow reference'!$B$38 |
Damage skin over open interval |
PSI_sdMax |
'Inflow reference'!$B$24 |
Damage skin screening threshold |
PSI_sp |
'Inflow reference'!$B$18 |
Perforation skin |
PSL_Coleman |
'Gas loading'!$B$94 |
Coleman adjustment |
PSL_DaysYr |
'Gas loading'!$B$99 |
Days in a year, d/yr |
PSL_Decline |
'Gas loading'!$A$71:$F$81 |
Year, Gas rate (MMscf/d), Turner (MMscf/d), Coleman (MMscf/d), Li (MMscf/d), State |
PSL_Di |
'Gas loading'!$B$16 |
Nominal decline rate, 1/yr |
PSL_GpT |
'Gas loading'!$B$46 |
Gas made before Turner loading, Bscf |
PSL_ID |
'Gas loading'!$B$6 |
Tubing inner diameter, in |
PSL_IFT |
'Gas loading'!$B$13 |
Liquid-gas surface tension, dyne/cm |
PSL_Inputs |
'Gas loading'!$B$4:$B$20 |
Gas, tubing, liquid, decline and screening inputs |
PSL_Lead |
'Gas loading'!$B$20 |
Lead time for lift, years |
PSL_LeadCheck |
'Gas loading'!$B$48 |
Lead time verdict |
PSL_LeadCheckNote |
'Gas loading'!$C$48 |
Lead time comment |
PSL_LoadCheck |
'Gas loading'!$B$47 |
Loading verdict |
PSL_LoadCheckNote |
'Gas loading'!$C$47 |
Loading comment |
PSL_MMB |
'Gas loading'!$B$100 |
MMscf in a Bscf, MMscf/Bscf |
PSL_PassCheck |
'Gas loading'!$B$49 |
Profile verdict |
PSL_PassCheckNote |
'Gas loading'!$C$49 |
Profile comment |
PSL_PassTol |
'Gas loading'!$B$102 |
Second pass tolerance, % |
PSL_Pwh |
'Gas loading'!$B$8 |
Flowing wellhead pressure, psia |
PSL_QRatio |
'Gas loading'!$B$42 |
Rate over largest Turner rate |
PSL_QcC |
'Gas loading'!$B$36 |
Largest Coleman rate, MMscf/d |
PSL_QcLi |
'Gas loading'!$B$37 |
Largest Li rate, MMscf/d |
PSL_QcT |
'Gas loading'!$B$33 |
Largest Turner rate, MMscf/d |
PSL_QcWh |
'Gas loading'!$B$28 |
Turner, MMscf/d |
PSL_QcWhC |
'Gas loading'!$B$29 |
Coleman, MMscf/d |
PSL_QcWhLi |
'Gas loading'!$B$30 |
Li, MMscf/d |
PSL_Qg |
'Gas loading'!$B$15 |
Gas rate today, MMscf/d |
PSL_R0 |
'Gas loading'!$B$96 |
Rankine at 0 F, °R |
PSL_Results |
'Gas loading'!$B$23:$B$49 |
Wellhead and tubing critical rates, decline and checks |
PSL_RhoL |
'Gas loading'!$B$12 |
Liquid density, lb/ft³ |
PSL_Rough |
'Gas loading'!$B$7 |
Tubing relative roughness |
PSL_SGg |
'Gas loading'!$B$4 |
Gas specific gravity, air = 1 |
PSL_Scf |
'Gas loading'!$B$97 |
scf in an MMscf, scf/MMscf |
PSL_Sec |
'Gas loading'!$B$98 |
Seconds in a day, s/d |
PSL_Step |
'Gas loading'!$B$101 |
Decline table step, years |
PSL_TVD |
'Gas loading'!$B$5 |
Depth of perforations, ft |
PSL_Tbh |
'Gas loading'!$B$10 |
Temperature at perforations, °F |
PSL_TubingData |
'Gas loading'!$A$57:$I$67 |
Depth (ft), Temperature (F), Pressure (psia), Z, Turner (MMscf/d), Coleman (MMscf/d), Li (MMscf/d), Turner vc (ft/s), Li vc (ft/s) |
PSL_TurnerF |
'Gas loading'!$B$19 |
Turner velocity adjustment |
PSL_Twh |
'Gas loading'!$B$9 |
Flowing wellhead temperature, °F |
PSL_Vert |
'Gas loading'!$B$95 |
Vertical pipe angle, ° |
PSL_Where |
'Gas loading'!$B$35 |
Where the well loads first |
PSL_b |
'Gas loading'!$B$17 |
Arps exponent |
PSL_tC |
'Gas loading'!$B$44 |
Years to Coleman, years |
PSL_tLi |
'Gas loading'!$B$45 |
Years to Li, years |
PSL_tT |
'Gas loading'!$B$43 |
Years to Turner, years |
PSS_Checks |
Summary!$B$23:$B$37 |
All component verdicts |
PSS_GasCandidate |
Summary!$B$14 |
Gas-loading reference |
PSS_InflowCandidate |
Summary!$B$13 |
Vertical oil inflow reference |
PSS_J |
Summary!$B$18 |
Vertical oil reference PI, STB/d/psi |
PSS_Overall |
Summary!$B$4 |
Overall verdict verdict |
PSS_OverallNote |
Summary!$C$4 |
Overall verdict comment |
PSS_QcT |
Summary!$B$19 |
Gas reference Turner critical rate, MMscf/d |
PSS_Reason1 |
Summary!$B$7 |
A-3 oil trend |
PSS_Results |
Summary!$B$17:$B$20 |
Independent waterflood, inflow and gas reference results |
PSS_WorCandidate |
Summary!$B$12 |
DWS waterflood reference |
PSS_WorEc |
Summary!$B$17 |
DWS producer economic WOR, bbl/STB |
PSS_tT |
Summary!$B$20 |
Gas reference years to Turner, years |
PSW_A |
'WOR diagnostics'!$B$27 |
Log WOR intercept |
PSW_B |
'WOR diagnostics'!$B$26 |
Log WOR slope, 1/STB |
PSW_ChanCheck |
'WOR diagnostics'!$B$38 |
Chan diagnostic verdict |
PSW_ChanCheckNote |
'WOR diagnostics'!$C$38 |
Chan diagnostic comment |
PSW_ChanSlope |
'WOR diagnostics'!$B$23 |
Late Chan slope |
PSW_DaysPerMonth |
'WOR diagnostics'!$B$44 |
Average days in a month, days |
PSW_EconCheck |
'WOR diagnostics'!$B$40 |
Economic limit verdict |
PSW_EconCheckNote |
'WOR diagnostics'!$C$40 |
Economic limit comment |
PSW_FitFrom |
'WOR diagnostics'!$B$5 |
First month of trend |
PSW_Fixed |
'WOR diagnostics'!$B$11 |
Fixed monthly cost, $/well-month |
PSW_FwEc |
'WOR diagnostics'!$B$32 |
Economic water cut, % |
PSW_History |
'WOR diagnostics'!$A$51:$G$74 |
Time (days), Oil (STB/d), Water (STB/d), WOR, WOR derivative, Cumulative oil (STB), Log WOR |
PSW_Inputs |
'WOR diagnostics'!$B$4:$B$14 |
Producer breakthrough, trend window, economics and recovery inputs |
PSW_Lift |
'WOR diagnostics'!$B$12 |
Liquid handling cost, $/STB |
PSW_Months |
'WOR diagnostics'!$AD$21 |
Months |
PSW_N |
'WOR diagnostics'!$B$13 |
Oil initially in place, STB |
PSW_Np0 |
'WOR diagnostics'!$B$4 |
Oil at breakthrough, STB |
PSW_NpEc |
'WOR diagnostics'!$B$33 |
Economic cumulative oil, STB |
PSW_Opex |
'WOR diagnostics'!$B$10 |
Variable oil cost, $/STB |
PSW_Price |
'WOR diagnostics'!$B$7 |
Oil price, $/STB |
PSW_QoEc |
'WOR diagnostics'!$B$30 |
Economic oil rate, STB/d |
PSW_R2 |
'WOR diagnostics'!$B$28 |
Trend R squared |
PSW_R2Min |
'WOR diagnostics'!$B$14 |
Minimum trend R squared |
PSW_RF |
'WOR diagnostics'!$B$35 |
Recovery factor, % |
PSW_Rem |
'WOR diagnostics'!$B$34 |
Remaining oil, STB |
PSW_Results |
'WOR diagnostics'!$B$21:$B$35 |
Chan diagnostic, trend and economic recovery results |
PSW_Royalty |
'WOR diagnostics'!$B$8 |
Royalty, % |
PSW_SlopeConing |
'WOR diagnostics'!$B$6 |
Chan slope threshold |
PSW_Tax |
'WOR diagnostics'!$B$9 |
Production tax, % |
PSW_TrendCheck |
'WOR diagnostics'!$B$39 |
Trend quality verdict |
PSW_TrendCheckNote |
'WOR diagnostics'!$C$39 |
Trend quality comment |
PSW_WindowCheck |
'WOR diagnostics'!$B$37 |
Fit window verdict |
PSW_WindowCheckNote |
'WOR diagnostics'!$C$37 |
Fit window comment |
PSW_WorEc |
'WOR diagnostics'!$B$31 |
Economic WOR, bbl/STB |
Details
| Opens in | Needs the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates. Needs Microsoft 365 or Excel 2024: it uses functions Excel 2016 doesn't have, such as named LAMBDAs, which show #NAME? there. |
| File | ProductionSurveillance.xlsx, 92 KB |
| Category | Production |
| For agents and tools | Descriptor (.md) |
More Production Workbooks
Artificial Lift Selection
PO Add-in + Microsoft 365Which artificial-lift method suits a well, from a six-method screen against editable limits to first-pass ESP, gas-lift, rod-pump and plunger sizing.
Continuous Gas-Lift Design
PO Add-inHow much lift gas one well needs, how deep to inject it and where the unloading valves go, checked against port throughput and the nodal rate.
Decline Curve Analysis
PO Add-in + Microsoft 365How much oil one well will recover, from its monthly rate history through four decline fits to an EUR, a booked model and its sensitivity.
ESP System Design
PO Add-in + Microsoft 365How many stages and which motor one well's ESP needs, where it operates, and whether intake gas, cable voltage drop and drive speed are acceptable.
Field Production Profile
PO Add-in + Microsoft 365What a 24-well development will produce year by year, from a P50 type well through a drilling schedule and a buildup, plateau and decline profile.
Flow Assurance Screening
PO Add-in + Microsoft 365Whether a subsea tieback will hydrate, scale, corrode or erode, the methanol that clears its hydrates, and how high each threat rates.
Gas Well Deliverability
PO Add-in + Microsoft 365How much gas one well delivers and when it will load up, from a four-point test fit through the tubing to critical rates along a decline.
Gas-Lift Field Optimisation
PO Add-inHow to split a limited lift-gas supply across four wells for the most oil, and where the first well then injects.
Gathering System Diagram
Excel 2016+How a field's wells, chokes, manifold and separators connect, drawn from a network table and labelled with typed rates and pressures.
Inverted ESP for a Downhole Water Sink
PO Add-in + Microsoft 365Which pump, stages and drive frequency an inverted ESP needs to drain water below the contact and re-inject it, and whether that water is coning.
Nodal Analysis
PO Add-in + Microsoft 365At what rate one oil well flows, from its inflow and best-matching tubing curve, and how tubing size, skin, wellhead pressure and water cut move it.
Pipeline Design and Route Integrity
PO Add-in + Microsoft 365What size one route's gas, liquid and multiphase lines must be, and whether the bore holds against erosion, hydrates and CO2 corrosion.
Production Allocation
Excel 2016+How much of one battery's metered oil, gas and water each of its ten wells made, from each well's test rates and hours on production.
Rod Pump System Design
PO Add-in + Microsoft 365Whether a tapered rod string, pump and pumping unit lift one well's target rate within rod stress, unit ratings and counterbalance.
Surface Facility Sizing
PO Add-in + Microsoft 365How big a separator, how much compression and which wellhead choke one well stream needs, from its gas, oil and water rates and pressures.
Type Well Builder
PO Add-in + Microsoft 365What a new well in a play will produce, as P90, P50 and P10 type curves and EURs from ten offset wells normalised by lateral length and screened for outliers.
Unconventional Rate-Transient Analysis
PO Add-in + Microsoft 365Whether a tight-oil well has reached boundary-dominated flow, how much oil it contacts and what it will recover, from its monthly rates and flowing pressures.
VFP Production and Injection Tables
PO Add-in + Microsoft 365What bottomhole pressure one vertical well needs across rate, pressure, water cut and GOR, written as VFPPROD and VFPINJ tables for a simulator.
Well Productivity Review
PO Add-in + Microsoft 365Which wells are worth stimulating, ranked by PI, skin and damage ratio, with each one's IPR uplift valued against a type curve.
Need a workbook we don't have? Suggest a Workbook















