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 so you can start using them immediately.
(You can use the same license file to trial ALL Excel tools in our library)
- Important Note:
- Excel File Security - READ!
Get unlimited access to the tool
Convinced of the value this tool delivers? Start using this tool through a CrowdField plan:
- Premium ($30/month)
Full usage access to this tool and the entire library (licensed, no code access)
- Lifetime (one-time)
Full access to all tools, including source code and rights to modify, extend, and use in your own work