Spreadsheet: 846123d1697438677-excel-formula-with-multiple-conditions-downgrade-template
Sheet: NEW BOOKED IN

 | BOOKED IN DOWNGRADE
 | Downgrade Material
 | Material ID | Lens/EA | UNIT | Material | Weight |  | Load |  | RATES AT TIME OF ORDER ARRIVAL
 | PURPLE LOAD - 9 DEC 2021 |  |  |  |  |  | Purple 9/12/21 |  | DOWNGRADE RATES - 9/12/2021
 | 189597 | 42 | EA | RHS-065-065-01.6-REJ-GAL-08000 | 1.05168 |  | Purple 9/12/21 |  |  | RESELLER |  |  | END USER
 | 225841 | 8 | EA | RHS-065-065-02.0-REJ-AGAL-07200 | 0.223488 |  | Purple 9/12/21 |  | PIPE | RATE | COST | MARGIN | RATE | COST | MARGIN
 | 189351 | 34 | EA | RHS-065-065-02.0-REJ-GAL-08000 | 1.05536 |  | Purple 9/12/21 |  | PTD | 1850 | 1550 |  |  | 1550
 | 223412 | 42 | EA | RHS-065-065-02.5-REJ-GAL-08000 | 1.60608 |  | Purple 9/12/21 |  | GAL | 2000 | 1680 |  |  | 1680
 | 220894 | 28 | EA | RHS-089-089-02.0-REJ-PGAL-06200 | 0.917088 |  | Purple 9/12/21 |  | RHS
 | 226216 | 13 | EA | RHS-100-100-02.0-REJ-AGAL-08000 | 0.63128 |  | Purple 9/12/21 |  | PTD | 2000 | 1675 |  |  | 1675
 | 238139 | 14 | EA | RHS-100-100-03.0-REJ-ULTRAGAL-PCQ-08000 | 1.05728 |  | Purple 9/12/21 |  | GAL | 2150 | 1805 |  |  | 1805
 | 226294 | 84 | EA | RHS-115-042-02.0-REJ-PGAL-RL-06100 | 2.319891 |  | Purple 9/12/21 |  | C/RAIL
 | 223466 | 4 | EA | RHS-125-125-04.0-REJ-AGAL-12000 | 0.7104 |  | Purple 9/12/21 |  | GAL | N/A |  |  | 2400 | 1805
 | 231148 | 21 | EA | RHS-150-050-03.0-REJ-AGAL-07500 | 1.49632 |  | Purple 9/12/21
 | Total PCs |  |  | Total Weight |  |  | Purple 9/12/21
 | 225503 | 10 | EA | CP-100.0-M-REJ-ORRFIRE-PE-06500 | 0.793 |  | Purple 9/12/21
 | 225551 | 10 | EA | CP-150.0-M-REJ-ORRFIRE-PE-06500 | 1.2805 |  | Purple 9/12/21
 | 144643 | 28 | EA | RHS-050-050-04.0-REJ-PTD-08000 | 1.1984 |  | Purple 9/12/21
 | 144646 | 21 | EA | RHS-050-050-05.0-REJ-PTD-08000 | 1.07352 |  | Purple 9/12/21
 | 201666 | 13 | EA | RHS-050-050-06.0-REJ-PTD-08000 | 0.76128 |  | Purple 9/12/21
 | 144836 | 12 | EA | RHS-100-100-03.0-REJ-PTD-08000 | 0.8534400000000001 |  | Purple 9/12/21
 | 184350 | 21 | EA | RHS-150-050-02.0-REJ-PTD-08000 | 1.01976 |  | Purple 9/12/21
 | 144893 | 12 | EA | RHS-150-050-04.0-REJ-PTD-08000 | 1.1136 |  | Purple 9/12/21
 | 245756 | 4 | EA | RHS-150-050-04.0-REJ-PTD-08500 | 0.395284 |  | Purple 9/12/21
 | 226482 | 1 | EA | RHS-150-100-05.0-REJ-PTD-10000 | 0.181 |  | Purple 9/12/21
 | 189043 | 5 | EA | RHS-150-100-05.0-REJ-PTD-12000 | 1.092 |  | Purple 9/12/21
 | 186297 | 8 | EA | RHS-150-100-06.0-REJ-PTD-12000 | 2.0544 |  | Purple 9/12/21
 | 186305 | 1 | EA | RHS-152-076-05.0-REJ-PTD-08000 | 0.1312 |  | Purple 9/12/21
 | 226488 | 5 | EA | RHS-152-076-05.0-REJ-PTD-12000 | 0.9840000000000001 |  | Purple 9/12/21
 | Total PCs |  |  | Total Weight |  |  | Purple 9/12/21
 | TOTAL PCS |  |  | GRAND TOTAL |  |  | Purple 9/12/21
 | [NAME] 16 DEC 2021 |  |  |  |  |  | Pink 16/12/21 |  | DOWNGRADE RATES - 16/12/2021
 | 232432 | 37 | EA | CP-051.0-04.0-REJ-AGAL-PE-06050 | 1038.664 |  | Pink 16/12/21 |  |  | RESELLER |  |  | END USER
 | 238134 | 128 | EA | RHS-050-050-01.6-REJ-ULTRAGAL-PCQ-07200 | 2193.408 |  | Pink 16/12/21 |  | PIPE | RATE | COST | MARGIN | RATE | COST | MARGIN
 | 223413 | 36 | EA | RHS-065-065-03.0-REJ-AGAL-08000 | 1630.08 |  | Pink 16/12/21 |  | PTD | 1850 | 1550 |  |  | 1550
 | 189356 | 7 | EA | RHS-075-050-01.6-REJ-GAL-08000 | 168.56 |  | Pink 16/12/21 |  | GAL | 2000 | 1680 |  |  | 1680
 | 144688 | 35 | EA | RHS-075-050-02.0-REJ-GAL-08000 | 1041.6 |  | Pink 16/12/21 |  | RHS
 | 189014 | 42 | EA | RHS-115-042-02.0-REJ-GAL-RL-06100 | 1093.974 |  | Pink 16/12/21 |  | PTD | 2000 | 1675 |  |  | 1675
 | 223469 | 42 | EA | RHS-150-050-02.0-REJ-AGAL-12000 | 3059.28 |  | Pink 16/12/21 |  | GAL | 2150 | 1805 |  |  | 1805
 | 198450 | 12 | EA | RHS-150-050-02.0-REJ-GAL-08000 | 582.72 |  | Pink 16/12/21 |  | C/RAIL
 | 223473 | 15 | EA | RHS-150-050-03.0-REJ-AGAL-08000 | 1075.2 |  | Pink 16/12/21 |  | GAL | N/A |  |  | 2400 | 1805
 | Total PCs |  |  | Total Weight |  |  | Pink 16/12/21
 | 223159 | 74 | EA | CP-050.0-M-REJ-BLK-PE-06500 | 2419.43 |  | Pink 16/12/21
 | 220626 | 5 | EA | CP-150.0-03.2-REJ-BLK-PE-12000 | 762 |  | Pink 16/12/21
 | 225546 | 10 | EA | CP-150.0-M-REJ-BLK-PE-06500 | 1280.5 |  | Pink 16/12/21 |  | **We were short supplied RHS Gal 50x50x1.6 - 22 pcs @ 6300 & 42 pcs @ 7200mm
 | 144872 | 9 | EA | RHS-125-075-04.0-REJ-PTD-08000 | 835.2 |  | Pink 16/12/21 |  | **The above short supplied was sent on 20/12/2021
 | 144874 | 2 | EA | RHS-125-075-04.0-REJ-PTD-12000 | 278.4 |  | Pink 16/12/21
 | 144881 | 9 | EA | RHS-125-075-06.0-REJ-PTD-08000 | 1202.4 |  | Pink 16/12/21
 | 189025 | 10 | EA | RHS-125-075-06.0-REJ-PTD-12000 | 2004 |  | Pink 16/12/21
 | 144895 | 15 | EA | RHS-150-050-05.0-REJ-PTD-08000 | 1704 |  | Pink 16/12/21
 | Total PCs |  |  | Total Weight |  |  | Pink 16/12/21
 | TOTAL PCS |  |  | GRAND TOTAL |  |  | Pink 16/12/21
 | ATM - 18 JAN 2022
 |  | 49 | EA |  | 1604 | 8000 | 18/1/22 |  | 49 | RHS | 40X40X4 | BLK / PTD | 8000
 |  | 49 | EA |  | 1604 | 8000 | 18/1/22 |  | 49 | RHS | 40X40X4 | BLK / PTD | 8000
 |  | 49 | EA |  | 1604 | 8000 | 18/1/22 |  | 49 | RHS | 40X40X4 | BLK / PTD | 8000
 |  | 49 | EA |  | 1604 | 8000 | 18/1/22 |  | 49 | RHS | 40X40X4 | BLK / PTD | 8000
 |  | 64 | EA |  | 1444 | 8000 | 18/1/22 |  | 64 | RHS | 40X40X2.5 | BLK / PTD | 8000
 |  | 64 | EA |  | 1444 | 8000 | 18/1/22 |  | 64 | RHS | 40X40X2.5 | BLK / PTD | 8000
 |  | 64 | EA |  | 1444 | 8000 | 18/1/22 |  | 64 | RHS | 40X40X2.5 | GAL | 8000
 |  | 64 | EA |  | 1444 | 8000 | 18/1/22 |  | 64 | RHS | 40X40X3 | BLK / PTD | 8000
 |  | 81 | EA |  | 1497 | 8000 | 18/1/22 |  | 81 | RHS | 40X40X2.0 | GAL | 8000
 |  | 81 | EA |  | 1497 | 8000 | 18/1/22 |  | 81 | RHS | 40X40X2.0 | BLK / PTD | 8000
 |  | 81 | EA |  | 1497 | 8000 | 18/1/22 |  | 81 | RHS | 40X40X2.0 | BLK / PTD | 8000
 |  | 81 | EA |  | 1497 | 8000 | 18/1/22 |  | 81 | RHS | 40X40X2.0 | BLK / PTD | 8000
 |  | 64 | EA |  | 1444 | 8000 | 18/1/22 |  | 64 | RHS | 40X40X2.5 | GAL | 8000
 |  | 30 | EA |  | 1736 | 8000 | 18/1/22 |  | 30 | RHS | 65X65X4 | GAL | 8000
 |  | 100 | EA |  | 728 | 6500 | 18/1/22 |  | 100 | RHS | 25X25X1.6 | BLK / PTD | 6500
 |  | 100 | EA |  | 884 | 6500 | 18/1/22 |  | 100 | RHS | 25X25X2.0 | BLK / PTD | 6500
 |  | 100 | EA |  | 884 | 6500 | 18/1/22 |  | 100 | RHS | 25X25X2.0 | BLK / PTD | 6500
 |  | 100 | EA |  | 728 | 6500 | 18/1/22 |  | 100 | RHS | 25X25X1.6 | BLK / PTD | 6500
 |  | 100 | EA |  | 728 | 6500 | 18/1/22 |  | 100 | RHS | 25X25X1.6 | BLK / PTD | 6500
 |  | 21 | EA |  | 679 |  | 18/1/22 |  | 21 | CATTLE RAIL | 115X42X2.5 | GAL | 6100
 |  | 21 | EA |  | 679 |  | 18/1/22 |  | 21 | CATTLE RAIL | 115X42X2.5 | GAL | 6100
 |  | 21 | EA |  | 679 |  | 18/1/22 |  | 21 | CATTLE RAIL | 115X42X2.5 | GAL | 6100
 |  | 21 | EA |  | 547 |  | 18/1/22 |  | 21 | CATTLE RAIL | 115X42X2.0 | GAL | 6100
 |  | 21 | EA |  | 547 |  | 18/1/22 |  | 21 | CATTLE RAIL | 115X42X2.0 | GAL | 6100
 |  | 32 | EA |  | 1152 |  | 18/1/22 |  | 32 | RHS | 100X50X2.0 | GAL | 8000
 |  | 32 | EA |  | 1424 |  | 18/1/22 |  | 32 | RHS | 100X50X2.5 | BLK / PTD | 8000
 |  | 32 | EA |  | 1424 |  | 18/1/22 |  | 32 | RHS | 100X50X2.5 | BLK / PTD | 8000
 | TOTAL PCS |  |  | GRAND TOTAL
 | ORRCON 5/5/2022
 |  | 8 | EA | CATTLE RAIL 75x40x1.6 GAL 8000 | N/A
 |  | 12 | EA | CATTLE RAIL 75x40x1.6 GAL 8000 | N/A
 |  | 20 | EA | CATTLE RAIL 75x40x1.6 GAL 8000 | N/A
 |  | 20 | EA | CATTLE RAIL 75x40x1.6 GAL 8000 | N/A
 |  | 20 | EA | CATTLE RAIL 75x40x1.6 GAL 8000 | N/A
 |  | 33 | EA | PIPE 25NB Light BLK / PTD 6500 | N/A
 |  | 37 | EA | PIPE 25NB Light BLK / PTD 7000 | N/A
 |  | 37 | EA | PIPE 50NB Medium BLK / PTD 6500 | N/A
 |  | 10 | EA | PIPE 50NB Medium BLK / PTD 6500 | N/A
 |  | 9 | EA | PIPE 50NB Medium BLK / PTD 6500 | N/A
 |  | 28 | EA | PIPE 50NB Medium BLK / PTD 6500 | N/A
 |  | 12 | EA | PIPE 65NB Extra Heavy BLK / PTD 6500 | N/A
 |  | 8 | EA | PIPE 65NB Extra Light BLK / PTD 6500 | N/A
 |  | 1 | EA | PIPE 65NB Heavy BLK / PTD 6500 | N/A
 |  | 13 | EA | PIPE 65NB Heavy BLK / PTD 6500 | N/A
 |  | 4 | EA | PIPE 65NB Light BLK / PTD 6500 | N/A
 |  | 5 | EA | PIPE 65NB Medium BLK / PTD 6000 | N/A
 |  | 10 | EA | PIPE 65NB Medium BLK / PTD 6000 | N/A
 |  | 2 | EA | PIPE 65NG Light BLK / PTD 6500 | N/A
 |  | 15 | EA | PIPE 80NB Extra Heavy BLK / PTD 6500 | N/A
 |  | 1 | EA | PIPE 80NB Heavy BLK / PTD 6500 | N/A
 |  | 10 | EA | PIPE 90NB Light BLK / PTD 6500 | N/A
 |  | 7 | EA | PIPE 90NB Medium BLK / PTD 6500 | N/A
 |  | 28 | EA | RHS 100x50x1.6 GAL 8000 | N/A
 |  | 32 | EA | RHS 100x50x1.6 GAL 8000 | N/A
 |  | 32 | EA | RHS 100x50x1.6 GAL 8000 | N/A
 |  | 8 | EA | RHS 100x50x3.0 BLK / PTD 8000 | N/A
 |  | 8 | EA | RHS 100x50x3.0 BLK / PTD 8000 | N/A
 |  | 16 | EA | RHS 100x50x3.0 BLK / PTD 8200 | N/A
 |  | 1 | EA | RHS 125x125x4.0 GAL 8000 | N/A
 |  | 7 | EA | RHS 125x125x5.0 GAL 8000 | N/A
 |  | 4 | EA | RHS 150x100x3.0 GAL 9000 | N/A
 |  | 12 | EA | RHS 150x100x3.0 GAL 9200 | N/A
 |  | 8 | EA | RHS 150x100x3.0 GAL 9200 | N/A
 |  | 12 | EA | RHS 150x50x3.0 BLK / PTD 8000 | N/A
 |  | 16 | EA | RHS 50x50x4.0 GAL 8000 | N/A
 |  | 20 | EA | RHS 50x50x4.0 GAL 8000 | N/A
 |  | 12 | EA | RHS 50x50x5.0 BLK / PTD 8000 | N/A
 |  | 30 | EA | RHS 50x50x5.0 BLK / PTD 8000 | N/A
 |  | 3 | EA | RHS 50x50x5.0 GAL 8000 | N/A
 |  | 9 | EA | RHS 50x50x5.0 GAL 8000 | N/A
 |  | 10 | EA | RHS 50x50x6.0 BLK / PTD 7300 | N/A
 |  | 9 | EA | RHS 50x50x6.0 BLK / PTD 8000 | N/A
 |  | 20 | EA | RHS 65x65x4.0 BLK / PTD 8000 | N/A
 |  | 11 | EA | RHS 65x65x4.0 GAL 8000 | N/A
 |  | 9 | EA | RHS 65x65x4.0 GAL 8000 | N/A
 |  | 19 | EA | RHS 65x65x5.0 BLK / PTD 8000 | N/A
 |  | 1 | EA | RHS 65x65x6.0 BLK / PTD 8000 | N/A
 |  | 20 | EA | RHS 65x65x6.0 BLK / PTD 8000 | N/A
 |  | 20 | EA | RHS 65x65x6.0 BLK / PTD 8000 | N/A
 |  | 12 | EA | RHS 75x50x4.0 BLK / PTD 8000 | N/A
 |  | 9 | EA | RHS 75x50x4.0 BLK / PTD 8000 | N/A
 |  | 13 | EA | RHS 75x50x4.0 GAL 8000 | N/A
 |  | 14 | EA | RHS 75x50x4.0 GAL 8000 | N/A
 |  | 12 | EA | RHS 75x50x4.0 GAL 8000 | N/A
 |  | 7 | EA | RHS 75x75x3.0 BLK / PTD 8000 | N/A
 |  | 15 | EA | RHS 75x75x3.0 BLK / PTD 8000 | N/A
 |  | 16 | EA | RHS 75x75x3.0 GAL 6000 | N/A
 |  | 16 | EA | RHS 75x75x3.0 GAL 6000 | N/A
 |  | 26 | EA | RHS 75x75x3.0 GAL 8000 | N/A
 |  | 4 | EA | RHS 75x75x3.0 GAL 8000 | N/A
 |  | 9 | EA | RHS 75x75x4.0 GAL 8000 | N/A
 |  | 6 | EA | RHS 76x38x2.5 BLK / PTD 8000 | N/A
 |  | 8 | EA | RHS 76x38x2.5 BLK / PTD 8000 | N/A
 |  | 10 | EA | RHS 76x38x4.0 BLK / PTD 8000 | N/A
 |  | 10 | EA | RHS 89x89x5.0 BLK / PTD 8000 | N/A
 |  | 2 | EA | RHS 95x35x2.8 BLK / PTD 8000 | N/A
 |  | 14 | EA | RHS 95x35x2.8 BLK / PTD 8000 | N/A
 |  | 24 | EA | SILO SECTION 75x64x3.0 GAL 12000 | N/A
 |  | 24 | EA | SILO SECTION 75x64x3.0 GAL 12000 | N/A
 |  | 18 | EA | SILO SECTION 75x64x3.0 GAL 12000 | N/A
 |  | 6 | EA | SILO SECTION 75x64x3.0 GAL 12000 | N/A
 | ORRCON 6/5/2022
 | QTY Approx. | Type | Description | Finish | Approximate Length (mm)
