Petroleum Goodies: Rate-Time Spreadsheet

Posted: 09 Jun 2013 08:12 PM PDT

Rate-Time Spreadsheet (RTS) To Estimate Range of Your Reserves

This Excel spreadsheet helps you to calculate range of production forecast using seven different methods by analyzing gas or oil production (i.e. rate-time) data.

This tool is available for Excel 2003 and 2007 versions. For those who use newer version of Excel (2013 and later versions) can use the 2007 version. The authors of this tool provide user guide on how use this tool (see download links at the bottom of this page). They also provide examples using tight gas well. For more details, please read SPE papers 116731, 119897, 132352 from OnePetro website.

Using The Rate-Time Spreadsheet

Edit Data Sheet

The authors built the RTS based on order when you want to analyze your data. It starts by entering your rate-time data (or cumulative production – optional) into sheet Edit Data. In this sheet, you can exclude unwanted data points by entering 0 (zero number) in column D. Once you finish editing unwanted data points, then go to sheet Home.

Home Sheet

In this sheet, you can calculate Loss Ratio (D) and Loss Ratio Derivative (b) by clicking on the Calculate buttons. This tool provides two different methods to calculate D parameter; using production rate and cumulative production.

Rate-Time Relation Sheets

These sheets allow you to choose rate-time relation that you want to use. The relations include:

Arps’ Exponential (exp) Relation
Reciprocal Rate Method
Arps’ Hyperbolic (hyper) Relation
Modified Hyperbolic (MH) Relation
Power-Law Exponential (PLE) Model
Ansah, Knowles and Buba (AKB) Semi-Analytic Relation
Quadratic Rate Cumulative Relation

Summary & Appendix Sheets

At the end of RTS, you are provided with summary of estimated ultimate recovery (EUR) calculations and decline parameters. The EUR calculation can be limited either by abandonment rate or time. To see the equations to calculate rate-time relations you can go to Appendix sheet.

Improvement

The RTS is an excellent Excel-based tool to analyze rate-time data. This tool can calculate EUR using seven different methods for individual well. If you have more than one well to analyze, you can make a copy of this tool and change your rate-time data. You can improve this tool by allowing rate-time inputs from multiple wells. VBA programming skill might required to do this improvement.

If you have questions or inquires related to the RTS, you can contact one of the authors of this tool at stephaniemariecurrie[at]gmail.com.

Using VBA macro? Yes

Download The Rate-Time Spreadsheet

Note: There is a file embedded within this post, please visit this post to download the file.

Related Posts:

Monday, June 10, 2013