No that I am whining but this is what I think of about all the complaints I am getting about painted keys and seatbelt options I am getting today.

For a feature I just added yesterday!

Again all in good fun cause I love this bit and I am not REALLY complaining because I actually like the feedback as well...

but still:

 

You get what you pay for lol

 

Just to reiterate that post was all in good fun.

Please don't take that and decide not to provide feedback when you see errors. I seriously do not mind since I get to correct mistakes before they grow.

As a matter of fact I was able to correct the seatbelt option thanks to Jenner pointing out that it was wrong. Prior to seatbelts I had never tried to display an option with four possible outcomes. Wheels were the most complex with only three.

This is what the formula looks like for wheels on my spreadsheet:

=IFERROR(IFERROR(IF(MATCH(346,$AS7:$CD7,0)>0,346,""),IF(MATCH("XDK",$AS7 :$CD7,0)>0,"XDK","")),"")

And now this is what the formula has to look like for seatbelts to allow for one extra option

=IFERROR(IFERROR(IFERROR(IF(MATCH("XHN",$AS7:$CD7,0)>0,"XHN",""),IF(MATC H("XSH",$AS7:$CD7,0)>0,"XSH","")),IF(MATCH("XSX",$AS7:$CD7,0)>0,"XSX","" )),"")

Trust me, I have too much fun doing this stuff, and it keeps my Excel chops up which is even good for my work!

 

Ok I think I have things basically sorted now. Got the seat belt and key data corrected so now I think there is validity to the new columns.

I think I have everyone entered and assigned to the right car too.

If you see any errors please let me know. Despite my whiny post above.

Also if you have provided me with your VIN somewhere on the board or sent me a PM and I have not responded please let me know. I have tried to respond to everyone and get their cars entered but it is always possible I missed one.

enjoy!

 

Looks great, and mine is corrected. Believe me I wasn't whining; I just know you're on a mission to have this be perfect and were surprised to have missed a car earlier, so I wanted to call out the error. I do love that Louis C.K. clip though, so true!

Question about the Rennlist member thing though: Is that only calling out paid members rather than freeloaders such as myself? If so, fair enough, but if not, Car #309 can be called out as mine.

Those Excel formulas have gotten me geeking out a bit too now, but I don't see anything in that formula that translates the option code to the text, like "Black/Silver/Yellow/Red" for the seat belts. How is that working? I've recently started teaching myself PowerShell since I had some tedious tasks I knew I could automate if I learned it, and that has turned out to be useful in my own job beyond even the initial pains I hoped to and did in fact alleviate.

One recommendation for the Wisdom sheet: I would say that the car will take 7.25 - 8 qts of oil. I only put 7.25 into my car after break-in and the dipstick said the oil was full after driving it around for a bit, and in fact PCNA said that the oil required for change was 7.5 L (8 qts) in the thread I created about this here. The distance from minimum to maximum on the electronic dipstick is 1.8 qts, so there's no harm in only filling 7 qts initially and topping off as necessary, but 7.9 qts as quoted on the Wisdom sheet could cause an overfill, and 8.5 qts almost certainly would. And speaking of the Wisdom sheet, I LOVE the section about the seats!!

Lastly, is that Log sheet intentionally public? Seems personal and contains a fair amount of activity information.

 

Very good observation. So the way it works, and the reason it is laid out as such has to do with the way i get the data from the Porsche site. All I get from the site is a row of option codes. So those end up pasted in a row in my spreadsheet, each option in a different cell.

The problem is that they do not fall in any time of organized fashion. Color option is sometimes the very first on the list, but sometimes it is the 7th, or 5th or whatever. So I have to check the entire row of options for the particular one I am looking for. That is all that formula is doing is taking a random set of option code, and forcing them into a predefined column.

Once that is done, I have another column looking up that value on another table I have that contains all possible options.

So that formula is just a part of the picture.

Does that make any sense? lol.

 

Makes perfect sense, interesting! I also edited my post after you quoted it with a couple more things. Thanks for putting this level of work in!!

 

OK I missed a couple things.

You don't even have to be a rennlist member to have your car included. Just tell me your VIN and you're in. I even have P9 people in there. I will update your car!

As far as the log, I am not too worried. I sometimes hide it but then I unhide it to update and forget about hiding it again. I should probably move it to another google doc. However since the car is for sale at the moment I am leaving it open in case someone wants to see exactly how the car has been treated.

I have been lax on the wisdom page because I don't get much feedback on it. I will take a look at your comments though. I did update based on my own experience changing the oil. And I am pretty sure I did add 7 quarts to start and then topped it off with one more quart to get it perfect.

 

That Louis CK bit was hilarious! And SO TRUE! Great stuff. Thanks for sharing and thanks for all the data!

Now if you could just speed it up a little ...

 

So, to date, what is the rarest combo? Not including PTS, of course.

 

Depends on how many criteria you want to include in the combo. There are several unique builds if you include everything, especially MSRP since that would take into account options not explicitly listed on the spreadsheet, although two builds with identical MSRPs could still of course have different particular options. But if you click the filter button you can create a new temporary filter to play around with various combinations to see what you get.

 

gmaki if you get bored, Leather vs Alcantara steering wheel and shifter might be a cool column to add and then include in the Summary sheet to compare take rates. You know, while you're at it.

 

Correct. As a matter of fact some time ago I checked the entire database for cars that were optioned 100% identical and the fact is almost every car is "one of a kind"

About the only duplicates seem to be dealer orders. There were 5 (or 6) white cars ordered very early which are all identical and I know at least two of them ended up at Auto Gallery and I think Circle in LA.

Bottom line is if you want to check rarity you need to tell me exactly what combination of options you want to check. Some of this can be found on the summary page for the larger option combinations.

Will do! probably next week though. I have a busy weekend ahead of me.

 

Awesome! Also, I just realized the PCM column could be renamed "Stereo" if you wanted to include CDR+ as a possible value there and make the default "No" into just "CDR".

On the uniqueness aspect, I'm surprised how many zero-option cars were built! Just MSRP plus delivery fee. And on the other end of the spectrum there are $120K+ cars, some of them without even PCCB and NONE of them with PTS. They must have upgraded their air vent slats AND fuse box covers.

 

There are 6 base price cars. But only 4 are TRUE zero option cars. Meaning a no cost paint option and 28 interior option and NOTHING else.

The other 2 have extravagances like extended extended fuel tank! lol

One of the true zero options is owned by a Rennlister.