{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["1-P's & G's","2-DAYWORKS","3-SITE CLEARANCE","4-EARTHWORKS","5-CULVERTS","6-GABIONS","BILL SUMMARY"],"not_rendered":{"external_links":8,"defined_names":205},"read":"whole","date_system":"1900"}

{"sheet":"1-P's & G's","index":0,"n_rows":185,"n_cols":7,"rows_kept":185,"merged":[[1,0,1,1],[2,0,2,1],[2,2,2,6],[74,0,74,5],[75,0,75,5],[131,0,131,5],[132,0,132,5],[184,0,184,5]]}
["CLIENT :",null,"COUNCIL FOR GEOSECIENCE"]
["CONTRACT No :",null,"CGS-2024-022S"]
["FOR :",null,"APPOINTMENT OF CONTRACTOR FOR THE IMPLEMENTATION OF INGRESS CONTROL MEASURES MODDERBEE CANAL PHASE 1"]
[null,null,"BILLS OF QUANTITIES  SECTION 1: P's&G's"]
["ITEM ","PAYMENT","DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["NO","ITEM",null,null,"TITY",null,"R            C"]
[1,"SANS 1200 A","SECTION 1: PRELIMINARY AND GENERAL"]
[1.1,"PSA 8.3","SCHEDULED FIXED-CHARGE AND VALUE RELATED ITEMS"]
[]
["1.1.1",null,"Fixed Preliminary and General Items"]
[]
["1.1.1.1","PSA 8.3.1","Contractual requirements (excluding items scheduled below)","Sum",1,null,{"$f":"F12*E12","v":0}]
[]
["1.1.2","8.3.2","Establishment of Facilities on site"]
[]
["1.1.2.1"," PSA 8.3.2.1 ","Facilities for the Engineer:"]
["`"]
[null,null,"a) Furnished Office (1 No)","Sum",1,null,{"$f":"F18*E18","v":0}]
[]
[null,null,"c) Project name board (1 No. off)","Sum",1,null,{"$f":"F20*E20","v":0}]
[]
["1.1.2.2","8.3.2.2","Facilities for  the Contractor:"]
[]
[null,null,"a) Offices and storage sheds","Sum",1,null,{"$f":"F24*E24","v":0}]
[]
[null,null,"b) Workshops","Sum",1,null,{"$f":"F26*E26","v":0}]
[]
[null,null,"c) Laboratories","Sum",1,null,{"$f":"F28*E28","v":0}]
[]
[null,null,"d) Living accommodation","Sum",1,null,{"$f":"F30*E30","v":0}]
[]
[null,null,"e) Ablution and latrine facilities","Sum",1,null,{"$f":"F32*E32","v":0}]
[]
[null,null,"f) Tools and equipment","Sum",1,null,{"$f":"F34*E34","v":0}]
[]
[null,null,"g) Water supplies ,electric power and communications (Services to site offices)","Sum",1,null,{"$f":"F36*E36","v":0}]
[]
[null,null,"h) Dealing with water","Sum",1,null,{"$f":"F38*E38","v":0}]
[]
[null,null,"i) Access","Sum",1,null,{"$f":"F40*E40","v":0}]
[]
[null,null,"j) Plant (7 KVA, 220 Volt (Gentech / Turner Morris / Honda / similar approved) Diesel Generator, for the duration of the project)","Sum",1,null,{"$f":"F42*E42","v":0}]
[]
[null,null,"k) Site Security (Armed Security)","Sum",1,null,{"$f":"F44*E44","v":0}]
[]
["1.1.3","8.3.3","Other fixed-charge obligations","sum",1,null,{"$f":"F46*E46","v":0}]
[]
["1.1.4","8.3.4","Removal of site Establishment","Sum",1,null,{"$f":"F48*E48","v":0}]
[]
[1.2,8.4,"SCHEDULED TIME-RELATED CHARGES"]
[]
["1.2.1","PSA 8.4.1","Contractual requirements (excluding items scheduled below)","Sum",1,null,{"$f":"F52*E52","v":0}]
[]
["1.2.2","8.4.2","Operation and maintenance of facilities on site, for duration of construction, except where otherwise stated"]
[]
["1.2.2.1","8.4.2.1","Facilities for the Engineer:"]
[]
[null,null,"a) Furnished Office (2 No)","Sum",1,null,{"$f":"F58*E58","v":0}]
[]
[null,null,"b) Project name board","Sum",1,null,{"$f":"F60*E60","v":0}]
[]
[null,"PSA","c) Survey Assistants, equipment and materials","Sum",1,null,{"$f":"F62*E62","v":0}]
[null,"8.4.2.1d"]
[]
["1.2.2.2","8.4.2.2","Facilities for the Contractor:"]
[]
[null,null,"a) offices and storage sheds","Sum",1,null,{"$f":"F67*E67","v":0}]
[]
[null,null,"b) workshops","Sum",1,null,{"$f":"F69*E69","v":0}]
[]
[null,null,"c) laboratories","Sum",1,null,{"$f":"F71*E71","v":0}]
[]
[]
[]
["Carried forward",{"$nulls":5},{"$f":"SUM(G7:G74)","v":0}]
["Brought  forward",{"$nulls":5},{"$f":"G75","v":0}]
[]
[null,null,"d)Living accommodation","Sum",1,null,{"$f":"F78*E78","v":0}]
[]
[null,null,"e) Ablution and latrine facilities","Sum",1,null,{"$f":"F80*E80","v":0}]
[]
[null,null,"f) Tools and equipment","Sum",1,null,{"$f":"F82*E82","v":0}]
[]
[null,null,"g) Water supplies ,electric power and communications (Services to site offices)","Sum",1,null,{"$f":"F84*E84","v":0}]
[]
[null,null,"h)Dealing with water","Sum",1,null,{"$f":"F86*E86","v":0}]
[]
[null,null,"i) access","Sum",1,null,{"$f":"F88*E88","v":0}]
[]
[null,null,"j) Plant (7 KVA Gentech / Turner Morris / Honda / Similar approved Diesel Generator), for the duration of the project","Sum",1,null,{"$f":"F90*E90","v":0}]
[]
[null,null,"k) Site Security (Armed Security) ","Sum",1,null,{"$f":"F92*E92","v":0}]
[]
["1.2.3","8.4.3","Supervision for duration of construction","Sum",1,null,{"$f":"F94*E94","v":0}]
[]
["1.2.4","8.4.4","Company and Head Office over-head costs for Duration of Contract","Sum",1,null,{"$f":"F96*E96","v":0}]
[]
["1.2.5","8.4.5","Other time- related obligations","Sum",1,null,{"$f":"F98*E98","v":0}]
[]
["1.2.6","SANS","Compliance with OHSA (Act 85 of 1993) as stipulated under  "]
[null,"1200 A","\"Part C3.6 & 3.7:  HEALTH AND SAFETY SPECIFICATIONS\" of the contract"]
[]
[null,null,"    a) Implementation of Health and Safety Plan ","Sum",1,null,{"$f":"F103*E103","v":0}]
[]
[null,null,"    b) Provision of a full time Construction Health and Safety Officer","Sum",1,null,{"$f":"F105*E105","v":0}]
[]
[null,null,"    c) Health and Safety Training","Sum",1,null,{"$f":"F107*E107","v":0}]
[]
[null,null,"    d) Personal Protective Clothing and Equipment","Sum",1,null,{"$f":"F109*E109","v":0}]
[]
[null,null,"    e) Fences, Signs and Barricades","Sum",1,null,{"$f":"F111*E111","v":0}]
[]
[null,null,"    f) Other Health and Safety Obligations (Covid-19 Requirements)","Sum",1,null,{"$f":"F113*E113","v":0}]
[]
[null,null,"    g) OHS agent for the duration of the project","Month",6,null,{"$f":"F115*E115","v":0}]
[]
[1.3,"PSA 8.5","SUMS STATED PROVISIONALLY BY ENGINEER"]
[]
[null,"PSA 8.5.1","a) For work to be executed by Contractor and valued in terms of the \"valuation of variations\" clause in the conditions of contract"]
["1.3.1","PSA 8.5.1.1","Provision for Registered Surveyor for the setting out  of 3 additional benchmarks & other required survey works as required by the engineer & in line with SANS1200A items 8.5.1.1 and 8.8.5).","Prov Sum",1,{"v":25000,"d":"R 25,000.00"},{"$f":"F120*E120","v":{"v":25000,"d":"R25,000.00"}}]
[]
["1.3.2",null,"Overheads, charges and profit on item 1.3.1 above ","%",{"$f":"F120","v":{"v":25000,"d":"25,000.00"}},null,{"$f":"F122*E122","v":0}]
[]
["1.3.3",null,"On-site inspectorate and additional tests required by the Engineer ","Prov Sum",1,{"v":50000,"d":"R 50,000"},{"$f":"F124*E124","v":{"v":50000,"d":"R50,000.00"}}]
[]
["1.3.4",null,"Overheads, charges and profit on item 1.3.5 above","%",{"$f":"F124","v":{"v":50000,"d":"50,000"}},null,{"$f":"F126*E126","v":0}]
[]
["1.3.5",null,"Geotechnical Investigation on the canal bed and bridge foundation","Prov Sum",1,{"v":55000,"d":"R 55,000.00"},{"$f":"F128*E128","v":{"v":55000,"d":"R55,000.00"}}]
[]
["1.3.6",null,"Charge required by Contractor on subitem 1.3.6 above","%",{"$f":"F128","v":{"v":55000,"d":"55,000.00"}},null,{"$f":"F130*E130","v":0}]
[]
["Carried forward",{"$nulls":5},{"$f":"SUM(G76:G131)","v":{"v":130000,"d":"R130,000.00"}}]
["Brought  forward",{"$nulls":5},{"$f":"G132","v":{"v":130000,"d":"R130,000.00"}}]
[]
[]
["1.3.7",null,"Application and submission of all wayleaves","Prov Sum",1,{"v":25000,"d":"R 25,000.00"},{"$f":"F136*E136","v":{"v":25000,"d":"R25,000.00"}}]
[]
["1.3.8",null,"Charge required by Contractor on subitem 1.3.11 above","%",{"$f":"F136","v":{"v":25000,"d":"25,000.00"}},null,{"$f":"E138*F138","v":0}]
[]
["1.3.9",null,"Provision for all actions, equipment and material required to ","Prov Sum",1,{"v":15000,"d":"R 15,000.00"},{"$f":"F140*E140","v":{"v":15000,"d":"R15,000.00"}}]
[null,null,"connect with Existing canal"]
[]
["1.3.10",null,"Overheads, charges and profit on item 1.3.13 above ","%",{"$f":"F140","v":{"v":15000,"d":"15,000.00"}},null,{"$f":"F143*E143","v":0}]
[]
["1.3.11",null,"Environmental Managemant"]
[]
["1.3.12a",null,"Compliance with Environmental Management plan","Prov Sum",{"v":1,"d":"1.00"},{"v":30000,"d":"R30,000.00"},{"$f":"F147*E147","v":{"v":30000,"d":"R30,000.00"}}]
[]
["1.3.12b",null,"Overheads, charges and profit on item 1.3.14a above ","%",{"$f":"F147","v":{"v":30000,"d":"30,000.00"}},null,{"$f":"E149*F149","v":0}]
[]
["1.3.13",null,"Relocation of existing services:"]
[]
[null,null,"(a) Relocating existing services as well as point repairs ","Prov Sum",1,{"v":20000,"d":"R 20,000.00"},{"$f":"F153*E153","v":{"v":20000,"d":"R20,000.00"}}]
[]
[null,null,"(b) Overheads, charges and profit on item (a) above ","%",{"$f":"F153","v":{"v":20000,"d":"20,000.00"}},null,{"$f":"E155*F155","v":0}]
[]
[1.4,8.8,"TEMPORARY WORKS"]
[]
["1.4.1","8.8.3","Protection of existing structures until construction in the vicinity is Complete","Sum",1,null,{"$f":"F159*E159","v":0}]
[]
["1.4.2","8.8.4","Existing services:"]
[]
[null,null,"a) Supply or hire of specialist equipment for the detection of:"]
[]
[null,null,"(i) Electrical and other cables","Sum",1,null,{"$f":"F165*E165","v":0}]
[]
[null,null,"(ii) Water pipelines","Sum",1,null,{"$f":"F167*E167","v":0}]
[]
[null,null,"(iii) Sewer pipelines","Sum",1,null,{"$f":"F169*E169","v":0}]
[]
[null,null,"b) The use of the equipment  referred to in item (a) above","Sum",1,null,{"$f":"F171*E171","v":0}]
[]
[null,null,"c)  Hand excavation necessary for locating and exposing existing services soft materials:"]
[]
[null,null,"(i) In roadways","m³",20,null,{"$f":"F175*E175","v":0}]
[]
[null,null,"(ii) In all other areas","m³",20,null,{"$f":"F177*E177","v":0}]
[]
[1.5,"8.8.6","Special Water Control in Terms of Project Specification"]
[]
[null,null,"Temporary canal flow diversion or temporary canal flow storage to allow for construction works ro proceed uninterupted","Sum",1,null,{"$f":"F181*E181","v":0}]
[]
[1.6,null,"Provide \"As Built\" drawings(with x,y,z coordinates) for the exact positions of all pipework, water markers, valve manholes and chambers.","Sum",1,null,{"$f":"F183*E183","v":0}]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G133:G184)","v":{"v":220000,"d":"R220,000.00"}}]

