Description
Which workovers should the budget fund? You enter a shared IPR well and, for each candidate, its permeability, current and target skin, cost and chance of success, with a decline, price deck and costs to value the gain. You read off each candidate's incremental rate, its success, failure and risked NPV, and which jobs the budget funds in order of risked NPV per dollar.
How to use it: Enter the reservoir, fluid and common flowing pressure, and each candidate's permeability, skins, cost and chance of success, on the Candidates sheet. Set the economics deck, the well's age and the incremental decline on the Workover Cash Flows sheet, and the budget on the Programme sheet. Check the input and horizon checks first, then each candidate's uplift against its own IPR base and its post-workover rate against the type curve's initial rate. Read the ranking, the funded jobs and the spend on the Programme sheet and the Summary. Replace every illustrative input with field data before a decision.
Method: Each candidate's productivity index is the pseudo-steady-state vertical-well index for today's skin and for the target skin, J = k h/(141.2 Bo μo (ln(re/rw) − 0.75 + S)), and its rate at the common flowing pressure is Vogel's composite IPR, q = J (Pr − Pb) + J Pb/1.8 (1 − 0.2 (Pwf/Pb) − 0.8 (Pwf/Pb)^2). The uplift is the target-skin rate less today's. The incremental rate then declines exponentially, sampled at mid-month, until the base well's economic life ends, with the nominal decline −ln(1 − D) from the effective. The incremental barrels earn the net operating margin; the workover's WI-adjusted cost falls in month one. Fixed LOE is not incremental. The success NPV discounts the monthly net cash at the month ends. The failure NPV is the negative discounted cost; the risked NPV is Pc × success NPV + (1 − Pc) × failure NPV.
Eligible jobs have positive uplift, cost and risked NPV. They are ranked by risked NPV over the undiscounted WI-adjusted capex, ties in input order. The walk goes down the ranks once, funding each affordable job and skipping an unaffordable one while continuing to the next; the budget counts the same WI-adjusted cost. This is a greedy heuristic for indivisible projects, not an optimal knapsack; shared constraints, interactions between jobs and scheduling are left out.
Example: Three synthetic variations of the IPR reference well (k = 0.5 mD, skins 1, 2 and 3 to −2, Pwf = 2,000 psi) gain about 48.24, 57.61 and 65.22 STB/d. Their success NPVs are about $654,206, $700,044 and −$134,137, and their risked NPVs about $453,919, $460,827 and −$404,937. At the $1,000,000 budget the ranking by risked NPV per dollar funds A, then B, spends $850,000 and leaves $150,000. The economics are the shared decline, price deck and costs of the economics family's well; beside the candidates sit the original IPR reference well, an independent 60 STB/d workover and the full-well NPV and IRR, which is not a workover. These rounded numbers are illustrations; each blueprint gives its own on the same inputs.
Validity
The workover cash flows run for at most 360 months and the full-well reference for at most 400 months. If either requested horizon exceeds its limit, its check and the overall verdict fail; the bounded values shown are invalid previews, and the programme excludes every candidate when the workover horizon is invalid. The IPR geometry, fluid properties, pressures, each candidate's permeability, the skin term, the cost and the chance must pass the input check. Do not decide on an invalid case.
The IPR and the economic type curve are independent examples, not a calibrated well. Both base rates are shown, with separate checks on the IPR uplift against its own base and on the post-workover type-curve rate against its initial rate. No rate is silently scaled or capped. The model ignores a workover's life extension, changing fixed costs and production acceleration. Replace every illustrative input with supported field data before a decision.
References
- Vogel, J.V. (1968). Inflow Performance Relationships for Solution-Gas Drive Wells. JPT 20(1), 83-92.
- Petroleum Office blueprints
po.bp.ipr.skin.sensitivity,po.bp.econ.workover.decisionandpo.bp.econ.npv.irr.
Inputs
| Input | Unit | Default | Name |
|---|---|---|---|
| Net pay | ft | 50 | WEC_h |
| Oil formation volume factor | rb/STB | 1.467 | WEC_Bo |
| Oil viscosity | cp | 0.302 | WEC_Uo |
| Drainage radius | ft | 1,490 | WEC_re |
| Wellbore radius | ft | 0.354 | WEC_rw |
| Reservoir pressure | psi | 4,000 | WEC_Pr |
| Bubble point | psi | 2,620 | WEC_Pb |
| Common flowing pressure | psi | 2,000 | WEC_Pwf |
| Permeability (candidates A, B, C) | mD | 0.5, 0.5, 0.5 | WEC_A_k, WEC_B_k, WEC_C_k |
| Current skin | — | 1, 2, 3 | WEC_A_Skin, WEC_B_Skin, WEC_C_Skin |
| Target skin | — | −2, −2, −2 | WEC_A_Target, WEC_B_Target, WEC_C_Target |
| Workover cost | $ | 350,000, 500,000, 1,500,000 | WEC_A_Cost, WEC_B_Cost, WEC_C_Cost |
| Chance of success | % | 80 % each | WEC_A_Pc, WEC_B_Pc, WEC_C_Pc |
| Economics deck: the shared well's life cap, type curve, prices, interests, Texas taxes, operating costs and discount rate | various | the economics family's well (800 STB/d, $70/STB oil, 10 %) | WEV_* |
| Months the well has produced before the workover | months | 36 | WEV_Age |
| Decline of the incremental rate, effective (exponential) | %/yr | 50 % | WEV_UpDecl |
| Incremental oil rate the workover adds at the start (60 STB/d reference) | STB/d | 60 | WEV_Reference_Uplift |
| Workover cost, paid in the first month (reference) | $ | 350,000 | WEV_Reference_Cost |
| Chance the workover succeeds (reference) | % | 80 % | WEV_Reference_Pc |
| Longest acceptable payout, from the workover | months | 12 | WEV_PayoutMax |
| Full-well reference: the same well's inputs | various | the economics family's well | WEN_* |
| Available budget | $ | 1,000,000 | WEP_Budget |
Sheets
Guide— what the workbook screens, how success, failure and risk are valued, and the limits of the greedy programme.Candidates— the shared IPR inputs, candidates A, B and C with their permeability, skins, cost and chance, each one's productivity index and IPR rate before and after treatment, the skin-derived uplift, the original IPR reference and the candidate checks.Workover Cash Flows— the economics deck, the base decline and remaining life, each candidate's and the 60 STB/d reference's incremental rate, success, failure and risked NPV, payout, PV/I, break-even chance and uplift, the monthly incremental cash flows and a chart of their first 60 months.Well Reference— the independent full-well NPV, IRR, payout, PV/I, EUR and net cash from a monthly cash flow, with its horizon check.Programme— the budget, each candidate's eligibility, risked NPV per dollar and rank, the greedy walk funding or skipping each rank, and the spend, headroom and funded NPVs.Summary— the programme's spend, headroom, NPVs and selected candidates, and every check under one verdict.Test Cases— the worked example and other cases, with expected and computed results.
The add-in supplies the IPR functions; Excel 365 supplies dynamic arrays.
Functions used
PO.IPR.VW.PSS.PIPO.IPR.VW.PSS.Rate.ByVogelPO.ECON.NPV.MonthlyPO.ECON.IRR.MonthlyPO.ECON.Payout
Names (266)
| Name | Refers to | Comment |
|---|---|---|
PO.ECON.IRR.MonthlyLAMBDA |
=LAMBDA(cash,LET(cash_col,cash,grid_step,0.0025,rates,SEQUENCE(1,201,-0.05,grid_step),periods,SEQUENCE(ROWS(cash_col)),npv_grid,MMULT(TRANSPOSE(cash_col),(1+rates)^(-periods)),first_pos,IFERROR(XMATCH(TRUE,npv_grid>0),0),crossing,IF(first_pos=0,0,IFERROR(XMATCH(1,(SEQUENCE(1,201)>first_pos)*(npv_grid<=0)),0)),IF(crossing=0,"n/a",LET(r_lo,INDEX(rates,1,crossing-1),v_lo,INDEX(npv_grid,1,crossing-1),v_hi,INDEX(npv_grid,1,crossing),r_interp,r_lo+grid_step*v_lo/(v_lo-v_hi),r_refined,IFERROR(IRR(cash_col,r_lo),r_interp),(1+IF(AND(r_refined>=r_lo,r_refined<=r_lo+grid_step),r_refined,r_interp))^12-1)))) |
Annualised IRR of monthly cash flows: the first rate, scanning up from -5 %/month, at which NPV falls through zero; "n/a" when it never does |
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 |
WEC_A_After |
Candidates!$B$24 |
IPR rate after treatment, STB/d |
WEC_A_Base |
Candidates!$B$23 |
IPR base rate, STB/d |
WEC_A_Cost |
Candidates!$B$19 |
Workover cost, $ |
WEC_A_J |
Candidates!$B$21 |
Current productivity index, STB/d/psi |
WEC_A_JTarget |
Candidates!$B$22 |
Target productivity index, STB/d/psi |
WEC_A_Pc |
Candidates!$B$20 |
Chance of success, % |
WEC_A_RateCheck |
Candidates!$B$31 |
A: IPR uplift against its own base verdict |
WEC_A_RateCheckNote |
Candidates!$C$31 |
A: IPR uplift against its own base comment |
WEC_A_Skin |
Candidates!$B$17 |
Current skin |
WEC_A_Target |
Candidates!$B$18 |
Target skin |
WEC_A_Uplift |
Candidates!$B$25 |
Skin-derived uplift, STB/d |
WEC_A_k |
Candidates!$B$16 |
Permeability, mD |
WEC_B_After |
Candidates!$C$24 |
IPR rate after treatment, STB/d |
WEC_B_Base |
Candidates!$C$23 |
IPR base rate, STB/d |
WEC_B_Cost |
Candidates!$C$19 |
Workover cost, $ |
WEC_B_J |
Candidates!$C$21 |
Current productivity index, STB/d/psi |
WEC_B_JTarget |
Candidates!$C$22 |
Target productivity index, STB/d/psi |
WEC_B_Pc |
Candidates!$C$20 |
Chance of success, % |
WEC_B_RateCheck |
Candidates!$B$32 |
B: IPR uplift against its own base verdict |
WEC_B_RateCheckNote |
Candidates!$C$32 |
B: IPR uplift against its own base comment |
WEC_B_Skin |
Candidates!$C$17 |
Current skin |
WEC_B_Target |
Candidates!$C$18 |
Target skin |
WEC_B_Uplift |
Candidates!$C$25 |
Skin-derived uplift, STB/d |
WEC_B_k |
Candidates!$C$16 |
Permeability, mD |
WEC_Bo |
Candidates!$B$5 |
Oil formation volume factor, bbl/STB |
WEC_C_After |
Candidates!$D$24 |
IPR rate after treatment, STB/d |
WEC_C_Base |
Candidates!$D$23 |
IPR base rate, STB/d |
WEC_C_Cost |
Candidates!$D$19 |
Workover cost, $ |
WEC_C_J |
Candidates!$D$21 |
Current productivity index, STB/d/psi |
WEC_C_JTarget |
Candidates!$D$22 |
Target productivity index, STB/d/psi |
WEC_C_Pc |
Candidates!$D$20 |
Chance of success, % |
WEC_C_RateCheck |
Candidates!$B$33 |
C: IPR uplift against its own base verdict |
WEC_C_RateCheckNote |
Candidates!$C$33 |
C: IPR uplift against its own base comment |
WEC_C_Skin |
Candidates!$D$17 |
Current skin |
WEC_C_Target |
Candidates!$D$18 |
Target skin |
WEC_C_Uplift |
Candidates!$D$25 |
Skin-derived uplift, STB/d |
WEC_C_k |
Candidates!$D$16 |
Permeability, mD |
WEC_InputCheck |
Candidates!$B$34 |
Candidate input check verdict |
WEC_InputCheckNote |
Candidates!$C$34 |
Candidate input check comment |
WEC_Inputs |
Candidates!$B$4:$B$11 |
Shared IPR inputs |
WEC_Pb |
Candidates!$B$10 |
Bubble point, psi |
WEC_Pr |
Candidates!$B$9 |
Reservoir pressure, psi |
WEC_Pwf |
Candidates!$B$11 |
Common flowing pressure, psi |
WEC_RefJ |
Candidates!$B$27 |
Reference today's PI, STB/d/psi |
WEC_RefJTarget |
Candidates!$B$28 |
Reference stimulated PI, STB/d/psi |
WEC_RefUplift |
Candidates!$B$29 |
Reference uplift, not a candidate, STB/d |
WEC_Results |
Candidates!$B$21:$D$25 |
Candidate IPR results |
WEC_Uo |
Candidates!$B$6 |
Oil viscosity, cp |
WEC_h |
Candidates!$B$4 |
Net pay, ft |
WEC_re |
Candidates!$B$7 |
Drainage radius, ft |
WEC_rw |
Candidates!$B$8 |
Wellbore radius, ft |
WEN_AdVal |
'Well Reference'!$B$21 |
Ad valorem tax, as a share of net revenue, % |
WEN_DC |
'Well Reference'!$B$22 |
Drilling and completion of the well, $MM |
WEN_Days |
'Well Reference'!$B$34 |
Days per month, days/month |
WEN_Dei |
'Well Reference'!$B$8 |
Initial decline, effective secant, %/yr |
WEN_Di |
'Well Reference'!$B$38 |
Initial nominal decline, from the effective secant, 1/yr |
WEN_Disc |
'Well Reference'!$B$31 |
Discount rate, end-of-month cash flows, %/yr |
WEN_Dt |
'Well Reference'!$B$39 |
Terminal nominal decline, from the effective, 1/yr |
WEN_Dterm |
'Well Reference'!$B$9 |
Terminal decline, effective (exponential tail), %/yr |
WEN_EUR |
'Well Reference'!$B$56 |
Oil EUR, MSTB |
WEN_Esc |
'Well Reference'!$B$16 |
Escalation of prices and operating costs, %/yr |
WEN_GOR |
'Well Reference'!$B$10 |
Gas-oil ratio, constant over life, scf/STB |
WEN_Gas |
'Well Reference'!$B$14 |
Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu |
WEN_GasDiff |
'Well Reference'!$B$15 |
Gas differential, deducted (Waha basis), $/MMBtu |
WEN_Gath |
'Well Reference'!$B$25 |
Gas gathering and processing, $/Mscf |
WEN_HorizonCheck |
'Well Reference'!$B$49 |
Full-well reference horizon verdict |
WEN_HorizonCheckNote |
'Well Reference'!$C$49 |
Full-well reference horizon comment |
WEN_Hurdle |
'Well Reference'!$B$32 |
IRR hurdle, %/yr |
WEN_IP |
'Well Reference'!$B$6 |
Initial oil rate of the type curve, STB/d |
WEN_IRR |
'Well Reference'!$B$52 |
IRR, %/yr |
WEN_LOE |
'Well Reference'!$B$23 |
Fixed LOE, $/well-month |
WEN_LOEVar |
'Well Reference'!$B$24 |
Variable LOE per barrel of oil, $/STB |
WEN_Life |
'Well Reference'!$B$46 |
Producing life, to the economic limit or the cap, months |
WEN_LifeCap |
'Well Reference'!$B$5 |
Longest producing life of the well, months |
WEN_Margin |
'Well Reference'!$B$43 |
Operating margin per barrel of oil, net of royalty and taxes, $/STB |
WEN_MoYr |
'Well Reference'!$B$35 |
Months per year, months/year |
WEN_N |
'Well Reference'!$B$48 |
Bounded months (preview only if horizon check fails), months |
WEN_NPV |
'Well Reference'!$B$51 |
NPV, $MM |
WEN_NRI |
'Well Reference'!$B$18 |
Net revenue interest (25 % royalty at 100 % WI), % |
WEN_NetCash |
'Well Reference'!$B$57 |
Net cash, $MM |
WEN_Oil |
'Well Reference'!$B$12 |
Oil price (WTI), $/STB |
WEN_OilDiff |
'Well Reference'!$B$13 |
Oil differential, deducted (quality and transport), $/STB |
WEN_Online |
'Well Reference'!$B$4 |
Month the well comes online (month 1 starts the evaluation), months |
WEN_PA |
'Well Reference'!$B$26 |
Plugging and abandonment, the month after the last production, $ |
WEN_PVI |
'Well Reference'!$B$55 |
PV/I |
WEN_Payout |
'Well Reference'!$B$53 |
Payout, months |
WEN_PayoutMax |
'Well Reference'!$B$33 |
Longest acceptable payout, from month 1, months |
WEN_PerMM |
'Well Reference'!$B$36 |
Dollars per million, $/MM |
WEN_Phase1 |
'Well Reference'!$B$30 |
D&C share spent the month before online, % |
WEN_Phase2 |
'Well Reference'!$B$29 |
D&C share spent two months before online, % |
WEN_Phase3 |
'Well Reference'!$B$28 |
D&C share spent three months before online, % |
WEN_Phase4 |
'Well Reference'!$B$27 |
D&C share spent four months before online, % |
WEN_PvCapital |
'Well Reference'!$B$54 |
Discounted capital, $MM |
WEN_QLimit |
'Well Reference'!$B$44 |
Economic-limit oil rate, fixed LOE over the margin, STB/d |
WEN_Qi |
'Well Reference'!$B$42 |
Initial oil rate, IP × type-curve factor, STB/d |
WEN_Qs |
'Well Reference'!$B$41 |
Rate at the switch over the initial rate |
WEN_RequestedN |
'Well Reference'!$B$47 |
Requested months through plugging, months |
WEN_SevGas |
'Well Reference'!$B$20 |
Gas severance tax (Texas, of the gas's value), % |
WEN_SevOil |
'Well Reference'!$B$19 |
Oil severance tax (Texas, of the oil's value), % |
WEN_TC |
'Well Reference'!$B$11 |
Type-curve factor (scales the initial rate) |
WEN_TLimit |
'Well Reference'!$B$45 |
Time the decline takes to reach the limit, years |
WEN_Ts |
'Well Reference'!$B$40 |
Time the hyperbolic switches to the terminal decline, years |
WEN_WI |
'Well Reference'!$B$17 |
Working interest (scales costs and capital), % |
WEN_b |
'Well Reference'!$B$7 |
Arps hyperbolic exponent b |
WEP_A_Eligible |
Programme!$B$9 |
Eligible (1=yes) |
WEP_A_Rank |
Programme!$B$11 |
Rank (zero excluded) |
WEP_A_Ratio |
Programme!$B$10 |
Risked NPV / cost |
WEP_B_Eligible |
Programme!$C$9 |
Eligible (1=yes) |
WEP_B_Rank |
Programme!$C$11 |
Rank (zero excluded) |
WEP_B_Ratio |
Programme!$C$10 |
Risked NPV / cost |
WEP_Budget |
Programme!$B$4 |
Available budget, $ |
WEP_BudgetCheck |
Programme!$B$5 |
Budget check verdict |
WEP_BudgetCheckNote |
Programme!$C$5 |
Budget check comment |
WEP_C_Eligible |
Programme!$D$9 |
Eligible (1=yes) |
WEP_C_Rank |
Programme!$D$11 |
Rank (zero excluded) |
WEP_C_Ratio |
Programme!$D$10 |
Risked NPV / cost |
WEP_ENPV |
Programme!$B$25 |
Risked NPV, $MM |
WEP_Headroom |
Programme!$B$23 |
Headroom, $ |
WEP_NPV |
Programme!$B$24 |
Success NPV, $MM |
WEP_R1_Cost |
Programme!$B$15 |
Cost, $ |
WEP_R1_Decision |
Programme!$B$18 |
Decision |
WEP_R1_ENPV |
Programme!$B$20 |
Risked NPV funded, $MM |
WEP_R1_Funded |
Programme!$B$16 |
Funded (1=yes) |
WEP_R1_Index |
Programme!$B$14 |
Candidate index (A=1, B=2, C=3) |
WEP_R1_NPV |
Programme!$B$19 |
Success NPV funded, $MM |
WEP_R1_Remaining |
Programme!$B$17 |
Budget remaining, $ |
WEP_R2_Cost |
Programme!$C$15 |
Cost, $ |
WEP_R2_Decision |
Programme!$C$18 |
Decision |
WEP_R2_ENPV |
Programme!$C$20 |
Risked NPV funded, $MM |
WEP_R2_Funded |
Programme!$C$16 |
Funded (1=yes) |
WEP_R2_Index |
Programme!$C$14 |
Candidate index (A=1, B=2, C=3) |
WEP_R2_NPV |
Programme!$C$19 |
Success NPV funded, $MM |
WEP_R2_Remaining |
Programme!$C$17 |
Budget remaining, $ |
WEP_R3_Cost |
Programme!$D$15 |
Cost, $ |
WEP_R3_Decision |
Programme!$D$18 |
Decision |
WEP_R3_ENPV |
Programme!$D$20 |
Risked NPV funded, $MM |
WEP_R3_Funded |
Programme!$D$16 |
Funded (1=yes) |
WEP_R3_Index |
Programme!$D$14 |
Candidate index (A=1, B=2, C=3) |
WEP_R3_NPV |
Programme!$D$19 |
Success NPV funded, $MM |
WEP_R3_Remaining |
Programme!$D$17 |
Budget remaining, $ |
WEP_Spend |
Programme!$B$22 |
Spend, $ |
WEV_A_AfterNow |
'Workover Cash Flows'!$B$53 |
After-workover type-curve rate, STB/d |
WEV_A_BaseDifference |
'Workover Cash Flows'!$B$51 |
IPR base less type-curve base, STB/d |
WEV_A_Capex |
'Workover Cash Flows'!$B$64 |
WI-adjusted undiscounted cost, $ |
WEV_A_ENPV |
'Workover Cash Flows'!$B$61 |
Risked NPV, $MM |
WEV_A_IncEUR |
'Workover Cash Flows'!$B$58 |
Incremental oil over horizon, MSTB |
WEV_A_IncNow |
'Workover Cash Flows'!$B$52 |
Incremental first-month rate, STB/d |
WEV_A_IprBase |
'Workover Cash Flows'!$B$50 |
Candidate IPR base at common pressure, STB/d |
WEV_A_NPV |
'Workover Cash Flows'!$B$54 |
Success NPV, $MM |
WEV_A_NetCash |
'Workover Cash Flows'!$B$59 |
Incremental net cash, $MM |
WEV_A_NpvFail |
'Workover Cash Flows'!$B$60 |
Failure NPV, $MM |
WEV_A_PVI |
'Workover Cash Flows'!$B$57 |
PV/I |
WEV_A_Payout |
'Workover Cash Flows'!$B$55 |
Payout month, months |
WEV_A_PcMin |
'Workover Cash Flows'!$B$62 |
Break-even chance, % |
WEV_A_PvCost |
'Workover Cash Flows'!$B$56 |
Discounted cost, $MM |
WEV_A_RateCheck |
'Workover Cash Flows'!$B$67 |
A: type-curve rate check verdict |
WEV_A_RateCheckNote |
'Workover Cash Flows'!$C$67 |
A: type-curve rate check comment |
WEV_A_UpliftMin |
'Workover Cash Flows'!$B$63 |
Break-even uplift, STB/d |
WEV_AdVal |
'Workover Cash Flows'!$B$20 |
Ad valorem tax, as a share of net revenue, % |
WEV_Age |
'Workover Cash Flows'!$B$25 |
Months the well has produced before the workover, months |
WEV_B_AfterNow |
'Workover Cash Flows'!$C$53 |
After-workover type-curve rate, STB/d |
WEV_B_BaseDifference |
'Workover Cash Flows'!$C$51 |
IPR base less type-curve base, STB/d |
WEV_B_Capex |
'Workover Cash Flows'!$C$64 |
WI-adjusted undiscounted cost, $ |
WEV_B_ENPV |
'Workover Cash Flows'!$C$61 |
Risked NPV, $MM |
WEV_B_IncEUR |
'Workover Cash Flows'!$C$58 |
Incremental oil over horizon, MSTB |
WEV_B_IncNow |
'Workover Cash Flows'!$C$52 |
Incremental first-month rate, STB/d |
WEV_B_IprBase |
'Workover Cash Flows'!$C$50 |
Candidate IPR base at common pressure, STB/d |
WEV_B_NPV |
'Workover Cash Flows'!$C$54 |
Success NPV, $MM |
WEV_B_NetCash |
'Workover Cash Flows'!$C$59 |
Incremental net cash, $MM |
WEV_B_NpvFail |
'Workover Cash Flows'!$C$60 |
Failure NPV, $MM |
WEV_B_PVI |
'Workover Cash Flows'!$C$57 |
PV/I |
WEV_B_Payout |
'Workover Cash Flows'!$C$55 |
Payout month, months |
WEV_B_PcMin |
'Workover Cash Flows'!$C$62 |
Break-even chance, % |
WEV_B_PvCost |
'Workover Cash Flows'!$C$56 |
Discounted cost, $MM |
WEV_B_RateCheck |
'Workover Cash Flows'!$B$68 |
B: type-curve rate check verdict |
WEV_B_RateCheckNote |
'Workover Cash Flows'!$C$68 |
B: type-curve rate check comment |
WEV_B_UpliftMin |
'Workover Cash Flows'!$C$63 |
Break-even uplift, STB/d |
WEV_BaseNow |
'Workover Cash Flows'!$B$47 |
Type-curve base rate, first month, STB/d |
WEV_C_AfterNow |
'Workover Cash Flows'!$D$53 |
After-workover type-curve rate, STB/d |
WEV_C_BaseDifference |
'Workover Cash Flows'!$D$51 |
IPR base less type-curve base, STB/d |
WEV_C_Capex |
'Workover Cash Flows'!$D$64 |
WI-adjusted undiscounted cost, $ |
WEV_C_ENPV |
'Workover Cash Flows'!$D$61 |
Risked NPV, $MM |
WEV_C_IncEUR |
'Workover Cash Flows'!$D$58 |
Incremental oil over horizon, MSTB |
WEV_C_IncNow |
'Workover Cash Flows'!$D$52 |
Incremental first-month rate, STB/d |
WEV_C_IprBase |
'Workover Cash Flows'!$D$50 |
Candidate IPR base at common pressure, STB/d |
WEV_C_NPV |
'Workover Cash Flows'!$D$54 |
Success NPV, $MM |
WEV_C_NetCash |
'Workover Cash Flows'!$D$59 |
Incremental net cash, $MM |
WEV_C_NpvFail |
'Workover Cash Flows'!$D$60 |
Failure NPV, $MM |
WEV_C_PVI |
'Workover Cash Flows'!$D$57 |
PV/I |
WEV_C_Payout |
'Workover Cash Flows'!$D$55 |
Payout month, months |
WEV_C_PcMin |
'Workover Cash Flows'!$D$62 |
Break-even chance, % |
WEV_C_PvCost |
'Workover Cash Flows'!$D$56 |
Discounted cost, $MM |
WEV_C_RateCheck |
'Workover Cash Flows'!$B$69 |
C: type-curve rate check verdict |
WEV_C_RateCheckNote |
'Workover Cash Flows'!$C$69 |
C: type-curve rate check comment |
WEV_C_UpliftMin |
'Workover Cash Flows'!$D$63 |
Break-even uplift, STB/d |
WEV_CashFlowCurve |
'Workover Cash Flows'!$A$160:$D$219 |
Incremental monthly cash flow: first 60 months |
WEV_Days |
'Workover Cash Flows'!$B$31 |
Days per month, days/month |
WEV_Dei |
'Workover Cash Flows'!$B$7 |
Initial decline, effective secant, %/yr |
WEV_Di |
'Workover Cash Flows'!$B$35 |
Initial nominal decline, from the effective secant, 1/yr |
WEV_Disc |
'Workover Cash Flows'!$B$24 |
Discount rate, end-of-month cash flows, %/yr |
WEV_Dt |
'Workover Cash Flows'!$B$36 |
Terminal nominal decline, from the effective, 1/yr |
WEV_Dterm |
'Workover Cash Flows'!$B$8 |
Terminal decline, effective (exponential tail), %/yr |
WEV_Dw |
'Workover Cash Flows'!$B$46 |
Nominal incremental decline, 1/yr |
WEV_Esc |
'Workover Cash Flows'!$B$15 |
Escalation of prices and operating costs, %/yr |
WEV_GOR |
'Workover Cash Flows'!$B$9 |
Gas-oil ratio, constant over life, scf/STB |
WEV_Gas |
'Workover Cash Flows'!$B$13 |
Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu |
WEV_GasDiff |
'Workover Cash Flows'!$B$14 |
Gas differential, deducted (Waha basis), $/MMBtu |
WEV_Gath |
'Workover Cash Flows'!$B$23 |
Gas gathering and processing, $/Mscf |
WEV_HorizonCheck |
'Workover Cash Flows'!$B$66 |
Workover horizon verdict |
WEV_HorizonCheckNote |
'Workover Cash Flows'!$C$66 |
Workover horizon comment |
WEV_IP |
'Workover Cash Flows'!$B$5 |
Initial oil rate of the type curve, STB/d |
WEV_LOE |
'Workover Cash Flows'!$B$21 |
Fixed LOE, $/well-month |
WEV_LOEVar |
'Workover Cash Flows'!$B$22 |
Variable LOE per barrel of oil, $/STB |
WEV_Life |
'Workover Cash Flows'!$B$43 |
Producing life, to the economic limit or the cap, months |
WEV_LifeCap |
'Workover Cash Flows'!$B$4 |
Longest producing life of the well, months |
WEV_Margin |
'Workover Cash Flows'!$B$40 |
Operating margin per barrel of oil, net of royalty and taxes, $/STB |
WEV_MoYr |
'Workover Cash Flows'!$B$32 |
Months per year, months/year |
WEV_N |
'Workover Cash Flows'!$B$45 |
Bounded months (preview only if horizon check fails), months |
WEV_NRI |
'Workover Cash Flows'!$B$17 |
Net revenue interest (25 % royalty at 100 % WI), % |
WEV_Oil |
'Workover Cash Flows'!$B$11 |
Oil price (WTI), $/STB |
WEV_OilDiff |
'Workover Cash Flows'!$B$12 |
Oil differential, deducted (quality and transport), $/STB |
WEV_PayoutMax |
'Workover Cash Flows'!$B$30 |
Longest acceptable payout, from the workover, months |
WEV_PerMM |
'Workover Cash Flows'!$B$33 |
Dollars per million, $/MM |
WEV_QLimit |
'Workover Cash Flows'!$B$41 |
Economic-limit oil rate, fixed LOE over the margin, STB/d |
WEV_Qi |
'Workover Cash Flows'!$B$39 |
Initial oil rate, IP × type-curve factor, STB/d |
WEV_Qs |
'Workover Cash Flows'!$B$38 |
Rate at the switch over the initial rate |
WEV_Reference_AfterNow |
'Workover Cash Flows'!$E$53 |
After-workover type-curve rate, STB/d |
WEV_Reference_Capex |
'Workover Cash Flows'!$E$64 |
WI-adjusted undiscounted cost, $ |
WEV_Reference_Cost |
'Workover Cash Flows'!$B$28 |
Workover cost, paid in the first month, $ |
WEV_Reference_ENPV |
'Workover Cash Flows'!$E$61 |
Risked NPV, $MM |
WEV_Reference_IncEUR |
'Workover Cash Flows'!$E$58 |
Incremental oil over horizon, MSTB |
WEV_Reference_IncNow |
'Workover Cash Flows'!$E$52 |
Incremental first-month rate, STB/d |
WEV_Reference_NPV |
'Workover Cash Flows'!$E$54 |
Success NPV, $MM |
WEV_Reference_NetCash |
'Workover Cash Flows'!$E$59 |
Incremental net cash, $MM |
WEV_Reference_NpvFail |
'Workover Cash Flows'!$E$60 |
Failure NPV, $MM |
WEV_Reference_PVI |
'Workover Cash Flows'!$E$57 |
PV/I |
WEV_Reference_Payout |
'Workover Cash Flows'!$E$55 |
Payout month, months |
WEV_Reference_Pc |
'Workover Cash Flows'!$B$29 |
Chance the workover succeeds, % |
WEV_Reference_PcMin |
'Workover Cash Flows'!$E$62 |
Break-even chance, % |
WEV_Reference_PvCost |
'Workover Cash Flows'!$E$56 |
Discounted cost, $MM |
WEV_Reference_RateCheck |
'Workover Cash Flows'!$B$70 |
Reference: type-curve rate check verdict |
WEV_Reference_RateCheckNote |
'Workover Cash Flows'!$C$70 |
Reference: type-curve rate check comment |
WEV_Reference_Uplift |
'Workover Cash Flows'!$B$27 |
Incremental oil rate the workover adds at the start, STB/d |
WEV_Reference_UpliftMin |
'Workover Cash Flows'!$E$63 |
Break-even uplift, STB/d |
WEV_RequestedN |
'Workover Cash Flows'!$B$44 |
Requested months in incremental cash flow, months |
WEV_SevGas |
'Workover Cash Flows'!$B$19 |
Gas severance tax (Texas, of the gas's value), % |
WEV_SevOil |
'Workover Cash Flows'!$B$18 |
Oil severance tax (Texas, of the oil's value), % |
WEV_TC |
'Workover Cash Flows'!$B$10 |
Type-curve factor (scales the initial rate) |
WEV_TLimit |
'Workover Cash Flows'!$B$42 |
Time the decline takes to reach the limit, years |
WEV_Ts |
'Workover Cash Flows'!$B$37 |
Time the hyperbolic switches to the terminal decline, years |
WEV_UpDecl |
'Workover Cash Flows'!$B$26 |
Decline of the incremental rate, effective (exponential), %/yr |
WEV_WI |
'Workover Cash Flows'!$B$16 |
Working interest (scales costs and capital), % |
WEV_b |
'Workover Cash Flows'!$B$6 |
Arps hyperbolic exponent b |
WEZ_Checks |
Summary!$B$15:$B$25 |
Every named check |
WEZ_ENPV |
Summary!$B$10 |
Risked NPV, $MM |
WEZ_First |
Summary!$B$11 |
First selected candidate index |
WEZ_Headroom |
Summary!$B$8 |
Headroom, $ |
WEZ_NPV |
Summary!$B$9 |
Success NPV, $MM |
WEZ_Overall |
Summary!$B$4 |
Overall verdict |
WEZ_OverallNote |
Summary!$C$4 |
Overall comment |
WEZ_Second |
Summary!$B$12 |
Second selected candidate index |
WEZ_Spend |
Summary!$B$7 |
Spend, $ |
WEZ_Third |
Summary!$B$13 |
Third selected candidate index |
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 | WorkoverEconomics.xlsx, 100 KB |
| Category | Economics |
| For agents and tools | Descriptor (.md) |
More Economics Workbooks
Production Sharing Contract Fiscal Model
Microsoft 365How a production sharing contract splits one well's revenue over twenty years, and the contractor's NPV, IRR and break-even oil price.
Well Program Economics
Microsoft 365What a small horizontal well program is worth month by month, one scenario per row, as NPV, IRR and payout, and which input swings it most.
Need a workbook we don't have? Suggest a Workbook







