Multi-Well Schedule Aggregation
Spreadsheet
20 rows x 3 columns
| A | B | C | |
|---|---|---|---|
| 1 | Multi-Well Schedule Aggregation | ||
| 2 | |||
| 3 | Time Series (months) | Well Profile (bbl/month) | Drilling Schedule (wells) |
| 4 | 0 | 15000 | 2 |
| 5 | 6 | 12000 | 1 |
| 6 | 12 | 9600 | 2 |
| 7 | 18 | 7680 | 1 |
| 8 | 24 | 6150 | 0 |
| 9 | 30 | 4920 | 0 |
| 10 | 36 | 3930 | 0 |
| 11 | |||
| 12 | Aggregated Production Forecast | ||
| 13 | t (months) | Field Rate (bbl/month) | Cumulative (Mstb) |
| 14 | 0 | 30000 | 0 |
| 15 | 6 | 39000 | 207 |
| 16 | 12 | 61200 | 507.6 |
| 17 | 18 | 63960 | 883.08 |
| 18 | 24 | 51180 | 1228.5 |
| 19 | 30 | 40950 | 1504.89 |
| 20 | 36 | 32760 | 1726.02 |
Description
Aggregated field production from a multi-well drilling schedule. Uses convolution of a typical well decline profile with a well drilling schedule to forecast total field production over time.
Parameters:
- timeSeries: Time array defining forecast periods
- profile: Typical well production profile (rate at each time step)
- schedule: Number of wells drilled at each time step
- t: Query time for rate/cumulative calculation
Units: the well profile is bbl/month against a time series in months, so the cumulative column is a true volume (shown as Mstb). The schedule-aggregation 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 Multi-Well Schedule Aggregation
- Click on the blueprint to preview
- Click Insert to place it into your worksheet. Modify the input values to match your data.