{"text_format":"3","workbook":"xlsx","n_sheets":24,"sheets":["SUMMARY","C1.2","C1.3 ","C1.4","C1.5","C1.6","C1.7","C3.1","C3.2","C3.3","C4.1","C4.2","C4.4","C.5.1","C5.2","C5.3","C5.4","C6.2","C8.1","C.9.1","C.11.6","C11.7","C11.9","G.10"],"not_rendered":{"external_links":1,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"SUMMARY","index":0,"n_rows":62,"n_cols":3,"rows_kept":62,"merged":[[61,0,61,1]]}
[{"$f":"'C1.2'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.2'!A3","v":"Contract No: Contract  \"A1\""}]
[]
["Section","Description","Amount (R)"]
["C1.2","GENERAL REQUIREMENTS AND PROVISIONS",{"$f":"'C1.2'!F93","v":{"v":1240000,"d":"1,240,000.00"}}]
[]
["C1.3","CONTRACTOR’S SITE ESTABLISHMENT AND GENERAL OBLIGATIONS",{"$f":"'C1.3 '!F54","v":0}]
[]
["C1.4","FACILITIES FOR THE ENGINEER",{"$f":"'C1.4'!F119","v":0}]
[]
["C1.5","ACCOMMODATION OF TRAFFIC",{"$f":"'C1.5'!F91","v":0}]
[]
["C1.6","CLEARING AND GRUBBING",{"$f":"'C1.6'!F38","v":0}]
[]
["C1.7","LOADING AND HAULING",{"$f":"'C1.7'!F37","v":0}]
[]
["C3.1",{"$f":"'C3.1'!B6","v":"DRAINS "},{"$f":"'C3.1'!F111","v":0}]
[]
["C3.2",{"$f":"'C3.2'!B6","v":"CULVERTS"},{"$f":"'C3.2'!F150","v":0}]
[]
["C3.3","CONCRETE KERBING AND CHANNELLING",{"$f":"'C3.3'!F73","v":0}]
[]
["C4.1","BORROW MATERIALS",{"$f":"'C4.1'!F45","v":0}]
[]
["C4.2","CUT MATERIALS",{"$f":"'C4.2'!F51","v":0}]
[]
["C4.4","COMMERCIAL MATERIALS",{"$f":"'C4.4'!F50","v":0}]
[]
["C5.1","ROADBED",{"$f":"'C.5.1'!F61","v":0}]
[]
["C5.2",{"$f":"'C5.2'!B6","v":"FILL LAYERS"},{"$f":"'C5.2'!F46","v":0}]
[]
["C5.3","ROAD PAVEMENT LAYERS",{"$f":"'C5.3'!F43","v":0}]
[]
["C5.4","STABILISATION",{"$f":"'C5.4'!F49","v":0}]
[]
["C6.2",{"$f":"'C6.2'!B6","v":"SEGMENTAL BLOCK PAVING LAYERS"},{"$f":"'C6.2'!F52","v":0}]
[]
["C8.1","PRIME COAT",{"$f":"'C8.1'!F47","v":0}]
[]
["C9.1","ASPHALT LAYERS",{"$f":"'C.9.1'!F42","v":0}]
[]
["C11.6","ROAD SIGNS ",{"$f":"'C.11.6'!F48","v":0}]
[]
["C11.7","ROAD MARKINGS AND ROAD STUDS",{"$f":"'C11.7'!F52","v":0}]
[]
["C11.9","FINISHING ROAD AND RESERVE AND TREATING OLD ROADS",{"$f":"'C11.9'!F48","v":0}]
[]
["G10","GUIDELINES FOR SUBCONTRACTING AND LABOUR ENHANCEMENT",{"$f":"G.10!F48","v":0}]
[]
[null,"SUB-TOTAL"]
[]
[]
[]
[null,"10% CONTINGENCIES"]
[]
[null,"   SUBTOTAL",{"$f":"SUM(C52:C56)","v":0}]
[]
[null,"Add 15% VAT",{"$f":"C58*15%","v":0}]
[]
[" Total Carried Forward To Summary Of Schedules",null,{"$f":"C58+C60","v":0}]

{"sheet":"C1.2","index":1,"n_rows":94,"n_cols":6,"rows_kept":94,"merged":[[65,0,65,4]]}
["New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"]
[]
["Contract No: Contract  \"A1\""]
[{"$nulls":5},"C1.2 GENERAL REQUIREMENTS AND PROVISIONS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C1.2","GENERAL REQUIREMENTS AND PROVISIONS"]
[]
["C1.2.1.1","Monitoring compliance with and reporting on the EMP","month ",{"v":12,"d":"12.00"},0,{"$f":"D8*E8","v":0}]
[]
["C1.2.1.2","Dedicated environmetal officer ","month ",{"v":12,"d":"12.00"},0,{"$f":"D10*E10","v":0}]
[]
["C1.2.4","Stakeholder liaison","month",{"v":12,"d":"12.00"},null,{"$f":"D12*E12","v":0}]
[]
["C1.2.4.1","Social Facilitation ","Lump",{"v":1,"d":"1.00"},{"v":750000,"d":"R750,000.00"},{"$f":"E14","v":{"v":750000,"d":"R750,000.00"}}]
[]
["C1.2.4.2","Occupational Health and Safety","Lump",{"v":1,"d":"1.00"},{"v":450000,"d":"R450,000.00"},{"$f":"E16","v":{"v":450000,"d":"R450,000.00"}}]
[]
["C1.2.5.1","Health and safety plan","Lump sum",1,40000,40000]
[]
["C1.2.5.2","Implementation of health and safety plan","month",{"v":12,"d":"12.00"},0,0]
["C1.2.5","Safety:"]
[]
["C1.2.5.1","Health and safety plan","Lump sum",{"v":1,"d":"1.00"},0,{"$f":"D23*E23","v":0}]
[]
["C1.2.5.2","Implementation of health and safety plan","month",{"v":12,"d":"12.00"},0,{"$f":"D25*E25","v":0}]
[]
["C1.2.8","Dayworks:"]
[]
["C1.2.8.1","Personnel:"]
[]
[null,"(a) Unskilled labourer","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(b) Semi-skilled labourer","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(c) Skilled labourer","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(d) Gang leader","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(e) Foreman","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(f) Skilled Artisan","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
["C1.2.8.2","Construction equipment (specify size and / or model number):"]
[]
[null,"(a) Motor grader","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(b) Vibratory roller","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(c) Pneumatic roller","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(d) Front end loader","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(e) Tractor loader backhoe","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(f) Excavator","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[null,"(g) Compressor","h",{"v":50,"d":"50.00"},0,"Rate Only"]
[]
[" Total Carried Forward",{"$nulls":4},{"$f":"SUM(F6:F58)","v":{"v":1240000,"d":"R1,240,000.00"}}]
[]
["New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"]
[]
["Contract No:"]
[{"$nulls":5},"C1.2 GENERAL REQUIREMENTS AND PROVISIONS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["Total brought forward",{"$nulls":4},{"$f":"F59","v":{"v":1240000,"d":"R1,240,000.00"}}]
[]
[null,"(h) Other equipment (specify)","h",{"v":50,"d":"50.00"},0,"Rate only"]
[]
["C1.2.8.3","Vehicles (specify size):"]
[]
[null,"(a) Light delivery vehicle","km",{"v":2500,"d":"2,500.00"},0,"Rate Only"]
[]
[null,"(b) Flatbed truck","km",{"v":2500,"d":"2,500.00"},0,"Rate Only"]
[]
[]
["BC1.2.10","Protection, Removal, Realignment and Replacement of services"]
[]
[null,"(a) Utility Services","prov sum ",{"v":1,"d":"1.00"},0,{"$f":"D79*E79","v":0}]
[]
[null,"(b) Contractors Handling cost and profit in respect of sub-item BC1.2.10(a)","%",{"$f":"F79","v":0},null,{"$f":"D81*E81","v":0}]
{"$rows_empty":11}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F66:F92)","v":{"v":1240000,"d":"R1,240,000.00"}}]
[null,null,"- 2 -"]

{"sheet":"C1.3 ","index":2,"n_rows":55,"n_cols":13,"rows_kept":55}
[{"$f":"'C1.2'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.2'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C1.3 CONTRACTOR’S SITE ESTABLISHMENT AND GENERAL OBLIGATIONS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C1.3","CONTRACTOR’S SITE ESTABLISHMENT AND GENERAL OBLIGATIONS"]
[]
["C1.3.1","The Contractor's general obligations:"]
[]
["C1.3.1.1","Fixed obligations","Lump sum",{"v":1,"d":"1.00"},0,{"$f":"D10*E10","v":0},null,null,{"$f":"F10/2","v":0}]
[]
["C1.3.1.2","Value related obligations","Lump sum",{"v":1,"d":"1.00"},0,{"$f":"D12*E12","v":0}]
[]
["C1.3.1.3","Time-related obligations","month",{"v":12,"d":"12.00"},0,{"$f":"D14*E14","v":0}]
[]
["C1.3.2","Contract sign boards","m²",{"v":36,"d":"36.00"},0,{"$f":"D16*E16","v":0}]
[]
["C1.3.3","(a)OHS Consultant to be Appointed by Client","Prov. Sum",{"v":1,"d":"1.00"},0,{"$f":"SUM(E18)","v":0}]
[]
[null,"(b) Contractors Handling cost and profit in respect of sub-item BC1.2.10(a)","%",{"$f":"SUM(F18)","v":0},{"v":0,"d":"0%"},{"$f":"D20*E20","v":{"v":0,"d":"0.00"}}]
[]
[null,"( c )Provision for proper PPE's to Local","No",100,0,{"$f":"SUM(D22*E22)","v":0}]
[null,"Workers"]
[]
[null,"(d)Provision for Compiling of Safety File","No",1,0,{"$f":"SUM(D25*E25)","v":0}]
[]
[null,"(e )  Provision for proper PPE's for Visitors","No",20,0,{"$f":"SUM(D27*E27)","v":0}]
[]
[null,"( f )Provision for Medical","No",1,0,{"$f":"SUM(D29*E29)","v":0}]
[null,"Surveillance(entry and exit)"]
[null,"(g) Provision for Site Safety Signage","No",1,0,{"$f":"SUM(D31*E31)","v":0}]
[]
[null,"(h) Provision for Fire Fighting Equipment","No",10,0,{"$f":"SUM(D33*E33)","v":0}]
[]
[null,"( I ) Provision for First Aid Kit(supply","No",2,0,{"$f":"SUM(D35*E35)","v":0}]
[null,"&maintenance)"]
[]
[null,"( j ) Provision for HCS Spill Kits(supply","No",1,0,{"$f":"SUM(D38*E38)","v":0}]
[null,"&maintain)"]
[]
[]
[null,"( k ) Provision for Safety Barricades","No",15,0,{"$f":"SUM(D42*E42)","v":0}]
[]
[null,"( l ) Provision for H&S Personnel(e.g","No",12,0,{"$f":"SUM(D44*E44)","v":0}]
[null,"CHSO.FA etc.)"]
{"$rows_empty":8}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F53)","v":0},{"$nulls":6},{"v":16850088.06,"d":"R16,850,088.06"}]
[null,null,"- 3 -"]

{"sheet":"C1.4","index":3,"n_rows":119,"n_cols":6,"rows_kept":119,"merged":[[3,0,3,5],[65,4,65,5]]}
[{"$f":"'C1.3 '!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.3 '!A3","v":"Contract No: Contract  \"A1\""}]
["C1.4 FACILITIES FOR THE ENGINEER"]
["ITEM     ","DESCRIPTION                                     ","    UNIT    ","QTY","RATE","AMOUNT"]
["C1.4.1","Office and laboratory accommodation:            "]
[]
["","The provision of accommodation as               "]
["","specified, including roof, external and         "]
["","internal walls, windows complete with           "]
["","glazing, doors with locks and fittings,         "]
["","burglar proofing, painting, floors,             "]
["","fencing, the provision of a 220/250             "]
["","volt electrical installation with               "]
["","wiring, switchboards, etc, water and            "]
["","sewerage installation, and stores,              "]
["","complete, in accordance with the                "]
["","drawings and specifications, except for         "]
["","items scheduled elsewhere:                      "]
[]
["C1.4.1.1","Offices and conference room","     m²     ",{"v":40,"d":"40.00"},0,{"$f":"D21*E21","v":0}]
[]
["C1.4.1.2","Laboratories","     m²     ",{"v":40,"d":"40.00"},"Rate Only","Rate Only"]
[]
["C1.4.1.5","Store rooms inside the laboratory","     m²     ",{"v":15,"d":"15.00"},"Rate Only","Rate Only"]
[]
["C1.4.1.6","Car ports","    No.     ",{"v":9,"d":"9.00"},0,{"$f":"D27*E27","v":0}]
[]
["C1.4.1.7","Ablution units                              ","     m²     ",{"v":15,"d":"15.00"},0,{"$f":"D29*E29","v":0}]
[]
["C1.4.1.9","Cooking unit, complete with stove,          ","    No.     ",{"v":1,"d":"1.00"},"Rate Only","Rate Only"]
["","basin, concrete working table,                  "]
["","shelving, sink                                  "]
[]
["C1.4.2.8","Notice boards as specified               ","     m²     ",{"v":3,"d":"3.00"},0,{"$f":"D35*E35","v":0}]
[]
["C1.4.3","Office and laboratory furniture, fittings, installations and equipment               "]
[]
["C1.4.3.1","Office swivel chair","    No.     ",{"v":9,"d":"9.00"},0,{"$f":"D39*E39","v":0}]
[]
["C1.4.3.2","Chairs                                      ","    No.     ",{"v":20,"d":"20.00"},0,{"$f":"D41*E41","v":0}]
[]
["C1.4.3.3","Draughtsman's stools                        ","    No.     ",{"v":1,"d":"1.00"},0,"Rate only"]
[]
["C1.4.3.4","High chairs for Laboratory","    No.     ",{"v":3,"d":"3.00"},0,"Rate only"]
[]
["C1.4.3.5","Desks, complete with drawers and            ","    No.     ",{"v":3,"d":"3.00"},0,{"$f":"D47*E47","v":0}]
["","locks                                           "]
[]
["C1.4.3.7","Drawing tables                              ","    No.     ",{"v":3,"d":"3.00"},0,{"$f":"D50*E50","v":0}]
[]
["C1.4.3.8","Conference tables                           ","    No.     ",{"v":1,"d":"1.00"},0,{"$f":"D52*E52","v":0}]
[]
["C1.4.3.11","General purpose steel cabinet with shelves","    No.     ",{"v":6,"d":"6.00"},0,{"$f":"D54*E54","v":0}]
[]
["C1.4.3.13","220/250 volt power points                   ","    No.     ",{"v":1,"d":"1.00"},0,{"$f":"D56*E56","v":0}]
[]
[]
[]
[]
[]
[{"$nulls":5},{"$f":"SUM(F6:F61)","v":0}]
[{"$f":"A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":4},{"$f":"A4","v":"C1.4 FACILITIES FOR THE ENGINEER"}]
["ITEM     ","DESCRIPTION                                     ","    UNIT    ","QTY","RATE","AMOUNT"]
["","BROUGHT FORWARD                                 ",{"$nulls":3},{"$f":"F62","v":0}]
[]
["C1.4.3.17","Double 55 watt fluorescent light           ","    No.     ",{"v":5,"d":"5.00"},0,{"$f":"D70*E70","v":0}]
["","fittings complete with ballast and              "]
["","tubes                                           "]
[]
["C1.4.3.16","Single incandescent light fittings          ","    No.     ",{"v":1,"d":"1.00"},0,{"$f":"D74*E74","v":0}]
["","complete with 100 watt globes                   "]
[]
["C1.4.3.19","Wash-hand basins coplte with taps and drains","     No.",{"v":2,"d":"2.00"},0,{"$f":"D77*E77","v":0}]
[]
["C1.4.3.20","Laboratory basins complete with swan-neck taps","    No.     ",{"v":1,"d":"1.00"},0,"Rate Only"]
[null,"and drain"]
[]
["C1.4.3.22","Fume cupboards complete according to the ","    No.     ",{"v":1,"d":"1.00"},0,{"$f":"D82*E82","v":0}]
[null,"drawings"]
[]
["C1.4.3.24","Air-conditioning units with, 2,2           ","    No.     ",{"v":3,"d":"3.00"},0,{"$f":"D85*E85","v":0}]
["","kW minimum capacity, mounted                    "]
["","and with own power connection                   "]
[]
["C1.4.3.26","Curing chamber for UCS specimens, complete "]
[null,"with water connection, including the provision of ","    No.     ",{"v":1,"d":"1.00"},0,"Rate Only"]
[null,"brick partitions, plaster, paint and shelving, all "]
[null,"complete according to the drawings"]
[]
["C1.4.3.30","A4 colour printer, copier, scanner","No.",{"v":1,"d":"1.00"},0,{"$f":"SUM(E94)","v":0}]
[]
[null,"Refrigerators                             ","    No.     ",{"v":1,"d":"1.00"},0,{"$f":"D96*E96","v":0}]
[]
[null,"Uninterruptable power supply              ","    No.     ",{"v":3,"d":"3.00"},0,{"$f":"D98*E98","v":0}]
[null,"units                                           "]
[]
[null,"Floodlights complete with poles            ","    No.     ",{"v":3,"d":"3.00"},0,{"$f":"D101*E101","v":0}]
[null,"and 500 Watt minimum globes                     "]
[]
["C1.4.3.31","Rain gauge                                ","    No.     ",{"v":2,"d":"2.00"},0,{"$f":"D104*E104","v":0}]
[]
["C1.4.3.32","Minimum/maximum atmospheric temperature gauge","    No.     ",{"v":2,"d":"2.00"},0,{"$f":"D106*E106","v":0}]
[""]
["C1.4.3.38","Standpipe complete with 30 m of 19 mm dia. heavy duty hose pipe","    No.     ",{"v":4,"d":"4.00"},0,{"$f":"D108*E108","v":0}]
[]
["C1.4.5","Services                                        "]
[]
["C1.4.5.1","fixed cost                      ","Lump sum     ",{"v":1,"d":"1.00"},0,"Rate Only"]
[]
["C1.4.5.2","Running   costs                            ","  month     ",{"v":12,"d":"12.00"},0,"Rate Only"]
[]
[null,"Services for rented houses                  ","  month     ",{"v":12,"d":"12.00"},0,{"$f":"D116*E116","v":0}]
[]
[null,"Provision of photostat facilities","month",{"v":12,"d":"12.00"},0,{"$f":"D118*E118","v":0}]
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F68:F118)","v":0}]

{"sheet":"C1.5","index":4,"n_rows":92,"n_cols":6,"rows_kept":92}
[{"$f":"'C1.4'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.4'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C1.5 ACCOMMODATION OF TRAFFIC"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C1.5","ACCOMMODATION OF TRAFFIC"]
[]
["C1.5.2","Accommodation of vehicular traffic","month",{"v":12,"d":"12.00"},0,{"$f":"D8*E8","v":0}]
[]
["C1.5.4","Construction of temporary deviations","km",{"v":7.4,"d":"7.40"},0,"Rate Only"]
[]
["C1.5.5","Maintenance of temporary deviations:","km",{"v":7,"d":"7.00"},0,"Rate Only"]
[]
["C1.5.5.9","Grading of temporary deviations and existing roads used as detours","km",{"v":1.2,"d":"1.20"},0,{"$f":"D14*E14","v":0}]
[]
["C1.5.5.10","Watering of temporary deviations and existing roads used as detours","kℓ",{"v":650,"d":"650.00"},0,{"$f":"D16*E16","v":0}]
[]
["C1.5.5.11","Other road maintenance work ordered by the Engineer","prov sum ",{"v":1,"d":"1.00"},0,{"$f":"D18*E18","v":0}]
[]
["C1.5.5.12","Handling cost, profit and all other charges in respect of item C1.5.6.11","%",{"v":50000,"d":"50,000.00"},{"v":0,"d":"0%"},{"$f":"D20*E20","v":0}]
[]
["C1.5.6","Removal of temporary deviations","km",{"v":6,"d":"6.00"},0,{"$f":"D22*E22","v":0}]
[]
["BC1.5.7","Temporary traffic control facilities:"]
[]
["L","(a) Flagmen","Person day",{"v":40,"d":"40.00"},0,{"$f":"D26*E26","v":0}]
[]
[null,"(b) Portable STOP and GO-RY signs","No",{"v":8,"d":"8.00"},0,"Rate Only"]
[]
[null,"(d) Amber flashing lights","No",{"v":20,"d":"20.00"},0,"Rate Only"]
[]
[null,"(e) Road signs, R- and TR-series"]
[]
[null,"(ii) 1200mm diameter","No",{"v":10,"d":"10.00"},0,{"$f":"D34*E34","v":0}]
[]
[null,"(f) Road signs, TW-series with distance board"]
[]
[null,"(iii) 1500mm sides","No",{"v":10,"d":"10.00"},0,{"$f":"D38*E38","v":0}]
[]
[null,"(g) Road signs, STW-, DTG-, TGS- AND TG-series (excluding delineators and barricades)","m²",{"v":25,"d":"25.00"},0,{"$f":"D40*E40","v":0}]
[]
[null,"(h) Delineators: (TW 401 and TW 402)"]
[]
[null,"(i) Single (1200mm x 300mm)","No",{"v":50,"d":"50.00"},0,{"$f":"D44*E44","v":0}]
[]
[null,"(ii) Double sided blade (800mm x 200mm)","No",{"v":40,"d":"40.00"},0,{"$f":"D46*E46","v":0}]
[]
[null,"(i) Moveable barricade/road sign combination (Chevron and ROAD CLOSED types)","No",{"v":6,"d":"6.00"},0,{"$f":"D48*E48","v":0}]
[]
[null,"(m) Two-way communication devices","No",{"v":2,"d":"2.00"},0,"Rate Only"]
[]
[]
[null,"(i) 1200mm x 400mm","No",{"v":10,"d":"10.00"},0,{"$f":"D53*E53","v":0}]
[" Total Carried Forward",{"$nulls":4},{"$f":"SUM(F6:F53)","v":0}]
[null,null,-6]
[{"$f":"A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[]
[{"$nulls":5},"C1.5 ACCOMMODATION OF TRAFFIC"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
[" Brought Forward",{"$nulls":4},{"$f":"F54","v":0}]
[null,"(r) Removable rumble strips (ATM) "]
[]
[null,"(i) 3000mm x 300mm","No",{"v":10,"d":"10.00"},"Rate Only","Rate Only"]
[]
[]
["C1.5.12","Additional traffic accommodation facilities ordered by the Engineer:"]
[]
["C1.5.12.1","Provision of additional traffic accommodation facilities","prov sum ",{"v":1,"d":"1.00"},{"v":20000,"d":"R20,000.00"},{"$f":"D69*E69","v":{"v":20000,"d":"20,000.00"}}]
[]
["C1.5.12.2","Handling cost, profit and all other charges in respect of item C1.5.12.1","%",{"v":20000,"d":"20,000.00"},{"v":0.1,"d":"10%"},{"$f":"D71*E71","v":{"v":2000,"d":"2,000.00"}}]
{"$rows_empty":19}
[" Total Carried Forward To Summary"]
[null,null,{"$f":"-7","v":-7}]

{"sheet":"C1.6","index":5,"n_rows":39,"n_cols":6,"rows_kept":39}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C1.6 CLEARING AND GRUBBING"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C1.6","CLEARING AND GRUBBING"]
[]
["C1.6.1","Clearing:"]
[]
["C1.6.1.1","Clearing with machines and some hand labour where necessary","ha",{"v":9,"d":"9.00"},0,{"$f":"D10*E10","v":0}]
[]
["C1.6.2","Grubbing:"]
[]
["C1.6.2.1","Grubbing with machines and some hand labour where necessary","ha",{"$f":"D10","v":{"v":9,"d":"9.00"}},0,{"$f":"D14*E14","v":0}]
{"$rows_empty":23}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F37)","v":0}]
[null,null,"- 6 -"]

{"sheet":"C1.7","index":6,"n_rows":38,"n_cols":6,"rows_kept":38}
[{"$f":"'C1.6'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.6'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C1.7 LOADING AND HAULING"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C1.7","LOADING AND HAULING"]
[]
["C1.7.2","Hauling:"]
[]
["C1.7.2.1","Hauling material for use in the Works and off-loading it on the site of the Works:"]
[]
[null,"(a) Soil, gravel, crushed stone and pavement layer material","m³-km",{"v":30000,"d":"30,000.00"},0,{"$f":"IF(C12 = CHAR(37), D12*E12/100,D12*E12)","v":0}]
{"$rows_empty":24}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F36)","v":0}]
[null,null,"- 7 -"]

{"sheet":"C3.1","index":7,"n_rows":111,"n_cols":10,"rows_kept":111,"merged":[[110,1,110,4]]}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C3.1 DRAINS "]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C3.1","DRAINS "]
[]
["C3.1.1.1","Excavating all material situated within the following depth "]
[null,"ranges below the surface level using conventional methods"]
[]
[null,"(a) 0 m up to 1,5 m                              ","     m³     ",{"v":225,"d":"225.00"},0,{"$f":"D11*E11","v":0}]
[]
[null,"(b) Exceeding 1,5 m and up to 3,0 m ","     m³     ",{"v":388,"d":"388.00"},0,{"$f":"SUM(D13*E13)","v":0}]
[]
[null,"(c) Etc, in increments of 1,5 m ","     m³     ",null,0,"Rate Only"]
[{"$nulls":9},{"$f":"100*100","v":10000}]
["C3.1.1.2 ","Extra over sub-item C3.1.1.1 for excavation in hard and  ","     m³     ",{"v":400,"d":"400.00"},0,{"$f":"SUM(D17*E17)","v":0}]
[null,"boulder material, irrespective of depth"]
[]
["C3.1.3","Clearing, shaping and disposal of accumulated sediment in "]
[""," existing lined open drains and systems"]
[]
["C3.1.3.1 ","Using conventional methods (up to 1,5 m): "]
[]
[null,"(a) Manholes and inlet and outlet structures ","     m³     ",{"v":300,"d":"300.00"},0,{"$f":"D25*E25","v":0}]
[]
[null,"(b) Culvert barrels ","  m³   ",{"v":135,"d":"135.00"},0,"Rate Only"]
[]
[null,"(c) Concrete or other lined side drains ","     m³     ",{"v":20,"d":"20.00"},0,{"$f":"SUM(D29*E29)","v":0}]
[]
["C3.1.4","Excavation for subsoil drainage                 "]
["","systems:                                        "]
[]
["C3.1.4.1","Excavating in all material situated               "]
["","within the following depth ranges below         "]
["","surface level                                   "]
[]
["","(a) 0 m up to 1,5 m                              ","     m³     ",{"v":600,"d":"600.00"},0,{"$f":"SUM(D38*E38)","v":0}]
[]
[null,"(b) Exceeding 1,5 m and up to 3,0 m ","     m³     ",{"v":200,"d":"200.00"},0,{"$f":"SUM(D40*E40)","v":0}]
[]
["C3.1.4.4 ","Extra over sub-item C3.1.4.1 for excavation in hard and","     m³     ",{"v":100,"d":"100.00"},0,{"$f":"SUM(D42*E42)","v":0}]
[null,"boulder material, irrespective of depth "]
[]
["C3.1.5","Impermeable backfilling to subsoil drainage systems       "]
[]
["C3.1.5.1 ","Un-stabilised natural gravel obtained from approved sources ","     m³     ",{"v":200,"d":"200.00"},0,{"$f":"SUM(D47*E47)","v":0}]
[null,"on the site"]
[]
["C3.1.5.3 ","Extra over items C3.1.5.1 ","     m³     "]
[]
["C3.1.8 ","Natural permeable material in subsoil           "]
["","drainage systems (sand)          "]
[]
["C3.1.8.1 ","Natural sand obtained from approved sources ","     m³     ",{"v":300,"d":"300.00"},0,{"$f":"SUM(D55*E55)","v":0}]
[""]
["C3.1.8.2 ","Natural sand from commercial sources ","     m³     ",{"v":125,"d":"125.00"},0,{"$f":"SUM(D57*E57)","v":0}]
[]
["C3.1.9","Pipes in subsoil drainage systems:              "]
[]
["C3.1.9.1","HDPE (i) 110 mm internal dia., slotted          ","      m     ",700,0,{"$f":"SUM(D61*E61)","v":0}]
[]
["C3.1.10","Polymer film sheeting or similar approved material, for lining  "]
[null,"subsoil drainage systems: "]
[]
["C3.1.10.1","0,15 mm thick ","     m²     ",800,0,{"$f":"SUM(D66*E66)","v":0}]
[]
[" Total Carried Forward",{"$nulls":4},{"$f":"SUM(F2:F67)","v":0}]
[]
["New Mashifani Park: Installation of Civil Engineering Services: Roads & Stormwater Network"]
[]
["Contract No: Contract 'A1'"]
[]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
[" Brought Forward",{"$nulls":4},{"$f":"F68","v":0}]
[]
[]
["C3.1.10.2 ","0,25 mm thick ","     m²     ",300,0,"Rate Only"]
[]
["C3.1.13","Concrete outlet structures, manhole             "]
["","boxes, junction boxes and cleaning eyes         "]
["","for subsoil drainage systems:                   "]
[]
["C3.1.13.1 ","Outlet structures                           ","    No.     ",4,0,{"$f":"SUM(D84*E84)","v":0}]
[]
["C3.1.13.2 ","Inspection boxes ","     No     ",null,0,"Rate Only"]
[]
["C3.1.13.3 ","Junction boxes                              ","    No.     ",8,0,{"$f":"SUM(D88*E88)","v":0}]
[]
["C3.1.13.4 ","Cleaning eyes                               ","    No.     ",15,0,{"$f":"SUM(D90*E90)","v":0}]
[]
["C3.1.14","Concrete caps for subsoil drain pipes           "]
[]
["C3.1.14.1 ","Concrete caps ","    No.     ",15,0,{"$f":"SUM(D94*E94)","v":0}]
[]
["C3.1.16","Overhaul for material hauled in excess          ","  m³-km     ",{"v":3500,"d":"3,500.00"},0,{"$f":"D96*E96","v":0}]
["","of 1,0 km free haul (normal overhaul)           "]
[]
["C3.1.17","Backfilling existing eroded side drains","  m³   ",200,0,{"$f":"D99*E99","v":0}]
[]
["C3.1.18 ","Backfilling of drains with selected material compacted to  ","  m³   ",1800,0,{"$f":"D101*E101","v":0}]
[null,"93 % of MDD prior to construction of concrete lining and/or "]
[null,"stone pitched lining"]
[]
["C3.1.22","Test flushing of pipe subsoil drains            ","    No.     ",null,0,"Rate Only"]
[]
["C3.1.23","Excavation, laying, backfilling and testing  of 110mm dia pvc . sleeves pipes","m",5500,0,0]
[]
[]
[]
["","CARRIED TO SUMMARY                              ",{"$nulls":3},{"$f":"SUM(F75:F106)","v":0}]

{"sheet":"C3.2","index":8,"n_rows":150,"n_cols":9,"rows_kept":150,"merged":[[149,1,149,4]]}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C3.2 CULVERTS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C3.2","CULVERTS"]
[]
["C3.2.1.1","Excavating in all material situated within the following depth ranges below the surface level:"]
[]
["(a)","0 m to 1,5 m","m³",{"v":2000,"d":"2,000.00"},0,{"$f":"SUM(D10*E10)","v":0}]
[]
["(b)","Exceeding 1,5 m and up to 3,0 m","m³",{"v":7500,"d":"7500.00"},0,{"$f":"SUM(D12*E12)","v":0}]
[]
["(c )","Exceeding 3,0m up to 4,0 m","m³",{"v":450,"d":"450.00"},0,{"$f":"SUM(D14*E14)","v":0}]
[]
["C3.2.1.4","Extra over sub-item C3.2.1.1 for excavation in hard or boulder material, irrespective of depth","m³",{"v":2500,"d":"2500.00"},0,{"$f":"SUM(D16*E16)","v":0}]
[]
["C3.2.2","Backfilling:"]
[]
["C3.2.2.1","Using the excavated material","m³",{"$f":"SUM(D10:D16)","v":{"v":12450,"d":"12450.00"}},0,{"$f":"D20*E20","v":0}]
[]
["C3.2.3","Concrete pipe culverts:"]
[]
["C3.2.3.2","On Class B bedding:"]
[]
["(a)","600mmØ 75D ","m",{"$f":"3100-1900","v":{"v":1200,"d":"1200.00"}},0,{"$f":"D26*E26","v":0}]
[]
["(b) ","600mmØ 100D ","m",{"v":900,"d":"900.00"},0,{"$f":"D28*E28","v":0}]
[]
["(c )","675mmØ 75D ","m",{"v":130,"d":"130.00"},0,{"$f":"D30*E30","v":0}]
[]
["(d)","675mmØ 100D ","m",{"v":135,"d":"135.00"},0,{"$f":"D32*E32","v":0}]
[]
["(e )","750mmØ 75D ","m",{"$f":"210-155","v":{"v":55,"d":"55.00"}},0,{"$f":"D34*E34","v":0}]
[]
["(f )","750mmØ 100D ","m",{"v":80,"d":"80.00"},0,{"$f":"D36*E36","v":0}]
[]
["(g)","825mmØ 75D ","m",{"v":55,"d":"55.00"},0,{"$f":"D38*E38","v":0}]
[]
["(h)","825mmØ 100D ","m",{"v":110,"d":"110.00"},0,{"$f":"D40*E40","v":0}]
[]
["(i)","900mmØ 75D ","m",{"v":80,"d":"80.00"},0,{"$f":"D42*E42","v":0}]
[]
["(j)","900mmØ 100D ","m",{"v":105,"d":"105.00"},0,{"$f":"D44*E44","v":0}]
[]
["(k)","1050mmØ 75D ","m",{"v":87,"d":"87.00"},0,{"$f":"D46*E46","v":0}]
[]
["(l)","1050mmØ 100D ","m",{"v":110,"d":"110.00"},0,{"$f":"D48*E48","v":0}]
[]
["(m)","1200mmØ 75D ","m",{"v":115,"d":"115.00"},0,{"$f":"D50*E50","v":0}]
[]
["(n)","1200mmØ 100D ","m",{"v":110,"d":"110.00"},0,{"$f":"D52*E52","v":0}]
[]
["(o)","1350mmØ 75D ","m",{"v":400,"d":"400.00"},0,{"$f":"D54*E54","v":0}]
[]
["(p)","1350mmØ 100D ","m",{"v":155,"d":"155.00"},0,{"$f":"D56*E56","v":0}]
[]
["C3.2.3.5","Provision of skew ends of pipe culvert"]
[]
[null,"(600-1350mmØ","No",{"v":10,"d":"10.00"},0,{"$f":"D60*E60","v":0}]
[]
["C3.2.7","Cast in situ concrete and formwork:"]
[]
["C3.2.7.1","In Class A bedding, screeds, concrete backfill and the encasing for pipes, including formwork, (25MPa)","m³",55,0,{"$f":"D64*E64","v":0}]
[]
["C3.2.7.2","In complete in situ floor slabs for rectangular culverts, manholes and catchpits including formwork, joints and Class U2 surface finish (25MPa) (installed at a standard depth of 1,0 m)","m³",65,0,{"$f":"D66*E66","v":0}]
[]
["C3.2.7.3","In walls, excluding formwork but including Class U2 surface finish (25MPa)","m³",80,0,{"$f":"D68*E68","v":0}]
[]
["C3.2.7.5","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 (25MPa)","m³",35,0,{"$f":"D70*E70","v":0}]
[]
[" Total Carried Forward",{"$nulls":4},{"$f":"SUM(F6:F71)","v":0}]
[]
["New Mashifani Park: Installation of Civil Engineering Services: Roads & Stormwater Network"]
[]
["Contract No: Contract \"A1\""]
[]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
[" Brought Forward",{"$nulls":4},{"$f":"F72","v":0}]
[]
["C3.2.7.6","Formwork of concrete under items C3.2.7.3 to 5 above (U2)","m²",200,0,{"$f":"D81*E81","v":0}]
[]
["C3.2.8","Concrete backfill or encasement for culverts (19mm 20MPa)","m³",30,0,{"$f":"D83*E83","v":0}]
[]
["C3.2.10","Reinforcement:"]
[]
["C3.2.10.1","Mild steel bars","Ton",2,0,{"$f":"D87*E87","v":0}]
[]
["C3.2.10.2","High-tensile steel bars","Ton",7,0,{"$f":"D89*E89","v":0}]
[]
["C3.2.10.3","Welded steel fabric","kg",{"$f":"13000-8000","v":5000},0,{"$f":"D91*E91","v":0}]
[]
["C3.2.15","Manholes and catch pits, with prefabricated elements"]
[]
["C3.2.15.1","Prefabricated floors (installed at a standard depth of 1,5 m):"]
[]
["(a) ","600mmØ","No",{"$f":"200-135","v":65},0,{"$f":"D97*E97","v":0},null,null,388]
[]
["(b)","750mmØ","No",10,0,{"$f":"D99*E99","v":0}]
[]
["(c )","900mmØ","No",{"$f":"38-25","v":13},0,{"$f":"D101*E101","v":0}]
[]
["C3.2.15.2","Prefabricated roofs:"]
[]
["(a) ","600mmØ","No",{"$f":"200-135","v":65},0,{"$f":"D105*E105","v":0}]
[]
["(b)","750mmØ","No",10,0,{"$f":"D107*E107","v":0}]
[]
["(c )","900mmØ","No",{"$f":"38-25","v":13},0,{"$f":"D109*E109","v":0}]
[]
["C3.2.15.3","Prefabricated walls"]
[]
["(a) ","600mmØ","m",135,0,{"$f":"D113*E113","v":0}]
[]
["(b)","750mmØ","m",25,0,{"$f":"D115*E115","v":0}]
[]
["(c )","900mmØ","m",{"$f":"38-25","v":13},0,{"$f":"D117*E117","v":0}]
[]
["C3.2.15.4","Extra over item C3.2.15.1 and C3.2.7.2 for variations in the depths of all types of concrete manholes with prefabricated wall combinations deeper than 1,0 m","m",125,0,{"$f":"D119*E119","v":0}]
[]
["C3.2.16","Brickwork (Engineering bricks):"]
[]
["C3.2.16.2","230 mm thick","m²",85,0,{"$f":"D123*E123","v":0}]
[]
["C3.2.17","Plaster","m²",85,0,{"$f":"D125*E125","v":0}]
[]
["C3.2.18","Benching","m²",155,0,{"$f":"D127*E127","v":0}]
[]
["C3.2.19","Accessories:"]
[]
["C3.2.19.2","Inlet grids or covers","No",24,0,{"$f":"D131*E131","v":0}]
[]
["C3.2.19.3","Manhole frames","No",24,0,{"$f":"D133*E133","v":0}]
[]
["C3.2.19.4","Manhole covers or gratings","No",15,0,{"$f":"D135*E135","v":0}]
[]
["C3.2.20","Anchors for pipes ","No",40,0,{"$f":"D137*E137","v":0}]
[]
["C3.2.24","Compaction of bedding for inlets, outlets, manholes and catchpits:"]
[]
["C3.2.24.1","Preparation and compaction of in situ bedding material to 93 % of MDD (200mm)","m³",85,0,{"$f":"D141*E141","v":0}]
{"$rows_empty":8}
["","CARRIED TO SUMMARY                              ",{"$nulls":3},{"$f":"SUM(F79:F148)","v":0}]

{"sheet":"C3.3","index":9,"n_rows":73,"n_cols":6,"rows_kept":73,"merged":[[72,1,72,4]]}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C3.3 CONCRETE KERBING AND CHANNELLING"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C3.3","CONCRETE KERBING AND CHANNELLING, ASPHALT BERMS, CHUTES, DOWNPIPES, AS WELL AS CONCRETE, STONE PITCHED AND GABION LININGS FOR OPEN DRAINS"]
[]
["C3.3.1.1","Prefabricated kerbing-channeling"]
[]
[null,"Figure 8c","m",{"$f":"17500-10200","v":{"v":7300,"d":"7,300.00"}},0,{"$f":"D10*E10","v":0}]
[]
[null,"Figure 7","m",{"$f":"3200-1055","v":{"v":2145,"d":"2145.00"}},0,{"$f":"D12*E12","v":0}]
[]
[null,"Figure 3","m",{"$f":"2200-1455","v":{"v":745,"d":"745.00"}},0,{"$f":"D14*E14","v":0}]
[]
[null,"Figure 12","m",{"$f":"12000-5350","v":{"v":6650,"d":"6650.00"}},0,{"$f":"D16*E16","v":0}]
[]
[null,"Cast in situ concrete channeling (300mm wide x 100mm thk)","m",{"$f":"12500-6200","v":{"v":6300,"d":"6300.00"}},0,{"$f":"SUM(D18*E18)","v":0}]
[]
[null,"Transition kerbing as per drawing","m",{"$f":"450-125","v":{"v":325,"d":"325.00"}},0,{"$f":"D20*E20","v":0}]
[]
[]
[]
["C3.3.3","Extra over items C3.3.1 for concrete kerbing or concrete kerbing and channeling on curves"]
[]
["C3.3.3.1","On curves of radii more than or equal to 5,0 m but less than 20 m","m",{"v":125,"d":"125.00"},0,{"$f":"D26*E26","v":0}]
[]
["C3.3.3.2","On curves with radii more than or equal to 1,0 m but less than 5,0 m","m",null,0,"Rate Only"]
[]
["C3.3.3.3","On curves with radii less than 1,0 m","m",null,0,"Rate Only"]
[]
["C3.3.15","Energy dissipaters in outlet structures"]
[]
["C3.3.15.1","Precast concrete blocks in outlet structures","No",{"v":55,"d":"55.00"},0,{"$f":"D34*E34","v":0}]
[]
["C3.3.15.2","Stones set in outlet structures","m²",{"v":120,"d":"120.00"},0,{"$f":"D36*E36","v":0}]
[]
["C3.3.16","Demolition and removal of existing kerbs and/or channel","m³",{"v":105,"d":"105.00"},0,{"$f":"D38*E38","v":0}]
{"$rows_empty":34}
["","CARRIED TO SUMMARY                              ",{"$nulls":3},{"$f":"SUM(F10:F59)","v":0}]

{"sheet":"C4.1","index":10,"n_rows":46,"n_cols":6,"rows_kept":46}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C4.1 BORROW MATERIALS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C4.1","BORROW MATERIALS"]
[]
["C4.1.2","Additional material investigations during the supplementary exploration:"]
[]
["C4.1.2.1","Cost of additional trial pits and / or drilling and laboratory testing","prov sum ",{"v":1,"d":"1.00"},0,{"$f":"D10*E10","v":0}]
[]
["C4.1.2.2","Handling costs and profit in respect of item C4.1.2.1","%",{"$f":"F10","v":0},{"v":0,"d":"0%"},{"$f":"D12*E12","v":0}]
[]
["C4.1.4","Removing of the overburden:"]
[]
["C4.1.4.1","In borrow pits","m³",{"v":3000,"d":"3,000.00"},0,{"$f":"D16*E16","v":0}]
[]
["C4.1.5","Excavating of materials in the borrow pits and quarries, material obtained from:"]
[]
["C4.1.5.1","Soft excavation","m³",{"v":6200,"d":"6,200.00"},0,{"$f":"D20*E20","v":0}]
[]
["C4.1.5.4","Hard excavation (other than by blasting)","m³",{"v":4500,"d":"4,500.00"},0,{"$f":"D22*E22","v":0}]
[]
["C4.1.5.5","Hard excavation (by blasting)","m³",0,0,"Rate Only"]
[]
["C4.1.15.2","Finishing of the borrow pit and quarry areas, and the stockpile sites using labour enhanced methods of construction:"]
[]
[null,"(a) Borrow pits (list all borrow pits separately)","ha",{"v":3,"d":"3.00"},0,{"$f":"D28*E28","v":0}]
{"$rows_empty":16}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F44)","v":0}]
[null,null,"- 8 -"]

{"sheet":"C4.2","index":11,"n_rows":51,"n_cols":21,"rows_kept":51}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C4.2 CUT MATERIALS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C4.2","CUT MATERIALS"]
[]
["C4.2.2","Additional material investigations during the supplementary exploration"]
[]
["C4.2.2.1","Cost of additional trial pits and/or drilling and laboratory testing","Prov Sum",{"v":1,"d":"1.00"},0,{"$f":"D10*E10","v":0}]
[]
["C4.2.2.2","Handling costs and profit in respect of item C4.2.2.1","%",{"$f":"F10","v":0},{"v":0,"d":"0%"},{"$f":"D12*E12","v":0}]
[]
["C4.2.3","Excavating of materials in cuttings, material obtained from"]
[]
["C4.2.3.1","Soft excavation","m³",{"v":7000,"d":"7,000.00"},0,{"$f":"D16*E16","v":0}]
[]
["C4.2.3.2","Boulder excavation class A","m³",null,null,"Rate Only"]
[]
["C4.2.3.3","Boulder excavation class B","m³",null,null,"Rate Only"]
[]
["C4.2.3.4","Hard excavation (other than by blasting)","m³",{"v":1500,"d":"1,500.00"},0,{"$f":"D22*E22","v":0}]
[]
["C4.2.3.5","Hard excavation (by blasting)","m³",null,null,"Rate Only"]
[{"$nulls":19},0.85,0.15]
["C4.2.4","Excavating of materials in box cuts, material obtained from",{"$nulls":16},{"$f":"Q28*0.5","v":55800},{"$f":"S26*$T$25","v":47430},{"$f":"S26*$U$25","v":8370}]
[{"$nulls":18},{"$f":"Q28*0.3","v":33480},{"$f":"S27*$T$25","v":28458},{"$f":"S27*$U$25","v":5022}]
["C4.2.4.1","Soft excavation","m³",{"v":38400,"d":"38,400.00"},0,{"$f":"D28*E28","v":0},{"$nulls":7},18600,10,0.6,{"$f":"N28*O28*P28","v":111600},null,{"$f":"Q28*0.2","v":22320},{"$f":"S28*$T$25","v":18972},{"$f":"S28*$U$25","v":3348}]
[{"$nulls":16},{"$f":"Q28/2","v":55800},null,{"$f":"SUM(S26:S28)","v":111600}]
["C4.2.4.2","Boulder excavation class A","m³",null,null,"Rate Only"]
[]
["C4.2.4.3","Boulder excavation class B","m³",null,null,"Rate Only"]
[]
["C4.2.4.4","Hard excavation (other than by blasting)","m³",{"v":1500,"d":"1,500.00"},0,{"$f":"D34*E34","v":0}]
[]
["C4.2.4.5","Hard excavation (by blasting)","m³",{"v":800,"d":"800.00"},0,{"$f":"SUM(D36*E36)","v":0}]
[]
["C4.2.8","Excavate material to spoil in sites designated by the Contractor, material obtained from"]
[]
["C4.2.8.1","Soft excavation, overburden and unsuitable material","m³",{"v":2500,"d":"2,500.00"},0,{"$f":"D40*E40","v":0}]
[{"$nulls":9},{"$f":"SUM(D16:D34)","v":{"v":48400,"d":"48,400.00"}}]
["C4.2.8.2","Boulder excavation class A","m³",null,null,"Rate Only"]
[]
["C4.2.8.3","Boulder excavation class B","m³",null,null,"Rate Only"]
[]
["C4.2.8.4","Hard excavation (other than by blasting)","m³",{"v":1200,"d":"1,200.00"},0,{"$f":"D46*E46","v":0}]
[]
[]
[]
[]
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F50)","v":0}]

{"sheet":"C4.4","index":12,"n_rows":51,"n_cols":6,"rows_kept":51}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C4.4 COMMERCIAL MATERIALS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C4.4","COMMERCIAL MATERIALS"]
[]
["C4.4.2","Commercial materials identified by the Contractor from commercial, private or other non-commercial suppliers:"]
[]
["C4.4.2.1","Pavement layer material:"]
[]
[null,"(a) Type G1 material","m³",{"v":6300,"d":"6,300"},0,{"$f":"IF(C12 = CHAR(37), D12*E12/100,D12*E12)","v":0}]
[]
["C4.4.7","Sampling and material testing by a commercial laboratory for the stabilisation designs"]
[]
["C4.4.7.1","Cost of sampling and material testing","P. Suum",{"v":1,"d":"1.00"},0,{"$f":"D16*E16","v":0}]
[{"$nulls":4},"."]
["C4.4.7.2","Handling cost and profit in respect of item C4.4.7.1","%",{"$f":"F16","v":0},{"v":0,"d":"0%"},{"$f":"E18*D18","v":0}]
{"$rows_empty":31}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F49)","v":0}]
[null,null,"- 9 -"]

{"sheet":"C.5.1","index":13,"n_rows":62,"n_cols":6,"rows_kept":62}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C5.1 ROADBED"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C5.1","ROADBED"]
[]
["C5.1.1","Roadbed construction and compaction:"]
[]
["C5.1.1.2","Compaction of in-situ sand roadbed to 93 % of MDD","m³",{"v":3750,"d":"3,750.00"},0,{"$f":"D10*E10","v":0}]
[]
["C5.1.1.3","Compaction of imported material to 93 % of MDD","m³",{"v":700,"d":"700.00"},0,{"$f":"D12*E12","v":0}]
[]
["C5.1.2","Excavate material to spoil from roadbed construction:"]
[]
["C5.1.2.1","Excavate material to spoil from roadbed construction, material obtained from:"]
[]
[null,"(a) Soft excavation","m³",{"v":1000,"d":"1,000.00"},0,{"$f":"D18*E18","v":0}]
[]
[null,"(d) Hard excavation","m³",{"v":200,"d":"200.00"},0,{"$f":"D20*E20","v":0}]
[]
["C5.1.4","Removal of unsuitable material to spoil:"]
[]
["C5.1.4.1","In layer thicknesses of 200 mm and less:"]
[]
[null,"(a) Stable material","m³",{"v":1000,"d":"1,000.00"},0,{"$f":"D26*E26","v":0}]
[]
[null,"(b) Unstable material","m³",{"v":1200,"d":"1,200.00"},0,{"$f":"D28*E28","v":0}]
[]
["C5.1.5","In-situ treatment of roadbed in hard material:"]
[]
["C5.1.5.2","In-situ treatment by drilling and blasting","m³",{"v":100,"d":"100.00"},0,{"$f":"D32*E32","v":0}]
[]
["C5.1.6","Roller-pass compaction:"]
[]
["C5.1.6.3","Smooth drum vibratory rollers","m²",{"v":50000,"d":"50,000.00"},0,{"$f":"D36*E36","v":0}]
[]
["C5.1.12","Excavation for benches:"]
[]
["C5.1.12.1","Excavation for benches:"]
[]
[null,"(a) Side-cut to fill in soft material","m³",null,0,"Rate Only"]
[]
[null,"(b) Side-cut to spoil in soft material","m³",null,0,"Rate Only"]
[]
["C5.1.13","Construction of a levelling layer:"]
[]
["C5.1.13.1","Over roadbed treatment in hard material compacted to 90 % MDD","m³",0,0,"Rate Only"]
[]
["C5.1.13.2","Over a constructed pioneer layer compacted to 90 % MDD","m³",0,0,"Rate Only"]
{"$rows_empty":10}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F10:F50)","v":0}]
[null,null,"- 10 -"]

