{"text_format":"3","workbook":"xlsx","n_sheets":30,"sheets":["Version","C1.2","C1.3","C1.4","C1.5","C1.6","C1.7","C2.1","C3.1","C3.2","C4.1","C4.3","C4.4","C5.1","C5.3","C5.4","C8.1","C8.8","C9.1","C10.1","C11.1","C11.2","C11.4","C11.6","C11.7","C11.9","C13.7","C20.1","Sect D - D1000","Summary of Pricing"],"not_rendered":{"defined_names":161},"read":"whole","date_system":"1900"}

{"sheet":"Version","index":0,"n_rows":173,"n_cols":6,"rows_kept":173}
[]
["This Pricing Schedule is based on the COTO Draft Standard (DS) October 2020, and updated for the Works ProForma Book 3 - 2022.1 – June 2022 version saved in EDMS folder 7475454"]
{"$rows_empty":146}
[{"$nulls":5},"metre (m)"]
[{"$nulls":5},"metre (m)"]
[]
[]
[]
[]
["C2.3.27",{"$nulls":3},"Extra over item C2.3.21 for encasing (wrapping) joints "]
[null,"C2.3.27.1",null,null,"State for each water main the number of joints to be encased (wrapped)"]
[{"$nulls":4},"State diameter"]
[{"$nulls":4},"State diameter"]
["C2.3.28",{"$nulls":3},"Installation of hydrants and water meters "]
[null,"C2.3.28.1",null,null,"Describe hydrant type"]
[null,"C2.3.28.2",null,null,"Describe water meter type"]
[null,"C2.3.28.3",null,null,"Etc., insert additional items as required"]
["C2.3.29",{"$nulls":3},"Bedding for water mains (Class B and C) and fill blanket compacted to 90 % of MDD (100 % for sand)"]
[null,"C2.3.29.1"]
[]
[null,null,"(c)"]
[null,null,"(d)"]
[null,null,"(e)"]
[null,"C2.3.29.2"]
[]
[null,null,"(c)"]
[null,null,"(d)"]
[null,null,"(e)"]

