{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["1300","1400","1600","1700","3300","3400","B71","8100","C100","Summary"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"1300","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[24,0,24,4]]}
["Number","Item Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":5},"R"]
[1300,"CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS"]
[]
[13.01,"Contractor's general obligations"]
[]
[null,"(a) Fixed obligations","L/sum",1]
[]
[null,"(c) Time-related obligations","month",7]
[]
[]
["B13.02","Community Liaison Officer","Prov sum",1,{"$f":"6000*12","v":{"v":72000,"d":"72,000.00"}},{"$f":"E12*D12","v":{"v":72000,"d":"R72,000.00"}}]
[]
[null,"(a) Handling cost and profit in respect of item B13.02 above,not exceed 10% of item B13.02","%",{"$f":"+F12","v":{"v":72000,"d":"72,000.00"}}]
[]
[null,"SITE SAFETY"]
[]
["B13.04","Contractors general obligations in terms of Part E of the project specifications (Pre-construction Health and Safety Specification).Including the PPE and all safety compliance","L/sum",1]
[]
[]
[null,"(a) Fixed obligations"]
[]
[null,"(i) Preparation of risk assessments, safe work procedures including, the project health and safety file, the health and safety plan and any other health and safety matter the contractor deems necessary, including handing overrecords to the Employer","L/sum",1]
[]
[" Total Carried Forward To Summary"]

{"sheet":"1400","index":1,"n_rows":27,"n_cols":6,"rows_kept":27,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[26,0,26,4]]}
["Number","Item Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":5},"R"]
[1400,"HOUSING AND OFFICES FOR THE CONTRACTOR"]
[]
[14.01,"Office accommodation"]
[]
[null,"(a) Offices,including furniture and equipment","month",7]
[]
[null,"(b) Prime-cost items and items paid for in a lump sum:","L/sum",1]
[]
[14.08,"Services:"]
[]
[null,"(a) Service at office "]
[]
[null,"(1) Fixed costs","L/sum",1]
[]
[null,"(2) Running costs","month",7]
[]
[]
["B14.11","Subcontractor Development"]
[]
[null,"Coaching, guidance and mentoring of Subcontractors by full time site staff. Preparing and maintaining Portfolio of Evidence for each subcontractor"]
[null,"Provision of office facilities for subcontractors","Prov sum",1,{"v":50000,"d":"50,000.00"},{"$f":"E23*D23","v":{"v":50000,"d":"R50,000.00"}}]
[]
[]
[]
[" Total Carried Forward To Summary"]

{"sheet":"1600","index":2,"n_rows":33,"n_cols":6,"rows_kept":33,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[32,0,32,4]]}
["Number","Item Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":5},"R"]
[1600,"OVERHAUL"]
[]
[16.02,"Overhaul on material hauled in excess of 1,0 km (ordinary overhaul).","m³.km",{"v":16209,"d":"16,209"}]
{"$rows_empty":27}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F3:F32)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"1700","index":3,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[46,0,46,4]]}
["Number","Item Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":5},"R"]
[{"$nulls":5},{"$f":"IF(OR(AND(D3=\"Prov\",E3=\"Sum\"),(E3=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D3*E3),\"\",IF(D3*E3=0,\"\",ROUND(D3*E3,2))))","v":""}]
[null,"CLEARING AND GRUBBING"]
[]
["17.01","Clearing and grubbing",{"$nulls":3},{"$f":"IF(OR(AND(D6=\"Prov\",E6=\"Sum\"),(E6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D6*E6),\"\",IF(D6*E6=0,\"\",ROUND(D6*E6,2))))","v":""}]
[null,"Allow for clearing the area of the site to be built upon of all grass, weeds, shrubs, trees with trunks not exceeding 200mm girth, debris, including grubbing up all roots, scuffling up as required and cart away all vegetation and debris ","m2",{"v":18000,"d":"18,000.00"}]
[{"$nulls":5},{"$f":"IF(OR(AND(D8=\"Prov\",E8=\"Sum\"),(E8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D8*E8),\"\",IF(D8*E8=0,\"\",ROUND(D8*E8,2))))","v":""}]
["17.02","Removal and grubbing of large trees and "]
[null,"tree stumps:"]
[{"$nulls":5},{"$f":"IF(OR(AND(D11=\"Prov\",E11=\"Sum\"),(E11=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D11*E11),\"\",IF(D11*E11=0,\"\",ROUND(D11*E11,2))))","v":""}]
[null,"(a) Trees exceeding 200mm and n.e 1000mm girth","No",{"v":50,"d":"50.00"}]
{"$rows_empty":34}
[" Total Carried Forward To Summary","TOTAL CARRIED TO SUMMARY"]

