Ask Ratbert

Stumeat · Apr 14, 2022

ogo said:
Your Window Sticker shows the 4.88 gears
https://www.jeep.com/hostd/windowsticker/getWindowStickerPdf.do?vin=1C4HJXCG8NW188563

Sorry, I meant that I do not see it listed on the listed dates. Not a biggy, my bet is that crypto was just off.

Ratbert · Apr 14, 2022

Stumeat said:
Sorry, I meant that I do not see it listed on the listed dates. Not a biggy, my bet is that crypto was just off.

My extraction / database has nothing to do with crypto. The only commonality is that we're both pulling from the same data source.

Each extraction takes a few hours, so for the dates to be relatively consistent for a given run I pull every morning at 2am Mountain Time. That means that the dates are extremely likely to be off by one except for the situation where your build sheet / window sticker was created after midnight Mountain Time.

My code found your build sheet at 2022-03-25 02:25:08 and your window sticker at 2022-03-28 06:42:13.

longbucks08 · Apr 14, 2022

Hey Ratbert, I've heard others mention that dealers are telling them that MOPAR door sills and cargo tubs are holding up some of the older orders. Are you able to see if those options are coming through in the orders being made? I wasn't sure if that was getting too detailed for the data you are pulling. Appreciate it if you can help!

Ratbert · Apr 14, 2022

Powelligator said:

Sorry, I should have specified that this query was based on window stickers. Thinking about it now I realize that it should have been based on build sheets instead. 4.88s from a build sheet perspective. Extract started at 2am so it somewhat represents the previous day.

2022-03-17 43
2022-03-18 21
2022-03-21 1
2022-03-23 1
2022-03-24 2
2022-03-25 2
2022-03-26 1
2022-03-29 2
2022-03-30 1
2022-04-02 2
2022-04-05 6
2022-04-06 4
2022-04-08 1
2022-04-11 1
2022-04-14 2

p.s. I find that these forums are much easier on the eyes when they're configured with dark mode enabled. There is, however, a significant chance that I spend waaaaay too much time here

Powelligator · Apr 14, 2022

Yeah, that makes more sense. Window sticker gets generated when it comes out of JB Status, that has nothing to do with 4.88 Gear production. My build sheet showed up on 3/17, so on that day it appears I'm only 1 of 43.

Ratbert · Apr 14, 2022

longbucks08 said:
Hey Ratbert, I've heard others mention that dealers are telling them that MOPAR door sills and cargo tubs are holding up some of the older orders. Are you able to see if those options are coming through in the orders being made? I wasn't sure if that was getting too detailed for the data you are pulling. Appreciate it if you can help!

My database is ideal for those types of detailed queries. It's the queries that aren't as precise that are challenging.

Instances of MOPAR Stainless Door Sill Guards over time:

day	build sheets	window stickers
2022-03-20	25	19
2022-03-21	15	6
2022-03-22	20	6
2022-03-23	30	0
2022-03-24	3	0
2022-03-25	24	0
2022-03-26	0	33
2022-03-27	3	68
2022-03-28	32	21
2022-03-29	27	18
2022-03-30	21	21
2022-03-31	10	14
2022-04-01	22	29
2022-04-02	0	11
2022-04-03	0	11
2022-04-04	32	15
2022-04-05	23	3
2022-04-06	19	3
2022-04-07	22	13
2022-04-08	27	14
2022-04-09	0	0
2022-04-10	47	70
2022-04-11	2	0
2022-04-12	17	38
2022-04-13	16	11

Instances of MOPAR Plastic Door Sill Guards over time:

day	build sheets	window stickers
2022-03-20	26	28
2022-03-21	12	12
2022-03-22	28	16
2022-03-23	55	0
2022-03-24	4	0
2022-03-25	24	0
2022-03-26	0	29
2022-03-27	1	119
2022-03-28	48	38
2022-03-29	36	35
2022-03-30	51	16
2022-03-31	7	8
2022-04-01	56	42
2022-04-02	1	33
2022-04-03	0	22
2022-04-04	65	15
2022-04-05	34	5
2022-04-06	32	24
2022-04-07	26	24
2022-04-08	37	27
2022-04-09	0	0
2022-04-10	75	125
2022-04-11	1	1
2022-04-12	24	58
2022-04-13	42	15

Ratbert · Apr 14, 2022

longbucks08 said:
Hey Ratbert, I've heard others mention that dealers are telling them that MOPAR door sills and cargo tubs are holding up some of the older orders. Are you able to see if those options are coming through in the orders being made? I wasn't sure if that was getting too detailed for the data you are pulling. Appreciate it if you can help!

