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:

Monday, January 14, 2013

Petroleum Goodies: Gas Compressibility Factor

Gas Compressibility Factor

Posted: 13 Jan 2013 09:13 PM PST

Web Tool To Calculate Gas Compressibility Factor

We rewrite VBA Excel function to calculate gas compressibility factor (Z) using JavaScript and develop a web tool so Petroleum Goodies users can Z factor directly from our website.

This web tool calculates gas compressibility factor for natural gases based on equation of state from Dranchuk and Abou-Kassem. Required inputs: gas gravity (air=1), mole percent of CO₂ and H₂S, pressure and temperature.

This tool also includes intermediate calculation such as pseudocritical pressure and temperature.

References:

Dranchuk, P.M., and Abou-Kassem, J.H.: “Calculation of Z Factors For Natural Gases Using Equations of State,” J. Cdn. Pet. Tech. (July-Sept., 1975) 34-36.
“Theory and Practice of Testing Gas Wells”, 3rd. Edition (1975) Energy Resources Conservation Board 603 6th. Ave. S.W. Calgary, Alberta, Canada.

Link to Web Tool To Compute Gas Compressibility Factor.

This web tool is also available for download in Excel version.

Related Posts:

Cumulative Probability Chart

Thursday, December 27, 2012

Petroleum Goodies: Cumulative Probability Chart

Cumulative Probability Chart

Posted: 26 Dec 2012 05:55 PM PST

Cumulative Probability Plot

This tool helps you to create cumulative probability chart from your data. To do this, we sort your data in ascending order. Next, we calculate percentile rank from your data. The smallest number in your data has the smallest percentile. Then we plot your sorted data versus percentile rank.

You can do it easily in Excel. However, this useful web tool can help you to build cumulative probability chart up to 5 series, instantly, all in one chart! So you can compare your data side-by-side. This chart is also called percentile rank plot. We build this web tool using jquery and JavaScript plot. We have tested this web tool using Firefox, Chrome, Safari, Opera and IE.

Definition of percentile rank. A percentile rank is typically defined as the proportion of scores in a distribution that a specific score is greater than or equal to. For instance, if you received a score of 90 on a math test and this score was greater than or equal to the scores of 80% of the students taking the test, then your percentile rank would be 80. You would be in the 80th percentile.

How to use this tool?

Input your data (up to 5 series) in provided text area. You don’t need to sort your data.
Label your data by changing series name.
Hit Reset Scale to clear axis scales. If these input scales are empty, tool will use minimum and maximum numbers from your data.
You can rename axis labels.
Hit Update Plot.

In this tool we provided example showing initial production of 300 wells from 5 different operator. Total data in this example 1500 points. You can use this tool to analyze percentile rank of your own data.

Tips: No need to sort your data. Numbers with comma thousand separators are allowed. Tested up to 15,000 points (3,000 points for each series). Let us know if you are able to use this tool with more than 15,000 data points. Show data point when hovering the mouse over a data point on a chart.

Link to web tool: Cumulative Probability Plot Related Posts:

None Found

Saturday, November 17, 2012

Petroleum Goodies: Calculate Daily Step Rate from Production Volume

Calculate Daily Step Rate from Production Volume

Posted: 16 Nov 2012 09:00 PM PST

Imagine you have producing gas wells with small amount of liquid production oil or water. Your liquid productions are not producing continuously (intermittent). Your liquid productions are not tied in directly to sales line. Or your wells are located far away from central facilities. Consequently, liquid productions need to be hauled by truck every certain day or every week. As a result, your production data is not in daily rate but in volume collected from certain days.

As petroleum engineer, you want to have daily production data from this volume to do production analysis or put them into simulation for history matching. You can convert this volume into step daily rate by dividing the volume with number of elapsed days when you collect the liquid production. You can calculate daily rate manually in Excel sheet or use this Excel tool to get daily step rate. This Excel tool can calculate daily step rate from production volume automatically.

