{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["A-P&G","B-Excavation Bulk","C-Bulk Pipelines","D-Steel Tanks","E-Boreholes","F-Fence","Sum"],"not_rendered":{"images":2,"external_links":6,"defined_names":11},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"A-P&G","index":0,"n_rows":292,"n_cols":7,"rows_kept":292,"merged":[[0,0,0,4],[57,0,57,5],[59,3,59,6],[61,0,61,5],[120,0,120,5],[122,3,122,6],[124,0,124,5],[184,0,184,5],[186,3,186,6],[188,0,188,5],[235,0,235,5],[237,3,237,6],[239,0,239,5],[291,0,291,5]],"flags":["formulas_cached_only"]}
["SCHEDULE A: SANS 1200 A: PRELIMINARY AND GENERAL"]
["SEFENE, EISLEBEN, MATSEKE & RAMATSHOWE REGIONAL WATER SUPPLY - PHASE 1 - CONTRACT A"]
["ITEM No.","PAYM REF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,null,"SECTION A: SANS 1200 A: PRELIMINARY AND GENERAL"]
[]
["A1",8.3,"FIXED-CHARGE ITEMS"]
[]
[1.1,"8.3.1","Contractual Requirements"]
[]
["1.1.1",null,"a)  Provision of Surities","Sum",1,null,""]
[]
["1.1.2",null,"b)  Insurance of the Works and Plant","Sum",1,null,""]
[]
["1.1.3",null,"c)  Public Liability Insurance","Sum",1,null,""]
[]
["1.1.4",null,"d)  Special Risk Insurance","Sum",1,null,""]
[]
["A1.2","8.3.2","Establish Facilities on the Site :"]
[]
[null,"8.3.2.1","Facilities for Engineer"]
[]
["1.2.1","PS-8.1","a) 1 x Furnished Office","Sum",1,null,""]
[]
["1.2.2","PSAB 4.1","b) Telephone","Sum",1,null,""]
[]
["1.2.3",null,"c) Nameboards (4)","No",4,null,""]
[]
["1.2.4",null,"d) 1 x Rain Gauge","Sum",1,null,""]
[]
["1.2.5","PS-8.1","e) Survey assistant and instruments (1 set)","Sum",1,null,""]
[]
["1.2.6","PS-8","f) Portable Computer and accessories & Printer","P. Sum",1,{"v":40000,"d":"R 40,000.00"},{"v":40000,"d":"R 40,000.00"}]
[]
["1.2.7",null,"g) Overheads, charges and Profit on item 1.2.5","%",{"v":40000,"d":"40,000"},null,""]
[]
["1.2.8",null,"h) 1 x Conference room","Sum",1,null,""]
[]
["1.2.9",null,"i) Furnishings and equipment to Conference room","Sum",1,null,""]
[]
["1.2.10",null,"j) 2 x Parking facilities","Sum",1,null,""]
[]
["A1.3","8.3.2.2","Facilities for Contractor"]
[]
["1.3.1","PS-7.1","a) Offices and storage sheds","Sum",1,null,""]
[]
["1.3.2",null,"b) Work shops and stores","Sum",1,null,""]
[]
["1.3.3","PS-7.1","c) Laboratories","Sum",1,null,""]
[]
["1.3.4",null,"d) Living accommodation ","Sum",1,null,""]
[]
["1.3.5",null,"e) Ablution and latrine facilities ","Sum",1,null,""]
[]
["1.3.6",null,"f) Tools and equipment","Sum",1,null,""]
[]
["1.3.7",null,"g) Water supplies, electric power and communications","Sum",1,null,""]
[]
["TOTAL CARRIED FORWARD"]
[]
[{"$nulls":3},"SANS 1200 A: PRELIMINARY AND GENERAL"]
["ITEM No.","PAYM REF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TOTAL BROUGHT FORWARD"]
[]
["1.3.8",null,"h) Protection against water and storms","Sum",1,null,""]
[]
["1.3.9","PS-2","i) Access to the Works","Sum",1,null,""]
[]
["1.3.10",null,"j) Plant","Sum",1,null,""]
[]
["1.3.11","PSA 5.1.1","Setting out of the Works","Sum",1,null,""]
[]
["1.3.12",null,"Protection of survey pegs","Sum",1,null,""]
[]
["1.3.13","PSA 5.2","Dealing with water","Sum",1,null,""]
[]
[1.4,"8.3.3","Other fixed-charge obligations","Sum",1,null,""]
[]
[1.5,"8.3.4","Removal of Engineer's and Contractor's Site establishment on completion","Sum",1,null,""]
[]
[1.6,null,"Trial Panel","Sum",1,null,""]
[]
["A2",8.4,"SCHEDULED TIME-RELATED ITEMS"]
[]
[2.1,"8.4.1","Contractual Requirements"]
[]
["2.1.1",null,"a)  Provision of Surities","Sum",1,null,""]
[]
["2.1.2",null,"b)  Insurance of the Works and Plant","Sum",1,null,""]
[]
["2.1.3",null,"c)  Public Liability Insurance","Sum",1,null,""]
[]
["2.1.4",null,"d)  Special Risk Insurance","Sum",1,null,""]
[]
["A2.2","8.4.2","Operate and maintain facilities on the Site, for duration of costruction, except where otherwise stated"]
[]
["2.2.1","8.4.2.1","Facilities for the Engineer"]
[]
["2.2.1.1","PS-8.1","a) Furnished Office","Sum",1,null,""]
[]
["2.2.1.2",null,"b) Telephone/Cellphone & Internet Connectivity","Sum",1,null,""]
[]
["2.2.1.3",null,"c) Nameboards (1)","Sum",1,null,""]
[]
[null,null,"d) 1 x Rain Gauge","Sum",1,null,""]
[]
["2.2.1.4",null,"e) Survey assistant and instruments (1 set)","Sum",1,null,""]
[]
["2.2.1.5","PS-8","f) Portable Computer and accessories & Printer","Sum",1,null,""]
[]
["2.2.1.6",null,"g) 1 x Conference room","Sum",1,null,""]
[]
[null,null,"h) Furnishings and equipment to Conference room","Sum",1,null,""]
[]
[null,null,"f)  Office assistant to clean and maintain office","Sum",1,null,""]
[]
[]
[]
[]
[]
[]
["TOTAL CARRIED FORWARD"]
[]
[{"$nulls":3},"SANS 1200 A: PRELIMINARY AND GENERAL"]
["ITEM No.","PAYM REF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TOTAL BROUGHT FORWARD"]
[]
["2.2.2","8.4.2.2","Facilities for Contractor"]
[]
["2.2.2.1",null,"a) Offices and storage sheds","Sum",1,null,""]
[]
["2.2.2.2",null,"b) Work shops and stores","Sum",1,null,""]
[]
["2.2.2.3",null,"c) Laboratories","Sum",1,null,""]
[]
["2.2.2.4",null,"d) Living accommodation","Sum",1,null,""]
[]
["2.2.2.5",null,"e) Ablution and latrine facilities","Sum",1,null,""]
[]
["2.2.2.6",null,"f) Tools and equipment","Sum",1,null,""]
[]
["2.2.2.7",null,"g) Water supplies, electric power and communications","Sum",1,null,""]
[]
["2.2.2.8",null,"h) Protection against water and storms","Sum",1,null,""]
[]
["2.2.2.9",null,"i) Access to the Works","Sum",1,null,""]
[]
["2.2.2.10",null,"j) Plant","Sum",1,null,""]
[]
["2.2.2.11",null,"Setting out of the Works","Sum",1,null,""]
[]
["2.2.2.12",null,"Protection of survey pegs","Sum",1,null,""]
[]
["2.2.2.13","PSA 3.2","Workmen's Compensation Act","Sum",1,null,""]
[]
["2.2.2.13",null,"Dealing with water","Sum",1,null,""]
[]
[2.3,"8.4.3","Supervision for the duration of Construction","Sum",1,null,""]
[]
[2.4,"8.4.4","Company and Head office overhead costs for the duration of the Contract","Sum",1,null,""]
[]
[2.5,"8.4.5","Other time-related obligations","Sum",1,null,""]
[]
["A3",null,"SUMS STATED PROVISIONALLY BY ENGINEER"]
[]
[3.1,null,"a) Additional tests"]
["3.1.1",null," (i) Additional tests ordered by the Engineer","Prov Sum",1,{"v":100000,"d":"R 100,000.00"},{"v":100000,"d":"R 100,000.00"}]
[]
["3.1.2",null," (ii) Percentage charges and profit on (i) above","%",{"v":100000,"d":"100,000.00"},null,""]
[]
["3.1.3",null,"b) Engineer's Personnel"]
[]
["3.1.4",null," (i) Accommodation for the full duration of the project","Prov Sum",1,{"v":170000,"d":"R 170,000.00"},{"v":170000,"d":"R 170,000.00"}]
[]
[null,null," (ii) Percentage charges and profit on (i) ","%",{"v":170000,"d":"170000.00"},null,""]
{"$rows_empty":10}
["TOTAL CARRIED FORWARD"]
[]
[{"$nulls":3},"SANS 1200 A: PRELIMINARY AND GENERAL"]
["ITEM No.","PAYM REF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TOTAL BROUGHT FORWARD"]
[]
[3.2,null,"b) Community Liaison Officer (CLO) and members of the Project Liaison Committee (PLC)"]
["3.2.1",null," (i) Remuneration (CLO)","Prov Sum",1,{"v":72000,"d":"R 72,000.00"},{"v":72000,"d":"R 72,000.00"}]
[]
["3.2.2",null," (ii) Remuneration (PLC)","Prov Sum",1,{"v":45000,"d":"R 45,000.00"},{"v":45000,"d":"R 45,000.00"}]
[]
["3.2.3",null," (iii) Overheads, handling charges and profit on (i) and (ii) above","%",{"v":117000,"d":"117,000.00"},null,""]
[]
[3.4,null,"c) Skills Training:"]
["3.4.1",null," (i) Technical skills, Generic and Management Skills","Prov Sum",1,{"v":200000,"d":"R 200,000.00"},{"v":200000,"d":"R 200,000.00"}]
[]
["3.4.2",null," (ii) Overheads, handling charges and profit on (i), (ii), (iii) and (iv) above","%",{"v":200000,"d":"200,000.00"},null,""]
[]
[3.5,"OHS Spec","c) Compliance with the Occupational Health and Safety Act as specified","Sum",1,null,""]
[]
["3.5.1",null,"i) Full time (three shifts per day, two persons per shift) high level security by an approved local bona fide security firm for the duration of the contract. Need not be armed. Note: this is not for the contractor's camp.","Sum",1,null,""]
[]
["3.5.2",null,"ii) Barricading and fencing of the works by a subcontractor. According to the contractor's own work program.","Sum",1,null,""]
[]
[3.6,"EMP Spec","d) Compliance with the Environmental Management Plan as specified","Sum",1,null,""]
[]
[3.7,"HIV/ADS Spec","e) Compliance with the HIV / AIDS Awareness Specification as specified","Sum",1,null,""]
[]
[3.8,"PSA 8.4.6","f) Liaison with Authorities, opportunities to, and Co-operation with Others on Site"]
[]
["3.8.1",null," (i) Mechanical Contractor","Sum",1,null,""]
[]
["3.8.2",null," (ii) Electrical Contractor","Sum",1,null,""]
{"$rows_empty":18}
["TOTAL CARRIED FORWARD"]
[]
[{"$nulls":3},"SANS 1200 A: PRELIMINARY AND GENERAL"]
["ITEM No.","PAYM REF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TOTAL BROUGHT FORWARD"]
[]
["A4",8.7,"DAYWORKS"]
[]
[4.1,null,"Labour"]
[]
["4.1.1",null,"(a) Contractor's Site Agent"]
[]
["4.1.2",null,"(b) artisans","h",65,null,""]
[]
["4.1.3",null,"(c) skilled labourers","h",65,null,""]
[]
["4.1.4",null,"(d) semi-skilled labourers     ","h",65,null,""]
[]
["4.1.5",null,"(de un-skilled labourers","h",300,null,""]
[]
[4.2,null,"Plant intended for use on contract"]
[]
["4.2.1",null,"(a) Excavator type .................................","h",25,null,""]
[]
["4.2.2",null,"(b) Loader type ......................................","h",25,null,""]
[]
["4.2.3",null,"(c) Tip truck type ...................................","h",25,null,""]
[]
["4.2.4",null,"(d) Pedestrian type 900 - 1000 roller ...............................","h",25,null,""]
[]
["4.2.5",null,"(e) Other plant type ..............................","h",25,null,""]
[]
["4.2.6",null,"(f) Welding plant (size) ....……….............","h",25,null,""]
[]
["4.2.7",null,"(g) Compressor ....………………..............","h",25,null,""]
[]
["4.2.8",null,"(h) Crane ....................……………..........","h",25,null,""]
[]
["4.2.9",null,"(i) Hand held equipment type ..............…...............","h",25,null,""]
[]
[4.3,null,"Materials","Prov Sum",1,{"v":25000,"d":"R 25,000.00"},{"v":25000,"d":"R 25,000.00"}]
[]
[4.4,null,"Overheads, charges and profit on item No 1.13.10.  (Tenderer to state  percentage)","%",{"v":25000,"d":"25,000"},null,""]
[]
["A5",8.8,"TEMPORARY WORKS"]
[]
[5.1,"8.8.2","Accommodation of traffic. The Sum tendered shall include full compensation for dealing with traffic over the full duration of the project period inclusive of all required temporary road signage anf flagmen.","Sum",1,null,""]
[]
[5.2,"8.8.4","Existing Services"]
[]
["5.2.1",null,"c) Hand excavation necessary for locating and exposing existing services in all materials: (IRRESPECTIVE OF THE TYPE OF SERVICE)","m³",250,null,""]
[]
[]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY (SANS 1200 A)"]

{"sheet":"B-Excavation Bulk","index":1,"n_rows":79,"n_cols":7,"rows_kept":79,"merged":[[39,0,39,5],[40,0,40,5],[78,2,78,5]],"flags":["formulas_cached_only"]}
["SCHEDULE B: EARTHWORKS FOR PIPES"]
["SEFENE, EISLEBEN, MATSEKE & RAMATSHOWE REGIONAL WATER SUPPLY - PHASE 1 - CONTRACT A"]
["ITEM NO","PAYM REF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["B.1",null,"SECTION B: BULK PIPELINES: TRENCH EXCAVATION AND EARTHWORKS"]
[null,null,"(As specified in SABS 1200 DB and the Project Specifications.)"]
[]
[1.1,null,"Site Clearance:"]
["1.1.1","8.3.1 a","Clear vegetation, 800 mm wide. (Provisional)","m",23565,null,""]
["1.1.2","8.3.1 b","Clear trees of girth over 1.0 m.","No.",50,null,""]
["1.1.3","8.3.1 c","Remove 150 mm topsoil, 800 mm wide.","m3",{"v":2827.7999999999997,"d":"2828"},null,""]
["1.1.4",null,"Demolish existing concrete.","m3","Rate Only",null,"Rate Only"]
["1.1.5",null,"Clear and shape roads and side drains.","m3","Rate Only",null,"Rate Only"]
["1.1.6",null,"Shape to grade for trench excavation.","m3","Rate Only",null,"Rate Only"]
[{"$nulls":6},""]
[1.2,"PSDB 4.1","Excavation using Plant:",{"$nulls":3},""]
["1.2.1",null,"Excavate in all materials for trench depths up to 1000 mm, 800 mm wide.","m",23565,null,""]
["1.2.2",null,"Excavate in all materials for trench depths exceeding 1000 mm up to 1500 mm, 800 mm wide.","m",{"v":7069.5,"d":"7070"},null,""]
["1.2.3",null,"Excavate in all materials for trench depths exceeding 1500 mm up to 2000 mm, 800 mm wide.","m","Rate Only",null,"Rate Only"]
["1.2.4",null,"Extra-over items 1.2.1, 1.2.2 and 1.2.3 for excavation in intermediate material.","m3",{"v":5885.599999999999,"d":"5886"},null,""]
["1.2.5",null,"Extra-over items 1.2.1, 1.2.2 and 1.2.3 for excavation in hard material. (Provisional)","m3",{"v":4147.4400000000005,"d":"4147"},null,""]
["1.2.6",null,"Excavate and dispose of unsuitable material from trench bottom.","m3",{"v":1413.9,"d":"1414"},null,""]
["1.2.7",null,"Spoil unsuitable backfill material.","m3",{"v":706.95,"d":"707"},null,""]
[{"$nulls":6},""]
[1.3,"PSDB 2","Excavation using Labour Intensive Methods:",{"$nulls":3},""]
["1.3.1",null,"Extra-over Item 1.2.1 for excavation in soft material using labour intensive methods.","m",{"v":1178.25,"d":"1178"},null,""]
["1.3.2",null,"Extra-over Item 1.2.2 for excavation in soft material using labour intensive methods.","m",{"v":7069.5,"d":"7070"},null,""]
["1.3.3",null,"Extra-over Item 1.2.3 for excavation in soft material using labour intensive methods.","m","Rate Only",null,"Rate Only"]
["1.3.4",null,"Extra-over Item 1.2.4 for excavation in intermediate material using labour intensive methods.","m3",{"v":1177.12,"d":"1177"},null,""]
["1.3.5",null,"Extra-over Item 1.2.6 for excavate and dispose of unsuitable materisl using labour intensive methods.","m3","Rate Only",null,"Rate Only"]
[]
[1.4,null,"BEDDING:"]
[null,null,"(As specified in SABS 1200 LB and the Project Specifications.)"]
[]
[null,"8.2.1","Bedding from Trench Excavations:"]
[null,null,"(Bedding to be Class C for flexible pipes as indicated in the contract drawings)",{"$nulls":3},""]
["1.4.1",null,"Provision of bedding from pipe trench excavation within 1.0 km, using selected granular material.","m3",{"v":2827.8,"d":"2828"},null,""]
["1.4.2",null,"Provision of bedding from pipe trench excavation within 1.0 km, using selected fill material.","m3",{"v":706.95,"d":"707"},null,""]
[]
["SUB-TOTAL SCHEDULE B - SECTION 1 CARRIED FORWARD:"]
["SUB-TOTAL SCHEDULE B - SECTION 1 BROUGHT FORWARD:"]
[1.5,"8.2.2","Imported Bedding Material:"]
[null,null,"(Bedding to be Class C for flexible pipes as indicated in the contract drawings)"]
["1.5.1",null,"Provision of bedding imported from designated borrow pit using selected granular material.","m3",{"v":1131.1200000000001,"d":"1131"},null,""]
["1.5.2",null,"Provision of bedding imported from designated borrow pit using selected fill material.","m3",{"v":424.17,"d":"424"},null,""]
[]
[1.6,"8.2.5","Overhaul:"]
["1.6.1",null,"Overhaul of material for bedding from trench excavations. Free-haul distance is 1.0 km.","Rate Only","Rate Only",null,"Rate Only"]
["1.6.2",null,"Overhaul of material for bedding from designated borrow pit. Free-haul distance is 5.0 km.","m3-km",{"v":15552.900000000001,"d":"15553"},null,""]
[]
[1.7,"PSDB 5.6","Backfill and Compaction:"]
["1.7.1",null,"Backfill and compact trenches using labour intensive methods.","m3",{"v":19794.600000000002,"d":"19795"},null,""]
[null,null,"Backfill road crosings using a commercial type G4 material compacted to 98% Mod. AASHTO density.","m3",{"v":1385.6220000000003,"d":"1386"},null,""]
["1.7.2",null,"Dispose of surplus excavated material.","m3","Rate Only",null,"Rate Only"]
[{"$nulls":6},""]
[1.8,null,"Excavation Ancillaries;",{"$nulls":3},""]
["1.8.1","8.3.3.1 a","Make up deficiency in backfill material  from other excavations.","m3",{"v":1979.4600000000003,"d":"1979"},null,""]
["1.8.2","8.3.3.1 b","Make up deficiency in backfill material  from borrow pits. Free-haul is 5.0 km.","m3","Rate Only",null,"Rate Only"]
["1.8.4",null,"Pipe protection installed at 300 mm below top of finished backfill level using 3 strips of danger tape. ","m","Rate Only",null,"Rate Only"]
["1.8.5","8.3.3.2","Opening and closing designated borrow pits.","Pov. Sum",1,{"v":20000,"d":"R 20,000.00"},{"v":20000,"d":"R 20,000.00"}]
["1.8.6","8.3.3.3","Compaction within road reserve to 90 % of Modified AASHTO density clause 5.7.1.","m3",{"v":277.1244000000001,"d":"277"},null,""]
["1.8.7","8.3.3.3","Compaction within road reserve to 98 % of Modified AASHTO density, as per clause 5.7.2.","m3",{"v":395.89200000000005,"d":"396"},null,""]
[{"$nulls":6},""]
[1.9,null,"Overhaul:",{"$nulls":3},""]
["1.9.1","8.3.3.4","Overhaul in excess of the free-haul of 5.0 km.","m3-km",{"v":31176.495000000006,"d":"31176"},null,""]
[]
[{"v":1.1,"d":"1.10"},null,"Existing Services:"]
["1.10.1","8.3.5 a","Services that intersect a trench.","No.",30,null,""]
[{"$nulls":6},""]
[1.11,null,"Finishing:",{"$nulls":3},""]
["1.11.1","8.3.6.1 c","Reinstate road surfaces using 40 mm asphalt.","m2",100,null,""]
["1.11.2",null,"Topsoil trenches. (Provisional)","m2",47130,null,""]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL SECTION 1 CARRIED TO SUMMARY"]

{"sheet":"C-Bulk Pipelines","index":2,"n_rows":134,"n_cols":7,"rows_kept":134,"merged":[[0,0,0,2],[46,0,46,5],[47,0,47,5],[91,0,91,5],[92,0,92,5],[133,0,133,5]],"flags":["formulas_cached_only"]}
["SCHEDULE D: BULK SUPPLY AND DISTRIBUTION"]
["SEFENE, EISLEBEN, MATSEKE & RAMATSHOWE REGIONAL WATER SUPPLY - PHASE 1 - CONTRACT A"]
["ITEM NO","PAYM REF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["C.1",null,"SECTION D: BULKLINE-MEDIUM PRESSURE PIPES"]
[null,null,"(As specified in SABS 1200 L, SABS 1200 GA and the Project Specifications.)"]
[]
["C.1.1","8.2.1","Supply, Lay and Bed uPVC Pipes Complete:"]
[null,null,"(The rates shall include disinfecting of pipes after completion of hydraulic pipe test.)"]
[]
[null,null,"Boreholes Rising Mains"]
["1.1.1",null,"90 mm uPVC medium pressure pipes - Class 12","m",400,null,""]
["1.1.2",null,"110 mm uPVC medium pressure pipes - Class 12","m",15725,null,""]
["1.1.3",null,"160 mm uPVC medium pressure pipes - Class 12","m",910,null,""]
["1.1.4",null,"200 mm uPVC medium pressure pipes - Class 12","m",280,null,""]
["1.1.5",null,"250 mm uPVC medium pressure pipes - Class 12","m",5850,null,""]
[]
[null,null,"Gravity Outlet Main"]
["1.1.6",null,"315 mm uPVC medium pressure pipes - Class 9","m",200]
["1.1.7",null,"400 mm uPVC medium pressure pipes - Class 9","m",200]
[]
["D.1.2","8.2.2","Fittings and Specials - uPVC Lyng Bends:",{"$nulls":3},""]
[null,null,"(Extra-over rate to Items 3.1.1 to 3.1.6.)",{"$nulls":3},""]
["1.2.1",null,"90 mm uPVC:",{"$nulls":3},""]
["1.2.1.1",null,"uPVC bends less than 25 degree angle.","No.",5,null,""]
["1.2.1.2",null,"uPVC bends with 45 degree angle.","No.",5,null,""]
["1.2.1.3",null,"uPVC bends with 90 degree angle.","No.",10,null,""]
["1.2.2",null,"110 mm uPVC:",{"$nulls":3},""]
["1.2.2.1",null,"uPVC bends less than 25 degree angle.","No.",3,null,""]
["1.2.2.2",null,"uPVC bends with 45 degree angle.","No.",2,null,""]
["1.2.2.3",null,"uPVC bends with 90 degree angle.","No.",6,null,""]
["1.2.3",null,"160 mm uPVC:",{"$nulls":3},""]
["1.2.3.1",null,"uPVC bends less than 25 degree angle.","No.",5,null,""]
["1.2.3.2",null,"uPVC bends with 45 degree angle.","No.",5,null,""]
["1.2.3.3",null,"uPVC bends with 90 degree angle.","No.",5,null,""]
["1.2.4",null,"200 mm uPVC:"]
["1.2.4.1",null,"uPVC bends less than 25 degree angle.","No.",2,null,""]
["1.2.4.2",null,"uPVC bends with 45 degree angle.","No.",2,null,""]
["1.2.4.3",null,"uPVC bends with 90 degree angle.","No.",3,null,""]
["1.2.5",null,"250 mm uPVC:",{"$nulls":3},""]
["1.2.5.1",null,"uPVC bends less than 25 degree angle.","No.",4,null,""]
["1.2.5.2",null,"uPVC bends with 45 degree angle.","No.",3,null,""]
["1.2.5.3",null,"uPVC bends with 90 degree angle.","No.",3,null,""]
[]
[2.1,"8.2.2","Specials and Fittings - Cast Iron Special Tees:",{"$nulls":3},""]
[null,null,"(Bitumen dipped and LYNG sockets on all sides all to SABS 546 and SABS 966.)",{"$nulls":3},""]
["SUB-TOTAL SCHEDULE C - SECTION 2 CARRIED FORWARD:"]
["SUB-TOTAL SCHEDULE C - SECTION 2 BROUGHT FORWARD:"]
["2.1.1",null,"110 mm dia.","No.",2,null,""]
["2.1.2",null,"160 mm dia.","No.",4,null,""]
["2.1.3",null,"200 mm dia.","No.",4,null,""]
[]
[2.2,"8.2.2","Specials and Fittings - Hydrant Tees:",{"$nulls":3},""]
[null,null,"(Cast iron hydrant tees, Bitumen dipped and LYNG sockets to SABS 546 and SABS 966 with flanged branch, 50 mm dia, drilled to SABS 1123, Table 16.)",{"$nulls":3},""]
["2.2.1",null,"110 mm dia.","No.","Rate Only",null,"Rate Only"]
["2.2.2",null,"160 mm dia.","No.",2,null,""]
[]
[2.3,"8.2.2","Specials and Fittings - Cast Iron Scour Tees:",{"$nulls":3},""]
[null,null,"(Cast iron scour tee, Bitumen dipped and LYNG sockets to SABS 546 and SABS 966 with flanged branch, 100 mm dia, drilled to SABS 1123, Table 16.)",{"$nulls":3},""]
["2.3.1",null,"110 mm dia.","No.",3,null,""]
["2.3.2",null,"140 mm dia.","No.",2,null,""]
["2.3.3",null,"160 mm dia.","No.",2,null,""]
["2.3.4",null,"200 mm dia.","No.",2,null,""]
["2.3.5",null,"250 mm dia.","No.",2,null,""]
["2.3.6",null,"315 mm dia.","No.",3,null,""]
[]
[2.4,"8.2.2","Specials and Fittings - Cast Iron End Caps:",{"$nulls":3},""]
["2.4.1",null,"63 mm dia.","No.",5,null,""]
["2.4.2",null,"75 mm dia.","No.",15,null,""]
["2.4.3",null,"110 mm dia.","No.","Rate Only",null,"Rate Only"]
["2.4.4",null,"140 mm dia.","No.",2,null,""]
["2.4.5",null,"160 mm dia.","No.",2,null,""]
["2.4.6",null,"250 mm dia.","No.",1,null,""]
[]
[2.5,"8.2.2","Specials and Fittings - Cast Iron Reducers:",{"$nulls":3},""]
[null,null,"(Bitumen dipped, spigot and socket and socketed cast iron reducers all to SABS 546 and SABS 966.)",{"$nulls":3},""]
["2.5.1",null,"63 mm x 90 mm dia. [S]","No.","Rate Only",null,"Rate Only"]
["2.5.2",null,"90 mm x 110 mm dia. [S]","No.","Rate Only",null,"Rate Only"]
["2.5.3",null,"110 mm x 63 mm dia. [S]","No.","Rate Only",null,"Rate Only"]
["2.5.4",null,"160 mm x 75 mm dia. [S]","No.","Rate Only",null,"Rate Only"]
["2.5.5",null,"200 mm x 75 mm dia. [S]","No.","Rate Only",null,"Rate Only"]
[]
[2.6,"8.2.3","Specials and Fittings - Isolating Valves:",{"$nulls":3},""]
[null,null,"(Flanged RSV isolating valves. Valves to be non-rising spindles with cap top.)",{"$nulls":3},""]
["2.6.1",null,"110 mm dia. Class 16","No.",6,null,""]
["2.6.2",null,"140 mm dia. Class 16","No.",4,null,""]
["2.6.3",null,"160 mm dia. Class 16","No.",2,null,""]
["2.6.4",null,"200 mm dia. Class 16","No.",{"v":6.586666666666667,"d":"7"},null,""]
["2.6.5",null,"250 mm dia. Class 16","No.",{"v":4.4,"d":"4"},null,""]
["2.6.6",null,"315 mm dia. Class 16","No.",{"v":4.875,"d":"5"},null,""]
["2.6.7",null,"400 mm dia. Class 16","No.",2,null,""]
["SUB-TOTAL SCHEDULE C - SECTION 2 CARRIED FORWARD:"]
["SUB-TOTAL SCHEDULE C - SECTION 2 BROUGHT FORWARD:"]
[]
[2.7,"8.2.3","Specials and Fittings - Air Valve:",{"$nulls":3},""]
[null,null,"(Vent O' Mat SERIES RBX  with screwed BSP male inlet, or similar. Complete with flange, barrel nipple, and 50 mm gate valve)",{"$nulls":3},""]
[]
["2.7.1",null,"50 mm Air Valve ","No.",34,null,""]
[]
[2.8,"8.2.3","Specials and Fittings - Bulk Water Meter:",{"$nulls":3},""]
[null,null,"(Kent or similar approved, flanged and drilled to SABS 1123, Table 16)",{"$nulls":3},""]
["2.8.1",null,"110 mm dia.  In-Line Bulk Water Meter.","No.",13,null,""]
["2.8.2",null,"160 mm dia.  In-Line Bulk Water Meter.","No.",1,null,""]
["2.8.3",null,"200 mm dia.  In-Line Bulk Water Meter.","No.",1,null,""]
["2.8.4",null,"250 mm dia.  In-Line Bulk Water Meter.","No.",4,null,""]
[]
[2.9,"8.2.13","Valve Chambers:",{"$nulls":3},""]
["2.9.1",null,"Valve chamber -  complete including excavation, materials, plant, labour and incidentals, as per detail drawings (Drawing no: EKS-001-006-006-T-00)","No.",{"v":82.86166666666666,"d":"83"},null,""]
["2.9.2",null,"Extra-over Item 3.15.1 for depth increments of 250 mm.","No.","Rate Only",null,"Rate Only"]
[]
[{"v":2.1,"d":"2.10"},null,"Thrust Blocks:",{"$nulls":3},""]
["2.10.1",null,"Excavation.","m3",350,null,""]
["2.10.2",null,"Formwork.","m2",600,null,""]
["2.10.3",null,"Concrete. [Class 20/19 MPa]","m3",250,null,""]
[]
[2.11,null,"Supply and Install Pipe Markers as per Detail Drawing (Drawing no: EKS-001-006-005-T-00)","No.",{"v":96.33,"d":"96"},null,""]
[]
[2.12,null,"Scour Valve"]
["2.12.1",null,"Scour Valve complete, excluding specials and fittings, including all labour, plant, materials and incidentals, as per detail drawings. (Refer to Drawing No. EKS-001-006-011-T-00) ","No.",4,null,""]
[]
[2.13,null,"Main Roads Crossings using pipe jacking method","Prov. Sum",1,{"v":90000,"d":"R 90,000.00"},{"v":90000,"d":"R 90,000.00"}]
[]
["2.13.1",null,"Overheads, charges and profit on item 2.23","%",{"v":90000,"d":"90,000"},null,""]
{"$rows_empty":10}
["TOTAL SECTION 2 CARRIED TO SUMMARY"]

{"sheet":"D-Steel Tanks","index":3,"n_rows":42,"n_cols":7,"rows_kept":42,"merged":[[41,2,41,5]],"flags":["formulas_cached_only"]}
["SCHEDULE D: STEEL TANKS",{"$nulls":5},"SECTION 1"]
["SEFENE, EISLEBEN, MATSEKE & RAMATSHOWE REGIONAL WATER SUPPLY - PHASE 1 - CONTRACT A"]
["ITEM NO","Payment Clause","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["D.1",null,"SECTION D - STEEL TANKS:"]
[null,null,"(As specified in the Project Specifications.)"]
[]
[1.1,"PSH 4.1","Pressed Steel Tank-Sump: (Raw Water Storage Positioned at package plant)"]
[]
[null,null,"(Reservoir shall be a \"Braithwaite\" type pressed steel water storage tank, or similar Approved. All manufacturing to SABS standards with hot dip galvaising to SANS 121(ISO 1461), installation to be performed by the supplier)"]
[]
["1.1.1",null,"Supply and erect 1000KL capacity pressed steel tank on ground beams 0.6m above natural ground level including fittings. complete as per detailed DWG No: EKS-001-006-013-T-00","Prov. Sum",1,{"v":3934741.0999999996,"d":"R 3,934,741.10"},{"v":3934741.0999999996,"d":"R 3,934,741.10"}]
[]
["1.1.2",null,"Overheads, charges and profit on item 4.4.1","%",{"v":3934741.0999999996,"d":"3,934,741"},null,""]
[]
["1.1.3",null,"Extra over item 1.3.1 for construction of the foundation, including all earthworks, material, etc. complete as per detailed DWG No: EKS-001-006-014-T-00","No.",1,null,""]
{"$rows_empty":25}
[null,null,"TOTAL SECTION 1 CARRIED TO SUMMARY"]

{"sheet":"E-Boreholes","index":4,"n_rows":100,"n_cols":7,"rows_kept":100,"merged":[[0,0,0,2],[41,0,41,5],[42,0,42,5],[61,0,61,5],[62,0,62,5],[99,2,99,5]],"flags":["formulas_cached_only"]}
["SCHEDULE E: BOREHOLES"]
["SEFENE, EISLEBEN, MATSEKE & RAMATSHOWE REGIONAL WATER SUPPLY - PHASE 1 - CONTRACT A"]
["ITEM NO","Payment Clause","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["E",null,"ANCILLARY WORKS"]
[null,null,"(As specified in the Project Specifications.)"]
[1,null,"Site Clearance:"]
[1.1,null,"Clear vegetation, (Provisional)","m2",550,null,""]
[1.2,null,"Clear trees of girth over 1.0 m.","No",10,null,""]
[1.3,null,"Remove 150 mm topsoil, 800 mm wide.","m3",100,null,""]
[1.4,null,"Access Gravel road wearing course compacted to 93% of modified AASHTO density (150mm compacted layer thickness) to all boreholes","Prov. Sum",1,{"v":550000,"d":"R 550,000.00"},{"v":550000,"d":"R 550,000.00"}]
[1.5,null,"Overheads, charges and profit on item 1.5","%",{"v":550000,"d":"550,000"},null,""]
[]
[2,null,"Foundation Preparation:"]
[]
[2.1,null,"(a) Excavating soft material situated within the following successive depth ranges:"]
[null,null,"      i) 0 m up to 2 m","m3",60,null,""]
[]
[2.2,null,"b) Extra-over subitem 5.1.1 (a) for excavating in hard material irrespective of depth","m3",25,null,""]
[]
[3,null,"Backfill to excavation utilising"]
[]
[3.1,null,"a) Material from excavation","m3",53.99999999999999,null,""]
[]
[3.2,null,"b) Imported material","m3",45,null,""]
[]
[4,null,"Overhaul in excess of 1,0 km on excavated material and on material imported for backfill, foundation fill","m³-km",396,null,""]
[]
[5,null,"Foundation fill consisting of:"]
[]
[5.1,null,"a) Compacted granular material","m3",48,null,""]
[5.2,null,"b) Concrete screed, 75 mm thick, class 15/19 concrete","m3",25,null,""]
[]
[6,"PSGA5","Concrete Pumphouse:"]
[]
[6.1,null,"Supply and Installation of High Security Concrete Lid for Maintenance Access and Pumps installations, etc","No",6,null,""]
[]
[6.2,null,"Construction of borehole concrete floor 3000 x 3000 x 150mm min, depth above ground level complete as per detailed DWG No: EKS-001-006-009-T-00","No.",6,null,""]
[]
[6.3,null,"Supply and Install High Security Sliding Concrete Platform Door as per DWG No: EKS-001-006-010-T-00","No.",6,null,""]
[]
["SUB-TOTAL SCHEDULE E - SECTION 1 CARRIED FORWARD:"]
["SUB-TOTAL SCHEDULE E - SECTION 2 BROUGHT FORWARD:"]
[7,"PSPME5.2","Borehole Equipping:"]
[null,null,"(All works shall comply to SABS specifications Compliance certificates shall be provided to the Engineer)"]
[]
[7.1,null,"Borehole No: H16-2847 - Supply and install new positive displacement mono pump/similar approved by the engineer including all pipes fittings for delivery pipe up to 315mm diameter (the pump must be able to discharge 13.1 (l/s) for pumping yield for 24 hrs over 6km at head of 120m) complete.","Prov. Sum",1,{"v":347500,"d":"R 347,500.00"},{"v":347500,"d":"R 347,500.00"}]
["7.1.1",null,"Overheads, charges and profit on item 7.1","%",{"v":347500,"d":"347,500"},null,""]
[]
[7.2,null,"Borehole No: H16-2851 - Supply and install new positive displacement mono pump/similar approved by the engineer including all pipes fittings for delivery pipe up to 315mm diameter (the pump must be able to discharge 25.87 (l/s) for pumping yield for 24 hrs over 6km at head of 120m) complete.","Prov. Sum",1,{"v":382600,"d":"R 382,600.00"},{"v":382600,"d":"R 382,600.00"}]
["7.2.1",null,"Overheads, charges and profit on item 7.2","%",{"v":382600,"d":"382,600"},null,""]
[]
[7.3,null,"Borehole No: H16-2853 - Supply and install new positive displacement mono pump/similar approved by the engineer including all pipes fittings for delivery pipe up to 315mm diameter (the pump must be able to discharge 28 (l/s) for pumping yield for 24 hrs over 6km at head of 120m) complete.","Prov. Sum",1,{"v":432000,"d":"R 432,000.00"},{"v":432000,"d":"R 432,000.00"}]
["7.3.1",null,"Overheads, charges and profit on item 7.3","%",{"v":432000,"d":"432,000"},null,""]
[]
[7.4,null,"Borehole No: H16-2855 - Supply and install new positive displacement mono pump/similar approved by the engineer including all pipes fittings for delivery pipe up to 315mm diameter (the pump must be able to discharge 6 (l/s) for pumping yield for 24 hrs over 6km at head of 120m) complete.","Prov. Sum",1,{"v":356000,"d":"R 356,000.00"}]
["7.4.1",null,"Overheads, charges and profit on item 7.4","%",{"v":356000,"d":"356,000"}]
[]
[7.5,null,"Borehole No: H16-2855 - Supply and install new positive displacement mono pump/similar approved by the engineer including all pipes fittings for delivery pipe up to 315mm diameter (the pump must be able to discharge 6 (l/s) for pumping yield for 24 hrs over 6km at head of 120m) complete.","Prov. Sum",1,{"v":269500,"d":"R 269,500.00"},{"v":269500,"d":"R 269,500.00"}]
["7.5.1",null,"Overheads, charges and profit on item 7.5","%",{"v":269500,"d":"269,500"},null,""]
[]
["SUB-TOTAL SCHEDULE E - SECTION 2 CARRIED FORWARD:"]
["SUB-TOTAL SCHEDULE E - SECTION 3 BROUGHT FORWARD:"]
[]
[7.6,null,"Upgrading of Pumps in Fifteen (15) Existing Boreholes - Supply and install new positive displacement mono pump/similar and Motors as approved by the engineer including all pipes fittings for delivery pipe up to 110mm diameter (the pump must be able to discharge 2.5 to 6.5 (l/s) for pumping yield for 24 hrs over 15km at head of 200m) complete.","Prov. Sum",1,{"v":2536500,"d":"R 2,536,500.00"},{"v":2536500,"d":"R 2,536,500.00"}]
["7.6.1",null,"Overheads, charges and profit on item 7.6","%",{"v":2536500,"d":"2,536,500"},null,""]
[]
[7.7,null,"Supply and installation of Five (5) Boreholes ancillaries and consumables ","Sum",1,null,""]
[]
[7.8,null,"Supply and installation of Five (5) Boreholes electrical connections ancillaries and consumables (Electrical motors and control panels) ","Sum",1,null,""]
[]
[7.9,null,"Provision for Eskom connection","Prov.sum",1,{"v":2392500,"d":"R 2,392,500.00"},{"v":2392500,"d":"R 2,392,500.00"}]
["7.9.1",null,"Overheads, charges and profit on item 7.9","%",{"v":2392500,"d":"2,392,500"},null,""]
[]
[{"v":7.1,"d":"7.10"},null,"Provision for High security CCTV system to Twenty (20) Boreholes","Prov.sum",1,{"v":1220000,"d":"R 1,220,000.00"},{"v":1220000,"d":"R 1,220,000.00"}]
["7.10.1",null,"Overheads, charges and profit on item 7.10","%",{"v":1220000,"d":"1,220,000"},null,""]
{"$rows_empty":23}
[null,null,"TOTAL SECTION 1 CARRIED TO SUMMARY"]

{"sheet":"F-Fence","index":5,"n_rows":47,"n_cols":9,"rows_kept":47,"merged":[[0,7,1,12],[46,0,46,5]],"flags":["formulas_cached_only"]}
["SCHEDULE F: FENCING"]
["SEFENE, EISLEBEN, MATSEKE & RAMATSHOWE REGIONAL WATER SUPPLY - PHASE 1 - CONTRACT A"]
["ITEM NO","PAYMENT REF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["F.1","SANS","FENCING"]
[null,"1200 C","(As specified in the Project Specifications.)"]
[]
[1.1,null,"SECURITY FENCING"]
[]
["1.1.1","8.2.49","Erection of new Pre-cast Palisade concrete industrial type fencing security walling 2,4 m high supplied and fixed complete, including all posts, excavation, backfilling, concrete bases, etc.","m",1150,null,""]
[]
["1.1.2",null,"Supply & Erect Ground Beams","m",1150,null,""]
[]
["1.1.3",null,"Supply & Erect Razor Wire (500mm Flat Wrap)","m",1150,null,""]
[]
[2,null,"SECURITY FENCING GATES"]
[]
[2.1,null,"3m Wide by 2.7 m High heavy duty steel sliding gate installed with all posts and rail required at main entrance complete as detailed on drawing no. EKS-001-006-015-T-00","No",6,null,"",null,""]
{"$rows_empty":28}
["TOTAL CARRIED TO SUMMARY"]

{"sheet":"Sum","index":6,"n_rows":22,"n_cols":4,"rows_kept":22,"merged":[[0,0,0,3],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2]],"flags":["formulas_cached_only"]}
["ESTIMATED PROJECT COST (ALL INCLUSIVE) "]
["SECTION ","SECTION","DESCRIPTION","AMOUNT"]
["A",1,"PRELIMINARY AND GENERAL AND PROVISIONAL"]
["B",1,"EXCAVATION-BULKLINE:EARTHWORKS FOR PIPE TRENCHES AND PIPE BEDDING"]
["C",1,"BULK PIPELINE-MEDIUM PRESSURE PIPELINES AND ANCILLARIES"]
["D",1,"STEEL TANK FOR RAW WATER STORAGE (Positioned at Package Plant)"]
["E ",1,"ANCILLARY WORKS (BOREHOLE EQUIPPING)"]
["F",1,"FENCING (PRE-CAST CONCRETE PALISADE)"]
{"$rows_empty":8}
["SUBTOTAL"]
["CONTINGENCIES @ 10%"]
["ESCALATION @ 2.5%"]
["SUB-TOTAL:"]
["ADD 15% VAT:"]
["TOTAL TENDER AMOUNT:"]