PDA

View Full Version : ZHP production data



SickFinga
02-26-2014, 10:16 AM
Just noticed that you guys opened up forum registration and decided to join and share some of the production data. I'm sure it would be interesting for most of you. I've done similar graphs before(135is, 335is, X5 M), but never done it with so much information in one graph(transmission + market). I'm not really an expert at making spreadsheets, but I hope it is easy to understand. If anyone got any ideas on how to improve the spreadsheet, feel free to chime in.

For now, here is the production data for sedans.


http://i.imgur.com/2dJTqwy.png (http://i.imgur.com/2dJTqwy.png)

http://i.imgur.com/ICdvzEj.png (http://i.imgur.com/ICdvzEj.png)

http://i.imgur.com/QJkyZ3N.png (http://imgur.com/QJkyZ3N.png)

cakM3
02-26-2014, 10:20 AM
Thanks for sharing :thumbsup

I like how you have this set up :)

Simmsled
02-26-2014, 10:52 AM
Thats amazing data right there.

Do you have a database with this info, or just a spreadsheet data dump?

What is the source?

Thanks for sharing!!!

PS Your spreadsheet layout isn't half bad!

slater
02-26-2014, 10:56 AM
that's awesome! thanks for sharing. looking forward to the coupe data!

peter

SickFinga
02-26-2014, 11:12 AM
Thats amazing data right there.

Do you have a database with this info, or just a spreadsheet data dump?

What is the source?

Thanks for sharing!!!

PS Your spreadsheet layout isn't half bad!

I got the data by pulling build sheets for every single 330 from BMW's ASAP website (http://www.bmw.com/com/en/owners/accessories/electronic-parts-catalogue/electronic-parts-catalogue.html). Then I isolated cars with the option S767A and that's pretty much it.

Lanister
02-26-2014, 11:17 AM
Coupe data would be much appreciated :)

ELCID86
02-26-2014, 11:32 AM
Way cool. Thanks. There are a few others here you should collaborate with on the data/analytics. If you have VINs, it would be great (to me) to have the zhpregistry.net updated accordingly.

Simmsled
02-26-2014, 11:32 AM
Got the build sheets...

You must have just gone through 1 by 1. Thats a LOT of work. Mad props.

brettbimmer
02-26-2014, 11:55 AM
Nice work, thank you!

johnrando
02-26-2014, 12:05 PM
Great work. +1 on the coupe (vert) data.

PKR
02-26-2014, 02:21 PM
Fascinating stuff .. thanks!
Ditto the Ci(c).

quikryptonite
02-26-2014, 02:32 PM
Very nice spreadsheet. Thanks for sharing.

So, if I am reading this right, my car is one of only 45 Mystic Blue, Grey Leather, 6MT ZHPs in the United States?

oldzilla
02-26-2014, 02:36 PM
Nice work, +2 on vert/coupe data

E_Rak
02-26-2014, 08:38 PM
Amazing work, thanks for the info :thumbsup

HokieZHP
02-26-2014, 08:47 PM
Dang my old car was one of 26 and only 310 total cars with tan interior.

3ZHPGUY
02-27-2014, 09:49 AM
Great stuff, thank you, thank you, thank you.

Now to add a little detail:

From the Wat-s-your-number thread, I found the earliest ZHP production date of 3-3-03 and the last Sedan listed was 1/14/2005. That amounts to 684 days of production if they worked every holiday and Sunday or approximately 3390 ZHPs annually . Close enough @ 1 year 10 Months and 12 Days. So, I did some simple math and evenly distributed this among dealers across the US and came up with the results by state below.

http://i591.photobucket.com/albums/ss351/3zhpguy/ZHP/ZHPsSoldPerdealersperstate.jpg (http://s591.photobucket.com/user/3zhpguy/media/ZHP/ZHPsSoldPerdealersperstate.jpg.html)

danewilson77
02-27-2014, 11:33 AM
Just noticed that you guys opened up forum registration and decided to join and share some of the production data. I'm sure it would be interesting for most of you. I've done similar graphs before(135is, 335is, X5 M), but never done it with so much information in one graph(transmission + market). I'm not really an expert at making spreadsheets, but I hope it is easy to understand. If anyone got any ideas on how to improve the spreadsheet, feel free to chime in.

For now, here is the production data for sedans.

http://i.imgur.com/2dJTqwy.png

Awaiting coupe/vert data so I can add to our FAQ thread. Really appreciated.


Great stuff, thank you, thank you, thank you.

Now to add a little detail:

From the Wat-s-your-number thread, I found the earliest ZHP production date of 3-3-03 and the last Sedan listed was 1/14/2005. That amounts to 684 days of production if they worked every holiday and Sunday or approximately 3390 ZHPs annually . Close enough @ 1 year 10 Months and 12 Days. So, I did some simple math and evenly distributed this among dealers across the US and came up with the results by state below.

http://i591.photobucket.com/albums/ss351/3zhpguy/ZHP/ZHPsSoldPerdealersperstate.jpg (http://s591.photobucket.com/user/3zhpguy/media/ZHP/ZHPsSoldPerdealersperstate.jpg.html)

Good stuff Guy. So this is just a mathematical estimation correction (no real numbers)?

johnrando
02-27-2014, 11:34 AM
Moar good data. Love it... keep it coming.

SickFinga
02-27-2014, 12:36 PM
First post updated

danewilson77
02-27-2014, 12:40 PM
Thank you Sir.

slater
02-27-2014, 01:00 PM
First post updated

awesome, thanks - my coupe is 1 of 10! wow!

(jet black on black leather '05 coupe 6MT)

peter

johnrando
02-27-2014, 01:07 PM
awesome, thanks - my coupe is 1 of 10! wow!

(jet black on black leather '05 coupe 6MT)

peter

Really? Thought that would be common. EDIT: (oh, I get it, the Canada version). BTW, if these numbers are correct, I literally have the most produced non-Sedan ZHP there is. Black/Black/Vert/AT. Whoda thought? Good thing I've got my customizing (mods).

OP - thanks again for these numbers. Never thought I'd see them. This is awesome.

slater
02-27-2014, 01:12 PM
Really? Thought that would be common. BTW, if these numbers are correct, I literally have the most produced non-Sedan ZHP there is. Black/Black/Vert/AT. Whoda thought? Good thing I've got my customizing (mods).

OP - thanks again for these numbers. Never thought I'd see them. This is awesome.

agreed, totally awesome!

yeah, it looks like black sapphire metallic, and silver, and imola, were the most popular colors by far. only 10 jet black on black leather 6-speeds... yowza!

now i'm not so interested in selling it for a sedan, LOL. :)

peter

johnrando
02-27-2014, 01:23 PM
Yup, I realized its the Canada version. Still, very cool!

ELCID86
02-27-2014, 01:47 PM
So Sickfinga can you provide the vins and other details to zhpregistry so that he has an accurate repository?


Tapatalk on iPad

stephenkirsh
02-27-2014, 02:23 PM
So 14,484 ZHPs made?

3ZHPGUY
02-28-2014, 07:51 AM
just a mathematical estimation correction (no real numbers)?

Yep

johnrando
02-28-2014, 08:36 AM
Yup, but the best estimation I've seen so far.

JFern
02-28-2014, 11:15 AM
This is great info, thanks a lot OP. Is it possible to break out the numbers by model year?


Sent from my iPhone using Tapatalk

gmurphy
03-06-2014, 09:47 AM
Awesome data thank you


Sent from my iPhone using Tapatalk

pilotnick1203
01-03-2015, 08:25 PM
Add one car to the manual, swapping trans :shifty

E_Rak
01-04-2015, 08:10 AM
:like

johnrando
01-06-2015, 10:11 AM
Will be interesting to see how it goes.

CTYankee
03-01-2015, 05:16 PM
Awesome,!

GE Geoff
03-01-2015, 06:14 PM
Wow! Super cool Data! Depsite the relatviely low numbers on some of these combos I guess we're still not special. HA! :rofl