GT4 Database
Thread Starter
Burning Brakes
Joined: Mar 2015
Posts: 1,123
Likes: 6
From: Stevenson Ranch, CA
So kind of a big update today.
I have added the FULL build of every single car in the database. This is information I have been holding onto for awhile and just didn't know how best to present it. Well for whatever reason today I just thought "Eff it, I'll just barf it all out across the spreadsheet and clean it up later"
And that is largely what I have done.
I left some of the basic summarized specs like color, Major Leather options, brakes etc... in the first few columns, then notes. Then literally every single option after that.
Doing this also broke some of the graphs, but I intend to revamp those anyway.
So there ya have it. Crunch away! now you guys know everything I know about what options have been ordered.
I have added the FULL build of every single car in the database. This is information I have been holding onto for awhile and just didn't know how best to present it. Well for whatever reason today I just thought "Eff it, I'll just barf it all out across the spreadsheet and clean it up later"
And that is largely what I have done.
I left some of the basic summarized specs like color, Major Leather options, brakes etc... in the first few columns, then notes. Then literally every single option after that.
Doing this also broke some of the graphs, but I intend to revamp those anyway.
So there ya have it. Crunch away! now you guys know everything I know about what options have been ordered.
Pro
Joined: Jun 2009
Posts: 610
Likes: 114
From: North East
So kind of a big update today.
I have added the FULL build of every single car in the database. This is information I have been holding onto for awhile and just didn't know how best to present it. Well for whatever reason today I just thought "Eff it, I'll just barf it all out across the spreadsheet and clean it up later"
And that is largely what I have done.
I left some of the basic summarized specs like color, Major Leather options, brakes etc... in the first few columns, then notes. Then literally every single option after that.
Doing this also broke some of the graphs, but I intend to revamp those anyway.
So there ya have it. Crunch away! now you guys know everything I know about what options have been ordered.
I have added the FULL build of every single car in the database. This is information I have been holding onto for awhile and just didn't know how best to present it. Well for whatever reason today I just thought "Eff it, I'll just barf it all out across the spreadsheet and clean it up later"
And that is largely what I have done.
I left some of the basic summarized specs like color, Major Leather options, brakes etc... in the first few columns, then notes. Then literally every single option after that.
Doing this also broke some of the graphs, but I intend to revamp those anyway.
So there ya have it. Crunch away! now you guys know everything I know about what options have been ordered.
Rennlist Member
Joined: Nov 2011
Posts: 489
Likes: 0
From: Toronto
Thread Starter
Burning Brakes
Joined: Mar 2015
Posts: 1,123
Likes: 6
From: Stevenson Ranch, CA
The first thing that makes it possible is to understand the VIN's are sequential. That seems simple enough, but due to check digit, and the fact that Porsche skipped the sequence at one point it was a little more complicated than you might expect.
Up until just recently I had been using an online calculator to provide me the the checksum digit. The crappy part about that was I had to enter each VIN one by one into the tool and then get the correct VIN, with the correct checksum, and then check that against the Porsche database. I had been entering about 20 at a time that way and then just "discovering" more as needed.
However recently I stumbled upon the math to calculate the checksum, and it was a piece of cake. So I wrote an Excel formula and calculated every VIN from here out to 191999. so that part is all done!
The second part of the equation is there is an online tool, intended for use by dealers in the US and Canada that will return the full build of each car if you enter the VIN.
BigKraig wrote a little tool that will crawl that database if you provide it with a list of VIN's and so he is actually responsible for the initial huge data ingest that created the database.
However now that I am up to date with production, I just check for new ones manually and then enter them one by one when I find them.
yeah so that is how I do it. and boy let me tell you is it fun! lol. Well it was a lot of fun when I was waiting for my GT4. Now I pretty much do it because I want to see it completed, and I know the new people ordering their cars are just as interested in seeing the data as I was.
Rennlist Member
Joined: Nov 2011
Posts: 489
Likes: 0
From: Toronto
I have answered before, but I am sure it is buried deep within this thread. Not to mention I keep changing how I do it.
The first thing that makes it possible is to understand the VIN's are sequential. That seems simple enough, but due to check digit, and the fact that Porsche skipped the sequence at one point it was a little more complicated than you might expect.
Up until just recently I had been using an online calculator to provide me the the checksum digit. The crappy part about that was I had to enter each VIN one by one into the tool and then get the correct VIN, with the correct checksum, and then check that against the Porsche database. I had been entering about 20 at a time that way and then just "discovering" more as needed.
However recently I stumbled upon the math to calculate the checksum, and it was a piece of cake. So I wrote an Excel formula and calculated every VIN from here out to 191999. so that part is all done!
The second part of the equation is there is an online tool, intended for use by dealers in the US and Canada that will return the full build of each car if you enter the VIN.
BigKraig wrote a little tool that will crawl that database if you provide it with a list of VIN's and so he is actually responsible for the initial huge data ingest that created the database.
However now that I am up to date with production, I just check for new ones manually and then enter them one by one when I find them.
yeah so that is how I do it. and boy let me tell you is it fun! lol. Well it was a lot of fun when I was waiting for my GT4. Now I pretty much do it because I want to see it completed, and I know the new people ordering their cars are just as interested in seeing the data as I was.
The first thing that makes it possible is to understand the VIN's are sequential. That seems simple enough, but due to check digit, and the fact that Porsche skipped the sequence at one point it was a little more complicated than you might expect.
Up until just recently I had been using an online calculator to provide me the the checksum digit. The crappy part about that was I had to enter each VIN one by one into the tool and then get the correct VIN, with the correct checksum, and then check that against the Porsche database. I had been entering about 20 at a time that way and then just "discovering" more as needed.
However recently I stumbled upon the math to calculate the checksum, and it was a piece of cake. So I wrote an Excel formula and calculated every VIN from here out to 191999. so that part is all done!
The second part of the equation is there is an online tool, intended for use by dealers in the US and Canada that will return the full build of each car if you enter the VIN.
BigKraig wrote a little tool that will crawl that database if you provide it with a list of VIN's and so he is actually responsible for the initial huge data ingest that created the database.
However now that I am up to date with production, I just check for new ones manually and then enter them one by one when I find them.
yeah so that is how I do it. and boy let me tell you is it fun! lol. Well it was a lot of fun when I was waiting for my GT4. Now I pretty much do it because I want to see it completed, and I know the new people ordering their cars are just as interested in seeing the data as I was.
Rennlist Stories
The Best Porsche Posts for Porsche Enthusiasts
Talos Takes Your 991 Porsche 911 GT3 to the Next Level for a Cool $1.13 Million
Verdad Gallardo
9 Vehicles Porsche Helped Engineer that Aren't Porsches
Verdad Gallardo
9 Features and Characteristics That Only Porsche People Understand
Verdad Gallardo
I've Written 500 Rennlist Articles: Here's How Porsche Has Changed Along the Way
Joe Kucinski
10 Most Unnecessary Porsches Ever Built (And Why We Love Them)
Verdad Gallardo
Porsche 911 GT3 S/C vs 718 Spyder RS: 10 Categories, One Winner
Joe Kucinski
This Builder Is Turning Heads With Its Slantnose 911 Creation
Verdad Gallardo
Porsche 911 GT3 Artisan Edition Pays Homage to Japanese Culture
Verdad Gallardo
Porsche Reveals Coupe Variant of the Electric Cayenne With a Fresh Look
Verdad Gallardo
Drifting
Joined: Aug 2005
Posts: 2,432
Likes: 127
From: New York, NY
Thank you so much for creating this and keeping it going gmaki.
I always remember the kick I got when I found my build in your database based on color and MSRP before the dealer had sent me any info.
I always remember the kick I got when I found my build in your database based on color and MSRP before the dealer had sent me any info.
Thread Starter
Burning Brakes
Joined: Mar 2015
Posts: 1,123
Likes: 6
From: Stevenson Ranch, CA
Thanks and yeah it is still fun. Not to mention I am keeping my Excel and now Google sheets chops up to speed. I get to do so little difficult work anymore in Excel that I actively seek out little challenges like this. I have put to use what I have learned here at work already a couple of different times.
It is not quite perfect yet but I added a bit of a fun look at the data on the "Options" tab. So if you have any interest in this kind of stuff go ahead and take a look. What I have done is started to track the split of certain options over time. I used the VIN sequence in roughly lots of 100 to denote "time" since build months were too inconsistent with the totals.
An example of an interesting little tidbit is that over the last 400 or so builds, Sapphire Blue Metallic has actually been the most popular color while White has dropped to #2. I did have a sense of that but it is interesting to see it proven out. My theory is that SBM looks so good in the flesh as soon as people started seeing them delivered it skewed the orders going forward.
It is not quite perfect yet but I added a bit of a fun look at the data on the "Options" tab. So if you have any interest in this kind of stuff go ahead and take a look. What I have done is started to track the split of certain options over time. I used the VIN sequence in roughly lots of 100 to denote "time" since build months were too inconsistent with the totals.
An example of an interesting little tidbit is that over the last 400 or so builds, Sapphire Blue Metallic has actually been the most popular color while White has dropped to #2. I did have a sense of that but it is interesting to see it proven out. My theory is that SBM looks so good in the flesh as soon as people started seeing them delivered it skewed the orders going forward.
Racer
Joined: Nov 2004
Posts: 306
Likes: 1
From: Merritt Island, Fl
This is outstanding work and coming from a background with some of the limited production air-cooled cars I see it as even far more useful as we go thru the years. We will have a "complete" database of the numbers built and their configurations. No longer will there be competing claims and uncertainties. In other words, it's your duty to keep this up and scratch known losses off the list as the years go by.... Lucky guy :-)
Thread Starter
Burning Brakes
Joined: Mar 2015
Posts: 1,123
Likes: 6
From: Stevenson Ranch, CA
This is outstanding work and coming from a background with some of the limited production air-cooled cars I see it as even far more useful as we go thru the years. We will have a "complete" database of the numbers built and their configurations. No longer will there be competing claims and uncertainties. In other words, it's your duty to keep this up and scratch known losses off the list as the years go by.... Lucky guy :-)