[PSUBS-MAILIST] Pressure Hull Calculations

[Jon Wallace via Personal_Submersibles]

You have to enable Macros.  Different versions of MS excel can be different, but when you open the document look for "warnings" at the top.  I get two of them, the first is called "Protected View" and warns that the document came from the internet and might be unsafe.  There is a button "Enable Editing" that has to be clicked.
The second is called, "Security Warning" and is where you enable Macros.  Click on "Enable Content".
Jon 

    On Saturday, February 17, 2018 10:37 PM, Eric Bruhahn via Personal_Submersibles <personal_submersibles at psubs.org> wrote:
 

 Hi All,

I've been having issues getting the ABSHullCalc spreadsheet to work for me, most of the function macros show as #MACRO? using Open Office Calc or #NAME? using MS Excel even with macros enabled. 

So I've been trying to use Procedure 2-2 in the Pressure Vessel Design Manual and having some questions.

For a 120" cylinder including heads, 40" diameter with 0.25" thick 516gr70 plate and a Px of 175 psi I'm getting Pa=29.2psi. So, to calculate required stiffeners to raise Pa I'm trying to use 1.25"x0.25" T rings with 10" spacing (Ls) and getting I=0.618, As=0.625 giving me Factor "B" of 1,411 if P in the calculation is 14.7 psi. Now the problem with this is my Factor "B" is not even shown on Figure 2-1g. Increasing my Ls to 20" gives Factor "B" of 1,568, closer but still short of the lowest number in the figure of 2,500. In step 10 am I reading it right as I=(0.16*(Do^3)*Px*Ls)/E ?

Can anyone see what I'm doing wrong here?

-Eric
_______________________________________________
Personal_Submersibles mailing list
Personal_Submersibles at psubs.org
http://www.psubs.org/mailman/listinfo.cgi/personal_submersibles


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.whoweb.com/pipermail/personal_submersibles/attachments/20180218/81c999e3/attachment.html>