Boat comparison spreadsheet - SailNet Community
 
LinkBack Thread Tools
post #1 of 9 Old 06-27-2004 Thread Starter
Member
 
Join Date: Jun 2004
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 11
 
Boat comparison spreadsheet

A while back I ran across a website that had a fairly simple Excel spreadsheet for comparing (3) different boats.

It was semi-useful (i.e. ''quick & dirty) spreadsheet in that it automatically calculated D/L, B/D ratio, etc and charted the results.

It also provided subjective comparisons based on a value (0-20) for things like storage, galley, headroom, etc. You would assign the category a value based on how important the category was (based on your subjective assessment of the category) then total everything allowing you to compare these values between the boats.

Now I can''t find the spreadsheet or where I located it on the web.

Anyone know what I''m talking about and where I can find it?
mmccoy is offline  
Quote Quick Reply Share with Facebook
Sponsored Links
Advertisement
 
post #2 of 9 Old 06-27-2004
Senior Member
 
Join Date: Sep 2002
Location: Callao, VA
Posts: 108
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 13
 
Boat comparison spreadsheet

I don''t think this is what you are looking for specifically, but it has a lot of info on a lot of boats:

http://image-ination.com/sailcalc.html

I created my own Excel spreadsheet that I use for boat comparisons. I''d be happy to send you a copy if you are interested.

Gerhard
gstraub is offline  
Quote Quick Reply Share with Facebook
post #3 of 9 Old 06-28-2004
Senior Member
 
Join Date: Jul 2001
Posts: 272
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 14
 
Boat comparison spreadsheet

Go to www.re-sail.net. All the numbers you need on over 2900 boats are already there, sorted every way you can imagine.
drynoc is offline  
Quote Quick Reply Share with Facebook
post #4 of 9 Old 06-28-2004 Thread Starter
Member
 
Join Date: Jun 2004
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 11
 
Boat comparison spreadsheet

Neither was the particular spreadsheet I was looking for. Sailcalc is very nice though. Certainly more thorough regarding the ''important'' parameters (S/D, motion comfort, etc.). The re-sail database isn''t what I need as I have my ''short list'' and don''t need the extensive database of 2900 different boats.

What I thought was useful with the spreadsheet I was seeking is the ability to subjectively rank a number of ''user specified criteria'' on a scale of 1-20. For example, lets say the Galley is an important factor in choosing a boat. Maybe Boat ''A'' had the perfect galley. You would give it a ''20''. Boat ''B'' had a nice one but but the icebox didn''t have thick insulation. You would give it, say, a ''15''. The 3rd boat ''C'' didn''t have a galley at all so you would give it a zero.

The spreadsheet would then total up all the numbers in all the categories and give each boat a ''score''. I guess that would be easy enough to replicate on my own though. Just nice to have it ''integrated'' to something not unlike the sailcalc calculator in a stand-alone excel spreadsheet.

Gerhard, sure... I''m alsways looking for new wasy to look at data! I''d love to have a copy of the spreadsheet you created. You can send it to:

mmccoy@copper(remove).net

And thanks!
mmccoy is offline  
Quote Quick Reply Share with Facebook
post #5 of 9 Old 06-28-2004
Member
 
Join Date: Mar 2002
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 14
 
Boat comparison spreadsheet

Hi, I sent a seperate e-mail with an attached spreadsheet... not exactly the one your after but take it for what it''s worth...

I think I''d once seen the spreadsheet that you mentioned, however, I couldn''t find it either, when I went back to look at it... so, I constructed my own with calculations from various sources on the web. Below are the links I used to create it. None of these calcs is really useful for comparing metrics for different boats on galley size etc. but they will tell you something about sailing characteristics.

http://www.nsc.ca/tools/boat_metrics.htm
http://www.sailingusa.info/motion_comfort.htm
http://www.tedbrewer.com/yachtdesign.html
mdougan is offline  
Quote Quick Reply Share with Facebook
post #6 of 9 Old 06-29-2004
Junior Member
 
Join Date: Apr 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
 
Boat comparison spreadsheet

Seems that I read about that spreadsheet in "Good Old Boat"...within the last year?

John
CherylannJohn is offline  
Quote Quick Reply Share with Facebook
post #7 of 9 Old 06-29-2004 Thread Starter
Member
 
Join Date: Jun 2004
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 11
 
Boat comparison spreadsheet

mmccoy is offline  
Quote Quick Reply Share with Facebook
post #8 of 9 Old 06-29-2004 Thread Starter
Member
 
Join Date: Jun 2004
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 11
 
Boat comparison spreadsheet

Bingo John!

Good Old Boat rang a bell and I went to the site. I couldn''t find it just looking around on the website but when I did a google for "good old boat spreadsheet" it popped up:

http://www.goodoldboat.com/right_boat.html

However, I must say the spreadsheets that were sent to me (THANKS!) were more comprehensive. However, with a little tweeking the ''GOB'' spreadsheet will rank ''highly desirable items'' for 3 ''definable'' boats. Very subjective, but interesting/useful.

Thanks for remembering where you saw it.
mmccoy is offline  
Quote Quick Reply Share with Facebook
post #9 of 9 Old 06-29-2004 Thread Starter
Member
 
Join Date: Jun 2004
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 11
 
Boat comparison spreadsheet

Whoops.. double post
mmccoy is offline  
Quote Quick Reply Share with Facebook
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the SailNet Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
Please note: After entering 3 characters a list of Usernames already in use will appear and the list will disappear once a valid Username is entered.


User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in









Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Similar Threads
Thread Thread Starter Forum Replies Last Post
Re-naming the boat pirateofcapeann General Discussion (sailing related) 130 01-07-2014 11:14 AM
New name (I know, I know) owlmtn Boat Review and Purchase Forum 13 12-13-2009 07:46 PM
help with lifes dream kimby Boat Review and Purchase Forum 37 12-02-2009 11:32 PM
What can you tell from the numbers? brazilnut Boat Review and Purchase Forum 10 07-01-2009 04:09 PM
buying first boat jerrycooper14 Boat Review and Purchase Forum 21 04-23-2002 02:15 PM

Posting Rules  
You may post new threads
You may 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 On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome