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.
Collapse resistance of a tubular, release 10a, issued 11 May 2008. WORK version.
This worksheet exists in two versions. They are identical apart from the way they are formatted. The Work version hides intermediate calculations and allows the user to see the results just below the inputs. This is useful for quick “what-if” games, changing various inputs to see what works best. The JIT version displays all intermediate calculations, plus adds tutorial text to explain the methodology.
ALL the figures published in API 5C2 for burst, tension, collapse and biaxial have been checked against this worksheet. Only three are different by more than rounding errors. These are noted at the bottom of the worksheet.
This worksheet takes inputs of tubular OD, wall thickness, grade, axial force, internal pressure and temperature. It uses the formulae defined in the referenced documents to calculate the collapse resistance and will account for the effects of temperature, internal pressure and tension.
Tension or compression at the depth of interest can be entered to allow the biaxial effect to be calculated. It is normal to account for the reduction in collapse resistance due to axial tension but not usual to take advantage of the increase in burst due to tension. This may be defined by your own company’s policy.
You can also enter a Design Factor to include in the calculation, or set the DF to 1 if this is not required.
4.5″ 9.5 ppf4.5″ 10.5 ppf4.5″ 11.6 ppf4.5″ 13.5 ppf4.5″ 15.1 ppf5″ 11.5 ppf5″ 13 ppf5″ 15 ppf5″ 18 ppf5″ 21.4 ppf5″ 23.2 ppf5″ 24.1 ppf5.5″ 14 ppf5.5″ 15.5 ppf5.5″ 17 ppf5.5″ 20 ppf5.5″ 23 ppf5.5″ 26.8 ppf5.5″ 29.7 ppf5.5″ 32.6 ppf5.5″ 35.3 ppf5.5″ 38 ppf5.5″ 40.5 ppf5.5″ 43.1 ppf6.625″ 20 ppf6.625″ 24 ppf6.625″ 28 ppf6.625″ 32 ppf7″ 17 ppf7″ 20 ppf7″ 23 ppf7″ 26 ppf7″ 29 ppf7″ 32 ppf7″ 35 ppf7″ 38 ppf7″ 42.7 ppf7″ 46.4 ppf7″ 50.1 ppf7″ 53.6 ppf7″ 57.1 ppf7.625″ 24 ppf7.625″ 26.4 ppf7.625″ 29.7 ppf7.625″ 33.7 ppf7.625″ 39 ppf7.625″ 42.8 ppf7.625″ 45.3 ppf7.625″ 47.1 ppf7.625″ 51.2 ppf7.625″ 55.3 ppf7.75″ 46.1 ppf8.625″ 24 ppf8.625″ 28 ppf8.625″ 32 ppf8.625″ 36 ppf8.625″ 40 ppf8.625″ 49 ppf9.625″ 32 ppf9.625″ 36 ppf9.625″ 40 ppf9.625″ 43.5 ppf9.625″ 47 ppf9.625″ 53.5 ppf9.625″ 58.4 ppf9.625″ 59.4 ppf9.625″ 64.9 ppf9.625″ 70.3 ppf9.625″ 75.6 ppf10.75″ 32.75 ppf10.75″ 40.5 ppf10.75″ 45.5 ppf10.75″ 51 ppf10.75″ 55.5 ppf10.75″ 60.7 ppf10.75″ 65.7 ppf10.75″ 73.2 ppf10.75″ 79.2 ppf10.75″ 85.3 ppf11.75″ 42 ppf11.75″ 47 ppf11.75″ 54 ppf11.75″ 60 ppf11.75″ 65 ppf11.75″ 71 ppf13.375″ 48 ppf13.375″ 54.5 ppf13.375″ 61 ppf13.375″ 68 ppf13.375″ 72 ppf16″ 65 ppf16″ 75 ppf16″ 84 ppf16″ 109 ppf18.625″ 87.5 ppf20″ 94 ppf20″ 106.5 ppf20″ 133 ppf8.625″ 44 ppf
Select a casing
Enter axial force at the depth of interest (tensile is +ve). Fa =
Enter the temperature at the depth of interest. Temp =
Enter the internal pressure at the depth of interest. pi =
Enter the number part of the steel grade eg for L80, enter 80 (units are kpsi). Gr =
Enter design factor for collapse or use 1 if design factor is not to be considered. DFc =
Click here when any values are modified to update the result.
Pipe cross sectional area
Ratio of OD to wall thickness, D/t ratio
Temperature Correction Factor
Pipe body axial stress at depth of interest
(Axial stress as a % of Minimum Yield Stress)
API collapse resistance, ambient, no axial force or DF
API collapse resistance with TCF, DF and Biaxial
API collapse resistance with TCF, DF, Biaxial & internal pressure
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.
API Bulletin 5C2, 21st Edition, October 1999 “Bulletin on Performance Properties of Casing, Tubing and Drill Pipe”.
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 1 January 2008.
Version 10 released after testing against API 5C2 21st Edition for burst, tension, collapse and biaxial. The only significant differences were found in Table 4 (biaxial) as follows, with all other results the same within normal rounding;
9.625″ 40ppf Grade 80 at -10,000 psi axial load, this worksheet showed 3167 psi vs API 3107
7.625″ 45.3ppf Grade 95 at -10,000 psi axial load, this worksheet showed 14,241 psi vs API 14,330
9.625″ 43.5ppf Grade 110 at 25000 psi axial load, this worksheet showed 4205 psi vs API 4130