{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["P&G","RETICULATION","ELEVATED TANK","PUMPS","SUMMARY "],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"P&G","index":0,"n_rows":240,"n_cols":7,"rows_kept":240,"merged":[[50,0,50,3],[57,0,57,3],[119,0,119,3],[127,0,127,3],[179,0,179,3],[187,0,187,3],[224,3,225,3],[224,4,225,4],[224,5,225,5],[224,6,225,6],[235,3,236,3],[235,4,236,4],[235,5,236,5],[235,6,236,6],[239,0,239,3]]}
["Capricon District Municipality"]
["RATSAKA WATER SUPPLY"]
["SCHEDULE 1 - PRELIMINARY AND GENERAL"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO.","REFER."]
[]
[" ","SABS","GENERAL"]
[" ","1200A"," "," "]
["A.1",8.3,"Fixed Charges and Value Related Items"]
[]
["1.1",null,"Contractual Requirements"]
[null,null," "]
["1.1.1","8.3.1","Fixed charge contractual requirements.","Sum",1]
[]
["1.1.2","8.3.1","Value related contractual requirements.","Sum",1]
[null," "]
["1.1.2","8.3.2","Provision of Facilities on the Site"]
[" ",null," "]
[null,"8.3.2.1","FACILITIES FOR ENGINEER"]
[" "," "," "]
[null," ","a) Office as per PSAB2","Sum",1]
[]
[" "," ","b) Sanitary","Sum",1]
[]
[null,null,"c) Provission of the Lap top for the use of the Engineer","P Sum",1]
[]
[null,null,"d) Handling cost and profit in respect of item ©","%"]
[]
["1.1.2.1","8.3.2.2","FACILITIES FOR CONTRACTOR"]
[null,null," "]
[null,null,"a) Offices, stores, workshops","Sum",1]
[null,null," "]
[null,null,"b) Housing for staff","Sum",1]
[null,null," "]
[null,null,"c) Toilets and ablutions","Sum",1]
[null,null," "]
[null,null,"d) Fencing off site of construction camp","Sum",1]
[null,null," "]
[null,null,"e) Provision of water, power and communication facilities","Sum",1]
[null,null," "]
[null,null,"f) Tools and equipment","Sum",1]
[]
["1.1.2.2","8.3.4","Removal of site establishment","Sum",1]
[]
[]
[]
[]
[]
[]
["TOTAL CARRIED FORWARD"]
[{"$f":"+A$1","v":"Capricon District Municipality"}]
[{"$f":"+A$2","v":"RATSAKA WATER SUPPLY"}]
[{"$f":"+A$3","v":"SCHEDULE 1 - PRELIMINARY AND GENERAL"}]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO.","REFER."]
[" Brought Forward"]
[null,"SABS"]
[null,"1200A"]
[null,8.4,"Time related Costs to be paid monthly"]
["1.2.2","8.4.1","Operation and Maintenance of Facilities on Site"]
[null,"8.4.2.1","FACILITIES FOR ENGINEER"]
[null,null,"a) One furnished office","month",10]
[]
[null,"PSAB5.1","b) Provisional sum for the costs of cellular calls, fax "]
[null,null,"    and other charges","month",10]
[]
[null,"PSAB5.1","c) Survey Equipment","month",10]
[]
[null,null,"d) Provision of Computers, printing & photostat facilities ","month",10]
[]
[null,"PSAB5.1","e) Overheads, charges and profit on b, c and d","%"]
[]
[" "," ","FACILITIES FOR THE CONTRACTOR"]
[null,null,"a) Office for Contractor","month",10]
[]
[null,null,"b) Housing of staff","month",10]
[null,null," "]
[null,null,"c) Toilets and ablution","month",10]
[]
[" ",null,"d) Provision of water, power and communication ","month",10]
[null,null,"     facilities"]
[]
[null,null,"e) Tools and equipment","month",10]
[null,null," "]
["1.2.3","8.4.3","Supervision for duration of construction"]
["1.2.3.1",null,"Contractors supervision and management","P Sum",10,{"v":45000,"d":"R45,000.00"},{"$f":"E88*F88","v":{"v":450000,"d":"R 450,000.00"}}]
[]
[null,null,"Handling cost and profit in respect of item 1.2.3.1","%",{"$f":"G88","v":{"v":450000,"d":"R450,000.00"}}]
[null,null," "]
[null,"8.4.4","Company and head office overhead costs","month",{"$f":"+E88","v":10}]
[]
[1.3,null,"NAMEBOARD"]
[null,null,"Supply and install construction nameboard as per "]
[null,null,"detail drawing ","No.",{"v":1,"d":"1.00"}]
[]
["1.4",null,"PROVISIONAL SUMS:"]
[]
["1.4.1","8.5 b","Community Liaison Officer:"]
[]
["1.4.1.1","PSA 14.5 a","Provision for employment of CLO.","P Sum",{"v":1,"d":"1.00"},{"v":60000,"d":"R60,000.00"},{"$f":"F102","v":{"v":60000,"d":"R 60,000.00"}}]
[]
["1.4.1.2","PSA 14.5 b","Handling cost and profit in respect of item  1.4.1.1","%",{"$f":"F102","v":{"v":60000,"d":"R60,000.00"}}]
[]
["1.4.2","8.5 b","PSC Attendance at Site Meeting:"]
[]
["1.4.2.1","PSA 14.5 c","Provision for the attendance of PSC members ","P Sum",{"v":1,"d":"1.00"},{"v":16000,"d":"R16,000.00"},{"$f":"F108","v":{"v":16000,"d":"R 16,000.00"}}]
[]
["1.4.2.2","PSA 14.5 d","Handling cost and profit in respect of item 1.4.2.1","%",{"$f":"F108","v":{"v":16000,"d":"R16,000.00"}}]
[]
["1.5","8.5 b","Additional Tests required by Engineer:"]
[]
["1.5.1","PSA 14.5 e","Provision for additional tests.","P Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},{"$f":"F114","v":{"v":50000,"d":"R 50,000.00"}}]
[]
["1.5.2","PSA 14.5 f","Handling cost and profit in respect of item 1.5.1","%",{"v":50000,"d":"R 50,000.00"}]
[]
[]
[null,null," "]
["   TOTAL SCHEDULE 1 CARRIED FORWARD "]
[]
[{"$f":"+A$1","v":"Capricon District Municipality"}]
[{"$f":"+A$2","v":"RATSAKA WATER SUPPLY"}]
[{"$f":"+A$3","v":"SCHEDULE 1 - PRELIMINARY AND GENERAL"}]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO.","REFER."]
[" Brought Forward"]
[1.6,"PSA6.3","Occupational Health & safety"]
[null,null,"Provision for the cost of the Occupational Health &"]
[null,null,"Safety Act, 85 of 1993, and the relevant regulations:"]
[]
[null,null,"a)  Preparation of Health & Safety Plan","Sum",1]
[]
[null,null,"b)  Health and Safety Officer","Sum",1]
[]
[null,null,"c)  Health & safety induction training of employees","Sum",1]
[]
[null,null,"d) Compilation and keeping up with date the Health & "]
[null,null,"     Safety file which shall include all documentation "]
[null,null,"     required in terms of the Act.","sum",1]
{"$rows_empty":37}
[null,null," "]
["   TOTAL SCHEDULE 1 CARRIED FORWARD "]
[]
[{"$f":"+A$1","v":"Capricon District Municipality"}]
[{"$f":"+A$2","v":"RATSAKA WATER SUPPLY"}]
[{"$f":"+A$3","v":"SCHEDULE 1 - PRELIMINARY AND GENERAL"}]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO.","REFER."]
[" Brought Forward"]
["1.7",null,"DAYWORK:"]
[null,null,"(As specified in SABS 1200 A and the Project Specifications.)"]
[]
[]
["1.7","8.7","Labour - Normal Working Hours: [Provisional]"]
[]
["1.7.1",null,"Skilled Labour (Artisan).","hr",null,null,"Rate Only"]
[]
["1.7.2",null,"Semi-skilled Labour.","hr",null,null,"Rate Only"]
[]
["1.7.3",null,"Unskilled Labour.","hr",null,null,"Rate Only"]
[]
["1.7.4",null,"Foreman.","hr",null,null,"Rate Only"]
[]
[]
["1.8","8.7","Plant - Heavy Equipment "]
[null,null,"(Plant shall not be more than 3 years old or have more than"]
[null,null,"3000 hrs logged. Operator to be qualified and competency "]
[null,null,"certified)."]
[]
["1.8.1",null,"Excavator - Size CAT 225","hr",null,null,"Rate Only"]
[]
["1.8.1",null,"Excavator - TLB.","hr",null,null,"Rate Only"]
[]
["1.8.2",null,"Grader 140G or similar.","hr",null,null,"Rate Only"]
[]
["1.8.3",null,"Front end loader - bucket capacity ≤ 1.5 m3.","hr",null,null,"Rate Only"]
[]
["1.8.4",null,"Front end loader - bucket capacity > 1.5 m3.","hr",null,null,"Rate Only"]
[]
["1.8.5",null,"Tip truck - 5 m3 capacity","hr",null,null,"Rate Only"]
[]
["1.8.6",null,"Tip truck - 10 m3 capacity","hr",null,null,"Rate Only"]
[]
["1.8.7",null,"Vibratory compactor roller - 13.5 ton","hr",null,null,"Rate Only"]
[]
["1.8.8",null,"Transport cost per any unit of plant to deliver to site and","Sum",null,null,"Rate Only"]
[null,null,"remove from site for items 1.8.1 to 1.8.7"]
[]
["1.9","8.7","Plant - Small Equipment [Provisional]"]
[]
["1.9.1",null,"Pedestrain roller - BW90 or similar.","hr",null,null,"Rate Only"]
[]
["1.9.2",null,"Vibratory plate compactor.","hr",null,null,"Rate Only"]
[]
["1.9.3",null,"Vibratory rammer.","hr",null,null,"Rate Only"]
[]
["1.9.4",null,"Transport cost per any unit of plant to deliver to site and","Sum",null,null,"Rate Only"]
[null,null,"remove from site for items 1.9.1 to 1.9.3"]
[]
[null,null," "]
["   TOTAL SCHEDULE 1 CARRIED FORWARD TO SUMMARY "]

{"sheet":"RETICULATION","index":1,"n_rows":235,"n_cols":12,"rows_kept":235,"merged":[[1,9,1,10],[3,5,3,7],[4,9,4,10],[51,0,51,4],[58,0,58,4],[113,0,113,4],[114,0,114,7],[121,0,121,4],[165,3,167,3],[171,3,173,3],[174,0,174,4],[181,0,181,4],[197,2,197,3],[202,2,202,3],[223,3,224,3],[233,0,233,4]]}
[{"$f":"'P&G'!A1","v":"Capricon District Municipality"}]
[{"$f":"'P&G'!A2","v":"RATSAKA WATER SUPPLY"},{"$nulls":8},"PHASE 1 "]
["SCHEDULE 2  : RETICULATION "]
[]
["ITEM","PAYMENT","DESCRIPTION",null,"UNIT","QUANTITY","RATE","AMOUNT",null,"QUANTITY"]
["NO.","REFER.",{"$nulls":7},"ph 1 qty","ph 2 qty"]
[]
["2.1.1","SABS ","SITE CLEARANCE"]
["2.1.1.1","1200C","a)","Clear vegetation and trees of girth up to 1m"]
[{"$nulls":3},"(2m Wide on pipeline route)","m",{"$f":"20876","v":{"v":20876,"d":"20,876.00"}},{"$nulls":3},{"v":15901,"d":"15,901.00"},{"$f":"F10-J10","v":{"v":4975,"d":"4,975.00"}},{"$f":"F10-J10-K10","v":0}]
[]
[null,null,"b)","Remove and grub all shrubs (all girth)","ha",{"v":6,"d":"6.00"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"F12-J12","v":{"v":5,"d":"5.00"}}]
[]
["2.1.2","1200DB","EXCAVATION"]
["2.1.2.1",null,"Excavation in all materials for trenches for 200mm"]
[null,null,"nominal diameter pipes and smaller.  Rates to include "]
[null,null,"backfill, compact and dispose of surplus material"]
[null,null,"a)","Up to 1,5m deep (700 mm wide)","m",{"v":40000,"d":"40,000.00"},{"$nulls":3},{"$f":"15901-J21-J23","v":{"v":10889,"d":"10,889.00"}},{"$f":"F18-J18","v":{"v":29111,"d":"29,111.00"}}]
[]
["2.1.2.2","8.3.2","Extra-over item 3.1.2.1 for"]
[null,null,"a)","Intermediate excavation ","m³",{"v":3500,"d":"3,500.00"},{"$nulls":3},{"v":4325,"d":"4,325.00"},{"$f":"F21-J21","v":{"v":-825,"d":"(825.00)"}}]
[]
[null,null,"b)","Hard rock excavation ","m³",{"$f":"0.1*F18","v":{"v":4000,"d":"4,000.00"}},{"$nulls":3},{"v":687,"d":"687.00"},{"$f":"F23-J23","v":{"v":3313,"d":"3,313.00"}}]
[]
["2.1.2.3","8.3.3.3","Excavate and dispose of unsuitable material from"]
[null,null,"trench bottom ",null,"m³",{"$f":"35000*0.1*0.5","v":{"v":1750,"d":"1,750.00"}},{"$nulls":3},{"v":1500,"d":"1,500.00"},{"$f":"F26-J26","v":{"v":250,"d":"250.00"}}]
[]
["2.1.2.4",null,"Import backfill material from designated borrow "]
[null,null,"pits ",null,"m³",{"$f":"35000*1*0.5","v":{"v":17500,"d":"17,500.00"}},{"$nulls":3},{"v":1440,"d":"1,440.00"},{"$f":"F29-J29","v":{"v":16060,"d":"16,060.00"}}]
[]
["2.1.2.5",null,"Opening up and closing down of designated "]
[null,null,"borrow pit",null,"ha",{"v":0.5,"d":"0.50"},null,"Rate Only",null,{"v":0.5,"d":"0.50"},{"$f":"F32-J32","v":0}]
[]
["2.1.2.7","8.3.4","Overhaul"]
[null,null,"a)","Limited overhaul (0,5 to 1,0km) ","m³",{"$f":"F29","v":{"v":17500,"d":"17,500.00"}},null,"Rate Only",null,{"v":4543,"d":"4,543.00"},{"$f":"F35-J35","v":{"v":12957,"d":"12,957.00"}}]
[{"$nulls":10},{"$f":"F36-J36","v":0}]
[null,null,"b)","Long overhaul ","m³.km",{"$f":"F35*0.1","v":{"v":1750,"d":"1,750.00"}},null,"Rate Only",null,{"$f":"+J35*1.5","v":{"v":6814.5,"d":"6,814.50"}},{"$f":"F37-J37","v":{"v":-5064.5,"d":"(5,064.50)"}}]
[]
["2.1.2.8",null,"Existing Services"]
[null,null,"a)","Excavate and expose of existing services ","No",{"v":30,"d":"30.00"},{"$nulls":3},{"v":20,"d":"20.00"},{"$f":"F40-J40","v":{"v":10,"d":"10.00"}}]
[]
[null,null,"b)","Services that adjoin a trench","m",{"v":100,"d":"100.00"},null,"Rate Only",null,{"v":100,"d":"100.00"},{"$f":"F42-J42","v":0}]
[]
[null,null,"c) ","Services that intersect a trench","No",{"v":10,"d":"10.00"},null,"Rate Only",null,{"v":10,"d":"10.00"},{"$f":"F44-J44","v":0}]
[]
["2.1.3","SABS","PIPE BEDDING"]
["2.1.3.1","1200LB","Provision of bedding from trench excavations"]
[null,null,"a)","Selected Granula Material","m³",{"$f":"35000*0.1*1","v":{"v":3500,"d":"3,500.00"}},{"$nulls":3},{"v":1700,"d":"1,700.00"},{"$f":"F48-J48","v":{"v":1800,"d":"1,800.00"}}]
[]
[null,"8.2.2.2","b)","Selected fill material","m³",{"$f":"0.1*F48","v":{"v":350,"d":"350.00"}},{"$nulls":3},{"v":800,"d":"800.00"},{"$f":"F50-J50","v":{"v":-450,"d":"(450.00)"}}]
[]
["TOTAL CARRIED FORWARD"]
[{"$f":"+A$1","v":"Capricon District Municipality"}]
[{"$f":"+A$2","v":"RATSAKA WATER SUPPLY"}]
[{"$f":"+A$3","v":"SCHEDULE 2  : RETICULATION "}]
[]
["ITEM","PAYMENT","DESCRIPTION",null,"UNIT","QUANTITY","RATE","AMOUNT",null,"QUANTITY"]
["NO.","REFER."]
[" Brought Forward"]
["2.1.3.2",null,"Provision of selected fill material for flexible pipe"]
[null,null,"blanket"]
[null,null,"a)","Trench excavation 1500mm deep","m³",{"$f":"35000*1*0.5","v":{"v":17500,"d":"17,500.00"}},{"$nulls":3},{"v":2230,"d":"2,230.00"},{"$f":"F62-J62","v":{"v":15270,"d":"15,270.00"}}]
[null,"8.2.2.2","b)","Borrow pits (Provisional)","m³",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":0,"d":"0.00"}]
["2.1.2.3",null,"Overhaul for imported material for bedding cradle"]
[null,null,"and selected fill blanket (Provisional)",null,"m³.km",{"$f":"+(F50+F63)*1.5","v":{"v":525,"d":"525.00"}},null,"Rate Only",null,{"v":4000,"d":"4,000.00"},{"$f":"F65-J65","v":{"v":-3475,"d":"(3,475.00)"}}]
[]
[null,"SABS "]
["2.1.4","1200L","uPVC PRESSURE PIPE AND PIPE FITTINGS"]
["2.1.4.1","8.2.1","Supply, lay, bed and test the following uPVC pressure"]
[" ",null,"pipes (conforming with SABS 966-1976 specifications)"]
[null,null,"in 6m lengths each pipe fitted at one end with socket"]
[null,null,"for Mechanical jointing, in the following diameters :"]
[null,null,"a)","63mm dia Class 16","m",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":200,"d":"200.00"},{"$f":"F73-J73","v":{"v":-200,"d":"(200.00)"}}]
[null,null,"b)","63mm dia Class 12","m",{"v":18500,"d":"18,500.00"}]
[null,null,"c)","63mm dia Class 9","m",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":1000,"d":"1,000.00"},{"$f":"F75-J75","v":{"v":-1000,"d":"(1,000.00)"}}]
[null,null,"d)","63mm dia Class 6","m",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":550,"d":"550.00"},{"$f":"F76-J76","v":{"v":-550,"d":"(550.00)"}}]
[null,null,"e)","75mm dia Class 12","m",{"v":1400,"d":"1,400.00"}]
[null,null,"f)","75mm dia Class 9","m",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":4030,"d":"4,030.00"},{"$f":"F78-J78","v":{"v":-4030,"d":"(4,030.00)"}}]
[null,null,"g)","110mm dia Class 12","m",{"v":0,"d":"0.00"},null,"Rate Only"]
[null,null,"h)","110mm dia Class 16","m",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":400,"d":"400.00"},{"$f":"F80-J80","v":{"v":-400,"d":"(400.00)"}}]
[null,null,"i)","160mm dia Class 12","m",{"v":12500,"d":"12,500.00"},{"$nulls":3},{"$f":"91+8500","v":{"v":8591,"d":"8,591.00"}},{"$f":"F81-J81","v":{"v":3909,"d":"3,909.00"}}]
[null,null,"j)","200mm dia Class 12","m",{"v":2500,"d":"2,500.00"},{"$nulls":3},{"v":1130,"d":"1,130.00"},{"$f":"F82-J82","v":{"v":1370,"d":"1,370.00"}}]
[]
["2.1.4.2",null,"FITTINGS AND SPECIALS FOR FIXING ONTO"]
[null,null,"uPVC PIPES"]
[null,null,"Fittings to be suitable for coupling directly (mechanically)"]
[null,null,"onto pipes.  Each fitting socketed for mechanical jointing. "]
[null,null,"Fittings for PVC Class 16 (unless otherwise specified)"]
[null,null,"Fittings to be of PVC, Cast Iron or epoxy coated steel."]
[null,null,"Fittings"]
[null,null,"a)","Tee`s"]
[null,null,"(i)","200mm Equal T","No",{"v":5,"d":"5.00"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"F92-J92","v":{"v":4,"d":"4.00"}}]
[null,null,"(ii)","110mm Equal T","No",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":16,"d":"16.00"},{"v":-16,"d":"(16.00)"}]
[null,null,"(iii)","160mm x 63mm T","No",{"v":50,"d":"50.00"},{"$nulls":3},{"v":3,"d":"3.00"},{"v":47,"d":"47.00"}]
[null,null,"(iv)    ","160mm x 75mm T","No",{"v":5,"d":"5.00"},{"$nulls":3},{"v":5,"d":"5.00"},0]
[null,null,"(v)","75mm Equal T","No",{"v":2,"d":"2.00"},{"$nulls":3},{"v":12,"d":"12.00"},{"v":-10,"d":"(10.00)"}]
[null,null,"(vi)","75mm x 63mm T","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":4,"d":"4.00"},{"v":-3,"d":"(3.00)"}]
[null,null,"(vii)","63mm Equal T","No",{"v":50,"d":"50.00"},{"$nulls":3},{"v":3,"d":"3.00"},{"v":47,"d":"47.00"}]
[]
[null,null,"b)","Reduccers"]
[null,null,"(i)","160 x 63 B","No",{"v":50,"d":"50.00"},{"$nulls":3},{"v":4,"d":"4.00"},{"$f":"F101-J101","v":{"v":46,"d":"46.00"}}]
[null,null,"(ii)","2000 X 75 B","No",{"v":10,"d":"10.00"},{"$nulls":3},{"v":13,"d":"13.00"},{"$f":"F102-J102","v":{"v":-3,"d":"(3.00)"}}]
[null,null,"(iii)      110mm x 75mm Reducing Tee","75mm x 63mm B","No",{"v":2,"d":"2.00"},{"$nulls":3},{"v":7,"d":"7.00"},{"$f":"F103-J103","v":{"v":-5,"d":"(5.00)"}}]
[null,null,"(iv)","200mm x 160 L","No",{"v":2,"d":"2.00"},{"$nulls":3},{"v":2,"d":"2.00"},{"$f":"F104-J104","v":0}]
[]
[null,null,"c)","uPVC Long radius bends"]
[null,null,"(i)","90 Deg. 200mm dia","No",{"v":10,"d":"10.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F107-J107","v":{"v":5,"d":"5.00"}}]
[null,null,"(ii)","90 Deg. 160mm dia.","No",{"v":25,"d":"25.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F108-J108","v":{"v":20,"d":"20.00"}}]
[null,null,"(iii)","90 Deg. 75mm dia.","No",{"v":4,"d":"4.00"},{"$nulls":3},{"v":4,"d":"4.00"},{"$f":"F109-J109","v":0}]
[null,null,"(iv)","90 Deg.  63mm dia.","No",{"v":50,"d":"50.00"}]
[null,null,"(vii)","45 Deg. 200mm dia.","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F111-J111","v":{"v":-4,"d":"(4.00)"}}]
[]
[null,null,"(viii)","45 Deg. 110mm dia.","No",{"v":10,"d":"10.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F113-J113","v":{"v":5,"d":"5.00"}}]
["TOTAL CARRIED FORWARD"]
[]
[{"$f":"+A$1","v":"Capricon District Municipality"}]
[{"$f":"+A$2","v":"RATSAKA WATER SUPPLY"}]
[{"$f":"+A$3","v":"SCHEDULE 2  : RETICULATION "}]
[]
["ITEM","PAYMENT","DESCRIPTION",null,"UNIT","QUANTITY","RATE","AMOUNT",null,"QUANTITY"]
["NO.","REFER."]
[" Brought Forward"]
[null,null,"(ix)","45 Deg. 75mm dia.","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F123-J123","v":{"v":-4,"d":"(4.00)"}}]
[{"$nulls":3},"45 Deg.  63mm dia.","No",{"v":10,"d":"10.00"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"F124-J124","v":{"v":9,"d":"9.00"}}]
[null,null,"(xiii)","22.5 Deg. 200mm dia.","No",{"v":4,"d":"4.00"},{"$nulls":3},{"v":7,"d":"7.00"},{"$f":"F125-J125","v":{"v":-3,"d":"(3.00)"}}]
[null,null,"(xiv)","22.5 Deg. 160mm dia.","No",{"v":4,"d":"4.00"},{"$nulls":3},{"v":14,"d":"14.00"},{"$f":"F126-J126","v":{"v":-10,"d":"(10.00)"}}]
[null,null,"(xv)","22.5 Deg. 75mm dia.","No",{"v":13,"d":"13.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F127-J127","v":{"v":8,"d":"8.00"}}]
[{"$nulls":3},"22,5 Deg.  63mm dia.","No",{"v":1,"d":"1.00"}]
[null,null,"(xxi)","11.5 Deg. 200mm dia.","No",{"v":2,"d":"2.00"},{"$nulls":3},{"v":10,"d":"10.00"},{"$f":"F129-J129","v":{"v":-8,"d":"(8.00)"}}]
[null,null,"(xx)","11.5 Deg. 160mm dia.","No",{"v":5,"d":"5.00"},{"$nulls":3},{"v":31,"d":"31.00"},{"$f":"F130-J130","v":{"v":-26,"d":"(26.00)"}}]
[null,null,"(xxi)","11.5 Deg. 75mm dia.","No",{"v":3,"d":"3.00"},{"$nulls":3},{"v":18,"d":"18.00"},{"$f":"F131-J131","v":{"v":-15,"d":"(15.00)"}}]
[{"$nulls":3},"11,5 Deg. 63mm dia.","No",{"v":20,"d":"20.00"},{"$nulls":3},{"v":6,"d":"6.00"},{"$f":"F132-J132","v":{"v":14,"d":"14.00"}}]
[]
[null,null,"d)","CI End Cap for uPVC pipes"]
[null,null,"(i)","200mm dia.","No",{"v":2,"d":"2.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F135-J135","v":{"v":-3,"d":"(3.00)"}}]
[null,null,"(ii)","110mm dia.","No",{"v":2,"d":"2.00"},{"$nulls":3},{"v":6,"d":"6.00"},{"$f":"F136-J136","v":{"v":-4,"d":"(4.00)"}}]
[null,null,"(iii)","75mm dia.","No",{"v":2,"d":"2.00"},{"$nulls":3},{"v":10,"d":"10.00"},{"$f":"F137-J137","v":{"v":-8,"d":"(8.00)"}}]
[null,null,"(iv)","63mm dia.","No",{"v":15,"d":"15.00"},{"$nulls":3},{"v":9,"d":"9.00"},{"$f":"F138-J138","v":{"v":6,"d":"6.00"}}]
[]
[null,null,"e)","CI Reducer for uPVC pipes"]
[null,null,"(i)","200mm x 160mm ","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":4,"d":"4.00"},{"$f":"F141-J141","v":{"v":-3,"d":"(3.00)"}}]
[null,null,"(ii)","160mm x 63mm ","No",{"v":50,"d":"50.00"},{"$nulls":3},{"v":8,"d":"8.00"},{"$f":"F142-J142","v":{"v":42,"d":"42.00"}}]
[null,null,"(iii)","160mm x 75mm ","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F143-J143","v":{"v":-4,"d":"(4.00)"}}]
[null,null,"(iv)","75mm x 63mm ","No",{"v":4,"d":"4.00"},{"$nulls":3},{"v":14,"d":"14.00"},{"$f":"F144-J144","v":{"v":-10,"d":"(10.00)"}}]
[]
[null,null,"f)","Double Socket for uPVC pipes"]
[null,null,"(i)","200mm dia.","No",{"v":5,"d":"5.00"},null,"Rate Only",null,{"v":5,"d":"5.00"},{"$f":"F147-J147","v":0}]
[null,null,"(ii)","160mm dia.","No",{"v":5,"d":"5.00"},null,"Rate Only",null,{"v":7,"d":"7.00"},{"$f":"F148-J148","v":{"v":-2,"d":"(2.00)"}}]
[null,null,"(iii)","75mm dia.","No",{"v":5,"d":"5.00"},null,"Rate Only"]
[]
[null,null,"g)","RSV Gate Valves with non rising spindle, cap top."]
[{"$nulls":3},"Supply and install complete as per detail the "]
[{"$nulls":3},"following Gate valves. Incl. Valve box."]
[null,null,"(i)","200mm dia.","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":2,"d":"2.00"},{"$f":"F154-J154","v":{"v":-1,"d":"(1.00)"}}]
[null,null,"(ii)","160mm dia.","No",20,{"$nulls":3},5,{"$f":"F155-J155","v":{"v":15,"d":"15.00"}}]
[null,null,"(ii)","75mm dia.","No",4,{"$nulls":3},2,{"$f":"F156-J156","v":{"v":2,"d":"2.00"}}]
[null,null,"(iii)","63mm dia","No",10,{"$nulls":3},0,{"$f":"F157-J157","v":{"v":10,"d":"10.00"}}]
[]
[null,null,"h)","Cut into and connect to existing mains"]
[null,null,"i)","VJ flange to suit the following"]
[null,null,"(i)","200mm dia uPVC x 100mm dia GI","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":2,"d":"2.00"},{"$f":"F161-J161","v":{"v":-1,"d":"(1.00)"}}]
[null,null,"(ii)","200mm dia uPVC x 160mm dia Pvc","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":2,"d":"2.00"},{"$f":"F162-J162","v":{"v":-1,"d":"(1.00)"}}]
[]
[null,null,"j)","Pipeline markers - as per standard drawings","No",{"$f":"35000/250","v":{"v":140,"d":"140.00"}},{"$nulls":3},{"v":5,"d":"5.00"},{"$f":"F164-J164","v":{"v":135,"d":"135.00"}}]
[]
[null,null,"k)","Supply and construct 25th air valves (Ventomat type) completed with manhole, covers and all fittings - as per  DWAF details"]
[]
[]
[null,null,"(i)","200mm dia ","No",{"v":2,"d":"2.00"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"F169-J169","v":{"v":1,"d":"1.00"}}]
[null,null,"(i)","160mm dia ","No",{"v":10,"d":"10.00"}]
[]
[null,null,"l)","Supply and construct 50mm air valves (Ventomat type) completed with manhole, covers and all fittings - as per  DWAF details"]
[]
[]
["TOTAL CARRIED FORWARD"]
[{"$f":"+A$1","v":"Capricon District Municipality"}]
[{"$f":"+A$2","v":"RATSAKA WATER SUPPLY"}]
[{"$f":"+A$3","v":"SCHEDULE 2  : RETICULATION "}]
[]
["ITEM","PAYMENT","DESCRIPTION",null,"UNIT","QUANTITY","RATE","AMOUNT",null,"QUANTITY"]
["NO.","REFER."]
[" Brought Forward"]
[null,null,"(i)","200mm dia ","No",{"v":1,"d":"1.00"},null,"Rate Only",null,{"v":0,"d":"0.00"},{"$f":"F183-J183","v":{"v":1,"d":"1.00"}}]
[null,null,"(ii)","160mm dia ","No",{"v":10,"d":"10.00"},{"$nulls":3},{"v":0,"d":"0.00"},{"$f":"F184-J184","v":{"v":10,"d":"10.00"}}]
[null,null,"(iii)","110mm dia ","No",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":0,"d":"0.00"},{"$f":"F185-J185","v":0}]
[]
[null,null,"m)","Supply and construct scour valves   "]
[{"$nulls":3},"complete with manhole, covers and all fittings - as "]
[{"$nulls":3},"per DWAF details"]
[null,null,"(i)","200 mm dia","No",{"v":1,"d":"1.00"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"F190-J190","v":0}]
[null,null,"(i)","160 mm dia","No",{"v":6,"d":"6.00"}]
[{"$nulls":10},{"$f":"F192-J192","v":0}]
[null,null,"n)","Disconnect Existing Standpipes on the Alpha sand "]
[{"$nulls":3},"Pipe Line and  repair the pipe. (Rate to include for "]
[{"$nulls":3},"Disconnecting and supply of all materials to restore ","No",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":4,"d":"4.00"},{"$f":"F195-J195","v":{"v":-4,"d":"(4.00)"}}]
[{"$nulls":3},"the pipe)"]
[]
[null,"PSDB 5.6","Backfill and Compaction:"]
[null,"L.I.",null,"Backfill and compact trenches using labour intensive methods.","m3",{"v":20000,"d":"20,000.00"},{"$nulls":3},{"v":7235,"d":"7,235.00"},{"$f":"F199-J199","v":{"v":12765,"d":"12,765.00"}}]
[{"$nulls":3},"Backfill road crosings using a commercial type G4 material compacted to 98% Mod. AASHTO density.","m3",{"v":1000,"d":"1,000.00"},{"$nulls":3},{"v":300,"d":"300.00"},{"$f":"F200-J200","v":{"v":700,"d":"700.00"}}]
[{"$nulls":3},"Dispose of surplus excavated material.","m3",{"v":950,"d":"950.00"},{"$nulls":3},{"v":250,"d":"250.00"},{"$f":"F201-J201","v":{"v":700,"d":"700.00"}}]
[]
[null,null,"Excavation Ancillaries;"]
[{"$nulls":3},"Make up deficiency in backfill material  from other excavations.","m3",{"$f":"35000*1*0.1","v":{"v":3500,"d":"3,500.00"}},{"$nulls":3},{"v":3500,"d":"3,500.00"},{"$f":"F204-J204","v":0}]
[{"$nulls":3},"Make up deficiency in backfill material  from borrow pits. Free-haul is 5.0 km.","m3",{"v":0,"d":"0.00"},null,"Rate Only"]
[{"$nulls":3},"Pipe protection installed at 300 mm below top of finished backfill level using 3 strips of danger tape. ","m",{"v":10,"d":"10.00"},{"$nulls":3},{"v":10,"d":"10.00"},{"$f":"F206-J206","v":0}]
[{"$nulls":3},"Opening and closing designated borrow pits.","P Sum",{"v":1,"d":"1.00"},null,"Rate Only",null,{"v":1,"d":"1.00"},{"$f":"F207-J207","v":0}]
[{"$nulls":3},"Compaction within road reserve to 90 % of Modified AASHTO density clause 5.7.1.","m3",null,null,"Rate Only"]
[{"$nulls":3},"Compaction within road reserve to 98 % of Modified AASHTO density, as per clause 5.7.2.","m3",null,null,"Rate Only"]
[]
[{"$nulls":3},"Overhaul in excess of the free-haul of 5.0 km.","m3-km",null,null,"Rate Only"]
[]
[null,null,"MISCELLANEOUS"]
["2.1.5",null,"Concrete thrust block configuration."]
["2.1.5.1","L.I.","a)","Concrete volume < 0,5m³ (Provisional)","No",{"$f":"SUM(F130:F154)+SUM(F100:F118)","v":{"v":285,"d":"285.00"}},{"$nulls":3},{"v":30,"d":"30.00"},{"$f":"F215-J215","v":{"v":255,"d":"255.00"}}]
[]
[null,"SABS ","STANDPIPES"]
["2.1.6","1200LF"]
[null,"L.I.","a)","Supply handle and install communal stand pipes"]
[{"$nulls":3},"complete including all fittings,concrete work and"]
[{"$nulls":3},"two SABS approved taps with hose connection "]
[{"$nulls":3},"as per detail drawings","No",{"v":917,"d":"917.00"},{"$nulls":3},{"v":310,"d":"310.00"},{"$f":"F222-J222","v":{"v":607,"d":"607.00"}}]
[]
[null,null,"b)","Supply all Materials  and  fittings required for the installation of domestic water meters"]
[{"$nulls":4},"No",{"v":917,"d":"917.00"},{"$nulls":3},{"v":0,"d":"0.00"},{"$f":"F225-J225","v":{"v":917,"d":"917.00"}}]
[]
["2.1.7","8.3.6","FINISHING"]
[null,null,"Re-instate the road surface complete with all courses"]
[null,null,"a)","150 layer of G5 material compacted to 98 MOD","m2",{"v":0,"d":"0.00"},null,"Rate Only",null,{"v":0,"d":"0.00"},{"$f":"F229-J229","v":0}]
[]
["2.1.8",null,"Submit as-built drawings of all existing services and "]
[null,null,"adjustments to Construction drawings before "]
[null,null,"submission of final payment certificate",null,"sum",{"v":1,"d":"1.00"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"F233-J233","v":0}]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"$f":"SUM(H182:H233)","v":0}]
[{"$nulls":7},{"$f":"3510684-3510684.76","v":-0.7599999997764826}]

{"sheet":"ELEVATED TANK","index":2,"n_rows":115,"n_cols":11,"rows_kept":115,"merged":[[3,4,3,6],[53,0,53,3],[60,0,60,3],[114,0,114,3]]}
[{"$f":"'P&G'!A1","v":"Capricon District Municipality"}]
[{"$f":"'P&G'!A2","v":"RATSAKA WATER SUPPLY"}]
["SCHEDULE 3  : ELEVATED STEEL TANK"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["NO.","REFER."]
[]
["D","PET","ELEVATED STEEL TANK"]
[]
["C.1",null,"ELEVATED STEEL TANK 15m STAND"]
[]
["C.1.1","PSA 8.5(e)1","Elevated tank (750m³)","Sum",1,{"$nulls":3},1,{"v":0,"d":"0.00"},{"$f":"E12-I12","v":0}]
[{"$nulls":8},1,{"v":1500000,"d":"1,500,000.00"},{"$f":"E13-I13","v":{"v":-1,"d":"(1.00)"}}]
[]
["C.2",null,"ANCILLARY WORKS"]
[]
["C.2.1",null,"Offloading from suppliers delivery vehicle the complete structure (+ 11.23 tons)","Sum",1,{"$nulls":3},1,{"v":3000,"d":"3,000.00"},{"$f":"E17-I17","v":0}]
[]
["C.3",null,"LIGHTINING PROTECTION"]
[]
["C.3.1",null,"Specialist sub-contractor for lightning protection","Sum",1,{"$nulls":3},1,{"v":15000,"d":"15,000.00"},{"$f":"E21-I21","v":0}]
[]
["C.4","SABS 1200C","SITE CLEARANCE"]
[]
["C.4.1","8.2.1","Clear & grub vegetation & smaller trees up to 1m girth","m2",{"$f":"20*20","v":400},{"$nulls":3},150,{"v":8.5,"d":"8.50"},{"$f":"E25-I25","v":{"v":250,"d":"250.00"}}]
[{"$nulls":7},{"$f":"+E25/E17","v":400}]
["C.5","SABS 1200D","EARTHWORKS FOR FOUNDATIONS"]
[]
["C.5.1","8.3.2 (a)","Excavate in all materials and dispose excess material","m³",60,{"$nulls":3},180,{"v":25,"d":"25.00"},{"$f":"E29-I29","v":{"v":-120,"d":"(120.00)"}}]
[]
["C.6",null,"MISCELLANEOUS"]
["C.6.1",null,"Allow for the filling of the tank once with clean water for testing purpose","Sum",1,{"$nulls":3},1,{"v":5000,"d":"5,000.00"},{"$f":"E32-I32","v":0}]
[]
["C.6.2","8.3.4","Supply 150g of Calcium Hyperchloride per m³ of water for sterilising the elevated tank","kg",150,{"$nulls":3},25,{"v":50,"d":"50.00"},{"$f":"E34-I34","v":{"v":125,"d":"125.00"}}]
[]
["C.7",null,"SCOUR"]
[]
["C.7.1",null,"80mm Ø GMS Flange threaded inside","No.",1,{"$nulls":3},1,{"v":1500,"d":"1,500.00"},{"$f":"E38-I38","v":0}]
[]
["C.7.2",null,"80mm Ø GMS Barrel nipple, 100mm long, threaded both sides","No.",1,{"$nulls":3},1,{"v":600,"d":"600.00"},{"$f":"E40-I40","v":0}]
[]
["C.7.3",null,"80mm Ø GMS Barrel nipple, 100mm long, threaded one side","No.",1,{"$nulls":3},1,{"v":1500,"d":"1,500.00"},{"$f":"E42-I42","v":0}]
[]
["C.7.4",null,"800MM Ø  Brass fullway gate valve","No.",1,{"$nulls":3},1,{"v":900,"d":"900.00"},{"$f":"E44-I44","v":0}]
[]
["C.8",null,"OVERFLOW"]
[]
["C.8.1",null,"100mm Ø GMS pipe, 100mm long, flanged one end","No.",1,{"$nulls":3},1,{"v":1600,"d":"1,600.00"},{"$f":"E48-I48","v":0}]
[]
["C.9",null,"INLET PIPE"]
[null,null,"Supply delivery and installation of all pipes for the inlet pipes, comprising of pipes, fittings, jointing, materials, gaskets, bolts, etc as for complete installation (All pipes (See detailed drawings for items listed below hot dip galvanised)"]
[null,null,"Item (To SABS 1123, Table 1600/3)"]
[]
["TOTAL CARRIED FORWARD"]
[{"$f":"+A$1","v":"Capricon District Municipality"}]
[{"$f":"+A$2","v":"RATSAKA WATER SUPPLY"}]
[{"$f":"+A$3","v":"SCHEDULE 3  : ELEVATED STEEL TANK"}]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT",null,"QUANTITY"]
["NO.","REFER."]
[" Brought Forward"]
["C.9.1",null,"a 150mm Ø Aqualok flange adaptor","No.",1,{"$nulls":3},1,{"v":800,"d":"800.00"},{"$f":"E62-I62","v":0}]
[]
["C.9.2",null,"b 150mm Ø Pipe GMS section (1750mm long) FOE","No.",1,{"$nulls":3},1,{"v":1400,"d":"1,400.00"},{"$f":"E64-I64","v":0}]
[]
["C.9.3",null,"c 150mm Ø GMS long radius bend FBE","No.",2,{"$nulls":3},2,{"v":1200,"d":"1,200.00"},{"$f":"E66-I66","v":0}]
[]
["C.9.4",null,"d 150mm Ø Pipe GMS section (6036mm long, FTF)","No.",2,{"$nulls":3},2,{"v":3300,"d":"3,300.00"},{"$f":"E68-I68","v":0}]
[]
["C.9.5",null,"e 150mm Ø Pipe GMS secton (2085mm long, FTF)","No.",1,{"$nulls":3},1,{"v":2600,"d":"2,600.00"},{"$f":"E70-I70","v":0}]
[]
["C.10",null,"OUTLET PIPE"]
[null,null,"Item (SABS 1123, Table 1600/3)"]
[]
["C.10.1",null,"a 150mm Ø Aqualok flanfe adaptor","No.",1,{"$nulls":3},1,{"v":900,"d":"900.00"},{"$f":"E75-I75","v":0}]
[]
["C.10.2",null,"b 150mm Ø Pipe GMS section (1750mm long) FOE","No.",1,{"$nulls":3},1,{"v":1400,"d":"1,400.00"},{"$f":"E77-I77","v":0}]
[]
["C.10.3",null,"c 150mm Ø GMS long radius bend FBE","No.",2,{"$nulls":3},2,{"v":1300,"d":"1,300.00"},{"$f":"E79-I79","v":0}]
[{"$nulls":7},104.84]
["C.10.4",null,"d 150mm Ø Pipe GMS section (6036mm long, FTF)","No.",1,null,null,69.97,1,{"v":3600,"d":"3,600.00"},{"$f":"E81-I81","v":0}]
[{"$nulls":7},33.1]
["C.10.5",null,"e 150mm Ø Pipe GMS secton (2085mm long, FTF)","No.",1,null,null,180,1,{"v":3100,"d":"3,100.00"},{"$f":"E83-I83","v":0}]
[]
["C.11","SABS 1200G","CONCRETE (STRUCTURAL)"]
[{"$nulls":7},150]
["C.11.1","8.2","SCHEDULE FORMWORK ITEMS"]
[]
[null,"8.2.1","Rough surface finish (vertical)","m2",150,{"$nulls":3},100,{"v":75,"d":"75.00"},{"$f":"E89-I89","v":{"v":50,"d":"50.00"}}]
[]
[null,"8.2.2","Smooth surface finish (vertical)","m2",100,null,null,{"$f":"+SUM(E80:E82)+100","v":{"v":101,"d":"101.00"}},100,{"v":180,"d":"180.00"},{"$f":"E91-I91","v":0}]
[]
["C.11.2","8.3","SCHEDULE REINFORCEMENT ITEMS"]
[]
[null,"8.3.1","a) Mild steel bars","t",1,{"$nulls":3},1,{"v":13000,"d":"13,000.00"},{"$f":"E95-I95","v":0}]
[]
[null,null,"b) High-tensile steel bars","t",4,{"$nulls":3},6,{"v":13000,"d":"13,000.00"},{"$f":"E97-I97","v":{"v":-2,"d":"(2.00)"}}]
[{"$nulls":7},661.75,null,null,{"$f":"+J98*$I$77","v":0}]
["C.11.3","8.4","SCHEDULE CONRETE ITEMS",{"$nulls":4},389.03,null,null,{"$f":"+J99*$I$77","v":0}]
[]
[null,"8.4.1","Blinding layer in foundation concrete "]
[{"$nulls":7},186.73,null,null,{"$f":"+J102*$I$77","v":0}]
[null,"8.4.2","Minimum 75mm thickness, 20mPa/19mm grade","m2",150,{"$nulls":3},150,{"v":10,"d":"10.00"},{"$f":"E103-I103","v":0}]
[{"$nulls":10},{"$f":"+J104*$I$77","v":0}]
[null,"8.4.3","Strength concrete, 30MPa/19mm","m³",70,{"$nulls":3},63,{"v":15,"d":"15.00"},{"$f":"E105-I105","v":{"v":7,"d":"7.00"}}]
[]
["C.12","SABS 1200H","STRUCTURAL STEELWORK",{"$nulls":4},575.76,null,null,{"$f":"+J107*$I$77","v":0}]
[{"$nulls":7},360.36]
["C.12.1","8.3.4","SCHEDULED ERECTION BOLTS ITEMS"]
[]
[null,null,"Supply, deliver and install M24 HD bolts, 100mm long, including washers and nuts, complete as per detailed drawings","No.",36,{"$nulls":3},72,{"v":300,"d":"300.00"},{"$f":"E111-I111","v":{"v":-36,"d":"(36.00)"}}]
[]
[{"$nulls":8},1,{"v":100000,"d":"100,000.00"},{"$f":"E113-I113","v":{"v":-1,"d":"(1.00)"}}]
[{"$nulls":10},{"$f":"+J114*$I$77","v":0}]
["TOTAL CARRIED FORWARD"]

{"sheet":"PUMPS","index":3,"n_rows":65,"n_cols":8,"rows_kept":65,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,4],[3,5,3,7],[64,1,64,6]]}
[]
[null,{"$f":"RETICULATION!A53","v":"Capricon District Municipality"}]
[null,{"$f":"RETICULATION!A54","v":"RATSAKA WATER SUPPLY"}]
[]
[null,"SCHEDULE VC: WATER SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SCHEDULE 4: PUMPS"]
[]
[null,"ITEM NUMBER","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,"SANS 1200D",null,"PUMPS"]
[{"$nulls":3},"(As specified in the Project Specifications.)"]
[]
[null,4.1,"PS VC 10","Supply and Delivery of Pumps"]
[]
[null,"4.1.2","PS VC 10.1","Supply, deliver, Install,commission,comissioning and maintanance(during defect liability period) of positive displacement pumps complete with acceseries"]
[null,null,"i) ","BOREHOLE H16-2918 (Yield=3 l/s,depth=46m)"]
[{"$nulls":3},"a) BP 16H  Element complete with:15x65mm columns,30xbobbin bearings,5xstabilisers,30 line shafts,complete head, vee belts,taper lock,motor mount bracket e.t.c.","NO",1]
[]
[null,null,"ii)","BOREHOLE H16-2808A (Yield=3.8 l/s,depth=50m)"]
[{"$nulls":3},"a) BP 23M  Element complete with:15x65mm columns,30xbobbin bearings,8xstabilisers,30 line shafts,complete head, vee belts,taper lock,motor mount bracket e.t.c.","NO",1]
[]
[null,null,"iii)","BOREHOLE H16-2808 (Yield=1.3 l/s,depth=55m)"]
[{"$nulls":3},"a) BP 23M  Element complete with:17x65mm columns,34xbobbin bearings,8xstabilisers,34 line shafts,complete head, vee belts,taper lock,motor mount bracket e.t.c.","NO",1]
[]
[null,null,"iv)","BOREHOLE H16-2807 (Yield=1.9 l/s,depth=60m)"]
[{"$nulls":3},"a) BP 16H  Element complete with:20x65mm columns,40xbobbin bearings,8xstabilisers,40 line shafts,complete head, vee belts,taper lock,motor mount bracket e.t.c.","NO",1]
[null,null,"v)","BOREHOLE H16-2809 (Yield=1.8 l/s,depth=60m)"]
[{"$nulls":3},"a) BP 16H  Element complete with:20x65mm columns,40xbobbin bearings,8xstabilisers,40 line shafts,complete head, vee belts,taper lock,motor mount bracket e.t.c.","NO",1]
[null,null,"vi)","BOREHOLE H16-2806 (Yield=1.0l/s,depth=55m)"]
[{"$nulls":3},"a) BP 6MRCL  Element complete with:18x65mm columns,36xbobbin bearings,8xstabilisers,36 line shafts,complete head, vee belts,taper lock,motor mount bracket e.t.c.","NO",1]
[]
[null,null,"PS VC 10.2","Supply, deliver, Install,commission,comissioning and maintanance(during defect liability period) of a three phase Electrical motor  4-pole foot mount complete with taper lock,vee belts and pulley"]
[{"$nulls":3},"a) 11kw","No",5]
[{"$nulls":3},"b) 7.5kw","No",1]
[]
[null,null,"PS VC 10.3","design,fabricate and install delivery maniford as detailed on the delivery pipework maniford drawing to Dwa specs including 2xgate valves,pressure swith,flow switch,water meter,non return valve,galvernised pipes etc"]
[{"$nulls":3},"a) 65mm pipework","No",5]
[{"$nulls":3},"b) 50mm pipework","No",1]
[]
[]
[null,"4.1.4","PS VC 10.4","Compile, Supply and  delivery a complete set of operation and maintenance manuals of all pumps as specified and measured above","Prov Sum",1]
[]
[null,"4.1.5",null,"Design, manufacture, supply, delivery, installation, testing, commissioning and maintenance for a 12 month period  of a DWA spec control box for borehole automation including probes","No",6]
[]
[null,"4.1.6",null,"Eskom Transformers"]
[]
[{"$nulls":3},"(a) Provisional sum for application of Eskom transformers for 6 boreholes","Prov Sum",1,{"v":673773.65,"d":"R673,773.65"},{"$f":"G47","v":{"v":673773.65,"d":"673,773.65"}}]
[]
[{"$nulls":3},"Contractor's handling costs, profit and all other charges in respect of item  4.1.6","%",{"$f":"G47","v":{"v":673773.65,"d":"R673,773.65"}}]
[]
[null,4.2,"PS VC 4.2","Supply and erect  fence"]
[null,"4.2.1",null,"Supply and Installation of concrete palisade fence (36m per borehole) as specified on the drawing","no",6]
[]
[null,"4.2.2",null,"Palisade steel gate 2,4 x 6m as per drawing","no",1]
[]
[null,4.3,"PS PME 4.2.3","Pump House"]
[null,"4.3.1",null,"Erect pre-fabricated reinforced concrete pump house"]
[{"$nulls":3},"complete with locking device as per drawing.","no",6]
[]
[null,null,"PS PME 4.2.4","Existing Equipment"]
[{"$nulls":3},"Take out existing borehole equipment, clean and"]
[{"$nulls":3},"store on site. Rust prevention fluid to be put on all"]
[{"$nulls":3},"sockets and threads.","no",1]
[]
[null,"TOTAL SCHEDULE 4 -  CARRIED TO SUMMARY:"]

{"sheet":"SUMMARY ","index":4,"n_rows":47,"n_cols":2,"rows_kept":47,"merged":[[1,0,1,6],[3,0,3,6],[5,0,5,6],[7,5,8,6],[65,0,65,6]]}
[]
["CAPRICORN DISTRICT  MUNICIPALITY"]
[]
[{"$f":"'P&G'!A2","v":"RATSAKA WATER SUPPLY"}]
[]
["PROJECT NUMBER : INF- W30/2022/2023"]
[]
["SUMMARY OF SCHEDULES"]
[]
["ESTIMATED CONSTRUCTION FEE"]
[]
["SCHEDULE 1 :","PRELIMINARY AND GENERAL"]
[]
["SCHEDULE 2 :","RETICULATION "]
[]
["SCHEDULE 3 :","STEEL ELAVATED TANK"]
[]
["SCHEDULE 4 :","PUMPS & PUMP HOUSE"]
[]
[]
["SUB - TOTAL 1"]
[]
[]
[]
["Provide the sum of 10% of  Total 1 for contingencies to be used at the discretion of the"]
{"$rows_empty":17}
["SUB - TOTAL 2"]
[]
["ADD 15% VAT"]
[]
["TOTAL CONTRACT AMOUNT"]