---
cid: po.bp.econ.tornado.sensitivity
hub: econ
tags: [economics, tornado, sensitivity, NPV, price, capex, opex, EUR, timing, one-well, risk]
facets: { discipline: economics, method-type: analytical }
title: One-Well NPV Tornado
summary: "Shows which of price, capex, opex, EUR and timing moves a well's NPV most and whether any plausible case loses money."
slug: po.econ.tornado.sensitivity
type: worksheet
---

# One-Well NPV Tornado

## Description

Which input moves a well's value most, and does any plausible case lose money? You enter the well and a low and a high case for the price, the D&C, the fixed LOE, the EUR (through the type-curve factor) and the timing. The sheet moves one input at a time, the rest at the base case, and you read off the NPV at each case, the swings ranked largest first, and the cases that take the NPV to zero or below.

**Parameters:**
- **The well**: the month it comes online `TOR_Online`, the life cap `TOR_LifeCap` (months), the type curve's initial rate `TOR_IP` (STB/d), Arps exponent `TOR_b`, effective secant initial decline `TOR_Dei`, effective terminal decline `TOR_Dterm`, the gas-oil ratio `TOR_GOR` (scf/STB) and the type-curve factor `TOR_TC`
- **Prices**: oil `TOR_Oil` ($/STB) less `TOR_OilDiff`, gas `TOR_Gas` ($/MMBtu) less `TOR_GasDiff`, and escalation `TOR_Esc`
- **Interests and taxes**: `TOR_WI`, `TOR_NRI`, severance `TOR_SevOil` and `TOR_SevGas`, and ad valorem `TOR_AdVal`
- **Costs**: the D&C `TOR_DC` ($MM), fixed LOE `TOR_LOE` ($/well-month), variable LOE `TOR_LOEVar` ($/STB), gathering `TOR_Gath` ($/Mscf), plugging `TOR_PA` ($), and the D&C phasing `TOR_Phase4` to `TOR_Phase1`
- **Discounting**: `TOR_Disc`
- **Low and high cases**: price `TOR_PriceLo` and `TOR_PriceHi`, capex `TOR_CapexLo` and `TOR_CapexHi`, and opex `TOR_OpexLo` and `TOR_OpexHi`, each a multiple of the base; the type-curve factor `TOR_EurLo` and `TOR_EurHi`, a multiple of `TOR_TC`; and the shift `TOR_DelayLo` and `TOR_DelayHi` in months, negative earlier

**How to use it:** The well and its cases are the well-program workbook's illustrative ones; the sheet is that workbook's Tornado sheet reduced to one well. Type the well's own type curve, prices and costs over the inputs, and set each low and high case from the input's real range: the price deck's low and high, the AFE's contingency, the LOE history's spread, the type curve's P90 and P10, and the schedule's slip. The chart is a tornado of the NPV's change at each case, the largest swing at the top, and it stays sorted as the inputs change. The sheet flags a base case that loses money, names any low or high case that takes the NPV to zero or below, and flags an input whose low and high cases lie on the same side of the base, which makes its bars overlap.

**Method:** Each case's NPV is the full monthly model of the One-Well NPV and IRR sheet, written as one cell with that input moved, with the capital phased over the months before online: the type curve sampled at mid-month to the economic limit, so a lower price, a higher LOE or a weaker type curve also shortens the life; the margin per barrel after royalty, severance, ad valorem and variable costs; the fixed LOE, the phased D&C and the plugging; end-of-month discounting. Price moves oil and gas by the same factor, and capex the D&C only. Timing moves every cash flow by m months, which multiplies the NPV by (1 + Disc)^(−m/12), so it is exact without repricing. An input's swing is |NPV(high) − NPV(low)|; its rank counts the swings above it, a tie going to the row above, and the sorted table looks each rank up with INDEX and MATCH, so the chart's bars are the NPV's change from the base at each case, largest swing first.

