Well Spacing & Drainage Area Calculator: DSU Geometry, Spacing Sensitivity & Interference Flags
Screen well spacing and drainage area from DSU geometry and well coordinates: nearest-well drainage partition with a colour map, equivalent drainage radius, spacing sensitivity and live interference flags. A geometric tool, no reserves or DCF.
TAGLINE
Screen well spacing and drainage area from DSU geometry and well coordinates: nearest-well drainage partition with a colour map, equivalent drainage radius, spacing sensitivity and live interference flags. A geometric tool, no reserves or DCF.
WHO IT'S FOR
Development engineers and asset teams screening DSU spacing and drainage geometry before field development decisions.
WHAT IT DOES
Splits the DSU between wells by nearest well (a Voronoi-style partition computed on a 40 × 40 grid), giving each well's drainage area from its coordinates, shown as a colour map; the areas sum to the DSU. Converts each area to a square-equivalent side and an equivalent drainage radius. Tabulates wells per DSU and acres per well over a range of inter-well spacings, and flags wells closer than the interference threshold to their nearest neighbour, with a live count.
TABS INCLUDED (9)
• Instructions & Legend • DSU Assumptions — DSU dimensions and area, target spacing, interference threshold • Well Layout — well coordinates and nearest-neighbour distances • Drainage Area — acres per well from the nearest-well grid, colour map, square-equivalent side, equivalent radius, sum check • Spacing Sensitivity — wells per DSU and acres per well vs inter-well spacing • Well Layout Crossplot — x-y well positions • Spacing Sensitivity Crossplot — spacing vs acres per well • Interference Flags — flag per well, interference and OK counts • Summary — wells, mean and minimum drainage area, minimum nearest-well distance, wells flagged, wells and acres per well at the target spacing
KEY FORMULAS
Drainage area = grid cells nearest the well × cell area; equivalent radius re = √(A × 43,560 / π); square-equivalent side = √(A × 43,560); Spacing Sensitivity: wells/DSU = INT(L/s) × INT(W/s), acres/well = DSU area / wells
TECHNICAL SPECS
• Excel 2016+; 1,700+ formulas; 6-well sample layout • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
What you get
- Instant workbook access after payment in your Excel Library
- Formula-driven worksheet designed for petroleum workflows
- No recurring fees and no plugin requirements
Licence
Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.
FAQ
Is this a one-time purchase?
Yes. Each workbook is sold as a one-time purchase with no recurring subscription.
How do I access purchased files?
After checkout, your file appears in Excel Library under your account for download.
Do these templates require macros or plugins?
No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.
