This spreadsheet will help you calculate Flange Rating, based on ASME 16.5 - 2009. Please use this calculator for NPS ranging from 0.5 to 24. Supported Flange Materials are as follows:
- 1.1 _Normal Carbon Steel_A 105, A 350 Gr. LF2, LF6 CI. 1, A 350 Gr. LF3, A 216 Gr. WCB
- 1.2 _High Carbon Steel_A 350 Gr. LF6 Cl. 2, A 216 Gr. WCC, A 352 Gr. LCC, LC2, LC3
- 1.3 _High Carbon Steel_A 352 Gr. LCB, A 217 Gr. WC,1 A 352 Gr. LC1
- 1.4 _Low Carbon Steel_A 350 Gr. LF1 Cl. 1
- 1.5 _Alloy Steel_A 182 Gr. F1
- 1.7 _Alloy Steel_A 182 Gr. F2, A 217 Gr. WC4, WC5
- 1.9 _Alloy Steel_A 182 Gr. F11 CL.2, A 217 Gr. WC6
- 1.10 _Alloy Steel_A 182 Gr. F22 Cl. 3, A 217 Gr. WC9
- 1.11 _Alloy Steel_C-V2M0
- 1.13 _Alloy Steel_A 182 Gr. F5a, A 217 Gr. C5
- 1.14 _Alloy Steel_A 182 Gr. F9, A 217 Gr. C12
- 1.15 _Alloy Steel_A 182 Gr. F91, A 217 Gr. C12A
- 1.17 _Alloy Steel_A 182 Gr. F12 Cl. 2, F5
- 1.18 _Alloy Steel_A 182 Gr. F92
- 2.1 _Austenitic Steel_A 182 Gr. F304, F304H, A 351 Gr. CF3, CF8
- 2.2 _Austenitic Steel_A 182 Gr. F316, F316H, F317, A 351 Gr. CF3M,CF8M, CG8M
- 2.3 _Austenitic Steel_A 182 Gr. F304L, F316L, F317L
- 2.4 _Austenitic Steel_A 182 Gr. F321,F321H
- 2.5 _Austenitic Steel_A 182 Gr. F347, F347H, F348, F348H
- 2.6 _Austenitic Steel_A 240 Gr. 309H
- 2.7 _Austenitic Steel_A 182 Gr. F310, A 240 Gr. 310H
- 2.8 _Ferritic/Austenitic Steel_A 182 Gr.F44,F51,F53,F55, A 351 Gr.CK3MCuN,CE8MN,CD4MCu,CD3MWCuN
- 2.9 _Ferritic/Austenitic Steel_A 240 Gr. 309S,310S
- 2.10 _Ferritic/Austenitic Steel_A 351 Gr. CH8 , CH20
- 2.11 _Ferritic/Austenitic Steel_A 351 Gr. CF8C
- 2.12 _Ferritic/Austenitic Steel_A 351 Gr. CK20
- 3.1 _Alloy 20
- 3.2 _Nickel 200
- 3.2 _Nickel 200
- 3.4 _Alloy 400, R-405
- 3.5 _Alloy 600
- 3.6 _Alloy 800
- 3.7 _Alloy B-2
- 3.8 _Alloy C-276, 625, N, C-4, 825, C-22 ,UNS N10001
- 3.9 _Alloy X , Alloy 556
- 3.10 _Alloy 700
- 3.11 _Alloy 904L
- 3.12 _UNS N08320, Alloy G-3, AL-6XN, A 351 Gr. CN3MN
- 3.13 _UNS N06975, Alloy 31
- 3.14 _Alloy G, G-30, G-35
- 3.15 _Alloy 800 H
- 3.16 _Alloy 330
- 3.17 _A 351 Gr. CN7M
- 3.19 _Alloy 230
So, without wait, you can get this spreadsheet from here. As usual, this spreadsheet is uploaded at dropbox.com, so just make sure that it is not blocked at your workplace. If you think that i have violated any copyright by publishing this spreadsheet, please contact us for the claim.
We have published many spreadsheets in past. You can find those posts as below:
Tagged as :
Downloads
Piping Design
It doesnt work when downloaded..
ReplyDeletePls. check & reattach the excel sheet
Thnx
Sam, can you tell the exact problem your facing?
ReplyDeleteAnkit, When I click on the link to download the excel sheet & click on open, the microsoft excel error pops up " The filename has been changed. Pleas rename to the original filename [Flange Rating_(NPS0.5~24)_V3.0.xls]"
ReplyDeleteThere must be some issue in your computer. All other readers have not faced this problem yet.
ReplyDeleteI have the same peoblem as Sam filename changed. can this be resolved?
ReplyDelete