**Example:** The default well is the One-Well NPV and IRR sheet's: the economics workbook's base case for one Texas horizontal, 800 STB/d on an Arps hyperbolic with b = 1 and a 65 %/yr secant decline to an 8 %/yr tail, $70/STB oil and $3.00/MMBtu gas, a 100 % WI and 75 % NRI, Texas severance and ad valorem, a $7MM well online in month 3, $8,000 a month of fixed LOE and 10 % discounting. The cases are the workbook's: price and D&C at 0.8 and 1.2 of the base, fixed LOE at 0.75 and 1.25, the type-curve factor at 0.75 (P90) and 1.3 (P10), and the well three months early or six late.

The base NPV is $9.80MM, the One-Well NPV and IRR sheet's. The EUR swings it most: $5.39MM at the P90 type curve and $15.08MM at the P10, a $9.69MM swing. Price follows: $5.74MM at 0.8 and $13.85MM at 1.2, $8.12MM. Capex: $11.17MM at 0.8 and $8.42MM at 1.2, $2.76MM, which is ±20 % of the $6.89MM discounted capital, as the D&C enters the cash flow linearly. Timing: 9.795 × 1.1^(3/12) = $10.03MM three months early and 9.795 × 1.1^(−6/12) = $9.34MM six months late, $0.69MM. Opex: $10.03MM and $9.56MM, $0.47MM. These are the workbook's eight-well tornado over its 7.782 discount-weighted wells (its $41.94MM P90 case is 7.782 × $5.39MM), in the same order. The lowest case, the P90 type curve, keeps the NPV at $5.39MM, so no plausible case loses money. At $30 oil the base case loses $1.11MM. A low type-curve factor of 0.4 takes the NPV to −$0.77MM, and the EUR is named as the losing case; a low price of 0.5 ($35 oil and $1.50 gas) gives −$0.35MM, a $14.20MM swing, and price takes the top.

## Validity

A one-at-a-time, before-income-tax tornado: it ranks the inputs but ignores their correlation (price and cost move together through a cycle), and a combined downside is worse than any single bar. The cases are deterministic low and high values, not P90 and P10 of a distribution, unless they were set from one. Each bar is stacked from the base, so an input's low and high changes should have opposite signs, which the case check enforces. Price moves oil and gas together; the economic limit uses the moved prices, so the life changes too. Named alternatives: the well-program workbook for the same tornado over a program of wells with scenarios; the break-even oil price sheet for the price at which the NPV is zero; the One-Well NPV and IRR sheet for the base case's cash flow, IRR and payout; a Monte Carlo of the inputs sampled jointly for P90, P50 and P10 of the NPV.

## References

- Mian, M.A. (2011). *Project Economics and Decision Analysis*, Vol. 2, 2nd ed. PennWell (sensitivity analysis and tornado diagrams).
- Newendorp, P.D. and Schuyler, J.R. (2000). *Decision Analysis for Petroleum Exploration*, 2nd ed. Planning Press.
- Eschenbach, T.G. (1992). Spiderplots versus Tornado Diagrams for Sensitivity Analysis. *Interfaces* 22(6), 40–46.
- Arps, J.J. (1945). Analysis of Decline Curves. *Trans. AIME* 160, 228–247.

## Functions used

`PO.ECON.NPV.Monthly`, `PO.ECON.Capex.Phasing`

## Spreadsheet: TornadoSensitivity