1 | 14 | RHS | 50x50x2.5 | GAL | 8000
2 | 13 | RHS | 50x50x2.5 | GAL | 8000
3 | 7 | RHS | 50x50x2.0 | GAL | 8000
4 | 19 | RHS | 50x50x2.0 | GAL | 8000
5 | 2 | RHS | 50x50x2.0 | GAL | 8000
6 | 7 | RHS | 50x50x1.6 | GAL | 8000
7 | 19 | PIPE | 25.4MM Extra Light | GAL | 7000
8 | 3 | RHS | 185x65x3.0 | GAL | 8800
9 | 4 | RHS | 185x65x3.0 | GAL | 8800
10 | 72 | PIPE | 25.4MM Extra Light | GAL | 6100
11 | 12 | PIPE | 80NB Light | GAL | 6500
12 | 16 | RHS | 50x50x1.6 | GAL | 7320
13 | 6 | SILO SECTION | 75x64x3 | GAL | 12000
14 | 12 | RHS | 75x75x4.0 | GAL | 9000
15 | 3 | RHS | 150x100x4.0 | GAL | 9000
16 | 6 | RHS | 50x50x1.6 | GAL | 7200
17 | 64 | RHS | 50x50x1.6 | GAL | 7200
18 | 8 | RHS | 50x50x2.5 | GAL | 7200
19 | 6 | RHS | 185x65x3.0 | GAL | 9700
20 | 14 | RHS | 50x50x1.6 | GAL | 7200
21 | 3 | RHS | 50x50x1.6 | GAL | 7200
22 | 42 | RHS | 50x50x1.6 | GAL | 7200
23 | 14 | RHS | 100x50x1.6 | GAL | 10500
24 | 1 | RHS | 150x100x3 | GAL | 9200
25 | 4 | RHS | 150x100x3 | GAL | 9200
26 | 2 | PIPE | 50NB Light | BLK / PTD | 6500
27 | 6 | RHS | 125x125x5.0 | BLK / PTD | 12000
28 | 10 | PIPE | 80NB Extra Heavy | BLK / PTD | 12000
29 | 1 | RHS | 100NB Extra Heavy | BLK / PTD | 12000
30 | 4 | RHS | 100NB Extra Heavy | BLK / PTD | 12000
31 | 18 | RHS | 50NB Heavy | BLK / PTD | 6500
32 | 6 | RHS | 50NB Heavy | BLK / PTD | 6500
33 | 1 | PIPE | 50NB Medium | BLK / PTD | 6500
34 | 18 | PIPE | 50NB Medium | BLK / PTD | 6500
35 | 1 | PIPE | 50NB Medium | BLK / PTD | 6500
36 | 37 | PIPE | 65NB Medium | BLK / PTD | 6500
37 | 9 | PIPE | 50NB Extra Heavy | BLK / PTD | 6500
38 | 12 | RHS | 75x75x5.0 | BLK / PTD | 12000
39 | 1 | PIPE | 50NB Extra Heavy | BLK / PTD | 6500
40 | 1 | RHS | 185x65x3.0 | BLK / PTD | 7900
1 | 16 | RHS | 100x100x2.5 | GAL | 8000
2 | 50 | RHS | 20x20x1.6 | GAL | 6500
3 | 18 | RHS | 75x75x3.0 | GAL | 9000
4 | 6 | RHS | 185x65x3.0 | GAL | 6300
5 | 8 | RHS | 185x65x3.0 | GAL | 6300
6 | 5 | RHS | 100x100x3.0 | GAL | 12000
7 | 9 | RHS | 150x100x4.0 | GAL | 12000
8 | 8 | CATTLE RAIL | 66x44x1.6 | GAL | 7100
9 | 12 | CATTLE RAIL | 66x44x1.6 | GAL | 8000
10 | 3 | RHS | 89x89x5.0 | GAL | 6000
11 | 12 | RHS | 150x50x2.0 | GAL | 9000
12 | 9 | RHS | 150x50x2.0 | GAL | 9000
13 | 10 | RHS | 150x50x2.0 | GAL | 9000
14 | 6 | RHS | 150x50x5.0 | GAL | 12000
15 | 16 | RHS | 75x50x1.6 | GAL | 12000
16 | 4 | RHS | 89x89x2.0 | GAL | 6000
17 | 64 | RHS | 50x50x2.0 | GAL | 6000
18 | 11 | RHS | 150x50x2.0 | GAL | 8900
19 | 4 | RHS | 150x50x5.0 | GAL | 11800
20 | 28 | RHS | 50x50x2.0 | BLK / PTD | 8000
21 | 64 | RHS | 50x50x2.0 | BLK / PTD | 8000
22 | 4 | RHS | 50x50x2.5 | BLK / PTD | 8000
23 | 32 | RHS | 50x50x2.5 | BLK / PTD | 8000
24 | 4 | RHS | 125x75x4.0 | BLK / PTD | 12000
25 | 15 | RHS | 89x89x3.5 | BLK / PTD | 8000
26 | 8 | RHS | 89x89x6.0 | BLK / PTD | 8000
27 | 8 | RHS | 89x89x6.0 | BLK / PTD | 8000
28 | 4 | RHS | 100x100x6.0 | BLK / PTD | 12000
29 | 2 | RHS | 125x75x5.0 | BLK / PTD | 10000
30 | 7 | RHS | 100x100x3.0 | BLK / PTD | 12000
31 | 5 | RHS | 125x75x4.0 | BLK / PTD | 9000