Notices

TSX Owner Sign-In Database

 
Old 02-22-2005, 11:53 AM
  #1  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Thumbs up TSX Owner Sign-In Database

I thought there was a lot of good information in the TSX Owner Sign-In thread so I compiled it into a database to make it easier for members to find pricing in their area.

Soopa is going to work on getting it online but in the meantime I thought I'd share some highlights of the collected data:

Most popular color combo: Carbon Grey Pearl / Ebony (23%)

Most popular transmission choice: AT (60%)

There are exactly the same number of people that have navi as those that don't (93 members each)

Average Pricing
2004 MY
Navi: $27,350.45
Non-Navi: $25,483.91

2005 MY
Navi: $28,085.47
Non-Navi: $26,118.74


So stay tuned for the database....

Edit: Removed cars with dealer-installed options from the averages.
Dan Martin is offline  
Old 02-22-2005, 11:55 AM
  #2  
Registered Member
iTrader: (1)
 
CGTSX2004's Avatar
 
Join Date: Feb 2004
Location: Beach Cities, CA
Posts: 24,300
Received 378 Likes on 198 Posts
Good stuff
CGTSX2004 is offline  
Old 02-22-2005, 11:56 AM
  #3  
dom
Senior Moderator
 
dom's Avatar
 
Join Date: Apr 2003
Location: Toronto, Canada
Age: 42
Posts: 47,711
Received 797 Likes on 659 Posts
Those Navi numbers may be scewed because of We should be able to pull the country info out right?

And another victory for the AT army
dom is offline  
Old 02-22-2005, 11:59 AM
  #4  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
I separated out the Canadian prices so they don't affect the pricing. There really weren't many participants in the thread from Canada but I can still post statistics if we want.
Dan Martin is offline  
Old 02-22-2005, 12:02 PM
  #5  
My Garage
 
GIBSON6594's Avatar
 
Join Date: Nov 2004
Location: NY
Age: 36
Posts: 13,388
Received 11 Likes on 10 Posts
Originally Posted by domn
Those Navi numbers may be scewed because of We should be able to pull the country info out right?

And another victory for the AT army
Less people driving 6MT, is a MT victory. It increases our uniqueness.
GIBSON6594 is offline  
Old 02-22-2005, 12:04 PM
  #6  
Quattro in.....
 
Viking's Avatar
 
Join Date: Jun 2004
Location: NYC
Posts: 3,412
Likes: 0
Received 0 Likes on 0 Posts
Good info!
Viking is offline  
Old 02-22-2005, 12:06 PM
  #7  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Canadian Owners Stats

Most popular colour combo: Premium White Pearl / Ebony (35%) no surprises here...

Most popular transmission choice: AT (57%)

There are no members with Navi in Canada.

Average Pricing
2004 MY
Non-Navi: $33,612.00

2005 MY
Navi: No data
Non-Navi: $35,400.00

Edit: I put the 'U' back in colour where it belongs for us Canucks
Dan Martin is offline  
Old 02-22-2005, 12:25 PM
  #8  
Moderator Alumnus
 
sauceman's Avatar
 
Join Date: Jul 2003
Location: Windsor-Quebec corridor
Age: 42
Posts: 7,709
Likes: 0
Received 5 Likes on 3 Posts
Good stuff Dan,

Funny, I just thinking we should be doing something similar to this yesterday, as I was browsing that thread.

Beat me to it!
sauceman is offline  
Old 02-22-2005, 12:36 PM
  #9  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Originally Posted by sauceman
Good stuff Dan,

Funny, I just thinking we should be doing something similar to this yesterday, as I was browsing that thread.

Beat me to it!
It was a bitch to do it but I thought it would be interesting. Nearly 4 hours of copying and pasting.
Dan Martin is offline  
Old 02-22-2005, 12:37 PM
  #10  
Registered Member
iTrader: (1)
 
CGTSX2004's Avatar
 
Join Date: Feb 2004
Location: Beach Cities, CA
Posts: 24,300
Received 378 Likes on 198 Posts
Damn, Dan, 4 hours? You must not have much to do after you get home from work...
CGTSX2004 is offline  
Old 02-22-2005, 12:39 PM
  #11  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
@ after work

Dan Martin is offline  
Old 02-22-2005, 12:46 PM
  #12  
Moderator Alumnus
 
sauceman's Avatar
 
Join Date: Jul 2003
Location: Windsor-Quebec corridor
Age: 42
Posts: 7,709
Likes: 0
Received 5 Likes on 3 Posts
^^
sauceman is offline  
Old 02-22-2005, 12:58 PM
  #13  
Registered Member
iTrader: (1)
 
CGTSX2004's Avatar
 
Join Date: Feb 2004
Location: Beach Cities, CA
Posts: 24,300
Received 378 Likes on 198 Posts
Originally Posted by Dan Martin
@ after work

Your boss must love the amount of dedication you put into here...
CGTSX2004 is offline  
Old 02-22-2005, 01:00 PM
  #14  
dom
Senior Moderator
 
dom's Avatar
 
