Engine, Drivetrain & Forced-Induction Have Technical Questions or Done Modifications to the G35? Find out the answer in here! (View All Posts)

Vehicle Selection Matrix Spreadsheet

Thread Tools
 
Search this Thread
 
Rate Thread
 
  #1  
Old 02-15-2003, 10:46 PM
constjs's Avatar
Registered User
Thread Starter
Join Date: Aug 2002
Posts: 122
Likes: 0
Received 0 Likes on 0 Posts
Vehicle Selection Matrix Spreadsheet

After being asked by many people how I determined the G35 Sedan was right for me, I decided to put this spreadsheet together for them. I thought a few people would also be interested here as well.

I've used this for more than just car purchases, so it's pretty easy to manipulate, edit, and use. Here are some details:

- allows for up to 5 cars to be measured
- all responses are weighted and ranked
- winners in each major area are identified
- final winner is identified by measuring all weighted scores
- you determine the weight to be applied
- you determine the importance level
- just enter in a ranking and watch the results show up

To use this tool just modify the Importance percentage to your needs, modify the Weight for each criteria in each Major Category, enter the car names in the top table (where the major categories are located), and start entering your ranking.

The criterias that were used are subjective and can be changed. Just be sure that formulas don't get screwed up. These just happen to be what I was looking at, and they may not be the same for you.

Give it a try, and if you like it let me know! I've included a pick of what it looks like and a link to download the spreadsheet.

Thanks,

- JC

Download (right-click then Save-As) : <a href="http://constjs.home.insightbb.com/Vehicle_Selection_Matrix.xls">Vehicle Selection Matrix</a>

<img border="0" src="http://constjs.home.insightbb.com/example_matrix.GIF"></img>

 
  #2  
Old 02-16-2003, 01:24 AM
pestilence's Avatar
Registered User
iTrader: (1)
Join Date: Sep 2002
Posts: 2,253
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

hehe nerd.. lol its okay.. so am I.

..pestilence..
 
  #3  
Old 02-18-2003, 08:57 PM
bigel's Avatar
Registered User
Join Date: Dec 2002
Posts: 460
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

Dude... if you knew all the answers about the other cars, didn't it take longer to make the spreadsheet than make up your mind?

 
  #4  
Old 02-18-2003, 10:49 PM
constjs's Avatar
Registered User
Thread Starter
Join Date: Aug 2002
Posts: 122
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

Almost...I've had this for a while. I've used it on other large purchases. I didn't go balistic with this because it is intended to help after you've narrowed your choices down. I liked all the cars, and actually had money down on the Jag X-Type - man I'm glad I never got that car because it's having some major problems!

The hard part for me was that I wanted the G so bad after I drove it for the first time, but the closet dealer to me is three hours away. That's why you don't see too many dealer related criteria items! I figured the trip to the dealer would allow me to enjoy my ride even more!

 
  #5  
Old 02-19-2003, 08:58 AM
KongzGx's Avatar
Registered User
Join Date: Dec 2002
Location: Texas
Posts: 1,606
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

very consultant-like..

'03 G35 Sedan: ivory/aero body/sport/sunroof
Warning: Objects in mirror are FASTER than they appear
 
  #6  
Old 02-19-2003, 08:54 PM
pestilence's Avatar
Registered User
iTrader: (1)
Join Date: Sep 2002
Posts: 2,253
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

haha

I wanted a Jag instead of the G.. but not the X type... it looks too cheap.. and its the "cheap" jag in my opinion.. it kind of reminds me of a ford taurus...

My next car as of now: Jaguar S Type!! these look awesome ... i love the way the front grille looks!!!!

..pestilence..
 
  #7  
Old 02-19-2003, 11:46 PM
constjs's Avatar
Registered User
Thread Starter
Join Date: Aug 2002
Posts: 122
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

I know, the S-Type is beautiful. Of all things, our city has a Jag dealer but no Infiniti! They have a black S-Type R in the showroom as I write this.

They called me on Monday to come out and see it, and some of the dealers there wanted to see the G since there's only 2 in this entire area that I know of. In fact, the last time I saw the other (or any other for that matter) G was back in October, so who knows if it was a local or not.

Anyway, if you like the S-type you'll crap when you see the S-type R - HOLY @#$@#$ is it nice! If I had the cash it would have been mine. Unfortunately I could only have a test drive if I was a serious buyer.

