{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Disclaimer","A ","B","C ","D","E","F","G","H","I","J","K","L","Summary"],"not_rendered":{"external_links":5,"defined_names":199},"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":12,"n_cols":2,"rows_kept":12}
[null,"DISCLAIMER"]
[]
[null,"This electronic file is made available for the convenience of prospective tenderers and no responsibility is accepted by the Engineer or the Employer for the accuracy of the data in this file or for any discrepancy between the data in this file and the Bill of Quantities bound into the relevant tender document.  Tenderers or others using the information in this file do so at their own risk.  This file and the data therein, including any hard copy produced from this file are the copyright of Tlowana Consulting & Engineering (Pty) Ltd.  This file will not be amended to take account of any Notice(s) to Tenderers issued."]
[]
[null,"Notwithstanding the provision of this electronic file, tenders may not be submitted in electronic form nor may tenders be submitted on a print-out made from this file. The requirements of the Conditions of Tender of the relevant tender document, must be strictly adhered to."]
[]
[]
[null,"AFWYSING"]
[]
[null,"Hierdie elektroniese leêr word vir die gerief van voornemende tenderaars beskikbaar gestel en geen verantwoordelikheid word deur die Ingenieur of die Werkgewer aanvaar nie vir die akkuraatheid van die data in hierdie leêr of enige teenstrydigheid tussen die data in hierdie leêr en die Hoeveelheidslys ingebind in die betrokke tender dokument.  Tenderaars en ander gebruik die inligting in heirdie leêr op eie risiko.  Hierdie leêr en data daarin, asook enige herprodusering van hierdie leêr, is kopiereg van Tlowana Consulting & Engineering (Edms) Bpk.  Hierdie leêr sal nie aangepas word om enige Kennisgewing(s) aan Tenderaars in ag te neem nie."]
[]
[null,"Nieteenstaande die beskikbaarstelling van hierdie elektroniese leêr, mag tenders nie in elektroniese vorm of as 'n drukstuk van hierdie elektroniese leêr ingedien word nie.  Die vereistes van die Tendervoorwaardes van die betrokke tender dokument moet ten strengste nagekom word. "]

{"sheet":"A ","index":1,"n_rows":322,"n_cols":8,"rows_kept":322,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7],[53,1,55,3],[53,4,53,7],[54,4,55,7],[112,1,114,3],[112,4,112,7],[113,4,114,7],[179,1,181,3],[179,4,179,7],[180,4,181,7],[244,1,246,3],[244,4,244,7],[245,4,246,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION A "]
[{"$nulls":4},"PRELIMINARY AND GENERAL"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[1,"A ","SANS\n1200 A","SECTION A : PRELIMINARY AND GENERAL"]
[]
[2,"A 1","PSA 8.2.1","SCHEDULED FIXED-CHARGE ITEMS AND VALUE RELATED ITEMS\n"]
[]
[3,"A 1.1","8.3.1","Contractual Requirements (All Regions)"]
[]
[4,"A 1.1.1",null,"Provision of performance security on appointment for active assigned work up to R 10 000 000","Sum",1,null,{"$f":"F12*G12","v":0}]
[]
[5,"A 1.1.2",null,"Extra over for increasing the performance security for each additional R 2 000 000 or portion thereof of active assigned work","No",1,null,{"$f":"F14*G14","v":0}]
[]
[6,"A 1.1.3",null,"Extra over for amendment, replacement, renewal or extension of performance security required in terms of the Contract","No.",1,null,{"$f":"F16*G16","v":0}]
[]
[7,"A 1.1.4",null,"Contractual requirements of a general nature, excluding guarantees / sureties measured elsewhere, including all charges, fees, submissions, notices, records and obligations required under the Contract and not separately measured","Sum",1,null,{"$f":"F18*G18","v":0}]
[]
[8,"A 1.1.5",null,"Initial contract establishment, inception meeting, pricing setup and reporting systems","Sum",1,null,{"$f":"F20*G20","v":0}]
[]
[9,"A 1.1.6",null,"Preparation of quality plan, environmental controls and standard method statement templates","Sum",1,null,{"$f":"F22*G22","v":0}]
[]
[10,"A 1.1.7",null,"Initial GIS / as-built coding structure and leak register setup for contract reporting","Sum",1,null,{"$f":"F24*G24","v":0}]
[]
[11,"A 1.2","8.3.2","Establishment of Facilities on the Site. Establishment of Contractor’s regional base for the Greater Maluti-a-Phofung / Phuthaditjhaba service area, including all associated facilities required for the Contractor’s principal operating base."]
[]
[12,"A 1.2.1","8.3.2.1","Facilities for Engineer  (SABS 1200AB)"]
[]
[13,"A 1.2.1.1",null,"Furnished Office to SANS 1200 AB 3.2 Specifications","Sum",1,null,{"$f":"F30*G30","v":0}]
[]
[14,"A 1.2.1.2",null,"Mobile Cellular Wifi Modem including 10GB of data per month for the sole use of the Engineers","Month",24,null,{"$f":"F32*G32","v":0}]
[]
[15,"A 1.2.1.3",null,"Cellular Airtime allowance for the Engineers at  1 000 minutes talk time per month","Month",24,null,{"$f":"F34*G34","v":0}]
[]
[16,"A 1.2.1.4",null,"Epson L14150 EcoTank A3 4-in-1 Wi-Fi Printer for sole use of the engineer including A4 & A3 paper and cartridges for the duration of the project","Sum",1,null,{"$f":"F36*G36","v":0}]
[]
[17,"A 1.2.1.5",null,"Laptop 4 GHZ Processor ( i7 13th Gen ), 16 GB RAM, 1TB  SSD, integrated graphics card Lenovo or similar approved, complete with carry bag and Bluetooth mouse Windows 11 64 bit operating system, MS Office Basic and MS Projects","No.",1,null,{"$f":"G38*F38","v":0}]
[]
[18,"A 1.2.1.6",null,"Contract Notice Board","Sum",1,null,{"$f":"F40*G40","v":0}]
[]
[19,"A 1.2.1.7",null,"Safety equipment for the Engineers"]
[]
[20,"A 1.2.1.7.1",null,"2 x Sets of steel pointed safety shoes","Sum",1,null,{"$f":"F44*G44","v":0}]
[]
[21,"A 1.2.1.7.2",null,"2 x Safety jackets of vests","Sum",1,null,{"$f":"F46*G46","v":0}]
[]
[22,"A 1.2.1.7.3",null,"2 x Construction Hard Hats","Sum",1,null,{"$f":"F48*G48","v":0}]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H5:H52)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION A "]
[{"$nulls":4},"PRELIMINARY AND GENERAL"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H53","v":0}]
[]
[23,"A 1.3","8.3.2.2","Facilities for Contractor (SABS 1200A)"]
[]
[24,"A 1.3.1",null,"Offices and storage sheds","Sum",1,null,{"$f":"F62*G62","v":0}]
[]
[25,"A 1.3.2",null,"Living accommodation","Sum",1,null,{"$f":"F64*G64","v":0}]
[]
[26,"A 1.3.3",null,"Ablution and latrine facilities with wash hand basins and taps","Sum",1,null,{"$f":"F66*G66","v":0}]
[]
[27,"A 1.3.4",null,"Tools and equipment","Sum",1,null,{"$f":"F68*G68","v":0}]
[]
[28,"A 1.3.5",null,"Water supplies, electric power and communications","Sum",1,null,{"$f":"F70*G70","v":0}]
[]
[29,"A 1.3.6",null,"Rain gauge","No",1,null,{"$f":"F72*G72","v":0}]
[]
[30,"A 1.3.7",null,"Dealing with water ","Sum",1,null,{"$f":"F74*G74","v":0}]
[]
[31,"A 1.4","8.3.3","Other Fixed -charge obligations"]
[]
[32,"A 1.4.1",null,"Provision of Site Security","Sum",1,null,{"$f":"F78*G78","v":0}]
[]
[33,"A 1.5","8.3.4","Removal of Site Establishment","Sum",1,null,{"$f":"F80*G80","v":0}]
[]
[34,"A 1.6","PSA 8.3.5","Additional geographically separate Work Fronts"]
[]
[35,"A 1.6.1",null,"Establishment at an additional geographically separate Work Front, including mobilisation of supervisory staff, plant, tools, temporary stores, secure storage / container, temporary ablutions, local signage, local communications, temporary access arrangements and all associated costs required to commence work at that Work Front, complete","No.",10,null,{"$f":"F84*G84","v":0}]
[]
[36,"A 1.6.2",null,"Removal of an instructed additional geographically separate Work Front on completion, suspension or closure of that Work Front, including clearing away, removal of temporary facilities, making good and leaving the area in a neat and acceptable condition, complete","No.",10,null,{"$f":"F86*G86","v":0}]
[]
[37,"A 1.6.3",null,"Interim relocation / re-establishment of substantial resources between geographically separate Work Fronts on written instruction, including de-establishment from one Work Front and re-establishment at another, but excluding payment under Items A 1.6.1 and A 1.6.2 where separately measured","Event",10,null,{"$f":"F88*G88","v":0}]
[]
[38,"A 2","PSA 8.2.2","SCHEDULED TIME-RELATED ITEMS"]
[]
[39,"A 2.1","PSA 8.4.1","Contractual Requirements","Sum",1,null,{"$f":"F92*G92","v":0}]
[]
[40,"A 2.2","8.4.2","Operation and Maintenance of Facilities on Site for the duration of the Contract, for:"]
[]
[41,"A 2.3","8.4.2.1","Facilities for Engineer for duration of construction (SANS 1200 AB)"]
[]
[42,"A 2.3.1",null,"Furnished Office to SANS 1200 AB 3.2 Specifications","Sum",1,null,{"$f":"F98*G98","v":0}]
[]
[43,"A 2.3.2",null," Survey assistants","Sum",1,null,{"$f":"F100*G100","v":0}]
[]
[44,"A 2.3.3",null,"Survey Equipment and Material","Sum",1,null,{"$f":"F102*G102","v":0}]
[]
[45,"A 2.4","8.4.2.2","Facilities for Contractor for duration of construction, except where otherwise stated"]
{"$rows_empty":7}
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H58:H111)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION A "]
[{"$nulls":4},"PRELIMINARY AND GENERAL"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H112","v":0}]
[]
[46,"A 2.4.1",null,"Offices and storage sheds","Sum",1,null,{"$f":"F119*G119","v":0}]
[]
[47,"A 2.4.2",null,"Workshops","Sum",1,null,{"$f":"F121*G121","v":0}]
[]
[48,"A 2.4.3",null,"Laboratories","Sum",1,null,{"$f":"F123*G123","v":0}]
[]
[49,"A 2.4.4",null,"Living accommodation","Sum",1,null,{"$f":"F125*G125","v":0}]
[]
[50,"A 2.4.5",null,"Ablution and Latrine facilities","Sum",1,null,{"$f":"F127*G127","v":0}]
[]
[51,"A 2.4.6",null,"Tools and Equipment","Sum",1,null,{"$f":"F129*G129","v":0}]
[]
[52,"A 2.4.7",null,"Water supplies, electric power and communications","Sum",1,null,{"$f":"F131*G131","v":0}]
[]
[53,"A 2.4.8",null,"Dealing with water ","Sum",1,null,{"$f":"F133*G133","v":0}]
[]
[54,"A 2.4.9",null,"Acess","Sum",1,null,{"$f":"F135*G135","v":0}]
[]
[55,"A 2.4.10",null,"Plant","Sum",1,null,{"$f":"F137*G137","v":0}]
[]
[56,"A 2.4.11","8.4.3","Construction Supervision for the duration of the contract","Sum",1,null,{"$f":"F139*G139","v":0}]
[]
[57,"A 2.4.12","8.4.4","Company and Head Office overhead costs for the Duration of the Contract","Sum",1,null,{"$f":"F141*G141","v":0}]
[]
[58,"A 2.4.13","8.4.5","Provision of Security Personnel at Site offices,  buildings, works etc.","Sum",1,null,{"$f":"F143*G143","v":0}]
[]
[59,"A 3",null,"MONTHLY TIME-RELATED CHARGES"]
[]
[60,"A 3.1","8.3.3","Contract manager / project lead","Month",24,null,{"$f":"F147*G147","v":0}]
[]
[61,"A 3.2","8.3.3","Site agent / supervisor","Month",24,null,{"$f":"F149*G149","v":0}]
[]
[62,"A 3.3","8.3.3","Safety, environmental and public interface management","Month",24,null,{"$f":"F151*G151","v":0}]
[]
[63,"A 3.4","8.3.3","Maintenance of site establishment, records, attendance registers and monthly progress reporting","Month",24,null,{"$f":"F153*G153","v":0}]
[]
[64,"A 3.5","8.3.3","GIS / as-built and photo record updating support","Month",24]
[]
[65,"A 3.6","PSA 8.3.5","Time-related cost of maintaining an instructed additional geographically separate Work Front in operation, including temporary stores, secure storage / container, ablutions, local supervision attendance, local signage, communications, security and all associated overheads for that Work Front, complete","Month",24,null,{"$f":"F156*G156","v":0}]
[]
[66,"A 4",null,"SUMS STATED PROVISIONALLY BY EMPLOYER"]
[]
[67,"A 4.1",null,"Relocation of Municipal Services","Prov. Sum",1,{"v":50000,"d":"R50,000.00"},{"$f":"F161*G161","v":{"v":50000,"d":"R 50 000.00"}}]
[]
[68,"A 4.2",null,"Overheads, charges and profit on item A2.3.3","%",{"v":50000,"d":"R50,000.00"},null,{"$f":"F163*G163","v":0}]
[]
[69,"A 4.3",null,"Community Liaison Officer (CLO) remuneration","Prov. Sum",1,{"v":240000,"d":"R240,000.00"},{"$f":"F165*G165","v":{"v":240000,"d":"R 240 000.00"}}]
[]
[70,"A 4.4",null,"Overheads, charges and profit on item A2.3.5","%",{"v":240000,"d":"R240,000.00"},null,{"$f":"F167*G167","v":0}]
[]
[71,"A 4.5",null,"Conducting of skills audit, development of training plan, attending  accredited training courses","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"F169*G169","v":{"v":100000,"d":"R 100 000.00"}}]
[]
[72,"A 4.6",null,"Overheads, charges and profit over Item 2.3.7","%",{"v":100000,"d":"R100,000.00"},null,{"$f":"F171*G171","v":0}]
[]
[73,"A 4.7",null,"Transport of workers for training where it is not possible to undertake training in close proximity to the site","Prov. Sum",1,{"v":50000,"d":"R50,000.00"},{"$f":"F173*G173","v":{"v":50000,"d":"R 50 000.00"}}]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H117:H178)","v":{"v":440000,"d":"R440,000.00"}}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION A "]
[{"$nulls":4},"PRELIMINARY AND GENERAL"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H179","v":{"v":440000,"d":"R440,000.00"}}]
[]
[74,"A 4.8",null,"Overheads, charges and profit on item A2.3.9","%",{"v":50000,"d":"R50,000.00"},null,{"$f":"F186*G186","v":0}]
[]
[75,"A 4.9",null,"Accommodation of workers for training where it is not possible to undertake training in close proximity to the site","Prov. Sum",1,{"v":50000,"d":"R50,000.00"},{"$f":"F188*G188","v":{"v":50000,"d":"R 50 000.00"}}]
[]
[76,"A 4.10",null,"Overheads, charges and profit on item A2.3.11","%",{"v":50000,"d":"R50,000.00"},null,{"$f":"F190*G190","v":0}]
[]
[77,"A 5",8.8,"TEMPORARY WORKS"]
[]
[78,"A 5.1","8.8.2","Accommodation of traffic","Sum",1,null,{"$f":"F194*G194","v":0}]
[]
[79,"A 6",null,"Payment for the following items shall only be made on instruction of the Engineer to utilise these items:"]
[]
[80,"A 6.1",null,"Portable STOP/GO-RY signs","No",4,null,{"$f":"F198*G198","v":0}]
[]
[81,"A 6.2",null,"Road works - TW336","No",4,null,{"$f":"F200*G200","v":0}]
[]
[82,"A 6.3",null,"Temporary Regulatory Sign - TR201-60","No",4,null,{"$f":"F202*G202","v":0}]
[]
[83,"A 6.4",null,"Temporary Regulatory Sign - TR201-40","No",4,null,{"$f":"F204*G204","v":0}]
[]
[84,"A 6.5",null,"Keep Right - TR104","No",4,null,{"$f":"F206*G206","v":0}]
[]
[85,"A 6.6",null,"Warning TW336-WG (We Apologize for …)","No",2,null,{"$f":"F208*G208","v":0}]
[]
[86,"A 6.7",null,"Danger Plate TW401/TW402","No",20,null,{"$f":"F210*G210","v":0}]
[]
[87,"A 6.8",null,"Plastic traffic cones (large)","No",20,null,{"$f":"F212*G212","v":0}]
[]
[88,"A 6.9",null,"Plastic barrier with droppers and fencing to  barricade off works area and trenches","m",1000,null,{"$f":"F214*G214","v":0}]
[]
[89,"A 7",null,"Special water control in terms of project specification.","Sum",1,null,{"$f":"F216*G216","v":0}]
[]
[90,"A 8",null,"Supply temporary vehicle access to appropriate households.","No",10,null,{"$f":"F218*G218","v":0}]
[]
[91,"A 9",null,"SPECIALIST COMPLIANCE AND ADMINISTRATION"]
[]
[92,"A 9.1",null,"Asbestos-containing pipework management plan, induction and compliance oversight","Task",6,null,{"$f":"F222*G222","v":0}]
[]
[93,"A 9.2",null,"Traffic accommodation establishment for work in major roads / urban centres","Task",10,null,{"$f":"F224*G224","v":0}]
[]
[94,"A 9.3",null,"Emergency call-out and out-of-hours standby arrangement","Month",36,null,{"$f":"F226*G226","v":0}]
[]
[95,"A 10",null,"OCCUPATIONAL HEALTH AND SAFETY"]
[]
[96,"A 10.1","PSA 8.9.1","Cost of OHS measures in terms of Construction Regulations (2014) of the Occupational Health and Safety Act.","Month",36,null,{"$f":"F230*G230","v":0}]
[]
[97,"A 10.2","PSA 8.9.2","Compilation and maintenance of a Health and Safety Plan, including Risk Assessment, Safety Works Procedures and Methods Statement.","Sum",1,null,{"$f":"F232*G232","v":0}]
[]
[98,"A 10.3","PS A 8.9.3","Compilation and maintenance of the Health and Safety File. ","Sum",1,null,{"$f":"F234*G234","v":0}]
[]
[99,"A 10.4","PS A 8.9.4","Medical Examinations","No.",50,null,{"$f":"F236*G236","v":0}]
[]
[100,"A 11",null,"ENVIRONMENTAL MANAGEMENT PLAN"]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H184:H243)","v":{"v":490000,"d":"R490,000.00"}}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION A "]
[{"$nulls":4},"PRELIMINARY AND GENERAL"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H244","v":{"v":490000,"d":"R490,000.00"}}]
[]
[101,"A 11.1","PSA 10.1","Compliation of a Environmental Management Plan","No.",1,null,{"$f":"F251*G251","v":0}]
[]
[102,"A 11.2","PSA 10.2","Compliantce and impletmentation of the Environmental Management Plan","Month",24,null,{"$f":"F253*G253","v":0}]
[]
[103,"A 12","PSA 11","LOCAL ECONOMIC PARTICIPLATION PLAN"]
[]
[104,"A 12.1","PSA 10.1","Compliation of a Local Econimic Participation Plan","No.",1,null,{"$f":"F257*G257","v":0}]
[]
[105,"A 12.2","PSA 10.2","Compliantce and impletmentation of the Local Econimic Participation Plan","Month",24,null,{"$f":"F259*G259","v":0}]
{"$rows_empty":62}
["TSF","TOTAL SECTION A  CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H249:H321)","v":{"v":490000,"d":"R490,000.00"}}]

{"sheet":"B","index":2,"n_rows":73,"n_cols":8,"rows_kept":73,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION B"]
[{"$nulls":4},"DAYWORKS"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[106,"B","SANS 1200A 8.7","SECTION B: DAYWORKS"]
[]
[107,"B1",null,"Labour : (Rates shall include all on-costs, including Supervision)"]
[]
[108,"B1.1",null,"Contract manager","hr",80,null,{"$f":"F10*G10","v":0}]
[]
[109,"B1.2",null,"Site agent / foreman","hr",240,null,{"$f":"F12*G12","v":0}]
[]
[110,"B1.3",null,"Leak detection technician","hr",240,null,{"$f":"F14*G14","v":0}]
[]
[111,"B1.4",null,"Artisan plumber / pipe fitter","hr",320,null,{"$f":"F16*G16","v":0}]
[]
[112,"B1.5",null,"Welder / steel pipe repair artisan","hr",160,null,{"$f":"F18*G18","v":0}]
[]
[113,"B1.6",null,"Electrician / instrumentation technician","hr",160,null,{"$f":"F20*G20","v":0}]
[]
[114,"B1.7",null,"General worker","hr",{"v":1000,"d":"1,000"},null,{"$f":"F22*G22","v":0}]
[]
[115,"B1.8",null,"Flagman / traffic marshal","hr",320,null,{"$f":"F24*G24","v":0}]
[]
[116,"B2",null,"Plant : (Wet rates shall be tendered and shall include all on-costs, including supervision)"]
[]
[117,"B2.1",null,"LDV / bakkie","km",30000,null,{"$f":"F28*G28","v":0}]
[]
[118,"B2.2",null,"Tipper truck","hr",160,null,{"$f":"F30*G30","v":0}]
[]
[119,"B2.3",null,"TLB","hr",240,null,{"$f":"F32*G32","v":0}]
[]
[120,"B2.4",null,"Excavator 5-8 ton","hr",240,null,{"$f":"F34*G34","v":0}]
[]
[121,"B2.5",null,"Excavator 12-20 ton","hr",160,null,{"$f":"F36*G36","v":0}]
[]
[122,"B2.6",null,"Road breaker / compressor","hr",160,null,{"$f":"F38*G38","v":0}]
[]
[123,"B2.7",null,"Dewatering pump set","hr",160,null,{"$f":"F40*G40","v":0}]
[]
[124,"B2.8",null,"Generator","hr",160,null,{"$f":"F42*G42","v":0}]
[]
[125,"B2.9",null,"Plate compactor / rammer","hr",160,null,{"$f":"F44*G44","v":0}]
[]
[126,"B3",null,"Materials"]
[]
[127,"B3.1",null,"Additional materials required by the Engineer based on their net cost","Prov Sum",1,{"v":150000,"d":"R150,000.00"},{"$f":"F48*G48","v":{"v":150000,"d":"R 150 000.00"}}]
[]
[128,"B3.2",null,"Materials supplied under daywork - tendered mark-up on nett invoiced cost","%",{"v":150000,"d":"R150,000.00"},null,{"$f":"F50*G50","v":0}]
[]
[129,"B4",null,"Specialist Sub-Contractor Works"]
[]
[130,"B4.1",null,"Specialist Subcontractor Work required by tge Engineer based on their net cost","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"F54*G54","v":{"v":100000,"d":"R 100 000.00"}}]
[]
[131,"B4.2",null,"Specialist subcontract work under daywork - tendered mark-up on nett invoiced cost","%",{"v":100000,"d":"R100,000.00"},null,{"$f":"F56*G56","v":0}]
{"$rows_empty":16}
["TSF","TOTAL SECTION B CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H5:H72)","v":{"v":250000,"d":"R250,000.00"}}]

{"sheet":"C ","index":3,"n_rows":140,"n_cols":8,"rows_kept":140,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7],[68,1,70,3],[68,4,68,7],[69,4,70,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION C "]
[{"$nulls":4},"SITE CLEARANCE"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[132,"C ",null,"SECTION C : SITE CLEARANCE"]
[]
[133,"C 1","SANS\r\n1200 C","SITE CLEARANCE"]
[]
[134,"C 1.1","8.2.1","Clear and grub Site, 3.0m wide strip","m",5000,null,{"$f":"F10*G10","v":0}]
[]
[135,"C 1.2","8.2.2","Remove and grub large trees and tree stumps of girth Over and up to"]
[]
[136,"C 1.2.1",null,"1 m to 2 m","No.",6,null,{"$f":"F14*G14","v":0}]
[]
[137,"C 1.2.2",null,"2 m to 3 m","No.",3,null,{"$f":"F16*G16","v":0}]
[]
[138,"C 1.2.3",null,"3 m upwards in 1 m steps","No.",2,null,{"$f":"F18*G18","v":0}]
[]
[139,"C 1.3","8.2.4","Reclear working strip 3 m wide on written instruction from the Engineer","m",1500,null,{"$f":"F20*G20","v":0}]
[]
[140,"C 2","8.2.5","REMOVAL OF FENCES, BOUNDARY WALLS, ETC"]
[]
[141,"C 2.1",null,"Taking down existing fences including neatly stacking on site designated by the Engineer"]
[]
[142,"C 2.1.1",null,"1,2m High fence","m",200,null,{"$f":"F26*G26","v":0}]
[]
[143,"C 2.1.2",null,"1,8m High fence","m",200,null,{"$f":"F28*G28","v":0}]
[]
[144,"C 2.2","8.2.6","Clear hedge, fence or both where not scheduled separately and spoil material"]
[]
[145,"C 2.2.1",null,"Hedge 1,5m high","m",200,null,{"$f":"F32*G32","v":0}]
[]
[146,"C 2.2.2",null,"Hedge 1,5m high including fence 1,2m high","m",200,null,{"$f":"F34*G34","v":0}]
[]
[147,"C 2.3","8.2.5","Taking down existing steel palisade fencing including neatly stacking on site designated by the Engineer"]
[]
[148,"C 2.3.1",null,"Steel palisade fence 1,8m high","m",200,null,{"$f":"F38*G38","v":0}]
[]
[149,"C 2.3.2",null,"Steel palisade fence 2,4m high","m",200,null,{"$f":"F40*G40","v":0}]
[]
[150,"C 2.4","8.2.5","Taking down existing precast concrete boundary walls including neatly stacking on site designated by the Engineer"]
[]
[151,"C 2.4.1",null,"Precast concrete boundary walls 1,2m high","m",200,null,{"$f":"F44*G44","v":0}]
[]
[152,"C 2.4.2",null,"Precast concrete boundary walls 1,8m high","m",200,null,{"$f":"F46*G46","v":0}]
[]
[153,"C 2.4.3",null,"Precast concrete boundary walls 2,4m high","m",200,null,{"$f":"F48*G48","v":0}]
[]
[154,"C 2.5","8.2.5","Taking down existing brick boundary walls and spoil material"]
[]
[155,"C 2.5.1",null,"115mm Thick brick boundary wall including pilasters, etc 1,2m high","m",100,null,{"$f":"F52*G52","v":0}]
[]
[156,"C 2.5.2",null,"115mm Thick brick boundary wall including pilasters, etc 1,8m high","m",50,null,{"$f":"F54*G54","v":0}]
[]
[157,"C 2.5.3",null,"230mm Thick brick boundary wall 1,2m high","m",200,null,{"$f":"F56*G56","v":0}]
[]
[158,"C 2.5.4",null,"230mm Thick brick boundary wall 1,8m high","m",250,null,{"$f":"F58*G58","v":0}]
[]
[159,"C 2.5.5",null,"345mm Thick brick boundary wall 1,2m high","m",100,null,{"$f":"F60*G60","v":0}]
[]
[160,"C 2.5.6",null,"345mm Thick brick boundary wall 1,8m high","m",100,null,{"$f":"F62*G62","v":0}]
[]
[161,"C 3",null,"REINSTATEMENT OF FENCES, BOUNDARY, WALLS ETC.  "]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H5:H67)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION C "]
[{"$nulls":4},"SITE CLEARANCE"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H68","v":0}]
[]
[162,"C 3.1","PSC8","Take from stockpile on site existing fences and reinstate in similar position including replacing missing or damaged elements, etc"]
[]
[163,"C 3.1.1",null,"1,2m High fence","m",200,null,{"$f":"F77*G77","v":0}]
[]
[164,"C 3.1.2",null,"1,8m High fence","m",200,null,{"$f":"F79*G79","v":0}]
[]
[165,"C 3.2","PSC8","Take from stockpile on site existing steel  palisade fencing and reinstate in similar position including replacing missing or damaged elements, etc"]
[]
[166,"C 3.2.1",null,"Steel palisade fence 1,8m high","m",200,null,{"$f":"F83*G83","v":0}]
[]
[167,"C 3.2.2",null,"Steel palisade fence 2,4m high","m",200,null,{"$f":"F85*G85","v":0}]
[]
[168,"C 3.3","PSC8","Take from stockpile on site existing precast concrete reinstate in similar position including replacing missing or damaged elements, etc"]
[]
[169,"C 3.3.1",null,"Precast concrete boundary walls 1,2m high","m",200,null,{"$f":"F89*G89","v":0}]
[]
[170,"C 3.3.2",null,"Precast concrete boundary walls 1,8m high","m",200,null,{"$f":"F91*G91","v":0}]
[]
[171,"C 3.3.3",null,"Precast concrete boundary walls 2,4m high","m",200,null,{"$f":"F93*G93","v":0}]
[]
[172,"C 3.4",null,"Supply and deliver bricks for the reinstatement of brickwalls","m²",1200,null,{"$f":"F95*G95","v":0}]
[]
[173,"C 3.5",null,"Reinstatement of brickswalls 115mm to 345mm","m²",1200,null,{"$f":"F97*G97","v":0}]
[]
[174,"C 4",null,"Locate and test hydrants and valves on instruction by the Engineer irrespective of size and type","No.",50,null,{"$f":"F99*G99","v":0}]
{"$rows_empty":40}
["TSF","TOTAL SECTION C  CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H73:H139)","v":0}]

{"sheet":"D","index":4,"n_rows":277,"n_cols":8,"rows_kept":277,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7],[56,1,58,3],[56,4,56,7],[57,4,58,7],[122,1,124,3],[122,4,122,7],[123,4,124,7],[199,1,201,3],[199,4,199,7],[200,4,201,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION D"]
[{"$nulls":4},"EARTHWORKS (PIPE TRENCHES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[175,"D","SANS\r\n1200 DB","SECTION D: EARTHWORKS (PIPE TRENCHES"]
[]
[176,"D.1","PSDB8.3.2","EXCAVATION"]
[]
[177,"D.1.1",null,"Excavate with machine in all materials for trenches, backfill, compact and dispose of surplus material, for pipes up to 400mm diameter, for the following depths:"]
[]
[178,"D.1.1.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",500,null,{"$f":"F12*G12","v":0}]
[]
[179,"D.1.1.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",500,null,{"$f":"F14*G14","v":0}]
[]
[180,"D.1.1.3",null,"Exceeding 1,5 m but not exceeding 2,0 m","m",500,null,{"$f":"F16*G16","v":0}]
[]
[181,"D.1.2",null,"Excavate by hand in all materials for trenches, backfill, compact and dispose of surplus material, for pipes up to 400 mm diameter, for the following depths:"]
[]
[182,"D.1.2.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",50,null,{"$f":"F20*G20","v":0}]
[]
[183,"D.1.2.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",50,null,{"$f":"F22*G22","v":0}]
[]
[184,"D.1.3",null,"Backfill by hand including select, backfill, compact and dispose of all surplus material at authorized spoil site determined by the Contractor for main pipes with diameters up to 400 mm, for the following depths:"]
[]
[185,"D.1.3.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",50,null,{"$f":"F26*G26","v":0}]
[]
[186,"D.1.3.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",50,null,{"$f":"F28*G28","v":0}]
[]
[187,"D.1.4",null,"Excavate with machine in all materials for trenches, backfill, compact and dispose of surplus material, for pipes up to 250mm diameter, for the following depths:"]
[]
[188,"D.1.4.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",500,null,{"$f":"F32*G32","v":0}]
[]
[189,"D.1.4.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",500,null,{"$f":"F34*G34","v":0}]
[]
[190,"D.1.4.3",null,"Exceeding 1,5 m but not exceeding 2,0 m","m",500,null,{"$f":"F36*G36","v":0}]
[]
[191,"D.1.5",null,"Excavate by hand in all materials for trenches, backfill, compact and dispose of surplus material, for pipes up to 250mm diameter, for the following depths:"]
[]
[192,"D.1.5.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",50,null,{"$f":"F40*G40","v":0}]
[]
[193,"D.1.5.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",50,null,{"$f":"F42*G42","v":0}]
[]
[194,"D.1.6",null,"Backfill by hand including select, backfill, compact and dispose of all surplus material at authorized spoil site determined by the Contractor for main pipes with diameters up to 250 mm, for the following depths:"]
[]
[195,"D.1.6.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",50,null,{"$f":"F46*G46","v":0}]
[]
[196,"D.1.6.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",50,null,{"$f":"F48*G48","v":0}]
[]
[197,"D.1.7",null,"Excavate with machine in all materials for trenches, backfill, compact and dispose of surplus material, for pipes up to 110 diameter, for the following depths:"]
[]
[198,"D.1.7.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",500,null,{"$f":"F52*G52","v":0}]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H5:H55)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION D"]
[{"$nulls":4},"EARTHWORKS (PIPE TRENCHES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H56","v":0}]
[]
[199,"D.1.7.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",500,null,{"$f":"F63*G63","v":0}]
[]
[200,"D.1.7.3",null,"Exceeding 1,5 m but not exceeding 2,0 m","m",500,null,{"$f":"F65*G65","v":0}]
[]
[201,"D.1.8",null,"Excavate by hand in all materials for trenches, backfill, compact and dispose of surplus material, for pipes up to 110mm diameter, for the following depths:"]
[]
[202,"D.1.8.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",50,null,{"$f":"F69*G69","v":0}]
[]
[203,"D.1.8.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",50,null,{"$f":"F71*G71","v":0}]
[]
[204,"D.1.9",null,"Backfill by hand including select, backfill, compact and dispose of all surplus material at authorized spoil site determined by the Contractor for main pipes with diameters up to 110 mm, for the following depths:"]
[]
[205,"D.1.9.1",null,"Exceeding 0,0 m but not exceeding 1,0 m","m",500,null,{"$f":"F75*G75","v":0}]
[]
[206,"D.1.9.2",null,"Exceeding 1,0 m but not exceeding 1,5 m","m",500,null,{"$f":"F77*G77","v":0}]
[]
[207,"D.1.9.3","8.3.2","Extra-over for PSDB 8.3.2 (a) & (d) "]
[]
[208,"D.1.9.3.1",null,"Intermediate excavation","m³",500,null,{"$f":"F81*G81","v":0}]
[]
[209,"D.1.9.3.2",null,"Hard rock excavation","m³",2500,null,{"$f":"F83*G83","v":0}]
[]
[210,"D.1.9.3.3",null,"Excavate and dispose of unsuitable material from trench bottom","m³",1500,null,{"$f":"F85*G85","v":0}]
[]
[211,"D.1.9.3.4",null,"Extra-over PS DB 8.3.2 (a) for temporary stockpiling of material","m³",300,null,{"$f":"F87*G87","v":0}]
[]
[212,"D.1.9.3.5","PS DB 8.3.2(f)","Extra-over item PS DB 8.3.2(a) for restricted excavation for pipe trenches in all materials and use for backfilling, fill or disposal","m³",150,null,{"$f":"F89*G89","v":0}]
[]
[213,"D.1.9.3.6","PS DB 8.3.2(g)","Hand excavation to expose and protect all existing services","m³",50,null,{"$f":"F91*G91","v":0}]
[]
[214,"D.1.9.3.7","PS DM 8.3.12","Extra-over for overhaul on item PS DB 8.3.2(b) and (c) to spoil site determined by Contractor","m³",50,null,{"$f":"F93*G93","v":0}]
[]
[215,"D.2","PS DB 8.3.3","EXCAVATION ANCILLARIES"]
[]
[216,"D.2.1","8.3.3.1","Make up deficiency in backfill material"]
[]
[217,"D.2.1.1",null," from other ecessary excavations on site","m³",150,null,{"$f":"F99*G99","v":0}]
[]
[218,"D.2.1.2",null,"by importation from commercial sources G7 quality material","m³",900,null,{"$f":"F101*G101","v":0}]
[]
[219,"D.2.1.3",null,"By importation from designated borrow pits","m³",300,null,{"$f":"F103*G103","v":0}]
[]
[220,"D.2.2","8.3.3.3","Compaction in road reserves (300mm deep)","m³",300,null,{"$f":"F105*G105","v":0}]
[]
[221,"D.2.3","PS DB 8.3.4","Shore a trench opposite structure or service "]
[]
[222,"D.2.3.1",null,"ESKOM Line","m",200,null,{"$f":"F109*G109","v":0}]
[]
[223,"D.2.3.2",null,"Sewer Line","m",200,null,{"$f":"F111*G111","v":0}]
[]
[224,"D.2.3.3",null,"Water Line","m",200,null,{"$f":"F113*G113","v":0}]
[]
[225,"D.2.3.4",null,"TELKOM & Fibre Lines","m",200,null,{"$f":"F115*G115","v":0}]
[]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H61:H121)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION D"]
[{"$nulls":4},"EARTHWORKS (PIPE TRENCHES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H122","v":0}]
[]
[226,"D.3","8.3.5(a)","EXISTING SERVICES"]
[]
[227,"D.3.1",null,"Crossing and protecting services that intersect a trench"]
[]
[228,"D.3.1.1",null,"Underground electrical cables","No.",50,null,{"$f":"F133*G133","v":0}]
[]
[229,"D.3.1.2",null,"Overhead electrical cables","No.",50,null,{"$f":"F135*G135","v":0}]
[]
[230,"D.3.1.3",null,"Underground Telkom cables","No.",50,null,{"$f":"F137*G137","v":0}]
[]
[231,"D.3.1.4",null,"Overhead Telkom cables","No.",50,null,{"$f":"F139*G139","v":0}]
[]
[232,"D.3.1.5",null,"Water main not exceeding Ø 300mm","No.",100,null,{"$f":"F141*G141","v":0}]
[]
[233,"D.3.1.6",null,"Water main exceeding Ø 300mm","No.",50,null,{"$f":"F143*G143","v":0}]
[]
[234,"D.3.1.7",null,"Sewer main not excedding Ø 300mm","No.",100,null,{"$f":"F145*G145","v":0}]
[]
[235,"D.3.1.8",null,"Sewer main exceeding Ø 300mm","No.",50,null,{"$f":"F147*G147","v":0}]
[]
[236,"D.3.1.9",null,"Stormwater pipe not exceeding Ø 600mm ","No.",10,null,{"$f":"F149*G149","v":0}]
[]
[237,"D.3.1.10",null,"Stormwater pipe exceeding Ø 600mm ","No.",10,null,{"$f":"F151*G151","v":0}]
[]
[238,"D.3.2","8.3.5(b)","Working along and protecting services that adjoin a trench"]
[]
[239,"D.3.2.1",null,"Underground electrical cables","m",50,null,{"$f":"F155*G155","v":0}]
[]
[240,"D.3.2.2",null,"Overhead electrical pole","m",50,null,{"$f":"F157*G157","v":0}]
[]
[241,"D.3.2.3",null,"Underground Telkom cables","m",50,null,{"$f":"F159*G159","v":0}]
[]
[242,"D.3.2.4",null,"Overhead Telkom cables","m",50,null,{"$f":"F161*G161","v":0}]
[]
[243,"D.3.2.5",null,"Water main not exceeding Ø 300mm","m",100,null,{"$f":"F163*G163","v":0}]
[]
[244,"D.3.2.6",null,"Water main exceeding Ø 300mm","m",50,null,{"$f":"F165*G165","v":0}]
[]
[245,"D.3.2.7",null,"Sewer main not excedding Ø 300mm","m",100,null,{"$f":"F167*G167","v":0}]
[]
[246,"D.3.2.8",null,"Sewer main exceeding Ø 300mm","m",50,null,{"$f":"F169*G169","v":0}]
[]
[247,"D.3.2.9",null,"Stormwater pipe not exceeding Ø 600mm ","m",100,null,{"$f":"F171*G171","v":0}]
[]
[248,"D.3.2.10",null,"Stormwater pipe exceeding Ø 600mm ","m",50,null,{"$f":"F173*G173","v":0}]
[]
[249,"D.4",null,"Crossing of Main Roads with water pipe line by means of Directional Drilling up to Ø 160 mm","Prov Sum",{"v":1,"d":" 1"},{"v":300000,"d":"R300,000.00"},{"$f":"F175*G175","v":{"v":300000,"d":"R 300 000.00"}}]
[]
[250,"D.4.1",null,"Attendance and profit on Item D4","%",{"v":300000,"d":"R300,000.00"},null,{"$f":"F177*G177","v":0}]
[]
[251,"D.5",null,"Removal and relaying of existing brick paving ","m²",50,null,{"$f":"F179*G179","v":0}]
[]
[252,"D.6",null,"Removal and replacement of concrete paving ","m²",50,null,{"$f":"F181*G181","v":0}]
[]
[253,"D.7",null,"Remove and reinstate existing grass areas","m²",50,null,{"$f":"F183*G183","v":0}]
[]
[254,"D.8",null,"Remove and reinstate existing gardens","m²",50,null,{"$f":"F185*G185","v":0}]
[]
[255,"D.9","8.3.6","FINISHING"]
[]
[256,"D.9.1"," 8.3.6.1","Reinstate road surfaces complete with all layers"]
[]
[257,"D.9.1.1",null,"150mm Thick G9 lower selected layer","m³",250,null,{"$f":"F191*G191","v":0}]
[]
[258,"D.9.1.2",null,"150mm Thick G7 upper selected layer","m³",250,null,{"$f":"F193*G193","v":0}]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H127:H198)","v":{"v":300000,"d":"R300,000.00"}}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION D"]
[{"$nulls":4},"EARTHWORKS (PIPE TRENCHES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H199","v":{"v":300000,"d":"R300,000.00"}}]
[]
[259,"D.9.1.3",null,"150mm Thick G5 subbase course","m³",250,null,{"$f":"F206*G206","v":0}]
[]
[260,"D.9.1.4",null,"150mm Thick G4 base course","m³",250,null,{"$f":"F208*G208","v":0}]
[]
[261,"D.9.1.5",null,"Asphalt 30 mm thick including prime and tack coat","m²",50,null,{"$f":"F210*G210","v":0}]
[]
[262,"D.9.1.6",null,"60mm thick (Existing pavers)","m²",50,null,{"$f":"F212*G212","v":0}]
[]
[263,"D.9.1.7",null,"60mm thick (Light grey, 25MPa interlocker pavers)","m²",50,null,{"$f":"F214*G214","v":0}]
[]
[264,"D.9.1.8",null,"25MPa Concrete, 150mm thick with mesh ref 193","m²",50,null,{"$f":"F216*G216","v":0}]
[]
[265,"D.9.1.9",null,"13mm Stone, 100m thick layer","m²",50,null,{"$f":"F218*G218","v":0}]
[]
[266,"D.9.2",null,"Extra-over DB 8.3.6.1 for imported material for:"]
[]
[267,"D.9.2.1",null,"150mm Thick G7 upper selected layer","m³",125,null,{"$f":"F222*G222","v":0}]
[]
[268,"D.9.2.2",null,"150mm Thick G5 subbase course","m³",125,null,{"$f":"F224*G224","v":0}]
[]
[269,"D.9.2.3",null,"150mm Thick G4 base course","m³",125,null,{"$f":"F226*G226","v":0}]
[]
[270,"D.9.2.4",null,"Asphalt 30 mm thick","m²",25,null,{"$f":"F228*G228","v":0}]
[]
[271,"D.9.2.5",null,"60mm pavers","m²",25,null,{"$f":"F230*G230","v":0}]
[]
[272,"D.9.2.6",null,"25MPa Concrete, 150mm thick with mesh ref 193","m²",25,null,{"$f":"F232*G232","v":0}]
[]
[273,"D.9.2.7",null,"13mm Stone, 100m thick layer","m²",25,null,{"$f":"F234*G234","v":0}]
[]
[274,"D.9.3","8.3.6.1(d)","Cut Bitumen Layer "]
[]
[275,"D.9.3.1",null,"30mm Asphalt","m",1000,null,{"$f":"F238*G238","v":0}]
[]
[276,"D.9.4",null,"Trim, Shape And Compact Sidewalks ","m²",500,null,{"$f":"F240*G240","v":0}]
{"$rows_empty":36}
["TSF","TOTAL SECTION D CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H204:H276)","v":{"v":300000,"d":"R300,000.00"}}]

