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??
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”.
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
First of all you need to enable Macro. You click “Enable Content” (Figure 2).
Figure 2 – Enable Content
How To Use This file
This is the main page of this file (Figure 3).
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
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
Then you click “Generate X-over” (Figure 6)
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
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
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 : )
Need a Excel sheet
Very good idea thank you for your help
Great !! Astonishing …..
a Dropdown menu for all Connection types would be great
Fabulous tool – thank you!
Thank you for your information