EUR Sensitivity Analysis
Spreadsheet
34 rows x 4 columns
| A | B | C | D | |
|---|---|---|---|---|
| 1 | EUR Sensitivity Analysis - Arps Decline | |||
| 2 | Base Case Parameters | |||
| 3 | Initial Rate (qi) | 30000 | bbl/month | |
| 4 | Initial Decline (Di) | 0.06 | 1/month | |
| 5 | b-exponent | 0.5 | - | |
| 6 | Economic Limit | 300 | bbl/month | |
| 7 | ||||
| 8 | Base Case EUR | |||
| 9 | EUR (to qlimit) | 900 | Mstb | |
| 10 | Time to Limit | 25 | years | |
| 11 | ||||
| 12 | EUR Sensitivity to b-exponent | |||
| 13 | b | EUR (Mstb) | % of Base | Time to Limit (yrs) |
| 14 | 0 | 495 | 55 | 6.396069703 |
| 15 | 0.3 | 685.8494878 | 76.20549865 | 13.8012579 |
| 16 | 0.5 | 900 | 100 | 25 |
| 17 | 0.7 | 1248.018928 | 138.6687698 | 47.85488951 |
| 18 | 1 | 2302.585093 | 255.8427881 | 137.5 |
| 19 | ||||
| 20 | EUR Sensitivity to Initial Decline (Di) | |||
| 21 | Di (1/month) | EUR (Mstb) | % of Base | 5-Year Np (Mstb) |
| 22 | 0.03 | 1800 | 200 | 947.3684211 |
| 23 | 0.05 | 1080 | 120 | 720 |
| 24 | 0.06 | 900 | 100 | 642.8571429 |
| 25 | 0.08 | 675 | 75 | 529.4117647 |
| 26 | 0.1 | 540 | 60 | 450 |
| 27 | ||||
| 28 | EUR Sensitivity to Economic Limit | |||
| 29 | qlimit (bbl/month) | EUR (Mstb) | % of Base | Life (years) |
| 30 | 150 | 929.2893219 | 103.2543691 | 36.50593229 |
| 31 | 300 | 900 | 100 | 25 |
| 32 | 600 | 858.5786438 | 95.39762708 | 16.86407726 |
| 33 | 900 | 826.7949192 | 91.86610214 | 13.2597297 |
| 34 | 1500 | 776.3932023 | 86.26591136 | 9.644822097 |
Description
Sensitivity analysis of Estimated Ultimate Recovery (EUR) to Arps decline parameters. Understanding parameter uncertainty impact on EUR is critical for reserves estimation and economic analysis.
Key Sensitivities:
- b-factor: Higher b = slower decline = higher EUR
- Initial Decline (Di): Higher Di = faster decline = lower EUR
- Economic Limit: Lower limit = longer production = higher EUR
Units: rates are bbl/month and Di is 1/month, so the EUR and Np columns are true volumes (shown as Mstb) and the life columns divide the returned months by 12. The Arps functions are unit-agnostic — rate and time must share the same time base.
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for EUR Sensitivity Analysis
- Click on the blueprint to preview
- Click Insert to place it into your worksheet. Modify the input values to match your data.