Material Balance — Expansion Terms

MBE expansion terms (Eo, Eg, Efw) for a black oil reservoir with gas cap. Named input cells for initial conditions. 9 pressure steps with PVT data and computed expansions.

Material Balance Excel workbook
BlackOilModel.xlsx
Material Balance — Expansion Terms: Expansion Terms vs Pressure (Expansion Terms)Material Balance — Expansion Terms: Inputs sheetMaterial Balance — Expansion Terms: Expansion Terms sheet

Inputs

Named cells you can edit — every result recalculates from them.

Name Description Default Unit
MBE_Pi Initial Pressure (Pi) 4200 psi
MBE_Boi Initial Bo (Boi) 1.35 RB/STB
MBE_Rsi Initial Rs (Rsi) 650 scf/STB
MBE_Bgi Initial Bg (Bgi) 0.00095 RB/scf
MBE_m Gas Cap Ratio (m) 0.3 dimensionless
MBE_Swc Connate Water Saturation 0.25 fraction
MBE_cw Water Compressibility 3.0e-6 1/psi
MBE_cf Rock Compressibility 5.0e-6 1/psi

2 sheets, shown with the values the file opens with

A B C D E F
1 Material Balance — Inputs
2 Initial reservoir conditions for material balance analysis. The Expansion Terms sheet computes Eo, Eg, and Efw at each pressure step using PVT lab data.
3
4 Initial Conditions
5 Initial Pressure (Pi) 4200 psi
6 Initial Bo (Boi) 1.35 RB/STB
7 Initial Rs (Rsi) 650 scf/STB
8 Initial Bg (Bgi) 0.00095 RB/scf
9
10 Reservoir Parameters
11 Gas Cap Ratio (m) 0.3 dimensionless
12 Connate Water Saturation 0.25 fraction
13 Water Compressibility 3E-06 1/psi
14 Rock Compressibility 5E-06 1/psi
Opens inNeeds the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates.
Functions used PO.MBE.Exp.EfwPO.MBE.Exp.EgPO.MBE.Exp.Eo
FileBlackOilModel.xlsx, 10 KB
CategoryReservoir
For agents and tools Structure (.json) · Descriptor (.md)
Tags:
material-balanceexpansion-termsmbe

Need a workbook we don't have? Suggest a Workbook