2022 HD Crowdsourced VIN/Order Tracking

[OfficerDirtySanchez]

uion city cdjr ,union city ,ga

Thanks @Woodywoodpecker

 

[Brutal_HO]

@OfficerDirtySanchez Have you considered adding the Model sales code?

That would indicate platform config and distinguish pickup vs C&C.

 

[OfficerDirtySanchez]

@Brutal_HO that is a good idea. I can intuit some of that from the VIN (e.g. 2500, 3500, DRW, C&C) as I've figured out how to decode them. I might write a script to generate some more of those data points where I have the full VIN.

At this point it'll be pretty hard to go back and enrich the data for existing orders though.

 

[Christofo]

@Brutal_HO that is a good idea. I can intuit some of that from the VIN (e.g. 2500, 3500, DRW, C&C) as I've figured out how to decode them. I might write a script to generate some more of those data points where I have the full VIN.

At this point it'll be pretty hard to go back and enrich the data for existing orders though.

You could parse the VINs into columns pretty easily just using the native formulas. Let me know if you need any help.

 

[Brutal_HO]

No good deed goes unpunished.

 

[OfficerDirtySanchez]

No good deed goes unpunished.

I bet you know something about that. Maybe from giving away your time for free to moderate a forum?

 

[clotagames]

5/18 order date for 2500 Mega Limited 6.7. Dealer just called and has 8/19 ship date. NG103456. ALREADY IN THE SPREADSHEET.

 

[OfficerDirtySanchez]

Congrats! I added your estimated ship date to the sheet.

 

[Motochris]

If you are wanting to add the dealer location, mine is Hunter Dodge (Ram of the West) in Palmdale Ca.

 

[b307a1]

ODS,

my build code is DD8L63

 

[tcuweimer]

@Brutal_HO that is a good idea. I can intuit some of that from the VIN (e.g. 2500, 3500, DRW, C&C) as I've figured out how to decode them. I might write a script to generate some more of those data points where I have the full VIN.

At this point it'll be pretty hard to go back and enrich the data for existing orders though.

If you wanted to add data to my listing, I'm Crew cab 3500 SRW, Limited, HO, Rambox, sunroof, air suspension, ordered through Sandy. I think build code is
D28M91

 

[b307a1]

ODS,
Some updates for you....and you can also add zone 32-New York.

 

[BcMac23]

Showing estimated shipping date of 08/09 as of today

 

[red88rick]

If you wanted more info on mine I’m on the list. It’s a 2500 diesel Laramie LVL2. CCSB Ordered from papas Dodge Ram in CT

 

[BRob]

@OfficerDirtySanchez I’m zone 42-Detroit and my build code is DJ7R91.

 

[OfficerDirtySanchez]

Got all these updates in the sheet. Thanks!

 

[OfficerDirtySanchez]

Ah thanks, @b307a1. I missed that.

 

[Bamabuggy]

Ah thanks, @b307a1. I missed that.

Was just on phone with my dealer. He stated that an estimated ship date of 8/14 just showed today on my order. He also said not to count on it.

 

[Bamabuggy]

Thank you for your efforts on the spreadsheet!

 

[b307a1]

Ah thanks, @b307a1. I missed that.

I can't wait to see the updated pie chart. Looks like the Laramie will have a bigger percentage on the next one.