<html><head></head><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1518961762502_5019"><span>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.</span></div><div id="yui_3_16_0_ym19_1_1518961762502_5019"><span><br></span></div><div id="yui_3_16_0_ym19_1_1518961762502_5019"><span>The second is called, "Security Warning" and is where you enable Macros. Click on "Enable Content".</span></div><div id="yui_3_16_0_ym19_1_1518961762502_5019"><span><br></span></div><div id="yui_3_16_0_ym19_1_1518961762502_5019">Jon</div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: times new roman, new york, times, serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"><font size="2" face="Arial"> On Saturday, February 17, 2018 10:37 PM, Eric Bruhahn via Personal_Submersibles <personal_submersibles@psubs.org> wrote:<br></font></div> <br><br> <div class="y_msg_container"><div id="yiv0802121289"><div dir="ltr"><div>
<div><div>Hi All,<br><br></div>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. <br><br>So I've been trying to use Procedure 2-2 in the Pressure Vessel Design Manual and having some questions.<br><br>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 ?<br><br></div>Can anyone see what I'm doing wrong here?
<br><br></div>-Eric<br></div>
</div>_______________________________________________<br>Personal_Submersibles mailing list<br><a ymailto="mailto:Personal_Submersibles@psubs.org" href="mailto:Personal_Submersibles@psubs.org">Personal_Submersibles@psubs.org</a><br><a href="http://www.psubs.org/mailman/listinfo.cgi/personal_submersibles" target="_blank">http://www.psubs.org/mailman/listinfo.cgi/personal_submersibles</a><br><br><br></div> </div> </div> </div></div></body></html>