{"sheet":"2-DAYWORKS","index":1,"n_rows":84,"n_cols":7,"rows_kept":84,"merged":[[0,0,0,1],[0,2,0,4],[1,0,1,1],[1,2,1,4],[2,0,2,1],[2,2,2,6],[75,0,75,5]]}
["CLIENT :",null,{"$f":"'1-P''s & G''s'!C1","v":"COUNCIL FOR GEOSECIENCE"}]
["TENDER No :",null,{"$f":"'1-P''s & G''s'!C2","v":"CGS-2024-022S"}]
["FOR :",null,{"$f":"'1-P''s & G''s'!C3:G3","v":"APPOINTMENT OF CONTRACTOR FOR THE IMPLEMENTATION OF INGRESS CONTROL MEASURES MODDERBEE CANAL PHASE 1"}]
[null,null,"SECTION 2: DAYWORKS "]
["ITEM NO","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE ","AMOUNT"]
[null,"ITEM"]
[null,"SANS"]
[null,"1200 A"]
[null,"PSA"]
[2,8.7,"SECTION 5: DAY WORKS"]
[null,null,"(Note: Rates submitted as \"Rate Only\" must be fair and balanced as it"]
[null,null," may be used to determine the contract value)"]
[]
[2.1,null,"LABOUR"]
[null,null,"(a) Working Hours (As and when instructed by the Engineer including "]
[null,null,"non-working hours, Public Holidays, Weekends etc.)"]
[]
[null,null,"(i) Unskilled Labour","hour",10,null,{"$f":"F18*E18","v":0}]
[]
[null,null,"(ii) Semi-Skilled Labour","hour",10,null,{"$f":"F20*E20","v":0}]
[]
[null,null,"(iii) Skilled Labour","hour",10,null,0]
[]
[null,null,"(iv) Construction Foreman","hour",10,null,0]
[]
[null,null,"(v) Gang Supervisor","hour",10,null,0]
[]
[null,null,"(vi) Surveyors Assistant","hour",10,null,0]
[]
[null,null,"(vii) Registered Surveyor","hour",10,null,0]
[]
[2.2,8.7,"PLANT"]
[]
[null,null,"(i) Excavator 25 - 30 Ton (110kw)","hour",10,null,0]
[]
[null,null,"(ii) Excavator Less 25 Ton (Less 110kw)","hour",10,null,0]
[]
[null,null,"(iii) Loader 10 Ton","hour",10,null,0]
[]
[null,null,"(iv) TLB Backator (10 ton Max)","hour",10,null,0]
[]
[null,null,"(v) Tipper or Dumper (4-10m3)","hour",10,null,0]
[]
[null,null,"(vi) Grader (CAT 140G or Similar Approved)","hour",10,null,0]
[]
[null,null,"(vii) Water Truck (Equpied with sprayer) 5000 litres Min","hour",10,null,0]
[]
[null,null,"(viii) Compactor (Bomag BW190 11-13tons or Similar Approved) (100kw)","hour",10,null,0]
[]
[null,null,"(ix) Pneumatic Roller (Bomag BW190 5-9tons or Similar Approved) (55kw)","hour",10,null,0]
[]
[null,null,"(x) Sheep Foot Compactor (20-25 ton) 100kw","hour",10,null,0]
[]
[null,null,"(xi) Waterpump "]
[null,null,"     (a) Capacity 20 liter/sec (small)","hour",10,null,{"$f":"F55*E55","v":0}]
[null,null,"     (b) Capacity 50liter/sec (medium)","hour",10,null,{"$f":"F56*E56","v":0}]
[null,null,"     (c) Capacity 100 liter/sec (large)","hour",10,null,0]
[]
[2.3,null,"Main Access Road to Works (construct and maintain)"]
[]
[null,null,"(i) Acess road to works","Sum",1,null,{"$f":"F61*E61","v":0}]
{"$rows_empty":14}
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G12:G75)","v":0}]
{"$rows_empty":7}
[null,null,"`"]