{"sheet":"C5.2","index":14,"n_rows":46,"n_cols":6,"rows_kept":46}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C5.2 FILL LAYERS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
[null,"FILL LAYERS"]
[]
["C5.2.2","FILL CONSTRUCTION"]
[]
["C5.2.2.1","Normal fill material in compacted layer thicknesses of 200 mm and less:"]
[]
[null,"(b) Compacted to 93 % of MDD","m³",{"v":8000,"d":"8,000.00"},0,{"$f":"IF(C12 = CHAR(37), D12*E12/100,D12*E12)","v":0}]
[]
["C5.2.5","Fill in sidewalk"]
[]
["C5.2.5.2","Fill material in sidewalk compacted to 93 % of MDD using labour enhanced methods of construction and light hand equipment.","m³",{"v":1400,"d":"1,400.00"},0,{"$f":"IF(C16 = CHAR(37), D16*E16/100,D16*E16)","v":0}]
[]
["C5.2.11","Finishing-off fill slopes, medians and interchange areas"]
[]
["C5.2.11.1","Fill slopes","m³",{"v":5100,"d":"5,100.00"},0,{"$f":"IF(C20 = CHAR(37), D20*E20/100,D20*E20)","v":0}]
{"$rows_empty":25}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F8:F45)","v":0}]

