Ask Ratbert

Ratbert · May 24, 2022

bjm00se said:
OK, I subtracted that out of Oct only. Nov still shows -76 negative build progress.

There's gonna be certain imprecision inherent in the system.

I'm constantly refining the boundary points between months as people provide those details, but I'll have to research to see if that happened. I'm not sure what else could cause it.

Erock482 · May 25, 2022

I'm seeing a notable slow down of 3.6 equipped 2 doors moving through in Crypto.
Is that trend showing in your analysis? Specifically with the manual transmission

Not Very Patient · May 25, 2022

Ratbert:

1st love saying that name. I truly wish someone has that as their legal name BTW.
How complex can you queries go.
The reason I ask is I feel like my dealer is being lazy on "escalating" my delay.
Granted I dont have a chart but I do check people builds from crypto and it seems like many Rubicons are being built after mine with the same if not similar option. (Maybe diff color or cold weather and not just remote start.)
Am I delusional in thinking this?
Here are my options...

Jeep Wrangler JL Ask Ratbert Screen Shot 2022-03-18 at 11.01.15 AM

Is that something you can query?
Are you using SQL?

Thanks
Mark

Ratbert · May 25, 2022

TriumphJeepster said:
Hows the Gobi ramp up since last week, they speeding up at all?

It looks like they're getting build sheets faster than they're building them.

Instances of Limited Edition Gobi Clear Coat over time:

day	build sheets	window stickers	in progress
2022-03-19	2	1	1
2022-03-20	0	0	1
2022-03-21	0	0	1
2022-03-22	0	0	1
2022-03-23	0	0	1
2022-03-24	0	0	1
2022-03-25	0	0	1
2022-03-26	0	0	1
2022-03-27	0	0	1
2022-03-28	0	0	1
2022-03-29	0	0	1
2022-03-30	0	0	1
2022-03-31	0	0	1
2022-04-01	0	0	1
2022-04-02	0	0	1
2022-04-03	0	0	1
2022-04-04	0	0	1
2022-04-05	0	0	1
2022-04-06	0	0	1
2022-04-07	0	0	1
2022-04-08	0	0	1
2022-04-10	0	0	1
2022-04-11	0	0	1
2022-04-12	0	0	1
2022-04-13	0	0	1
2022-04-14	0	1	0
2022-04-15	0	0	0
2022-04-16	0	0	0
2022-04-17	0	0	0
2022-04-18	0	0	0
2022-04-19	0	0	0
2022-04-20	0	0	0
2022-04-21	0	0	0
2022-04-22	0	0	0
2022-04-23	0	0	0
2022-04-24	0	0	0
2022-04-25	0	0	0
2022-04-26	0	0	0
2022-04-27	0	0	0
2022-04-28	0	0	0
2022-04-29	0	0	0
2022-04-30	0	0	0
2022-05-01	0	0	0
2022-05-02	0	0	0
2022-05-03	0	0	0
2022-05-04	1	0	1
2022-05-05	0	0	1
2022-05-06	20	8	13
2022-05-07	1	3	11
2022-05-08	6	0	17
2022-05-09	13	11	19
2022-05-10	21	10	30
2022-05-11	41	21	50
2022-05-12	0	2	48
2022-05-13	26	38	36
2022-05-14	0	6	30
2022-05-15	5	7	28
2022-05-16	68	41	55
2022-05-17	27	17	65
2022-05-18	59	34	90
2022-05-19	0	0	90
2022-05-20	0	0	90
2022-05-21	37	53	74
2022-05-22	55	46	83
2022-05-23	63	35	111
2022-05-24	38	26	123
total	483	360

Ratbert · May 25, 2022

Bokonon_FL said:
Based on what I see on Crypto, looks like lots of XRs getting build sheets the last few days. May be more about the source data, and a large number of XR builders tracking their orders.
Is this real or just my imagination?

It kind of looks that way. Also looks like they're getting further behind on finishing them.