Instances of MOPAR Cargo Tub Liner over time:

day	build sheets	window stickers
2022-03-20	25	23
2022-03-21	16	12
2022-03-22	25	11
2022-03-23	45	0
2022-03-24	2	0
2022-03-25	23	0
2022-03-26	0	34
2022-03-27	2	84
2022-03-28	45	26
2022-03-29	35	28
2022-03-30	41	24
2022-03-31	10	12
2022-04-01	41	40
2022-04-02	0	20
2022-04-03	0	17
2022-04-04	47	18
2022-04-05	26	4
2022-04-06	22	16
2022-04-07	24	21
2022-04-08	28	11
2022-04-09	0	0
2022-04-10	54	87
2022-04-11	3	1
2022-04-12	22	42
2022-04-13	40	14

Ratbert · Apr 14, 2022

Powelligator said:
Yeah, that makes more sense. Window sticker gets generated when it comes out of JB Status, that has nothing to do with 4.88 Gear production. My build sheet showed up on 3/17, so on that day it appears I'm only 1 of 43.

Now that I've written the code to pull these details out by day it's significantly easier to generate these types of queries where build sheets and window stickers are both included:

Instances of 4.88 Rear Axle Ratio over time:

day	build sheets	window stickers
2022-03-20	1	1
2022-03-21	0	0
2022-03-22	1	0
2022-03-23	2	0
2022-03-24	2	0
2022-03-25	1	0
2022-03-26	0	1
2022-03-27	0	4
2022-03-28	2	3
2022-03-29	1	2
2022-03-30	0	0
2022-03-31	0	0
2022-04-01	2	0
2022-04-02	0	2
2022-04-03	0	0
2022-04-04	6	2
2022-04-05	4	1
2022-04-06	0	0
2022-04-07	1	1
2022-04-08	0	1
2022-04-09	0	0
2022-04-10	1	4
2022-04-11	0	0
2022-04-12	0	1
2022-04-13	2	0

Ratbert · Apr 14, 2022

Powelligator said:
Yeah, that makes more sense. Window sticker gets generated when it comes out of JB Status, that has nothing to do with 4.88 Gear production. My build sheet showed up on 3/17, so on that day it appears I'm only 1 of 43.

I just realized that it might be cool / interesting to include the delta between build sheets and window stickers for these types of queries. I love that it's all in Java now.

Instances of 4.88 Rear Axle Ratio over time:

day	build sheets	window stickers	backlog
2022-03-16	15	unknown
2022-03-17	47	unknown
2022-03-18	2	unknown
2022-03-19	0	46	18
2022-03-20	1	1	18
2022-03-21	0	0	18
2022-03-22	1	0	19
2022-03-23	2	0	21
2022-03-24	2	0	23
2022-03-25	1	0	24
2022-03-26	0	1	23
2022-03-27	0	4	19
2022-03-28	2	3	18
2022-03-29	1	2	17
2022-03-30	0	0	17
2022-03-31	0	0	17
2022-04-01	2	0	19
2022-04-02	0	2	17
2022-04-03	0	0	17
2022-04-04	6	2	21
2022-04-05	4	1	24
2022-04-06	0	0	24
2022-04-07	1	1	24
2022-04-08	0	1	23
2022-04-10	1	4	20
2022-04-11	0	0	20
2022-04-12	0	1	19
2022-04-13	2	0	21

Note that backlog (build sheets minus window stickers) includes build sheets that may never get window stickers.

Nitehawk92 · Apr 14, 2022

FloridaSon said:
This is good! No suggestions at this point, I am a Feb orderer but this might be of some interest. I signed up for MOPAR Jeep Owner and it won’t return my vehicle until its built.

But yesterday, a picture of a Jeep Wrangler popped up in ‘my garage’ with a VIN of 00000000000000001. I assume this a place holder.

The first VIN you posted also ended like that. So that too may be a placeholder when they built the database just to keep errors down?

Anyway thanks for this.

I had the same thing happen. It shows a picture of a Jeep, but if I try to add the Vin, it doesn't find anything. But before there was no picture at all. To bad we don't know what this means. Hopefully in the future it will find my Vin...

Nitehawk92 · Apr 14, 2022

longbucks08 said:
Hey Ratbert, I've heard others mention that dealers are telling them that MOPAR door sills and cargo tubs are holding up some of the older orders. Are you able to see if those options are coming through in the orders being made? I wasn't sure if that was getting too detailed for the data you are pulling. Appreciate it if you can help!

If it was my order being delayed by one of those things, I would just say skip it, build my Jeep.