{"sheet":"C5.3","index":15,"n_rows":44,"n_cols":10,"rows_kept":44}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C5.3 ROAD PAVEMENT LAYERS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
[null,"ROAD PAVEMENT LAYERS"]
[]
["C5.3.2","Construction of pavement layers:"]
[]
["C5.3.2.1","Construction of layers using conventional construction methods:"]
[]
[null,"(a) Selected layer - G5 - (150mm thick) compacted to 95 % Mos Aashto Density - Sub Base","m³",{"v":6000,"d":"6,000.00"},0,{"$f":"IF(C12 = CHAR(37), D12*E12/100,D12*E12)","v":0}]
[{"$nulls":9},{"$f":"0.15*10.2*100","v":152.99999999999997}]
[null,"(b) Selected  layer - G5- (150mm thick) Stabilised to C4 Lower Sub-Base","m³",{"v":5800,"d":"5,800.00"},0,{"$f":"D14*E14","v":0}]
[]
[null,"(c) Selected layer G5 (Stabilized) (150mm thick)  To C3 Upper Sub-Base Layer","m³",{"v":3650,"d":"3,650.00"},0,{"$f":"IF(C16 = CHAR(37), D16*E16/100,D16*E16)","v":0}]
[]
[null,"(d) Gravel Base layer G5 (Stabilized) (150mm thick) Stabilized to C4 Base layer","m³",{"v":3400,"d":"3,400.00"},0,{"$f":"D18*E18","v":0}]
[]
["C5.3.2.2","Construction of layers using labour enhancement:"]
[null,"(e ) Gravel wearing course layer (layer thickness indicated) compacted to 95 % of MDD","m³",{"v":1250,"d":"1,250.00"},0,{"$f":"D21*E21","v":0}]
[]
["C5.3.9","Construction of a trial section:"]
[]
["C5.3.9.1","Construction of a trial section using conventional methods of construction:"]
[]
[null,"(a) Stabilised gravel layer (150mm thick) trial section","m³",{"v":180,"d":"180.00"},0,{"$f":"IF(C27 = CHAR(37), D27*E27/100,D27*E27)","v":0}]
[]
[null,"(c) Crushed stone base layer (150mm thick) trial section","m³",{"$f":"D27","v":{"v":180,"d":"180.00"}},0,{"$f":"IF(C29 = CHAR(37), D29*E29/100,D29*E29)","v":0}]
[]
[]
["C5.3.12","Surface regularity payment adjustments","prov sum ",{"v":1,"d":"1.00"},{"v":100000,"d":"R100,000.00"},{"$f":"IF(C32 = CHAR(37), D32*E32/100,D32*E32)","v":{"v":100000,"d":"R100,000.00"}}]
{"$rows_empty":10}
[" Total Carried Forward To Summary"]
[null,null,"- 11 -"]

