GolfGTIforum.co.uk

Model specific boards => Golf mk7 => Topic started by: Bill_the_Bear on 29 April 2013, 17:52

Title: Spec and Options Popularity
Post by: Bill_the_Bear on 29 April 2013, 17:52
Didn't want to post this in the sticky thread as it clearly says no spam.

This is a quick analysis I did of how popular each choice is based on the posts in the sticky thread as of 18:00 on 29/04.

(http://s14.postimg.org/sfxhbajox/Golf_GTI_Orders.png)
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 29 April 2013, 17:59
And now for the bonus:

(http://s18.postimg.org/oghrb0ae1/Golf_GTI_Orders_2.png)

In case this one isn't clear, its showing the number of people that selected a number of options.  So if you picked Performance Pack, Keyless Entry and 19" Wheels then you would increase the frequency of the "3" column by +1.  In other words cars ordered with 4 or 0 optional extras added are the most frequent, and no one has ordered more than 9 options (so far).

EDIT:
DSG and Paint are not counted as "options" for this, if they were then everything would be bumped up by 2 as you'll always have to pick something here, you can't have no DSG or Manual and you can't have no paint work!  Its only the 14 extras listed in the bar chart on the first post that count.
Title: Re: Spec and Options Popularity
Post by: matchboy on 29 April 2013, 18:33
You have far too much time on your hands  :laugh: :grin:

But I'm glad you do, excellent work, very interesting!!  :nerd:
Title: Re: Spec and Options Popularity
Post by: Sootchucker on 29 April 2013, 19:04
oh my god...is that me in the 9 options category on my own  :huh: :huh: (and the only person to select lane assist ?)
Title: Re: Spec and Options Popularity
Post by: Hawaii-Five-O on 29 April 2013, 20:42
oh my god...is that me in the 9 options category on my own  :huh: :huh: (and the only person to select lane assist ?)

That my friend is a fully loaded car you're buying :shocked:

You'll need the first three months of driving just to work your way through them all. Hehe :laugh:

I don't think anyone else will take your crown.
Title: Re: Spec and Options Popularity
Post by: Champagne on 29 April 2013, 21:12
Love it! The sort of thing I do at work all day...
Interesting to me is the manual preference and the 50:50 3/5 door.
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 29 April 2013, 21:26
Love it! The sort of thing I do at work all day...
Interesting to me is the manual preference and the 50:50 3/5 door.

Yes.  Also Pure White was obviously popular but I had no idea it was the choice of 58%.  Kinda odd which options are most popular.  I would have guessed things like Performance Pack and 19" Alloys would be the most popular, yet Rear Cam and Winter Pack are surprisingly near the top of the list instead.

oh my god...is that me in the 9 options category on my own  :huh: :huh: (and the only person to select lane assist ?)

Yep, that's you out alone there! :tongue: However, you kept clear of some of the pricier options so on a cursory look at the distribution of ticks in the table I used to generate this I suspect you may not be the most expensive... I won't be pricing everyone's up though, that seems a bit too mischievous/nosy.
Title: Re: Spec and Options Popularity
Post by: Ginge 35Edition on 29 April 2013, 21:33
This is ace, interesting split on three and five doors. Good to see lots going for Candy White. My dealer rang me on Saturday to tell me I can get int a mk7 GiT for the same money as what I'm paying now nice Performance Pack, but who knows what's around the corner?!?!
Title: Re: Spec and Options Popularity
Post by: AAddict on 29 April 2013, 21:48
Good to see lots going for Candy White.

Pure White's whiter than Candy White, right?
Title: Re: Spec and Options Popularity
Post by: Jimble on 29 April 2013, 21:54
Good to see lots going for Candy White.

Pure White's whiter than Candy White, right?


I think so, imo candy is ever so slightly creamier (mmm) than pure white.

Title: Re: Spec and Options Popularity
Post by: AAddict on 29 April 2013, 21:57
Good to see lots going for Candy White.

Pure White's whiter than Candy White, right?


I think so, imo candy is ever so slightly creamier (mmm) than pure white.

Yeah I have a Candy MK6 now, it's definitely on the creamy side of white.
Title: Re: Spec and Options Popularity
Post by: mk7gti on 29 April 2013, 22:06
I agree the VW White isn't as white as other manufacturers and its seems to go yellow over time.

Ive had two white Sciroccos and when I was picking up my last one in 2011 it was parked beside my 2008 model and the colour difference was subtle but noticeable. 
Title: Re: Spec and Options Popularity
Post by: Sootchucker on 29 April 2013, 22:23
If you use an acrylic sealant like Werkstatt acrylic Jett, the car doesn't go yellow. Normally it's the carnuba in modern waxes that do this. White cars shouldn't really have wax applied but a sealant instead.
Title: Re: Spec and Options Popularity
Post by: p3asa on 30 April 2013, 10:48
Kinda odd which options are most popular.  I would have guessed things like Performance Pack and 19" Alloys would be the most popular, yet Rear Cam and Winter Pack are surprisingly near the top of the list instead.


Rear cam is a must. Probably most folk that put it on their MK6 put it on as a gimmick as it was cheap but then grew to find it was invaluable. It would be my first option without a doubt.
Title: Re: Spec and Options Popularity
Post by: Jimble on 30 April 2013, 12:18
Kinda odd which options are most popular.  I would have guessed things like Performance Pack and 19" Alloys would be the most popular, yet Rear Cam and Winter Pack are surprisingly near the top of the list instead.


Rear cam is a must. Probably most folk that put it on their MK6 put it on as a gimmick as it was cheap but then grew to find it was invaluable. It would be my first option without a doubt.

This ^ i've got it on my 6 and although i've had it replaced once i wouldn't be without it!  :cool:
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 30 April 2013, 15:54
Just out of interest, what makes it invaluable?

Don't the parking distance sensors do the job?  Also if you have the sat nav I thought the parking sensors would give a visual indication of which ones are registering an obstruction rather than just going off the audio warning?
Title: Re: Spec and Options Popularity
Post by: Gryzor on 30 April 2013, 16:06
Just out of interest, what makes it invaluable?

Don't the parking distance sensors do the job?  Also if you have the sat nav I thought the parking sensors would give a visual indication of which ones are registering an obstruction rather than just going off the audio warning?

For the price it's a no-brainer, and the first thing I ticked.  I've never had it, but my cousin has it, and it's just so convenient to have.  Yes you still get the audio (and I think a display of the sensor activity on the MFD?), but I've had sensors go off for reasons other than obvious obstruction.  Plus, Just lining your car up into a parking space you are reversing into is so much easier as you don't have to twist around and look behind you.

I've added a LOT to my car now, way more than I originally intended to, but it's all stuff that I cannot easily supplement post-build.  Also, with the exception of the Heated Screen and Heated Seats, every other option will get used every single time I drive the car.  For me, it represents everything I want out of a car, and will probably keep this for as long as I possibly can.

Well, that is until the Mk8 comes out with a whole load of new fancy gizmos ;)  :grin:
Title: Re: Spec and Options Popularity
Post by: p3asa on 30 April 2013, 22:13
Just out of interest, what makes it invaluable?

Don't the parking distance sensors do the job?  Also if you have the sat nav I thought the parking sensors would give a visual indication of which ones are registering an obstruction rather than just going off the audio warning?

A graphical display is absolutely no match for a live camera. It makes parking so easy.
Its just one of those options that once you have you will always look for. Plus the cost is fantastic for what it is.
You can park to within half an inch of the car behind.
Why would I do that? Because parking the families cars on the drive is a tight squeeze to get them all in so they need be as close as possible. My present car has the audible warning and the graphics on the display unit but its not a touch on the camera.
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 01 May 2013, 08:37
If you're keeping the car 5 years then the extended warranty (which must be taken up before delivery of the car) looks to be a good deal. About £400 for an extra 2 years peace of mind - probably less than the cost of one major thing going wrong just outside the warranty after a hefty "goodwill gesture" has taken into account.
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 05 May 2013, 13:53
I have to ring the dealer today to ask him to add extended warranty for my Dad's GTD and I am so tempted to ask him to change the colour on mine from Pearl Black to Tornado red after seeing a Peal black Passat CC covered in swirls all over and lots of light laquer scratches around the door handles. Does the Tornado red suffer from major colour mismatch on the bumpers (looking a few shades darker than the bodywork) like the Scirocco's "Salsa" red?
Title: Re: Spec and Options Popularity
Post by: mcmaddy on 05 May 2013, 16:20
Change it to white haha with the black paint all the trim pieces look lost. Looks much better in white although I am tempted to change to red after seeing every man and his dog on here ordering white  :grin:
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 05 May 2013, 16:33
mcmaddy: Will have to ring Mick on Tues (he's usually off on a Mon after doing the weekend run - not sure if that changes on a bank holiday weekend). Still undecided about Black > Red. I really like Red, and the Passat CC I saw probably goes through a car wash rather than being hand washed. I know what you're saying about the grille details etc getting lost in the black paint. If it doesn't cause Mick any grief to change it (it's only week 20 next week isn't it?) I think I might - I have a whole day to mull it over and maybe spot another Red and Black Golf/Passat in the meantime.
Title: Re: Spec and Options Popularity
Post by: mcmaddy on 05 May 2013, 16:42
Red or white would be better than the black but that's just me though. I'm seriously toying with the red idea too but you'll see less paint damage on white than you will on any other colour. it's still there but not as noticeable.
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 05 May 2013, 17:07
Red is the classic colour,  but the detailing is in red.  Surely black is better than red if you want the details to be visible.  White is best I think even though more than half of us have picked it.  Of all the mk6 cars around the white ones look twice as good as the others.
Title: Re: Spec and Options Popularity
Post by: Gryzor on 05 May 2013, 17:15
Totally agree Bear, a red GTI seems lose the whole point with all of the accents being red.  Black does look nice (when clean), but white is just perfect for it.  If I were getting a GTD then I'd seriously consider red because of the silver/grey accents.

To be honest, over half of my cars have been white.  Just something about the colour suiting the style of car that I go for (not all white cars look good).  Really glad I didn't throw a grand into the Oryx white though.  A couple of cars near me have got pearl white paint, and from a distance it looks OK, but closer up it shimmers too much and has a bit of a feminine look about it.  Personal taste though.
Title: Re: Spec and Options Popularity
Post by: mcmaddy on 05 May 2013, 18:24
Overall white is the better colour on the gtd and gti, then red. black loses the detail of the front vents and the trim around windows/doors etc.
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 05 May 2013, 18:40
Gryzor: I think you sold Red on me - I am getting a GTD. I did have a MK5 Golf GT in Black Pearl and it looked great, but the GT didn't have any stand-out "performance" features that were lost in the colour. My next car, a Golf GT Sport did, as it had the black gloss nose/grille bit liek a GTI, and it was in Tornado Red. It looked great, for about 2 weeks until a bus hit it with all of 405 miles on the clock. Benfield VW did such a poor job of repairing it that I resented it until I got shot of it for my first Roc in Pewter Grey (great looking shade of grey - it has that slight pruple hue about it).

Red it is, unless my dealer says it is too late to change (doubtful). Black is a poor choice on the Roc, it really hides the curves of the car, especially at the back.
Title: Re: Spec and Options Popularity
Post by: mcmaddy on 05 May 2013, 18:47
Changing the colour shouldn't be a problem. Mick said we had right up until 27th
Title: Re: Spec and Options Popularity
Post by: Gryzor on 05 May 2013, 20:18
Gryzor: I think you sold Red on me - I am getting a GTD. I did have a MK5 Golf GT in Black Pearl and it looked great, but the GT didn't have any stand-out "performance" features that were lost in the colour. My next car, a Golf GT Sport did, as it had the black gloss nose/grille bit liek a GTI, and it was in Tornado Red. It looked great, for about 2 weeks until a bus hit it with all of 405 miles on the clock. Benfield VW did such a poor job of repairing it that I resented it until I got shot of it for my first Roc in Pewter Grey (great looking shade of grey - it has that slight pruple hue about it).

Red it is, unless my dealer says it is too late to change (doubtful). Black is a poor choice on the Roc, it really hides the curves of the car, especially at the back.

Glad to be of service  :tongue:  Good choice though, and changing it shouldn't be a problem at all.  Make sure you mention the potential re-pricing and that you obviously don't want that to happen.  Head office can override it.
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 06 May 2013, 09:18
Gryzor: No repricing issues there, the base car price didn't go up and I didn't add any options except the black Pearl paint that i'd be losing, so £500 saved. Nowshould I be really sensible and order the 5 year guarantee and actually keep this one for 5 years as it's unlikely to change in spec significantly in that time? I do seem to hanker for a change every 2 years or so, but only because of something better being out there. When I got my 140TDI Roc I was so sick of my poorly repaired Golf GT Sport 170TDI that I jumped in without waiting for the 170 Roc to be released. After doing that I missed the 170 output i'd had with the Golf and wanted the 170 Roc (which I now have). Would I be wanting a change if there were no better options out there? I'm not sure i'd buy another identical GTD just to have a newer one, but a new Roc on the MQB platform with accedd to the GTD engine and as many toys as standard could tempt me if wor lass was driving the sensible option car (something 5 doors - she wants an A1 when we get her back into driving lessons).
Title: Re: Spec and Options Popularity
Post by: Gryzor on 06 May 2013, 09:29
Sounds good monkeyhanger, although I do tend to just start ignoring what's out there for the very reasons you change!  There are always new toys and gadgets coming out, but the spec of my current GTI ticks every single box.  My current Mk5 GTI lasted me all this time from 2005, and I'm hoping for the same longevity from my Mk7.
Title: Re: Spec and Options Popularity
Post by: AAddict on 06 May 2013, 09:43
Gryzor: No repricing issues there, the base car price didn't go up and I didn't add any options except the black Pearl paint that i'd be losing, so £500 saved. Nowshould I be really sensible and order the 5 year guarantee and actually keep this one for 5 years as it's unlikely to change in spec significantly in that time? I do seem to hanker for a change every 2 years or so, but only because of something better being out there. When I got my 140TDI Roc I was so sick of my poorly repaired Golf GT Sport 170TDI that I jumped in without waiting for the 170 Roc to be released. After doing that I missed the 170 output i'd had with the Golf and wanted the 170 Roc (which I now have). Would I be wanting a change if there were no better options out there? I'm not sure i'd buy another identical GTD just to have a newer one, but a new Roc on the MQB platform with accedd to the GTD engine and as many toys as standard could tempt me if wor lass was driving the sensible option car (something 5 doors - she wants an A1 when we get her back into driving lessons).

I think the GTD is more future proof for people with upgrade-itis as on the petrol front there will be an R and 40 edition. Unless they have a Golf D R in the pipeline.
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 06 May 2013, 09:45
Gryzor: TBH i'm nowhere near bored of my Roc yet. But the GTD with more power, better economy, better residuals and loads of standard kit, as well as being easier for my elderly great aunty to get into and out of without the danger of her breaking her hip are the reasons for my current change (actually a near miss with the aunty and my lass moaning about 3 door access when she has to sit in the back are the biggest reasons).

Changing at 3 years does have its advantages - VW dealers are more interested in a 3 year old p/x that they can sell rather than a 5 year old p/x that they'll have to ship off to the auctions, getting shot of the p/x for a decent value can be a real hassle on an older car, but maybe selling privately is more lucrative if you're willing to put in the work and maybe the hassle of being without a car for a few weeks.
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 06 May 2013, 09:47
Golf D R would tread on the GTIs toes a bit I think if they slapped a bi-turbo unit in with 215-225PS, I doubt it would happen.
Title: Re: Spec and Options Popularity
Post by: Gryzor on 06 May 2013, 10:01
I hear ya' monkeyhanger, and I can totally appreciate the 3 door debate!  Never again, only as a second car that was solely for myself! lol. Changing every 3 years is OK if you are prepared to keep saving up to cover the depreciation, but I plan on paying it off in 3 years as it has been nice having no debt aside from my mortgage!
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 06 May 2013, 19:01
Gryzor: I should do the same and keep a hold of this one, with 5 year warranty. I'll be redundant in either Oct 2014 or June 2015, depending upon which phase I go (want to go as soon as possible, the place is slowly dying around me), walking away with £50k in the hand lumper and hopefully straight into a comparable job soon after. I plan on paying off the car with my lumper and then chucking £400 a month off the mortgage in overpayment (when working again), in lieu of what car repayments usually cost me. If I bank what's left of the lumper then next time I get a car i'll be able to buy it outright without copping for any interest.  :laugh:

Leaning towards the 5 year warranty now. The warranty should be a canny incentive to sell privately if I do get rid after 3 years, it is fully transferable to the next owner, given a £17.50 admin fee.

Had a look at Benfield Scotswood Road to compare a Tornado Red Golf with a Pearl Black one. They had a PB MK7 GT in and a TR MK6 35th edition GTI. Looking at teh 2, the GTD details would be lost on the PB and they look so dull when they're not immaculately clean (which the demo wasn't). Pleased to see that the body and bumpers were the same shade of red on the GTI, unlike the huge shade variance you can see on a Salsa Red Scirocco (my colleague has one and it is very noticeable).

Tornado Red for definite.
Title: Re: Spec and Options Popularity
Post by: Gryzor on 06 May 2013, 19:04
Sounds like a good plan monkeyhanger.  If you can get a car you like and settle with it, it's by far the cheapest way of motoring.  I would be very surprised if after 5 years your annual repairs bill (not including routine maintenance) exceeded the depreciation levels on a new car!
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 06 May 2013, 19:38
I do sometimes wonder whether VW reliability has declined over the years partially to encourage you to keep buying new ones under warranty. If they make a car you want to stick with then they won't be making as much money. Makes you wonder what extra stuff they'll be hoying at future MY's to entice you to trade in.
Title: Re: Spec and Options Popularity
Post by: Gryzor on 06 May 2013, 19:45
Aye, unfortunately these days lots of things have built-in limited life-spans.  I used to go swapping anything and everything just because I could, but lately I've got bored of playing to the tune of the manufacturers.
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 13 May 2013, 16:08
I'll update this properly when I get the chance with new graphs and sh!t.  However, in the meantime:

I went through the sticky again seeking out updated posts with order numbers, dealer info and estimated build weeks to see what can be learned.

Short Story:
Not much.  We don't have enough data to make conclusions and even where we do have data it is debatable how useful it is.  For example, if one dealer estimates BW 23 and another BW 35 are they both accurate or is one grossly underestimating and the other just playing it really safe?  :undecided:

It seems clear to me that estimated BW do not tally much with what we would expect.

Longer Story:
Ok fine, lets have a go anyways!

So, its quite interesting to look at MonkeyHanger vs others as his order is early on with no options.  MH has an estimated BW of 23 on a stock GTD.  I have to assume GTI and GTD are the same really as to seperate means we have virtually no helpful data at all.

MH vs Jimble - Addition of DSG, PP and ACC pushes order back to BW35
MH vs Gung-Ho - Addition of DSG, PP and ACC pushes order back to BW27
MH vs Matchboy - Addition of PP pushes order back to BW27

All the above are on orders placed at end of March/early April.  Order # are 2317 or 2318
Hmm...

Jimble vs Bear - Similar spec, Bear orders Leather and a month later, same estimated BW!  2317 vs 2322.
MH vs Hawaii-5-0 - Similar spec, H50 grabs DSG pushes order back to BW27
MH vs MH2 - Similar spec, MH2 grabs DSG no effect on BW

Hmm...

Lets look a specific options instead:

Colour: Not enough info, no exotic colours ordered and posted BW or order # info.
Order Date: Impossible to analyse without more dealer info, e.g. more data points and order X/X at dealer.
DSG: No apparent effect on BW (but possibly MH dealer underestimates effect)
PP: No apparent effect on BW (but possibly NickNotts dealer underestimates effect)
ACC: No apparent effect on BW (but possibly NickNotts dealer underestimates effect)
Sunroof: Bumps BW to 35 (Jimble and Bear are only BW35 and only sunroof orders)

Sample size is 10  :sick:

Any questions/requests?

EDIT:
If I was smart/better at coding then I would write a small program to data mine the VW order system by pluging in each order number starting with 2317xxxx up to 2325xxxx and grabbing the dealer, GTI/D, PP, Transmission, doors and colour data to go with that order number.  That should give us full coverage of the entire country (assuming website works for all order #) but without the full list of options.  When BW start being posted (in 2-3 weeks time I assume) we could get some really good data.

So, any of you chaps any good at this kind of thing?  I know it can be quite easily done as websites like SC2ranks constantly trawl other websites to amass their data.  All it has to do is request "http://www.volkswagen.co.uk/owners/track-my-order/doingPaperwork?orderNumber=23xxxxxx" and then record a few pieces of info in a csv file.  I'm guessing this is half hour job for someone who knows what they are doing.
Title: Re: Spec and Options Popularity
Post by: Sootchucker on 13 May 2013, 16:30
Bloody hell Bill, you got nothing to do  :grin: :grin: :grin:
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 13 May 2013, 16:44
Bloody hell Bill, you got nothing to do  :grin: :grin: :grin:

Shush, keep it quiet would you.  And don't tell my boss!  :grin:

Now then.  I pulled the source code from my order tracker result.  Lines 811 to 839 are the ones we want.  Here they are:
Quote
                        <h3 class="sIFR-ignore title">Your car details</h3>
                        <div class="vw-box list-details">
                            <div class="item">
                                <h4 class="label">Your car:</h4>
                                <p class="description">New Golf GTI Performance 2.0 TSI 230 PS 6-speed DSG 5 Door</p>
                            </div>
                            <div class="item">
                                <h4 class="label">Colour:</h4>
                                <p class="description">Pure White</p>
                            </div>
                            <div class="item">
                                <h4 class="label">Upholstery:</h4>
                                <p class="description">Titan Black</p>
                            </div>
                        </div>
                        <div class="contact-details" data-retailer-id="00317">
                                <h4>Listers Nuneaton</h4>
                                <p>phone:<br><span>02476 321 400</span></p>
                                <p>email:<br>
                                        <a href="mailto:vw.nuneaton@listers.co.uk">vw.nuneaton@listers.co.uk</a>
                                </p>
                        </div>

Now I'm pretty sure I can code something to automatically access my page and find and save this data (cleaning out all the html tags of course).  Presumably its a simple matter to then create a For x = 2317xxxx to 2318xxxx loop to then grab everything.  Just need something to filter out null results.

I think this might actually be dooable.  I might test it out on something like a 10 number range because I'm guessing if I run it on 10,000 numbers VW might get suspicious and adjust the order form to stop anyone accessing everyone else's orders!  And we don't want that to happen. :evil:
Title: Re: Spec and Options Popularity
Post by: matchboy on 13 May 2013, 16:51
Is your name really Neo?!  :shocked:
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 13 May 2013, 16:53
Is your name really Neo?!  :shocked:

No :sad: this is actually terribly basic stuff.  I'm a total noob.
Title: Re: Spec and Options Popularity
Post by: matchboy on 13 May 2013, 16:57
Is your name really Neo?!  :shocked:

No :sad: this is actually terribly basic stuff.  I'm a total noob.

Looks like rocket science to me!  :shocked:
Title: Re: Spec and Options Popularity
Post by: matchboy on 13 May 2013, 17:02
Also, in English, what does that all mean?! Cause it sounds interesting!
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 13 May 2013, 17:18
Also, in English, what does that all mean?! Cause it sounds interesting!

I just used a ~15 line subroutine in BASIC to access the VW site and retrieve the phone number of my dealer.

Principle proved I think.

Next steps:
- Access car info data instead
- Insert into a loop that sequentially accesses each order number
- Apply some annoying stuff like waits to allow the website to respond, filters to ignore non GTD/GTI orders and error handling for cases where the order number returns an error
- Generate a .csv file with the output paired with the order number used

:evil:
This might totally work.

In English:

A list of every 23xxxxxx order number in the country associated with a GTI or GTD together with the colour, dealer, transmission, doors and if it has the PP.  And HOPEFULLY come week 22 the confirmed BW as well.  Now that would give us a sample big enough to properly analyse.

I think I have a new pet project.  Might all fall flat on its face mind you, as I said I'm a total noob.
Title: Re: Spec and Options Popularity
Post by: Gryzor on 13 May 2013, 17:24
I think I have a new pet project.  Might all fall flat on its face mind you, as I said I'm a total noob.

We need to use the word "noob" in context here!  I'm by no means an IT noob, done systems design and business analysis for years, but this ain't no trivial stuff that bloggs joey can knock up!  :grin:

Good work though Bear!
Title: Re: Spec and Options Popularity
Post by: matchboy on 13 May 2013, 17:24
Sounds like an excellent project to me! I await the results with baited breath, will be very interesting to see the data summarised.
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 13 May 2013, 17:29
I'm doing it in excel using the in built visual basic editor (cause I'm too lazy to break out the C++) so when its working (maybe tonight if the wife lets me play) I can probably upload it so you can plug your own number in and see the output.

I'll keep the "grab everything" version private for now.  If a dozen people start bombarding the VW website with hundreds of requests they're gonna get irritated and probably block us all from accessing it at the very least so lets not do that! :tongue:

I'm sure there are many people on here who are actual professionals and can do this better than me so feel free to jump in and take over if you are.
Title: Re: Spec and Options Popularity
Post by: Gung-Ho on 13 May 2013, 18:08
Nice work 'Bear' but I'm really struggling to keep up with you... You wouldn't be related to Gary McKinnon by any chance? :grin:

You're obviously a computer genius... Any chance of manipulating our build dates to come forward on the system?  :grin:
Title: Re: Spec and Options Popularity
Post by: matchboy on 13 May 2013, 18:14
I'm a professional and I have no idea what you are talking about - but I like it! I look forward to the upload!!
Title: Re: Spec and Options Popularity
Post by: Sootchucker on 13 May 2013, 19:14
Are you hacking VW then  :grin:

It'll me the MOD or the CIA next  :laugh: :laugh:
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 13 May 2013, 19:31
Are you hacking VW then  :grin:

It'll me the MOD or the CIA next  :laugh: :laugh:

I think hacking would require that they actually have some kind of security to hack... which they do not.  :tongue:

Don't tell them, this is good for us.
Title: Re: Spec and Options Popularity
Post by: matchboy on 13 May 2013, 19:59
Are you hacking VW then  :grin:

It'll me the MOD or the CIA next  :laugh: :laugh:

I think hacking would require that they actually have some kind of security to hack... which they do not.  :tongue:

Don't tell them, this is good for us.

What are you doing on here?! Get to it!!  :laugh:
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 13 May 2013, 21:39
What are you doing on here?! Get to it!!  :laugh:

Ok chaps, I've really no idea if this will work.  There are some disclaimers:

Download this.  Open and allow it to run if it asks if you want to trust it.  Should be self explanatory.  Works for any Golf order I think.

https://docs.google.com/file/d/0B9-CTALYHX1eQkJVaU1YX1BHM1E/edit?usp=sharing

The idea is that when they post build weeks I can modify it to grab the confirmed build week for you too.
Then, I should be able to make it sequentially try each order number in a specified range and every time it finds a GTI or GTD order stuff the details in a file which I can then post here.
Title: Re: Spec and Options Popularity
Post by: matchboy on 14 May 2013, 09:02
Ok, so I tried this and it worked!  Very clever!  But what do we do now?!
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 14 May 2013, 10:21
Ok, so I tried this and it worked!  Very clever!  But what do we do now?!

Ok well now I've got to make it so that instead of just grabbing the details for the one number you know (your number) it runs automatically for a range of numbers.  So for example it might start at 23000000 and then do 23000001 until and keep going for how ever long I set it.

Each time it finds a result that includes "GTI" or "GTD" it will then have to write that down in the spreadsheet on a new line.  Might look like this:

230000001 None
230000002 None
230000003 GTI Performance, 5dr, Pure White, DSG, DealerName
230000004 None
230000005 GTD, 3dr, Tornado Red, Manual, DealerName

etc...

I need a little time to do it.  Also, I need to find an order where it has a confirmed build week (could be a Tiguan or anything) so I can see the format they use, then I can grab this too.  End result is we have order numbers and confirmed BW together with some basic description of the cars for every order we can find.  That should give a better picture on when things are due/what causes delays.

Maybe.
Title: Re: Spec and Options Popularity
Post by: CraigW on 14 May 2013, 10:23
Ok, so I tried this and it worked!  Very clever!  But what do we do now?!

Ok well now I've got to make it so that instead of just grabbing the details for the one number you know (your number) it runs automatically for a range of numbers.  So for example it might start at 23000000 and then do 23000001 until and keep going for how ever long I set it.

Each time it finds a result that includes "GTI" or "GTD" it will then have to write that down in the spreadsheet on a new line.  Might look like this:

230000001 None
230000002 None
230000003 GTI Performance, 5dr, Pure White, DSG, DealerName
230000004 None
230000005 GTD, 3dr, Tornado Red, Manual, DealerName

etc...

I need a little time to do it.  Also, I need to find an order where it has a confirmed build week (could be a Tiguan or anything) so I can see the format they use, then I can grab this too.  End result is we have order numbers and confirmed BW together with some basic description of the cars for every order we can find.  That should give a better picture on when things are due/what causes delays.

Maybe.

Bill, are you a member of MENSA? If not, i'm going to nominate you  :smiley:
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 14 May 2013, 10:57
Has anyone seen any anomalies between the official VW order confirmation form (that your dealer may have posted to you or emailed you a PDF) and what the tracker says?

My Dad's vanilla GTD 5 door DSG in Tornado Red order has had no amendments (we asked the dealer to add on 5 year warranty as he will keep it a fair while, but that is it). The order confirmation clearly states all of the above, yet the order tracker states that his order number relates to a Pearl Black 5DR DSG GTD. My dad had initially shown interest in this colour but decided to save £500 and get Tornado Red at point of order. I'm going to ask whether he wants me to tell the dealer or whether he would be prepared to chance getting a Pearl black one. Obviously it would be VWs cock up (seeing as the dealer submitted order is correct) so neither dealership nor my dad would be obliged to pay for it.

I do wonder whether this anomaly has occurred due to me originally ordering Pearl black and having the exact same name as him, maybe an order mix-up has happened at VW's end?

Incidentally my order change from DBP to tornado red is not shown on the tracker findings for my order.
Title: Re: Spec and Options Popularity
Post by: matchboy on 14 May 2013, 11:02
I'd check it with VW if I were you, sounds like a c0ck up to me - you would hope that the order tracker shows the colour you've ordered!

Bear, you are some kind of genius and I am loving your work!  I'm guessing we now wait until build weeks are confirmed in w22 and then you're good to go?!
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 14 May 2013, 11:23
Ok, well I found an order with "Build Week Confirmed" however, it doesn't say what the BW is.  :cry:

It does say that BW confirmed typically happens about 4 weeks before the car is built.  So, at the moment we can't pin it down precisely.  I suppose running the program once a week might show which cars have moved from order processing into build week confirmed and thus give us an idea of how fast they are building them and what orders move through without delay.
Title: Re: Spec and Options Popularity
Post by: GolfTi on 14 May 2013, 11:33
Sounds a bit like sneaking a look at the Christmas presents when I was a kid.....

Mine is still on wk 25, it'll be here this Summer some time. Fine by me.
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 14 May 2013, 11:45
I'd check it with VW if I were you, sounds like a c0ck up to me - you would hope that the order tracker shows the colour you've ordered!

We have to ask ourselves whether we'd take DBP for free over Tornado Red. If both of our orders turn up with DBP then neither would be obliged to pay for it - my dad never ordered that colour and I changed mine from that colour with the dealer. With mine I suspect that maybe the tracker hasn't been updated (maybe it will change when week 22 has passed). I think my Dad has a better chance of getting DBP than me die to his seemingly a genuine cock-up by VW. If he's happy with the possibility of DBP for free then we'll say nowt and see what happens.
Title: Re: Spec and Options Popularity
Post by: mcmaddy on 14 May 2013, 12:49
I would ring Mick and double check. What if its not even the same car??
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 14 May 2013, 13:31
mcmaddy: The tracker spec for my dad's order states that it is a 5dr DSG GTD, just the colour is wrong, and it is a colour my dad was keen on apart from the £500 cost. The dealership is right, everything else is right on the order. If my dad would welcome free DBP paint I think we'd just not mention it. VWs cock-up and Mick won't be liable for it.
Title: Re: Spec and Options Popularity
Post by: mcmaddy on 14 May 2013, 13:35
I agree but if your dad wanted a black car then he would have stuck with it. He's gone for red. I would still ring Mick even though it isnt his fault. I would be rejecting mine if it wasnt the colour id ordered.
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 14 May 2013, 13:40
mcmaddy: My dad was giving the black some thought, I think the price was putting him off - he liked it but did he like it £500 more than he liked the red? I'll tell him the situation and see whether he wants to chance the possibility of a black one (for no extra) or stick with the red.

In a situation where my car turned up in the wrong colour, it would depend on the colour. If it turned up white I could live with it, but wouldn't be paying for the paint charge, likewise for black, possibly carbon grey. Any other colour and I would reject.
Title: Re: Spec and Options Popularity
Post by: mcmaddy on 14 May 2013, 13:46
I've ordered White and I want white  :grin: :grin: :grin:
Title: Re: Spec and Options Popularity
Post by: Gryzor on 14 May 2013, 13:56
I've ordered White and I want white  :grin: :grin: :grin:

Yeah, if my Pure White turned up DPB I'd be annoyed to say the least!  They'd have to order a new car for me or give me a HUGE incentive to keep it!
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 14 May 2013, 17:38
Ok dudes, I've made it work on a loop, so I can grab every GTI or GTD order in any range of order number I specify.  However, it seems like the website sometimes takes forever to respond risking a crash of my program.  Need to overcome this.

Perhaps some method to timeout after 5 seconds and come back to that number later?  I've no idea how to do this though... yet! :evil:

Thinking about it, I have a suspicion that the delays occur when it finds an order number that is valid (i.e. has a car associated with it) but that car is not a GTI or GTD...
Title: Re: Spec and Options Popularity
Post by: matchboy on 14 May 2013, 17:57
I'm looking forward to the summary charts of the results! Tonight?!
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 14 May 2013, 17:59
Unfortunately not tonight.

I gotta figure out this delay problem.  I just ran it on 50 order numbers and about 20 results pop out in 1 second then I'm staring at an egg timer for about 2mins for the next result.  I have to brain storm this problem.

Also, since there are no confirmed BWs yet its a little pointless running it right now anyway!
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 14 May 2013, 18:02
That was odd.  I got bored waiting and tried to cancel it and suddenly the other 30 results popped up.  Hmm.

Also, any of you lot ordered a Limestone Grey GTD from "Phillips" dealers?  It was the one GTI/GTD hit I scored on the 50 numbers I picked to test it on! :evil: I suppose it might be the dealer placed an order for a demo and this is it.
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 14:01
I actually found a better way to do this using Firefox instead of excel so I can access multiple links at the same time and an error just means you miss one number instead of having to start all over because it crashed excel.

One drawback... I need 50 Euros for a program whose functions I need to use.  Hmm, to be or not to be? :undecided:
Title: Re: Spec and Options Popularity
Post by: Gryzor on 15 May 2013, 14:03
I actually found a better way to do this using Firefox instead of excel so I can access multiple links at the same time and an error just means you miss one number instead of having to start all over because it crashed excel.

One drawback... I need 50 Euros for a program whose functions I need to use.  Hmm, to be or not to be? :undecided:

What program Bear?  I might have it  :whistle:
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 14:04
I actually found a better way to do this using Firefox instead of excel so I can access multiple links at the same time and an error just means you miss one number instead of having to start all over because it crashed excel.

One drawback... I need 50 Euros for a program whose functions I need to use.  Hmm, to be or not to be? :undecided:

What program Bear?  I might have it  :whistle:

Its pretty obscure, I never heard of it before.  "OutWit Hub".
Title: Re: Spec and Options Popularity
Post by: Gryzor on 15 May 2013, 14:19
Its pretty obscure, I never heard of it before.  "OutWit Hub".

At this point I shall bow out gracefully! :nerd:
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 15:08
I've scanned about 400 order numbers using the limited functionality I can access for free.  Interestingly there are large number ranges with no orders actually associated with them (i.e. they return "sorry we don't recognise that number").  I can think of a few reasons why this might be but it does complicate matters.  Out of the 400 numbers I've checked there are 22 active orders, of which 11 are Golfs, only one of these is a GTI or GTD (my own). :sad:

EDIT:
I spoke too soon.  Just hit on 3 GTD orders in close succession.  Possibly demos for a dealer?
Title: Re: Spec and Options Popularity
Post by: Gryzor on 15 May 2013, 15:17
My order number still isn't recognised in the online tracker so not sure what's going on.  Like I've said previously though, not too fussed - you can weigh a pig all you like but it won't get any fatter!  It'll be here when it's here, and not knowing is almost better as there are no expectations to be shattered!  :grin:
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 15:30
Found another GTD and my first GTI.  Seems like I'm getting somewhere.

How much is 50 euros in our British pounds then? :nerd:
Title: Re: Spec and Options Popularity
Post by: Gryzor on 15 May 2013, 16:07
Found another GTD and my first GTI.  Seems like I'm getting somewhere.

How much is 50 euros in our British pounds then? :nerd:

Good work!  It looks to me like the order total was near 60 euros, so that'll be around 51 of our squids.  Rather a lot just to know something that you cannot change the outcome of, but hey, if you have use beyond it, might be worth it.  Maybe folk on here would be willing to donate?! ;)
Title: Re: Spec and Options Popularity
Post by: Sootchucker on 15 May 2013, 16:11
How much is 50 euros in our British pounds then? :nerd:

Against today's Ex rate of 1.1774 that will be £42.47
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 16:14
Well at present I can see no way of getting the BW information from the website automatically.

So, for £50 ish I can set up a system that will find all the UK GTI and GTD order numbers and bung them in a list.  I could then check them all manually once a week or something, assuming we're talking about at most a few hundreds, and make a note when each one gets a confirmed build week.

I dunno, £50 plus that many orders to check... I can think of better things to do with the time and money, yet this wait is unbearable. :grin:

In other news I modified my script to pull the info regardless of what kind of car it finds, so at least I now know which are VWs most popular models in the UK (Its the Up!, Passat and Golf if anyone is interested).
Title: Re: Spec and Options Popularity
Post by: ROO1 on 15 May 2013, 16:24
Well at present I can see no way of getting the BW information from the website automatically.

So, for £50 ish I can set up a system that will find all the UK GTI and GTD order numbers and bung them in a list.  I could then check them all manually once a week or something, assuming we're talking about at most a few hundreds, and make a note when each one gets a confirmed build week.

I dunno, £50 plus that many orders to check... I can think of better things to do with the time and money, yet this wait is unbearable. :grin:

In other news I modified my script to pull the info regardless of what kind of car it finds, so at least I now know which are VWs most popular models in the UK (Its the Up!, Passat and Golf if anyone is interested).

Fab
Title: Re: Spec and Options Popularity
Post by: Gryzor on 15 May 2013, 16:32
I can see the fun in doing what you have, for the interest of it and to pass the time while you wait!  Blimey, I've messed around with spreadsheets and macros for hours, but I personally don't see £50 worth of value here.  Certainly not when it gives you nothing more than what your dealer can give you with a weekly phone call.
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 16:43
I can see the fun in doing what you have, for the interest of it and to pass the time while you wait!  Blimey, I've messed around with spreadsheets and macros for hours, but I personally don't see £50 worth of value here.  Certainly not when it gives you nothing more than what your dealer can give you with a weekly phone call.

Oh no, it gives you much more than that.  You can compare the everyone's order numbers to their BW (when it is confirmed 4 weeks prior to the build) and also to some basic options including GTI/GTD, doors, colour, transmission, performance pack and dealer (i.e. what place in the dealers allocation it occupies).

This allows some predictions to be made along the lines of which options are causing longer lead times, when orders are likely to be processed based on the order number and dealer allocation, if cars are being built in batches, GTI first? etc etc.... Might even be able to predict which dealers have yet to use their allocations and therefore could let people jump the queue.

Could also tell you other (non GTI specific) things.  For example, Deep Black Pearlescent is a highly popular colour choice across the total VW range (and a thousand other facts like this).

I'm not convinced its worth the effort still.
Title: Re: Spec and Options Popularity
Post by: Gryzor on 15 May 2013, 16:51
It's all really interesting stuff, but unless you are going to actually do something with the information that you have beyond your own curiosity (i.e. take requests from people) I'm still not convinced either!
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 17:02
Deep Black Pearl is by far the most popular colour ordered in May.

(http://s2.postimg.org/mamzr4gdl/Colour_Popularity.png)



Warrington has placed a lot of orders in May.

(http://s10.postimg.org/egg6w3dy1/Dealer_Activity.png)
Title: Re: Spec and Options Popularity
Post by: matchboy on 15 May 2013, 17:10
That is excellent Bear. Although why is my dealer not on the chart?!
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 17:27
That is excellent Bear. Although why is my dealer not on the chart?!

Firstly, I started using my own order number which was last week of April, so I'm assuming these are May orders.  My assumption may be wrong, perhaps dealers are assigned number blocks and use them later on.

Secondly, the script I use is not perfect.  Sometimes it "fails" which I think is basically a time out on the website, like if you put your number in manually and it sits on "loading" forever.  So around 8% of the numbers I tried got missed like this.  This is compounded by the fact that I can only run 100 numbers at once so after a few errors the late 90s on that list of 100 don't get a look in.  I don't mind much because I'm interested in averages mainly.

Thirdly, I've only run around 1000 numbers.  I've no idea how many go in per month, but I'm getting a response rate of around 10%.  That means for every 10 numbers tried 1 of them returns an actual order in progress.  So we're looking at around 100 data points here.

So, I wouldn't be worried if your dealer is missing.  If I spent the 50 smackers I could improve this a lot and probably just run it overnight grabbing tens of thousands of order numbers... but there are two drawbacks.  1) They might block me if I'm hogging 99% of the traffic to their site (but I doubt they would notice if I take some basic precautions) and 2) It costs me 50 quids.

 :grin: :grin: :grin:
Title: Re: Spec and Options Popularity
Post by: matchboy on 15 May 2013, 17:33
My order went through mid April, maybe that's why its not on there??

Good work though!
Title: Re: Spec and Options Popularity
Post by: Gung-Ho on 15 May 2013, 17:41
What I find surprising is how popular Deep Black Pearl is in the VW range? I've hardly come across any black VW's of late so maybe its coming back into fashion??

I did consider ordering a black pearl GTi this time round just as a change to my normal white, but the problem with keeping it clean & the dreaded swirl marks put me off once again. Do like the colour though
Title: Re: Spec and Options Popularity
Post by: Bill_the_Bear on 15 May 2013, 17:45
What I find surprising is how popular Deep Black Pearl is in the VW range? I've hardly come across any black VW's of late so maybe its coming back into fashion??

I did consider ordering a black pearl GTi this time round just as a change to my normal white, but the problem with keeping it clean & the dreaded swirl marks put me off once again. Do like the colour though

Your post just reminded me, some of us on here said the tracker was incorrectly showing DBP when they choose Tornado Red.  I think it was monkeyhanger and his pops.  Perhaps its bugged to show this when there is some kind of error or uncertainty?  That would artificially bump it up.

If we ignore DBP then white is popular, and the various greys and blues could be grouped together I suppose.  VW don't give you much choice really since like 75% of the options are some variation on grey or blue.  Or at least the ones people order apparently are!
Title: Re: Spec and Options Popularity
Post by: monkeyhanger on 15 May 2013, 20:16
Bill: Yep, me and my dad, although mine is correct on the assumption the tracker has not updated (I originally ordered DBP, but then rang the dealer to change it), although my dad's seems to be a true error, as on the "order confirmation form" Tornado red as ordered is there, but the tracker clearly states DBP. Could be the main reason for the apparent popularity of the colour if it's a glitch.