EUR Calculator
Spreadsheet
15 rows x 3 columns
| A | B | C | |
|---|---|---|---|
| 1 | EUR Calculator | ||
| 2 | |||
| 3 | Decline Parameters | ||
| 4 | Initial Rate (qi) | 30000 | bbl/month |
| 5 | Initial Decline (Di) | 0.05 | 1/month |
| 6 | b-exponent | 0.5 | |
| 7 | |||
| 8 | Economic Limit Analysis | ||
| 9 | q_limit (bbl/month) | EUR (Mstb) | Years to Limit |
| 10 | 3000 | 820.5266808 | 7.207592201 |
| 11 | 2250 | 871.3664655 | 8.838279056 |
| 12 | 1500 | 931.6718427 | 11.57378652 |
| 13 | 750 | 1010.26334 | 17.74851773 |
| 14 | 300 | 1080 | 30 |
| 15 | 150 | 1115.147186 | 43.80711875 |
Description
Calculate Estimated Ultimate Recovery (EUR) for different economic limits and decline parameters. Essential for reserves estimation and economic analysis.
Usage: Set decline parameters, then see EUR at various economic limit rates.
Units: rates are bbl/month and Di is 1/month, so EUR comes out as a true volume (shown as Mstb) and "Years to Limit" divides 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 Calculator
- Click on the blueprint to preview
- Click Insert to place it into your worksheet. Modify the input values to match your data.