The dealers also liked the G quite a bit as well. We had the G next to the X-Type making comparisons. Nothing negative at all was said by them. In fact they wanted to drive it but it wouldn't have looked too good to see the Jag dealer drive off with a G! It all got broken up when word got up to their main office that people were looking at the G instead of their cars. I was then nicely asked to leave, but was still thanked for taking time to see the Type R and given a cool mug!

 
  #8  
Old 02-20-2003, 01:09 PM
pestilence's Avatar
Registered User
iTrader: (1)
Join Date: Sep 2002
Posts: 2,253
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

where can i find pics of the jaguar s-type R?

..pestilence..
 
  #9  
Old 02-20-2003, 01:11 PM
pestilence's Avatar
Registered User
iTrader: (1)
Join Date: Sep 2002
Posts: 2,253
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

found.. damn!!!!


for around $63,000 ... 390 hp.. 0-60 in 5.3..

..pestilence..
 
  #10  
Old 02-20-2003, 05:59 PM
RamboRami's Avatar
G35driver.com Moderator
Join Date: Nov 2002
Location: Mishigan
Posts: 3,476
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

Yeah, its slow, and plus its a Ford. [img]/w3timages/icons/smile.gif[/img]
E55 blows it away, so does Audi RS6 and M5 bimmer [img]/w3timages/icons/wink.gif[/img] [img]/w3timages/icons/smile.gif[/img]

<font color=blue>-Ramb<font color=red>0</font color=red></font color=blue>
Yeah, Mongolians!
 
  #11  
Old 02-20-2003, 06:03 PM
Tre5's Avatar
Registered User
Join Date: Oct 2002
Location: Pleasanton, CA
Posts: 263
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

Is the cat on top standard or an option??? [img]/w3timages/icons/tongue.gif[/img]

Drive safe, have fun, kick butt when necessary
<font color=green>'03 Emerald Mist</font color=green>
Premium/Sport/Xenon
 
  #12  
Old 02-20-2003, 06:42 PM
pestilence's Avatar
Registered User
iTrader: (1)
Join Date: Sep 2002
Posts: 2,253
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

cat is an option, a naked woman is standard..

..pestilence..
 
  #13  
Old 02-20-2003, 07:05 PM
Tre5's Avatar
Registered User
Join Date: Oct 2002
Location: Pleasanton, CA
Posts: 263
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

Almost makes it worth the 60+ grand!!

Drive safe, have fun, kick butt when necessary
<font color=green>'03 Emerald Mist</font color=green>
Premium/Sport/Xenon
 
  #14  
Old 02-21-2003, 11:33 AM
IQ9's Avatar
IQ9
IQ9 is offline
Registered User
Join Date: Jan 2003
Location: San Jose,CA
Posts: 2,085
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

Have you test driven a S type? The seats are Ford Contour covered in leather. The interior is full of Ford parts bin switchs and *****. The interior is small but the car is too. It looks great but the interior takes it off my list. I had really considered it before my G. The X type was not an option at any price-Ford Contour with a body kit and AWD and no motor to move the heft of the "jagging" process.

03.5 Sedan/B. Silver/Premium/Winter/Aero
69 Chevelle BB/4.11's
 
  #15  
Old 02-21-2003, 01:06 PM
pestilence's Avatar
Registered User
iTrader: (1)
Join Date: Sep 2002
Posts: 2,253
Likes: 0
Received 0 Likes on 0 Posts
Re: Vehicle Selection Matrix Spreadsheet

never been inside a jag.. but i dont like the ford-like interiors..

..pestilence..
 
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
RemmyZero
V36 DIY
10
04-23-2018 11:13 AM
Ninjay16
Audio/Video/Electronics
11
02-26-2018 06:14 PM
g.spot
G35 Cars
12
05-09-2016 10:54 PM
BradMD_96
Engine, Drivetrain & Forced-Induction
7
10-06-2015 09:31 AM
ChickenTendrs
Media Share G35 Coupe V35
7
09-16-2015 01:10 PM



You have already rated this thread Rating: Thread Rating: 0 votes,  average.

Quick Reply: Vehicle Selection Matrix Spreadsheet



All times are GMT -4. The time now is 05:45 AM.