Join Date: Apr 2003
Location: Toronto, Canada
Age: 42
Posts: 47,711
Received 797 Likes on 659 Posts
Originally Posted by Dan Martin
@ after work


dom is offline  
Old 02-22-2005, 03:33 PM
  #15  
n00b
 
vwong's Avatar
 
Join Date: Jul 2003
Location: SoCal
Posts: 2,738
Received 45 Likes on 30 Posts
Originally Posted by Dan Martin
Edit: I put the 'U' back in colour where it belongs for us Canucks
Well, you did put the "u" in the word colour, but you mis-spelled your own kind in the title ----> Candian.

:troutslap


vwong is offline  
Old 02-22-2005, 03:35 PM
  #16  
fdl
Senior Moderator
 
fdl's Avatar
 
Join Date: Jul 2003
Location: Toronto
Age: 43
Posts: 21,673
Likes: 0
Received 1 Like on 1 Post
Dan, did you find a way to deal with dealer installed options?
fdl is offline  
Old 02-22-2005, 03:49 PM
  #17  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Originally Posted by fdl
Dan, did you find a way to deal with dealer installed options?
The database lists the installed options beside the price but there's really no way of me breaking them out separately. The best I can do is list all vehicles per state and let the members determine what's the best deal.

In a sense, those averages at the top will be inflated or deflated depending on options chosen. Perhaps I should do a separate average of cars without options...
Dan Martin is offline  
Old 02-22-2005, 03:57 PM
  #18  
dom
Senior Moderator
 
dom's Avatar
 
Join Date: Apr 2003
Location: Toronto, Canada
Age: 42
Posts: 47,711
Received 797 Likes on 659 Posts
Originally Posted by Dan Martin
The database lists the installed options beside the price but there's really no way of me breaking them out separately. The best I can do is list all vehicles per state and let the members determine what's the best deal.

In a sense, those averages at the top will be inflated or deflated depending on options chosen. Perhaps I should do a separate average of cars without options...

See what the boss thinks, I'm sure he'll have some input.

dom is offline  
Old 02-22-2005, 04:03 PM
  #19  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Ok, I updated the first post to only include cars that have no options in the average. Then I thought of one other interesting stat: the average amount spent on dealer installed options

Average spent on dealer installed options:
2004
Navi: $956.27
Non-Navi: $159.84

2005
Navi: $575.43
Non-Navi: $341.26



So what does this mean?

It would appear that people who splurged on Navi also bought more options.
Dan Martin is offline  
Old 02-22-2005, 04:04 PM
  #20  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Originally Posted by domn
See what the boss thinks, I'm sure he'll have some input.

Out of respect for my workplace, I'm not going to analyze the Canadian data until I get home.
Dan Martin is offline  
Old 02-22-2005, 05:37 PM
  #21  
Registered Member
 
Join Date: Sep 2004
Location: Baiting Hollow, NY
Age: 66
Posts: 163
Likes: 0
Received 0 Likes on 0 Posts
Very nice job! Thanks for taking the time to do it.
vger105 is offline  
Old 02-22-2005, 05:39 PM
  #22  
Moderator Alumnus
 
sauceman's Avatar
 
Join Date: Jul 2003
Location: Windsor-Quebec corridor
Age: 42
Posts: 7,709
Likes: 0
Received 5 Likes on 3 Posts
Originally Posted by Dan Martin
Out of respect for my workplace, I'm not going to analyze the Canadian data until I get home.
Bwahahaha.
sauceman is offline  
Old 02-23-2005, 05:07 PM
  #23  
Senior Moderator
 
cM3go's Avatar
 
Join Date: Mar 2003
Location: IL
Posts: 15,238
Received 105 Likes on 71 Posts
this is what you TSX mods do
cM3go is offline  
Old 02-23-2005, 05:47 PM
  #24  
Registered Member
 
Join Date: Mar 2004
Location: nerdlingerton
Age: 39
Posts: 2,242
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by Dan Martin
It would appear that people who splurged on Navi also bought more options.
hmmm, maybe the navi owners are suckers for getting options installed at the dealership and non-navi owners do them for cheaper elsewhere.

but seriously, i wonder if we should've added our oem options and how much we paid for them and how much install cost. that would really help prospective buyers.
sleeper is offline  
Old 02-23-2005, 06:08 PM
  #25  
Registered Member
 
jlukja's Avatar
 
Join Date: Dec 2003
Location: Long Beach, CA
Age: 56
Posts: 20,559
Received 5 Likes on 5 Posts
Good info Dan. Thanks for putting the time in.

Originally Posted by Dan Martin
@ after work

+ 1

I do 95% of my posting from work. If I'm gonna get into trouble with the boss I guess we know which boss I fear more.
jlukja is offline  
Old 02-23-2005, 07:07 PM
  #26  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Glad you've got your priorities straight.
Dan Martin is offline  
Old 02-23-2005, 07:38 PM
  #27  
The Creator
 
Join Date: Apr 2000
Location: Albany, NY
Age: 37
Posts: 37,962
Likes: 0
Received 7 Likes on 3 Posts
Okie...

