Spreadsheet: 598731d1542682175-is-delivery-date-within-agreed-reference-date-or-not-is-firm-eta-within-referene-eta-or-not
Sheet: Sheet1

RM Part Number | RM Description | NA1 | Vendor | NA2 | NA3 | NA4 | NA5 | NA6 | NA7 | NA8 | NA9 | NA10 | NA11 | NA12 | NA13 | NA14 | Firm ETA DATE 1 | Firm ETA QTY 1 | Firm ETA DATE 2 | Firm ETA QTY 2 | Firm ETA DATE 3 | Firm ETA QTY 3 | Firm ETA DATE 4 | Firm ETA QTY 4 | Firm ETA DATE 5 | Firm ETA QTY 5 | NA23 | NA24 | NA25 | NA26 | NA27 | NA28 | Ref. ETA DATE 1 | Ref. ETA QTY 1 | Ref. ETA DATE 2 | Ref. ETA QTY 2 | Ref. ETA DATE 3 | Ref. ETA QTY 3 | Ref. ETA DATE 4 | Ref. ETA QTY 4 | Ref. ETA DATE 5 | Ref. ETA QTY 5 | NA29 | Valitation ETA DATE 1 | Valitation ETA QTY 1 | Valitation ETA DATE 2 | Valitation ETA QTY 2 | Valitation ETA DATE 3 | Valitation ETA QTY 3 | Valitation ETA DATE 4 | Valitation ETA QTY 4 | Valitation ETA DATE 5 | Valitation ETA QTY 5
Part Number_1 | Description_1 |  | Vendor_1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-31 00:00:00 | 2160 | 2019-01-07 00:00:00 | 1350 | 2019-01-23 00:00:00 | 230 |  |  |  |  |  |  |  |  |  |  | 2018-12-27 00:00:00 | 540 | 2018-12-31 00:00:00 | 1350 | 2019-01-10 00:00:00 | 500 | 2019-01-21 00:00:00 | 1350
Part Number_2 | Description_2 |  | Vendor_2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-12 00:00:00 | 45000 | 2018-11-15 00:00:00 | 9000 | 2018-11-19 00:00:00 | 26000 | 2018-12-05 00:00:00 | 34440 | 2019-01-05 00:00:00 | 29560 |  |  |  |  |  |  | 2018-10-20 00:00:00 | 45000 | 2018-10-22 00:00:00 | 9000 | 2018-11-13 00:00:00 | 63000 | 2018-11-17 00:00:00 | 9000 | 2018-11-27 00:00:00 | 18000
Part Number_3 | Description_3 |  | Vendor_3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-11 00:00:00 | 60000 | 2018-10-19 00:00:00 | 414000 | 2018-10-24 00:00:00 | 36000 | 2018-10-30 00:00:00 | 36000 | 2018-11-19 00:00:00 | 12000
Part Number_4 | Description_4 |  | Vendor_4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-15 00:00:00 | 669000 | 2019-12-15 00:00:00 | 1338000 | 2019-01-15 00:00:00 | 1338000 | 2019-01-21 00:00:00 | 103000 |  |  |  |  |  |  |  |  | 2018-09-06 00:00:00 | 584000 | 2018-09-21 00:00:00 | 344000 | 2018-10-05 00:00:00 | 440000 | 2018-11-01 00:00:00 | 1808000 | 2018-11-21 00:00:00 | 272000
Part Number_5 | Description_5 |  | Vendor_5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-09 00:00:00 | 4500 | 2018-11-14 00:00:00 | 2000 | 2018-11-26 00:00:00 | 3000 | 2018-12-11 00:00:00 |  |  |  |  |  |  |  |  |  | 2018-10-09 00:00:00 | 1500 | 2018-10-18 00:00:00 | 5500 | 2018-10-24 00:00:00 | 500 | 2018-10-30 00:00:00 | 1500 | 2018-11-02 00:00:00 | 2500
Part Number_6 | Description_6 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-05 00:00:00 | 124000 | 2019-12-15 00:00:00 | 43000 |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-23 00:00:00 | 48000 | 2018-11-02 00:00:00 | 28000 | 2018-11-09 00:00:00 | 14000 | 2018-11-26 00:00:00 | 14000 | 2018-11-30 00:00:00 | 63000
Part Number_7 | Description_7 |  | Vendor_7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-05 00:00:00 | 100000 | 2018-11-30 00:00:00 | 31000 | 2019-12-18 00:00:00 | 130000 |  |  |  |  |  |  |  |  |  |  | 2018-10-23 00:00:00 | 81000 | 2018-11-02 00:00:00 | 20000 | 2018-11-26 00:00:00 | 20000 | 2018-11-30 00:00:00 | 60000 | 2018-12-18 00:00:00 | 80000
Part Number_8 | Description_8 |  | Vendor_8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-26 00:00:00 | 8000 | 2018-12-13 00:00:00 | 10000 | 2019-01-13 00:00:00 | 23150.12 |  |  |  |  |  |  |  |  |  |  | 2018-09-27 00:00:00 | 50 | 2018-10-01 00:00:00 | 3600.12 | 2018-11-19 00:00:00 | 7500 | 2018-12-05 00:00:00 | 21000 | 2018-12-24 00:00:00 | 9000
Part Number_9 | Description_9 |  | Vendor_9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-16 00:00:00 | 1500 | 2018-12-14 00:00:00 | 1000 | 2019-01-05 00:00:00 | 3900 |  |  |  |  |  |  |  |  |  |  | 2018-10-04 00:00:00 | 200 | 2018-11-07 00:00:00 | 2700 | 2018-11-26 00:00:00 | 1000 | 2018-12-12 00:00:00 | 1500 | 2018-12-31 00:00:00 | 1000
Part Number_10 | Description_10 |  | Vendor_10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-05 00:00:00 | 20000 | 2018-11-12 00:00:00 | 28000 | 2018-12-10 00:00:00 | 36000 | 2019-01-10 00:00:00 | 5000 | 2019-01-18 00:00:00 | 5000 |  |  |  |  |  |  | 2018-10-16 00:00:00 | 14000 | 2018-10-25 00:00:00 | 32000 | 2018-10-30 00:00:00 | 18000 | 2018-11-07 00:00:00 | 28000 | 2018-11-13 00:00:00 | 2000
Part Number_11 | Description_11 |  | Vendor_11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-30 00:00:00 | 3000 | 2018-12-05 00:00:00 | 12000 | 2019-12-15 00:00:00 | 14000 | 2018-12-29 00:00:00 | 18000 | 2018-01-05 00:00:00 | 12500 |  |  |  |  |  |  | 2017-11-03 00:00:00 | 7000 | 2018-11-09 00:00:00 | 24500 | 2018-11-23 00:00:00 | 7000 | 2018-11-26 00:00:00 | 14000 | 2018-11-29 00:00:00 | 7000
Part Number_12 | Description_12 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-31 00:00:00 | 2160 | 2019-01-07 00:00:00 | 1350 | 2019-01-14 00:00:00 | 4500 | 2019-01-19 00:00:00 | 3750 |  |  |  |  |  |  |  |  | 2018-08-23 00:00:00 | 490 | 2018-09-20 00:00:00 | 3430 | 2018-10-23 00:00:00 | 1960 | 2018-10-25 00:00:00 | 1960 | 2018-11-02 00:00:00 | 3920
Part Number_13 | Description_13 |  | Vendor_13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-22 00:00:00 | 440000 | 2018-11-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-08-31 00:00:00 | 200000 | 2018-10-16 00:00:00 | 120000 | 2018-11-02 00:00:00 | 80000 | 2018-11-06 00:00:00 | 50000 | 2018-11-09 00:00:00 | 30000
Part Number_14 | Description_14 |  | Vendor_14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-31 00:00:00 | 4000 | 2018-11-12 00:00:00 | 11000 | 2018-11-16 00:00:00 | 8000 | 2018-12-19 00:00:00 | 4000 |  |  |  |  |  |  |  |  | 2018-09-06 00:00:00 | 7000 | 2018-09-25 00:00:00 | 2000 | 2018-10-05 00:00:00 | 2000 | 2018-10-09 00:00:00 | 2000 | 2018-10-16 00:00:00 | 14000
Part Number_15 | Description_15 |  | Vendor_15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-23 00:00:00 | 7978 | 2018-11-16 00:00:00 | 12000 | 2019-12-09 00:00:00 | 3022 |  |  |  |  |  |  |  |  |  |  | 2018-08-31 00:00:00 | 7000 | 2018-10-04 00:00:00 | 6000 | 2018-11-02 00:00:00 | 1000 | 2018-11-06 00:00:00 | 1000 | 2018-11-20 00:00:00 | 8000
Part Number_16 | Description_16 |  | Vendor_16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-31 00:00:00 | 90000 | 2018-11-25 00:00:00 | 250000 | 2018-12-05 00:00:00 | 100000 | 2019-12-29 00:00:00 | 48000 |  |  |  |  |  |  |  |  | 2018-09-06 00:00:00 | 96000 | 2018-10-19 00:00:00 | 168000 | 2018-10-23 00:00:00 | 104000 | 2018-10-25 00:00:00 | 24000 | 2018-10-30 00:00:00 | 96000
Part Number_17 | [NAME] |  | Vendor_17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-10-31 00:00:00 | 92000 | 2018-11-14 00:00:00 | 40000 | 2018-11-19 00:00:00 | 100000 | 2018-12-19 00:00:00 | 100000 | 2019-01-05 00:00:00 | 128000 |  |  |  |  |  |  | 2018-10-16 00:00:00 | 92000 | 2018-10-25 00:00:00 | 161000 | 2018-10-30 00:00:00 | 69000 | 2018-11-07 00:00:00 | 115000 | 2018-11-20 00:00:00 | 23000
Part Number_18 | Description_18 |  | Vendor_18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-09 00:00:00 | 12000 | 2018-11-30 00:00:00 | 24000 | 2018-12-05 00:00:00 | 54000 |  |  |  |  |  |  |  |  |  |  | 2018-09-21 00:00:00 | 18000 | 2018-09-29 00:00:00 | 12000 | 2018-10-03 00:00:00 | 12000 | 2018-11-02 00:00:00 | 12000 | 2018-12-06 00:00:00 | 36000
Part Number_19 | Description_19 |  | Vendor_19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018-11-09 00:00:00 | 480000 | 2018-12-31 00:00:00 | 384000 | 2019-01-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2018-09-21 00:00:00 | 288000 | 2018-09-29 00:00:00 | 384000 | 2018-10-03 00:00:00 | 192000 | 2018-10-29 00:00:00 | 768000 | 2018-11-02 00:00:00 | 288000