Pipe Wall Thickness Calculation according to ASME B31.3 (Excel Sheet)

As we probably are aware, ASME B31.3 provides equation and rules for computation of line under tension. However the equation is very straightforward, finding right upsides of individual variables can be precarious once in a while. This cycle pipe thickness adding machine involves following equation for computation of divider thickness.

This Excel sheet Contains

1. Pipe wall thickness calculation according ASME B31.3
2. ASME B31.3 # 303. Pressure design of components.
3. ASME code for pressure piping, B31.
4. Allowable stress as function of temperature [MPa].
5. Basic Quality Factors for Longitudinal Weld Joints in Pipes.
6. Value of Y Coefficient.
7. Basic dimensions of American National Standard Taper Pipe Thread.
8. Minimum wall thickness.
9. Recommendations For Minimum Thicknesses.
10. ASME B36.10M Schedule/Identification.
11. Corrosion Allowance for ASME B31.3 Piping.
12. Appendix M. Guide to classifying fluid services.
13. ASTM A106, API 5L and ASTM A53 Seamless Carbon Steel Pipes - Pressure and Temperature Ratings
14. ANSI B16.5 - Maximum Pressure and Temperature Ratings.
15. Sample wall thickness calculation according Process Piping.
16. Pressure Rating and Piping Class.
17. Mill tolerance.
18. References
    

Important Notes

Select material from data validation list Data is taken from sheet: 3.- B31.3_Table A-1.The selected material must be able to produce valid answers in the points:

• Material allowable stress 
• Quality factor "E" for the given longitudinal weld type
• "Y" coefficient for equation (3a)

Note 1: Select welding type from data validation list  

• S Seamless pipe
• ERW Electric Resistance Welded pipe
• EFW Electric Fusion Welded pipe
• FBW Furnace Butt Welded pipe

Note 2: Nominal diameter from drop down list

Note 4 Quality factor "E" is determined from Table A-1B,  from sheet 4.- Table A-1B, for the selected  material and weld joint type.

Note 5: "y" coefficient of Eq. 3a is determined by interpolation  from Table 304.1.1, for the selected material and  temperature (sheet 5. y coefficient).  Available VBA function: y ferritic _t

Note 6: Use any consistent set of units

Note 7: When thread is to be considered, the number of  threads per inch is obtained from Table 2 and the thread height from Table 1 of sheet 6.

Note 8: Table 2, ASME B1.20.1-1983, gives the number of  threads per inch.

Note 9: For a number of threads per inch NT, Table 1,  ASME B1.20.1-198 gives a thread depth TD.

Note 10 :- Select a schedule, that with the used nominal  diameter, will satisfy the requirements.

Download Pipe Wall Thickness Calculation Sheet