Description
Which candidate wells are damaged enough to stimulate, how much oil would removing the damage add, and is the workover worth its cost? You enter the shared rock, fluid and pressures, the completion and each candidate's skin, cost and chance of success. You read off each candidate's pseudosteady-state PI, flow efficiency, damage ratio and ranks, the unscaled composite IPR uplift at a common flowing pressure, and its risked NPV, payout and break-even against a separately modelled type curve. Field units; the candidates are synthetic.
How to use it: Replace the synthetic wells and reservoir on the Candidates sheet with measured well data: the shared rock, fluid and pressures, the completion (open interval, its top, kv/kh and perforation skin) and one row per candidate with its skin, cost and chance. Ties in the ranks keep the input order. Check that the uplift does not exceed the candidate's own IPR base. Enter the type curve, prices and fiscal terms on the Economics Inputs sheet, then read each job's value and GO or NO-GO decision on the Value sheet; check that the rate after workover stays within the type curve's initial rate. The Summary collects the results and checks. Use measured well data before making decisions.
Method: For each candidate, radial pseudosteady-state PI is k h / [141.2 Bo μo (ln(re/rw) − 0.75 + s)]. Flow efficiency is the ratio of damaged to ideal PI, and damage ratio its reciprocal. The completion skin is split into its damage, partial-penetration and perforation parts; a matrix-treatment PI removes the damage part only, not all completion skin. At the common pressure, the composite IPR uses a straight line above the bubble point and Vogel below; the target-skin rate less the current-skin rate is the unscaled uplift. The independent single-phase test pressure is above the bubble point and uses the straight-line IPR. For economics, the uplift declines exponentially over the remaining base life of the type-curve well. Incremental oil earns the shared net margin, with the workover cost, scaled by working interest, in month one. Workover cash is incremental, before income tax, and ends at the base well's economic life; no life extension is assumed. Risked NPV weights the successful cash flow by the chance of success and the cost-only failure by its complement; payout is measured from the workover.
Example: The three synthetic candidates are illustrative modifications of the IPR reference well, not field measurements: 0.5 mD, current skins 1, 2 and 3, target skin −2 and 2,000 psi flowing pressure. Their IPR base rates are approximately 90.0, 80.6 and 73.0 STB/d, and unscaled uplifts approximately 48.2, 57.6 and 65.2 STB/d. The separate type-curve well's base is approximately 120.3 STB/d in the first month. These are different hypothetical wells, not a single calibrated production forecast: their coupling is illustrative. Separately labelled references reproduce the IPR reference well's stimulation, horizontal and multilayer examples, keeping its independent 20 mD and skin 5, and the independent workover example that starts with a 60 STB/d uplift.
Validity
Vertical PI is pseudosteady state; horizontal methods are steady state. The composite IPR assumes Darcy flow above the bubble point and Vogel below. Multilayer shut-in pressure is PI-weighted and may not balance the nonlinear composite rates. The horizontal and layered reference sheets keep their inputs, headline and checks; the detailed method comparisons, per-layer results and curves are in the single-sheet horizontal and multilayer blueprints they come from. The economics assume constant GOR, oil and gas prices and the shared fiscal terms, exponential decline of the incremental rate, end-of-month cash flow, no fixed-LOE change and no income tax. Alternatives: steady-state or transient vertical PI; the Klins or Fetkovich rate for a depleted well instead of the composite model; the single-sheet blueprints for PI, skin sensitivity, horizontal comparison, multilayer and the workover decision.
References
- Hawkins, M.F. Jr. (1956). “A Note on the Skin Effect.” Trans. AIME 207, 356–357.
- Saidikowski, R.M. (1979). “Numerical Simulations of the Combined Effects of Wellbore Damage and Partial Penetration.” SPE-8204.
- Papatzacos, P. (1987). “Approximate Partial-Penetration Pseudoskin for Infinite-Conductivity Wells.” SPE Reservoir Engineering 2(2), 227–234.
- Vogel, J.V. (1968). “Inflow Performance Relationships for Solution-Gas Drive Wells.” JPT 20(1), 83–92.
- Standing, M.B. (1970). “Inflow Performance Relationships for Damaged Wells Producing by Solution-Gas Drive.” JPT 22(11), 1399–1400.
Inputs
The IPR, Horizontal and Layered Reference sheets carry their own inputs from the IPR reference well.
| Input | Unit | Default | Name |
|---|---|---|---|
| Candidate permeability | mD | 0.5 | PRA_k |
| Net pay | ft | 50 | PRA_h |
| Oil formation volume factor | bbl/STB | 1.467 | PRA_Bo |
| Oil viscosity | cp | 0.302 | PRA_Uo |
| Drainage radius | ft | 1490 | PRA_re |
| Wellbore radius | ft | 0.354 | PRA_rw |
| Reservoir pressure | psi | 4000 | PRA_Pr |
| Bubble point pressure | psi | 2620 | PRA_Pb |
| Common flowing pressure | psi | 2000 | PRA_Pwf |
| Synthetic target skin | — | −2 | PRA_Target |
| Single-phase test pressure above Pb | psi | 3000 | PRA_PwfTest |
| Open interval | ft | 40 | PRA_hp |
| Open interval top below pay top | ft | 0 | PRA_htop |
| Vertical over horizontal permeability | — | 0.1 | PRA_kvkh |
| Perforation skin | — | 0.5 | PRA_sp |
| Candidate skin, A, B, C | — | 1, 2, 3 | PRA_SkinA, PRA_SkinB, PRA_SkinC |
| Candidate cost, A, B, C | $ | 350000, 500000, 1500000 | PRA_CostA, PRA_CostB, PRA_CostC |
| Candidate chance of success, A, B, C | % | 80 | PRA_PcA, PRA_PcB, PRA_PcC |
| Type curve, prices, interests, taxes, operating costs and discount rate | — | see the Economics Inputs sheet | PRE_LifeCap, PRE_IP, PRE_b, PRE_Dei, PRE_Dterm, PRE_GOR, PRE_TC, PRE_Oil, PRE_OilDiff, PRE_Gas, PRE_GasDiff, PRE_Esc, PRE_WI, PRE_NRI, PRE_SevOil, PRE_SevGas, PRE_AdVal, PRE_LOE, PRE_LOEVar, PRE_Gath, PRE_Disc |
| Months the well has produced before the workover | months | 36 | PRE_Age |
| Reference workover: incremental oil rate at the start, its effective decline, cost, chance of success | STB/d, 1/yr, $, % | 60, 0.5, 350000, 80 | PRE_UpliftRef, PRE_UpDecl, PRE_CostRef, PRE_PcRef |
| Longest acceptable payout, from the workover | months | 12 | PRE_PayoutMax |
Sheets
Guide— what the workbook answers, the order to work through its sheets and the model boundaries.Candidates— the shared rock, fluid and pressures, the completion inputs, and per candidate the PI, flow efficiency, damage ratio and their ranks, the composite rate and unscaled uplift, the damage skin, treated PI and matrix gain, and the single-phase test rate, with an uplift chart and the checks.IPR Reference— the independent 20 mD reference well with its skins and five composite IPRs; not a synthetic candidate or a type-curve forecast.Horizontal Reference— the reference well drilled horizontally, with steady-state PI by several methods and their mean.Layered Reference— three sands with shared fluid and geometry, the PI-weighted shut-in pressure and the crossflow check at the operating flowing pressure.Economics Inputs— the separate type-curve well, prices, fiscal terms and the workover inputs, with its decline, life and first-month base rate.Cash Flow— the monthly oil and net revenue per STB/d of uplift that every job shares.Value— the 60 STB/d reference and each candidate's uplift, rate after workover, success, failure and risked NPV, payout, PV/I, break-even chance and uplift, and the GO or NO-GO decision.Summary— the references, the candidate results and every check under one verdict.Test Cases— the worked example and other cases, with expected and computed results.
Functions used
PO.IPR.VW.PSS.PIPO.IPR.VW.PSS.RatePO.IPR.VW.PSS.Rate.ByVogelPO.IPR.HW.SS.PI.ByBorisovPO.IPR.HW.SS.PI.ByEconomides.CenteredPO.IPR.HW.SS.PI.ByGRJPO.IPR.HW.SS.PI.ByJoshiPO.IPR.HW.SS.PI.ByRenardDupuyPO.CO.Damage.DecompositionPO.CO.Damage.HawkinsPO.ECON.NPV.MonthlyPO.ECON.PayoutPO.IPR.VW.SS.PIPO.IPR.VW.TF.PIPO.IPR.VW.PSS.Rate.ByKlinsPO.IPR.VW.PSS.Rate.ByFetkovich
Names (399)
| 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.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.ECON.NPV.MonthlyLAMBDA |
=LAMBDA(cash,annual_rate,NPV((1+annual_rate)^(1/12)-1,cash)) |
NPV of end-of-month cash flows at an annual discount rate, in the units of cash. |
PO.ECON.PayoutLAMBDA |
=LAMBDA(cash,LET(cumulative,SCAN(0,cash,LAMBDA(running,flow,running+flow)),trough,MATCH(MIN(cumulative),cumulative,0),IFERROR(MATCH(1,(SEQUENCE(ROWS(cumulative))>trough)*(cumulative>=0),0),"none"))) |
Month in which cumulative cash flow climbs back to zero after its low point; "none" if it never does |
PRA_Bo |
Candidates!$B$6 |
Oil formation volume factor, bbl/STB |
PRA_CandidateResults |
Candidates!$A$42:$Q$44 |
Candidate inputs and results |
PRA_CompletionCheck |
Candidates!$B$58 |
Completion geometry verdict |
PRA_CompletionCheckNote |
Candidates!$C$58 |
Completion geometry comment |
PRA_Completion_Inputs |
Candidates!$B$28:$B$31 |
Completion inputs |
PRA_CostA |
Candidates!$C$42 |
|
PRA_CostB |
Candidates!$C$43 |
|
PRA_CostC |
Candidates!$C$44 |
|
PRA_DRA |
Candidates!$G$42 |
|
PRA_DRB |
Candidates!$G$43 |
|
PRA_DRC |
Candidates!$G$44 |
|
PRA_DamageACheck |
Candidates!$B$59 |
A: damage skin verdict |
PRA_DamageACheckNote |
Candidates!$C$59 |
A: damage skin comment |
PRA_DamageBCheck |
Candidates!$B$60 |
B: damage skin verdict |
PRA_DamageBCheckNote |
Candidates!$C$60 |
B: damage skin comment |
PRA_DamageCCheck |
Candidates!$B$61 |
C: damage skin verdict |
PRA_DamageCCheckNote |
Candidates!$C$61 |
C: damage skin comment |
PRA_DrRankA |
Candidates!$L$42 |
|
PRA_DrRankB |
Candidates!$L$43 |
|
PRA_DrRankC |
Candidates!$L$44 |
|
PRA_FEA |
Candidates!$F$42 |
|
PRA_FEB |
Candidates!$F$43 |
|
PRA_FEC |
Candidates!$F$44 |
|
PRA_Inputs |
Candidates!$B$4:$B$13 |
Shared inputs |
PRA_InvalidPI |
Candidates!$B$16 |
Invalid PI inputs |
PRA_J0 |
Candidates!$B$37 |
Ideal productivity index, STB/d/psi |
PRA_JA |
Candidates!$E$42 |
|
PRA_JB |
Candidates!$E$43 |
|
PRA_JC |
Candidates!$E$44 |
|
PRA_JTarget |
Candidates!$B$38 |
Target productivity index, STB/d/psi |
PRA_JTreatA |
Candidates!$O$42 |
|
PRA_JTreatB |
Candidates!$O$43 |
|
PRA_JTreatC |
Candidates!$O$44 |
|
PRA_MatrixGainA |
Candidates!$P$42 |
|
PRA_MatrixGainB |
Candidates!$P$43 |
|
PRA_MatrixGainC |
Candidates!$P$44 |
|
PRA_Pb |
Candidates!$B$11 |
Bubble point pressure, psi |
PRA_PcA |
Candidates!$D$42 |
|
PRA_PcB |
Candidates!$D$43 |
|
PRA_PcC |
Candidates!$D$44 |
|
PRA_PiRankA |
Candidates!$J$42 |
|
PRA_PiRankB |
Candidates!$J$43 |
|
PRA_PiRankC |
Candidates!$J$44 |
|
PRA_Pr |
Candidates!$B$10 |
Reservoir pressure, psi |
PRA_PressureCheck |
Candidates!$B$57 |
Pressures verdict |
PRA_PressureCheckNote |
Candidates!$C$57 |
Pressures comment |
PRA_Pss |
Candidates!$B$14 |
Pseudosteady-state radius correction |
PRA_Pwf |
Candidates!$B$12 |
Common flowing pressure, psi |
PRA_PwfTest |
Candidates!$B$15 |
Single-phase test pressure above Pb, psi |
PRA_SafeDen |
Candidates!$B$35 |
Safe radius denominator without skin |
PRA_SafeRe |
Candidates!$B$34 |
Safe drainage radius, ft |
PRA_SafeRw |
Candidates!$B$33 |
Safe wellbore radius, ft |
PRA_SkinA |
Candidates!$B$42 |
|
PRA_SkinB |
Candidates!$B$43 |
|
PRA_SkinC |
Candidates!$B$44 |
|
PRA_SkinCheck |
Candidates!$B$56 |
PI inputs verdict |
PRA_SkinCheckNote |
Candidates!$C$56 |
PI inputs comment |
PRA_SkinRankA |
Candidates!$K$42 |
|
PRA_SkinRankB |
Candidates!$K$43 |
|
PRA_SkinRankC |
Candidates!$K$44 |
|
PRA_Target |
Candidates!$B$13 |
Synthetic target skin |
PRA_Test_Inputs |
Candidates!$B$15 |
Single-phase test pressure |
PRA_Uo |
Candidates!$B$7 |
Oil viscosity, cp |
PRA_UpliftA |
Candidates!$I$42 |
|
PRA_UpliftACheck |
Candidates!$B$62 |
A: IPR uplift verdict |
PRA_UpliftACheckNote |
Candidates!$C$62 |
A: IPR uplift comment |
PRA_UpliftB |
Candidates!$I$43 |
|
PRA_UpliftBCheck |
Candidates!$B$63 |
B: IPR uplift verdict |
PRA_UpliftBCheckNote |
Candidates!$C$63 |
B: IPR uplift comment |
PRA_UpliftC |
Candidates!$I$44 |
|
PRA_UpliftCCheck |
Candidates!$B$64 |
C: IPR uplift verdict |
PRA_UpliftCCheckNote |
Candidates!$C$64 |
C: IPR uplift comment |
PRA_UpliftChartData |
Candidates!$A$42:$I$44 |
Candidate IPR uplift |
PRA_h |
Candidates!$B$5 |
Net pay, ft |
PRA_hp |
Candidates!$B$28 |
Open interval, ft |
PRA_htop |
Candidates!$B$29 |
Open interval top below pay top, ft |
PRA_k |
Candidates!$B$4 |
Candidate permeability, mD |
PRA_kvkh |
Candidates!$B$30 |
Vertical over horizontal permeability |
PRA_qA |
Candidates!$H$42 |
|
PRA_qB |
Candidates!$H$43 |
|
PRA_qC |
Candidates!$H$44 |
|
PRA_qSingleA |
Candidates!$Q$42 |
|
PRA_qSingleB |
Candidates!$Q$43 |
|
PRA_qSingleC |
Candidates!$Q$44 |
|
PRA_qTarget |
Candidates!$B$39 |
Target composite rate, STB/d |
PRA_re |
Candidates!$B$8 |
Drainage radius, ft |
PRA_rw |
Candidates!$B$9 |
Wellbore radius, ft |
PRA_sLeftA |
Candidates!$N$42 |
|
PRA_sLeftB |
Candidates!$N$43 |
|
PRA_sLeftC |
Candidates!$N$44 |
|
PRA_sdA |
Candidates!$M$42 |
|
PRA_sdB |
Candidates!$M$43 |
|
PRA_sdC |
Candidates!$M$44 |
|
PRA_sp |
Candidates!$B$31 |
Perforation skin |
PRE_AdVal |
'Economics Inputs'!$B$21 |
|
PRE_Age |
'Economics Inputs'!$B$26 |
|
PRE_BaseNow |
'Economics Inputs'!$B$49 |
EconWell base in first month post-job, STB/d |
PRE_CostRef |
'Economics Inputs'!$B$29 |
|
PRE_Days |
'Economics Inputs'!$B$33 |
Days in a month, days/month |
PRE_Dei |
'Economics Inputs'!$B$8 |
|
PRE_Di |
'Economics Inputs'!$B$38 |
|
PRE_Disc |
'Economics Inputs'!$B$25 |
|
PRE_Dt |
'Economics Inputs'!$B$39 |
|
PRE_Dterm |
'Economics Inputs'!$B$9 |
|
PRE_Dw |
'Economics Inputs'!$B$48 |
Incremental nominal decline, 1/yr |
PRE_EconomicsInputs |
'Economics Inputs'!$A$5:$B$31 |
EconWell and workover inputs |
PRE_Esc |
'Economics Inputs'!$B$16 |
|
PRE_GOR |
'Economics Inputs'!$B$10 |
|
PRE_Gas |
'Economics Inputs'!$B$14 |
|
PRE_GasDiff |
'Economics Inputs'!$B$15 |
|
PRE_Gath |
'Economics Inputs'!$B$24 |
|
PRE_HorizonCheck |
'Economics Inputs'!$B$50 |
Horizon check verdict |
PRE_HorizonCheckNote |
'Economics Inputs'!$C$50 |
Horizon check comment |
PRE_IP |
'Economics Inputs'!$B$6 |
|
PRE_LOE |
'Economics Inputs'!$B$22 |
|
PRE_LOEVar |
'Economics Inputs'!$B$23 |
|
PRE_Life |
'Economics Inputs'!$B$46 |
|
PRE_LifeCap |
'Economics Inputs'!$B$5 |
|
PRE_Margin |
'Economics Inputs'!$B$43 |
|
PRE_MoYr |
'Economics Inputs'!$B$34 |
Months in a year, months/yr |
PRE_N |
'Economics Inputs'!$B$47 |
Months remaining (cash range capped at 1000), months |
PRE_NRI |
'Economics Inputs'!$B$18 |
|
PRE_Oil |
'Economics Inputs'!$B$12 |
|
PRE_OilDiff |
'Economics Inputs'!$B$13 |
|
PRE_PayoutMax |
'Economics Inputs'!$B$31 |
|
PRE_PcRef |
'Economics Inputs'!$B$30 |
|
PRE_PerMM |
'Economics Inputs'!$B$35 |
Dollars in a million, $/MM |
PRE_QLimit |
'Economics Inputs'!$B$44 |
|
PRE_Qi |
'Economics Inputs'!$B$42 |
|
PRE_Qs |
'Economics Inputs'!$B$41 |
|
PRE_SevGas |
'Economics Inputs'!$B$20 |
|
PRE_SevOil |
'Economics Inputs'!$B$19 |
|
PRE_TC |
'Economics Inputs'!$B$11 |
|
PRE_TLimit |
'Economics Inputs'!$B$45 |
|
PRE_Ts |
'Economics Inputs'!$B$40 |
|
PRE_UpDecl |
'Economics Inputs'!$B$28 |
|
PRE_UpliftRef |
'Economics Inputs'!$B$27 |
|
PRE_WI |
'Economics Inputs'!$B$17 |
|
PRE_WellCalculation |
'Economics Inputs'!$A$38:$B$46 |
Calculation, Value (row units) |
PRE_b |
'Economics Inputs'!$B$7 |
|
PRH_AnisCheck |
'Horizontal Reference'!$B$26 |
Borisov miss verdict |
PRH_AnisCheckNote |
'Horizontal Reference'!$C$26 |
Borisov miss comment |
PRH_Bo |
'Horizontal Reference'!$B$11 |
|
PRH_BorTol |
'Horizontal Reference'!$B$17 |
|
PRH_CvMax |
'Horizontal Reference'!$B$16 |
|
PRH_GeoCheck |
'Horizontal Reference'!$B$24 |
Geometry verdict |
PRH_GeoCheckNote |
'Horizontal Reference'!$C$24 |
Geometry comment |
PRH_HorizontalInputs |
'Horizontal Reference'!$A$5:$B$17 |
Horizontal inputs |
PRH_JMean |
'Horizontal Reference'!$B$23 |
Mean horizontal PI, STB/d/psi |
PRH_JoshiMax |
'Horizontal Reference'!$B$18 |
Maximum Joshi half-length over radius |
PRH_L |
'Horizontal Reference'!$B$5 |
|
PRH_LhMin |
'Horizontal Reference'!$B$15 |
|
PRH_Pr |
'Horizontal Reference'!$B$13 |
|
PRH_Pwf |
'Horizontal Reference'!$B$14 |
|
PRH_Side |
'Horizontal Reference'!$B$20 |
Equivalent square side, ft |
PRH_SpreadCheck |
'Horizontal Reference'!$B$25 |
Method spread verdict |
PRH_SpreadCheckNote |
'Horizontal Reference'!$C$25 |
Method spread comment |
PRH_Uo |
'Horizontal Reference'!$B$12 |
|
PRH_h |
'Horizontal Reference'!$B$6 |
|
PRH_kh |
'Horizontal Reference'!$B$7 |
|
PRH_kv |
'Horizontal Reference'!$B$8 |
|
PRH_re |
'Horizontal Reference'!$B$9 |
|
PRH_rw |
'Horizontal Reference'!$B$10 |
|
PRL_Bo |
'Layered Reference'!$B$6 |
|
PRL_FlowCheck |
'Layered Reference'!$B$26 |
Flowing crossflow verdict |
PRL_FlowCheckNote |
'Layered Reference'!$C$26 |
Flowing crossflow comment |
PRL_Layers |
'Layered Reference'!$A$11:$F$13 |
Layer inputs and PIs |
PRL_NetTol |
'Layered Reference'!$B$17 |
Net rate below which shut-in balances, STB/d |
PRL_Pb |
'Layered Reference'!$B$5 |
|
PRL_PrL |
'Layered Reference'!$B$13 |
|
PRL_PrM |
'Layered Reference'!$B$12 |
|
PRL_PrU |
'Layered Reference'!$B$11 |
|
PRL_PwfOp |
'Layered Reference'!$B$15 |
Operating flowing pressure, psi |
PRL_Pws |
'Layered Reference'!$B$18 |
PI-weighted shut-in pressure, psi |
PRL_RateComponents |
'Layered Reference'!$A$21:$C$23 |
Signed layer rates |
PRL_SharedInputs |
'Layered Reference'!$A$5:$B$9 |
Shared fluid and geometry |
PRL_Uo |
'Layered Reference'!$B$7 |
|
PRL_WsCheck |
'Layered Reference'!$B$28 |
Shut-in balance verdict |
PRL_WsCheckNote |
'Layered Reference'!$C$28 |
Shut-in balance comment |
PRL_XfCheck |
'Layered Reference'!$B$27 |
Shut-in crossflow verdict |
PRL_XfCheckNote |
'Layered Reference'!$C$27 |
Shut-in crossflow comment |
PRL_XfTol |
'Layered Reference'!$B$16 |
Accepted shut-in crossflow, STB/d |
PRL_hL |
'Layered Reference'!$D$13 |
|
PRL_hM |
'Layered Reference'!$D$12 |
|
PRL_hU |
'Layered Reference'!$D$11 |
|
PRL_kL |
'Layered Reference'!$C$13 |
|
PRL_kM |
'Layered Reference'!$C$12 |
|
PRL_kU |
'Layered Reference'!$C$11 |
|
PRL_q |
'Layered Reference'!$B$25 |
Operating rate, STB/d |
PRL_re |
'Layered Reference'!$B$8 |
|
PRL_rw |
'Layered Reference'!$B$9 |
|
PRL_sL |
'Layered Reference'!$E$13 |
|
PRL_sM |
'Layered Reference'!$E$12 |
|
PRL_sU |
'Layered Reference'!$E$11 |
|
PRM_AnisCheck |
Summary!$B$42 |
Horizontal anisotropy verdict |
PRM_AnisCheckNote |
Summary!$C$42 |
Horizontal anisotropy comment |
PRM_BalanceCheck |
Summary!$B$45 |
Layered shut-in balance verdict |
PRM_BalanceCheckNote |
Summary!$C$45 |
Layered shut-in balance comment |
PRM_BaseMismatchA |
Summary!$E$12 |
|
PRM_BaseMismatchB |
Summary!$E$13 |
|
PRM_BaseMismatchC |
Summary!$E$14 |
|
PRM_CandidateTable |
Summary!$A$12:$I$14 |
Candidate, IPR base (STB/d), Uplift (STB/d), Econ base (STB/d), Base difference (STB/d), PI rank (—), Skin rank (—), Damage rank (—), Risked NPV ($MM) |
PRM_CompletionCheck |
Summary!$B$49 |
Completion geometry verdict |
PRM_CompletionCheckNote |
Summary!$C$49 |
Completion geometry comment |
PRM_CrossflowCheck |
Summary!$B$44 |
Layered shut-in crossflow verdict |
PRM_CrossflowCheckNote |
Summary!$C$44 |
Layered shut-in crossflow comment |
PRM_DamageCheckA |
Summary!$B$26 |
A: damage verdict |
PRM_DamageCheckANote |
Summary!$C$26 |
A: damage comment |
PRM_DamageCheckB |
Summary!$B$30 |
B: damage verdict |
PRM_DamageCheckBNote |
Summary!$C$30 |
B: damage comment |
PRM_DamageCheckC |
Summary!$B$34 |
C: damage verdict |
PRM_DamageCheckCNote |
Summary!$C$34 |
C: damage comment |
PRM_DrRankA |
Summary!$H$12 |
|
PRM_DrRankB |
Summary!$H$13 |
|
PRM_DrRankC |
Summary!$H$14 |
|
PRM_ENPVA |
Summary!$I$12 |
|
PRM_ENPVB |
Summary!$I$13 |
|
PRM_ENPVC |
Summary!$I$14 |
|
PRM_EconBase |
Summary!$B$7 |
Independent EconWell first-month base, STB/d |
PRM_EconBaseA |
Summary!$D$12 |
|
PRM_EconBaseB |
Summary!$D$13 |
|
PRM_EconBaseC |
Summary!$D$14 |
|
PRM_FlowCheck |
Summary!$B$43 |
Layered flow verdict |
PRM_FlowCheckNote |
Summary!$C$43 |
Layered flow comment |
PRM_GeometryCheck |
Summary!$B$40 |
Horizontal geometry verdict |
PRM_GeometryCheckNote |
Summary!$C$40 |
Horizontal geometry comment |
PRM_GoCheckA |
Summary!$B$25 |
A: decision verdict |
PRM_GoCheckANote |
Summary!$C$25 |
A: decision comment |
PRM_GoCheckB |
Summary!$B$29 |
B: decision verdict |
PRM_GoCheckBNote |
Summary!$C$29 |
B: decision comment |
PRM_GoCheckC |
Summary!$B$33 |
C: decision verdict |
PRM_GoCheckCNote |
Summary!$C$33 |
C: decision comment |
PRM_HorizonCheck |
Summary!$B$38 |
EconWell horizon verdict |
PRM_HorizonCheckNote |
Summary!$C$38 |
EconWell horizon comment |
PRM_HorizontalMean |
Summary!$B$8 |
Horizontal reference mean PI, STB/d/psi |
PRM_IprBaseA |
Summary!$B$12 |
|
PRM_IprBaseB |
Summary!$B$13 |
|
PRM_IprBaseC |
Summary!$B$14 |
|
PRM_IprUpliftCheckA |
Summary!$B$23 |
A: IPR uplift verdict |
PRM_IprUpliftCheckANote |
Summary!$C$23 |
A: IPR uplift comment |
PRM_IprUpliftCheckB |
Summary!$B$27 |
B: IPR uplift verdict |
PRM_IprUpliftCheckBNote |
Summary!$C$27 |
B: IPR uplift comment |
PRM_IprUpliftCheckC |
Summary!$B$31 |
C: IPR uplift verdict |
PRM_IprUpliftCheckCNote |
Summary!$C$31 |
C: IPR uplift comment |
PRM_LayerRate |
Summary!$B$9 |
Layered reference operating rate, STB/d |
PRM_Overall |
Summary!$B$52 |
Review all checks above verdict |
PRM_OverallNote |
Summary!$C$52 |
Review all checks above comment |
PRM_PiRankA |
Summary!$F$12 |
|
PRM_PiRankB |
Summary!$F$13 |
|
PRM_PiRankC |
Summary!$F$14 |
|
PRM_PressureCheck |
Summary!$B$48 |
Candidate pressure inputs verdict |
PRM_PressureCheckNote |
Summary!$C$48 |
Candidate pressure inputs comment |
PRM_ReferenceENPV |
Summary!$B$6 |
60 STB/d reference risked NPV, $MM |
PRM_ReferenceGain |
Summary!$B$5 |
IprWell stimulation gain, % |
PRM_ReferenceGoCheck |
Summary!$B$46 |
Reference workover verdict |
PRM_ReferenceGoCheckNote |
Summary!$C$46 |
Reference workover comment |
PRM_ReferenceRateCheck |
Summary!$B$47 |
Reference EconWell rate verdict |
PRM_ReferenceRateCheckNote |
Summary!$C$47 |
Reference EconWell rate comment |
PRM_ReferenceUplift |
Summary!$B$4 |
IprWell stimulation uplift, STB/d |
PRM_Results |
Summary!$B$4:$B$9 |
Reference results |
PRM_SkinCheck |
Summary!$B$37 |
Candidate PI denominators verdict |
PRM_SkinCheckNote |
Summary!$C$37 |
Candidate PI denominators comment |
PRM_SkinRankA |
Summary!$G$12 |
|
PRM_SkinRankB |
Summary!$G$13 |
|
PRM_SkinRankC |
Summary!$G$14 |
|
PRM_SpreadCheck |
Summary!$B$41 |
Horizontal method spread verdict |
PRM_SpreadCheckNote |
Summary!$C$41 |
Horizontal method spread comment |
PRM_StimCheck |
Summary!$B$39 |
Reference stimulation verdict |
PRM_StimCheckNote |
Summary!$C$39 |
Reference stimulation comment |
PRM_TypeRateCheckA |
Summary!$B$24 |
A: EconWell rate verdict |
PRM_TypeRateCheckANote |
Summary!$C$24 |
A: EconWell rate comment |
PRM_TypeRateCheckB |
Summary!$B$28 |
B: EconWell rate verdict |
PRM_TypeRateCheckBNote |
Summary!$C$28 |
B: EconWell rate comment |
PRM_TypeRateCheckC |
Summary!$B$32 |
C: EconWell rate verdict |
PRM_TypeRateCheckCNote |
Summary!$C$32 |
C: EconWell rate comment |
PRM_UpliftA |
Summary!$C$12 |
|
PRM_UpliftB |
Summary!$C$13 |
|
PRM_UpliftC |
Summary!$C$14 |
|
PRS_AOF1 |
'IPR Reference'!$D$26 |
|
PRS_AOF2 |
'IPR Reference'!$D$27 |
|
PRS_AOF3 |
'IPR Reference'!$D$28 |
|
PRS_AOF4 |
'IPR Reference'!$D$29 |
|
PRS_AOF5 |
'IPR Reference'!$D$30 |
|
PRS_Bo |
'IPR Reference'!$B$7 |
|
PRS_Gain |
'IPR Reference'!$B$44 |
Stimulation gain, % |
PRS_GainHawk |
'IPR Reference'!$B$45 |
Hawkins gain, % |
PRS_GainMin |
'IPR Reference'!$B$20 |
|
PRS_J1 |
'IPR Reference'!$C$26 |
|
PRS_J2 |
'IPR Reference'!$C$27 |
|
PRS_J3 |
'IPR Reference'!$C$28 |
|
PRS_J4 |
'IPR Reference'!$C$29 |
|
PRS_J5 |
'IPR Reference'!$C$30 |
|
PRS_JTest |
'IPR Reference'!$B$22 |
|
PRS_Pb |
'IPR Reference'!$B$12 |
|
PRS_Pr |
'IPR Reference'!$B$11 |
|
PRS_Pwf |
'IPR Reference'!$B$13 |
|
PRS_PwfTest |
'IPR Reference'!$B$21 |
|
PRS_ReferenceInputs |
'IPR Reference'!$A$5:$B$22 |
IprWell inputs |
PRS_SkinCases |
'IPR Reference'!$A$26:$E$30 |
Case, Skin (—), PI (STB/d/psi), AOF (STB/d), Rate (STB/d) |
PRS_StimCheck |
'IPR Reference'!$B$47 |
Reference stimulation threshold verdict |
PRS_StimCheckNote |
'IPR Reference'!$C$47 |
Reference stimulation threshold comment |
PRS_Uo |
'IPR Reference'!$B$8 |
|
PRS_dq |
'IPR Reference'!$B$43 |
Incremental rate, STB/d |
PRS_h |
'IPR Reference'!$B$6 |
|
PRS_k |
'IPR Reference'!$B$5 |
|
PRS_ks |
'IPR Reference'!$B$16 |
|
PRS_q1 |
'IPR Reference'!$E$26 |
|
PRS_q2 |
'IPR Reference'!$E$27 |
|
PRS_q3 |
'IPR Reference'!$E$28 |
|
PRS_q4 |
'IPR Reference'!$E$29 |
|
PRS_q5 |
'IPR Reference'!$E$30 |
|
PRS_qMeasuredTest |
'IPR Reference'!$B$48 |
Independent test rate (test PI), STB/d |
PRS_qStim |
'IPR Reference'!$B$42 |
Rate stimulated, STB/d |
PRS_qTest |
'IPR Reference'!$B$46 |
Rate at independent test pressure, STB/d |
PRS_qToday |
'IPR Reference'!$B$41 |
Rate today, STB/d |
PRS_re |
'IPR Reference'!$B$9 |
|
PRS_rs |
'IPR Reference'!$B$17 |
|
PRS_rw |
'IPR Reference'!$B$10 |
|
PRS_s1 |
'IPR Reference'!$B$14 |
|
PRS_s2 |
'IPR Reference'!$B$15 |
|
PRS_s4 |
'IPR Reference'!$B$18 |
|
PRS_s5 |
'IPR Reference'!$B$19 |
|
PRS_sHawk |
'IPR Reference'!$B$24 |
Hawkins skin |
PRV_AfterNowA |
Value!$G$6 |
|
PRV_AfterNowB |
Value!$G$7 |
|
PRV_AfterNowC |
Value!$G$8 |
|
PRV_AfterNowRef |
Value!$G$5 |
|
PRV_ENPVA |
Value!$O$6 |
|
PRV_ENPVB |
Value!$O$7 |
|
PRV_ENPVC |
Value!$O$8 |
|
PRV_ENPVRef |
Value!$O$5 |
|
PRV_EconBaseA |
Value!$F$6 |
|
PRV_EconBaseB |
Value!$F$7 |
|
PRV_EconBaseC |
Value!$F$8 |
|
PRV_EconBaseRef |
Value!$F$5 |
|
PRV_GoCheckA |
Value!$B$12 |
A: decision verdict |
PRV_GoCheckANote |
Value!$C$12 |
A: decision comment |
PRV_GoCheckB |
Value!$B$13 |
B: decision verdict |
PRV_GoCheckBNote |
Value!$C$13 |
B: decision comment |
PRV_GoCheckC |
Value!$B$14 |
C: decision verdict |
PRV_GoCheckCNote |
Value!$C$14 |
C: decision comment |
PRV_GoCheckRef |
Value!$B$11 |
Ref: decision verdict |
PRV_GoCheckRefNote |
Value!$C$11 |
Ref: decision comment |
PRV_IncEURA |
Value!$L$6 |
|
PRV_IncEURB |
Value!$L$7 |
|
PRV_IncEURC |
Value!$L$8 |
|
PRV_IncEURRef |
Value!$L$5 |
|
PRV_IncNowA |
Value!$E$6 |
|
PRV_IncNowB |
Value!$E$7 |
|
PRV_IncNowC |
Value!$E$8 |
|
PRV_IncNowRef |
Value!$E$5 |
|
PRV_IprBaseA |
Value!$R$6 |
|
PRV_IprBaseB |
Value!$R$7 |
|
PRV_IprBaseC |
Value!$R$8 |
|
PRV_NPVA |
Value!$H$6 |
|
PRV_NPVB |
Value!$H$7 |
|
PRV_NPVC |
Value!$H$8 |
|
PRV_NPVRef |
Value!$H$5 |
|
PRV_NetCashA |
Value!$M$6 |
|
PRV_NetCashB |
Value!$M$7 |
|
PRV_NetCashC |
Value!$M$8 |
|
PRV_NetCashRef |
Value!$M$5 |
|
PRV_NpvFailA |
Value!$N$6 |
|
PRV_NpvFailB |
Value!$N$7 |
|
PRV_NpvFailC |
Value!$N$8 |
|
PRV_NpvFailRef |
Value!$N$5 |
|
PRV_PVIA |
Value!$K$6 |
|
PRV_PVIB |
Value!$K$7 |
|
PRV_PVIC |
Value!$K$8 |
|
PRV_PVIRef |
Value!$K$5 |
|
PRV_PayoutA |
Value!$I$6 |
|
PRV_PayoutB |
Value!$I$7 |
|
PRV_PayoutC |
Value!$I$8 |
|
PRV_PayoutRef |
Value!$I$5 |
|
PRV_PcMinA |
Value!$P$6 |
|
PRV_PcMinB |
Value!$P$7 |
|
PRV_PcMinC |
Value!$P$8 |
|
PRV_PcMinRef |
Value!$P$5 |
|
PRV_PvCostA |
Value!$J$6 |
|
PRV_PvCostB |
Value!$J$7 |
|
PRV_PvCostC |
Value!$J$8 |
|
PRV_PvCostRef |
Value!$J$5 |
|
PRV_RateCheckA |
Value!$B$16 |
A: EconWell rate verdict |
PRV_RateCheckANote |
Value!$C$16 |
A: EconWell rate comment |
PRV_RateCheckB |
Value!$B$17 |
B: EconWell rate verdict |
PRV_RateCheckBNote |
Value!$C$17 |
B: EconWell rate comment |
PRV_RateCheckC |
Value!$B$18 |
C: EconWell rate verdict |
PRV_RateCheckCNote |
Value!$C$18 |
C: EconWell rate comment |
PRV_RateCheckRef |
Value!$B$15 |
Ref: EconWell rate verdict |
PRV_RateCheckRefNote |
Value!$C$15 |
Ref: EconWell rate comment |
PRV_UpliftMinA |
Value!$Q$6 |
|
PRV_UpliftMinB |
Value!$Q$7 |
|
PRV_UpliftMinC |
Value!$Q$8 |
|
PRV_UpliftMinRef |
Value!$Q$5 |
|
PRV_ValueTable |
Value!$A$5:$R$8 |
Workover values |
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 | WellProductivityReview.xlsx, 61 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.
Production Surveillance
PO Add-in + Microsoft 365Whether an oil well's rate, GOR, WOR or productivity index has moved off trend enough to review, beside decline, WOR, inflow and loading references.
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.
Need a workbook we don't have? Suggest a Workbook










