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

DRUM No | DRUM REF # | INT or EXT | FIBRE | REMAINING | LOCAT C or Y | MAKE | ON SITE | START | END | FLY | Dir | OPP NAME | JOB AMOUNT | DATE ISSUED | COST PER M | [NAME]
 | LG25DM102299 | INT / EXT | 12 | 2003 | C | T | YES | 2002 | 4005 |  |  |  |  |  | 0.44
 | ALG25D0UK2061 | INT / EXT | 12 | 163 | C | T | YES |  |  | 293 |  |  |  |  | 0.44
 | LG25DM100863 | INT / EXT | 12 |  |  | T | NO | 2006 | 2007?
 | ALG25D0UK2566 | INT / EXT | 12 |  | C | T |  |  |  | 235
 | 1713 | INT / EXT | 12 | 220 | C | T | YES |  |  | 220
 | LG25DM100861 | INT / EXT | 12 | 4000 | C | T | YES
 | LG25DM102383 | INT / EXT | 12 | 336 | C | T | YES
 | 6XP45789 | INT / EXT | 12 |  |  | N | NO | 2197 | 00197 | 3054 | 5 |  |  |  | 0.512
 | 8XCH01257 | INT / EXT | 12 | 600 |  | N W | YES | 4257 | 6257 |  |  |  |  |  | 0.512
 | 8XCH01258 | INT / EXT | 12 |  |  | N W | NO | 10331 | 12331
 | 8XCH01260 | INT / EXT | 12 | 360 | C | N W | YES | 6258 | 8258
 | 8XCH01262 | INT / EXT | 12 |  |  | N W | NO | 8285 | 10285
 | 8XCH02038 | INT / EXT | 12 |  |  | NW | NO
 | 8XCH02044 | INT / EXT | 12 | 408 | C | NW | YES |  |  | 5711
 | 8XCH02046 | INT / EXT | 12 |  |  | NW | NO
 | 8XCH02051 | INT / EXT | 12 | 2000 | C | NW | YES
 | 8XCP87712 | INT / EXT | 12 | 2000 | C | N | YES | 10259 | 12309
 | 8XCP87713 | INT/EXT | 12 |  |  | N | NO | 8208 | 10258
 | 8XCP87714 | INT / EXT | 12 |  | C | N | NO | 6157 | 8207
 | 8XCP87716 | INT / EXT | 12 |  |  | N | NO | 2055 | 4105
 | 8XCP87717 | INT / EXT | 12 | 1850 | C | N | YES | 4 | 2054
 | 8XP82049 | INT / EXT | 12 | 150 | C | N | YES | 7702 | 5702
 | 8XP84243 | INT / EXT | 12 |  |  | N | NO | 8367 | 10367
 | 8XP84244 | INT / EXT | 13 |  | C | N | NO | 6366 | 8366 |  |  |  |  |  | 0.519
 | 8XP84245 | INT / EXT | 14 |  |  | N | NO | 4365 | 6365 |  |  |  |  |  | 0.519
 |  | INT / EXT | 12 |  |  | N |  |  |  |  | 5 |  |  |  | 0.519
 |  | INT / EXT | 12 |  |  |  |  |  |  |  |  |  |  |  | 0.256
 |  | INT/EXT | 12 |  |  |  |  |  |  |  |  |  |  |  | 0.255
 | NEXANS
 | TURNKEY
 | 12 FIBER INTERNAL
 | 8XP78568 | EXT | 12 | 190 | C | USED | YES | 4504 | 2504 | 4229 | 5 |  |  |  | 0.405
 | 8XP77451 | EXT | 12 | 200 | C | USED | YES | 6505 | 4505 | 6066 | 5
 | 8XP80315 | EXT | 12 | 408 | C | USED | YES | 14187 | 16187
 | 8XP80317 | EXT | 12 |  |  | NEW | NO | 18189 | 20189
 | 8XP80314 | EXT | 12 | 2000 | C | NEW | YES | 12186 | 14186
 | 8XP77450 | EXT | 12 | 243 | C | USED | YES | 8506 | 6506 | 8257
 | 8XP78664 | EXT | 12 | 2000 | Y | NEW | YES
 | k7-0850 | EXT | 12 | 600 | C | HEX | YES |  |  |  | 6
 | 8XP78666 | EXT | 12 | 180 | C | USED | YES | 4002 | 6002 | 4491 | 6
 | 10XP26322 | EXT | 12 | 308 | C | USED | YES | 0000 | 0000 | 308 | 6
 | 8XP80316 | EXT | 12 |  |  | NEW | NO | 16188 | 18188
 | 8XP76679 | EXT | 12 |  |  | USED | NO |  |  | 295 | 6
 | 8XP78667 | EXT | 12 |  |  | NEW | NO | 6003 | 8003 | 6517 | 6
 | K7-23453 | EXT | 12 | 2000 |  | NEW | YES | 1 | 2001 |  |  |  |  |  | 0.31
 | K7-23451 | EXT | 12 | 2000 |  | NEW | YES | 4003 | 6003 |  |  |  |  |  | 0.31
 | K7-23452 | EXT | 12 | 1360 |  | NEW | YES | 2002 | 4002 |  |  |  |  |  | 0.31
 | K7-23450 | EXT | 12 | 2000 |  | NEW | YES | 6004 | 8004 |  |  |  |  |  | 0.31
 |  | EXT | 12
 | NEXANS |  | 12
 | NEXANS |  | 12
 | 12 FIBER EXTERNAL
 |  |  | 12 | 500 |  | NOT FOR USE |  |  |  |  |  |  |  |  | 1.5
 | 12 FIBRE ARMOURED
 |  | BF | 4 | 4000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER | 0.12
 |  | BF | 4 | 4000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 4 | 1397 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 4 |  |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 4 | 4000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 4 | 4000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 4 | 4000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 4 | 4000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 4 | 357 |  | HEX | YES |  |  |  |  |  |  | CONTAINER | 0.12
 | 4 BLOWN BUNDLE
 |  | BF | 12 | 234 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 12 | 80 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 12 | 387 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 12 |  |  | HEX |  |  |  |  |  |  |  | CONTAINER | 0.24
 |  | BF | 12 | 2000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER | 0.24
 |  | BF | 12 | 2000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 12 | 2000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 12 | 2000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER
 |  | BF | 12 | 2000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER | 0.24
 | 12BLOWN BUNDLE
 |  | BF | 24 | 2000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER | 0.36
 |  | BF | 24 | 2000 |  | HEX | YES |  |  |  |  |  |  | CONTAINER | 0.36
 |  | BF | 24 |  |  | HEX | YES |  |  |  |  |  |  | CONTAINER | 0.24
 | 24 BLOWN BUNDLE
 | UKNOWN | INT / EXT | 24 | 1847 | C | T | YES |  |  | 1847 | 6 |  |  |  | 0.4
 |  | INT / EXT | 24 | 400 | C | T | YES |  |  | 3598 | 5 |  |  |  | 0.4
 |  | INT / EXT | 24 | 2000 | C |  | YES |  |  |  |  |  |  |  | 0.8
 |  | INT / EXT | 24
 | 24 FIBER INTERNAL
 | 0850FN/50592/2 | EXT | 24 | 746 | C |  | YES | 0 | 2009 |  |  |  |  |  | 0.38
 | 0850FN/50555/2 | EXT | 24 | 2000 | Y |  | YES | 0 | 2010
 | 0850FN/50575/2 | EXT | 24 |  | C |  | NO | 0 | 2009
 | 0850FN/50586/2 | EXT | 24 | 2000 | Y |  | YES | 0 | 2039
 | K7-6227 | EXT | 24 | 2000 | Y |  | YES | 4003 | 6003
 | K7-6236 | EXT | 24 | 2000 | Y |  | YES | 2003 | 4003
 | K7-6226 | EXT | 24 | 2000 | Y |  | YES | 6004 | 8004
 | K7-6229 | EXT | 24 | 2000 | Y |  | YES | 1 | 2002
 | 0850FN/50227/2 | EXT | 24 |  |  |  | NO | 0 | 2028
 | 0850FN/50237/2 | EXT | 24 |  |  |  | NO | 0 | 2028
 | 0850FN/50096/2 | EXT | 24 |  |  |  | NO | 0 | 2028
 | 0850FN/50254/2 | EXT | 24 | 181 |  |  | YES | 0 | 2028 |  |  |  |  |  | 0.376
 | NO IDENT | EXT | 24 |  |  |  | NO |  |  |  |  |  |  |  | 0.4
 |  | EXT | 24 | 160 |  |  | YES | 6005 | 8005 |  |  |  |  |  | 0.4
 | 10XP28357 | EXT | 24 | 1780 |  |  | NO | 16000 | 20000 |  |  |  |  |  | 0.4
 | K7-767 | EXT | 24 |  |  |  | NO | 0001 | 2002 | 75 |  |  |  |  | 0.4
 |  | EXT | 24 |  |  | USED
 | NEXANS | EXT | 24
 | HEXATRONIC | EXT | 24
 | 24 FIBER EXTERNAL
 | K8-20220 | EXT | 48 | 4000 | Y |  | YES | 4004 | 8004 |  |  |  |  |  | 0.67
 | K8-20221 | EXT | 48 | 4000 | Y |  | YES | 1 | 4003
 | K8-20231 | EXT | 48 | 3200 | Y |  | YES | 4004 | 8004
 | K8-02351 | EXT | 48 | 3700 | C |  | YES
 | 50059/2 | EXT | 48 |  | C |  | NO
 | 10XP29049 | EXT | 48 | 540 | C |  | YES | 8246 | 4246 | 7702 | 6 |  |  |  | 0.63
 | 10XP28217 | EXT | 48 |  |  |  | NO | 8002 | 12182 | 8360 | 6 |  |  |  | 0.63
 | 10XP28388 | EXT | 48 |  |  |  | NO | 8018 | 12018 |  | 6 |  |  |  | 0.63
 | 10XP28389 | EXT | 48 |  |  |  | NO | 4017 | 8017 | 7754 | 5 |  |  |  | 0.63
 | 10XP25231 | EXT | 48 |  |  |  | NO |  |  | 190 |  |  |  |  | 0.63
 |  | EXT | 48 |  |  |  |  |  |  |  |  |  |  |  | 0.68
 |  | EXT | 48 |  |  |  |  |  |  |  |  |  |  |  | 0.63
 |  | EXT | 48 |  |  |  |  |  |  |  |  |  |  |  | 0.63
 |  | EXT | 48 |  |  |  |  |  |  |  |  |  |  |  | 0.63
 | HEXATRONIC |  | 48
 | NEXANS |  | 48
 | 48 FIBER EXTERNAL
 | 7181830 | INT | 48 | 365 |  |  | YES |  |  |  |  |  |  |  | 1.5
 | 7181847 | INT | 48 | 1395 |  |  | YES |  |  |  |  |  |  |  | 1.5
 | 48 FIBER INTERNAL
 |  | INT / EXT | 96 | 600 |  | 620 | YES | 2000 | 000 | 1375 | 5 |  |  |  | 1.49
 | 12X52870 | INT / EXT | 96 | UNK |  |  | YES |  |  | 736
 |  | INT / EXT | 96 |  |  | USED | NO | 501 | 701 |  |  |  |  |  | 2.5
 | 96 FIBRE INTERNAL
 |  | EXT | 96
 | 12XP00374 | EXT | 96 | 1250 | C |  | YES | 7946 |  | 6016
 | 0840FN/50285/2 | EXT | 96 | 4000 | Y | HEX WOOD | YES | 0 | 4079
 | 0840FN/50284/2 | EXT | 96 | 4000 | Y | HEX WOOD | YES | 0 | 4010 |  | 6
 | K8-3471 | EXT | 96 | 1600 |  | EX-NON | YES
 | K8-3165 | EXT | 96 | 290 |  | EX-NON | YES
 |  | EXT | 96 |  |  |  |  |  |  |  |  |  |  |  | 1.12
 |  |  | 96 |  |  |  |  |  |  |  |  |  |  |  | 1.06
 |  |  | 96 |  |  |  |  |  |  |  |  |  |  |  | 1.06
 | 96 FIBER EXTERNAL
 | 10XP26678 | EXT | 144 | 1990 | Y | BAU BLOW | YES |  |  |  |  |  |  |  | 2.347
 | K8-02214 | EXT | 144 | 2000 | Y | HEX | YES | 1 | 2002 |  |  |  |  |  | 1.67
 | K10-2876 | EXT | 144 |  |  |  |  |  |  |  |  | UNKNOWN USAGE OR PROJECT
 |  |  | 144 |  |  | plus part drums Zayo
 | 144 FIBER EXTERNAL
 | old 12f drum | INT | 144 | 200 | C |  | YES | 300 | 499
 | 12XCH04265 |  | 144 | 4000 | Y |  | YES | 6021 | 2021 |  |  |  |  |  | 2.347
 | NON DRUM |  | 144
 | 144 INTERNAL
 | 16XCH0468 |  | 288 | 480 |  |  | YES | 54 | 6054 | 5574 |  |  |  |  | 0.304
 | K12-21405 | EXT | 288 | 4000 |  | HEX PLAST | YES | 0 | 4000
 | K12-21337 | EXT | 288 | 4000 |  | HEX PLAST | YES | 0 | 4000
 | K12-21340 | EXT | 288 | 4000 |  | HEX PLAST | YES | 0 | 4000
 | K12-21411 | EXT | 288 | 4000 |  | HEX PLAST | YES | 0 | 4000
 | K12-21486 | EXT | 288 | 4000 |  | HEX PLAST | YES | 0 | 4000 |  | 5
 | K12-21271 | EXT | 288 | 4000 |  | HEX PLAST | YES | 0 | 4000 |  |  |  |  |  | 3.44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.4
 | 70 | EXT | 288 | 990 | C | S80785 | YES | 2 |  | 998 | 6 |  |  |  | 0.304
 | Black small drum | EXT | 288 |  |  |  | NO | 12048 |  | 11643 | 5
 | NEXANS |  | 288
 | 288 EXTERNAL |  |  |  |  |  | 12,000 M - 2 DRUMS
 | 53126 | EXT | G655 | 1460 |  |  | YES
 | 11124 | EXT | G655 | 2389 |  |  | YES
 |  | EXT | G655 | 4000 |  |  | YES |  |  |  |  |  | Owned by City Fibre
 | G655 CABLE NOT FOR USE
 |  |  | 432
 |  |  | 432
 |  |  | 432
 |  |  | 432 |  |  |  |  |  |  |  |  |  | reserved LDN upgrade
 |  |  | 432 |  |  |  |  |  |  |  |  |  | belongs to EU
 |  |  | 432 |  |  |  |  |  |  |  |  |  | off cut remainders
 | 432 FIBRE