Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Part Shipment - Parts Query

 |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  |  |  |  |  | * |  | * |  |  |  |  |  |  | * | * |  |  |  | * | * | * | * | * |  | * | * | * |  |  | * |  |  |  |  |  |  |  |  |  | * | * | * | * | * | * | * | * |  | * | * | * | * | * | * | * | *
 |  | CENTRE OF EXCELLENCE (COE) - OFF SHORE SUPPLIERS |  |  |  |  |  |  | PACING & LOGISTICS TEAM - SA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PARTS FULFILMENT - SA |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GE Status |  |  | LOGISTIC LEAD TIMES
No | Shipment Readiness - GESA Notified | [NAME] | GESA PO Line | Eskom PO Line | GESA PO | Shipment Value (GBP) | Shipment Value (EUR) | Shipment Value (USD) | Shipment Status | Region | Power Station | Eskom Customer PO | Eskom End User | Delivery Note | Weight - Kg | EUR 1 Available | EUR 1 Review | Date : Sent to ITR Manager (Shipment Readiness) | Date : Sent to Eskom | Week | WBS | Actual Collection Date - Ex Works | Actual Date - Shipment docs received | Actual Date - Sent to Part team | Pacing Risk | Quarter | Invoice Approval Status (ITR Manager) | Actual Date - Invoice Approval (ITR Manager) | Actual Approval Date - Status | Ageing | Actual Date - GRN | Actual Date - Rev Req (ITR Manager) | Actual Date - Invoice Request (ITR Manager) | Region | Power Station | Eskom Customer PO | Delivery note | Weight - Kg | EUR 1 Available | EUR 1 Review | Shipment Value - County Currency | Shipment Value - USD | Pacing Risk | Date : REQ PO from End-User | Eskom End User | PO Date | PO Number - Transport | Date : Instruction to CFA | CFA | COE Notified- Customs | Planned Date - Collection | Mode of Transport | ETA SA | GE Comments | GESA Notification - Eskom (Days) | GESA Notification - Eskom Status | CoE Notified- Actual collection (Days) | CoE - Actual collection (Status) | CoE - Actual collection (Age Analysis) | Eskom Notified-Actual collection(Days) | Eskom Notified- Actual collection (Status) | Days - Notification to Customer | Days - Notification to Customer - Networkday | Eskom - Actual collection (Status) | Eskom - Actual collection (Age Analysis) | Shipment Value (GBP to USD) | Shipment Value (EUR to USD) | Shipment Value (GBP to USD) | Shipment Value (EUR to USD) | Shipment Value (USD) | CSL
1 | 2018-02-02 00:00:00 | 180063 |  |  | 4101482854 |  | 68368 |  | GE : Parts Query | France | Lethabo |  | [NAME] | 80441419 | 176 | No | Copy Attached |  | Not Sent as yet |  | EE0-470199 | Not Collected |  |  |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No date confirmed |  | No PO |  | No date confirmed |  |  |  |  |  | Riaan to advice
2 | 2018-04-06 00:00:00 | 180063 |  |  | 4101482854 |  | 38549.75 |  | GE : Parts Query | France | Lethabo |  |  | 80437995 | 779 | No |  |  | Not Sent as yet |  | EE0-470200 | Not Collected |  |  |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No date confirmed |  | No PO |  | No date confirmed |  |  |  |  |  | Riaan to advice
3 | 2020-01-16 00:00:00 | 30066403 |  |  | 4200149276 | 150441 |  |  | GE : Parts Query | UK | [NAME] | 3070352735 | [NAME] | 80591919 | 4 | No |  | 2020-01-17 00:00:00 | 2020-01-20 00:00:00 |  | ES0-472368 | Not Collected |  |  | [NAME] | 2 | YES | 2020-01-27 00:00:00 |  |  | 2020-01-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-30 00:00:00 |  | 2020-04-01 00:00:00 | 4502961904 | 2020-04-01 00:00:00 | BPL |  |  | AIR |  | The item will be collected once the whole order is ready estimated September 2020
4 | 2020-02-17 00:00:00 | 499208 |  |  | 4200181017 |  | 54388 |  | GE : Parts Query | Germany | Arnot | AR |  | 80594149 | 67 | Yes |  | 2020-02-17 00:00:00 | 2020-02-17 00:00:00 |  | ES0-473158 | Not Collected |  |  |  |  | NO | Not Sent as yet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No date confirmed |  | No PO |  | No date confirmed |  |  |  |  |  | [NAME], waiting for Customer PO
5 | 2020-02-21 00:00:00 |  |  |  | 4200177034 |  | 18834 |  | GE : Parts Query | France | Koeberg | 4502889807 | Ayanda Alistair Ramokolo | 80588751 | 25 | No |  | 2020-02-24 00:00:00 | 2020-02-24 00:00:00 |  | ES0-473120 | Not Collected |  |  |  |  | YES | 2020-02-24 00:00:00 |  |  | 2019-11-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | No date confirmed |  | No PO |  | No date confirmed |  |  |  | AIR |  | Parts are not yet ready
6 | 2020-05-15 00:00:00 | 518725 |  |  | 7200001014 |  | 14352 |  | GE : Parts Query | Germany | Arnot | AR |  | 80600271 | 87 | Yes | Copy Attached | 2020-05-15 00:00:00 | 2020-05-18 00:00:00 |  | ES0-473158 | Not Collected |  |  |  |  | YES | 2020-05-15 00:00:00 |  |  | 2020-05-15 00:00:00
7 | 2020-05-27 00:00:00 | 516582 |  |  | 7200000812 |  | 45696 |  | GE : Parts Query | Germany | Arnot | AR |  | 80600559 | 228 | No | No Preferential Origin | 2020-05-27 00:00:00 | Not Sent as yet |  | ES0-473339 | Not Collected |  |  |  |  | YES | 2020-05-27 00:00:00 |  |  | 2020-05-27 00:00:00
8 | 2020-07-21 00:00:00 | 511443 |  |  | 7200000066 |  | 873838 |  | GE : Parts Query | Germany | Matla | 4502914286 |  | 80603714 | 2841 |  |  | 2020-07-22 00:00:00 | not sent |  | ES0-473221 | Not Collected |  |  |  |  | YES | 2020-07-22 00:00:00 |  |  | 2020-07-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Waiting for PO amendment from the station
9 | 2020-10-01 00:00:00 | 528939 |  |  | 7200002324 |  | 16025 |  | GE : Parts Query | Germany | Arnot | AR |  | 80610229 | 34 | No | No Preferential Origin | 2020-10-01 00:00:00 | not sent |  | ES0-473531 | Not Collected | Not Delivered
10 | 2020-10-01 00:00:00 | 528939 |  |  | 7200002324 |  |  |  | GE : Parts Query | Germany | Arnot | AR |  | 80609755 | 36 | No | No Preferential Origin | 2020-10-01 00:00:00 | not sent |  | ES0-473531 | Not Collected | Not Delivered