{"sheet":"C5.4","index":16,"n_rows":50,"n_cols":14,"rows_kept":50}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C5.4 STABILISATION"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C5.4","STABILISATION"]
[]
["C5.4.1","Pre-treatment of gravel layers:"]
[]
["C5.4.1.1","Pre-treatment of (150mm thick) gravel layer","m³",0,0,"Rate Only"]
[]
["C5.4.2","Chemical Stabilization"]
[]
["C5.4.2.1","Chemical stabilisation (150mm) of base layers ","m³",{"$f":"SUM('C5.3'!D16,'C5.3'!D18)","v":{"v":7050,"d":"7,050.00"}},0,{"$f":"E14*D14","v":0}]
[]
[null,"Chemical stabilisation (150mm) of subbase layers ","m³",{"$f":"SUM('C5.3'!D12,'C5.3'!D14)","v":{"v":11800,"d":"11,800.00"}},0,{"$f":"D16*E16","v":0}]
[]
[]
["C5.4.5","Cementitious stabilisation agents for pavement layers:"]
[]
["C5.4.5.2","Addition of cementitious stabilisation agents (specify agent separately) for pavement layers and spreading the agent using bags and labour enhancement methods:"]
[{"$nulls":9},"Mod","Compaction","Percentage"]
[null,"(a) Cement (for base and subbase)","t",{"v":600,"d":"600.00"},0,{"$f":"IF(C23 = CHAR(37), D23*E23/100,D23*E23)","v":0},{"$nulls":3},1909,{"v":0.98,"d":"98%"},{"v":0.03,"d":"3%"},{"$f":"J23*K23*L23","v":{"v":56.124599999999994,"d":"56.12"}}]
[{"$nulls":9},"Length ","Width","Depth"]
[null,"(b) And so forth for other agents (for pavement layers)","t",0,0,"Rate Only ",{"$nulls":3},18600,7.4,0.15,{"$f":"J25*K25*L25","v":{"v":20646,"d":"20,646.00"}}]
[{"$nulls":11},"Cement",{"$f":"ROUNDUP(M25/M23,0)+ROUNDUP(M23*M25,0)","v":{"v":1159117,"d":"1,159,117.00"}},"Kg"]
["C5.4.10","Provision and application of water for curing","kℓ",{"v":700,"d":"700.00"},0,{"$f":"IF(C27 = CHAR(37), D27*E27/100,D27*E27)","v":0},{"$nulls":6},{"$f":"M26/1000","v":{"v":1159.117,"d":"1,159.12"}},"Tons"]
[]
["C5.4.14","Trial section for a stabilised layer","m³",{"v":170,"d":"170.00"},0,{"$f":"IF(C29 = CHAR(37), D29*E29/100,D29*E29)","v":0}]
{"$rows_empty":19}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F48)","v":0}]
[null,null,"- 12 -"]

