Spreadsheet: 860913d1708939876-stuck-on-complicated-data-validation-drop-down-list-booking-slot-test-6-table
Sheet: Sheet 3

Business Unit | Product Family | Serial Number | Expected Output Date | Actual Output Date | SKU | Customer | Production Order Number | Status | Yard | Transport Date | EQV Value | [NAME] | Expected Despatch Date | Ex-Works | Age
E&W Sales | Test Unit | 11111 | 2022-07-15 00:00:00 | 2022-08-25 00:00:00 | 386770 | test 1 | 1316598 | [NAME] | Yard 2 | 45076 | 0.8 |  | 2023-03-27 00:00:00 | 2022-10-05 00:00:00 | 1+ year
Site Accommodation | Test Unit | 22222 | 2016-02-15 00:00:00 | 2016-02-29 00:00:00 | 613944 | test 2 | 6326895 | [NAME] | Yard 5 | 42906 | 1.2 |  |  | 2016-02-23 00:00:00 | 1+ year
France | Test Unit | 33333 | 2019-06-04 00:00:00 | 2019-06-12 00:00:00 | 728145 | test 3 | 6630634 | [NAME] | Yard 2 | 43669 | 1.5 |  |  | 2019-06-11 00:00:00 | 1+ year
France | Test Unit | 44444 | 2019-06-24 00:00:00 | 2019-06-25 00:00:00 | 446252 | test 4 | 8094999 | [NAME] | Yard 2 | 43648 | 1.9 |  | 2023-02-13 00:00:00 | 2019-07-01 00:00:00 | 1+ year
E&W [NAME] | Test Unit | 55555 | 2022-06-22 00:00:00 | 2022-07-13 00:00:00 | 437518 | test 5 | 7337244 | [NAME] | Yard 2 | 44824 | 0.8 |  |  | 2022-08-29 00:00:00 | 1+ year
E&W [NAME] | Test Unit | 66666 | 2022-03-07 00:00:00 | 2022-03-10 00:00:00 | 68193 | test 6 | 2686018 | [NAME] | Yard 1 | 44917 | 4.3 |  |  | 2022-08-29 00:00:00 | 1+ year
E&W [NAME] | Test Unit | 77777 | 2022-06-22 00:00:00 | 2022-07-13 00:00:00 | 484320 | test 7 | 9971750 | [NAME] | Yard 2 | 44824 | 0.8 |  |  | 2022-08-29 00:00:00 | 1+ year
E&W [NAME] | Test Unit | 88888 | 2022-07-19 00:00:00 | 2022-08-16 00:00:00 | 625009 | test 8 | 8338595 | [NAME] | Yard 2 | 44832 | 0.8 |  |  | 2022-08-17 00:00:00 | 1+ year
E&W [NAME] | Test Unit | 99999 | 2022-07-20 00:00:00 | 2022-08-12 00:00:00 | 730230 | test 9 | 5545144 | [NAME] | Yard 2 | 44837 | 0.8 |  |  | 2022-08-22 00:00:00 | 1+ year
E&W [NAME] | Test Unit | 11119 | 2022-08-11 00:00:00 | 2022-08-25 00:00:00 | 449881 | test 10 | 3056567 | [NAME] | Yard 2 | 44873 | 0.8 |  |  | 2022-09-12 00:00:00 | 1+ year
E&W [NAME] | Test Unit | 22229 | 2022-08-11 00:00:00 | 2022-08-26 00:00:00 | 143360 | test 11 | 5271001 | [NAME] | Yard 2 | 44874 | 0.8 |  |  | 2022-09-12 00:00:00 | 1+ year
E&W [NAME] | Test Unit | 33339 | 2022-08-11 00:00:00 | 2022-08-26 00:00:00 | 584308 | test 12 | 3836222 | [NAME] | Yard 2 | 44844 | 0.8 |  |  | 2022-09-12 00:00:00 | 1+ year
Ireland | Test Unit | 44449 | 2022-06-22 00:00:00 | 2022-07-13 00:00:00 | 299600 | test 13 | 7208532 | [NAME] | Yard 2 | 45111 | 0.8 |  | 2023-03-13 00:00:00 | 2022-08-29 00:00:00 | 1+ year
Ireland | Test Unit | 55559 | 2022-03-07 00:00:00 | 2022-03-16 00:00:00 | 299430 | test 14 | 1636240 | [NAME] | Yard 2 | 44819 | 2 |  |  | 2022-08-29 00:00:00 | 1+ year
Ireland | Test Unit | 66669 | 2022-06-23 00:00:00 | 2022-07-13 00:00:00 | 657297 | test 15 | 6771939 | [NAME] | Yard 2 | 44819 | 0.8 |  |  | 2022-08-29 00:00:00 | 1+ year
Site Accommodation | Test Unit | 77779 | 2021-08-05 00:00:00 | 2021-08-13 00:00:00 | 470749 | test 16 | 1454139 | [NAME] | Yard 2 | 44762 | 1.5 |  |  | 2021-08-31 00:00:00 | 1+ year
Ireland | Test Unit | 88889 | 2022-06-23 00:00:00 | 2022-07-13 00:00:00 | 946375 | test 17 | 4674613 | [NAME] | Yard 2 | 44819 | 0.8 |  |  | 2022-08-29 00:00:00 | 1+ year
Ireland | Test Unit | 11199 | 2022-07-04 00:00:00 | 2022-07-25 00:00:00 | 108428 | test 18 | 4000188 | [NAME] | Yard 2 | 44819 | 0.8 |  |  | 2022-07-25 00:00:00 | 1+ year
Ireland | Test Unit | 22299 | 2022-07-04 00:00:00 | 2022-07-25 00:00:00 | 721643 | test 19 | 9531941 | [NAME] | Yard 2 | 44887 | 0.8 |  |  | 2022-07-25 00:00:00 | 1+ year
Ireland | Solus | 33399 | 2022-07-05 00:00:00 | 2022-07-26 00:00:00 | 258913 | test 20 | 2327595 | [NAME] | Yard 2 | 44818 | 0.8 |  |  | 2022-08-15 00:00:00 | 1+ year
Ireland | Solus | 44499 | 2022-07-05 00:00:00 | 2022-07-26 00:00:00 | 716141 | test 21 | 6716475 | [NAME] | Yard 2 | 44818 | 0.8 |  |  | 2022-08-15 00:00:00 | 1+ year
Site Accommodation | [NAME] | 55599 | 2021-11-18 00:00:00 | 2021-11-23 00:00:00 | 619762 | test 22 | 2434583 | [NAME] | Yard 2 | 44762 | 1.5 |  |  | 2021-11-29 00:00:00 | 1+ year
E&W [NAME] | Solus | 66699 | 2022-03-09 00:00:00 | 2022-03-18 00:00:00 | 187891 | test 23 | 5559098 | [NAME] | Yard 2 | 44831 | 2 |  |  | 2022-04-13 00:00:00 | 1+ year
Ireland | Solus | 77799 | 2022-07-20 00:00:00 | 2022-08-16 00:00:00 | 987804 | test 24 | 6578444 | [NAME] | Yard 2 | 44826 | 0.8 |  |  | 2022-08-22 00:00:00 | 1+ year
E&W [NAME] | Solus | 88899 | 2022-03-09 00:00:00 | 2022-03-23 00:00:00 | 759020 | test 25 | 3546055 | [NAME] | Yard 2 | 44831 | 2 |  |  | 2022-08-29 00:00:00 | 1+ year
Ireland | Solus | 11999 | 2022-08-02 00:00:00 | 2022-08-16 00:00:00 | 463406 | test 26 | 4624060 | [NAME] | Yard 2 | 44826 | 0.8 |  |  | 2022-09-12 00:00:00 | 1+ year
E&W [NAME] | Solus | 22999 | 2021-12-21 00:00:00 | 2022-01-11 00:00:00 | 328795 | test 27 | 8888500 | [NAME] | Yard 2 | 44838 | 1.4 |  |  | 2022-08-29 00:00:00 | 1+ year
France | Solus | 33999 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | 841736 | test 28 | 8639807 | [NAME] | Yard 2 | 44827 | 0.8 |  |  | 2022-08-17 00:00:00 | 1+ year
E&W [NAME] | Solus | 44999 | 2022-01-28 00:00:00 | 2022-01-31 00:00:00 | 661584 | test 29 | 1203319 | [NAME] | Yard 2 | 44827 | 1.6 |  |  | 2022-02-18 00:00:00 | 1+ year
E&W [NAME] | Solus | 55999 | 2022-01-31 00:00:00 | 2022-02-01 00:00:00 | 378028 | test 30 | 3725538 | [NAME] | Yard 2 | 44824 | 1.6 |  |  | 2022-08-29 00:00:00 | 1+ year
Ireland | Solus | 66999 | 2022-10-11 00:00:00 | 2022-10-05 00:00:00 | 754004 | test 31 | 4728971 | [NAME] | Yard 2 | 44887 | 0.8 |  |  | 2022-11-07 00:00:00 | 1+ year
E&W [NAME] | Solus | 77999 | 2022-01-31 00:00:00 | 2022-02-01 00:00:00 | 869024 | test 32 | 7157300 | [NAME] | Yard 2 | 44824 | 1.6 |  |  | 2022-08-29 00:00:00 | 1+ year
Ireland | Solus | 88999 | 2022-10-11 00:00:00 | 2022-10-05 00:00:00 | 597130 | test 33 | 9787930 | [NAME] | Yard 2 | 44887 | 0.8 |  |  | 2022-11-07 00:00:00 | 1+ year