Homework using a spreadsheet

[Redbull addict]

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!

[CaptainK]

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.

[dana-tenacity]

Displacement in long tone (2240lbs) divided by .01 times the cube of the lwl

[dana-tenacity]

ton not tone, fat fingers.

[mudnut]

Originally Posted by dana-tenacity

ton not tone, fat fingers.

Bragger .Mudnut.

[GordMay]

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

[Redbull addict]

thanks gents!!