{"sheet":"E","index":5,"n_rows":74,"n_cols":8,"rows_kept":74,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION E"]
[{"$nulls":4},"BEDDING (PIPES)"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[277,"E","SANS 1200 LB","SECTION E: BEDDING (PIPES)"]
[]
[278,"E1","8.2.2.3","Provision of bedding material compacted to 93% MDD (100% for sand) with material from commercial sources (including overhaul)"]
[]
[279,"E1.1",null,"Selected granular material","m³",1000,null,{"$f":"F10*G10","v":0}]
[]
[280,"E1.2",null,"Selected fill material","m³",1000,null,{"$f":"F12*G12","v":0}]
[]
[281,"E2","8.2.1","Provision of bedding material compacted to 93% MDD (100% for sand) with material from trench excavations (including overhaul)"]
[]
[282,"E2.1",null,"Selected granular material","m³",200,null,{"$f":"F16*G16","v":0}]
[]
[283,"E2.2",null,"Selected fill material","m³",200,null,{"$f":"F18*G18","v":0}]
[]
[284,"E3",null,"19mm Crushed stone","m²",100,null,{"$f":"F20*G20","v":0}]
[]
[285,"E4","PSLB8.2.7","Bidim Geotextile","m³",100,null,{"$f":"F22*G22","v":0}]
[]
[286,"E5","PSLB8.2.6","Extra over for items E1.2 to E2.2 for bedding, cradle and blanket stabilized with 3% cement.","m³",50,null,{"$f":"F24*G24","v":0}]
[]
[287,"E6",null,"Encasing of pipes in concrete"]
[]
[288,"E6.1",null," 25 MPa/19 mm","m³",30,null,{"$f":"F28*G28","v":0}]
{"$rows_empty":45}
["TSF","TOTAL SECTION E CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H5:H73)","v":0}]

{"sheet":"F","index":6,"n_rows":857,"n_cols":8,"rows_kept":857,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7],[76,1,78,3],[76,4,76,7],[77,4,78,7],[150,1,152,3],[150,4,150,7],[151,4,152,7],[230,1,232,3],[230,4,230,7],[231,4,232,7],[310,1,312,3],[310,4,310,7],[311,4,312,7],[389,1,391,3],[389,4,389,7],[390,4,391,7],[461,1,463,3],[461,4,461,7],[462,4,463,7],[519,1,521,3],[519,4,519,7],[520,4,521,7],[578,1,580,3],[578,4,578,7],[579,4,580,7],[648,1,650,3],[648,4,648,7],[649,4,650,7],[723,1,725,3],[723,4,723,7],[724,4,725,7],[783,1,785,3],[783,4,783,7],[784,4,785,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[289,"F","SANS 1200 L","SECTION F: MEDIUM PRESSURE PIPELINES"]
[]
[290,"F1"," 8.2.1","Supply (include materials), lay and bed on Class B bedding according to SABS 1200 LB drawing LB-2, joint including cutting of pipes to length where required, testing and disinfecting, with necessary couplings."]
[]
[291,"F1.1",null,"63mm diameter uPVC Class 9","m",100,null,{"$f":"F10*G10","v":0}]
[]
[292,"F1.2",null,"63mm diameter uPVC Class 12","m",100,null,{"$f":"F12*G12","v":0}]
[]
[293,"F1.3",null,"63mm diameter uPVC Class 16","m",100,null,{"$f":"F14*G14","v":0}]
[]
[294,"F1.4",null,"75mm diameter uPVC Class 9","m",100,null,{"$f":"F16*G16","v":0}]
[]
[295,"F1.5",null,"75mm diameter uPVC Class 12","m",100,null,{"$f":"F18*G18","v":0}]
[]
[296,"F1.6",null,"75mm diameter uPVC Class 16","m",100,null,{"$f":"F20*G20","v":0}]
[]
[297,"F1.7",null,"90mm diameter uPVC Class 9","m",100,null,{"$f":"F22*G22","v":0}]
[]
[298,"F1.8",null,"90mm diameter uPVC Class 12","m",100,null,{"$f":"F24*G24","v":0}]
[]
[299,"F1.9",null,"90mm diameter uPVC Class 16","m",100,null,{"$f":"F26*G26","v":0}]
[]
[300,"F1.10",null,"110mm diameter uPVC Class 9","m",100,null,{"$f":"F28*G28","v":0}]
[]
[301,"F1.11",null,"110mm diameter uPVC Class 12","m",100,null,{"$f":"F30*G30","v":0}]
[]
[302,"F1.12",null,"110mm diameter uPVC Class 16","m",100,null,{"$f":"F32*G32","v":0}]
[]
[303,"F1.13",null,"160mm diameter uPVC Class 9","m",100,null,{"$f":"F34*G34","v":0}]
[]
[304,"F1.14",null,"160mm diameter uPVC Class 12","m",100,null,{"$f":"F36*G36","v":0}]
[]
[305,"F1.15",null,"160mm diameter uPVC Class 16","m",100,null,{"$f":"F38*G38","v":0}]
[]
[306,"F1.16",null,"200mm diameter uPVC Class 9","m",100,null,{"$f":"F40*G40","v":0}]
[]
[307,"F1.17",null,"200mm diameter uPVC Class 12","m",100,null,{"$f":"F42*G42","v":0}]
[]
[308,"F1.18",null,"200mm diameter uPVC Class 16","m",100,null,{"$f":"F44*G44","v":0}]
[]
[309,"F1.19",null,"250mm diameter uPVC Class 9","m",100,null,{"$f":"F46*G46","v":0}]
[]
[310,"F1.20",null,"250mm diameter uPVC Class 12","m",100,null,{"$f":"F48*G48","v":0}]
[]
[311,"F1.21",null,"250mm diameter uPVC Class 16","m",100,null,{"$f":"F50*G50","v":0}]
[]
[312,"F1.22",null,"315mm diameter uPVC Class 9","m",100,null,{"$f":"F52*G52","v":0}]
[]
[313,"F1.23",null,"315mm diameter uPVC Class 12","m",100,null,{"$f":"F54*G54","v":0}]
[]
[314,"F1.24",null,"315mm diameter uPVC Class 16","m",100,null,{"$f":"F56*G56","v":0}]
[]
[315,"F1.25",null,"355mm diameter uPVC Class 9","m",100,null,{"$f":"F58*G58","v":0}]
[]
[316,"F1.26",null,"355mm diameter uPVC Class 12","m",100,null,{"$f":"F60*G60","v":0}]
[]
[317,"F1.27",null,"355mm diameter uPVC Class 16","m",100,null,{"$f":"F62*G62","v":0}]
[]
[318,"F1.28",null,"400mm diameter uPVC Class 9","m",100,null,{"$f":"F64*G64","v":0}]
[]
[319,"F1.29",null,"400mm diameter uPVC Class 12","m",100,null,{"$f":"F66*G66","v":0}]
[]
[320,"F1.30",null,"400mm diameter uPVC Class 16","m",100,null,{"$f":"F68*G68","v":0}]
{"$rows_empty":7}
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H5:H75)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H76","v":0}]
[]
[321,"F2","8.2.2","SPECIALS AND FITTINGS:\nSupply (include materials), lay and bed on Class B bedding according to SABS 1200 LB drawing LB-2, joint including cutting of pipe to length where required, testing an disinfecting, Extra- over item 8.2.1 above for specials and fittings complete with necessary couplings:"]
[]
[322,"F2.1",null,"uPVC bends for uPVC pipes:"]
[]
[323,"F2.1.1",null,"63mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F87*G87","v":0}]
[]
[324,"F2.1.2",null,"63mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F89*G89","v":0}]
[]
[325,"F2.1.3",null,"63mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F91*G91","v":0}]
[]
[326,"F2.1.4",null,"63mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F93*G93","v":0}]
[]
[327,"F2.1.5",null,"75mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F95*G95","v":0}]
[]
[328,"F2.1.6",null,"75mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F97*G97","v":0}]
[]
[329,"F2.1.7",null,"75mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F99*G99","v":0}]
[]
[330,"F2.1.8",null,"75mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F101*G101","v":0}]
[]
[331,"F2.1.9",null,"90mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F103*G103","v":0}]
[]
[332,"F2.1.10",null,"90mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F105*G105","v":0}]
[]
[333,"F2.1.11",null,"90mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F107*G107","v":0}]
[]
[334,"F2.1.12",null,"90mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F109*G109","v":0}]
[]
[335,"F2.1.13",null,"110mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F111*G111","v":0}]
[]
[336,"F2.1.14",null,"110mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F113*G113","v":0}]
[]
[337,"F2.1.15",null,"110mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F115*G115","v":0}]
[]
[338,"F2.1.16",null,"110mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F117*G117","v":0}]
[]
[339,"F2.1.17",null,"160mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F119*G119","v":0}]
[]
[340,"F2.1.18",null,"160mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F121*G121","v":0}]
[]
[341,"F2.1.19",null,"160mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F123*G123","v":0}]
[]
[342,"F2.1.20",null,"160mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F125*G125","v":0}]
[]
[343,"F2.1.21",null,"200mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F127*G127","v":0}]
[]
[344,"F2.1.22",null,"200mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F129*G129","v":0}]
[]
[345,"F2.1.23",null,"200mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F131*G131","v":0}]
[]
[346,"F2.1.24",null,"200mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F133*G133","v":0}]
[]
[347,"F2.1.25",null,"250mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F135*G135","v":0}]
[]
[348,"F2.1.26",null,"250mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F137*G137","v":0}]
[]
[349,"F2.1.27",null,"250mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F139*G139","v":0}]
[]
[350,"F2.1.28",null,"250mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F141*G141","v":0}]
[]
[351,"F2.1.29",null,"315mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F143*G143","v":0}]
[]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H81:H149)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H150","v":0}]
[]
[352,"F2.1.30",null,"315mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F157*G157","v":0}]
[]
[353,"F2.1.31",null,"315mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F159*G159","v":0}]
[]
[354,"F2.1.32",null,"315mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F161*G161","v":0}]
[]
[355,"F2.1.33",null,"355mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F163*G163","v":0}]
[]
[356,"F2.1.34",null,"355mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F165*G165","v":0}]
[]
[357,"F2.1.35",null,"355mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F167*G167","v":0}]
[]
[358,"F2.1.36",null,"355mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F169*G169","v":0}]
[]
[359,"F2.1.37",null,"400mm diameter uPVC Class 16 - 11.25º","No.",10,null,{"$f":"F171*G171","v":0}]
[]
[360,"F2.1.38",null,"400mm diameter uPVC Class 16 - 22.5º","No.",10,null,{"$f":"F173*G173","v":0}]
[]
[361,"F2.1.39",null,"400mm diameter uPVC Class 16 - 45º","No.",10,null,{"$f":"F175*G175","v":0}]
[]
[362,"F2.1.40",null,"400mm diameter uPVC Class 16 - 90º","No.",10,null,{"$f":"F177*G177","v":0}]
[]
[363,"F2.2","8.2.2","Cast Iron Unequal T-pieces (Class 16)"]
[]
[364,"F2.2.1",null,"75mm x 63mm diameter for uPVC Pipes","No",10,null,{"$f":"F181*G181","v":0}]
[]
[365,"F2.2.2",null,"90mm x 63mm diameter for uPVC Pipes","No",10,null,{"$f":"F183*G183","v":0}]
[]
[366,"F2.2.3",null,"90mm x 75mm diameter for uPVC Pipes","No",10,null,{"$f":"F185*G185","v":0}]
[]
[367,"F2.2.4",null,"110mm x 63mm diameter for uPVC Pipes","No",10,null,{"$f":"F187*G187","v":0}]
[]
[368,"F2.2.5",null,"110mm x 75mm diameter for uPVC Pipes","No",10,null,{"$f":"F189*G189","v":0}]
[]
[369,"F2.2.6",null,"110mm x 90mm diameter for uPVC Pipes","No",10,null,{"$f":"F191*G191","v":0}]
[]
[370,"F2.2.7",null,"160mm x 63mm diameter for uPVC Pipes","No",10,null,{"$f":"F193*G193","v":0}]
[]
[371,"F2.2.8",null,"160mm x 75mm diameter for uPVC Pipes","No",10,null,{"$f":"F195*G195","v":0}]
[]
[372,"F2.2.9",null,"160mm x 90mm diameter for uPVC Pipes","No",10,null,{"$f":"F197*G197","v":0}]
[]
[373,"F2.2.10",null,"160mm x 110mm diameter for uPVC Pipes","No",10,null,{"$f":"F199*G199","v":0}]
[]
[374,"F2.2.11",null,"200mm x 75mm diameter for uPVC Pipes","No",10,null,{"$f":"F201*G201","v":0}]
[]
[375,"F2.2.12",null,"200mm x 90mm diameter for uPVC Pipes","No",10,null,{"$f":"F203*G203","v":0}]
[]
[376,"F2.2.13",null,"200mm x 110mm diameter for uPVC Pipes","No",10,null,{"$f":"F205*G205","v":0}]
[]
[377,"F2.2.14",null,"200mm x 160mm diameter for uPVC Pipes","No",10,null,{"$f":"F207*G207","v":0}]
[]
[378,"F2.2.15",null,"250mm x 90mm diameter for uPVC Pipes","No",10,null,{"$f":"F209*G209","v":0}]
[]
[379,"F2.2.16",null,"250mm x 110mm diameter for uPVC Pipes","No",10,null,{"$f":"F211*G211","v":0}]
[]
[380,"F2.2.17",null,"250mm x 160mm diameter for uPVC Pipes","No",10,null,{"$f":"F213*G213","v":0}]
[]
[381,"F2.2.18",null,"250mm x 200mm diameter for uPVC Pipes","No",10,null,{"$f":"F215*G215","v":0}]
[]
[382,"F2.2.19",null,"315mm x 110mm diameter for uPVC Pipes","No",10,null,{"$f":"F217*G217","v":0}]
[]
[383,"F2.2.20",null,"315mm x 160mm diameter for uPVC Pipes","No",10,null,{"$f":"F219*G219","v":0}]
[]
[384,"F2.2.21",null,"315mm x 200mm diameter for uPVC Pipes","No",10,null,{"$f":"F221*G221","v":0}]
[]
[385,"F2.2.22",null,"315mm x 250mm diameter for uPVC Pipes","No",10,null,{"$f":"F223*G223","v":0}]
[]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H155:H229)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H230","v":0}]
[]
[386,"F2.2.23",null,"355mm x 160mm diameter for uPVC Pipes","No",10,null,{"$f":"F237*G237","v":0}]
[]
[387,"F2.2.24",null,"355mm x 200mm diameter for uPVC Pipes","No",10,null,{"$f":"F239*G239","v":0}]
[]
[388,"F2.2.25",null,"355mm x 250mm diameter for uPVC Pipes","No",10,null,{"$f":"F241*G241","v":0}]
[]
[389,"F2.2.26",null,"355mm x 315mm diameter for uPVC Pipes","No",10,null,{"$f":"F243*G243","v":0}]
[]
[390,"F2.2.27",null,"400mm x 200mm diameter for uPVC Pipes","No",10,null,{"$f":"F245*G245","v":0}]
[]
[391,"F2.2.28",null,"400mm x 250mm diameter for uPVC Pipes","No",10,null,{"$f":"F247*G247","v":0}]
[]
[392,"F2.2.29",null,"400mm x 315mm diameter for uPVC Pipes","No",10,null,{"$f":"F249*G249","v":0}]
[]
[393,"F2.2.30",null,"400mm x 355mm diameter for uPVC Pipes","No",10,null,{"$f":"F251*G251","v":0}]
[]
[394,"F2.3","8.2.2","Cast Iron T-pieces (Class 16)"]
[]
[395,"F2.3.1",null,"63mm x 63mm diameter for uPVC Pipes","No",10,null,{"$f":"F255*G255","v":0}]
[]
[396,"F2.3.2",null,"75mm x 75mm diameter uPVC Pipes","No",10,null,{"$f":"F257*G257","v":0}]
[]
[397,"F2.3.3",null,"90mm x 90mm diameter uPVC Pipes","No",10,null,{"$f":"F259*G259","v":0}]
[]
[398,"F2.3.4",null,"110mm x 110mm diameter uPVC Pipes","No",10,null,{"$f":"F261*G261","v":0}]
[]
[399,"F2.3.5",null,"160mm x 160mm diameter uPVC Pipes","No",10,null,{"$f":"F263*G263","v":0}]
[]
[400,"F2.3.6",null,"200mm x 200mm diameter uPVC Pipes","No",10,null,{"$f":"F265*G265","v":0}]
[]
[401,"F2.3.7",null,"250mm x 250mm diameter uPVC Pipes","No",10,null,{"$f":"F267*G267","v":0}]
[]
[402,"F2.3.8",null,"315mm x 315mm diameter uPVC Pipes","No",10,null,{"$f":"F269*G269","v":0}]
[]
[403,"F2.3.9",null,"355mm x 355mm diameter uPVC Pipes","No",10,null,{"$f":"F271*G271","v":0}]
[]
[404,"F2.3.10",null,"400mm x 400mm diameter uPVC Pipes","No",10,null,{"$f":"F273*G273","v":0}]
[]
[405,"F2.4","8.2.2","Cast Iron Reducers (Class 16)"]
[]
[406,"F2.4.1",null,"75mm to 63mm diameter for uPVC Pipes","No",10,null,{"$f":"F277*G277","v":0}]
[]
[407,"F2.4.2",null,"90mm to 63mm diameter for uPVC Pipes","No",10,null,{"$f":"F279*G279","v":0}]
[]
[408,"F2.4.3",null,"90mm to 75mm diameter for uPVC Pipes","No",10,null,{"$f":"F281*G281","v":0}]
[]
[409,"F2.4.4",null,"110mm to 63mm diameter for uPVC Pipes","No",10,null,{"$f":"F283*G283","v":0}]
[]
[410,"F2.4.5",null,"110mm to 75mm diameter for uPVC Pipes","No",10,null,{"$f":"F285*G285","v":0}]
[]
[411,"F2.4.6",null,"110mm to 90mm diameter for uPVC Pipes","No",10,null,{"$f":"F287*G287","v":0}]
[]
[412,"F2.4.7",null,"160mm to 90mm diameter for uPVC Pipes","No",10,null,{"$f":"F289*G289","v":0}]
[]
[413,"F2.4.8",null,"160mm to 110mm diameter for uPVC Pipes","No",10,null,{"$f":"F291*G291","v":0}]
[]
[414,"F2.4.9",null,"200mm to 110mm diameter for uPVC Pipes","No",10,null,{"$f":"F293*G293","v":0}]
[]
[415,"F2.4.10",null,"200mm to 160mm diameter for uPVC Pipes","No",10,null,{"$f":"F295*G295","v":0}]
[]
[416,"F2.4.11",null,"250mm to 160mm diameter for uPVC Pipes","No",10,null,{"$f":"F297*G297","v":0}]
[]
[417,"F2.4.12",null,"250mm to 200mm diameter for uPVC Pipes","No",10,null,{"$f":"F299*G299","v":0}]
[]
[418,"F2.4.13",null,"315mm to 200mm diameter for uPVC Pipes","No",10,null,{"$f":"F301*G301","v":0}]
[]
[419,"F2.4.14",null,"315mm to 250mm diameter for uPVC Pipes","No",10,null,{"$f":"F303*G303","v":0}]
[]
[420,"F2.4.15",null,"315mm to 250mm diameter for uPVC Pipes","No",10,null,{"$f":"F305*G305","v":0}]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H235:H309)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H310","v":0}]
[]
[421,"F2.4.16",null,"355mm to 200mm diameter for uPVC Pipes","No",10,null,{"$f":"F317*G317","v":0}]
[]
[422,"F2.4.17",null,"355mm to 250mm diameter for uPVC Pipes","No",10,null,{"$f":"F319*G319","v":0}]
[]
[423,"F2.4.18",null,"355mm to 315mm diameter for uPVC Pipes","No",10,null,{"$f":"F321*G321","v":0}]
[]
[424,"F2.4.19",null,"400mm to 200mm diameter for uPVC Pipes","No",10,null,{"$f":"F323*G323","v":0}]
[]
[425,"F2.4.20",null,"400mm to 250mm diameter for uPVC Pipes","No",10,null,{"$f":"F325*G325","v":0}]
[]
[426,"F2.4.21",null,"400mm to 315mm diameter for uPVC Pipes","No",10,null,{"$f":"F327*G327","v":0}]
[]
[427,"F2.4.22",null,"400mm to 355mm diameter for uPVC Pipes","No",10,null,{"$f":"F329*G329","v":0}]
[]
[428,"F2.5","8.2.2","Cast Iron End Caps for uPVC Pipes (Class 16)"]
[]
[429,"F2.5.1",null,"63mm diameter","No.",10,null,{"$f":"F333*G333","v":0}]
[]
[430,"F2.5.2",null,"75mm diameter ","No.",10,null,{"$f":"F335*G335","v":0}]
[]
[431,"F2.5.3",null,"90mm diameter ","No.",10,null,{"$f":"F337*G337","v":0}]
[]
[432,"F2.5.4",null,"110mm diameter","No.",10,null,{"$f":"F339*G339","v":0}]
[]
[433,"F2.5.5",null,"160mm diameter ","No.",10,null,{"$f":"F341*G341","v":0}]
[]
[434,"F2.5.6",null,"200mm diameter","No.",10,null,{"$f":"F343*G343","v":0}]
[]
[435,"F2.5.7",null,"250mm diameter ","No.",10,null,{"$f":"F345*G345","v":0}]
[]
[436,"F2.5.8",null,"315mm diameter","No.",10,null,{"$f":"F347*G347","v":0}]
[]
[437,"F2.5.9",null,"355mm diameter","No.",10,null,{"$f":"F349*G349","v":0}]
[]
[438,"F2.5.10",null,"400mm diameter","No.",10,null,{"$f":"F351*G351","v":0}]
[]
[439,"F2.6","8.2.2","Cast Iron Flange Adaptors for uPVC Pipes (Class 16)"]
[]
[440,"F2.6.1",null,"63mm diameter","No.",10,null,{"$f":"F355*G355","v":0}]
[]
[441,"F2.6.2",null,"75mm diameter ","No.",10,null,{"$f":"F357*G357","v":0}]
[]
[442,"F2.6.3",null,"90mm diameter ","No.",10,null,{"$f":"F359*G359","v":0}]
[]
[443,"F2.6.4",null,"110mm diameter","No.",10,null,{"$f":"F361*G361","v":0}]
[]
[444,"F2.6.5",null,"160mm diameter ","No.",10,null,{"$f":"F363*G363","v":0}]
[]
[445,"F2.6.6",null,"200mm diameter","No.",10,null,{"$f":"F365*G365","v":0}]
[]
[446,"F2.6.7",null,"250mm diameter ","No.",10,null,{"$f":"F367*G367","v":0}]
[]
[447,"F2.6.8",null,"315mm diameter","No.",10,null,{"$f":"F369*G369","v":0}]
[]
[448,"F2.6.9",null,"355mm diameter","No.",10,null,{"$f":"F371*G371","v":0}]
[]
[449,"F2.6.10",null,"400mm diameter","No.",10,null,{"$f":"F373*G373","v":0}]
[]
[450,"F2.7","8.2.2","Couplings and Joints "]
[]
[451,"F2.7.1",null,"Flexible / dresser coupling 63 mm to 110 mm","No.",20,null,{"$f":"F377*G377","v":0}]
[]
[452,"F2.7.2",null,"Flexible / dresser coupling 160 mm to 250 mm","No.",20,null,{"$f":"F379*G379","v":0}]
[]
[453,"F2.7.3",null,"Flexible / dresser coupling 300 mm to 450 mm","No.",20,null,{"$f":"F381*G381","v":0}]
[]
[454,"F2.7.4",null,"Dismantling joint 80 mm to 150 mm","No.",20,null,{"$f":"F383*G383","v":0}]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H315:H388)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H389","v":0}]
[]
[455,"F2.7.5",null,"Dismantling joint 200 mm to 300 mm","No.",20,null,{"$f":"F396*G396","v":0}]
[]
[456,"F3","8.2.3","Valves\nExtra over 8.2.1 for supply (include materials) and install on concrete support, joint, include cutting of pipes where necessary and testing, complete with fittings, pipe work and couplings, where necessary."]
[]
[457,"F3.1",null,"AVK Socketed RS Gate Valves including all couplings for GMS, epoxy coated, flanged both ends to table 1600/3 on the following pipe diameter:"]
[]
[458,"F3.1.1",null,"63mm diameter","No.",10,null,{"$f":"F402*G402","v":0}]
[]
[459,"F3.1.2",null,"75mm diameter","No.",10,null,{"$f":"F404*G404","v":0}]
[]
[460,"F3.1.3",null,"90mm diameter","No.",10,null,{"$f":"F406*G406","v":0}]
[]
[461,"F3.1.4",null,"110mm diameter","No.",20,null,{"$f":"F408*G408","v":0}]
[]
[462,"F3.1.5",null,"160mm diameter","No.",20,null,{"$f":"F410*G410","v":0}]
[]
[463,"F3.1.6",null,"200mm diameter","No.",20,null,{"$f":"F412*G412","v":0}]
[]
[464,"F3.1.7",null,"250mm diameter","No.",20,null,{"$f":"F414*G414","v":0}]
[]
[465,"F3.1.8",null,"315mm diameter","No.",5,null,{"$f":"F416*G416","v":0}]
[]
[466,"F3.1.9",null,"355mm diameter","No.",5,null,{"$f":"F418*G418","v":0}]
[]
[467,"F3.1.10",null,"400mm diameter","No.",5,null,{"$f":"F420*G420","v":0}]
[]
[468,"F3.2","8.2.3","Fire Hydrants"]
[]
[469,"F3.2.1",null,"AVK London Round Tread Fire hydrant complete with T-pieces and extensions on uPVC pipes as per detail drawings issued"]
[]
[470,"F3.2.1.1",null,"Installed on 63mm diameter pipe","No.",20,null,{"$f":"F426*G426","v":0}]
[]
[471,"F3.2.1.2",null,"Installed on 75mm diameter pipe","No.",20,null,{"$f":"F428*G428","v":0}]
[]
[472,"F3.2.1.3",null,"Installed on 90mm diameter pipe","No.",20,null,{"$f":"F430*G430","v":0}]
[]
[473,"F3.2.1.4",null,"Installed on 110mm diameter pipe","No.",20,null,{"$f":"F432*G432","v":0}]
[]
[474,"F3.2.1.5",null,"Installed on 160mm diameter pipe","No.",20,null,{"$f":"F434*G434","v":0}]
[]
[475,"F3.2.1.6",null,"Installed on 200mm diameter pipe","No.",20,null,{"$f":"F436*G436","v":0}]
[]
[476,"F3.2.1.7",null,"Installed on 250mm diameter pipe","No.",20,null,{"$f":"F438*G438","v":0}]
[]
[477,"F3.2.1.8",null,"Installed on 315mm diameter pipe","No.",20,null,{"$f":"F440*G440","v":0}]
[]
[478,"F3.2.1.9",null,"Installed on 355mm diameter pipe","No.",20,null,{"$f":"F442*G442","v":0}]
[]
[479,"F3.2.1.10",null,"Installed on 400mm diameter pipe","No.",20,null,{"$f":"F444*G444","v":0}]
[]
[480,"F3.2.2","8.2.3","Butterfly Valve"]
[]
[481,"F3.2.2.1",null,"250mm diameter","No.",5,null,{"$f":"F448*G448","v":0}]
[]
[482,"F3.2.2.2",null,"315mm diameter","No.",5,null,{"$f":"F450*G450","v":0}]
[]
[483,"F3.2.2.3",null,"355mm diameter","No.",5,null,{"$f":"F452*G452","v":0}]
[]
[484,"F3.2.2.4",null,"400mm diameter","No.",5,null,{"$f":"F454*G454","v":0}]
[]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H394:H460)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H461","v":0}]
[]
[485,"F3.2.3","8.2.3","Air-Valves"]
[]
[486,"F3.2.3.1",null,"DN Ø 160mm PVC-O to DN Ø 176mm Cast Iron Mechnical Coupling","No.",3,null,{"$f":"F470*G470","v":0}]
[]
[487,"F3.2.3.2",null,"DN Ø 200mm PVC-O to DN Ø 220mm Cast Iron Mechnical Coupling","No.",3,null,{"$f":"F472*G472","v":0}]
[]
[488,"F3.2.3.3",null,"DN Ø 250mm PVC-O to DN Ø 250mm Cast Iron Mechnical Coupling","No.",3,null,{"$f":"F474*G474","v":0}]
[]
[489,"F3.2.3.4",null,"DN Ø 315mm PVC-O to DN Ø 300mm Cast Iron Mechnical Coupling","No.",3,null,{"$f":"F476*G476","v":0}]
[]
[490,"F3.2.3.5",null,"DN Ø 355mm PVC-O to DN Ø 350mm Cast Iron Mechnical Coupling","No.",3,null,{"$f":"F478*G478","v":0}]
[]
[491,"F3.2.3.6",null,"DN Ø 400mm PVC-O to DN Ø 400mm Cast Iron Mechnical Coupling","No.",3,null,{"$f":"F480*G480","v":0}]
[]
[492,"F3.2.3.7",null,"DN Ø 160mm x 360mm x 6 mm Wall Thickness Welded Air Collection Chamber","No.",3,null,{"$f":"F482*G482","v":0}]
[]
[493,"F3.2.3.8",null,"DN Ø 200mm x 420mm x 6 mm Wall Thickness Welded Air Collection Chamber","No.",3,null,{"$f":"F484*G484","v":0}]
[]
[494,"F3.2.3.9",null,"DN Ø 315mm x 420mm x 8 mm Wall Thickness Welded Air Collection Chamber","No.",3,null,{"$f":"F486*G486","v":0}]
[]
[495,"F3.2.3.10",null,"DN Ø 355mm x 450mm x 8.5 mm Wall Thickness Welded Air Collection Chamber","No.",3,null,{"$f":"F488*G488","v":0}]
[]
[496,"F3.2.3.11",null,"DN Ø 400mm x 500mm x 9.5 mm Wall Thickness Welded Air Collection Chamber","No.",3,null,{"$f":"F490*G490","v":0}]
[]
[497,"F3.2.3.12",null,"DN Ø 80mm Pipe x 200mm Long Double Flange with Flange to Suite Ø 80mm pipe one  end and Flanged to Suit Ø 350mm pipe on the Other end","No.",18,null,{"$f":"G492*F492","v":0}]
[]
[498,"F3.2.3.13",null,"DN Ø 80mm Wedge Gate Valve with Rising Spindle Flanged Both Ends to SANS 1123 Table 2500/3 (R/F)","No.",18,null,{"$f":"G494*F494","v":0}]
[]
[499,"F3.2.3.14",null,"DN Ø 50mm Combination Air-valve for High Flow Non-Slam double acting air valve class 16 ARI D-020 or similar approved suitable for final sewer effluent ","No.",18,null,{"$f":"G496*F496","v":0}]
[]
[500,"F3.2.4","8.2.3","Scour Valves"]
[]
[501,"F3.2.4.1",null,"Ø 200mm Mechnical Coupling Adaptor Flanged to one end to SANS 1123 Table 2500/3 (R/F)","No.",4,null,{"$f":"G500*F500","v":0}]
[]
[502,"F3.2.4.2",null,"DN Ø 200mm x DN Ø 80mm Special Reducing Tee","No.",2,null,{"$f":"G502*F502","v":0}]
[]
[503,"F3.2.4.3",null,"Ø 250mm Mechnical Coupling Adaptor Flanged to one end to SANS 1123 Table 2500/3 (R/F)","No.",4,null,{"$f":"G504*F504","v":0}]
[]
[504,"F3.2.4.4",null,"DN Ø 250mm x DN Ø 80mm Special Reducing Tee","No.",2,null,{"$f":"G506*F506","v":0}]
[]
[505,"F3.2.4.5",null,"Ø 315mm Mechnical Coupling Adaptor Flanged to one end to SANS 1123 Table 2500/3 (R/F)","No.",4,null,{"$f":"G508*F508","v":0}]
[]
[506,"F3.2.4.6",null,"DN Ø 315mm x DN Ø 80mm Special Reducing Tee","No.",2,null,{"$f":"G510*F510","v":0}]
[]
[507,"F3.2.4.7",null,"Ø 355mm Mechnical Coupling Adaptor Flanged to one end to SANS 1123 Table 2500/3 (R/F)","No.",4,null,{"$f":"G512*F512","v":0}]
[]
[508,"F3.2.4.8",null,"DN Ø 355mm x DN Ø 80mm Special Reducing Tee","No.",2,null,{"$f":"G514*F514","v":0}]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H466:H518)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H519","v":0}]
[]
[509,"F3.2.4.9",null,"Ø 400mm Mechnical Coupling Adaptor Flanged to one end to SANS 1123 Table 2500/3 (R/F)","No.",4,null,{"$f":"G526*F526","v":0}]
[]
[510,"F3.2.4.10",null,"DN Ø 400mm x DN Ø 80mm Special Reducing Tee","No.",2,null,{"$f":"G528*F528","v":0}]
[]
[511,"F3.2.4.11",null,"DN Ø80mm x 3.9mm Pipe Spool SANS 62 Medium Duty Plain Ended","No.",10,null,{"$f":"G530*F530","v":0}]
[]
[512,"F3.2.4.12",null,"DN Ø80mm Segmented Bend Plain Ended","No.",10,null,{"$f":"G532*F532","v":0}]
[]
[513,"F3.2.4.13",null,"DN Ø80mm x 3.9mm Pipe Spool SANS 62 Medium Duty Flanged to One End to SANS 1123 Table 2500/3 (R/F) with Puddle Flange","No.",10,null,{"$f":"G534*F534","v":0}]
[]
[514,"F3.2.4.14",null,"DN Ø80mm Wedge Gate Valve with Rising Spindle Flanged Both Ends to SANS 1123 Table 2500/3 (R/F)","No.",10,null,{"$f":"G536*F536","v":0}]
[]
[515,"F3.2.4.15",null,"DN Ø80mm Restrained Dismantling joint Flanged to both end to SANS 1123 Table 2500/3","No.",10,null,{"$f":"G538*F538","v":0}]
[]
[516,"F3.2.4.16",null,"DN Ø80mm x 3.9mm Pipe Spool SANS 62 Medium Duty Flanged Both Ends to SANS 1123 Table 2500/3 (R/F) with  Steek Pipe Support Approximate Length 800mm","No.",10,null,{"$f":"G540*F540","v":0}]
[]
[517,"F3.2.4.17",null,"DN Ø 80mm Orifice Plate for Orifice Detail","No.",10,null,{"$f":"G542*F542","v":0}]
[]
[518,"F3.2.4.18",null,"DN Ø80mm x 3.9mm Pipe Spool SANS 62 Medium Duty Flanged Both Ends to SANS 1123 Table 2500/3 (R/F) with  Puddle Flange Approximate Length 1000mm","No.",10,null,{"$f":"G544*F544","v":0}]
[]
[519,"F3.2.4.19",null,"DN Ø80mm x DN Ø50mm Concentric Reducer Flanged One End to SANS 1123 Table 2500/3 (R/F)","No.",10,null,{"$f":"G546*F546","v":0}]
[]
[520,"F3.2.4.20",null,"Mild steel orifice plate assembly complete with carrier ring, flanges, gaskets and bolts, tested","No.",10,null,{"$f":"G548*F548","v":0}]
[]
[521,"F3.2.5","8.2.3","Altitude / level control valve, Bermad or similar approved type, complete with pilot set and isolating valves for the following diameters"]
[]
[522,"F3.2.5.1",null,"250mm diameter","No.",1,null,{"$f":"G552*F552","v":0}]
[]
[523,"F3.2.5.2",null,"315mm diameter","No.",1,null,{"$f":"G554*F554","v":0}]
[]
[524,"F3.2.5.3",null,"355mm diameter","No.",1,null,{"$f":"G556*F556","v":0}]
[]
[525,"F3.2.5.4",null,"400mm diameter","No.",1,null,{"$f":"G558*F558","v":0}]
[]
[526,"F4","8.2.2","OTHER PIPE MATERIALS"]
[]
[527,"F4.1",null,"110 mm dia HDPE PE100 PN16 pipe complete","m",10,null,{"$f":"G562*F562","v":0}]
[]
[528,"F4.2",null,"160 mm dia HDPE PE100 PN16 pipe complete","m",10,null,{"$f":"G564*F564","v":0}]
[]
[529,"F4.3",null,"150 mm dia DI K9 pipe complete","m",10,null,{"$f":"G566*F566","v":0}]
[]
[530,"F4.4",null,"Supply and install fabricated steel pipe replacement complete with 250 micron Copon 891 internal coated and  Copon 134 75 micron exterior coated flanged steel pipes to SANS 1123 Table 1600/3 including all elbows, bends, pipe clamps, testing and disinfecting"]
[]
[531,"F4.4.1",null,"DN 200 Steel Pipe","m",18,null,{"$f":"G570*F570","v":0}]
[]
[532,"F4.4.2",null,"DN 250 Steel Pipe","m",18,null,{"$f":"G572*F572","v":0}]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H524:H577)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H578","v":0}]
[]
[533,"F4.4.3",null,"DN 300 Steel Pipe","m",18,null,{"$f":"G585*F585","v":0}]
[]
[534,"F4.4.4",null,"DN 350 Steel Pipe","m",18,null,{"$f":"G587*F587","v":0}]
[]
[535,"F4.4.5",null,"DN 400 Steel Pipe","m",18,null,{"$f":"G589*F589","v":0}]
[]
[536,"F5",null,"ANCILLARIES"]
[]
[537,"F5.1","8.2.5","Supplying And Fixing Of Pipes ","No.",10,null,{"$f":"F593*G593","v":0}]
[]
[538,"F5.2","8.2.10","Temporary valves, etc.","No.",10,null,{"$f":"F595*G595","v":0}]
[]
[539,"F5.3"," PSL8.2.11","Anchor/thrust blocks, transverse anchor blocks and vertical anchor blocks as per detail drawings issued","m³",80,null,{"$f":"F597*G597","v":0}]
[]
[540,"F5.4","8.2.12","Concrete encasing of pipes with grade 15/19 Mpa concrete, complete","m³",25,null,{"$f":"F599*G599","v":0}]
[]
[541,"F6","8.2.13","VALVE CHAMBERS AND MANHOLES"]
[]
[542,"F6.1",null,"Gate valve chambers complete as shown on detail drawings issued, for a depth of up to 1.5m.","No.",20,null,{"$f":"F603*G603","v":0}]
[]
[543,"F6.2",null,"Fire hydrant chambers complete as shown on detail drawings issued","No.",20,null,{"$f":"F605*G605","v":0}]
[]
[544,"F7",null,"SUNDRIES"]
[]
[545,"F7.1","PSL 8.2.16","Connect to existing AC or uPVC Pipes, include materials, cutting of pipe to length where required, testing an disinfecting, complete with necessary couplings:"]
[]
[546,"F7.1.1",null,"63mm diameter uPVC","No",10,null,{"$f":"F611*G611","v":0}]
[]
[547,"F7.1.2",null,"75mm diameter uPVC","No",10,null,{"$f":"F613*G613","v":0}]
[]
[548,"F7.1.3",null,"90mm diameter uPVC","No",10,null,{"$f":"F615*G615","v":0}]
[]
[549,"F7.1.4",null,"110mm diameter uPVC","No",10,null,{"$f":"F617*G617","v":0}]
[]
[550,"F7.1.5",null,"160mm diameter uPVC","No",10,null,{"$f":"F619*G619","v":0}]
[]
[551,"F7.1.6",null,"200mm diameter uPVC","No",10,null,{"$f":"F621*G621","v":0}]
[]
[552,"F7.1.7",null,"250mm diameter uPVC","No",10,null,{"$f":"F623*G623","v":0}]
[]
[553,"F7.1.8",null,"315mm diameter uPVC","No",10,null,{"$f":"F625*G625","v":0}]
[]
[554,"F7.1.9",null,"355mm diameter uPVC","No",10,null,{"$f":"F627*G627","v":0}]
[]
[555,"F7.2",null,"Removal of existing structures"]
[]
[556,"F7.2.1",null,"Gate valves","No",10,null,{"$f":"F631*G631","v":0}]
[]
[557,"F7.2.2",null,"Fire hydrant","No",10,null,{"$f":"F633*G633","v":0}]
[]
[558,"F7.2.3",null,"Valve / fire hydrant markers","No",10,null,{"$f":"F635*G635","v":0}]
[]
[559,"F7.3",null,"Markers:"]
[]
[560,"F7.3.1",null,"Valve and fire hydrant markers complete and installed.","No",10,null,{"$f":"F639*G639","v":0}]
[]
[561,"F8","SANS 1200 LF","ERF CONNECTIONS (WATER)"]
[]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H583:H647)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H648","v":0}]
[]
[562,"F8.1","8.2.2","Supply (include materials), lay and bed type IV PN 12.5 HDPE pipes on Class C bedding, complete with couplings, test and disinfect the following pipes:"]
[]
[563,"F8.1.1",null,"20mm diameter","m",100,null,{"$f":"F657*G657","v":0}]
[]
[564,"F8.1.2",null,"25mm diameter","m",100,null,{"$f":"F659*G659","v":0}]
[]
[565,"F8.1.3",null,"32mm diameter","m",100,null,{"$f":"F661*G661","v":0}]
[]
[566,"F8.1.4",null,"40mm diameter","m",100,null,{"$f":"F663*G663","v":0}]
[]
[567,"F8.2","8.2.3","Extra over Item 8.2.2 for specials\nSupply (include materials) and install saddles for type IV HDPE pipes on uPVC main pipes."]
[]
[568,"F8.2.1",null,"20mm on 75mm diameter","No.",10,null,{"$f":"F667*G667","v":0}]
[]
[569,"F8.2.2",null,"25mm on 75mm diameter","No.",10,null,{"$f":"F669*G669","v":0}]
[]
[570,"F8.2.3",null,"32mm on 75mm diameter","No.",10,null,{"$f":"F671*G671","v":0}]
[]
[571,"F8.2.4",null,"40mm on 75mm diameter","No.",10,null,{"$f":"F673*G673","v":0}]
[]
[572,"F8.2.5",null,"25mm on 90mm diameter","No",10,null,{"$f":"F675*G675","v":0}]
[]
[573,"F8.2.6",null,"32mm on 90mm diameter","No",10,null,{"$f":"F677*G677","v":0}]
[]
[574,"F8.2.7",null,"40mm on 90mm diameter","No.",10,null,{"$f":"F679*G679","v":0}]
[]
[575,"F8.2.8",null,"25mm on 110mm diameter","No.",10,null,{"$f":"F681*G681","v":0}]
[]
[576,"F8.2.9",null,"32mm on 110mm diameter","No.",10,null,{"$f":"F683*G683","v":0}]
[]
[577,"F8.2.10",null,"40mm on 110mm diameter","No.",10,null,{"$f":"F685*G685","v":0}]
[]
[578,"F8.3","8.2.3","Lockable ferrules for type IV HDPE pipes:"]
[]
[579,"F8.3.1",null,"20mm diameter","No.",10,null,{"$f":"F689*G689","v":0}]
[]
[580,"F8.3.2",null,"25mm diameter","No.",10,null,{"$f":"F691*G691","v":0}]
[]
[581,"F8.3.3",null,"32mm diameter","No.",10,null,{"$f":"F693*G693","v":0}]
[]
[582,"F8.3.4",null,"40mm diameter","No.",10,null,{"$f":"F695*G695","v":0}]
[]
[583,"F8.4","8.2.3","Male elbows for type IV HDPE pipes:"]
[]
[584,"F8.4.1",null,"20mm x 1/2\" diameter","No.",10,null,{"$f":"F699*G699","v":0}]
[]
[585,"F8.4.2",null,"25mm x 3/4\" diameter","No.",10,null,{"$f":"F701*G701","v":0}]
[]
[586,"F8.4.3",null,"32mm x 1\" diameter","No.",10,null,{"$f":"F703*G703","v":0}]
[]
[587,"F8.4.4",null,"40mm x 1\" diameter","No.",10,null,{"$f":"F705*G705","v":0}]
[]
[588,"F8.5","8.2.3","Supply (include material) and install tees with female thread branch for type IV HDPE pipe"]
[]
[589,"F8.5.1",null,"32mm x 1 1/4\" diameter","No.",10,null,{"$f":"F709*G709","v":0}]
[]
[590,"F8.6","8.2.3","Male adaptors for type IV HDPE pipes"]
[]
[591,"F8.6.1",null,"25mm x 1 3/4\" diameter","No.",10,null,{"$f":"F713*G713","v":0}]
[]
[592,"F8.7","8.2.3","Multi reducers for type IV HDPE pipes"]
[]
[593,"F8.7.1",null,"32mm on 25mm diameter","No",10,null,{"$f":"F717*G717","v":0}]
[]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H653:H722)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H723","v":0}]
[]
[594,"F8.8","8.2.3","End caps for type IV HDPE pipes"]
[]
[595,"F8.8.1",null,"20mm diameter","No",10,null,{"$f":"F732*G732","v":0}]
[]
[596,"F8.8.2",null,"25mm diameter","No",10,null,{"$f":"F734*G734","v":0}]
[]
[597,"F8.8.3",null,"32mm diameter","No",10,null,{"$f":"F736*G736","v":0}]
[]
[598,"F9",null,"WATER METERS"]
[]
[599,"F9.1","8.2.4","Supply (include materials) Kent meters, or similar approved. The rate shall cover all fittings and labour to install the meter in the existing meter chamber for the following diamters:"]
[]
[600,"F9.1.1",null,"20mm","No",2,null,{"$f":"F742*G742","v":0}]
[]
[601,"F9.1.2",null,"25mm","No",2,null,{"$f":"F744*G744","v":0}]
[]
[602,"F9.1.3",null,"32mm","No",2,null,{"$f":"F746*G746","v":0}]
[]
[603,"F9.1.4",null,"50mm","No",2,null,{"$f":"F748*G748","v":0}]
[]
[604,"F9.1.5",null,"65mm","No",2,null,{"$f":"F750*G750","v":0}]
[]
[605,"F9.1.6",null,"80mm","No",2,null,{"$f":"F752*G752","v":0}]
[]
[606,"F10",null,"SUNDRIES"]
[]
[607,"F10.1","PS L 8.2.16","Cut Into And Connect To Existing Mains "]
[]
[608,"F10.1.1",null,"Connecting to existing water meters at erven. Rate to include all labour, plant and material including all notices to home owners and businesses and co-ordination of temporary water cut-offs during connection to new supply pipe.","No.",50,null,{"$f":"F758*G758","v":0}]
[]
[609,"F10.1.2",null,"Connecting to existing house connection at erven. Rate to include all labour, plant and material including all notices to home owners and businesses and co-ordination of temporary water cut-offs during connection to new supply pipe.","No.",50,null,{"$f":"F760*G760","v":0}]
[]
[610,"F10.2",null,"Pipeline marker posts, complete as shown on detail drawings issued","No.",50,null,{"$f":"F762*G762","v":0}]
[]
[611,"F10.3",null,"Selected backfilling with soilcrete under roads and walkways or where instructed by Engineer","m³",20,null,{"$f":"F764*G764","v":0}]
[]
[612,"F11","8.2.2","CLAMP REPAIRS AND CUT-OUTS"]
[]
[613,"F11.1",null,"Repair clamp complete for pipe diameter up to 110 mm","No.",10,null,{"$f":"F768*G768","v":0}]
[]
[614,"F11.2",null,"Repair clamp complete for pipe diameter 160 mm to 250 mm","No.",10,null,{"$f":"F770*G770","v":0}]
[]
[615,"F11.3",null,"Repair clamp complete for pipe diameter 300 mm to 450 mm","No.",10,null,{"$f":"F772*G772","v":0}]
[]
[616,"F11.4",null,"Repair clamp complete for pipe diameter above 450 mm","No.",10,null,{"$f":"F774*G774","v":0}]
[]
[617,"F11.5",null,"Cut out defective section and replace pipe up to 110 mm complete with couplings and all incidentals","No.",20,null,{"$f":"F776*G776","v":0}]
[]
[618,"F11.6",null,"Cut out defective section and replace pipe 160 mm to 250 mm complete with couplings and all incidentals","No.",20,null,{"$f":"F778*G778","v":0}]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H728:H782)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION F"]
[{"$nulls":4},"MEDIUM PRESSURE PIPELINES"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H783","v":0}]
[]
[619,"F11.7",null,"Cut out defective section and replace pipe 300 mm to 450 mm complete with couplings and all incidentals","No.",20,null,{"$f":"F790*G790","v":0}]
[]
[620,"F11.8",null,"Cut out defective section and replace pipe above 450 mm complete with couplings and all incidentals","No.",20,null,{"$f":"F792*G792","v":0}]
[]
[621,"F12","8.2.14(a)","PRECAST CHAMBERS FOR ALL TYPES OF VALVES"]
[]
[622,"F12.1",null,"Precast chamber complete including support brickwork, concrete foundations and insitu casted concrete slab","No.",10,null,{"$f":"G796*F796","v":0}]
[]
[623,"F12.2","8.2.14(b)","Extra-over for all types of valve chambers of depth exceeding 1.5m"]
[]
[624,"F12.2.1",null,"Air-release valve chamber (precast)","No.",5,null,{"$f":"G800*F800","v":0}]
{"$rows_empty":56}
["TSF","TOTAL SECTION F CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H788:H856)","v":0}]

