Petroleum Goodies: November 2011

Tuesday, November 22, 2011

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

Tuesday, November 8, 2011

Petroleum Goodies: Excel XY Chart Labeler

Excel XY Chart Labeler

Posted: 08 Nov 2011 05:00 AM PST

Quick Excel XY Chart Labeler

Excel XY Chart Labeler

This Excel add-ins from Application Professionals is very helpful when you want to label your data point in Excel chart. Using this tool you don’t have to put label one by one to your data points.

How To Install Excel XY Chart Labeler

Download and extract the attachment below. Close your Excel before run the XYChartLabeler.exe setup file. Once you’ve installed the chart labeler you should see a new sub-menu called XY Chart Labels below the Excel Tools menu. If you are running Excel 2007 this menu will be located on the Add-Ins tab. If you don’t see the XY Chart Labels menu, see the Troubleshooting section from the author website.

How To Use Excel XY Chart Labeler

Click Add Chart Labels from Excel menu Tools – XY Chart Labels.
Select the data series you want to label,
Specify the range that you want to use as labels,
Set the position where the labels will be placed in relation to the data points.

Note that the number of cells you select as your label range must be exactly the same as the number of data points in the selected data series.

Use VBA macro? Yes

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

Similar Posts:

Monday, November 7, 2011

Petroleum Goodies: Calculate Minimum Distance – Vertical Wells

Calculate Minimum Distance – Vertical Wells

Posted: 07 Nov 2011 06:00 AM PST

Measure Minimum Distance of Vertical Wells

This tool is useful to calculate minimum distance from surrounding vertical wells. It’s very helpful to estimate well spacing, especially when you have many wells. The idea is to measure the distance between wells from their X-Y path locations. This tool will search the well within given radius of search, this to speed up the search process.

Stay tune to get update on this well distance calculation.

Use VBA macro? Yes

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

Similar Posts:

Sunday, November 6, 2011

Petroleum Goodies: Convert Hourly Production Data To Daily Data

Convert Hourly Production Data To Daily Data

Posted: 05 Nov 2011 02:49 PM PDT

Tool To Convert Hourly Production Data To Daily Data

If you have big daily production data, sometime it can take your time to convert them to daily production using Excel Average function.

There is an easier way to do this is using the capability of Ms. Excel to do array calculations. This calculation is marked by curly brackets “{}”. You can find an example converting hourly data to daily in this tool. If you want to convert your daily data to monthly or yearly you can use Convert Daily to Monthly tool which has been posted earlier.

Hint: When editing an array formula press Shift & Ctrl buttons (don’t release them yet) then hit Enter to apply.

Use VBA macro? No

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