{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":181,"n_cols":8,"rows_kept":181,"merged":[[1,1,3,7],[4,1,5,1],[4,2,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[8,2,8,3],[12,2,12,3],[22,2,22,3],[59,1,59,3],[60,1,61,1],[60,2,61,3],[60,4,61,4],[60,5,61,5],[60,6,61,6],[60,7,61,7],[72,2,72,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[81,2,81,3],[82,2,82,3],[83,2,83,3],[85,2,85,3],[87,2,87,3],[88,2,88,3],[93,2,93,3],[101,1,102,1],[101,2,102,3],[101,4,102,4],[101,5,102,5],[101,6,102,6],[101,7,102,7],[130,2,130,3],[134,2,134,3],[159,1,160,1],[159,2,160,3],[159,4,160,4],[159,5,160,5],[159,6,160,6],[159,7,160,7]]}
[]
[null,"MARULA ZONE 23 SUBSTATION: Knobel,Eerstegoed,Zanput,Letsetile,Soekmekaar,Shayandima,Venulu, Loius Trichadt ,Malamulele,Barbrook, Hlanganani,Mulendani, Pietersburg, Pondrift, Rebolwa, Sanari, Silica ,Singo, Songloed, The Ranch, Thomo,Tshikwetla,Makonde\n"]
[]
[]
[null,"ITEM","DESCRIPTION",null,"UNIT","QUANTITY","RATE","AMOUNT"]
[]
[]
[null,null,"SECTION 1:  "]
[null,null,"CONTRACT ADMINISTRATION AND GENERAL REQUIREMENTS"]
[]
[null,1.1,"General"]
[]
[null,"1.1.1","Contract administration and general obligations, including Professional Indemnity and Public Liability Insurance  insurance, (R10 million cover)",null,"Lump sum",1]
[]
[null,"1.1.2","OHS Preparation and File",null,"Lump sum",1]
[]
[null,"1.1.3","Registration of Sub-contractors with Local Authority",null,"Lump sum",1]
[]
[null,"1.1.4","Performance Guarantees & General Obligations",null,"Lump sum",1]
[]
[null,1.2,"Contractor's establishment on site"]
[]
[null,"1.2.1","Fixed charges - Project Manager  days for duration of contract",null,"Lump sum",10]
[]
[null,"1.2.2","Time related charges (6 months)",null,"Lump sum",1]
[]
[null,"1.2.3","Provide and maintain a quality control system",null,"Lump sum",1]
[]
[null,1.3,"Setting out"]
[]
[null,"1.3.1","Detailed survey of installation sites ",null,"No",1]
[]
[null,"1.3.2","Equipment selection and positioning",null,"No",1]
[]
[null,"1.3.3","Obtain permision to mount equipment and positions",null,"No",1]
[]
[null,"1.3.4","Termination enclosure positions",null,"No",1]
[]
[null,"1.3.5","Cable and sleeve routes:  power and comms",null,"Lump sum",1]
[]
[null,{"v":1.4,"d":"1.40"},"Scope of supply approval"]
[]
[null,"1.4.1","Design review workshop",null,"hr",4]
[]
[null,"1.4.2","Sample submissions",null,"Lump sum",1]
[]
[null,"1.4.3","Demonstration of equipment (only aspects of concern)",null,"Lump sum",1]
[]
[null,"1.4.4","Pre-installation testing and evaluation",null,"Lump sum",1]
[]
[null,"1.4.5","Training obligations as specified",null,"Lump sum",1]
[]
[null,"1.4.6","System test and commission the installation",null,"hr",4]
[]
[null,"1.4.7","As-built drawings, instllation manuals & upkeep",null,"Lump sum",1]
[]
[null,"1.4.8","Termination diagrams including rack layouts amendmends & upkeep",null,"Lump sum",1]
[]
[null,"1.4.9","Cable schedules including patch panels amendmends & upkeep",null,"Lump sum",1]
[null,"SECTION 1 TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H12:H58)","v":0}]
[null,"ITEM","DESCRIPTION",null,"UNIT","QUANTITY","INSTALL","AMOUNT"]
[]
[]
[null,"2.1","SECTION 2:EQUIPMENT"]
[]
[null,"2.1.1","XV-IP Control Panel,IP,2 Way Voice,GPRS, 2 x I & 1 x O (Supply & Installed)",null,"No",115]
[null,"2.1.2","Outdoor Box for Control Panel",null,"No",115]
[null,"2.1.3","E-Guard Client Monitoring Solution",null,"No",23]
[null,"2.1.4","Power Supply 3,2A & 7,5AH Batt Deep Cycle (Supply & Installed)",null,"No",230]
[null,"2.1.5","Programming, Commissioning & Sundary Materials",null,"No",115]
[null,"2.1.6","External Antenna and Connection for 868Mhz panel Omni Direct",null,"No",115]
[null,"2.1.7","Pigtail for Antenna 30cm to fit in Panel KIT",null,"No",115]
[null,"2.1.8","Wall mount exstension Bracket Aluminum ",null,"No",1150]
[null,"2.1.9","Outdoor Camera Mounting Bracket  (Supply & Installed)",null,"No",1150]
[null,"2.1.10","Outdoor Stainless Steel powder coated Anti-Vandal bracket",null,"No",1150]
[null,"2.1.11","OMV210  Camera Outdoor PIR MotionViewer (Supply & Installed)",null,"No",1150]
[null,"2.1.12","Poles to mount HORNS",null,"No",230]
[null,"2.1.13","E-mail Videos from Security Viewer - Monthly",null,"No",1150]
[null,"2.1.14","BOSCH LBB 1990/00 Plena Voice Alarm Controller",null,"No",46]
[null,"2.1.15","TC-651M TOA REFLEX HORN SPEAKER",null,"No",230]
[null,"2.1.16","1.5MM Ripcord for Speakers (Supply & Installed)",null,"M",6900]
[null,"2.1.17","MP3 Voice Template to generate Audio Input for Amp",null,"No",46]
[null,"2.1.18","Stun Bomb",null,"No",46]
[null,"2.1.19","4U Rack Cabinet",null,"No",46]
[null,"2.1.20","Warning signs (Supply & Installed)",null,"No",575]
[null,"2.1.21","Sim Card, Data,SMS & Voice (Supply & Installed)",null,"No",115]
[null,"2.1.22","Annual Data 12 Months Contract (Supply)",null,"No",115]
[null,"2.1.23","Batt AA Cell Lithium (Supply & Installed)",null,"No",6900]
[null,"2.1.24","Outdoor Pepper Gas",null,"No",0]
[null,"2.1.25","Batt D Cell Alcaline (Supply & Installed)",null,"No",1150]
[null,"2.1.26","Traveling, Programming, Commissioning & Sundry materials",null,"No",23]
[null,"2.1.27","Monitoring Fee 24/7 offsite Control room per Months - Contract",null,"No",828]
[null,"2.1.28","SMS all siganals + Opening / Closing per Months - Contract",null,"No",828]
[null,"2.1.29","Full Maintenance and consumables (Supply Stun Bomb Consumable Maximum 1x Per month)",null,"No",828]
[]
[null,"2.2","Other:"]
[null,null,"Items to be listed that is required to provide a fully operational system "]
[null,null,"a.RX Receivers",null,"No",500]
[null,null,"b."]
[]
[null,"SECTION 2 TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H66:H99)","v":0}]
[null,"ITEM","DESCRIPTION",null,"UNIT","QUANTITY","INSTALL","AMOUNT"]
[]
[]
[null,3,"SECTION 3:ELECTRICAL "]
[]
[null,"3.1","Conduits\nFixed on any surface complete with draw wires including bending, threading, jointing, draw boxes, cover plates, couplings, bends, tees, spacer bar saddles, screws, etc. as specified."]
[null,"3.2","Conduit and Accessories"]
[]
[null,"3.2.1","25mm PVC",null,"m",10,{"v":12,"d":"R12.00"}]
[null,"3.2.2","32mm PVC",null,"m",12,{"v":12,"d":"R12.00"}]
[null,"3.2.3","25mm Galvanised steel",null,"m",35,{"v":15,"d":"R15.00"}]
[]
[null,"3.3","Conduit Boxes\nWall boxes and conduit round boxes, one or two or three or four way built-in brick and/or fixed on any surface including fixing to conduit with necessary locknuts, adaptors, bushes, cover plates, screws, etc. as specified."]
[null,"3.3.1","4x4 Junction Boxes (Albro)",null,"m",385,{"v":85,"d":"R85.00"}]
[null,"3.3.2","60mm Round box - 25mm galvanised steel",null,"m",80,{"v":25,"d":"R25.00"}]
[{"$nulls":5},""]
[null,"3.4","Flexible conduit and accessories\nSupply and install flexible conduit fixed onto conduit, conduit boxes, etc. including all fixing materials, adaptors, locknuts, etc. as specified.",null,null,""]
[null,"3.4.1","25mm Kopex - PVC",null,"m",55,{"v":20,"d":"R20.00"}]
[null,"3.5","Modifications to Existing Distribution Boards\nSupply and install of new circuit breakers complete with switcgears, wiring, connections, labels and including testing and commissioning",null,null,""]
[null,"3.5.1","10A SP, 6kA",4,"No",120,{"v":70,"d":"R70.00"}]
[]
[null,"3.6","New Distribution Boards\nManufacture, delivery, off-loading and installation of  surface mounted metal distribution boards complete with frames, sub-frames, base frame, chassis, faceplates, doors, busbars, all switchgear, meters, wiring, connections, labels, mounting of board including testing and commissioning as specified and as indicated on the single line diagram drawings. "]
[null,"3.6.1","DB-CAM1",null,"No",3500,{"v":250,"d":"R250.00"}]
[null,"3.6.2","DB-CAM2",null,"No",3500,{"v":250,"d":"R250.00"}]
[]
[null,"3.7","Excavations of trenches for sleeves\nAllowance should be made for excavations of trenches for cables, cable ducts, road crossings, jointing pits, manholes, etc. including setting out, safeguarding, bedding, backfilling, compaction, finishing and disposing of surplus material in accordance with SANS 2001-DP3, SANS 1200 DA, SANS 1200 LC and as specified in the standard specifications."]
[null,"3.7.1","Soft Material",5,"m³",null,{"v":1570,"d":"R1,570.00"}]
[null,"3.7.2","Intermediate Material",null,"m³",null,{"v":1800,"d":"R1,800.00"}]
[]
[null,"3.8","Manholes\nStackable modular polyethylene cable access boxes, complete with polymer concrete lids and frame"]
[null,"3.8.1","300x300 manhole, minimum of 600mm below ground level",null,"No",4500,{"v":300,"d":"R300.00"}]
[]
[]
[null,"3.9","Earthing and Bonding\nSupply, delivery, installation, testing, commissioning and handing over in working condition and maintenance during the guarantee period of a complete earthing installation in accordance with the relevant SANS standards and as specified, including all fixing materials, copper straps, lugs, and connections."]
[null,"3.9.1","Cabinets",1,"No",225,{"v":85,"d":"R85.00"}]
[null,"3.9.2","Gate Motors",1,"No",225,{"v":85,"d":"R85.00"}]
[]
[null,"3.10","Electrical Testing and Commissioning"]
[null,"3.10.1","Allow for inspection, testing and commissioning of the complete installation in this Bill, including provision of all test equipment. Tests shall be carried out in the presence of the Engineer who shall have been notified of the dates and approximate durations of the tests, sufficiently in advance as to allow attendance to such testing.",1,"Sum",null,{"v":2500,"d":"R2,500.00"}]
[null,"3.10.2","Allow for the provision of a Certificate of Compliance in terms of SANS 10142-1 specifications for each completed distribution board.",3,"No",null,{"v":1500,"d":"R1,500.00"}]
[]
[null,"3.11","Documentation and Training"]
[null,"3.11.1","As-built drawings of the electrical installation (3 Copies) Refer to  Specification",0,"Sum",null,{"v":2500,"d":"R2,500.00"}]
[null,"3.11.2","Maintenance and operating manuals of the complete electrical installation in soft and hard copy as specified (3 Copies) Refer to  Specification",0,"Sum",null,{"v":1000,"d":"R1,000.00"}]
[]
[null,"3.12","UPS"]
[null,"3.12.1","1kVA 230V Single Phase input, 230V Single Phase output, On-Line Full Conversion, UPS System with 15 minute battery backup time, auxiliary output relays, complete",null,"No",12000,{"v":800,"d":"R800.00"}]
[]
[null,"3.13","Builder's work"]
[null,"3.13.1","Drill through masonary walls, patch, make good and paint",null,"Sum"]
[null,"3.13.2","Repair existing tarmac, where road crossing sleeves are to be installed",1,"Sum",500,{"v":2500,"d":"R2,500.00"}]
[null,"3.13.3","Repair existing concrete, where road crossing sleeves are to be installed",null,"Sum",null,{"v":10000,"d":"R10,000.00"}]
[null,"3.13.4","Repair existing paving, where road crossing sleeves are to be installed",1,"Sum",null,{"v":1200,"d":"R1,200.00"}]
[]
[null,"3.14","Any other items  specified or required but not measured"]
[]
[]
[null,"SECTION 3 TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H124:H157)","v":0}]
[null,"ITEM","DESCRIPTION",null,"UNIT","QUANTITY","INSTALL","AMOUNT"]
[]
[]
[null,4,"SECTION 4:Miscellaneous"]
[]
[null,"4.1","O&M documentation and certificates "]
[null,"4.1.1","O+ M Technical documentation draft and final submission (2 sets hard copy and sets soft copy) as specified, Incl system setup on memory stick",null,"Sum",1]
[null,"4.1.2","As-built drawings (2 sets hard copy, set soft copy)",null,"Sum",1]
[null,"4.1.3","System Schematic Drawings  (2 sets hard copy, set soft copy)",null,"Sum",1]
[null,"4.1.4","Photo Report of Complete Installation",1,"Sum",1]
[]
[null,"4.2","Client training "]
[null,"4.2.1","End-user training session",4,"Hr",4]
[null,"4.2.2","End-user follow-up training session",4,"Hr",4]
[null,"4.3","Testing and Commissioning"]
[null,"4.3.1","Programming and Configuration of all Video Analytics",null,"Sum",1]
[null,"4.3.2","GUI Maps overlays of all buildings, areas and site for all subsystems, e.g. alarm icons, camera icons,  etc.",1,"Sum",1]
[null,"4.3.3","Compile Commissioning Procedure for approval by Engineer",1,"Sum",1]
[null,"4.3.5","Final inspection with Eskom Maintenance, tests and demonstration",null,"Sum",1]
[null,"4.4","Bush Clearance",1,"Sum",1]
[]
[null,"SECTION 4 TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H165:H179)","v":0}]