Production volume can be collected in different time intervals of day, not necessary every 5 days, every week, etc. For example, you collect your liquid production every 3 days for the first month of production, every week for the second month of production then every month for the rest of your well life. This Excel tool can calculate daily step rate from production volume from different time intervals of day.

How to use this tool?

Input date in column B and your production volume in column C. Please remember, this should be production volume NOT rate. Daily step rate will be calculated in this Excel tool.
Hit Calculate button to convert production volume to daily step rate.
Check total cumulative volume from production volume and step rate for QC purposes. These two numbers should match.

Using VBA macro? Yes Note: There is a file embedded within this post, please visit this post to download the file.

Disclaimer: This work falls under the GNU General Public License. Any usage of these Excel sheets is undertaken at users own risk. There is no warranty, that they will not cause damage to your computer system, network, software or other technology. This Excel tool has VBA macro that is currently not working on Microsoft Excel for Mac OS X due to unresolved issue.Related Posts:

Sunday, September 2, 2012

Petroleum Goodies: Modified Hyperbolic Decline Curve

Modified Hyperbolic Decline Curve

Posted: 02 Sep 2012 04:10 AM PDT

Modified Hyperbolic Decline Curve Formula

Extrapolation of hyperbolic declines over long periods of time frequently results in unrealistically high reserves. To avoid this problem, it has been suggested (Robertson) that at some point in time, the hyperbolic decline be converted into an exponential decline.⁽¹⁾

This Excel tool is useful to forecast a gas well from historical production. Historical productions are used to history match to get decline parameters such as initial rate (qi), decline rate (D) and b value. A value of b = 0 corresponds to exponential decline. A value of b = 1 is called harmonic decline. Sometimes, values of b > 1 are observed. This forecasting tool is built using two decline schedules, the first schedule used hyperbolic decline (b > 1) and the second part utilized exponential decline (b = 0). The change in decline type is indicated by switch rate. Decline conversion from effective to nominal (vice versa) has been calculated in this tool.⁽²⁾

Feel free to use this tool and don’t forget to Like it and share it with your friends.

Using VBA macro? No

References:

Fekete Decline Curve Analysis
Schlumberger Oil Field Manager (OFM)

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

Related Posts:

Thursday, February 2, 2012

Petroleum Goodies: Horizontal Well Landing Position

Horizontal Well Landing Position

Posted: 02 Feb 2012 05:08 AM PST

Visualize Horizontal Well Landing Position Easily

horizontal well landing position

This is an extended work from the previous tool called Horizontal Toe Direction posted in this website earlier. The objective of this tool is to visualize horizontal well landing position within target zone using horizontal well deviation survey and top and bottom formation data points. Once we plot these survey and tops formation data, we can determine the following information:

Horizontal length
Toe direction
Formation thickness along wellbore
Landing position within target zone
Average depth of horizontal section

How to use:

Select well you want to analyze using scroll button or alternatively, type Well Number (not Well Code) in yellow cell.
Use “Run Batch” button to run multiple well selections.
Update your well list if you have new survey data added from new well.

How to update/change database:

Put your survey data into sheet “Survey”. Required colums: Well Code, Well Name, MD, TVD, DIP, TVDSS, X COORD, Y COORD. Please put them to the same column like in this tool.
Put your top formation into sheet “Top Fromation” and your bottom formation into “Btm Fromation”. These are X-Y-Z data points, Z in TVD subsea.
Enjoy the tool!

Assumptions:

Assumptions may vary depending your needs. The following assumptions apply to the tool.

Horizontal length – calculated from heel to toe. heel defines where dip start >88 deg. This also applies to define category for well landing position and toe direction.
Formation thickness – the distance between top and bottom formations.
Landing position – calculated from average depth of horizontal section related to top and bottom formation. Available for 3 positions (i.e., top, middle, bottom), also for 5 positions.
Toe direction – calculated from average dip of horizontal section from heel to toe. Dip ranges between 90 +/-0.5 deg is called flat.