{"sheet":"G","index":7,"n_rows":148,"n_cols":8,"rows_kept":148,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7],[69,1,71,3],[69,4,69,7],[70,4,71,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION G"]
[{"$nulls":4},"CONCRETE (SMALL WORKS)"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[625,"G","SANS 1200GA\n","SECTION G: CONCRETE (SMALL WORKS)"]
[]
[626,"G1",null,"Concrete Chamber for All Types of Valves"]
[]
[627,"G1.1","SANS 1200DB","Excavation"]
[]
[628,"G1.1.1","8.3.2(a)","Excavation for valve chambers in all materials, including hard rock","m³",66,null,{"$f":"G12*F12","v":0}]
[]
[629,"G1.1.2",null,"Level and Compact in-situ material on excavation bottom to 90% Mod. AASHTO in layer of 150mm","m²",35,null,{"$f":"G14*F14","v":0}]
[]
[630,"G1.1.3","SANS 1200DB 8.3.2(c)\n","Excavate and dispose of unsuitable material from excavation bottom","m³",23,null,{"$f":"G16*F16","v":0}]
[]
[631,"G1.1.4","8.3.3.1","Import selected G6 material obtained for commercial sources and compact in layers of 150mm thickness","m³",23,null,{"$f":"G18*F18","v":0}]
[]
[632,"G1.1.5",null,"19mm Crushed stone, 200m thick layer","m³",12,null,{"$f":"G20*F20","v":0}]
[]
[633,"G1.2","SANS 1200 GA 8.2\n","Rough Formwork"]
[]
[634,"G1.2.1","8.2.1","External faces of scour valve base including 20mm x 20mm chamfer to all vertical and horizonal edges","m²",6,null,{"$f":"G24*F24","v":0}]
[]
[635,"G1.3","8.2.2","Smooth Formwork"]
[]
[636,"G1.3.1",null,"Plane Horizontal Formwork"]
[]
[637,"G1.3.1.1",null,"Soffit of roof slab","m²",14,null,{"$f":"G30*F30","v":0}]
[]
[638,"G1.3.2",null,"Plane Vertical Formwork"]
[]
[639,"G1.3.2.1",null,"Internal faces of the scour valve","m²",56,null,{"$f":"G34*F34","v":0}]
[]
[640,"G1.3.2.2",null,"Exterior vertical faces including 20mm x 20mm chamfer to all vertical and horizonal edges","m²",26,null,{"$f":"G36*F36","v":0}]
[]
[641,"G1.4",8.4,"Concrete"]
[]
[642,"G1.4.1","8.4.2","50mm Class 15/19 Blinding layer for scour valve chamber","m³",2,null,{"$f":"G40*F40","v":0}]
[]
[643,"G1.5","8.4.3","Strength Concrete Class 30/19 Fast Curing"]
[]
[644,"G1.5.1",null,"Chamber floor","m³",5,null,{"$f":"G44*F44","v":0}]
[]
[645,"G1.5.2",null,"Chamber walls","m³",9,null,{"$f":"G46*F46","v":0}]
[]
[646,"G1.5.3",null,"Chamber roof slab","m³",2,null,{"$f":"G48*F48","v":0}]
[]
[647,"G1.6","8.3.1","Reinforcement "]
[]
[648,"G1.6.1",null,"Y10 High yield mild steel bars","t",{"v":0.1,"d":"0.10"},null,{"$f":"G52*F52","v":0}]
[]
[649,"G1.6.2",null,"Y12 High yield mild steel bars","t",{"v":0.72,"d":"0.720"},null,{"$f":"G54*F54","v":0}]
[]
[650,"G1.6.3",null,"Y16 High yield mild steel bars","t",{"v":0.1,"d":"0.10"},null,{"$f":"G56*F56","v":0}]
[]
[651,"G1.7","8.3.2","High tensile welded mesh"]
[]
[652,"G1.7.1",null,"Mesh Ref 617","m²",12,null,{"$f":"G60*F60","v":0}]
[]
[653,"G1.7.2",null,"Mesh Ref 888","m²",62,null,{"$f":"G62*F62","v":0}]
[]
[654,"G1.8","8.4.4","Unformed Surface Finishes"]
[]
[]
[]
[]
["TCF","TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H5:H68)","v":0}]
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION G"]
[{"$nulls":4},"CONCRETE (SMALL WORKS)"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["TBF","TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"H69","v":0}]
[]
[655,"G1.8.1",null,"Wood-floated finish","m²",10,null,{"$f":"G76*F76","v":0}]
[]
[656,"G2",null,"Manhole Covers"]
[]
[657,"G2.1",null,"Lockable Securex Y-560-C Ductile Iron Manhole Cover Class C250 or similar approved","No",10,null,{"$f":"G80*F80","v":0}]
{"$rows_empty":67}
["TSF","TOTAL SECTION G CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H74:H147)","v":0}]

{"sheet":"H","index":8,"n_rows":75,"n_cols":8,"rows_kept":75,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION H"]
[{"$nulls":4},"LEAK DETECTION"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[658,"H",null,"SECTION H: LEAK DETECTION"]
[]
[659,"H1","PSLD-1","Desktop review and prioritisation of suspected leak points / existing leak sheets","No.",90,null,{"$f":"F8*G8","v":0}]
[]
[660,"H2","PSLD-2","Visible leak inspection and confirmation","No.",100,null,{"$f":"F10*G10","v":0}]
[]
[661,"H3","PSLD-3","Acoustic leak detection survey on distribution / trunk mains","km",40,null,{"$f":"F12*G12","v":0}]
[]
[662,"H4","PSLD-4","Ground microphone / listening stick pinpointing at suspected leak location","No.",90,null,{"$f":"F14*G14","v":0}]
[]
[663,"H5","PSLD-5","Correlator-based leak detection and pinpointing","No.",50,null,{"$f":"F16*G16","v":0}]
[]
[664,"H6","PSLD-6","Noise logger deployment, retrieval and interpretation","Week",10,null,{"$f":"F18*G18","v":0}]
[]
[665,"H7","PSLD-7","Flow logging and night-flow assessment","Week",10,null,{"$f":"F20*G20","v":0}]
[]
[666,"H8","PSLD-8","Pressure logging and pressure profile assessment","Week",10,null,{"$f":"F22*G22","v":0}]
[]
[667,"H9","PSLD-9","Step test / zone isolation test","No.",10,null,{"$f":"F24*G24","v":0}]
[]
[668,"H10","PSLD-10","Reservoir drop test and leakage assessment","No.",10,null,{"$f":"F26*G26","v":0}]
[]
[669,"H11","PSLD-11","Pegging, marking and recording confirmed leak location with coordinates and photo","No.",90,null,{"$f":"F28*G28","v":0}]
{"$rows_empty":46}
["TSF","TOTAL SECTION H CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H5:H74)","v":0}]

{"sheet":"I","index":9,"n_rows":61,"n_cols":8,"rows_kept":61,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION I"]
[{"$nulls":4},"RESERVOIR SEALING AND WATERPROOFING"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[670,"I",null,"SECTION I: RESERVOIR SEALING AND WATERPROOFING"]
[]
[671,"I1",null,"Sealing and Waterproofing"]
[]
[672,"I1.1","PSRS-1","Prepare and seal leaking construction / movement joint in reservoir or chamber complete","m",150,null,{"$f":"F10*G10","v":0}]
[]
[673,"I1.2","PSRS-2","Inject and seal structural crack in water-retaining structure complete","m",100,null,{"$f":"F12*G12","v":0}]
[]
[674,"I1.3","PSRS-3","Apply two-component polymer-modified cementitious flexible waterproof coating, potable-water approved, in minimum two coats to 2.0 mm DFT on prepared surface complete","m²",500,null,{"$f":"F14*G14","v":0}]
[]
[675,"I1.4","PSRS-4","Supply and apply approved epoxy / polymer repair mortar to local defects, honeycombing or spalled concrete complete","m²",60,null,{"$f":"F16*G16","v":0}]
[]
[676,"I2",null,"Pipework, Valves and Accessories"]
[]
[677,"I2.1","PSRS-5","Repair leaking scour, overflow, inlet or outlet pipework at reservoir or chamber","No.",10,null,{"$f":"F20*G20","v":0}]
[]
[678,"I2.2","PSRS-6","Replace or refurbish altitude / float / level control valve, Bermad or similar approved type, complete","No.",10,null,{"$f":"F22*G22","v":0}]
[]
[679,"I2.3","PSRS-7","Repair / replace chamber floor drain, sump or drainage arrangement","No.",10,null,{"$f":"F24*G24","v":0}]
[]
[680,"I2.4","PSRS-8","Repair leaking hatch, roof slab penetration, vent or access detail complete","No.",10,null,{"$f":"F26*G26","v":0}]
[]
[681,"I3","SANS 1200 GA\n","Structural Repairs"]
[]
[682,"I3.1","8.4.3","Mass concrete 20 MPa / 19 mm nominal stone to chamber bases, plinths and minor works","m³",10,null,{"$f":"F30*G30","v":0}]
[]
[683,"I3.2","8.4.3","Reinforced concrete 25 MPa / 19 mm nominal stone to chamber walls, slabs and local repairs","m³",10,null,{"$f":"F32*G32","v":0}]
[]
[684,"I3.3","8.4.3","Reinforced concrete 30 MPa / 19 mm nominal stone to water-retaining structural repairs or new works","m³",10,null,{"$f":"F34*G34","v":0}]
[]
[685,"I3.4","8.3.1","High tensile reinforcement complete","t",4,null,{"$f":"F36*G36","v":0}]
[]
[686,"I3.5","8.2.2","Formwork Smooth to sides of concrete","m²",55,null,{"$f":"F38*G38","v":0}]
[]
[687,"I3.6","8.2.2","Formwork Smooth to soffits, slabs and beams","m²",30,null,{"$f":"F40*G40","v":0}]
[]
[688,"I3.7",8.7,"Non-shrink grout to baseplates, valve pedestals, plinths and similar works","m³",5,null,{"$f":"F42*G42","v":0}]
[]
[689,"I4",null,"Ancilliary Works"]
[]
[690,"I4.1","PSRS-16","Refurbish security fence, gate and lock arrangement at reservoir / chamber","Item",5,null,{"$f":"F46*G46","v":0}]
[]
[691,"I4.2","PSRS-17","Make good internal plaster / screed / fillet to wall-floor junctions complete","m",50,null,{"$f":"F48*G48","v":0}]
{"$rows_empty":12}
["TSF","TOTAL SECTION I CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H5:H60)","v":0}]

{"sheet":"J","index":10,"n_rows":71,"n_cols":8,"rows_kept":71,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION J"]
[{"$nulls":4},"METERING, ZONE CONTROL & TELEMETRY"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[692,"J",null,"SECTION J: METERING, ZONE CONTROL & TELEMETRY"]
[]
[693,"J1","PSMZ 1","Bulk and Zone Metering"]
[]
[694,"J1.1",null,"Supply and install electromagnetic bulk / zone flow meter 80 mm to 100 mm complete","No.",10,null,{"$f":"F10*G10","v":0}]
[]
[695,"J1.2",null,"Supply and install electromagnetic bulk / zone flow meter 150 mm to 200 mm complete","No.",10,null,{"$f":"F12*G12","v":0}]
[]
[696,"J1.3",null,"Supply and install electromagnetic bulk / zone flow meter 250 mm to 400 mm complete","No.",10,null,{"$f":"F14*G14","v":0}]
[]
[697,"J1.4","PSMZ-4","Replace faulty existing bulk meter complete","No.",10,null,{"$f":"F16*G16","v":0}]
[]
[698,"J1.5","PSMZ-5","Temporary clamp-on ultrasonic flow survey complete","Week",20,null,{"$f":"F18*G18","v":0}]
[]
[699,"J2",null,"Zone Control, Loggers and Telemetry"]
[]
[700,"J2.1","PSMZ-6","Pressure logger supplied, installed, downloaded and reported","Logger-week",40,null,{"$f":"F22*G22","v":0}]
[]
[701,"J2.2","PSMZ-7","Flow logger supplied, installed, downloaded and reported","Logger-week",30,null,{"$f":"F24*G24","v":0}]
[]
[702,"J2.3","PSMZ-8","RTU / telemetry panel upgrade or replacement at meter / reservoir / PRV site","No.",10,null,{"$f":"F26*G26","v":0}]
[]
[703,"J2.4","PSMZ-9","Solar power supply / battery backup for remote meter or telemetry site","No.",10,null,{"$f":"F28*G28","v":0}]
[]
[704,"J2.5","PSMZ-10","Zone meter chamber, spool pieces and isolation arrangement complete fer to typical detail drawing no 6253-PCE-???","No.",10,null,{"$f":"F30*G30","v":0}]
[]
[705,"J2.6","PSMZ-11","Calibration and commissioning of bulk / zone meter","No.",30,null,{"$f":"F32*G32","v":0}]
{"$rows_empty":38}
["TSF","TOTAL SECTION J CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H5:H70)","v":0}]

{"sheet":"K","index":11,"n_rows":74,"n_cols":8,"rows_kept":74,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION K"]
[{"$nulls":4},"TEMPORARY SUPPLY, TESTING & COMMISSIONING"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[706,"K",null,"SECTION K: TEMPORARY SUPPLY, TESTING & COMMISSIONING"]
[]
[707,"K1",null,"Tempory Supply and Shutdowns"]
[]
[708,"K1.1","PSTS-1","Shutdown planning, notices and operational coordination","Per Shutdown",30,null,{"$f":"F10*G10","v":0}]
[]
[709,"K1.2","PSTS-2","Valve isolation and controlled shutdown / re-opening operation","Per Event",60,null,{"$f":"F12*G12","v":0}]
[]
[710,"K1.3","PSTS-3","Temporary bypass pumping arrangement","Day",60,null,{"$f":"F14*G14","v":0}]
[]
[711,"K1.4","PSTS-4","Temporary overland hose / bypass line up to 100 mm","m-day",{"v":1000,"d":"1,000"},null,{"$f":"F16*G16","v":0}]
[]
[712,"K1.5","PSTS-5","Temporary overland hose / bypass line above 100 mm","m-day",500,null,{"$f":"F18*G18","v":0}]
[]
[713,"K2",null,"Testing, Disinfection and Handover"]
[]
[714,"K2.1","PSTS-6","Pressure test of repaired or replacement pipeline section","Per Test",30,null,{"$f":"F22*G22","v":0}]
[]
[715,"K2.2","PSTS-7","Flush, disinfect and commission repaired / replaced section","Per Event",30,null,{"$f":"F24*G24","v":0}]
[]
[716,"K2.3","PSTS-8","Water quality sampling and compliance confirmation after repair","No.",20,null,{"$f":"F26*G26","v":0}]
[]
[717,"K2.4","PSTS-9","Completion record including photographs, coordinates and asset update data","No.",100,null,{"$f":"F28*G28","v":0}]
{"$rows_empty":45}
["TSF","TOTAL SECTION K CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H5:H73)","v":0}]

{"sheet":"L","index":12,"n_rows":80,"n_cols":8,"rows_kept":80,"merged":[[0,1,2,3],[0,4,0,7],[1,4,2,7]]}
[null,{"$f":"ProjectTitle","v":"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA"},null,null,"SECTION L"]
[{"$nulls":4},"PROVISIONAL SUMS"]
[]
["UID","ITEM","PAY REFS","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[718,"L",null,"SECTION L: PROVISIONAL SUMS"]
[]
[719,"L1","SANS 1200A 8.5\n","Sum Stated Provisionally by Engineer"]
[]
[720,"L1.1",null,"Arrange for tests to be carried out, as required by the Engineer, by an accredited laboratory.","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"F10*G10","v":{"v":100000,"d":"R 100 000.00"}}]
[]
[721,"L1.2",null,"Overheads, charges and profit on item L1.1","%",{"v":100000,"d":"R100,000.00"},null,{"$f":"F12*G12","v":0}]
[]
[722,"L1.3",null," Engineer's accommodation and transportation charges","Prov. Sum",1,{"v":500000,"d":"R500,000.00"},{"$f":"F14*G14","v":{"v":500000,"d":"R 500 000.00"}}]
[]
[723,"L1.4",null,"Overheads, charges and profit over Item L1.3","%",{"v":500000,"d":"R500,000.00"},null,{"$f":"F16*G16","v":0}]
[]
[724,"L1.5",null,"Engineer's additional Monitoring and Quality Control Charges","Prov. Sum",1,{"v":300000,"d":"R300,000.00"},{"$f":"F18*G18","v":{"v":300000,"d":"R 300 000.00"}}]
[]
[725,"L1.6",null,"Overheads, charges and profit on item L1.5","%",{"v":300000,"d":"R300,000.00"},null,{"$f":"F20*G20","v":0}]
[]
[726,"L1.7","8.8.5","Trigonometrical Surveys and submission of survey data (.csv) and drawings (.dwg) in electroicnic format to the Engineers","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"F22*G22","v":{"v":100000,"d":"R 100 000.00"}}]
[]
[727,"L1.8",null,"Overheads, charges and profit on item L1.7","%",{"v":100000,"d":"R100,000.00"},null,{"$f":"F24*G24","v":0}]
[]
[728,"L1.9",null,"Provisional sum for specialist asbestos sampling, air monitoring and disposal oversight","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"F26*G26","v":{"v":100000,"d":"R 100 000.00"}}]
[]
[729,"L1.10",null,"Overheads, charges and profit on item L1.9","%",{"v":100000,"d":"R100,000.00"},null,{"$f":"F28*G28","v":0}]
[]
[730,"L1.11",null,"Provisional sum for specialist reservoir structural assessment and sealing design input","Prov. Sum",1,{"v":200000,"d":"R200,000.00"},{"$f":"F30*G30","v":{"v":200000,"d":"R 200 000.00"}}]
[]
[731,"L1.12",null,"Overheads, charges and profit on item L1.11","%",{"v":200000,"d":"R200,000.00"},null,{"$f":"F32*G32","v":0}]
[]
[732,"L1.13",null,"Provisional sum for survey / GIS specialist support","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"F34*G34","v":{"v":100000,"d":"R 100 000.00"}}]
[]
[733,"L1.14",null,"Overheads, charges and profit on item L1.13","%",{"v":100000,"d":"R100,000.00"},null,{"$f":"F36*G36","v":0}]
[]
[734,"L1.15",null,"Provisional sum for emergency utility diversions / third-party approvals","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"F38*G38","v":{"v":100000,"d":"R 100 000.00"}}]
[]
[735,"L1.16",null,"Overheads, charges and profit on item L1.15","%",{"v":100000,"d":"R100,000.00"},null,{"$f":"F40*G40","v":0}]
{"$rows_empty":39}
["TSF","TOTAL SECTION L CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(H5:H79)","v":{"v":1500000,"d":"R1,500,000.00"}}]

{"sheet":"Summary","index":13,"n_rows":38,"n_cols":4,"rows_kept":38,"merged":[[1,1,3,3]]}
[]
[null,"CONTRACT NO: VCW380/PWLPLM/24: MALUTI-A-PHOFUNG LOCAL MUNICIPALITY: APPOINTMENT OF A MAXIMUM OF FOUR (04) CONTRACTORS FOR THE REPAIRS OF POTABLE WATER LEAKS MALUTI-A-PHOFUNG LOCAL MUNICIPALITY IN PHUTHADITJABA "]
[]
[]
[]
[null,"A ","PRELIMINARY AND GENERAL",{"$f":"'A '!H322","v":{"v":490000,"d":"R490,000.00"}}]
[]
[null,"B ","DAYWORKS",{"$f":"B!H73","v":{"v":250000,"d":"R250,000.00"}}]
[]
[null,"C","SITE CLEARANCE",{"$f":"'C '!H140","v":0}]
[]
[null,"D","EARTHWORKS (PIPE TRENCHES",{"$f":"D!H277","v":{"v":300000,"d":"R300,000.00"}}]
[]
[null,"E","BEDDING (PIPES)",{"$f":"E!H74","v":0}]
[]
[null,"F","MEDIUM PRESSURE PIPELINES",{"$f":"F!H857","v":0}]
[]
[null,"G","CONCRETE (SMALL WORKS)",{"$f":"G!H148","v":0}]
[]
[null,"H","LEAK DETECTION",{"$f":"H!H75","v":0}]
[]
[null,"I","RESERVOIR SEALING AND WATERPROOFING",{"$f":"I!H61","v":0}]
[]
[null,"J","METERING, ZONE CONTROL & TELEMETRY",{"$f":"J!H71","v":0}]
[]
[null,"K","TEMPORARY SUPPLY, TESTING & COMMISSIONING",{"$f":"K!H74","v":0}]
[]
[null,"L","PROVISIONAL SUMS",{"$f":"L!H80","v":{"v":1500000,"d":"R1,500,000.00"}}]
[]
[null,null,"SUBTOTAL",{"$f":"SUM(D6:D29)","v":{"v":2540000,"d":"R2,540,000.00"}}]
[]
[null,null,"10% CONTINGENCIES",{"$f":"D30*0.1","v":{"v":254000,"d":"R254,000.00"}}]
[]
[null,null,"SUBTOTAL",{"$f":"SUM(D30:D33)","v":{"v":2794000,"d":"R2,794,000.00"}}]
[]
[null,null,"15 % VALUE ADDED TAX",{"$f":"D34*0.15","v":{"v":419100,"d":"R419,100.00"}}]
[]
[null,null,"TOTAL",{"$f":"D34+D36","v":{"v":3213100,"d":"R3,213,100.00"}}]