{"text_format":"3","workbook":"xls","n_sheets":26,"sheets":["00000","1200 ","1300","1400","1500","1600","1700","2100","2200","3100","3300","3400","4500","5100","5100 (SUB)","5100 SUB","5200 SUB","5200","5200 (SUB)","5600","5600 (SUB)","5600 SUB","5900","7300","8100","SUMMARY "],"not_rendered":{"charts":15,"external_links":3,"defined_names":40},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"00000","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"1200 ","index":1,"n_rows":73,"n_cols":8,"rows_kept":73,"merged":[[11,0,13,0],[31,2,31,3],[33,2,33,3],[35,1,35,3],[37,1,37,3],[39,1,39,3]],"flags":["formulas_cached_only"]}
["CLIENT:",null,null,"CONSTRUCTION OF MBONGWANA VIA DOTYE TO GREENVILLE HOSPITAL ACCESS ROAD"]
[]
["CONTRACT NO.:"]
[]
["CONTRACT NAME:",null,null,"CONSTRUCTION OF MBONGWANA VIA DOTYE TO GREENVILLE HOSPITAL ACCESS ROAD"]
[]
["SCHEDULE OF QUANTITIES"]
[]
["NB: ","TENDERERS MUST COMPLETE THE SCHEDULE OF QUANTITIES IN BLACK INK."]
[]
["SCHEDULE A: PRELIMINARY AND GENERAL",{"$nulls":6},"SECTION 1200"]
["ITEM                NO"]
[null,"DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[]
[{"$nulls":7},""]
[null,"GENERAL REQUIREMENTS AND PROVISIONS",{"$nulls":5},""]
[{"$nulls":7},""]
["B12.01","Protection, removal, realignment and"]
[null,"replacement of services"]
[]
[null,"(a)","Payment to the service providers to relocate"]
[null,null,"and/or protect their service",null,"Prov Sum",1,{"v":50000,"d":"50,000.00"},{"v":50000,"d":"50,000.00"}]
[]
[null,"(b)","Contractor's handling costs, profit and all "]
[null,null,"other charges in respect of subitem"]
[null,null,"B12.01(a) ",null,"%",{"v":50000,"d":"50,000"}]
[]
["B12.02","a)","Additional Survey required by Engineer",null,"Prov Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"50000.00"},{"v":50000,"d":"50,000.00"}]
[]
[null,"b) ","Provision for As-Built Drawings",null,"Prov Sum",{"v":1,"d":"1.00"},{"v":40000,"d":"40000.00"},{"v":40000,"d":"40,000.00"}]
[]
[null,"c)","Allow for Civil Engineering Student for the 4 months for R6000p/m",null,"Prov Sum",{"v":1,"d":"1.00"},{"v":36000,"d":"36000.00"},{"v":36000,"d":"36,000.00"}]
[]
[null,"d)","Contractor's handling costs, profit and all other charges in respect of subitem B12.02(a), (b) and ©",null,"Prov Sum",{"v":126000,"d":"126000.00"}]
[]
["B12.04","a) Allow for Accredited training of EPWP to be provided by a CETA accredited serviceprovider",null,null,"Prov. Sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[]
[null,"b) Allow for Supervision and Training of SMME's",null,null,"Prov. Sum",1,{"v":5000,"d":"5,000.00"},{"v":5000,"d":"5,000.00"}]
[]
[null,"Contractor's handling costs, profit and all other charges in respect of subitem B12.04(a) and (b)",null,null,"%",{"v":25000,"d":"25,000.00"}]
[]
["B12.32","Occupational Health and Safety"]
[]
[null,"(a)","Compliance with Occupational Health and "]
[null,null,"Safety Act (Act 85 of 1993) and its regulations"]
[null,null,"and with the Employers Healt and Safety"]
[null,null,"Specification",null,"Lump Sum",1]
[]
[null,"(b)","Compliance with Occupational Health and "]
[null,null,"Safety Act (Act 85 of 1993) and its regulations"]
[null,null,"and with the Employers Healt and Safety"]
[null,null,"Specification",null,"Months",6]
[]
["B12.31","Environmental Managemant"]
[]
[null,"(a)","Compliance with Environmental Management "]
[null,null,"plan",null,"Lump Sum",1]
[null,"(b)","Environmental Compliance Officer",null,"Month",6]
[]
[]
[1200,"TOTAL CARRIED TO SUMMARY"]
{"$rows_empty":11}
[{"$nulls":5},0]

{"sheet":"1300","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"merged":[[20,2,20,3],[26,2,26,3]],"flags":["formulas_cached_only"]}
["SCHEDULE A: PRELIMINARY AND GENERAL",{"$nulls":6},"SECTION 1300"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","BILL","RATE","TENDER"]
["NO",{"$nulls":4},"QUANTITY",null,"AMOUNT"]
[]
[{"$nulls":7},""]
[null,"CONTRACTOR'S ESTABLISHMENT ON SITE",{"$nulls":5},""]
[null,"AND GENERAL OBLIGATIONS",{"$nulls":5},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
["B13.01","The Contractor's general obligations:"]
[]
[null,"(a)","Fixed obligations",null,"lump",1]
[]
[null,"(b)","Value-related obligations",null,"lump",1]
[]
[null,"(c)","(i)  Contractor's Time-related obligations",null,"month",6]
[]
[null,"(d)","Allow 50000 for Engineers site telecom equipment",null,"P.Sum",1,{"v":50000,"d":"50,000.00"},{"v":50000,"d":"50,000.00"}]
[]
[null,"e)","Contractor's handling costs, profit and all ",null,"%",{"v":50000,"d":"50,000"}]
[null,null,"other charges in respect of subitem"]
[null,null,"B13.01(d) "]
[]
["B13.02","a)","Community Liason Officer (R5000 p/m including R500 airtime)",null,"P.Sum",1,{"v":33000,"d":"33,000.00"},{"v":33000,"d":"33,000.00"}]
[]
[null,"b)","PSC allowance per sitting per person",null,"P.Sum",1,{"v":10800,"d":"10,800.00"},{"v":10800,"d":"10,800.00"}]
[]
[null,"c)","Allowance for Instritutional support and developmet",null,"P.Sum",1,{"v":10000,"d":"10,000.00"},{"v":10000,"d":"10,000.00"}]
[]
[null,"d)","Allowance for Iengineering stdent @ R 6500 er month",null,"P.Sum",1,{"v":39000,"d":"39,000.00"},{"v":39000,"d":"39,000.00"}]
[]
[]
[]
[null,"c)","Contractor's handling costs, profit and all "]
[null,null,"other charges in respect of subitem",null,"%",{"v":92800,"d":"92,800"},{"v":0.1,"d":"10%"},{"v":9280,"d":"9,280.00"}]
[null,null,"B13.02(a), (b), c), (d) & e)"]
[]
[]
[]
[]
[{"$nulls":7},""]
{"$rows_empty":17}
[" 1300","TOTAL CARRIED TO SUMMARY"]

{"sheet":"1400","index":3,"n_rows":70,"n_cols":8,"rows_kept":70,"merged":[[25,1,25,3],[28,1,28,3]],"flags":["formulas_cached_only"]}
["SCHEDULE A: PRELIMINARY AND GENERAL",{"$nulls":6},"SECTION 1400"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","BILLED","RATE","TENDER"]
["NO",{"$nulls":4},"QUANTITY",null,"AMOUNT"]
[]
[{"$nulls":7},""]
[null,"HOUSING, OFFICES AND LABORATORIES",{"$nulls":5},""]
[null,"FOR THE ENGINEER'S SITE PERSONNEL",{"$nulls":5},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[" B14.03","Office and laboratory fittings, installations and"]
[null,"equipment:"]
[]
[null,"(b)","Prime-cost items and items paid for in a"]
[null,null,"lump sum:"]
[]
[null,null,"(viii)","Notice boards as specified","No.",{"v":2,"d":"2.00"}]
[]
["B14.12","Supply of Safety Equipment"]
[]
[null,"(a)","Safety Equipment as per specifications",null,"Sum",1]
[]
[]
[]
[null,"b) Fencing of Borrow Pit",null,null,"m",500]
[]
[]
[null,"c) Rehabilitation of Borrow Pit",null,null,"Sum",1]
{"$rows_empty":36}
["14.04","Car-ports                             "]
[{"$nulls":3},"(a) Car ports, as specified, at offices and laboratory buildings","number"]
[]
[]
[" 1400","TOTAL CARRIED TO SUMMARY"]

{"sheet":"1500","index":4,"n_rows":66,"n_cols":8,"rows_kept":66,"flags":["formulas_cached_only"]}
["SCHEDULE A: PRELIMINARY AND GENERAL",{"$nulls":6},"SECTION 1500"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","BILL","RATE","TENDER"]
["NO",{"$nulls":4},"QUANTITY",null,"AMOUNT"]
[]
[{"$nulls":7},""]
[null,"ACCOMMODATION OF TRAFFIC",{"$nulls":5},""]
[]
[" B15.01","Accommodation of traffic and maintaining "]
[null,"deviations",null,null,"km",{"v":1,"d":"1.0"}]
[]
["B15.03","Temporary traffic-control facilities"]
[]
[null,"(a)","Flagperson (LI)",null,"man-day",264]
[]
[null,"(b)","Portable STOP and GO-RY signs",null,"no",2]
[]
[null,"(e)","Road signs, R-and TR-series, 1200mm in",null,"no",2]
[null,null,"diameter"]
[]
[null,"(f)","Road signs, TW-series, 1524mm sides",null,"no",2]
[]
[null,"(h)","Delinators TW401-and TW402 series,"]
[null,null,"1000mm x 250mm"]
[]
[null,null,"(i)","Single sided","no",5]
[]
[null,null,"(ii)","Double sided","no",5]
[]
[null,"(j)","Traffic cones 450mm",null,"no",5]
{"$rows_empty":34}
[" 1500","TOTAL CARRIED TO SUMMARY"]

{"sheet":"1600","index":5,"n_rows":59,"n_cols":8,"rows_kept":59,"merged":[[9,1,9,3]],"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":6},"SECTION 1600"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","BILL","RATE","TENDER"]
["NO",{"$nulls":4},"QUANTITY",null,"AMOUNT"]
[]
[{"$nulls":7},""]
[null,"OVERHAUL",{"$nulls":5},""]
[]
[16.02,"Overhaul on material hauled in excess of 1.0km (ordinary haul)",null,null,"m3-km",{"v":7800,"d":"7800.0"}]
{"$rows_empty":36}
[{"$nulls":7},""]
{"$rows_empty":11}
[" 1700","TOTAL CARRIED TO SUMMARY"]

{"sheet":"1700","index":6,"n_rows":59,"n_cols":8,"rows_kept":59,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":6},"SECTION 1700"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","BILL","RATE","TENDER"]
["NO",{"$nulls":4},"QUANTITY",null,"AMOUNT"]
[]
[{"$nulls":7},""]
[null,"CLEARING AND GRUBBING",{"$nulls":5},""]
[]
[17.01,"Clearing and grubbing",null,null,"ha",3.6]
[]
[null,"Dismantling and Reconstruction of existing"]
[null,"fences"]
[]
[null,"(i)","reconstruction of existing fences affected by ",null,"m",{"v":300,"d":"300.0"}]
[null,null,"construction"]
{"$rows_empty":30}
[{"$nulls":7},""]
{"$rows_empty":11}
[" 1700","TOTAL CARRIED TO SUMMARY"]

{"sheet":"2100","index":7,"n_rows":48,"n_cols":10,"rows_kept":48,"merged":[[30,2,30,3]],"flags":["formulas_cached_only"]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":6},"SECTION 2100"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},""]
[null,"DRAINS",{"$nulls":5},""]
[{"$nulls":7},""]
[21.01,"Excavation of open drains"]
[]
[null,"(a)","Excavating soft material situated within the following"]
[null,null,"depth ranges below the surface level"]
[{"$nulls":8},6630]
[null,null,"(i) 0m up to 1,5m",null,"m³",4680,null,null,11.05]
[]
[null,"(b)","Extra over subitem B21.01(a) for excavation in hard"]
[null,null," material irrespective of depth",null,"m³",150]
[]
[21.02,"Clearing and shaping existing open drains",null,null,"m³",200]
[]
[null,"Clearing and shaping side and mitre drains by ",null,null,"m",100]
[null,"grader"]
[]
[21.06,"Natural permeable material in subsoil drainage systems"]
[null,"(crushed stone):"]
[{"$nulls":9},1.2]
[null,"b)","Crushed stone obtained from commercial sources ",null,"m3",30,{"$nulls":3},600]
[null,null,"(19mm)",{"$nulls":6},0.6]
[{"$nulls":9},432]
[null,"c)","Dump rock in waterlogged areas (650mm roadwidth,2m deep)",null,"m3",3250]
{"$rows_empty":7}
[{"$nulls":8},37.5]
{"$rows_empty":8}
[2100,"TOTAL CARRIED TO SUMMARY"]

{"sheet":"2200","index":8,"n_rows":51,"n_cols":10,"rows_kept":51,"flags":["formulas_cached_only"]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":6},"SECTION 2200"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},""]
[null,"PREFABRICATED CULVERTS",{"$nulls":5},""]
[{"$nulls":7},""]
["22.01","Excavation:",{"$nulls":5},""]
[" ",{"$nulls":6},""]
[null,"(a)","Excavating soft material situated within the"]
[null,null,"following depth ranges below the surface "]
[null,null,"level:",{"$nulls":5},6630]
[{"$nulls":8},11.05]
[null,null,"(i)","0 m up to 1,5 m(LI)","m³",{"v":202.5,"d":"202.50"}]
[]
[null,null,"(ii)","Exceeding 1,5 m and up to 3,0 m","m³",{"v":51,"d":"51.00"}]
[]
[null,"(b)","Extra over subitem 22.01(a) for excavation "]
[null,null,"in hard material, irrespective of depth",null,"m³",{"v":51,"d":"51.00"}]
[]
[" 22.02","Backfilling:"]
[]
[null,"(a)","Using the excavated material (LI)",null,"m³",{"v":14,"d":"14.00"}]
[]
[null,"(b)","Using imported selected material (LI)",null,"m³",{"v":5,"d":"5.00"},{"$nulls":3},1.2]
[{"$nulls":9},600]
[null,"(c)","Extra over subitems 22.02(a) and (b) for soil",{"$nulls":6},0.6]
[null,null,"cement backfilling containing 2% cement*",null,"m³",{"v":0.5,"d":"0.50"},{"$nulls":3},432]
[]
[" 22.03","Precast Concrete culverts:"]
[]
[null,"(b)","On class B bedding:"]
[]
[null,null,"(i)","Type SC 100D-load pipes with "]
[{"$nulls":3},"ogee joints:"]
[]
[{"$nulls":3},"(i)     600mm dia","m",{"v":60,"d":"60.00"}]
[]
[{"$nulls":3},"(iii)     900mm dia","m",{"v":15,"d":"15.00"},null,null,33.6]
[]
[22.17,"Cast insitu concrete Inlet  and outlet headwall structures",{"$nulls":6},172.5]
[]
[null,"(a)","allow R90 000 for subcontracting of Headwalls",null,"P.Sum",{"v":1,"d":"1.00"},90000,{"v":90000,"d":"90,000.00"}]
[null,null,"to local SMMEs"]
[]
[null,"b)","allow for profits and attandance",null,1,90000]
[]
[]
[" 2200","TOTAL CARRIED TO SUMMARY"]

{"sheet":"3100","index":9,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[33,1,33,3]],"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":6},"SECTION 3100"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","BILL","RATE","TENDER"]
["NO",{"$nulls":4},"QUANTITY",null,"AMOUNT"]
[]
[]
[null,"FINISHING OFF BORROW AREAS HAUL ROADS"]
[]
[]
[31.03]
[" ","Finishing off borrow arears in:"]
[]
[null,"(a)","Hard Material",null,"ha",30]
[]
[null,"(b)     Inermediate Material",null,null,"ha",45]
[]
[null,"(c)","Soft Material",null,"ha",80]

{"sheet":"3300","index":10,"n_rows":50,"n_cols":10,"rows_kept":50,"merged":[[20,1,20,3]],"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":6},"SECTION 3300"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","BILL","RATE","TENDER"]
["NO",{"$nulls":4},"QUANTITY",null,"AMOUNT"]
[]
[]
[null,"MASS EARTHWORKS"]
[]
[null,"BORROW MATERIALS"]
[]
[33.01,"Cut and borrow to fill "]
[" ","including all haul"]
[]
[null,"(a)","Material in compacted layer thicknesses"]
[null,null,"of 150 mm and less:"]
[]
[null,null,"(i)","Insitu Compacted to 90% of modified"]
[{"$nulls":3},"AASHTO density","m³",{"v":3900,"d":"3,900"}]
[]
[33.03,"Extra over items 33.01 and for excavation and"]
[null,"breaking down material in:"]
[]
[null,null,"(a)","Intermediate excavation","m³",490]
[]
[null,null,"(b)","Hard Excavation","m³",165]
[]
[null,null,"(c)","Boulder excavatiom - class A","m³",60]
[]
[33.04,"Cut to spoil, including free-haul up to 0.5 km."]
[null,"Material obtained from:"]
[]
[null,"(a)","Soft Excavation",null,"m³",300]
[]
[null,"(b)","Intermediate excavation",null,"m³",75]
[]
[null,"(c) ","Hard Excavation",null,"m³",100]
[]
[33.07,"Removal of unsuitable material (including"]
[null,"free-haul of 0.5km)",null,null,"m³",220]
[]
[" 33.10","Roadbed preparation and the compaction of "]
[null,"material:"]
[]
[null,"(a)","Compaction to 93% of modified ",{"$nulls":6},3450]
[null,null,"AASHTO density",null,"m³",4370]
[]
[]
[]
[" 3300"," Carried forward"]

{"sheet":"3400","index":11,"n_rows":65,"n_cols":16,"rows_kept":65,"merged":[[14,2,14,3],[24,1,24,3],[28,1,28,3],[33,1,33,3],[35,1,35,3],[37,1,37,3],[38,1,38,3]],"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":6},"SECTION 3400"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","BILLED","RATE","TENDER"]
["NO",{"$nulls":4},"QTY",null,"AMOUNT"]
[]
[{"$nulls":7},""]
[null,"PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$nulls":5},""]
[{"$nulls":7},""]
[" "]
["34.01","Pavement layers constructed from gravel "]
[null,"obtained from approved borrowpit, including "]
[null,"unlimited free-haul:",{"$nulls":12},0]
[{"$nulls":14},0]
[null,"(h)","Gravel Wearing Courses (G6 and G5) layer compacted to:",{"$nulls":11},0]
[{"$nulls":14},0,{"v":0.1,"d":"10%"}]
[null,null,"(i)","96% of modified AASHTO density for a",{"$nulls":11},"."]
[{"$nulls":3},"compacted layer thickness of 150 mm","m³",0]
[null,null,"(ii)","98% of modified AASHTO density for a",{"$nulls":10},0]
[{"$nulls":3},"compacted layer thickness of 150mm G6 gravel","m³",4000]
[]
[null,null,"(iii)","98% of modified AASHTO density for a compacted layer thickness of 150mm G5 gravel","m³",3500]
[]
[]
[null,"(iv) 4% Cement stabilization of selected layers in steep areas ",null,null,"m³",160]
[]
[]
[]
[34.02,"Extra over items 34.01 and for excavation and"]
[null,"breaking down material in:"]
[]
[null,null,"(a)","Intermediate excavation","m³",600]
[]
[null,"CONCRETE SURFACING"]
[]
[null,"a) 500m long Concrete Slab - 35MPa, 5m wide, 150mm with Mesh Ref 645",null,null,"m³",375]
[]
[]
[null,"b) Mesh Ref 617",null,null,"m2",{"v":3750,"d":"3,750"}]
{"$rows_empty":25}
[3400,"TOTAL CARRIED TO SUMMARY"]

{"sheet":"4500","index":12,"n_rows":56,"n_cols":8,"rows_kept":56,"hidden":true,"merged":[[1,0,3,0],[1,1,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[8,1,8,3],[25,1,25,3]],"flags":["formulas_cached_only"]}
[]
["Item","Description",null,null,"Unit","Quantity","Rate","Amount"]
[]
[]
[]
[4500,"DOUBLE SEALS"]
[]
[]
[45.01,"Double seal (Grade 1 aggregate, 80/100 penetration grade):"]
[null,"bitumen binder"]
[null,"(a)","Using 13.2mm and 6.7mm aggregate ",null,"m²",6000,60,{"v":360000,"d":"360,000.00"}]
[]
[45.02,"Bitumen binder variations"]
[]
[null,"(i)","80/100 penetration grade",null,"litre",200,2.3,459.99999999999994]
[]
[45.03,"Aggregate variations (Grade 1) "]
[]
[null,"(a)","13.2mm aggregate",null,"m3",180,162,29160]
[]
[null,"(c )","6.7mm aggregate",null,"m3",100,162,16200]
[]
[45.04,"Application of fog spray consisting of:"]
[null,"(b)","30% spray-grade emulsion",null,"l",5600,8,{"v":44800,"d":"44,800.00"}]
[]
[45.05,"Precoating the aggregate at a rate of 12 litre/m3 (Sacresote ",null,null,"m3"]
[null,"70 or similar)"]
[]
[45.06,"Addition of wetting agent:"]
[]
[null,"(a) ","Providing and supplying",null,"L. Sum",1,null,"RATE"]
[]
[null,"(b)","Handling, applying, profit and all other costs",null,"%"]
{"$rows_empty":21}
[{"$nulls":3},""]
[4500,"TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"v":0,"d":"0.00"}]

{"sheet":"5100","index":13,"n_rows":84,"n_cols":9,"rows_kept":84,"hidden":true,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":4},"SECTION 5100"]
[]
["ITEM  ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
["5100 LI","PITCHING, STONEWORK AND PROTECTION AGAINST "]
[null,"EROSION"]
[]
[51.01,"Stone Pitching"]
[]
[null,"(b)  Grouted Stone Pitching","p.sum",1,250000,{"v":250000,"d":"250,000.00"},{"v":232000,"d":"232,000.00"}]
[]
[null,"Allow for handling cost","%",{"v":250000,"d":"250,000.00"},{"v":0.1,"d":"10%"},{"v":25000,"d":"25,000.00"}]
[]
[]
[]
[{"$nulls":6},{"v":605270,"d":"605,270.00"}]
{"$rows_empty":51}
[5100,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"v":275000,"d":"275,000.00"}]
{"$rows_empty":15}
[null,"The tenderer shall add 15% of the subtotal for VAT………………………………………………………………………………………………………………………………………...…",{"$nulls":6},0]

{"sheet":"5100 (SUB)","index":14,"n_rows":83,"n_cols":9,"rows_kept":83,"hidden":true,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":4},"SECTION 5100"]
[]
["ITEM  ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
["5100 LI","PITCHING, STONEWORK AND PROTECTION AGAINST "]
[null,"EROSION"]
[]
[51.01,"Stone Pitching"]
[]
[null,"(a) Allow a provisional sum of R 235 000 for the construction","Prov. Sum",1,235000,{"v":235000,"d":"235,000.00"}]
[null,"    of grouted stone pitching to be done by a Local Grade -1 "]
[null,"    Sub-Contractor nominated by the client."]
[]
[null,"(b) Allow for Handling Fee ","%",235000,{"v":0.1,"d":"10%"},23500]
{"$rows_empty":52}
[5100,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"v":258500,"d":"258,500.00"}]
{"$rows_empty":15}
[null,"The tenderer shall add 15% of the subtotal for VAT………………………………………………………………………………………………………………………………………...…",{"$nulls":6},0]

{"sheet":"5100 SUB","index":15,"n_rows":57,"n_cols":9,"rows_kept":57,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":4},"SECTION 5100"]
[]
["ITEM  ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
["5100 LI","PITCHING, STONEWORK AND PROTECTION AGAINST "]
[null,"EROSION"]
[]
[51.01,"Stone Pitching"]
[]
[null,"(a) Lining of Side Drains - 25MPa concrete, 150mm thick, Ref 193 mesh","m³",70]
{"$rows_empty":8}
[{"$nulls":8},{"v":250000,"d":"R250,000.00"}]
{"$rows_empty":21}
[5100,"TOTAL CARRIED TO SUMMARY"]
{"$rows_empty":15}
[null,"The tenderer shall add 15% of the subtotal for VAT………………………………………………………………………………………………………………………………………...…",{"$nulls":6},0]

{"sheet":"5200 SUB","index":16,"n_rows":45,"n_cols":6,"rows_kept":45,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":4},"SECTION 5200"]
[]
["ITEM  ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
["5200 LI","GABIONS"]
[]
[null,"a) Preparation for Gabions","m2",900]
[]
[]
[null,"b) Supply and install PVC coated gabion boxes (1m x 1m x 1m)","m³",300]
[]
[null,"c) Supply and install coated gabion mattresses (0,3 deep)","m³",100]
[]
[]
[null,"d) Subsurface drain - 500m","m",500]
{"$rows_empty":29}
[5100,"TOTAL CARRIED TO SUMMARY"]

{"sheet":"5200","index":17,"n_rows":54,"n_cols":8,"rows_kept":54,"hidden":true,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":4},"SECTION 5200"]
[]
["ITEM  ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
["5200 LI","GABIONS"]
[]
[null,"Foundation trench excavation and backfilling"]
[]
[null,"a)In solid Rock","m3",100,100,10000]
[]
[null,"In all other classes of material","m3",400,95,38000]
[]
["52.02","Surface preparation for bedding the gabions","m2",250,105,26250]
[]
["52.03","Gabions"]
[]
[null,"a)Galvanised gabion boxes 1 x 1 x 1m","m3",150,650,97500]
[]
[null,"b) Galvanised gabion mattreses","m3",150,350,52500]
[]
[null,"Filter Fabric","m2",2000,38,76000]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},72]
{"$rows_empty":25}
[5100,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"v":300250,"d":"300,250.00"}]

{"sheet":"5200 (SUB)","index":18,"n_rows":60,"n_cols":6,"rows_kept":60,"hidden":true,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":4},"SECTION 5100"]
[]
["ITEM  ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
["5200 LI","GABIONS"]
[]
["52.02","(a) Allow a provisional sum of R479050 for the construction","Prov. Sum",1,479050,{"v":479050,"d":"479,050.00"}]
[null,"    of gabions to be done by a Local Grade -1 "]
[null,"    Sub-Contractor nominated by the client."]
[]
[null,"(b) Allow for Handling Fee ","%",479050,{"v":0.1,"d":"10%"},47905]
{"$rows_empty":48}
[5100,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"v":526955,"d":"526,955.00"}]

{"sheet":"5600","index":19,"n_rows":71,"n_cols":8,"rows_kept":71,"hidden":true,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":6},"SECTION 5600"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},""]
[5600,"ROAD SIGNS",{"$nulls":5},""]
[{"$nulls":7},""]
[56.01,"Road sign boards faces with painted or ",{"$nulls":5},""]
[null,"coloured background. Symbols, lettering and ",{"$nulls":5},""]
[null,"borders in engineering-grade retroreflective",{"$nulls":5},""]
[null,"material, where the sign board is constructed "]
[null,"from:"]
[]
[null,"(c)","Sheet steel (Chromadek, 1,6 mm thick): ",{"$nulls":4},""]
[{"$nulls":7},""]
[null,null,"(1)","Area not exceeding 2 m²","m²",{"v":15,"d":"15.00"},{"v":750,"d":"750.00"},{"v":11250,"d":"11,250.00"}]
[]
[null,null,"(2)","Area exceeding 2 m² but not exceeding  "]
[{"$nulls":3},"10 m²","m²",{"v":5,"d":"5.00"},{"v":1250,"d":"1250.00"},{"v":6250,"d":"6,250.00"}]
[]
[]
[56.02,"Extra over item 56.01 for using:"]
[]
[null,"(a)","Background retro-reflective material of:"]
[]
[null,null,"(1)","Engineering grade","m²",{"v":5,"d":"5.00"},{"v":1500,"d":"1500.00"},{"v":7500,"d":"7,500.00"}]
[]
[56.03,"Road sign supports (overhead road sign "]
[null,"structures excluded) "]
[]
[null,"(a)","75 mm diameter steel tubing with wall "]
[null,null,"thickness of 2 mm ",null,"ton",{"v":1,"d":"1.0"},{"v":25000,"d":"25,000.00"},{"v":25000,"d":"25,000.00"}]
[]
["56.05LI","Excavation and backfilling for road sign ",{"$nulls":5},""]
[null,"supports (not applicable to kilometre posts)",null,null,"m³",{"v":30,"d":"30.00"},{"v":150,"d":"150.00"},{"v":4500,"d":"4,500.00"}]
[]
[]
["56.06LI","Extra over item 56.05L for cement-treated soil"]
[null,"backfill",null,null,"m³",{"v":4,"d":"4.00"},{"v":130,"d":"130.00"},{"v":520,"d":"520.00"}]
[]
[]
[{"$nulls":7},""]
[{"$nulls":7},""]
{"$rows_empty":19}
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[]
[{"$nulls":7},""]
[]
[5600,"TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"v":55020,"d":"55,020.00"}]

{"sheet":"5600 (SUB)","index":20,"n_rows":65,"n_cols":6,"rows_kept":65,"hidden":true,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":4},"SECTION 5600"]
[]
[]
["ITEM",null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},""]
[5600,"ROAD SIGNS",{"$nulls":3},""]
[{"$nulls":5},""]
[56.01,"(a) Allow a provisional sum of R 58 864,00 for the installation of Road Signs","Prov. Sum",1,58864,{"v":58864,"d":"58,864.00"}]
[null," of to be done by a Local Grade -1 "]
[null," Sub-Contractor nominated by the client."]
[]
[null,"(b) Allow for Handling Fee ","%",58864,{"v":0.1,"d":"10%"},5886.400000000001]
{"$rows_empty":44}
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[]
[{"$nulls":5},""]
[]
[5600,{"$nulls":4},{"v":64750.4,"d":"64,750.40"}]

{"sheet":"5600 SUB","index":21,"n_rows":60,"n_cols":7,"rows_kept":60,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":5},"SECTION 5600"]
[]
[]
["ITEM","DESCRIPTION",null,"UNIT","QTY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":6},""]
[5600,"ROAD SIGNS",{"$nulls":4},""]
[{"$nulls":6},""]
[56.01,"Road sign boards faces with painted or ",{"$nulls":4},""]
[null,"coloured background. Symbols, lettering and ",{"$nulls":4},""]
[null,"borders in engineering-grade retroreflective",{"$nulls":4},""]
[null,"material, where the sign board is constructed "]
[null,"from:"]
[]
[null,"a) Allow for subcontracting of the roadsigns to a local SMME  ",null,"P.Sum",1,65000,65000]
[null,"to the value of R60 000"]
[]
[null,"b) Allow for profits, handling cost and attandacce for the ",null,"%",65000]
[null,"above item"]
{"$rows_empty":13}
[{"$nulls":6},""]
{"$rows_empty":19}
[{"$nulls":6},""]
[]
[]
[]
[]
[]
[5600,"TOTAL CARRIED TO SUMMARY"]

{"sheet":"5900","index":22,"n_rows":64,"n_cols":8,"rows_kept":64,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":6},"SECTION 5900"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},""]
[null,"FINISHING THE ROAD AND ROAD RESERVE",{"$nulls":5},""]
[null,"AND TREATING OLD ROADS",{"$nulls":5},""]
[{"$nulls":7},""]
[]
[]
["59.01","Finishing the road and road reserve:"]
[]
[null,"(b)","Single-carriageway road",null,"m",5200]
{"$rows_empty":48}
[5900,"TOTAL CARRIED TO SUMMARY"]

{"sheet":"7300","index":23,"n_rows":35,"n_cols":8,"rows_kept":35,"hidden":true,"merged":[[11,1,11,3]],"flags":["formulas_cached_only"]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":6},"SECTION 7300"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},""]
[null,"CONCRETE BLOCK PAVING FOR ROADS",{"$nulls":5},""]
[{"$nulls":7},""]
["73.01LI","Concrete block paving:",{"$nulls":5},""]
[{"$nulls":7},""]
[null,"(a) 60mm interlocking concrete paving blocks, on 25mm sand bedding",null,null,"m²",{"v":9300,"d":"9,300"},{"v":170,"d":"170.00"},{"v":1581000,"d":"1,581,000.00"}]
[{"$nulls":7},""]
[{"$nulls":7},""]
["73.03L","Provision of approved herbicide and",{"$nulls":5},""]
[null," ant poison:",{"$nulls":5},""]
[{"$nulls":7},""]
[null,"(a) Provision of materials",null,null,"P.C.Sum",{"v":1,"d":"1.00"},{"v":30000,"d":"30000.00"},{"v":30000,"d":"30,000.00"}]
[{"$nulls":7},""]
[null,"(b) Contractor's charges and profit added",{"$nulls":5},""]
[null," to the Prime Cost Sum",null,null,"%",{"v":30000,"d":"30000.00"},{"v":0.1,"d":"10%"},{"v":3000,"d":"3,000.00"}]
{"$rows_empty":7}
[{"$nulls":7},""]
[]
[]
[{"$nulls":7},""]
[{"$nulls":7},""]
[]
[7300,"TOTAL CARRIED TO SUMMARY                 ",{"$nulls":5},{"v":0,"d":"0.00"}]

{"sheet":"8100","index":24,"n_rows":65,"n_cols":8,"rows_kept":65,"flags":["formulas_cached_only"]}
["SCHEDULE B: ROAD WORKS",{"$nulls":6},"SECTION 8100"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},""]
[null,"TESTING MATERIALS AND WORKMANSHIP",{"$nulls":5},""]
[{"$nulls":7},""]
[]
[{"$nulls":7},""]
["B81.04","Additional tests required by the Engineer"]
[{"$nulls":7},""]
[null,"(a)","Prime Cost Sum for additional tests"]
[null,null,"required by Engineer",null,"Prov Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"50000.00"},{"v":50000,"d":"50,000.00"}]
[]
[null,"(b)","Contractor's handling costs, profit and all"]
[null,null,"other charges in respect of subitems "]
[null,null,"B81.02(a)",null,"%",{"v":50000,"d":"50,000.00"}]
{"$rows_empty":45}
[" 8100","TOTAL CARRIED TO SUMMARY"]

{"sheet":"SUMMARY ","index":25,"n_rows":56,"n_cols":15,"rows_kept":56,"flags":["formulas_cached_only"]}
[null,"CLIENT:",null,"WINNIE MADIKIZELA-MANDELA LOCAL MUNICIPALITY"]
[]
[null,"CONTRACT NO.:"]
[]
[null,"CONTRACT NAME:",null,"CONSTRUCTION OF MBONGWANA VIA DOTYE TO GREENVILLE HOSPITAL ACCESS ROAD"]
[]
[null,"SUMMARY OF SCHEDULE OF QUANTITIES AND CALCULATION OF TENDER SUM"]
[]
[null,"SCHEDULE A: PRELIMINARY AND GENERAL"]
[{"$nulls":7},"TENDER"]
[null,"SECTION 1200",null,"GENERAL PROVISIONS AND REQUIREMENTS"]
[]
[null,"SECTION 1300",null,"CONTRACTORS ESTABLISHMENT ON SITE AND "]
[{"$nulls":3},"GENERAL OBLIGATIONS"]
[]
[null,"SECTION 1400",null,"HOUSING, OFFICES AND LABORATORIES FOR THE"]
[null,1400,null,"HOUSING, OFFICES AND LABORATORIES FOR THE"]
[{"$nulls":3},"ENGINEER'S SITE PERSONNEL …………………………………………………………………………………………………...."]
[]
[{"$nulls":3},"ENGINEER'S SITE PERSONNEL"]
[]
[null,"SECTION 1500",null,"ACCOMMODATION OF TRAFFIC"]
[]
[null,"SECTION 1600",null,"OVERHAUL"]
[]
[null,"SECTION 1700",null,"CLEARING AND GRUBBING"]
[]
[null,"SECTION 2100",null,"DRAINS"]
[]
[null,"SECTION 2200",null,"PREFABRICATED CULVERTS"]
[]
[null,"SECTION 3100",null,"FINISHING OFF BORROW AREAS HAUL ROADS"]
[]
[null,"SECTION 3300",null,"MASS EARTHWORKS"]
[]
[null,"SECTION 3400",null,"PAVEMENT LAYERS OF GRAVEL MATERIAL"]
[]
[null,"SECTION 5100",null,"PITCHING, STONEWORK AND PROTECTION AGAINST "]
[]
[null,"SECTION 5200",null,"GABIONS"]
[]
[null,"SECTION 5600",null,"ROAD SIGNS",{"$nulls":10},{"v":995500,"d":"R995,500.00"}]
[]
[null,"SECTION 5900",null,"FINISHING THE ROAD AND ROAD RESERVE"]
[]
[null,"SECTION 8100",null,"TESTING MATERIALS AND WORKMANSHIP"]
[]
[null,"Sub Total -A"]
[]
[null,"Add 10% Contigencies"]
[]
[null,"Direct Construction Cost"]
[]
[null,"ADD AT @ 15%"]
[]
[null,"TOTAL CARRIED FORWARD TO FORM OF OFFER"]