Production Allocation & Tank Battery Split Calculator — Commingled Stream Allocation Factors
Allocate commingled tank battery volumes to individual wells using test-based allocation factors with oil/water/gas reconciliation QC.
TITLE
Production Allocation & Tank Battery Split Calculator — Commingled Stream Allocation Factors
PRICE
$69 USD — one-time purchase
TAGLINE
Allocate commingled tank battery volumes to individual wells using test-based allocation factors with oil/water/gas reconciliation QC.
WHO IT'S FOR
Production engineers and operations staff allocating commingled battery production to individual wells.
WHAT IT DOES
Calculates oil/water/gas allocation factors from well tests, applies to battery totals, and reconciles allocated sums with pass/fail QC. Dedicated crossplot tabs support visual QC of model vs measured data.
TABS INCLUDED (10)
• Instructions & Legend • Battery Totals • Well Test Data • Allocation Factors • Allocated Volumes • Reconciliation QC • Oil QC Crossplot — test vs allocated with 1:1 • Water QC Crossplot — test vs allocated • Gas QC Crossplot — test vs allocated • Summary
KEY FORMULAS
Factor = well test / sum tests; allocated = factor × battery total
TECHNICAL SPECS
• Excel 2016+; 300+ formulas; 4-well battery sample • MDT professional color scheme throughout • Yellow cells = inputs; white cells = formulas
SHOP COPY
7-tab allocation calculator: test factors, volume splits, reconciliation QC. Includes QC crossplots with 1:1 reference lines.
SUGGESTED TAGS
production allocation, tank battery, commingled, allocation factor
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.com
ETSY LISTING
TITLE: Production Allocation Excel Calculator | Tank Battery Commingled Well Split Factors PRICE: $69 USD — suggested; set your price in Etsy shop manager TAGS: production allocation, tank battery, commingled production, allocation factor, well test, operations Excel, petroleum engineering, oil gas, Excel template, digital download, field operations
DESCRIPTION:
Professional Excel workbook for upstream engineers. Calculates oil/water/gas allocation factors from well tests, applies to battery totals, and reconciles allocated sums with pass/fail QC. Dedicated crossplot tabs support visual QC of model vs measured data.
Who it's for: Production engineers and operations staff allocating commingled battery production to individual wells.
What's included: • Instructions & Legend • Battery Totals • Well Test Data • Allocation Factors • Allocated Volumes • Reconciliation QC • Oil QC Crossplot — test vs allocated with 1:1 • Water QC Crossplot — test vs allocated • Gas QC Crossplot — test vs allocated • Summary
Technical specs: Excel 2016+; 300+ formulas; 4-well battery sample. Excel 2016+, no plugins, sample data pre-loaded.
About Reservoir Risk Solutions — built by petroleum engineers. reservoirrisksolutions.com DIGITAL_DELIVERY: Instant download — Excel .xlsx file
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
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.
