Free Cross Over Generator Excel Spreadsheet for Oilfield Use

You may have a problem regarding ordering the cross over to use on the rig because there are so many threads used for the operation. For example if you have just only three threads (3-1/2” IF, 4-1/2” IF, 7” BTC) for the operation. These are a total of 18 the possible crossovers that you may need as listed below.

3-1/2″ IF PIN X 4-1/2″ IF BOX

3-1/2″ IF PIN X 7″ BTC BOX

4-1/2″ IF PIN X 3-1/2″ IF BOX

4-1/2″ IF PIN X 7″ BTC BOX

7″ BTC PIN X 3-1/2″ IF BOX

7″ BTC PIN X 4-1/2″ IF BOX

3-1/2″ IF PIN X 3-1/2″ IF PIN

3-1/2″ IF PIN X 4-1/2″ IF PIN

3-1/2″ IF PIN X 7″ BTC PIN

4-1/2″ IF PIN X 4-1/2″ IF PIN

4-1/2″ IF PIN X 7″ BTC PIN

7″ BTC PIN X 7″ BTC PIN

3-1/2″ IF BOX X 3-1/2″ IF BOX

3-1/2″ IF BOX X 4-1/2″ IF BOX

3-1/2″ IF BOX X 7″ BTC BOX

4-1/2″ IF BOX X 4-1/2″ IF BOX

4-1/2″ IF BOX X 7″ BTC BOX

7″ BTC BOX X 7″ BTC BOX

You will get lost easily, won’t you??

confused

As you can see, it is quite tricky to determine all possible required cross over especially when you have a lot of connections. Therefore we create an Excel file to help you do this task. We call this file as “Cross Over Generator”.

facebook-show


What will this file help you?

It will help you generate all possible x-overs then you can identify which one you need or not. It will greatly reduce failure if you forget something.

Download the x-over generator file here ->http://goo.gl/CjDpZO

Then you open the file using Microsoft Excel. You will see the screen link this

Figure 1 - Open up

Figure 1 – Open up

 

First of all you need to enable Macro. You click “Enable Content” (Figure 2).

Figure 2 - Enable Content

Figure 2 – Enable Content

How To Use This file

This is the main page of this file (Figure 3).

Figure 3 - Main Page

Figure 3 – Main Page

 

You need to put the connection types in the blue cells only and you can input to 500 different connections (Figure 4 and Figure 5).

Figure 4 - Input Cells

Figure 4 – Input Cells

Let’s input some data into these cells.

4-1/2″ IF (NC 50)

3-1/2″ REG

9-5/8″ BTC

3-1/2″ FOX

4″ FH

4″ XT39

  Figure 5 - Input data

Figure 5 – Input data

Then you click “Generate X-over” (Figure 6)

Figure 6 - Generate Result

Figure 6 – Generate Result

Macro in the Excel file will generate all possible x-over like this (Figure 7).

 Figure 7 – x-over list generated

Figure 7 – x-over list generated

 

The cross-overs which are generated by this macro consist of three main types which are Box – Pin, Pin – Pin and Box – Box (Figure 8).

Figure 8 - Three main types of x-over

Figure 8 – Three main types of x-over

 

From the example above, you will get a total of 72 types of x-over.

Finally, you can select which one you need for operation from the list created by this file. We wish this file would help you to figure out the possible cross over needed for your operation. Please feel free to share with your friends : )

Tagged , . Bookmark the permalink.

About DrillingFormulas.Com

Working in the oil field and loving to share knowledge.

6 Responses to Free Cross Over Generator Excel Spreadsheet for Oilfield Use

  1. ABoungou says:

    Need a Excel sheet

  2. Mohamed Ali says:

    Very good idea thank you for your help

  3. Rathesh says:

    Great !! Astonishing …..

  4. Marcel says:

    a Dropdown menu for all Connection types would be great

  5. Rob says:

    Fabulous tool – thank you!

  6. jalal alhatoum says:

    Thank you for your information

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.