Spreadsheet: 792055d1660722740-subtracting-and-adding-automatically-stock-spreadsheet
Sheet: MAIN STOCK SHEET

STORE STOCK | QTY |  | LIQUID ECG | QTY |  | LIQUID WCG | QTY |  | TELKOM | QTY |  | HEROTEL | QTY |  | ZTE | QTY
 |  |  | ECG - 110mm Orange Duct 6m |  |  | WCG - 110mm Orange Duct 6m |  |  | Telkom  - BLT, MACH, 12MM, 1.75MM, 165MM, 60MM, GS, HEX |  |  | Herotel 12mm S/S Strapping (Per Roll) |  |  | ZTE - 110mm Duct Pipe HDPE (6m)
 |  |  | ECG - 12 Fibre UG Micro Blown |  |  | WCG - 2 Way 12/10 Duct |  |  | Telkom - BRKT - VERT E OPTCL CABL, 25x442x6mm |  |  | Herotel 5.4M POLE (100-120) CCA H4 SANS 754 |  |  | ZTE - 110mm HDPE Class 10 Drill Pipe
 |  |  | ECG - 144 Fibre Access Closure |  |  | WCG - 4 Drop Fibre |  |  | Telkom - BRKT - VERT U, OPTCL CABL, 25x200x5mm |  |  | Herotel 5.4m POLE (120-140) CCA H4 SANS 754 |  |  | ZTE - 12/10 Connectors
 |  |  | ECG - 144 Fibre UG Micro Blown |  |  | WCG - 7 Way 12/10 Duct |  |  | Telkom - BX, DISTRN, BUDI-2S 2-36 SPLIC |  |  | Herotel 7.2M POLE (120-140) CCA H4 SANS |  |  | ZTE - 12mm End Cap
 |  |  | ECG - 15U Cabinet |  |  | WCG - 72 FAC (Fibre Access Closure) |  |  | Telkom - BX, DISTRN, RHI-NODE 300STD OPN-PAL |  |  | Herotel Pole Tag Plates 50x25 With Slots, Black Letters, Silver Back Ground |  |  | ZTE - 1U Patch Panel
 |  |  | ECG - 1U Brush Panel Black |  |  | WCG - 72 Fibre UG |  |  | Telkom - CB;. FP. S,-BI-G657A2 1LT PC, 12, 2.1MM |  |  | Herotel Pole Hooks |  |  | ZTE - 1U Slack Box
 |  |  | ECG - 1U Cabinet Mount |  |  | WCG - Plastic Manhole [NAME] 1000 |  |  | Telkom - CBL, FO - AERL, 12, 1310/1550NM, SM |  |  | Herotel Pole Slack Bracket |  |  | ZTE - 48 Fibre Blown G652D
 |  |  | ECG - 2 Way |  |  | WCG - Termination Box |  |  | Telkom - CBL, FO - MCR UG 12G.652D BLOWN, 12, HDPE |  |  | Herotel Pipe 25mm NON SABS |  |  | ZTE - 4Way Micro-Duct 12/10mm
 |  |  | ECG - 25U Cabinet |  |  | WCG - Termination Box Bracket |  |  | Telkom - CBL, FO - MCR UG G.652D BLOWN, 24, HDPE, 1.7MM |  |  | Herotel Pipe 50mm NON SABS |  |  | ZTE - 50mm Bosal Bend
 |  |  | ECG - 4 Drop Fibre |  |  |  |  |  | Telkom - CBL, FO - MCR UG G652D BLOWN, 48 HDPE, 1.7MM |  |  |  |  |  | ZTE - 50mm [NAME]
 |  |  | ECG - 7 Way |  |  |  |  |  | Telkom - CBL, FO - SM-BI-G657A2 1LT PC, 12, 2.1mm |  |  |  |  |  | ZTE - 50mm [NAME]
 |  |  | ECG - Plastic Manhole [NAME] 1000 |  |  |  |  |  | Telkom - CBL, FO - SM-BI-G657A2 1LT PC, 6, 2.1mm |  |  |  |  |  | ZTE - 50mm Bosal Pipe 4m
 |  |  | ECG - Termination Box |  |  |  |  |  | Telkom - CBL, FO - SM-BI-G657D, 96 HDPE, 1.4MM |  |  |  |  |  | ZTE - 50mm [NAME]
 |  |  | ECG - Termination Box Bracket |  |  |  |  |  | Telkom - CBL, FO - SM-BI-G657D1, 144, HDPE, 1.4mm |  |  |  |  |  | ZTE - 50mm Sprague
 |  |  |  |  |  |  |  |  | Telkom - CBL, FO, AERL, 24 1310/1150NM, SM |  |  |  |  |  | ZTE - 58mm [NAME]
 |  |  |  |  |  |  |  |  | Telkom - CBL, FO, MCR UG G652D BLOWN, 72, HDPE, 1.7MM |  |  |  |  |  | ZTE - 7Way Micro-Duct 12/10mm
 |  |  |  |  |  |  |  |  | Telkom - CBL, FO, MCR UG, BLOWN, 36, PE, ORNG |  |  |  |  |  | ZTE - Black Epoxy
 |  |  |  |  |  |  |  |  | Telkom - CBL, FO, SHRT SPAN AERL, 36, PE BLK |  |  |  |  |  | ZTE - Filler Foam 750ml
 |  |  |  |  |  |  |  |  | Telkom - CBL, FO, SM, 48, PE, 1.9MM |  |  |  |  |  | ZTE - Handhole D500mm
 |  |  |  |  |  |  |  |  | Telkom - CBL, FO, SM, 72, PE, 1.9MM |  |  |  |  |  | ZTE - ODC BC6 Fist
 |  |  |  |  |  |  |  |  | Telkom - CLSUR - B8G Splic 72F, EMTY, ADPTR PNL |  |  |  |  |  | ZTE - Plastic Manhole 900mm x 900mm
 |  |  |  |  |  |  |  |  | Telkom - CLSUR - SPLIC, PLP STR-JR, 12F |  |  |  |  |  | ZTE - Trench Tape (Yellow - 500m p/r)
 |  |  |  |  |  |  |  |  | Telkom - CLSUR, TENIO-B6 48F SEAL BRKT
 |  |  |  |  |  |  |  |  | Telkom - CLSUR, TENIO-B6 96F SEAL BRKT
 |  |  |  |  |  |  |  |  | Telkom - CLSUR- TENIO-B6 144F SEAL BRKT
 |  |  |  |  |  |  |  |  | Telkom - DBL HOOKS
 |  |  |  |  |  |  |  |  | Telkom - DEDND, PRFRMD THMBL, FDES 366/374, GS
 |  |  |  |  |  |  |  |  | Telkom - DUCT - 2 WAY FLAT, 16-13MM, HDPE BLK
 |  |  |  |  |  |  |  |  | Telkom - HOOK, TRMN, DIA 10MM, GS
 |  |  |  |  |  |  |  |  | Telkom - Kit - Gel Seal RND 4 Way Gen2
 |  |  |  |  |  |  |  |  | Telkom - KIT, CUST - BUDI-1S SPLC 36-96 FB
 |  |  |  |  |  |  |  |  | Telkom - KIT, FOSC-A-SEAL-INT, 12-48 FBR CNT
 |  |  |  |  |  |  |  |  | Telkom - KIT, JOINTING PIT RHI-NODE 600 SPLT BSE
 |  |  |  |  |  |  |  |  | Telkom - KIT, LCKBL SQ 600MM FRM & CVR JNT PIT 9B
 |  |  |  |  |  |  |  |  | Telkom - MCRDCT - BUNDLED, GRN, 2 WAY, 8/5MM
 |  |  |  |  |  |  |  |  | Telkom - MCRDCT - BUNDLED, GRN, 4 WAY, 8/5MM
 |  |  |  |  |  |  |  |  | Telkom - MCRDCT - NON RODNT PFR, 1 WAY, ORNG, 12/10MM
 |  |  |  |  |  |  |  |  | Telkom - MCRDCT - SNGL, DARK BLUE, 8/5MM
 |  |  |  |  |  |  |  |  | Telkom - MICRODUCT - 2, 10/12MM HDPE
 |  |  |  |  |  |  |  |  | Telkom - MICRODUCT - 4, 10/12MM HDPE
 |  |  |  |  |  |  |  |  | Telkom - PIPE, NON METLC, POLYETHEL, 32MM, RED
 |  |  |  |  |  |  |  |  | Telkom - PIPE, NON METLC, POLYETHYLN GRN, 95MM, 6M
 |  |  |  |  |  |  |  |  | Telkom - PNL - 19IN, FOWB
 |  |  |  |  |  |  |  |  | Telkom - PNL, Patch - FOWB-T-NNNNN - EMPTY
 |  |  |  |  |  |  |  |  | Telkom - PNL, PATCH - MFPS-JED-P-SKL1-144, LC/PC LH
 |  |  |  |  |  |  |  |  | Telkom - POLE, PWR, MED DUTY, 7M, WOD, RNDED, CCA TRTD
 |  |  |  |  |  |  |  |  | Telkom - SEAL - TENIO-SKG3 5-8MM CABL DIA, 3 PORT
 |  |  |  |  |  |  |  |  | Telkom - SEAL, TENIO-SKG2 11-14MM CABL DIA, 2 PORT
 |  |  |  |  |  |  |  |  | Telkom - SEAL, TENIO-SKG3 5-8MM CBL DIA, 3 PORT
 |  |  |  |  |  |  |  |  | Telkom - SEAL, TENIO-SKG3 7-10MM CABL DIA, 3 PORT
 |  |  |  |  |  |  |  |  | Telkom - SEAL, TENIO-SKG4 3-6MM CABL DIA, 4 PORT
 |  |  |  |  |  |  |  |  | Telkom - SLV, FBR SPLIC PRTCTR, 45MM
 |  |  |  |  |  |  |  |  | Telkom - SPLTR, FO - 1;32 WITH HLDR
 |  |  |  |  |  |  |  |  | Telkom - SPLTR, FO - 1;32 WITH HLDR+ SPLIC TRAY
 |  |  |  |  |  |  |  |  | Telkom - SPRT, TANGENT, 11.1-12MM, GS
 |  |  |  |  |  |  |  |  | Telkom - SPRT, TANGENT, 13.1-14.1MM, GS
 |  |  |  |  |  |  |  |  | Telkom - SPRT, TANGENT, GS
 |  |  |  |  |  |  |  |  | Telkom - SPRT, THMBL, 10.55-11.66MM, GS
 |  |  |  |  |  |  |  |  | Telkom - SPRT, THMBL, 12.8-14.1MM, GS
 |  |  |  |  |  |  |  |  | Telkom - Tray - HRZNTL SLCK STRG SPRTNG 100 FBR, 2U
 |  |  |  |  |  |  |  |  | Telkom - TRENCH TAPE / DANGER TAPE
 |  |  |  |  |  |  |  |  | Telkom - UNIT - CABL TRMN TENIO LRG
 |  |  |  |  |  |  |  |  | Telkom - UNIT - CABL TRMN, TENIO SML