Ratbert · Apr 14, 2022

Nitehawk92 said:
If it was my order being delayed by one of those things, I would just say skip it, build my Jeep.

How would you know definitively that it was being held up by one of those things?

From what I understand, getting your order changed after a VIN has been assigned is also extremely difficult.

TriumphJeepster · Apr 14, 2022

Crazy how few 4.88 builds there are.

Just goes to show, everyone asks for a thing, Jeep offers it, and no one buys it =]

Except for the few of us of course. Doesn't help few people know you can order it, on top of it hasn't been out on dealer lots.

Ratbert · Apr 14, 2022

This is for all builds. It seems like the backlog varies a little, but not significantly. Something screwy must have been going on from 3/24 to 3/27.

I discovered that my window sticker PDF parser was having difficulties parsing some of the weirder formats that don't conform to what others look like. It also didn't know how to deal with the French versions that appear for some Canadian orders. I've remedied those issues so tonight's extraction will hopefully see a bump in window stickers.

day	build sheets	window stickers	backlog
2022-03-16	21,397	unknown
2022-03-17	36,921	unknown
2022-03-18	5,569	unknown
2022-03-19	0	48,011	15,876
2022-03-20	726	513	16,089
2022-03-21	1,108	897	16,300
2022-03-22	917	641	16,576
2022-03-23	1,960	14	18,522
2022-03-24	64	0	18,586
2022-03-25	1,008	0	19,594
2022-03-26	0	1,389	18,205
2022-03-27	21	3,401	14,825
2022-03-28	1,222	1,004	15,043
2022-03-29	1,113	864	15,292
2022-03-30	1,081	822	15,551
2022-03-31	409	374	15,586
2022-04-01	1,525	1,287	15,824
2022-04-02	15	415	15,424
2022-04-03	0	226	15,198
2022-04-04	1,628	1,017	15,809
2022-04-05	899	250	16,458
2022-04-06	863	399	16,922
2022-04-07	801	570	17,153
2022-04-08	917	651	17,419
2022-04-10	1,895	3,060	16,254
2022-04-11	31	29	16,256
2022-04-12	409	621	16,044
2022-04-13	628	279	16,393

Note that backlog (build sheets minus window stickers) includes build sheets that may never get window stickers.

TriumphJeepster · Apr 14, 2022

Ratbert said:
This is for all builds. It seems like the backlog varies a little, but not significantly. Something screwy must have been going on from 3/24 to 3/27.

I discovered that my window sticker PDF parser was having difficulties parsing some of the weirder formats that don't conform to what others look like. It also didn't know how to deal with the French versions that appear for some Canadian orders. I've remedied those issues so tonight's extraction will hopefully see a bump in window stickers.

day build sheets window stickers backlog
2022-03-16
21,397
unknown

2022-03-17
36,921
unknown

2022-03-18
5,569
unknown

2022-03-19
0
48,011
15,876
2022-03-20
726
513
16,089
2022-03-21
1,108
897
16,300
2022-03-22
917
641
16,576
2022-03-23
1,960
14
18,522
2022-03-24
64
0
18,586
2022-03-25
1,008
0
19,594
2022-03-26
0
1,389
18,205
2022-03-27
21
3,401
14,825
2022-03-28
1,222
1,004
15,043
2022-03-29
1,113
864
15,292
2022-03-30
1,081
822
15,551
2022-03-31
409
374
15,586
2022-04-01
1,525
1,287
15,824
2022-04-02
15
415
15,424
2022-04-03
0
226
15,198
2022-04-04
1,628
1,017
15,809
2022-04-05
899
250
16,458
2022-04-06
863
399
16,922
2022-04-07
801
570
17,153
2022-04-08
917
651
17,419
2022-04-10
1,895
3,060
16,254
2022-04-11
31
29
16,256
2022-04-12
409
621
16,044
2022-04-13
628
279
16,393

Note that backlog (build sheets minus window stickers) includes build sheets that may never get window stickers.

Lol @ the huge drop off of build sheets on my order date 3-18. Naturally.

Ask Ratbert

Stumeat

Well-Known Member

Ratbert

Well-Known Member

longbucks08

Member

Ratbert

Well-Known Member

Powelligator

Well-Known Member

Ratbert

Well-Known Member

Ratbert

Well-Known Member

Ratbert

Well-Known Member

Ratbert

Well-Known Member

Nitehawk92

Well-Known Member

Nitehawk92

Well-Known Member

Ratbert

Well-Known Member

TriumphJeepster

Well-Known Member

Ratbert

Well-Known Member

TriumphJeepster

Well-Known Member

Similar threads