The database is up and I put this rough interface on it

I'll expand upon this later, allowing you to add/update... and "slickifying" it a good bit.

I've semi-integrated this with the vbb database so I could in theory have this info flush out in your forum profile...

Anyway, it's a beginning. Good work putting all the shit together Dan
soopa is offline  
Old 02-23-2005, 07:46 PM
  #28  
The Creator
 
Join Date: Apr 2000
Location: Albany, NY
Age: 37
Posts: 37,962
Likes: 0
Received 7 Likes on 3 Posts
list is ordered by purchase date BTW. most recent purchase first
soopa is offline  
Old 02-23-2005, 07:55 PM
  #29  
Just dial 1911
 
joerockt's Avatar
 
Join Date: May 2004
Location: San Diego, CA
Age: 44
Posts: 12,145
Likes: 0
Received 1 Like on 1 Post
Originally Posted by soopa
Okie...

The database is up and I put this rough interface on it

I'll expand upon this later, allowing you to add/update... and "slickifying" it a good bit.

I've semi-integrated this with the vbb database so I could in theory have this info flush out in your forum profile...

Anyway, it's a beginning. Good work putting all the shit together Dan
Wow, Feb. 23rd must have been a record sales day for Acura

Take a look at the link soop...

Edit: Woah, just saw that was 2005, today
joerockt is offline  
Old 02-23-2005, 07:57 PM
  #30  
The Creator
 
Join Date: Apr 2000
Location: Albany, NY
Age: 37
Posts: 37,962
Likes: 0
Received 7 Likes on 3 Posts
doh nice catch
soopa is offline  
Old 02-23-2005, 08:00 PM
  #31  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Nice work
Dan Martin is offline  
Old 02-23-2005, 08:03 PM
  #32  
The Creator
 
Join Date: Apr 2000
Location: Albany, NY
Age: 37
Posts: 37,962
Likes: 0
Received 7 Likes on 3 Posts
Originally Posted by soopa
doh nice catch
fix0red kinda
soopa is offline  
Old 02-24-2005, 08:11 AM
  #33  
Registered Member
iTrader: (1)
 
CGTSX2004's Avatar
 
Join Date: Feb 2004
Location: Beach Cities, CA
Posts: 24,300
Received 378 Likes on 198 Posts
Looking good,
CGTSX2004 is offline  
Old 02-24-2005, 08:13 AM
  #34  
dom
Senior Moderator
 
dom's Avatar
 
Join Date: Apr 2003
Location: Toronto, Canada
Age: 42
Posts: 47,711
Received 797 Likes on 659 Posts
So in what format was this exported out of ebullettin in?
dom is offline  
Old 02-24-2005, 08:17 AM
  #35  
Quattro in.....
 
Viking's Avatar
 
Join Date: Jun 2004
Location: NYC
Posts: 3,412
Likes: 0
Received 0 Likes on 0 Posts
Nice work

Edit: noticed answer in post above.
Viking is offline  
Old 02-24-2005, 10:56 AM
  #36  
The Creator
 
Join Date: Apr 2000
Location: Albany, NY
Age: 37
Posts: 37,962
Likes: 0
Received 7 Likes on 3 Posts
Originally Posted by domn
So in what format was this exported out of ebullettin in?
exported in Dan Martin hard-labor file format.

then I just cleaned up his CSV, created a database, and imported his data.

now it is stored in MySQL and full of wonderful whizzy querying potential.
soopa is offline  
Old 02-24-2005, 11:28 AM
  #37  
dom
Senior Moderator
 
dom's Avatar
 
Join Date: Apr 2003
Location: Toronto, Canada
Age: 42
Posts: 47,711
Received 797 Likes on 659 Posts
Originally Posted by soopa
exported in Dan Martin hard-labor file format.

then I just cleaned up his CSV, created a database, and imported his data.

now it is stored in MySQL and full of wonderful whizzy querying potential.

Geez, nice work Dan.
dom is offline  
Old 02-24-2005, 11:33 AM
  #38  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Thanks!
Dan Martin is offline  
Old 02-24-2005, 11:39 AM
  #39  
Go Giants
 
Whiskers's Avatar
 
Join Date: Aug 2004
Location: PA
Age: 47
Posts: 69,229
Received 983 Likes on 667 Posts
Wow, actual useful stuff here...
Whiskers is offline  
Old 02-24-2005, 11:40 AM
  #40  
Photography Nerd
Thread Starter
 
Dan Martin's Avatar
 
Join Date: Sep 2003
Location: Toronto
Age: 39
Posts: 21,489
Likes: 0
Received 9 Likes on 5 Posts
Originally Posted by wsklar
Wow, actual useful stuff here...
Who would have thought...

Dan Martin is offline  

Thread Tools
Search this Thread
Quick Reply: TSX Owner Sign-In Database


Contact Us - Advertising - Cookie Policy - Privacy Statement - Terms of Service

© 2019 MH Sub I, LLC dba Internet Brands

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.