{"sheet":"3-SITE CLEARANCE","index":2,"n_rows":66,"n_cols":7,"rows_kept":66,"merged":[[0,0,0,1],[0,2,0,4],[1,0,1,1],[1,2,1,4],[2,0,2,1],[2,2,2,6],[65,0,65,5]]}
["CLIENT :",null,{"$f":"'1-P''s & G''s'!C1","v":"COUNCIL FOR GEOSECIENCE"}]
["TENDER No :",null,{"$f":"'1-P''s & G''s'!C2","v":"CGS-2024-022S"}]
["FOR :",null,{"$f":"'1-P''s & G''s'!C3:G3","v":"APPOINTMENT OF CONTRACTOR FOR THE IMPLEMENTATION OF INGRESS CONTROL MEASURES MODDERBEE CANAL PHASE 1"}]
[]
[null,null,"SECTION 3: SITE CLEARANCE"]
["ITEM ","PAYMENT","DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["NO","ITEM",null,null,"TITY",null,"R            C"]
[3,"SANS 1200 C","SECTION 3: SITE CLEARANCE"]
[]
[3.1,null,"SITE CLEARANCE"]
[]
["3.1.1","8.2.1","Clear and grub ","ha",{"v":4,"d":"4.0"},null,{"$f":"E12*F12","v":0}]
[]
["3.1.2","8.2.2","Remove and grub large trees and tree stumps of girth"]
[null,null,"a) Over 1m and up to and including 2m","No.",5,null,{"$f":"E15*F15","v":0}]
[]
[null,null,"b) Over 2m and up to and including 3m","No.",2,null,{"$f":"E17*F17","v":0}]
[]
[null,null,"c) Over 3m and up to and including 4m","No.",1,null,{"$f":"E19*F19","v":0}]
[]
["3.1.3","8.2.3","Remove and grub all trees and tree stumps regardless of girth ","ha",{"v":1,"d":"1.0"},null,{"$f":"E21*F21","v":0}]
[null,null,"(As instructed by the Engineer)"]
[]
["3.1.4","8.2.4","Reclear Surfaces (Only on instructions from the Engineer)","ha",0.5,null,{"$f":"E24*F24","v":0}]
[]
["3.1.5","8.2.8","Demolish and remove  structures/ building and dismantle steelwork, etc."]
[]
[null,null,"(a)'Demolishing of existing culvert bridge ","Sum",1,null,{"$f":"F28*E28","v":0}]
[]
[null,"PSC 3.1"]
["3.1.6","8.2.9","Transport materials and debris shall be disposed to suitable places specified by the Contractor (Prov)","m3.km",100,null,{"$f":"E31*F31","v":0}]
[]
["3.1.7","8.2.10","Remove topsoil to nominal depth of 150mm and stockpile","m3",1000,null,{"$f":"E33*F33","v":0}]
{"$rows_empty":32}
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G8:G65)","v":0}]