Instances of Xtreme Recon 35" Tire Package over time:

day	build sheets	window stickers	in progress
2022-03-19	2,466	2,076	390
2022-03-20	61	28	423
2022-03-21	27	15	435
2022-03-22	24	5	454
2022-03-23	67	0	521
2022-03-24	3	0	524
2022-03-25	47	0	571
2022-03-26	0	38	533
2022-03-27	2	186	349
2022-03-28	92	42	399
2022-03-29	66	11	454
2022-03-30	65	35	484
2022-03-31	9	43	450
2022-04-01	9	104	355
2022-04-02	0	46	309
2022-04-03	0	32	277
2022-04-04	54	44	287
2022-04-05	54	1	340
2022-04-06	67	0	407
2022-04-07	73	3	477
2022-04-08	69	14	532
2022-04-10	182	55	659
2022-04-11	1	0	660
2022-04-12	50	26	684
2022-04-13	72	22	734
2022-04-14	160	104	790
2022-04-15	74	35	829
2022-04-16	75	58	846
2022-04-17	0	16	830
2022-04-18	76	11	895
2022-04-19	66	50	911
2022-04-20	0	7	904
2022-04-21	134	97	941
2022-04-22	61	35	967
2022-04-23	24	54	937
2022-04-24	24	95	866
2022-04-25	74	44	896
2022-04-26	149	97	948
2022-04-27	97	80	965
2022-04-28	125	123	967
2022-04-29	39	32	974
2022-04-30	32	75	931
2022-05-01	8	31	908
2022-05-02	78	0	986
2022-05-03	105	141	950
2022-05-04	134	149	935
2022-05-05	25	15	945
2022-05-06	93	72	966
2022-05-07	1	37	930
2022-05-08	36	39	927
2022-05-09	115	140	902
2022-05-10	114	105	911
2022-05-11	147	144	914
2022-05-12	8	27	895
2022-05-13	75	175	795
2022-05-14	0	57	738
2022-05-15	9	39	708
2022-05-16	153	44	817
2022-05-17	75	59	833
2022-05-18	136	143	826
2022-05-19	0	0	826
2022-05-20	0	0	826
2022-05-21	78	123	781
2022-05-22	182	144	819
2022-05-23	207	24	1,002
2022-05-24	99	91	1,010
total	6,648	5,638

Ratbert · May 25, 2022

Erock482 said:
I'm seeing a notable slow down of 3.6 equipped 2 doors moving through in Crypto.
Is that trend showing in your analysis? Specifically with the manual transmission

I haven't developed a query language that accepts (engine x OR engine y) AND two doors AND manual transmission yet (there are two types of 3.6). It would probably need to be something more elaborate than just a web url.

I can, however, show manual two doors:

Instances of 6-Speed Manual Transmission AND Two Door over time:

day	build sheets	window stickers	in progress
2022-03-19	809	764	45
2022-03-20	9	7	47
2022-03-21	12	9	50
2022-03-22	13	12	51
2022-03-23	17	0	68
2022-03-24	3	0	71
2022-03-25	7	0	78
2022-03-26	0	14	64
2022-03-27	0	42	22
2022-03-28	15	12	25
2022-03-29	8	11	22
2022-03-30	13	8	27
2022-03-31	3	4	26
2022-04-01	19	17	28
2022-04-02	0	5	23
2022-04-03	0	5	18
2022-04-04	24	13	29
2022-04-05	10	1	38
2022-04-06	10	4	44
2022-04-07	12	15	41
2022-04-08	8	8	41
2022-04-10	22	28	35
2022-04-11	0	0	35
2022-04-12	5	14	26
2022-04-13	18	4	40
2022-04-14	25	31	34
2022-04-15	2	6	30
2022-04-16	0	6	24
2022-04-17	0	2	22
2022-04-18	2	1	23
2022-04-19	7	6	24
2022-04-20	0	1	23
2022-04-21	24	22	25
2022-04-22	10	7	28
2022-04-23	6	10	24
2022-04-24	7	9	22
2022-04-25	16	9	29
2022-04-26	35	16	48
2022-04-27	27	18	57
2022-04-28	29	24	62
2022-04-29	7	18	51
2022-04-30	13	14	50
2022-05-01	9	6	53
2022-05-02	42	13	82
2022-05-03	17	28	71
2022-05-04	19	36	54
2022-05-05	1	4	51
2022-05-06	9	8	52
2022-05-07	1	2	51
2022-05-08	9	10	50
2022-05-09	17	14	53
2022-05-10	15	8	60
2022-05-11	6	10	56
2022-05-12	0	0	56
2022-05-13	1	10	47
2022-05-14	0	0	47
2022-05-15	0	1	46
2022-05-16	5	6	45
2022-05-17	4	3	46
2022-05-18	8	6	48
2022-05-19	0	0	48
2022-05-20	0	0	48
2022-05-21	6	11	43
2022-05-22	6	14	35
2022-05-23	13	9	39
2022-05-24	4	8	35
total	1,439	1,404

