This tool provides a user-friendly Excel interface to perform material balance calculations for dry gas reservoirs using the P/Z straight-line method.
Key Features:
- Easy Data Input: Simply paste in your cumulative gas production and average reservoir pressure data.
- Automatic Z-Factor Calculation: The Z-factor is automatically calculated using the Hall-Yarborough correlation, implemented as a simple Excel formula powered by VBA code.
- Interactive Data Fitting: Use intuitive sliders to fit the straight line through your data points.
- Quick Readouts: Instantly read original gas in place (OGIP), estimated ultimate recovery (EUR), and recovery factor (RF) directly from the chart.
This tool streamlines calculations for quick, effective dry gas depletion material balance analysis.
Tutorial
See how the tool works in this demo video:
https://www.youtube.com/watch?v=p4Luy4ZuFyk&t=300s
Get the file
👉 Click here to download
→ It’ll open a GDrive window with the zip file. Download and unzip it.
→ You must have the file saved locally to access its full functionality