{"sheet":"C6.2","index":17,"n_rows":53,"n_cols":10,"rows_kept":53}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C6.2 SEGMENTAL BLOCK PAVING LAYERS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C6.2","SEGMENTAL BLOCK PAVING LAYERS"]
[]
["C6.2.1","Segmental Block paving"]
[]
["C6.2.1.1","Concrete block paving (S-A type, 80mm thick) ","     m²     ",{"v":20000,"d":"20,000.00"},0,{"$f":"D10*E10","v":0}]
[]
["C6.2.1.2","Concrete block paving (S-A type, 60mm thick) ","     m²     ",{"v":6500,"d":"6,500.00"},0,{"$f":"D12*E12","v":0}]
[]
["C6.2.2","Cast in-situ concrete edge and intermediate beams","m³",{"$f":"0.2*0.3*1000","v":60},0,{"$f":"D14*E14","v":0}]
[]
["C6.2.3.1","Provision of materials","Prime cost  sum ",{"v":1,"d":"1.00"},0,{"$f":"D16*E16","v":0},{"$nulls":3},{"$f":"0.2*0.3*[1]Sheet1!$G$12","v":634.08216}]
[{"$nulls":9},{"$f":"J16*1.1","v":697.4903760000001}]
["C6.2.3.2","Contractor’s charges and profit","%",{"$f":"F16","v":0},{"v":0,"d":"0%"},{"$f":"D18*E18","v":0}]
[]
[{"$nulls":8},{"$f":"0.02*[1]Sheet1!$G$12","v":211.36072000000004},{"$f":"13900*1.05","v":14595}]
[{"$nulls":8},{"$f":"I20*1.1","v":232.49679200000006}]
{"$rows_empty":30}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F51)","v":0}]
[null,null,"- 12 -"]

