Cruisers Forum
 


Join CruisersForum Today

Reply
 
Thread Tools Rate Thread Display Modes
Old 14-06-2007, 23: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, 23: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, 23:43   #3
Senior Cruiser

Cruisers Forum Supporter

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, 23:44   #4
Senior Cruiser

Cruisers Forum Supporter

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, 01: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, 02:15   #6
Moderator Emeritus
 
GordMay's Avatar

Join Date: Mar 2003
Location: Thunder Bay, Ontario - 48-29N x 89-20W
Boat: (Cruiser Living On Dirt)
Posts: 31,573
Images: 240
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, 11: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
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




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

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


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

ShowCase vBulletin Plugins by Drive Thru Online, Inc.