{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["1200..","1300.. ","1500..","1800","2100","2300","3300","3400","3500","5600","5700","5800","7300","8100..","Summary"],"not_rendered":{"defined_names":40},"read":"whole","date_system":"1900"}

{"sheet":"1200..","index":0,"n_rows":75,"n_cols":9,"rows_kept":75,"merged":[[14,1,14,3]]}
[]
["EMPLOYER",null,":","Ikhala TVET College"]
[]
["CONTRACT NO",null,":"]
[]
["FOR"]
[]
["CONTRACT TITLE",null,":","IKHALA TVET COLLEGE"]
[{"$nulls":3},"INTERSECTION UPGRADE"]
[]
["SCHEDULE OF QUANTITIES"]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 1200"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G18=\"Prov\",H18=\"Sum\"),(H18=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G18*H18),\"\",IF(G18*H18=0,\"\",ROUND(G18*H18,2))))","v":""}]
[null,"GENERAL REQUIREMENTS AND PROVISIONS",{"$nulls":6},{"$f":"IF(OR(AND(G19=\"Prov\",H19=\"Sum\"),(H19=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G19*H19),\"\",IF(G19*H19=0,\"\",ROUND(G19*H19,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G20=\"Prov\",H20=\"Sum\"),(H20=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G20*H20),\"\",IF(G20*H20=0,\"\",ROUND(G20*H20,2))))","v":""}]
[]
["B12.01","Occupational Health and Safety Act Administration",{"$nulls":6},{"$f":"IF(OR(AND(G22=\"Prov\",H22=\"Sum\"),(H22=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G22*H22),\"\",IF(G22*H22=0,\"\",ROUND(G22*H22,2))))","v":""}]
[]
[null,"(a)","Contractor's initial obligations in terms of the",{"$nulls":5},{"$f":"IF(OR(AND(G24=\"Prov\",H24=\"Sum\"),(H24=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G24*H24),\"\",IF(G24*H24=0,\"\",ROUND(G24*H24,2))))","v":""}]
[null,null,"Occupational Health and Safety Act and"]
[null,null,"Construction Regulations",null,null,"Lump Sum",{"v":1,"d":"1.00"},{"v":20000,"d":"R 20,000.00"},{"$f":"IF(OR(AND(G26=\"Prov\",H26=\"Sum\"),(H26=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G26*H26),\"\",IF(G26*H26=0,\"\",ROUND(G26*H26,2))))","v":{"v":20000,"d":"R 20,000.00"}}]
[]
[null,"(b)","Contractor's Time related Obligations in terms of the"]
[null,null,"Occupational Health and Safety Act, Construction ",{"$nulls":5},{"$f":"IF(OR(AND(G29=\"Prov\",H29=\"Sum\"),(H29=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G29*H29),\"\",IF(G29*H29=0,\"\",ROUND(G29*H29,2))))","v":""}]
[null,null,"Regulations and requirements",null,null,"month",{"v":3,"d":"3.00"},{"v":15000,"d":"R 15,000.00"},{"$f":"G30*H30","v":{"v":45000,"d":"R 45,000.00"}}]
[]
[null,"(c) ","Submission and approval of Health and Safety File",null,null,"Lump Sum",{"v":1,"d":"1.00"},"-","Included"]
[]
["B12.02","Provision for a Community Liaison Officer (CLO)",{"$nulls":6},{"$f":"IF(OR(AND(G34=\"Prov\",H34=\"Sum\"),(H34=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G34*H34),\"\",IF(G34*H34=0,\"\",ROUND(G34*H34,2))))","v":""}]
[]
[null,"(a)","Payment of one CLO (R5500/month plus R250"]
[null,null,"cellphone and talktime, plus R250 for transport, "]
[null,null,"total = R6000/CLO/month)",null,null,"month",{"v":3,"d":"3.00"},{"v":6000,"d":"R 6,000.00"},{"$f":"IF(OR(AND(G38=\"Prov\",H38=\"Sum\"),(H38=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G38*H38),\"\",IF(G38*H38=0,\"\",ROUND(G38*H38,2))))","v":{"v":18000,"d":"R 18,000.00"}}]
[{"$nulls":8},{"$f":"IF(OR(AND(G39=\"Prov\",H39=\"Sum\"),(H39=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G39*H39),\"\",IF(G39*H39=0,\"\",ROUND(G39*H39,2))))","v":""}]
[null,"(b)","Handling costs and profit in respect of "]
[null,null,"sub-item B12.03(a)",null,null,"%",{"v":0.1,"d":"10%"},{"$f":"I38*G41","v":{"v":1800,"d":"R 1,800.00"}},{"$f":"H41","v":{"v":1800,"d":"R 1,800.00"}}]
[]
["B12.03","Relocation and protection of existing services:"]
[]
[null,"a)   ","Relocation, including lowering or raising,"]
[null,"       ","protection and/or repair of existing services"]
[null,"      ","which are not allowed for under any other"]
[null,"      ","items in the schedule of quantities.",null,null,"Prov Sum",{"v":1,"d":"1.00"},{"v":20000,"d":"20,000.00"},{"$f":"H48","v":{"v":20000,"d":"R 20,000.00"}}]
[]
[null,"b)   ","Handling cost and profit in respect of"]
[null,"       ","sub-item B12.04(a) ",null,null,"%",{"v":0.1,"d":"10%"},{"$f":"I48*G51","v":{"v":2000,"d":"2,000.00"}},{"$f":"H51","v":{"v":2000,"d":"R 2,000.00"}}]
[]
["B12.04","Control of dust and pollution",{"$nulls":3},"Lump Sum",{"v":1,"d":"1.00"},{"v":15000,"d":"R 15,000.00"},{"$f":"H53","v":{"v":15000,"d":"R 15,000.00"}}]
[]
["B12.05","Compliance with Environment Management Plan",{"$nulls":3},"Lump Sum",{"v":1,"d":"1.00"},{"v":20000,"d":"R 20,000.00"},{"v":15000,"d":"R 15,000.00"}]
{"$rows_empty":19}
[1200,"TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"SUM(I18:I73)","v":{"v":136800,"d":"R 136,800.00"}}]

{"sheet":"1300.. ","index":1,"n_rows":82,"n_cols":11,"rows_kept":82,"merged":[[2,1,2,3]]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 1300"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"CONTRACTOR'S ESTABLISHMENT ON SITE"]
[null,"AND GENERAL OBLIGATIONS"]
[{"$nulls":10},{"$f":"Summary!G14","v":{"v":1258987,"d":"1,258,987.00"}}]
["B13.01","The Contractor's general obligations:",{"$nulls":8},{"$f":"K9*0.1","v":125898.70000000001}]
[]
[null,"(a)","Fixed obligations",null,null,"Lump Sum",{"v":1,"d":"1.00"},{"$f":"K10*0.5","v":{"v":62949.350000000006,"d":"R 62,949.35"}},{"v":180000,"d":"R 180,000.00"}]
[]
[null,"(b)","Value-related obligations",null,null,"Lump Sum",{"v":1,"d":"1.00"},{"$f":"K10*0.2","v":{"v":25179.740000000005,"d":"R 25,179.74"}},{"v":60000,"d":"R 60,000.00"},null,{"$f":"K10*0.3","v":37769.61}]
[{"$nulls":10},{"$f":"K14/3","v":12589.87}]
[null,"(c)","Time-related obligations",null,null,"month",{"v":3,"d":"3.00"},{"$f":"K15","v":{"v":12589.87,"d":"R 12,589.87"}},{"$f":"G16*H16","v":{"v":37769.61,"d":"R 37,769.61"}}]
[]
[null,"NB","The combined total tendered for subitems"]
[null,null,"(a), (b) and (c) shall not exceed 10% of  the"]
[null,null,"Tender Sum"]
[null,null,"(excluding VAT and Contingencies)"]
{"$rows_empty":17}
[{"$nulls":8},{"$f":"IF(OR(AND(G39=\"Prov\",H39=\"Sum\"),(H39=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G39*H39),\"\",IF(G39*H39=0,\"\",ROUND(G39*H39,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G40=\"Prov\",H40=\"Sum\"),(H40=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G40*H40),\"\",IF(G40*H40=0,\"\",ROUND(G40*H40,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G41=\"Prov\",H41=\"Sum\"),(H41=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G41*H41),\"\",IF(G41*H41=0,\"\",ROUND(G41*H41,2))))","v":""}]
{"$rows_empty":40}
[" 1300","TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"SUM(I11:I79)","v":{"v":277769.61,"d":"R 277,769.61"}}]

{"sheet":"1500..","index":2,"n_rows":80,"n_cols":20,"rows_kept":80,"merged":[[2,1,2,3]]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 1500"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"ACCOMMODATION OF TRAFFIC"]
[]
[15.03,"Temporary traffic-control facilities:"]
[]
[null,"(a)","Flagmen ",null,"LI","man-day",{"$f":"20*3","v":{"v":60,"d":"60.00"}},{"v":270,"d":"R 270.00"},{"$f":"IF(OR(AND(G11=\"Prov\",H11=\"Sum\"),(H11=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G11*H11),\"\",IF(G11*H11=0,\"\",ROUND(G11*H11,2))))","v":{"v":16200,"d":"R 16,200.00"}}]
[]
[null,"(b)","Portable STOP and GO-RY signs",null,"LI","No.",{"v":3,"d":"3.00"},{"v":700,"d":"R 700.00"},{"$f":"IF(OR(AND(G13=\"Prov\",H13=\"Sum\"),(H13=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G13*H13),\"\",IF(G13*H13=0,\"\",ROUND(G13*H13,2))))","v":{"v":2100,"d":"R 2,100.00"}}]
[]
[null,"(d) ","Amber flicker lights",null,"LI","No.",{"v":0,"d":"0.00"},{"v":388.57,"d":"R 388.57"},{"$f":"H15*G15","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"(e) ","Regulatory Road Signs R- and TR-series"]
[]
[]
[null,null,"(i)","TR101","LI","No.",{"v":16,"d":"16.00"},{"v":720,"d":"R 720.00"},{"$f":"G20*H20","v":{"v":11520,"d":"R 11,520.00"}}]
[]
[null,null,"(i)","TR103 or TR104","LI","No.",{"v":6,"d":"6.00"},{"v":800,"d":"R 800.00"},{"$f":"IF(OR(AND(G22=\"Prov\",H22=\"Sum\"),(H22=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G22*H22),\"\",IF(G22*H22=0,\"\",ROUND(G22*H22,2))))","v":{"v":4800,"d":"R 4,800.00"}}]
[]
[null,null,"(ii)","TR201-40","LI","No.",{"v":6,"d":"6.00"},{"v":800,"d":"R 800.00"},{"$f":"IF(OR(AND(G24=\"Prov\",H24=\"Sum\"),(H24=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G24*H24),\"\",IF(G24*H24=0,\"\",ROUND(G24*H24,2))))","v":{"v":4800,"d":"R 4,800.00"}}]
[]
[null,"(f) ","Warning Road Signs TW-series"]
[]
[null,null,"(i)","TW 328","LI","No.",{"v":0,"d":"0.00"},{"v":480,"d":"R 480.00"},{"$f":"IF(OR(AND(G28=\"Prov\",H28=\"Sum\"),(H28=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G28*H28),\"\",IF(G28*H28=0,\"\",ROUND(G28*H28,2))))","v":""}]
[]
[null,null,"(ii)","TW 329 or TW330","LI","No.",{"v":3,"d":"3.00"},{"v":480,"d":"R 480.00"},{"$f":"IF(OR(AND(G30=\"Prov\",H30=\"Sum\"),(H30=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G30*H30),\"\",IF(G30*H30=0,\"\",ROUND(G30*H30,2))))","v":{"v":1440,"d":"R 1,440.00"}}]
[]
[null,null,"(iii)","TW 336","LI","No.",{"v":3,"d":"3.00"},{"v":480,"d":"R 480.00"},{"$f":"IF(OR(AND(G32=\"Prov\",H32=\"Sum\"),(H32=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G32*H32),\"\",IF(G32*H32=0,\"\",ROUND(G32*H32,2))))","v":{"v":1440,"d":"R 1,440.00"}}]
[]
[null,null,"(iv)","TW 402","LI","No.",{"v":3,"d":"3.00"},{"v":480,"d":"R 480.00"},{"$f":"IF(OR(AND(G34=\"Prov\",H34=\"Sum\"),(H34=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G34*H34),\"\",IF(G34*H34=0,\"\",ROUND(G34*H34,2))))","v":{"v":1440,"d":"R 1,440.00"}}]
[]
[null,"(h)","Delineators (DTG50J), 150 mm x 600 mm high"]
[]
[null,null,"(i)","Single","LI","No.",{"v":40,"d":"40.00"},{"v":80,"d":"R 80.00"},{"$f":"IF(OR(AND(G38=\"Prov\",H38=\"Sum\"),(H38=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G38*H38),\"\",IF(G38*H38=0,\"\",ROUND(G38*H38,2))))","v":{"v":3200,"d":"R 3,200.00"}}]
[]
[null,null,"(ii)","Mounted back to back","LI","No.",{"v":40,"d":"40.00"},{"v":120,"d":"R 120.00"},{"$f":"IF(OR(AND(G40=\"Prov\",H40=\"Sum\"),(H40=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G40*H40),\"\",IF(G40*H40=0,\"\",ROUND(G40*H40,2))))","v":{"v":4800,"d":"R 4,800.00"}}]
[{"$nulls":17},"                        ","      "," number (No.)"]
[null,"(j) ","Traffic Cones TD4",null,"LI","No.",{"v":40,"d":"40.00"},{"v":150,"d":"R 150.00"},{"$f":"IF(OR(AND(G42=\"Prov\",H42=\"Sum\"),(H42=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G42*H42),\"\",IF(G42*H42=0,\"\",ROUND(G42*H42,2))))","v":{"v":6000,"d":"R 6,000.00"}},{"$nulls":8},"                        ","      "," number (No.)"]
{"$rows_empty":37}
[" 1500","TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"IF(SUM(I9:I79)=0,\"\",SUM(I9:I79))","v":{"v":57740,"d":"R 57,740.00"}}]

{"sheet":"1800","index":3,"n_rows":80,"n_cols":9,"rows_kept":80}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 1800"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"DAYWORKS",{"$nulls":6},""]
[{"$nulls":8},""]
["B18.01","Labourers:",{"$nulls":6},""]
[{"$nulls":8},""]
[null,"(i)   Unskilled",null,null,"LI","hour","-",{"v":58.1706935,"d":"58.17"},"Rate only"]
[]
[null,"(ii)   Semi-skilled",null,null,"LI","hour","-",{"v":59.56724064,"d":"59.57"},"Rate only"]
[]
[null,"(iii)   Skilled",null,null,"LI","hour","-",{"v":63.14870831,"d":"63.15"},"Rate only"]
[]
["B18.02","Foreman",null,null,"LI","hour","-",{"v":94.9314183,"d":"94.93"},"Rate only"]
[]
["B18.03","Tipper trucks:"]
[]
[null,"(i)   3 - 5 ton",{"$nulls":3},"hour","-",{"v":353.2250649,"d":"353.23"},"Rate only"]
[]
[]
["B18.04","Loader (0,5m³)",{"$nulls":3},"hour","-",{"v":538.3126113,"d":"538.31"},"Rate only"]
[]
["B18.05","Grader (CAT 140G or similar)",{"$nulls":3},"hour","-",{"v":1049.899365,"d":"1,049.90"},"Rate only"]
[]
["B18.06","LDV",{"$nulls":3},"hour","-",{"v":188.3311397,"d":"188.33"},"Rate only"]
[]
["B18.07","Compaction Rollers:"]
[]
[null,"(i)   Vibrator roller",{"$nulls":3},"hour","-",{"v":713.8045272,"d":"713.80"},"Rate only"]
[]
[null,"(ii)   Tamping roller",{"$nulls":3},"hour","-",{"v":713.8045272,"d":"713.80"},"Rate only"]
[]
[null,"(iii)   Grid roller",{"$nulls":3},"hour","-",{"v":626.8469426,"d":"626.85"},"Rate only"]
[]
["B18.08","Hand controlled compactors:"]
[]
[null,"(i)   Pedestrian roller (Bomag BW90)",{"$nulls":3},"hour","-",{"v":137.1544444,"d":"137.15"},"Rate only"]
[]
[null,"(ii)   Vibratory plate",{"$nulls":3},"hour","-",{"v":164.58533328,"d":"164.59"},"Rate only"]
[]
[null,"(iii)   Rammers",{"$nulls":3},"hour","-",{"v":197.502399936,"d":"197.50"},"Rate only"]
[]
["B18.09","Water truck (min. 7 000 l)",{"$nulls":3},"hour","-",{"v":240.4538831,"d":"240.45"},"Rate only"]
[]
[]
["B18.11","Tracked Excavator (92kw)",{"$nulls":3},"hour","-",{"v":511.5867534,"d":"511.59"},"Rate only"]
{"$rows_empty":30}
[1800,"TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"IF(SUM(I6:I78)=0,\"-\",SUM(I6:I78))","v":"-"}]

{"sheet":"2100","index":4,"n_rows":72,"n_cols":11,"rows_kept":72,"merged":[[2,1,2,3]]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 2100"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"EXCAVATION FOR OPEN DRAINS",{"$nulls":6},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G8=\"Prov\",H8=\"Sum\"),(H8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G8*H8),\"\",IF(G8*H8=0,\"\",ROUND(G8*H8,2))))","v":""}]
[21.01,"Excavation for open drains:"]
[" "]
[null,"(a)","Excavating in all materials situated within the"]
[null,null,"following depth ranges below the surface "]
[null,null,"level:"]
[]
[null,null,"(i)","0 m up to 1,5 m","LI","m³",{"v":16,"d":"16.00"},{"v":135,"d":"R 135.00"},{"$f":"G15*H15","v":{"v":2160,"d":"R 2,160.00"}}]
[]
[21.06,"Pipes in subsoil drainage systems"]
[]
[null,"(c)","High-density type poly-ethylene pressure pipes"]
[null,null,"and fittings, complete with couplings"]
[]
[null,null,"(i)","110mm dia","LI","m",{"v":100,"d":"100.00"},{"v":470,"d":"R 470.00"},{"$f":"G22*H22","v":{"v":47000,"d":"R 47,000.00"}},null,{"$f":"180/1.8","v":100}]
[]
[21.12,"concrete outlet structures,manhole boxes, junction boxes and "]
[null,"cleaning eyes for subsoil drainage systems:"]
[]
[null,"(a)","Outlet structures",null,"Ll","No",{"v":1,"d":"1.00"},{"v":8280,"d":"R 8,280.00"},{"$f":"H27","v":{"v":8280,"d":"R 8,280.00"}}]
{"$rows_empty":44}
[" 2200","TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"SUM(I10:I70)","v":{"v":57440,"d":"R 57,440.00"}}]

{"sheet":"2300","index":5,"n_rows":81,"n_cols":9,"rows_kept":81,"merged":[[2,1,2,3]]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 2300"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"CONCRETE KERBING, CHANNELLING, CHUTES",{"$nulls":6},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
[null,"AND DOWNPIPES, AND CONCRETE LININGS ",{"$nulls":6},{"$f":"IF(OR(AND(G8=\"Prov\",H8=\"Sum\"),(H8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G8*H8),\"\",IF(G8*H8=0,\"\",ROUND(G8*H8,2))))","v":""}]
[null,"FOR OPEN DRAINS"]
[]
[23.01,"Concrete kerbing"]
[]
[null,"(b)","SABS 927 Fig 8b Precast concrete kerb",null,"LI","m",{"v":80,"d":"80.00"},{"v":480,"d":"R 480.00"},{"$f":"IF(OR(AND(G13=\"Prov\",H13=\"Sum\"),(H13=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G13*H13),\"\",IF(G13*H13=0,\"\",ROUND(G13*H13,2))))","v":{"v":38400,"d":"R 38,400.00"}}]
[]
[null,"(c) ","SABS 927 Fig 7 Precast concrete kerb",null,"LI","m",100,{"v":350,"d":"R 350.00"},{"$f":"IF(OR(AND(G15=\"Prov\",H15=\"Sum\"),(H15=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G15*H15),\"\",IF(G15*H15=0,\"\",ROUND(G15*H15,2))))","v":{"v":35000,"d":"R 35,000.00"}}]
[{"$nulls":8},""]
[null,"(d) ","Cast in-situ concrete edge beams Class 30/19",{"$nulls":5},""]
[null,"     ","(100mm x 100mm) - next to paved walkways",null,"LI","m",{"v":275,"d":"275.00"},{"v":368,"d":"R 368.00"},{"v":101200,"d":"R 101,200.00"}]
[]
["B23.17","Removing existing kerbing",null,null,"LI","m",{"v":300,"d":"300.00"},{"v":120,"d":"R 120.00"},{"$f":"IF(OR(AND(G20=\"Prov\",H20=\"Sum\"),(H20=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G20*H20),\"\",IF(G20*H20=0,\"\",ROUND(G20*H20,2))))","v":{"v":36000,"d":"R 36,000.00"}}]
{"$rows_empty":60}
[2300,"TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"SUM(I6:I79)","v":{"v":210600,"d":"R 210,600.00"}}]

{"sheet":"3300","index":6,"n_rows":60,"n_cols":10,"rows_kept":60,"merged":[[2,1,2,3]]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 3300"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"BORROW MATERIALS",{"$nulls":6},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G8=\"Prov\",H8=\"Sum\"),(H8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G8*H8),\"\",IF(G8*H8=0,\"\",ROUND(G8*H8,2))))","v":""}]
["B33.04","Cut to spoil to an approved dumping site, or sources",{"$nulls":6},{"$f":"IF(OR(AND(G9=\"Prov\",H9=\"Sum\"),(H9=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G9*H9),\"\",IF(G9*H9=0,\"\",ROUND(G9*H9,2))))","v":""}]
[null,"provided by the Contractor, including all haul:",{"$nulls":6},""]
[{"$nulls":8},""]
[null,"(b)","Intermediate excavation",null,null,"m3",{"v":530,"d":"530.0"},{"v":250,"d":"R 250.00"},{"$f":"G12*H12","v":{"v":132500,"d":"R 132,500.00"}}]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"v":33.1,"d":"33.10"},"Roadbed preparation and the compaction of material:",{"$nulls":6},""]
[{"$nulls":8},""]
[null,"(b)","Compaction to 93% of modified AASHTO to",null,null,"m3",{"v":210,"d":"210.00"},{"v":230,"d":"R 230.00"},{"v":48300,"d":"R 48,300.00"},{"$f":"0.86*0.1*250","v":21.5}]
[null,null,"compacted layer thickness of 150 mm",{"$nulls":5},""]
[]
[{"$nulls":8},""]
[{"$nulls":8},""]
{"$rows_empty":38}
[" 3300","TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"SUM(I9:I21)","v":{"v":180800,"d":"R 180,800.00"}}]

{"sheet":"3400","index":7,"n_rows":68,"n_cols":9,"rows_kept":68}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 3400"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$nulls":6},""]
[]
["B34.15","Pavement layers constructed from gravel"]
[null,"obtained from commercial sources or "]
[null,"approved sources provided by the Contractor,"]
[null,"including all haul:"]
[]
[null,"(a)","Gravel selected layer (G7) compacted to:"]
[]
[null,null,"(i)","93% of modified AASHTO density for a"]
[{"$nulls":3},"compacted layer thickness of 150 mm",null,"m³",{"v":255,"d":"255.00"},{"v":410,"d":"R 410.00"},{"$f":"G17*H17","v":{"v":104550,"d":"R 104,550.00"}}]
[]
[null,"(c)","Gravel subbase (stabilized gravel, min G5 or G6 "]
[null,null,"before stabilisation to ensure a C4 after "]
[null,null,"stabilisation) compacted to:"]
[]
[null,null,"(i)","97% of modified AASHTO density for a"]
[{"$nulls":3},"compacted layer thickness of 150 mm",null,"m³",{"v":180,"d":"180.00"},{"v":445,"d":"R 445.00"},{"$f":"G24*H24","v":{"v":80100,"d":"R 80,100.00"}}]
{"$rows_empty":43}
[3400,"TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"SUM(I6:I66)","v":{"v":184650,"d":"R 184,650.00"}}]

{"sheet":"3500","index":8,"n_rows":82,"n_cols":9,"rows_kept":82}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 3500"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"STABILIZATION",{"$nulls":6},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G8=\"Prov\",H8=\"Sum\"),(H8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G8*H8),\"\",IF(G8*H8=0,\"\",ROUND(G8*H8,2))))","v":""}]
[35.01,"Chemical stabilization extra over unstabilized "]
[null,"compacted layers:"]
[]
[null,"(c)","Gravel subbase, 150 mm thick",null,"LI","m³",{"$f":"'3400'!G24","v":{"v":180,"d":"180.00"}},{"v":25,"d":"R 25.00"},{"$f":"G12*H12","v":{"v":4500,"d":"R 4,500.00"}}]
[]
[35.02,"Chemical stabilizing agent:"]
[]
[null,"(a)","Ordinary Portland Cement",null,"LI","t",{"v":13,"d":"13.00"},{"v":2200,"d":"R 2,200.00"},{"$f":"G16*H16","v":{"v":28600,"d":"R 28,600.00"}}]
[]
[35.04,"Provision and application of water for curing",null,null,"LI","kilolitre",{"v":500,"d":"500.00"},{"v":23,"d":"R 23.00"},{"$f":"G18*H18","v":{"v":11500,"d":"R 11,500.00"}}]
{"$rows_empty":63}
[3500,"TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"SUM(I6:I80)","v":{"v":44600,"d":"R 44,600.00"}}]

{"sheet":"5600","index":9,"n_rows":82,"n_cols":11,"rows_kept":82}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 5600"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"ROAD SIGNS",{"$nulls":6},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G8=\"Prov\",H8=\"Sum\"),(H8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G8*H8),\"\",IF(G8*H8=0,\"\",ROUND(G8*H8,2))))","v":""}]
["B56.01","Road sign boards with painted or coloured semi-matt"]
[null,"background.  Symbols, lettering and borders in "]
[null,"diamond grade retro- reflective material, where the "]
[null,"sign board is constructed from:"]
[]
[null,"(b) ","Aluminum sections (extruded alloy profiles, "]
[null,null,"200mm high), all sizes",null,"LI","m²",{"v":39,"d":"39.00"},{"v":950,"d":"R 950.00"},{"$f":"IF(OR(AND(G15=\"Prov\",H15=\"Sum\"),(H15=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G15*H15),\"\",IF(G15*H15=0,\"\",ROUND(G15*H15,2))))","v":{"v":37050,"d":"R 37,050.00"}},null,{"$f":"0.8*0.6","v":0.48}]
[]
[56.05,"Excavation and backfilling for road sign supports "]
[null,"(not applicable to kilometre posts)",null,null,"LI","m³",{"v":19,"d":"19.00"},{"v":156,"d":"R 156.00"},{"$f":"IF(OR(AND(G18=\"Prov\",H18=\"Sum\"),(H18=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G18*H18),\"\",IF(G18*H18=0,\"\",ROUND(G18*H18,2))))","v":{"v":2964,"d":"R 2,964.00"}},null,{"$f":"K15*39","v":18.72}]
[]
[56.06,"Extra over item 56.05 for cement-treated soil backfill",null,null,"LI","m³",{"v":2,"d":"2.00"},{"v":250,"d":"R 250.00"},{"v":500,"d":"R 500.00"}]
{"$rows_empty":61}
[5600,"TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"IF(SUM(I1:I81)=0,\"\",SUM(I1:I81))","v":{"v":40514,"d":"R 40,514.00"}}]

{"sheet":"5700","index":10,"n_rows":72,"n_cols":9,"rows_kept":72,"merged":[[2,1,2,3]]}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 5700"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"ROAD MARKINGS",{"$nulls":6},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G8=\"Prov\",H8=\"Sum\"),(H8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G8*H8),\"\",IF(G8*H8=0,\"\",ROUND(G8*H8,2))))","v":""}]
[57.03,"Retro-reflective road marking paint:",{"$nulls":6},""]
[{"$nulls":8},""]
[null,"(a)","White lines (broken or unbroken):",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"(i)","100 mm wide","LI","km",{"v":1,"d":"1.00"},{"v":4615,"d":"R 4,615.00"},{"$f":"IF(OR(AND(G13=\"Prov\",H13=\"Sum\"),(H13=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G13*H13),\"\",IF(G13*H13=0,\"\",ROUND(G13*H13,2))))","v":{"v":4615,"d":"R 4,615.00"}}]
[]
[null,null,"(iii)","300 mm wide","LI","km",{"v":1,"d":"1.00"},{"v":4603,"d":"R 4,603.00"},{"v":4603,"d":"R 4,603.00"}]
[]
[null,"(d)","White lettering and symbols",null,"LI","m²",{"v":160,"d":"160.00"},{"v":200,"d":"R 200.00"},{"$f":"IF(OR(AND(G17=\"Prov\",H17=\"Sum\"),(H17=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G17*H17),\"\",IF(G17*H17=0,\"\",ROUND(G17*H17,2))))","v":{"v":32000,"d":"R 32,000.00"}}]
[]
[null,"(e)","Yellow lettering and symbols",null,"LI","m²",30,{"v":170,"d":"R 170.00"},{"v":5100,"d":"R 5,100.00"}]
[]
[57.06,"Setting out and premarking the lines "]
[null,"(excluding traffic-island markings, lettering "]
[null,"and symbols)",null,null,"LI","km",{"v":2.5,"d":"2.50"},{"v":1850,"d":"R 1,850.00"},{"$f":"IF(OR(AND(G23=\"Prov\",H23=\"Sum\"),(H23=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G23*H23),\"\",IF(G23*H23=0,\"\",ROUND(G23*H23,2))))","v":{"v":4625,"d":"R 4,625.00"}}]
{"$rows_empty":48}
[5700,"TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"IF(SUM(I1:I71)=0,\"\",SUM(I1:I71))","v":{"v":50943,"d":"R 50,943.00"}}]

