NOTICE: Our Mathcad database got attacked and infected with a virus. Unfortunately, we've had to shut it down until further notice.

You can safely browse the pages, as the Mathcad server was separate to this main website, and was only accessible here. (We used something called an iFrame, which is like a window into a different website).

UPDATE 28th of January 2020: the virus happened just over a week ago. We've temporarily cut and pasted the text parts of the Mathcad pages rather than having blank pages there.

UPDATE 3rd of February 2020: We've been unable to recover the Mathcad worksheets and offer them in a format that provided total security to users. They were published a decade ago, and our IT people say that they would need a complete re-creation with the latest code and security fixes.

APPEAL: These 44 pages were created, and offered as a free resource for over a decade. We know from our website analytics that more than 1000 users visited each month. If only half of these regular visitors donated $20, we would have enough to create an even better solution. As you know, time is money, have these Mathcad pages saved you $20 in time over the years? We expect that they have, not to mention the learning opportunities provided to new engineers entering the industry.

Please, donate at least $20 as a one-off payment, to bring back the drillers Mathcad back as an always free to use resource!

NO! I can't or won't donate to the restoration fund. I'm happy to spend a few minutes to offer a testimonial to help encourage the effort. These worksheets do have value. Offer Feedback.

API Casing strengths Worksheet, release 10, issued 30 August 2019. WORK version.

This worksheet is similar to the API casing strengths worksheet, the only difference is that the user enters pipe information rather than looking up the standard API sizes in a table. This allows the user to calculate for pipes which are not in the API tables BUT it assumes that the pipes entered are manufactured to the requirements of API 5CT.

There is no audit version of this sheet. To audit the calculations, use the API Casing Strengths Worksheet, Audit version.

Description

This worksheet takes a set of inputs typical for tubular design. It uses the formulae defined in the referenced documents to calculate the tubing design parameters and will account for the effects of temperature, internal pressure and tension.

User input

Enter the nominal outside diameter of the pipe. L_Dcs =

0.472

inchmm

Enter the nominal wall thickness of the pipe. L_tcs =

47

lb/ftkg/m

Enter the nominal weight of the pipe. wcs =

51

lbkg

Enter the additional weight per connection. Wtconn =

42

ftm

Enter average joint length. Lcsav =

50000

kgflbfNkN

Enter axial force at the depth of interest (tensile is +ve). Fa =

75

FCK

Enter the temperature at the depth of interest. Temp =

1000

psiPakPaMPa

Enter the internal pressure at the depth of interest. pi =

80

Enter the number part of the steel grade eg for L80, enter 80 (units are kpsi). Gr =

1

Enter design factor for collapse. C_dfc =

1.15

Enter design factor for burst. C_dfb =

1.25

Enter design factor for tension. C_dfts =

Click here when any values are modified to update the result.

Results

Maximum possible pipe OD within API tolerances

Minimum possible pipe OD within API tolerances

API nominal wall thickness

Minimum possible wall thickness within API tolerances

API nominal ID

ID for minimum amount of steel used within tolerances

API Drift Dia

Nominal cross sectional area

Ratio of OD to nominal wall thickness, D/t ratio

Temperature Correction Factor

API Minimum Yield Strength, nominal, ambient

API Minimum Yield Strength, with TCF and DF

Pipe body API Minimum Burst Strength, ambient

Pipe body API Minimum Burst Strength, with TCF and DF

Pipe body axial stress at nominal CSA

API collapse resistance, ambient, no axial force

API collapse resistance with TCF, DF, Biaxial & internal pressure

Plain end pipe weight, nominal dimensions

Pipe weight average with connections, nominal dimensions

Worksheet references

API Specification 5CT, 5th Edition, April 1 1995 “Specification for Casing and Tubing (U.S. Customary Units)”.

API Bulletin 5C3, 6th Edition, October 1 1994 “Bulletin on Formulas and Calculations for Casing, Tubing, Drill Pipe, and Line Pipe Properties”, also ISO/TR10400:2007 which is expected to replace API 5C3 during 2008.

Formulae for Temperature Correction Factor taken from the Exxon Casing Design Manual.

SG of steel from http://www.simetric.co.uk/si_metals.htm taken as 7.85.

Version 1 of this worksheet released on 12 January 2009.