{"sheet":"3300","index":4,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
[]
[]
["Number","Item Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":5},"R"]
[null,"MASS EARTHWORKS",{"$nulls":3},{"$f":"IF(OR(AND(D5=\"Prov\",E5=\"Sum\"),(E5=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D5*E5),\"\",IF(D5*E5=0,\"\",ROUND(D5*E5,2))))","v":""}]
[]
[]
["B33.04","Cut to spoil, including free-haul up to 0,5 km."]
[null,"Material obtained from:"]
[]
[null,"(a) Soft excavation","m3",{"v":13966,"d":"13,966"}]
[]
[null,"(b) Intermediate excavation","m3",{"v":2621,"d":"2,621"}]
[]
[null,"(c) Hard excavation","m3",{"v":2729,"d":"2,729"}]
[]
[]
[]
[]
["33/32.06","Stockpiling of material                 ","m³",{"v":16209,"d":"16,209.00"}]
{"$rows_empty":15}
[3300,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F5:F35)","v":{"v":0,"d":"0.00"}}]

{"sheet":"3400","index":5,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[0,0,1,0],[0,1,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6]]}
["Number","Item Description",null,null,"Unit","Unit","Quantity","Rate","Amount"]
[{"$nulls":8},"R"]
[{"$nulls":6},{"$f":"IF(OR(AND(D3=\"Prov\",F3=\"Sum\"),(F3=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D3*F3),\"\",IF(D3*F3=0,\"\",ROUND(D3*F3,2))))","v":""},null,{"$f":"IF(OR(AND(G3=\"Prov\",H3=\"Sum\"),(H3=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G3*H3),\"\",IF(G3*H3=0,\"\",ROUND(G3*H3,2))))","v":""}]
[null,"PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$nulls":4},{"$f":"IF(OR(AND(D4=\"Prov\",F4=\"Sum\"),(F4=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D4*F4),\"\",IF(D4*F4=0,\"\",ROUND(D4*F4,2))))","v":""},null,{"$f":"IF(OR(AND(G4=\"Prov\",H4=\"Sum\"),(H4=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G4*H4),\"\",IF(G4*H4=0,\"\",ROUND(G4*H4,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G5=\"Prov\",H5=\"Sum\"),(H5=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G5*H5),\"\",IF(G5*H5=0,\"\",ROUND(G5*H5,2))))","v":""}]
["B34.14","Pavement layers constructed from gravel obtained"]
[null,"from commercial sources or approved sources"]
[null,"provided by the Contractor, including all haul:"]
[]
[null,"(a) Gravel subbase layer compacted to:",{"$nulls":6},{"$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":""}]
[{"$nulls":8},""]
[null,null,"(i)(a)","97% of modified AASHTO density for a",{"$nulls":4},""]
[{"$nulls":3},"compacted layer thickness of 150 mm "]
[{"$nulls":3},"selected (G7)",null,"m3",{"v":2025,"d":"2,025.00"}]
[]
[null,"(b)","Gravel base (unstabilized gravel) compacted"]
[null,null,"to:"]
[]
[null,null,"(i)","98% of modified AASHTO density for a"]
[{"$nulls":3},"compacted layer thickness of 150 mm (G5)","m³","m3",{"v":2025,"d":"2,025.00"}]
[]
[null,"(c)","Gravel base (unstabilized gravel) compacted"]
[null,null,"to:"]
[]
[null,null,"(i)","98% of modified AASHTO density for a"]
[{"$nulls":3},"compacted layer thickness of 150 mm (G6)","m³","m3",{"v":3500,"d":"3,500.00"}]
{"$rows_empty":8}
[3400,"TOTAL CARRIED TO SUMMARY"]