{"sheet":"5800","index":11,"n_rows":82,"n_cols":9,"rows_kept":82}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 5800"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"LANDSCAPING AND PLANTING PLANTS",{"$nulls":6},""]
[{"$nulls":8},""]
["58.03","Preparing the areas for grassing:",{"$nulls":6},""]
[]
[null,"(c)","Topsoiling within the road reserve, where the",{"$nulls":5},""]
[null,null,"following materials are used:"]
[{"$nulls":8},{"$f":"IF(OR(AND(G13=\"Prov\",H13=\"Sum\"),(H13=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G13*H13),\"\",IF(G13*H13=0,\"\",ROUND(G13*H13,2))))","v":""}]
[null,null,"(ii)","Topsoil obtained from other sources by ","LI","m³",20,{"v":50,"d":"R 50.00"},{"$f":"IF(OR(AND(G14=\"Prov\",H14=\"Sum\"),(H14=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G14*H14),\"\",IF(G14*H14=0,\"\",ROUND(G14*H14,2))))","v":{"v":1000,"d":"R 1,000.00"}}]
[{"$nulls":3},"the Contractor (including all haul)",{"$nulls":4},{"$f":"IF(OR(AND(G15=\"Prov\",H15=\"Sum\"),(H15=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G15*H15),\"\",IF(G15*H15=0,\"\",ROUND(G15*H15,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G16=\"Prov\",H16=\"Sum\"),(H16=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G16*H16),\"\",IF(G16*H16=0,\"\",ROUND(G16*H16,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G17=\"Prov\",H17=\"Sum\"),(H17=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G17*H17),\"\",IF(G17*H17=0,\"\",ROUND(G17*H17,2))))","v":""}]
{"$rows_empty":12}
[{"$nulls":8},{"$f":"IF(OR(AND(G30=\"Prov\",H30=\"Sum\"),(H30=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G30*H30),\"\",IF(G30*H30=0,\"\",ROUND(G30*H30,2))))","v":""}]
{"$rows_empty":10}
[{"$nulls":8},{"$f":"IF(OR(AND(G41=\"Prov\",H41=\"Sum\"),(H41=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G41*H41),\"\",IF(G41*H41=0,\"\",ROUND(G41*H41,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G42=\"Prov\",H42=\"Sum\"),(H42=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G42*H42),\"\",IF(G42*H42=0,\"\",ROUND(G42*H42,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G43=\"Prov\",H43=\"Sum\"),(H43=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G43*H43),\"\",IF(G43*H43=0,\"\",ROUND(G43*H43,2))))","v":""}]
{"$rows_empty":27}
[{"$nulls":8},{"$f":"IF(OR(AND(G71=\"Prov\",H71=\"Sum\"),(H71=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G71*H71),\"\",IF(G71*H71=0,\"\",ROUND(G71*H71,2))))","v":""}]
[{"$nulls":8},""]
[]
[]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},{"$f":"IF(OR(AND(G80=\"Prov\",H80=\"Sum\"),(H80=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G80*H80),\"\",IF(G80*H80=0,\"\",ROUND(G80*H80,2))))","v":""}]
[]
[" 5900","TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"IF(SUM(I6:I81)=0,\"\",SUM(I6:I81))","v":{"v":1000,"d":"R 1,000.00"}}]

