{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Traditional Lights BoQ"],"not_rendered":{"external_links":22,"defined_names":766},"read":"whole","date_system":"1900"}

{"sheet":"Traditional Lights BoQ","index":0,"n_rows":183,"n_cols":8,"rows_kept":183,"merged":[[182,1,183,1],[182,2,183,2],[182,3,183,3],[182,4,183,4],[182,5,183,5],[182,6,183,6],[182,7,183,7]]}
[]
[null,null," ",{"$nulls":4},"2026-07-24"]
[null,"PROJECT: REPLACEMENT OF TRADITIONAL LIGHTS AT KUSILE POWER STATION FOR A PERIOD OF NINE (9) MONTHS REV. 2"]
[]
[null,"ITEM NO.","DESCRIPTION","UNIT","NO. OFF","QTY","RATE","AMOUNT"]
[]
[null,null,"ITEM 1"]
[null,1,"PRELIMINARIES AND GENERAL"]
[]
[null,"1.1.1","Site Establishment & Facilities"]
[null,"1.1.1.1","Site Establishment for: Delivery of Office Converted Container Insulated, with Air-Con (L-9m; W-3m)","Once Off",1,1]
[null,"1.1.1.2","Site Establishment for: Delivery of Kitchen Converted Container Fitted with Single Bowl Sink with a Work Top, Fitted with Undercounter Cupboard L-12m; W-3m","Once Off",1,4]
[null,"1.1.1.3","Site Establishment for: Delivery of Storage Container, Enclosed with No Windows L-12m; W-2.5m","Once Off",1,3]
[null,"1.1.1.4","Site Establishment for: Delivery of Split Male and Female Ablution L-9m; W-3m","Once Off",1,1]
[null,"1.1.1.5","Supply and connection of power supply to Containers/Parkhomes","m",1,100]
[null,"1.1.1.6","Supply and connection of temporary water supply inlcuding, piping, pump, tap and storage tank (10000Lt water tank, food grade LLDPE plastics) adjacent contractor camp","Once Off",1,1]
[null,"1.1.1.7","Supply and connection of temporary waste water system, including, piping and plastic under-ground septic tank (12500 litres) typical for 1 to 55 people use","Once Off",1,2]
[null,"1.1.1.8","Supply and Installation of Site Fencing (1.8m High Diamond Mesh wire, 40 Steel Poles, 2 way double swing gate)","m",1,200]
[null,"1.1.1.9","Site Establishment for: Delivery of Cherry Picker 24m (2 Off)","Once Off",1,2]
[null,"1.1.1.10","Site Establishment for: Delivery of Cherry Picker 42m (1 Off)","Once Off",1,1]
[]
[null,"1.1.2","Site Clearance at Contractors Camp"]
[null,"1.1.2.1","Site Establishment for: Delivery of TLB - 4 X 4 Backhoe Loader (1 Off)","Once Off",1,1]
[null,"1.1.2.2","Site De-Establishment for: Collection of TLB - 4 X 4 Backhoe Loader (1 Off)","Once Off",1,1]
[null,"1.1.2.3","TLB - 4 X 4 Backhoe Loader","Per Day",1,1]
[]
[null,"1.1.3","Site De-establishment "]
[null,"1.1.3.1","Site De-establishment for: Collection of Office Converted Container Insulated, with Air-Con (L-9m; W-3m)","Once Off",1,1]
[null,"1.1.3.2","Site De-establishment for: Collection of Kitchen Converted Container Fitted with Single Bowl Sink with a Work Top, Fitted with Undercounter Cupboard L-12m; W-3m","Once Off",1,4]
[null,"1.1.3.3","Site De-establishment for: Collection of Storage Container, Enclosed with No Windows L-12m; W-2.5m","Once Off",1,3]
[null,"1.1.3.4","Site De-establishment for: Collection of Split Male and Female Ablution L-9m; W-3m","Once Off",1,1]
[null,"1.1.3.5","Disconnection and Collection of power supply to Containers/Parkhomes","m",1,100]
[null,"1.1.3.6","Collect and disconnection of temporary water supply inlcuding, piping, tap and storage tank (10000Lt water tank, food grade LLDPE plastics) adjacent contractor camp","Once Off",1,1]
[null,"1.1.3.7","Collect and disconnection of temporary waste water system, including, piping and plastic under-ground septic tank (12500 litres) typical for 1 to 55 people use","Once Off",1,2]
[null,"1.1.3.8","Removal and Collection of Site Fencing (1.8m High Diamond Mesh wire, 40 Steel Poles, 2 way double swing gate)","m",1,200]
[null,"1.1.2.2","Site De-Establishment for: Collection of Cherry Picker 24m (2 Off)","Once Off",1,2]
[null,"1.1.2.3","Site De-Establishment for: Collection of Cherry Picker 42m (1 Off)","Once Off",1,1]
[]
[null,1.2,"Health and Safety Complaince"]
[]
[null,"1.2.1","Personal Protective Equipment"]
[]
[null,"1.2.1.1","Overall Trouser","Per Person",2,120]
[null,"1.2.1.2","Overall Jacket","Per Person",2,120]
[null,"1.2.1.3","Arc Flash Jacket ","Per Person",2,101]
[null,"1.2.1.4","Arc Flash Trouser ","Per Person",2,101]
[null,"1.2.1.5","Under Garment for Arc Flash ","Per Person",2,101]
[null,"1.2.1.6","Safety Boots ","Per Person",2,120]
[null,"1.2.1.7","Hardhat ","Per Person",2,120]
[null,"1.2.1.8","Reflector Vest ","Per Person",2,120]
[null,"1.2.1.9","Mask (Box of 20)","Box",{"$f":"ROUNDUP((365*0.9)/(20),0.5)","v":17},120]
[null,"1.2.1.10","Safety Gloves ","Yearly",{"$f":"2*9","v":18},120]
[null,"1.2.1.11","Safety Glasses","Yearly",{"$f":"1*9","v":9},120]
[null,"1.2.1.12","Ear Protection ","Yearly",{"$f":"2*9","v":18},120]
[null,"1.2.1.13","Dust Overralls ","Yearly",{"$f":"4*9","v":36},101]
[]
[null,"1.2.2","Medicals, Security and Safety Complaince"]
[null,"1.2.2.1","Safety file","Once Off",1,1]
[null,"1.2.2.2","Medicals - Entry","Per Person ",1,120]
[null,"1.2.2.3","Medicals - Exit","Per Person ",1,120]
[null,"1.2.2.4","Police Clearance Certification","Per Person ",1,120]
[]
[null,"1.2.3","Safety Trainings and Competency"]
[null,"1.2.3.1","Training (Working at heights) (Valid for 3 years) ","Per Person ",1,104]
[null,"1.2.3.2","Training (Confined Spaces) (Valid for 3 years) ","Per Person ",1,104]
[null,"1.2.3.3","First Aid (Valid for 3 years)","No",1,3]
[null,"1.2.3.4","Basic Fire Fighting (Valid for 2 years)","No",1,5]
[null,"1.2.3.5","OHS Act (Valid for 2 years)","No",1,5]
[null,"1.2.3.6","Legal Liability (Once Off) (2 Off)","No",1,5]
[null,"1.2.3.7","Supervisory Safety (Valid for 2 years) (2 Off)","No",1,5]
[null,"1.2.3.8","Planned Job Observation (Once Off)","No",1,5]
[null,"1.2.3.9","HIRA (Valid for 2 years))","No",1,6]
[null,"1.2.3.10","Incident Investigator (Valid for 2 years)","No",1,6]
[null,"1.2.3.11","Evacuation Warden (Valid for 2 years) ","No",1,5]
[]
[null,"1.2.4","Occupational Hygiene Surveys (All Areas)"]
[null,"1.2.4.1","Illumination for Office, Kitchen, Ablution and Storage Containers (valid for 2 years)","No",1,9]
[null,"1.2.4.2","Indoor Air Quality for Office container (valid for 2 years)","No",1,1]
[null,"1.2.4.3","Ergonomics (valid for 2 years)","No",1,1]
[null,"1.2.4.4","Personal Airborne Pollutant Sampling, (including Silica, welding fumes and non-ionizing radiation as part of Occupational Hyigiene Health Risk assessment) (Plant -All Units) (valid for 2 years)","No",1,1]
[]
[null,"1.2.5","Equipment"]
[null,"1.2.5.1","Fire Extingisher (9 Kg)","No",1,9]
[null,"1.2.5.2","Multi Gas Monitors (5 sensor- O2,H2S,CO,LEL,CO2)","No",1,5]
[]
[null,"1.2.6","Temporary Site Facilities"]
[null,"1.2.6.1","Office Converted Container Insulated, with Air-Con. L-9m; W-3m ","Per Month",1,9]
[null,"1.2.6.2","Kitchen Converted Container Fitted with Single Bowl Sink with a Work top, Fitted with Undercounter Cupboard L-12m; W-3m","Per Month",4,9]
[null,"1.2.6.3","Storage Container, Enclosed with No Windows L-12m; W-2.5m","Per Month",3,9]
[null,"1.2.6.4","Split Male and Female Ablution Container L-9m; W-3m","Per Month",2,9]
[]
[null,"1.2.7","Transport and Logistics"]
[null,"1.2.7.1","22 Seater (5 Off)","Per Month",5,9]
[null,"1.2.7.2","LDV Site Bakie 4 x 4 Double Cab (6 Off)","Per Month",6,9]
[null,"1.2.7.3","Cherry Picker - 24m","Per Month",2,8]
[null,"1.2.7.4","Cherry Picker - 42m","Per Month",1,1]
[]
[null,null,"Total Item 1 (Preliminaries and General) Carried to Final Summary"]
[]
[null,null,"ITEM 2"]
[null,2,"RESOURCES"]
[]
[null,2.1,"NORMAL TIME"]
[]
[null,"2.1.1","Master Installation Electrican - MIE (Min 3 Year of Experience) (1 Off)",{"$f":"D117","v":"Hours"},{"v":1,"d":"1.00"},{"$f":"[22]Calculations!G6","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.2","Site Manager (Min 1 Years of Experience) (1 Off) ","Hours",{"v":1,"d":"1.00"},{"$f":"[22]Calculations!G7","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.3","Supervisor (Min 1 Years of Experience) (4 Off) ","Hours",{"v":4,"d":"4.00"},{"$f":"[22]Calculations!G8","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.4","Electricians (Min 3 Year of Experience) (48 Off)",{"$f":"+D107","v":"Hours"},{"v":48,"d":"48.00"},{"$f":"[22]Calculations!G9","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.5","Safety Officer (Min 1 Year of Experience) (1 Off)",{"$f":"D108","v":"Hours"},{"v":1,"d":"1.00"},{"$f":"[22]Calculations!G10","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.6","Quality Officer (Min 2 Years of Experience) (1 Off)",{"$f":"D107","v":"Hours"},{"v":1,"d":"1.00"},{"$f":"[22]Calculations!G11","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.7","Semi-skilled (Min 1 Year of Experience) (48 Off)",{"$f":"D110","v":"Hours"},{"v":48,"d":"48.00"},{"$f":"[22]Calculations!G12","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.8","Storeman (Min 1 Year of Experience) (1 Off)",{"$f":"D111","v":"Hours"},{"v":1,"d":"1.00"},{"$f":"[22]Calculations!G13","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.9","Admin (Min 1 Year of Experience) (1 Off)","Hours",{"v":1,"d":"1.00"},{"$f":"[22]Calculations!G14","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.10","Cleaners (Min 1 Years of Experience) (2 Off)","Hours",{"v":2,"d":"2.00"},{"$f":"[22]Calculations!G15","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.11","SHE Rep (Min 2 Years of Experience) (4 Off)","Hours",{"v":4,"d":"4.00"},{"$f":"[22]Calculations!G16","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.12","Drivers (Min 1 Years of Experience) (5 Off)","Hours",{"v":5,"d":"5.00"},{"$f":"[22]Calculations!G17","v":{"v":1476,"d":"1476.00"}}]
[null,"2.1.13","Operator (Min 1 Years of Experience) (3 Off)","Hours",{"v":3,"d":"3.00"},{"$f":"[22]Calculations!G18","v":{"v":1476,"d":"1476.00"}}]
[]
[null,null,"Subtotal Item 2 (Resources) carried to Final Summary"]
[]
[null,null,"ITEM 3"]
[null,3,"TOOLS AND EQUIPMENT"]
[]
[null,"3.1.1","Electrical Toolbox (19 Piece including Muilti-Meter T85D and TP200)","Each",{"v":1,"d":"1.00"},{"v":48,"d":"48.00"}]
[null,"3.1.2","Cordless battery drill with extra battery -18V Brushless, 5.0Ah Li-ion batteries, charger, carry case, minimum 65Nm torque","Each",{"v":1,"d":"1.00"},{"v":24,"d":"24.00"}]
[null,"3.1.3","115mm Cordless Angle Grinders -18V Brushless, 115mm disc, 5.0Ah batteries","Each",{"v":1,"d":"1.00"},{"v":12,"d":"12.00"}]
[null,"3.1.4","1200w Hammer/Electric drills - 220V Rotary Hammer, SDS Plus, 1200W, drilling capacity 26–32mm concrete","Each",{"v":1,"d":"1.00"},{"v":6,"d":"6.00"}]
[null,"3.1.5","30m Complete Extensions Reel - Industrial rubber cable, 3-core 2.5mm², IP44, overload protection, 16A","Each",{"v":1,"d":"1.00"},{"v":12,"d":"12.00"}]
[null,"3.1.6","8 Step Fibre Glass Stepladders","Each",{"v":1,"d":"1.00"},{"v":12,"d":"12.00"}]
[null,"3.1.7","10 Step Fibre Glass Stepladders","Each",{"v":1,"d":"1.00"},{"v":8,"d":"8.00"}]
[null,"3.1.8","12 Step Fibre Glass Stepladders","Each",{"v":1,"d":"1.00"},{"v":2,"d":"2.00"}]
[null,"3.1.9","Fluke 177 Tester with calibration certificates","Each",{"v":1,"d":"1.00"},{"v":2,"d":"2.00"}]
[null,"3.1.10","Luminance testers with calibration certificates","Each",{"v":1,"d":"1.00"},{"v":2,"d":"2.00"}]
[]
[null,null,"Subtotal Item 3 (Tools and Equipment) carried to Final Summary"]
[]
[null,null,"ITEM 4"]
[null,4,"CONSUMABLES"]
[]
[null,4.1,"No. 00 Glands ","Each",{"v":1,"d":"1.00"},{"$f":"SUM(F151:F156)","v":{"v":22850,"d":"22850.00"}}]
[null,4.2,"Round knock out galv boxes with lid and screws","Each",{"v":1,"d":"1.00"},{"v":22850,"d":"22850.00"}]
[null,4.3,"Connector Blocks 2.5mm 3 Wire 3 Way","Each",{"v":1,"d":"1.00"},{"v":22850,"d":"22850.00"}]
[null,4.4,"M8 spring washers + 8M x 30mm Bolts and Nuts","Each",{"v":1,"d":"1.00"},{"v":22850,"d":"22850.00"}]
[null,4.5,"Drill bits, Cable ties, Q20 & General consumables","Each",{"v":1,"d":"1.00"},{"v":22850,"d":"22850.00"}]
[]
[null,null,"Subtotal Item 4 (Consumables) carried to Final Summary"]
[]
[null,null,"ITEM 5"]
[null,5,"REPLACEMENT LIGHTS"]
[]
[null,5.1,"70W LED Bulkhead (Mag44 retrofit panel and modules) Replacement for 100W HPS Bulkhead Light","Each",{"v":1,"d":"1.00"},{"v":12000,"d":"12000.00"}]
[null,5.2,"600 x 600mm LED Panel Light replacement for 2ft Fluorescent 24W Tubes","Each",{"v":1,"d":"1.00"},{"v":3600,"d":"3600.00"}]
[null,5.3,"150W LED High Bay replacement for 400W High Bay Light","Each",{"v":1,"d":"1.00"},{"v":600,"d":"600.00"}]
[null,5.4,"280W LED High Bay replacement for 600W High Bay Light","Each",{"v":1,"d":"1.00"},{"v":400,"d":"400.00"}]
[null,5.5,"5 - 9W LED Bulb replacement for 9W Energy Saving Bulbs","Each",{"v":1,"d":"1.00"},{"v":6000,"d":"6000.00"}]
[null,5.6,"18W LED Tube replacement for 5ft Fluorescent Tubes","Each",{"v":1,"d":"1.00"},{"v":250,"d":"250.00"}]
[]
[null,null,"Subtotal Item 5 (Replacement Lights) carried to Final Summary"]
[null,null,"ITEM 6"]
[null,null,"TESTING AND COMMISIONING SERVICES"]
[]
[null,6.1,"Testing of power on 230V systems and supply cable power and insulation resistance.","Sum",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[null,6.2,"Testing all installations to verify compliance with the illuminance requirements which are:\nWalkways: 100 lux\nBoiler equipment (valves, gauges, etc): 150 lux\nTurbine floor: 300 lux","Sum",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[null,6.3,"Commissioning of installed ligths","Sum",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[]
[null,null,"Subtotal Item 6 (Testing and Commissioning Services) carried to Final Summary"]
[]
[]
[null,null,"FINAL SUMMARY"]
[]
[null,"ITEM 1","PRELIMINARIES AND GENERAL"]
[]
[null,"ITEM 2","RESOURCES"]
[null," "]
[null,"ITEM 3","TOOLS AND EQUIPMENT"]
[]
[null,"ITEM 4","CONSUMABLES"]
[]
[null,"ITEM 5","REPLACEMENT LIGHTS"]
[]
[null,"ITEM 6","TESTING AND COMMISIONING SERVICES"]
[]
[null,null,"Final Summary Total"]