{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Main BOQ","Summary"],"not_rendered":{"external_links":11,"defined_names":183},"read":"whole","date_system":"1900"}

{"sheet":"Main BOQ","index":0,"n_rows":1284,"n_cols":14,"rows_kept":1284,"merged":[[2,4,2,5],[14,6,19,6],[14,7,19,7],[14,8,19,8],[14,9,19,9],[14,10,19,10],[14,11,19,11],[64,4,64,5],[131,4,131,5],[198,4,198,5],[407,2,407,3],[411,2,411,3],[475,2,475,3],[479,2,479,3],[481,9,481,11],[485,9,485,11],[550,2,550,3],[672,6,672,7],[830,4,830,5],[898,4,898,5],[965,4,965,5],[1126,4,1126,5],[1225,2,1227,2],[1228,2,1230,2],[1231,2,1233,2],[1234,2,1236,2],[1237,2,1239,2],[1240,2,1242,2],[1243,2,1245,2],[1246,2,1248,2],[1249,2,1251,2],[1252,2,1254,2],[1255,2,1257,2],[1258,2,1260,2],[1261,2,1263,2],[1264,2,1266,2],[1267,2,1269,2],[1270,2,1272,2],[1273,2,1274,2],[1275,0,1276,1],[1275,2,1276,2],[1277,0,1278,1],[1277,2,1278,2],[1279,0,1280,1],[1279,2,1280,2],[1281,0,1282,1],[1281,2,1282,2]]}
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 1300"]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT","PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C8)),NOT(ISNUMBER($D8))),\"Rate only\",$D8*E8)","v":0}]
[null,"CONTRACTOR'S ESTABLISHMENT ON SITE",{"$nulls":3},0]
[null,"AND GENERAL OBLIGATIONS",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["B13.01","The contractor's general obligations:",{"$nulls":3},0]
[{"$nulls":6},1,null,{"$f":"G15+H15","v":{"v":1,"d":"1.00"}},{"$f":"F15*G15","v":0},{"$f":"F15*H15","v":0},{"$f":"J15+K15","v":0}]
[null,"(a) Fixed obligations","Lump Sum",1,null,{"$f":"E16*D16","v":0}]
[]
[null,"(b) Value-related obligations","Lump Sum",1,null,{"$f":"E18*D18","v":0}]
[]
[null,"© Time-related obligations","month",1,null,0]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C21)),NOT(ISNUMBER($D21))),\"Rate only\",$D21*E21)","v":0},{"$nulls":7},{"v":7349737.1355,"d":"R7,349,737.14"}]
[{"$nulls":5},0]
[null,"(e) Monthly Safety Audit by the Client","PC Sum",1,null,0,null,{"$f":"F23","v":{"v":0,"d":"0.00"}},{"$f":"F23","v":{"v":0,"d":"0.00"}},0,{"$f":"D23*E23","v":0},{"$f":"J23+K23","v":0}]
[{"$nulls":5},0]
[null,"(f) Handling costs and profit in respect",{"$nulls":3},{"$f":"IF(AND(NOT(ISBLANK($C25)),NOT(ISNUMBER($D25))),\"Rate only\",$D25*E25)","v":0}]
[null,"of subitem B13.01(e) above","%",0.1,null,0,null,{"$f":"F26","v":{"v":0,"d":"0.00"}},{"$f":"F26","v":{"v":0,"d":"0.00"}},0,{"$f":"H26","v":0},{"$f":"I26","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0,{"$nulls":7},{"$f":"N21-F59","v":{"v":7349737.1355,"d":"R7,349,737.14"}}]
{"$rows_empty":26}
[" 1300","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F16:F26)","v":0},{"$nulls":3},{"$f":"SUM(J15:J57)","v":0},{"$f":"SUM(K15:K57)","v":0},{"$f":"SUM(L15:L57)","v":0}]
[]
[]
[]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 1500"]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT","PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C70)),NOT(ISNUMBER($D70))),\"Rate only\",$D70*E70)","v":0}]
[null,"ACCOMMODATION OF TRAFFIC",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["B15.01","Accommodating traffic and maintaining ",{"$nulls":3},0]
[" ","temporary deviations",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"(a) On all roads","Lump Sum",1,null,0,0.00631313131313131,{"v":0,"d":"0.0000"},{"v":0,"d":"0.00"},{"$f":"E78*G78","v":0},null,{"$f":"J78+K78","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
{"$rows_empty":33}
[" 1500","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F70:F126)","v":0},{"$nulls":3},{"$f":"SUM(J71:J125)","v":0},{"$f":"SUM(K71:K125)","v":0},{"$f":"SUM(L71:L125)","v":0}]
[]
[]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 1500"]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT","PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C137)),NOT(ISNUMBER($D137))),\"Rate only\",$D137*E137)","v":0}]
[null,"OVERHAUL",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["B16.02","Overhaul on material hauled in excess of "]
[" ","10,0 km (ordinary overhaul)","m³-km",{"v":1,"d":"1.0"},null,{"$f":"IF(AND(NOT(ISBLANK($C143)),NOT(ISNUMBER($D143))),\"Rate only\",$D143*E143)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
{"$rows_empty":41}
[1600,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F137:F193)","v":0}]
[]
[]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 1700"]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT","PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C204)),NOT(ISNUMBER($D204))),\"Rate only\",$D204*E204)","v":0}]
[null,"CLEARING AND GRUBBING",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[]
["B17.07","Clearing and cleaning of existing surfaced "]
[null,"roads"]
[]
[null,"(a) Manual labour (6 man team) plus tools","Hr",{"v":1,"d":"1.00"},null,{"$f":"E213*D213","v":0},270,null,{"$f":"G213+H213","v":{"v":270,"d":"270.000"}},{"$f":"E213*G213","v":0},{"$f":"E213*H213","v":0},{"$f":"J213+K213","v":0}]
[]
[null,"(b) 6 m³ Tipper truck","Hr",{"$f":"D213","v":{"v":1,"d":"1.00"}},null,{"$f":"E215*D215","v":0},45,null,{"$f":"G215+H215","v":{"v":45,"d":"45.000"}},{"$f":"E215*G215","v":0},{"$f":"E215*H215","v":0},{"$f":"J215+K215","v":0}]
[]
[]
["B17.07","Dump site charges for spoil of all excavated ","m³",{"v":1,"d":"1.00"},null,{"$f":"E218*D218","v":0},48.54,null,{"$f":"G218+H218","v":{"v":48.54,"d":"48.540"}},{"$f":"E218*G218","v":0},{"$f":"E218*H218","v":0},{"$f":"J218+K218","v":0}]
[null,"material at a suitable dump site identified by "]
[null,"the Engineer ."]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
{"$rows_empty":7}
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
{"$rows_empty":25}
[1700,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F203:F260)","v":0},{"$nulls":3},{"$f":"SUM(J204:J259)","v":0},{"$f":"SUM(K204:K259)","v":0},{"$f":"SUM(L205:L259)","v":0}]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT","PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C267)),NOT(ISNUMBER($D267))),\"Rate only\",$D267*E267)","v":0}]
[null,"DRAINS",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[]
[21.01,"Excavation for open drains:"]
[]
[]
[null,"(a)  Excavating soft material situated within the ",{"$nulls":3},{"$f":"E276*D276","v":0},270,null,{"$f":"G276+H276","v":{"v":270,"d":"270.000"}},{"$f":"E276*G276","v":0},{"$f":"E276*H276","v":0},{"$f":"J276+K276","v":0}]
[null,"     following depth ranges below the surface level:"]
[null," (I) 0m up to 1,5m","m³",{"v":1,"d":"1.00"},null,{"$f":"E278*D278","v":0},45,null,{"$f":"G278+H278","v":{"v":45,"d":"45.000"}},{"$f":"E278*G278","v":0},{"$f":"E278*H278","v":0},{"$f":"J278+K278","v":0}]
[]
[]
[null,"(b)Extra over subitem 21.01(a) for excavation ","m³",{"v":1,"d":"1.00"},null,{"$f":"E281*D281","v":0},48.54,null,{"$f":"G281+H281","v":{"v":48.54,"d":"48.540"}},{"$f":"E281*G281","v":0},{"$f":"E281*H281","v":0},{"$f":"J281+K281","v":0}]
[null,"in hard material, irrespective of depth"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C284)),NOT(ISNUMBER($D284))),\"Rate only\",$D284*E284)","v":0}]
[21.19,"Selected backfill material under concrete lined side drains",{"$nulls":3},0]
[null,"compacted to 93% of modified AASHTO density","m³",1,null,{"$f":"E286*D286","v":0}]
{"$rows_empty":7}
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C294)),NOT(ISNUMBER($D294))),\"Rate only\",$D294*E294)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
{"$rows_empty":27}
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C326)),NOT(ISNUMBER($D326))),\"Rate only\",$D326*E326)","v":0}]
[]
[2100,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F266:F327)","v":0},{"$nulls":3},{"$f":"SUM(J267:J326)","v":0},{"$f":"SUM(K267:K326)","v":0},{"$f":"SUM(L268:L326)","v":0}]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT","PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C334)),NOT(ISNUMBER($D334))),\"Rate only\",$D334*E334)","v":0}]
[null,"PREFABRICATED CULVERTS",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[]
[22.17,"Manholes, catchpits, precast inlets and outlet structures"]
[null,"complete:"]
[]
[null,"(b) Catch Pits",{"$nulls":3},{"$f":"E343*D343","v":0},270,null,{"$f":"G343+H343","v":{"v":270,"d":"270.000"}},{"$f":"E343*G343","v":0},{"$f":"E343*H343","v":0},{"$f":"J343+K343","v":0}]
[]
[null,"(i)Grid inlet (3m long)","No",{"v":1,"d":"1.00"},null,{"$f":"E345*D345","v":0},45,null,{"$f":"G345+H345","v":{"v":45,"d":"45.000"}},{"$f":"E345*G345","v":0},{"$f":"E345*H345","v":0},{"$f":"J345+K345","v":0}]
[]
[]
[null,"(e)Extra over or less than subitem 22.17 (b) for variations","m",{"v":1,"d":"1.00"},null,{"$f":"E348*D348","v":0},48.54,null,{"$f":"G348+H348","v":{"v":48.54,"d":"48.540"}},{"$f":"E348*G348","v":0},{"$f":"E348*H348","v":0},{"$f":"J348+K348","v":0}]
[null,"in depths of catchpits from the standard depth"]
[null,"designated for construction purposes as per drawings"]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C351)),NOT(ISNUMBER($D351))),\"Rate only\",$D351*E351)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[22.1,"Steel Reinforcements:"]
[]
[null,"(a)High Tensile Steel Bars","t",1]
[{"$nulls":5},{"$f":"E358*D358","v":0}]
[null,"©Welded Steel Fabric ","kg",1]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C361)),NOT(ISNUMBER($D361))),\"Rate only\",$D361*E361)","v":0}]
[22.21,"Accessories",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"(a)Inlet Grids including Frames","No",1]
[{"$nulls":5},0]
[22.26,"Hand Excavation to determine the positions of existing"]
[null,"services","m³",1,null,{"$f":"E367*D367","v":0}]
[]
[]
["B22.27","Reconstruction of existing structures ","P/sum",1,null,{"$f":"E370*D370","v":0}]
{"$rows_empty":22}
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C393)),NOT(ISNUMBER($D393))),\"Rate only\",$D393*E393)","v":0}]
[{"$nulls":5},0]
[]
[2200,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F333:F395)","v":0},{"$nulls":3},{"$f":"SUM(J334:J394)","v":0},{"$f":"SUM(K334:K394)","v":0},{"$f":"SUM(L335:L394)","v":0}]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C402)),NOT(ISNUMBER($D402))),\"Rate only\",$D402*E402)","v":0},"PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
[null,"CONCRETE KERBING, CONCRETE",{"$nulls":3},0]
[null,"CHANNELLING, CHUTES AND DOWNPIPES,",{"$nulls":3},0]
[null,"AND CONCRETE LININGS FOR OPEN DRAINS",{"$nulls":3},0]
[]
[]
[23.01,"Concrete Kerbing"]
[]
[null,"(a) Prefabricated mountable kerb, SABS 927 "]
[null,"as shown on the drawings",{"$nulls":3},{"$f":"E411*D411","v":0}]
[]
[null,"(iii) Fig 8c-Mountable Kerbs ","m",1,null,{"$f":"E413*D413","v":0}]
[{"$nulls":3},{"$f":"D411","v":{"v":0,"d":"0.00"}},null,null,270,null,{"$f":"G414+H414","v":{"v":270,"d":"270.000"}},{"$f":"E479*G414","v":0},{"$f":"E479*H414","v":0},{"$f":"J414+K414","v":0}]
[]
[23.08,"Concrete lining for open drains ",{"$nulls":4},45,null,{"$f":"G416+H416","v":{"v":45,"d":"45.000"}},{"$f":"E482*G416","v":0},{"$f":"E482*H416","v":0},{"$f":"J416+K416","v":0}]
[]
[null,"(a) Cast in situ concrete-25MPa/19mm for standard side "]
[null,"drains","m³",1,null,{"$f":"E419*D419","v":0},48.54,null,{"$f":"G419+H419","v":{"v":48.54,"d":"48.540"}},{"$f":"E485*G419","v":0},{"$f":"E485*H419","v":0},{"$f":"J419+K419","v":0}]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C420)),NOT(ISNUMBER($D420))),\"Rate only\",$D420*E420)","v":0}]
[23.09,"Formwork to cast in situ concrete lining for "]
[null,"open drains (class F2 surface finish):"]
[]
[null,"(a) To sides with formwork on both internal and"]
[null,"external faces (each face measured)","m²",1,null,{"$f":"E425*D425","v":0}]
[{"$nulls":5},{"$f":"E426*D426","v":0}]
[]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C429)),NOT(ISNUMBER($D429))),\"Rate only\",$D429*E429)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[{"$nulls":5},{"$f":"E435*D435","v":0}]
{"$rows_empty":26}
[2300,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F401:F461)","v":0}]
[]
[]
[{"$nulls":9},{"$f":"SUM(J405:J463)","v":0},{"$f":"SUM(K405:K463)","v":0},{"$f":"SUM(L406:L463)","v":0}]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C470)),NOT(ISNUMBER($D470))),\"Rate only\",$D470*E470)","v":0}]
[null,"MASS EARTHWORKS",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0,"ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY"]
[{"$nulls":6},"NO"]
[]
[33.01,"Cut and borrow to fill,including free -haul up to 0.5km"]
[null,"complete:",{"$nulls":5},"MASS EARTHWORKS"]
[]
[null,"(a)Material in compacted layer thickness of 150mm and less",{"$nulls":3},{"$f":"E479*D479","v":0}]
[]
[{"$nulls":5},{"$f":"E482*D482","v":0}]
[null,"(i)Compaction to 93% of modified AASHTO density ","m³",{"v":1,"d":"1.00"},null,null,33.01,null,null,"Cut and borrow to fill,including free -haul up to 0.5km"]
[{"$nulls":9},"complete:"]
[33.03,"Extra over item 33.01 for excavating and breaking"]
[null,"down material in.",{"$nulls":5},"     ","(a)","Material in compacted layer thickness of 150mm"]
[{"$nulls":9},"     and less"]
[null,"(a)intermediate excavation","m³",1,{"$nulls":7},{"$f":"L485","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C488)),NOT(ISNUMBER($D488))),\"Rate only\",$D488*E488)","v":0},null,null,"(i)","Compaction to 93% of modified AASHTO density ","m³"]
[null,"(b)Hard excavation","m³",1]
[{"$nulls":6},33.03,null,null,"Extra over item 33.01 for excavating and breaking","m",{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[33.04,"Cut to spoil, including free-haul up to 0,5 km.",{"$nulls":7},"down material in."]
[null,"Material obtained from:"]
[{"$nulls":8},"(a)","intermediate excavation","m³"]
[null,"(a)Soft excavation","m³",1,null,{"$f":"E494*D494","v":0}]
[{"$nulls":8},"(b)","Hard excavation","m³"]
[33.1,"Roadbed preparation and the compaction of material:"]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C497)),NOT(ISNUMBER($D497))),\"Rate only\",$D497*E497)","v":0},33.04,null,null,"Cut to spoil, including free-haul up to 0,5 km."]
[null,"(a)Compaction to 90% of modified AASHTO density ","m³",1,null,0,{"$nulls":3},"Material obtained from:"]
[{"$nulls":5},0]
[33.13,"Finishing-off cut and fill slopes,medians and ",{"$nulls":3},0,null,null,"(a)","Soft excavation","m³"]
[null,"interchange areas",{"$nulls":3},0]
[{"$nulls":6},33.1,null,null,"Roadbed preparation and the compaction of material:"]
[null,"(a)services","m²",1,null,{"$f":"E503*D503","v":0}]
[{"$nulls":8},"(a)","Compaction to 90% of modified AASHTO density ","m³"]
[]
[{"$nulls":6},33.13,null,null,"Finishing-off cut and fill slopes,medians and "]
[{"$nulls":9},"interchange areas"]
[]
[{"$nulls":8},"(a)","services","m²"]
{"$rows_empty":20}
[3300,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F469:F529)","v":0}]
[]
[]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 3900",3300,"TOTAL CARRIED TO SUMMARY"]
[]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT","SCHEDULE A : ROAD CONSTRUCTION"]
["NO"]
[{"$nulls":6},"PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C541)),NOT(ISNUMBER($D541))),\"Rate only\",$D541*E541)","v":0}]
[null,"PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[]
[34.01,"Pavement layers constructed from gravel"]
[null,"taken from cut or borrow including free-haul"]
[null,"up to 1,0 km:"]
[null,"     ",{"$nulls":3},{"$f":"E550*D550","v":0}]
[null,"(d) Gravel subbase ( Chemically stabilized gravel material)"]
[null,"compacted layer thickness of 150mm",{"$nulls":3},{"$f":"E552*D554","v":0}]
[]
[null,"(i) 93% of modified AASHTO density for a","m³",1]
[null,"compacted layer thickness of 150 mm"]
[]
[null,"(f) Gravel base ( chemically stabilized gravel material)",{"$nulls":3},{"$f":"IF(AND(NOT(ISBLANK($C557)),NOT(ISNUMBER($D557))),\"Rate only\",$D557*E557)","v":0}]
[null,"compacted to:",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"(i) 97% of modified AASHTO density for a"]
[null,"compacted layer thickness of 150 mm","m³",1,null,{"$f":"E561*D561","v":0}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C568)),NOT(ISNUMBER($D568))),\"Rate only\",$D568*E568)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
{"$rows_empty":26}
[3400,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F540:F597)","v":0}]
[]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C605)),NOT(ISNUMBER($D605))),\"Rate only\",$D605*E605)","v":0}]
[null,"STABILIZATION ",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[{"$nulls":6},"PREV.    QTY","PRESENT QTY","TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
[35.01,"Chemical stabilization extra over unstabalized"]
[null,"compacted layers:"]
[]
[null,"     ",{"$nulls":3},{"$f":"E614*D614","v":0}]
[null,"(e)Gravel subbase, 150mm thick","m³",1]
[{"$nulls":5},{"$f":"E616*D616","v":0}]
[35.02,"Chemical stabilizing agent"]
[]
[null,"(a)Ordinary portland cement","t",{"v":1,"d":"1.00"},null,{"$f":"E619*D619","v":0},124.8,{"v":0,"d":"0.000"},null,{"$f":"E842*G619","v":0},{"$f":"E842*H619","v":0},{"$f":"J619+K619","v":0}]
[]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C622)),NOT(ISNUMBER($D622))),\"Rate only\",$D622*E622)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
{"$rows_empty":7}
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C632)),NOT(ISNUMBER($D632))),\"Rate only\",$D632*E632)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
{"$rows_empty":27}
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C664)),NOT(ISNUMBER($D664))),\"Rate only\",$D664*E664)","v":0}]
[]
[3500,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F604:F665)","v":0}]
[]
[{"$nulls":5},"SECTION 3800"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":6},"SECTION 3800"]
[]
[{"$nulls":9},{"$f":"SUM(J613:J672)","v":0},{"$f":"SUM(K613:K672)","v":0},{"$f":"SUM(L613:L672)","v":0}]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},{"$f":"IF(AND(NOT(ISBLANK($E678)),NOT(ISNUMBER($F678))),\"Rate only\",$F678*G678)","v":0}]
[null,"BREAKING UP EXISTING PAVEMENT LAYERS",{"$nulls":5},0]
[{"$nulls":7},0]
[{"$nulls":7},0,"TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
[]
[]
[]
["B38.02","Milling out existing bituminous material with "]
[null,"an average milling depth:"]
[]
[null,"(a) Not exceeding 30mm ","m³",1,null,null,{"v":1200,"d":"1,200.00"},0]
[{"$nulls":7},0,{"$f":"G781+H781","v":1067.04},{"$f":"E909*G781","v":0},{"$f":"E909*H781","v":0},{"$f":"J689+K689","v":0}]
[null,"(b) Exceeding 30 mm but not exceeding 60mm","m³",1,null,null,{"v":1600,"d":"1,600.00"},0]
[{"$nulls":7},0]
[null,"(c) Exceeding 60 mm","m³",1,null,null,{"v":1900,"d":"1,900.00"},0,{"$f":"G784+H784","v":{"v":0,"d":"0.00"}},{"$f":"E912*G784","v":0},{"$f":"E912*H784","v":0},{"$f":"J692+K692","v":0}]
[{"$nulls":7},0]
{"$rows_empty":18}
[{"$nulls":8},{"$f":"G804+H804","v":{"v":1,"d":"1.00"}},{"$f":"E932*G804","v":0},{"$f":"E932*H804","v":0},{"$f":"J712+K712","v":0}]
[]
[{"$nulls":7},0]
{"$rows_empty":27}
[{"$nulls":9},{"$f":"SUM(J684:J740)","v":0},{"$f":"SUM(K684:K740)","v":0},{"$f":"SUM(L684:L740)","v":0}]
[]
[]
[]
[]
[]
[{"$nulls":8},"TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[{"$nulls":7},0,null,{"$f":"E980*G852","v":0},{"$f":"E980*H852","v":0},{"$f":"J760+K760","v":0}]
[]
[3800,"TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H677:H761)","v":0}]
[]
[]
[]
[null,"PATCHING AND REPAIRING EDGE BREAKS"]
[]
[]
["B39.02","Excavation in existing pavements for",{"$nulls":7},{"$f":"E989*G861","v":0},{"$f":"E989*H861","v":0},{"$f":"J769+K769","v":0}]
[null,"patching in:"]
[]
[null,"(a)Asphalt layers","m³",1,null,{"$f":"E772*D772","v":0}]
[{"$nulls":6},"PREV.    QTY","PRESENT QTY"]
[]
[]
["39.05","Cutting back the edges of the existing "]
[null,"surfacing for the repairing of edge breaks","m",1,null,{"$f":"E777*D777","v":0}]
[]
[]
[]
[{"$nulls":6},1067.04]
[]
[]
[{"$nulls":7},{"v":0,"d":"0.000"}]
{"$rows_empty":19}
[{"$nulls":6},{"$f":"D932","v":{"v":1,"d":"1.0"}}]
[]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C807)),NOT(ISNUMBER($D807))),\"Rate only\",$D807*E807)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0,{"$nulls":3},{"$f":"SUM(J757:J808)","v":0},{"$f":"SUM(K757:K808)","v":0},{"$f":"SUM(L757:L808)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[]
[]
[]
[{"$nulls":8},"TOTAL QTY","PREV.    Amount","PRESENT Amount","TOTAL AMOUNT"]
{"$rows_empty":7}
["3900","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F764:F825)","v":0}]
[]
[]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 4100"]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C836)),NOT(ISNUMBER($D836))),\"Rate only\",$D836*E836)","v":0}]
[null,"PRIME COAT",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[" 41.01","Prime coat:",{"$nulls":3},0,"PREV.    QTY","PRESENT QTY",{"$f":"G932+H932","v":{"$error":"#REF!"}},{"$f":"#REF!*G932","v":{"$error":"#REF!"}},{"$f":"#REF!*H932","v":{"$error":"#REF!"}},{"$f":"J840+K840","v":{"$error":"#REF!"}}]
[{"$nulls":5},0]
[null,"(c)MC-30 cut-back bitumen @ 0.8 l/m²","litre",1,null,0]
[{"$nulls":5},0,null,null,{"$f":"G935+H935","v":{"v":0,"d":"0.00"}},{"$f":"E1153*G935","v":0},{"$f":"E1153*H935","v":0},{"$f":"J843+K843","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[]
[{"$nulls":6},{"$f":"D980","v":1}]
{"$rows_empty":8}
[{"$nulls":6},0.5,0]
{"$rows_empty":13}
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0,{"$nulls":3},{"$f":"SUM(J836:J875)","v":{"$error":"#REF!"}},{"$f":"SUM(K836:K875)","v":{"$error":"#REF!"}},{"$f":"SUM(L836:L875)","v":{"$error":"#REF!"}}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[]
[]
[]
[]
[" 4100","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F835:F893)","v":0}]
[]
[]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 4200"]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C904)),NOT(ISNUMBER($D904))),\"Rate only\",$D904*E904)","v":0}]
[null,"ASPHALT BASE AND SURFACING",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["42.04","Tack coat of 30% stable-grade emulsion   ","litre",1,null,{"$f":"D909*E909","v":0}]
[{"$nulls":5},0,"PREV.    QTY","PRESENT QTY"]
[{"$nulls":5},0]
["42.08","100 mm cores in asphalt paving          ","No",1,null,{"$f":"D912*E912","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
["42.10","Asphalt layer constructed for rehabilitation",{"$nulls":3},0]
[null,"purposes in accordance with the provisions",{"$nulls":3},0]
[null,"of subsubclause 4213(f)(i):",{"$nulls":3},0]
[]
[null,"(b)Surfacing or overlay constructed with new ",{"$nulls":3},0]
[null,"asphalt, medium grade, 50/70 pen bitumen",{"$nulls":3},0]
[{"$nulls":5},0]
[]
[null,"(iii)Continuously graded - 40mm thick","t",1,null,{"$f":"D923*E923","v":0}]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C924)),NOT(ISNUMBER($D924))),\"Rate only\",$D924*E924)","v":0}]
[{"$nulls":5},0]
["B42.11","Asphalt layer constructed for rehabilitation ",{"$nulls":3},0]
[null,"purposes in accordance with the provisions",{"$nulls":3},0]
[null,"of subsubclauses 4213(f)(ii) or 4213(f)(iii):",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"(a)Base constructed with new asphalt,",{"$nulls":3},0]
[null,"continuously grades (26.5 mm aggregage "]
[null,"size) using 50/70 penetration grade bitumen","t",{"v":1,"d":"1.0"},null,{"$f":"D932*E932","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C933)),NOT(ISNUMBER($D933))),\"Rate only\",$D933*E933)","v":0}]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C934)),NOT(ISNUMBER($D934))),\"Rate only\",$D934*E934)","v":0}]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C935)),NOT(ISNUMBER($D935))),\"Rate only\",$D935*E935)","v":0},null,{"$f":"D1153","v":0}]
[{"$nulls":5},0]
["B42.20","Backfilling of excavation for patching with:",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"(a) Asphalt base","t",1,null,{"$f":"D939*E939","v":0}]
[{"$nulls":5},0]
{"$rows_empty":21}
[" 4200","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F903:F961)","v":0}]
[]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 5700"]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C971)),NOT(ISNUMBER($D971))),\"Rate only\",$D971*E971)","v":0}]
[null,"ROAD MARKINGS",{"$nulls":3},0]
[{"$nulls":5},0]
["57.02","Retro-reflective road marking paint:",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"(a)White lines (broken or unbroken):","km",1,null,0]
[{"$nulls":5},0]
[null,"(i)100 mm wide","km",1,null,0]
[{"$nulls":5},0]
[null,"(d)White lettering and symbols","m²",1,null,{"$f":"E980*D980","v":0}]
[{"$nulls":5},0]
[]
["57.04","Variations in rate of application:"]
[]
[null,"(a)White paint","litre",1,null,{"$f":"E985*D985","v":0}]
[]
[57.06,"Setting out and pre-marking the lines "]
[null,"(excluding traffic-island markings, lettering "]
[null,"and symbols)","km",1,null,{"$f":"E989*D989","v":0}]
{"$rows_empty":41}
[" 5700",{"$nulls":4},{"$f":"SUM(F972:F1023)","v":0}]
[]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C1038)),NOT(ISNUMBER($D1038))),\"Rate only\",$D1038*E1038)","v":0}]
[null,"CONCRETE BLOCK PAVING ",{"$nulls":3},0]
[{"$nulls":5},0]
[73.01,"concrete block paving ",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"(b)80mm thick, Interlocking Block paving @ intersections","m²",1,null,0]
[{"$nulls":5},0]
[73.02,"Cast in situ concrete edge and intermediate beams","m³",1,null,0]
[{"$nulls":5},0]
[73.03,"Provision of approved herbicide and ant poison",{"$nulls":3},{"$f":"E1047*D1047","v":0}]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C1048)),NOT(ISNUMBER($D1048))),\"Rate only\",$D1048*E1048)","v":0}]
[null,"(a)Provision of material ","P/sum",1]
[]
[null,"(c)Contractor's charges and profit added to the "]
[null,"prime cost","%",1,null,{"$f":"E1052*D1052","v":0}]
[]
["B73,05","Removal of old kerbs ","No",1,null,{"$f":"E1054*D1054","v":0}]
[]
[{"$nulls":5},{"$f":"E1056*D1056","v":0}]
{"$rows_empty":63}
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C1120)),NOT(ISNUMBER($D1120))),\"Rate only\",$D1120*E1120)","v":0}]
[]
[7300,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F1037:F1121)","v":0}]
[]
[]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":4},"SECTION 11000"]
[]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":5},{"$f":"IF(AND(NOT(ISBLANK($C1132)),NOT(ISNUMBER($D1132))),\"Rate only\",$D1132*E1132)","v":0}]
[null,"MISCELLANEOUS ACTION",{"$nulls":3},0]
[{"$nulls":5},0]
["B110.01","Raising of manholes ",{"$nulls":3},{"$f":"IF(AND(NOT(ISBLANK($C1136)),NOT(ISNUMBER($D1136))),\"Rate only\",$D1136*E1135)","v":0}]
[null,null,"m",1]
[null,"Supply and install cast iron manhole covers with a ",{"$nulls":3},0]
[null,"lift of 30mm. The rate shall include full ",{"$nulls":3},0]
[null,"compensation for supplying and installing ",{"$nulls":3},0]
[null,"the collar. ",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"The collar shall be fixed to the existing manhole",{"$nulls":3},0]
[null," with a rapid setting steel to steel epoxy.",{"$nulls":3},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["B110.02","Traffic calming devices:",{"$nulls":3},0]
[{"$nulls":5},0]
[null,"Asphalt speed humps complete as","m",1,null,0]
[null," detailed, to suit road width.",{"$nulls":3},0]
[{"$nulls":5},0]
[]
[]
[{"$nulls":5},{"$f":"E1153*D1153","v":0}]
{"$rows_empty":58}
[11000,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F1131:F1211)","v":0}]
[]
[]
[]
[]
["Lesedi Rehab"]
["DEPARTMENT OF ROADS AND STORMWATER"]
[]
["CONTRACT NUMBER: "]
[]
[]
["SCHEDULE A : ROADWORKS"]
[]
[]
[1300,"CONTRACTOR'S ESTABLISHMENT ON SITE AND "]
[null,"GENERAL OBLIGATIONS "]
[]
[1500,"ACCOMMODATION OF TRAFFIC "]
[]
[]
[1600,"OVERHAUL"]
[]
[]
[1700,"CLEARING AND GRUBBING "]
[]
[]
[2100,"DRAINS"]
[]
[]
[2200,"PREFABRICATED CULVERTS"]
[]
[]
[2300,"CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND"]
[null,"DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS "]
[]
[3300,"MASS EARTHWORKS"]
[]
[]
[3400,"PAVEMENT LAYERS OF GRAVEL MATERIAL "]
[]
[]
[3500,"STABILIZATIONS "]
[]
[]
[3800,"BREAKING UP EXISTING PAVEMENT LAYERS"]
[]
[]
[3900,"PATCHING AND REPAIRING EDGE BREAKS"]
[]
[]
[4100,"PRIME COAT"]
[]
[]
[4200,"ASPHALT BASE AND SURFACING"]
[]
[]
[5700,"ROAD MARKINGS"]
[]
[]
[7300,"CONCRETE BLOCK PAVING"]
[]
[]
[11000,"MISCELLANEOUS ACTION"]
[]
["SUBTOTAL BILL/SCHEDULE A            "]
[]
["10% CONTINGENCY "]
[]
["SUB-TOTAL B "]
[]
["VAT"]
[]
["TOTAL with VAT"]

{"sheet":"Summary","index":1,"n_rows":15,"n_cols":4,"rows_kept":15}
["Summary",null,null,"Amount"]
[]
["Apsey",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Roshini",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Loveday",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Strydom",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Bindon",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Vygie",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Bailey",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["TOTAL",null,null,{"$f":"SUM(D3:D9)","v":{"$error":"#REF!"}}]
[]
[]
["SIGNATURE OF THE BIDDER:_____________________"]
[]
["DATE:_________________________"]