{"text_format":"3","workbook":"xlsx","n_sheets":22,"sheets":["1200","1300","1400","1500","1700","2100","2200 ","2300","3100","3200","3300","3400 ","3500","5100","5400","5600","5700","5900","7300","8100","GENERAL SUMMARY","SUMMARY"],"not_rendered":{"macros":1,"external_links":1,"defined_names":88,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"1200","index":0,"n_rows":249,"n_cols":7,"rows_kept":249,"merged":[[0,0,0,6],[2,7,2,8],[4,5,4,6],[138,1,138,2],[152,1,152,2],[172,1,172,2]]}
["RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"]
["SCHEDULE A : GENERAL"]
["SECTION 1200"]
["GENERAL REQUIREMENTS AND PROVISIONS"]
[]
["ITEM",null,"DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[null,"GENERAL REQUIREMENTS AND PROVISIONS"]
[]
["B12.01","Training:"]
[]
[null,"(a)  ","Accredited Engineering and Technical skills Training","Prov Sum",{"v":1,"d":"1.00"},{"v":100000,"d":"100,000.00"},{"$f":"E12*F12","v":{"v":100000,"d":"100,000.00"}}]
[]
[null,"(c) ","Training venue","Prov Sum",{"v":1,"d":"1.00"},{"v":15000,"d":"15,000.00"},{"$f":"E14*F14","v":{"v":15000,"d":"15,000.00"}}]
[]
[null,"(d)  ","Remuneration (stipent of students undergoing engineering"]
[null,null,"and technical skills training)","Prov Sum",{"v":1,"d":"1.00"},{"v":65000,"d":"65,000.00"},{"$f":"E17*F17","v":{"v":65000,"d":"65,000.00"}}]
[]
[null,"(e)  ","Contractor's handling costs, profit and all other charges in"]
[null,null,"in respect of Subitems 12.01(a)"]
[]
[null,null,"                (i)  Engineering & Technical skills","%",{"$f":"F12","v":{"v":100000,"d":"100,000.00"}},null,{"$f":"E22*F22","v":0}]
[]
[null,"(h)  ","Transport and accommodation of students during training where"]
[null,null,"it is not possible to undertake the training in close proximity"]
[null,null,"to the site.","Prov Sum",{"v":1,"d":"1.00"},{"v":20000,"d":"20,000.00"},{"$f":"E26*F26","v":{"v":20000,"d":"20,000.00"}}]
[]
[null,"(i)   ","Contractor's handling costs, profit and all other charges in"]
[null,null,"respect of subitem (h)","%",{"$f":"F26","v":{"v":20000,"d":"20,000.00"}},null,{"$f":"E29*F29","v":0}]
[]
["B12.02","Provision for Special Services - Accredited Professionals"]
[null,"to be nominated and appointed by the Employer."]
[]
[null,"(a)","Geo-Technical Engineering  and Quality Control","Prov Sum",{"v":1,"d":"1.00"},{"v":200000,"d":"200,000.00"},{"$f":"E34*F34","v":{"v":200000,"d":"200,000.00"}}]
[]
[null,"(b) ","Engineering Survey, setting out and levels control ","Prov Sum",{"v":1,"d":"1.00"},{"v":100000,"d":"100,000.00"},{"$f":"E36*F36","v":{"v":100000,"d":"100,000.00"}}]
[]
[null,"(c) ","Handling cost and Profit in respect of subitem B12.02 (a) and (b)","%",{"$f":"F34+F36","v":{"v":300000,"d":"300,000.00"}},null,{"$f":"E38*F38","v":0}]
[]
["B12.03","Compliance with OHS Act and Regulations (Including the"]
[null,"Construction Regulations 2014)"]
[]
[null,"(a)","Fixed obligations for the duration of the contract","Lump Sum",{"v":1,"d":"1.00"},null,{"$f":"E43*F43","v":0}]
[]
[null,"(b)","Time related obligations for the duration of the contract","Month",{"v":8,"d":"8.00"},null,{"$f":"E45*F45","v":0}]
[]
["B12.04","Contractors' initial obligations in respect of Heavy Duty "]
[null,"Personal Protective Equpment (PPE). All PPE must be  "]
[null,"SABS or any recognized authorities' approved. Colours"]
[null,"branding and logos to be finalized with the Employer"]
[]
[null,"(a)","Conti two piece work suit with aluminium zips on the jacket"]
[null,null,"and trousers."]
[null,null,"     (i). Triple stitched trousers in the back, leg and front areas"]
[null,null,"          with elastic waist band, two side pockets and one at the "]
[null,null,"          back; jacket with two side pockets and pouched breast"]
[null,null,"          pocket with reinforcing triple stitching.","Pair",{"v":20,"d":"20.00"},null,{"$f":"E57*F57","v":0}]
[]
[null,"(b)","Construction safety boots (frams or profit manufacturer)","Pair",{"v":20,"d":"20.00"},null,{"$f":"E59*F59","v":0}]
[]
[null,"(c)","Contruction safety helmet or hard hat","No",{"v":20,"d":"20.00"},null,{"$f":"E61*F61","v":0}]
[]
[null,"(d)","Showa blue pvc coated work gloves (mfr. part no: SH06604)"]
[null,null,"or CUT5 leather gloves dotted (code:55MJAXJSI) or impact"]
[null,null,"gloves (code:5ZLSTPV) or any Dromex approved gloves.","Pair",{"v":20,"d":"20.00"},null,{"$f":"E65*F65","v":0}]
[]
[null,"(e)","3M4800 anti mist safety goggles with clear lenses (mfr. part"]
[null,null,"no: 7134704) or similar approved","Pair",{"v":20,"d":"20.00"},null,{"$f":"E68*F68","v":0}]
[]
[null,"(f)","Value reflective vest with zip and id pocket from Protekta"]
[null,null,"Safety gear.","Pair",{"v":20,"d":"20.00"},null,{"$f":"E71*F71","v":0}]
[]
[null,"(g)","Orange solid relective BiB with reflective cross at back and"]
[null,null,"stripe on the front.","Pair",{"v":20,"d":"20.00"},null,{"$f":"E74*F74","v":0}]
[]
["B12.05","Submission of the Health and Safety File"]
[null,"The Contractor must submit to the Employer a health and safety"]
[null," plan for approval by the Safety Officer within 14 days of "]
[null,"appointment and before commencing with any works on site.",null,"Item",{"v":1,"d":"1.00"},null,{"$f":"E79*F79","v":0}]
[]
[]
[1200,null,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G12:G79)","v":{"v":500000,"d":"500,000.00"}}]
[]
[]
["ITEM",null,"DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,null,"TOTAL BROUGHT FORWARD",{"$nulls":3},{"$f":"G82","v":{"v":500000,"d":"500,000.00"}}]
[]
["B12.06","Occupational Health and Safety Management "]
[null,"The Contractor must maintain a full time OHS Management on "]
[null,"site as per OHS Act and Regulations including Construction "]
[null,"Regulations"]
[]
[null,"(a)","Health and Safety Officer"]
[null,null,"The Health and Safety Officer must  be in a possession of a"]
[null,null,"minimum qualifications for construction recognized in the Built"]
[null,null,"and Environment field in construction. (NOSA, SAMTRAC, etc)","Month",{"$f":"E45","v":{"v":8,"d":"8.00"}},null,{"$f":"E96*F96","v":0}]
[]
["B12.07","Compliance with COVID-19 Regulations and Specifications"]
[]
[null,"(a)","Fixed obligations for the duration of the contract","Lump Sum",{"v":1,"d":"1.00"},null,{"$f":"E100*F100","v":0}]
[]
[null,"(b)","Time related obligations for the duration of the contract","Month",{"$f":"E96","v":{"v":8,"d":"8.00"}},null,{"$f":"E102*F102","v":0}]
[]
["B12.08","Contractors' initial obligations in respect of covid-19"]
[null,"pandemic equipments."]
[]
[null,"(a)","Triple cloth face mask manufactured locally from the affected","No",{"v":20,"d":"20.00"},null,{"$f":"E107*F107","v":0}]
[null,null,"communities or in the jurisdiction of the Employer."]
[]
[null,"(b)","Sanitization stations on site or sanitizing equipments, all"]
[null,null,"sanitizers to be SABS Approved.",{"$f":"D107","v":"No"},{"v":2,"d":"2.00"},null,{"$f":"E111*F111","v":0}]
[]
[null,"(c)","Handwashing station in the site camp",{"$f":"D111","v":"No"},{"v":2,"d":"2.00"},null,{"$f":"E113*F113","v":0}]
[]
[null,"(d)","Digital temperature testing hand machine (SABS Approved)",{"$f":"D113","v":"No"},{"v":2,"d":"2.00"},null,{"$f":"E115*F115","v":0}]
[]
[null,"(e)","Records and register files for labourers, visitors and "]
[null,null,"management team (Employer, Consultant and Contractor).",{"$f":"D115","v":"No"},{"v":2,"d":"2.00"},null,{"$f":"E118*F118","v":0}]
[]
["B12.10","Compliance with (Eco) Environmental Management Plan"]
[]
[null,"(a)","Fixed obligations for the duration of the contract","Lump Sum",{"v":1,"d":"1.00"},null,{"$f":"E122*F122","v":0}]
[]
[null,"(b)","Time related obligations for the duration of the contract","Month",{"$f":"E102","v":{"v":8,"d":"8.00"}},null,{"$f":"E124*F124","v":0}]
[]
["B12.11","Health and Safety Agent"]
[]
[null,"(a)","Monthly health and safety site audits to be conducted and "]
[null,null,"OHS Plan reviewed by an approved Professional Service"]
[null,null,"Provider and to comply with the OHS Act and Regulations"]
[null,null,"(including Construction Regulations 2014) to be approved by"]
[null,null,"the Employer's Agent or Safety Officer, SACPCMP registered"]
[null,null,"and to be appointed by the Consultant.","Lump Sum",{"v":1,"d":"1.00"},{"v":150000,"d":"150,000.00"},{"$f":"E133*F133","v":{"v":150000,"d":"150,000.00"}}]
[]
[null,"(b)","Contractor's handling costs, profit and all other charges in"]
[null,null,"respect of Subitem B12,11(a)","%",{"$f":"F133","v":{"v":150000,"d":"150,000.00"}},null,{"$f":"E136*F136","v":0}]
[]
["B12.12","(Eco) Environmental Management Plan and Environmental "]
[null,"Compliance Audits for Engineers"]
[]
[null,"(a)  ","Monthly Environmental Audits to be conducted by an "]
[null,null,"approved Professional Service Providerand to comply with "]
[null,null,"Environmental Act and to be approved by the Employer's Agent"]
[null,null,"or Envirnmental Officer.","Prov sum",{"v":1,"d":"1.00"},{"v":110000,"d":"110,000.00"},{"$f":"E144*F144","v":{"v":110000,"d":"110,000.00"}}]
[]
[null,"(b)","Contractor's handling costs, profit and all other charges in"]
[null,null,"respect of Subitem B12,12(a)","%",{"$f":"F144","v":{"v":110000,"d":"110,000.00"}},null,{"$f":"E147*F147","v":0}]
[]
["B12.13","Mine Health and Safety"]
[null,"The Contractor must obtain all permits from the DME before"]
[null,"openning up any borrowpits. All opened borrowpits must be"]
[null,"rehabilitated on completion of the project for community"]
[null,"safety."]
[]
["LI","(a)","Borrowpit fencing including double gate","m",{"v":400,"d":"400.00"},null,{"$f":"E155*F155","v":0}]
[]
["LI","(b)","Provision of warning signs at the borrowpit","No",{"v":10,"d":"10.00"},null,{"$f":"E157*F157","v":0}]
[]
[null,"(c)","Borrowpit rehabilitation.","Lump Sum ",{"v":1,"d":"1.00"},null,{"$f":"E159*F159","v":0}]
[]
[]
[]
[]
[]
[]
[1200,null,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G159)","v":{"v":760000,"d":"760,000.00"}}]
[]
[]
["ITEM",null,"DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,null,"TOTAL BROUGHT FORWARD",{"$nulls":3},{"$f":"G166","v":{"v":760000,"d":"760,000.00"}}]
[]
["B12.14","Remuneration of the Project Liaison Officer and members"]
[null,"of the Project Liaison Committee:\n"]
[]
[null,"(a)  ","Project Liaison Officer - CLO","Prov sum",{"v":1,"d":"1.00"},{"v":68000,"d":"68,000.00"},{"$f":"E175*F175","v":{"v":68000,"d":"68,000.00"}}]
[]
[null,"(b)  ","Project Liaison Committee - Sitting allowance","Prov sum",{"v":1,"d":"1.00"},{"$f":"8*6*400","v":{"v":19200,"d":"19,200.00"}},{"$f":"E177*F177","v":{"v":19200,"d":"19,200.00"}}]
[]
[null,"(d)  ","Contractor's handling costs, profit and all other charges in"]
[null,null,"respects of Subitems B12.03(a) and (b) "]
[]
[null,"           (i)   Liaison Officer","           (i)   Project Liaison Officer","%",{"$f":"F175","v":{"v":68000,"d":"68,000.00"}},null,{"$f":"E182*F182","v":0}]
[]
[null,"           (ii)  Project Liaison Committee ","           (ii)  Project Liaison Committee ","%",{"$f":"F177","v":{"v":19200,"d":"19,200.00"}},null,{"$f":"E184*F184","v":0}]
[]
["B12.15","Protection, removal, realignment and replacement of"]
[null,"services including boundaries"]
[]
[null,"(a)  ","Utility services"]
[]
[null,null," (i)  Relocation of services and payments to service owners","Prov sum\n",{"v":1,"d":"1.00"},{"v":10000,"d":"10,000.00"},{"$f":"E191*F191","v":{"v":10000,"d":"10,000.00"}}]
[]
[null,null,"(ii) Removal and re-erction of fences","Prov sum",{"v":1,"d":"1.00"},{"v":15000,"d":"15,000.00"},{"$f":"E193*F193","v":{"v":15000,"d":"15,000.00"}}]
[]
[null,null,"(iii) Handling cost and profit on items (i) and (ii)","%",{"$f":"F191+F193","v":{"v":25000,"d":"25,000.00"}},null,{"$f":"E195*F195","v":0}]
[]
["B12.16","Provision of survey equipment to be used by the Engineer or "]
[null,"his Representatives on site."]
[]
[null,null,"(i)  Automatic level","No",{"v":1,"d":"1.00"},null,{"$f":"E200*F200","v":0}]
[]
[null,null,"(ii)  Staff","No",{"v":1,"d":"1.00"},null,{"$f":"E202*F202","v":0}]
[]
[null,null,"(iii) Survey Assistant","No",{"v":1,"d":"1.00"},null,{"$f":"E204*F204","v":0}]
[]
[null,null,"(iv) Measuring wheel","No",{"v":1,"d":"1.00"},null,{"$f":"E206*F206","v":0}]
[]
[null,null,"(v) 30m measuring tape","No",{"v":1,"d":"1.00"},null,{"$f":"E208*F208","v":0}]
[]
["B12.17","Provision of Engineer's services to the Contractor on site"]
[]
[null,null,"(i)  Survey","Prov sum",{"v":1,"d":"1.00"},{"v":45000,"d":"45,000.00"},{"$f":"E212*F212","v":{"v":45000,"d":"45,000.00"}}]
[]
[null,null,"(ii) Geotechnical and quality control","Prov sum",{"v":1,"d":"1.00"},{"v":65000,"d":"65,000.00"},{"$f":"E214*F214","v":{"v":65000,"d":"65,000.00"}}]
[]
[null,null,"(iii) Handling cost and profit on items (i) and (ii)","%",{"$f":"F212+F214","v":{"v":110000,"d":"110,000.00"}},null,{"$f":"E216*F216","v":0}]
[]
["B12.18","Construction nameboard as per attached drawings",null,"No",{"v":2,"d":"2.00"},null,{"$f":"E218*F218","v":0}]
[]
["B12.19","Nominated Sub-Contractors (Provisional)"]
[]
[null,"       Overhead, markup, charges and profit on","(i) Appointment of nominated subcontractors ","item",null,{"v":1000000,"d":"1,000,000.00"}]
[]
[null,null,"(ii) Management and supervision of nominated subcontractors","%"]
{"$rows_empty":24}
[1200,null,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(G170:G245)","v":{"v":982200,"d":"982,200.00"}}]

{"sheet":"1300","index":1,"n_rows":73,"n_cols":6,"rows_kept":73,"merged":[[1,0,1,5],[5,4,5,5],[72,3,72,4]]}
[]
[{"$f":"'1200'!A1:G1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE A : GENERAL"]
["SECTION 1300"]
["CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[null,"CONTRACTOR'S ESTABLISHMENT ON SITE AND"]
[null,"GENERAL OBLIGATIONS"]
[]
[13.01,"Contractor's General Obligations:"]
[]
[null,"(a)  Fixed obligations for the duration of contract","Lump sum ",{"v":1,"d":"1.00"},null,{"$f":"D14*E14","v":0}]
[]
[null,"(b)  Value-related obligations for the duration of contract","Lump sum ",{"v":1,"d":"1.00"},null,{"$f":"D16*E16","v":0}]
[]
[null,"(c)  Time-related obligations","Month",{"v":8,"d":"8.00"},null,{"$f":"D18*E18","v":0}]
[]
[null,"NB: The combined Total Tendered Sum for subitems (a),"]
[null,"        (b) & ( c) shall not exceed 15% of the Tendered Sum"]
[]
[13.02,"Sub Contractors' General Obligations:"]
[]
[null,"(a)  Fixed obligations for the duration of contract","Prov sum ",0,{"v":80000,"d":"80,000.00"}]
[]
[null,"(b)  Time-related obligations","Prov sum ",0,{"v":15000,"d":"15,000.00"}]
[]
[null,"(c) Contractor's handling cost and Profit in respect of subitem "]
[null,"      13.02 (a) and (b)","%",0,null,{"$f":"D30*E30","v":0}]
[]
["A1303","Management of the works"]
[]
[null,"(a)  The contractor to maintain full time supervision of the "]
[null,"      works for the duration of the contract.","Lump sum ",{"v":1,"d":"1.00"},null,{"$f":"D35*E35","v":0}]
{"$rows_empty":37}
["1300","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F14:F68)","v":0}]

{"sheet":"1400","index":2,"n_rows":155,"n_cols":6,"rows_kept":155,"merged":[[0,0,0,5]]}
[{"$f":"'1300'!A2:F2","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE A : GENERAL"]
["SECTION 1400 "]
["HOUSING, OFFICES AND LABORATORIES FOR THE ENGINEER'S SITE PERSONNEL"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[null,"HOUSING, OFFICES AND LABORATORIES"]
[]
[" 14.01","Office and laboratory accommodation:"]
[]
[null,"(a)  Offices (interior floor space only)","m²",{"v":20,"d":"20.00"},null,{"$f":"D12*E12","v":0}]
[]
[null,"(b)  Venue for site meetings","m²",{"v":40,"d":"40.00"},null,{"$f":"D14*E14","v":0}]
[]
["LI","(c)  Ablution units","m²",{"v":16,"d":"16.00"},null,{"$f":"D16*E16","v":0}]
[]
["LI","(d)  Stores","m²",{"v":16,"d":"16.00"},null,{"$f":"D18*E18","v":0}]
[]
[" 14.02","Office and laboratory furniture:"]
[]
[null,"(a) Chairs","number",{"v":20,"d":"20.00"},null,{"$f":"D22*E22","v":0}]
[]
[null,"(b) Delete \"Draughtman's stools\" and insert "]
[null,"     \"chairs used during drawings review\"","number",{"v":2,"d":"2.00"},null,{"$f":"D25*E25","v":0}]
[]
[null,"(c) Delete \"High chairs for laboratory\" and insert "]
[null,"     \"drawings rag or stand with five holding rails\"","number",{"v":2,"d":"2.00"},null,{"$f":"D28*E28","v":0}]
[]
[null,"(d) Desks, complete with drawers and locks","number",{"v":3,"d":"3.00"},null,{"$f":"D30*E30","v":0}]
[]
[null,"(e) Drawing tables for drawings review","number",{"v":3,"d":"3.00"},null,{"$f":"D32*E32","v":0}]
[]
[null,"(f) Conference tables","number",{"v":2,"d":"2.00"},null,{"$f":"D34*E34","v":0}]
[]
[" 14.03","Office and laboratory fittings, installations "]
[null,"and equipment:"]
[]
[null,"(a)  Items measured by number:"]
[]
[null,"       (i)   220/250 volt power points","number",{"v":2,"d":"2.00"},null,{"$f":"D41*E41","v":0}]
[]
[null,"       (ii)   400/231 volt 3-phase power points","number",{"v":1,"d":"1.00"},null,{"$f":"D43*E43","v":0}]
[]
[null,"       (iii)  Double 80 watt fluorescent-light fittings"]
[null,"              complete with ballast and tubes","number",{"v":2,"d":"2.00"},null,{"$f":"D46*E46","v":0}]
[]
[null,"       (iv)  Wash-hand basins complete with taps"]
[null,"              and drains","number",{"v":1,"d":"1.00"},null,{"$f":"D49*E49","v":0}]
[]
[null,"       (v)  Fire extinguishers, 9,0 kg all purpose"]
[null,"              dry powder type, complete, mounted"]
[null,"              on wall with brackets","number",{"v":2,"d":"2.00"},null,{"$f":"D53*E53","v":0}]
[]
[null,"       (vi)  Air-conditioning units with 2,2 kW "]
[null,"              minimum capacity, mounted and with"]
[null,"              own power connection","number",{"v":2,"d":"2.00"},null,{"$f":"D57*E57","v":0}]
[]
[null,"    (vii)  Heater, space heating type, minimum"]
[null,"            capacity 1,5 kW","number",{"v":2,"d":"2.00"},null,{"$f":"D60*E60","v":0}]
[]
[null,"   (viii)  General-purpose steel cupboards with"]
[null,"            shelves","number",{"v":2,"d":"2.00"},null,{"$f":"D63*E63","v":0}]
[]
[null,"    (ix)  Steel filing cabinets with drawers","number",{"v":2,"d":"2.00"},null,{"$f":"D65*E65","v":0}]
[]
[null,"    (x)  Refrigirators","number",{"v":1,"d":"1.00"},null,{"$f":"D67*E67","v":0}]
[]
[null,"(b)    Prime-cost items and items paid for in a"]
[null,"         lump sum:"]
[]
[null,"       (i)  The provision of a direct independent"]
[null,"             telephone line/cellphone for the Engineer, "]
[null,"             including the cost of calls in connection  "]
[null,"             with contract administration and telephone"]
[null,"             rental","PC sum",{"v":1,"d":"1.00"},{"$f":"8*3800","v":{"v":30400,"d":"30,400.00"}},{"$f":"D76*E76","v":{"v":30400,"d":"30,400.00"}}]
[]
[null,"       (ii)  Handling costs and profit in respect of"]
[null,"             subitem 14.03(b)(i) above","%",{"$f":"E76","v":{"v":30400,"d":"30,400.00"}},null,{"$f":"D79*E79","v":0}]
[]
[null,"       (iii) The provision of fax or e-mail facilities as"]
[null,"             specified","PC sum",{"v":1,"d":"1.00"},{"v":8000,"d":"8,000.00"},{"$f":"D82*E82","v":{"v":8000,"d":"8,000.00"}}]
[]
[null,"       (iv)  Handling costs and profit in respect of"]
[null,"             subitem 14.03(b)(iii) above","%",{"$f":"E82","v":{"v":8000,"d":"8,000.00"}},null,{"$f":"D85*E85","v":0}]
[]
[1400,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F12:F85)","v":{"v":38400,"d":"38,400.00"}}]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"TOTAL BROUGHT FORWARD",{"$nulls":3},{"$f":"F87","v":{"v":38400,"d":"38,400.00"}}]
[]
[null,"(c)    Items measured by area:"]
[]
[null,"       (i) Notice boards as specified","m²",{"v":1,"d":"1.00"},null,{"$f":"D94*E94","v":0}]
[]
["14.04","Car-ports                             "]
[]
["LI","       (i) Car ports as specified, at offices and "]
[null,"           laboratory buildings, COLTO 1998 Edition"]
[null,"           (strictly for the use by the Engineer and his"]
[null,"           staff together with the Employer; the "]
[null,"           Contractor shall provide his own parking at "]
[null,"           his costs\"","number",{"v":3,"d":"3.00"},null,{"$f":"D103*E103","v":0}]
[]
["14.05","Housing for labourers - Provisional"]
[]
[null,"(a) Allow the provisional amount for housing of"]
[null,"      labourers as specified in COLTO, 1998 Edition","Lump sum",{"v":1,"d":"1.00"},null,{"$f":"D108*E108","v":0}]
[]
[null,"(b) Ablution unit as specified including provision "]
[null,"      of wash basins or movable wheel ablution"]
[null,"      facilities for male and female. The rate shall "]
[null,"     include maintenance and disinfection chemicals.","number",{"v":4,"d":"4.00"},null,{"$f":"D113*E113","v":0}]
[]
[14.08,"Services: "]
[null,"The provision of water, electricity, low pressure"]
[null,"gas, sewerage, septic tanks, sewage and rubbish"]
[null,"removal, cleaning sevices, maintenance and"]
[null,"repairs, all as specified in COLTO, 1998 Edition "]
[null,"clause 1404 including the construction and "]
[null,"maintenance of the access roads, footpaths, etc."]
[]
[null,"(a)  Services at offices and laboratories:"]
[]
[null,"      (i)  Fixed costs","Lump sum",{"v":1,"d":"1.00"},null,{"$f":"D125*E125","v":0}]
[]
[null,"      (ii)  Running costs","month",{"$f":"'1300'!D18","v":{"v":8,"d":"8.00"}},null,{"$f":"D127*E127","v":0}]
[]
[null,"(d) Allow the provision amount for labourers' "]
[null,"     accomodation services on site, eating areas"]
[]
[null,"      (i)  Fixed costs","Lump sum",{"v":1,"d":"1.00"},null,{"$f":"D132*E132","v":0}]
[]
[null,"      (ii)  Running costs","month",{"$f":"D127","v":{"v":8,"d":"8.00"}},null,{"$f":"D134*E134","v":0}]
[]
[" 14.10","Provision of photostat facilities"]
[null,"Delete \"provision of photostat facilities\" and insert"]
[null,"the following provisional items which shall remain "]
[null,"the property of the Employer on project completion:"]
[]
[null,"(a). Allow amount of R 25 000, 00 for a A3/A4 table"]
[null,"      top toner laser, HP colour printer with scan.","Prov sum",{"v":1,"d":"1.00"},{"v":25000,"d":"25,000.00"},{"$f":"D142*E142","v":{"v":25000,"d":"25,000.00"}}]
[]
[null,"(b). Allow amount of R 40 000. 00 for NXH98EA.001"]
[null,"      Acer swift 7 laptop, Win 11 Pro, SF714-5ZT-"]
[null,"      77KA or HP Spectre X360, 15,6inch, 4K VHD "]
[null,"      touch i7 - 10750H.","Prov sum",{"v":1,"d":"1.00"},{"v":40000,"d":"40,000.00"},{"$f":"D147*E147","v":{"v":40000,"d":"40,000.00"}}]
[]
[null,"(c). Allow R 20 000, 00 for Acer swift 5 core i7"]
[null,"       win 11 notebook","Prov sum",{"v":1,"d":"1.00"},{"v":20000,"d":"20,000.00"},{"$f":"D150*E150","v":{"v":20000,"d":"20,000.00"}}]
[]
[null,"(d). Handling costs and profit in respect of"]
[null,"       subitems 14.10 (a), (b, and (c) above","%",{"$f":"SUM(E142+E147+E150)","v":{"v":85000,"d":"85,000.00"}},null,{"$f":"D153*E153","v":0}]
[]
[1400,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F90:F153)","v":{"v":123400,"d":"123,400.00"}}]

{"sheet":"1500","index":3,"n_rows":67,"n_cols":6,"rows_kept":67,"merged":[[0,0,0,5]]}
[{"$f":"'1400'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B: ROADWORKS"]
["SECTION 1500"]
["ACCOMMODATION OF TRAFFIC"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"ACCOMMODATION OF TRAFFIC"]
[]
["15.01","Accommodating traffic and maintaining "]
[" ","temporary deviations","km ",{"$f":"3.9","v":{"v":3.9,"d":"3.90"}},null,{"$f":"D11*E11","v":0}]
[]
["15.02","Earthworks for temporary deviations:"]
[]
[null,"(a)  Shaping of temporary deviations","km",{"$f":"D11","v":{"v":3.9,"d":"3.90"}},null,{"$f":"D15*E15","v":0}]
[]
[15.03,"Temporary traffic-control facilities:"]
[]
[null,"(a)  Flagmen","man-day",{"$f":"8*4*5*4","v":{"v":640,"d":"640.00"}},null,{"$f":"D19*E19","v":0}]
[]
[null,"(b)  Portable STOP and GO-RY signs","number",{"v":8,"d":"8.00"},null,{"$f":"D21*E21","v":0}]
[]
[null,"(e)  Road signs, R- and TR-series, 900mm","number",{"v":8,"d":"8.00"},null,{"$f":"D23*E23","v":0}]
[]
[null,"(f)  Road signs, TW-series, 900mm side","number",{"v":4,"d":"4.00"},null,{"$f":"D25*E25","v":0}]
[]
[null,"(g)  Road signs, STW-, DTG-, TGS- and TG-"]
[null,"       series (excluding delineators and barricades)","m²",{"v":20,"d":"20.00"},null,{"$f":"D28*E28","v":0}]
[]
[null,"(i)   Movable barricade/road sign combination","number",{"v":4,"d":"4.00"},null,{"$f":"D30*E30","v":0}]
[]
[null,"(j)   Traffic cones, (750mm high)","number",{"v":30,"d":"30.00"},null,{"$f":"D32*E32","v":0}]
[]
["15.04","Relocation of traffic-control facilities","Lump sum",{"v":1,"d":"1.00"},null,{"$f":"D34*E34","v":0}]
[]
["15.06","Watering of temporary deviations","kilolitre",{"v":2000,"d":"2,000.00"},null,{"$f":"D36*E36","v":0}]
[]
[15.07,"Blading by road grader of:"]
[]
[null,"(a)  Temporary deviations","km-pass",{"v":180,"d":"180.00"},null,{"$f":"D40*E40","v":0}]
[]
[null,"(b) Existing roads used as temporary deviations","km-pass",{"v":110,"d":"110.00"},null,{"$f":"D42*E42","v":0}]
[]
[]
[]
[]
[]
[]
[null,null," "]
{"$rows_empty":17}
[1500,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F11:F65)","v":0}]

{"sheet":"1700","index":4,"n_rows":65,"n_cols":6,"rows_kept":65,"merged":[[0,0,0,5]]}
[{"$f":"'1500'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 1700"]
["CLEARING AND GRUBBING"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"CLEARING AND GRUBBING"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[null,"NOTE: Provide rates for all items below"]
[]
[17.01,"Clearing and grubbing of:"]
[]
[null,"(a)  Normal areas"]
[]
[null,"     (ii) In borrow areas"," ha",{"v":1,"d":"1.00"},null,{"$f":"D20*E20","v":0}]
[]
[17.02,"Removal and grubbing of large trees and "]
[null,"tree stumps:"]
[]
[null,"(a)  Girth exceeding 1 m up to and including 2 m","number",{"v":1,"d":"1.00"},null,{"$f":"D25*E25","v":0}]
[]
[null,"(b)  Girth exceeding 2m up to and including 3m","number",0,null,{"$f":"D27*E27","v":0}]
[]
[17.03,"Re-clearing of surfaces (on written instruction of"]
[null,"the Engineer Only)","ha",{"v":1,"d":"1.00"},null,{"$f":"D30*E30","v":0}]
[]
[17.04,"Clearing and grubbing at inlets and outlets "]
[null,"of hydraulic structures","m2",{"v":4,"d":"4.00"},null,{"$f":"D33*E33","v":0}]
[]
[17.05,"Cleaning out of Hydraulic structures"]
[]
[null,"(a) Pipes with internal diameter up to and including "]
[null,"     750mm","m3",0,null,{"$f":"D38*E38","v":0}]
[]
[null,"(b) Pipes with internal diameter up to and "]
[null,"     exceeding 750mm","m3",0,null,{"$f":"D41*E41","v":0}]
[]
[null,"(c) Box culvets up to and including 1.5m vertical"]
[null,"     dimensions","m3",{"v":4,"d":"4.00"},null,{"$f":"D44*E44","v":0}]
[]
[null,"(c) Box culvets up to and exceeding 1.5m vertical"]
[null,"     dimensions","m3",0,null,{"$f":"D47*E47","v":0}]
{"$rows_empty":17}
["1700","TOTAL CARRIED  TO SUMMARY",{"$nulls":3},{"$f":"SUM(F20:F47)","v":0}]

{"sheet":"2100","index":5,"n_rows":60,"n_cols":6,"rows_kept":60,"merged":[[0,0,0,5]]}
[{"$f":"'1700'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 2100"]
["DRAINS"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"DRAINS"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
["21.01","Excavation for open drains:"]
[]
[null,"(a)  Excavating soft material situated within the "]
[null,"       following depth ranges below the surface "]
[null,"       level:"]
[]
["LI","              (i)  0 m up to 1,5 m","m³",{"v":890,"d":"890.00"},null,{"$f":"SUM(D20*E20)","v":0}]
[]
[null,"(b)   Extra over subitem 21.01(a) for excavation "]
[null,"        in hard material, irrespective of depth","m³",{"v":60,"d":"60.00"},null,{"$f":"SUM(D23*E23)","v":0}]
[]
[21.02,"Clearing and shaping open drains","m³",{"v":250,"d":"250.00"},null,{"$f":"SUM(D25*E25)","v":0}]
["LI"]
{"$rows_empty":33}
[2100,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F17:F28)","v":0}]

{"sheet":"2200 ","index":6,"n_rows":69,"n_cols":8,"rows_kept":69,"merged":[[0,0,0,7],[5,1,5,3],[68,1,68,6]]}
[{"$f":"'2100'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 2200"]
["PREFABRICATED CULVERTS"]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"PREFABRICATED CULVERTS"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[null,"NOTE: Rate only items, Provide all rates"]
[]
["22.01","Excavation:"]
[" "]
[null,"(a)","Excavating soft material situated within the"]
[null,null,"following depth ranges below the surface "]
[null,null,"level:"]
[]
["LI",null,"(i)","0 m up to 1,5 m","m³",{"v":180,"d":"180.00"},null,{"$f":"F22*G22","v":0}]
[]
[null,"(b)","Extra over subitem 22.01(a) for excavation "]
[null,null,"in hard material, irrespective of depth",null,"m³",{"v":40,"d":"40.00"},null,{"$f":"F25*G25","v":0}]
[]
[" 22.02","Backfilling:"]
[]
["LI","(a)","Using the excavated material",null,"m³",{"v":60,"d":"60.00"},null,{"$f":"F29*G29","v":0}]
[]
["LI","(c)","Extra over subitems 22.02(a) for soil cement"]
[null,null,"backfilling containing 3% cement*",null,"m³",{"v":10,"d":"10.00"},null,{"$f":"F32*G32","v":0}]
[]
[" 22.03","Concrete pipe culverts:"]
[]
[null,"(a)","On class A bedding:"]
[]
["LI",null,"(i)","600mm dia 75D","m",{"v":40,"d":"40.00"},null,{"$f":"F38*G38","v":0}]
[]
["LI",null,"(ii)","675mm dia 75D","m",{"v":40,"d":"40.00"},null,{"$f":"F40*G40","v":0}]
[]
[22.05,"Portal and rectangular culverts:"]
[]
[null,"(a)","Complete with prefabricated floor slabs "]
[]
["LI",null,"(i)","600mm X 450mm class 100s","m",{"v":100,"d":"100.00"},null,{"$f":"F46*G46","v":0}]
[]
["LI",null,"(ii)","900mm X 450mm class 100s","m",{"v":12,"d":"12.00"},null,{"$f":"F48*G48","v":0}]
{"$rows_empty":20}
[" 2200","TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H21:H66)","v":0}]

{"sheet":"2300","index":7,"n_rows":64,"n_cols":6,"rows_kept":64,"merged":[[0,0,0,5]]}
[{"$f":"'2200 '!A1:H1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 2300"]
["CONCRETE KERBING"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"CONCRETE KERBING, CONCRETE"]
[null,"CHANNELLING, CHUTES AND DOWNPIPES,"]
[null,"AND CONCRETE LININGS FOR OPEN DRAINS"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[23.02,"Concrete kerbing-channelling combination"]
[]
["LI","(a)  300mm x 300mm 30Mpa insitu edgebeam","m",{"v":60,"d":"60.00"},null,{"$f":"D18*E18","v":0}]
[]
["LI","(b)  Figure 16 heavyduty edgebeam","m",0,null,{"$f":"D20*E20","v":0}]
[]
["LI","(c)  Figure 8c heavy duty kerb mountable with"]
[null,"       castle bottom including 25Mpa haunching","m",{"$f":"3900*2","v":{"v":7800,"d":"7,800.00"}},null,{"$f":"D23*E23","v":0}]
[]
[23.07,"Trimming of excavations for concrete-lined"]
[null,"open drains:"]
[]
["LI","(a)  In soft material","m²",{"v":320,"d":"320.00"},null,{"$f":"D28*E28","v":0}]
[]
[23.08,"Concrete lining for open drains:"]
[]
["LI","(a)  Cast in situ class  concrete 30/19"]
[null,"       lining in V drains","m³",{"v":420,"d":"420.00"},null,{"$f":"D33*E33","v":0}]
[]
["LI","(b)  Class U2 surface finish to cast in situ "]
[null,"       concrete in V drains","m²",{"v":280,"d":"280.00"},null,{"$f":"D36*E36","v":0}]
{"$rows_empty":27}
[2300,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F16:F61)","v":0}]

{"sheet":"3100","index":8,"n_rows":62,"n_cols":6,"rows_kept":62,"merged":[[0,0,0,5]]}
[{"$f":"'2300'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 3100"]
["BORROW MATERIALS"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"BORROW MATERIALS"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[null,"NOTE: Price must include haulage"]
[]
[31.01,"Excess overburden in borrow pits for                 "]
[null,"obtaining crushed stone for pavement layers"]
[]
[null,"(a)  In all depths but not exceeding 2m and types","m³",{"$f":"0.45*3900*6","v":{"v":10530,"d":"10,530.00"}},null,{"$f":"D19*E19","v":0}]
[]
[31.03,"Finishing-off borrow areas in:"]
[]
[null,"(a)  Soft material","ha",{"$f":"D19/5000","v":{"v":2.106,"d":"2.11"}},null,{"$f":"D23*E23","v":0}]
[]
[31.04,"Compensation to Landowners"]
[]
[null,"(a)  Prime Cost sum for compensation to"]
[null,"      landowners ","PC sum",{"v":1,"d":"1.00"},{"v":140000,"d":"140,000.00"},{"$f":"D28*E28","v":{"v":140000,"d":"140,000.00"}}]
[]
[null,"(b)  Handling cost and profit in respect of sub-item"]
[null,"      31.04(a) above","%",{"$f":"E28","v":{"v":140000,"d":"140,000.00"}},null,{"$f":"D31*E31","v":0}]
{"$rows_empty":30}
[3100,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F18:F61)","v":{"v":140000,"d":"140,000.00"}}]

{"sheet":"3200","index":9,"n_rows":58,"n_cols":6,"rows_kept":58,"merged":[[0,0,0,5]]}
[{"$f":"'3100'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 3200"]
["MATERIAL STOCKPILE"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"SELECTION, STOCKPILING AND BREAKING-"]
[null,"DOWN THE MATERIAL FROM BORROW PITS,"]
[null,"CUTTINGS AND EXISTING PAVEMENT"]
[null,"LAYERS, AND PLACING AND COMPACTING"]
[null,"THE GRAVEL LAYERS "]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[null,"NOTE: Price must include haulage"]
[]
[32.06," Stockpiling of material ","m³",{"$f":"'3100'!D19","v":{"v":10530,"d":"10,530.00"}},null,{"$f":"D20*E20","v":0}]
{"$rows_empty":37}
[3200,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F20:F55)","v":0}]

{"sheet":"3300","index":10,"n_rows":61,"n_cols":6,"rows_kept":61,"merged":[[0,0,0,5]]}
[{"$f":"'3200'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 3300"]
["MASS EARTHWORKS"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"MASS EARTHWORKS"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[" ","of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[null,"NOTE: Price must include haulage"]
[]
["33.04","Cut to spoil, including unlimited free-haulage "]
[null,"material obtained from:"]
[]
[null,"(a)  Soft excavation","m³",{"$f":"'3200'!D20","v":{"v":10530,"d":"10,530.00"}},null,{"$f":"D19*E19","v":0}]
[]
[" 33.09","Material bladed to windrow              ","m³",{"$f":"D19*2%","v":{"v":210.6,"d":"210.60"}},null,{"$f":"D21*E21","v":0}]
[]
[" 33.10","Roadbed preparation and the compaction of "]
[null,"material:"]
[]
[null,"(b)  Compaction to 93% of modified AASHTO "]
[null,"       density","m³",{"$f":"3900*5.6*0.15","v":{"v":3276,"d":"3,276.00"}},null,{"$f":"D27*E27","v":0}]
[]
[33.11,"Three roller passes compaction"]
[]
[null,"(a) Vibratory roller","m2",{"$f":"3900*6","v":{"v":23400,"d":"23,400.00"}},null,{"$f":"D31*E31","v":0}]
[]
["33(a)","Shallow milling (150mm)","m³",0,null,{"$f":"D33*E33","v":0}]
[]
["33(b)","Deep milling (300mm)","m³",0,null,{"$f":"D35*E35","v":0}]
{"$rows_empty":25}
[3300,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F17:F58)","v":0}]

{"sheet":"3400 ","index":11,"n_rows":74,"n_cols":6,"rows_kept":74,"merged":[[0,0,0,5]]}
[{"$f":"'3300'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 3400"]
["PAVEMENT LAYERS OF GRAVEL MATERIAL"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"PAVEMENT LAYERS OF GRAVEL MATERIAL"]
[null,"The Contractor must provide rates on all items, should the"]
[null,"Contractor not provide a rate for some of items, and is instructed"]
[null,"instructed to utilize such, no payment shall be made"]
[]
[null,"NOTE: Price must include haulage"]
[]
["34.01","Pavement layers constructed from gravel take from cut or"]
[null,"borrow including free-haul up to 1,0km:"]
[]
[null,"(a)  Gravel selected layer compacted to:"]
[]
[null,"      (i)   95% of modified AASHTO density for a compacted"]
[null,"            layer thickness of 150 mm","m³",{"$f":"'3300'!D27","v":{"v":3276,"d":"3,276.00"}},null,{"$f":"D21*E21","v":0}]
[]
[null,"(c)  G6/G7 gravel subbase (unstabilized material) compacted to:"]
[]
[null,"     (i)  97% of modified AASHTO density for a compacted layer"]
[null,"          thickness of 150 mm","m³",{"$f":"D21","v":{"v":3276,"d":"3,276.00"}},null,{"$f":"D26*E26","v":0}]
[]
[null,"(f)  G6/G7 Gravel base (C3 -stabilized material) compacted to:"]
[]
[null,"      (ii)  98% of modified AASHTO density for a compacted layer"]
[null,"           thickness of 150 mm","m³",{"$f":"D26","v":{"v":3276,"d":"3,276.00"}},null,{"$f":"D31*E31","v":0}]
{"$rows_empty":42}
[3400,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F21:F69)","v":0}]

{"sheet":"3500","index":12,"n_rows":56,"n_cols":6,"rows_kept":56,"merged":[[0,0,0,5]]}
[{"$f":"'3400 '!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 3500"]
["STABILIZATION"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"STABILIZATION"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
["35.01","Chemical stabilization extra over unstabilized "]
[null,"compacted layers:"]
[]
[null,"(b) Gravel base 150 mm thick","m³",{"$f":"'3400 '!D31","v":{"v":3276,"d":"3,276.00"}},null,{"$f":"D17*E17","v":0}]
[]
["35.02","Chemical stabilizing agent:"]
[]
[null,"(a) Ordinary Portland cement: Base","t",{"$f":"'3400 '!D31*2082*3%/1000","v":{"v":204.61896,"d":"204.62"}},null,{"$f":"D21*E21","v":0}]
[null,"     (i) Shall comply with the requirements of SABS"]
[null,"         471. Rapid hardening portlant cement shall"]
[null,"         not be used."]
[]
[35.04,"Provision and application of water for curing","kl",{"v":2600,"d":"2,600.00"},null,{"$f":"D26*E26","v":0}]
{"$rows_empty":29}
["3500","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F17:F52)","v":0}]

{"sheet":"5100","index":13,"n_rows":62,"n_cols":6,"rows_kept":62,"merged":[[0,0,0,5],[3,0,3,5]]}
[{"$f":"'3500'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 5100"]
["PITCHING, STONEWORK AND PROTECTION AGAINST EROSION\n"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"PITCHING, STONEWORK AND PROTECTION"]
[null,"AGAINST EROSION"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[null,"NOTE: Rate only, provide rates"]
[]
[51.01,"Stone pitching:"]
[]
["LI","(a)  Plain pitching"]
[]
[null,"      (i)   Method 1","m²",{"v":100,"d":"100.00"},null,{"$f":"D21*E21","v":0}]
[]
[null,"      (ii)   Method 2","m²",{"v":100,"d":"100.00"},null,{"$f":"D23*E23","v":0}]
[]
["LI","(b)     Grouted stone pitching","m²",{"v":300,"d":"300.00"},null,{"$f":"D25*E25","v":0}]
{"$rows_empty":36}
["5100","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F21:F54)","v":0}]

{"sheet":"5400","index":14,"n_rows":64,"n_cols":6,"rows_kept":64,"merged":[[0,0,0,5]]}
[{"$f":"'5100'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 5400"]
["GUARDRAILS"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"GUARDRAILS"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[null,"NOTE: Rate only, provide rates"]
[]
[54.01,"Guardrails on timber posts: "]
[]
["LI","(a)  Galvanized \n","m",0,null,{"$f":"D18*E18","v":0}]
[]
[null,"(b) Painted","m",0,null,{"$f":"D20*E20","v":0}]
[]
[54.02,"End treatments:"]
[]
["LI","(a)  End wings","number",0,null,{"$f":"D24*E24","v":0}]
[]
["LI","(b)  Bull noses","number",0,null,{"$f":"D26*E26","v":0}]
[]
["LI","(c)  End treatments in accordance with the"]
[null,"      Drawings where single guardrail sections are"]
[null,"      used","number",0,null,{"$f":"D30*E30","v":0}]
[]
["LI","(d)  End treatments in accordance with the"]
[null,"      Drawings where double guardrail sections"]
[null,"      are used","number",0,null,{"$f":"D34*E34","v":0}]
[]
[54.03,"Additional guardrail posts:"]
[]
["LI","(a) Timber","number",0,null,{"$f":"D38*E38","v":0}]
[]
[54.04,"Reflective plates","number",0,null,{"$f":"D40*E40","v":0}]
["LI"]
{"$rows_empty":22}
[5400,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F18:F60)","v":0}]

{"sheet":"5600","index":15,"n_rows":68,"n_cols":6,"rows_kept":68,"merged":[[0,0,0,5]]}
[{"$f":"'5400'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 5600"]
["ROAD SIGNS"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"ROAD SIGNS"]
[null,"The Contractor must provide rates on all items, should the"]
[null,"Contractor not provide a rate for some of items, and is"]
[null,"instructed to utilize such, no payment shall be made."]
[]
["A56,11","Regulatory Signs and Warning Signs\n"]
[]
[null,"NOTE: Price to include excavation in all class of material, "]
[null,"backfill, compaction and material treatment"]
[]
["LI","(a) Supply and install a complete \"STOP SIGNS\" with galvanized"]
[null,"     supports posts including  bolds and nuts. The galvanized"]
[null,"     posts should be engraved   \"TLM/005/2022/23\" while stop "]
[null,"     signs must reflect  the manufacture date and"]
[null,"     \"TLM005/2022/23\" at the back. Ref: COLTO and SANS1200.","No",{"v":8,"d":"8.00"},null,{"$f":"D22*E22","v":0}]
[]
["LI","(b) Supply and install a complete \"YIELD SIGNS\" with galvanized"]
[null,"     supports posts including  bolds and nuts. The galvanized"]
[null,"     posts should be engraved \"TLM/005/2022/23\" while yield"]
[null,"     signs must reflect  the manufacture date and"]
[null,"     \"TLM/005/2022/23\" at the back.","No",{"v":8,"d":"8.00"},null,{"$f":"D28*E28","v":0}]
[]
["LI","(c) Supply and install complete \"200mm * 800mm HAZARD "]
[null,"     PLATES\" with galvanized supports posts including  bolds and "]
[null,"     nuts. The galvanized posts should be engraved "]
[null,"     \"TLM/005/2022/23\" while hazard signs must reflect  the "]
[null,"     manufacture date and \"TLM/005/2022/23\" at the back.","No",{"v":12,"d":"12.00"},null,{"$f":"D34*E34","v":0}]
{"$rows_empty":33}
[5600,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F22:F64)","v":0}]

{"sheet":"5700","index":16,"n_rows":66,"n_cols":8,"rows_kept":66,"merged":[[0,0,0,7],[5,1,5,3],[13,1,13,3],[65,1,65,6]]}
[{"$f":"'5600'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROAD MARKINGS"]
["SECTION 5700"]
["ROAD MARKINGS"]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"ROAD MARKINGS"]
[null,"The Contractor must provide rates on all items, should the"]
[null,"Contractor not provide a rate for some of items, and is"]
[null,"instructed to utilize such, no payment shall be made."]
[]
[57.02,"Retro-reflective road-marking paint: Water based"]
[null,"paint applied at 0.6 l/ m². (Paint to be approved by\nm²\n"]
[null,"the Employer  and the Engineer first with no"]
[null,"additional costs or shop material sample compensation)"]
[]
["LI","(a)","White lines (broken or unbroken):"]
[]
[null,null,"(i)","100 mm wide","km",{"$f":"3.9","v":{"v":3.9,"d":"3.90"}},null,{"$f":"F20*G20","v":0}]
[]
[null,null,"(iii)","200 mm wide","km",{"$f":"3.9","v":{"v":3.9,"d":"3.90"}},null,{"$f":"F22*G22","v":0}]
[]
["LI","(d)","White lettering and symbols",null,"m²",{"v":12,"d":"12.00"},null,{"$f":"F24*G24","v":0}]
[]
[57.06,"Setting out and premarking the lines (excluding"]
[null,"traffic-island markings, lettering and symbols).",null,null,"km",{"$f":"F20","v":{"v":3.9,"d":"3.90"}},null,{"$f":"F27*G27","v":0}]
[]
[57.07,"Re-establishing the painting unit at the end of "]
[null,"the maintenance period",null,null,"lump sum",{"v":1,"d":"1.00"},null,{"$f":"F30*G30","v":0}]
{"$rows_empty":35}
[" 5700","TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H20:H59)","v":0}]

{"sheet":"5900","index":17,"n_rows":56,"n_cols":6,"rows_kept":56,"merged":[[0,0,0,5]]}
[{"$f":"'5700'!A1:H1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 5900"]
["FINISHING THE ROAD AND ROAD RESERVE "]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"FINISHING THE ROAD AND ROAD RESERVE"]
[null,"AND TREATING OLD ROADS"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[59.01,"Finishing the road and road reserve"]
[]
[null,"(b)    Single carriageway road","km",{"$f":"3.9*2","v":{"v":7.8,"d":"7.80"}},null,{"$f":"D17*E17","v":0}]
[]
[59.02,"Treatment of old roads and temporary "]
[null,"deviations","km",{"$f":"3.9*2","v":{"v":7.8,"d":"7.80"}},null,{"$f":"D20*E20","v":0}]
{"$rows_empty":11}
[" "," "," "]
[null," "]
[null," "]
[null," "]
{"$rows_empty":20}
["5900","TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":3},{"$f":"SUM(F16:F52)","v":0}]

{"sheet":"7300","index":18,"n_rows":62,"n_cols":6,"rows_kept":62,"merged":[[0,0,0,5],[3,0,3,1]]}
[{"$f":"'5900'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 7300"]
["CONCRETE BLOCK PAVING FOR ROADS"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[7300,"CONCRETE BLOCK PAVING FOR ROADS (GREY)"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
[73.01,"Concrete block paving"]
[]
["LI","(a)  200mm x 100mm x 60mm, 30Mpa grey heavy duty"]
[null,"       interlocking paving laid in a herringbone pattern","m²",{"$f":"3900*6","v":{"v":23400,"d":"23,400.00"}},null,{"$f":"D17*E17","v":0}]
[]
["LI","(c)  20mm bedding sand applied underneath bricks","m²",{"$f":"D17","v":{"v":23400,"d":"23,400.00"}},null,{"$f":"D19*E19","v":0}]
[]
["LI","(d)  Cemented locking sand broomed evenly ","m²",{"$f":"D19","v":{"v":23400,"d":"23,400.00"}},null,{"$f":"D21*E21","v":0}]
[]
[73.02,"Cast in-situ concrete edge and intermediate"]
[null,"beams"]
[]
["LI","(a)  200mm wide x 300mm deep,  class 30/19"]
[null,"       concrete (measured elsewhere)","m³",{"$f":"0.2*0.3*6*25","v":{"v":9,"d":"9.00"}},null,{"$f":"D27*E27","v":0}]
[]
[73.03,"Provision of approved herbicides and ant"]
[null,"poison","litre",{"$f":"D19*2","v":{"v":46800,"d":"46,800.00"}},null,{"$f":"D30*E30","v":0}]
[]
[73.04,"Construct Complete Speed Hump / Pedestrian"]
["LI","crossing as per drawing,  road markings and traffic \n"]
[null,"sign measured elsewhere","number",{"v":9,"d":"9.00"},null,{"$f":"D34*E34","v":0}]
{"$rows_empty":27}
[7300,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F17:F59)","v":0}]

{"sheet":"8100","index":19,"n_rows":58,"n_cols":6,"rows_kept":58,"merged":[[0,0,0,5]]}
[{"$f":"'7300'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SCHEDULE B : ROADWORKS"]
["SECTION 8100"]
["TESTING MATERIALS AND WORKMANSHIP"]
[]
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"TESTING MATERIALS AND WORKMANSHIP"]
[null,"The Contractor must provide rates on all items,"]
[null,"should the Contractor not provide a rate for some"]
[null,"of items, and is instructed to utilize such, no"]
[null,"payment shall be made."]
[]
["81.02","Other special tests requested by the"]
[null,"Engineer:"]
[]
[null,"(a)     Cost of testing","PC  sum",{"v":1,"d":"1.00"},{"v":100000,"d":"100,000.00"},{"$f":"D17*E17","v":{"v":100000,"d":"100,000.00"}}]
[]
[null,"(b)     Charge on provisional sum for"]
[null,"         overheads and profits","%",{"$f":"E17","v":{"v":100000,"d":"100,000.00"}},null,{"$f":"D20*E20","v":0}]
{"$rows_empty":37}
["8100","TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F17:F53)","v":{"v":100000,"d":"100,000.00"}}]

{"sheet":"GENERAL SUMMARY","index":20,"n_rows":39,"n_cols":3,"rows_kept":39,"merged":[[0,0,0,2],[1,0,1,2],[28,0,28,2],[29,0,29,2],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1]]}
[{"$f":"'8100'!A1:F1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
["SUMMARY OF SCHEDULE  OF QUANTITIES"]
["ITEM","DESCRIPTION","AMOUNT"]
[null,"SUMMARY OF SCHEDULE A :   GENERAL"]
[1200,"GENERAL REQUIREMENTS AND PROVISIONS",{"$f":"'1200'!G249","v":{"v":982200,"d":"982,200.00"}}]
[1300,"CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS",{"$f":"'1300'!F73","v":0}]
[1400,"HOUSING, OFFICES AND LABORATORY FOR THE ENGINEER'S SITE PERSONNEL",{"$f":"'1400'!F155","v":{"v":123400,"d":"123,400.00"}}]
[null,"SUB-TOTAL TO MAIN SUMMARY  :  ",{"$f":"SUM(C5:C7)","v":{"v":1105600,"d":"1,105,600.00"}}]
[null,"SUMMARY OF SCHEDULE B :   ROADWORKS"]
[1500,"ACCOMMODATION OF TRAFFIC",{"$f":"'1500'!F67","v":0}]
[1700,"CLEARING AND GRUBBING",{"$f":"'1700'!F65","v":0}]
[2100,"DRAINS",{"$f":"'2100'!F60","v":0}]
[2200,"PREFABRICATED CULVERTS ",{"$f":"'2200 '!H69","v":0}]
[2300,"CONCRETE KERBING",{"$f":"'2300'!F64","v":0}]
[3100,"BORROW MATERIALS",{"$f":"'3100'!F62","v":{"v":140000,"d":"140,000.00"}}]
[3200,"MATERIAL STOCKPILE",{"$f":"'3200'!F58","v":0}]
[3300,"MASS EARTHWORKS",{"$f":"'3300'!F61","v":0}]
[3400,"PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$f":"'3400 '!F74","v":0}]
[3500,"STABILISATION",{"$f":"'3500'!F56","v":0}]
[5100,"PITCHING, STONEWORK AND PROTECTION AGAINST EROSION",{"$f":"'5100'!F62","v":0}]
[5400,"GUARDRAILS",{"$f":"'5400'!F64","v":0}]
[5600,"ROAD SIGNS",{"$f":"'5600'!F68","v":0}]
[5700,"ROAD MARKINGS",{"$f":"'5700'!H66","v":0}]
[5900,"FINISHING THE ROAD AND ROAD RESERVE AND TREATMENT OF OLD ROADS",{"$f":"'5900'!F56","v":0}]
[7300,"CONCRETE BLOCK PAVING FOR ROADS",{"$f":"'7300'!F62","v":0}]
[8100,"TESTING MATERIALS AND WORKMANSHIP",{"$f":"'8100'!F58","v":{"v":100000,"d":"100,000.00"}}]
[null,"SUB-TOTAL CARRIED FORWARD TO FINAL SUMMARY  :  ",{"$f":"SUM(C10:C26)","v":{"v":240000,"d":"240,000.00"}}]
[]
["FINAL SUMMARY"]
[]
["DESCRIPTION",null,"AMOUNT"]
["SCHEDULE A:  GENERAL",null,{"$f":"C8","v":{"v":1105600,"d":"1,105,600.00"}}]
["SCHEDULE B:  ROADWORKS",null,{"$f":"C27","v":{"v":240000,"d":"240,000.00"}}]
["SUB-TOTAL 1",null,{"$f":"C32+C33","v":{"v":1345600,"d":"1,345,600.00"}}]
["ADD CONTINGENCIES @ 10%",null,{"$f":"C34*10%","v":{"v":134560,"d":"134,560.00"}}]
["SUB-TOTAL 2",null,{"$f":"C34+C35","v":{"v":1480160,"d":"1,480,160.00"}}]
["ADD VALUE ADDED TAX (VAT) @ 15% ",null,{"$f":"C36*15%","v":{"v":222024,"d":"222,024.00"}}]
["SUB-TOTAL 3",null,{"$f":"C36+C37","v":{"v":1702184,"d":"1,702,184.00"}}]
["TOTAL TENDER SUM CARRIED TO THE FORM OF TENDER",null,{"$f":"C38","v":{"v":1702184,"d":"1,702,184.00"}}]

{"sheet":"SUMMARY","index":21,"n_rows":32,"n_cols":3,"rows_kept":32,"merged":[[1,0,2,2],[4,0,4,2],[25,0,25,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,1,31,2],[32,0,32,2]]}
[]
[{"$f":"'GENERAL SUMMARY'!A1","v":"RECONSTRUCTION OF FRISGEWAAGT INTERNAL ROADS AND STORMWATER PHASE 1 - WARD 6"}]
[]
[]
["FINAL SUMMARY"]
[]
["DESCRIPTION",null,"AMOUNT"]
[]
["SCHEDULE A:  GENERAL",":",{"$f":"'GENERAL SUMMARY'!C8","v":{"v":1105600,"d":"1,105,600.00"}}]
[]
["SCHEDULE B:  ROADWORKS",":",{"$f":"'GENERAL SUMMARY'!C27","v":{"v":240000,"d":"240,000.00"}}]
[]
["SUB-TOTAL 1",":",{"$f":"C9+C11","v":{"v":1345600,"d":"1,345,600.00"}}]
[]
["ADD CONTINGENCIES @ 10%",":",{"$f":"C13*10%","v":{"v":134560,"d":"134,560.00"}}]
[]
["SUB-TOTAL 2",":",{"$f":"C13+C15","v":{"v":1480160,"d":"1,480,160.00"}}]
[]
["ADD VALUE ADDED TAX (VAT) @ 15% ",null,{"$f":"C17*15%","v":{"v":222024,"d":"222,024.00"}}]
[]
["SUB-TOTAL 3",":",{"$f":"C17+C19","v":{"v":1702184,"d":"1,702,184.00"}}]
[]
[]
["TOTAL TENDER SUM CARRIED TO THE FORM OF TENDER",":",{"$f":"C21","v":{"v":1702184,"d":"1,702,184.00"}}]
[]
["TENDERER : ________________________________________________________________________"]
[]
[]
["NAME & SURNAME : _________________________________________________________________"]
[]
[]
["SIGNATURE : ___________________________","DATE : ___________________"]