SailNet Community

SailNet Community (http://www.sailnet.com/forums/)
-   Boat Review and Purchase Forum (http://www.sailnet.com/forums/boat-review-purchase-forum/)
-   -   Any Spreadsheets for Comparing Boats ? (http://www.sailnet.com/forums/boat-review-purchase-forum/37235-any-spreadsheets-comparing-boats.html)

Deckerd 09-28-2007 08:00 PM

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?

camaraderie 09-28-2007 09:44 PM

Nope...no such thing I've ever seen.

42ndstreet 09-28-2007 10:24 PM

my wife doesn't like spreadsheets. She just likes sheets.
what does a spreadsheet look like?

CapnHand 09-28-2007 11:51 PM

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.

chris_gee 09-29-2007 12:57 AM

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.

garymcg 09-29-2007 12:58 AM

Quote:

Originally Posted by CapnHand (Post 199516)
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.

sailingdog 09-29-2007 02:41 AM

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.


All times are GMT -4. The time now is 09:18 AM.

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