Spreadsheet: 83654d1283636756-lookup-formula-testlog2
Sheet: Sheet1

Day | No | [NAME] | Vehicle Destination | Sched Dep | Total Pallets | Actual Dep
Sunday | 1 | C | Post Services Ist Edition | 23:07:00 | 5 | 23:10:16
 | 2 | T | Newton Abbot/Plymouth | 23:09:00
 | 3 | T | Poly Bulk 1 | 23:12:00
 | 4 | T | Bodmin/Redruth | 23:13:00
 | 5 | C | Higgs | 23:17:00
 | 6 | C | Swansea | 23:25:00
 | 7 | T | Taunton | 23:32:00
 | 8 | T | South Coast/IOW | 23:34:00
 | 9 | C | Reeds | 23:35:00
 | 10 | C | Dover Docks | 23:37:00
 | 11 | C | Stevenage Early | 23:40:00
 | 12 | C | Newsflash 1 | 23:50:00
 | 13 | C | Newsflash 2 | 23:50:00
 | 14 | C | Newsflash 3 | 23:50:00
 | 15 | C | Newsflash 4 | 23:50:00
 | 16 | C | Gloucester/Hereford | 23:56:00
 | 17 | T | MOM | 00:01:00
 | 18 | C | Swindon/Bristol | 00:02:00
 | 19 | C | OCS Millwall | 00:03:00
 | 20 | C | OCS Heathrow | 00:03:00
 | 21 | C | Night Sales | 00:06:00
 | 22 | C | [NAME] | 00:08:00
 | 23 | C | [NAME] | 00:10:00
 | 24 | C | RMS Hotels | 00:12:00
 | 25 | C | Newport | 00:14:00
 | 26 | S | Leicester/Coventry | 00:19:00
 | 27 | S | Wednesbury | 00:26:00
 | 28 | C | [NAME] | 00:28:00
 | 29 | S | [NAME] | 00:31:00
 | 30 | C | [NAME] | 00:35:00
 | 31 | C | Newmarket/Ipswich | 00:40:00
 | 32 | C | Peterborough/[NAME] | 00:43:00
 | 33 | C | [NAME] | 00:50:00
 | 34 | C | Oxford | 01:28:00
 | 35 | C | Crawley/Lancing | 01:35:00
 | 36 | C | Heathrow/Slough | 02:08:00
 | 37 | T | Reading | 02:15:00
 | 38 | C | Harlow/Chelmsford | 02:35:00
 | 39 | C | Grays Collect | 02:36:00
 | 40 | C | Weybridge | 02:41:00
 | 41 | C | Stevenage | 02:45:00
 | 42 | C | Borehamwood | 03:02:00
 | 43 | C | Grays | 03:08:00
 | 44 | C | Postal Services | 04:00:00
 | 45 |  |  |  | #N/A | #N/A
 | 46 |  |  |  | #N/A | #N/A
 | 47 |  |  |  | #N/A | #N/A
 | 48 |  |  |  | #N/A | #N/A
 | 49 |  |  |  | #N/A | #N/A
 | 50 |  |  |  | #N/A | #N/A
 | 51 |  |  |  | #N/A | #N/A
 | 52 |  |  |  | #N/A | #N/A
 | 53 |  |  |  | #N/A | #N/A
 | 54 |  |  |  | #N/A | #N/A
 | 55 |  |  |  | #N/A | #N/A
 | 56 |  |  |  | #N/A | #N/A
 | 57 |  |  |  | #N/A | #N/A
 | 58 |  |  |  | #N/A | #N/A
 | 59 |  |  |  | #N/A | #N/A
 | 60 |  |  |  | #N/A | #N/A
 | 61 |  |  |  | #N/A | #N/A
 | 62 |  |  |  | #N/A | #N/A
 | 63 |  |  |  | #N/A | #N/A
 | 64 |  |  |  | #N/A | #N/A
 | 65 |  |  |  | #N/A | #N/A
