DRILL PIPE INSPECTION

Collect past drill pipe inspections and determine the life span of current and past drill pipe for two oil rigs through Excel.

Three different methods were approaching analyzing over 6000 drill pipe.
First and Last Analysis: Finding all the surviving drill pipe by looking for any similar serial numbers from the oldest and the most recent inspection.
Lost Joint Analysis: Finding all drill pipe taken out of service due to having lower wall thickness.
Original Pipe: Tracking all of the drill pipes from the oldest inspection and trace it throughout all of the other inspections.
After each method, the data sets are reduced to a sizable amount for analysis. Each data set is put in linear regression, and data are eliminated based on how close they are to the linear as seen in Table 2. Data is selected based on the number of data points and the number of data points eliminated.
The selected datasets are put into normal distribution and put in a normal bell curve graph.

Rig 63

Rig 62

Excel

Rig 63

1/3

The data collected is very inconsistent, so not a solid conclusion can be drawn.
The first and Last analysis is not enough to conclude a trend.
Lost Joint Analysis had too few numbers of data sets
Original pipe was the most tedious yet yield the most meaningful data sets.
Thus, the result is the combination of the original pipe and the lost pipe. the estimated lifespan for Rig 62 is around 48 months and Rig 63 is around 49 months.