Spreadsheet: 794101d1661874727-vlookup-with-multiple-conditions-template-update
Sheet: Perf Pricing 

STOCK PART USAGE OVER LAST 360 DAYS |  |  |  |  |  |  |  |  |  |  |  | Site ID: |  | CAGIL |  |  |  |  |  | Printed 8/29/2022,  2:28:30PM
Part Id | Column1 | Material | Column2 | Part Description | WIDTH | LENGTH | Product Code | Commodity Code | AUTO BKFL | Column3 | Last PO Id | Last PO Date | Column4 | Vendor | Column5 | Last Work Order Id | [NAME] | Column6 | Primary Location | Column7 | Column8 | Standard Cost | Column9 | Last Unit Cost | Column10 | Usage | Column11 | Column12 | On Hand | Column13 | On  Order | Column14 | In Demand | Column15 | Released In Demand | Column16 | Planning Lead Time
15-11-60-96-17 |  |  |  | PERF, GALV CT, 16GA X 48 X 144, 23% OA | 48 | 144 | 04 | GALV PERF PANEL | Y |  |  |  |  |  |  |  | STEEL |  | [NAME] |  |  | 0 |  |  |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 63
15-16-48-120-17 |  |  |  | PERF, GNEAL A60, 16GA X 48 X 120, 23% OA | 48 | 120 | 04 | GALV PERF PANEL | Y |  | 170402 | 2021-11-23 00:00:00 |  | ACCURATE |  |  | STEEL |  | SM501-R3-S1 |  |  | 196 |  | 196 |  | 220 |  |  | 74.25 |  | 0 |  | 18 |  | 4 |  | 63
15-16-48-144-17 |  |  |  | PERF, GNEAL A60, 16GA X 48 X 144, 23% OA | 48 | 144 | 04 | GALV PERF PANEL | Y |  | 170589 | 2021-12-07 00:00:00 |  | ACCURATE |  |  | STEEL |  | SM501-R5-S1 |  |  | 235.2 |  | 235.2 |  | 3 |  |  | 59 |  | 0 |  | 0 |  | 0 |  | 63
15-16-60-120-17 |  |  |  | PERF, GNEAL A60, 16GA X 60 X 120, 23% OA | 60 | 120 | 04 | GALV PERF PANEL | Y |  | 170402 | 2021-11-23 00:00:00 |  | ACCURATE |  |  | STEEL |  | [NAME] |  |  | 245 |  | 245 |  | 29 |  |  | 5 |  | 0 |  | 0 |  | 0 |  | 63
15-16-60-144-17 |  |  |  | PERF, GNEAL A60, 16GA X 60 X 144, 23% OA | 60 | 144 | 04 | GALV PERF PANEL | Y |  | 170589 | 2021-12-07 00:00:00 |  | ACCURATE |  |  | STEEL |  | SM501-R6-S1 |  |  | 294 |  | 294 |  | 14 |  |  | 64 |  | 0 |  | 0 |  | 0 |  | 63
15-22-60-96-17 |  |  |  | PERF, GNEAL A60, 22GA X 60 X 96, 23% OA | 60 | 96 | 05 | GALV PERF PANEL | Y |  | 169122 | 2021-08-25 00:00:00 |  | ACCURATE |  |  | STEEL |  | [NAME] |  |  | 101.65 |  | 101.65 |  | 225.4313 |  |  | 216.125 |  | 0 |  | 1.2031 |  | 0.2031 |  | 63
17-16-48-96-17 |  |  |  | PERF, GALV NCT, 16GA X 48 X 96, 23% OA | 48 | 96 | 04 | GALV PERF PANEL | Y |  | 162697 | 2020-07-17 00:00:00 |  | ACCURATE |  |  | STEEL |  | SM501-R1-S4 |  |  | 83.35 |  | 83.35 |  | 25 |  |  | 15 |  | 0 |  | 0 |  | 0 |  | 63
17-16-60-192-17 |  |  |  | PERF, GALV NCT, 16GA X 60 X 192, 23% | 60 | 192 | 04 | GALV PERF PANEL | Y |  | 163187 | 2020-08-19 00:00:00 |  | ACCURATE |  |  | STEEL |  | [NAME] |  |  | 282.85 |  | 282.85 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 63
17-22-48-120-17 |  |  |  | PERF, GALV NCT, 22GA X 48 X 120, 23% | 48 | 120 | 04 | GALV PERF PANEL | Y |  | 170147 | 2021-11-01 00:00:00 |  | ACCURATE |  |  | STEEL |  | [NAME] |  |  | 104.6 |  | 104.6 |  | 73.5 |  |  | 145.5 |  | 0 |  | 21.5 |  | 11.5 |  | 63
17-22-48-144-17 |  |  |  | PERF, GALV NCT, 22GA X 48 X 144, 23% | 48 | 144 | 04 | GALV PERF PANEL | Y |  | 170012 | 2021-10-22 00:00:00 |  | NOISE BARRIERS |  |  | STEEL |  | SM501-R6-S3 |  |  | 139.2 |  | 139.2 |  | 55.25 |  |  | 96 |  | 0 |  | 20 |  | 12 |  | 63
17-22-48-96-17 |  |  |  | PERF, GALV NCT, 22GA X 48 X 96, 23% | 48 | 96 | 04 | GALV PERF PANEL | Y |  | 170590 | 2021-12-07 00:00:00 |  | ACCURATE |  |  | STEEL |  | SM501-R1-S2 |  |  | 72.96 |  | 72.96 |  | 73.75 |  |  | 50.625 |  | 0 |  | 4 |  | 0 |  | 63
17-22-60-144-17 |  |  |  | PERF, GALV NCT, 22GA X 60 X 144, 23% | 60 | 144 | 04 | GALV PERF PANEL | Y |  | 171598 | 2022-03-02 00:00:00 |  | ACCURATE |  |  | STEEL |  | SM501-R6-S6 |  |  | 149.75 |  | 149.75 |  | 86.75 |  |  | 18.25 |  | 0 |  | 1 |  | 1 |  | 63
17-22-60-192-17 |  |  |  | PERF, GALV NCT, 22GA X 60 X 192, 23% | 60 | 192 | 04 | GALV PERF PANEL | Y |  | 164724 | 2020-11-20 00:00:00 |  | ACCURATE |  |  | STEEL |  | SM501-R7-S6 |  |  | 104.3 |  | 104.3 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 63
50-18-60-144-17 |  |  |  | 3003 [NAME] PERF 23% .040 X 60 X 144 | 60 | 144 | 05 | ALUMINIUM | Y |  | 170216 | 2021-11-05 00:00:00 |  | NOISE BARRIERS |  |  | STEEL |  | SM-R3-S5 |  |  | 131 |  | 131 |  | 27.35 |  |  | 11.75 |  | 0 |  | 0 |  | 0 |  | 63