{"sheet":"C1.2","index":1,"n_rows":58,"n_cols":8,"rows_kept":58,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
["CONTRACT SANRAL N.012-150-2020/1"]
["FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"]
["C1.2",{"$nulls":3},"GENERAL REQUIREMENTS AND PROVISIONS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C1.2.1",null,null,"Environmental Management"]
[null,"C1.2.1.1",null,"Monitoring of compliance with and reporting on the EMP","month",19,0,{"$f":"F8*G8","v":0}]
[null,"C1.2.1.2",null,"Dedicated environmental officer","month",19,0,{"$f":"F9*G9","v":0}]
["C1.2.2",null,null,"Programming and Reporting"]
[null,"C1.2.2.3",null,"Submission of a Scheme 2 Initial Programme","lump sum","lump","sum",0]
[null,"C1.2.2.4",null,"Submission of a Scheme 2 Full Programme","lump sum","lump","sum",0]
[null,"C1.2.2.5",null,"Reviewing and updating a Scheme 2 programme every month","month",18,0,{"$f":"F13*G13","v":0}]
[null,"C1.2.2.6",null,"Preparation and submission of all information and reports specified in the Contract Documentation","month",18,0,{"$f":"F14*G14","v":0}]
[null,"C1.2.3.13",null,"Liaison with the routine road maintenance contractor","month",19,0,{"$f":"F15*G15","v":0}]
["C1.2.3",null,null,"Routine road maintenance of existing public roads within the Site of the Works or other public roads outside the Site of the Works which are used as detours"]
[null,"C1.2.3.6",null,"Base and/or surface patching using cold premixed asphalt","kilogram (kg)",200,0,{"$f":"F17*G17","v":0}]
[null,"C1.2.3.11",null,"Other road maintenance work ordered by the Engineer","provisional sum","Prov","Sum",{"v":100000,"d":"R100,000.00"}]
[null,"C1.2.3.12",null,"Handling cost, profit and all other charges in respect of item C1.2.3.11","percentage (%)",{"$f":"H18","v":{"v":100000,"d":"R100,000.00"}},{"v":0,"d":"0.00%"},{"$f":"G19*F19","v":0}]
[null,"C1.2.3.13",null,"Liaison with the routine road maintenance contractor","month",21,0,{"$f":"F20*G20","v":0}]
["C1.2.4",null,null,"Stakeholder liaison","month",20,0,{"$f":"F21*G21","v":0}]
["C1.2.5",null,null,"Safety "]
[null,"C1.2.5.1",null,"Health and safety plan","lump sum","lump","sum",0]
[null,"C1.2.5.2",null,"Implementation of health and safety plan","month",18,0,{"$f":"F24*G24","v":0}]
["PC1.2.7",null,null,"Road safety audits"]
[null,"C1.2.7.1",null,"Stage 4 work zone traffic management audit","provisional sum","Prov","Sum",{"v":80000,"d":"R80,000.00"}]
[null,"C1.2.7.2",null,"Handling cost, profit and all other charges in respect of item C1.2.7.1","percentage (%)",{"$f":"H26","v":{"v":80000,"d":"R80,000.00"}},{"v":0,"d":"0.00%"},{"$f":"G27*F27","v":0}]
[null,"C1.2.7.3",null,"Stage 5 pre-opening stage traffic safety audit","provisional sum","Prov","Sum",{"v":80000,"d":"R80,000.00"}]
[null,"C1.2.7.4",null,"Handling cost, profit and all other charges in respect of item C1.2.7.3","percentage (%)",{"$f":"H28","v":{"v":80000,"d":"R80,000.00"}},{"v":0,"d":"0.00%"},{"$f":"G29*F29","v":0}]
["C1.2.8",null,null,"Dayworks"]
[null,"C1.2.8.1",null,"Personnel"]
[null,null,"(a)","Unskilled labourer","hour (h)",200,0,{"$f":"F32*G32","v":0}]
[null,null,"(b)","Semi-skilled labourer","hour (h)",150,0,0]
[null,"C1.2.8.2",null,"Construction equipment (specify size and/or model number)"]
[null,null,"(a)","Motor grader","hour (h)",50,0,{"$f":"F35*G35","v":0}]
[null,null,"(b)","Vibratory roller","hour (h)",50,0,0]
[null,null,"(c)","Pneumatic roller","hour (h)",50,0,0]
[null,null,"(d)","Front end loader","hour (h)",20,0,0]
[null,null,"(e)","Tractor loader backhoe","hour (h)",50,0,0]
[null,null,"(f)","Excavator","hour (h)",50,0,0]
[null,null,"(h)","Milling Machine (Size as required requested by the Engineer)","hour (h)",30,0,0]
[null,"C1.2.8.3",null,"Vehicles (specify size)"]
[null,null,"(c)","Dump truck - 10m3 Capacity","kilometre (km)",100,0,{"$f":"F43*G43","v":0}]
[null,null,"(d)","Lowbed establishment for plant which can not be driven on open road, which will require the Engineer's approval and must be substaintiated with an invoice","kilometre (km)",100,0,{"$f":"F44*G44","v":0}]
[null,"C1.2.8.4",null,"Materials"]
[null,null,"(a)","Procurement of materials","provisional sum","Prov","Sum",{"v":65000,"d":"R65,000.00"}]
[null,null,"(b)","Contractor's handling costs, profit and all other charges in respect of item C1.2.8.4(a)","percentage (%)",{"$f":"H46","v":{"v":65000,"d":"R65,000.00"}},{"v":0,"d":"0.00%"},{"$f":"G47*F47","v":0}]
[null,"C1.2.9.1",null,"Disposal of non-useable assets identified in the Contract Documentation at time of tender\n(list items and quantity)","rate (per asset)"]
[null,null,"(a)","Guard rails","metre (m)",20,0,{"$f":"F49*G49","v":0}]
[null,null,"(b)","Road Studs","number(No.)",5550,0,{"$f":"F50*G50","v":0}]
[null,"C1.2.9.2",null,"Disposal of non-useable assets not identified at time of tender","provisional sum","Prov","Sum",{"v":50000,"d":"R50,000.00"}]
[null,"C1.2.9.3",null,"Handling cost, profit and all other charges in respect of item C1.2.9.2","percentage (%)",{"$f":"H51","v":{"v":50000,"d":"R50,000.00"}},{"v":0,"d":"0.00%"},{"$f":"G52*F52","v":0}]
["PC1.2.10",null,null,"Dispute Adjudication Board (DAB)"]
[null,"C1.2.10.1",null,"Employer’s contribution to DAB (50%)","prime cost (PC) sum","Prime","Cost",{"v":200000,"d":"R200,000.00"}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H57)","v":{"v":575000,"d":"R575,000.00"}}]

{"sheet":"C1.3","index":2,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C1.2'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C1.2'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C1.3",{"$nulls":3},"CONTRACTOR’S SITE ESTABLISHMENT AND GENERAL OBLIGATIONS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["PC1.3.1",null,null,"The Contractor's general obligations"]
[null,"C1.3.1.1",null,"Fixed obligations","lump sum","lump","sum",0]
[null,"C1.3.1.2",null,"Value-related obligations","lump sum","lump","sum",0]
[null,"C1.3.1.3",null,"Time-related obligations"]
[null,null,"(a)","Mobilisation period","month",3,0,{"$f":"F11*G11","v":0}]
[null,null,"(b)","Execution of the works","month",18,0,0]
[null,"C1.3.1.4",null,"Suspension Cost"]
[null,null,"(a)","De-establishment","number",1,0,{"$f":"F14*G14","v":0}]
[null,null,"(b)","Re-establishment","number",1,0,0]
[null,null,"(c)","Suspension period","month",1,0,0]
[null,null,"(d)","Engineer's cost","prime cost (PC) sum","prime","cost",{"v":250000,"d":"R250,000.00"}]
["C1.3.2",null,null,"Contract sign boards","square metre (m2)",30,0,{"$f":"F18*G18","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H21)","v":{"v":250000,"d":"R250,000.00"}}]

{"sheet":"C1.4","index":3,"n_rows":73,"n_cols":7,"rows_kept":73,"merged":[[0,0,0,6],[1,0,1,6],[2,3,2,6]]}
[{"$f":"'C1.3'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C1.3'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C1.4",null,null,"FACILITIES FOR THE ENGINEER"]
["ITEM",null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C1.4.1",null,"Site accommodation"]
[null,"C1.4.1.1","Offices and conference room ","square metre (m2)",130,0,{"$f":"E8*F8","v":0}]
[null,"C1.4.1.2","Laboratories","square metre (m2)",130,0,0]
[null,"C1.4.1.3","Open concrete working floors and verandas","square metre (m2)",120,0,0]
[null,"C1.4.1.4","Roofs over open concrete working floors and verandas","square metre (m2)",140,0,0]
[null,"C1.4.1.5","Store rooms inside the laboratory ","square metre (m2)",20,0,0]
[null,"C1.4.1.6","Car ports","number (No.)",6,0,0]
[null,"C1.4.1.7","Ablution unit (As per COTO specification requirements to included a toilet and wash basin outside the Toilet per unit)","number (No.)",4,0,0]
[null,"C1.4.1.8","Change room with a shower","number (No.)",2,0,0]
[null,"C1.4.1.9","Kitchen unit (As per COTO Specification requirements to include a refridgerator, Microwave, Kettle, wash basin, cupboard with a table top and cutlery)","number (No.)",2,0,0]
["C1.4.2",null,"Items measured by area"]
[null,"C1.4.2.1","Shelving as specified, complete with brackets","square metre (m2)",null,null,{"$f":"E18*F18","v":0}]
[null,"C1.4.2.2","Work benches with a concrete slab top","square metre (m2)",10,0,0]
[null,"C1.4.2.3","Work-benches with a wooden top","square metre (m2)",10,0,0]
[null,"C1.4.2.4","Constant-temperature baths of concrete and/or plastered brick","square metre (m2)",1,0,0]
[null,"C1.4.2.5","Concrete footings and pedestals for laboratory equipment","square metre (m2)",10,0,0]
[null,"C1.4.2.7","Venetian blinds","square metre (m2)",15,0,0]
[null,"C1.4.2.8","Notice boards","square metre (m2)",4,0,0]
[null,"C1.4.2.9","White boards","square metre (m2)",10,0,0]
["C1.4.3",null,"Items measured by number"]
[null,"C1.4.3.1","Office swivel chair","number (No.)",2,0,{"$f":"E27*F27","v":0}]
[null,"C1.4.3.2","Office chair ","number (No.)",25,0,0]
[null,"C1.4.3.4","Laboratory high chair","number (No.)",20,0,0]
[null,"C1.4.3.5","Office desk with 3 drawers (at least one lockable drawer)","number (No.)",6,0,0]
[null,"C1.4.3.7","Drawing table","number (No.)",null,null,0]
[null,"C1.4.3.8","Conference table","number (No.)",1,0,0]
[null,"C1.4.3.11","General purpose steel cabinet with shelves","number (No.)",4,0,0]
[null,"C1.4.3.13","220/250 volt power outlet plug point","number (No.)",10,0,0]
[null,"C1.4.3.15","Single 1500m, 58 watt fluorescent tube ceiling light","number (No.)",15,0,0]
[null,"C1.4.3.19","Wash-hand basin ","number (No.)",3,0,0]
[null,"C1.4.3.20","Laboratory basin ","number (No.)",5,0,0]
[null,"C1.4.3.21","Extractor fan","number (No.)",2,0,0]
[null,"C1.4.3.22","Fume cupboard","number (No.)",1,0,0]
[null,"C1.4.3.23","Fire extinguisher 9,0 kg, dry powder type","number (No.)",3,0,0]
[null,"C1.4.3.24","Air-conditioning unit","number (No.)",5,0,0]
[null,"C1.4.3.26","Concrete specimen curing bath","number (No.)",1,0,0]
[null,"C1.4.3.27","Waste paper basket","number (No.)",5,0,0]
[null,"C1.4.3.29","A3 / A4 colour printer, copier, scanner","number (No.)",1,0,0]
[null,"C1.4.3.31","Rain gauge","number (No.)",2,0,0]
[null,"C1.4.3.33","Digital thermometer","number (No.)",1,0,0]
[null,"C1.4.3.35","3,0m aluminium straight edge complete with two measuring wedges","number (No.)",1,0,0]
[null,"C1.4.3.36","Measuring wheel","number (No.)",2,0,0]
[null,"C1.4.3.37","First aid kit","number (No.)",2,0,0]
["C1.4.4",null,"Prime cost items"]
[null,"C1.4.4.5","The provision of internet connectivity and WiFi data for Engineer’s site staff","prime cost (PC) sum","prime","cost",{"v":65000,"d":"R65,000.00"}]
[null,"C1.4.4.6","Handling costs and profit in respect of item C1.4.4.5","percentage (%)",{"$f":"G51","v":{"v":65000,"d":"R65,000.00"}},{"v":0,"d":"0.00%"},{"$f":"E52*F52","v":0}]
[null,"C1.4.4.7","The provision of paper and ink for a combination colour printer/copier/scanner ","prime cost (PC) sum","prime","cost",{"v":15000,"d":"R15,000.00"}]
[null,"C1.4.4.8","Handling costs and profit in respect of item C1.4.4.7","percentage (%)",{"$f":"G53","v":{"v":15000,"d":"R15,000.00"}},{"v":0,"d":"0.00%"},{"$f":"E54*F54","v":0}]
[null,"C1.4.4.9","The provision of a complete 220/250 volt single phase electrical power installation, including all poles, insulators, wiring, switchboards, mains connections, meters etc.","prime cost (PC) sum","prime","cost",{"v":20000,"d":"R20,000.00"}]
[null,"C1.4.4.10","Handling costs and profit in respect of item C1.4.4.9","percentage (%)",{"$f":"G55","v":{"v":20000,"d":"R20,000.00"}},{"v":0,"d":"0.00%"},{"$f":"E56*F56","v":0}]
[null,"C1.4.4.11","The provision of a complete 440/231 volt three phase electrical power installation, including all poles, insulators, wiring, switchboards, mains connections, meters etc.","prime cost (PC) sum","prime","cost",{"v":20000,"d":"R20,000.00"}]
[null,"C1.4.4.12","Handling costs and profit in respect of item C1.4.4.11","percentage (%)",{"$f":"G57","v":{"v":20000,"d":"R20,000.00"}},{"v":0,"d":"0.00%"},{"$f":"E58*F58","v":0}]
[null,"C1.4.4.13","Provision of a 440/231 volt three phase electricity generator if electricity from a power supply authority is not available on site","prime cost (PC) sum","prime","cost",{"v":20000,"d":"R20,000.00"}]
[null,"C1.4.4.14","Handling costs and profit in respect of item C1.4.4.13","percentage (%)",{"$f":"G59","v":{"v":20000,"d":"R20,000.00"}},{"v":0,"d":"0.00%"},{"$f":"E60*F60","v":0}]
["C1.4.5",null,"Services at site offices, laboratories and site accommodation"]
[null,"C1.4.5.1","Fixed costs","lump sum","lump","sum",0]
[null,"C1.4.5.2","Running costs","month",21,0,{"$f":"E63*F63","v":0}]
["C1.4.7",null,"Site inspection transport"]
[null,"C1.4.7.1","Provision of a bus, mini-bus or combi van for site inspection purposes (specify type and size of vehicle)","per day",30,0,{"$f":"E65*F65","v":0}]
[null,"C1.4.7.2","Travel on site","kilometre (km)",1000,0,{"$f":"E66*F66","v":0}]
["C1.4.8",null,"Site security measures for the Engineer’s facilities"]
[null,"C1.4.8.1","Supply and installation of all required security measures at the Engineer’s site offices and laboratories","lump sum","lump","sum",0]
[null,"C1.4.8.2","Provision of security guards / watchmen and an armed response service at the Engineer’s site offices and laboratories","month",21,0,{"$f":"E69*F69","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G7:G72)","v":{"v":140000,"d":"R140,000.00"}}]

{"sheet":"C1.5","index":4,"n_rows":49,"n_cols":9,"rows_kept":49,"merged":[[0,0,0,8],[1,0,1,8],[2,5,2,8]]}
[{"$f":"'C1.4'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C1.4'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C1.5",{"$nulls":4},"ACCOMMODATION OF TRAFFIC"]
["ITEM",{"$nulls":3},"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C1.5.1",{"$nulls":3},"Accommodation of pedestrian and non-motorised traffic"]
[null,"C1.5.1.1",null,null,"Accommodation of pedestrian and non-motorised traffic","month",18,0,{"$f":"G8*H8","v":0}]
["C1.5.2",{"$nulls":3},"Accommodation of vehicular traffic","month",18,0,{"$f":"G9*H9","v":0}]
["C1.5.3",{"$nulls":3},"Liaison with traffic authorities","month",18,0,{"$f":"G10*H10","v":0}]
["C1.5.7",{"$nulls":3},"Temporary traffic control facilities"]
[null,"C1.5.7.1",null,null,"Delineators including mounting bases and ballast:"]
[null,null,"(a)",null,"Single sided, reversible left or right (size indicated)","number (No.)",300,0,{"$f":"G13*H13","v":0}]
[null,null,"(b)",null,"Double sided, reversible left or right (size indicated)","number (No.)",700,0,{"$f":"G14*H14","v":0}]
[null,"C1.5.7.2",null,null,"Traffic cones, minimum height 750mm","number (No.)",50,0,{"$f":"G15*H15","v":0}]
[null,"C1.5.7.3",null,null,"Flagmen","man-shift",6300,0,{"$f":"G16*H16","v":0}]
[null,"C1.5.7.4",null,null,"Traffic controllers","man-shift",690,0,{"$f":"G17*H17","v":0}]
[null,"C1.5.7.5",null,null,"Provision of illuminated traffic signs:"]
[null,null,"(a)",null,"Sign mounted flashing amber lights (2 lights with the specified power supply) mounted on a backing board which is:"]
[{"$nulls":3},"(i)","900mm wide x 150mm high","number (No.)",10,0,{"$f":"G20*H20","v":0}]
[null,"C1.5.7.6",null,null,"Maintenance of illuminated traffic signs:"]
[null,null,"(b)",null,"Flashing LED illuminated arrow board","month",5,0,{"$f":"G22*H22","v":0}]
[null,"C1.5.7.7",null,null,"Traffic calming devices:"]
[null,null,"(a)",null,"25mm high x 100mm wide asphalt rumble strips","metre (m)",200,0,{"$f":"G24*H24","v":0}]
[null,null,"(c)",null,"150mm high x 3m wide asphalt speed control humps","metre (m)",70,0,0]
[null,"C1.5.7.8",null,null,"Traffic control stations(2 sets)","month",6,0,0]
[null,"C1.5.7.9",null,null,"Cleaning of traffic control facilities","month",6,0,0]
[null,"C1.5.7.10",null,null,"Movable barriers",{"$nulls":3},{"$f":"IF(G28=\"\",\"\",IF(OR(F28=\"PC Sum\",F28=\"Prov Sum\"),G28,G28*H28))","v":""}]
[null,null,"(a)",null,"Supply to site, initial placement and removal from site of barriers:",{"$nulls":3},""]
[{"$nulls":3},"(i)","Barriers obtained from Employers Depot: \n",{"$nulls":3},""]
[{"$nulls":4},"Concrete NJ Type, 3m long units, located at the kingway store yard","metre (m)",{"v":1200,"d":"1,200"},0,0]
[null,null,"(b)",null,"Dismantling and re-erecting barriers during the works\n","metre (m)",{"v":2600,"d":"2,600"},0,0]
[null,null,"(c)",null,"Supply to site, initial placement and removal from site of terminal section for temporary barriers","number (No.)",80,0,0]
[null,null,"(d)",null,"Dismantling and re-erecting of terminal section for temporary barriers during the works","number (No.)",80,0,0]
[null,null,"(e)",null,"Supply to site barrier connectors “fish plates” and bolts for barriers obtained from Employers Depot","number (No.)",480,0,0]
[null,null,"(f)",null,"Supply to site retroreflective plates for barriers obtained from Employers Depot","number (No.)",480,0,0]
[null,null,"(g)",null,"Movable barriers (Plastic NJ barriers)","metre (m)",200,0,0]
[null,"C1.5.7.11",null,null,"Moveable barricade/road sign combination (Chevron and ROAD CLOSED types)","No",8,0,0]
["C1.5.8",{"$nulls":3},"Traffic safety officer","man-month",18,0,0]
["C1.5.9",{"$nulls":3},"Traffic safety vehicle","month",18,0,0]
["C1.5.11",{"$nulls":3},"Provision of safety equipment for visitors"]
[null,"C1.5.11.1",null,null,"Provision of reflective safety vests for visitors","number (No.)",10,0,{"$f":"G42*H42","v":0}]
["C1.5.12",{"$nulls":3},"Additional traffic accommodation facilities ordered by the Engineer:"]
[null,"C1.5.12.1",null,null,"Provision of additional traffic accommodation facilities ","provisional sum","Prov","Sum",{"v":100000,"d":"R100,000.00"}]
[null,"C1.5.12.2",null,null,"Handling cost, profit and all other charges in respect of item C1.5.12.1","percentage (%)",{"$f":"I44","v":{"v":100000,"d":"R100,000.00"}},{"v":0,"d":"0.00%"},{"$f":"G45*H45","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":7},{"$f":"SUM(I7:I48)","v":{"v":100000,"d":"R100,000.00"}}]

{"sheet":"C1.6","index":5,"n_rows":18,"n_cols":7,"rows_kept":18,"merged":[[0,0,0,6],[1,0,1,6],[2,3,2,6]]}
[{"$f":"'C1.5'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C1.5'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C1.6",null,null,"CLEARING AND GRUBBING"]
["ITEM",null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C1.6.1",null,"Clearing"]
[null,"C1.6.1.1","Clearing with machines and some hand labour where necessary","hectare (ha)",2,0,{"$f":"E8*F8","v":0}]
["C1.6.2",null,"Grubbing"]
[null,"C1.6.2.1","Grubbing with machines and some hand labour where necessary","hectare (ha)",2,0,{"$f":"E10*F10","v":0}]
["C1.6.3",null,"Removal and grubbing of large trees and tree stumps:"]
[null,"C1.6.3.1","Girth equal to or exceeding 1,0m up to and including 2,0m","number (No.)",2,0,{"$f":"E12*F12","v":0}]
[null,"C1.6.3.2","Girth exceeding 2,0m up to and including 3,0m","number (No.)",2,0,{"$f":"E13*F13","v":0}]
[null,"C1.6.3.3","Girth exceeding 3,0m","number (No.)",2,0,{"$f":"E14*F14","v":0}]
["C1.6.7",null,"Re-clearing of previously cleared areas","hectare (ha)",1,0,{"$f":"E15*F15","v":0}]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G8:G17)","v":0}]

{"sheet":"C1.7","index":6,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C1.6'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C1.6'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C1.7",{"$nulls":3},"LOADING AND HAULING"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C1.7.1",null,null,"Loading"]
[null,"C1.7.1.1",null,"Loading from stockpile using machines and some hand labour where necessary","cubic metre (m3)",14002.2,0,{"$f":"F8*G8","v":0}]
["C1.7.2",null,null,"Hauling"]
[null,"C1.7.2.1",null,"Hauling material for use in the Works and off-loading it on the site of the Works:"]
[null,null,"(a)","Soil, gravel, crushed stone and pavement layer material","cubic metre - kilometre (m3 - km)",140022,0,{"$f":"F11*G11","v":0}]
[null,"C1.7.2.2",null,"Hauling material to spoil and off-loading it at a designated spoil or stockpile area:"]
[null,null,"(a)","Cleared and grubbed material (organic matter and all other unsuitable or waste material)","cubic metre - kilometre (m3 - km)",52800,0,{"$f":"F13*G13","v":0}]
[null,null,"(b)","Soil and gravel material","cubic metre - kilometre (m3 - km)",3000,0,{"$f":"F14*G14","v":0}]
[null,null,"(c)","Boulders, hard material and concrete","cubic metre - kilometre (m3 - km)",500,0,{"$f":"F15*G15","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H8:H18)","v":0}]

{"sheet":"C2.1","index":7,"n_rows":12,"n_cols":8,"rows_kept":12,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C1.7'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C1.7'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C2.1",{"$nulls":3},"GENERAL REQUIREMENTS AND TRENCHING FOR SERVICES"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C2.1.1",null,null,"Location, identification, protection and relocation of existing services"]
[null,"C2.1.1.1",null,"Contractor’s obligations","lump sum","lump","sum",0]
[null,"C2.1.1.4",null,"Permanent services relocation or protection work by the Contractor","provisional sum","Prov","Sum",{"v":100000,"d":"R100,000.00"}]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H11)","v":{"v":100000,"d":"R100,000.00"}}]

{"sheet":"C3.1","index":8,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C2.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C2.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C3.1",{"$nulls":3},"DRAINS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C3.1.1",null,null,"Excavation for open drains:"]
[null,"C3.1.1.1",null,"Excavating all material situated within the following depth ranges below the surface level using conventional methods:"]
[null,null,"(a)","0m to 1,5m","cubic metre (m3)",20,0,{"$f":"F9*G9","v":0}]
[null,"C3.1.1.2",null,"Extra over sub-item C3.1.1.1 for excavation in hard and boulder material, irrespective of depth","cubic metre (m3)",5,0,0]
["C3.1.2",null,null,"Clearing, shaping and disposal of accumulated sediment in existing unlined open drains "]
[null,"C3.1.2.1",null,"Using conventional methods","cubic metre (m3)",20,0,{"$f":"F12*G12","v":0}]
[null,"C3.1.2.2",null,"Using labour enhanced construction methods","cubic metre (m3)",null,null,{"$f":"F13*G13","v":0}]
["C3.1.3",null,null,"Excavation, clearing and disposal of accumulated sediment in existing lined drains and drainage systems"]
[null,"C3.1.3.3",null,"Using labour enhanced construction methods:"]
[null,null,"(a)","Manholes and inlet and outlet structures","cubic metre (m3)",10,0,{"$f":"F16*G16","v":0}]
[null,null,"(b)","Culvert barrels","cubic metre (m3)",10,0,{"$f":"F17*G17","v":0}]
[null,null,"(c)","Concrete or other lined side drains","cubic metre (m3)",null,null,{"$f":"F18*G18","v":0}]
["C3.1.4",null,null,"Excavation and disposal of material for subsoil drainage systems:"]
[null,"C3.1.4.1",null,"Excavating in all material situated within the following depth ranges below the surface:"]
[null,null,"(a)","0m to 1,5m","cubic metre (m3)",10,0,{"$f":"F21*G21","v":0}]
[null,"C3.1.4.4",null,"Extra over sub-item C3.1.4.1 for excavation in hard and boulder material, irrespective of depth","cubic metre (m3)",2,0,0]
["C3.1.5",null,null,"Impermeable backfilling to subsoil drainage systems"]
[null,"C3.1.5.1",null,"Un-stabilised natural gravel obtained from approved sources on the site","cubic metre (m3)",10,0,{"$f":"F24*G24","v":0}]
["C3.1.7",null,null,"Natural permeable material in subsoil drainage systems (approved crushed stone):"]
[null,"C3.1.7.2",null,"Crushed stone obtained from commercial sources (course grade and 20mm nominal aggregate size)","cubic metre (m3)",10,0,{"$f":"F26*G26","v":0}]
["C3.1.8",null,null,"Natural permeable material in subsoil drainage systems (approved natural sand):"]
[null,"C3.1.8.2",null,"Natural sand from commercial sources (Medium grade)","cubic metre (m3)",20,0,{"$f":"F28*G28","v":0}]
["C3.1.9",null,null,"Pipes in subsoil drainage systems:"]
[null,"C3.1.9.1",null,"U-PVC pipes and fittings, normal duty, complete with couplings (110mm Internal Dia and  perforated","metre (m)",15,0,{"$f":"F30*G30","v":0}]
["C3.1.10",null,null,"Polymer film sheeting or similar approved material, for lining subsoil drainage systems:"]
["C3.1.11",null,null,"Geotextiles (Bidim, Grade E)","square metre (m2)",1800,0,{"$f":"F32*G32","v":0}]
["C3.1.12",null,null,"Composite drainage systems"]
[null,"C3.1.12.1",null,"In-plane drainage systems (Supply and lay fin drain composite subsoil drainage system including 100 mm diameter HDPE mesh structured pipe","metre (m)",15,0,{"$f":"F34*G34","v":0}]
["C3.1.13",null,null,"Concrete outlet structures, manhole boxes, junction boxes and cleaning eyes for subsoil drainage systems:"]
[null,"C3.1.13.1",null,"Outlet structures (Type A as per Standard detail  TD-SD-1002","number (No.)",6,0,{"$f":"F36*G36","v":0}]
[null,"C3.1.13.3",null,"Junction boxes (As per TD-SD-1003)","number (No.)",6,0,{"$f":"F37*G37","v":0}]
[null,"C3.1.13.4",null,"Cleaning eyes (As per TD-SD-1003)","number (No.)",6,0,{"$f":"F38*G38","v":0}]
["C3.1.14",null,null,"Caps for subsoil drain pipes:"]
[null,"C3.1.14.3",null,"Other (Glass fibre reinforced, PVC etc.) (PVC)","number (No.)",10,0,{"$f":"F40*G40","v":0}]
["C3.1.16",null,null,"Loading and hauling of material in excess of 1,0 km","cubic metre - kilometre (m3 - km)",60,0,{"$f":"F41*G41","v":0}]
["C3.1.22",null,null,"Test flushing of subsoil drain pipe systems","number (No.)",2,0,{"$f":"F42*G42","v":0}]
["C3.1.23",null,null,"Subsoil drain outlet marker (As per TD-SD-1002)","number (No.)",2,0,{"$f":"F43*G43","v":0}]
["C3.1.24",null,null,"Submission of as built drawings by the Contractor","provisional sum","Prov","Sum",{"v":10000,"d":"R10,000.00"}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H47)","v":{"v":10000,"d":"R10,000.00"}}]

{"sheet":"C3.2","index":9,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C3.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C3.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C3.2",{"$nulls":3},"CULVERTS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C3.2.1",null,null,"Excavation for culvert structures:"]
[null,"C3.2.1.1",null,"Excavating in all material situated within the following depth ranges below the surface level:"]
[null,null,"(a)","0m to 1,5m","cubic metre (m3)",10,0,{"$f":"F9*G9","v":0}]
[null,null,"(b)","Exceeding 1,5m and up to 3,0m","cubic metre (m3)",5,0,0]
[null,"C3.2.1.4",null,"Extra over sub-item C3.2.1.1 for excavation in hard or boulder material, irrespective of depth","cubic metre (m3)",1.5,0,0]
["PC3.2.2",null,null,"Backfilling"]
[null,"C3.2.2.2",null,"Using imported selected material:"]
[null,null,"(a)","From commercial sources (G5)","cubic metre (m3)",20,0,{"$f":"F14*G14","v":0}]
["C3.2.3",null,null,"Concrete pipe culverts:"]
[null,"C3.2.3.3",null,"On Class C bedding (Concrete pipes 600mm Diameter)","metre (m)",5,0,{"$f":"F16*G16","v":0}]
["C3.2.7",null,null,"Cast in situ concrete and formwork:"]
[null,"C3.2.7.5",null,"In inlet and outlet structures including kerbs, chutes and downpipes, skewed ends, catchpits, manholes, thrust and anchor blocks, excluding formwork but including Class U2 surfacing finish (20 MPA)","cubic metre (m3)",5,0,{"$f":"F18*G18","v":0}]
[null,"C3.2.7.6",null,"Formwork of concrete under items C3.2.7.3 to 5 above (U2 Finish)","square metre (m2)",6,0,0]
["C3.2.9",null,null,"Prefabricated concrete inlets and outlets to culverts (600mm Dia Pipe inlet and outlet structures)","number (No.)",2,0,0]
["C3.2.16",null,null,"Brickwork (Engineering bricks):"]
[null,"C3.2.16.2",null,"230mm thick","square metre (m2)",10,0,{"$f":"F22*G22","v":0}]
["C3.2.17",null,null,"Plaster","square metre (m2)",10,0,0]
["C3.2.18",null,null,"Benching","cubic metre (m3)",1,0,0]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H27)","v":0}]

{"sheet":"C4.1","index":10,"n_rows":14,"n_cols":8,"rows_kept":14,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C3.2'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C3.2'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C4.1",{"$nulls":3},"BORROW MATERIALS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C4.1.10",null,null,"Compacting the floor of the stockpile sites","cubic metre (m3)",1500,0,{"$f":"F7*G7","v":0}]
["C4.1.11",null,null,"Constructing a platform for the stockpile site ","cubic metre (m3)",1500,0,0]
["C4.1.15",null,null,"Shaping and finishing the borrow pit and quarry areas, and the stockpile sites"]
[null,"C4.1.15.1",null,"Shaping and finishing the borrow pit and quarry areas, and the stockpile sites:"]
[null,null,"(c)","Stockpile sites","hectare (ha)",1,0,{"$f":"F11*G11","v":0}]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H13)","v":0}]

{"sheet":"C4.3","index":11,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,0,8],[1,0,1,8],[2,5,2,8]]}
[{"$f":"'C4.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C4.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C4.3",{"$nulls":4},"EXISTING ROAD MATERIALS"]
["ITEM",{"$nulls":3},"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C4.3.4",{"$nulls":3},"Saw-cutting existing materials within the following average depth ranges "]
[null,"C4.3.4.1",null,null,"Asphalt material:"]
[null,null,"(a)",null,"Up to 50mm","metre (m)",3302.4,0,{"$f":"G9*H9","v":0}]
["C4.3.5",{"$nulls":3},"Providing the milling machine on the site"]
[null,"C4.3.5.2",null,null,"Large milling machine with a cutting width exceeding 1,2m","number (No.)",1,0,{"$f":"G11*H11","v":0}]
["C4.3.6",{"$nulls":3},"Milling and removal of existing asphalt layers with an average milling depth (Contractor takes ownership)"]
[null,"C4.3.6.1",null,null,"Not exceeding 50mm","cubic metre (m3)",2320,0,{"$f":"G13*H13","v":0}]
[null,"C4.3.6.3",null,null,"Exceeding 100mm","cubic metre (m3)",1710,0,{"$f":"G14*H14","v":0}]
["C4.3.8",{"$nulls":3},"Excavating material by milling"]
[null,"C4.3.8.3",null,null,"Natural gravel material","cubic metre (m3)",300,0,{"$f":"G16*H16","v":0}]
["C4.3.18",{"$nulls":3},"Excavate non-compliant or excess pavement layer material to spoil in sites designated by the Contractor, material consisting of"]
[null,"C4.3.18.1",null,null,"Asphalt material","cubic metre (m3)",1600,0,{"$f":"G18*H18","v":0}]
[null,"C4.3.18.2",null,null,"Crushed stone, macadam, gravel and sand material","cubic metre (m3)",6576,0,{"$f":"G19*H19","v":0}]
[null,"C4.3.18.3",null,null,"Cemented material","cubic metre (m3)",1450,0,{"$f":"G20*H20","v":0}]
["C4.3.21/4.1.16",{"$nulls":3},"Personnel"]
[null,"C4.3.21/4.1.16.2",null,null,"Excavation controller","month",6,0,{"$f":"G22*H22","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":7},{"$f":"SUM(I7:I25)","v":0}]

{"sheet":"C4.4","index":12,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C4.3'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C4.3'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C4.4",{"$nulls":3},"COMMERCIAL MATERIALS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C4.4.2",null,null,"Commercial materials identified by the Contractor from commercial, private or other non-commercial suppliers"]
[null,"C4.4.2.1",null,"Pavement layer material:"]
[null,null,"(c)","Type G5B material for leveling layer and reshaping of gravel shoulders","cubic metre (m3)",650,0,{"$f":"F9*G9","v":0}]
[null,null,"(d)","Type G5A material for cement stabilised pavement layers ( 200mm Cemented C3 upper subbase to 95% of MDD and 200mm Cemented C4 lower subbase to 95% of MDD)","cubic metre (m3)",4887,0,0]
[null,"C4.4.2.5",null,"Fill material in the earthworks:"]
[null,"C4.4.2.6",null,"Adhoc Pioneer material 300mm thick","cubic metre (m3)",950,0,{"$f":"F12*G12","v":0}]
["C4.4.4",null,null,"Cementitious stabilising agents"]
[null,"C4.4.4.1",null,"Cement - CEM II B-L 32.5N","ton (t)",520,0,{"$f":"F14*G14","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H17)","v":0}]

{"sheet":"C5.1","index":13,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[0,0,0,8],[1,0,1,8],[2,5,2,8]]}
[{"$f":"'C4.4'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C4.4'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C5.1",{"$nulls":4},"ROADBED"]
["ITEM",{"$nulls":3},"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C5.1.1",{"$nulls":3},"Roadbed construction and compaction:"]
[null,"C5.1.1.4",null,null,"Compaction of imported material to 93% of MDD","cubic metre (m3)",1830,0,{"$f":"G8*H8","v":0}]
["C5.1.11",{"$nulls":3},"Construction of roadbed comprising a pioneer layer","cubic metre (m3)",950,0,{"$f":"G9*H9","v":0}]
["C5.1.13",{"$nulls":3},"Construction of a levelling layer:"]
[null,"C5.1.13.2",null,null,"Over a constructed pioneer layer compacted to 90% MDD","cubic metre (m3)",474.75,0,{"$f":"G11*H11","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":7},{"$f":"SUM(I7:I14)","v":0}]

{"sheet":"C5.3","index":14,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7],[25,9,26,18]]}
[{"$f":"'C5.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C5.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C5.3",{"$nulls":3},"ROAD PAVEMENT LAYERS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C5.3.1",null,null,"Compiling and implementing M&U plans for the construction of all the pavement layers.","number (No.)",2,{"v":0,"d":"R0.00"},{"$f":"F7*G7","v":0}]
["C5.3.2",null,null,"Construction of pavement layers"]
[null,"C5.3.2.1",null,"Construction of layers using conventional construction methods:"]
[null,null,"(j)","Lower subbase gravel layer ( 200mm Cemented C4 lower subbase to 95% of MDD) ","cubic metre (m3)",2442,{"v":0,"d":"R0.00"},{"$f":"F10*G10","v":0}]
[null,null,"(l)","Upper subbase gravel layer (200mm Cemented C3 upper subbase to 95% of MDD )","cubic metre (m3)",2445,{"v":0,"d":"R0.00"},0]
{"$rows_empty":10}
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H21)","v":0}]

{"sheet":"C5.4","index":15,"n_rows":17,"n_cols":8,"rows_kept":17,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C5.3'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C5.3'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C5.4",{"$nulls":3},"STABILISATION"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C5.4.2",null,null,"Chemical stabilisation:"]
[null,"C5.4.2.1",null,"(i) Chemical stabilisation ( 200mm Cemented C4 lower subbase to 95% of MDD) ","cubic metre (m3)",2442,0,{"$f":"F8*G8","v":0}]
[{"$nulls":3},"(ii) Chemical stabilisation ( 200mm Cemented C3 Upper subbase to 95% of MDD) ","cubic metre (m3)",2445,0,{"$f":"F9*G9","v":0}]
["C5.4.5",null,null,"Cementitious stabilisation agents for pavement layers:"]
[null,"C5.4.5.1",null,"Addition of cementitious stabilisation agents (specify agent separately) for pavement layers"]
[null,null,"(a)","Cement - CEM II B-L 32.5N (C3 upper subbase and C4 lower subbase)","ton (t)",520,0,{"$f":"F12*G12","v":0}]
["C5.4.10",null,null,"Provision and application of water for curing","kilolitre (kℓ)",2500,0,{"$f":"F13*G13","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H16)","v":0}]

{"sheet":"C8.1","index":16,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[0,0,0,6],[1,0,1,6],[2,3,2,6]]}
[{"$f":"'C5.4'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C5.4'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C8.1",null,null,"PRIME COAT"]
["ITEM",null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C8.1.1",null,"Prime coat:"]
[null,"C8.1.1.3","Inverted bitumen emulsion","litre (ℓ)",28000,0,{"$f":"E8*F8","v":0}]
[null,"C8.1.1.4","Certified product containing solvents (Quick Dry Prime (QDP))","litre (ℓ)",100,0,{"$f":"E9*F9","v":0}]
["C8.1.2",null,"Aggregate for blinding:"]
[null,"C8.1.2.1","Natural sand","cubic metre (m3)",50,0,{"$f":"E11*F11","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G7:G14)","v":0}]

{"sheet":"C8.8","index":17,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C8.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C8.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C8.8",{"$nulls":3},"PATCHING AND EDGE BREAK REPAIR"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C8.8.1",null,null,"Saw cutting pavement layers for patching"]
[null,"C8.8.1.1",null,"Asphalt or bituminous surfacing to an average depth"]
[null,null,"(a)","Not exceeding 50mm","metre (m)",845,0,{"$f":"F9*G9","v":0}]
["C8.8.2",null,null,"Excavation in existing pavements for patching (non-milling)"]
[null,"C8.8.2.1",null,"Asphalt layers"]
[null,null,"(a)","Not exceeding 10 m² including for edge repairs wider than 250mm","cubic metre (m3)",8.4,0,{"$f":"F12*G12","v":0}]
[null,null,"(b)","Exceeding 10 m² but not exceeding 50 m² including for edge repairs wider than 250mm","cubic metre (m3)",48,0,{"$f":"F13*G13","v":0}]
[null,null,"(c)","Exceeding 50 m² up to 100 m² including for edge repairs wider than 250mm","cubic metre (m3)",31.2,0,{"$f":"F14*G14","v":0}]
[null,null,"(d)","Exceeding 100 m²","cubic metre (m3)",18,0,{"$f":"F15*G15","v":0}]
[null,"C8.8.2.3",null,"Other layers (Gravel Material)"]
[null,null,"(a)","Not exceeding 10 m² including for edge repairs wider than 250mm","cubic metre (m3)",14.4,0,{"$f":"F17*G17","v":0}]
[null,null,"(b)","Exceeding 10 m² but not exceeding 50 m² including for edge repairs wider than 250mm","cubic metre (m3)",121.2,0,{"$f":"F18*G18","v":0}]
[null,null,"(c)","Exceeding 50 m² up to 100 m² including for edge repairs wider than 250mm","cubic metre (m3)",84,0,{"$f":"F19*G19","v":0}]
[null,null,"(d)","Exceeding 100 m²","cubic metre (m3)",48,0,{"$f":"F20*G20","v":0}]
["C8.8.3",null,null,"Compacting the floor of excavations for patching (specify density)","square metre (m2)",2000,0,{"$f":"F21*G21","v":0}]
["C8.8.4",null,null,"Backfilling of excavations for patching with:"]
[null,"C8.8.4.3",null,"Asphalt for a patch with a surface area (150mm thick BTB continously grade with 14mm maximum aggreagte utilising an elastomeric modified  binder 93% min density)"]
[null,null,"(a)","Not exceeding 10 m² including for edge repairs wider than 250mm","ton (t)",68.4,0,{"$f":"F24*G24","v":0}]
[null,null,"(b)","Exceeding 10 m² but not exceeding 50 m² including for edge repairs wider than 250mm","ton (t)",507.6,0,{"$f":"F25*G25","v":0}]
[null,null,"(c)","Exceeding 50 m² up to 100 m² including for edge repairs wider than 250mm","ton (t)",345.6,0,{"$f":"F26*G26","v":0}]
[null,null,"(d)","Exceeding 100 m²","ton (t)",198,0,{"$f":"F27*G27","v":0}]
["C8.8.6",null,null,"Repairing edge breaks in surfacing "]
[null,"C8.8.6.1",null,"Cutting back the edges of the existing surfacing for the repairing of edge breaks","metre (m)",1280.4,0,{"$f":"F29*G29","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H32)","v":0}]

{"sheet":"C9.1","index":18,"n_rows":38,"n_cols":8,"rows_kept":38,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C8.8'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C8.8'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C9.1",{"$nulls":3},"ASPHALT LAYERS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C9.1.1",null,null,"Asphalt mix designs"]
[null,"C9.1.1.2",null,"Sand skeletal mixes:"]
[null,null,"(a)","Continuous grading; NMPS 14mm; PG64-16V (Elastomeric modified binder) binder; Design Level II; minimum 50mm thickness, continuous grading; NMPS 14mm PG64-16S (Elastomeric modified binder) binder; Design Level II; minimum 150mm thicknes, continuous grading; NMPS 14mm PG64-16S (Elastomeric modified binder) binder; Design Level II; minimum 150mm thickness.","lump sum","lump","sum",0]
["C9.1.2",null,null,"Construction of trial sections "]
[null,"C9.1.2.1",null,"Asphalt wearing course at intersections:\nSand skeletal mix; continuous grading; NMPS 14mm; PG64-16V (Elastomeric modified binder) binder; Design Level II; minimum 50mm thickness.","square metre (m2)",1220,0,{"$f":"F11*G11","v":0}]
[{"$nulls":3},"Asphalt base and base patching:\nSand skeletal mix; continuous grading; NMPS 14mm PG64-16S (Elastomeric modified binder) binder; Design Level II; minimum 150mm thickness.","square metre (m2)",1220,0,{"$f":"F12*G12","v":0}]
[{"$nulls":3},"Asphalt wearing course and surface patching: Sand skeletal mix; continuous grading; NMPS 14mm; PG64-16S (Elastomeric modified binder) binder; Design Level II; minimum 50mm thickness.","square metre (m2)",1220,0,{"$f":"F13*G13","v":0}]
[null,"C9.1.2.2",null,"Removal of trial section where so instructed by the Engineer","square metre (m2)",3660,0,{"$f":"F14*G14","v":0}]
["C9.1.3",null,null,"Application of bond coat"]
[null,"C9.1.3.1",null,"Stable–grade 30% net bitumen emulsion as specified.  Applied with a calibrated distributer ","litre (ℓ)",26000,0,{"$f":"F16*G16","v":0}]
["C9.1.4",null,null,"Asphalt base "]
[null,"C9.1.4.2",null,"Rehabilitation "]
[null,null,"(c)","Asphalt base and base patching:\nSand skeletal mix; continuous grading; NMPS 14mm PG64-16S (Elastomeric modified binder) binder; Design Level II; minimum 150mm thickness.","ton (t)",10500,0,{"$f":"F19*G19","v":0}]
["C9.1.5",null,null,"Asphalt surfacing"]
[null,"C9.1.5.2",null,"Rehabilitation "]
[null,null,"(e)","(i) Asphalt wearing course and surface patching: Sand skeletal mix; continuous grading; NMPS 14mm; PG64-16S (Elastomeric modified binder) binder; Design Level II; minimum 50mm thickness.","ton (t)",3500,0,{"$f":"F22*G22","v":0}]
[{"$nulls":3},"(ii) Asphalt wearing course at intersections:\nSand skeletal mix; continuous grading; NMPS 14mm; PG64-16V (Elastomeric modified binder) binder; Design Level II; minimum 50mm thickness.","ton (t)",4100,0,{"$f":"F23*G23","v":0}]
["C9.1.7",null,null,"Placing and compacting asphalt in restricted areas"]
[null,"C9.1.7.2",null,"Extra over payment items C9.1.4.2 and C9.1.5.2 (Asphalt wearing course at intersections:\nSand skeletal mix; continuous grading; NMPS 14mm; PG64-16V (Elastomeric modified binder) binder; Design Level II; minimum 50mm thickness and placing technique (hand or paver))  ","ton (t)",205,0,{"$f":"F25*G25","v":0}]
["C9.1.9",null,null,"Application of rolled in chippings (10mm precoated aggregate)  "]
[null,"C9.1.9.1",null,"By means of chip spreader","square metre (m2)",33000,0,{"$f":"F27*G27","v":0}]
[null,"C9.1.9.2",null,"By hand in restricted areas","square metre (m2)",2000,0,{"$f":"F28*G28","v":0}]
["C9.1.10",null,null,"Variation rates  "]
[null,"C9.1.10.1",null,"Bitumen (Elastomeric modified binder)","ton (t)",10,0,{"$f":"F30*G30","v":0}]
[null,"C9.1.10.3",null,"Active filler (lime unless stated in Contract Documentation) ","ton (t)",2,0,0]
[null,"C9.1.10.5",null,"Rolled-in chippings","ton (t)",30,0,0]
[null,"C9.1.14.1",null,"Establishment of equipment: \nInertial laser Profilometer \n","number (No.)",1,0,{"$f":"F33*G33","v":0}]
[null,"C9.1.14.2",null,"Profiler Surveys utilising equipment as specified - Base layers and surfacing layers","lane kilometre (km)",5,0,{"$f":"F34*G34","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H9:H34)","v":0}]

{"sheet":"C10.1","index":19,"n_rows":24,"n_cols":8,"rows_kept":24,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C9.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C9.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C10.1",{"$nulls":3},"GENERAL REQUIREMENTS FOR SURFACE TREATMENTS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C10.1.1",null,null,"Single seals including a cover spray, if specified (Grade 1 aggregate with a cationic spray grade emulsion (undiluted)):"]
[null,"C10.1.1.2",null,"Using 7,1mm aggregate","square metre (m2)",2500,0,{"$f":"F8*G8","v":0}]
["C10.1.4",null,null,"Embargo period effects"]
[null,"C10.1.4.1",null,"Re-establishment of sealing team after embargo period","lump sum","lump","sum",0]
["C10.1.9",null,null,"Bituminous binder variations:"]
[null,"C10.1.9.7",null,"Homogeneous modified binder (S-E1) hot applied","litre (ℓ)",56364,0,{"$f":"F12*G12","v":0}]
["C10.1.10",null,null,"Aggregate variation (Grade 1):"]
[null,"C10.1.10.5",null,"20mm aggregate","cubic metre (m3)",1127.28,0,{"$f":"F14*G14","v":0}]
["C10.1.15",null,null,"Precoating of aggregate by hand "]
[null,"C10.1.15.1",null,"Product containing low flashpoint solvent (Bitucote) ","litre (ℓ)",75152,0,{"$f":"F16*G16","v":0}]
["C10.1.22",null,null,"Bituminous single seal and slurry, including a cover spray if specified:"]
[null,"C10.1.22.1",null,"Bituminous single seal with 20mm aggregate and first slurry (Grade  1 aggregate, 65% Diluted Cationic spray-grade emulsion idiluted 50% with water and applied at 0.50 l/m2 of diluted emulsion and S-E1 binder and a fine slurry medium grading)","square metre (m2)",563640,0,{"$f":"F18*G18","v":0}]
[null,"C10.1.22.4",null,"Extra over C10.1.22.1 for application of second slurry (Fine Slurry, Fine Grading)","square metre (m2)",563640,0,{"$f":"F19*G19","v":0}]
["C10.1.26",null,null,"Trial sections for all seal types specified (20mm Cape Seal with 2 layer slurry application and cover spray)","lump sum","lump","sum",0]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H23)","v":0}]

{"sheet":"C11.1","index":20,"n_rows":11,"n_cols":8,"rows_kept":11,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C10.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C10.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C11.1",{"$nulls":3},"PITCHING, STONEWORK, CAST IN SITU CONCRETE FOR PROTECTION AGAINST EROSION"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C11.1.6",null,null,"Concrete edge beams (30 MPA)","cubic metre (m3)",10,0,{"$f":"F7*G7","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H10)","v":0}]

{"sheet":"C11.2","index":21,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C11.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C11.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C11.2",{"$nulls":3},"NON-STRUCTURAL GABIONS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C11.2.1",null,null,"Foundation trench excavation:"]
[null,"C11.2.1.1",null,"Excavating all material situated within the following depth ranges below the surface level"]
[null,null,"(a)","0m to 1,5m","cubic metre (m3)",20,0,{"$f":"F9*G9","v":0}]
[null,"C11.2.1.2",null,"Extra over sub-item C11.2.1.1 for excavation in hard material, irrespective of depth","cubic metre (m3)",3,0,0]
["C11.2.2",null,null,"Surface preparation for bedding the gabion boxes and mattresses","square metre (m2)",45,0,0]
["C11.2.3",null,null,"Gabion boxes and mattresses:"]
[null,"C11.2.3.1",null,"Galvanized gabion boxes (2,0 m x 1,0m x 1,0m gabion box with 1,0m  diaphragm spacing, mesh size 80mm x  100mm with 2,7mm wires)","cubic metre (m3)",10,0,{"$f":"F13*G13","v":0}]
[null,"C11.2.3.3",null,"Galvanized gabion mattresses (2,0 m x 1m x 0.3m gabion mattresses with \n, mesh size 80mm x 100mm with 2,7mm wires)","cubic metre (m3)",6,0,{"$f":"F14*G14","v":0}]
["C11.2.4",null,null,"Geotextile (Grade 1 non-woven, minimum mass 320g/m²)","square metre (m2)",80,0,{"$f":"F15*G15","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H18)","v":0}]

{"sheet":"C11.4","index":22,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C11.2'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C11.2'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C11.4",{"$nulls":3},"ROAD RESTRAINT SYSTEMS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C11.4.1",null,null,"Erecting of guardrails at 3,81m spacing"]
[null,"C11.4.1.1",null,"Complete galvanized system compliant to SANS 1350:"]
[null,null,"(a)","On timber posts (TD-R-GR-1001-1002)","metre (m)",20,0,{"$f":"F9*G9","v":0}]
[null,null,"(d)","Extra over C11.4.1.1(a) and C11.4.1.1(b) for excavating holes of posts using labour enhanced methods (soft and intermediate)","metre (m)",20,0,{"$f":"F10*G10","v":0}]
[null,"C11.4.1.2",null,"Terminal sections for 3,81 guardrails comprising of:"]
[null,null,"(e)","End treatments where double guardrail sections are specified (TD-R-GR-1100-1101) ","number (No.)",1,0,{"$f":"F12*G12","v":0}]
[null,null,"(f)","Bridge adaptors (including extra rails and posts) (TD-R-GR-1200-1201)","number (No.)",2,0,0]
["C11.4.5",null,null,"Additional guardrail posts for 3,81m systems:"]
[null,"C11.4.5.1",null,"Timber","number (No.)",5,0,{"$f":"F15*G15","v":0}]
["C11.4.6",null,null,"Reflective plates"]
[null,"C11.4.6.1",null,"Steel plates","number (No.)",10,0,{"$f":"F17*G17","v":0}]
["C11.4.7",null,null,"Removing existing guardrails:","metre (m)",20,0,{"$f":"F18*G18","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H21)","v":0}]

{"sheet":"C11.6","index":23,"n_rows":25,"n_cols":8,"rows_kept":25,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C11.4'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C11.4'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C11.6",{"$nulls":3},"ROAD SIGNS "]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["PC11.6.1",null,null,"Road signboards with painted or coloured semi-matt background. Symbols, lettering and borders in semi- matt black or in Class I retro-reflective material, where the sign board is constructed from:"]
[null,"C11.6.1.8",null,"Regulatory signs, temporary"]
[null,null,"(a)","600mm diameter (galvenised steel boards with retro-reflective class I ","number (No.)",10,0,{"$f":"F9*G9","v":0}]
[null,null,"(b)","900mm diameter (galvenised steel boards with retro-reflective class I )","number (No.)",30,0,{"$f":"F10*G10","v":0}]
[null,null,"(c)","1200mm diameter (galvenised steel boards with retro-reflective class I ","number (No.)",30,0,{"$f":"F11*G11","v":0}]
[null,"C11.6.1.10",null,"Warning signs, temporary "]
[null,null,"(b)","900mm size (galvenised steel boards with retro-reflective class I ","number (No.)",10,0,{"$f":"F13*G13","v":0}]
[null,null,"(c)","1200mm size (galvenised steel boards with retro-reflective class I ","number (No.)",30,0,0]
[null,null,"(d)","1500mm size (galvenised steel boards with retro-reflective class I ","number (No.)",30,0,0]
["C11.6.3",null,null,"Road sign supports (overhead road sign structures excluded):"]
[null,"C11.6.3.2",null,"Timber (110mm Dia treated poles)","metre (m)",200,0,{"$f":"F17*G17","v":0}]
["C11.6.5",null,null,"Excavation and backfilling for road sign supports (not applicable to kilometre posts)"]
[null,"C11.6.5.2",null,"Excavating soft or intermediate material and backfilling using labour enhanced construction methods","cubic metre (m3)",20,0,{"$f":"F19*G19","v":0}]
["C11.6.8",null,null,"Danger plates at culverts/structures"]
[null,"C11.6.8.3",null,"Size 300 x 1200mm (Class  I Reflective material","number (No.)",20,0,{"$f":"F21*G21","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H24)","v":0}]

{"sheet":"C11.7","index":24,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,0,0,6],[1,0,1,6],[2,3,2,6]]}
[{"$f":"'C11.6'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C11.6'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C11.7",null,null,"ROAD MARKINGS AND ROAD STUDS"]
["ITEM",null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C11.7.2",null,"Retro-reflective road marking:"]
[null,"C11.7.2.1","White lines broken or unbroken  Solvent based(150mm)","kilometre (km)",50,0,{"$f":"E8*F8","v":0}]
[null,"C11.7.2.2","Yellow lines broken or unbroken Solvent Based (150mm)","kilometre (km)",{"$f":"(44*2)+(44*20%)","v":{"v":96.8,"d":"96.80"}},0,0]
[null,"C11.7.2.4","White lettering and symbols (Solvent Based)","square metre (m2)",1000,0,0]
[null,"C11.7.2.7","Transverse lines, painted island and arrestor bed markings (any colour) (Solvent Based) ","square metre (m2)",1500,0,0]
["PC11.7.3",null,"Thermoplastic road marking"]
[null,"C11.7.3.1","Thermoplastic road marking, broken or unbroken ","kilometre (km)"]
[null,null,"(a) White lines broken or unbroken ( width of 150mm)","kilometre (km)",50,0,{"$f":"E14*F14","v":0}]
[null,null,"(b) Yellow lines broken or unbroken (width of 150mm)","kilometre (km)",96.8,0,{"$f":"E15*F15","v":0}]
["C11.7.7",null,"Road studs"]
[null,"C11.7.7.2","Permanent road studs compliant to SANS 1463 (Type RSA-1 bi-directional reflective road studs (anchored) )","number (No.)",5550,0,{"$f":"E17*F17","v":0}]
[null,"C11.7.7.3","Temporary road studs compliant to SANS 1442 or 1463 (type/classification & colours stated)","number (No.)",500,0,{"$f":"E18*F18","v":0}]
["C11.7.8",null,"Setting out and premarking the lines (excluding traffic island markings, lettering and symbols)","kilometre (km)",170,0,{"$f":"E19*F19","v":0}]
["C11.7.9",null,"Re-establishing the painting unit during the defects notification period and at other instances on instruction of the Engineer","number (No.)",2,0,0]
["C11.7.11",null,"Removal of existing road studs","number (No.)",5550,0,{"$f":"E21*F21","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G7:G24)","v":0}]

{"sheet":"C11.9","index":25,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[0,0,0,6],[1,0,1,6],[2,3,2,6]]}
[{"$f":"'C11.7'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C11.7'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C11.9",null,null,"FINISHING THE ROAD AND ROAD RESERVE AND TREATING OLD ROADS"]
["ITEM",null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C11.9.1",null,"Finishing the road and road reserve:"]
[null,"C11.9.1.2","Single carriageway road","kilometre (km)",5,0,{"$f":"E8*F8","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G7:G11)","v":0}]

{"sheet":"C13.7","index":26,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[0,0,0,7],[1,0,1,7],[2,4,2,7]]}
[{"$f":"'C11.9'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C11.9'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C13.7",{"$nulls":3},"JOINTS"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["C13.7.5",null,null,"Supply and installation of Agrément South Africa certified proprietary expansion joints"]
[null,"C13.7.5.2",null,"Asphaltic plug type joints"]
[null,null,"(c)","400mm x 75mm","metre (m)","-",0,"Rate Only"]
[null,null,"(d)","500mm x 75mm","metre (m)",50,0,{"$f":"F10*G10","v":0}]
[null,null,"(e)","500mm x 100mm","metre (m)","-",0,"Rate Only"]
[null,null,"(g)","Extra over for variation in joint depth of asphaltic joints","litre (ℓ)",50,0,0]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H12)","v":0}]

{"sheet":"C20.1","index":27,"n_rows":9,"n_cols":9,"rows_kept":9,"merged":[[0,0,0,8],[1,0,1,8],[2,5,2,8]]}
[{"$f":"'C13.7'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C13.7'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["C20.1",{"$nulls":4},"TESTING MATERIALS AND JUDGEMENT OF WORKMANSHIP"]
["ITEM",{"$nulls":3},"DESCRIPTION","UNIT","QTY","RATE","AMT"]
["C20.1.4",{"$nulls":3},"Special tests using Automated Road condition assessment instruments operated by service providers as requested by the Engineer for acceptance control in terms of Clause A20.1.3.6b)(iii)"]
[null,"C20.1.4.4",null,null,"Surface macro texture (Clause A20.1.5.5 b))","prime cost (PC) sum","Prime","Cost",{"v":200000,"d":"R200,000.00"}]
[null,null,"(a)",null,"Handling cost and profit in respect of item C20.1.4.4","percentage (%)",{"$f":"I6","v":{"v":200000,"d":"R200,000.00"}},{"v":0,"d":"0%"},{"$f":"G7*H7","v":0}]
["PC20.1.5",{"$nulls":3},"Financial contribution for an independent site laboratory (to be a negative rate)","month",18,0,{"$f":"G8*H8","v":0}]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":7},{"$f":"SUM(I6:I8)","v":{"v":200000,"d":"R200,000.00"}}]

{"sheet":"Sect D - D1000","index":28,"n_rows":35,"n_cols":8,"rows_kept":35,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,3],[2,4,2,7]]}
[{"$f":"'C20.1'!A1","v":"CONTRACT SANRAL N.012-150-2020/1"}]
[{"$f":"'C20.1'!A2","v":"FOR RESURFACING OF NATIONAL ROUTE N12 SECTION\n15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"}]
["SECTION D - D1000",{"$nulls":3},"TRAINING, COACHING, GUIDANCE, MENTORING AND ASSISTANCE"]
["ITEM",null,null,"DESCRIPTION","UNIT","QTY","RATE","AMT"]
[]
[]
["D10.01",null,null,"Target Group Participation"]
[null,"(a)",null,"Contract Participation Performance bonus ","prime cost (PC) sum","Prime","Cost",{"v":754000,"d":"R754,000.00"}]
["D10.02",null,null,"Stakeholder and Community Liaison and Social Facilitation"]
[null,"(a)",null,"Cost of liaison, social facilitation and PLC support ","prime cost (PC) sum","Prime","Cost",{"v":120000,"d":"R120,000.00"}]
[null,"(b)",null,"Handling cost and profit in respect of sub-item D10.02(a) ","percentage (%)",{"$f":"H10","v":{"v":120000,"d":"R120,000.00"}},{"v":0,"d":"0%"},{"$f":"F11*G11","v":0}]
["D10.03",null,null,"Tender Process for Targeted Enterprises"]
[null,"(a)",null,"Contractor’s charge for the management and execution of the Targeted Enterprise procurement process:"]
[null,null,"(i)","Procurement process for the totality of all tenders concluded for the appointment of Targeted Enterprise subcontractors of CIDB 1 and 2 contractor grading","number (No.)",6,0,{"$f":"F14*G14","v":0}]
[null,null,"(ii)","Procurement process for the totality of all tenders concluded for the appointment of Targeted Enterprise subcontractors of CIDB 3 and 4 contractor grading","number (No.)",3,0,{"$f":"F15*G15","v":0}]
[null,null,"(iii)","Procurement process for the totality of all tenders concluded for the appointment of Targeted Enterprise subcontractors of CIDB 5 and higher contractor grading","number (No.)",5,0,{"$f":"F16*G16","v":0}]
[null,null,"(iv)","Procurement process for the totality of all tenders concluded for the appointment of Targeted Enterprise suppliers","number (No.)",14,0,{"$f":"F17*G17","v":0}]
[null,"(b)",null,"Targeted Enterprise Procurement Coordinator","month",21,0,{"$f":"F18*G18","v":0}]
["D10.04",null,null,"Responsibilities of the Contractor towards Targeted Enterprises"]
[null,"(a)",null,"Contractor’s establishment, management, management support, assistance, coaching, guidance, mentoring and supervision of Targeted Enterprises","month",18,0,{"$f":"F20*G20","v":0}]
[null,"(b)",null,"Targeted Enterprise Construction Manager","Person.Month",18,0,{"$f":"F21*G21","v":0}]
[null,"(c)",null,"Targeted Enterprise Site Supervisors","Person.Month",18,0,{"$f":"F22*G22","v":0}]
["D10.05",null,null,"Construction Works by Targeted Enterprises"]
[null,"(a)",null,"Payments associated with the construction works carried out by Targeted Enterprise subcontractors of CIDB 1 and 2 contractor grading designation appointed in terms of Section D","provisional sum","Prov","Sum",{"v":5067131.25,"d":"R5,067,131.25"}]
[null,"(b)",null,"Handling costs and profit in respect of payment associated with sub-item D10.05(a)","percentage (%)",{"$f":"H24","v":{"v":5067131.25,"d":"R5,067,131.25"}},{"v":0,"d":"0%"},{"$f":"F25*G25","v":0}]
[null,"(c)",null,"Fluctuation between the main contractor’s rates and that of the Targeted Enterprise subcontractors","lump sum","lump","sum",0]
[null,"(d)",null,"Preliminary and General Obligations of Targeted Enterprise sub-contractors appointed in terms of Section D","lump sum","lump","sum",0]
["D10.06",null,null,"Training, coaching, guidance, mentoring and assistance"]
[null,"(a)",null,"Training Costs"]
[null,null,"(ii)","Accredited generic skills training","provisional sum","Prov","Sum",{"v":200000,"d":"R200,000.00"}]
[null,null,"(iii)","Community skills training","provisional sum","Prov","Sum",{"v":100000,"d":"R100,000.00"}]
[null,null,"(iv)","Handling cost and profit in respect of subitems D10.06(a)(i), (ii) and (iii)","percentage (%)",{"$f":"H30+H31","v":{"v":300000,"d":"R300,000.00"}},{"v":0,"d":"0%"},{"$f":"F32*G32","v":0}]
[null,"(c)",null,"Other costs during training (Transport Cost)","provisional sum","Prov","Sum",{"v":30000,"d":"R30,000.00"}]
[null,"(d)",null,"Training venue","lump sum","lump","sum",0]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H7:H34)","v":{"v":6271131.25,"d":"R6,271,131.25"}}]

{"sheet":"Summary of Pricing","index":29,"n_rows":84,"n_cols":4,"rows_kept":84,"merged":[[0,0,0,1],[2,0,2,1],[3,0,3,1],[5,0,5,1],[7,6,7,13],[8,6,8,13],[13,0,13,1],[17,0,17,1],[22,0,22,1],[28,0,28,1],[34,0,34,1],[39,0,39,1],[42,0,42,1],[45,0,45,1],[58,0,58,1],[61,0,61,1]]}
["C2.3 SUMMARY OF PRICING SCHEDULE"]
[]
["CONTRACT SANRAL N.012-150-2020/1"]
["FOR RESURFACING OF NATIONAL ROUTE N12 SECTION 15 FROM WOLMARANSSTAD (KM 0.0) TO KM 46.0"]
[]
["GENERAL"]
["C1.2","GENERAL REQUIREMENTS AND PROVISIONS",{"$f":"'C1.2'!H58","v":{"v":575000,"d":"R575,000.00"}}]
["C1.3","CONTRACTOR’S SITE ESTABLISHMENT AND GENERAL OBLIGATIONS",{"$f":"'C1.3'!H22","v":{"v":250000,"d":"R250,000.00"}}]
["C1.4","FACILITIES FOR THE ENGINEER",{"$f":"'C1.4'!G73","v":{"v":140000,"d":"R140,000.00"}}]
["C1.5","ACCOMMODATION OF TRAFFIC",{"$f":"'C1.5'!I49","v":{"v":100000,"d":"R100,000.00"}}]
["C1.6","CLEARING AND GRUBBING",{"$f":"'C1.6'!G18","v":{"v":0,"d":"R0.00"}}]
["C1.7","LOADING AND HAULING",{"$f":"'C1.7'!H19","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(C7:C12)","v":{"v":1065000,"d":"R1,065,000.00"}}]
[]
["SERVICES"]
["C2.1","GENERAL REQUIREMENTS AND TRENCHING FOR SERVICES",{"$f":"'C2.1'!H12","v":{"v":100000,"d":"R100,000.00"}}]
[{"$nulls":3},{"$f":"SUM(C15:C16)","v":{"v":100000,"d":"R100,000.00"}}]
[]
["DRAINAGE"]
["C3.1","DRAINS",{"$f":"'C3.1'!H48","v":{"v":10000,"d":"R10,000.00"}}]
["C3.2","CULVERTS",{"$f":"'C3.2'!H28","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},{"$f":"SUM(C19:C21)","v":{"v":10000,"d":"R10,000.00"}}]
[]
["EARTHWORKS AND PAVEMENT LAYERS MATERIALS"]
["C4.1","BORROW MATERIALS",{"$f":"'C4.1'!H14","v":{"v":0,"d":"R0.00"}}]
["C4.3","EXISTING ROAD MATERIALS",{"$f":"'C4.3'!I26","v":{"v":0,"d":"R0.00"}}]
["C4.4","COMMERCIAL MATERIALS",{"$f":"'C4.4'!H18","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},{"$f":"SUM(C24:C27)","v":{"v":0,"d":"R0.00"}}]
[]
["EARTHWORKS AND PAVEMENT LAYERS CONSTRUCTION"]
["C5.1","ROADBED",{"$f":"'C5.1'!I15","v":{"v":0,"d":"R0.00"}}]
["C5.3","ROAD PAVEMENT LAYERS",{"$f":"'C5.3'!H22","v":{"v":0,"d":"R0.00"}}]
["C5.4","STABILISATION",{"$f":"'C5.4'!H17","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},{"$f":"SUM(C30:C33)","v":{"v":0,"d":"R0.00"}}]
[]
["PRETREATMENT AND REPAIR EXISTING LAYERS"]
["C8.1","PRIME COAT",{"$f":"'C8.1'!G15","v":{"v":0,"d":"R0.00"}}]
["C8.8","PATCHING AND EDGE BREAK REPAIR",{"$f":"'C8.8'!H33","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},{"$f":"SUM(C36:C38)","v":{"v":0,"d":"R0.00"}}]
[]
["ASPHALT LAYERS"]
["C9.1","ASPHALT LAYERS",{"$f":"'C9.1'!H38","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(C41)","v":{"v":0,"d":"R0.00"}}]
[]
["SURFACE TREATMENTS"]
["C10.1","GENERAL REQUIREMENTS FOR SURFACE TREATMENTS",{"$f":"'C10.1'!H24","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(C44)","v":{"v":0,"d":"R0.00"}}]
[]
["ANCILLIARY ROAD WORKS"]
["C11.1","PITCHING, STONEWORK, CAST IN SITU CONCRETE FOR PROTECTION AGAINST EROSION",{"$f":"'C11.1'!H11","v":{"v":0,"d":"R0.00"}}]
["C11.2","NON-STRUCTURAL GABIONS",{"$f":"'C11.2'!H19","v":{"v":0,"d":"R0.00"}}]
["C11.4","ROAD RESTRAINT SYSTEMS",{"$f":"'C11.4'!H22","v":{"v":0,"d":"R0.00"}}]
["C11.6","ROAD SIGNS",{"$f":"'C11.6'!H25","v":{"v":0,"d":"R0.00"}}]
["C11.7","ROAD MARKINGS AND ROAD STUDS",{"$f":"'C11.7'!G25","v":{"v":0,"d":"R0.00"}}]
["C11.9","FINISHING THE ROAD AND ROAD RESERVE AND TREATING OLD ROADS",{"$f":"'C11.9'!G12","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(C47:C52)","v":{"v":0,"d":"R0.00"}}]
[]
["STRUCTURES"]
["C13.7","JOINTS",{"$f":"'C13.7'!H13","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},{"$f":"SUM(C55:C56)","v":{"v":0,"d":"R0.00"}}]
[]
[]
["QUALITY ASSURANCE"]
["C20.1","TESTING MATERIALS AND JUDGEMENT OF WORKMANSHIP",{"$f":"'C20.1'!I9","v":{"v":200000,"d":"R200,000.00"}},{"$f":"SUM(C60)","v":{"v":200000,"d":"R200,000.00"}}]
[]
["SECTION D: STAKEHOLDER AND COMMUNITY LIAISON, AND TARGET LABOUR AND TARGETED ENTERPRISES UTILISATION AND DEVELOPMENT"]
["D1010","TRAINING, COACHING, GUIDANCE, MENTORING AND ASSISTANCE",{"$f":"'Sect D - D1000'!H35","v":{"v":6271131.25,"d":"R6,271,131.25"}},{"$f":"SUM(C63)","v":{"v":6271131.25,"d":"R6,271,131.25"}}]
[]
[]
[null,"SUBTOTAL A",{"$f":"SUM(D12+D16+D21+D27+D33+D38+D41+D44+D52+D56+D60+D63)","v":{"v":7646131.25,"d":"R7,646,131.25"}}]
[]
[]
[null,"CONTRACT SKILLS DEVELOPMENT GOAL:"]
[null,"0.25% of Subtotal A",{"$f":"0.25/100*C66","v":{"v":19115.328125,"d":"R19,115.33"}}]
[]
[null,"SUBTOTAL B",{"$f":"C66+C70","v":{"v":7665246.578125,"d":"R7,665,246.58"}}]
[]
[]
[null,"VALUE ADDED TAX:"]
[null,"15% of Subtotal ",{"$f":"C72*0.15","v":{"v":1149786.9867187499,"d":"R1,149,786.99"}}]
[]
[null,"TOTAL CARRIED TO C.1.1.1 : FORM OF OFFER ",{"$f":"C72+C76","v":{"v":8815033.56484375,"d":"R8,815,033.56"}}]
[]
[]
[]
[]
[]
[null,"SIGNED BY TENDERER: "]