Spreadsheet: 224257d1364499145-help-with-my-price-referencing-spread-sheet-price-referencing-spread-sheet
Sheet: Data

 |  |  |  | Model Number | Discription | Price Unit |  |  |  |  | Alphabatized Rank | Lookup | Alphabetical Order
 |  |  |  | S1200 | DETA 1 gang Blank Plate | 0.35 |  |  |  | 1
 |  |  |  | S1202 | DETA 1 gang 1 way 10A Plate Switch | 0.36 |  |  |  | 2
 |  |  |  | S1203 | DETA 1 gang 2 way 10A Plate Switch | 0.46 |  |  |  | 3
 |  |  |  | S1204 | DETA 2 gang 2 way 10A Plate Switch | 0.86 |  |  |  | 4
 |  |  |  | S1205 | DETA 3 gang 2 way 10A Plate Switch | 1.2 |  |  |  | 5
 |  |  |  | S1206 | DETA 13A 1 gang Unswitched Socket | 0.74 |  |  |  | 6
 |  |  |  | S1207SDP | DETA 13A 1 gang Switched Socket DP | 1.09 |  |  |  | 7
 |  |  |  | S1209S | DETA 13A 2 gang Switched Socket SP | 1.38 |  |  |  | 8
 |  |  |  | S1209SDP | DETA 13A 2 gang Switched Socket DP | 1.53 |  |  |  | 9
 |  |  |  | S1215 | DETA 25A Flex Outlet Plate | 1.51 |  |  |  | 10
 |  |  |  | S1217 | DETA 45A Cooker Cable Outlet | 1.94 |  |  |  | 11
 |  |  |  | S1244 | DETA 4 gang 2 Way 10A Plate Switch | 3.43 |  |  |  | 12
 |  |  |  | S1246 | DETA Intermediate Switch | 1.71 |  |  |  | 13
 |  |  |  | S1247 | DETA 3 Pole Fan Isolator | 1.66 |  |  |  | 14
 |  |  |  | S1264 | DETA Single Co-Axial Outlet - Isolated | 1.06 |  |  |  | 15
 |  |  |  | S1268 | DETA Single Co-Axial Outlet - Non Isolated | 1.15 |  |  |  | 16
 |  |  |  | S1300 | DETA 45A DP Red Switch | 3.32 |  |  |  | 17
 |  |  |  | S1300P | DETA 45A DP Red Switch with Neon | 3.52 |  |  |  | 18
 |  |  |  | S1301 | DETA 45A DP Tall Red Switch | 3.99 |  |  |  | 19
 |  |  |  | S1302 | DETA 45A Cooker Control Unit Red Switch | 4.34 |  |  |  | 20
 |  |  |  | S1305 | DETA Dual Voltage Shaver Socket | 9 |  |  |  | 21
 |  |  |  | S1342 | DETA TV/FM DAB Sat x 2 Quadplexor | 6.2 |  |  |  | 22
 |  |  |  | S1352 | DETA Single Master Telephone Outlet | 2.3 |  |  |  | 23
 |  |  |  | S1353 | DETA Single Secondary Telephone Outlet | 1.38 |  |  |  | 24
 |  |  |  | S1360 | DETA 13A Unswitched Spur | 1.49 |  |  |  | 25
 |  |  |  | S1370 | DETA 13A Switched Spur | 2.03 |  |  |  | 26
 |  |  |  | S1371 | DETA 13A Switched Spur with Neon | 2.61 |  |  |  | 27
 |  |  |  | [NAME] | DETA 20A DP Switch | 1.68 |  |  |  | 28
 |  |  |  | S1390WH | DETA 20A DP Switch Engraved "WATER HEATER" | 2.03 |  |  |  | 29
 |  |  |  | S1392 | DETA 20A DP Switch with Flex Outlet | 1.68 |  |  |  | 30
 |  |  |  | S1393 | DETA 20A DP Switch with Neon & Flex Outlet | 2.49 |  |  |  | 31
 |  |  |  | S1419WH | DETA Screw Caps Per Bag of 100 | 5.75 |  |  |  | 32
 |  |  |  | 1975WHW | DETA White Lounge Plate Complete with [NAME] and Blanks | 45 |  |  |  | 33
 |  |  |  | V1278 | DETA 6" Pendant Set - T2 Rated with V1299 Safety Ceiling Rose | 1 |  |  |  | 34
 |  |  |  | V1280 | DETA 6" Pendant Set - T2 Rated | 0.7 |  |  |  | 35
 |  |  |  | V1289 | DETA Batten Lampholder Straight Home Office Skirt, [NAME] | 1.66 |  |  |  | 36
 |  |  |  | V1297 | DETA 10A 2 way Ceiling Switch With Pull Cord | 0.81 |  |  |  | 37
 |  |  |  | V1298 | DETA 45A DP Ceiling Switch with Neon | 3.98 |  |  |  | 38
 |  |  |  | V1400 | DETA Low Energy Pendant | 7.7 |  |  |  | 39
 |  |  |  | [NAME] | DETA Low Energy Batten | 7.7 |  |  |  | 40
 |  |  |  | DB2547 | DETA 1 gang 35mm Deep Lipless Dry Lining Box | 0.62 |  |  |  | 41
 |  |  |  | DB2548 | DETA 2 gang 35mm Deep Lipless Dry Lining Box | 1.02 |  |  |  | 42
 |  |  |  | 1900 | DETA Chrome 1 gang Blank Plate | 2.09 |  |  |  | 43
 |  |  |  | 1903 | DETA Chrome 1 gang 2 way 10A Plate Switch | 3.13 |  |  |  | 44
 |  |  |  | 1904 | DETA Chrome 2 gang 2 way 10A Switch | 3.42 |  |  |  | 45
 |  |  |  | 1905 | DETA Chrome 3 gang 10A Switch | 4.67 |  |  |  | 46
 |  |  |  | 1907 | DETA Chrome 1 gang 13A Switched Socket | 3.85 |  |  |  | 47
 |  |  |  | 1909 | DETA Chrome 2 gang 12A Switched Scoket | 5.15 |  |  |  | 48
 |  |  |  | 1910 | DETA Chrome 13A Unswitched Spur | 5.11 |  |  |  | 49
 |  |  |  | 1913 | DETA Chrome 13A Switched Spur | 5.4 |  |  |  | 50
 |  |  |  | 1914 | DETA Chrome 13A [NAME] with Neon | 6.12 |  |  |  | 51
 |  |  |  | 1916 | DETA Chrome 13A Switched Connection Unit with [NAME] and Neon | 6.5 |  |  |  | 52
 |  |  |  | 1920 | DETA Chrome 4 gang Switch | 6.84 |  |  |  | 53
 |  |  |  | 1923 | DETA Chrome 45A DP Switch | 8.53 |  |  |  | 54
 |  |  |  | 1925 | DETA Chrome 45A DP Tall Switch | 8.95 |  |  |  | 55
 |  |  |  | 1927 | DETA Chrome 45A Cooker Control Unit with Neon | 15.1 |  |  |  | 56
 |  |  |  | 1931 | DETA Chrome Dual Voltage Shaver Socket | 20.7 |  |  |  | 57
 |  |  |  | 1933 | DETA Chrome 20A DP Switch | 4.8 |  |  |  | 58
 |  |  |  | 1935 | DETA Chrome 20A DP Switch with Flex Outlet | 5.18 |  |  |  | 59
 |  |  |  | 1940 | DETA Chrome Single Co-Axial Outlet Isolated | 3.94 |  |  |  | 60
 |  |  |  | 1946 | DETA Chrome Intermediate Switch | 5.85 |  |  |  | 61
 |  |  |  | 1949 | DETA Chrome 3 pole Fan Isolator Switch | 5.95 |  |  |  | 62
 |  |  |  | 1960 | DETA Chrome Single Master Telephone Outlet | 5.63 |  |  |  | 63
 |  |  |  | 1962 | DETA Chrome Single Secondary Telephone Outlet | 4.88 |  |  |  | 64
 |  |  |  | 1971SCB/CHB | DETA Chrome 4 Modual Data Plate | 6.5 |  |  |  | 65
 |  |  |  | 1971CHW | DETA Chrome 4 Modual Data Plate | 6.5 |  |  |  | 66
 |  |  |  | [NAME] | DETA Chrome Quadplexer Modual | 9.5 |  |  |  | 67
 |  |  |  | 8601WHW | DETA Screwless White 1 gang Switch | 1.23 |  |  |  | 68
 |  |  |  | 8602WHW | DETA Screwless White 2 gang Switch | 1.58 |  |  |  | 69
 |  |  |  | 8603WHW | DETA Screwless White 3 gang Switch | 2.63 |  |  |  | 70
 |  |  |  | 8637WHW | DETA Screwless White 1 gang Unswitched 5A Socket | 2.63 |  |  |  | 71
 |  |  |  | 8631WHW | DETA Screwless White Single Switch Socket | 2.1 |  |  |  | 72
 |  |  |  | 8632WHW | DETA Screwless White Double Switch Socket | 2.98 |  |  |  | 73
 |  |  |  | 8646WHW | DETA Screwless White Unswitched Fuse Spur with Neon | 3.85 |  |  |  | 74
 |  |  |  | 8643WHW | DETA Screwless White Switched Fuse Spur with Neon | 4.36 |  |  |  | 75
 |  |  |  | 8644WHW | DETA Screwless White Switched Fuse Spur with Neon and [NAME] | 5.25 |  |  |  | 76
 |  |  |  | 8604WHW | DETA Screwless White 4 gang Switch | 4.9 |  |  |  | 77
 |  |  |  | 8606WHW | DETA Screwless White Intermediate Switch | 3.15 |  |  |  | 78
 |  |  |  | 8690WHW | DETA Screwless White Single Co-Axial Outlet Non-Isolated | 2.45 |  |  |  | 79
 |  |  |  | 8650WHW | DETA Screwless White 1 Gang 45A DP Switch with Neon | 7.35 |  |  |  | 80
 |  |  |  | 8681WHW | DETA Screwless White Master [NAME] | 3.68 |  |  |  | 81
 |  |  |  | 8683WHW | DETA Screwless White Secondary Telephone Socket | 2.24 |  |  |  | 82
 |  |  |  | 8671WHW | DETA Screwless White Shaver Socket | 16.8 |  |  |  | 83
 |  |  |  | 8692WHW | DETA Screwless White TV/FM Diplexor Outlet | 5.25 |  |  |  | 84
 |  |  |  | 8694WHW | DETA Screwless White TV/FM/SAT Triplexor | 6.3 |  |  |  | 85
 |  |  |  | 8687WHW | DETA Screwless White 2 Modual Data Plate | 1.23 |  |  |  | 86
 |  |  |  | 8689WHW | DETA Screwless White 4 Modual Data Plate | 1.75 |  |  |  | 87
 |  |  |  | [NAME] | DETA Slimline 1 gang Front Plate | 0.43 |  |  |  | 88
 |  |  |  | [NAME] | [NAME] 2 gang Front Plate | 0.43 |  |  |  | 89
 |  |  |  | G3303 | DETA Slimline 3 gang Front Plate | 0.96 |  |  |  | 90
 |  |  |  | G3304 | [NAME] 4 gang Front Plate | 0.96 |  |  |  | 91
 |  |  |  | [NAME] | DETA Slimline 6 gang Front Plate | 2.23 |  |  |  | 92
 |  |  |  | G3306 | [NAME] 8 gang Front Plate | 2.23 |  |  |  | 93
 |  |  |  | G3401 | DETA 1 Modual Grid Frame | 0.45 |  |  |  | 94
 |  |  |  | G3402 | DETA 2 Modual Grid Frame | 0.45 |  |  |  | 95
 |  |  |  | G3403 | DETA 3 Modual Grid Frame | 0.62 |  |  |  | 96
 |  |  |  | G3404 | DETA 4 Modual Grid Frame | 0.62 |  |  |  | 97
 |  |  |  | G3501 | DETA 10A 1 way Switch | 0.75 |  |  |  | 98
 |  |  |  | G3511 | DETA 20A 1 way Switch | 1.23 |  |  |  | 99
 |  |  |  | G3541 | DETA Flex Outlet | 3.05 |  |  |  | 100
 |  |  |  | G3542 | DETA Fused Outlet | 2.35 |  |  |  | 101
 |  |  |  | G3544 | [NAME] | 0.56 |  |  |  | 102
 |  |  |  | G3551 | DETA 20A DP Switch OVEN | 1.65 |  |  |  | 103
 |  |  |  | G3552 | DETA 20A DP Switch HOB | 1.65 |  |  |  | 104
 |  |  |  | G3553 | DETA 20A DP Switch Extractor Fan | 1.65 |  |  |  | 105
 |  |  |  | G3554 | DETA 20A DP Switch Washing Machine | 1.65 |  |  |  | 106
 |  |  |  | G3555 | DETA 20A DP Switch Tumble Dryer | 1.65 |  |  |  | 107
 |  |  |  | G3556 | DETA 20A DP Switch Dish Washer | 1.65 |  |  |  | 108
 |  |  |  | G3557 | DETA 20A DP [NAME] | 1.65 |  |  |  | 109
 |  |  |  | G3558 | DETA 20A DP [NAME] | 1.65 |  |  |  | 110
 |  |  |  | G3562 | DETA 20A DP [NAME] Freezer | 1.65 |  |  |  | 111
 |  |  |  | G3559 | DETA 20A DP [NAME] | 1.65 |  |  |  | 112
 |  |  |  | G3560 | DETA 20A DP Switch Cook Hood | 1.65 |  |  |  | 113
 |  |  |  | G3561 | DETA 20 A DP Switch Microwave | 1.65 |  |  |  | 114
 |  |  |  | G3341 | DETA Decorative Chrome 1 gang Front Plate | 2.26 |  |  |  | 115
 |  |  |  | G3342 | DETA Decorative Chrome 2 gang Front Plate | 2.26 |  |  |  | 116
 |  |  |  | G3343 | DETA Decorative Chrome 3 gang Front Plate | 4.95 |  |  |  | 117
 |  |  |  | G3344 | DETA Decorative Chrome 4 gang Front Plate | 4.95 |  |  |  | 118
 |  |  |  | [NAME] | DETA Decorative Chrome 6 gang Front Plate | 7.2 |  |  |  | 119
 |  |  |  | G3346 | DETA Decorative Chrome 8 gang Front Plate | 7.2 |  |  |  | 120
 |  |  |  | G3351 | DETA [NAME] gang Front Plate | 2.26 |  |  |  | 121
 |  |  |  | G3352 | DETA [NAME] gang Front Plate | 2.26 |  |  |  | 122
 |  |  |  | G3353 | DETA [NAME] gang Front Plate | 4.95 |  |  |  | 123
 |  |  |  | G3354 | DETA [NAME] gang Front Plate | 4.95 |  |  |  | 124
 |  |  |  | G3355 | DETA [NAME] gang Front Plate | 7.2 |  |  |  | 125
 |  |  |  | G3356 | DETA [NAME] gang Front Plate | 7.2 |  |  |  | 126
 |  |  |  | S105/6T2 | DETA 6inch Safety Pendant Set | 1.6 |  |  |  | 127
 |  |  |  | S96/H0/T2 | DETA Safety - Enclosed Batten Holder - Straight Home Office Skirt | 2.7 |  |  |  | 128
 |  |  |  | L1044CH | DETA Bathroom Bulk Head Light | 14.9 |  |  |  | 129
 |  |  |  | C3500 | DETA 230V Bell Complete with Built in Transformer | 8.5 |  |  |  | 130
 |  |  |  | 1111 | DETA 230V AC Mains Ionisation Smoke Alarm | 9.6 |  |  |  | 131
 |  |  |  | 1113 | DETA 230V AC Mains Optical Smoke Alarm | 13.92 |  |  |  | 132
 |  |  |  | 1115 | DETA 230V AC Mains Heat Alarm | 17.5 |  |  |  | 133
 |  |  |  | 1110 | DETA Common Smoke Detector [NAME] Terminals | 0.75 |  |  |  | 134
 |  |  |  | 1121 | DETA 230V AC Carbon Monoxide Alarm | 29 |  |  |  | 135
 |  |  |  | 1125 | DETA CO Detector with 7 Year Guarantee, Battery Operated | 15.5 |  |  |  | 136
 |  |  |  | L2841 | DETA 4 Pannel Lantern - PIR | 12.95 |  |  |  | 137
 |  |  |  | L2843 | DETA 6 Pannel Lantern - PIR | 12.95 |  |  |  | 138
 |  |  |  | L2845 | DETA Half Lantern - PIR | 22.75 |  |  |  | 139
 |  |  |  | L1590WH4 | DETA LED 6W, Dimable, Fire Rated, Fixed, Downlight WH | 18.45 |  |  |  | 140
 |  |  |  | L1590SC4 | DETA LED 6W, Dimable, Fire Rated, Fixed, Downlight SC | 18.95 |  |  |  | 141
 |  |  |  | L1590CH4 | DETA LED 6W, Dimable, Fire Rated, Fixed, [NAME] | 18.95 |  |  |  | 142
 |  |  |  | L1592WH4 | DETA LED 6W, Dimable, Fire Rated, Fixed, IP 65, Downlight WH | 18.95 |  |  |  | 143
 |  |  |  | L1592CH4 | DETA LED 6W, Dimable, Fire Rated, Fixed, IP 65, Downlight SC | 19.45 |  |  |  | 144
 |  |  |  | L1592SC4 | DETA LED 6W, Dimable, Fire Rated, Fixed, IP65, [NAME] | 19.45 |  |  |  | 145
 |  |  |  | L1580WH4 | DETA LED 4.5W, None-Dimable, [NAME], Fixed Downlight WH | 11.95 |  |  |  | 146
 |  |  |  | L1580SC4 | DETA LED 4.5W, None-Dimable, [NAME], Fixed Downlight SC | 11.95 |  |  |  | 147
 |  |  |  | L1580CH4 | DETA LED 4.5W, None-Dimable, [NAME], Fixed Downlight CH | 11.95 |  |  |  | 148
 |  |  |  | L1582WH4 | DETA LED 4.5W, None-Dimable, [NAME], IP Rated, Fixed Downlight WH | 12.95 |  |  |  | 149
 |  |  |  | L1582SC4 | DETA LED 4.5W, None-Dimable, [NAME], IP Rated, Fixed Downlight SC | 12.95 |  |  |  | 150
 |  |  |  | L1582CH4 | DETA LED 4.5W, None-Dimable, [NAME], IP Rated, Fixed Downlight CH | 12.95 |  |  |  | 151
 |  |  |  | L1370CH | DETA Low Energy, Fire Rated, Fixed [NAME] | 14.55 |  |  |  | 152
 |  |  |  | L1370SC | DETA Low Energy, Fire Rated, Fixed [NAME] | 14.55 |  |  |  | 153
 |  |  |  | L1370WH | DETA Low Energy, Fire Rated, Fixed Downlight - White C/W Lamp | 14.07 |  |  |  | 154
 |  |  |  | L1380CH | DETA Low Energy, Fire Rated, IP65 [NAME] | 15.48 |  |  |  | 155
 |  |  |  | L1380SC | DETA Low Energy, Fire Rated, IP65 [NAME] | 15.48 |  |  |  | 156
 |  |  |  | L1380WH | DETA Low Energy, Fire Rated, IP65 [NAME] | 15.13 |  |  |  | 157
 |  |  |  | L1320CH | DETA LV, Fire Rated, Fixed Downlight, C/W 50W Osram Cool Lamp - Chrome | 9.68 |  |  |  | 158
 |  |  |  | L1320SC | DETA LV, Fire Rated, Fixed Downlight, C/W 50W Osram Cool Lamp - Satin Chrome | 9.68 |  |  |  | 159
 |  |  |  | L1320WH | DETA LV, Fire Rated, Fixed Downlight, C/W 50W Osram Cool Lamp - White | 8.94 |  |  |  | 160
 |  |  |  | L1321CH | DETA LV, Fire Rated, [NAME], C/W 50W Osram Cool Lamp - Chrome | 11.06 |  |  |  | 161
 |  |  |  | L1321SC | DETA LV, Fire Rated, [NAME], C/W 50W Osram Cool Lamp - Satin Chrome | 11.06 |  |  |  | 162
 |  |  |  | [NAME] | DETA LV, Fire Rated, [NAME], C/W 50W Osram Cool Lamp - White | 9.79 |  |  |  | 163
 |  |  |  | L1330CH | DETA LV, Fire Rated, IP65 [NAME], C/W 50W Osram Lamp - Chrome | 13.56 |  |  |  | 164
 |  |  |  | L1330SC | DETA LV, Fire Rated, IP65 [NAME], C/W 50W Osram Lamp - Satin Chrome | 13.56 |  |  |  | 165
 |  |  |  | [NAME] | DETA LV, Fire Rated, IP65 [NAME], C/W 50W Osram Lamp - White | 12.5 |  |  |  | 166
 |  |  |  | L1340CH | DETA GU10, Fire Rated, Fixed Downlight, C/W 50W Osram Lamp - Chrome | 9.19 |  |  |  | 167
 |  |  |  | L1340SC | DETA GU10, Fire Rated, Fixed Downlight, C/W 50W Osram Lamp - Satin Chrome | 9.19 |  |  |  | 168
 |  |  |  | L1340WH | DETA GU10, Fire Rated, Fixed Downlight, C/W 50W Osram Lamp - White | 8.88 |  |  |  | 169
 |  |  |  | L1341CH | DETA GU10, Fire Rated, [NAME], C/W 50W Osram Lamp - Chrome | 11.74 |  |  |  | 170
 |  |  |  | L1341SC | DETA GU10, Fire Rated, [NAME], C/W 50W Osram Lamp - Satin Chrome | 11.74 |  |  |  | 171
 |  |  |  | L1341WH | DETA GU10, Fire Rated, [NAME], C/W 50W Osram Lamp - White | 10.89 |  |  |  | 172
 |  |  |  | L1360CH | DETA GU10, [NAME], IP65, [NAME], C/W 50W Osram Lamp - Chrome | 15.23 |  |  |  | 173
 |  |  |  | L1360SC | DETA GU10, [NAME], IP65, [NAME], C/W 50W Osram Lamp - Satin Chrome | 15.23 |  |  |  | 174
 |  |  |  | L1360WH | DETA GU10, [NAME], IP65, [NAME], C/W 50W Osram Lamp - White | 14.39 |  |  |  | 175