{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["COVER","NED Control Plant BOM","CP FEES","Cables","Materials","Long Lead Material","TELECONTROL","Cost Summary","Panel Footprints","BOM","PIC"],"not_rendered":{"external_links":1,"defined_names":239,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"COVER","index":0,"n_rows":48,"n_cols":8,"rows_kept":48}
[]
[]
["BILL OF MATERIALS : FINAL (SECONDARY PLANT)"]
[]
["MAKHATINI 2 x 3MVAr 22kV CAP BANK ESTABLISHMENT"]
[]
["PROJECT ID No: ",null,"ET-RFM-1601-3505-00001",{"$nulls":3},"Date:","2021-10-25"]
["WBS No:",null,"T.B.A",{"$nulls":3},"Revision:",1]
[]
["NOTES :"]
[]
["1. This schedule is to be used for ordering purposes, only once the associated"]
["   ERA has been approved. "]
["  NB. Materials Management are to confirm, via a return signed copy of"]
["  this document, that there are no deviations to the material and equipment"]
["  stipulated. Should there be necessity to change an indicated item, this"]
["  must be identified clearly on the return copy to Secondary Plant"]
["  (ED Project Engineering) and only ordered subject to their approval."]
[]
["2. The revisions to this document are listed as follows: "]
["Rev 0:"]
["Rev 1:","Added a SAP No. for Belden armoured cable.  Unit Cost increased from R90 to R130."]
["Rev 2:","Added:","1 x SERIAL TRAY WITH 1 MOXA"]
[null,"Removed:","60m x 10 pair, 0.5mm²"]
[null,null,"30m x 20 pair, 0.5mm²"]
{"$rows_empty":20}
["Mthandeni Khuzwayo"]
["NED PROJECT ENGINEERING (P,M,DC&TC)"]
["New Germany"]

{"sheet":"NED Control Plant BOM","index":1,"n_rows":145,"n_cols":16,"rows_kept":145,"merged":[[1,0,1,9],[6,0,6,9],[14,0,14,9],[15,0,15,9],[23,0,23,9],[28,0,28,9],[34,0,34,9],[41,0,41,9],[46,0,46,9],[52,0,52,9],[59,0,59,9],[78,0,78,9],[107,0,107,9],[121,0,121,9],[125,0,125,9],[139,0,139,9]]}
["QTY","TYPE","MANUFACTURER","SUPPLIER","DESCRIPTION","ENC","SAP NO.","UNIT COST","TOTAL COST","LONG LEAD"]
["HV FEEDER SCHEME (4ZD3940)"]
[null,"4ZD3940 Scheme","ABB SOUTH AFRICA","ABB SOUTH AFRICA","Distance/Differential Protection Scheme (SERIAL SCADA ONLY)",4600037097,"0248559",{"v":141363,"d":"R 141,363.00"},{"$f":"A3*H3","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Swing Frame Panel","ABB SOUTH AFRICA","ABB SOUTH AFRICA","Swing Frame Panel with Dual Entry Ability for Schemes 4FZ39x0 and 4FZD39x0",4600037097,"0248564",{"v":11789,"d":"R 11,789.00"},{"$f":"A4*H4","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Additional Supervisory Binary Output Card ","ABB SOUTH AFRICA","ABB SOUTH AFRICA","Used if the Default DNP3 Protocol Supervisory Link is not Being Used",4600037097,"0248568",{"v":3245,"d":"R 3,245.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["RURAL FEEDER SCHEME (4RF1101)"]
[null,"4RF1101 Scheme","ACTOM","ACTOM","4RF1101 Reticulation Feeder Protection Scheme (SERIAL SCADA ONLY)",4600039646,"0224943",{"v":21474.5,"d":"R 21,474.50"},{"$f":"A8*H8","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"4RF1101 Scheme","ACTOM","ACTOM","4RF1101 Reticulation Feeder Protection Scheme (SERIAL & HARDWIRE SCADA)",4600039646,"0224944",{"v":22088.56,"d":"R 22,088.56"},{"$f":"A9*H9","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Swing Frame Panel","ACTOM","ACTOM","Swing Frame Panel: 2400mm h x 800mm d x 600mm w",4600039646,"0224951",{"v":8782,"d":"R 8,782.00"},{"$f":"A10*H10","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"USB","ACTOM","ACTOM","USB (PC) to DB9 male (Relay) “straight through” serial communication cable",4600039646,"0224952",{"v":371,"d":"R 371.00"},{"$f":"A11*H11","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"2nd Rear Comms port","ACTOM","ACTOM","Optional Second Rear Communication port for MiCOM P145 relay",4600039646,"0224955",{"v":1859.5,"d":"R 1,859.50"},{"$f":"A12*H12","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Solkor-N 7SG1816","WoodBeam","WoodBeam","Cable diff relay 1BL/7BO (Including 3C0contacts); 1300nm optical fibrelink (0-16km)","Vendor No: 11045237",null,{"v":29495,"d":"R 29,495.00"},{"$f":"A13*H13","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Crating","ACTOM","ACTOM","Crating of one 4RF-1100 protection scheme module for transport",4600039646,"0225041",{"v":593,"d":"R 593.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["TRANSFORME SCHEME (4TM7101)"]
[null,"4TM7101 Scheme","CONCO","CONCO","4TM-7100 TWO- OR THREE WINDING TRANSFORMER PROTECTION SCHEME (110V DC)",4600037464,"0246026",{"v":95026.66,"d":"R 95,026.66"},{"$f":"A17*H17","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Swing Frame Panel","CONCO","CONCO","2400mm HIGH x 800mm WIDE x 600mm DEEP",4600037464,"0246031",{"v":12915,"d":"R 12,915.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Ethernet Comms","CONCO","CONCO","ETHERNET COMMS INTERFACE SUPPORTING THE IEC 61850 PROTOCOL FOR A SEL-487E RELAY",4600037464,"0246044",{"v":13324.01,"d":"R 13,324.01"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"High Impedance REF","CONCO","CONCO","HIGH IMPEDANCE RESTRICTED EARTH FAULT ",4600037464,"0246035",{"v":25370.34,"d":"R 25,370.34"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Handling & Installation of 4TC5200","CONCO","CONCO","HANDLING AND INSTALLATION OF 1 x 4TC-5200 TAP INTO A 1 x 4TM PANEL",4600037464,"0246033",{"v":861,"d":"R 861.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Trfr Junction Box","Contrep","Contrep","Pole/ Wall Mounted",4600004399,"Buy Out Item",{"v":13000,"d":"R 13,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["TAPE CHANGE SCHEME (4TC5200)"]
[null,"4TC5200 Scheme","IST","IST","4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME (110 VDC)",4600036968,"0246077",{"v":49765.68,"d":"R 49,765.68"},{"$f":"A25*H25","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Temporary Crating of 4TC5200","IST","IST","TEMPORARY CRATING, TRANSPORT AND OFFLOADING OF 1 X 4TC-5200 SCHME",4600036968,"0246080",{"v":1731,"d":"R 1,731.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"IEC 61850 for the tap changer","IST","IST","UPGRADE OF EBERLE REG-DA TAP CHANGE CONTROL RELAY TO INCLUDE REG-PED",4600036968,"0246086",{"v":6131,"d":"R 6,131.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["BUS COUPLER CONTROL SCHEME (4BC1800/1900)"]
[null,"4BC1800 Scheme","ACTOM","ACTOM","4BC1800 Bus Coupler Control Scheme",4600039646,"0224921",{"v":18664.91,"d":"R 18,664.91"},{"$f":"A30*H30","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"4BC1900 Scheme","ACTOM","ACTOM","4BC1900 Bus Coupler Control Scheme",4600039646,"0224931",{"v":12613,"d":"R 12,613.00"},{"$f":"A31*H31","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Swing Frame Panel","ACTOM","ACTOM","Swing Frame Panel: 2400mm h x 800mm d x 600mm w",4600039646,"0224934",{"v":8781.5,"d":"R 8,781.50"},{"$f":"A32*H32","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Anti-pump timer module","ACTOM","ACTOM","Anti-pump timer module (4BC1900 only)",4600039646,"0224935",{"v":1489.5,"d":"R 1,489.50"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["BUSBAR ARC FLASH PROTECTION SCHEME (3BP4901)"]
[null,"3BP4901 Scheme","Vamp Solutions","Vamp Solutions","Busprotection, indoor switchgear, 2 Zone, 2 Incommers, 8 Fdrs & 1 B/S",4600040774,"0179552",{"v":125000,"d":"R 125,000.00"},{"$f":"A36*H36","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Arc Sensors","Vamp Solutions","Vamp Solutions","Arc Sensor with 6m lead (VA1DA-6)",4600040774,"0175179",{"v":390,"d":"R 390.00"},{"$f":"A37*H37","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Slave Unit","Vamp Solutions","Vamp Solutions","Slave unit (VAM12CD)",4600040774,"0175178",{"v":3026,"d":"R 3,026.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Vamp 120 Relays","Vamp Solutions","Vamp Solutions","Vamp 120 arc sensing relay","Buy Out","-",{"v":6500,"d":"R 6,500.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Swing Frame Panel","World Power Products","World Power Products","Swing Frame Panel, 800mm x 600mm x 2400mm with complete earthing",4600013592,"0402613",{"v":8190,"d":"R 8,190.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["BUSBAR PROTECTION SCHEME (4BZ5700/5800/5900)"]
[null,"4BZ5700 Scheme","IST","IST","Two zone differential protection with a check zone+ Panel.",4600025371,"0224973",{"v":37272.6,"d":"R 37,272.60"},{"$f":"A43*H43","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"4BZ5800 Scheme","IST","IST","Two zone differential protection with a check zone+ Panel.",4600025371,"0224971",{"v":87702.4,"d":"R 87,702.40"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"4BZ5900 Scheme","IST","IST","Single zone differential protection with a check zone+ Panel.",4600025371,"0224975",{"v":30540.6,"d":"R 30,540.60"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["Under-Frequency Load Shedding (4LS1101)"]
[null,"4LS1101 Scheme","ACTOM","ACTOM","4LS1101 UFLS Protection Scheme (Serial SCADA only)",4600026679,"0404058",{"v":22071,"d":"R 22,071.00"},{"$f":"A48*H48","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Swing Frame Panel","ACTOM","ACTOM","Swing Frame Panel: 2400mm h x 800mm d x 600mm w",4600026679,"0404074",{"v":10094,"d":"R 10,094.00"},{"$f":"A49*H49","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Crating","ACTOM","ACTOM","Crating of one 4LS1100 or 4LS1200 protection scheme module for transport",4600026679,"0225384",{"v":817,"d":"R 817.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Voltage Selection Module","ACTOM","ACTOM","Optional Second 3-phase VT input & Voltage selection module",4600026679,"0404080",{"v":3534.5,"d":"R 3,534.50"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["Capacitor Bank Protection Scheme (Based on GE C70 relay scheme)"]
[2,"C70 type Scheme",null,null,"Modified Capacitor Bank Protection Scheme (Serial SCADA only)",null,"Buy out",{"v":700000,"d":"R 700,000.00"},{"$f":"A54*H54","v":{"v":1400000,"d":"R 1,400,000.00"}},"Yes"]
[2,"Swing Frame Panel",null,null,"Swing Frame Panel: 2400mm h x 800mm d x 600mm w",null,"Buy out",{"v":15000,"d":"R 15,000.00"},{"v":30000,"d":"R 30,000.00"},"Yes"]
[1,"2nd Rear Comms port",null,null,"Optional Second Rear Communication port for MiCOM P145 relay",null,"Buy out",{"v":5000,"d":"R 5,000.00"},{"$f":"A56*H56","v":{"v":5000,"d":"R 5,000.00"}},"Yes"]
[null,"training"]
[null,"Crating",null,null,"Crating of one 4CB1100 protection scheme module for transport",null,null,{"v":817,"d":"R 817.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["Metering (Statistical/Tarrif)"]
[null,"Meter, Elster A1700 3Ph 1A CL0.5","-","-","METER 3 PH CL0.5 1A RS485","-","0242580",{"v":3090.7,"d":"R 3,090.70"},{"$f":"A61*H61","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"MODULE, METERING STD METER SUBPANEL","Wirconn","Wirconn","METER MODULE PART OF STANDARD METERING PANEL",4600004977,"0175685",{"v":8000,"d":"R 8,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"VSM","Wirconn","Wirconn","Voltage Selection Module - Type D",4600004977,"0175688",{"v":7000,"d":"R 7,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Swing Frame Panel","World Power Products","World Power Products","SWING FRAME CABINET * 800mm x 600mm x 2400mm","-","0402613",{"v":8190,"d":"R 8,190.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 1U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 1U * 19\" (482.6mm) RACK","-","0401942",{"v":31,"d":"R 31.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 2U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 2U * 19\" (482.6mm) RACK","-","0401944",{"v":40,"d":"R 40.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 3U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 3U * 19\" (482.6mm) RACK","-","0401952",{"v":67.3,"d":"R 67.30"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 4U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 4U * 19\" (482.6mm) RACK","-","0401954",{"v":79.6,"d":"R 79.60"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 5U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 5U * 19\" (482.6mm) RACK","-","0401956",{"v":92.1,"d":"R 92.10"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 6U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 6U * 19\" (482.6mm) RACK","-","0402097",{"v":103.8,"d":"R 103.80"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 7U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 7U * 19\" (482.6mm) RACK","-","0401958",{"v":90,"d":"R 90.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 8U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 8U * 19\" (482.6mm) RACK","-","0401960",{"v":127.2,"d":"R 127.20"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 9U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 9U * 19\" (482.6mm) RACK","-","0401962",{"v":139.1,"d":"R 139.10"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 10U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 10U * 19\" (482.6mm) RACK","-","0401964",{"v":150.6,"d":"R 150.60"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 11U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 11U * 19\" (482.6mm) RACK","-","0401966",{"v":162.4,"d":"R 162.40"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Plate, Blanking Protection 12U","World Power Products","World Power Products","BLANKING PLATE * TYPE: 12U * 19\" (482.6mm) RACK","-","0402099",{"v":174.2,"d":"R 174.20"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Trucom Smartoo Modem","Trucom","Trucom","TRUCOM SMARTOO GSM/GPRS DIN-RAIL MOUNT METERING MODEM","-","0223364",{"v":3000,"d":"R 3,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["Telecontrol"]
[null,"D20RTU Power Supply","GE","IST","48 / 110V DC PSU",4600048574,"0213376",{"v":6665,"d":"R 6,665.00"},{"$f":"A80*H80","v":{"v":0,"d":"R 0.00"}},"Yes",{"$nulls":5},{"$f":"SUM(I8:I12,#REF!,I31:I33,I36:I37,I48:I51,I61:I77,I80:I86,I109:I120,#REF!,I133:I134)","v":{"$error":"#REF!"}}]
[null,"D20RTU Config 11","GE","IST","Config 11 Krone VME D20 RTU, 1 D20C, 1 Moxa",4600048574,"0559978",{"v":80623,"d":"R 80,623.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"D20 Cabinet","-","IST","PB6 800w x 600d cabinets with removable sides, swing frame, “G” rails, earth studs,",4600048574,"0213368",{"v":12355,"d":"R 12,355.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"MOXA EXPANSION KIT","Moxa","IST","MOXA EXPANSION KIT (RS232 --> RS485)",4600048574,"0250320",{"v":2087,"d":"R 2,087.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"D20S Expansion Kit","GE","IST","D20 S Status Expansion Kit with 10m cable",4600048574,"0213245",{"v":9791,"d":"R 9,791.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"D20C Expansion Kit","GE","IST","D20 C Combo Expansion Kit with 10m cable",4600048574,"0213260",{"v":14669,"d":"R 14,669.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Fiber to RS232/422/485 Convertor","Moxa","Elonics","Moxa, RS-232/422/485 to optical fiber media converters: TCF-142-S-SC","Buy Out","-",{"v":5000,"d":"R 5,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"RTU D20 CONFIG 11 1MOXA D20C KRONE ","GE","IST","IST GE MISC KIT D20 NON-VME CPU SINGLE SLOT CHASSIS",4600048574,"0250318","-",null,"Yes"]
[1,"SERIAL TRAY WITH 1 MOXA ","GE","IST","01 X 4 U MOXA RACK MOUNT BOX WITH SILK SCREEN (ISTE-304300)",4600048574,"0250319",{"v":6000,"d":"R 6,000.00"},{"$f":"A88*H88","v":{"v":6000,"d":"R 6,000.00"}},"Yes"]
[null,"D20S EXPANSION KIT WITH KRONE D9653 ","GE","IST","06 x KRONE CONNECTOR 10PR DISCONNECT",4600048574,"0250322","-",null,"Yes"]
[null,"FORM 4C IBOX DOOR KIT D9653","GE","IST","METAL DOOR ENCLOSURE, IBOX SER 24V 8 I/P 4 O/P",4600048574,"0250323","-",null,"Yes"]
[null,"IBOX PMRTU D9653","GE","IST","IST GE POLE TOP ENCLOSURE 3CR12 STEEL",4600048574,"0250324","-",null,"Yes"]
[null,"IBOX SER 24V 8 I/P 4 O/P D9653 ","GE","IST","IBOX 20-60 VDC INPUT",4600048574,"0250325","-",null,"Yes"]
[null,"IBOX SER TO MDS RADIO CABLE D9653","GE","IST","MDS RADIO TO IBOX INTERFACE CABLE ",4600048574,"0250326","-",null,"Yes"]
[null,"IBOX SER TO MC402 GPRS CABLE D9653","GE","IST","METACOM MC402 GPRS MODEM TO IBOX INTERFACE CABLE ",4600048574,"0250327","-",null,"Yes"]
[null,"F4C SER TO F-OPTIC CABLE D9653","GE","IST","FORM4C SERIAL TO FIBRE OPTIC (PMRTU-35000) INTERFACE CABLE ",4600048574,"0250328","-",null,"Yes"]
[null,"DIN RAIL F-OPTIC CONVERTER D9653","GE","IST","RS232 TO MULTIMODE FIBRE OPTIC CONVERTER WITH BAYONET FIBRE INTERFACE",4600048574,"0250329","-",null,"Yes"]
[null,"SD-25A-24 25W DC-DC CONVERTER D9653","GE","IST","MEANWELL SD-25A 25W, 24V, 1.1A SINGLE OUTPUT DC-DC CONVERTER",4600048574,"0250330","-",null,"Yes"]
[null,"DISCONNECT BLOCKS.","KRONE  031-9043169","KRONE  031-9043169","10 PAIR DISCONNECT BLOCKS.","Buy Out","-","-",null,"Yes"]
[null,"LABEL HOLDERS","KRONE  031-9043169","KRONE  031-9043169","1O PAIR. SIZE 1  FIXED LABEL HOLDERS.","Buy Out","-","-",null,"Yes"]
[null,"BACKMOUNT FRAME","KRONE  031-9043169","KRONE  031-9043169","10 PAIR. 55WAY. 49mm. BACKMOUNT FRAME.  FRME 255","Buy Out","-","-",null,"Yes"]
[null,"Tait Radio ","EMCOM ","EMCOM ","Radio Mobile Dash Mount UHF Tait TM8115 - Contact Raj 031 312 9288","Vendor No: 11001537",null,"-",null,"Yes"]
[null,"Trio Radio ","IST","IST","CPE Radio/ Trio ER450","Vendor No: 11051059",null,"-",null,"Yes"]
[null,"Coaxial Cable ","WEB INDUSTRIES","WEB INDUSTRIES","3m LMR 195 Coaxial Cable Flylead BNC Male to N Female","Vendor No: 11000449",null,"-",null,"Yes"]
[null,"Antenna","WEB INDUSTRIES","WEB INDUSTRIES","Webb Antenna (380 - 470 MHZ). Y425/ 3 Yagi 3 Element with casting hub. ","Vendor No: 11000449",null,"-",null,"Yes"]
[null,"Bracket ","WEB INDUSTRIES","WEB INDUSTRIES","WM30 Extra Heavy Duty offset bracket (300mm) - Contact Lodie Potgieter on 011 719 0149","Vendor No: 11000449",null,"-",null,"Yes"]
[null,"Pole","WEB INDUSTRIES","WEB INDUSTRIES","6m Aluminium pole 50mm diameter 5mm wall thickness ","Vendor No: 11000449",null,"-",null,"Yes"]
[]
["Cable & Accessories (provisional Forecast for costing purpose only)"]
[300,"12core, 2.5mm²","Aberdare","Various","CABLE 1kV 12C 2.5SQ CU BVX12DCV",4600035807,"0014469",{"v":51.95,"d":"R 51.95"},{"$f":"A109*H109","v":{"v":15585,"d":"R 15,585.00"}},"Stock Item"]
[300,"19core, 2.5mm²","Aberdare","Various","CABLE 1kV 19C 2.5SQ CU BVX19DCV",4600035807,"0014484",{"v":75,"d":"R 75.00"},{"v":22500,"d":"R 22,500.00"},"Stock Item"]
[0,"10 pair, 0.5mm²","Aberdare","Various","Telephone Cable",4600035807,"0014666",{"v":20,"d":"R 20.00"},{"v":0,"d":"R 0.00"},"Stock Item"]
[0,"20 pair, 0.5mm²","Aberdare","Various","Telephone Cable",4600035807,403128,{"v":30,"d":"R 30.00"},{"v":0,"d":"R 0.00"},"Stock Item"]
[500,"4core, 4mm²","Aberdare","Various","CABLE 1kV 4C 4.0SQ CU BVX4ECV",4600035807,"0014475",{"v":30.45,"d":"R 30.45"},{"v":15225,"d":"R 15,225.00"},"Stock Item"]
[500,"4core, 2.5mm²","Aberdare","Various","CABLE 1kV 4C 2.5SQ CU BVX4ECV",4600035807,"0400646",{"v":22.6,"d":"R 22.60"},{"v":11300,"d":"R 11,300.00"},"Stock Item"]
[null,"4core, 16mm²","Aberdare","Various","CABLE 1kV 4C 16.0SQ CU BVX4HCV",4600035807,"0014476",{"v":75,"d":"R 75.00"},{"v":0,"d":"R 0.00"},"Stock Item"]
[30,"CABLE,COMMS:ARMOURED;4 PAIR TWISTED","Belden","Various","CABLE, COMMUNICATION: ARMOURED;\nCONDUCTOR: 4 PAIR TWISTED; CONDUCTOR SIZE: 22/24 AWG;\nFOR EIA - RS 485 DATA;","-",588799,{"v":130,"d":"R 130.00"},{"v":3900,"d":"R 3,900.00"},"Stock Item"]
[null,"Belden, Unarmoured, 4 pair, 0.5mm²","Jaycor","Various","Belden, Unarmoured, 4 pair, 0.5mm²","Buy Out","-",{"v":110,"d":"R 110.00"},{"v":0,"d":"R 0.00"},"Yes"]
[30,"Size 1 Cable Gland","Pratley","Various","Size 1 Cable Gland","-","0168367",{"v":12,"d":"R 12.00"},{"v":360,"d":"R 360.00"},"Stock Item"]
[15,"Size 2 Cable Gland","Pratley","Various","Size 2 Cable Gland","-","0168279",{"v":18,"d":"R 18.00"},{"v":270,"d":"R 270.00"},"Stock Item"]
[null,"Size 3 Cable Gland","Pratley","Various","Size 3 Cable Gland","-","0168280",{"v":25,"d":"R 25.00"},{"v":0,"d":"R 0.00"},"Stock Item"]
[]
["Auxilliaries"]
[null,"CTJB","Contrep","Contrep","VRW20 Junction Box , with 6 circuit CT insert (Fitted) (Complete JB) ",4600004399,"0186961",{"v":6500,"d":"R 6,500.00"},{"$f":"A123*H123","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"VTJB","Contrep","Contrep","VRW20 Junction Box , with 8 circuit VT insert (Fitted) (Complete JB) ",4600004399,"0186950",{"v":7500,"d":"R 7,500.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
["AC/ DC Boards"]
[null,"VRPP/ VTX M100 (110V Battery Bank)","Alkaline","Alkaline","CELL, NICD 1.2V 100AH VTX1 M100 D9308",4600041171,"0256102",{"v":820.27,"d":"R 820.27"},{"$f":"A127*H127","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Battery Cabinet","Alkaline","Alkaline","CABINET, BATT NICD 88C SA TYPE 3",4600041171,"0256354",{"v":16655,"d":"R 16,655.00"},{"$f":"A128*H128","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Link Set","Alkaline","Alkaline","CONNECTORS, VTX BATT LINK SET 3 ",4600041171,"0256348",{"v":675,"d":"R 675.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Sub-rack Battery Charger","IST","IST","110V 20A Sub-rack Battery Charger - Ensure This is installed in panel",4600039043,"0217235",{"v":37036.25,"d":"R 37,036.25"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Type F Interface Module","IST","IST","Type F: 19\" Interface module - Ensure This is installed in panel",4600039043,"0212999",{"v":15483.73,"d":"R 15,483.73"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"Swingframe Panel","IST","IST","800x600x1800mm 19” swingframe cabinet with blanking plates D9242",4600039043,"0213000",{"v":11477.48,"d":"R 11,477.48"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"AC board","SABI ELECTRICAL","SABI ELECTRICAL","As per Drawing-Request from Control Plant Engineer at Ordering Stage","Buy Out","-",{"v":15000,"d":"R 15,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"110V DC Board","SABI ELECTRICAL","SABI ELECTRICAL","As per Drawing-Request from Control Plant Engineer at Ordering Stage","Buy Out","-",{"v":10000,"d":"R 10,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"50V DC Board, 63A &  32A MCB's","SABI ELECTRICAL","SABI ELECTRICAL","As per Drawing-Request from Control Plant Engineer at Ordering Stage","Buy Out","-",{"v":5000,"d":"R 5,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"AC Supply Changeover Box","SABI ELECTRICAL","SABI ELECTRICAL","Contact Sabi on (031) 700 3977or email sabi@Iafrica.com  ","Buy Out","-",{"v":15000,"d":"R 15,000.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"100A 3 phase MCB","Various","Various","100A 3 Phase MCB, DIN Rail Mount","Buy Out","-",{"v":500,"d":"R 500.00"},{"v":0,"d":"R 0.00"},"Yes"]
[]
[]
["Fiber"]
[null,"Armoured 12/24/48 core Single mode fiber","Various","Various","Must be terminated with SC connectors at both ends","Buy Out","-",{"v":40,"d":"R 40.00"},{"$f":"A141*H141","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Conduit for fiber run (High Density Poly Ethelene)","Various","Various","Conduit for fiber run (High Density Poly Ethelene)","Buy Out","-",{"v":55,"d":"R 55.00"},{"$f":"A142*H142","v":{"v":0,"d":"R 0.00"}},"Yes"]
[null,"Corrugated PVC Conduit 110mm","Various","Various","6m lenghts with connector at end","Buy Out","-",{"v":233,"d":"R 233.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"25mm sprag tubing","Various","Various","25mm sprag tubing","Buy Out","-",{"v":22,"d":"R 22.00"},{"v":0,"d":"R 0.00"},"Yes"]
[null,"ODF","Various","Various","SC 12PORT PATCH PANEL","Buy Out","-",{"v":2550,"d":"R 2,550.00"},{"v":0,"d":"R 0.00"},"Yes"]

{"sheet":"CP FEES","index":2,"n_rows":58,"n_cols":9,"rows_kept":58,"merged":[[0,0,54,0],[0,1,0,7],[1,1,1,3],[1,4,1,6],[2,1,2,3],[2,4,2,7],[3,1,5,3],[3,4,3,7],[4,4,4,7],[5,4,5,7],[6,1,6,3],[6,4,6,7],[16,1,16,7],[23,1,23,7],[44,1,44,7],[53,1,53,3],[54,1,54,3],[54,6,54,7]]}
["NED CONTROL PLANT EHGINEERING FEES QUOTATION","QUOTATION - NED CONTROL PLANT ENGINEERING PRELIM AND DETAIL DESIGN "]
[null,"Revised by: Aroon Sukhnandan (Control Plant New Germany)",null,null,"Revision Date",null,null,"2022-08-26"]
[null,"SUBSTATION NAME:",null,null,"Makhitini Caps x 2"]
[null,"Estimators Details",null,null,"E-mail: Sukhnaa@eskom.co.za"]
[{"$nulls":4},"Tel : 031 710 5265"]
[{"$nulls":4},"Fax2Email : 086 696 5792"]
[null,"DATE",null,null,"2022-08-16"]
[{"$nulls":3},"RATE (T10) ELECTRICAL DRAUGHTSMAN",null,276.76,"R/Hour"]
[{"$nulls":3},"RATE (P13) ENGINEER",null,621.13,"R/Hour"]
[{"$nulls":3},"RATE (P16) SENIOR ENGINEER",null,866.55,"R/Hour"]
[{"$nulls":3},"RATE (T10) ELECTRICAL DRAUGHTSMAN - Overtime",null,{"$f":"F8*1.5","v":415.14},"R/Hour"]
[{"$nulls":3},"RATE (P13) ENGINEER - Overtime",null,{"$f":"F9*1.5","v":{"v":931.6949999999999,"d":"931.70"}},"R/Hour"]
[{"$nulls":3},"TRAVEL RATE ",null,4.17,"/km"]
[{"$nulls":3},"DISTANCE TO SITE",null,410,"km"]
[{"$nulls":3},"A3 Printing Cost",null,{"v":1.3,"d":"1.30"},"Rands/ A3 print"]
[null,"QTY (NORMAL WORK)","QTY (REWORK)","BAY TYPE","DUR (days)","MAN HRS","COST Normal Work","COST Rework"]
[null,"General and Travel Costs"]
[null,1,null,"REFURBISHMENT + 25% of total",null,{"$f":"B18*E18","v":0},{"$f":"B18*(0.25*(G44+G53))","v":{"v":53173.479999999996,"d":"R53,173.48"}},{"$f":"C18*(0.25*(G44+G53))","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"NON STANDARD APPLICATION + 40% of Total",null,{"$f":"B19*E19","v":0},{"$f":"B19*(0.4*(G44+G53))","v":{"v":0,"d":"R0.00"}},{"$f":"C19*(0.4*(G44+G53))","v":{"v":0,"d":"R0.00"}}]
[null,4,null,"NUMBER OF SITE VISITS -fpr Design Engineers typically 4 to 6",null,8,{"$f":"B20*F20*$F$10","v":{"v":27729.6,"d":"R27,729.60"}},{"$f":"C20*F20*$F$12","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"NUMBER OF SITE VISITS - For Commissiong Engineers typically 2 to 3",null,8,{"$f":"B21*F21*$F$10","v":{"v":0,"d":"R0.00"}},{"$f":"C21*F21*$F$12","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Total Travel Costs",null,null,{"$f":"(B20+B21+C20+C21)*2*(F14)*F13","v":{"v":13677.6,"d":"R13,677.60"}}]
[{"$nulls":3},"General and Travel Sub Total",null,null,{"$f":"SUM(G18:G22)","v":{"v":94580.68,"d":"R94,580.68"}},{"$f":"H18+H19+H20","v":{"v":0,"d":"R0.00"}}]
[null,"Draughting Costs"]
[{"$nulls":3},"TRANSFORMER < 20MVA",8,64,{"$f":"B25*F25*$F$8","v":{"v":0,"d":"R0.00"}},{"$f":"C25*F25*$F$11","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"TRANSFORMER >= 20MVA",10,80,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"TAPCHANGE",5,40,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"HV FEEDER BAY",10,80,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"HV BUS COUPLER/SECTION",8,64,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"HV BUSBAR (1 zone, no check)",5,40,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"HV BUSBAR (2 zone + check)",10,80,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"LV BUSBAR",5,40,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"LV FEEDER - rural feeders",2,16,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"LV METAL CLAD BUS ZONE (Vamp) 1Incommer",5,40,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"LV METAL CLAD BUS ZONE (Vamp) 2Incommer",8,64,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"LV METAL CLAD BUS ZONE (Vamp) 3 Incommer",8,64,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"LV METAL CLAD BUS ZONE (Vamp) Double Busbar",10,80,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,2,null,"CAP BANK ",10,80,{"v":44281.6,"d":"R44,281.60"},{"v":0,"d":"R0.00"}]
[null,1,null,"AC/DC BOARD",2,16,{"v":4428.16,"d":"R4,428.16"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"IDF",1,8,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"TARIFF METERING ",4,32,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"STATS METERING ",3,24,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,500,null,"PRINTS FOR ISSUE - No of sheets",null,0,{"$f":"B43*$F$15","v":{"v":650,"d":"R650.00"}},{"$f":"C43*1","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Draughting Sub Total",null,{"$f":"CEILING(G44/F8/8,1)","v":23},{"$f":"SUM(G25:G43)","v":{"v":49359.759999999995,"d":"R49,359.76"}},{"$f":"SUM(H25:H43)","v":{"v":0,"d":"R0.00"}}]
[null,"Engineering Design Costs"]
[null,4,null,"Telecontrol detail design (New - 10, Existing 14)",null,{"$f":"B46*8","v":32},{"$f":"F46*$F$9","v":{"v":19876.16,"d":"R19,876.16"}},{"$f":"C46*8*$F$12","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Fiber Optic Design",null,{"$f":"B47*8","v":0},{"$f":"F47*$F$9","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},0]
[null,6,null,"Checking and Approving of Pack & Drawings (20% of Eng hours)",null,{"$f":"0.2*(SUM(F46:F47,F49:F52))","v":43.2},{"$f":"F48*$F$10","v":{"v":37434.96,"d":"R37,434.96"}},{"v":0,"d":"R0.00"}]
[null,20,null,"Compilation and Presentation of Design (10 to 25 days)",null,{"$f":"B49*8","v":160},{"$f":"F49*$F$9","v":{"v":99380.8,"d":"R99,380.80"}},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Settings (as per schedule)",null,{"$f":"B50*8","v":0},{"$f":"F50*$F$9","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,3,null,"As Builts (by Drawing Office - require schedule)",null,{"$f":"B51*8","v":24},{"$f":"F51*$F$8","v":{"v":6642.24,"d":"R6,642.24"}},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Commissioning Engineers (normally 3 days per project)",null,{"$f":"B52*8","v":0},{"$f":"F52*$F$10","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Engineering Sub Total",null,{"$f":"SUM(F46:F52)","v":259.2},{"$f":"SUM(G46:G52)","v":{"v":163334.15999999997,"d":"R163,334.16"}},{"$f":"SUM(H46:H52)","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL DURATION & COST",{"$nulls":4},{"$f":"G23+G44+G53","v":{"v":307274.6,"d":"R307,274.60"}},{"$f":"H23+H44+H53","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL FINAL PROJECT QUOTATION",{"$nulls":4},{"$f":"G54+H54","v":{"v":307274.6,"d":"R 307,274.60"}}]
[]
[]
[{"$nulls":6},{"$f":"G55","v":{"v":307274.6,"d":"R307,274.60"}}]

{"sheet":"Cables","index":3,"n_rows":134,"n_cols":16,"rows_kept":134,"hidden":true}
[null,null,30]
[null,null,150]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm","2core16sqmm","4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"TOTAL",{"$f":"SUM(D14)+D20+D40+D52+D62+D76+D86+D94+D99+D25+D30+D111+D120+D134","v":630},180,0,0,{"$f":"SUM(H14)+H20+H40+H52+H62+H76+H86+H94+H99+H25+H30+H111+H120+H134","v":150},150,60,30,0,18,2,2,{"$f":"SUM(N4:O4)","v":4}]
[null,5,"4RF1100"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"AC DB",{"$f":"C1*B7","v":0},{"$nulls":8},{"$f":"2*B7","v":0}]
[null,null,"DC DB",null,{"$f":"C1*B8","v":0},{"$nulls":7},{"$f":"2*B8","v":0}]
[null,null,"VT",null,{"$f":"C2*B9","v":0},{"$nulls":7},{"$f":"2*B9","v":0}]
[null,null,"CT's",{"$nulls":4},{"$f":"C2*B10","v":0},{"$f":"C2*B10","v":0},{"$nulls":4},{"$f":"2*B10","v":0},{"$f":"2*B10","v":0}]
[null,null,"LINE ISOLATOR",{"$f":"B11*C2","v":0},{"$nulls":8},{"$f":"2*B11","v":0}]
[null,null,"IDF",{"$nulls":6},{"$f":"B12*C1","v":0},null,null,{"$f":"2*B12","v":0}]
[null,null,"D20RTU",{"$nulls":8},{"$f":"B13*C1","v":0},{"$f":"2*B13","v":0}]
[{"$nulls":3},{"$f":"SUM(D7:D13)","v":0},{"$f":"SUM(E7:E13)","v":0},null,{"$f":"SUM(G7:G13)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Stats Metering"]
[null,null,"VT",null,{"$f":"C2*B18","v":0},{"$nulls":7},{"$f":"B18*2","v":0}]
[null,null,"Bays (CT's)",{"$f":"C2*B19","v":0},{"$nulls":8},{"$f":"2*B19","v":0}]
[{"$nulls":3},{"$f":"SUM(D18:D19)","v":0},{"$f":"SUM(E18:E19)","v":0},null,{"$f":"SUM(G18:G19)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Tariff Metering"]
[null,null,"VT",null,{"$f":"C$2*B23","v":0},{"$nulls":7},{"$f":"2*B23","v":0}]
[null,null,"Bays (CT's)",{"$nulls":4},{"$f":"B24*C2","v":0},{"$nulls":5},{"$f":"2*B24","v":0}]
[{"$nulls":3},{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":0},null,{"$f":"SUM(G23:G24)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Tariff Metering - Customer Meters in the Controlroom"]
[null,null,"VT",null,{"$f":"C$1*B28","v":0},{"$nulls":7},{"$f":"2*B28","v":0}]
[null,null,"Bays (CT's)",{"$nulls":4},{"$f":"C$1*B29","v":0},{"$nulls":5},{"$f":"2*B29","v":0}]
[{"$nulls":3},{"$f":"SUM(D28:D29)","v":0},{"$f":"SUM(E28:E29)","v":0},null,{"$f":"SUM(G28:G29)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"4BZ-5900"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"AC DB",{"$f":"C1*B34","v":0},{"$nulls":8},{"$f":"2*B$34","v":0}]
[null,null,"DC DB",null,{"$f":"C1*B35","v":0},{"$nulls":7},{"$f":"2*B$35","v":0}]
[null,null,"Bays (CT's)",{"$f":"C2*B36","v":0},{"$nulls":8},{"$f":"2*B$36","v":0}]
[null,null,"Relay Panels",{"$f":"C1*B37","v":0},{"$nulls":8},{"$f":"2*B$37","v":0}]
[null,null,"IDF",{"$nulls":6},{"$f":"C1*B38","v":0},null,null,{"$f":"2*B$38","v":0}]
[null,null,"D20RTU",{"$nulls":8},{"$f":"B39*C1","v":0},{"$f":"2*B$39","v":0}]
[{"$nulls":3},{"$f":"SUM(D34:D39)","v":0},{"$f":"SUM(E34:E39)","v":0},null,{"$f":"SUM(G34:G39)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"4BZ-5800"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"AC DB",{"$f":"C1*B44","v":0},{"$nulls":8},{"$f":"2*B$44","v":0}]
[null,null,"DC DB",null,{"$f":"C1*B45","v":0},{"$nulls":7},{"$f":"2*B$45","v":0}]
[null,null,"Bays (CT's)",{"$f":"C2*B46","v":0},{"$nulls":8},{"$f":"2*B$46","v":0}]
[null,null,"Customer CT's",{"$f":"D2*B47","v":0},{"$nulls":8},{"$f":"2*B$47","v":0}]
[null,null,"Relay Panels",{"$f":"C1*B48","v":0},{"$nulls":8},{"$f":"2*B$48","v":0}]
[null,null,"Customer Relay  Panels",{"$f":"D2*B49","v":0},{"$nulls":8},{"$f":"2*B$49","v":0}]
[null,null,"IDF",{"$nulls":6},{"$f":"C1*B50","v":0},null,null,{"$f":"2*B$51","v":0}]
[null,null,"D20RTU",{"$nulls":8},{"$f":"B51*C1","v":0},{"$f":"2*B$51","v":0}]
[{"$nulls":3},{"$f":"SUM(D44:D51)","v":0},{"$f":"SUM(E44:E51)","v":0},null,{"$f":"SUM(G44:G51)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"4LS-1100"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"AC DB",{"$f":"C1*B56","v":0},{"$nulls":8},{"$f":"2*B$56","v":0}]
[null,null,"DC DB",null,{"$f":"C1*B57","v":0},{"$nulls":7},{"$f":"2*B$57","v":0}]
[null,null,"VT",null,{"$f":"B58*C2","v":0},{"$nulls":7},{"$f":"2*B58","v":0}]
[null,null,"Relay Panels",{"$f":"C1*B59","v":0},{"$nulls":8},{"$f":"2*B$59","v":0}]
[null,null,"IDF",{"$nulls":6},{"$f":"C1*B60","v":0},null,null,{"$f":"2*B60","v":0}]
[null,null,"D20RTU",{"$nulls":8},{"$f":"B61*C1","v":0},{"$f":"2*B61","v":0}]
[{"$nulls":3},{"$f":"SUM(D56:D61)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"4TM-7100"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"AC DB",{"$f":"C1*B66","v":0},{"$nulls":8},{"$f":"2*B$66","v":0}]
[null,null,"DC DB",null,{"$f":"C1*B67","v":0},{"$nulls":7},{"$f":"2*B$67","v":0}]
[null,null,"HV CT's",{"$nulls":4},{"$f":"B68*C2","v":0},{"$nulls":4},{"$f":"2*B$68","v":0}]
[null,null,"HV CB",{"$nulls":4},{"$f":"C2*B69","v":0},{"$f":"B69*C2","v":0},{"$nulls":4},{"$f":"2*B69","v":0},{"$f":"2*B$69","v":0}]
[null,null,"MV VT",null,{"$f":"B70*C2","v":0},{"$nulls":7},{"$f":"2*B$70","v":0}]
[null,null,"TJB/TRFR",null,{"$f":"B71*C2","v":0},{"$nulls":3},{"$f":"2*B71*C2","v":0},{"$nulls":3},{"$f":"2*B$71","v":0},null,{"$f":"B71*4","v":0}]
[null,null,"HV ISOLATOR",{"$f":"B72*C2","v":0},{"$nulls":8},{"$f":"2*B72","v":0}]
[null,null,"MV ISOLATOR",{"$f":"B73*C2","v":0},{"$nulls":8},{"$f":"2*B73","v":0}]
[null,null,"IDF",{"$nulls":6},{"$f":"B74*C1","v":0},null,null,{"$f":"2*B74","v":0}]
[null,null,"D20RTU",{"$nulls":8},{"$f":"B75*C1","v":0},{"$f":"2*B75","v":0}]
[{"$nulls":3},{"$f":"SUM(D66:D75)","v":0},{"$f":"SUM(E66:E75)","v":0},null,{"$f":"SUM(G66:G75)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"4TC-5200"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"AC DB",{"$f":"B80*C1","v":0},{"$nulls":8},{"$f":"2*B80","v":0}]
[null,null,"DC DB",null,{"$f":"B81*C1","v":0},{"$nulls":7},{"$f":"2*B$81","v":0}]
[null,null,"MV VT",null,{"$f":"B82*C2","v":0},{"$nulls":7},{"$f":"2*B$82","v":0}]
[null,null,"TJB/TRFR",null,{"$f":"B83*C2","v":0},{"$nulls":3},{"$f":"B83*2*C2","v":0},{"$nulls":3},{"$f":"B83*2","v":0},{"$f":"2*B83","v":0},{"$f":"B83*4","v":0}]
[null,null,"IDF",{"$nulls":6},{"$f":"B84*C1","v":0},null,null,{"$f":"2*B84","v":0}]
[null,null,"D20RTU",{"$nulls":8},{"$f":"B85*C1","v":0},{"$f":"2*B85","v":0}]
[{"$nulls":3},{"$f":"SUM(D80:D85)","v":0},{"$f":"SUM(E80:E85)","v":0},null,{"$f":"SUM(G80:G85)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"DC Supply - Battery Charger"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"AC DB",{"$f":"B90*C1","v":0},{"$nulls":8},{"$f":"2*B90","v":0}]
[null,null,"DC DB",null,null,{"$f":"B91*C1","v":0},{"$nulls":7},{"$f":"2*B$91","v":0}]
[null,null,"Batt. Bank",null,null,{"$f":"B92*C1","v":0},{"$nulls":7},{"$f":"4*B$92","v":0}]
[null,null,"IDF",{"$nulls":6},{"$f":"B93*C1","v":0},null,null,{"$f":"2*B93","v":0}]
[{"$nulls":3},{"$f":"SUM(D90:D93)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"AC Supply"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,null,"AUX",{"$nulls":3},{"$f":"B98*C2","v":0},{"$nulls":5},{"$f":"2*B98","v":0}]
[{"$nulls":3},{"$f":"SUM(D98:D98)","v":0},{"$f":"SUM(E98:E98)","v":0},null,{"$f":"SUM(G98:G98)","v":0},0,0,0,0,0,0,0,0]
[]
[null,0,"4BC-1900 "]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,0,"AC DB",{"$f":"B103*C1","v":0},{"$nulls":8},{"$f":"2*B103","v":0}]
[null,0,"DC DB",null,{"$f":"B104*C1","v":0},{"$nulls":7},{"$f":"2*B104","v":0}]
[null,0,"VT",null,{"$f":"B105*C2","v":0},{"$nulls":7},{"$f":"2*B105","v":0}]
[null,0,"BREAKER",null,{"$f":"B106*C2","v":0},{"$nulls":3},{"$f":"B106*C2","v":0},{"$nulls":3},{"$f":"B106*2","v":0},null,{"$f":"B106*4","v":0}]
[null,0,"CT's",{"$nulls":5},{"$f":"B107*C2","v":0},{"$nulls":5},{"$f":"B107*4","v":0}]
[null,0,"BB1 ISOLATOR",{"$f":"B108*C2","v":0},{"$nulls":8},{"$f":"2*B108","v":0}]
[null,0,"BB2 ISOLATOR",{"$f":"B109*C2","v":0},{"$nulls":8},{"$f":"2*B109","v":0}]
[null,0,"IDF",{"$nulls":6},{"$f":"B110*C1","v":0},{"$f":"B110*C1","v":0},null,{"$f":"4*B110","v":0}]
[{"$nulls":3},{"$f":"SUM(D103:D110)","v":0},{"$f":"SUM(E103:E110)","v":0},null,{"$f":"SUM(G103:G110)","v":0},0,0,0,0,0,0,0,0]
[]
[null,0,"Busbar Arc Flash Protection scheme"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,0,"AC DB",{"$f":"B115*C1","v":0},{"$nulls":8},{"$f":"2*B115","v":0}]
[null,0,"DC DB",null,{"$f":"B116*C1","v":0},{"$nulls":7},{"$f":"2*B116","v":0}]
[null,0,"INCOMER",{"$nulls":4},{"$f":"B117*C2","v":0},{"$nulls":5},{"$f":"2*B117","v":0}]
[null,0,"BAYS",{"$f":"B118*C1","v":0},{"$nulls":8},{"$f":"B118*2","v":0}]
[null,0,"IDF",{"$nulls":6},{"$f":"B119*C1","v":0},null,null,{"$f":"2*B119","v":0}]
[{"$nulls":3},{"$f":"SUM(D115:D119)","v":0},{"$f":"SUM(E115:E119)","v":0},null,{"$f":"SUM(G115:G119)","v":0},0,0,0,0,0,0,0,0]
[]
[null,5,"4RF1100"]
[{"$nulls":3},"4core2.5sqmm","4core4sqmm",null,"4core16sqmm","12core2.5sqmm","19core2.5sqmm","10pair","20pair","4Pair Cable (Amoured)","No 1 Cable Gland","No 2 Cable Gland","No 3 Cable Gland"]
[null,1,"AC DB",{"$f":"C1*B124","v":30},{"$nulls":8},{"$f":"2*B124","v":2}]
[null,1,"DC DB",null,{"$f":"C1*B125","v":30},{"$nulls":7},{"$f":"2*B125","v":2}]
[null,1,"VT",null,{"$f":"C2*B126","v":150},{"$nulls":7},{"$f":"2*B126","v":2}]
[null,1,"CT's",{"$nulls":4},{"$f":"C2*B127","v":150},{"$nulls":5},{"$f":"2*B127","v":2}]
[null,1,"BKR MB",{"$f":"C2*B128","v":150},{"$nulls":4},{"$f":"C2*B127","v":150},{"$nulls":5},{"$f":"2*B127","v":2}]
[null,1,"BKR CB SIDE ES",{"$f":"C2*B129","v":150},{"$nulls":8},{"$f":"2*B129","v":2}]
[null,1,"BKR BB SIDE ES",{"$f":"C2*B130","v":150},{"$nulls":8},2]
[null,1,"BB ISOLATOR",{"$f":"B131*C2","v":150},{"$nulls":8},{"$f":"2*B131","v":2}]
[null,1,"IDF",{"$nulls":6},{"$f":"B132*C1*2","v":60},{"$f":"B132*C1","v":30},null,{"$f":"2*B132*3","v":6}]
[null,null,"D20RTU",{"$nulls":8},{"$f":"B133*C1","v":0},{"$f":"2*B133","v":0}]
[{"$nulls":3},{"$f":"SUM(D124:D133)","v":630},{"$f":"SUM(E124:E133)","v":180},null,{"$f":"SUM(G124:G133)","v":0},150,150,60,30,0,18,2,2]

{"sheet":"Materials","index":4,"n_rows":68,"n_cols":8,"rows_kept":68,"merged":[[3,1,24,1],[3,2,3,5],[9,2,9,5],[13,2,13,5],[17,2,17,5],[20,2,20,5],[25,1,35,1],[25,2,25,5],[36,1,37,1],[38,1,44,1],[45,1,49,1],[50,1,55,1],[57,1,57,4]]}
[]
[]
[null,"MATERIALS","QUANTITY","ITEM","COST","TOTAL"]
[null," PROTECTION","1 x Transformer Protection Schemes - (TRFR-1: 20MVA, 88/22kV)"]
[null,null,0,"4TM-7101 TWO- OR THREE WINDING TRANSFORMER PROTECTION SCHEME (110V DC)",{"v":109000,"d":"R 109,000.00"},{"$f":"C5*E5","v":0}]
[null,null,0,"SWING FRAME PANEL OF DIMENSIONS:  2400mm HIGH x 800mm WIDE x 600mm DEEP. Bottom Entry",{"v":16000,"d":"R 16,000.00"},{"$f":"C6*E6","v":0}]
[null,null,0,"HANDLING AND INSTALLATION OF 1 x 4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME INTO THE SWING FRAME PANEL OF A 4TM-7xx0 SCHEME",{"v":1100,"d":"R 1,100.00"},{"$f":"C7*E7","v":0}]
[null,null,0,"HIGH IMPEDANCE RESTRICTED EARTH FAULT PROTECTION FOR 4TM-7101 OR 4TM-7150 TRANSFORMER PROTECTION SCHEMES FOR APPLICATION WITH A TWO-WINDING TRANSFORMER",{"v":29000,"d":"R 29,000.00"},{"$f":"C8*E8","v":0}]
[null,null,0,"ETHERNET COMMS INTERFACE SUPPORTING THE IEC 61850 PROTOCOL FOR A SEL-487E-3 RELAY",{"v":15000,"d":"R 15,000.00"},{"$f":"C9*E9","v":0}]
[null,null,"1 x Tap Changer Protection Schemes -  (TRFR-1: 20MVA)"]
[null,null,0,"4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME (110 VDC)",{"v":50000,"d":"R 50,000.00"},{"$f":"C11*E11","v":0}]
[null,null,0,"TEMPORARY CRATING, TRANSPORT AND OFFLOADING OF 1 X 4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME MODULE FROM POWERTECH IST WORKS TO CONSOLIDATED POWER PROJECTS (CONCO) WORKS",{"v":1800,"d":"R 1,800.00"},{"$f":"C12*E12","v":0}]
[null,null,0,"UPGRADE OF EBERLE REG-DA TAP CHANGE CONTROL RELAY TO INCLUDE REG-PED (ETHERNET) SUPERVISORY COMMS INTERFACE",{"v":6135,"d":"R 6,135.00"},{"$f":"C13*E13","v":0}]
[null,null,"22kV MV Rural Feeder Scheme "]
[null,null,0,"4RF-1101 Reticulation Feeder Protection Scheme (Serial SCADA only).  ",{"v":20500,"d":"R 20,500.00"},{"$f":"C15*E15","v":0}]
[null,null,0,"Optional second rear communication port for MiCOM P145 relay.  ",{"v":2000,"d":"R 2,000.00"},{"$f":"C16*E16","v":0}]
[null,null,0,"19' Swing frame panel.",{"v":13500,"d":"R 13,500.00"},{"$f":"C17*E17","v":0}]
[null,null,"Under Frequency Load Shedding Scheme (UFLS)"]
[null,null,0,"4LS-1101 Under Frequency Load Shedding Protection Scheme (Serial SCADA only).  ",{"v":30400,"d":"R 30,400.00"},{"$f":"C19*E19","v":0}]
[null,null,0,"19' Swing frame panel.",{"v":13500,"d":"R 13,500.00"},{"$f":"C20*E20","v":0}]
[null,null,"Capacitor Bank Protection Scheme (4CB1100)"]
[null,null,2,"GE C70 based Capacitor Bank Protection Scheme (Serial SCADA)",{"$f":"'NED Control Plant BOM'!H54","v":{"v":700000,"d":"R 700,000.00"}},{"$f":"C22*E22","v":{"v":1400000,"d":"R 1,400,000.00"}}]
[null,null,2,"Swing Frame Panel: 2400mm h x 800mm d x 600mm w",{"v":15000,"d":"R 15,000.00"},{"$f":"C23*E23","v":{"v":30000,"d":"R 30,000.00"}}]
[]
[null,null,0,"Crating of one 4CB1100 protection scheme module for transport",{"v":817,"d":"R 817.00"},0]
[null,"METERING","STATS METERING"]
[null,null,0,"Meter module Plate",{"v":7000,"d":"R 7,000.00"},{"$f":"C27*E27","v":0}]
[null,null,0,"Meter  ",{"v":4000,"d":"R 4,000.00"},0]
[null,null,0,"Cellular Modem",{"v":3000,"d":"R 3,000.00"},0]
[null,null,0,"MODULE, MODEM S/PANEL D9404",{"v":4000,"d":"R 4,000.00"},0]
[null,null,0,"Swing Frame Panels",{"v":9000,"d":"R 9,000.00"},0]
[null,null,0,"SIM Card",{"v":5,"d":"R 5.00"},0]
[null,null,0,"Voltage Selection Module",{"v":9500,"d":"R 9,500.00"},0]
[null,null,0,"7U Blanking Plate",{"v":100,"d":"R 100.00"},0]
[null,null,0,"3U Blanking Plate",{"v":70,"d":"R 70.00"},0]
[null,null,0,"Cage Nuts, Bolts",{"v":5,"d":"R 5.00"},0]
[null,"TELECONTROL",null,"Telecontrol"]
[null,null,1,"SERIAL TRAY WITH 1 MOXA ",{"$f":"'NED Control Plant BOM'!H88","v":{"v":6000,"d":"R 6,000.00"}},{"$f":"C38*E38","v":{"v":6000,"d":"R 6,000.00"}}]
[null,"DC SUPPLY",null,"Battery Bank"]
[null,null,0,"CELL, NICD 1.2V 75AH VTX1 M75 D9308",{"v":655,"d":"R 655.00"},{"$f":"C40*E40","v":0}]
[null,null,0,"CONNECTORS, VTX BATT LINK SET 3 ",{"v":700,"d":"R 700.00"},{"$f":"C41*E41","v":0}]
[null,null,0,"Battery Bank Cabinet",{"v":16700,"d":"R 16,700.00"},{"$f":"C42*E42","v":0}]
[{"$nulls":3},"110V DC LIGHTS"]
[null,null,0,"110DC Light",{"v":1000,"d":"R 1,000.00"},{"$f":"C44*E44","v":0}]
[null,null,0,"110DC Lights Switch",{"v":300,"d":"R 300.00"},{"$f":"C45*E45","v":0}]
[null,"TELECOMMS",null,"FIBRE OPTIC"]
[null,null,0,"12 core Heavy Duty Duct fibre cable 50/125nm Multimode (non-metallic) ",{"v":25,"d":"R 25.00"},{"$f":"C47*E47","v":0}]
[null,null,0,"Optex duct (Direct burial duct – OD/ID: 32/26mm)",{"v":30,"d":"R 30.00"},{"$f":"C48*E48","v":0}]
[null,null,0,"Plastic/Metal dome fibre splice closure",{"v":3500,"d":"R 3,500.00"},{"$f":"C49*E49","v":0}]
[null,null,0,"STX mounting rail distributor with 6xST Duplex, splice\ncassette, Pigtails, cable strain relief                                             [12x G50/125 OM2, ST]",{"v":1000,"d":"R 1,000.00"},{"$f":"C50*E50","v":0}]
[null,"AUX",null,"AUXILLARIES"]
[null,null,0,"VRW20 Junction Box , with 8 circuit VT insert (Fitted) (Complete JB)\n304 stainless steel option.\n",{"v":7100,"d":"R 7,100.00"},{"$f":"C52*E52","v":0}]
[{"$nulls":3},"CT Junction Box",{"v":6000,"d":"R 6,000.00"},{"$f":"C53*E53","v":0}]
[null,null,0,"AC Distribution Board",{"v":13000,"d":"R 13,000.00"},{"$f":"C54*E54","v":0}]
[{"$nulls":3},"Transformer Junction Box",{"v":13000,"d":"R 13,000.00"},{"$f":"C55*E55","v":0}]
[{"$nulls":3},"Cable and Glands",{"$f":"SUM('NED Control Plant BOM'!I109:I120)","v":{"v":69140,"d":"R 69,140.00"}},{"$f":"E56","v":{"v":69140,"d":"R 69,140.00"}}]
[null,"Miscellaneous ",null,{"v":0.1,"d":"10%"},null,{"$f":"D57*SUM(F5:F9,F11:F13,F15:F17,F19:F20,F27:F36,F38,F40:F42,F44:F45,F52:F56,F47:F50,F22:F25)","v":{"v":150514,"d":"R 150,514.00"}}]
[null,"TOTAL",{"$nulls":3},{"$f":"SUM(F5:F9,F11:F13,F15:F17,F19:F20,F27:F36,F38,F40:F42,F44:F45,F52:F57,F47:F50,F22:F25)","v":{"v":1655654,"d":"R 1,655,654.00"}}]
[]
[]
[]
[{"$nulls":5},{"$f":"F58-F57","v":{"v":1505140,"d":"R 1,505,140.00"}}]
[{"$nulls":5},{"$f":"'NED Control Plant BOM'!I150","v":0}]
[{"$nulls":5},{"$f":"F62-F63","v":{"v":1505140,"d":"R 1,505,140.00"}}]
[]
[]
[]
[{"$nulls":7},"v"]

{"sheet":"Long Lead Material","index":5,"n_rows":68,"n_cols":8,"rows_kept":68,"merged":[[3,1,24,1],[3,2,3,5],[9,2,9,5],[13,2,13,5],[17,2,17,5],[20,2,20,5],[25,1,35,1],[25,2,25,5],[36,1,37,1],[38,1,44,1],[45,1,49,1],[50,1,55,1],[57,1,57,4]]}
[]
[]
[null,"MATERIALS","QUANTITY","ITEM","COST","TOTAL"]
[null," PROTECTION","1 x Transformer Protection Schemes - (TRFR-1: 20MVA, 88/22kV)"]
[null,null,0,"4TM-7101 TWO- OR THREE WINDING TRANSFORMER PROTECTION SCHEME (110V DC)",{"v":109000,"d":"R 109,000.00"},{"$f":"C5*E5","v":0}]
[null,null,0,"SWING FRAME PANEL OF DIMENSIONS:  2400mm HIGH x 800mm WIDE x 600mm DEEP. Bottom Entry",{"v":16000,"d":"R 16,000.00"},{"$f":"C6*E6","v":0}]
[null,null,0,"HANDLING AND INSTALLATION OF 1 x 4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME INTO THE SWING FRAME PANEL OF A 4TM-7xx0 SCHEME",{"v":1100,"d":"R 1,100.00"},{"$f":"C7*E7","v":0}]
[null,null,0,"HIGH IMPEDANCE RESTRICTED EARTH FAULT PROTECTION FOR 4TM-7101 OR 4TM-7150 TRANSFORMER PROTECTION SCHEMES FOR APPLICATION WITH A TWO-WINDING TRANSFORMER",{"v":29000,"d":"R 29,000.00"},{"$f":"C8*E8","v":0}]
[null,null,0,"ETHERNET COMMS INTERFACE SUPPORTING THE IEC 61850 PROTOCOL FOR A SEL-487E-3 RELAY",{"v":15000,"d":"R 15,000.00"},{"$f":"C9*E9","v":0}]
[null,null,"1 x Tap Changer Protection Schemes -  (TRFR-1: 20MVA)"]
[null,null,0,"4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME (110 VDC)",{"v":50000,"d":"R 50,000.00"},{"$f":"C11*E11","v":0}]
[null,null,0,"TEMPORARY CRATING, TRANSPORT AND OFFLOADING OF 1 X 4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME MODULE FROM POWERTECH IST WORKS TO CONSOLIDATED POWER PROJECTS (CONCO) WORKS",{"v":1800,"d":"R 1,800.00"},{"$f":"C12*E12","v":0}]
[null,null,0,"UPGRADE OF EBERLE REG-DA TAP CHANGE CONTROL RELAY TO INCLUDE REG-PED (ETHERNET) SUPERVISORY COMMS INTERFACE",{"v":6135,"d":"R 6,135.00"},{"$f":"C13*E13","v":0}]
[null,null,"22kV MV Rural Feeder Scheme "]
[null,null,0,"4RF-1101 Reticulation Feeder Protection Scheme (Serial SCADA only).  ",{"v":20500,"d":"R 20,500.00"},{"$f":"C15*E15","v":0}]
[null,null,0,"Optional second rear communication port for MiCOM P145 relay.  ",{"v":2000,"d":"R 2,000.00"},{"$f":"C16*E16","v":0}]
[null,null,0,"19' Swing frame panel.",{"v":13500,"d":"R 13,500.00"},{"$f":"C17*E17","v":0}]
[null,null,"Under Frequency Load Shedding Scheme (UFLS)"]
[null,null,0,"4LS-1101 Under Frequency Load Shedding Protection Scheme (Serial SCADA only).  ",{"v":30400,"d":"R 30,400.00"},{"$f":"C19*E19","v":0}]
[null,null,0,"19' Swing frame panel.",{"v":13500,"d":"R 13,500.00"},{"$f":"C20*E20","v":0}]
[null,null,"Capacitor Bank Protection Scheme (4CB1100)"]
[null,null,2,"C70 based Capacitor Bank Protection Scheme (Serial SCADA only)",{"$f":"'NED Control Plant BOM'!H54","v":{"v":700000,"d":"R 700,000.00"}},{"$f":"C22*E22","v":{"v":1400000,"d":"R 1,400,000.00"}}]
[null,null,2,"Swing Frame Panel: 2400mm h x 800mm d x 600mm w",{"v":15000,"d":"R 15,000.00"},{"$f":"C23*E23","v":{"v":30000,"d":"R 30,000.00"}}]
[]
[null,null,0,"Crating of one 4CB1100 protection scheme module for transport",{"v":817,"d":"R 817.00"},0]
[null,"METERING","STATS METERING"]
[null,null,0,"Meter module Plate",{"v":7000,"d":"R 7,000.00"},{"$f":"C27*E27","v":0}]
[null,null,0,"Meter  ",{"v":4000,"d":"R 4,000.00"},0]
[null,null,0,"Cellular Modem",{"v":3000,"d":"R 3,000.00"},0]
[null,null,0,"MODULE, MODEM S/PANEL D9404",{"v":4000,"d":"R 4,000.00"},0]
[null,null,0,"Swing Frame Panels",{"v":9000,"d":"R 9,000.00"},0]
[null,null,0,"SIM Card",{"v":5,"d":"R 5.00"},0]
[null,null,0,"Voltage Selection Module",{"v":9500,"d":"R 9,500.00"},0]
[null,null,0,"7U Blanking Plate",{"v":100,"d":"R 100.00"},0]
[null,null,0,"3U Blanking Plate",{"v":70,"d":"R 70.00"},0]
[null,null,0,"Cage Nuts, Bolts",{"v":5,"d":"R 5.00"},0]
[null,"TELECONTROL",null,"Telecontrol"]
[null,null,1,"SERIAL TRAY WITH 1 MOXA ",{"$f":"'NED Control Plant BOM'!H88","v":{"v":6000,"d":"R 6,000.00"}},{"$f":"C38*E38","v":{"v":6000,"d":"R 6,000.00"}}]
[null,"DC SUPPLY",null,"Battery Bank"]
[null,null,0,"CELL, NICD 1.2V 75AH VTX1 M75 D9308",{"v":655,"d":"R 655.00"},{"$f":"C40*E40","v":0}]
[null,null,0,"CONNECTORS, VTX BATT LINK SET 3 ",{"v":700,"d":"R 700.00"},{"$f":"C41*E41","v":0}]
[null,null,0,"Battery Bank Cabinet",{"v":16700,"d":"R 16,700.00"},{"$f":"C42*E42","v":0}]
[{"$nulls":3},"110V DC LIGHTS"]
[null,null,0,"110DC Light",{"v":1000,"d":"R 1,000.00"},{"$f":"C44*E44","v":0}]
[null,null,0,"110DC Lights Switch",{"v":300,"d":"R 300.00"},{"$f":"C45*E45","v":0}]
[null,"TELECOMMS",null,"FIBRE OPTIC"]
[null,null,0,"12 core Heavy Duty Duct fibre cable 50/125nm Multimode (non-metallic) ",{"v":25,"d":"R 25.00"},{"$f":"C47*E47","v":0}]
[null,null,0,"Optex duct (Direct burial duct – OD/ID: 32/26mm)",{"v":30,"d":"R 30.00"},{"$f":"C48*E48","v":0}]
[null,null,0,"Plastic/Metal dome fibre splice closure",{"v":3500,"d":"R 3,500.00"},{"$f":"C49*E49","v":0}]
[null,null,0,"STX mounting rail distributor with 6xST Duplex, splice\ncassette, Pigtails, cable strain relief                                             [12x G50/125 OM2, ST]",{"v":1000,"d":"R 1,000.00"},{"$f":"C50*E50","v":0}]
[null,"AUX",null,"AUXILLARIES"]
[null,null,0,"VRW20 Junction Box , with 8 circuit VT insert (Fitted) (Complete JB)\n304 stainless steel option.\n",{"v":7100,"d":"R 7,100.00"},{"$f":"C52*E52","v":0}]
[{"$nulls":3},"CT Junction Box",{"v":6000,"d":"R 6,000.00"},{"$f":"C53*E53","v":0}]
[null,null,0,"AC Distribution Board",{"v":13000,"d":"R 13,000.00"},{"$f":"C54*E54","v":0}]
[{"$nulls":3},"Transformer Junction Box",{"v":13000,"d":"R 13,000.00"},{"$f":"C55*E55","v":0}]
[{"$nulls":3},"Cable and Glands",{"$f":"SUM('NED Control Plant BOM'!I109:I120)","v":{"v":69140,"d":"R 69,140.00"}},{"$f":"E56","v":{"v":69140,"d":"R 69,140.00"}}]
[null,"Miscellaneous ",null,{"v":0,"d":"0%"},null,{"$f":"D57*SUM(F5:F9,F11:F13,F15:F17,F19:F20,F27:F36,F38,F40:F42,F44:F45,F52:F56,F47:F50,F22:F25)","v":0}]
[null,"TOTAL",{"$nulls":3},{"$f":"SUM(F5:F9,F11:F13,F15:F17,F19:F20,F27:F36,F38,F40:F42,F44:F45,F52:F57,F47:F50,F22:F25)","v":{"v":1505140,"d":"R 1,505,140.00"}}]
[]
[]
[]
[{"$nulls":5},{"$f":"F58-F57","v":{"v":1505140,"d":"R 1,505,140.00"}}]
[{"$nulls":5},{"$f":"'NED Control Plant BOM'!I150","v":0}]
[{"$nulls":5},{"$f":"F62-F63","v":{"v":1505140,"d":"R 1,505,140.00"}}]
[]
[]
[]
[{"$nulls":7},"v"]

{"sheet":"TELECONTROL","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"hidden":true}
{"$rows_empty":7}
[null,"I/O","Status inputs","Control outputs","Analogues inputs"]
[null,"Proposed capacity",{"$f":"SUM(C12:C15)","v":192},{"$f":"SUM(D12:D15)","v":64},{"$f":"SUM(E12:E15)","v":32}]
[]
[]
[0,"Combo Card",{"$f":"16*A12","v":0},{"$f":"8*A12","v":0},{"$f":"16*A12","v":0}]
[3,"Status Card",{"$f":"A13*64","v":192}]
[2,"Control Card",null,{"$f":"A14*32","v":64}]
[1,"Analogue Card",null,null,{"$f":"A15*32","v":32}]

{"sheet":"Cost Summary","index":7,"n_rows":39,"n_cols":5,"rows_kept":39,"merged":[[3,1,3,3],[3,4,3,5],[4,1,4,3],[4,4,4,5],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[8,4,8,5],[15,1,15,3],[27,1,27,3],[31,1,31,3],[34,1,34,3],[34,4,34,5],[36,1,36,3],[36,4,36,5],[38,1,38,3],[38,4,38,5]]}
[]
[]
[]
[null,"Description",null,null,"Cost"]
[null,"Material Cost (M)",null,null,{"$f":"SUM(E6:E8)","v":{"v":1655654,"d":"R 1,655,654.00"}}]
[null,"Control Plant ( C)",null,null,{"$f":"Materials!F58","v":{"v":1655654,"d":"R 1,655,654.00"}}]
[null,"Primary Plant (M)",null,null,0]
[null,"Reticulation - 33 & 11kv Line (Material)",null,null,0]
[null,"Labour and Transport",null,null,{"$f":"E16+E10+E28+E32","v":{"v":2068308.6,"d":"R 2,068,308.60"}}]
[null,"Engineering Cost (E)",null,null,{"$f":"SUM(D11:D15)","v":{"v":307274.6,"d":"R 307,274.60"}}]
[null,"Control Plant Design (C)",null,{"$f":"'CP FEES'!G58","v":{"v":307274.6,"d":"R 307,274.60"}}]
[null,"Project  Management Fees (B)",null,0]
[null,"Environment ( E)",null,0]
[null,"Primary Plant (Survey, Design, Environ)",null,0]
[null,"Reticulation - 33 & 11kv Line (Design)",null,0]
[null,"Internal  Contracts",null,null,{"$f":"SUM(D17:D27)","v":{"v":65000,"d":"R 65,000.00"}}]
[null,"SCADA Management",null,{"$f":"500*20","v":{"v":10000,"d":"R 10,000.00"}}]
[null,"Control Plant Maintenance (CPM) Audit",null,{"v":35000,"d":"R 35,000.00"}]
[null,"Settings and Configuration",null,{"v":20000,"d":"R 20,000.00"}]
[null,"MEW",null,0]
[null,"Control Plant Maintenance (CPM) Mobile Commissioning",null,0]
[null,"Electrical (Labour only)",null,0]
[null,"FS, TSG, Workshops",null,0]
[null,"Reticulation - 33 & 11kv Line [Transport,Eng Survey & Geo Mapping( MV ), Project Management Fees MV, Field Services ( MV ), Commissioning]",null,0]
[null,"Major Engineering Works (MEW)",null,0]
[null,"TSG - Mobile Substation",null,0]
[null,"Fibre Contractor (Eskom Telecomms)",null,0]
[null,"External Contracts",null,null,{"$f":"SUM(D29:D31)","v":{"v":0,"d":"R 0.00"}}]
[null,"Civil Works (Material & Labour)",null,0]
[null,"Reticulation - 33 & 11kv Line (Labour)",null,0]
[null,"Demolish & Rehabilitate site",null,0]
[null,"Commissioning (T)",null,null,{"$f":"SUM(D33:D34)","v":{"v":1696034,"d":"R 1,696,034.00"}}]
[null,"Customer Network Centre (CNC)",null,{"v":5000,"d":"R 5,000.00"}]
[null,"PTM/Commissioning Contractor",null,{"v":1691034,"d":"R 1,691,034.00"}]
[null,"Sub-Total 1",null,null,{"$f":"SUM(E5 + E9)","v":{"v":3723962.6,"d":"R 3,723,962.60"}}]
[null,"Overheads",null,{"v":0.1,"d":"10.00%"},{"$f":" D36*E35","v":{"v":372396.26,"d":"R 372,396.26"}}]
[null,"Sub-Total 2",null,null,{"$f":"SUM(E35:F36)","v":{"v":4096358.8600000003,"d":"R 4,096,358.86"}}]
[null,"IDC (Calculated over  6 Months)",9,{"v":0,"d":"0.00%"},{"$f":"IF(C38<9,0,E37*(C38/12)*D38)*0.6","v":0}]
[null,"Total Project Cost",null,null,{"$f":"SUM(E37:F38)","v":{"v":4096358.8600000003,"d":"R 4,096,358.86"}}]

{"sheet":"Panel Footprints","index":8,"n_rows":27,"n_cols":4,"rows_kept":27,"hidden":true,"merged":[[14,1,14,3],[20,1,20,3],[21,1,21,2]]}
[]
[]
[null,"Description","Dimension","Panels"]
[null,"Transformer and Tapchanger Schemes","2400mm HIGH x 800mm WIDE x 600mm DEEP ",1]
[null,"Buszone Protection","2400mm HIGH x 800mm WIDE x 600mm DEEP "]
[null,"Tariff Metering","2400mm HIGH x 800mm WIDE x 600mm DEEP "]
[null,"Statistical Metering","2400mm HIGH x 800mm WIDE x 600mm DEEP ",1]
[null,"Customer Metering Panel","2400mm HIGH x 800mm WIDE x 600mm DEEP "]
[null,"Battery Charger 110V","1300mm HIGH x 1200mm WIDE x 750mm DEEP "]
[null,"Battery Bank 110V ","1800mm HIGH x 850mm WIDE x 650mm DEEP "]
[null,"110V Top Drawer Battery Charger and Battery Bank","1300mm HIGH x 1200mm WIDE x 750mm DEEP                ",1]
[null,"D20 RTU","1800mm HIGH x 800mm WIDE x 600mm DEEP                ",1]
[null,"SUB-TOTAL",null,{"$f":"SUM(D4:D12)","v":4}]
[]
[null,"Wall Mount"]
[null,"AC Distribution Board","850mm HIGH x 1100mm WIDE x 200mm DEEP ",1]
[null,"AC Distribution Board"]
[null,"DC Distribution Board","735mm HIGH x 600mm WIDE x 150mm DEEP ",1]
[null,"CCTV"]
[null,"SUB-TOTAL",null,{"$f":"SUM(D16:D19)","v":2}]
[]
[null,"TOTAL",null,{"$f":"D13+D20","v":6}]
[]
[]
[]
[]
[null,null,"Reserve 4 33/11kV S/S Relocation (5km)"]

{"sheet":"BOM","index":9,"n_rows":95,"n_cols":14,"rows_kept":95,"hidden":true,"merged":[[1,1,1,11],[2,1,2,11],[8,1,8,11],[12,1,12,11],[13,13,15,13],[16,1,16,11],[17,13,18,13],[19,1,19,11],[20,1,20,11],[31,1,31,11],[32,1,32,11],[36,1,36,11],[39,1,39,11],[40,1,40,11],[41,10,43,10],[41,11,43,11],[41,12,43,12],[41,13,43,13],[44,1,44,11],[47,1,47,11],[57,1,57,11],[61,1,61,11],[73,1,73,11],[78,1,78,11],[80,1,80,11]]}
["ITEM","QTY","TYPE","MNFR","SUPPLIER","DESCRIPTION","ENC?","TECHNICAL DETAILS","SAP No","Status","Price/Unit","Total Price","LLT","Comment"]
[null,"               PROTECTION"]
[null,"1 x Transformer Protection Schemes - (TRFR-1: 20MVA, 88/22kV)"]
[1,0,"4TM-7101 TWO- OR THREE WINDING TRANSFORMER PROTECTION SCHEME (110V DC)","CONCO","CONCO","Includes capability for differential- and low impedance Restricted Earth Fault protection, current- and voltage-based protection and measurements. Supervisory indications and controls via serial communication:  rear RS485 port with DNP3 protocol.\nIncludes second rear RS485 port for remote engineering access (via SEL’s LMD protocol).\n",4600037464,"See Ordering Schedule",246026,"To Order",{"v":109000,"d":"R 109,000.00"},{"$f":"K4*B4","v":0},"Y"]
[2,0,"SWING FRAME PANEL OF DIMENSIONS:  2400mm HIGH x 800mm WIDE x 600mm DEEP. Bottom Entry","CONCO","CONCO","Includes:\n1) Installation of 1 x 4TM-7xx0 transformer protection scheme into panel\n2) All blanking plates to close front panel aperture\n3) Crating for transport\n",4600037464,"See Ordering Schedule",246031,"To Order",{"v":16000,"d":"R 16,000.00"},{"$f":"K5*B5","v":0},"Y"]
[3,0,"HANDLING AND INSTALLATION OF 1 x 4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME INTO THE SWING FRAME PANEL OF A 4TM-7xx0 SCHEME","CONCO","CONCO","HANDLING AND INSTALLATION OF 1 x 4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME INTO THE SWING FRAME PANEL OF A 4TM-7xx0 SCHEME",4600037464,"See Ordering Schedule",246033,"To Order",{"v":1100,"d":"R 1,100.00"},{"$f":"K6*B6","v":0},"Y"]
[4,0,"HIGH IMPEDANCE RESTRICTED EARTH FAULT PROTECTION FOR 4TM-7101 OR 4TM-7150 TRANSFORMER PROTECTION SCHEMES FOR APPLICATION WITH A TWO-WINDING TRANSFORMER","CONCO","CONCO","Includes:\n- 2 x RMS 2V73 High impedance differential protection relays\n- 2 x Single phase metrosils (one 6 inch, one 3 inch)\n- Installation and additional wiring as per Eskom master drawings D-DT-15202 and D-DT-15203 Level 8\n",4600037464,"See Ordering Schedule",246035,"To Order",{"v":29000,"d":"R 29,000.00"},{"$f":"K7*B7","v":0},"Y"]
[5,0,"ETHERNET COMMS INTERFACE SUPPORTING THE IEC 61850 PROTOCOL FOR A SEL-487E-3 RELAY","CONCO","CONCO","Note: When specified at scheme ordering stage, the scheme will be delivered with the Ethernet card AND SEL-2885 and SEL-2886 RS232 to RS485 converters of default schemes (i.e. Levels 27 and 28 of the scheme master drawings).",4600037464,"See Ordering Schedule",246044,"To Order",{"v":15000,"d":"R 15,000.00"},{"$f":"K8*B8","v":0},"Y"]
[null,"1 x Tap Changer Protection Schemes -  (TRFR-1: 20MVA)"]
[6,0,"4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME (110 VDC)","Powertech IST Energy\n","Powertech IST Energy\n","Manual and automatic tap change control with tapping supervision.  Parallel control via circulating current minimisation or master–slave programs.  Compatible with REG-D voltage regulating relays.\nSupervisory indications and controls via serial communication:  rear RS-485 port with DNP3 protocol.\nAccepts binary encoded tap position indication from tap change drive.\nVoltage supplies: 110 Volt DC and 230 Volt AC.\nSuitable for 1A or 5A rated current transformer input.\n",4600036968,"See Ordering Schedule",246077,"To Order",{"v":50000,"d":"R 50,000.00"},{"$f":"K10*B10","v":0},"Y"]
[7,0,"TEMPORARY CRATING, TRANSPORT AND OFFLOADING OF 1 X 4TC-5200 TAP CHANGE PROTECTION AND CONTROL SCHEME MODULE FROM POWERTECH IST WORKS TO CONSOLIDATED POWER PROJECTS (CONCO) WORKS","Powertech IST Energy\n","Powertech IST Energy\n","Non-stock item for costing purposes only.\nEXCLUDES: \n- Handling, storage and installation of the module into the transformer protection scheme by CONCO ",4600036968,"See Ordering Schedule",246080,"To Order",{"v":1800,"d":"R 1,800.00"},{"$f":"K11*B11","v":0},"Y"]
[8,0,"UPGRADE OF EBERLE REG-DA TAP CHANGE CONTROL RELAY TO INCLUDE REG-PED (ETHERNET) SUPERVISORY COMMS INTERFACE","Powertech IST Energy","Powertech IST Energy","INCLUDES:-\n- 1 x RS-485 port supporting the DNP3 protocol (replaces the RS-485 port provided on standard relay).\n- 1 x 820 nm fibre optic Ethernet port and 1 x copper Ethernet port supporting IEC 61850 (SCADA protocol excluding goose messages)\n",4600036968,"See Ordering Schedule",246086,"To Order",{"v":6135,"d":"R 6,135.00"},{"$f":"K12*B12","v":0},"Y"]
[null,"22kV MV Rural Feeder Scheme "]
[9,0,"4RF-1101 Reticulation Feeder Protection Scheme (Serial SCADA only).  ","ACTOM Protection & Control","ACTOM Protection & Control"," Including a MiCOM P145 feeder management relay.",4600039646,"See Ordering Schedule",583094,"To Order",{"v":20500,"d":"R 20,500.00"},{"$f":"K14*B14","v":0},"Y","Only 2 schemes shall be installed in the same panel (item 11).  The third scheme to be housed in the UFLS pane (item 13)."]
[10,0,"Optional second rear communication port for MiCOM P145 relay.  ","ACTOM Protection & Control","ACTOM Protection & Control","Supports Courier protocol on RS-485/RS-232/K-bus (user settable) for remote engineering access.  ",4600039646,"See Ordering Schedule",224955,"To Order",{"v":2000,"d":"R 2,000.00"},{"$f":"K15*B15","v":0},"Y"]
[11,0,"19' Swing frame panel.","ACTOM Protection & Control","ACTOM Protection & Control","Swing frame panel of dimensions:  2400mm high x 800mm wide x 600mm deep suitable for top or bottom entry of cables.  This will be used for Bottom Entry Cables. ",4600039646,"See Ordering Schedule",224951,"To Order",{"v":13500,"d":"R 13,500.00"},{"$f":"K16*B16","v":0},"Y"]
[null,"Under Frequency Load Shedding Scheme (UFLS)"]
[12,0,"4LS-1101 Under Frequency Load Shedding Protection Scheme (Serial SCADA only).  ","Alstom","Alstom","SCADA only via RS-485 serial interface (i.e. traditional hardwired supervisory alarms and controls are NOT provided).",4600050463,"See Ordering Schedule",404058,"To Order",{"v":30400,"d":"R 30,400.00"},{"$f":"K18*B18","v":0},"Y","To be housed in the panel (item 13)."]
[13,0,"19' Swing frame panel.","Alstom","Alstom","Swing frame panel of dimensions:  2400mm high x 800mm wide x 600mm deep suitable for top or bottom entry of cables",4600050463,"See Ordering Schedule",404074,"To Order",{"v":13500,"d":"R 13,500.00"},{"$f":"K19*B19","v":0},"Y"]
[null,"METERING"]
[null,"STATS METERING"]
[1,null,"Meter module Plate","Out to tender","Out to tender","Meter Module (14U)- MODULE, METERING STD METER SUBPANEL D9400","NO","See Ordering Schedule",175685,"To Order",{"v":7000,"d":"R 7,000.00"},{"$f":"K22*B22","v":0},"Y"]
[1,1,"Meter  ","Various","Various","METER 3 PH CL0.5 1A RS485 D9420 ","NO","See Ordering Schedule",242580,"To Order",{"v":4000,"d":"R 4,000.00"},{"v":4000,"d":"R 4,000.00"},"Y"]
[3,null,"Cellular Modem","Truteq","Truteq","MODEM, METERING TRUCOM SMARTOO D9503 ","NO","See Ordering Schedule",223364,"To Order",{"v":3000,"d":"R 3,000.00"},0,"Y"]
[2,1,"MODULE, MODEM S/PANEL D9404","Truteq","Truteq","MODULE TO BE USED TO MOUNT THE CELL MODEM EQUIPMENT","NO","See Ordering Schedule","0230645","To Order",{"v":4000,"d":"R 4,000.00"},{"v":4000,"d":"R 4,000.00"},"Y"]
[5,null,"Swing Frame Panel","World Power Products","World Power Products","To be used as the metering panel. ",4600036012,"see schedule",402613,"To Order",{"v":9000,"d":"R 9,000.00"},0,"Y"]
[6,null,"SIM Card",null,"Innocent Mdletshe (031 710 5504)","SIM Card for Cellular Modem","NO","Innocent Mdletshe (031 710 5504)","N/A","To Order",{"v":5,"d":"R 5.00"},0,"N"]
[null,0,"Voltage Selection Module",null,null,"Voltage selection module D",null,"Module, Volt. Selection D   D9401 ",175688,"To Order",{"v":9500,"d":"R 9,500.00"},0,"Y"]
[3,0,"7U Blanking Plate","World Power Products","World Power Products","7U Blanking Plate",4600036012,"See Ordering Schedule",401958,"To Order",{"v":100,"d":"R 100.00"},0,"Y"]
[4,0,"3U Blanking Plate","World Power Products","World Power Products","PLATE, BLANKING PROT SCHEME 3U M/S D9141",4600036012,"See Ordering Schedule",401952,"To Order",{"v":70,"d":"R 70.00"},0,"Y"]
[3,10,"Cage Nuts, Bolts","World Power Products","World Power Products","M6 Cage nuts, bolts with 6mm sealing washer",4600036012,"See Ordering Schedule",401414,"To Order",{"v":5,"d":"R 5.00"},{"v":50,"d":"R 50.00"},"Y"]
[null,"DC SUPPLY"]
[null,"110V DC Battery Bank"]
[null,null,"CELL, NICD 1.2V 75AH VTX1 M75 D9308","Alcad\n","ALKALINE BATTERIES","CELL, NICD 1.2V 75AH VTX1 M75 D9308",4600041171,"See Ordering Schedule",256101,"To Order",{"v":655,"d":"R 655.00"},{"$f":"B34*K34","v":0},"Y"]
[null,null,"CONNECTORS, VTX BATT LINK SET 3 ","Alcad\n","ALKALINE BATTERIES","CONNECTORS, VTX BATT LINK SET 3 ",4600041171,"See Ordering Schedule",256348,"To Order",{"v":700,"d":"R 700.00"},{"$f":"B35*K35","v":0},"Y"]
[null,null,"Battery Bank Cabinet","Alcad\n","ALKALINE BATTERIES","CABINET, BATT NICD 88C SA TYPE 3",4600041171,"See Ordering Schedule",256354,"To Order",{"v":16700,"d":"R 16,700.00"},{"$f":"B36*K36","v":0},"Y"]
[null,"110V DC LIGHTS"]
[4,4,"110DC Light",null,null,"110DC Light","NO",null,null,"To Order",{"v":1000,"d":"R 1,000.00"},{"$f":"B38*K38","v":{"v":4000,"d":"R 4,000.00"}},"N"]
[5,1,"110DC Lights Switch",null,null,"110DC Lights Switch","NO",null,null,"To Order",{"v":300,"d":"R 300.00"},{"$f":"B39*K39","v":{"v":300,"d":"R 300.00"}},"N"]
[null,"TELECONTROL"]
[null,"D20RTU"]
[6,1,"RTU D20 CONFIG 11 1MOXA D20C KRONE D9653","IST","IST","Config 11 Krone D20 RTU, 1 D20C, 1 Moxa",4600048574,"ISTE-00011","250318","To Order",{"v":110000,"d":"R 110,000.00"},{"$f":"K42*B42","v":{"v":110000,"d":"R 110,000.00"}},"Y","All D20RTU associated equipment to be housed in the D20RTU  Panel. "]
[7,1,"Power Supply","IST","IST","IST GE 110 VDC PSU HIGH POWER 19 INCH RACKMOUNT",4600048574,"ISTE-10700","0248402","To Order"]
[8,1,"D20 Cabinet","IST","IST","PB8 800w x 600d cabinets with removable sides, swing frame, “G” rails, earth studs,",4600048574,"ISTE-40120","213366","To Order"]
[null,"Digital Radio"]
[9,1,"TRIO DIGITAL RADIOS ER450E series Generation ll","Eskom Telecommunications 031 710 5420. (Vendor 11051059)","Eskom Telecommunications 031 710 5420. (Vendor 11051059)","TRIO DIGITAL RADIOS ER450E series Generation ll\nModel No: ER450-63E01-DH0, with diagnostics option installed",null,"See Ordering Schedule",225674,"To Order",{"v":7500,"d":"R 7,500.00"},{"$f":"K46*B46","v":{"v":7500,"d":"R 7,500.00"}},"Y"]
[10,1,"MATERIALS - RS232 adaptor cable for TRIO radio ER450 to RTU","Eskom Telecommunications 031 710 5420. (Vendor 11051059)","Eskom Telecommunications 031 710 5420. (Vendor 11051059)","MATERIALS - RS232 adaptor cable for TRIO radio ER450 to RTU",{"$nulls":3},"To Order",{"v":100,"d":"R 100.00"},{"$f":"K47*B47","v":{"v":100,"d":"R 100.00"}},"Y"]
[null,"RTU Antenna"]
[11,1,"3 ELEMENT WEBB ANTENNA  WITH CASTING HUB.","WEBB INDUSTRIES","WEBB INDUSTRIES","WEBB ANTENNA (380 - 470 MHz).  Y425/3 . TUNED TO CENTRE FREQ. 410MHZ. 3 ELEMENT WITH CASTING HUB.",{"$nulls":3},"To Order",{"v":700,"d":"R 700.00"},{"$f":"K49*B49","v":{"v":700,"d":"R 700.00"}},"Y","The 6m aluminium pole is already installed on site."]
[12,1,"3M RUBBER TAPE","WEBB INDUSTRIES","WEBB INDUSTRIES","3M RUBBER TAPE",{"$nulls":3},"To Order",{"v":80,"d":"R 80.00"},{"v":80,"d":"R 80.00"},"Y","Roll"]
[13,1,"2 Metre LEAD COAXIAL CABLE FLYLEAD WITH N FEMALE BULKHEAD TO N-TYPE MALE ","WEBB INDUSTRIES","WEBB INDUSTRIES","2 Metre FLYLEAD LMR195 COAXIAL CABLE  PREMADE WITH N FEMALE BULKHEAD (J01021A0147) TO N-TYPE MALE (J01020A0108) CONNECTORS ",{"$nulls":3},"To Order",{"v":180,"d":"R 180.00"},{"v":180,"d":"R 180.00"},"Y","2 metres"]
[14,1,"30 METRE LMR 400 WITH N-MALE JO1020A0127 AND N-FEMALE J01021AA0155  TELEGAERTNER CONNECTORS","WEBB INDUSTRIES 011 444 2299","WEBB INDUSTRIES 011 444 2299","30 METRE LMR 400 WITH N-MALE JO1020A0127 AND N-FEMALE J01021AA0155  TELEGAERTNER CONNECTORS",{"$nulls":3},"To Order",{"v":8400,"d":"R 8,400.00"},{"v":8400,"d":"R 8,400.00"},"Y","30 metres"]
[null,1,"ALUMINIUM POLE","WEBB INDUSTRIES 011 444 2299","WEBB INDUSTRIES 011 444 2299"," 6m ALUMINIUM POLE 50mm DIAMETER 5mm WALL THICKNESS",{"$nulls":3},"To Order",{"v":1000,"d":"R 1,000.00"},{"v":1000,"d":"R 1,000.00"},"Y"]
[15,10,"CUMFY CLAMPS   TK 78-2.  (WITH CLIPS)","WEBB INDUSTRIES 011 444 2299","WEBB INDUSTRIES 011 444 2299","CUMFY CLAMPS   TK 78-2.  (WITH CLIPS)",{"$nulls":3},"To Order",{"v":11.7,"d":"R 11.70"},{"v":117,"d":"R 117.00"},"Y"]
[16,2,"BANDIT STRAP","WEBB INDUSTRIES 011 444 2299","WEBB INDUSTRIES 011 444 2299","BANDIT STRAP",{"$nulls":3},"To Order",{"v":18,"d":"R 18.00"},{"v":36,"d":"R 36.00"},"Y","in metres (m)"]
[17,10,"BANDIT CLIPS","WEBB INDUSTRIES 011 444 2299","WEBB INDUSTRIES 011 444 2299","BANDIT CLIPS",{"$nulls":3},"To Order",{"v":2,"d":"R 2.00"},{"v":20,"d":"R 20.00"},"Y"]
[18,1,"0.5 mm BOOTLACE FERRULES","WEBB INDUSTRIES 011 444 2299","WEBB INDUSTRIES 011 444 2299","0.5 mm BOOTLACE FERRULES",{"$nulls":3},"To Order",{"v":23,"d":"R 23.00"},{"v":23,"d":"R 23.00"},"Y","Pocket"]
[null,"Door Switch and other Telecontrol associated material"]
[19,1,"DOOR ALARM","Omron","Electric World ","Omron limit switch WLNJ-Y :- order from Electric World Pinetown - 031 716 9300",{"$nulls":3},"To Order",{"v":600,"d":"R 600.00"},{"$f":"K59*B59","v":{"v":600,"d":"R 600.00"}},"N","For Control room."]
[20,2,"MEDIUM CABLE TIES (WHITE)","NOT OBLIGATORY","NOT OBLIGATORY","MEDIUM CABLE TIES (WHITE)",null,"PACKETS",null,"To Order",{"v":30,"d":"R 30.00"},{"$f":"K60*B60","v":{"v":60,"d":"R 60.00"}},"N"]
[21,1,"SMALL CABLE TIES (WHITE)","NOT OBLIGATORY","NOT OBLIGATORY","SMALL CABLE TIES (WHITE)",null,"PACKETS",null,"To Order",{"v":20,"d":"R 20.00"},{"$f":"K61*B61","v":{"v":20,"d":"R 20.00"}},"N"]
[null,"CABLES"]
[22,1000,"4 core 2,5mm","Aberdare","Various","CABLE,ELECT:BVX4DCV 1,0KV 4C;CU;2.5 MM2","Yes","Order via stores",400646,"To Order",{"v":25,"d":"R 25.00"},{"$f":"K63*B63","v":{"v":25000,"d":"R 25,000.00"}},"Y","Cable length in metres (m)"]
[23,1000,"4 core 4mm","Aberdare","Various","CABLE,ELECT:BVX4ECV 1,0KV 4C;CU;4 MM2","Yes","Order via stores",404764,"To Order",{"v":34,"d":"R 34.00"},{"v":34000,"d":"R 34,000.00"},"Y","Cable length in metres (m)"]
[24,50,"2 core, 16mm","Aberdare","Various","CABLE,ELECT:BVX2HCV 1,0KV 2C;CU;16 MM2","Yes","Order via stores",14474,"To Order",{"v":45,"d":"R 45.00"},{"v":2250,"d":"R 2,250.00"},"Y","Cable length in metres (m)"]
[25,150,"4 core, 16mm","Aberdare","Various","CABLE,ELECT:BVX4HCV 1,0KV 4C;CU;16 MM2","Yes","Order via stores",404766,"To Order",{"v":60,"d":"R 60.00"},{"v":9000,"d":"R 9,000.00"},"Y","Cable length in metres (m)"]
[26,500,"12 core 2.5mm","Aberdare","Various","CABLE,ELECT:BVX12DCV 1,0KV 12C;CU;PVC","Yes","Order via stores",404761,"To Order",{"v":60,"d":"R 60.00"},{"v":30000,"d":"R 30,000.00"},"Y","Cable length in metres (m)"]
[27,1000,"19 core 2.5mm","Aberdare","Various","CABLE,ELECT:BVX19DCV 1.0KV 19C;CU;PVC","Yes","Order via stores",404118,"To Order",{"v":80,"d":"R 80.00"},{"v":80000,"d":"R 80,000.00"},"Y","Cable length in metres (m)"]
[28,30,"10 Pair 0.5mm","Aberdare","Various","CABLE,TEL TPH10AV 10PR 0.5mmDIA    D9161            (Armored Cable)","Yes","Order via stores",404123,"To Order",{"v":30,"d":"R 30.00"},{"v":900,"d":"R 900.00"},"Y","Cable length in metres (m)"]
[29,30,"2 Pair 0.5mm","Aberdare","Various","CABLE,TEL TPH2AV 2PR 0.5mm DIA     D9161          (Armored Cable)","Yes","Order via stores",403126,"To Order",{"v":25,"d":"R 25.00"},{"v":750,"d":"R 750.00"},"Y","Cable length in metres (m)"]
[30,30,"4 Pair 0.762mm","Jaycor International Pty Ltd","Jaycor International Pty Ltd","Belden # 3109 22AWG x 4PR Overall\nFoil + TC BRD screen, black UV resistant\nRS 485 cable.\nStock Code: BLDN3109A.  Armored Cable","Yes","See Ordering Schedule",588799,"To Order",{"v":90,"d":"R 90.00"},{"v":2700,"d":"R 2,700.00"},"Y","Cable length in metres (m)"]
[31,80,"No 1 Cable Gland","Pratley","Various","CABLE GLAND ADJUST No.1 D3070","Yes","Order via stores",168367,"To Order",{"v":20,"d":"R 20.00"},{"v":1600,"d":"R 1,600.00"},"Y"]
[32,50,"No 2 Cable Gland","Pratley","Various","CABLE GLAND ADJUST No.2 D3070","Yes","Order via stores",168279,"To Order",{"v":25,"d":"R 25.00"},{"v":1250,"d":"R 1,250.00"},"Y"]
[null,"AUXILLARIES"]
[33,1,"VRW20 Junction Box , with 8 circuit VT insert (Fitted) (Complete JB)\n304 stainless steel option.\n","Contrep c.c.","Contrep c.c.","VRW20 Junction Box, with 8 circuit VT insert (Fitted) (Complete JB) 304 stainless steel option\n",4600036004,"See Ordering Schedule",186950,"To Order",{"v":7100,"d":"R 7,100.00"},{"$f":"K75*B75","v":{"v":7100,"d":"R 7,100.00"}},"Y"]
[null,null,"CT Junction Box","Contrep c.c.","Contrep c.c.","VRW20 Junction box, 6 circuit CT insert. (fitted) (Complete JB) 304 stainless steel option\n",4600036004,"See Ordering Schedule",186961,"To Order",{"v":6000,"d":"R 6,000.00"},{"$f":"K76*B76","v":0},"Y"]
[34,1,"AC Distribution Board","SABI, Switchboard","SABI, Switchboard","AC Distribution Board","No","See drawing set 66 sheets 1-3","-","To Order",{"v":13000,"d":"R 13,000.00"},{"$f":"K77*B77","v":{"v":13000,"d":"R 13,000.00"}},"Y"]
[null,null,"Transformer Junction Box","Contrep","Contrep","Transformer junction box","No",null,null,"To Order",{"v":13000,"d":"R 13,000.00"},{"$f":"K78*B78","v":0},"Y"]
[null,"              LABELING"]
[35,null,"LABELS",null,null,"To be ordered from New Germany Test House. ",null,"SEE Schedule attached Label Requisition",{"$nulls":4},"N"]
[null,"FIBRE"]
[36,200,"12 core Heavy Duty Duct fibre cable","Various","Various","12 core Heavy Duty Duct fibre cable 50/125nm Multimode (non-metallic) ","Buy Out",null,null,"To Order",{"v":25,"d":"R 25.00"},{"$f":"K82*B82","v":{"v":5000,"d":"R 5,000.00"}},"Y","Cable length in metres (m)"]
[37,200,"Conduit for fiber run (High Density Poly Ethelene)","Various","Various","Optex duct (Direct burial duct – OD/ID: 32/26mm)","Buy Out","See Ordering Schedule",null,"To Order",{"v":30,"d":"R 30.00"},{"$f":"K83*B83","v":{"v":6000,"d":"R 6,000.00"}},"Y","Length in metres (m)"]
[38,1,"Fibre Joint Enclosure","Various","Various","Plastic/Metal dome fibre splice closure","Buy Out","See Ordering Schedule",null,"To Order",{"v":3500,"d":"R 3,500.00"},{"$f":"K84*B84","v":{"v":3500,"d":"R 3,500.00"}},"Y"]
[39,1,"Splice termination box","Telegartner","Telegartner","STX mounting rail distributor with 6xST Duplex, splice\ncassette, Pigtails, cable strain relief                                             [12x G50/125 OM2, ST]","Buy Out","See Ordering Schedule",null,"To Order",{"v":1000,"d":"R 1,000.00"},{"$f":"K85*B85","v":{"v":1000,"d":"R 1,000.00"}},"Y"]
{"$rows_empty":9}
[{"$nulls":11},{"$f":"SUM(L22:L31,L38:L39,L42,L46:L47,L49:L57,L59:L61,L63:L73,L75:L78,L82:L85)","v":{"v":364236,"d":"R 364,236.00"}}]

{"sheet":"PIC","index":10,"n_rows":14,"n_cols":7,"rows_kept":14,"hidden":true,"merged":[[5,6,7,6]]}
[]
[]
[null,null,"CRA Cost ","DRA Cost","Variance ","% Variance","Explanation"]
[null,"Engineering Cost",{"v":296109.84,"d":"R 296,109.84"},{"$f":"'Cost Summary'!E10","v":{"v":307274.6,"d":"R 307,274.60"}},{"$f":"C4-D4","v":{"v":-11164.759999999951,"d":"R -11,164.76"}},{"$f":"(1-(D4/C4))","v":{"v":-0.037704792248713925,"d":"-3.77%"}},"The Engineering Cost was under estimated at CRA.                       Primary Plant costing was estimated too low.                     "]
[null,"Material",{"v":1479825.99,"d":"R 1,479,825.99"},{"$f":"SUM('Cost Summary'!E6:E7)","v":{"v":1655654,"d":"R 1,655,654.00"}},{"v":-175828.01,"d":"R -175,828.01"},{"v":-0.11881667925024075,"d":"-11.88%"},"The Primary Plant Material was under estimated at CRA.                  New estimates were issued from Primary Plant Dept at DRA."]
[null,"Internal Contracts",{"v":356178.15,"d":"R 356,178.15"},{"$f":"'Cost Summary'!E16","v":{"v":65000,"d":"R 65,000.00"}},{"v":291178.15,"d":"R 291,178.15"},{"v":0.8175070537033223,"d":"81.75%"},"Internal Contracts, External Contracts, and Commissioning was under estimated at CRA.  No External Contracts for this project, Commissioning has now formed part of Internal Contracts at DRA."]
[null,"External Contracts",{"v":689377.06,"d":"R 689,377.06"},{"$f":"'Cost Summary'!E28","v":0},{"v":689377.06,"d":"R 689,377.06"},{"v":1,"d":"100.00%"}]
[null,"Commissioning",{"v":34468.85,"d":"R 34,468.85"},0,{"v":34468.85,"d":"R 34,468.85"},{"v":1,"d":"100.00%"}]
[null,"Overheads",{"v":314155.59,"d":"R 314,155.59"},{"$f":"'Cost Summary'!E36","v":{"v":372396.26,"d":"R 372,396.26"}},{"v":-58240.669999999984,"d":"R -58,240.67"},{"v":-0.18538797924939043,"d":"-18.54%"},"Overheads increased at DRA due to increase in total project cost."]
[null,"IDC",{"v":139944.75,"d":"R 139,944.75"},{"$f":"'Cost Summary'!E38","v":0},{"v":139944.75,"d":"R 139,944.75"},{"v":1,"d":"100.00%"},"IDC is calculated over 13 months at DRA vs 9 months at CRA.                                                                        Also increased due to escalated total project cost."]
[null,"Total Project Cost",{"$f":"SUM(C4:C10)","v":{"v":3310060.23,"d":"R 3,310,060.23"}},{"$f":"SUM(D4:D10)","v":{"v":2400324.8600000003,"d":"R 2,400,324.86"}},{"v":909735.3699999996,"d":"R 909,735.37"},{"v":0.27483952157571456,"d":"27.48%"}]
[]
[]
[null,null,{"$f":"SUM(C6:C8)","v":{"v":1080024.06,"d":"R 1,080,024.06"}}]