Version Updates:

Version 1:

First release Feb 2012
Works well with Excel 2003, need some modification in macro to work with Excel 2007.
You need to use Excel 2007 if your data exceed 65000 rows.

Note:

All data provided in this tool are not real data and not related to any company.
To enable copy from Excel range to Powerpoint, you have to add Ms. PowerPoint object library from VBA editor. Click Tools – References and select Microsoft PowerPoint Object Library as shown below, then hit OK. See previous Excel tool that shows you how to add this object library.

Using VBA macro? Yes

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

Similar Posts:

Sunday, January 29, 2012

Petroleum Goodies: Horizontal Well Toe Direction

Horizontal Well Toe Direction

Posted: 28 Jan 2012 05:49 PM PST

Visualize Horizontal Well Toe Direction Quickly

horizontal well toe direction

The objective of this tool is to visualize horizontal well toe direction using horizontal well deviation survey. Yes you can do easily if you have less well. What if you have more than 1000 wells? This tool can save your time! Once we plot directional survey data, we can determine the following information:

Horizontal length
Toe direction
Average depth of horizontal section

How to use:

Select well you want to analyze using scroll button or alternatively, type Well Number (not Well Code) in yellow cell.
Use “Run Batch” button to run multiple well selections.
Update your well list if you have new survey data added from new well.

How to update/change database:

Put your survey data into sheet “Survey”. Required colums: Well Code, Well Name, MD, TVD, DIP, TVDSS, X COORD, Y COORD. Please put them to the same column like in this tool.
Enjoy the tool!

Assumptions:

Assumptions may vary depending your needs. The following assumptions apply to the tool.

Horizontal length – calculated from heel to toe. heel defines where dip start >88 deg. This also applies to define category for well landing position and toe direction.
Toe direction – calculated from average dip of horizontal section from heel to toe. Dip ranges between 90 +/-0.5 deg is called flat.

Version Updates:

Version 1: first release Feb 2012

Note:

All data provided in this tool are not real and not related to any company.
To enable copy from Excel range to Powerpoint, you have to add Ms. PowerPoint object library from VBA editor. Click Tools – References and select Microsoft PowerPoint Object Library as shown below, then hit OK. See previous Excel tool that shows you how to add this object library.

Using VBA macro? Yes

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

Similar Posts:

Friday, January 27, 2012

Petroleum Goodies: Calculate Best Initial Production

Calculate Best Initial Production

Posted: 26 Jan 2012 07:43 PM PST

Calculate Best Initial Production Automatically

calculate best inital production

It’s not hard to calculate best 30, 60, 0r 90-day average of initial production manually. What if you have many wells, let say more than 100 wells? This Excel tool is useful to determine initial production based on certain number of days. In addition to that, this tool has capability to exclude downtime, for example you don’t want to include production rates that are less than a specified cut off rate. For quality control purposes, this tool provides chart showing original production before and after applying cut off rates.

How to run this tool:

Select well by clicking scroll button, or alternatively you can type well number in yellow cell.
Update your well list by clicking “Update Well List” button if you have production data from new well that is not on the list. Please note that this button will erase the previous outputs that have been generated before. If you want to keep the previous results, do not use this update button, just add your well name manually into Main sheet after adding new well production data into Prod Data sheet.

How to update production data:

Put your production data with the same format with this template into sheet “Prod Data”. You do not need to worry about the order of the well or production data. This tool will sort them for you.
Run this tool using above procedure.

Using VBA macro? Yes

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

Similar Posts:

Monday, January 16, 2012

Petroleum Goodies: Post Audit Production Template

Post Audit Production Template

Posted: 15 Jan 2012 08:36 PM PST

Production Template for Post Audit Review

post audit production template

This is Excel production template for post audit review. To use this tool you must have the following:

Target production rate before you drill wells.
Actual production from your wells after drilling wells.

