Conditional Format Help with more complex formula

[keef2]

So I have a schedule I am working on. I have it complete for the most part but one function I want to add is we get a 3 week look ahead delivery schedule from our supplier always in the same format. What I am hoping to do is copy the data in the delivery tab then on the schedule tab the days will conditional format to fill purple lets call it for any day a delivery is scheduled. The complexity comes from it needs to be project specific and also day specific. Here are some snap shots to try to help paint the picture:

Schedule Snap shot:

SRI Schedule Prototype - Working.xlsx
	A	B	C	D	E	F		H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1		10/2/2022						Duration	Contract	Submittals	Labor Req.	Manpower	32	32	32	32	32	32	32	40	40	40
2													Oct					Oct
3	Job #	Job Name	Roof System	PM	Supt	Start Date						Contractor	3	4	5	6	7	10	11	12	13	14
4		Javier Rodriguez
5	3376	Project River	Rhinobond	JS	BM	9/12/2022		81	Y	A	G	Clayco	8	8	8	8	8	8	8	8	8	8
6	3411	Dhamer Drive Spec Bldg	Rhinobond	JS	BM	1/24/2023		25	N	NS		Meridian
7	3416	Bridge McCook Bldg #1	EPDM/Ballast	JS	BM	3/1/2022			Y	NS		ARCO
8		Santos Toribio
9	3404	3351 Brandon Road	Rhinobond	JS	BM	9/12/2022		81	Y	A		Morgan Harbour	8	8	8	8	8	8	8	8	8	8
10		Pedro Rodriguez
11	3382	PRG - Laraway & Marcella - 639K SF	Rhinobond	JS	BM	8/2/2022		53	Y	A		FCL	8	8	8	8	8	8	8	8	8	8
12	3400	Centerpoint Schweitzer Road Spec	Rhinobond	JS	BM	10/24/2022		84	Y	A		FCL
13	3424	ELP 55 Bldg VII	Rhinobond	JS	BM	4/10/2023			Y	A		Alston
14		Marco Barahas
15	3371	LPC Palatine Spec 350K SF Distribution	Rhinobond	JS	BM	10/12/2022		27	Y	A		Owner								8	8	8
16	3403.1	Ridgeline - NW Gateway Center Bldg #1	Rhinobond	JS	BM	12/15/2022		22	Y	A		FCL
17	3417	Bridge McCook Bldg #2	EPDM/Ballast	JS	BM	7/6/2022			Y	NS		ARCO
18	3429	Project Overlook	Rhinobond	JS	BM	7/18/2023			N	NS		Ryan
19		Bob Faulkner
20	3374	LPC Aurora OD	Rhinobond	JS	BM	11/29/2022		24	Y	A		Owner
21	3372	LPC Oak Forest Spec 660K	Rhinobond	JS	BM	2/24/2022			N	NS		Owner
22	3422.8	Montgomery Terminal Bldg 8 (A)	EPDM/Ballast	KA	BM	6/26/2023			Y	A		Alston
23	3428	Nordeen Dolinger - Morris Spec	Rhinobond	JS	BM	7/17/2023			N	NS		Ryan
24		Jose Portillo
25	3375	LPC Aurora - Diehl Road	Rhinobond	JS	BM	9/26/2022		34	Y	A		Owner	8	8	8	8	8	8	8	8	8	8
26	3403.2	Ridgeline - NW Gateway Center Bldg #2	Rhinobond	JS	BM	11/15/2022		27	Y	A		FCL
27	3422.9	Montgomery Terminal Bldg 9 (B)	EPDM/Ballast	KA	BM	7/6/2023			Y	A		Alston
Schedule