{"sheet":"4-EARTHWORKS","index":3,"n_rows":68,"n_cols":7,"rows_kept":68,"merged":[[0,0,0,1],[0,2,0,4],[1,0,1,1],[1,2,1,4],[2,0,2,1],[2,2,2,6],[59,0,59,5]]}
["CLIENT :",null,{"$f":"'1-P''s & G''s'!C1","v":"COUNCIL FOR GEOSECIENCE"}]
["TENDER No :",null,{"$f":"'1-P''s & G''s'!C2","v":"CGS-2024-022S"}]
["FOR :",null,{"$f":"'1-P''s & G''s'!C3:G3","v":"APPOINTMENT OF CONTRACTOR FOR THE IMPLEMENTATION OF INGRESS CONTROL MEASURES MODDERBEE CANAL PHASE 1"}]
[null,null,"SECTION 4: EARTH WORKS"]
["ITEM NO","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE ","AMOUNT"]
[null,"ITEM"]
[3,"SANS 1200D","SECTION 3: EARTHWORKS"]
[]
[null,null,"Notes:"]
[]
[null,null,"i) Preliminary Geotechnical investigations indicate that 70% of the first 2m depth of cut may be unsuitable for fill and will need to be spoiled. Hereafter 30% of material encountered may be unsuitable for fill and will need to be spoiled"]
[]
[null,null,"ii) The contractor is to provide a method statement to the engineer indicating how the contractor intends to select appropriate material for fill purposes without the contamination of unsuitable material"]
[]
[null,null,"Provisional Sum for stabilizing unstable slopes - This Provisional Sum may be omitted or changed at the request of the engineer. Should this item be ommitted or changed, it will have no bearing on the contract duration or compensation owed to the contractor"]
[]
[null,null,"Shoring:"]
[null,null,"Shoring of excavations will not be measured, and prices for\nthis operation shall be included in the excavation rates. The\nContractor must study the Geotechnical Report and make his\nown allowance in this regard. Shoring will only be measured\nif the Engineer requires this to be done to protect an existing\nstructure or service. Refer to the Project Specification in this\nregard."]
[]
[null,null,"Dewatering:"]
[null,null,"Dewatering of earthworks will not be measured seperately\nand shall be included in SANS 1200A reference 8.4.2.2.(h) in\nthe Preliminary and General bill"]
[]
[]
[3.1,null,"Excavate in all materials and spoil on-site at a site\nestablished by the Engineer from"]
[]
["3.1.1","8.3.3","(a) Canal","m³",4000,null,{"$f":"F26*E26","v":0}]
[]
[3.2,"8.3.7","Cut to spoil to stockpile to material to be cartaway :"]
[]
["3.2.1","8.3.2","Cut to spoil, including free haul up to 1.0km.Material obtained from excavation of the canal and culvert bridge","m³",1300,null,{"$f":"E30*F30","v":0}]
[]
[3.3,null,"Extra-over items inclusive for excavating and breaking down material in:"]
[]
["3.3.1","8.3.2","(a)Intermediate Material","m³",20,null,{"$f":"F34*E34","v":0}]
[]
["3.3.2","8.3.2","(b)Hard material","m³",5,null,{"$f":"F36*E36","v":0}]
[]
["3.3.3","8.3.2","(c)Boulder excavation ","m³",1,null,{"$f":"F38*E38","v":0}]
[]
[3.4,"8.3.6","Overhaul on material hauled in excess of 1.0km (ordinary overhaul) up to or through 1.0km (resticted overhaul)","m³",{"v":1300,"d":"1300.0"},null,{"$f":"F40*E40","v":0}]
[]
[3.5,"8.3.1.2","Select from stockpile on site and use as fill, compacted to 93% mod AASHTO density for","m³",2000,null,{"$f":"F42*E42","v":0}]
[]
[3.6,null,"COMMERCIAL MATERIAL"]
[]
[null,null,"Construct filling with material supplied by the Contractor from commercial sources of the following quality"]
[]
["3.6.1","8.3.4","(a) G5 material in Backfilling of canal including levelling","m³",2000,null,{"$f":"F48*E48","v":0}]
[]
[3.7,null,"Compaction of surfaces"]
[]
["3.7.1","8.3.3","Compaction of ground surface under floors etc including scarifying for a depth of 150mm, breaking down oversize material, adding suitable material where necessary and compacting to 93% Mod AASHTO density","m²",4000,null,{"$f":"F52*E52","v":0}]
{"$rows_empty":7}
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G8:G59)","v":0}]
{"$rows_empty":7}
[null,null,"`"]

