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

LCS Approved / Delivery Date | (All)
Count of TF Numbers |  |  | Column Labels
Row Labels | Equipment Type | Summary | 1 | 2 | Full | Grand Total
084C | [NAME] | The valve assembly is excluded from the scope of the PED, in accordance with Article 1,2(n). | 1 |  |  | 1
 | 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. | 1 |  |  | 1
 | 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. | 1 |  |  | 1
555B | n/a | No items of Legislative interest have been discovered in this Kit | 1 |  |  | 1
834A | n/a | No items of Legislative interest have been discovered in this Kit |  |  | 1 | 1
DMHC | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable” Compliance with the requirement for design using SEP has been confirmed. | 3 |  |  | 3
 |  | “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. | 1 |  |  | 1
 | 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. | 1 |  |  | 1
 | 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. | 2 |  |  | 2
 | 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. | 1 |  |  | 1
 | 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. |  | 1 |  | 1
 | 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. | 2 |  |  | 2
 | 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. | 1 |  |  | 1
[NAME] | 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. |  | 4 |  | 4
 | 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. |  | 2 |  | 2
 | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed. |  | 1 |  | 1
 | 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. |  | 1 |  | 1
 | Filter Assembly | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed. |  | 1 |  | 1
 |  | “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. |  | 1 |  | 1
 | 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. |  | 2 |  | 2
 | 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. |  | 4 |  | 4
TI01 | 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. | 2 |  |  | 2
 | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed. | 1 |  |  | 1
 | 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. | 1 |  |  | 1
 | 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. | 3 |  |  | 3
 | Indicator | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed. | 4 |  |  | 4
 | 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. | 2 |  |  | 2
 | 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. | 1 |  |  | 1
 | 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. | 1 |  |  | 1
 | Manifold | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed. | 1 |  |  | 1
 | [NAME] | “No CE marking is required, sound engineering practice must be demonstrable.” Compliance with the requirement for design using SEP has been confirmed. | 1 |  |  | 1
 | 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. | 1 |  |  | 1
 | Valve, In-line check | “The valve assembly is excluded from the scope of the PED, in accordance with Article 1,2(n)”. | 1 |  |  | 1
[NAME] | n/a | No items of Legislative interest have been discovered in this Kit |  | 1 |  | 1
Grand Total |  |  | 34 | 18 | 1 | 53