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

{"sheet":"INYANGA","index":0,"n_rows":60,"n_cols":10,"rows_kept":60}
["Section Number","Part Code","Item Number","Clause","Unit","Long Description","EstimatedQty","Rate","Value","SUB TOTALS"]
[1,"0102",1,"C1.2.1.1","months","Monitoring of compliance with and reporting on the EMP",{"v":4,"d":"4.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[1,"0102",2,"C1.2.2.4","Lump sum","Submission of a Full Contract Programme",{"v":1,"d":"1.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[1,"0102",3,"C1.2.2.6","months","Preparation and submission of all information and reports specified in the Contract Documentation, including reporting on local labour",{"v":4,"d":"4.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[1,"0102",4,"C1.2.4 (COTO)\nC1.2.3","months","Stakeholder Management and Liaison (CLO)",{"v":4,"d":"4.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[1,"0102",5,"C1.2.5.1","Lump sum","Health and safety plan",{"v":1,"d":"1.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[1,"0102",6,"C1.2.5.2","months","Implementation of health and safety plan",{"v":4,"d":"4.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[1,"0102",7,"PS.10","PC Sum","Survey and Setting out",{"v":27000,"d":"27,000.00"},{"v":1,"d":"R 1.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":27000,"d":"R 27,000.00"}},{"$f":"SUM(I2:I8)","v":{"v":27000,"d":"R 27,000.00"}}]
[1,"0103",1,"C1.3.1.1","Lump sum","Fixed obligations",{"v":100000,"d":"100,000.00"},{"v":1,"d":"R 1.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":100000,"d":"R 100,000.00"}}]
[1,"0103",2,"C1.3.1.3\nPS.11","months","Time-related obligations",{"v":4,"d":"4.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[1,"0103",3,"PS.17","sum","Submission of As-Built Data",{"v":1,"d":"1.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I9:I11)","v":{"v":100000,"d":"R 100,000.00"}}]
[2,"0106",1,"C1.6.1.1","ha","Clearing with machines and some hand labour where necessary",{"v":0.2,"d":"0.20"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(Table1[[#This Row],[Value]])","v":{"v":0,"d":"R 0.00"}}]
[3,"023A",1,"C2.3.9.1(a)","no","Raising manholes: \n(a) Sewer Concrete Ring manhole (Drawing ref 38570) - 1m Height",{"v":3,"d":"3.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[3,"023A",2,"C2.3.9.2(a)","no","Lowering manholes:\n(a) Sewer Concrete Ring manhole (Drawing ref 38570) - 1m Height",{"v":2,"d":"2.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I13:I14)","v":{"v":0,"d":"R 0.00"}}]
[3,"023B",1,"C2.3.21.1(a)","m","State for each water main the pipe material type, class, coupling type and the class of bedding etc.\n(a) State diameter(RiderMain)",{"v":400,"d":"400.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[3,"023B",2,"C2.3.23.1(a)","no","State for each water main valve the type, class etc.\n(a) State diameter",{"v":4,"d":"4.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[3,"023B",3,"C3.2.1.1(a)","m3","Excavation for culvert structures: in all material situated within the following depth ranges below the surface level:\n(a) 0 m to 1,5 m",{"v":365,"d":"365.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[3,"023B",4,"C3.2.2.2(a)","m3","Backfilling: Using imported selected material:\n(a) From commercial sources (State type)",{"v":365,"d":"365.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[3,"023B",5,"C2.3.29.1(e )","m3","Bedding using selected granular material:\n(e) From commercial sources - Clean Course River Sand",{"v":145,"d":"145.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I15:I19)","v":{"v":0,"d":"R 0.00"}}]
[4,"0303",1,"C3.3.2.1,","m","Prefabricated kerbing chanelling cast in-situ channeling / fillet:\nType B Barrier Kerb, fig. 6 with cast insitu channel / fillet, as per Drawing 38577 (Inclusive of transition kerbs)",{"v":710,"d":"710.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(Table1[[#This Row],[Value]])","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",1,"C3.2.1.1(a)","m3","Excavation for culvert structures: in all material situated within the following depth ranges below the surface level:(a) 0 m to 1,5 m",{"v":75,"d":"75.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",2,"C3.2.1.1(b)","m3","Excavation for culvert structures: in all material situated within the following depth ranges below the surface level:(b) Exceeding 1,5 m and up to 3,0 m",{"v":375,"d":"375.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",3,"C3.2.1.1(c )","m3","Excavation for culvert structures: in all material situated within the following depth ranges below the surface level:(c) Exceeding 3,0 m and up to 4,5 m",{"v":4,"d":"4.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",4,"C3.2.2.2(a)","m3","Backfilling: Using imported selected material:\n(a) From commercial sources (State type)",{"v":120,"d":"120.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",5,"C3.2.3.2","m","Concrete pipe culverts: Spigot and Socket: On Class B bedding (450mm diameter concrete Class 100D)",{"v":225,"d":"225.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",6,"C3.2.15.2","no","Manholes Type A with heavy duty concrete cover : Depth : Exceeding 1,5m and up to 2,5m",{"v":4,"d":"4.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",7,"C3.2.15.2","no","Manholes Type A with heavy duty concrete cover : Depth : Exceeding 2,5m and up to 3,5m",{"v":1,"d":"1.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",8,"C3.2.15.2","no","Inlet Type S2, heavy duty concrete cover: Depth : Exceeding 1,5m and up to 2,5m",{"v":7,"d":"7.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",9,"C3.2.15.2","no","Inlet Type S2, heavy duty concrete cover: Depth : Exceeding 2,5m and up to 3,5m",{"v":1,"d":"1.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",10,"C3.2.15.2","no","Inlet Type D3, heavy duty concrete cover: Depth : Exceeding 1,5m and up to 2,5m",{"v":2,"d":"2.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",11,"C3.2.15.2","no","Filled Inlet, heavy duty concrete cover: Depth : Exceeding 1,5m and up to 2,5m",{"v":1,"d":"1.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",12,"C3.2.9","no","Inlets and outlets to culverts: Headwalls, Type A, for 450mm  and 600mm pipes",{"v":2,"d":"2.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[5,"0302",13,"C3.2.24.1","m3","Compaction of bedding for inlets, outlets, manholes and catchpits: Preparation and compaction of in situ bedding material to 90 % of MDD (depth 150mm)",{"v":80,"d":"80.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I21:I33)","v":{"v":0,"d":"R 0.00"}}]
[6,"0402",1,"C4.2.3.1","m3","Excavating of materials in cuttings for use in the works, material obtained from: \nSoft excavation",{"v":305,"d":"305.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[6,"0402",2,"C1.7.1.1","m3","Loading from stockpile using machines and some hand labour where necessary",{"v":130,"d":"130.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[6,"0402",3,"C4.2.7.1","m3","Removal of unsuitable stable cut material to spoil: In layer thicknesses of 200 mm and less",{"v":355,"d":"355.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[6,"0402",4,"C4.2.5.1","m3","Excavating of materials in designated excavations, material obtained from:\nSoft excavation",{"v":125,"d":"125.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[6,"0402",5,"C4.2.9.1","m3","Excavate material to spoil in sites designated by the Contractor, material obtained from:\nSoft excavation, overburden and unsuitable material",{"v":130,"d":"130.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I34:I38)","v":{"v":0,"d":"R 0.00"}}]
[6,"0403",1,"C4.3.4.1(a)","m","Saw-cutting existing materials within the following average depth ranges:\nAsphalt:\n(a) Up to 50 mm",{"v":15,"d":"15.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[6,"0403",2,"C4.3.9.4","m3","Excavating material by using conventional road construction equipment: Natural gravel and sand materials",{"v":205,"d":"205.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[6,"0403",3,"C4.3.15.4","m3","Stockpiling of road layer materials: Natural gravel material",{"v":205,"d":"205.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I39:I41)","v":{"v":0,"d":"R 0.00"}}]
[6,"0404",1,"C4.4.2.1(g)","m3","Commercial materials identified by the Contractor from commercial, private or other non-commercial suppliers:\nPavement layer material: Type G7",{"v":710,"d":"710.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(Table1[[#This Row],[Value]])","v":{"v":0,"d":"R 0.00"}}]
[6,"0502",1,"C5.2.2.1(b)","m3","Fill construction: Normal fill material (G7) in compacted layer thicknesses of 200 mm and less:\n(b) Compacted to 93 % of MDD",{"v":710,"d":"710.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[6,"0502",2,"C5.2.2.1(b)","m3","Fill construction: Normal fill material (Recovered Gravel) Compacted to 93 % of MDD",{"v":205,"d":"205.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I43:I44)","v":{"v":0,"d":"R 0.00"}}]
[7,"0404",1,"C4.4.2.1(d )","m3","Commercial materials identified by the Contractor from commercial, private or other non-commercial suppliers:\nPavement layer material: Type G4",{"v":345,"d":"345.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[7,"0404",2,"C4.4.2.1(g )","m3","Commercial materials identified by the Contractor from commercial, private or other non-commercial suppliers \nPavement layer material: Type G7",{"v":1055,"d":"1,055.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[7,"0404",3,"C4.4.2.1(e )","m3","Commercial materials identified by the Contractor from commercial, private or other non-commercial suppliers:(for sidewalk)\nPavement layer material: Type G4",{"v":45,"d":"45.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I45:I47)","v":{"v":0,"d":"R 0.00"}}]
[7,"0501",1,"C5.1.1.2","m3","Roadbed construction and compaction to 95 % of MDD",{"v":1950,"d":"1,950.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[7,"0501",2,"C5.1.5.1","m3","In-place treatment of roadbed in hard material:\nby ripping",{"v":295,"d":"295.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I48:I49)","v":{"v":0,"d":"R 0.00"}}]
[7,"0503",1,"C5.3.2.1(k)","m3","Construction of layers: Upper subbase (G4) layer compacted to 98 % of MDD",{"v":345,"d":"345.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[7,"0503",2,"C5.3.2.1 (c )","m3","Construction of layers: Upper selected subgrade (G7) layer compacted to 95 % of MDD",{"v":1055,"d":"1,055.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[7,"0503",3,"C5.3.2.1(m)","m3","Construction of layers: Sidewalk selected layer (G4) compacted to 98 % of MDD",{"v":45,"d":"45.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I50:I52)","v":{"v":0,"d":"R 0.00"}}]
[7,"0901",1,"PS.C9.1.5.1(e )","t","New construction (paver laid) \n(a) Stone skeletal mix - continously graded (SA-S14) (40mm layer)",{"v":240,"d":"240.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[7,"0901",2,"C8.1.1.2","l","Prime coat: MC -30 cut-back bitumen. 0.6l/m2",{"v":1735,"d":"1,735.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[7,"0901",3,"C9.1.3.1","l","Application of bond coat: Stable –grade 30 % net bitumen emulsion as specified. Applied with a calibrated distributer",{"v":870,"d":"870.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}}]
[7,"0901",4,"C9.1.5.1 (e)","m2","New construction Sidewalks\n(a) Stone skeletal mix – continuously graded (SA-S7) (25mm layer)",{"v":430,"d":"430.00"},{"v":0,"d":"R 0.00"},{"$f":"+Table1[[#This Row],[EstimatedQty]]*Table1[[#This Row],[Rate]]","v":{"v":0,"d":"R 0.00"}},{"$f":"SUM(I53:I56)","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$nulls":9},{"$f":"SUM(J2:J56,J46,J44,J42,J40,J38,J33,J27,J22,J20,J18,J15)","v":{"v":127000,"d":"R 127,000.00"}}]
[{"$nulls":9},{"$f":"+J58*0.15","v":{"v":19050,"d":"R19,050.00"}}]
[{"$nulls":9},{"$f":"+J58+J59","v":{"v":146050,"d":"R 146,050.00"}}]