Petroleum Goodies

Sunday, February 10, 2013

Petroleum Goodies: 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