Put your actual and target production rate in column mode starts with well name actual date and production rate in monthly basis. Your target production rate must be in month 1, 2, 3, etc. Add your new well name into Well list sheet. Extend existing formula if needed.

Use drop down cell to select different wells and to compare target versus actual production. This excel production template will look up the data based on well name you select using an array Excel function. therefore, well name must be exactly the same between actual and target production data.

Notes:

Some calculation uses EOMONTH excel function to determine number of maximum days in a month. This requires add-ons Analysis ToolPak and Analysis ToolPak – VBA to be turn on. To do this go to Tools, Add-ons and then select add-ons Analysis ToolPak and Analysis ToolPak – VBA .
This template using array formula that covers row up to 20000 for your production data (Actual and Target). You can extend this range if needed.
When adding new wells or new production data for existing wells, just add the data at the end row of Actual or Target sheets.
You must extract file to run array formula.

Use VBA macro? No

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

Similar Posts:

Saturday, December 17, 2011

Petroleum Goodies: Calculate Gas Compressibility

Calculate Gas Compressibility

Posted: 17 Dec 2011 05:00 AM PST

Excel Function To Calculate Gas Compressibility

calculate gas compressibility

This Excel tool is very helpful to calculate gas compressibility (Cg). This gas properties is estimated from gas formation volume factor that has been calculated from the previous post. On input, you have to provide gas specific gravity (air=1), gas composition (CO2 and H2S), and temperature. Gas formation volume factor calculation is provided in this tool. Gas compressibility is asymptotically approached as the pressure decrease.

Use VBA macro? Yes

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

Similar Posts:

Sunday, December 11, 2011

Petroleum Goodies: Calculate Gas Formation Volume Factor

Calculate Gas Formation Volume Factor

Posted: 10 Dec 2011 09:11 AM PST

Excel Function To Calculate Gas Formation Volume Factor

calculate gas formation volume factor

This Excel tool is very helpful to calculate gas formation volume factor (Bg). This gas properties is estimated from gas viscosity and compressibility factor that have been calculated from the previous posts. On input, you have to provide gas specific gravity (air=1), gas composition (CO2 and H2S), and temperature. Gas compressibility factor and viscosity calculations are provided in this tool. Gas formation volume factor is asymptotically approached as the pressure decrease.

Note: Gas compressibility factor is calculated using Dranchuk and Abou-Kassem equation. Gas viscosity is estimated from Lee, Gonzales and Eakin equations.

Use VBA macro? Yes

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

Tuesday, November 22, 2011

Petroleum Goodies: Excel Production Plot Template

Excel Production Plot Template

Posted: 21 Nov 2011 09:25 PM PST

Excel Production Plot Template To Visualize Your Data Quickly

This Excel production template version 2 is very useful to visualize your production data from different wells. This version 2 is different way to lookup your data compare to version 1 that uses array formula. This method uses INDIRECT Excel function that allows you to create Excel formula based on input string. Please note that you have to name your well list (see tab “List”) exactly the same with sheet name. This method allows you to put well data by sheet.

This chart is set up to 3 series but you can add more. Just add your production data in new sheet from different wells as long as you want. Then, add/update formula in sheet Plot Data and Plot. Please note that red cell is calculated data, yellow is input.

Hint: This version 2 template is running faster than previous version because version 2 is not using array formula.

Use VBA macro? No

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

Similar Posts:

Friday, November 11, 2011

Petroleum Goodies: Production Plot Template

Production Plot Template

Posted: 10 Nov 2011 07:51 PM PST

Production Plot Template To Visualize Your Data Quickly

This Excel template is very useful to visualize production data from different wells. This chart is set up to 3 series but you can add more. Just add your production data in sheet “Raw Data” from different wells as long as you want. The data is not necessary in order because we look up the value using array formula. An array formula is marked with curly bracket “{}” in sheet “Plot Data”. Please note that red cell is calculated data, yellow is input.

Use VBA macro? No

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

Similar Posts: