09-15-2014, 10:50 AM
Now that we have >100 entries I started fiddling around with making some charts. I'm pulling them together using pivot tables based off the Raw Data sheet, and then using filters or additional formulas in them to condense it down to the data I want. Point of the story, I'm not very good at this, it's probably done using the worst methods possible, so don't crucify me if you dump a bunch of data in there and break my charts.
We can now say that BMWs are in fact the most popular make in MM, leading the pack at 25.2%, followed by Honda at 12.6%. Mazda is trailing with a wimpy 3.9%. You miata guys better start represetin'
The most popular decade was the 1990s at 47.1%, followed by the 2000s at 28.8%. The oldest car we've owned is a 1954 and the newest is a 2013.
The most popular model category is overrun by BMWs. 325i taking the cake, followed closely by the 318i and then the M3. 4runner and Miata take the remaining spots.
We've sold 71.8% of the cars we've ever bought.
The craziest among us are Channing with 22 total cars owned (Jesus Christ, Channing) followed by Dave with 19 and DJ with 10.
Check it out: https://docs.google.com/spreadsheets/d/1...=657007018
One more thought:
I should have done another column seperate from "Model" for all the trim info, specs, #of pedals, important mods and that crumpled in fender you grew fond of.
For example it's great to capture that we have an LS1 M3 in our midst, but I can't easily roll "M3" "M3 Convertible" and "M3 LS1" into one category to make pretty charts like this. When I have more time I'm going to see if I can add that extra column without breaking all the functions, hopefully I can and turn it into kind of a notes field, and that way we can have consistent "Make" "Model" "Color" formatting and you can still store your fun details in a column i don't have to try and process.
We can now say that BMWs are in fact the most popular make in MM, leading the pack at 25.2%, followed by Honda at 12.6%. Mazda is trailing with a wimpy 3.9%. You miata guys better start represetin'
The most popular decade was the 1990s at 47.1%, followed by the 2000s at 28.8%. The oldest car we've owned is a 1954 and the newest is a 2013.
The most popular model category is overrun by BMWs. 325i taking the cake, followed closely by the 318i and then the M3. 4runner and Miata take the remaining spots.
We've sold 71.8% of the cars we've ever bought.
The craziest among us are Channing with 22 total cars owned (Jesus Christ, Channing) followed by Dave with 19 and DJ with 10.
Check it out: https://docs.google.com/spreadsheets/d/1...=657007018
One more thought:
I should have done another column seperate from "Model" for all the trim info, specs, #of pedals, important mods and that crumpled in fender you grew fond of.
For example it's great to capture that we have an LS1 M3 in our midst, but I can't easily roll "M3" "M3 Convertible" and "M3 LS1" into one category to make pretty charts like this. When I have more time I'm going to see if I can add that extra column without breaking all the functions, hopefully I can and turn it into kind of a notes field, and that way we can have consistent "Make" "Model" "Color" formatting and you can still store your fun details in a column i don't have to try and process.
Now: 07 Porsche Cayman S | 18 VW Tiguan
Then: 18 VW GTI Autobahn | 95 BMW M3 | 15 VW GTI SE | 12 Kia Optima SX | 2009 VW GTI | 00 BMW 540i Sport | 90 Mazda Miata | 94 Yamaha FZR600R | 1993 Suzuki GS500E | 2003 BMW 325i | 95 Saab 900S