Color Combo Data for All ZR-1's - ZR-1 Net Registry Forums

QB93Z · 02-04-2010

I have completed a project to gather the color, interior color and roof option data for all ZR-1's. The data was obtained by entering all of the ZR-1 VIN's at a website that gives the RPO codes for any GM VIN. http://www.compnine.com/vid.php?vin=1G1YZ23J0L5802556

Here is a summary of the data:

The complete year-by-year lists for all cars will be posted on the ZR-1 Net Registry Website soon. http://www.zr1netregistry.com/. It may take a little while to get the data formatted and posted.

There are still 16 VIN's that I didn't find data for (16-1990). If anyone has another way to search GM VIN's let me know and I will provide the VIN's of the missing cars. Maybe somebody can stop by the NCM and look at the build sheets.

Since the 1994 and 1995 cars were all researched and listed by Art Wong some time ago, I did not redo that project.

I make no gaurantee that the data is correct. There may be errors. If any errors are found, please let me know so that I can correct the database.

I know that there are a lot of people here that maintain ZR-1 data lists. I will be glad to provide an Excel file of the data to members of the ZR-1 Net Registry. Please contact me at my email address: jim@gizmosart.com.

As a part of this project, I generated a list of the VIN's for all the ZR-1's. I can provide that list also, if you contact me.

Enjoy

Jim

phrogs · 02-04-2010

Thats alot of work!! I think we need to find you a new hobby

QB93Z · 02-04-2010

Quote:

Originally Posted by phrogs

Thats alot of work!! I think we need to find you a new hobby

Well said Johnny!

Now that I am done, I can get back to my real hobby, driving the ZR-1's.

bobbyhi · 02-04-2010

Great job Jim.

Thanks for all of your hard work....

ZZZZZR1 · 02-04-2010

I can personally tell you he put in a ton of man hours on this one...

Way to go Captian!

David

Hammer · 02-04-2010

I have them done by the years for interior and extrior but I was missing a few VIN's for some color combos. I don't know how to post spreadsheets or I would have. Let me know and I can do that. Better yet I'll send mine to Jim.

Here it comes.

gbrtng · 02-04-2010

The number of 91 turqs and other colors looks correct here. The number of cars and the number of cars by color did not agree in much earlier published totals. Thanks for the great job, Jim.

Aurora40 · 02-14-2010

Yeesh man, you manually punched in 6000+ VINs (including calculating the check digit) by hand?? If you try to do something similar again, let me know. I suspect it could have been automated. Good work, though!

QB93Z · 02-14-2010

Quote:

Originally Posted by Aurora40

Yeesh man, you manually punched in 6000+ VINs (including calculating the check digit) by hand?? If you try to do something similar again, let me know. I suspect it could have been automated. Good work, though!

I "automated" the VIN generation and Web search link creation using Excel. But I had to scroll down and read the RPO data manually. Then I had code that would quickly record the results. If you know someone who can code javascript, I would be interested in finding a way to extract the perninent RPO data and record it. Then I could run all the data again to get the other interesting data such as AC control and "export cars".

Also I could double check my data. Another WAZOO member checked my data for the 1992's and found 4 errors. So a validation run would be apppropriate.

Jim

Aurora40 · 02-14-2010

Hey Jim,

I wouldn't do it in javascript, that is a browser-executed language and I don't know it that well (I can figure out what stuff does but am not familiar enough to code up anything). But I get what you are saying.

If you are not in any rush, I'll take a whack at pulling the relevant info out (paint, interior, roof panel, anything else?) and sticking it in a small database. I could then export it to a CSV or something if you prefer excel. I'll mess around with it when I have free time, it might take a while as I'd probably try some things I've wanted to try just for the sake of trying them (I do this for a living, and am always interested in learning some new skills).

