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 brief demo video:

https://www.youtube.com/watch?v=p4Luy4ZuFyk&t=300s

Free Trial

Start your free trial today, risk-free.

To get started, you’ll need to launch a small executable to generate your personal license file.

<aside> 👉

License Request

</aside>

Once you submit the form, you’ll receive your personal license file along with the Excel Tools to start using.

• Important Note:
• Excel File Security - READ!

Purchase the Tool

Convinced of the value this tool delivers?

You have three options to continue using this tool:

1. Join a monthly membership plan, starting at $10/month.

   You’ll receive licensed access to the Excel files for all tools (VBA code remains locked).

2. Purchase this tool as a standalone product, granting you full access to its VBA code for your own customisations and improvements.

3. Upgrade to the Lifetime Vault. Get access to ALL my current and future tools, with unlimited access to VBA code and full rights to edit, customise, and extend every tool as you wish.

Explore the options below to find your best fit.