Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Pacing In Progress - Finance

Quarter | 3
Shipment Value (USD) |  |  |  |  |  |  |  | Pacing Risk
Region | Mode of Transport | ETA SA | Power Station | Shipment Status | WBS | Delivery Note | Eskom Customer PO | (blank) | [NAME] | Cash In | Grand Total
France | AIR | 2020-09-11 00:00:00 | Matimba | Eskom : In Transit | ES0-473267 | 80605409 | 4502932980 |  |  | 17875.2 | 17875.2
France | AIR | (blank) | Lethabo | Eskom : Awaiting CFA Collection | ES0-473200 | 80605495 | 4502919272 | 216660.9984 |  |  | 216660.9984
France | AIR |  | Matla | Eskom : Await Shipment docs & POD | ES0-473221 | PKL 104246 | 4502914286 |  |  | 12185.6 | 12185.6
France | SEA | 2020-10-16 00:00:00 | Lethabo | Eskom : In Transit | ES0-473201 | S809248/203169 | 4502920041 |  |  | 1059394.56 | 1059394.56
France | SEA |  | Lethabo | Eskom : In Transit | ES0-473201 | S809248/203169-1 | 4502920041 |  |  | 6627.040000000001 | 6627.040000000001
France | (blank) | TBA | Koeberg | Eskom : Await Transport PO | ES0-473163 | PKL 104545 | 4502904020 |  | 162400 |  | 162400
Germany | AIR | 2020-09-12 00:00:00 | [NAME] | Eskom : In Transit | ES0-473398 | 80605925 | 4502965759 |  |  | 4773.2832 | 4773.2832
Germany | AIR |  | [NAME] | Eskom : In Transit | ES0-473398 | 80605544 | 4502965759 |  |  | 10444.9184 | 10444.9184
Germany | AIR | 2020-09-16 00:00:00 | [NAME] | Eskom : In Transit | ES0-473401 | 80606057 | 4502965768 |  |  | 49640.4608 | 49640.4608
Germany | AIR |  | [NAME] | Eskom : In Transit | ES0-473412 | 80605236 | 4502968300 |  |  | 8363.04 | 8363.04
Germany | AIR |  | [NAME] | Eskom : In Transit | ES0-473399 | 80605130 | 4502965640 |  | 36943.84960000001 |  | 36943.84960000001
Germany | AIR |  | [NAME] | Eskom : In Transit | ES0-473398 | 80605188 | 4502965759 |  |  | 83454.91840000001 | 83454.91840000001
Germany | AIR |  | Lethabo | Eskom : In Transit | ES0-472883 | 80606911 | 4502832348 |  |  | 1385.216 | 1385.216
Germany | AIR |  | Medupi | Eskom : In Transit | ES0-473420 | 80603692 | 4502968300 |  |  | 719.0400000000001 | 719.0400000000001
Germany | AIR |  | Medupi | Eskom : In Transit | ES0-473420 |  | 4502972251 |  |  | 2580.48 | 2580.48
Germany | AIR |  | Medupi | Eskom : In Transit | ES0-473420 | 80603288 | 4502968300 |  |  | 2580.48 | 2580.48
Germany | AIR |  | Medupi | Eskom : In Transit | ES0-473355 | 80606387 | 4502960903 |  |  | 132814.08 | 132814.08
Germany | AIR |  | Medupi | Eskom : In Transit | ES0-473454 | 80606754 | 4502984409 |  |  | 198.24 | 198.24
Germany | AIR | 2020-09-19 00:00:00 |  |  |  |  |  |  |  | 141359.3664 | 141359.3664
Germany | (blank) | TBA | [NAME] | Eskom : Await Transport PO | ES0-473399 | 80607698 | 4502965640 |  | 105315.3472 |  | 105315.3472
UK | AIR | 2020-09-09 00:00:00 | Duvha | Eskom : Await Shipment docs & POD | ES0-473252 | 80606348 | 4502914768 |  |  | 109319.2251 | 109319.2251
UK | AIR |  | Duvha | Eskom : In Transit | ES0-473337 | 80606909 | 4502952662 |  |  | 239900.1425 | 239900.1425
UK | AIR |  | Duvha | Eskom : In Transit | ES0-473297 | 80607047 | 4502932519 |  |  | 0 | 0
UK | AIR |  | Duvha | Eskom : In Transit | ES0-473251 | 80607266 | 4502854881 |  |  | 36664.9 | 36664.9
Grand Total |  |  |  |  |  |  |  | 216660.9984 | 304659.1968 | 1920280.1908 | 2441600.386