02-04-2010	#1
QB93Z Join Date: May 2007 Location: Westminster, Maryland Posts: 3,689	Color Combo Data for All ZR-1's I have completed a project to gather the color, interior color and roof option data for all ZR-1's. The data was obtained by entering all of the ZR-1 VIN's at a website that gives the RPO codes for any GM VIN. http://www.compnine.com/vid.php?vin=1G1YZ23J0L5802556 Here is a summary of the data: The complete year-by-year lists for all cars will be posted on the ZR-1 Net Registry Website soon. http://www.zr1netregistry.com/. It may take a little while to get the data formatted and posted. There are still 16 VIN's that I didn't find data for (16-1990). If anyone has another way to search GM VIN's let me know and I will provide the VIN's of the missing cars. Maybe somebody can stop by the NCM and look at the build sheets. Since the 1994 and 1995 cars were all researched and listed by Art Wong some time ago, I did not redo that project. I make no gaurantee that the data is correct. There may be errors. If any errors are found, please let me know so that I can correct the database. I know that there are a lot of people here that maintain ZR-1 data lists. I will be glad to provide an Excel file of the data to members of the ZR-1 Net Registry. Please contact me at my email address: jim@gizmosart.com. As a part of this project, I generated a list of the VIN's for all the ZR-1's. I can provide that list also, if you contact me. Enjoy Jim __________________ If it isn't fun, you aren't doing it right! 1990 Black ZR-1 - sold 1993 Quasar Blue ZR-1 1994 Competition Yellow ZR-1 1995 Dark Purple ZR-1 Maryland State Coordinator WAZOO Member Last edited by QB93Z; 02-05-2010 at 12:44 PM. Reason: Update with new data for 1991's

02-04-2010	#2
phrogs Join Date: Jul 2004 Location: Kalamazoo MI Posts: 1,753	Re: Color Combo Data for All ZR-1's Thats alot of work!! I think we need to find you a new hobby __________________ JOHNNY P Currently own 90 ZR-1 #845 DRM 500 engine package 90 #226 Parts car Hit me up if you need anything.

02-04-2010	#4
bobbyhi Join Date: Jul 2005 Location: Mendota Heights, MN. 55120 Posts: 984	Re: Color Combo Data for All ZR-1's Great job Jim. Thanks for all of your hard work.... __________________ Bob Anderson 1990 #2405 White/Gray Haibeck chip,4:09 gears,Power Effects Exhaust,5 spoke chrome,C5 brakes,49th Street rockers,K&N,Hurst,Headers,Upper & lower ported Minnesota State Director Founding Member #19

02-04-2010	#5
ZZZZZR1 Banned BANNED Join Date: Oct 2006 Location: MD Posts: 3,690	Re: Color Combo Data for All ZR-1's I can personally tell you he put in a ton of man hours on this one... Way to go Captian! David

02-04-2010	#6
Hammer Join Date: Apr 2006 Location: Ideho Posts: 2,653	Re: Color Combo Data for All ZR-1's I have them done by the years for interior and extrior but I was missing a few VIN's for some color combos. I don't know how to post spreadsheets or I would have. Let me know and I can do that. Better yet I'll send mine to Jim. Here it comes. __________________ [I][FONT=Comic Sans MS]John Boyd[/FONT][/I] [I][FONT=Comic Sans MS][SIZE=1]Ideho[/SIZE][/FONT][/I] [FONT=Comic Sans MS][SIZE=1][I]2015 ZL1 [/I][I]Camaro #1121 BLACK/BLACK 6 SPD (540 RWHP)[/I][/SIZE][/FONT] [I][FONT=Comic Sans MS][SIZE=1]1991 ZR-1 #458 [COLOR=red]RED/[/COLOR][COLOR=black]BLACK 72[/COLOR]k miles ([B][COLOR=red]SOLD[/COLOR][/B]) 1991 ZR-1 #473 [COLOR=red]RED/[/COLOR][COLOR=black]BLACK [/COLOR]37k miles ([B][COLOR=red]SOLD[/COLOR][/B])[/SIZE][/FONT][/I]

02-04-2010	#7
gbrtng Join Date: Feb 2006 Location: San Antonio area Posts: 1,179	Re: Color Combo Data for All ZR-1's The number of 91 turqs and other colors looks correct here. The number of cars and the number of cars by color did not agree in much earlier published totals. Thanks for the great job, Jim. __________________ “Buy the best example of what you want, and pay whatever it takes. That way, you cry only once.” ~ Bruce Meyer

02-14-2010	#8
Aurora40 Join Date: May 2005 Location: Leesburg, VA Posts: 2,713	Re: Color Combo Data for All ZR-1's Yeesh man, you manually punched in 6000+ VINs (including calculating the check digit) by hand?? If you try to do something similar again, let me know. I suspect it could have been automated. Good work, though! __________________ Bob Saveland Former owner of #2517 [IMG]http://a.random-image.net/aurora40/vette.jpg[/img]