bjm00se · May 25, 2022

6sp is only available with V6 ESS. Not eTorque or turbo, so no need to refine the engine criteria when searching 6sp.

Ratbert · May 25, 2022

Not Very Patient said:
Ratbert:

1st love saying that name. I truly wish someone has that as their legal name BTW.
How complex can you queries go.
The reason I ask is I feel like my dealer is being lazy on "escalating" my delay.
Granted I dont have a chart but I do check people builds from crypto and it seems like many Rubicons are being built after mine with the same if not similar option. (Maybe diff color or cold weather and not just remote start.)
Am I delusional in thinking this?
Here are my options...

Is that something you can query?
Are you using SQL?

Thanks
Mark

Ratbert was a character name that I used while playing WoW (where I met my wife!). Dogbert, Catbert, Ratbert, etc. characters from Dilbert.

Yes, it's a SQL database, but SQL won't really format these results in a forum-friendly manner. I was initially building these tables by hand with lots of copy/paste pain, but I've subsequently written another program that does the queries for me.

Note that doing yours is a one-off. Transcribing those one by one perfectly isn't fun.

Did yours get a build sheet on April 24th? That's on the only "new" one that I see. Pretty damn rare combo.

Instances of 3.6L V6 24V VVT eTorque Engine Upg I, 8-Spd Auto 850RE Trans (Make), Advanced Safety Group, Black 3-Piece Hard Top, Corning Gorilla(R) Glass, Customer Preferred Package 25R, LED Lighting Group, Leather Trimmed Bucket Seats, MOPAR All-Weather Floor Mats, MOPAR HD Rock Slider w/Step Assist, Safety Group, Sting-Gray Clear Coat, AND Trailer Tow and HD Electrical Group over time:

day	build sheets	window stickers	in progress
2022-03-19	1	1	0
2022-03-20	0	0	0
2022-03-21	0	0	0
2022-03-22	0	0	0
2022-03-23	0	0	0
2022-03-24	0	0	0
2022-03-25	0	0	0
2022-03-26	0	0	0
2022-03-27	0	0	0
2022-03-28	0	0	0
2022-03-29	0	0	0
2022-03-30	0	0	0
2022-03-31	0	0	0
2022-04-01	0	0	0
2022-04-02	0	0	0
2022-04-03	0	0	0
2022-04-04	0	0	0
2022-04-05	0	0	0
2022-04-06	0	0	0
2022-04-07	0	0	0
2022-04-08	0	0	0
2022-04-10	0	0	0
2022-04-11	0	0	0
2022-04-12	0	0	0
2022-04-13	0	0	0
2022-04-14	0	0	0
2022-04-15	0	0	0
2022-04-16	0	0	0
2022-04-17	0	0	0
2022-04-18	0	0	0
2022-04-19	0	0	0
2022-04-20	0	0	0
2022-04-21	0	0	0
2022-04-22	0	0	0
2022-04-23	0	0	0
2022-04-24	1	0	1
total	2	1