{"sheet":"C8.1","index":18,"n_rows":48,"n_cols":6,"rows_kept":48}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C8.1 PRIME COAT"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C8.1","PRIME COAT"]
[]
["C8.1.1","Prime coat:"]
[]
["C8.1.1.2","MC -30 cut-back bitumen","ℓ",{"v":13000,"d":"13,000.00"},0,{"$f":"IF(C10 = CHAR(37), D10*E10/100,D10*E10)","v":0}]
[]
["C8.1.1.3","Inverted bitumen emulsion","ℓ",0,0,"Rate Only "]
[]
["C8.1.2","Aggregate for blinding:"]
[]
["C8.1.2.2","Crusher sand","m³",null,0,"Rate Only "]
[]
["C8.1.3","Extra over item C8.1.1 for applying the prime coat accessible only to hand-held or light equipment","ℓ",{"v":200,"d":"200.00"},0,{"$f":"D18*E18","v":0}]
{"$rows_empty":28}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F46)","v":0}]
[null,null,"- 13 -"]

{"sheet":"C.9.1","index":19,"n_rows":43,"n_cols":10,"rows_kept":43}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C9.1 ASPHALT LAYERS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C9.1","ASPHALT LAYERS"]
[]
["C9.1.5.1","New construction:"]
[]
[null,"(ii) (a) Stone skeletal mix – continuously graded as defined (30mm, 70/100 Pennetration Grade Bitumen and design class / level)","m²",{"v":19000,"d":"19,000.00"},0,{"$f":"D10*E10","v":0}]
[]
["C9.1.6","Extra over pay items C.9.1.4.1 and C.9.1.5.1 for placing small quantities of asphalt of less than 10 tons specially produced as specified in terms of Clause A9.1.7.1d)","t",{"v":10,"d":"10.00"},0,{"$f":"IF(C12 = CHAR(37), D12*E12/100,D12*E12)","v":0}]
[]
["C9.1.2","Construction of trial sections:",{"$nulls":7},{"$f":"8.2*100","v":819.9999999999999}]
[]
["C9.1.2.1","Asphalt layers - Continously graded, 30mm thick, 50/70 Penetration Grade Bitumen, applied by paver","m²",{"v":600,"d":"600.00"},0,{"$f":"IF(C16 = CHAR(37), D16*E16/100,D16*E16)","v":0}]
[]
[null,"Removal of trial section where so instructed by the Engineer","m²",{"$f":"D16","v":{"v":600,"d":"600.00"}},0,{"$f":"D18*E18","v":0}]
[]
["C9.1.3","Application of bond coat:"]
[]
["C9.1.6","Extra over pay items C.9.1.4.1 and C.9.1.5.1 for placing small quantities of asphalt of less than 10 tons specially produced as specified in terms of Clause A9.1.7.1d)","t",{"v":50,"d":"50.00"},0,{"$f":"IF(C22 = CHAR(37), D22*E22/100,D22*E22)","v":0}]
{"$rows_empty":19}
[" Total Carried Forward To Summary",{"$nulls":4},{"$f":"SUM(F6:F41)","v":0}]
[null,null,"- 14 -"]

