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)
- S Seamless pipe
- ERW Elecric Resisitance Welded pipe
- EFW Electric FusionWelded pipe
- FBW Furnace Butt Welded pipe
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.
You May Also Like These E-Books:-
vevry good
ReplyDeletePdf download is not there
DeletePdf download is not there
DeletePdf download is not there
DeleteExcellent
ReplyDeleteok..
ReplyDeletedownload link
ReplyDeleteSuper i need this
ReplyDeleteGood day. Where is the link?
ReplyDeleteno link ?
ReplyDeleteThank you very much
ReplyDeleteI value the article. Thanks Again. Much obliged.plumbers near me
ReplyDeleteI cannot thank you enough for the blog article. Really looking forward to read more. Great.
ReplyDeletehttps://theguttergobbler.co.uk/gutter-cleaning-southampton-local-reliable-gutter-cleaning-specialists/