{"text_format":"3","workbook":"xlsx","n_sheets":19,"sheets":["Summary of Pricing","C1.2","C1.3","C1.4","C1.5","C1.6","C3.1","C3.2","C3.3","C4.2","C4.3","C5.2","C9.1","C11.1","C11.2","C11.7","C11.9","C20.1","Schedule B"],"not_rendered":{"defined_names":95},"read":"whole","date_system":"1900"}

{"sheet":"Summary of Pricing","index":0,"n_rows":153,"n_cols":5,"rows_kept":153,"merged":[[1,1,1,2],[3,1,3,2],[4,1,4,4],[6,1,6,2],[14,1,14,2],[20,1,20,2],[25,1,25,2],[32,1,32,2],[39,1,39,2],[43,1,43,2],[51,1,51,2],[62,1,62,2],[65,1,65,2],[69,1,69,2],[80,1,80,2],[110,1,110,2],[123,1,123,2],[126,1,126,2],[129,1,129,2],[132,1,132,2],[145,2,145,3],[148,2,148,3],[150,2,151,3],[153,2,153,3]]}
[]
[null,"C2.2.2 SUMMARY OF PRICING SCHEDULE - RWY TWY and GA works"]
[]
[null,4429]
[null,"RUNWAY AND TAXIWAY REHABILITATION AT CHIEF DAWID STUURMAN INTERNATIONAL AIRPORT (CDSIA) "]
[]
[null,"GENERAL"]
[null,"C1.2","GENERAL REQUIREMENTS AND PROVISIONS",{"$f":"'C1.2'!I39","v":{"v":558000,"d":"R558,000.00"}}]
[null,"C1.3","CONTRACTOR’S SITE ESTABLISHMENT AND GENERAL OBLIGATIONS",{"$f":"'C1.3'!I16","v":{"v":0,"d":"R0.00"}}]
[null,"C1.4","FACILITIES FOR THE ENGINEER",{"$f":"'C1.4'!I45","v":{"v":480000,"d":"R480,000.00"}}]
[null,"C1.5","ACCOMMODATION OF TRAFFIC",{"$f":"'C1.5'!I20","v":{"v":0,"d":"R0.00"}}]
[null,"C1.6","CLEARING AND GRUBBING",{"$f":"'C1.6'!I20","v":{"v":0,"d":"R0.00"}}]
[null,"C1.7","LOADING AND HAULING",{"v":0,"d":"R0.00"},{"$f":"SUM(D8:D13)","v":{"v":1038000,"d":"R1,038,000.00"}}]
[]
[null,"SERVICES"]
[null,"C2.1","GENERAL REQUIREMENTS AND TRENCHING FOR SERVICES",{"v":0,"d":"R0.00"}]
[null,"C2.2","DRY SERVICES",{"v":0,"d":"R0.00"}]
[null,"C2.3","WET SERVICES",{"v":0,"d":"R0.00"}]
[null,"C2.4","ENERGY AND OTHER SERVICES",{"v":0,"d":"R0.00"},{"$f":"SUM(D16:D19)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"DRAINAGE"]
[null,"C3.1","DRAINS",{"$f":"'C3.1'!I63","v":{"v":0,"d":"R0.00"}}]
[null,"C3.2","CULVERTS",{"$f":"'C3.2'!I156","v":{"v":0,"d":"R0.00"}}]
[null,"C3.3","CONCRETE KERBING AND CHANNELING, ASPHALT BERMS, CHUTES, DOWNPIPES, AS WELL AS CONCRETE, STONE PITCHED AND GABION LININGS FOR OPEN DRAINS",{"$f":"'C3.3'!I31","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"EARTHWORKS AND PAVEMENT LAYERS MATERIALS"]
[null,"C4.1","BORROW MATERIALS",{"v":0,"d":"R0.00"}]
[null,"C4.2","CUT MATERIALS",{"$f":"'C4.2'!I13","v":{"v":0,"d":"R0.00"}}]
[null,"C4.3","EXISTING ROAD MATERIALS",{"$f":"'C4.3'!I22","v":{"v":50000,"d":"R50,000.00"}}]
[null,"C4.4","COMMERCIAL MATERIALS",{"v":0,"d":"R0.00"}]
[null,"C4.5","ALTERNATIVE MATERIALS",{"v":0,"d":"R0.00"},{"$f":"SUM(D27:D31)","v":{"v":50000,"d":"R50,000.00"}}]
[]
[null,"EARTHWORKS AND PAVEMENT LAYERS CONSTRUCTION"]
[null,"C5.1","ROADBED",{"v":0,"d":"R0.00"}]
[null,"C5.2","FILL",{"$f":"'C5.2'!I14","v":{"v":0,"d":"R0.00"}}]
[null,"C5.3","ROAD PAVEMENT LAYERS",{"v":0,"d":"R0.00"}]
[null,"C5.4","STABILISATION",{"v":0,"d":"R0.00"}]
[null,"C5.5","RECONSTRUCTION OF PAVEMENT LAYERS",{"v":0,"d":"R0.00"},{"$f":"SUM(D34:D38)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"CONCRETE LAYERS"]
[null,"C6.1","PAVER LAID CONCRETE LAYERS",{"v":0,"d":"R0.00"}]
[null,"C6.2","SEGMENTAL BLOCK PAVING LAYERS",{"v":0,"d":"R0.00"},{"$f":"SUM(D41:D42)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"MAINTENANCE AND REPAIR CONCRETE LAYERS"]
[null,"C7.1","REPLACEMENT OF EXISTING JOINT SEALANT",{"v":0,"d":"R0.00"}]
[null,"C7.2","REPAIR TO CONCRETE PANELS AND CONCRETE ADJACENT TO UNCONTROLLED CRACKS AND EXISTING JOINTS",{"v":0,"d":"R0.00"}]
[null,"C7.3","REMOVAL AND REINSTATEMENT OF EXISTING CONCRETE LAYERS",{"v":0,"d":"R0.00"}]
[null,"C7.4","REINSTATEMENT OF SLAB SUPPORT BY GROUT INJECTION",{"v":0,"d":"R0.00"}]
[null,"C7.5","REINSTATEMENT OF RIDING QUALITY",{"v":0,"d":"R0.00"}]
[null,"C7.6","REINSTATEMENT OF SURFACE TEXTURE",{"v":0,"d":"R0.00"},{"$f":"SUM(D45:D50)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"PRETREATMENT AND REPAIR EXISTING LAYERS"]
[null,"C8.1","PRIME COAT",{"v":0,"d":"R0.00"}]
[null,"C8.2","COVER SPRAYS, FOG SPRAYS AND REJUVENATION SPRAYS",{"v":0,"d":"R0.00"}]
[null,"C8.3","TEXTURE TREATMENT",{"v":0,"d":"R0.00"}]
[null,"C8.4","RUT AND/OR DEPRESSION CORRECTION",{"v":0,"d":"R0.00"}]
[null,"C8.5","STANDARD CRACK SEALING",{"v":0,"d":"R0.00"}]
[null,"C8.6","GEOSYNTHETIC CRACK SEALING",{"v":0,"d":"R0.00"}]
[null,"C8.7","PLANING",{"v":0,"d":"R0.00"}]
[null,"C8.8","PATCHING AND EDGE BREAK REPAIR",{"v":0,"d":"R0.00"}]
[null,"C8.9","REPAIR OF SURFACE DEFECTS",{"v":0,"d":"R0.00"},{"$f":"SUM(D53:D61)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"ASPHALT LAYERS"]
[null,"C9.1","ASPHALT LAYERS",{"$f":"'C9.1'!I31","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(D64)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"SURFACE TREATMENTS"]
[null,"C10.1","GENERAL REQUIREMENTS FOR SURFACE TREATMENTS",{"v":0,"d":"R0.00"},{"$f":"SUM(D67)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"ANCILLIARY ROAD WORKS"]
[null,"C11.1","PITCHING, STONEWORK, CAST IN SITU CONCRETE FOR PROTECTION AGAINST EROSION",{"$f":"'C11.1'!I16","v":{"v":100000,"d":"R100,000.00"}}]
[null,"C11.2","NON-STRUCTURAL GABIONS",{"$f":"'C11.2'!I33","v":{"v":0,"d":"R0.00"}}]
[null,"C11.3","GUIDE BLOCKS AND KILOMETRE MARKERS",{"v":0,"d":"R0.00"}]
[null,"C11.4","ROAD RESTRAINT SYSTEMS",{"v":0,"d":"R0.00"}]
[null,"C11.5","FENCING",{"v":0,"d":"R0.00"}]
[null,"C11.6","ROAD SIGNS",{"v":0,"d":"R0.00"}]
[null,"C11.7","ROAD MARKINGS AND ROAD STUDS",{"$f":"'C11.7'!I29","v":{"v":0,"d":"R0.00"}}]
[null,"C11.8","LANDSCAPING AND PLANTING PLANTS",{"v":0,"d":"R0.00"}]
[null,"C11.9","FINISHING THE ROAD AND ROAD RESERVE AND TREATING OLD ROADS",{"$f":"'C11.9'!I7","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(D71:D79)","v":{"v":100000,"d":"R100,000.00"}}]
[]
[null,"GEOTECHNICAL"]
[null,"C12.1","PILING",{"v":0,"d":"R0.00"}]
[null,"C12.2","GROUND ANCHORS",{"v":0,"d":"R0.00"}]
[null,"C12.3","GROUND IMPROVEMENT",{"v":0,"d":"R0.00"}]
[null,"C12.4","LATERAL SUPPORT",{"v":0,"d":"R0.00"}]
[null,"C12.5","SHOTCRETE",{"v":0,"d":"R0.00"}]
[null,"C12.6","MECHANICALLY STABILISED EARTH WALLS AND GABIONS",{"v":0,"d":"R0.00"}]
[null,"C12.7","TRENCHLESS METHODS ",{"v":0,"d":"R0.00"}]
[null,"C12.8","GROUND DRAINAGE",{"v":0,"d":"R0.00"}]
[null,"C12.9","SLOPE PROTECTION MEASURES",{"v":0,"d":"R0.00"}]
[null,"C12.10","HARD EXCAVATION BY BLASTING",{"v":0,"d":"R0.00"}]
[null,"C12.11","GEOSYNTHETICS",{"v":0,"d":"R0.00"}]
[null,"C12.12","CONSTRUCTION DEWATERING",{"v":0,"d":"R0.00"},{"$f":"SUM(D82:D93)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"STRUCTURES"]
[null,"C13.1","FOUNDATIONS",{"v":0,"d":"R0.00"}]
[null,"C13.2","FALSEWORK, FORMWORK AND CONCRETE FINISH",{"v":0,"d":"R0.00"}]
[null,"C13.3","STEEL REINFORCEMENT",{"v":0,"d":"R0.00"}]
[null,"C13.4","CONCRETE",{"v":0,"d":"R0.00"}]
[null,"C13.5","PRESTRESSING",{"v":0,"d":"R0.00"}]
[null,"C13.6","BEARINGS",{"v":0,"d":"R0.00"}]
[null,"C13.7","JOINTS",{"v":0,"d":"R0.00"}]
[null,"C13.8","ANCILLARY STRUCTURAL ELEMENTS",{"v":0,"d":"R0.00"}]
[null,"C13.9","STRUCTURAL STEELWORK FOR MINOR STRUCTURES",{"v":0,"d":"R0.00"}]
[null,"C13.10","PAINTING OF MINOR STRUCTURES",{"v":0,"d":"R0.00"}]
[null,"C13.11","STRUCTURAL STEELWORK FOR MAJOR STRUCTURES",{"v":0,"d":"R0.00"}]
[null,"C13.12","STRUCTURAL STEEL PROTECTIVE TREATMENT OF MAJOR STRUCTURES",{"v":0,"d":"R0.00"}]
[null,"C13.13","INCREMENTAL LAUNCHING OF BRIDGE DECKS",{"v":0,"d":"R0.00"}]
[null,"C13.14","SPECIALIST STRUCTURES",{"v":0,"d":"R0.00"},{"$f":"SUM(D96:D109)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"REPAIR AND REHABILITATION STRUCTURES"]
[null,"C14.1","ACCESS FOR BRIDGE REHABILITATION",{"v":0,"d":"R0.00"}]
[null,"C14.2","CORROSION SURVEY METHODS AND TESTING OF NEAR SURFACE CONCRETE PROPERTIES",{"v":0,"d":"R0.00"}]
[null,"C14.3","DEMOLITION AND REMOVAL OF STRUCTURAL CONCRETE AND STEELWORK",{"v":0,"d":"R0.00"}]
[null,"C14.4","SURFACE AND STRUCTURAL REPAIR OF CONCRETE MEMBERS",{"v":0,"d":"R0.00"}]
[null,"C14.5","ANCHORING OF REINFORCEMENT, GROUTING AND CRACK INJECTION",{"v":0,"d":"R0.00"}]
[null,"C14.6","SPRAYED CONCRETE FOR STRUCTURES",{"v":0,"d":"R0.00"}]
[null,"C14.7","PROTECTIVE COATINGS AND TREATMENTS FOR CONCRETE",{"v":0,"d":"R0.00"}]
[null,"C14.8","EXTERNAL BONDING OF STEEL AND CARBON FIBRE",{"v":0,"d":"R0.00"}]
[null,"C14.9","REPAIR AND REPLACEMENT OF ANCILLARY STRUCTURAL ELEMENTS",{"v":0,"d":"R0.00"}]
[null,"C14.10","JACKING OF BRIDGE STRUCTURES",{"v":0,"d":"R0.00"}]
[null,"C14.11","REPAIR OF STEEL ELEMENTS",{"v":0,"d":"R0.00"},{"$f":"SUM(D112:D122)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"QUALITY ASSURANCE"]
[null,"C20.1","TESTING MATERIALS AND JUDGEMENT OF WORKMANSHIP",{"$f":"'C20.1'!I11","v":{"v":4900000,"d":"R4,900,000.00"}},{"$f":"SUM(D125)","v":{"v":4900000,"d":"R4,900,000.00"}}]
[]
[null,"SECTION D: STAKEHOLDER AND COMMUNITY LIAISON, AND TARGET LABOUR AND TARGETED ENTERPRISES UTILISATION AND DEVELOPMENT"]
[null,"D1010","TRAINING, COACHING, GUIDANCE, MENTORING AND ASSISTANCE",{"v":0,"d":"R0.00"},{"$f":"SUM(D128)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Main Works "]
[null,"A","Main Works (Civils)",{"$f":"SUM(D7:D129)","v":{"v":6088000,"d":"R6,088,000.00"}},{"$f":"+D131","v":{"v":6088000,"d":"R6,088,000.00"}}]
[]
[null,"Electrical Works "]
[null,"B","Electrical Works",{"$f":"'Schedule B'!I6","v":{"v":16284436.34,"d":"R16,284,436.34"}},{"$f":"SUM(D134)","v":{"v":16284436.34,"d":"R16,284,436.34"}}]
[]
[null,null,"SUBTOTAL A (Sch A + B)",{"$f":"+E134+E131","v":{"v":22372436.34,"d":"R22,372,436.34"}}]
[]
[null,null,"Contract Skills Development Goal (CSDG: 0.25% of Subtotal A)",{"$f":"+D136*0.0025","v":{"v":55931.09085,"d":"R55,931.09"}}]
[null,null,"The tenderer shall add allowance of 8% Rise and Fall and CPA",{"$f":"D136*0.08","v":{"v":1789794.9072,"d":"R1,789,794.91"}}]
[]
[null,null,"SUBTOTAL B (Subtotal A + CSDG + CPA)",{"$f":"D136+D138+D139","v":{"v":24218162.33805,"d":"R24,218,162.34"}}]
[]
[null,null,"10% Contingency (of Subtotal B)",{"$f":"D141*0.1","v":{"v":2421816.2338050003,"d":"R2,421,816.23"}}]
[]
[null,null,"SUBTOTAL C",{"$f":"D143+D141","v":{"v":26639978.571855,"d":"R26,639,978.57"}}]
[]
[null,null,"VALUE ADDED TAX:"]
[null,null,"15% of Subtotal C",{"$f":"D145*0.15","v":{"v":3995996.78577825,"d":"R3,995,996.79"}}]
[]
[null,null,"TOTAL CARRIED TO C.1.1.1 : FORM OF OFFER (Subtotal C + VAT)",{"$f":"D145+D148","v":{"v":30635975.35763325,"d":"R30,635,975.36"}}]
[]
[]
[null,null,"SIGNED BY TENDERER: "]

{"sheet":"C1.2","index":1,"n_rows":39,"n_cols":9,"rows_kept":39,"merged":[[1,2,1,8],[2,1,2,3],[3,2,3,8],[6,2,6,8],[11,1,11,8],[12,2,12,8],[13,3,13,8],[17,3,17,8],[22,3,22,8],[27,3,27,8],[31,4,31,9],[34,3,34,8],[38,1,38,7]]}
[]
[null,"C1.2","GENERAL REQUIREMENTS AND PROVISIONS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C1.2.1","Environmental Management"]
[null,null,"C1.2.1.1",null,"General Compliance with environmental specifications","month",12,null,{"$f":"G5*H5","v":0}]
[]
[null,"C1.2.5","Safety "]
[null,null,"C1.2.5.1",null,"Contractor's initial obligations in respect of the Occupational Health and Safety Act and the Construction Regulations","Sum",1,null,{"$f":"G8*H8","v":0}]
[null,null,"C1.2.5.2",null,"Contractor's time related obligations in respect of the Health and Safety Act and the Construction Regulations"," month",12,null,0]
[null,null,"C1.2.5.3",null,"Provision of full time Construction Safety Officer"," month",12,null,{"$f":"G10*H10","v":0}]
[null,null,"C1.2.5.4",null,"Submission of the Health and Safety File","L Sum",1,null,0]
[]
[null,"C1.2.8","Dayworks"]
[null,null,"C1.2.8.1","Personnel"]
[{"$nulls":3},"(a)","Labourer","hour",120,null,{"$f":"G15*H15","v":0}]
[{"$nulls":3},"(e)","Charge hand / supervisor","hour",24,null,0]
[{"$nulls":3},"(f)","Surveyor","hour",8,null,0]
[null,null,"C1.2.8.2","Construction equipment (specify size and/or model number)"]
[{"$nulls":3},"(b)","10 - 12 tonne vibratory roller","hour",8,null,{"$f":"G19*H19","v":0}]
[{"$nulls":3},"(c)","16 tonne pneumatic roller","hour",8,null,0]
[{"$nulls":3},"(e)","Tractor loader backhoe (TLB)","hour",16,null,0]
[{"$nulls":3},"(h)","Plate compactor","hour",24,null,0]
[null,null,"C1.2.8.3","Vehicles (specify size)"]
[{"$nulls":3},"(a)","Light delivery vehicle (LDV)","km",5000,null,{"$f":"G24*H24","v":0}]
[{"$nulls":3},"(a)-alt","Light delivery vehicle (LDV) - equipment rate","hour",16,null,0]
[{"$nulls":3},"(b)","Flatbed truck","km",1000,null,0]
[{"$nulls":3},"(c)","8 - 10 tonne tipper truck","hour",32,null,0]
[null,null,"C1.2.8.4","Materials"]
[{"$nulls":3},"(a)","Procurement of materials","Prov Sum",1,{"v":58000,"d":"R58,000.00"},{"$f":"G29*H29","v":{"v":58000,"d":"R58,000.00"}}]
[{"$nulls":3},"(b)","Contractor's handling costs, profit and all other charges in respect of item C1.2.8.4(a)","%",{"$f":"I29","v":{"v":58000,"d":"R58,000.00"}},null,0]
[]
[null,"PC1.2.10",null,null,"Dispute Adjudication Board (DAB)"]
[null,null,"C1.2.10.1",null,"Employer’s contribution to DAB (50%)","PC Sum",1,{"v":500000,"d":"R500,000.00"},{"$f":"H33*G33","v":{"v":500000,"d":"R500,000.00"}}]
[]
[null,"PC1.2.11",null,"Permits and Courses"]
[null,null,"C1.2.11",null,"Airside induction courses and permits","Lump Sum",1,null,{"$f":"G36*H36","v":0}]
[null,null,"C1.2.12",null,"Provision for CIDB B.U.I.L.D. Program ","month",12,null,{"$f":"G37*H37","v":0}]
[]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I4:I38)","v":{"v":558000,"d":"R558,000.00"}}]

{"sheet":"C1.3","index":2,"n_rows":16,"n_cols":9,"rows_kept":16,"merged":[[1,2,1,8],[2,1,2,3],[3,2,3,8],[15,1,15,7],[16,1,16,8]]}
[]
[null,"C1.3","CONTRACTOR’S SITE ESTABLISHMENT AND GENERAL OBLIGATIONS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"PC1.3.1","The Contractor's general obligations"]
[null,null,"C1.3.1.1",null,"Fixed obligations","L/sum",1,null,{"$f":"G5*H5","v":0}]
[null,null,"C1.3.1.2",null,"Value-related obligations","L/sum",1,null,0]
[null,null,"C1.3.1.3",null,"Time-related obligations"]
[{"$nulls":3},"(b)","Time-related obligations","Month",12,null,0]
[{"$nulls":3},"(c)","Contractor's obligations in respect of compliance and dealing with unforeseen","month",12,null,0]
[{"$nulls":3},"(d)","Provision of a full time traffic safety and construction safety officer","month",12,null,0]
[{"$nulls":3},"(e)","Submission of Health and Safety File","Sum",1,null,0]
[{"$nulls":3},"(f)","Preparation and submission of as-built drawings, manuals and operating instructions","Sum",1,null,0]
[{"$nulls":3},"(g)","A new 50 mm (compacted) Stone Mastic Asphalt (SMA) overlay shall be constructed at full runway width. The SMA shall be a gap-graded, stone-on-stone mix with NMPS 14 mm, and shall be designed and approved in accordance with NAPA guidance, AASHTO R46, and Sabita Manual 35. The binder shall be PG 58E-22 polymer-modified, and the mix design shall comply with Sabita Manual 35, Design Level III requirements.","L/sum",1,null,0]
[{"$nulls":3},"(h)","Mix design for a sand skeletal gap-graded asphalt mix, as defined, to be placed in a 50 mm compacted layer using an AP1 modified binder, Design Level II, and NMPS 14 mm, and to be paver-laid in accordance with the approved working mix.","L/sum",1,null,0]
[null,"C1.3.2",null,null,"Contract sign boards","No.",1,null,0]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I5:I15)","v":0}]

{"sheet":"C1.4","index":3,"n_rows":45,"n_cols":9,"rows_kept":45,"merged":[[1,2,1,8],[2,1,2,3],[3,2,3,8],[13,2,13,8],[18,2,18,8],[38,2,38,8],[41,2,41,8],[44,1,44,7]]}
[]
[null,"C1.4","FACILITIES FOR THE ENGINEER"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C1.4.1","Site accommodation"]
[null,null,"C1.4.1.1",null,"Offices (interior floor space only)","m²",60,null,{"$f":"G5*H5","v":0}]
[null,null,"C1.4.1.4",null,"Roofs over open concrete working floors (Gate 6A)","m²",30,null,0]
[null,null,"C1.4.1.5",null,"Stores","m²",12,null,0]
[null,null,"C1.4.1.6",null,"Car ports","No.",2,null,0]
[null,null,"C1.4.1.7",null,"Ablution units","m²",10,null,0]
[null,null,"C1.4.1.9",null,"Kitchen (interior floor space only)","m²",10,null,0]
[null,null,"C1.4.1.13",null,"Rented housing paid for by the Contractor","Prov sum",1,{"$f":"12*2*20000","v":{"v":480000,"d":"R480,000.00"}},{"v":480000,"d":"R480,000.00"}]
[null,null,"C1.4.1.14",null,"Contractor's handling costs, profit and all other charges in respect of item C1.4.1.13","%",{"$f":"I11","v":{"v":480000,"d":"R480,000.00"}}]
[null,null,"C1.4.1.15",null,"Steel containers at Gate 6A (6 m x 2,4 m x 2,6 m including two windows and doors)","No",1,null,0]
[null,"C1.4.2","Items measured by area"]
[null,null,"C1.4.2.1",null,"Shelving as specified complete with brackets","m²",4,null,{"$f":"G15*H15","v":0}]
[null,null,"C1.4.2.7",null,"Venetian blinds","m²",12,null,0]
[null,null,"C1.4.2.8",null,"Notice boards as specified","m²",3,null,0]
[null,null,"C1.4.2.9",null,"White board (1.5m x 1.2m)","No.",2,null,0]
[null,"C1.4.3","Items measured by number"]
[null,null,"C1.4.3.2",null,"Chairs","No.",10,null,{"$f":"G20*H20","v":0}]
[null,null,"C1.4.3.5",null,"Desks, complete with drawers and locks","No.",2,null,0]
[null,null,"C1.4.3.7",null,"Drawing table","No.",1,null,0]
[null,null,"C1.4.3.8",null,"Conference table","No.",1,null,0]
[null,null,"C1.4.3.11",null,"General-purpose steel cupboards with shelves","No.",2,null,0]
[null,null,"C1.4.3.13",null,"220/250 volt power points","No.",6,null,0]
[null,null,"C1.4.3.15",null,"Double 80 watt fluorescent light fittings complete with ballast and tubes","No.",5,null,0]
[null,null,"C1.4.3.23",null,"Fire extinguishers, 9,0 kg,all purpose dry powder type, complete, mounted on wall with brackets","No.",3,null,0]
[null,null,"C1.4.3.24",null,"Air conditioning units with 2,2 kW minimum capacity, mounted and with own power connection","No.",2,null,0]
[null,null,"C1.4.3.39",null,"Refrigerators","No.",1,null,0]
[null,null,"C1.4.3.40",null,"Electric kettle","No.",1,null,0]
[null,null,"C1.4.3.41",null,"Flood lights complete with poles and 500W (min) globes","No.",2,null,0]
[null,null,"C1.4.3.42",null,"Water dispenser","No.",1,null,0]
[null,null,"C1.4.3.43",null,"Steel drawing rack","No.",1,null,0]
[null,null,"C1.4.3.44",null,"Table (1.0 m2)","No.",1,null,0]
[null,null,"C1.4.3.45",null,"ACSA approved lime coloured reflective safety jackets (with lettering)","No.",4,null,0]
[null,null,"C1.4.3.46",null,"Rechargeable 500 000 candlelight halogen lamps","No.",3,null,0]
[null,null,"C1.4.3.47",null,"Two-way hand held radio VHF/AM Dittel FSG5 complete with charger, carrying bag with strap and adapter cable","No.",2,null,{"$f":"G37*H37","v":0}]
[null,null,"C1.4.3.48",null,"Provision of multifunction printing facilities (mapped from Colto B14.10)","month",12,null,{"$f":"G38*H38","v":0}]
[null,"C1.4.4","Prime cost items"]
[null,null,"C1.4.4.5",null,"The provision of internet connectivity and WiFi data for Engineer’s site staff","Sum",1,null,{"$f":"G40*H40","v":0}]
[]
[null,"C1.4.5","Services at site offices, laboratories and site accommodation"]
[null,null,"C1.4.5.1",null,"Services at office and laboratories: Fixed costs","Sum",1,null,{"$f":"G43*H43","v":0}]
[null,null,"C1.4.5.2",null,"Services at office and laboratories: Running costs","month",12,null,{"$f":"G44*H44","v":0}]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I5:I44)","v":{"v":480000,"d":"R480,000.00"}}]

{"sheet":"C1.5","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[3,2,3,8],[4,3,4,8],[8,3,8,8],[10,1,10,8],[16,2,16,8],[19,1,19,7]]}
[]
[null,"C1.5",null,null,"ACCOMMODATION OF TRAFFIC"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C1.5.7","Temporary traffic control facilities"]
[null,null,"C1.5.7.1","Delineators including mounting bases and ballast:"]
[{"$nulls":3},"(b)","Delineators (TW401 & TN402) (250 mm x 1,000 mm) Mounted back to back (was: Double sided, reversible left or right (size indicated))","No",200,null,{"$f":"H6*G6","v":0}]
[null,null,"C1.5.7.2",null,"Traffic cones (750 mm) (was: Traffic cones, minimum height 750mm)","No",20,null,0]
[null,null,"C1.5.7.3",null,"Flagmen","manday",300,null,0]
[null,null,"C1.5.7.5","Provision of illuminated traffic signs:"]
[{"$nulls":3},"(a)","Amber flicker lights (was: Sign mounted flashing amber lights (2 lights with the specified power supply) mounted on a backing board which is:)","No",14,null,{"$f":"H10*G10","v":0}]
[null,"(Note: COTO template specifies board sizes, Colto BOQ does not. Used generic description from Colto.)"]
[null,null,"C1.5.7.6",null,"Relocation of traffic control facilities","Lump Sum",1,null,{"$f":"H12*G12","v":0}]
[null,null,"C1.5.7.7",null,"Manufacturing and supply of aircraft barriers","No",6,null,0]
[null,null,"C1.5.7.8",null,"Moveable barricade (red and white alternating) HDPE plastic barrier","No",20,null,0]
[null,null,"C1.5.7.9",null,"Placing, repositioning, and final removal of vehicle and aircraft barriers upon completion of shifts","Lump Sum",1,null,0]
[null,null,"C1.5.7.10",null,"Runway Closure Marker","No",2,null,0]
[null,"C1.5.12","Additional traffic accommodation facilities ordered by the Engineer:"]
[null,null,"C1.5.7.12",null,"Provision of lighting on site to work areas","Lump Sum",1,null,{"$f":"H18*G18","v":0}]
[null,null,"C1.5.7.13",null,"Provision of lighting on site to work areas as requested by the Engineer","hours",600,null,0]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I6:I19)","v":0}]

{"sheet":"C1.6","index":5,"n_rows":20,"n_cols":9,"rows_kept":20,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[3,2,3,8],[7,2,7,8],[14,2,14,8],[19,1,19,7]]}
[]
[null,"C1.6",null,null,"CLEARING AND GRUBBING"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C1.6.11","Cleaning out of hydraulic structures"]
[null,null,"C1.6.11.1",null,"Pipes, box culverts, and side drains or grid inlets - RWY Works","m³",20,null,{"$f":"H5*G5","v":0}]
[null,null,"C1.6.11.2",null,"Pipes, box culverts, and side drains or grid inlets - TWY Works","m³",20,null,0]
[null,null,"C1.6.11.3",null,"Pipes, box culverts, and side drains or grid inlets - GA Works","m³",20,null,0]
[null,"C1.6.12","Clearing, excavating, and spoiling existing material from site camp"]
[null,null,"C1.6.12.1",null,"Bituminous material on stockpile - RWY Works","m³",600,null,{"$f":"H9*G9","v":0}]
[null,null,"C1.6.12.2",null,"Milled material - RWY Works","m³",350,null,0]
[null,null,"C1.6.12.3",null,"Bituminous material on stockpile - TWY Works","m³",600,null,0]
[null,null,"C1.6.12.4",null,"Milled material - TWY Works","m³",350,null,0]
[null,null,"C1.6.12.5",null,"Bituminous material on stockpile - GA Works","m³",50,null,0]
[null,null,"C1.6.12.6",null,"Milled material - GA Works","m³",50,null,0]
[null,"C1.6.13","Clearing, excavating, and removal of stockpiled materials"]
[null,null,"C1.6.13.1",null,"Bituminous material on stockpile - RWY Works","m³",120,null,{"$f":"H16*G16","v":0}]
[null,null,"C1.6.13.2",null,"Milled material - RWY Works","m³",2079,null,0]
[null,null,"C1.6.13.3",null,"Bituminous material on stockpile - TWY Works","m³",120,null,0]
[null,null,"C1.6.13.4",null,"Milled material - TWY Works","m³",2079,null,0]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I5:I19)","v":0}]

{"sheet":"C3.1","index":6,"n_rows":63,"n_cols":9,"rows_kept":63,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[62,1,62,7]]}
[]
[null,"C3.1",null,null,"DRAINS & SUB-SOILS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"  ",{"$nulls":6},{"$f":"IF(G4=\"\",\"\",IF(OR(F4=\"PC Sum\",F4=\"Prov Sum\"),G4,G4*H4))","v":""}]
[null,"C3.1.1  ",null,null,"EXCAVATION FOR OPEN DRAINS:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.1.1.1 ",null,"Excavating all material situated within the following depth ranges below the surface level using conventional methods:",{"$nulls":3},""]
[{"$nulls":8},""]
[{"$nulls":3},"  (a)","0m to 1,5m","m³",4800,null,{"$f":"H9*G9","v":0}]
[{"$nulls":8},""]
[null,null," C3.1.1.2 ",null,"Extra over sub-item C3.1.1.1 for excavation in hard and boulder material, irrespective of depth","m³",800,null,{"$f":"H11*G11","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.1.5  ",null,null,"IMPERMEABLE BACKFILLING TO SUBSOIL DRAINAGE SYSTEMS:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.1.5.1 ",null,"Un-stabilised natural gravel obtained from approved sources on the site","m³",1000,null,{"$f":"H15*G15","v":0}]
[null,null,"  ",{"$nulls":5},""]
[null,null," C3.1.5.2 ",null,"G5 material obtained from commercial sources, stabilisation with 4,0% CEM II B-M (V-S) 32,5N","m³",200,null,{"$f":"H17*G17","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.1.6  ",null,null,"CONSTRUCTION OF BANKS AND DYKES:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.1.6.1 ",null,"Banks and dykes using conventional methods","m³",1300,null,{"$f":"H21*G21","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.1.7  ",null,null,"NATURAL PERMEABLE MATERIAL IN SUBSOIL DRAINAGE SYSTEMS (APPROVED CRUSHED STONE):",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.1.7.1 ",null,"Crushed stone obtained from approved sources on the site (Coarse grade - 19.0mm)","m³",1100,null,{"$f":"H25*G25","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.1.8  ",null,null,"NATURAL PERMEABLE MATERIAL IN SUBSOIL DRAINAGE SYSTEMS (APPROVED NATURAL SAND):",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.1.8.1 ",null,"Natural sand obtained from approved sources (Medium grade > 2.00mm, source)","m³",1800,null,{"$f":"H29*G29","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.1.9  ",null,null,"PIPES IN SUBSOIL DRAINAGE SYSTEMS:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.1.9.1 ",null,"U-PVC pipes and fittings, normal duty, complete with couplings",{"$nulls":3},""]
[null,null,"  "]
[{"$nulls":3},"  (a)","150mm Slotted","m",4000,null,{"$f":"H35*G35","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (b)","150mm unslotted","m",200,null,{"$f":"H37*G37","v":0}]
[null,"  ",{"$nulls":6},{"$f":"IF(G38=\"\",\"\",IF(OR(F38=\"PC Sum\",F38=\"Prov Sum\"),G38,G38*H38))","v":""}]
[null,"C3.1.11  ",null,null,"Geotextile (Grade 5)","m²",8500,null,{"$f":"H39*G39","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.1.14  ",null,null,"CAPS FOR SUBSOIL DRAIN PIPES:",{"$nulls":3},{"$f":"IF(G41=\"\",\"\",IF(OR(F41=\"PC Sum\",F41=\"Prov Sum\"),G41,G41*H41))","v":""}]
[null,"  ",{"$nulls":6},{"$f":"IF(G42=\"\",\"\",IF(OR(F42=\"PC Sum\",F42=\"Prov Sum\"),G42,G42*H42))","v":""}]
[null,null," C3.1.14.1 ",null,"Concrete caps","No.",10,null,{"$f":"H43*G43","v":0}]
[null,"  "]
[null,"C3.1.16  ",null,null,"LOADING AND HAULING OF MATERIAL IN EXCESS OF 1,0 KM","m³ - km",43500,null,{"$f":"H45*G45","v":0}]
[null,"  ",{"$nulls":6},{"$f":"IF(G46=\"\",\"\",IF(OR(F46=\"PC Sum\",F46=\"Prov Sum\"),G46,G46*H46))","v":""}]
[null,"C3.1.18  ",null,null,"BACKFILLING OF DRAINS WITH SELECTED MATERIAL COMPACTED TO 93% OF MDD PRIOR TO CONSTRUCTION OF CONCRETE LINING AND/OR STONE PITCHED LINING","m³",1870,null,{"$f":"H47*G47","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.1.22  ",null,null,"TEST FLUSHING OF SUBSOIL DRAIN PIPE SYSTEMS","No.",10,null,{"$f":"H49*G49","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.1.23  ",null,null,"SUBSOIL DRAIN OUTLET MARKER ","No.",10,null,{"$f":"H51*G51","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C11.8.4  ",null,null,"Grassing:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C11.8.4.3 ",null,"Hydroseeding:",{"$nulls":3},""]
[null,null,"  ",{"$nulls":5},""]
[{"$nulls":3},"  (a)","Providing an approved seed mixture for hydroseeding","kg",6300,null,{"$f":"H57*G57","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (b)","Providing an approved mulch","kg",24900,null,{"$f":"H59*G59","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (c)","Hydroseeding","ha",200,null,{"$f":"H61*G61","v":0}]
[null,"  "]
[null," Total Carried Forward To Summary",{"$nulls":6},{"$f":"SUM(I4:I62)","v":0}]

{"sheet":"C3.2","index":7,"n_rows":156,"n_cols":9,"rows_kept":156,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[155,1,155,7]]}
[]
[null,"C3.2",null,null,"CULVERTS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"  ",{"$nulls":6},{"$f":"IF(G4=\"\",\"\",IF(OR(F4=\"PC Sum\",F4=\"Prov Sum\"),G4,G4*H4))","v":""}]
[null,"C3.2.1  ",null,null,"Excavation for culvert structures:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.1.1 ",null,"Excavating in all material situated within the following depth ranges below the surface level:",{"$nulls":3},""]
[null,null,"  ",{"$nulls":5},""]
[{"$nulls":3},"  (a)","0m to 1,5m","m³",6720,null,{"$f":"H9*G9","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (b)","Exceeding 1,5m and up to 3,0m","m³",710,null,{"$f":"H11*G11","v":0}]
[{"$nulls":3},"  "]
[null,null," C3.2.1.4 ",null,"Extra over sub-item C3.2.1.1 for excavation in hard or boulder material, irrespective of depth","m³",400,null,{"$f":"H13*G13","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.2.2  ",null,null,"Backfilling",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.2.1 ",null,"Using the excavated material compacted to 95% of modified AASHTO density","m³",5980,null,{"$f":"H17*G17","v":0}]
[null,null,"  ",{"$nulls":5},""]
[null,null," C3.2.2.2 ",null,"Using imported selected material:"]
[null,null,"  "]
[{"$nulls":3},"  (a)","From commercial sources, G5 quality","m³",580,null,{"$f":"H21*G21","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (b)","From sources on site, G5 quality","m³",145,null,{"$f":"H23*G23","v":0}]
[null,null,"  "]
[null,null,"  "]
[null,null," C3.2.2.3 ",null,"Extra over sub-items C3.2.2.1 and C3.2.2.2 for soil cement backfilling ",{"$nulls":3},""]
[null,null,"  ",{"$nulls":5},""]
[{"$nulls":3},"  (a)","With wet mixture of 5% cement","m³",30,null,{"$f":"H28*G28","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.2.3  ",null,null,"Concrete pipe culverts:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.3.2 ",null,"On Class B bedding",{"$nulls":3},""]
[null,null,"  "]
[{"$nulls":3},"  (a)","350mm dia. Class 100D","m",70,null,{"$f":"H34*G34","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (b)","450mm dia. Class 100D","m",10,null,{"$f":"H36*G36","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (c)","600mm dia. Class 100D","m",690,null,{"$f":"H38*G38","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (d)","900mm dia. Class 100D","m",10,null,{"$f":"H40*G40","v":0}]
[{"$nulls":3},"  "]
[null,"C3.2.5  ",null,null,"Rectangular culverts with prefabricated elements:",{"$nulls":3},{"$f":"IF(G42=\"\",\"\",IF(OR(F42=\"PC Sum\",F42=\"Prov Sum\"),G42,G42*H42))","v":""}]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.5.1 ",null,"Prefabricated portal culverts; wall and roof combination (size and type indicated)",{"$nulls":3},""]
[{"$nulls":3},"  (a)","600mm x 450mm Portal 150S","m",330,null,{"$f":"H45*G45","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (b)","600mm x 600mm Portal 150S","m",430,null,{"$f":"H47*G47","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (c)","900mm x 600mm Portal 150S","m",520,null,{"$f":"H49*G49","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (d)","1200mm x 600mm Portal 150S","m",600,null,{"$f":"H51*G51","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (f)","1500mm x 600mm Portal 150S","m",90,null,{"$f":"H53*G53","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[null,"C3.2.7  ",null,null,"Cast in situ concrete and formwork:",{"$nulls":3},{"$f":"IF(G55=\"\",\"\",IF(OR(F55=\"PC Sum\",F55=\"Prov Sum\"),G55,G55*H55))","v":""}]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.7.2 ",null,"In complete in situ floor slabs for rectangular culverts, manholes and catchpits including formwork, joints and Class U2 surface finish (Class C24/30-20 concrete) (installed at a standard depth of 1,0m)","m³",1,null,{"$f":"H57*G57","v":0}]
[null,null,"  ",{"$nulls":5},""]
[null,null," C3.2.7.5 ",null,"In inlet and outlet structures including kerbs, chutes and downpipes, skewed ends, catchpits, manholes, thrust and anchor blocks, excluding formwork but including Class U2 surfacing finish (Class C24/30-20 concrete)","m³",10,null,{"$f":"H59*G59","v":0}]
[null,null,"  ",{"$nulls":5},""]
[null,null," C3.2.7.6 ",null,"Formwork of concrete under items C3.2.7.3 to 5 above",{"$nulls":3},""]
[null,null,"  ",{"$nulls":5},""]
[{"$nulls":3},"  (a)","Vertical formwork for F1 surface finish","m²",3,null,{"$f":"H63*G63","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (b)","Vertical formwork for F2 surface finish","m²",30,null,{"$f":"H65*G65","v":0}]
[null,"  "]
[null,"C3.2.10  ",null,null,"Reinforcement:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.10.1 ",null,"Mild steel bars","t",1,null,{"$f":"H69*G69","v":0}]
[null,null,"  ",{"$nulls":5},""]
[null,null," C3.2.10.2 ",null,"High-tensile steel bars","t",1,null,{"$f":"H71*G71","v":0}]
[null,null,"  ",{"$nulls":5},""]
[null,null," C3.2.10.3 ",null,"Welded steel fabric","kg",300,null,{"$f":"H73*G73","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.2.12  ",null,null,"Demolition of concrete members or elements:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.12.1 ",null,"Full member or element",{"$nulls":3},""]
[null,null,"  ",{"$nulls":5},""]
[{"$nulls":3},"  (c)","Inlet Structures","m³",5,null,{"$f":"H79*G79","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (d)","Outlet Structures","m³",5,null,{"$f":"H81*G81","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C3.2.13  ",null,null,"Removing and re-laying existing culverts:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.13.1 ",null,"Removing and stacking existing culverts for re-use",{"$nulls":3},""]
[null,null,"  ",{"$nulls":5},""]
[{"$nulls":3},"  (a)","90mm diameter pipe","m",120,null,{"$f":"H87*G87","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (c)","160mm diameter pipe","m",50,null,{"$f":"H89*G89","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (d)","300mm diameter pipe","m",190,null,{"$f":"H91*G91","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (e)","350mm diameter pipe","m",250,null,{"$f":"H93*G93","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (f)","450mm diameter pipe","m",200,null,{"$f":"H95*G95","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (g)","600mm diameter pipe","m",130,null,{"$f":"H97*G97","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (h)","750mm diameter pipe","m",10,null,{"$f":"H99*G99","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},{"$f":"IF(G100=\"\",\"\",IF(OR(F100=\"PC Sum\",F100=\"Prov Sum\"),G100,G100*H100))","v":""}]
[{"$nulls":3},"  (i)","900mm diameter pipe","m",10,null,{"$f":"H101*G101","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},""]
[{"$nulls":3},"  (j)","600mm x 600mm Portal","m",10,null,{"$f":"H103*G103","v":0}]
[null,"  "]
[null,"C3.2.15  ",null,null,"Manholes and catch pits, with prefabricated elements",{"$nulls":3},{"$f":"IF(G105=\"\",\"\",IF(OR(F105=\"PC Sum\",F105=\"Prov Sum\"),G105,G105*H105))","v":""}]
[null,"  "]
[null,null," C3.2.15.2 ",null,"Prefabricated roofs"]
[null,null,"  "]
[{"$nulls":3},"  (a)","Stormwater Manhole covers","No",22,null,{"$f":"H109*G109","v":0}]
[{"$nulls":3},"  ",{"$nulls":4},{"$f":"IF(G110=\"\",\"\",IF(OR(F110=\"PC Sum\",F110=\"Prov Sum\"),G110,G110*H110))","v":""}]
[{"$nulls":3},"  (b)","Kerb inlet covers","No",12,null,{"$f":"H111*G111","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (c) ","Grid Inlet Covers","No.",15,null,{"$f":"H113*G113","v":0}]
[null,"  "]
[null,"C3.2.16  ",null,null,"Brickwork (Engineering bricks)",{"$nulls":3},{"$f":"IF(G115=\"\",\"\",IF(OR(F115=\"PC Sum\",F115=\"Prov Sum\"),G115,G115*H115))","v":""}]
[null,"  "]
[null,null," C3.2.16.2 ",null,"230 mm thick","m²",300,null,{"$f":"H117*G117","v":0}]
[null,"  ",{"$nulls":6},{"$f":"IF(G118=\"\",\"\",IF(OR(F118=\"PC Sum\",F118=\"Prov Sum\"),G118,G118*H118))","v":""}]
[null,null," C3.2.16.3 ",null,"345 mm thick","m²",70,null,{"$f":"H119*G119","v":0}]
[null,"  "]
[null," C3.2.17 ",null,null,"Plaster","m²",350,null,{"$f":"H121*G121","v":0}]
[null,"  "]
[null,"  "]
[null,"C3.2.18  ",null,null,"Benching",{"$nulls":3},{"$f":"IF(G124=\"\",\"\",IF(OR(F124=\"PC Sum\",F124=\"Prov Sum\"),G124,G124*H124))","v":""}]
[null,"  "]
[null,"C3.2.18  ",null,null,"Plaster","m³",10,null,{"$f":"H126*G126","v":0}]
[null,"  "]
[null,"C3.2.19  ",null,null,"Benching",{"$nulls":3},{"$f":"IF(G128=\"\",\"\",IF(OR(F128=\"PC Sum\",F128=\"Prov Sum\"),G128,G128*H128))","v":""}]
[null,"  "]
[null,null," C3.2.19.1 ",null,"Manhole frames","No",28,null,{"$f":"H130*G130","v":0}]
[null,null,"  "]
[null,null," C3.2.19.4 ",null,"Manhole covers or gratings","No",28,null,{"$f":"H132*G132","v":0}]
[null,null,"  "]
[null,null," C3.2.19.7 ",null,"Step irons","No",198,null,{"$f":"H134*G134","v":0}]
[null,"  "]
[null,"C3.2.20  ",null,null,"Anchor for pipes (1.5m x 3.5kg/m steel) H-section as per drawing","No.",8,null,{"$f":"H136*G136","v":0}]
[null,"  ",{"$nulls":6},{"$f":"IF(G137=\"\",\"\",IF(OR(F137=\"PC Sum\",F137=\"Prov Sum\"),G137,G137*H137))","v":""}]
[null,"C3.2.22  ",null,null,"Cutting of concrete pipes:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[{"$nulls":3},"  (a)","600mm diameter pipe","No.",2,null,{"$f":"H140*G140","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (c) ","900mm diameter pipe","No.",2,null,{"$f":"H142*G142","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (c) ","900mm x 600mm Portal","No.",2,null,{"$f":"H144*G144","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (d)","1500mm x 600mm Class","No.",2,null,{"$f":"H146*G146","v":0}]
[null,"  "]
[null,"C3.2.24  ",null,null,"Compaction of bedding for inlets, outlets, manholes and catchpits:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C3.2.24.1 ",null,"Preparation and compaction of in situ bedding material to 90% of MDD (150mm depth)","m³",170,null,{"$f":"H150*G150","v":0}]
[null,null,"  "]
[null,null," C3.2.24.2 ",null,"Extra-over sub-item C3.2.24.1 for compaction to 93% of MDD, 150 mm thick layer","m³",70,null,{"$f":"H152*G152","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"PC3.2.28 PC3.2.6.1 ",null,null,"Waterproofing of prefabricated culvert joints with a 500 mm wide composite membrane strip consisting of rubberized asphalt and cross-laminated high-density polyethylene film","m",2750,null,{"$f":"H154*G154","v":0}]
[null,"  "]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I4:I155)","v":0}]

{"sheet":"C3.3","index":8,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[30,1,30,7],[31,1,33,1],[31,4,33,4],[34,1,36,1],[34,4,36,4],[34,5,36,5],[34,6,36,6],[34,7,36,7],[34,8,36,8]]}
[]
[null,"C3.3",null,null,"ARMOFLEX LINING"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"  ",{"$nulls":6},{"$f":"IF(G4=\"\",\"\",IF(OR(F4=\"PC Sum\",F4=\"Prov Sum\"),G4,G4*H4))","v":""}]
[null,"C3.3.8  ",null,null,"Linings for open drains:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," PC3.3.8.1 ",null,"Armoflex blocks",{"$nulls":3},""]
[null,null,"  ",{"$nulls":5},""]
[{"$nulls":3},"  (a)","Armoflex lining for open drains, including preparation of surface, trimming, bedding, installation of Armoflex, anchoring, and all necessary fittings and overlaps complete as specified","m2",{"v":13000,"d":"13000.00"},null,{"$f":"H9*G9","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3},"  (b)","Supply and install geotextile membrane ","m2",{"v":13000,"d":"13000.00"},null,{"$f":"H11*G11","v":0}]
[{"$nulls":3},"  "]
[null,"C3.3.16  ",null,null,"Demolition and removal of existing kerbs and/or channel:",{"$nulls":3},{"$f":"IF(G13=\"\",\"\",IF(OR(F13=\"PC Sum\",F13=\"Prov Sum\"),G13,G13*H13))","v":""}]
[null,"  ",{"$nulls":6},{"$f":"IF(G14=\"\",\"\",IF(OR(F14=\"PC Sum\",F14=\"Prov Sum\"),G14,G14*H14))","v":""}]
[{"$nulls":3}," (a) ","Plain concrete (including existing side drains, and kerb/channel combinations)","m³",{"v":5,"d":"5.00"},null,{"$f":"H15*G15","v":0}]
[{"$nulls":3},"  "]
[{"$nulls":3}," (b) ","Breaking and removing existing concrete drain outlet structures","m³",{"v":5,"d":"5.00"},null,{"$f":"H17*G17","v":0}]
[null,"  ",{"$nulls":6},{"$f":"IF(G18=\"\",\"\",IF(OR(F18=\"PC Sum\",F18=\"Prov Sum\"),G18,G18*H18))","v":""}]
[null,null,"C3.3 3.1.18 ",null,"Backfilling of drains with selected material compacted to 93% of MDD prior to construction of concrete lining and/or stone pitched lining","m³",{"v":1870,"d":"1870.00"},null,{"$f":"H19*G19","v":0}]
[null,"  "]
[null,"C1.7.1  ",null,null,"LOADING:",{"$nulls":3},{"$f":"IF(G21=\"\",\"\",IF(OR(F21=\"PC Sum\",F21=\"Prov Sum\"),G21,G21*H21))","v":""}]
[null,"  ",{"$nulls":6},""]
[null,null," C1.7.1.2 ",null,"Loading from heaps or windrows using machines and/some hand labour where necessary","m³",{"v":1870,"d":"1870.00"},null,{"$f":"H23*G23","v":0}]
[null,"  ",{"$nulls":6},""]
[null,"C1.7.2  ",null,null,"HAULING:",{"$nulls":3},""]
[null,"  ",{"$nulls":6},""]
[null,null," C1.7.2.2 ",null,"Hauling material to spoil and off-loading it at a designated spoil or stockpile area:",{"$nulls":3},""]
[null,null,"  ",{"$nulls":5},""]
[{"$nulls":3},"  (b)","Soil and gravel material","m³ -km",{"v":1870,"d":"1870.00"},null,{"$f":"H29*G29","v":0}]
[null,"  ",{"$nulls":6},""]
[null," Total Carried Forward To Summary",{"$nulls":6},{"$f":"SUM(I4:I30)","v":0}]

{"sheet":"C4.2","index":9,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[12,1,12,7]]}
[]
[null,"C4.2",null,null,"CUT MATERIALS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[null,"C4.2.8",null,null,"Excavate material to spoil in sites designated by the Employer, material obtained from"]
[null,null,"C4.2.8.1",null,"Cut to spoil: Soft excavation","m3",{"v":6000,"d":"6,000.00"},null,{"$f":"H6*G6","v":0}]
[null,null,"C4.2.8.4",null,"Cut to spoil: Intermediate excavation (was: Hard excavation (other than by blasting))","m3",{"v":1500,"d":"1,500.00"},null,0]
[null,null,"C4.2.8.4",null,"Cut to spoil: Hard excavation (was: Hard excavation (other than by blasting))","m3",{"v":500,"d":"500.00"},null,0]
[null,"C4.2.12",null,null,"Finishing the side slopes"]
[null,null,"C4.2.12.1",null,"Cuttings: "]
[{"$nulls":3},"(a)","Finishing off cut slopes (was: In soft material)","m3",{"v":6000,"d":"6,000.00"},null,{"$f":"H11*G11","v":0}]
[]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I5:I12)","v":0}]

{"sheet":"C4.3","index":10,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[3,2,3,8],[6,2,6,8],[18,2,18,8],[21,1,21,7]]}
[]
[null,"C4.3",null,null,"EXISTING ROAD MATERIALS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C4.3.2","Cleaning the existing road surface"]
[null,null,"C4.3.2.1",null,"Removal of rubber deposits by water blasting","Prov Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},{"$f":"H5*G5","v":{"v":50000,"d":"R50,000.00"}}]
[null,null,"C4.3.2.2",null,"Handling cost and profit in respect of item C4.3.2.1 (for rubber removal)","%",{"$f":"I5","v":{"v":50000,"d":"50,000.00"}},null,{"$f":"H6*G6","v":0}]
[null,"C4.3.6","Milling and removal of existing asphalt layers with an average milling depth (Contractor takes ownership)"]
[null,null,"C4.3.6",null,"Milling and removal of existing asphalt layers with an average milling depth (Contractor takes ownership)"]
[null,null,"C4.3.6.1","(a)","Milling out existing bituminous material: At full width 50 mm Milling - RWY Works ","m³",{"v":5000,"d":"5,000.00"},null,{"$f":"H9*G9","v":0}]
[null,null,"C4.3.6.1","(b)","Milling out existing bituminous material (50 mm) - TWY Works (ALPHA)","m³",{"v":3000,"d":"3,000.00"},null,0]
[null,null,"C4.3.6.1","(c)","Milling out existing bituminous material: Patches (50 mm) - TWY Works (ALPHA 1)","m³",{"v":220,"d":"220.00"},null,{"$f":"H11*G11","v":0}]
[null,null,"C4.3.6.1","(d)","Milling out existing bituminous material (50 mm) - TWY Works (ALPHA 2)","m³",{"v":230,"d":"230.00"},null,{"$f":"H12*G12","v":0}]
[null,null,"C4.3.6.1","(e)","Milling out existing bituminous material (50 mm) - TWY Works (ALPHA 3)","m³",{"v":100,"d":"100.00"},null,0]
[null,null,"C4.3.6.1","(f)","Milling out existing bituminous material: Patches  (50 mm) - TWY Works (ALPHA 4)","m³",{"v":150,"d":"150.00"},null,0]
[null,null,"C4.3.6.1","(g)","Milling out existing bituminous material: Patches (50 mm) - TWY Works (ECHO)","m³",{"v":35,"d":"35.00"},null,0]
[null,null,"C4.3.6.1","(h)","Milling out existing bituminous material: Patches on GA (50 mm) - GA Works","m³",{"v":300,"d":"300.00"},null,0]
[null,null,"C4.3.6.2","(a)","Milling out existing bituminous material (100 mm) - RUNWAY ","m³",{"v":2000,"d":"2,000.00"},null,0]
[null,null,"C4.3.6.2","(b)","Milling out existing bituminous material (100 mm) - TWY Works (ALPHA 3)","m³",{"v":150,"d":"150.00"},null,0]
[null,"C4.3.15","Ancillary Works"]
[null,null,"C4.3.15.1",null,"Preparing stockpile sites - RWY Works","m²",{"v":10000,"d":"10,000.00"},null,{"$f":"H20*G20","v":0}]
[null,null,"C4.3.15.2",null,"Preparing stockpile sites - TWY Works","m²",{"v":10000,"d":"10,000.00"},null,0]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I5:I21)","v":{"v":50000,"d":"R50,000.00"}}]

{"sheet":"C5.2","index":11,"n_rows":14,"n_cols":9,"rows_kept":14,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[13,1,13,7]]}
[]
[null,"C5.2",null,null,"FILL"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C5.2.2",null,null,"Fill construction: "]
[null,null,"C5.2.2.1",null,"Normal fill material in compacted layer thicknesses of 200mm and less:"]
[{"$nulls":3},"(a)","Cut and borrow to fill: Silty sand or sandy gravel compacted to 90% of modified AASHTO density","m3",{"v":34000,"d":"34,000.00"},null,{"$f":"H6*G6","v":0}]
[null,null,"C5.2.2.3",null,"Cut and borrow to fill: Free draining sand compacted to 100% of mod. AASHTO density (was: Sand fill material in compacted layer thicknesses of 400mm and less, compacted to 100% of MDD)","m3",{"v":10000,"d":"10,000.00"},null,0]
[null,"C5.2.12",null,null,"Extra over for excavation hardness in fill material"]
[null,null,"C5.2.12.1",null,"Extra over item 33.01 for excavating and breaking down material in: Intermediate excavation","m3",{"v":15000,"d":"15,000.00"},null,{"$f":"H9*G9","v":0}]
[null,null,"C5.2.12.2",null,"Extra over item 33.01 for excavating and breaking down material in: Hard excavation","m3",{"v":2000,"d":"2,000.00"},null,0]
[null,"C5.2.11",null,null,"Finishing-off fill slopes, medians and interchange areas:"]
[null,null,"C5.2.11.1",null,"Finishing off fill slopes","m3",{"v":12000,"d":"12,000.00"},null,{"$f":"H12*G12","v":0}]
[]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I6:I13)","v":0}]

{"sheet":"C9.1","index":12,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[30,1,30,7]]}
[]
[null,"C9.1",null,null,"ASPHALT LAYERS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C9.1.2",null,null,"Construction of trial sections "]
[null,null,"C9.1.2.1","(a)","50 mm thick Stone Mastic Asphalt (SMA) constructed at full width for the runway (Gap-graded mix, 14 mm NMPS. PG 58E-22 polymer-modified binder,  mix design to adhere to NAPA, AASHTO R46 and SABITA MANUAL 35 Design Level III requirements. ","m²",{"v":900,"d":"900.00"},null,{"$f":"H5*G5","v":0}]
[null,null,"C9.1.2.1","(b)","Base constructed with new asphalt: BTB (100 mm, 35/50 penetration grade bitumen, NMPS 20mm, design level II and placing technique paver) 350mx46m","m²",{"v":900,"d":"900.00"},null,0]
[null,null,"C9.1.2.1","(c)","Asphalt layer constructed for rehabilitation: Surfacing with AC: Sand skeletal mix gab graded as defined (50 mm layer thickness, AP1 modified binder, design level II, NMPS 14 mm and placing technique paver) at full width; TWY Works (APLHA, ALPHA 1,ALPHA 2, ALPHA 3, ALPHA 4, ECHO and CHARLI)","m²",{"v":900,"d":"900.00"},null,0]
[null,null,"C9.1.2.2","(a)","Removal of the trial section (50mm Surfacing) where so instructed by the Engineer - RWY Works","m²",{"v":900,"d":"900.00"},null,0]
[null,null,"C9.1.2.2","(b)","Removal of the trial section (100mm BTB) where so instructed by the Engineer - RWY Works","m²",{"v":900,"d":"900.00"},null,0]
[null,"C9.1.3",null,null,"Application of bond coat"]
[null,null,"C9.1.3.1","(a)","Tack coat: 30% stablegrade emulsion at full width for resurfacing (0,5 l/m²) - RWY Works","l",{"v":50000,"d":"50,000.00"},null,{"$f":"H11*G11","v":0}]
[null,null,"C9.1.3.1","(b)","Tack coat: 30% stablegrade emulsion - TWY Works","l",{"v":26500,"d":"26,500.00"},null,0]
[null,null,"C9.1.3.3",null,"Application of tack coat to the edges of a layer - RWY Works","l",{"v":24000,"d":"24,000.00"},null,0]
[null,"C9.1.4",null,null,"Asphalt base "]
[null,null,"C9.1.4.2",null,"Rehabilitation "]
[null,null,"C9.1.4.2","(a)","Base constructed with new asphalt: BTB (100 mm, 35/50 penetration grade bitumen, NMPS 20mm, design level II and placing technique paver) 350mx46m - RWY Works","t",{"v":4000,"d":"4,000.00"},null,{"$f":"H16*G16","v":0}]
[null,null,"C9.1.4.2","(b)","Asphalt layer constructed for rehabilitation: Base with BTB (100 mm, 35/50 penetration grade bitumen, NMPS 20mm, design level II and placing technique paver) 10% Taxiway ALPHA and 100% Taxiway ALPHA 3","t",{"v":1500,"d":"1,500.00"},null,0]
[null,"C9.1.5",null,null,"Asphalt surfacing"]
[null,null,"C9.1.5.2",null,"Rehabilitation "]
[null,null,"C9.1.5.2",null,"50 mm thick Stone Mastic Asphalt (SMA) constructed at full width for the runway (Gap-graded mix, 14 mm NMPS. PG 58E-22 polymer-modified binder,  mix design to adhere to NAPA, AASHTO R46 and SABITA MANUAL 35 Design Level III requirements. ","t",{"v":12000,"d":"12,000.00"},null,{"$f":"H20*G20","v":0}]
[null,null,"C9.1.5.2(e)","(a)","Asphalt layer constructed for rehabilitation: Surfacing with AC: Sand skeletal mix gab graded as defined (50 mm layer thickness, AP1 modified binder, design level II, NMPS 14 mm and placing technique paver) at full width; TWY Works (APLHA, ALPHA 1,ALPHA 2, ALPHA 3, ALPHA 4, ECHO and CHARLI)","t",{"v":10000,"d":"10,000.00"},null,0]
[null,null,"C9.1.5.2(e)","(b)","Asphalt layer constructed for rehabilitation: Sand skeletal mix gab graded as defined (50 mm layer thickness, AP1 modified binder, design level II, NMPS 14 mm and placing technique paver); GA Works","t",{"v":600,"d":"600.00"},null,0]
[null,"C9.1.13",null,null,"Coring of asphalt layers  "]
[null,null,"C9.1.13.1","(a)","Cores in asphalt paving: 100mm - RWY Works","No",{"v":600,"d":"600.00"},null,{"$f":"H24*G24","v":0}]
[null,null,"C9.1.13.1","(b)","Cores in asphalt paving: 100mm - TWY Works","No",{"v":400,"d":"400.00"},null,0]
[null,null,"C9.1.13.1","(c)","Cores in asphalt paving: 100mm - GA Works","No",{"v":25,"d":"25.00"},null,0]
[null,"C9.1.17",null,null,"Other Asphalt Related Works"]
[null,null,"C9.1.17.2",null,"Application of rejuvenation spray - GA Works","m²",{"v":4000,"d":"4,000.00"},null,{"$f":"H28*G28","v":0}]
[null,null,"C9.1.17.3",null,"Sealing cracks: Cleaning crack with hot compressed air and sealing using Class CR1 modified binder crack sealant - GA Works","l",{"v":1000,"d":"1,000.00"},null,0]
[]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I4:I30)","v":0}]

{"sheet":"C11.1","index":13,"n_rows":16,"n_cols":9,"rows_kept":16,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[15,1,15,7]]}
[]
[null,"C11.1",null,null,"PITCHING, STONEWORK AND PROTECTION AGAINST EROSION"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C11.1.2",null,null,"Stone pitching:"]
[]
[null,null,"C11.1.2.2",null,"Grouted stone pitching with mortar","m²",30,null,{"$f":"G6*H6","v":0}]
[]
[null,null,"C11.1.2.3",null,"Grouted stone pitching on a concrete bed","m²",3,null,{"$f":"G8*H8","v":0}]
[]
[null,"C11.1.7",null,null,"Provision of approved herbicide and ant poison:"]
[]
[null,null,"C11.1.7.1",null,"Provision of materials","PC sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"G12*H12","v":{"v":100000,"d":"R100,000.00"}}]
[]
[null,null,"C11.1.7.2",null,"Contractor’s charges and profit added to the prime cost sum","%",{"$f":"I12","v":{"v":100000,"d":"R100,000.00"}},null,{"$f":"G14*H14","v":0}]
[]
[null," Total Carried Forward To Summary",{"$nulls":6},{"$f":"SUM(I4:I15)","v":{"v":100000,"d":"R100,000.00"}}]

{"sheet":"C11.2","index":14,"n_rows":33,"n_cols":9,"rows_kept":33,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[32,1,32,7]]}
[]
[null,"C11.2",null,null,"NON-STRUCTURAL GABIONS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"C11.2.1",null,null,"Foundation trench excavation:"]
[]
[null,null,"C11.2.1.1",null,"Excavating all material situated within the following depth ranges below the surface level:"]
[]
[{"$nulls":4},"(a) 0 m to 1,5 m","m³",420,null,{"$f":"G8*H8","v":0}]
[]
[{"$nulls":4},"(b) Exceeding 1,5 m and up to 3,0 m","m³",105,null,{"$f":"G10*H10","v":0}]
[]
[null,null,"C11.2.1.2",null,"Extra over sub-item C11.2.1.1 for excavation in hard material, irrespective of depth","m³",21,null,{"$f":"G12*H12","v":0}]
[]
[null,"C11.2.2",null,null,"Surface preparation for bedding the gabion boxes and mattresses","m²",130,null,{"$f":"G14*H14","v":0}]
[]
[null,"C11.2.3",null,null,"Gabion boxes and mattresses:"]
[]
[null,null,"C11.2.3.1",null,"Galvanized gabion boxes:"]
[]
[{"$nulls":4},"(a) 0.5 m x 0.5 m x 1.0 m","m³",10,null,{"$f":"G20*H20","v":0}]
[]
[{"$nulls":4},"(b) 1.0 m x 0.3 m x 1.0 m","m³",1,null,{"$f":"G22*H22","v":0}]
[]
[{"$nulls":4},"(c) 1.0 m x 1.0 m x 1.0 m","m³",1,null,{"$f":"G24*H24","v":0}]
[]
[null,null,"C11.2.3.3",null,"Galvanized gabion mattresses :"]
[]
[{"$nulls":4},"(a) 0,3 m deep with 80 mm x 100 mm mesh and diaphragms at 1,0 m centres and 2,7 mm dia mesh wire","m³",50,null,{"$f":"G28*H28","v":0}]
[]
[{"$nulls":4},"(b) 0,5 m deep with 80 mm x 100 mm mesh and diaphragms at 1,0 m centres and 2,7 mm dia mesh wire","m³",5,null,{"$f":"G30*H30","v":0}]
[]
[null,"C11.2.4",null,null,"Geotextile (Synthetic filter membrane Grade 3)","m²",110,null,{"$f":"G32*H32","v":0}]
[null," Total Carried Forward To Summary",{"$nulls":6},{"$f":"SUM(I4:I32)","v":0}]

{"sheet":"C11.7","index":15,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[3,2,3,8],[23,2,23,8],[28,1,28,7]]}
[]
[null,"C11.7",null,null,"ROAD MARKINGS AND ROAD STUDS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C11.7.1","Road marking:"]
[null,null,"C11.7.1.1",null,"White Lines (broken or unbroken) 900 mm wide - RWY Works","km",7,null,{"$f":"H5*G5","v":0}]
[null,null,"C11.7.1.1",null,"Temporary White lines (broken or unbroken) 900 mm wide (at half normal application rate) - RWY Works","km",7,null,0]
[null,null,"C11.7.1.2",null,"Yellow lines (broken or unbroken) 150 mm wide - RWY Works","km","1.5",null,0]
[null,null,"C11.7.1.2",null,"Yellow lines (broken or unbroken) 150 mm wide - TWY Works","km",20,null,0]
[null,null,"C11.7.1.2",null,"Temporary Yellow Lines (150mm wide) (at half normal application rate) - TWY Works","km",5,null,0]
[null,null,"C11.7.1.2",null,"Yellow lines (broken or unbroken) 150 mm wide - GA Works","km",4,null,0]
[null,null,"C11.7.1.2",null,"Temporary Yellow Lines (150mm wide) (at half normal application rate) - GA Works","km",1,null,0]
[null,null,"C11.7.1.4",null,"White lettering and symbols - RWY Works","m²",200,null,0]
[null,null,"C11.7.1.4",null,"Temporary White lettering and symbols (at half normal application rate) - RWY Works","m²",200,null,0]
[null,null,"C11.7.1.4",null,"White lettering and symbols - TWY Works","m²",15,null,0]
[null,null,"C11.7.1.4",null,"Temporary White lettering and symbols (at half normal application rate) - TWY Works","m²",10,null,0]
[null,null,"C11.7.1.4",null,"White lettering and symbols - GA Works","m²",15,null,0]
[null,null,"C11.7.1.4",null,"Temporary White lettering and symbols (at half normal application rate) - GA Works","m²",10,null,0]
[null,null,"C11.7.1.7",null,"White solid (threshold, TDZ and aiming marks) - RWY Works","m²",5200,null,0]
[null,null,"C11.7.1.7",null,"Temporary White solid (threshold, TDZ and aiming marks) (at half normal application rate) - RWY Works","m²",5200,null,0]
[null,null,"C11.7.1.7",null,"Red solid paint for sign backgrounds (Permanent) - TWY Works","m²",80,null,0]
[null,null,"C11.7.1.7",null,"Temporary Red solid paint for sign backgrounds (at half normal application rate) - TWY Works","m²",80,null,0]
[null,null,"C11.7.1.7",null,"Red solid paint for sign backgrounds (Permanent) - GA Works","m²",5,null,0]
[null,null,"C11.7.1.7",null,"Temporary Red solid paint for sign backgrounds (at half normal application rate) - GA Works","m²",3,null,0]
[null,"C11.7.8","Setting out and premarking the lines (excluding traffic island markings, lettering and symbols)"]
[null,null,"C11.7.8.1",null,"Setting out and premarking for temporary roadmarking paint - RWY Works","km",50,null,{"$f":"H25*G25","v":0}]
[null,null,"C11.7.8.2",null,"Setting out and premarking for temporary roadmarking paint - TWY Works","km",7,null,{"$f":"H26*G26","v":0}]
[null,null,"C11.7.8.3",null,"Setting out and premarking for temporary roadmarking paint - GA Works","km",2,null,0]
[]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I5:I28)","v":0}]

{"sheet":"C11.9","index":16,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[3,2,3,8],[6,1,6,7]]}
[]
[null,"C11.9",null,null,"FINISHING THE ROAD AND ROAD RESERVE AND TREATING OLD ROADS"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C11.9.1","Finishing the road and road reserve:"]
[null,null,"C11.9.1.3",null,"Finishing and cleaning of the works: Runway at the end of each shift","Month",12,null,{"$f":"H5*G5","v":0}]
[]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I5)","v":0}]

{"sheet":"C20.1","index":17,"n_rows":11,"n_cols":9,"rows_kept":11,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[3,2,3,8],[10,1,10,7]]}
[]
[null,"C20.1",null,null,"TESTING MATERIALS AND JUDGEMENT OF WORKMANSHIP"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"C20.1.2","Special tests requested by the Engineer"]
[null,null,"C20.1.2.2","(a)","Other tests","prime cost (PC) sum",1,{"v":400000,"d":"R400,000.00"},{"$f":"H5*G5","v":{"v":400000,"d":"R400,000.00"}}]
[{"$nulls":3},"(i)","Handling costs and profit in respect of item C20.1.2.2(a)","%",{"$f":"H5","v":{"v":400000,"d":"400,000"}},null,0]
[null,null,"C20.1.5",null,"Financial Contribution by Contractor for an Independent Site Laboratory (to be a negative rate)","Month",12,null,{"$f":"IF(H7<0,G7*H7,-G7*H7)","v":0}]
[null,null,"PC20.1.6",null,"Payment of independent site laboratory by Employer"]
[null,null,"C20.1.6.1","(a)","Direct payment by contractor","prime cost (PC) sum",1,{"v":4500000,"d":"R4,500,000.00"},{"v":4500000,"d":"R4,500,000.00"}]
[{"$nulls":3},"(i)","Handling costs and profit in respect of item C20.1.2.2(a)","%",{"$f":"H9","v":{"v":4500000,"d":"4,500,000"}},null,{"$f":"H10*G10","v":0}]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(I5:I10)","v":{"v":4900000,"d":"R4,900,000.00"}}]

{"sheet":"Schedule B","index":18,"n_rows":6,"n_cols":9,"rows_kept":6,"merged":[[1,1,1,3],[1,4,1,8],[2,1,2,3],[5,1,5,7]]}
[]
[null,"A1",null,null,"TESTING MATERIALS AND JUDGEMENT OF WORKMANSHIP"]
[null,"ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[null,"A1",null,null,"Electrical Systems","Prov Sum",1,{"v":16284436.34,"d":"R16,284,436.34"},{"$f":"H4*G4","v":{"v":16284436.34,"d":"R16,284,436.34"}}]
[null,"A2",null,null,"Electrical Systems","%",{"$f":"I4","v":{"v":16284436.34,"d":"16,284,436"}},null,{"$f":"H5*G5","v":0}]
[null,"TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"I4+I5","v":{"v":16284436.34,"d":"R16,284,436.34"}}]