Cell Formulas
Range	Formula
M1:V1	M1	=IF(SUM(M4:M27)=0,"",SUM(M4:M27))
M2,R2	M2	=CHOOSE(MONTH(O3),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
M3	M3	=WORKDAY(B1,1)
N3:V3	N3	=WORKDAY(M3,1)
M4:V4	M4	=IF($G4="","",IF(AND(M$3>=$F4,NOT(COUNTIFS(Holidays!$F$3:$F$34,M$3)),M$3<=$G4),8,""))
M5:V27	M5	=IF($G5="","",IF(AND(M$3>=$F5,NOT(COUNTIFS(Holidays!$F$3:$F$34,M$3)),M$3<=$G5-1),8,""))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H4:H27	Expression	=AND(NOT(ISBLANK($F4)),ISBLANK($H4))	text	NO
M4:GE27	Expression	=M$3=TODAY()	text	NO
CD4:GE27,M3:CD27,M5:GE27	Expression	=COUNTIFS(Holidays!$F$3:$F$34,M$3)	text	NO
4:28,A29:L52,M29:XFD49,BK50:XFD50,M50:BJ52	Expression	=AND(NOT(ISBLANK($B4)),ISBLANK($A4))	text	NO
H1:H3,I:I	Expression	=AND(NOT(ISBLANK($A1)),$I1="N")	text	NO
H1:H3,I:I	Expression	=AND(NOT(ISBLANK($A1)),$I1="Y")	text	NO
J:J	Expression	=AND(NOT(ISBLANK($A1)),$J1="S")	text	NO
J:J	Expression	=AND(NOT(ISBLANK($A1)),$J1="NS")	text	NO
J:J	Expression	=AND(NOT(ISBLANK($A1)),$J1="A")	text	NO
M1:GE1	Expression	=AND(NOT(ISBLANK($B28)),ISBLANK($A28))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
I4:I52	List	=Holidays!$Z$2:$Z$3
J4:J52	List	=Holidays!$AA$2:$AA$4

Here is my attempt with countifs in white space to do some testing for conditional formatting. However, it doesn't seem the contains portion of the formula is working appropriately ("*"&X&"*"). Lastly, it doesn't seem to identify multiple days under the same project. As you can see the only 2 yellow cells have a value, and CenterPoint Schweitzer should have another 1(yellow) on 10-14which it doesn't. I think i need to use the LET function but not sure how to write formula appropriately. I hope this will also speed up the rest of the sheet since there is an abundance of CF. Please note that the snap shot below is also the same dates as above 10-3-22 thru 10-15-22.

SRI Schedule Prototype - Working.xlsx
	A	B	C	D	E	F		H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
29		Javier Rodriguez
30	3376	Project River	Rhinobond	JS	BM	9/12/2022		81	Y	A	G	Clayco	0	0	0	0	0	1	0	0	0	0
31	3411	Dhamer Drive Spec Bldg	Rhinobond	JS	BM	1/24/2023		25	N	NS		Meridian	0	0	0	0	0	0	0	0	0	0
32	3416	Bridge McCook Bldg #1	EPDM/Ballast	JS	BM	3/1/2022			Y	NS		ARCO	0	0	0	0	0	0	0	0	0	0
33		Santos Toribio
34	3404	3351 Brandon Road	Rhinobond	JS	BM	9/12/2022		81	Y	A		Morgan Harbour	0	0	0	0	0	0	0	0	0	0
35		Pedro Rodriguez
36	3382	PRG - Laraway & Marcella - 639K SF	Rhinobond	JS	BM	8/2/2022		53	Y	A		FCL	0	0	0	0	0	0	0	0	0	0
37	3400	Centerpoint Schweitzer Road Spec	Rhinobond	JS	BM	10/24/2022		84	Y	A		FCL	0	0	0	0	1	0	0	0	0	0
38	3424	ELP 55 Bldg VII	Rhinobond	JS	BM	4/10/2023			Y	A		Alston	0	0	0	0	0	0	0	0	0	0
39		Marco Barahas
40	3371	LPC Palatine Spec 350K SF Distribution	Rhinobond	JS	BM	10/12/2022		27	Y	A		Owner	0	0	0	0	0	0	0	0	0	0
41	3403.1	Ridgeline - NW Gateway Center Bldg #1	Rhinobond	JS	BM	12/15/2022		22	Y	A		FCL	0	0	0	0	0	0	0	0	0	0
42	3417	Bridge McCook Bldg #2	EPDM/Ballast	JS	BM	7/6/2022			Y	NS		ARCO	0	0	0	0	0	0	0	0	0	0
43	3429	Project Overlook	Rhinobond	JS	BM	7/18/2023			N	NS		Ryan	0	0	0	0	0	0	0	0	0	0
44		Bob Faulkner
45	3374	LPC Aurora OD	Rhinobond	JS	BM	11/29/2022		24	Y	A		Owner	0	0	0	0	0	0	0	0	0	0
46	3372	LPC Oak Forest Spec 660K	Rhinobond	JS	BM	2/24/2022			N	NS		Owner	0	0	0	0	0	0	0	0	0	0
47	3422.8	Montgomery Terminal Bldg 8 (A)	EPDM/Ballast	KA	BM	6/26/2023			Y	A		Alston	0	0	0	0	0	0	0	0	0	0
48	3428	Nordeen Dolinger - Morris Spec	Rhinobond	JS	BM	7/17/2023			N	NS		Ryan	0	0	0	0	0	0	0	0	0	0
49		Jose Portillo
50	3375	LPC Aurora - Diehl Road	Rhinobond	JS	BM	9/26/2022		34	Y	A		Owner	0	0	0	0	0	0	0	0	0	0
51	3403.2	Ridgeline - NW Gateway Center Bldg #2	Rhinobond	JS	BM	11/15/2022		27	Y	A		FCL	0	0	0	0	0	0	0	0	0	0
52	3422.9	Montgomery Terminal Bldg 9 (B)	EPDM/Ballast	KA	BM	7/6/2023			Y	A		Alston	0	0	0	0	0	0	0	0	0	0
Schedule

Cell Formulas
Range	Formula
M30:V32,M50:V52,M45:V48,M40:V43,M36:V38,M34:V34	M30	=COUNTIFS(Delivery!$N:$N,M$3,Delivery!$E:$E,"*"&$B30&"*")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H29:H52	Expression	=AND(NOT(ISBLANK($F29)),ISBLANK($H29))	text	NO
4:28,A29:L52,M29:XFD49,BK50:XFD50,M50:BJ52	Expression	=AND(NOT(ISBLANK($B4)),ISBLANK($A4))	text	NO
H1:H3,I:I	Expression	=AND(NOT(ISBLANK($A1)),$I1="N")	text	NO
H1:H3,I:I	Expression	=AND(NOT(ISBLANK($A1)),$I1="Y")	text	NO
J:J	Expression	=AND(NOT(ISBLANK($A1)),$J1="S")	text	NO
J:J	Expression	=AND(NOT(ISBLANK($A1)),$J1="NS")	text	NO
J:J	Expression	=AND(NOT(ISBLANK($A1)),$J1="A")	text	NO

 

[keef2]

Sorry lastly here is the delivery look ahead I receive in this format. So again i want to reference any day that list a delivery based on if the job name contains partial match. Note this is all on same tab but the xlb22 wont capture all based on limit space.

SRI Schedule Prototype - Working.xlsx
	A				E	F	G	H	I	J	K	L	M	N	O	P
1	Parent Partner Name				Ship to	Order #	Del Grp	Order Ln	Quote #	Customer PO#	Plant Desc	Order Del Block	Ln Lvl Del Block	Req Del Dt	Planned GI Dt	Planned Del Dt
2	GARTH BUILDING PRODUCTS & SERVICES				PROJECT RIVER, UNIVERSITY PARK, IL	102297089	1	10		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
3							2	20		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
4							3	30		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
5							4	40		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
6							5	50		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
7							6	60		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
8							7	70		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
9							8	80		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
10							9	90		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
11							10	100		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
12							11	110		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
13							12	120		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
14							13	130		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
15							14	140		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
16							15	150		3376-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
17						102301727	2	20		3376-5	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
18								50		3376-5	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
19	SULLIVAN ROOFING INC				CENTERPOINT SCHWEITZER ROAD SPEC, JOLIET, IL	102296253	1	10		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
20							2	20		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
21							3	30		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
22							4	40		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
23							5	50		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
24							6	60		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
25							7	70		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
26							8	80		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
27							9	90		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
28							10	100		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
29							11	110		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
30							12	120		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
31							13	130		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
32							14	140		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
33							15	150		3400-1	1016-Bremen			10/7/2022	10/6/2022	10/7/2022
34						102296257	1	10		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
35							2	20		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
36							3	30		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
37							4	40		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
38							5	50		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
39							6	60		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
40							7	70		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
41							8	80		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
42							9	90		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
43							10	100		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
44							11	110		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
45							12	120		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
46							13	130		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
47							14	140		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
48							15	150		3400-1	1026-Rockdale			10/14/2022	10/13/2022	10/14/2022
49						102296259	1	10		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
50							2	20		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
51							3	30		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
52							4	40		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
53							5	50		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
54							6	60		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
55							7	70		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
56							8	80		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
57							9	90		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
58							10	100		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
59							11	110		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
60							12	120		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
61							13	130		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
62							14	140		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
63							15	150		3400-1	1016-Bremen			10/21/2022	10/20/2022	10/21/2022
64						102301943	6	60		3400-1	1029-Scottsboro			10/7/2022	10/5/2022	10/7/2022
65								320		3400-1	1029-Scottsboro			10/7/2022	10/5/2022	10/7/2022
66								330		3400-1	1029-Scottsboro			10/7/2022	10/5/2022	10/7/2022
67							7	70		3400-1	1029-Scottsboro			10/21/2022	10/19/2022	10/21/2022
68							8	80		3400-1	1029-Scottsboro			10/21/2022	10/19/2022	10/21/2022
Delivery

SRI Schedule Prototype - Working.xlsx
	A				E	F	G	H	I	J	K	L	M	N	O	P
69					JOLIET ARSENAL, JOLIET, IL	102302028	1	10		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
70							2	20		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
71							3	30		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
72							4	40		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
73							5	50		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
74							6	60		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
75							7	70		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
76							8	80		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
77							9	90		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
78							10	100		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
79							11	110		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
80							12	120		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
81							13	130		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
82							14	140		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
83							15	150		3404-1	1026-Rockdale			10/6/2022	10/5/2022	10/6/2022
84						102302036	1	10		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
85							2	20		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
86							3	30		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
87							4	40		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
88							5	50		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
89							6	60		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
90							7	70		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
91							8	80		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
92							9	90		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
93							10	100		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
94							11	110		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
95							12	120		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
96							13	130		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
97							14	140		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
98							15	150		3404-1	1016-Bremen			10/13/2022	10/12/2022	10/13/2022
99						102302040	1	10		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
100							2	20		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
101							3	30		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
102							4	40		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
103							5	50		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
104							6	60		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
105							7	70		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
106							8	80		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
107							9	90		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
108							10	100		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
109							11	110		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
110							12	120		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
111							13	130		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
112							14	140		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
113							15	150		3404-1	1016-Bremen			10/20/2022	10/19/2022	10/20/2022
114						102302477	7	460		3404-1	1029-Scottsboro			10/13/2022	10/11/2022	10/13/2022
115							8	380		3404-1	1029-Scottsboro			10/20/2022	10/18/2022	10/20/2022
116								390		3404-1	1029-Scottsboro			10/20/2022	10/18/2022	10/20/2022
117								470		3404-1	1029-Scottsboro			10/20/2022	10/18/2022	10/20/2022
Delivery

 

[keef2]

Here is the rest of delivery tab:

SRI Schedule Prototype - Working.xlsx
	A				E	F	G	H	I	J	K	L	M	N	O	P
118					LPC AURORA - DIEHL, AURORA, IL	102308353	10	100		3375-1	1026-Rockdale			10/5/2022	10/4/2022	10/5/2022
119							12	120		3375-1	1026-Rockdale			10/5/2022	10/4/2022	10/5/2022
120						102308356	1	10		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
121							2	20		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
122							3	30		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
123							4	40		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
124							5	50		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
125							6	60		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
126							7	70		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
127							8	80		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
128							9	90		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
129							10	100		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
130							11	110		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
131							12	120		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
132							13	130		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
133							14	140		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
134							15	150		3375-1	1016-Bremen			10/12/2022	10/11/2022	10/12/2022
135						102308358	1	10		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
136							2	20		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
137							3	30		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
138							4	40		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
139							5	50		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
140							6	60		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
141							7	70		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
142							8	80		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
143							9	90		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
144							10	100		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
145							11	110		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
146							12	120		3375-1	1026-Rockdale			10/19/2022	10/18/2022	10/19/2022
147						102308376	2	20		3375-1	1029-Scottsboro			10/12/2022	10/10/2022	10/12/2022
148							3	30		3375-1	1029-Scottsboro			10/19/2022	10/17/2022	10/19/2022
149					LPC PALATINE SPEC 350K SF DISTRIBUT, SCHAUMBURG, IL	102313693	1	10		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
150							2	20		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
151							3	30		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
152							4	40		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
153							5	50		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
154							6	60		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
155							7	70		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
156							8	80		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
157							9	90		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
158							10	100		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
159							11	110		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
160							12	120		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
161							13	130		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
162							14	140		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
163							15	150		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
164								160		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
165								170		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
166								190		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
167								200		3371-1	1016-Bremen			10/10/2022	10/7/2022	10/10/2022
168						102313697	1	10		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
169							2	20		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
170							3	30		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
171							4	40		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
172							5	50		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
173							6	60		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
174							7	70		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
175							8	80		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
176							9	90		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
177							10	100		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
178							11	110		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
179							12	120		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
180							13	130		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
181							14	140		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
182							15	150		3371-1	1016-Bremen			10/17/2022	10/14/2022	10/17/2022
183						102313699	1	10		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
184							2	20		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
185							3	30		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
186							4	40		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
187							5	50		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
188							6	60		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
189							7	70		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
190							8	80		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
191							9	90		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
192							10	100		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
193							11	110		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
194							12	120		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
195							13	130		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
196							14	140		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
197							15	150		3371-1	1016-Bremen			10/24/2022	10/21/2022	10/24/2022
198						102314891	1	10		3371-1	1029-Scottsboro			10/17/2022	10/14/2022	10/17/2022
199							2	20		3371-1	1029-Scottsboro			10/24/2022	10/21/2022	10/24/2022
200								360		3371-1	1029-Scottsboro			10/24/2022	10/21/2022	10/24/2022
201								370		3371-1	1029-Scottsboro			10/24/2022	10/21/2022	10/24/2022
202							4	40		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
203								50		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
204								60		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
205								70		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
206								80		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
207								90		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
208								100		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
209								110		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
210								120		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
211								130		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
212								140		3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
213					150				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
214					160				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
215					170				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
216					180				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
217					190				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
218					200				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
219					210				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
220					220				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
221					230				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
222					240				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
223					250				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
224					260				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
225					270				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
226					280				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
227					290				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
228					300				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
229					310				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
230					320				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
231					330				3371-1	1029-Scottsboro			10/10/2022	10/7/2022	10/10/2022
Delivery