{"sheet":"5-CULVERTS","index":4,"n_rows":142,"n_cols":7,"rows_kept":142,"merged":[[0,0,0,1],[0,2,0,4],[1,0,1,1],[1,2,1,4],[2,0,2,1],[2,2,2,6],[58,0,58,5],[59,0,59,5],[133,0,133,5]]}
["CLIENT :",null,{"$f":"'1-P''s & G''s'!C1","v":"COUNCIL FOR GEOSECIENCE"}]
["TENDER No :",null,{"$f":"'1-P''s & G''s'!C2","v":"CGS-2024-022S"}]
["FOR :",null,{"$f":"'1-P''s & G''s'!C3:G3","v":"APPOINTMENT OF CONTRACTOR FOR THE IMPLEMENTATION OF INGRESS CONTROL MEASURES MODDERBEE CANAL PHASE 1"}]
[null,null,"SECTION 5: CULVERT BRIDGE"]
["ITEM NO","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE ","AMOUNT"]
[null,"ITEM"]
[5,"SANS"]
[null,"1200 LE","SECTION 5: BOX CULVERT BRIDGE"]
[]
[null,null,"Material "]
[]
[null,null,"Culverts to comply with the applicable requirements of SANS 986 for the classes of deck and of invert shown on the drawings or scheduled, as applicable, and in addition culverts or culvert sections, as relevant, shall be capable of withstanding the appropreiate proof loads given in the SANS 986 applied on a line parallel to the longitudial axis without showing any signs of shear failure or incipient shear failure. "]
[]
[null,null,"EARTHWORKS"]
[5.1,null,"Excavation "]
[]
[null,null,"Exacavation in soft material  situated within the following depth and ranges below the surface level :"]
[]
["5.1.1","8.3.2","(a) 0m up to 1,5 m ","m³",40,null,{"$f":"F19*E19","v":0}]
[]
["5.1.3","8.3.2","Excatation in hard material ","m³",1,null,{"$f":"F21*E21","v":0}]
[]
[5.2,null,"COMMERCIAL MATERIAL"]
[]
[null,null,"Construct filling with material supplied by the Contractor from commercial sources of the following quality"]
[]
["5.2.1","8.3.4","(a) G5 material in Backfilling of canal including levelling","m³",500,null,{"$f":"F27*E27","v":0}]
[]
[5.3,null,"Portal and rectangular culverts: "]
[null,null,"With prefabricated floor slabs: "]
[]
["5.3.1","8.2.2","(i) 4500x3250x1220 Precast road application stormwater culvert and precast base configuration  (SANS 986.2006) ","m",56,null,{"$f":"F32*E32","v":0}]
[]
[5.4,null,"Compaction of surfaces"]
[]
["5.4.1","8.3.3","Compaction of ground surface under floors etc including scarifying for a depth of 150mm, breaking down oversize material, adding suitable material where necessary and compacting to 93% Mod AASHTO density","m²",130,null,{"$f":"F36*E36","v":0}]
[]
[5.5,"8.3.3","Extra over all excavations for carting away","m³",40,null,{"$f":"F38*E38","v":0}]
[]
["5.5.1","8.3.3","Surplus material from excavations  on site to a dumping site to be located by the contractor","m³",10,null,{"$f":"F40*E40","v":0}]
[]
["5.5.2","8.3.3","Extra Over for constructing inclined culverts","m³",10,null,{"$f":"F42*E42","v":0}]
[]
[5.6,null,"Cast in situ concrete and formwork:"]
[]
["5.6.1","8.4.2","(a)Blinding under causeaways and  portal culverts bridge Class 15/19 Mpa ","m³",15,null,{"$f":"F46*E46","v":0}]
[]
["5.6.2","8.4.3","(b)Class 30/19 Mpa concrete including formwork,joints and class U2 surface finish ","m³",25,null,{"$f":"F48*E48","v":0}]
[]
[null,null,"i) Storm water Causeway including approach slabs","m³",8,null,{"$f":"F50*E50","v":0}]
[]
[null,null,"ii) Portal Culvert Bridge","m³",25,null,{"$f":"F52*E52","v":0}]
[]
["5.6.3",null,"(c)Concrete backfill for culverts","m³",50,null,{"$f":"F54*E54","v":0}]
[]
[null,null,"i) Causeways, Class 15/19 MPa","m³",50,null,{"$f":"F56*E56","v":0}]
[]
[]
["Carried forward",{"$nulls":5},{"$f":"SUM(G7:G58)","v":0}]
["Brought  forward",{"$nulls":5},{"$f":"G59","v":0}]
[5.7,null,"Reinforcement "]
[]
["5.7.1","8.3.2","(a)Ref. 888 Steel MESH @ 50mm bottom cover ","m²",130,null,{"$f":"F63*E63","v":0}]
[]
[5.8,null,"Manholes, catchpits, inlet and outlet structures complete Catchpits, construction complete including 25Mpa concrete, Mesh Ref 395, Formwork, Brickwork, plastering, benching as shown on the drawings"]
[]
["5.8.1","8.4.3","(a) 1,0 m to 1,5 m deep stormwater inlets","No",2,null,{"$f":"F67*E67","v":0}]
[]
["5.8.2","8.4.3","(b) 1,0 m to 1,5 m deep stormwater outlets","No",2,null,{"$f":"F69*E69","v":0}]
[]
[5.9,"8.3.3","Hand Excavation to determine the positions of existing\nservice. Rate should include re-position of the services","m³",10,null,{"$f":"F71*E71","v":0}]
[]
[{"v":5.1,"d":"5.10"},"SANS 1200 G","Culvert Bridge Works"]
[]
["5.10.1",null,"SMOOTH FORMWORK"]
[]
[null,null,"Plane sloping"]
[]
["5.10.1.1","8.2.2","(a) Soffit of bridge deck","m²",130,null,{"$f":"F79*E79","v":0}]
[]
[null,null,"Smooth formwork to narrow widths"]
[]
["5.10.1.2","8.2.5","a) Edges, risers, etc not exceeding 300mm wide (Side of bridge deck)","m²",15,null,{"$f":"F83*E83","v":0}]
[]
["5.10.2",null,"REINFORCEMENT"]
[]
[null,null,"Steel bars"]
[]
[null,null,"Mild steel"]
[]
["5.10.2.1","8.3.1","a) All sizes","ton",1,null,{"$f":"F91*E91","v":0}]
[]
[null,null,"High tensile steel"]
[]
["5.10.2.2","8.3.1","b) All sizes","ton",1,null,{"$f":"F95*E95","v":0}]
[]
["5.10.3",null,"CONCRETE"]
[]
[null,null,"STRENGTH CONCRETE"]
[]
[null,"8.4.2","Strength concrete 15Mpa/19mm"]
[]
["5.10.3.1",null,"a) Blinding layer 75mm thick","m³",10,null,{"$f":"F103*E103","v":0}]
[]
["5.10.3.2",null,"b) Mass concrete filling over bridge footings","m³",25,null,{"$f":"F105*E105","v":0}]
[]
[null,"8.4.3","c) Strength concrete 35Mpa/19mm including \"Penetron\" waterproofing additive all in accordance with the Manufacturers specifications (or similar approved)"]
[]
["5.10.3.3",null,"i) Bridge deck","m³",25,null,{"$f":"F109*E109","v":0}]
[]
["5.10.4",null,"SURFACE FINISHING"]
[]
[null,"8.4.4","Unformed surface finishes"]
[]
[null,null,"a) Wood Float"]
[]
["5.10.4.1",null,"i) Bridge deck","m²",150,null,{"$f":"F117*E117","v":0}]
[]
["5.10.5",null,"EXPANSION JOINTS"]
[]
[null,8.5,"Joint former placed between concrete surfaces"]
[]
["5.10.5.1",null,"a) 5mm wide expansion joint","m²",20,null,{"$f":"F123*E123","v":0}]
[]
["5.10.5.2",null,"b) 20mm wide expansion joint","m²",20,null,{"$f":"F125*E125","v":0}]
{"$rows_empty":8}
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G60:G133)","v":0}]
{"$rows_empty":7}
[null,null,"`"]

