Any Spreadsheets for Comparing Boats ? - SailNet Community
 
LinkBack Thread Tools
post #1 of 7 Old 09-28-2007 Thread Starter
Junior Member
 
Deckerd's Avatar
 
Join Date: Sep 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
 
Question Any Spreadsheets for Comparing Boats ?

Was going to put together a simple spreadsheet to enable wifey and I to compare and prioritize used boats (40-50 ft blue water cruisers) and their various features. Most likely this wheel has already been invented.....

Anyone have such an itwm or know where one is?
Deckerd is offline  
Quote Quick Reply Share with Facebook
Sponsored Links
Advertisement
 
post #2 of 7 Old 09-28-2007
moderate?
 
camaraderie's Avatar
 
Join Date: May 2002
Location: East Coast
Posts: 13,877
Thanks: 0
Thanked 3 Times in 3 Posts
Rep Power: 16
     
Nope...no such thing I've ever seen.
camaraderie is offline  
Quote Quick Reply Share with Facebook
post #3 of 7 Old 09-28-2007
Member
 
Join Date: Oct 2004
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 11
 
my wife doesn't like spreadsheets. She just likes sheets.
what does a spreadsheet look like?
42ndstreet is offline  
Quote Quick Reply Share with Facebook
post #4 of 7 Old 09-28-2007
humble pie rat
 
CapnHand's Avatar
 
Join Date: Nov 2006
Location: Location, Location
Posts: 867
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 9
 
There is a 6sigma tool called the 'house of quality' that could be used. I'm sure there are some for downloading from the net. Here is an example. You'd put the qualities you want in a boat in the first column, rank how important those qualities are to you in the second column and then list the boats you are considering across the other columns, ranking how well they address your needs as High (9), Medium (3) or Low (1). Total the product of the ranking x importance for each boat along the bottom row.

Last edited by CapnHand; 09-28-2007 at 11:53 PM.
CapnHand is offline  
Quote Quick Reply Share with Facebook
post #5 of 7 Old 09-29-2007
Senior Member
 
Join Date: May 2006
Posts: 825
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 10
 
Yes http://www.image-ination.com/sailcalc.html will give you various parameters, or locate boats which meet chosen criteria in standard boat characteristic terms.
I made my own spreadsheet inserting the formulae, and it is quite useful for seeing at a glance what the characteristics are. This was for a smaller size than you are interested in.
Some additional areas like number of heads, you will have to compile and score yourself because the scores are subjective.
However there are several threads here which will give you the names of boats which you might consider and which you can follow up to get the data.
chris_gee is offline  
Quote Quick Reply Share with Facebook
post #6 of 7 Old 09-29-2007
Senior Member
 
garymcg's Avatar
 
Join Date: Jun 2006
Location: Ann Arbor, MI
Posts: 110
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 10
 
Quote:
Originally Posted by CapnHand View Post
There is a 6sigma tool called the 'house of quality' that could be used. I'm sure there are some for downloading from the net. Here is an example. You'd put the qualities you want in a boat in the first column, rank how important those qualities are to you in the second column and then list the boats you are considering across the other columns, ranking how well they address your needs as High (9), Medium (3) or Low (1). Total the product of the ranking x importance for each boat along the bottom row.
I did this (not 6sigma) using a criteria spreadsheet, it was very useful.
I also used a sheet with all of the equipment I would like and line by line upgrade cost if the equipment that needed to be added or replaced for each potential boat, including transortation/taxes etc. Another sheet in the same workbook for boat shopping expenses, etc, etc. Like I said it was very useful, it helped us a great deal as some boats would have cost a small fortune to equip even though it didn't appear so at first glance.

Even if the upgrades cost more than you think, it's not the accuracy of the final amount that counts, it's the fact that you're comparing apples to apples for each potential boat.
garymcg is offline  
Quote Quick Reply Share with Facebook
post #7 of 7 Old 09-29-2007
Telstar 28
 
sailingdog's Avatar
 
Join Date: Mar 2006
Location: New England
Posts: 43,290
Thanks: 0
Thanked 14 Times in 12 Posts
Rep Power: 14
         
One of the people on this site, Robert Gainer I think, posted a link to a spreadsheet a while back. The spreadsheet had data for a lot of sailboats in it.

EDIT:
BTW, CapnHand recently posted a link to the spreadsheet in question in another thread earlier today. Hmmm... how weird is that. The spreadsheet is located here.

Sailingdog

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Telstar 28
New England

You know what the first rule of sailing is? ...Love. You can learn all the math in the 'verse, but you take
a boat to the sea you don't love, she'll shake you off just as sure as the turning of the worlds. Love keeps
her going when she oughta fall down, tells you she's hurting 'fore she keens. Makes her a home.

—Cpt. Mal Reynolds, Serenity (edited)

If you're new to the Sailnet Forums... please read this
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
.

Still—DON'T READ THAT POST AGAIN.

Last edited by sailingdog; 09-29-2007 at 02:45 AM.
sailingdog 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
help with lifes dream kimby Boat Review and Purchase Forum 37 12-02-2009 11:32 PM
Production blue water boats JakeLevi Boat Review and Purchase Forum 73 07-31-2009 10:07 PM
Different take on the first boat drynoc Boat Review and Purchase Forum 34 04-09-2007 08:44 AM

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