Spreadsheet: 836945d1689751847-how-can-i-make-2-copies-of-an-excel-workbook-that-updates-stock-list-revision-work
Sheet: MDU

MDU CONTAINER LISTING
PRODUCT | TYPE/CODE | SIZE | DoQ | SHELF  STK | MIN STOCK | MOQ | SUPPLIER | COMMENT | ORDER | COST | [NAME]
WHITE PVC CONDUIT 20mm
CR6W 20mm WHITE CONDUIT 3 METRE | CR6W |  | ea | 120 | 100 |  | SRM |  |  | 1.63
2MRB2W 20mm WHITE PVC TERMINAL BOX | 2MRB2W |  | ea | 7 | 5 |  | SRM
[NAME]mm WHITE PVC THR BOX | 2MRB3W |  | ea | 5 | 5 |  | SRM
2MRB5W20mm WHITE PVC ROUND TEE BOX | 2MRB5W |  | 20 | 7 | 5 |  | SRM
2MRB4W20MM WHTE PVC ROUND RT ANGLE BOX | 2MRB4W |  | 20 | 8 | 5 |  | SRM
MC2W 20mm WHITE PVC COUPLER | MC2W |  | 100 Bx | 9 | 3 |  | SRM
MIB2W 20mm PVC INSPECTION BEND | MIB2W |  | 20 Bx | 11 | 3 |  | SRM
MIT2W 20mm WHITE PVC INSPECTION TEES | MIT2W |  | 20 Bx | 13 | 5 |  | SRM
MCL1W MT WHITE PVC BOX LID STD | [NAME] |  | 100 Bx | 1 | 1 |  | SRM
MAB2W 20mm WHITE PVC FEMALE ADAPTOR | MAB2W |  | 100 Bx | 10 | 3 |  | SRM
MIE2W20mm WHITE PVC INSPECTION ELBOW | MIE2W |  | 20 Bx | 23 | 5 |  | SRM |  |  | 1.26
M4 X 20 BRASS MACHINE SCREWS | M4X20 |  | 100 | 20 | 5 |  | SRM |  |  | 4.01
WHITE PVC CONDUIT CABLE FIRE CLIPS | SDCCAB16W/100 CABLE CLIP | 16/21mm | 100 | 37 | 20 |  | SRM |  |  | 40
BLACK PVC CONDUIT 20mm
CR6B MT 20MM BLACK HG PVC CONDUIT 3M LENGTH | CR6B |  | ea |  |  |  | SRM |  |  | 4.034
M1E2B MT 20MM BLACK INSPECTION ELBOWS | M1E2B |  | ea |  |  |  | SRM |  |  | 1.793
[NAME] | MSB2B |  | ea |  |  |  | SRM |  |  | 0.6706
20MM BLACK PVC COUPLINGS | MC2B |  | ea |  |  |  | SRM |  |  | 0.47
BLACK 25MM GALVANISED CONDUIT
BLACK 25mm GALV CONDUIT 3.75M | BC25 | 25mm |  | 32 | 10 |  | SRM |  |  | 23.74
BLACK 25mm GALV TERMINAL BOX | [NAME] |  |  | 23 | 20 |  | SRM
BLACK 25mm CONDUIT THROUGH BOX | MB9B |  |  | 32 | 10 |  | SRM
BLACK 25mm CONDUIT ANGLE BOX | MB10B |  |  | 38 | 10 |  | SRM
BLACK 25mm CONDUIT COUPLER | SC2B |  |  | 53 | 10 |  | SRM
BLACK 25mm GALV LID | BL1B |  |  | 3 | 2 |  | SRM
BLACK 25mm GALV DISTANCE SADDLE standoff | DS2B |  |  | 76 | 50 |  | SRM
SB25BL BLACK 25mm GALV SPACER SADDLE flat | SB25BL |  |  | 190 | 50 |  | SRM
[NAME] (100) |  |  |  | 1 | 1 |  | SRM
PLASTIC BLACK SADDLES | Black - 25mm |  |  | 88 | 50 |  | Hexatronic |  |  | 0.8
BLACK 20MM GALVANISED CONDUIT
BC20 BLACK 20mm GALVANISED CONDUIT 3.75m | BC20 | 20mm | ea | 44 | 10 |  | SRM
IE1B BLACK 20mm GALV INSPECTION ELBOW | IE1B | 20mm | 10 bx | 8 | 3 |  | SRM
SBS20B SPACER BAR SADDLE 20MM BLACK GALV flat | SBS20B | 20mm | 100 bx | 3 | 3 |  | SRM |  |  | 0.17
DS1B DISTANCE SADDLE 20MM BLACK GALV standoff | DS1B | 20mm | 50 bx | 5 | 3 | 50 | SRM |  |  | 0.73
[NAME] 20MM BLACK PVC FEMALE ADAPTOR | MAB2B | 20mm | ea | 60 | 20 |  | SRM |  |  | 0.3
BLACK 25mm COATED STEEL KOPEX
BLACK GALV KOPEX 25MM 50 MTR REEL C25-50M |  | 25mm | 50m | 0 |  |  |  |  |  | 141.67
QF25 25mm METAL/RUBBER P CLIPS |  | 25mm | ea | 200 |  |  |  |  |  | 0.76
GREY 20mm GALVANISED CONDUIT
CON203M GALV CONDUIT GREY 3M | COM203M |  | ea | 7 | 24 |  | SRM |  | 56
GREY 20mm GALV TERMINAL BOX | V12820G |  | ea | 123 | 20 |  | SRM
GREY 20mm CONDUIT THROUGH BOX | V13020G |  | ea |  | 10 |  | SRM
GREY 20mm CONDUIT TEE BOX |  |  | ea | 25
GREY 20mm CONDUIT ANGLE BOX | V13120G |  | ea | 15 | 10 |  | SRM
GREY 20mm GALV INSP BEND | V12320G |  | ea |  | 50 |  | SRM
GREY 20mm INSP ELBOW | V11020G |  | 10 bx | 11 | 10 |  | SRM
GREY 20mm CONDUIT COUPLER | V10120G |  | ea | 15 | 10 |  | SRM |  |  | 0.25
GREY 20mm GALVANISED CON-LOK CONDUIT
CL1G 20mm CONLOK GALV END BOX | CL1G |  | 10 bx | 5 | 5 |  | SRM |  |  | 3.5
[NAME] CONLOK GALV ANGLE BOX | [NAME] |  | 10 bx | 5 | 5 |  | SRM |  |  | 3.82
CL2G 20mm CONLOK GALV THROUGH BOX | CL2G |  | 10 bx | 6 | 5 |  | SRM |  |  | 3.82
CL4G 20mm CONLOK GALV TEE BOX | CL4G |  | 10 bx | 6 | 5 |  | SRM |  |  | 3.97
CL20GC 20mm CONLOK GALV COUPLER | CL20GC |  | 40 bx | 4 | 3 |  | SRM |  | 50
CL20MB 20mm CONLOK GALV BEND | CL20MB |  | 10 bx | 3 | 1 |  | SRM
V141LG GREY 20mm GALV LID | V141LG |  | 100 bx | 530 | 100 |  | SRM
V75520G GREY 20mm GALV DISTANCE SADDLE standoff | V75520G |  | 50 bx | 40 | 10 |  | SRM
V74520G GREY 20mm GALV SPACER SADDLE flat | V74520G |  | 100 bx | 12 | 8 |  | SRM
Metal Rawlplug for No 8 screw | SA5 M5x30 |  | per 100 | 34 | 25 |  | SRM
D-Line Screws | DLINE DFIX/100 FIRERATED SCREW |  | 100pk | 36 | 25 |  | SRM
25mm Galvanised Flexible Conduit 10M |  |  | ea | 4
Galvanised No 1 Boot | S83-2758 |  | ea | 40 | 20 |  | Mills Ltd
Galvanised No 1 Boot |  |  | ea | 0 |  |  | SRM
JOINTS/DISTRIBUTION BOXES
[NAME] 12F BLACK | CFMDU-CTB2-B-P12-ALC |  | ea | 51 | 18 | 9 | HEXATRONIC |  |  | 32.76
[NAME] GREY | CFMDU-CTB2-G-P12-ALC |  | ea | 36 | 18 | 9 | HEXATRONIC |  | 54
DP MOUNTING BRACKET | FCLC-C2-CBKT-BK |  | ea | 15 |  |  | HEXATRONIC |  | 31
ASN-DISTRIBUTION  ODE UNLOADED | CFMDU-ASN-B-P12-ALC-PIG |  | ea | 0 |  |  | HEXATRONIC
ASN - Distribution Node - 16f - Split/Patch - 1:8(2) - ALC - Black | CFMDU-ASN-B-P16-1X8-ALC |  | ea | 9 | 5 |  | HEXATRONIC
ASN - Distribution Node - 16f - Split/Patch - 1:8(2) - ALC - Grey | CFMDU-ASN-G-P16-1X8-ALC |  | ea | 10 | 5 |  | HEXATRONIC
ASN - Distribution Node - 24f - Splice/Patch - ALC - Grey | CFMDU-ASN-G-P24-ALC-PIG |  | ea | 19 | 10 |  | HEXATRONIC
ASN - Distribution Node - 24f - Splice/Patch - ALC - Black | CFMDU-ASN-B-P24-ALC-PIG |  | ea | 57 | 10 |  | HEXATRONIC |  |  |  |  | \
ASN - Distribution Node - 12f - Splice/Patch - ALC - Black | CFMDU-ASN-B-P12-ALC-PIG |  | ea | 28 | 10 |  | HEXATRONIC
ASN - Distribution Node - 12f - Splice/Patch - ALC - Grey | CFMDU-ASN-G-P12-ALC-PIG |  | ea | 30 | 10 |  | HEXATRONIC |  |  | 46.8
ASN MOUNTING BRACKET | CFMDU-ASN-BKT-005-BK |  | ea | 44 | 15 |  | HEXATRONIC |  |  | 13.5
INT MID SPAN UNIT | CFMDU-SB01-P02-ALC-LDD |  | ea | 123 | 40 |  | HEXATRONIC | 2 WEEKS |  | 6 |  | 6
EXTERNAL MID SPAN BOX | 100x100x55 PVC ADAPTABLE BOX |  | ea | 199 | 50 |  | SRM |  |  | 3.63
AFN - 24 F EXTERNAL JOINT UNIT BLACK CAN ALSO BE USED WITH 1:32 SPLITTER AND 30 FIBRES | AFN-CF-SPTRY  AFN, BK, CE KIT 7MM, DC 4MM, Splice Tray only |  | ea | 53 | 10 |  | Hellermann |  |  | 22.77
EXTERNAL JOINT MOUNTING BRACKET | MB-AFN/PWB-CF/BK-400mm X 01 |  | ea | 42 | 10 |  | Hellermann
TRANSPORT TUBE  TU-3F-1MX8 | 857-40285 | 4 |  |  | 10 | N/A | HELLERMAN
Fibre Access Wallbox | Indoor |  |  | 4 |  |  | HEXATRONIC |  |  | 94
1:8 SPLITTER | SPLITTER-1X8-BE  1x8 Splitter-250 micron - Bare Ends |  | ea |  |  |  |  |  |  | 16.13
1:8 SPLITTER | FPCS-PS0F0-108-0/0-0/0 SPLITTERS, PLC 1:8 250uM |  | ea |  |  |  | Hexatronic |  |  | 14.07
1:4 SPLITTER | FPCS-PS0F0-104-0/0-0/0 SPLITTERS, PLC 1:4, 250uM |  | ea |  |  |  | Hexatronic |  |  | 13.21
1:16 [NAME] | FPCS-PS0F0-116-0/0-0/0 SPLITTERS, PLC 1:16, 250uM |  | ea |  |  |  | Hexatronic |  |  | 19.75
1:32 [NAME] | FPCS-PS0F0-132-0/0-0/0 SPLITTERS, PLC 1:32, 250uM |  | ea |  |  |  | Hexatronic |  |  | 28.53
TRUNKING 25 x 16mm WHITE
25 x 16mm MINITRUNKING | MT25 |  | ea | 57 | 26 |  | SRM
FALCON 25 x 16mm STOP END (10) | FSE2 |  | 50 | 200 |  |  | SRM
FALCON 25mm x 16mm INTERNAL ANGLE (10) | FIA2 |  | 50 | 100 |  |  | SRM
.FALCON 25mm x 16mm EXTERNAL ANGLE (10) | FEA2 |  | 50 | 100 |  |  | SRM
FALCON 25mm x 16mm FLAT ANGLE (10) | FFA2 |  | 50 | 100 |  |  | SRM
FALCON 25mm x 16mm COUPLER | FSC2 |  | 50 | 100 |  |  | SRM
TUFFLEX 25mm x 16mm TEE |  |  |  | 100
SCREWFIX 25mm x 16mm END STOP |  |  |  | 80
TRUNKING 50MM GALVANISED
[NAME] 50x50 Trunking | ST22 |  | ea | 31 | 10 |  | SRM |  |  | 13.98
[NAME] 50x50 Trunking Stop End | SA22SE | 50x50 | ea | 40 | 30 |  | SRM |  |  | 1.75
SA2290E TRENCH 50 X 50 EXT 90 TRUNKING BEND | SA2290E | 50x50 | ea | 30 |  |  | SRM |  |  | 5.11
SA2290I TRENCH 50 X 50 INTERNAL 90 TRUNKING BEND | SA2290I | 50x50 | ea | 30 |  |  | SRM |  |  | 5.11
EXTERNAL CATENARY WIRING PARTS
Catenary Wire | R02-0670 | 100m | Reel | 9 | 10 |  | Mills Ltd |  |  | 28.55
Catenary Wire 3mm 100m REEL |  | 100m |  | 15 | 0 |  | SRM |  |  | 39.45
M6 x 75mm shield anchor eyebolt |  | 50 bx | per 50 | 20 | 40 |  | SRM |  |  | 23.97
M6 x 75mm shield anchor eyebolt |  | 25bx | per 25 | 94 | 50 |  | SRM
M10 x 108mm Sheild Anchor Eyebolt |  |  | per 25 | 3 | 1 |  | Ironmongery Direct
[NAME] Hook Open Body Turnbuckle | SC101 |  | ea | 0 |  |  | SRM
3mm Thimbles | SKU3882 | 50 bag | ea | 2650 | 1500 |  | Steel Gear
3mm Wire Rope Grip | [NAME] | 50 bag | ea | 3300 | 1500 |  | Steel Gear
[NAME] Hook Open Body Turnbuckle | SKU3202 |  | ea | 645 | 750 |  | Steel Gear
Catenary Cable Coil Box Black | FCLW-MDUCOIL-XH-BK |  | ea | 40 |  |  | Hexatronic
Catenary Cable Coil Box Brown | FCLW-MDUCOIL-XH-BN |  | ea | 25 |  |  | Hexatronic
NTB50S TERM TECH 200 X 4.8MM BLACK Cable ties |  |  | 100 bag | 5 | 10 |  | SRM |  | 20
STAINESS STEEL TIES 4.6mm x 150mm | CT/SS/4.6/150 |  | 100pk | 0 | 10 |  | SRM
STAINESS STEEL TIES 4.6mm x 100mm | CT/SS/4.6/A00 STEEL TIE |  | 100pk | 51 | 20 |  | SRM |  |  | 9.1
CABLE [NAME] | CRAD78B |  | 100 bag | 11 |  |  | SRM |  |  | 4.7
6mm Blk Spiral Wrap |  | 6mm | 50m | 3 |  |  | SRM |  |  | 19.74
[NAME]
[NAME] 3mm | 1LCW003 |  | 100 PK | 97 | 50 |  | SRM
Fire Clips Galvanised 25mm | D-LINE SAFE-D30/100 |  | 100 PK | 37 | 30 |  | SRM
7mm BLACK ROUND CLIPS | CC/N/R7/B | 7mm |  | 12 |  |  | SRM
3.5mm Black Cable Clips | CBBR7270 | 3.5mm | 20 PK | 100 | 4 |  | SRM
Screws Metal | 3.5 x 32mm 1000pcs/box |  | 1000 | 2 |  |  | SCREWFIX
Screws Metal | 3.5 x 25mm 1000pcs/box |  | 1000 | 5 |  |  | SCREWFIX
Screws | 5mm x 50[NAME] | 5 x50 | 200 | 7 | 3 |  | TOOLSTATION
Screws | 8 x 1" |  | 200 | 9 | 2 |  | SRM
Screws | 8 x 1 1/2" |  | 200 | 2 | 2 |  | SRM
White Snap-on Caps |  |  | 100 | 5 | 3 |  | TOOLSTATION
Brown 7mm Rawlplug |  | 7mm | 288 | 0 | 3 |  | AMAZON
M5 X 25mm S/Steel Pan Head Screws |  | M5 x 25 | 50pk | 10 | 5 |  | SRM
7mm SD Connectors |  | 7mm | 10PK | 29 |  |  | HEXATRONIC
7mm SD Connectors |  | 7mm | 10pk | 0 |  |  | EMTELLE
7-5MM SD Reducers |  | 7-5mm | 10pk | 90 |  |  | EMTELLE
[NAME] | 35887 |  | ea | 0 | 10 | NO ORDER | SCREWFIX
White Sealant | 5689R |  | ea | 0 | 10 | NO ORDER | SCREWFIX
[NAME] | 80129 |  | ea | 0 | 2 |  | SCREWFIX
Pyrocoustic Sealant | S00-9312 |  | ea | 8 | 10 |  | MILLS |  |  | 1.94
Filler | 1 Ltr |  | ea | 1 |  |  | SCREWFIX |  |  | 10.99
Discreet Glue | CFMDU-DIS-ADH-01 |  | ea | 135 |  |  | Hexatronic |  |  | 8
Discreet Glue Gun | CFMDU-DIS-GUN-01 CFMDU |  | ea | 3 |  |  | Hexatronic |  |  | 22
[NAME] | FOAM-DIS-ADHTIP-20AWG | pack 25 | ea | 3 |  |  | Hexatronic |  |  | 3
3mm Discrete Radius Bends Protector int | CFMDU-DIS-INT-CL |  | 10 | 50 |  |  | Hexatronic
3mm Discrete Radius Bends Protector Ext | CFMDU-DIS-EXT-CL |  | 10 | 50 |  |  | Hexatronic
[NAME] pipe weld cement [NAME] |  |  |  | 2 |  |  | SCREWFIX
Pipe bender |  |  |  | 0
Bending Spring 15[NAME] | 39016 |  |  | 0 |  |  | SCREWFIX
BS20 Niglon 20mm Bending Spring | BS20 |  |  | 0 |  |  | SRM
Bending Spring 22[NAME] | 46276 |  |  | 2 |  |  | SCREWFIX |  |  | 2.99
Ladders Stability Device |  |  |  | 1
CABLE
2 FIBRE BROWN |  |  | 1000m | 11 | 5 |  | WEBRO |  |  | 0.22
2 FIBRE WHITE |  |  | 1000m | 18 | 5 |  | WEBRO
PART USED DRUMS
WHITE USED |  |  |  | 735
 |  |  |  | 143
BROWN USED |  |  |  | 645
 |  |  |  | 570
12F WHITE |  |  |  | 2535 |  |  |  |  |  | 0.36
PART DRUMS |  |  |  | 2669 |  |  |  |  |  | 0.36
 |  |  |  | 679
24F WHITE |  |  |  | 1577 |  |  |  |  |  | 0.45
PART DRUMS |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | TOTAL