Wednesday, June 12, 2019

Pipes. Wall thickness calculation according ASME B31.3

File Size :- 3597 KB

This Excel sheet Contains :- 
1. Pipe wall thickness calculation according ASME B31.3
2. ASME B31.3 # 303. Pressure design of componentes.
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

Note :-
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:
  • 3.-Material allowable stress
  • 4.- Quality factor "E" for the given longitudinal weld type
  • 5.- "Y" coefficient for equation (3a)
Note 1 :- Select welding type from data validation list  

  • S Seamless pipe
  • ERW Elecric Resisitance Welded pipe
  • EFW Electric FusionWelded pipe
  • FBW Furnace Butt Welded pipe
Note 2 :- Nominal diameter from drop down list

Note 3 :- Basic alowable stresses in tension for metals  Material allowable stress interpolated for the  temperature "t", from sheet: 3.- B31.3_Table A-1

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

Note 5 :- "y" coeficient 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 uf units

Note 7 :- When thread is to be considered, the number of  threads per inch is obtained from Table 2 and the  thread heigh 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 shedule, that with the used nominal  diameter, will satisfy the requirements.

Link To Download -1