[PSUBS-MAILIST] Pressure Hull Calculations

[Eric Bruhahn via Personal_Submersibles]

Thanks Jon,

I guess that's what I get for trying to use the Office 365 version of Word.
Got a real version and it works just fine. Anyway I got a lot of variations
of pressure hulls calculated now and I think I've got a design narrowed
down.

-Eric

On Sun, Feb 18, 2018 at 5:58 AM, Jon Wallace via Personal_Submersibles <
personal_submersibles at psubs.org> wrote:

> 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
>
>
>
> _______________________________________________
> 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/20180305/5257a80b/attachment.html>