{"sheet":"7300","index":12,"n_rows":77,"n_cols":9,"rows_kept":77}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 7300"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"CONCRETE BLOCK PAVING FOR ROADS",{"$nulls":6},""]
[{"$nulls":8},""]
[73.01,"Concrete block paving",{"$nulls":6},""]
[{"$nulls":8},""]
[null,"(a)","Grey interlocking precast concrete paving ",{"$nulls":5},""]
[null,null,"blocks type SA 60mm thick, including all cutting "]
[null,null,"of units to fit between edge restraints , laid on ",{"$nulls":5},""]
[null,null,"and including 20mm river sand bed , compacted "]
[null,null,"and plaster sand broomed into joints on"]
[null,null,"completion",null,"LI","m²",{"v":800,"d":"800.00"},{"v":300,"d":"R 300.00"},{"$f":"IF(OR(AND(G16=\"Prov\",H16=\"Sum\"),(H16=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G16*H16),\"\",IF(G16*H16=0,\"\",ROUND(G16*H16,2))))","v":{"v":240000,"d":"R 240,000.00"}}]
[{"$nulls":8},{"$f":"IF(OR(AND(G17=\"Prov\",H17=\"Sum\"),(H17=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G17*H17),\"\",IF(G17*H17=0,\"\",ROUND(G17*H17,2))))","v":""}]
[73.03,"Provision of approved herbicide and ant poison:",{"$nulls":6},{"$f":"IF(OR(AND(G18=\"Prov\",H18=\"Sum\"),(H18=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G18*H18),\"\",IF(G18*H18=0,\"\",ROUND(G18*H18,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G19=\"Prov\",H19=\"Sum\"),(H19=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G19*H19),\"\",IF(G19*H19=0,\"\",ROUND(G19*H19,2))))","v":""}]
[null,"a) ","Provision of materials",null,null,"PC",{"v":1,"d":"1.00"},{"v":24000,"d":"R 24,000.00"},{"$f":"IF(OR(AND(G20=\"Prov\",H20=\"Sum\"),(H20=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G20*H20),\"\",IF(G20*H20=0,\"\",ROUND(G20*H20,2))))","v":{"v":24000,"d":"R 24,000.00"}}]
[]
[null,"b) ","Contractor's charges and profit added to"]
[null,null,"the prime cost sum",null,null,"%",{"v":0.1,"d":"10%"},{"$f":"H20*G23","v":{"v":2400,"d":"R 2,400.00"}},{"$f":"H23","v":{"v":2400,"d":"R 2,400.00"}}]
[]
["B73.04","Pedestrian ramps"]
[]
[null,"a) ","Pedestrian ramp \"type A\" including transitions"]
[null,null,"complete",null,"LI","No.",{"v":3,"d":"3.00"},{"v":2500,"d":"R 2,500.00"},{"$f":"IF(OR(AND(G28=\"Prov\",H28=\"Sum\"),(H28=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G28*H28),\"\",IF(G28*H28=0,\"\",ROUND(G28*H28,2))))","v":{"v":7500,"d":"R 7,500.00"}}]
{"$rows_empty":7}
[{"$nulls":8},{"$f":"IF(OR(AND(G36=\"Prov\",H36=\"Sum\"),(H36=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G36*H36),\"\",IF(G36*H36=0,\"\",ROUND(G36*H36,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G37=\"Prov\",H37=\"Sum\"),(H37=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G37*H37),\"\",IF(G37*H37=0,\"\",ROUND(G37*H37,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G38=\"Prov\",H38=\"Sum\"),(H38=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G38*H38),\"\",IF(G38*H38=0,\"\",ROUND(G38*H38,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G39=\"Prov\",H39=\"Sum\"),(H39=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G39*H39),\"\",IF(G39*H39=0,\"\",ROUND(G39*H39,2))))","v":""}]
[{"$nulls":8},""]
[]
[]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
{"$rows_empty":27}
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},{"$f":"IF(OR(AND(G75=\"Prov\",H75=\"Sum\"),(H75=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G75*H75),\"\",IF(G75*H75=0,\"\",ROUND(G75*H75,2))))","v":""}]
[]
[7300,"TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"IF(SUM(I6:I76)=0,\"\",SUM(I6:I76))","v":{"v":273900,"d":"R 273,900.00"}}]