|    | A                                                                                                                                                      | B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | C                                                                                                                                                                                                                                                                                              | D                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | E                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | F             | G                                                           |
|----|--------------------------------------------------------------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------------|-------------------------------------------------------------|
| 1  | One-Well NPV Tornado                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Petroleum Office                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 2  | Blue cells on yellow are inputs: the well-program workbook's base case for one well and a low and high case of each input. The sorted tornado follows. |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 3  | The Well, Its Timing and Type Curve                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 4  | Month the well comes online (month 1 starts the evaluation)                                                                                            | 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | months                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 5  | Longest producing life of the well                                                                                                                     | 360                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | months                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 6  | Initial oil rate of the type curve                                                                                                                     | 800                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | STB/d                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 7  | Arps hyperbolic exponent b                                                                                                                             | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 8  | Initial decline, effective secant                                                                                                                      | 0.65                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | %/yr                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 9  | Terminal decline, effective (exponential tail)                                                                                                         | 0.08                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | %/yr                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 10 | Gas-oil ratio, constant over life                                                                                                                      | 1500                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | scf/STB                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 11 | Type-curve factor (scales the initial rate)                                                                                                            | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 12 | Prices, Interests and Texas Taxes                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 13 | Oil price (WTI)                                                                                                                                        | 70                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | $/STB                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 14 | Oil differential, deducted (quality and transport)                                                                                                     | 1.5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | $/STB                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 15 | Gas price (Henry Hub, 1 MMBtu per Mscf)                                                                                                                | 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | $/MMBtu                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 16 | Gas differential, deducted (Waha basis)                                                                                                                | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | $/MMBtu                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 17 | Escalation of prices and operating costs                                                                                                               | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | %/yr                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 18 | Working interest (scales costs and capital)                                                                                                            | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 19 | Net revenue interest (25 % royalty at 100 % WI)                                                                                                        | 0.75                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 20 | Oil severance tax (Texas, of the oil's value)                                                                                                          | 0.046                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 21 | Gas severance tax (Texas, of the gas's value)                                                                                                          | 0.075                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 22 | Ad valorem tax, as a share of net revenue                                                                                                              | 0.025                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 23 | Costs and the Capital Phasing                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 24 | Drilling and completion of the well                                                                                                                    | 7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | $MM                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 25 | Fixed LOE                                                                                                                                              | 8000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | $/well-month                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 26 | Variable LOE per barrel of oil                                                                                                                         | 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | $/STB                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 27 | Gas gathering and processing                                                                                                                           | 0.5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | $/Mscf                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 28 | Plugging and abandonment, the month after the last production                                                                                          | 150000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | $                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 29 | D&C share spent four months before online                                                                                                              | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 30 | D&C share spent three months before online                                                                                                             | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 31 | D&C share spent two months before online                                                                                                               | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 32 | D&C share spent the month before online                                                                                                                | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | %                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 33 | Discounting                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 34 | Discount rate, end-of-month cash flows                                                                                                                 | 0.1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | %/yr                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 35 | Low and High Cases                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 36 | Price, oil and gas, low                                                                                                                                | 0.8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 37 | Price, oil and gas, high                                                                                                                               | 1.2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 38 | Capex, D&C, low                                                                                                                                        | 0.8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 39 | Capex, D&C, high                                                                                                                                       | 1.2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 40 | Opex, fixed LOE, low                                                                                                                                   | 0.75                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 41 | Opex, fixed LOE, high                                                                                                                                  | 1.25                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 42 | EUR, type-curve factor, low                                                                                                                            | 0.75                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 43 | EUR, type-curve factor, high                                                                                                                           | 1.3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 44 | Timing, well shifted, low                                                                                                                              | -3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | months                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 45 | Timing, well shifted, high                                                                                                                             | 6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | months                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 47 | Calculation Constants                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 48 | Days in a month, 365.25/12                                                                                                                             | 30.4375                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | days/month                                                                                                                                                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 49 | Months in a year                                                                                                                                       | 12                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | months/yr                                                                                                                                                                                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 50 | Dollars in a million                                                                                                                                   | 1000000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | $/$MM                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 52 | The Decline, the Economic Limit and the Well's Life at the Base Case                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 53 | Initial nominal decline, from the effective secant                                                                                                     | =((1-TOR_Dei)^(-TOR_b)-1)/TOR_b                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 1/yr                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 54 | Terminal nominal decline, from the effective                                                                                                           | =-LN(1-TOR_Dterm)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1/yr                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 55 | Time the hyperbolic switches to the terminal decline                                                                                                   | =MAX(0,(TOR_Di/TOR_Dt-1)/(TOR_b*TOR_Di))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | years                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 56 | Rate at the switch over the initial rate                                                                                                               | =(1+TOR_b*TOR_Di*TOR_Ts)^(-1/TOR_b)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | —                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 57 | Initial oil rate, IP × type-curve factor                                                                                                               | =TOR_IP*TOR_TC                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | STB/d                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 58 | Operating margin per barrel of oil, net of royalty and taxes                                                                                           | =(TOR_Oil-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | $/STB                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 59 | Economic-limit oil rate, fixed LOE over the margin                                                                                                     | =IF(AND(TOR_Margin>0,TOR_LOE>0),TOR_LOE*TOR_WI/(TOR_Days*TOR_Margin),TOR_Qi)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | STB/d                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 60 | Time the decline takes to reach the limit                                                                                                              | =IF(TOR_QLimit>=TOR_Qi,0,IF(TOR_QLimit>=TOR_Qi*TOR_Qs,((TOR_Qi/TOR_QLimit)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(TOR_Qi*TOR_Qs/TOR_QLimit)/TOR_Dt))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | years                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 61 | Producing life, to the economic limit or the cap                                                                                                       | =IF(TOR_Margin<=0,0,IF(TOR_LOE<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*TOR_TLimit))))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | months                                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 63 | The Base Case and the Largest Swing                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 64 | NPV of the base case                                                                                                                                   | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC,cs_u,(TOR_Oil-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE>0),TOR_LOE*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM | $MM                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 65 | Input with the largest swing                                                                                                                           | =""&INDEX(TOR_Names,MATCH(1,TOR_Ranks,0))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 66 | Its swing, high case less low case                                                                                                                     | =MAX(TOR_Swings)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | $MM                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 67 | Lowest NPV of any case                                                                                                                                 | =MIN(TOR_NpvLo,TOR_NpvHi)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | $MM                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 68 | Case with the lowest NPV                                                                                                                               | =""&INDEX(TOR_Names,IFERROR(MATCH(TOR_Low,TOR_NpvLo,0),MATCH(TOR_Low,TOR_NpvHi,0)))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 69 | Downside check                                                                                                                                         | =IF(TOR_NPV<=0,"FAIL",IF(TOR_Low<=0,"WARN","PASS"))                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(TOR_NPV<=0,"the base case loses money, NPV "&FIXED(TOR_NPV,2)&" $MM",IF(TOR_Low<=0,""&TOR_LowCase&" takes the NPV to "&FIXED(TOR_Low,2)&" $MM","the NPV stays positive in every case, the lowest "&FIXED(TOR_Low,2)&" $MM"))                                                               |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 70 | Case check                                                                                                                                             | =IF(AND(TOR_PriceLo<=1,TOR_PriceHi>=1,TOR_CapexLo<=1,TOR_CapexHi>=1,TOR_OpexLo<=1,TOR_OpexHi>=1,TOR_EurLo<=1,TOR_EurHi>=1,TOR_DelayLo<=0,TOR_DelayHi>=0),"PASS","WARN")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | =IF(AND(TOR_PriceLo<=1,TOR_PriceHi>=1,TOR_CapexLo<=1,TOR_CapexHi>=1,TOR_OpexLo<=1,TOR_OpexHi>=1,TOR_EurLo<=1,TOR_EurHi>=1,TOR_DelayLo<=0,TOR_DelayHi>=0),"every low and high case lies either side of the base","a low and a high case lie on the same side of the base, so its bars overlap") |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 72 | How to use it: type the well's own type curve, prices and costs, and set each low and high case from its real range.                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 73 | The defaults are the well-program workbook's illustrative base case and tornado cases, for one well.                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 75 | Capital Phasing (nothing to edit)                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 76 | Spent, months before online                                                                                                                            | Share                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Month spent (month)                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 77 | =4                                                                                                                                                     | =TOR_Phase4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | =MAX(1,TOR_Online-A77)                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 78 | =3                                                                                                                                                     | =TOR_Phase3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | =MAX(1,TOR_Online-A78)                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 79 | =2                                                                                                                                                     | =TOR_Phase2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | =MAX(1,TOR_Online-A79)                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 80 | =1                                                                                                                                                     | =TOR_Phase1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | =MAX(1,TOR_Online-A80)                                                                                                                                                                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 82 | One Input at a Time                                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 83 | Swing is the NPV at the high case less the NPV at the low case, unsigned; rank 1 is the largest.                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 84 | Input                                                                                                                                                  | Low case                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | High case                                                                                                                                                                                                                                                                                      | NPV, low case ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | NPV, high case ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Swing ($MM)   | Rank                                                        |
| 85 | Price, oil and gas (× base)                                                                                                                            | =TOR_PriceLo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =TOR_PriceHi                                                                                                                                                                                                                                                                                   | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC,cs_u,(TOR_Oil*TOR_PriceLo-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas*TOR_PriceLo-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE>0),TOR_LOE*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM                     | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC,cs_u,(TOR_Oil*TOR_PriceHi-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas*TOR_PriceHi-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE>0),TOR_LOE*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM                     | =ABS(E85-D85) | =SUMPRODUCT((F$85:F$89>F85)*1)+SUMPRODUCT((F$85:F85=F85)*1) |
| 86 | Capex, D&C (× base)                                                                                                                                    | =TOR_CapexLo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =TOR_CapexHi                                                                                                                                                                                                                                                                                   | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC,cs_u,(TOR_Oil-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE>0),TOR_LOE*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_CapexLo*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM                                 | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC,cs_u,(TOR_Oil-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE>0),TOR_LOE*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_CapexHi*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM                                 | =ABS(E86-D86) | =SUMPRODUCT((F$85:F$89>F86)*1)+SUMPRODUCT((F$85:F86=F86)*1) |
| 87 | Opex, fixed LOE (× base)                                                                                                                               | =TOR_OpexLo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | =TOR_OpexHi                                                                                                                                                                                                                                                                                    | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC,cs_u,(TOR_Oil-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE*TOR_OpexLo>0),TOR_LOE*TOR_OpexLo*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE*TOR_OpexLo<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_OpexLo*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC,cs_u,(TOR_Oil-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE*TOR_OpexHi>0),TOR_LOE*TOR_OpexHi*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE*TOR_OpexHi<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_OpexHi*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM | =ABS(E87-D87) | =SUMPRODUCT((F$85:F$89>F87)*1)+SUMPRODUCT((F$85:F87=F87)*1) |
| 88 | EUR, type-curve factor (× base)                                                                                                                        | =TOR_EurLo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | =TOR_EurHi                                                                                                                                                                                                                                                                                     | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC*TOR_EurLo,cs_u,(TOR_Oil-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE>0),TOR_LOE*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM                                   | =PO.ECON.NPV.Monthly(LET(cs_qi,TOR_IP*TOR_TC*TOR_EurHi,cs_u,(TOR_Oil-TOR_OilDiff)*TOR_NRI*(1-TOR_SevOil-TOR_AdVal)+TOR_GOR/1000*((TOR_Gas-TOR_GasDiff)*TOR_NRI*(1-TOR_SevGas-TOR_AdVal)-TOR_Gath*TOR_WI)-TOR_LOEVar*TOR_WI,cs_ql,IF(AND(cs_u>0,TOR_LOE>0),TOR_LOE*TOR_WI/(TOR_Days*cs_u),cs_qi),cs_qs,cs_qi*TOR_Qs,cs_yr,IF(cs_ql>=cs_qi,0,IF(cs_ql>=cs_qs,((cs_qi/cs_ql)^TOR_b-1)/(TOR_b*TOR_Di),TOR_Ts+LN(cs_qs/cs_ql)/TOR_Dt)),cs_life,IF(cs_u<=0,0,IF(TOR_LOE<=0,TOR_LifeCap,MIN(TOR_LifeCap,INT(TOR_MoYr*cs_yr)))),cs_mon,SEQUENCE(TOR_Online+cs_life),cs_age,cs_mon-TOR_Online+1,cs_on,(cs_age>=1)*(cs_age<=cs_life),cs_t,((cs_age>=1)*(2*cs_age-1)+(cs_age<1))/2/TOR_MoYr,cs_oil,cs_on*((cs_t<=TOR_Ts)*cs_qi*(1+TOR_b*TOR_Di*cs_t)^(-1/TOR_b)+(cs_t>TOR_Ts)*cs_qs*EXP(-TOR_Dt*(cs_t-TOR_Ts)))*TOR_Days,cs_esc,(1+TOR_Esc)^((cs_mon-1)/TOR_MoYr),cs_cap,MMULT((cs_mon=TRANSPOSE(TOR_Spend))*1,PO.ECON.Capex.Phasing(TOR_DC*TOR_PerMM*TOR_WI,TOR_Phasing)),cs_esc*(cs_oil*cs_u-TOR_LOE*TOR_WI*cs_on)-cs_cap-(cs_mon=TOR_Online+cs_life)*TOR_PA*TOR_WI),TOR_Disc)/TOR_PerMM                                   | =ABS(E88-D88) | =SUMPRODUCT((F$85:F$89>F88)*1)+SUMPRODUCT((F$85:F88=F88)*1) |
| 89 | Timing, well shifted (months)                                                                                                                          | =TOR_DelayLo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =TOR_DelayHi                                                                                                                                                                                                                                                                                   | =TOR_NPV*(1+TOR_Disc)^(-(TOR_DelayLo)/TOR_MoYr)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =TOR_NPV*(1+TOR_Disc)^(-(TOR_DelayHi)/TOR_MoYr)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =ABS(E89-D89) | =SUMPRODUCT((F$85:F$89>F89)*1)+SUMPRODUCT((F$85:F89=F89)*1) |
| 91 | Sorted by Swing, the Tornado's Bars (nothing to edit)                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 92 | Input                                                                                                                                                  | Change, low case ($MM)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Change, high case ($MM)                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 93 | =INDEX(TOR_Names,MATCH(ROWS($A$93:A93),TOR_Ranks,0))                                                                                                   | =INDEX(TOR_NpvLo,MATCH(ROWS($A$93:A93),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =INDEX(TOR_NpvHi,MATCH(ROWS($A$93:A93),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 94 | =INDEX(TOR_Names,MATCH(ROWS($A$93:A94),TOR_Ranks,0))                                                                                                   | =INDEX(TOR_NpvLo,MATCH(ROWS($A$93:A94),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =INDEX(TOR_NpvHi,MATCH(ROWS($A$93:A94),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 95 | =INDEX(TOR_Names,MATCH(ROWS($A$93:A95),TOR_Ranks,0))                                                                                                   | =INDEX(TOR_NpvLo,MATCH(ROWS($A$93:A95),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =INDEX(TOR_NpvHi,MATCH(ROWS($A$93:A95),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 96 | =INDEX(TOR_Names,MATCH(ROWS($A$93:A96),TOR_Ranks,0))                                                                                                   | =INDEX(TOR_NpvLo,MATCH(ROWS($A$93:A96),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =INDEX(TOR_NpvHi,MATCH(ROWS($A$93:A96),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |
| 97 | =INDEX(TOR_Names,MATCH(ROWS($A$93:A97),TOR_Ranks,0))                                                                                                   | =INDEX(TOR_NpvLo,MATCH(ROWS($A$93:A97),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =INDEX(TOR_NpvHi,MATCH(ROWS($A$93:A97),TOR_Ranks,0))-TOR_NPV                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |               |                                                             |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.ECON.NPV.Monthly | =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.Capex.Phasing | =LAMBDA(total,profile,total*profile/SUM(profile)) | Spreads a capital total over periods in proportion to a phasing profile; returns an array the shape of the profile, in the units of total. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| TOR_Online | $B$4 | Month the well comes online (month 1 starts the evaluation), months |
| TOR_LifeCap | $B$5 | Longest producing life of the well, months |
| TOR_IP | $B$6 | Initial oil rate of the type curve, STB/d |
| TOR_b | $B$7 | Arps hyperbolic exponent b |
| TOR_Dei | $B$8 | Initial decline, effective secant, %/yr |
| TOR_Dterm | $B$9 | Terminal decline, effective (exponential tail), %/yr |
| TOR_GOR | $B$10 | Gas-oil ratio, constant over life, scf/STB |
| TOR_TC | $B$11 | Type-curve factor (scales the initial rate) |
| TOR_Oil | $B$13 | Oil price (WTI), $/STB |
| TOR_OilDiff | $B$14 | Oil differential, deducted (quality and transport), $/STB |
| TOR_Gas | $B$15 | Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu |
| TOR_GasDiff | $B$16 | Gas differential, deducted (Waha basis), $/MMBtu |
| TOR_Esc | $B$17 | Escalation of prices and operating costs, %/yr |
| TOR_WI | $B$18 | Working interest (scales costs and capital), % |
| TOR_NRI | $B$19 | Net revenue interest (25 % royalty at 100 % WI), % |
| TOR_SevOil | $B$20 | Oil severance tax (Texas, of the oil's value), % |
| TOR_SevGas | $B$21 | Gas severance tax (Texas, of the gas's value), % |
| TOR_AdVal | $B$22 | Ad valorem tax, as a share of net revenue, % |
| TOR_DC | $B$24 | Drilling and completion of the well, $MM |
| TOR_LOE | $B$25 | Fixed LOE, $/well-month |
| TOR_LOEVar | $B$26 | Variable LOE per barrel of oil, $/STB |
| TOR_Gath | $B$27 | Gas gathering and processing, $/Mscf |
| TOR_PA | $B$28 | Plugging and abandonment, the month after the last production, $ |
| TOR_Phase4 | $B$29 | D&C share spent four months before online, % |
| TOR_Phase3 | $B$30 | D&C share spent three months before online, % |
| TOR_Phase2 | $B$31 | D&C share spent two months before online, % |
| TOR_Phase1 | $B$32 | D&C share spent the month before online, % |
| TOR_Disc | $B$34 | Discount rate, end-of-month cash flows, %/yr |
| TOR_PriceLo | $B$36 | Price, oil and gas, low |
| TOR_PriceHi | $B$37 | Price, oil and gas, high |
| TOR_CapexLo | $B$38 | Capex, D&C, low |
| TOR_CapexHi | $B$39 | Capex, D&C, high |
| TOR_OpexLo | $B$40 | Opex, fixed LOE, low |
| TOR_OpexHi | $B$41 | Opex, fixed LOE, high |
| TOR_EurLo | $B$42 | EUR, type-curve factor, low |
| TOR_EurHi | $B$43 | EUR, type-curve factor, high |
| TOR_DelayLo | $B$44 | Timing, well shifted, low, months |
| TOR_DelayHi | $B$45 | Timing, well shifted, high, months |
| TOR_Phasing | $B$29:$B$32 | The D&C phasing shares, four months before the well comes online down to the month before |
| TOR_Inputs | $B$4:$B$45 | The well's timing and type curve, prices, interests and taxes, costs and capital phasing, the discount rate, and each tornado input's low and high case |
| TOR_Days | $B$48 | Days in a month, 365.25/12, days/month |
| TOR_MoYr | $B$49 | Months in a year, months/yr |
| TOR_PerMM | $B$50 | Dollars in a million, $/$MM |
| TOR_Di | $B$53 | Initial nominal decline, from the effective secant, 1/yr |
| TOR_Dt | $B$54 | Terminal nominal decline, from the effective, 1/yr |
| TOR_Ts | $B$55 | Time the hyperbolic switches to the terminal decline, years |
| TOR_Qs | $B$56 | Rate at the switch over the initial rate |
| TOR_Qi | $B$57 | Initial oil rate, IP × type-curve factor, STB/d |
| TOR_Margin | $B$58 | Operating margin per barrel of oil, net of royalty and taxes, $/STB |
| TOR_QLimit | $B$59 | Economic-limit oil rate, fixed LOE over the margin, STB/d |
| TOR_TLimit | $B$60 | Time the decline takes to reach the limit, years |
| TOR_Life | $B$61 | Producing life, to the economic limit or the cap, months |
| TOR_NPV | $B$64 | NPV of the base case, $MM |
| TOR_Top | $B$65 | Input with the largest swing |
| TOR_TopSwing | $B$66 | Its swing, high case less low case, $MM |
| TOR_Low | $B$67 | Lowest NPV of any case, $MM |
| TOR_LowCase | $B$68 | Case with the lowest NPV |
| TOR_DownsideCheck | $B$69 | Downside check verdict |
| TOR_DownsideCheckNote | $C$69 | Downside check comment |
| TOR_CaseCheck | $B$70 | Case check verdict |
| TOR_CaseCheckNote | $C$70 | Case check comment |
| TOR_Results | $B$53:$B$70 | The decline terms, the economic limit and life, the base NPV, the input with the largest swing and its swing, the lowest NPV and its case, and two checks |
| TOR_CapitalPhasing | $A$77:$C$80 | Each D&C share's lead, its share and the month it is spent (before month 1 it falls in month 1) |
| TOR_Spend | $C$77:$C$80 | The month each D&C share is spent, four months before online down to the month before |
| TOR_Cases | $A$85:$G$89 | Each input's low and high case, the NPV at each, the swing and its rank |
| TOR_PriceNpvLo | $D$85 | NPV with Price, oil and gas at its low case, $MM |
| TOR_PriceNpvHi | $E$85 | NPV with Price, oil and gas at its high case, $MM |
| TOR_CapexNpvLo | $D$86 | NPV with Capex, D&C at its low case, $MM |
| TOR_CapexNpvHi | $E$86 | NPV with Capex, D&C at its high case, $MM |
| TOR_OpexNpvLo | $D$87 | NPV with Opex, fixed LOE at its low case, $MM |
| TOR_OpexNpvHi | $E$87 | NPV with Opex, fixed LOE at its high case, $MM |
| TOR_EurNpvLo | $D$88 | NPV with EUR, type-curve factor at its low case, $MM |
| TOR_EurNpvHi | $E$88 | NPV with EUR, type-curve factor at its high case, $MM |
| TOR_DelayNpvLo | $D$89 | NPV with Timing, well shifted at its low case, $MM |
| TOR_DelayNpvHi | $E$89 | NPV with Timing, well shifted at its high case, $MM |
| TOR_Names | $A$85:$A$89 | The tornado's inputs |
| TOR_NpvLo | $D$85:$D$89 | NPV with each input at its low case, $MM |
| TOR_NpvHi | $E$85:$E$89 | NPV with each input at its high case, $MM |
| TOR_Swings | $F$85:$F$89 | Each input's swing, high less low, unsigned, $MM |
| TOR_Ranks | $G$85:$G$89 | Each input's rank by swing, 1 the largest |
| TOR_Bars | $A$93:$C$97 | The inputs sorted by swing, largest first, and the NPV's change at each case |
| TOR_TornadoCurve | $A$93:$C$97 | NPV Tornado, One Well |

---

## Related Blueprints
- [Break-Even Oil Price](/blueprint/po.econ.breakeven.price.md)
- [Decline Economics](/blueprint/po.econ.decline.economics.md)
- [One-Well NPV and IRR](/blueprint/po.econ.npv.irr.md)
- [Workover Decision](/blueprint/po.econ.workover.decision.md)
- [Production Sharing Contract Split](/blueprint/po.econ.psc.split.md)
- [Injector Hall Plot and Voidage Replacement](/blueprint/po.res.hall.plot.md)

