Petroleum Goodies

Saturday, April 5, 2014

Petroleum Goodies: Excel List Navigator

Posted: 04 Apr 2014 08:44 PM PDT

Free Excel List Navigator: Navigate Your List

This tool simply helps you to filter your data from list and show the selected data. It takes the data from sheet All List and dump the selected data to sheet Selected List. You can do operation from the selected data or simply show them on chart.

This tool can be used for general purpose. In this spreadsheet we use an example to select individual well and show its production and calculate peak rates (oil and gas).

How To Use This Tool?

Put your multiple item list by column (all the way down). Item name could not be in order as long as you have the same item list name.
Click reload button to update item list to drop down menu
To select your item, select item list from drop down toolbar or click the forward or backward buttons.

Note: Don’t do any operation in sheet Selected List. Instead you can link to this sheet and do calculation in another sheet.

Using VBA macro? Yes.

Updates: v1: First release for Ms. Excel 2007+ (.xlsm) accepts more than 1 millions rows and for Ms. Excel 2003 (.xls) accepts more than 65 thousand rows.

Download List Navigator

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

Monday, June 10, 2013

Petroleum Goodies: Rate-Time Spreadsheet

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:

Sunday, February 10, 2013

Petroleum Goodies: Calculate Gas Properties

Calculate Gas Properties

Posted: 09 Feb 2013 07:21 PM PST

Web-based & Excel Tools To Calculate Dry Gas Properties

It is essential for Petroleum Engineers to make various calculations in order to arrive at certain important figures on dry gas properties when they are engaged in working on their projects. Since these are quite time consuming calculations the presence of a web-based tool that does the calculations when their input figures are entered is of immense benefit for them. What you get in Excel format in this webpage is exactly that. It is a tool that could help them calculate various figures they need. When it comes to dry gas properties you may need inputs such as gas gravity, mole percent of CO₂ and H₂S, bottom hole pressure and temperature.

In addition to the final calculations they may also need to make intermediate calculations to obtain such figures as pseudocritical pressure and temperature, reduced pressure and temperature. With these calculations they may arrive at such figures as gas compressibility factor (Z), gas viscosity, gas formation volume factor (Bg), gas compressibility (Cg) and gas pseudo pressure (Pp). The tool available in the form of an Excel sheet is able to help Petroleum Engineers to do all these calculations effortlessly.

Various methods have been used in the calculation of dry gas properties. When it comes to the calculation of pseudocritical variables they were based on Sutton equation. For the calculation of gas compressibility factor Dranchuk and Abou-Kassem equation was used. In case of gas viscosity equation it is the Lee, Gonzales and Eakin equation that is being used.

The possibility is there for you to change labels of charts. Also, you could go to chart options and manually adjust the scales of charts. The calculated table available with the tool could be copied on to clipboard or could be exported to Excel or CSV files. When you choose print screen option you could print the charts also if you want.

Link to web-based tool to Calculate Dry Gas Properties.

Download Excel version

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