{"sheet":"8100..","index":13,"n_rows":82,"n_cols":9,"rows_kept":82}
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":7},"SECTION 8100"]
[]
["ITEM","DESCRIPTION",null,null,"LI","UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G6=\"Prov\",H6=\"Sum\"),(H6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G6*H6),\"\",IF(G6*H6=0,\"\",ROUND(G6*H6,2))))","v":""}]
[null,"TESTING MATERIALS AND WORKMANSHIP",{"$nulls":6},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G8=\"Prov\",H8=\"Sum\"),(H8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G8*H8),\"\",IF(G8*H8=0,\"\",ROUND(G8*H8,2))))","v":""}]
[81.02,"Other special tests requested by the engineer",{"$nulls":3},"Prov Sum  ",1,{"v":20000,"d":"R 20,000.00"},{"$f":"IF(OR(AND(G9=\"Prov\",H9=\"Sum\"),(H9=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G9*H9),\"\",IF(G9*H9=0,\"\",ROUND(G9*H9,2))))","v":{"v":20000,"d":"R 20,000.00"}}]
[{"$nulls":8},{"$f":"IF(OR(AND(G10=\"Prov\",H10=\"Sum\"),(H10=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G10*H10),\"\",IF(G10*H10=0,\"\",ROUND(G10*H10,2))))","v":""}]
{"$rows_empty":71}
[" 8100","TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"IF(SUM(I6:I81)=0,\"\",SUM(I6:I81))","v":{"v":20000,"d":"R 20,000.00"}}]