Ratbert · May 25, 2022

Erock482 said:
I'm seeing a notable slow down of 3.6 equipped 2 doors moving through in Crypto.
Is that trend showing in your analysis? Specifically with the manual transmission

bjm00se said:
6sp is only available with V6 ESS. Not eTorque or turbo, so no need to refine the engine criteria when searching 6sp.

Oh, I didn't realize that (and will forget that detail soon enough

).

I'm guessing that the 3.6L ESS is the only engine available on a two-door manual, right? The numbers are identical if I filter on the 3.6L v6 or not.

Oskaloosa Mailman · May 25, 2022

Ratbert said:
Ratbert was a character name that I used while playing WoW (where I met my wife!). Dogbert, Catbert, Ratbert, etc. characters from Dilbert

In the early '80s a roommate of mine drew cartoons using a character he named Ratbert. Of course he walked upright, dressed hip, had a long wrinkly rat nose, and talked.

bjm00se · May 25, 2022

Ratbert said:
I'm guessing that the 3.6L ESS is the only engine available on a two-door manual, right? The numbers are identical if I filter on the 3.6L v6 or not.

Yeah.

If you get a different engine, it'll have an automatic transmission

bjm00se · May 25, 2022

Oskaloosa Mailman said:
In the early '80s a roommate of mine drew cartoons using a character he named Ratbert. Of course he walked upright, dressed hip, had a long wrinkly rat nose, and talked.

He worked for PacBell, and was prematurely balding, right? :-D

(the roommate, I mean)

Oskaloosa Mailman · May 25, 2022

bjm00se said:
He worked for PacBell, and was prematurely balding, right? :-D

(the roommate, I mean)

Negative ???

Bokonon_FL · May 25, 2022

Ratbert said:
It kind of looks that way. Also looks like they're getting further behind on finishing them.

Instances of Xtreme Recon 35" Tire Package over time:

day build sheets window stickers in progress
2022-03-19
2,466
2,076
390
2022-03-20
61
28
423
2022-03-21
27
15
435
2022-03-22
24
5
454
2022-03-23
67
0
521
2022-03-24
3
0
524
2022-03-25
47
0
571
2022-03-26
0
38
533
2022-03-27
2
186
349
2022-03-28
92
42
399
2022-03-29
66
11
454
2022-03-30
65
35
484
2022-03-31
9
43
450
2022-04-01
9
104
355
2022-04-02
0
46
309
2022-04-03
0
32
277
2022-04-04
54
44
287
2022-04-05
54
1
340
2022-04-06
67
0
407
2022-04-07
73
3
477
2022-04-08
69
14
532
2022-04-10
182
55
659
2022-04-11
1
0
660
2022-04-12
50
26
684
2022-04-13
72
22
734
2022-04-14
160
104
790
2022-04-15
74
35
829
2022-04-16
75
58
846
2022-04-17
0
16
830
2022-04-18
76
11
895
2022-04-19
66
50
911
2022-04-20
0
7
904
2022-04-21
134
97
941
2022-04-22
61
35
967
2022-04-23
24
54
937
2022-04-24
24
95
866
2022-04-25
74
44
896
2022-04-26
149
97
948
2022-04-27
97
80
965
2022-04-28
125
123
967
2022-04-29
39
32
974
2022-04-30
32
75
931
2022-05-01
8
31
908
2022-05-02
78
0
986
2022-05-03
105
141
950
2022-05-04
134
149
935
2022-05-05
25
15
945
2022-05-06
93
72
966
2022-05-07
1
37
930
2022-05-08
36
39
927
2022-05-09
115
140
902
2022-05-10
114
105
911
2022-05-11
147
144
914
2022-05-12
8
27
895
2022-05-13
75
175
795
2022-05-14
0
57
738
2022-05-15
9
39
708
2022-05-16
153
44
817
2022-05-17
75
59
833
2022-05-18
136
143
826
2022-05-19
0
0
826
2022-05-20
0
0
826
2022-05-21
78
123
781
2022-05-22
182
144
819
2022-05-23
207
24
1,002
2022-05-24
99
91
1,010
total
6,648
5,638

