{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Summary","Bill 1 - P&G","Bill 2 - Civil Works","Bill 3 - SHS","Bill 4 - Earthing","Bill 5 - Telecoms","Bill 6 - Testing","Bill 7 - O&M","Bill 8- Enclosure"],"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[0,0,0,2],[17,2,17,4]]}
["SUMMARY OF BILL OF QUANTITIES - MASHAQIYA SOLAR PROJECT"]
[]
["Bill No.","Description","Amount"]
[1," Preliminary and General",{"$f":"'Bill 1 - P&G'!F45","v":0}]
[2," Civil Works",{"$f":"'Bill 2 - Civil Works'!F80","v":0}]
[3," Solar Home System Equipment and Installation",{"$f":"'Bill 3 - SHS'!F42","v":0}]
[4," Earthing and Lightning Protection",{"$f":"'Bill 4 - Earthing'!F13","v":0}]
[5," Telecommunications and Remote Monitoring",{"$f":"'Bill 5 - Telecoms'!F6","v":0}]
[6,"Testing, Commissioning, Acceptance and Handover",{"$f":"'Bill 6 - Testing'!F13","v":0}]
[7,"Operation and Maintenance Requirements",{"$f":"'Bill 7 - O&M'!F17","v":0}]
[8,"Outdoor Inverter and Battery Enclosure",{"$f":"'Bill 8- Enclosure'!F19","v":0}]
[]
[null,"SUB-TOTAL EXCLUDING VAT",{"$f":"SUM(C4:C10)","v":0}]
[null,"ADD VAT @ 15%",{"$f":"C13*15%","v":0}]
[null,"GRAND TOTAL INCLUDING VAT",{"$f":"SUM(C13:C14)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]

{"sheet":"Bill 1 - P&G","index":1,"n_rows":50,"n_cols":6,"rows_kept":50,"merged":[[0,0,0,5],[4,0,4,5],[6,0,6,5],[19,0,19,5],[23,0,23,5],[24,0,24,5],[26,0,26,5],[27,0,27,5],[35,0,35,5],[39,0,39,5],[41,0,41,5],[44,0,44,4],[47,2,47,4]]}
["BILL NO. 1 - PRELIMINARY AND GENERAL"]
[]
["Item No.","Description","Unit","Qty","Rate","Amount"]
[]
["Contractual Requirements"]
[null,"\"The sum shall cover the contractor's initial costs of providing sureties, insurance of the Works and plant, third party or public liability insurance and unemployment insurance to cover his compliance with the requirements of the Workmen's Compensation Act, 1941 (Act NO. 30 of 1941) and any other initial financing obligations of a preliminary and general nature, such as contributions to the CEITB.\"  ","Sum",1,null,{"$f":"IFERROR(D6*E6,\"\")","v":0}]
["Establishment of facilities on site:"]
[null,"a) The supply and complete installation of Diamond mesh fencing including fence posts at 1.8 meters high ","m",300,null,{"$f":"IFERROR(D8*E8,\"\")","v":0}]
[null,"b) The supply and complete installation of a Diamond mesh Lockable Gate including fence posts 1.8m high x 3.6m wide, including lock","No.",2,null,0]
[null,"c)The supply and complete installation of a temporary diamond mesh lockable pedestrian gate, 1m wide","No.",1,null,0]
[null,"d) Site office 6m x 3m with aircon","Sum",1,null,0]
[null,"e) Site Storage 6m x 3m","Sum",1,null,0]
[null,"f) Ablution facilities","Sum",1,null,0]
[null,"g)  Plant, tools & equipment","Sum",1,null,0]
[1.3,"Removal of all items indicated above upon completion of construction and making good and restoring of the Site to the satisfaction of the Project Manager.","Sum",1,null,0]
[1.4,"Provision of \"As Built\" drawings.","Sum",1,null,0]
[1.5,"Construction Name Board  - The Contractor shall supply, install and  maintain one project signboard bearing the name of the project, the name and logo of Eskom, and the Contractor.","Sum",1,null,0]
[1.6,"Provision of samples of materials to be used  (only materials supplied by contractor). (Provisional)","Sum",1,null,0]
[1.7,"Provision for the compilation of the Construction Programme, updated on a fortnight basis and Quality Assurance Programme for the works.","Sum",1,null,0]
["Occupational Health & Safety Requirements"]
[2.2,"Provision of personal protective equipment and clothing for all the contractor's staff, including sub-contractors.","Sum",1,null,{"$f":"IFERROR(D21*E21,\"\")","v":0}]
[2.3,"Provision of safety measures, e.g.. Fall arrest systems, shoring for safety purposes etc.","Sum",1,null,{"$f":"IFERROR(D22*E22,\"\")","v":0}]
[2.4,"Compliance with OH&S Act & Construction Regulations, for other provisions not accounted for elsewhere","Sum",1,null,{"$f":"IFERROR(D23*E23,\"\")","v":0}]
["Compliance with the Requirements for the Expanded Public Works Programme"]
["Note: The reports are to be submitted with the contractors monthly invoice."]
[3.1,"Compliance with the Requirements for the Expanded Public Works Programme (incl. monthly reports).","Sum",1,null,{"$f":"IFERROR(D26*E26,\"\")","v":0}]
["Time Related Items (To maintain site for the duration of the project)"]
["Operate and Maintain Facilities on Site:"]
[null,"a)Site office 6m x 3m with aircon","Month",3.5,null,{"$f":"IFERROR(D29*E29,\"\")","v":0}]
[null,"b)  Site Storage 6m x 3m","Month",3.5,null,0]
[null,"c)  Staff living accommodation","Month",3.5,null,0]
[null,"b)  Ablution facilities","Month",3.5,null,0]
[null,"c)  Plant, tools & equipment","Month",3.5,null,0]
[null,"d)  Temporary water supply","Month",3.5,null,0]
[null,"e)  Temporary electric power supply","Month",3.5,null,0]
["Labour: The Contractor need to submit Weekly Time Sheets for all hourly compensation claims and a Daily attendance register "]
[4.2,"Contractor shall provide a competent SACPCMP registered Construction Manager for the management and the supervision of the whole construction works on a full-time basis","Month",3.5,null,{"$f":"IFERROR(D37*E37,\"\")","v":0}]
[4.3,"Community Liaison Officer conversant in Zulu and local cultural norms","Month",3.5,null,{"$f":"IFERROR(D38*E38,\"\")","v":0}]
[4.4,"Storeman \n(Storeman is required to reconcile and quantify All material on site including Eskom supplied material using the correct material return to stores forms. The Storeman shall adhere to the implementation and maintenance plan for Materials Management System for the duration of the contract).","Month",3.5,null,{"$f":"IFERROR(D39*E39,\"\")","v":0}]
["Safety Officer"]
[4.5,"Contractor shall provide a competent SACPCMP registered Safety Officer to ensure the safety of all individuals on site. The Safety Officer is to ensure all construction and safety regulations are adhered to on site. ","Month",3.5,null,{"$f":"IFERROR(D41*E41,\"\")","v":0}]
["Security"]
[4.6,"Contractor shall provide security guard/s to ensure the site including offices, storage sheds and all Eskom material are protected from theft or any damage. The Contractor needs to ensure that the above mentioned is guarded 24hrs a day.","Month",3.5,null,{"$f":"IFERROR(D43*E43,\"\")","v":0}]
[]
["TOTAL (BILL 1) CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(F5:F44)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]

{"sheet":"Bill 2 - Civil Works","index":2,"n_rows":85,"n_cols":6,"rows_kept":85,"merged":[[0,0,0,5],[3,0,3,5],[10,0,10,5],[14,0,14,5],[16,0,16,5],[18,0,18,5],[21,0,21,5],[22,0,22,5],[29,0,29,5],[42,0,42,5],[55,0,55,5],[59,0,59,5],[66,0,66,5],[70,0,70,5],[73,0,73,5],[75,0,75,5],[79,0,79,4],[82,2,82,4]]}
["BILL 2: CIVIL WORKS"]
[]
["Item No.","Description","Unit","Qty","Rate","Amount"]
["Site clearance and earthworks"]
[2.01,"Clear and grub the work areas for Solar Home System installations, access and working space, including removal of grass, shrubs, minor vegetation, roots, loose surface material and unsuitable organic matter; cart away or dispose of arisings as directed and leave the areas ready for setting out, excavation and construction. Measured net over the areas identified for the SHS installations.","m²",{"v":4620,"d":"4620.00"},null,{"$f":"IFERROR(D5*E5,\"\")","v":0}]
[2.02,"Remove topsoil to a nominal depth of 150 mm, keep separate from unsuitable material, stockpile where practical for re-use in reinstatement or cart to spoil as instructed; include trimming, loading, hauling within the site, shaping stockpiles and maintaining stockpiles so that the material remains suitable for rehabilitation.","m³",12.96,null,0]
[2.03,"Survey, set out and verify the position, levels, orientation and footprint of each complete SHS installation, including the PV carport structure, equipment enclosure, earthing electrodes, earth conductors and any associated civil works; include pegging, checking against drawings, recording coordinates and providing as-built settingo out information. Ensure all PV panels are installed North-facing and located such that shading from trees, buildings, structures, terrain features or other obstructions is avoided.","No",{"v":60,"d":"60.00"},null,0]
[2.04,"Excavate in all materials and spoil or dispose of surplus material from general bulk earthworks, working platforms, slope trimming and levelling required for the SHS positions; include loading, hauling, temporary stockpiling, trimming, keeping excavations free of water, maintaining safe working faces, and shaping the formation to receive compacted layers or foundations.","m³",{"v":1479,"d":"1479.00"},null,0]
[2.05,"Compact selected in-situ or backfilled material to a minimum of 93% Mod AASHTO maximum dry density at optimum moisture content, including watering, drying, scarifying, testing support and reworking where necessary until the specified density and finish are achieved.","m³",{"v":259.2,"d":"259.20"},null,0]
[2.06,"Supply, haul, place, water and compact approved G8 selected fill material in layers not exceeding 150 mm loose thickness, including all plant, labour, testing, trimming, shaping and compaction to a minimum of 93% Modified AASHTO density, complete in accordance with the Specifications, Drawings and Engineer's requirements. The rate shall include for loading, transport, spreading, moisture conditioning, compaction, proof rolling, removal of unsuitable material where required, and all associated quality control testing. Measured as compacted volume in place.                                                                                            Note:Final quantities shall be determined from actual site conditions and measured in place and  material to be approved by the Engineer prior to use.","m³",{"v":140,"d":"140.00"},null,0]
["Concrete and reinforcement"]
[2.07,"Provide smooth formwork to exposed faces of concrete foundations, equipment plinths and support bases, including cutting, fixing, bracing, striking, cleaning, release agents and all labour and material necessary to obtain true lines, levels and faces suitable for the finished installation.","m²",{"v":1080,"d":"1080.00"},null,{"$f":"IFERROR(D12*E12,\"\")","v":0}]
[2.08,"Supply, cut, bend, fix and support mild steel reinforcement bars in accordance with the drawings and Engineer’s instructions, including tying wire, spacers, chairs, hooks, laps, bends, wastage, placing and maintaining correct cover during concrete placement.","kg",{"v":15600,"d":"15600.00"},null,{"$f":"IFERROR(D13*E13,\"\")","v":0}]
[2.09,"Place blinding concrete under foundations and excavated bases, Class 15/19 concrete, nominal 25 mm thickness or as detailed, including supply, placing, levelling, curing and surface preparation to receive reinforcement and structural concrete.","m³",{"v":10.8,"d":"10.80"},null,{"$f":"IFERROR(D14*E14,\"\")","v":0}]
["Foundations Concrete - SHS Pad Foundations and Concrete Testing"]
[{"v":2.1,"d":"2.10"},"G46 item 24) SHS Pad Foundations - Option A: ready-mix concrete to SHS pad foundations as scheduled in the Civil BOQ.","m³",{"v":146,"d":"146.00"},null,{"$f":"IFERROR(D16*E16,\"\")","v":0}]
["Option B: Site-Mixed Concrete"]
[2.11,"G46 item 25) SHS Pad Foundations - Supply all cement, stone, sand, water, batching equipment, mixing, transport, placing, vibration, curing and testing of 25 MPa/19 mm site-mixed concrete.","m³",{"v":146,"d":"146.00"},null,{"$f":"IFERROR(D18*E18,\"\")","v":0}]
["Concrete Testing"]
[2.12,"Slump testing of concrete, including test records and reporting.","No",{"v":10,"d":"10.00"},null,{"$f":"IFERROR(D20*E20,\"\")","v":0}]
[2.13,"Casting, curing, transport and testing of concrete cube sets (6 cubes per set).","Set",{"v":8,"d":"8.00"},null,{"$f":"IFERROR(D21*E21,\"\")","v":0}]
["Structural steel for PV carport and enclosure support structures - SANS 1200H full breakdown"]
["H1 - Supply and Fabrication of Steelwork"]
[2.14," Supply and fabrication: COLUMN Section designation IPE 160 [Steel:350W], including shop preparation, cutting, drilling, marking, handling and delivery ready for subsequent corrosion protection and erection.","t",{"v":11.196,"d":"11.20"},null,{"$f":"IFERROR(D24*E24,\"\")","v":0}]
[2.15,"Supply and fabrication: RAFTER Section designation IPE-AA 140 [Steel:350W], including cutting, drilling, connection preparation and handling.","t",{"v":7.758,"d":"7.76"},null,0]
[2.16,"Supply and fabrication: PURLIN Section designation 100x75x20x2.0 [Steel:350W], including cutting to length, drilling, punching and handling.","t",{"v":8.094,"d":"8.09"},null,0]
[2.17," Supply and fabrication: DIAGONAL BRACING Section designation 100x75x20x2.0 [Steel:350W], including preparation, punching, drilling and handling.","t",7.17,null,0]
[2.18," Supply and fabrication: Column to Rafter 180x270x5 mm steel plates, including cutting, drilling, edge preparation and handling.","t",{"v":0.915624,"d":"0.92"},null,0]
[2.19,"Supply and fabrication: Rafter to Purlin 70x70x6 cleats, including cutting, drilling, edge preparation and handling.","t",{"v":0.32184,"d":"0.32"},null,0]
["H2 - Corrosion Protection"]
[{"v":2.2,"d":"2.20"},"Corrosion protection to COLUMN Section designation IPE 160 [Steel:350W].","t",{"v":11.196,"d":"11.20"},null,{"$f":"IFERROR(D31*E31,\"\")","v":0}]
[2.21,"Corrosion protection to RAFTER Section designation IPE-AA 140 [Steel:350W].","t",{"v":7.758,"d":"7.76"},null,0]
[2.22," Corrosion protection to PURLIN Section designation 100x75x20x2.0 [Steel:350W].","t",{"v":8.094,"d":"8.09"},null,0]
[2.23," Corrosion protection to DIAGONAL BRACING Section designation 100x75x20x2.0 [Steel:350W].","t",7.17,null,0]
[2.24,"Corrosion protection to Column to Rafter 180x270x5 mm steel plates.","t",{"v":0.915624,"d":"0.92"},null,0]
[2.25," Corrosion protection to Rafter to Purlin 70x70x6 cleats.","t",{"v":0.32184,"d":"0.32"},null,0]
[2.26,"Corrosion protection to Column to Rafter M12 nuts and bolts.","t",{"v":0.182,"d":"0.18"},null,0]
[2.27,"Corrosion protection to Rafter to Purlin M12 nuts and bolts.","t",{"v":0.137,"d":"0.14"},null,0]
[2.28," Corrosion protection to Top-Diagonal Bracing to Purlin M10 nuts and bolts.","t",{"v":0.033,"d":"0.03"},null,0]
[2.29,"Corrosion protection to Side-Diagonal Bracing to Column M10 nuts and bolts.","t",{"v":0.053,"d":"0.05"},null,0]
[{"v":2.3,"d":"2.30"}," Corrosion protection to Enclosure-Column to Horizontal Member M12 nuts and bolts.","t",{"v":0.046,"d":"0.05"},null,0]
[2.31," Corrosion protection to Column-Base Plate to Concrete Pad M12 nuts and bolts.","t",{"v":0.114,"d":"0.11"},null,0]
["H3 - Delivery"]
[2.32,"Delivery to site: COLUMN Section designation IPE 160 [Steel:350W].","t",{"v":11.196,"d":"11.20"},null,{"$f":"IFERROR(D44*E44,\"\")","v":0}]
[2.33,"Delivery to site: RAFTER Section designation IPE-AA 140 [Steel:350W].","t",{"v":7.758,"d":"7.76"},null,0]
[2.34,"Delivery to site: PURLIN Section designation 100x75x20x2.0 [Steel:350W].","t",{"v":8.094,"d":"8.09"},null,0]
[2.35," Delivery to site: DIAGONAL BRACING Section designation 100x75x20x2.0 [Steel:350W].","t",7.17,null,0]
[2.36,"Delivery to site: Column to Rafter 180x270x5 mm steel plates.","t",{"v":0.916,"d":"0.92"},null,0]
[2.37," Delivery to site: Rafter to Purlin 70x70x6 cleats.","t",{"v":0.459,"d":"0.46"},null,0]
[2.38," Delivery to site: Column to Rafter M12 nuts and bolts.","t",{"v":0.182,"d":"0.18"},null,0]
[2.39,"Delivery to site: Rafter to Purlin M12 nuts and bolts.","t",{"v":0.137,"d":"0.14"},null,0]
[{"v":2.4,"d":"2.40"},"Delivery to site: Top-Diagonal Bracing to Purlin M10 nuts and bolts.","t",{"v":0.033,"d":"0.03"},null,0]
[2.41," Delivery to site: Side-Diagonal Bracing to Column M10 nuts and bolts.","t",{"v":0.053,"d":"0.05"},null,0]
[2.42,"Delivery to site: Enclosure-Column to Horizontal Member M12 nuts and bolts.","t",{"v":0.046,"d":"0.05"},null,0]
[2.43,"Delivery to site: Column-Base Plate to Concrete Pad M12 nuts and bolts.","t",{"v":0.114,"d":"0.11"},null,0]
["H4 - Erection by Crane"]
[2.44,"Erection by crane: COLUMN Section designation IPE 160 [Steel:350W], including lifting, positioning, temporary bracing, alignment and making safe.","t",{"v":2.2392,"d":"2.24"},null,{"$f":"IFERROR(D57*E57,\"\")","v":0}]
[2.45," Erection by crane: RAFTER Section designation IPE-AA 140 [Steel:350W], including lifting, positioning, temporary bracing, alignment and making safe.","t",{"v":0.02586,"d":"0.03"},null,{"$f":"IFERROR(D58*E58,\"\")","v":0}]
[2.46," Erection by crane: PURLIN Section designation 100x75x20x2.0 [Steel:350W], including lifting, positioning, temporary bracing, alignment and making safe.","t",{"v":1.6188,"d":"1.62"},null,{"$f":"IFERROR(D59*E59,\"\")","v":0}]
["H5 - Erection by Hand"]
[2.47," Erection by hand: COLUMN Section designation IPE 160 [Steel:350W], including handling, positioning, temporary bracing, alignment and making safe.","t",{"v":8.9568,"d":"8.96"},null,{"$f":"IFERROR(D61*E61,\"\")","v":0}]
[2.48," Erection by hand: RAFTER Section designation IPE-AA 140 [Steel:350W], including handling, positioning, temporary bracing, alignment and making safe.","t",{"v":0.10344,"d":"0.10"},null,0]
[2.49,"Erection by hand: PURLIN Section designation 100x75x20x2.0 [Steel:350W], including handling, positioning, temporary bracing, alignment and making safe.","t",{"v":6.4752,"d":"6.48"},null,0]
[{"v":2.5,"d":"2.50"}," Erection by hand: DIAGONAL BRACING Section designation 100x75x20x2.0 [Steel:350W], including handling, positioning, temporary bracing, alignment and making safe.","t",{"v":5.736000000000001,"d":"5.74"},null,0]
[2.51,"Erection by hand: Column to Rafter 180x270x5 mm steel plates.","t",{"v":0.916,"d":"0.92"},null,0]
[2.52," Erection by hand: Rafter to Purlin 70x70x6 cleats.","t",{"v":0.459,"d":"0.46"},null,0]
["H6 - Erection of Connection Bolts [M12]"]
[2.53,"Erection of M12 connection bolts: Column to Rafter M12 nuts and bolts.","No",{"v":1920,"d":"1920.00"},null,{"$f":"IFERROR(D68*E68,\"\")","v":0}]
[2.54,"Erection of M12 connection bolts: Rafter to Purlin M12 nuts and bolts.","No",{"v":2880,"d":"2880.00"},null,{"$f":"IFERROR(D69*E69,\"\")","v":0}]
[2.55," Erection of M12 connection bolts: Enclosure-Column to Horizontal Member M12 nuts and bolts.","No",{"v":480,"d":"480.00"},null,{"$f":"IFERROR(D70*E70,\"\")","v":0}]
["H7 - Erection of Connection Bolts [M10]"]
[2.56,"Erection of M10 connection bolts: Top-Diagonal Bracing to Purlin M10 nuts and bolts.","No",{"v":600,"d":"600.00"},null,{"$f":"IFERROR(D72*E72,\"\")","v":0}]
[2.57," Erection of M10 connection bolts: Side-Diagonal Bracing to Column M10 nuts and bolts.","No",{"v":960,"d":"960.00"},null,{"$f":"IFERROR(D73*E73,\"\")","v":0}]
["H8 - Erection of Holding Down Bolts [M12]"]
[2.58," Erection of M12 holding down bolts: Column-Base Plate to Concrete Pad M12 nuts and bolts.","No",{"v":1200,"d":"1200.00"},null,{"$f":"IFERROR(D75*E75,\"\")","v":0}]
["H9 - Site Welding [6 mm]"]
[2.59,"Site welding [6 mm]: Column to Rafter connections, including preparation, welding, inspection, cleaning and touch-up of affected corrosion protection.","m",81.48,null,{"$f":"IFERROR(D77*E77,\"\")","v":0}]
[{"v":2.6,"d":"2.60"},"Site welding [6 mm]: Rafter to Purlin connections, including preparation, welding, inspection, cleaning and touch-up of affected corrosion protection.","m",{"v":16.8,"d":"16.80"},null,{"$f":"IFERROR(D78*E78,\"\")","v":0}]
[]
["TOTAL CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(F4:F79)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]

{"sheet":"Bill 3 - SHS","index":3,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[0,0,0,5],[3,0,3,5],[14,0,14,5],[29,0,29,5],[41,0,41,4],[44,2,44,4]]}
["BILL 3: SOLAR HOME SYSTEM EQUIPMENT AND INSTALLATION"]
[]
["Item No.","Description","Unit","Qty","Rate","Amount"]
["PV modules, support and DC system"]
[3.1,"Supply and install 600 W monocrystalline photovoltaic modules, complete with module positioning, alignment, final fixing on the approved support structure, handling, protection against damage, electrical interconnection readiness and all manufacturer-recommended installation requirements. Quantity is based on 9 modules per SHS for 60 installations.","No",540,null,{"$f":"IFERROR(D5*E5,\"\")","v":0}]
[3.2,"Supply and install PV mounting rails, clamps, brackets, end clamps, mid clamps, fixings, fasteners and all proprietary accessories required to secure the PV modules to the roof/ground/carport mounting arrangement; include alignment, stainless or corrosion-resistant fasteners, torqueing and making good of protective coatings.","Set",60,null,0]
[3.3,"Supply and install UV-resistant 4 mm² red and black PV DC single-core cable between PV modules, combiner/DC protection box and inverter equipment as applicable, including routing, clipping, containment interface, segregation, labelling and allowance for wastage and terminations measured elsewhere.","m",6000,null,0]
[3.4,"Supply, make off and install MC4 compatible male/female connector pairs for PV module strings, including crimping, polarity checks, weatherproofing, strain relief, testing and all small accessories necessary for complete PV string connections.","Pair",300,null,0]
[3.5,"Supply and install UV-resistant cable glands, flexible and rigid conduit, saddles, bushes, locknuts, sealing accessories and supports for DC and auxiliary cabling between equipment, including drilling of enclosures and maintaining the required IP rating after installation.","Set",60,null,0]
[3.6,"Supply and install UV-resistant cable ties, clips, saddles and small cable support accessories for PV DC and equipment cabling, including fixing to the mounting structure, neat routing and provision of strain relief at equipment terminations.","Set",60,null,0]
[3.7,"Supply and install weatherproof DC protection box, complete with enclosure, DIN rail, glands, internal wiring, labels, termination points and arrangement suitable for the PV string configuration; include fixing to the support or enclosure and connection readiness.","No",60,null,0]
[3.8,"Supply and install 20 A, 1000 V DC PV string fuse holders and fuse links within the DC protection arrangement, including labelling, termination, polarity verification and all accessories necessary for safe isolation and protection of PV strings.","No",120,null,0]
[3.9,"Supply and install 600 to 1000 V DC, 32 A DC isolator, complete with enclosure or integral mounting, operating handle, labelling, termination, polarity checks, and all accessories necessary for safe disconnection of PV DC circuits.","No",60,null,0]
[{"v":3.1,"d":"3.10"},"Supply and install Type II DC surge protection device suitable for 600 to 1000 V DC PV circuits, including base, cartridges, earthing connection to the common earth system, labelling and status indication where applicable.","No",60,null,0]
["Inverter, battery and enclosure services"]
[3.11,"Supply and install 5 kW, 48 V DC, 230 V AC off-grid hybrid inverter with MPPT functionality, complete with mounting bracket, fixing, DC and AC connection interfaces, communication interface, configuration, firmware setup where required and manufacturer-recommended installation accessories.","No",60,null,{"$f":"IFERROR(D16*E16,\"\")","v":0}]
[3.12,"Supply and install 48 V, 5.3 kWh lithium iron phosphate battery system, complete with battery management interface, mounting or rack arrangement, interconnecting hardware, protection during installation, configuration and integration with the hybrid inverter.","No",60,null,0]
[3.13,"Supply and install 160 A DC battery fuse and fuse holder or approved protective device, including enclosure/interface, terminations, labelling and coordination with the battery isolator and inverter DC input.","No",60,null,0]
[3.14,"Supply and install 160 A DC battery isolator suitable for the battery system, including mounting, cable terminations, labelling and safe access for operation and maintenance.","No",60,null,0]
[3.15,"Supply and install 35 mm² copper red and black battery cabling between battery, isolator, fuse and inverter, including lugs, heat shrink, ferrules, routing, support, protection against abrasion, polarity checks and torqueing of terminations.","m",480,null,0]
[3.16,"Supply and install filtered battery cooling fan, complete with grille, filter, fixing, wiring, protection and testing. Contractor to determine the actual fan rating based on the enclosure size.","No",60,null,0]
[3.17,"Supply and install digital thermostat or battery cooling controller for automatic control of the battery ventilation system, including sensor placement, wiring, setting of operational parameters and functional testing.","No",60,null,0]
[3.18,"Supply and install DC extraction fan for inverter cooling, complete with fixing, grille, wiring, protection and testing. Contractor to determine the actual fan rating based on the enclosure size.","No",60,null,0]
[3.19,"Supply and install thermostatic fan controller for inverter ventilation, including sensor installation, wiring, setting of operating temperature range, testing and labelling.","No",60,null,0]
["3.19 a","Supply and install passive ventilation louvre assemblies complete with washable or replaceable filtration media, insect screens and weather protection; include fixings, weather seals and all accessories necessary for integration with the enclosure ventilation system.","Set",60,null,0]
[{"v":3.2,"d":"3.20"},"Automatic fire suppression system comprising self-activating fire suppression balls or approved equivalent, rated for Class A, B and C fire risks, complete with mounting brackets, fixing accessories and installation within the equipment enclosure (2 devices per enclosure).","No",120,null,{"$f":"IFERROR(D26*E26,\"\")","v":0}]
[3.21,"Hygrostat (humidity controller) complete with wiring, mounting and commissioning.","No",60,null,{"$f":"IFERROR(D27*E27,\"\")","v":0}]
[3.22,"Anti-condensation heater. Contractor to determine the actual heater rating based on the enclosure size.","No",60,null,{"$f":"IFERROR(D28*E28,\"\")","v":0}]
[3.23,"Internal 230 V AC socket outlet complete with wiring, mounting and labelling.","No",60,null,{"$f":"IFERROR(D29*E29,\"\")","v":0}]
["AC distribution and interface materials"]
[3.24,"Supply and install AC distribution board complete with enclosure, DIN rail, neutral and earth bars, internal wiring, labels, glands, fixing and all accessories necessary to distribute the inverter AC output to the connected installation.","No",60,null,{"$f":"IFERROR(D31*E31,\"\")","v":0}]
[3.25,"Supply and install 25 A double-pole AC circuit breaker, including mounting in the AC distribution board, wiring, termination, labelling and coordination with the inverter output and downstream circuits.","No",60,null,0]
[3.26,"Supply and install Type II, 230 V AC surge protection device, including base, cartridges, earth connection to the common earth busbar, indication, labelling and verification of correct connection.","No",60,null,0]
[3.27,"Supply and install 20 A double-pole AC circuit breaker, including mounting, wiring, termination, labelling and coordination with downstream circuits or protection requirements.","No",60,null,0]
[3.28,"Supply and install PV system safety labels, operating labels, warning notices, isolation labels, circuit identification labels and OHS notices to each SHS installation and associated equipment enclosures in accordance with applicable SANS and Eskom requirements.","Set",60,null,0]
[3.29,"Install Eskom supplied 1 kV, 6 mm² concentric copper service cable where instructed, including handling, stringing/routing, securing, terminations by others where applicable, protection and coordination with the meter and SHS interface.","m",3000,null,0]
[{"v":3.3,"d":"3.30"},"Install Eskom-supplied 5.0 m wooden pole, 80-100 mm top diameter, including receipt, handling, setting out, excavation, erection, plumbing, backfilling, compacting and making safe where required by the service arrangement.","No",60,null,0]
[3.31,"Install Eskom supplied pole-top split-meter box, two-way 50 A, including mounting to support, fixing, alignment, cable entry coordination, weatherproofing and readiness for meter installation.","No",60,null,0]
[3.32,"Install Eskom supplied smart DIN G3-PLC electricity service meter, including handling, mounting, connection interface, labelling and coordination with Eskom metering requirements. Final metering work shall be undertaken with the required authorised personnel where applicable.","No",60,null,0]
[3.33," Install Eskom supplied meter seals and security seals to metering and service equipment where instructed, including recording of seal numbers and replacement of damaged seals caused by the Contractor.","No",60,null,0]
[3.34," Install  Eskom supplied padlocks to metering or service equipment where instructed, including handing-over of keys, key numbering and recording in the completion documentation.","No",60,null,0]
["TOTAL CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(F4:F41)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]

{"sheet":"Bill 4 - Earthing","index":4,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,0,0,5],[3,0,3,5],[12,0,12,4],[15,2,15,4]]}
["BILL 4: EARTHING AND LIGHTNING PROTECTION"]
[]
["Item No.","Description","Unit","Qty","Rate","Amount"]
["Lightning protection and earth termination system"]
[4.1,"Supply and install a Class III lightning protection and equipotential bonding system comprising 1 m high aluminium air termination rods fixed at the PV carport structure edges, including brackets, clamps, fixings, corrosion-resistant fasteners, alignment, bonding to the natural down-conductor path, and verification of continuity. The rate shall further include equipotential bonding of the PV carport structure, equipment enclosure support structure, metallic enclosures, exposed conductive parts, and associated support steelwork to the common earthing system, including lugs, clamps, stainless steel or brass hardware, conductor tails, all necessary connections, and continuity testing, complete and ready for commissioning.","No",240,null,{"$f":"IFERROR(D5*E5,\"\")","v":0}]
[4.2,"Supply and install 16 mm diameter × 1.5 m long copper-coated steel earth rods, driven to the required depth at locations shown on the drawings or as directed, including couplings where required, protection of rod tops, connection preparation, and testing support. The rate shall further include all exothermic welded connections between round copper conductors and copper-coated earth rods, including provision of moulds, weld charges, joint preparation, cleaning, inspection, testing support, corrosion protection, and completion of the earthing system ready for commissioning.","No",120,null,0]
[4.3,"Supply and install 10 mm diameter round copper earth conductor at approximately 0.6 m below finished ground level to interconnect earth electrodes and bond the PV carport structure, equipment enclosure support structure, and all exposed metallic components to the common earthing network. The rate shall include excavation, laying, backfilling, protection, mechanical support, and all Silbralloy brazed copper-to-copper earthmat joints, including joint preparation, sample joint approval prior to production work, brazing materials, cleaning, inspection, corrosion protection, testing, and maintenance of records of completed joints.","kg",1500,null,0]
[4.4,"Supply and install 10 mm diameter round copper earth conductor at approximately 0.6 m below finished ground level to interconnect earth electrodes and provide equipotential bonding of the PV carport structure, equipment enclosure support structure, metallic enclosures, exposed conductive parts, and associated steelwork to the common earthing network. The rate shall include excavation, laying, backfilling, protection, mechanical support, lugs, clamps, stainless steel or brass hardware, conductor tails, and all connections to the earthing system, including Silbralloy brazed copper-to-copper earthmat joints and exothermic welded joints between round copper conductors and copper-coated earth rods. The rate shall further include joint preparation, sample joint approval prior to production work, provision of brazing materials, weld moulds and charges, cleaning, inspection, testing support, continuity verification, corrosion protection, maintenance of records of completed joints, and commissioning of the complete earthing and bonding system.","kg",600,null,0]
[4.5,"Carry out earth continuity testing of each SHS installation, including continuity between PV support steelwork, equipment enclosure, earth busbar, SPDs, inverter, battery equipment and main earthing system; include test instruments, records and submission of results.","No",60,null,0]
[4.6,"Carry out earth resistance testing of each SHS earthing system, including testing before backfilling where required, attendance to witness hold points, recording of readings, and retesting after corrective measures where applicable.","No",60,null,0]
[4.7,"Install additional earth electrodes and associated interconnecting conductor where required to achieve the specified earth resistance or accepted performance criteria after pilot or final testing. This item is provisional and shall be used only upon instruction of the Project Manager or Engineer.","Prov. Sum",1,null,0]
[]
["TOTAL CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(F4:F12)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]

{"sheet":"Bill 5 - Telecoms","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,0,0,5],[5,0,5,4],[8,2,8,4]]}
["BILL 5: TELECOMMUNICATIONS AND REMOTE MONITORING"]
[]
["Item No.","Description","Unit","Qty","Rate","Amount"]
[5.1,"Supply, install, configure, activate, test and commission complete GPRS communication and remote monitoring facilities for each Solar Home System (SHS), including eSIM-enabled communication device/modem, antenna (where required), SIM/eSIM activation, cabling, mounting accessories, communication setup and verification of network connectivity. The rate shall include all labour, materials, software configuration, commissioning, documentation for each SHS installation.","No",60,null,{"$f":"IFERROR(D4*E4,\"\")","v":0}]
[]
["TOTAL CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(F4:F5)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]

{"sheet":"Bill 6 - Testing","index":6,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,0,0,5],[12,0,12,4],[15,2,15,4]]}
["BILL 6: TESTING, COMMISSIONING, ACCEPTANCE AND HANDOVER"]
[]
["Item No.","Description","Unit","Qty","Rate","Amount"]
[6.1,"Install, test and commission one complete pilot Solar Home System before proceeding with the remaining installations, including civil, structural, PV, inverter, battery, earthing, lightning protection, telecommunications and monitoring checks; include all inspection records, measurements, functional tests and corrective actions required before acceptance of the pilot installation.","Sum",1,null,{"$f":"IFERROR(D4*E4,\"\")","v":0}]
[6.2,"Provide corrective measures and retesting for the pilot installation where the required performance criteria are not achieved, including additional testing, investigation, minor remedial work and updated records. Use only where instructed or accepted by the Engineer or Project Manager.","Prov. Sum",1,null,0]
[6.3,"Carry out preliminary cable testing to prove correct installation of DC, AC, battery, communication and associated cabling, including polarity checks, insulation resistance, continuity, integrity of terminations, labelling checks and submission of test records for each SHS installation.","No",60,null,0]
[6.4,"Final test and commission the complete SHS electrical equipment installation, including PV array checks, inverter configuration, battery integration, AC distribution, DC protection, SPDs, controls, cooling and operational function tests; include coordination with manufacturer, Eskom or Eskom-appointed contractor where specified.","No",60,null,0]
[6.5,"Verify reliable transmission of operational data from each SHS to the monitoring platform, including acceptance record for PV generation, battery state of charge, load consumption, alarms and device status.","No",60,null,0]
[6.6,"Compile and submit all relevant test results for materials, workmanship and commissioning, including electrical tests, earthing tests, lightning protection tests, communication tests, inspection checklists, hold-point approvals and corrective action close-out records.","Sum",1,null,0]
[6.7,"Provide Certificates of Compliance and statutory electrical certification for the completed electrical works covered by the contract, including inspection, testing, authorised sign-off and inclusion of certificates in the handover package.","No",60,null,0]
[6.8,"Demonstrate successful communication, operation and acceptance of each completed SHS installation to the designated Eskom representative or Engineer prior to completion, including live demonstration, system status review and acceptance record.","No",60,null,0]
[]
["TOTAL CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(F4:F12)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]

{"sheet":"Bill 7 - O&M","index":7,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,0,0,5],[16,0,16,4],[19,2,19,4]]}
["BILL 7: OPERATION AND MAINTENANCE REQUIREMENTS"]
[]
["Item No.","Description","Unit","Qty","Rate","Amount"]
[7.1,"Prepare and submit a preventative maintenance schedule and corrective maintenance plan for the installed SHS assets, including planned inspections, cleaning, battery checks, corrosion checks, monitoring arrangements, defect response and reporting responsibilities aligned to the defects liability period and Eskom requirements.","Sum",1,null,{"$f":"IFERROR(D4*E4,\"\")","v":0}]
[7.2,"Establish and maintain monitoring and fault reporting arrangements during the defects liability period, including call logging, escalation, tracking, reporting arrangements and communication channels for operational faults and alarms.","Sum",1,null,0]
[7.3,"Carry out quarterly scheduled inspections of the complete SHS installations, including visual inspection of PV modules, support structures, enclosures, inverter, battery, cabling, protection devices, labels, earthing, lightning protection, cooling systems and general condition; quantity based on 60 installations x 4 inspections.","No",240,null,0]
[7.4,"Carry out quarterly cleaning of relevant solar PV and enclosure components, including safe cleaning of PV module surfaces, ventilation grilles, filters and accessible enclosure components; include equipment, consumables, access and recording of completed cleaning activities.","No",240,null,0]
[7.5,"Carry out quarterly battery health checks and reporting, including review of battery condition, state of charge, alarms, temperature/ventilation status, terminations and manufacturer-recommended checks; submit records for each installation.","No",240,null,0]
[7.6,"Carry out quarterly corrosion inspections of support structures, enclosures, fixings, fasteners, electrical terminations, earthing connections and associated components, including condition reporting and recommendations for remedial action.","No",240,null,0]
[7.7,"Monitor system performance and alarms during the defects liability period, including regular review of communications, alarms, system status, abnormal performance and escalation of defects or failures for action.","Month",12,null,0]
[7.8,"Carry out monthly operational data download, backup and submission to Eskom Engineering, including data checks, file naming, secure storage, report preparation and confirmation of submission.","Month",12,null,0]
[7.9,"Prepare and submit quarterly maintenance reports, including inspection findings, cleaning records, battery health results, corrosion observations, faults, corrective actions, performance trends and recommendations.","Quarter",4,null,0]
[{"v":7.1,"d":"7.10"},"Prepare and submit a recommended spare parts schedule for major equipment, including PV modules, inverters, batteries, communication equipment, protection equipment and ancillary components, with suggested quantities and identification references.","Sum",1,null,0]
[7.11,"Supply initial critical spare holding where instructed by Eskom. This item is provisional and may be adjusted by the Quantity Surveyor or Project Manager based on final equipment selection and approved spare holding strategy.","Prov. Sum",1,null,0]
[7.12,"Carry out final defects liability inspection and prepare O&M close-out report, including final status of installations, outstanding defects, corrective actions completed, recommendations and handover confirmation.","Sum",1,null,0]
[]
["TOTAL CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(F4:F16)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]

{"sheet":"Bill 8- Enclosure","index":8,"n_rows":24,"n_cols":6,"rows_kept":24,"merged":[[0,0,0,5],[2,0,2,5],[18,0,18,4],[21,2,21,4]]}
["BILL 8: OUTDOOR INVERTER & BATTERY ENCLOSURE"]
[]
["The following items comprise complete outdoor IP65 inverter and battery enclosures measuring approximately 1650mm (L) × 1410mm (H) × 400mm (D), including all components and accessories required for a complete installation."]
[]
["Item No.","Description","Unit","Qty","Rate","Amount"]
[8.1,"IP65 enclosure cabinet complete with mounting plate, weather seals and installation hardware.","No",60,null,{"$f":"IFERROR(D6*E6,\"\")","v":0}]
[8.2,"Lockable enclosure door complete with 3-point locking mechanism, hinges and handles.","No",60,null,0]
[8.3,"Supply and install copper earth busbar within each equipment enclosure, complete with mounting insulators, fixing hardware, labels and sufficient termination points for inverter, battery, AC and DC SPD, enclosure, support structure and associated bonding conductors.","No",60,null,{"$f":"IFERROR(D8*E8,\"\")","v":0}]
[8.4,"Provide earthing and bonding connections for AC and DC surge protection devices to the common earthing system, including correctly sized conductors, short and direct routes, lugging, labelling, testing and verification of connection integrity.","No",60,null,{"$f":"IFERROR(D9*E9,\"\")","v":0}]
[8.5,"Weatherproof gland plate complete with cable glands, blanking plugs and sealing accessories.","Set",60,null,0]
[8.6,"Replaceable dust filter set.","Set",60,null,0]
[8.7,"Internal wiring trunking, cable ducts, terminals, ferrules and installation hardware.","Set",60,null,0]
[8.8,"Communication equipment mounting plate and support brackets.","Set",60,null,0]
[8.9,"External antenna mounting bracket complete with fixings and cable routing accessories.","No",60,null,0]
[{"v":8.1,"d":"8.10"},"External earth stud complete with protective cover, labels and fixing hardware.","No",60,null,0]
[8.11,"Site Acceptance Testing (SAT) of completed enclosure installation.","Lot",60,null,0]
[8.12,"As-built drawings, O&M manuals, datasheets, warranties and commissioning records.","Lot",60,null,0]
[]
["TOTAL CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(F6:F18)","v":0}]
[]
["QS:",null,"DATE:",{"$f":"TODAY()","v":"2026-09-04"}]
["End User:",null,"DATE:"]
["Design Engineer (Civil):",null,"DATE:"]
["Design Engineer (Electrical):",null,"DATE:"]