Well Productivity Review


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)

NameRefers toComment
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 inNeeds 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.
FileWellProductivityReview.xlsx, 61 KB
CategoryProduction
For agents and tools Descriptor (.md)
Tags:
IPRproductivity-indexskinstimulationmultilayerworkovereconomics

Need a workbook we don't have? Suggest a Workbook