I need a help regarding flange factors........

[gotothesky]

I would like to design Studding flanges for high pressure exchanger.
Commercial software for pressure vessel calculation dose not provide Design option of Studding flange.

Due to above reason, I have to make strength calculation sheet for flanges.

But, I am very sorry that I have a big problem during making calculation sheet.

In ASME Sec.VIII APP.2 Table 2-7.1, flange factors' Formulas are extremely complex!!
I checked Formulas so many times. But, I can't find out any error.
But results of F / V / f are minus values.

Is there any guy who can teach me what is wrong?
I attached excel sheet that I am making for flange calculation.

Regards,

 

[gotothesky]

Geoff13

I attached two files!
One is only for Flange factors!
The other is for completed flange calculation with factors!

First time, I prepared Flange factors according to formulas in APP.2 AMSE sec.VIII.
Even though I had checked it so many times, It seems to have some errors!
Finally I decided to complete flange factors from Figures in App.2.
The completed flange calculation is based on figure values!

I hope to get more exact factor values and reflect the exact one in flange calculation!

Thank you in advance!

Regards,

 

[Geoff13]

I only looked at your flange factor spreadsheet.

Your answers match mine exactly for equations (1) thru (45). Made checking very easy!

The only issues are in your F and f formulas.

This is a tricky one. Looking closely at the formula for F, it is the negative of the entire fraction. This would be much clearer if the Code included the negative on E6 in the numerator.

For f you also have to look at Figure 2-7.6 in the bottom left corner. f has a minimum value of 1 (as well as been assigned a value of 1 for two special situations). Add a MAX() to your formula and you should be good.

Geoff