View Full Version: Calculating cB/Displacement Spreadsheet

Nsdraftroom > Naval Technology > Calculating cB/Displacement Spreadsheet


Title: Calculating cB/Displacement Spreadsheet


Hogsweat - November 29, 2007 10:41 PM (GMT)

Stevid - November 29, 2007 11:08 PM (GMT)
Awesome, nice one mate. Excellent for everyone particulary the the beginers.

Kahanistan - December 14, 2007 05:35 AM (GMT)
Downloaded it. Had some trouble relearning how to use Excel spreadsheets, but I don't see where you account for the specific gravity of water (1.025 according to Rosdivan's thread, as you seem to be using metric) in your calculations.

The calculated displacements should be multiplied by 1.025 and the cB's divided by the same. This is only a 2.5% error, and may not be significant for most of us, but I thought I'd point it out. [/math major]

layarteb - March 30, 2008 04:02 PM (GMT)
I've actually updated this sheet with the 1.025 stuff as well as added a tab for imperial measurements. Anyone care to look?

Allanea - June 14, 2008 05:01 PM (GMT)
dead link is dead

layarteb - June 15, 2008 02:43 AM (GMT)
QUOTE (Allanea @ Jun 14 2008, 01:01 PM)
dead link is dead

Would you like me to host this on my website? I have space.

Kampfers - June 15, 2008 06:46 PM (GMT)
QUOTE (layarteb @ Jun 14 2008, 09:43 PM)
QUOTE (Allanea @ Jun 14 2008, 01:01 PM)
dead link is dead

Would you like me to host this on my website? I have space.

It was borken anyways

layarteb - June 16, 2008 03:37 AM (GMT)
QUOTE (Kampfers @ Jun 15 2008, 02:46 PM)
QUOTE (layarteb @ Jun 14 2008, 09:43 PM)
QUOTE (Allanea @ Jun 14 2008, 01:01 PM)
dead link is dead

Would you like me to host this on my website? I have space.

It was borken anyways

I had done some updated to with the 1.025 thing as above and added a tab for imperial as well. I tested it out on some RL vessels and it was pretty close.

layarteb - June 19, 2008 12:02 AM (GMT)

Gc1mak - February 27, 2010 12:36 PM (GMT)
Can somehow reupload this SS? Megaupload don't work for me in Hong Kong, and I can't find it on Layar's website.

Crookfur - February 27, 2010 12:46 PM (GMT)

Falls - February 27, 2010 07:03 PM (GMT)
What else you got hidden away there Crook?

Lamoni - February 27, 2010 08:38 PM (GMT)
QUOTE (Falls @ Feb 27 2010, 11:03 AM)
What else you got hidden away there Crook?

THIS.

Crookfur - February 27, 2010 09:02 PM (GMT)
Not a lot, the CB spread sheet wasn't even there until i hurd it was needed ;)

I've probabaly saved msot docs people have put up at soem point or another but that are all spread over my PC (i am an aweful housekeeper when it coems to files).

The only other major thing on my webspace that might be of use is big gun: http://www.drmeatballs.com/crookfur/images/BigGun.zip

edited to update lcoation to my current doman

Gc1mak - February 28, 2010 01:11 AM (GMT)
Thanks Crookfur :D

Rich and Corporations - February 8, 2012 11:11 PM (GMT)
Megaupload is down.

Crookfur - February 8, 2012 11:23 PM (GMT)
updated mah linkz




* Hosted for free by InvisionFree