{"sheet":"B71","index":6,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[29,0,29,4]]}
["Number","Item Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":5},"R"]
["B 71.00","BLOCK PAVED WALKWAYS(AT INTERSECTIONS)"]
[]
["B71.09","Soil poisoning ","m²",13500]
[]
["B71.10","River sand bedding, 20 mm max and grade","m³",270]
[]
["B71.11","Supply and lay 60mm Industrial Corobrik Corolockmulti Blend or Similar approved paving blocks","m²",13500]
[]
[null,"Kerbing and Channelling"]
[null,"Precast Concrete Kerbing - Straight and radii over 20m"]
[]
[null,"Supply and lay Fig.12  precast concrete kerbing on a class 20/19 concrete based including continuous haunching as per detail Drawing,","m",9000]
[]
[null,"Class 20/19 (cast insitu)"]
[null,"Concrete Base ","m3",203]
[]
[null,"Concrete haunch ","m3",14]
{"$rows_empty":10}
[" Total Carried Forward To Summary"]

{"sheet":"8100","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[13,0,13,4]]}
["Number","Item Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":5},"R"]
[81,"TESTING MATERIALS AND WORKMANSHIP"]
[]
[81.02,"Other special tests requested by the Engineer","Prov sum",1,25000,{"$f":"D5*E5","v":{"v":25000,"d":"R25,000.00"}}]
[]
["B81.03","Topographical survey after completion of construction works","Lump Sum",1,65000,{"$f":"E7*D7","v":{"v":65000,"d":"R65,000.00"}}]
[]
[81.04,"Employer's Occupational Health & Safety Agent ","Prov sum",1,200000,{"v":200000,"d":"R200,000.00"}]
[null,"Handling costs and profit in respect of subitem 81.04 ","%"]
[]
[]
[]
[" Total Carried Forward To Summary"]

{"sheet":"C100","index":8,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[35,0,35,4]]}
["Number","Item Description","Unit","Quantity","Rate","Amount"]
[{"$nulls":5},"R"]
["C10.00","DAYWORKS"]
[]
[null,"a) Personnel"]
[]
[null,"     i) Foreman","hr",9]
[]
[null,"     ii) Skilled Labour","hr",17]
[]
[null,"     iii) Unskilled labour","hr",21]
[]
[null,"b) Plant "]
[]
[null,"   ii) Compactors"]
[]
[null,"     1) Pedestrian Vibratory Roller 0.5 tons","hr",4]
[]
[null,"     2) Self Propelled Vibratory Roller 9.0 tons","hr",4]
[]
[null,"   iii) Trucks"]
[]
[null,"      1) 10m3 tip truck","hr",12]
[]
[null,"      2) 7000 litre water tanker with 900               litres/min water pump.","hr",4]
[]
[null,"   iv) Compressor - 7m3/min with tools            and operators.","hr",4]
[]
[null,"   v) TLB ( 4 x 4)","hr",10]
[]
[null,"   viii) Motor grader - 110kw of mass 12T","hr",5]
[]
[]
[]
[]
[" Total Carried Forward To Summary"]

{"sheet":"Summary","index":9,"n_rows":30,"n_cols":3,"rows_kept":30,"merged":[[0,0,0,2],[1,0,1,2],[2,0,3,0],[2,1,3,1],[2,2,3,2]]}
["SANBI PERIMETER PAVING"]
["SUMMARY "]
["Section","Description","Amount"]
[]
[1300,"CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS"]
[]
[1400,"HOUSING AND OFFICES "]
[]
[1600,"OVERHAUL"]
[]
[1700,"CLEARING AND GRUBBING"]
[]
[3300,"MASS EARTHWORKS"]
[]
[3400,"PAVEMENT LAYERS OF GRAVEL MATERIAL"]
[]
["B71","BLOCK PAVED WALKWAY"]
[]
[8100,"TESTING MATERIALS AND WORKMANSHIP"]
[]
["C100","DAYWORKS"]
[]
[null,"SUBTOTAL 1"]
[]
[null,"ADD : CONTINGENCIES @ 10%"]
[]
[null,"SUBTOTAL 2"]
[]
[null,"ADD : VAT @ 15%"]
[null,"SUBTOTAL 3 - TOTAL PROJECT COST"]