- May 17, 2008
- 10,010
- 66
- 91
This is just a topic I wanted your various opinions and processes on. I do not plan on buying anything soon, but I like to toy around with the idea and plan for things so I can create a path to save up enough cash for a nice down payment.
I've created an excel spreadsheet with some various math going on inside the cells which when given raw data about vehicles, can tell me which are objectively "best" based on the criteria I have set forth.
For example, I'm looking at mid and full size sedans in the "sporty" segment. I gather data on various comparable cars such as price, TCO, HP, 0-60 time, MPG and cargo capacity. I then give each one of those criteria a weighting, based on what I value most in a car. Then I have some excel magic happen (not worth explaining unless asked for) and it spits out a list of best to worst according to the weighting.
I find it hard to use subjective data like comfort, features, handling and looks. Here is the example below:
I still can't decide if I want to even include 0-60 time. Really what I'm after with that is if two cars have similar HP, I want the one which is "quicker" to get some more points.
How do you all decide how to buy a car when faced with many options?
I've created an excel spreadsheet with some various math going on inside the cells which when given raw data about vehicles, can tell me which are objectively "best" based on the criteria I have set forth.
For example, I'm looking at mid and full size sedans in the "sporty" segment. I gather data on various comparable cars such as price, TCO, HP, 0-60 time, MPG and cargo capacity. I then give each one of those criteria a weighting, based on what I value most in a car. Then I have some excel magic happen (not worth explaining unless asked for) and it spits out a list of best to worst according to the weighting.
I find it hard to use subjective data like comfort, features, handling and looks. Here is the example below:

I still can't decide if I want to even include 0-60 time. Really what I'm after with that is if two cars have similar HP, I want the one which is "quicker" to get some more points.
How do you all decide how to buy a car when faced with many options?