Ask Ratbert

[Ratbert]

At any rate, to me, a big part of the value of this representation is how it changes over time, so running that same view (using the now updated algorithm, assuming it doesn't change again) will show how much progress they're making on burning down the backlog of unbuilt orders in the older months.

Ideally it won't change, but invariably I'll discover a weird window sticker pdf format that I didn't expect. That's what sent me down the path of trying to more fully understand Canadian orders and parsing their French forms. That eventually made me realize that attempting to get an accurate representation of anything but domestic orders was futile.

Sponsored

 

[Ratbert]

I can't remember the exact details, but I thought Ratbert said he had to exclude some of the data because it was flagged for export or something like that.

Also, Ratbert, didn't you say something about running 2021 data and finding out that a certain % of sequence numbers were never built? Do you remember what that percentage was? I wonder if that will be roughly the same for MY 2022 builds.

Finally, since you have to assume everyone looking at these threads have custom builds, is there any information in the build sheets or window stickers that would give us an idea of what % of being built is custom rides compare to the total population?

Thanks as always @Ratbert!

You're right. Now that I'm focusing on domestic orders it's screwing up these big picture views of the data. I'll need to figure out an approach to deal with that.

I built a database of a subset of 2020 orders using my newer extraction algorithms, but I haven't had a chance to do any analysis of it yet. In theory that will give a decent idea of what percentages represent "done" for both domestic and international builds.

 

[Ratbert]

Finally, since you have to assume everyone looking at these threads have custom builds, is there any information in the build sheets or window stickers that would give us an idea of what % of being built is custom rides compare to the total population?
@Ratbert!

There's a "sold order" line item. I'll look up the stats on that tomorrow. Ideally I'll be able to put the analysis side of my code up on a website so anyone can do queries like this themselves. That will take a while though. Hopefully ads will pay for the cost of it all.

 

[Powelligator]

I'm also trying to figure out what to call the delta been build sheets and window stickers. I'm thinking that "being built" might best describe it.

Build Sheet -> Assembly Process ->Additional Mopar Options (Yes | No) if Yes -> Body Vendor -> Inspection -> Shipping -> Window Sticker, if No -> Inspection -> Shipping -> Window Sticker

 

[Ratbert]

Build Sheet -> Assembly Process ->Additional Mopar Options (Yes | No) if Yes -> Body Vendor -> Inspection -> Shipping -> Window Sticker, if No -> Inspection -> Shipping -> Window Sticker

Understood. Now compress it into a small number of words for a column heading that somewhat accurately represents that process. I've come up with:

• Being built
• In progress
• In the works

 

[JohnSarge]

Understood. Now compress it into a small number of words for a column heading that somewhat accurately represents that process. I've come up with:

• Being built
• In progress
• In the works

in progress and in the works are the same to me EDIT n/m i get it now

 

[Ratbert]

At any rate, to me, a big part of the value of this representation is how it changes over time, so running that same view (using the now updated algorithm, assuming it doesn't change again) will show how much progress they're making on burning down the backlog of unbuilt orders in the older months.

Once I have the controller returning that data in JSON I should be able to graph it across time.

 

[Ratbert]

Thank you so much!! Slowly but surely they’re getting built. You should start your own tracking page and charge for membership... I’d rather get my info from you than JC any day!

Unfortunately mine won't be able to tell you anything until you have a build sheet and won't be able to give you an estimated ship date or anything like that. The data that they have access to isn't publicly available.

 

[bjm00se]

There's a "sold order" line item. I'll look up the stats on that tomorrow. Ideally I'll be able to put the analysis side of my code up on a website so anyone can do queries like this themselves. That will take a while though. Hopefully ads will pay for the cost of it all.

Ads tend to work for sites with higher volume. If you just want to defray hosting & network costs, you could set up a patreon account. I'd toss a few bucks your way, and I expect others on this thread would as well.

 

[bjm00se]

• Being built
• In progress
• In the works

"In the capable hands of the Minions"

"Being Conjured"

"From Zero to One Hundred (percent)"

"In the Workshop"

and my personal favorite:

"Still In Integration Testing"

 

[Polar Bear 37885]

Is it possible to see how many do not have factory ac?

 

[Shanwowsd]

Ads tend to work for sites with higher volume. If you just want to defray hosting & network costs, you could set up a patreon account. I'd toss a few bucks your way, and I expect others on this thread would as well.

I would donate to the cause!

 

[kj11]

I've included both Altitude and High Altitude packages:

Instances of Altitude Package over time:

day	build sheets	window stickers	backlog
2022-03-16	1,753​	unknown​	​
2022-03-17	3,060​	unknown​	​
2022-03-18	647​	unknown​	​
2022-03-19	0​	3,559​	1,901​
2022-03-20	62​	33​	1,930​
2022-03-21	102​	29​	2,003​
2022-03-22	90​	83​	2,010​
2022-03-23	168​	3​	2,175​
2022-03-24	8​	0​	2,183​
2022-03-25	75​	0​	2,258​
2022-03-26	0​	91​	2,167​
2022-03-27	1​	251​	1,917​
2022-03-28	105​	75​	1,947​
2022-03-29	83​	67​	1,963​
2022-03-30	64​	33​	1,994​
2022-03-31	21​	26​	1,989​
2022-04-01	82​	59​	2,012​
2022-04-02	1​	10​	2,003​
2022-04-03	0​	7​	1,996​
2022-04-04	81​	23​	2,054​
2022-04-05	138​	3​	2,189​
2022-04-06	131​	26​	2,294​
2022-04-07	102​	56​	2,340​
2022-04-08	78​	85​	2,333​
2022-04-10	104​	228​	2,209​
2022-04-11	2​	4​	2,207​
2022-04-12	37​	95​	2,149​
2022-04-13	38​	12​	2,175​
2022-04-14	104​	119​	2,160​

Instances of High Altitude Package over time:

day	build sheets	window stickers	backlog
2022-03-16	597​	unknown​	​
2022-03-17	1,342​	unknown​	​
2022-03-18	157​	unknown​	​
2022-03-19	0​	1,925​	171​
2022-03-20	34​	27​	178​
2022-03-21	29​	24​	183​
2022-03-22	14​	13​	184​
2022-03-23	41​	0​	225​
2022-03-24	2​	0​	227​
2022-03-25	35​	0​	262​
2022-03-26	0​	45​	217​
2022-03-27	2​	102​	117​
2022-03-28	26​	34​	109​
2022-03-29	28​	24​	113​
2022-03-30	36​	13​	136​
2022-03-31	10​	6​	140​
2022-04-01	37​	33​	144​
2022-04-02	0​	10​	134​
2022-04-03	0​	9​	125​
2022-04-04	59​	40​	144​
2022-04-05	19​	6​	157​
2022-04-06	21​	13​	165​
2022-04-07	18​	17​	166​
2022-04-08	33​	17​	182​
2022-04-10	54​	158​	78​
2022-04-11	6​	6​	78​
2022-04-12	13​	33​	58​
2022-04-13	18​	14​	62​
2022-04-14	36​	64​	34​

I just ordered a Sport Altitude yesterday... Guess I'm in for a long wait

 

[Oskaloosa Mailman]

@Ratbert Hmmmm. There's an anomaly here I can't figure out. The "% w/Build Sheets" of Oct, Nov, Dec orders with build sheets (also window stickers) appears to have gone *down* between the 4/11 query and the 4/20 query. I don't see how this could be possible. They don't "unbuild" Jeeps.





I was kinda assuming you were building a database of build-sheets and stickers that had previously been found, and then you re-ran the query each day against the VINS that hadn't yet been located.

If you're feeding all the VINS as query parameters each time, the output's going to be much more subject to timeouts and transient data errors where sheets that exist simply can't be located by a system that's probably not all that reliable to begin with?

At any rate - I'm impressed with the effort! There's a lot of code and admin effort here you've slung by evenings-and-weekends for-the-hell-of-it coding.

I feel like they may have "unbuilt" my order!

 

[eniveparg]

@Ratbert can you tell if the 4xE models are taking precedence for the 2.0L? It appears that the majority of the 2.0L listed on Crypto are being used in the 4xE

Sponsored