{"sheet":"C.11.6","index":20,"n_rows":49,"n_cols":6,"rows_kept":49}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C11.6 ROAD SIGNS "]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C11.6","ROAD SIGNS                                      "]
[]
["C11.6.1","Road signboards with painted or coloured semi-matt background. "]
[null,"Symbols, lettering and borders in semi- matt black or in Class I"]
[null," retro-reflective 'material, where the sign board is constructed from:"]
[]
["C11.6.1.1","Aluminium sheet (2,0 mm thick)"]
[]
[null,"(b) Area exceeding 0,5m² but not 2 m² ","No.",{"v":50,"d":"50.00"},0,{"$f":"D14*E14","v":0}]
[]
["C11.6.1.3","Prepainted galvanized steel plate (chromadeck or"]
[null,"approved equivalent)"]
[]
[null,"(b) Area exceeding 0,5m² but not 2 m² ","    No.     ",{"v":50,"d":"50.00"},0,{"$f":"D19*E19","v":0}]
[]
["C11.6.6","Dismantling, storing and re-erecting road signs with a surface area of:         "]
[]
["C11.6.6.3","Area exceeding 2 m² but not 10 m² ","    No.     ",0,0,"Rate Only"]
[""]
["C11.6.6.4","Exceeding 10 m²                      ","    No.     ",{"v":1,"d":"1.00"},0,"Rate Only"]
[]
["C11.6.8","Danger plates at culverts/structures"]
[]
["C11.6.8.1","Size 150 x 600mm ","No.",{"v":40,"d":"40.00"},0,{"$f":"D29*E29","v":0}]
{"$rows_empty":18}
["","CARRIED TO SUMMARY                              ",{"$nulls":3},{"$f":"SUM(F6:F47)","v":0}]
[null,null,"- 15 -"]

