Spreadsheet: 749901d1633088937-how-to-properly-filter-an-array-of-cells-how-to-properly-filter-an-array-of-cells-v3
Sheet: Sheet1

Kit | Shipment | LCS Approved / Delivery Date | Qty of Items | Qty of Articles | [NAME] | TF Numbers | Part Number | Equipment Type | Summary
084C | 1 | 2021-01-20 00:00:00 |  | 616 |  | 2020-0717 |  | [NAME] | The valve assembly is excluded from the scope of the PED, in accordance with Article 1,2(n).
084C | 1 | 2021-01-20 00:00:00 |  |  |  | 2020-0718 |  | In-line Gage Root Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
084C | 1 | 2021-01-20 00:00:00 |  |  |  | 2020-0816 |  | ControlLogix 2 MB Controller | “The original manufacturer of the EuC has provided an EU Declaration of Conformity.  As importer ### should retain a copy of this document along with any instructions and verify that the correct conformity marking has been applied to this product (e.g. CE marking).” If this item is imported into the UK after the ### it will be necessary to obtain a UK Declaration of Conformity from the original manufacturer and the conformity marking required will be a UKCA mark rather than a CE mark.
DMHC | 1 | 2021-01-22 00:00:00 |  | 2157 | 477 | 2020-0340 |  | Swing Check Valve | “The original manufacturer of the EuC has provided an EU Declaration of Conformity.  As importer ### should retain a copy of this document along with any instructions and verify that the correct conformity marking has been applied to this product (e.g. CE marking).” If this item is imported into the UK after the ### it will be necessary to obtain a UK Declaration of Conformity from the original manufacturer and the conformity marking required will be a UKCA mark rather than a CE mark.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0342 |  | [NAME] | “The original manufacturer of the EuC has provided an EU Declaration of Conformity.  As importer ### should retain a copy of this document along with any instructions and verify that the correct conformity marking has been applied to this product (e.g. CE marking).” If this item is imported into the UK after the ### it will be necessary to obtain a UK Declaration of Conformity from the original manufacturer and the conformity marking required will be a UKCA mark rather than a CE mark.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0343 |  | Straight Ball Valve | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0347 |  | Vent & Drain Assembly | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0348 |  | Vent & Drain Assembly | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0350 |  | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0360 |  | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0361 |  | Straight Ball Valve | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0362 |  | Fluid Filter Assembly | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0430 |  | Vent & Test Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed. It has been assumed that sufficient information has been provided with the equipment to instruct the user on its safe installation & use.
DMHC | 1 | 2021-01-22 00:00:00 |  |  |  | 2020-0684 |  | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed.
DMHC | 2 | 2021-01-26 00:00:00 |  | 8 | 1 | 2020-0363 |  | Ultrasonic Flowmeter | “The original manufacturer of the EuC has provided an EU Declaration of Conformity.  As importer ### should retain a copy of this document along with any instructions and verify that the correct conformity marking has been applied to this product (e.g. CE marking).” If this item is imported into the UK after the ### it will be necessary to obtain a UK Declaration of Conformity from the original manufacturer and the conformity marking required will be a UKCA mark rather than a CE mark.
555B | 1 | 2021-01-27 00:00:00 |  | 18 | 1 | n/a |  | n/a | No items of Legislative interest have been discovered in this Kit
834A | Full | 2021-02-05 00:00:00 |  | 22 | 21 | n/a |  | n/a | No items of Legislative interest have been discovered in this Kit
TI01 | 1 | 2021-02-12 00:00:00 |  | 1227 | 694 | 2019-0445 |  | In-Line Needle Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0446 |  | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0715 |  | 2-Way Straight Ball Valve | “The original manufacturer of the EuC has provided an EU Declaration of Conformity.  As importer ### should retain a copy of this document along with any instructions and verify that the correct conformity marking has been applied to this product (e.g. CE marking).” If this item is imported into the UK after the ### it will be necessary to obtain a UK Declaration of Conformity from the original manufacturer and the conformity marking required will be a UKCA mark rather than a CE mark.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0775 |  | In-line Gage Root Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0855 |  | In-Line Gage Root Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0875 |  | Indicator | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0890 |  | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0891 |  | Electric Solenoid By-Pass Valve | “The original manufacturer of the EuC has provided an EU Declaration of Conformity.  As importer ### should retain a copy of this document along with any instructions and verify that the correct conformity marking has been applied to this product (e.g. CE marking).” If this item is imported into the UK after the ### it will be necessary to obtain a UK Declaration of Conformity from the original manufacturer and the conformity marking required will be a UKCA mark rather than a CE mark.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0904 |  | Valve, In-line check | “The valve assembly is excluded from the scope of the PED, in accordance with Article 1,2(n)”.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0922 |  | 2-Way Straight Ball Valve | “The original manufacturer of the EuC has provided an EU Declaration of Conformity.  As importer ### should retain a copy of this document along with any instructions and verify that the correct conformity marking has been applied to this product (e.g. CE marking).” If this item is imported into the UK after the ### it will be necessary to obtain a UK Declaration of Conformity from the original manufacturer and the conformity marking required will be a UKCA mark rather than a CE mark.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0996 |  | Indicator | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-0998 |  | Indicator | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2019-1022 |  | Indicator | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2020-0250 |  | Manifold | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2020-0639 |  | Swing Check Valve | “The valve assembly is excluded from the scope of the PED, in accordance with Article 1,2(n)”. The Dreadnought Platform Chief Engineer (PCE) has confirmed that this valve is specifically intended for use in Dreadnought class submarines and is not able to be used in alternative applications.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2020-0643 |  | In-Line Stop Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2020-0687 |  | Globe Valve (Instrument Gage Valve) | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2020-0688 |  | Globe Valve (Instrument Gage Valve) | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
TI01 | 1 | 2021-02-12 00:00:00 |  |  |  | 2020-0689 |  | Globe Valve (Instrument Gage Valve) | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-12 00:00:00 |  |  |  | n/a |  | n/a | No items of Legislative interest have been discovered in this Kit
[NAME] | 2 | 2021-02-19 00:00:00 |  | 1690 | 883 | 2019-0420 |  | 2-Way Straight Ball Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0421 |  | 2-Way Straight Ball Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0422 |  | 2-Way Straight Ball Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0423 |  | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0424 |  | 2-Way Straight Ball Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0425 |  | Automatic Balancing Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0426 |  | Flow Control Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0427 |  | Flow Control Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0428 |  | Automatic Balancing Valve | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2019-0874 |  | C.O.R.D [NAME] | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2020-0344 |  | Filter Assembly | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2020-0345 |  | Vent & Drain Assembly | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2020-0346 |  | Vent & Drain Assembly | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2020-0347 |  | Vent & Drain Assembly | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2020-0348 |  | Vent & Drain Assembly | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed.
[NAME] | 2 | 2021-02-19 00:00:00 |  |  |  | 2020-0349 |  | Filter Assembly | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed. It has been assumed that sufficient information has been provided with the equipment to instruct the user on its safe installation & use.