ASME Flange Design Calculation
Description
Flange qualified for B31.3 service per 304.5.1(b) using ASME BPVC Section VIII Division 1 App.2. Alternatively flange may be qualified for B31.3 per 304.7.2(a) 'extensive successful service'. Items highlighted in Blue are information from drawing. Items highlighted in Orange are information estimated by engineer. Calculation checks: Flange Stresses, Bolting Criteria, Weld Criteria, Rigidity Criteria, Gasket Seating Condition Satisfied, MAWP based on Bolt Stress, MAWP based on Flange Stress and Total Permissible MAWP.
Calculation Preview
Submitted By:
Submitted On:
06 Feb 2020
File Size:
150.96 Kb
Downloads:
84
File Version:
1.0
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
1. It looks like the following cells are hard coded with equations with no variables: E24, E25, E27, E38, E42, . These equations won’t be accurate for all flanges, please fix these.
2. The hub numbers (cells E25, E26, and E27) are not used in any calculations in the spreadsheet, but they are used in calculations in ASME BPVC Section VIII Division 1 Appendix 2. Can you update the calcs that should use cells E25, E26, and E27?
3. It would seem that all the cells that are controlled by calculations should be protected so they aren’t accidentally changed. Can you do that to make sure the integrity of the calculations is not compromised?
4. It would seem that D22 should be labeled as KL (for loose type) or KI (for integral type). And the parameter in C22 should reflect the same.
5. Cell E42 (tongue width) isn’t used in any equations. Is it supposed to be?
6. Longitudinal Hub Stress (E79 & E98) and Radial Flange Stress (E80 & E99) are hard coded to be zero. Tangential stress (E81 & E100) doesn’t seem to account for integral type. These equations should follow ASME BPVC Section VIII Division 1 Appendix 2, section 2.7 equations 8, 9, and 10 for integral type flanges.
7. I would also like to know if you have a validation proof that the results are accurate and per the code.
#NAME?' error I think it's looking for the file below, is there something additional I need to download?
='C:\Program Files (x86)\XLC\XLC.xlam'!EQS(E21,'Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 1; ShowWorking= 0; EqnStyle= 0; Eqp$F$21_2')