Cruisers Forum
 


Reply
  This discussion is proudly sponsored by:
Please support our sponsors and let them know you heard about their products on Cruisers Forums. Advertise Here
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 14-06-2007, 22:21   #1
Registered User

Join Date: Jan 2006
Location: San Jose, California
Posts: 105
Homework using a spreadsheet

Hi,

I'm collecting data as part of my research to narrow down my choices. One of the specs I want to keep track is the Displacement/Length Ratio. Unfortunetly some manufacturers do not provide it, so what I'd like to do is create a formula in my spreadsheet that can automatically calculate the ratio.

Can anyone tell me how to do it?

If the displacement of the vessel is in column X and the length is in column Y, what is the formula that I use??

Thanks!
Redbull addict is offline   Reply With Quote
Old 14-06-2007, 22:25   #2
Registered User
 
CaptainK's Avatar

Join Date: Sep 2005
Location: Phoenix, Arizona... USA
Posts: 2,386
Images: 7
Quote:
Originally Posted by Redbull addict
Can anyone tell me how to do it?
I was going to ask you if you knew how to do that!!

No seriously?!!

Somebody on here will help you out with that. Plenty of clever folks in here. And I look forward in seeing the reply to your question.
__________________
CaptainK
BMYC

"Those who desire to give up Freedom in order to gain security, will not have, nor do they deserve, either one." - Benjamin Franklin
CaptainK is offline   Reply With Quote
Old 14-06-2007, 22:43   #3
Registered User

Join Date: Mar 2006
Location: Whangaparaoa,NZ
Boat: 63 ft John Spencer Schooner
Posts: 956
Displacement in long tone (2240lbs) divided by .01 times the cube of the lwl
dana-tenacity is offline   Reply With Quote
Old 14-06-2007, 22:44   #4
Registered User

Join Date: Mar 2006
Location: Whangaparaoa,NZ
Boat: 63 ft John Spencer Schooner
Posts: 956
ton not tone, fat fingers.
dana-tenacity is offline   Reply With Quote
Old 15-06-2007, 00:11   #5
Registered User
 
mudnut's Avatar

Join Date: Dec 2005
Location: Australia
Posts: 666
Quote:
Originally Posted by dana-tenacity
ton not tone, fat fingers.
Bragger .Mudnut.
mudnut is offline   Reply With Quote
Old 15-06-2007, 01:15   #6
Senior Cruiser
 
GordMay's Avatar

Cruisers Forum Supporter

Join Date: Mar 2003
Location: Thunder Bay, Ontario - 48-29N x 89-20W
Boat: (Cruiser Living On Dirt)
Posts: 49,831
Images: 241
See also:

Ted Brewer Presents A Primer on Yacht Design - The Numbers
Ted Brewer Yacht Design

Carl's Sail Calculator v3.0.
Sail Calculator Pro v3.0

D / L = Displacement / [( 0.01 x LWL ) cubed]
Displacement is in long tons (2240 pounds)

BOAT TYPE D/L RATIO
Light racing multihull 40-50
Ultra light ocean racer 60-100
Very light ocean racer 100-150
Light cruiser/racer 150-200
Light cruising auxiliary 200-250
Average cruising auxiliary 250-300
Heavy cruising auxiliary 300-350
Very heavy cruising auxiliary 350-400
__________________
Gord May
"If you didn't have the time or money to do it right in the first place, when will you get the time/$ to fix it?"



GordMay is offline   Reply With Quote
Old 15-06-2007, 10:03   #7
Registered User

Join Date: Jan 2006
Location: San Jose, California
Posts: 105
thanks gents!!
Redbull addict is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Advertise Here


All times are GMT -7. The time now is 23:36.


Google+
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Social Knowledge Networks
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.

ShowCase vBulletin Plugins by Drive Thru Online, Inc.