Production Allocation & Tank Battery Split Calculator: Commingled Stream Allocation Factors
Allocate commingled tank battery volumes to individual wells from well tests corrected for test hours and days on, with a measured-vs-theoretical proration check per stream and oil/water/gas reconciliation QC.
TAGLINE
Allocate commingled tank battery volumes to individual wells from well tests corrected for test hours and days on, with a measured-vs-theoretical proration check per stream and oil/water/gas reconciliation QC.
WHO IT'S FOR
Production engineers and operations staff allocating commingled battery production to individual wells.
WHAT IT DOES
Converts each well test to a daily rate (volume × 24 / test hours), multiplies by days on production to get each well's theoretical volume, and allocates each stream's battery total in proportion. Reports BOE as oil + gas/6. Checks each stream's proration factor (battery measured / sum of theoretical volumes) against a 0.90–1.10 range, reconciles allocated sums with pass/fail QC, and shows how much each well's allocated oil changes if its test is off by a set percentage. Three crossplots compare each well's theoretical volume with its allocated volume against a 1:1 line, all from live formulas.
TABS INCLUDED (10)
• Instructions & Legend • Battery Totals — monthly oil, water and gas; days in period • Well Test Data — test volumes, test hours, days on; daily test rates • Allocation Factors — factor per well and stream; test-error sensitivity • Allocated Volumes — oil, water, gas and BOE per well, with totals • Reconciliation QC — allocated vs battery total, proration factor per stream with range check • Oil QC Crossplot — theoretical vs allocated with 1:1 line • Water QC Crossplot — theoretical vs allocated with 1:1 line • Gas QC Crossplot — theoretical vs allocated with 1:1 line • Summary — wells allocated, QC streams passing, factors in range, total BOE, proration factors
KEY FORMULAS
Test rate = test volume × 24 / test hours; factor = (test rate × days on) / Σ over wells; allocated = factor × battery total; proration factor = battery measured / Σ(test rate × days on); BOE = oil + gas/6
TECHNICAL SPECS
• Excel 2016+; 140+ formulas; 4-well battery sample • 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.
