Any Spreadsheets for Comparing Boats ? - SailNet Community

   Search Sailnet:

 forums  store  


Quick Menu
Forums           
Articles          
Galleries        
Boat Reviews  
Classifieds     
Search SailNet 
Boat Search (new)

Shop the
SailNet Store
Anchor Locker
Boatbuilding & Repair
Charts
Clothing
Electrical
Electronics
Engine
Hatches and Portlights
Interior And Galley
Maintenance
Marine Electronics
Navigation
Other Items
Plumbing and Pumps
Rigging
Safety
Sailing Hardware
Trailer & Watersports
Clearance Items

Advertise Here






Go Back   SailNet Community > On Board > Boat Review and Purchase Forum
 Not a Member? 


Reply
 
LinkBack Thread Tools
  #1  
Old 09-28-2007
Deckerd's Avatar
Junior Member
 
Join Date: Sep 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Deckerd is on a distinguished road
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?
Reply With Quote Share with Facebook
  #2  
Old 09-28-2007
camaraderie's Avatar
moderate?
 
Join Date: May 2002
Location: East Coast
Posts: 13,878
Thanks: 0
Thanked 2 Times in 2 Posts
Rep Power: 15
camaraderie is a jewel in the rough camaraderie is a jewel in the rough camaraderie is a jewel in the rough
Nope...no such thing I've ever seen.
Reply With Quote Share with Facebook
  #3  
Old 09-28-2007
Member
 
Join Date: Oct 2004
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 10
42ndstreet is on a distinguished road
my wife doesn't like spreadsheets. She just likes sheets.
what does a spreadsheet look like?
Reply With Quote Share with Facebook
  #4  
Old 09-28-2007
CapnHand's Avatar
humble pie rat
 
Join Date: Nov 2006
Location: Location, Location
Posts: 867
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 8
CapnHand is on a distinguished road
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.
Reply With Quote Share with Facebook
  #5  
Old 09-29-2007
Senior Member
 
Join Date: May 2006
Posts: 825
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 9
chris_gee is on a distinguished road
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.
Reply With Quote Share with Facebook
  #6  
Old 09-29-2007
garymcg's Avatar
Senior Member
 
Join Date: Jun 2006
Location: Ann Arbor, MI
Posts: 110
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 9
garymcg is on a distinguished road
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.
Reply With Quote Share with Facebook
  #7  
Old 09-29-2007
sailingdog's Avatar
Telstar 28
 
Join Date: Mar 2006
Location: New England
Posts: 43,291
Thanks: 0
Thanked 9 Times in 9 Posts
Rep Power: 13
sailingdog is just really nice sailingdog is just really nice sailingdog is just really nice sailingdog is just really nice sailingdog is just really nice
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.
Reply With Quote Share with Facebook
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is On


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


All times are GMT -4. The time now is 03:20 PM.

Add to My Yahoo!         
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.1
(c) Marine.com LLC 2000-2012

The SailNet.com store is owned and operated by a company independent of the SailNet.com forum. You are now leaving the SailNet forum. Click OK to continue or Cancel to return to the SailNet forum.