{"sheet":"Summary","index":14,"n_rows":62,"n_cols":7,"rows_kept":62,"merged":[[41,0,42,4]]}
["EMPLOYER:             JRA",{"$f":"'1200..'!D2","v":"Ikhala TVET College"}]
[]
["CONTRACT NO:                092/2013",{"$f":"'1200..'!D4","v":0}]
[]
["FOR"]
[]
["CONTRACT TITLE:           ",{"$f":"'1200..'!D8","v":"IKHALA TVET COLLEGE"}]
[null,{"$f":"'1200..'!D9","v":"INTERSECTION UPGRADE"}]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
["SCHEDULE A : ROAD CONSTRUCTION",{"$nulls":3},"COLTO"]
[]
[1200,"GENERAL REQUIREMENTS AND PROVISIONS . . . . . .  . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'1200..'!I75","v":{"v":136800,"d":"136,800.00"}},null,{"$f":"SUM(E17:E29)+E14","v":{"v":1258987,"d":"1,258,987.00"}}]
[1300,"CONTRACTOR'S ESTABLISHMENT ON SITE AND "," "]
[null,"GENERAL OBLIGATIONS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'1300.. '!I82","v":{"v":277769.61,"d":"277,769.61"}}]
[1500,"ACCOMMODATION OF TRAFFIC  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'1500..'!I80","v":{"v":57740,"d":"57,740.00"}}]
[1800,"DAYWORKS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'1800'!I80","v":"-"}]
[2100,"EXCAVATION FOR OPEN DRAINS",null,null,{"$f":"'2100'!I72","v":{"v":57440,"d":"57,440.00"}}]
[2300,"CONCRETE KERBING, CONCRETE CHANNELING, CHUTES AND"," "]
[null,"DOWNPIPES, CONCRETE LININS FOR OPEN DRAINS. . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'2300'!I81","v":{"v":210600,"d":"210,600.00"}}]
[3300,"MASS EARTHWORKS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'3300'!I60","v":{"v":180800,"d":"180,800.00"}}]
[3400,"PAVEMENT LAYERS OF GRAVEL MATERIALS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'3400'!I68","v":{"v":184650,"d":"184,650.00"}}]
[3500,"STABILIZATION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'3500'!I82","v":{"v":44600,"d":"44,600.00"}}]
[5600,"ROAD SIGNS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'5600'!I82","v":{"v":40514,"d":"40,514.00"}}]
[5700,"ROAD MARKINGS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'5700'!I72","v":{"v":50943,"d":"50,943.00"}}]
[5800,"FINISHING THE ROAD AND ROAD RESERVE AND TREATING OLD ROADS . . . . . ."," ","R",{"$f":"'5800'!I82","v":{"v":1000,"d":"1,000.00"}}]
[7300,"CONCRETE BLOCK PAVING FOR ROADS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."," ","R",{"$f":"'7300'!I77","v":{"v":273900,"d":"273,900.00"}}]
[8100,"TESTING MATERIALS AND WORKMANSHIP "," ","R",{"$f":"'8100..'!I82","v":{"v":20000,"d":"20,000.00"}}]
{"$rows_empty":12}
["CALCULATION OF TENDER SUM"]
[]
[]
["Schedule A: Road Construction",null," ","R",{"$f":"SUM(E14:E29)","v":{"v":1536756.6099999999,"d":"1,536,756.61"}}]
[null,null," "]
[]
["TOTAL OF SCHEDULE OF QUANTITIES (TENDER SUM). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null," ","R",{"$f":"E45","v":{"v":1536756.6099999999,"d":"1,536,756.61"}}]
[null,null," "]
[null,null," "]
["The Tenderer shall make an allowance of 10% of the tender "]
["sum for contingencies (Add 10% OF Tender Sum above)",null,null,"R",{"$f":"E48*0.1","v":{"v":153675.661,"d":"153,675.66"}}]
[]
[null,null," "]
["SUBTOTAL  (Tender sum plus contingencies plus contract price adjustment). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null," ","R",{"$f":"SUM(E47:E53)","v":{"v":1690432.271,"d":"1,690,432.27"}}]
[null,null," "]
[]
["VALUE-ADDED TAX (VAT)"]
["The tenderer shall add 15% of the subtotal for VAT . . . . . . . . . . . . . . . . . . . . . . .  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null," ","R",{"$f":"E55*0.15","v":{"v":253564.84064999997,"d":"253,564.84"}}]
["                                                                              "]
[]
["TENDER PRICE CARRIED TO FORM OF TENDER",null,null,"R",{"$f":"SUM(E55:E59)","v":{"v":1943997.1116499999,"d":"1,943,997.11"}}]