Petroleum Goodies

Tuesday, November 8, 2011

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