How unique is your Bronco build? Stats from 1600+ Submitted Ordered Builds

[Smheard]

Did a little data sanitization and was curious how many exact copies of my ride would be out there.

Data compiled from the submitted orders list @ Submitted Bronco Orders Tracking List & Stats

UPDATED (2/18/21) 1700+

Obviously the list goes on - but the number of 5 matches and below would make this even more of an eyechart. This is only taking into account our submissions but found it interesting that there would only by 6 others of my truck.

Also this is just from the factory - I'm sure we'll all be doing things that will make our rides our own!

For the Psuedo VIN.
1st Digit: 1 for 21MY 2 for 22MY
2nd: # Doors
3rd: 0-6 Assigned to models
4th: # Cylinders
5th: A/M trans
6th: 0 = No, 1 = Yes
7th: 0,1,2,3 (None, Mid, etc)
8th: A-G (assigned to colors in alphabetic order)
9th: 0,1,2,3,4 (Soft, MIC, MOD, Dual MIC, Dual MOD)

Looks like I’m unique and one of a kind....

1

1466A13E2

2021

4 Door

First Edition

2.7L EcoBoost

10 Speed Automatic

Yes

Lux Package

Cyber Orange

Modular Hard Top, Shadow Painted Black Only

Sponsored

 

[RoLyMa27]

So far only 4 copycats. Oxford White 2 door badlands. 2.3, 7M, No bigfoot, High, MGV, MIC top w/ Rack.

 

[Panzer948]

Wow, mine is the only unique build! It appears the limiting factor was the Modular Hardtop. I am surprised more didn't order that after all the angry posts about the MIC top. Yes I know mine might be late but I have a bunch of other options that make it late too. I figured might as well get all I wanted. Who knows, maybe most of the late options will be available around same time.

 

[L8apex]

wheres the Big Bend ? List doesn't scroll for me

That's because it's not a "list", I've attached the full spreadsheet for scrolling searching but in the post they're just pictures.

 

[Panzer948]

That's because it's not a "list", I've attached the full spreadsheet for scrolling searching but in the post they're just pictures.

BTW, thanks for doing that pivot table. I know its a bit of work in excel to setup! Very handy feature indeed. I like the way you added the selection buttons to the right of the table. Nicer to use than doing the filters at the top (and much more user friendly for those that aren't use to using excel

 

[L8apex]

BTW, thanks for doing that pivot table. I know its a bit of work in excel to setup! Very handy feature indeed. I like the way you added the selection buttons to the right of the table. Nicer to use than doing the filters at the top (and much more user friendly for those that aren't use to using excel

Eh, pivot tables aren't that hard! But the "slicers" are a must!

 

[IfIHMadeA2021Scout]

I feel like I'm standing in a restaurant full of people talking in their groups waiting for their tables when the hostess calls out, "IH, your table's ready. IH, party of ONE........" Then everyone looks around like who is that guy.

What's the matter? No one likes red anymore?

 

[TXRancher]

There appears to be an error in the formula for exact matches.

 

[Thed]

Hey @HorizonHunter

Just who the hell do you think you are stealing my build? And in my own state!?!

I did some more digging... you also reserved with Stephens. Your timestamp is an hour past mine soooooo.....

poser

 

[darkforest888]

Interesting, feeling like my day 2 reservation without any of the 6 deadly selections has a much better chance of being one of the earliest deliveries since the first 20 rows have 2-3 deadly selections. On the other hand, this is an enthusiast forum, probably not representative of the general publics' orders. Thanks for posting this.

 

[radiocontrolhead]

my dealership is a pos and never called me

 

[MyCoke]

There appears to be an error in the formula for exact matches.

Just need to extend the range to include the full sample. The formula for cell M2 should be updated to include through row 1671 =COUNTIF($N$2:$N$1671,N2)-COUNTIF($O$2:$O$1671,O2) and copy down.

 

[DCarter001]

Pretty short list.

How Many Other EXACT Matches?	Psuedo VIN	MY	Doors	Model	Engine	Trans	Squatch	Package	Color	Roof
1​	1244M03B1	2021​	2 Door	Badlands	2.3L EcoBoost	7 Speed Manual	No	Lux Package	Area 51	Molded-in-Color (MIC) Hard Top Only

 

[L8apex]

Just need to extend the range to include the full sample. The formula for cell M2 should be updated to include through row 1671 =COUNTIF($N$2:$N$1671,N2)-COUNTIF($O$2:$O$1671,O2) and copy down.

Whoops! When I updated with the second set of data forgot to update formulas.

 

[SirDapperDom]

To the two other 2021, 4-Dr BL, Shadow Black, SAS, Lux, 2.7, Mod Top reservation holders...you're cool with me!

Sponsored