[PSUBS-MAILIST] ABS Hull calulation Spreadsheet - How to use.

Jon Wallace via Personal_Submersibles personal_submersibles at psubs.org
Fri May 1 16:36:18 EDT 2015


Concatenated version for spherical heads

1) Open the excel spreadsheet
2) At top, click "Enable Editing" if you see that option
3) At top, look for a message about macros being disabled and click 
"Enable Content" so you can enter your own data
4) Click the "Spherical and Elliptical Heads" tab at the bottom.
5) Lines 5 through 9 is where you enter material properties.  It is 
preset for A516gr70.
6) Lines 10 through 22 are for hemisphere heads.
---- Line 11, enter diameter of head in column C
---- Line 15, enter thickness of head in column C
---- Line 22, read maximum allowable pressure

Note: when you enter a number in a cell you MUST click in another cell 
anywhere in the spreadsheet for the calculation to take effect.


More information about the Personal_Submersibles mailing list