{"sheet":"6-GABIONS","index":5,"n_rows":64,"n_cols":7,"rows_kept":64,"merged":[[0,0,0,1],[0,2,0,4],[1,0,1,1],[1,2,1,4],[2,0,2,1],[2,2,2,6],[55,0,55,5]]}
["CLIENT :",null,{"$f":"'1-P''s & G''s'!C1","v":"COUNCIL FOR GEOSECIENCE"}]
["TENDER No :",null,{"$f":"'1-P''s & G''s'!C2","v":"CGS-2024-022S"}]
["FOR :",null,{"$f":"'1-P''s & G''s'!C3:G3","v":"APPOINTMENT OF CONTRACTOR FOR THE IMPLEMENTATION OF INGRESS CONTROL MEASURES MODDERBEE CANAL PHASE 1"}]
[null,null,"SECTION 6: GABIONS "]
["ITEM NO","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE ","AMOUNT"]
[null,"ITEM"]
[6,"SANS"]
[null,"1200 DK","SECTION 6: GABIONS"]
[]
[null,null,"PREPARATION"]
[]
[6.1,"8.2.1","Surface preparation for bedding of gabions and mattresses"]
[]
["6.1.1",null,"(a) Mattress filled with approved rock","m³",20,null,{"$f":"F14*E14","v":0}]
[]
["6.1.2",null,"(b) Cavities filled with 15MPa/13mm concrete","m³",10,null,{"$f":"F16*E16","v":0}]
[]
[6.2,null,"GABIONS GABIONS AND MATTRESSES"]
[]
["6.2.1",null,"MATTRESSES "]
[]
[null,"8.2.2","Mattresses using Class Zinc Alloy Galvanized wire (Galfan) of the following sizes"]
[]
["6.2.1.1",null,"(a) Gabion boxes : 3000x1000x500 mm depth","m³",18,null,{"$f":"F24*E24","v":0}]
[]
[]
[6.3,"SANS 1200MM","GUARDRAILS"]
[]
["6.3.1",null,"STRAIGHT"]
[]
[null,"8.2.1","Supply and erect hot dip galvanized steel guardrails on Glavernised posts, including manufacturing, drilling and instaling on bridge concrete deck, spacer blocks, bolts, etc"]
[]
["6.3.1.1",null,"(a) Straight sections - Guardrail Barrier Sans1350, 3.81m In Length, Galvanised","m",30,null,{"$f":"F33*E33","v":0}]
[]
["6.3.2",null,"END UNITS"]
[]
[null,"8.2.3","Supply and fix hot dip galvanised steel end units complete"]
[]
["6.3.2.1",null,"(a) End wings Bullnose type - Guardrail Barrier Standard End Wing Sans1350, For 3.81m Guardrail Barrier, Galvanised","m",15,null,{"$f":"F39*E39","v":0}]
[]
[6.4,null,"GALVERNISED STEEL POSTS"]
[]
[null,"8.2.4","Supply and fix additional guardrail posts complete","No",24,null,{"$f":"E43*F43","v":0}]
[]
["6.4.1",null,"(a) Galvernised steel post including including manufacture, concrete drilling, achoring, spacer blocks, bolts, etc"]
[]
[6.5,null,"REFLECTOR PLATES"]
[]
[null,"8.2.5","Supply and fix reflector plates at each alternative post complete"]
[]
["6.5.1",null,"(a) Type D1 reflectors","No",4,null,{"$f":"F51*E51","v":0}]
[]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G7:G55)","v":0}]
{"$rows_empty":7}
[null,null,"`"]

