---
id: po.wb.fpp.production-allocation
title: Production Allocation
summary: "How much of one battery's metered oil, gas and water each of its ten wells made, from each well's test rates and hours on production."
category: Production
requires: []
tags:
  - allocation
  - well-test
  - uptime
  - production-accounting
  - oil
  - gas
  - water
---

## Description

How much of one battery's measured oil, gas and water did each of its ten wells produce this month? You enter the month's metered volumes, the factor bands, and each well's test oil rate, GOR, water cut and hours on. You read off each phase's allocation factor, every well's allocated oil, gas and water, the largest producer and the battery's uptime, with checks that the factors sit inside their bands and that each phase closes to its meter.

**How to use it:** On the Allocation sheet enter the days in the month, the measured oil (STB), gas (Mscf) and water (STB), and each well's test oil rate (STB/d), GOR (scf/STB), water cut and hours. Review the factors, the per-well volumes and the checks; the Summary gathers every result and verdict. The defaults are the allocation blueprint's synthetic month-30 type-well set, not field measurements.

**Method:** Theoretical oil is test oil rate times hours divided by 24. Theoretical gas is oil times test GOR divided by 1,000; water is oil times water cut divided by one minus water cut. Each phase's factor is its measured volume divided by its theoretical sum; each well's allocated phase is its theoretical volume times that factor. Each phase closes independently to its meter.

**Example:** For 30 days the wells' theoretical oil, gas and water are 49,510.5 STB, 79,983.96 Mscf and 12,509.74 STB. The measured volumes are 47,050 STB, 82,400 Mscf and 11,700 STB; the factors are approximately 0.950303, 1.03021 and 0.935271. B-4 is the largest oil producer at approximately 7,610.5 STB and 16.1754% of the total; uptime is 96.25%.

## Validity

A test is assumed representative of all producing hours. Changes in choke or line conditions, stale tests and meter errors can shift volume between wells. Independent phase factors change allocated well GOR and water cut from the test, and a factor does not identify the cause of a mismatch. Enter meter volumes already corrected for inventory, fuel, flare and lease use; this workbook does not reconcile meters, account for those corrections or combine multiple tests. Invalid input and zero theoretical phase totals fail the input check; review every failing or warning check before use.

## References

- American Petroleum Institute, Manual of Petroleum Measurement Standards, Chapter 20.1, Allocation Measurement.
- [PetroWiki: Production allocation](https://petrowiki.spe.org/Production_allocation) (allocation practice).
- The worked example uses the synthetic well tests and meter inputs of the allocation blueprint `po.bp.fpp.allocation`, checked well by well with independent arithmetic. These are illustrative inputs, not published field measurements.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| Days in month | days | 30 | `PAA_Days` |
| Measured oil, measured gas, measured water | STB, Mscf, STB | 47050, 82400, 11700 | `PAA_OilMeas`, `PAA_GasMeas`, `PAA_WatMeas` |
| Factor warning band, factor failure band | fraction | 0.1, 0.2 | `PAA_TolWarn`, `PAA_TolFail` |
| Well tests: test oil, GOR, water cut and hours for ten wells | STB/d, scf/STB, fraction, hours | synthetic month 30 | `PAA_TestOil`, `PAA_TestGor`, `PAA_TestWC`, `PAA_Hours` |

## Sheets

- `Guide` — the workflow and how to interpret the factors and the allocated volumes.
- `Allocation` — the measured month and factor bands, the theoretical volumes, factors and uptime, the allocation results and checks, the well table of tests, theoretical and allocated volumes, and a chart of theoretical against allocated oil by well.
- `Summary` — the measured, theoretical and allocated phase totals, the factors, the largest producer, uptime, and every check under one verdict.
- `Test Cases` — the worked example and other cases, with expected and computed results.

## Functions used

Excel arithmetic and standard functions only; no add-in UDFs.
