Spreadsheet: 188657d1350946304-excel-removes-all-data-validation-lists-at-the-opening-of-the-workbook-quotation_parkregis_hotel-master
Sheet: OFFER_BA

 |  |  |  |  |  |  |  |  | INCUMBENT LAMP TYPE
 |  |  |  |  |  |  |  |  | T8 FLURO |  |  | HALOGEN |  |  | HIGH BAY |  |  |  |  |  | Applications |  |  |  |  |  | Dimmers |  |  |  |  |  | Ceiling
 |  |  |  |  |  | Replacement Products | Product Type | Min [NAME] | T8 or T12 linear fluorescent or circular fluorescent (Unknown Ballast) | T8 or T12 linear fluorescent or circular fluorescent with an associated magnetic ballast | T8 or T12 linear fluorescent or circular fluorescent with an associated electronic ballast | Tungsten incandescent or halogen (mains voltage) | Tungsten incandescent or halogen (extra low voltage) with magnetic transformer | Tungsten incandescent or halogen (extra low voltage) with electronic transformer | Metal halide with magnetic ballast (reactor type) | Metal halide with magnetic ballast (constant wattage type) | Metal halide with electronic ballast | Mercury vapour with magnetic ballast | [NAME] (unknown ballast) | High pressure sodium (HPS) with magnetic ballast | Surgery / Detailed Work | Office | Retail | Hotel, Bar, Coffee Shop | Hall Way,Toilets | Warehouse | Leading Edge Dimmer | Trailing Edge Dimmer | Universal Dimmer | Sensor | CBUS | Dynalite | Ceiling <3 | Ceiling 3-4 | Ceiling >4 | Warm white | Day Light
 |  |  |  |  |  | Ecobulb 15W [NAME] (Non Dimmable) | [NAME] | 400 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1
 |  |  |  |  |  | Ecobulb 15W [NAME] (Dimmable) | [NAME] | 400 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1
 |  |  |  |  |  | EP 6W LED GU10 -Downlight (Non Dimmable) | [NAME] | 300 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0
 |  |  |  |  |  | LED4Life 6W GU10 - Downlight (Dimmable) | [NAME] | 200 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0
 |  |  |  |  |  | LED4Life 9W GU10 - Downlight (Dimmable) | [NAME] | 200 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0
 |  |  |  |  |  | Philips LED 10W MR16 - Downlight (Dimmable) | [NAME] | 300 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1
 |  |  |  |  |  | Centaurus 6W LED MR16 - (Dimmable) | [NAME] | 250 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0
 |  |  |  |  |  | [NAME] LED MR16 - (Dimmable) | [NAME] | 300 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0
 |  |  |  |  |  | ALPHA 12W Fuxture Downlight -  (Dimmable) | [NAME] | 500 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0
 |  |  |  |  |  | [NAME] 25W T5 Adaptor & Tube | Tube | 360 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  | SS 14W LED Tube | Tube | 360 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1
 |  |  |  |  |  | SS 20W LED Tube | Tube | 500 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1
 |  |  |  |  |  | Voxon 150W LED High Bay | High Bay | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1