[PSUBS-MAILIST] Shackleton stability spreadsheet

[Alec Smyth via Personal_Submersibles]

Hi everyone, here's the spreadsheet I used in my convention presentation.
Please be mindful this is highly questionable math from a thoroughly
unqualified source. It contains design-specific formulas that will not work
for other boats. It is, in short, completely unwarranted and your designs
should not be based on it without considerable rework. But you might have
some fun just noodling around. When you find errors, please do point them
out.

I recommend playing with the values on the Operational Dash sheet for a
while first to get a feel for how this works, before trying to figure out
the logic on the Calculations sheet. To explain some of the variables on
the dash:

Shackleton has up to four large floats arranged in a ring at the stern end
of the hull, and you specify the number of floats with the variable "Stern
float ring." Similarly, "Fifth stern float" is just a 1 or a 0 and refers
to the sternmost float of all if used, and "Num forward floats" is the
number of much smaller floats mounted on the forward half of the boat. The
basic idea is that you weigh your passenger and pilot, and pick a
combination of floats, weights, and weight tray position that gets you
approximately neutral and trimmed. The boat has no VBT.


Thanks,

Alec
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.whoweb.com/pipermail/personal_submersibles/attachments/20160803/3da4fba9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Static stability Shackleton.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 30165 bytes
Desc: not available
URL: <http://www.whoweb.com/pipermail/personal_submersibles/attachments/20160803/3da4fba9/attachment-0001.bin>