Amazing work to put this spreadsheet together.. Thank you!!
I would love to know how many cars fit the following criteria:
- exterior color: red, black, or white
- interior color: black or tan
- manual trans
- mileage: under 20,000 miles
- year: 2002-2005 (if you can list by year, that would be great)
- stock / no modifications
For now our database isn't sophisticated enough to answer your question with this many details. According to what we know today I tell tell you that:
According to Autocheck, January 2012 and all the information i acquired from Ebay, cars.com, autotrader and Prime:
There are 86 manual cars from 2002 with under 20k miles
There are 64 manual cars from 2003 with under 20k miles
There are 101 manual cars from 2004 with under 20k miles
There are 148 manual cars from 2005 with under 20k miles
This adds up to 399 cars from 2002-2005, this number includes all cars ( totalled, exported, modified to point of no return and etc).
Colors you want, production numbers:
Red/Black: 15 from 02 + 7 from 03 + 12 from 04 + 20 from 05 = 54
Red/Tan: 15 from 02 + 15 from 03 + 20 from 04 + 22 from 05 = 72
Black/Black: 20 from 02 + 18 from 03 + 18 from 04 + 43 from 05 = 99
Black/Tan: 7 from 02 + 4 from 03 + 4 from 04 + 12 from 05 = 27
White/Black: 3 from 02 + 0 from 03 + 1 from 04 + 4 from 05 = 8
White/Tan: 3 from 02 + 1 from 03 + 1 from 04 + 1 from 05 = 6
This adds up to 266, I can't give you an exact number but I would say that less than 100 from the bunch are going to be nice, stock, unmodified, accident free and under 20 000 miles
I hope this helps, Paul.