Monday | 1 | C | Post Services Ist Edition | 23:07:00
 | 2 | T | Newton Abbot/Plymouth | 23:09:00
 | 3 | T | Poly Bulk 1 | 23:12:00
 | 4 | T | Bodmin/Redruth | 23:13:00
 | 5 | C | Higgs | 23:17:00
 | 6 | C | Swansea | 23:25:00
 | 7 | T | Taunton | 23:32:00
 | 8 | T | South Coast/IOW | 23:34:00
 | 9 | C | Reeds | 23:35:00
 | 10 | C | Dover Docks | 23:37:00
 | 11 | C | Stevenage Early | 23:40:00
 | 12 | C | Newsflash 1 | 23:50:00
 | 13 | C | Newsflash 2 | 23:50:00
 | 14 | C | Newsflash 3 | 23:50:00
 | 15 | C | Newsflash 4 | 23:50:00
 | 16 | C | Gloucester/Hereford | 23:56:00
 | 17 | T | MOM | 00:01:00
 | 18 | C | Swindon/Bristol | 00:02:00
 | 19 | C | OCS Millwall | 00:03:00
 | 20 | C | OCS Heathrow | 00:03:00
 | 21 | C | Night Sales | 00:06:00
 | 22 | C | [NAME] | 00:08:00
 | 23 | C | [NAME] | 00:10:00
 | 24 | C | RMS Hotels | 00:12:00
 | 25 | C | Newport | 00:14:00
 | 26 | S | Leicester/Coventry | 00:19:00
 | 27 | S | Wednesbury | 00:26:00
 | 28 | C | [NAME] | 00:28:00
 | 29 | S | [NAME] | 00:31:00
 | 30 | C | [NAME] | 00:35:00
 | 31 | C | Newmarket/Ipswich | 00:40:00
 | 32 | C | Peterborough/[NAME] | 00:43:00
 | 33 | C | [NAME] | 00:50:00
 | 34 | C | Oxford | 01:28:00
 | 35 | C | Crawley/Lancing | 01:35:00
 | 36 | C | Heathrow/Slough | 02:08:00
 | 37 | T | Reading | 02:15:00
 | 38 | C | Harlow/Chelmsford | 02:35:00
 | 39 | C | Grays Collect | 02:36:00
 | 40 | C | Weybridge | 02:41:00
 | 41 | C | Stevenage | 02:45:00
 | 42 | C | Borehamwood | 03:02:00
 | 43 | C | Grays | 03:08:00
 | 44 | C | Postal Services | 04:00:00
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
Tuesday | 1 | C | Post Services Ist Edition | 23:07:00
 | 2 | T | Newton Abbot/Plymouth | 23:09:00
 | 3 | T | Poly Bulk 1 | 23:12:00
 | 4 | T | Bodmin/Redruth | 23:13:00
 | 5 | C | Higgs | 23:17:00
 | 6 | C | Swansea | 23:25:00
 | 7 | T | Taunton | 23:32:00
 | 8 | T | South Coast/IOW | 23:34:00
 | 9 | C | Reeds | 23:35:00
 | 10 | C | Dover Docks | 23:37:00
 | 11 | C | Stevenage Early | 23:40:00
 | 12 | C | Newsflash 1 | 23:50:00
 | 13 | C | Newsflash 2 | 23:50:00
 | 14 | C | Newsflash 3 | 23:50:00
 | 15 | C | Newsflash 4 | 23:50:00
 | 16 | C | Gloucester/Hereford | 23:56:00
 | 17 | T | MOM | 00:01:00
 | 18 | C | Swindon/Bristol | 00:02:00
 | 19 | C | OCS Millwall | 00:03:00
 | 20 | C | OCS Heathrow | 00:03:00
 | 21 | C | Night Sales | 00:06:00
 | 22 | C | [NAME] | 00:08:00
 | 23 | C | [NAME] | 00:10:00
 | 24 | C | RMS Hotels | 00:12:00
 | 25 | C | Newport | 00:14:00
 | 26 | S | Leicester/Coventry | 00:19:00
 | 27 | S | Wednesbury | 00:26:00
 | 28 | C | [NAME] | 00:28:00
 | 29 | S | [NAME] | 00:31:00
 | 30 | C | [NAME] | 00:35:00
 | 31 | C | Newmarket/Ipswich | 00:40:00
 | 32 | C | Peterborough/[NAME] | 00:43:00
 | 33 | C | [NAME] | 00:50:00
 | 34 | C | Oxford | 01:28:00
 | 35 | C | Crawley/Lancing | 01:35:00
 | 36 | C | Heathrow/Slough | 02:08:00
 | 37 | T | Reading | 02:15:00
 | 38 | C | Harlow/Chelmsford | 02:35:00
 | 39 | C | Grays Collect | 02:36:00
 | 40 | C | Weybridge | 02:41:00
 | 41 | C | Stevenage | 02:45:00
 | 42 | C | Borehamwood | 03:02:00
 | 43 | C | Grays | 03:08:00
 | 44 | C | Postal Services | 04:00:00
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
Wednesday | 1 | C | Post Services Ist Edition | 23:07:00
 | 2 | T | Newton Abbot/Plymouth | 23:09:00
 | 3 | T | Poly Bulk 1 | 23:12:00
 | 4 | T | Bodmin/Redruth | 23:13:00
 | 5 | C | Higgs | 23:17:00
 | 6 | C | Swansea | 23:25:00
 | 7 | T | Taunton | 23:32:00
 | 8 | T | South Coast/IOW | 23:34:00
 | 9 | C | Reeds | 23:35:00
 | 10 | C | Dover Docks | 23:37:00
 | 11 | C | Stevenage Early | 23:40:00
 | 12 | C | Newsflash 1 | 23:50:00
 | 13 | C | Newsflash 2 | 23:50:00
 | 14 | C | Newsflash 3 | 23:50:00
 | 15 | C | Newsflash 4 | 23:50:00
 | 16 | C | Gloucester/Hereford | 23:56:00
 | 17 | T | MOM | 00:01:00
 | 18 | C | Swindon/Bristol | 00:02:00
 | 19 | C | OCS Millwall | 00:03:00
 | 20 | C | OCS Heathrow | 00:03:00
 | 21 | C | Night Sales | 00:06:00
 | 22 | C | [NAME] | 00:08:00
 | 23 | C | [NAME] | 00:10:00
 | 24 | C | RMS Hotels | 00:12:00
 | 25 | C | Newport | 00:14:00
 | 26 | S | Leicester/Coventry | 00:19:00
 | 27 | S | Wednesbury | 00:26:00
 | 28 | C | [NAME] | 00:28:00
 | 29 | S | [NAME] | 00:31:00
 | 30 | C | [NAME] | 00:35:00
 | 31 | C | Newmarket/Ipswich | 00:40:00
 | 32 | C | Peterborough/[NAME] | 00:43:00
 | 33 | C | [NAME] | 00:50:00
 | 34 | C | Oxford | 01:28:00
 | 35 | C | Crawley/Lancing | 01:35:00
 | 36 | C | Heathrow/Slough | 02:08:00
 | 37 | T | Reading | 02:15:00
 | 38 | C | Harlow/Chelmsford | 02:35:00
 | 39 | C | Grays Collect | 02:36:00
 | 40 | C | Weybridge | 02:41:00
 | 41 | C | Stevenage | 02:45:00
 | 42 | C | Borehamwood | 03:02:00
 | 43 | C | Grays | 03:08:00
 | 44 | C | Postal Services | 04:00:00
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
Thursday | 1 | C | Post Services Ist Edition | 23:07:00
 | 2 | T | Newton Abbot/Plymouth | 23:09:00
 | 3 | T | Poly Bulk 1 | 23:12:00
 | 4 | T | Bodmin/Redruth | 23:13:00
 | 5 | C | Higgs | 23:17:00
 | 6 | C | Swansea | 23:25:00
 | 7 | T | Taunton | 23:32:00
 | 8 | T | South Coast/IOW | 23:34:00
 | 9 | C | Reeds | 23:35:00
 | 10 | C | Dover Docks | 23:37:00
 | 11 | C | Stevenage Early | 23:40:00
 | 12 | C | Newsflash 1 | 23:50:00
 | 13 | C | Newsflash 2 | 23:50:00
 | 14 | C | Newsflash 3 | 23:50:00
 | 15 | C | Newsflash 4 | 23:50:00
 | 16 | C | Gloucester/Hereford | 23:56:00
 | 17 | T | MOM | 00:01:00
 | 18 | C | Swindon/Bristol | 00:02:00
 | 19 | C | OCS Millwall | 00:03:00
 | 20 | C | OCS Heathrow | 00:03:00
 | 21 | C | Night Sales | 00:06:00
 | 22 | C | [NAME] | 00:08:00
 | 23 | C | [NAME] | 00:10:00
 | 24 | C | RMS Hotels | 00:12:00
 | 25 | C | Newport | 00:14:00
 | 26 | S | Leicester/Coventry | 00:19:00
 | 27 | S | Wednesbury | 00:26:00
 | 28 | C | [NAME] | 00:28:00
 | 29 | S | [NAME] | 00:31:00
 | 30 | C | [NAME] | 00:35:00
 | 31 | C | Newmarket/Ipswich | 00:40:00
 | 32 | C | Peterborough/[NAME] | 00:43:00
 | 33 | C | [NAME] | 00:50:00
 | 34 | C | Oxford | 01:28:00
 | 35 | C | Crawley/Lancing | 01:35:00
 | 36 | C | Heathrow/Slough | 02:08:00
 | 37 | T | Reading | 02:15:00
 | 38 | C | Harlow/Chelmsford | 02:35:00
 | 39 | C | Grays Collect | 02:36:00
 | 40 | C | Weybridge | 02:41:00
 | 41 | C | Stevenage | 02:45:00
 | 42 | C | Borehamwood | 03:02:00
 | 43 | C | Grays | 03:08:00
 | 44 | C | Postal Services | 04:00:00
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
Friday | 1 | C | Post Services Ist Edition | 23:07:00
 | 2 | T | Newton Abbot/Plymouth | 23:09:00
 | 3 | T | Poly Bulk 1 | 23:12:00
 | 4 | T | Bodmin/Redruth | 23:13:00
 | 5 | C | Higgs | 23:17:00
 | 6 | C | Swansea | 23:25:00
 | 7 | T | Taunton | 23:32:00
 | 8 | T | South Coast/IOW | 23:34:00
 | 9 | C | Reeds | 23:35:00
 | 10 | C | Dover Docks | 23:37:00
 | 11 | C | Stevenage Early | 23:40:00
 | 12 | C | Newsflash 1 | 23:50:00
 | 13 | C | Newsflash 2 | 23:50:00
 | 14 | C | Newsflash 3 | 23:50:00
 | 15 | C | Newsflash 4 | 23:50:00
 | 16 | C | Gloucester/Hereford | 23:56:00
 | 17 | T | MOM | 00:01:00
 | 18 | C | Swindon/Bristol | 00:02:00
 | 19 | C | OCS Millwall | 00:03:00
 | 20 | C | OCS Heathrow | 00:03:00
 | 21 | C | Night Sales | 00:06:00
 | 22 | C | [NAME] | 00:08:00
 | 23 | C | [NAME] | 00:10:00
 | 24 | C | RMS Hotels | 00:12:00
 | 25 | C | Newport | 00:14:00
 | 26 | S | Leicester/Coventry | 00:19:00
 | 27 | S | Wednesbury | 00:26:00
 | 28 | C | [NAME] | 00:28:00
 | 29 | S | [NAME] | 00:31:00
 | 30 | C | [NAME] | 00:35:00
 | 31 | C | Newmarket/Ipswich | 00:40:00
 | 32 | C | Peterborough/[NAME] | 00:43:00
 | 33 | C | [NAME] | 00:50:00
 | 34 | C | Oxford | 01:28:00
 | 35 | C | Crawley/Lancing | 01:35:00
 | 36 | C | Heathrow/Slough | 02:08:00
 | 37 | T | Reading | 02:15:00
 | 38 | C | Harlow/Chelmsford | 02:35:00
 | 39 | C | Grays Collect | 02:36:00
 | 40 | C | Weybridge | 02:41:00
 | 41 | C | Stevenage | 02:45:00
 | 42 | C | Borehamwood | 03:02:00
 | 43 | C | Grays | 03:08:00
 | 44 | C | Postal Services | 04:00:00
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
Saturday | 1 | C | Post Services Ist Edition | 23:07:00
 | 2 | T | Newton Abbot/Plymouth | 23:09:00
 | 3 | T | Poly Bulk 1 | 23:12:00
 | 4 | T | Bodmin/Redruth | 23:13:00
 | 5 | C | Higgs | 23:17:00
 | 6 | C | Swansea | 23:25:00
 | 7 | T | Taunton | 23:32:00
 | 8 | T | South Coast/IOW | 23:34:00
 | 9 | C | Reeds | 23:35:00
 | 10 | C | Dover Docks | 23:37:00
 | 11 | C | Stevenage Early | 23:40:00
 | 12 | C | Newsflash 1 | 23:50:00
 | 13 | C | Newsflash 2 | 23:50:00
 | 14 | C | Newsflash 3 | 23:50:00
 | 15 | C | Newsflash 4 | 23:50:00
 | 16 | C | Gloucester/Hereford | 23:56:00
 | 17 | T | MOM | 00:01:00
 | 18 | C | Swindon/Bristol | 00:02:00
 | 19 | C | OCS Millwall | 00:03:00
 | 20 | C | OCS Heathrow | 00:03:00
 | 21 | C | Night Sales | 00:06:00
 | 22 | C | [NAME] | 00:08:00
 | 23 | C | [NAME] | 00:10:00
 | 24 | C | RMS Hotels | 00:12:00
 | 25 | C | Newport | 00:14:00
 | 26 | S | Leicester/Coventry | 00:19:00
 | 27 | S | Wednesbury | 00:26:00
 | 28 | C | [NAME] | 00:28:00
 | 29 | S | [NAME] | 00:31:00
 | 30 | C | [NAME] | 00:35:00
 | 31 | C | Newmarket/Ipswich | 00:40:00
 | 32 | C | Peterborough/[NAME] | 00:43:00
 | 33 | C | [NAME] | 00:50:00
 | 34 | C | Oxford | 01:28:00
 | 35 | C | Crawley/Lancing | 01:35:00
 | 36 | C | Heathrow/Slough | 02:08:00
 | 37 | T | Reading | 02:15:00
 | 38 | C | Harlow/Chelmsford | 02:35:00
 | 39 | C | Grays Collect | 02:36:00
 | 40 | C | Weybridge | 02:41:00
 | 41 | C | Stevenage | 02:45:00
 | 42 | C | Borehamwood | 03:02:00
 | 43 | C | Grays | 03:08:00
 | 44 | C | Postal Services | 04:00:00
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65