ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
(OP)
Hi there,
I have converted all of Appendix 13 (Non-Circular Vessels) into a spreadsheet.
I am having a problem ironing out the errors in the more complex Sketch 6. Is anyone an expert on this?
I am prepared to give all my Appendix 13 spreadsheets if someone wants to work with me on this. Is there a Spreadsheet forum that anyone knows of?
In Particular, ThetaM is supposed to measure the angle on the long-side radiused bend where the bending stress is the greatest. It comes up with angles over 70°. However the bend in my example is only 45° in total. I get similar results for other examples. How can a stress be at 70° when the bend is only 45°. Below is the equation which makes no sense. It is close to the beginning of the calcs so I can't see an error.
Theta1 = arctan(-K5*S1/(2R²-R*S1-L3*t1))
where
K5 = L2 + L21
S1 = 2*R + t1 (This dimension makes no sense.)
Also betaM = arctan(CM/(L3-E*Theta1)) is strange
Surely it should be betaM = arctan(CM/(L3-EM))
But ASME has no errors? Right?
I have attached a drawing of the example if it helps.
I have used CodeCalc to check it. It gives a similar crazy angle but I found that CodeCalc has a few errors in its App13 calcs so can't trust it to much.
Any help would be appreiciated.
I have converted all of Appendix 13 (Non-Circular Vessels) into a spreadsheet.
I am having a problem ironing out the errors in the more complex Sketch 6. Is anyone an expert on this?
I am prepared to give all my Appendix 13 spreadsheets if someone wants to work with me on this. Is there a Spreadsheet forum that anyone knows of?
In Particular, ThetaM is supposed to measure the angle on the long-side radiused bend where the bending stress is the greatest. It comes up with angles over 70°. However the bend in my example is only 45° in total. I get similar results for other examples. How can a stress be at 70° when the bend is only 45°. Below is the equation which makes no sense. It is close to the beginning of the calcs so I can't see an error.
Theta1 = arctan(-K5*S1/(2R²-R*S1-L3*t1))
where
K5 = L2 + L21
S1 = 2*R + t1 (This dimension makes no sense.)
Also betaM = arctan(CM/(L3-E*Theta1)) is strange
Surely it should be betaM = arctan(CM/(L3-EM))
But ASME has no errors? Right?
I have attached a drawing of the example if it helps.
I have used CodeCalc to check it. It gives a similar crazy angle but I found that CodeCalc has a few errors in its App13 calcs so can't trust it to much.
Any help would be appreiciated.





RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
Attached is the problemed spreadsheet.
Two cells are my greatest problem. If you can campare betaM and ThetaM that would be good.
I suspect there may still be an error or two in the final stress calcs. So it would be good if you have the time to pdf a few examples of your own. If you have the time.
Thanks,
RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
The Theta1 equation is Theta1 = arctan(L4/L3).
The equation that you show is ThetaM equation.
I think that you should use E*Theta1 at BetaM equation. You are using EM, that I think is wrong. There are a variable E(subscribe)theta1 that I think shouldn't used here.
RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
I have already made all your thoughts a few times over. And I agree that Appendix 13 says what you are saying.
However these equations are simple geometry equations. If drawn in AutoCAD ThetaM and BetaM don't line up with the geometric drawing.
betaM = arctan(CM/(L3-E*Theta1)) has no geometric meaning.
What is the Youngs modulus or weld efficiency doing in a geometric equation.
betaM = arctan(CM/(L3-EM)) works perfectly in the geometry.
And then there is Theta1 = arctan(-K5*S1/(2R²-R*S1-L3*t1)) which is supposed to find the angle at which the greatest stress occurs in a bend, however returns an angle greater then the total angle of the bend. You can't calculate a stress in thin air.
These two equations are at the beginning of the spreadsheet and are quite simple. It doesn't add up.
RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
E*Theta1 is a typo in ASME 2007. Theta1 should be a subscript. The formula should be...
βM = tan-1 [CM / (L3 - Eθ1)]
where Eθ1 = R(1.0 - cos θ1)
RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
Crompto29 is right about the use of E_M instead of E_theta1 in the equation of Beta_M. I think that ASME is wrong. But the equation of Theta1 is still a mystery ...
RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
You could write the ASME B&PVC committee and request for an interpretation.
With regards to θM being greater than θ1, my guess is that if θM > θ1, then θM = θ1. I think that's what ASME did in their example on Appendix 13-17(j). The example showed the result for the membrane stress at the corner segment, (Sm)M. Try to calculate for (Sm)M and see if you get the same result as ASME.
RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
That worked. The example isn't referenced in the beginning of the Appendix. Somehow I didn't find it.
It appears that much of the design geometry for this type of rectangular vessel is not exact however is adequate for Appendix 13 purposes.
So,
βM = tan-1 [CM / (L3 - Eθ1)] is a typo and should be
βM = tan-1 [CM / (L3 - EM)]
and
θM should be calculated as per the code but have a maximum value of θ1.
(How do you do make letters subscript in your posts?)
RE: ASME VIII - Appendix 13 - Sketch 6 Spreadsheet issue
ht