Thanks for running this again! Mine is scheduled to be added to the iIn Progress List on June 10th…

Not Very Patient · May 26, 2022

Ratbert said:
Ratbert was a character name that I used while playing WoW (where I met my wife!). Dogbert, Catbert, Ratbert, etc. characters from Dilbert.

Yes, it's a SQL database, but SQL won't really format these results in a forum-friendly manner. I was initially building these tables by hand with lots of copy/paste pain, but I've subsequently written another program that does the queries for me.

Note that doing yours is a one-off. Transcribing those one by one perfectly isn't fun.

Did yours get a build sheet on April 24th? That's on the only "new" one that I see. Pretty damn rare combo.

Instances of 3.6L V6 24V VVT eTorque Engine Upg I, 8-Spd Auto 850RE Trans (Make), Advanced Safety Group, Black 3-Piece Hard Top, Corning Gorilla(R) Glass, Customer Preferred Package 25R, LED Lighting Group, Leather Trimmed Bucket Seats, MOPAR All-Weather Floor Mats, MOPAR HD Rock Slider w/Step Assist, Safety Group, Sting-Gray Clear Coat, AND Trailer Tow and HD Electrical Group over time:

day build sheets window stickers in progress
2022-03-19
1
1
0
2022-03-20
0
0
0
2022-03-21
0
0
0
2022-03-22
0
0
0
2022-03-23
0
0
0
2022-03-24
0
0
0
2022-03-25
0
0
0
2022-03-26
0
0
0
2022-03-27
0
0
0
2022-03-28
0
0
0
2022-03-29
0
0
0
2022-03-30
0
0
0
2022-03-31
0
0
0
2022-04-01
0
0
0
2022-04-02
0
0
0
2022-04-03
0
0
0
2022-04-04
0
0
0
2022-04-05
0
0
0
2022-04-06
0
0
0
2022-04-07
0
0
0
2022-04-08
0
0
0
2022-04-10
0
0
0
2022-04-11
0
0
0
2022-04-12
0
0
0
2022-04-13
0
0
0
2022-04-14
0
0
0
2022-04-15
0
0
0
2022-04-16
0
0
0
2022-04-17
0
0
0
2022-04-18
0
0
0
2022-04-19
0
0
0
2022-04-20
0
0
0
2022-04-21
0
0
0
2022-04-22
0
0
0
2022-04-23
0
0
0
2022-04-24
1
0
1
total
2
1

Thanks so much for your help. I knew it was going to be rare when I ordered. I still don't have any updates per se.
I get responses from the dealer like...

The only thing the rep told us is that they are so backed up on sold orders and between dealerships orders and customer orders they couldn’t keep up with both and they didn’t have enough parts for both so they stoped taking dealerships orders for half of this month and all of next month to Focus on customer orders and 2 that I ordered in jan just started getting built so I would say give it a couple weeks and it should start getting built

Jeep insists that they will make my Jeep this model year but I am becoming more and more skeptical as time passes. I took SQL in college so thanks for the query I understand the pains.

IDK what to really think. It is a bit chaotic to say the least.

Thanks again,
Mark

Ask Ratbert

Ratbert

Well-Known Member

Erock482

Well-Known Member

Not Very Patient

Active Member

Ratbert

Well-Known Member

Ratbert

Well-Known Member

Ratbert

Well-Known Member

bjm00se

Well-Known Member

Ratbert

Well-Known Member

Ratbert

Well-Known Member

Oskaloosa Mailman

Well-Known Member

bjm00se

Well-Known Member

bjm00se

Well-Known Member

Oskaloosa Mailman

Well-Known Member

Bokonon_FL

Active Member

Not Very Patient

Active Member

Similar threads