{"sheet":"BILL SUMMARY","index":6,"n_rows":28,"n_cols":4,"rows_kept":28,"merged":[[0,0,0,1],[0,2,0,3],[1,0,1,1],[1,2,1,4],[2,0,2,1],[2,2,2,3],[3,0,3,3],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2]]}
["CLIENT :",null,{"$f":"'1-P''s & G''s'!C1:G1","v":"COUNCIL FOR GEOSECIENCE"}]
["TENDER No :",null,{"$f":"'1-P''s & G''s'!C2","v":"CGS-2024-022S"}]
["FOR :",null,{"$f":"'1-P''s & G''s'!C3:G3","v":"APPOINTMENT OF CONTRACTOR FOR THE IMPLEMENTATION OF INGRESS CONTROL MEASURES MODDERBEE CANAL PHASE 1"}]
["BILLS OF QUANTITIES: SUMMARY"]
["Item","DESCRIPTION",null,"TOTAL (Rands)"]
[]
[1,{"$f":"'1-P''s & G''s'!C7","v":"SECTION 1: PRELIMINARY AND GENERAL"},null,{"$f":"'1-P''s & G''s'!G185","v":{"v":220000,"d":"R220,000.00"}}]
[]
[2,{"$f":"'2-DAYWORKS'!C4","v":"SECTION 2: DAYWORKS "},null,{"$f":"'2-DAYWORKS'!G76","v":0}]
[]
[3,{"$f":"'3-SITE CLEARANCE'!C5","v":"SECTION 3: SITE CLEARANCE"},null,{"$f":"'3-SITE CLEARANCE'!G66","v":0}]
[]
[4,{"$f":"'4-EARTHWORKS'!C4","v":"SECTION 4: EARTH WORKS"},null,{"$f":"'4-EARTHWORKS'!G60","v":0}]
[]
[5,{"$f":"'5-CULVERTS'!C4","v":"SECTION 5: CULVERT BRIDGE"},null,{"$f":"'5-CULVERTS'!G134","v":0}]
[]
[6,{"$f":"'6-GABIONS'!C4","v":"SECTION 6: GABIONS "},null,{"$f":"'6-GABIONS'!G56","v":0}]
[]
[null,"SUB-TOTAL 1 (VAT EXCLUDED)",null,{"$f":"SUM(D7:D17)","v":{"v":220000,"d":"R220,000.00"}}]
[]
[null,"CONTINGENCIES AT 5% OF SUB-TOTAL 1  ABOVE"]
[null,"The amount reflected here will be utilised on the works should unforeseen conditions warrant it.  If not used, it will be deducted in whole or in part.",null,{"$f":"D19*5%","v":{"v":11000,"d":"R11,000.00"}}]
[]
[null,"CONSTRUCTION COST SUB-TOTAL 2  (INCL CONTIGENCIES) (VAT EXCLUDED)",null,{"$f":"+D22+D19","v":{"v":231000,"d":"R231,000.00"}}]
[]
[null,"ADD: VALUE ADDED TAX (15%)",null,{"$f":"0.15*D24","v":{"v":34650,"d":"R34,650.00"}}]
[]
[null,"CONSTRUCTION COST TOTAL (VAT INCL.)",null,{"$f":"D26+D24","v":{"v":265650,"d":"R265,650.00"}}]