Design Curves for Unpierced Dished Ends (PD5500 Figure 3.5-2)
Design Curves for Unpierced Dished Ends (PD5500 Figure 3.5-2)
(OP)
Hi All,
Regarding the title of this post i was wondering if anyone has ever wrote a formula for the graph as I'm using it a lot and it would be great help to have it automated on my spread sheet rather than having to pull out this graph all the time.
Or
Does anyone one know how to formulate the the graph???
Best Regards
Jonno
Regarding the title of this post i was wondering if anyone has ever wrote a formula for the graph as I'm using it a lot and it would be great help to have it automated on my spread sheet rather than having to pull out this graph all the time.
Or
Does anyone one know how to formulate the the graph???
Best Regards
Jonno





RE: Design Curves for Unpierced Dished Ends (PD5500 Figure 3.5-2)
Maybe the attached can help?
You can input the table and look it up in Excel then use the Logarithmic Interpolation.
Cheers
RE: Design Curves for Unpierced Dished Ends (PD5500 Figure 3.5-2)
Thank you for your reply this does help.
My only other thing is if i want to calculate this automatically this would mean i have to note a lot of points down and then get excel to pick the correct range to look from??? and then use logarithmic interpolation to get the values in between the he/D line if my value isn't exactly on the line.
Is this correct??
gonna be a lot of work (but probably worth it).
Jonnox
RE: Design Curves for Unpierced Dished Ends (PD5500 Figure 3.5-2)
RE: Design Curves for Unpierced Dished Ends (PD5500 Figure 3.5-2)
I think i will be able to get excel to look up the correct range depending on the value of p/f.
I was hoping the second part to your post wasn't agreeing with the amount of work required!!
Oh well here goes the time consuming part, wish me luck!
Best Regards
Jonnox