{"sheet":"C11.7","index":21,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[51,1,51,4]]}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C11.7 ROAD MARKINGS AND ROAD STUDS "]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["C11.7","ROAD MARKINGS AND ROAD STUDS"]
[]
["C11.7.2","Retro-reflective road-marking paint                            "]
[]
["C11.7.2.1","White lines (broken or unbroken):           "]
[]
["","(i) 100 mm wide                                 ","     km     ",{"v":6,"d":"6.00"},0,{"$f":"D12*E12","v":0}]
[]
["","(ii) 150 mm wide                                ","     km     ",null,0,"Rate Only"]
[]
["","(iii) 200 mm wide                               ","     km     ",null,0,"Rate Only"]
[]
["C11.7.2.2","Yellow lines (broken or unbroken):          "]
[]
["","(i) 100 mm wide                                 ","     km     ",null,0,"Rate Only"]
[]
["","(ii) 150 mm wide                                ","     km     ",{"v":3,"d":"3.00"},0,{"$f":"D22*E22","v":0}]
[]
["C11.7.2.4","White lettering and symbols                 ","     m²     ",{"v":200,"d":"200.00"},0,{"$f":"E24*D24","v":0}]
[]
["C11.7.2.5","Yellow lettering and symbols                ","     m²     ",{"v":25,"d":"25.00"},0,{"$f":"D26*E26","v":0}]
[]
["C11.7.5","Variations in rate of application:              "]
[]
["C11.7.5.1","White paint                                 ","  litre     ",{"v":10,"d":"10.00"},0,{"$f":"D30*E30","v":0}]
[]
["C11.7.5.2","Yellow paint                                ","  litre     ",{"v":10,"d":"10.00"},0,{"$f":"E32*D32","v":0}]
[]
["C11.7.7","Road studs"]
[]
["C11.7.7.1","Permanent road studs compliant to SANS 1442 ","No",{"v":1500,"d":"1,500.00"},0,"Rate Only"]
[null,"red, yellow and white"]
[]
["C11.7.8","Setting out and premarking the lines            ","     km     ",{"v":6,"d":"6.00"},0,{"$f":"E39*D39","v":0}]
["","(excluding traffic-island markings,             "]
["","lettering and symbols)                          "]
[]
["C11.7.9","Re-establishing the painting unit during the defects notification  "," Lump S     ",{"v":1,"d":"1.00"},0,{"$f":"E43*D43","v":0}]
["","period and at other instances on instruction of the Engineer"]
[]
["57.08","Re-marking of road after liability period"," Lump S     ",{"v":1,"d":"1.00"},0,{"$f":"D46*E46","v":0}]
[]
[]
[]
[]
[]
[{"$nulls":5},{"$f":"SUM(F6:F51)","v":0}]
[]
[]
[""]

{"sheet":"C11.9","index":22,"n_rows":51,"n_cols":6,"rows_kept":51}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"C11.9 FINISHING THE ROAD AND RESERVE AND TREATING OLD ROADS"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
[]
["11.9","FINISHING THE ROAD AND ROAD RESERVE AND         "]
["","TREATING OLD ROADS                              "]
[]
["C11.9.1","Finishing road and road reserve:                "]
[]
["C11.9.1.2","Single carriageway road                     ","     km     ",{"v":5.2,"d":"5.20"},0,{"$f":"D12*E12","v":0}]
{"$rows_empty":35}
[null,"CARRIED TO SUMMARY                              ",{"$nulls":3},{"$f":"SUM(F6:F47)","v":0}]
[]
[]
[""]

{"sheet":"G.10","index":23,"n_rows":49,"n_cols":10,"rows_kept":49}
[{"$f":"'C1.5'!A1","v":"New Mashifane Park: Installation of Civil Engineering Services: Roads and Stormwater Network"}]
[]
[{"$f":"'C1.5'!A3","v":"Contract No: Contract  \"A1\""}]
[{"$nulls":5},"G1000 GUIDELINES FOR SUBCONTRACTING AND LABOUR ENHANCEMENT"]
["Item","Description","Unit","Quantity","Rate","Amount (R)"]
["G1000","GUIDELINES FOR SUBCONTRACTING AND LABOUR ENHANCEMENT"]
[]
["G10.01","Project Liaison Committee costs","Prov sum",{"v":1,"d":"1.00"},{"v":100000,"d":"R100,000.00"},{"$f":"E8*D8","v":{"v":100000,"d":"R100,000.00"}}]
[]
[null,"(a) Handling cost and profit in respect of Item G10.01 above","%",{"$f":"F8","v":{"v":100000,"d":"100,000.00"}},{"v":0,"d":"0%"},{"$f":"D10*E10","v":0}]
[]
["G10.02","Community Liaison Officer salary","month",{"v":12,"d":"12.00"},{"v":60000,"d":"R60,000.00"},{"$f":"D12*E12","v":{"v":720000,"d":"R720,000.00"}},{"$nulls":3},{"$f":"7000*18","v":126000}]
[]
[null,"(a) Handling cost and profit in respect of Item G10.02 above","%",{"$f":"F12","v":{"v":720000,"d":"720,000.00"}},{"v":0,"d":"0%"},{"$f":"D14*E14","v":0}]
[]
["G10.03","Training:"]
[]
[null,"(a) General training of potential ABE™s","Prov sum",{"v":1,"d":"1.00"},{"v":150000,"d":"R150,000.00"},{"$f":"E18*D18","v":{"v":150000,"d":"R150,000.00"}}]
[]
[null,"(b) Training of the temporary workforce:"]
[]
[null,"(i) Technical training","Prov sum",{"v":1,"d":"1.00"},{"v":450000,"d":"R450,000.00"},{"$f":"D22*E22","v":{"v":450000,"d":"R450,000.00"}}]
[]
[null,"(ii) HIV/ AIDS training","Prov sum",{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},{"$f":"D24*E24","v":{"v":50000,"d":"R50,000.00"}}]
[]
[null,"(iii) OHS Training","Prov sum",{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},{"$f":"D26*E26","v":{"v":50000,"d":"R50,000.00"}}]
[]
[null,"(c) Handling cost and profit in respect of Items G10.03 (a) (b) (i) (ii) (iii)","%",{"$f":"SUM(F18:F26)","v":{"v":700000,"d":"700,000.00"}},{"v":0,"d":"0%"},{"$f":"D28*E28","v":0}]
[]
["G10.05","Provision and maintenance of the ABE support office","month",{"v":12,"d":"12.00"},0,{"$f":"D30*E30","v":0}]
[]
["G10.06","Penalties"]
[]
[null,"(Refer to Part C3.7 : Guidelines for subcontracting and labour enhancement for the calculation of penalties)\r\n"]
[]
[null,"(a) Contract participation goals for subcontracting to Affirmable Business Enterprise (ABE) / Targeted Enterprise (CIDB 1CE PE - CIDB 5CE PE) 15%","%",0,0,{"$f":"D36*E36","v":0}]
[]
[null,"(b) Targeted Labour (8%)","%",0,0,{"$f":"D38*E38","v":0}]
{"$rows_empty":9}
[" Total Carried Forward To Summary"]
[null,null,"- 15 -"]