{"text_format":"3","workbook":"xlsx","n_sheets":16,"sheets":["Fixed P&Gs","Time Related","Prov Sums","PC Items","Dayworks","Temp Works","Earthworks_Trench","Earthworks_Trench2","Bedding","Pipelines1","Pipelines2","Pipelines3","Pipelines4","Pipelines5","Ancillaries","SUM"],"not_rendered":{"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"Fixed P&Gs","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"merged":[[1,1,1,7],[2,1,2,7],[3,1,3,4],[3,5,3,7],[41,1,41,6],[43,1,43,6]]}
[{"$nulls":7},"ORB.INV_02.22"]
[null,"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "]
[null,"SCHEDULE OF QUANTITIES: "]
[null,"INVERAAN VILLAGE WATER SUPPLY",{"$nulls":3},"CONTRACT No INF-W27/2022/2023"]
[null,"SCHEDULE A: PRELIMINARY AND GENERAL OBLIGATIONS"]
[null,"SECTION 1: PRELIMINARY AND GENERAL - FIXED CHARGE AND VALUE RELATED OBLIGATIONS"]
[]
[null,"ITEM NUMBER","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"A.1",null,"FIXED CHARGE AND VALUE RELATED ITEMS:"]
[{"$nulls":3},"(As specified in SABS 1200 A, SABS 1200 AB and the Project Specifications.)",{"$nulls":3},{"$f":"IF(F10=\"\",IF(G10=\"\",\"\",\"Rate Only\"),F10*G10)","v":""}]
[{"$nulls":7},{"$f":"IF(F11=\"\",IF(G11=\"\",\"\",\"Rate Only\"),F11*G11)","v":""}]
[null,1.1,null,"Contractual Requirements:",{"$nulls":3},{"$f":"IF(F12=\"\",IF(G12=\"\",\"\",\"Rate Only\"),F12*G12)","v":""}]
[null,"1.1.1","8.3.1","Fixed charge contractual requirements.","Sum",{"v":1,"d":"1.00"},0,{"$f":"G13*F13","v":0}]
[null,"1.1.2","8.3.1","Value related contractual requirements.","Sum",{"v":1,"d":"1.00"},0,{"$f":"G14*F14","v":0}]
[]
[null,1.2,null,"Facilities for Engineer:",{"$nulls":3},{"$f":"G16*F16","v":0}]
[null,"1.2.1","8.3.2.1 a","Furnished office - 1 No.","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.2.2","8.3.2.1 c","Name board","Sum",{"v":2,"d":"2.00"},0,0]
[null,"1.2.3","PSA 14.1 a","Provision of survey equipment.","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.2.4","8.3.2.1 e","Cellphone costs","Sum",{"v":1,"d":"1.00"},{"v":25000,"d":"25,000.00"},{"$f":"G20*F20","v":{"v":25000,"d":"25,000.00"}}]
[null,1.3,null,"Facilities for Contractor:"]
[null,"1.3.1","8.3.2.2 a","Offices and storage sheds","Sum",{"v":1,"d":"1.00"},0,{"$f":"G22*F22","v":0}]
[null,"1.3.2","8.3.2.2 b","Workshops","Sum",{"v":1,"d":"1.00"},0,{"$f":"G23*F23","v":0}]
[null,"1.3.3","8.3.2.2 c","Laboratories","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.4","8.3.2.2 d","Living accommodation","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.5","8.3.2.2 e","Ablution and latrine facilities","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.6","8.3.2.2 f","Tools and equipment","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.7","8.3.2.2 g","Water supplies, electric power and communications","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.8","8.3.2.2 h","Dealing with water","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.9","8.3.2.2 i","Access","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.10","8.3.2.2 j","Plant","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.11","PSA 14.2 a","Materials on site storage and protection.","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.12","PSA 14.2 b","Accommodation of traffic.","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.3.13","PSA 14.2 c","Labour intensive activity training.","Sum",{"v":1,"d":"1.00"},0,0]
[{"$nulls":6},0,0]
[null,1.4,"8.3.3","Other Fixed Charge Obligations:","Sum",{"v":1,"d":"1.00"},0,0]
[{"$nulls":6},0,0]
[null,1.5,"8.3.4","Removal of Site Establishment:","Sum",{"v":1,"d":"1.00"},0,0]
[{"$nulls":6},0,0]
[null,1.6,"PSA 14.3 a","Environmental Management:","Sum",{"v":1,"d":"1.00"},0,0]
[]
[null,"TOTAL SCHEDULE A - SECTION 1 CARRIED TO SUMMARY:",{"$nulls":5},0]
[]
[null,"INVERAAN CONT B WS BoQ "]

{"sheet":"Time Related","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[3,5,3,7],[41,1,41,6],[43,1,43,6]]}
[{"$nulls":7},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":3},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE A: PRELIMINARY AND GENERAL OBLIGATIONS"]
[null,"SECTION 2: PRELIMINARY AND GENERAL - TIME RELATED OBLIGATIONS"]
[]
[null,"ITEM NUMBER","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"A.2",null,"TIME RELATED ITEMS:",{"$nulls":3},{"$f":"IF(F9=\"\",IF(G9=\"\",\"\",\"Rate Only\"),F9*G9)","v":""}]
[{"$nulls":3},"(As specified in SABS 1200 A, SABS 1200 AB and the Project Specifications.)",{"$nulls":3},{"$f":"IF(F10=\"\",IF(G10=\"\",\"\",\"Rate Only\"),F10*G10)","v":""}]
[{"$nulls":7},{"$f":"IF(F11=\"\",IF(G11=\"\",\"\",\"Rate Only\"),F11*G11)","v":""}]
[null,2.1,null,"Contractual Requirements:",{"$nulls":3},{"$f":"IF(F12=\"\",IF(G12=\"\",\"\",\"Rate Only\"),F12*G12)","v":""}]
[null,"2.1.1","8.4.1","Time related contractual requirements.","Month",{"v":15,"d":"15.00"},0,{"$f":"G13*F13","v":0}]
[]
[null,2.2,null,"Facilities for Engineer:"]
[null,"2.2.1","8.4.2.1 a","Furnished office - 1 No.","Month",{"$f":"IF($F$13=\"\",\"\",IF(E16=\"\",\"\",$F$13))","v":{"v":15,"d":"15.00"}},0,{"$f":"G16*F16","v":0}]
[null,"2.2.2","8.4.2.1 c","Name boards - 2 No.","Month",{"$f":"IF($F$13=\"\",\"\",IF(E17=\"\",\"\",$F$13))","v":{"v":15,"d":"15.00"}},0,0]
[null,"2.2.3","8.4.2.1 d","Survey assistants and material.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.2.4","8.4.2.1e","Cellphone costs, including pro-rata","Month",{"v":15,"d":"15.00"},{"v":1000,"d":"1,000.00"},{"v":15000,"d":"15,000.00"}]
[null,2.3,null,"Facilities for Contractor:",null,""]
[null,"2.3.1","8.4.2.2 a","Offices and storage sheds.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.2","8.4.2.2 b","Workshops.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.3","8.4.2.2 c","Laboratories.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.4","8.4.2.2 d","Living accommodation.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.5","8.4.2.2 e","Ablution and latrine facilities.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.6","8.4.2.2 f","Tools and equipment.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.7","8.4.2.2 g","Water supplies, electric power and communications.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.8","8.4.2.2 h","Dealing with water.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.9","8.4.2.2 i","Access.","Month",{"v":15,"d":"15.00"},0,0]
[null,"2.3.10","8.4.2.2 j","Plant.","Month",{"v":15,"d":"15.00"},0,0]
[{"$nulls":5},""]
[null,2.4,"8.4.3","Supervision for Duration of the Contract:","Month",{"v":15,"d":"15.00"},0,0]
[{"$nulls":5},""]
[null,2.5,"8.4.4","Overhead Costs for the Duration of the Contract:","Month",{"v":15,"d":"15.00"},0,0]
[{"$nulls":5},""]
[null,2.6,"8.4.5","Other Time Related Obligations:","Month",{"v":15,"d":"15.00"},0,0]
[{"$nulls":5},""]
[null,2.7,"PSA 14.3 b","Environmental Management:","Month",{"v":15,"d":"15.00"},0,0]
[{"$nulls":5},""]
[null,2.8,"PSA 14.4 a","Construction Management Administration:","Month",{"v":15,"d":"15.00"},0,0]
[{"$nulls":5},"",null,{"$f":"IF(F41=\"\",IF(G41=\"\",\"\",\"Rate Only\"),F41*G41)","v":""}]
[null,"TOTAL SCHEDULE A - SECTION 2 CARRIED TO SUMMARY:",{"$nulls":5},0]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Prov Sums","index":2,"n_rows":42,"n_cols":8,"rows_kept":42,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[3,5,3,7],[39,1,39,6],[41,1,41,6]]}
[{"$nulls":7},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":3},{"$f":"'Fixed P&Gs'!F4:H4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE A: PRELIMINARY AND GENERAL OBLIGATIONS"]
[null,"SECTION 3: PRELIMINARY AND GENERAL - PROVISIONAL SUMS"]
[]
[null,"ITEM NUMBER","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"A.3",null,"PROVISIONAL SUMS:"]
[{"$nulls":3},"(As specified in SABS 1200 A and the Project Specifications.)"]
[]
[null,3.1,"8.5 b","Community Liaison Officer:"]
[null,"3.1.1","PSA 14.5 a","Provision for the employment of CLO.","Prov. Sum",{"v":15,"d":"15.00"},{"v":7000,"d":"R 7,000.00"},{"$f":"IF(G13=\"\",IF(F13=\"\",\"\",\"Rate Only\"),F13*G13)","v":{"v":105000,"d":"R 105,000.00"}}]
[null,"3.1.2","PSA 14.5 b","Overheads, charges and profit on item 3.1.1.","%",{"$f":"H13","v":{"v":105000,"d":"105,000.00"}},null,{"$f":"H13*G14","v":{"v":0,"d":"R 0.00"}}]
[]
[null,3.2,"8.5 b","PSC Attendance at Site Meeting:"]
[null,"3.2.1","PSA 14.5 c","Provision for the attendance of PSC members.","Prov. Sum",{"v":1,"d":"1.00"},{"$f":"250*5*6*2","v":{"v":15000,"d":"R 15,000.00"}},{"$f":"IF(G17=\"\",IF(F17=\"\",\"\",\"Rate Only\"),F17*G17)","v":{"v":15000,"d":"R 15,000.00"}}]
[null,"3.2.2","PSA 14.5 d","Overheads, charges and profit on item 3.2.1.","%",{"$f":"H17","v":{"v":15000,"d":"15,000.00"}},null,{"$f":"H17*G18","v":{"v":0,"d":"R 0.00"}}]
[]
[null,3.3,"8.5 b","Basic Skills and Construction Training:"]
[null,"3.3.1","PSA 14.5 e","Provision for basic skills and construction site safety training.","Prov. Sum",{"v":1,"d":"1.00"},{"v":100000,"d":"R 100,000.00"},{"$f":"IF(G21=\"\",IF(F21=\"\",\"\",\"Rate Only\"),F21*G21)","v":{"v":100000,"d":"R 100,000.00"}}]
[null,"3.3.2","PSA 14.5 f","Overheads, charges and profit on item 3.3.1.","%",{"$f":"H21","v":{"v":100000,"d":"100,000.00"}},null,{"$f":"H21*G22","v":{"v":0,"d":"R 0.00"}}]
[]
[null,3.4,"8.5 b","Relocation/Protection of Existing Services:"]
[null,"3.4.1","PSA 14.5 g","Provision for relocation/protection of existing services.","Prov. Sum",{"v":1,"d":"1.00"},{"v":25000,"d":"R 25,000.00"},{"$f":"IF(G25=\"\",IF(F25=\"\",\"\",\"Rate Only\"),F25*G25)","v":{"v":25000,"d":"R 25,000.00"}}]
[null,"3.4.2","PSA 14.5 h","Overheads, charges and profit on item 3.4.1.","%",{"$f":"H25","v":{"v":25000,"d":"25,000.00"}},null,{"$f":"H25*G26","v":{"v":0,"d":"R 0.00"}}]
[]
[null,3.5,"8.5 b","Additional Tests required by Engineer:"]
[null,"3.5.1","PSA 14.5 i","Provision for additional tests.","Prov. Sum",{"v":1,"d":"1.00"},{"v":40000,"d":"R 40,000.00"},{"$f":"IF(G29=\"\",IF(F29=\"\",\"\",\"Rate Only\"),F29*G29)","v":{"v":40000,"d":"R 40,000.00"}}]
[null,"3.5.2","PSA 14.5 j","Overheads, charges and profit on item 3.5.1.","%",{"$f":"H29","v":{"v":40000,"d":"40,000.00"}},null,{"$f":"H29*G30","v":{"v":0,"d":"R 0.00"}}]
[{"$nulls":7},{"$f":"IF(G31=\"\",\"\",G31*F31)","v":""}]
[null,3.6,"8.5 b","Occupational Health and Safety Audits:"]
[null,"3.6.1","PSA 14.5 k","Provision for Occupational Health and Safety audits on site.","Prov. Sum",{"v":1,"d":"1.00"},{"v":100000,"d":"R 100,000.00"},{"$f":"IF(G33=\"\",IF(F33=\"\",\"\",\"Rate Only\"),F33*G33)","v":{"v":100000,"d":"R 100,000.00"}}]
[null,"3.6.2","PSA 14.5 l","Overheads, charges and profit on item 3.6.1.","%",{"$f":"H33","v":{"v":100000,"d":"100,000.00"}},null,{"$f":"H33*G34","v":{"v":0,"d":"R 0.00"}}]
[{"$nulls":7},{"$f":"IF(F35=\"\",IF(G35=\"\",\"\",\"Rate Only\"),F35*G35)","v":""}]
[null,3.6,"8.5 b","Socail Facilitation"]
[null,"3.6.1","PSA 14.5 k","Provision for Social Facilitation by a Client Appointed Service Provider .","Prov. Sum",{"v":1,"d":"1.00"},{"v":180000,"d":"R 180,000.00"},{"$f":"IF(G37=\"\",IF(F37=\"\",\"\",\"Rate Only\"),F37*G37)","v":{"v":180000,"d":"R 180,000.00"}}]
[null,"3.6.2","PSA 14.5 l","Overheads, charges and profit on item 3.6.1.","%",{"$f":"H37","v":{"v":180000,"d":"180,000.00"}},null,{"$f":"H37*G38","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"TOTAL SCHEDULE A - SECTION 3 CARRIED TO SUMMARY:"]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"PC Items","index":3,"n_rows":29,"n_cols":8,"rows_kept":29,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[3,5,3,7],[26,1,26,6],[28,1,28,6]]}
[{"$nulls":7},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":3},{"$f":"'Fixed P&Gs'!F4:H4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE A: PRELIMINARY AND GENERAL OBLIGATIONS"]
[null,"SECTION 4: PRELIMINARY AND GENERAL - PRIME COST SUMS"]
[]
[null,"ITEM NUMBER","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"A.4",null,"PRIME COST ITEMS:"]
[{"$nulls":3},"(As specified in SABS 1200 A and the Project Specifications.)"]
[]
[null,4.1,8.6,"Pipe Specials:"]
[null,"4.1.1","PSA 14.6 k","Provision of pipe specials, valves and fittings for reservoir connections.","PC Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"50,000.00"},{"$f":"IF(G13=\"\",IF(F13=\"\",\"\",\"Rate Only\"),F13*G13)","v":{"v":50000,"d":"50,000.00"}}]
[null,"4.1.2","PSA 14.6 l","Overheads, charges and profit on item 4.1.1.","%",{"$f":"H13","v":{"v":50000,"d":"50,000.00"}},null,{"$f":"G14*H13","v":0}]
{"$rows_empty":8}
[{"$nulls":7},{"$f":"IF(G23=\"\",\"\",G23*F23)","v":""}]
[]
[{"$nulls":7},{"$f":"IF(G25=\"\",\"\",G25*F25)","v":""}]
[]
[null,"TOTAL SCHEDULE A - SECTION 4 CARRIED TO SUMMARY:",{"$nulls":5},0]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Dayworks","index":4,"n_rows":50,"n_cols":8,"rows_kept":50,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[3,5,3,7],[41,1,41,6],[43,1,43,6]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":5},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":3},{"$f":"'Fixed P&Gs'!F4:H4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE A: PRELIMINARY AND GENERAL OBLIGATIONS"]
[null,"SECTION 5: PRELIMINARY AND GENERAL - DAYWORKS"]
[]
[null,"ITEM NUMBER","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"A.5",null,"DAYWORK:",{"$nulls":3},{"$f":"IF(F9=\"\",IF(E9=\"\",\"\",\"Rate Only\"),\"\")","v":""}]
[{"$nulls":3},"(As specified in SABS 1200 A and the Project Specifications.)",{"$nulls":3},""]
[{"$nulls":7},""]
[null,5.1,8.7,"Labour - Normal Working Hours: [Provisional]",{"$nulls":3},""]
[null,"5.1.1",null,"Skilled Labour (Artisan).","hr",null,null,"Rate Only"]
[null,"5.1.2",null,"Semi-skilled Labour.","hr",null,null,"Rate Only"]
[null,"5.1.3",null,"Unskilled Labour.","hr",null,null,"Rate Only"]
[null,"5.1.4",null,"Foreman.","hr",null,null,"Rate Only"]
[null,"5.1.5",null,"Extra-over rate for items 5.1.1 to 5.1.4 for work during non working hours.","%",null,null,"Rate Only"]
[{"$nulls":7},""]
[null,5.2,8.7,"Materials: [Provisional]",{"$nulls":3},""]
[null,"5.2.1",null,"Allowance for Materials used under Dayworks.","Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"50,000.00"},{"$f":"IF(G20=\"\",IF(F20=\"\",\"\",\"Rate Only\"),F20*G20)","v":{"v":50000,"d":"50,000.00"}}]
[null,"5.2.2",null,"Overheads, Handling and all Charges on Item 5.2.1.","%",{"$f":"H20","v":{"v":50000,"d":"50,000.00"}},0,{"$f":"G21*H20","v":0}]
[{"$nulls":7},{"$f":"IF(F22=\"\",IF(E22=\"\",\"\",\"Rate Only\"),\"\")","v":""}]
[null,5.3,8.7,"Plant - Heavy Equipment: [Provisional]",{"$nulls":3},""]
[{"$nulls":3},"(Plant shall not be more than 3 years old or have more than 3000 hrs logged. Operator to be qualified and competency certified.)",{"$nulls":3},""]
[null,"5.3.1",null,"Excavator - Size Cat 225.","hr",null,null,"Rate Only"]
[null,"5.3.2",null,"Excavator - TLB.","hr",null,null,"Rate Only"]
[null,"5.3.3",null,"Grader 140G or similar.","hr",null,null,"Rate Only"]
[null,"5.3.4",null,"Front end loader - bucket capacity ≤ 1.5 m3.","hr",null,null,"Rate Only"]
[null,"5.3.5",null,"Front end loader - bucket capacity >1.5 m3.","hr",null,null,"Rate Only"]
[null,"5.3.6",null,"Tip truck - 5 m3  capacity.","hr",null,null,"Rate Only"]
[null,"5.3.7",null,"Tip truck - 10 m3 capacity.","hr",null,null,"Rate Only"]
[null,"5.3.8",null,"Vibratory compaction roller - 13.5 ton.","hr",null,null,"Rate Only"]
[null,"5.3.9",null,"Transport cost per any unit of plant to deliver to site and remove from site for items 5.3.1 to 5.3.8","Sum",null,null,"Rate Only"]
[{"$nulls":7},""]
[null,5.4,8.7,"Plant - Small Equipment: [Provisional]",{"$nulls":3},""]
[null,"5.4.1",null,"Pedestrian roller - BW90 or similar.","hr",null,null,"Rate Only"]
[null,"5.4.2",null,"Vibratory plate compactor.","hr",null,null,"Rate Only"]
[null,"5.4.3",null,"Vibratory rammer.","hr",null,null,"Rate Only"]
[null,"5.4.4",null,"Transport cost per any unit of plant to deliver to site and remove from site for items 5.4.1 to 5.4.3. ","Sum",null,null,"Rate Only"]
[{"$nulls":7},""]
[{"$nulls":7},""]
[null,"TOTAL SCHEDULE A - SECTION 5 CARRIED TO SUMMARY:",{"$nulls":5},0]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]
[]
[]
[]
[]
[]
[{"$nulls":3},"  "]

{"sheet":"Temp Works","index":5,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[3,5,3,7],[23,1,23,6],[25,1,25,6]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":5},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":3},{"$f":"'Fixed P&Gs'!F4:H4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE A: PRELIMINARY AND GENERAL OBLIGATIONS"]
[null,"SECTION 6: PRELIMINARY AND GENERAL - TEMPORARY WORKS"]
[]
[null,"ITEM NUMBER","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"A.6",null,"TEMPORARY WORKS:",{"$nulls":3},{"$f":"IF(F9=\"\",IF(E9=\"\",\"\",\"Rate Only\"),\"\")","v":""}]
[{"$nulls":3},"(As specified in SABS 1200 A and the Project Specifications.)",{"$nulls":3},""]
[{"$nulls":7},""]
[null,6.1,8.8,"Access Roads to the Works.",{"$nulls":3},""]
[null,"6.1.1","PSA 14.7 a","Provision and maintenance of construction access to sites, camp or pipeline routes as required by the contractor.","Sum",{"v":1,"d":"1.00"},0,{"$f":"G13*F13","v":0}]
[]
[null,6.2,8.8,"Safety Measures at Excavations:"]
[null,"6.2.1","PSA 14.7 b","Provision of all safety measures required to fully protect all excavations against public access, injury or any other possible accident. ","Sum",{"v":1,"d":"1.00"},0,{"$f":"G16*F16","v":0}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[null,"TOTAL SCHEDULE A - SECTION 6 CARRIED TO SUMMARY:",{"$nulls":5},{"$f":"SUM(H10:H23)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Earthworks_Trench","index":6,"n_rows":34,"n_cols":9,"rows_kept":34,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[31,1,31,7],[33,1,33,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 1: EARTHWORKS FOR PIPE TRENCHES"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"B.1",null,null,"EARTHWORKS:"]
[{"$nulls":4},"(As specified in SABS 1200 DB and the Project Specifications.)"]
[]
[null,1.1,null,null,"Site Clearance:"]
[null,"1.1.1",null,"8.3.1 a","Clear vegetation, 800 mm wide. (Provisional)","m",{"$f":"SUM(Pipelines1!G14:G19)+Pipelines1!G20","v":{"v":80934,"d":"80,934.00"}},0,{"$f":"H13*G13","v":0}]
[null,"1.1.2",null,"8.3.1 b","Clear trees of girth over 1.0 m.","No.",{"$f":"ROUND(G13/2500,0)","v":{"v":32,"d":"32.00"}},0,{"$f":"H14*G14","v":0}]
[null,"1.1.3",null,"8.3.1 c","Remove 150 mm topsoil, 800 mm wide.","m2",{"$f":"G13*0.8*0.15","v":{"v":9712.08,"d":"9,712.08"}},0,0]
[null,"1.1.4","LI",null,"Demolish existing concrete.","m3",{"$f":"ROUND(G13/5000,0)","v":{"v":16,"d":"16.00"}},0,0]
[]
[null,1.2,null,"PSDB 1.1","Excavation using Plant:"]
[null,"1.2.1",null,null,"Excavate in all materials for trench depths up to 1000 mm, 800 mm wide.","m",{"$f":"G13","v":{"v":80934,"d":"80,934.00"}},0,0]
[null,"1.2.2",null,null,"Excavate in all materials for trench depths exceeding 1000 mm up to 1500 mm, 800 mm wide.","m",{"$f":"G19*0.05","v":{"v":4046.7000000000003,"d":"4,046.70"}},0,0]
[null,"1.2.3",null,null,"Extra-over items 1.2.1 and 1.2.2 for excavation in intermediate material.","m3",{"$f":"G19*0.025","v":{"v":2023.3500000000001,"d":"2,023.35"}},0,0]
[null,"1.2.4",null,null,"Extra-over items 1.2.1 and 1.2.2 for excavation in hard material. (Provisional)","m3",{"$f":"G19*0.8*0.3","v":{"v":19424.16,"d":"19,424.16"}},0,0]
[null,"1.2.5",null,null,"Excavate and dispose of unsuitable material from trench bottom.","m3",{"$f":"G19*0.15*0.8*0.5","v":{"v":4856.04,"d":"4,856.04"}},0,0]
[null,"1.2.6",null,null,"Spoil unsuitable backfill material.","m3",{"$f":"G19*0.15*0.8*0.1","v":{"v":971.2080000000001,"d":"971.21"}},0,0]
[]
[null,1.3,"LI","PSDB 1.1","Excavation using Labour Intensive Methods:"]
[null,"1.3.1",null,null,"Extra-over Item 1.2.1 for excavation in soft material using labour intensive methods.","m",{"$f":"G19","v":{"v":80934,"d":"80,934.00"}},0,0]
[null,"1.3.2",null,null,"Extra-over Item 1.2.2 for excavation in soft material using labour intensive methods.","m",{"$f":"G20","v":{"v":4046.7000000000003,"d":"4,046.70"}},0,0]
[null,"1.3.4",null,null,"Extra-over Item 1.2.3 for excavation in intermediate material using labour intensive methods.","m3",{"$f":"G21","v":{"v":2023.3500000000001,"d":"2,023.35"}},0,0]
[null,"1.3.5",null,null,"Extra-over Item 1.2.5 for excavate and dispose of unsuitable materisl using labour intensive methods.","m3",{"$f":"G23","v":{"v":4856.04,"d":"4,856.04"}},0,0]
[]
[null,"SUB-TOTAL SCHEDULE B - SECTION 1 CARRIED FORWARD:",{"$nulls":6},{"$f":"SUM(I13:I30)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Earthworks_Trench2","index":7,"n_rows":36,"n_cols":9,"rows_kept":36,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[8,1,8,7],[33,1,33,7],[35,1,35,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 1: EARTHWORKS FOR PIPE TRENCHES"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"SUB-TOTAL SCHEDULE B - SECTION 1 BROUGHT FORWARD:",{"$nulls":6},{"$f":"Earthworks_Trench!I32","v":0}]
[null,"B.1",null,null,"EARTHWORKS: (Continues)"]
[{"$nulls":4},"(As specified in SABS 1200 DB and the Project Specifications.)"]
[]
[null,1.4,"LI","PSDB 1.2","Backfill and Compaction:"]
[null,"1.4.1",null,null,"Backfill and compact trenches using labour intensive methods.","m3",{"$f":"Earthworks_Trench!G13*0.8*0.85*1.05","v":{"v":57786.876000000004,"d":"57,786.88"}},0,{"$f":"H14*G14","v":0}]
[null,"1.4.2",null,null,"Backfill road crosings using a commercial type G4 material compacted to 98% Mod. AASHTO density.","m3",{"$f":"Earthworks_Trench!G13*0.8*0.9*0.05*1.05","v":{"v":3059.3052000000002,"d":"3,059.31"}},0,{"$f":"H15*G15","v":0}]
[]
[null,1.5,null,null,"Excavation Ancillaries;"]
[null,"1.5.1",null,"8.3.3.1 a","Make up deficiency in backfill material  from other excavations.","m3",{"$f":"G14*0.045*1.05","v":{"v":2730.429891,"d":"2,730.43"}},0,0]
[null,"1.5.2",null,"8.3.3.1 b","Make up deficiency in backfill material  from borrow pits. Free-haul is 5.0 km.","m3",{"$f":"G14*0.025*1.05","v":{"v":1516.9054950000004,"d":"1,516.91"}},0,0]
[null,"1.5.4",null,"8.3.3.2","Opening and closing designated borrow pits.","Sum",{"v":1,"d":"1.00"},0,0]
[null,"1.5.5",null,"8.3.3.3","Compaction within road reserve to 90 % of Modified AASHTO density clause 5.7.1.","m3",{"$f":"G15","v":{"v":3059.3052000000002,"d":"3,059.31"}},0,0]
[null,"1.5.6",null,"8.3.3.3","Compaction within road reserve to 98 % of Modified AASHTO density, as per clause 5.7.2.","m3",{"$f":"G21*0.6","v":{"v":1835.58312,"d":"1,835.58"}},0,0]
[]
[null,1.6,null,null,"Overhaul:"]
[null,"1.6.1",null,"8.3.3.4","Overhaul in excess of the free-haul of 5.0 km.","m3-km",{"$f":"ROUND(G19,0)","v":{"v":1517,"d":"1,517.00"}},0,0]
[]
[null,1.7,null,null,"Existing Services:"]
[null,"1.7.1","LI","8.3.5 a","Services that intersect a trench.","No.",{"$f":"ROUND(Earthworks_Trench!G13/2500,0)","v":{"v":32,"d":"32.00"}},0,0]
[]
[null,1.8,null,null,"Finishing:",{"$nulls":3},{"$f":"IF(G30=\"\",IF(F30=\"\",\"\",\"Rate Only\"),\"\")","v":""}]
[null,"1.8.1",null,"8.3.6.1 c","Reinstate road surfaces using 40 mm asphalt.","m2",null,0,{"$f":"IF(G31=\"\",IF(F31=\"\",\"\",\"Rate Only\"),\"\")","v":"Rate Only"}]
[null,"1.8.2","LI",null,"Topsoil trenches. (Provisional)","m2",{"$f":"Earthworks_Trench!G13*0.8*0.15*1.05","v":{"v":10197.684000000001,"d":"10,197.68"}},0,{"$f":"H32*G32","v":0}]
[]
[null,"TOTAL SCHEDULE B - SECTION 1 CARRIED TO SUMMARY:",{"$nulls":6},{"$f":"SUM(I9:I32)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Bedding","index":8,"n_rows":28,"n_cols":9,"rows_kept":28,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[25,1,25,7],[27,1,27,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 2: PIPE BEDDING"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"B.2",null,null,"BEDDING:"]
[{"$nulls":4},"(As specified in SABS 1200 LB and the Project Specifications.)"]
[]
[null,2.1,null,"8.2.1","Bedding from Trench Excavations:"]
[{"$nulls":4},"(Bedding to be Class C for flexible pipes as indicated in the contract drawings)"]
[null,"2.1.1","LI",null,"Provision of bedding from pipe trench excavation within 1.0 km, using selected granular material.","m3",{"$f":"Earthworks_Trench!G19*0.8*0.3","v":{"v":19424.16,"d":"19,424.16"}},null,{"$f":"G14*H14","v":0}]
[null,"2.1.2","LI",null,"Provision of bedding from pipe trench excavation within 1.0 km, using selected fill material.","m3",{"$f":"G14*0.35","v":{"v":6798.455999999999,"d":"6,798.46"}},null,{"$f":"G15*H15","v":0}]
[]
[null,2.2,null,"8.2.2","Imported Bedding Material:"]
[{"$nulls":4},"(Bedding to be Class C for flexible pipes as indicated in the contract drawings)"]
[null,"2.2.1",null,null,"Provision of bedding imported from designated borrow pit using selected granular material.","m3",{"$f":"ROUND(G14*0.25,0)","v":{"v":4856,"d":"4,856.00"}},null,0]
[null,"2.2.2",null,null,"Provision of bedding imported from designated borrow pit using selected fill material.","m3",{"$f":"ROUND(G15*0.25,0)","v":{"v":1700,"d":"1,700.00"}},null,0]
[]
[]
[]
[]
[]
[null,"TOTAL SCHEDULE B - SECTION 2 CARRIED TO SUMMARY:",{"$nulls":6},{"$f":"SUM(I10:I25)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Pipelines1","index":9,"n_rows":44,"n_cols":9,"rows_kept":44,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[41,1,41,7],[43,1,43,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 3: MEDIUM PRESSURE PIPELINES AND ANCILLARIES"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"B.3",null,null,"MEDIUM PRESSURE PIPES:"]
[{"$nulls":4},"(As specified in SABS 1200 L, SABS 1200 GA and the Project Specifications.)"]
[]
[null,3.1,"LI","8.2.1","Supply, Lay and Bed uPVC Pipes Complete:"]
[{"$nulls":4},"(The rates shall include disinfecting of pipes after completion of hydraulic pipe test.)"]
[null,"3.1.1",null,null,"75 mm uPVC medium pressure pipes - Class 9.","m",{"v":58675,"d":"58,675.00"},0,{"$f":"H14*G14","v":0}]
[null,"3.1.2",null,null,"160 mm uPVC medium pressure pipes - Class 12","m",{"v":0,"d":"0.00"},0,"Rate Only"]
[null,"3.1.3",null,null,"160 mm uPVC medium pressure pipes - Class 9.","m",{"v":6295,"d":"6,295.00"},0,{"$f":"H16*G16","v":0}]
[null,"3.1.4",null,null,"25 mm HDPE PN 20","m",{"v":15964,"d":"15,964.00"},0,0]
[null,"3.1.4",null,null,"110 mm uPVC medium pressure pipes - Class 16.","m",null,0,0]
[null,"3.1.5",null,null,"160 mm uPVC medium pressure pipes - Class 12.","m",null,0,0]
[null,"3.1.5",null,null,"200 mm uPVC medium pressure pipes - Class 12","m",{"v":0,"d":"0.00"},0,"Rate Only"]
[]
[null,3.2,"LI","8.2.2","Fittings and Specials - uPVC Lyng Bends:"]
[{"$nulls":4},"(Extra-over rate to Items 3.1)"]
[null,"3.2.1",null,null,"75 mm Upvc class 16:"]
[null,"3.2.1.1",null,null,"uPVC bends less than 25 degree angle.","No.",{"v":350,"d":"350.00"},0,0]
[null,"3.2.1.2",null,null,"uPVC bends with 45 degree angle.","No.",{"v":45,"d":"45.00"},0,0]
[null,"3.2.1.3",null,null,"uPVC bends with 90 degree angle.","No.",{"v":55,"d":"55.00"},0,0]
[null,"3.2.2",null,null,"160 mm uPVC class 16:",null,null,0]
[null,"3.2.2.1",null,null,"uPVC bends less than 25 degree angle.","No.",{"v":12,"d":"12.00"},0,0]
[null,"3.2.2.2",null,null,"uPVC bends with 45 degree angle.","No.",{"v":20,"d":"20.00"},0,0]
[null,"3.2.2.3",null,null,"uPVC bends with 90 degree angle.","No.",{"v":18,"d":"18.00"},0,0]
[null,"3.2.3",null,null,"200 mm uPVC class 16:",null,null,0]
[null,"3.2.3.1",null,null,"uPVC bends less than 25 degree angle.","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[null,"3.2.3.2",null,null,"uPVC bends with 45 degree angle.","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[null,"3.2.3.3",null,null,"uPVC bends with 90 degree angle.","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[]
[null,3.3,"LI","8.2.2","Specials and Fittings - Cast Iron Equal Tees:",null,null,0]
[{"$nulls":4},"(Bitumen dipped and LYNG sockets on all sides all to SABS 546 and SABS 966.)",null,null,0]
[null,"3.3.1",null,null,"75 mm dia.","No.",{"v":25,"d":"25.00"},0,0]
[null,"3.3.2",null,null,"160 mm dia.","No.",{"v":6,"d":"6.00"},0,0]
[null,"3.3.3",null,null,"200 mm dia","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[null,"SUB-TOTAL SCHEDULE B - SECTION 3 CARRIED FORWARD:",{"$nulls":6},{"$f":"SUM(I9:I41)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Pipelines2","index":10,"n_rows":44,"n_cols":9,"rows_kept":44,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[8,1,8,7],[41,1,41,7],[43,1,43,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 3: MEDIUM PRESSURE PIPELINES AND ANCILLARIES"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"SUB-TOTAL SCHEDULE B - SECTION 3 BROUGHT FORWARD:",{"$nulls":6},{"$f":"Pipelines1!I42","v":0}]
[null,"B.3",null,null,"MEDIUM PRESSURE PIPES:"]
[{"$nulls":4},"(As specified in SABS 1200 L, SABS 1200 GA and the Project Specifications.)"]
[]
[null,3.4,"LI","8.2.2","Specials and Fittings - Hydrant Tees:"]
[{"$nulls":4},"(Cast iron hydrant tees, Bitumen dipped and LYNG sockets to SABS 546 and SABS 966 with flanged branch, 80 mm dia, drilled to SABS 1123, Table 16.)"]
[null,"3.4.1",null,null,"75 mm dia.","No.",{"v":5,"d":"5.00"},0,{"$f":"G15*H15","v":0}]
[null,"3.4.2",null,null,"160 mm dia.","No.",{"v":2,"d":"2.00"},0,{"$f":"G16*H16","v":0}]
[null,"3.4.3",null,null,"200 mm dia.","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[]
[null,3.5,"LI","8.2.2","Specials and Fittings - Cast Iron Scour Tees:"]
[{"$nulls":4},"(Cast iron scour tee, Bitumen dipped and LYNG sockets to SABS 546 and SABS 966 with flanged branch, 100 mm dia, drilled to SABS 1123, Table 16.)"]
[null,"3.5.1",null,null,"75 mm dia.","No.",{"v":5,"d":"5.00"},0,{"$f":"G21*H21","v":0}]
[null,"3.5.2",null,null,"160 mm dia.","No.",{"v":6,"d":"6.00"},0,0]
[null,"3.5.3",null,null,"200 mm dia.","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[]
[null,3.6,"LI","8.2.2","Specials and Fittings - Cast Iron End Caps:"]
[null,"3.6.1",null,null,"75 mm dia.","No.",{"v":35,"d":"35.00"},0,{"$f":"H26*G26","v":0}]
[null,"3.6.2",null,null,"160 mm dia.","No.",{"v":6,"d":"6.00"},0,{"$f":"H27*G27","v":0}]
[{"$nulls":7},0]
[null,3.7,"LI","8.2.2","Specials and Fittings - Cast Iron Reducers:"]
[{"$nulls":4},"(Bitumen dipped, spigot and socket and socketed cast iron reducers all to SABS 546 and SABS 966.)"]
[null,"3.7.1",null,null,"75 mm x 160 mm dia. [S]","No.",{"v":30,"d":"30.00"},0,{"$f":"H31*G31","v":0}]
[null,"3.7.2",null,null,"75 mm x 200 mm dia. [S]","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[null,"3.7.3",null,null,"160 mm x 200 mm dia. [S]","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[]
[null,3.8,"LI","8.2.2","Specials and Fittings - Flang Adaptors:"]
[{"$nulls":4},"(Bitumen dipped and LYNG sockets to SABS 546 and SABS 966 with flange drilled to SABS 1123, Table 16.)"]
[null,"3.8.1",null,null,"75 mm dia.","No.",{"v":35,"d":"35.00"},0,{"$f":"H37*G37","v":0}]
[null,"3.8.2",null,null,"160 mm dia.","No.",{"v":6,"d":"6.00"},0,{"$f":"H38*G38","v":0}]
[null,"3.8.3",null,null,"91 mm dia.","No.",{"v":5,"d":"5.00"},0,{"$f":"H39*G39","v":0}]
[null,"3.8.4",null,null,"200 mm dia.","No.",{"v":0,"d":"0.00"},0,"Rate Only"]
[]
[null,"SUB-TOTAL SCHEDULE B - SECTION 3 CARRIED FORWARD:",{"$nulls":6},{"$f":"SUM(I9:I40)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Pipelines3","index":11,"n_rows":49,"n_cols":9,"rows_kept":49,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[8,1,8,7],[46,1,46,7],[48,1,48,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 3: MEDIUM PRESSURE PIPELINES AND ANCILLARIES"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"SUB-TOTAL SCHEDULE B - SECTION 3 BROUGHT FORWARD:",{"$nulls":6},{"$f":"Pipelines2!I42","v":0}]
[null,"B.3",null,null,"MEDIUM PRESSURE PIPES:"]
[{"$nulls":4},"(As specified in SABS 1200 L, SABS 1200 GA and the Project Specifications.)"]
[]
[null,3.9,"LI","8.2.2","Specials and Fittings - Saddles:"]
[{"$nulls":4},"(Cast iron, bitumen dipped saddle to be 25 mm BSP drilling and tapping.)"]
[null,"3.9.1",null,null,"75 mm dia.","No.",{"v":1571,"d":"1,571.00"},0,{"$f":"H15*G15","v":0}]
[null,"3.9.2",null,null,"160 mm dia.","No.",{"v":90,"d":"90.00"},0,{"$f":"H16*G16","v":0}]
[]
[null,"3.10","LI","8.2.3","Specials and Fittings - Isolating Valves:"]
[{"$nulls":4},"(Flanged RSV isolating valves. Valves to be non-rising spindles with cap top.)"]
[null,"3.10.1",null,null,"80 mm dia. Class 16","No.",{"v":15,"d":"15.00"},0,{"$f":"H20*G20","v":0}]
[null,"3.10.2",null,null,"160 mm dia. Class 16","No.",{"v":6,"d":"6.00"},0,0]
[null,"3.10.3",null,null,"161 mm dia. Class 16","No.",{"v":6,"d":"6.00"},0,{"$f":"H22*G22","v":0}]
[null,"3.10.4",null,null,"200 mm dia. Class 16","No.",null,0,0]
[]
[null,3.11,"LI","8.2.3","Specials and Fittings - Socketed Valves:"]
[{"$nulls":4},"(Socket ends RSV isolating valves. Valves to be non-rising spindles with cap top.)"]
[null,"3.11.1",null,null,"75 mm dia. Class 16","No.",{"v":20,"d":"20.00"},0,0]
[null,"3.11.2",null,null,"160 mm dia. Class 16","No.",{"v":3,"d":"3.00"},0,0]
[null,"3.11.3",null,null,"200 mm dia. Class 16","No.",null,0,0]
[]
[null,3.12,"LI","8.2.3","Specials and Fittings - Air Valve:"]
[{"$nulls":4},"(Vent O' Mat SERIES RBX  with screwed BSP male inlet, or similar. Complete with flange, barrel nipple, and 50 mm gate valve)"]
[null,"3.12.1",null,null,"50 mm Air Valve ","No.",{"v":15,"d":"15.00"},0,0]
[]
[null,3.13,"LI","8.2.3","Specials and Fittings - Bulk Water Meter:",null,null,0,0]
[{"$nulls":4},"(Kent or similar approved, flanged and drilled to SABS 1123, Table 16)",null,null,0,0]
[null,"3.13.1",null,null,"80 mm dia.  In-Line Bulk Water Meter.","No.",{"v":1,"d":"1.00"},0,"Rate Only"]
[null,"3.13.2",null,null,"150 mm dia.  In-Line Bulk Water Meter.","No.",{"v":1,"d":"1.00"},0,"Rate Only"]
[null,"3.13.3",null,null,"200 mm dia.  In-Line Bulk Water Meter.","No.",{"v":1,"d":"1.00"},0,"Rate Only"]
[]
[null,3.14,"LI","8.2.3","Flow Control Valves"]
[{"$nulls":4},"(Bermad or similar approved, flanged and drilled to SABS 1123, Table 16)"]
[null,"3.14.1",null,null,"Provisional Sum for the supply of 150 mm dia.  In-Line Flow Control Valves.","No.",{"v":1,"d":"1.00"},null,"Rate Only"]
[]
[null,"3.14.2",null,null,"Provisional Sum for the supply of 75 mm dia.  In-Line Flow Control Valves.","No.",{"v":1,"d":"1.00"},null,"Rate Only"]
[]
[null,"SUB-TOTAL SCHEDULE B - SECTION 3 CARRIED FORWARD:",{"$nulls":6},{"$f":"SUM(I9:I39)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Pipelines4","index":12,"n_rows":40,"n_cols":9,"rows_kept":40,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[8,1,8,7],[37,1,37,7],[39,1,39,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 3: MEDIUM PRESSURE PIPELINES AND ANCILLARIES"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"SUB-TOTAL SCHEDULE B - SECTION 3 BROUGHT FORWARD:",{"$nulls":6},{"$f":"Pipelines3!I47","v":0}]
[null,"B.3",null,null,"MEDIUM PRESSURE PIPES:"]
[{"$nulls":4},"(As specified in SABS 1200 L, SABS 1200 GA and the Project Specifications.)"]
[null,3.14,"LI","8.2.2","Specials and Fittings - Stand Pipes"]
[null,"3.14.1",null,null,"Stand pipe fittings complete, excluding saddles, including all labour, plant and incidentals as per DWAF details.","No.",{"v":1961,"d":"1,961.00"},0,{"$f":"H13*G13","v":0}]
[null,"3.14.2",null,null,"Supply and Installation of 15mm Kent Water meter brass type for household connections all complete as per project specifications","No.",{"$f":"G13","v":{"v":1961,"d":"1,961.00"}},0,{"$f":"H14*G14","v":0}]
[]
[null,3.15,"LI","8.2.2","Pipe Specials - Galvanised:"]
[null,"3.15.1",null,null,"80 mm dia. x 300 mm long GMS pipe, flanged both ends, drilled to SABS 1123 Table 16.","No.",{"$f":"Pipelines3!G33","v":{"v":15,"d":"15.00"}},0,{"$f":"H17*G17","v":0}]
[null,"3.15.2",null,null,"150 mm dia air valve chamber vent as per details.","No.",{"$f":"G17","v":{"v":15,"d":"15.00"}},0,0]
[{"$nulls":7},0,0]
[null,3.16,"LI","8.2.13","Valve Chambers:",null,null,0,0]
[null,"3.16.1",null,null,"Valve chamber - 1200 mm x 1400 mm x 1000 mm depth, complete including excavation, materials, plant, labour and incidentals, as per detail drawings.","No.",{"v":10,"d":"10.00"},0,0]
[null,"3.16.2",null,null,"Extra-over Item 3.15.1 for depth increments of 250 mm.","No.",null,0,0]
[]
[null,3.17,"LI",null,"Standpipes:"]
[null,"3.17.1",null,null,"Stand pipe complete, excluding specials and fittings, including all labour, plant, materials and incidentals, as per detail drawings.","No.",{"$f":"G13","v":{"v":1961,"d":"1,961.00"}},0,0]
[]
[null,3.18,"LI","8.2.1","Hydraulic Pipe Testing:",null,null,0,0]
[null,"3.18.1",null,null,"75 mm dia. Pipes","m",{"$f":"IF(Pipelines1!G14=\"\",\"\",Pipelines1!G14)","v":{"v":58675,"d":"58,675.00"}},0,0]
[null,"3.18.2",null,null,"160 mm dia. Pipes","m",{"$f":"IF(Pipelines1!G16=\"\",\"\",Pipelines1!G16)","v":{"v":6295,"d":"6,295.00"}},0,0]
[null,"3.18.3",null,null,"25 mm HDPE PN 20","m",{"$f":"IF(Pipelines1!G17=\"\",\"\",Pipelines1!G17)","v":{"v":15964,"d":"15,964.00"}},0,0]
[null,"3.18.4",null,null,"Pipe specials and fittings for testing.","Sum",{"v":1,"d":"1.00"},0,0]
[]
[null,3.19,"LI","8.2.1","Disinfecting Pipe Works."]
[null,"3.19.1",null,null,"75 mm dia. Pipes","m",{"$f":"IF(G28=\"\",\"\",G28)","v":{"v":58675,"d":"58,675.00"}},0,0]
[null,"3.19.2",null,null,"160 mm dia. Pipes","m",{"$f":"IF(G29=\"\",\"\",G29)","v":{"v":6295,"d":"6,295.00"}},0,0]
[null,"3.19.3",null,null,"200 mm dia. Pipes","m",{"v":0,"d":"0.00"},0,"Rate Only"]
[null,"3.19.4",null,null,"110 mm dia. Pipes","m",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IF(G37=\"\",IF(F37=\"\",\"\",\"Rate Only\"),\"\")","v":{"$error":"#REF!"}}]
[null,"SUB-TOTAL SCHEDULE B - SECTION 3 CARRIED FORWARD:",{"$nulls":6},{"$f":"SUM(I9:I36)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Pipelines5","index":13,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[8,1,8,7],[26,1,26,7],[28,1,28,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 3: MEDIUM PRESSURE PIPELINES AND ANCILLARIES"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"SUB-TOTAL SCHEDULE B - SECTION 3 BROUGHT FORWARD:",{"$nulls":6},{"$f":"Pipelines4!I38","v":0}]
[null,"B.3",null,null,"MEDIUM PRESSURE PIPES:"]
[{"$nulls":4},"(As specified in SABS 1200 L, SABS 1200 GA and the Project Specifications.)"]
[]
[null,{"v":3.2,"d":"3.20"},"LI","8.2.11","Thrust Blocks:"]
[null,"3.20.1",null,null,"Excavation.","m3",{"$f":"ROUNDUP(Earthworks_Trench!G13*0.8*0.0078358,0)","v":{"v":508,"d":"508.00"}},0,{"$f":"H14*G14","v":0}]
[null,"3.20.2",null,null,"Formwork.","m2",{"$f":"G14*2","v":{"v":1016,"d":"1,016.00"}},0,{"$f":"H15*G15","v":0}]
[null,"3.20.3",null,null,"Concrete. [Class 20/19 MPa]","m3",{"$f":"ROUND(G14*0.1404761904762,0)","v":{"v":71,"d":"71.00"}},0,0]
[]
[null,3.21,"LI",null,"Pipe Works Ancillaries:"]
[null,"3.21.1",null,null,"550 mm x 550 mm Fabricated manhole cover with frame, galvanised.","No.",{"$f":"Pipelines4!G21","v":{"v":10,"d":"10.00"}},0,0]
[null,"3.21.2",null,null,"Access ladder - 304 SS, galvanised.","No.",{"$f":"G19","v":{"v":10,"d":"10.00"}},0,0]
[null,"3.21.3",null,null,"Concrete pipe line markers as per details.","No.",{"$f":"ROUND(Earthworks_Trench!G13/250,0)","v":{"v":324,"d":"324.00"}},0,0]
[]
[]
[]
[]
[]
[null,"TOTAL SCHEDULE B - SECTION 3 CARRIED TO SUMMARY:",{"$nulls":6},{"$f":"SUM(I9:I26)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"Ancillaries","index":14,"n_rows":41,"n_cols":9,"rows_kept":41,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[3,6,3,8],[38,1,38,7],[40,1,40,7]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":6},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,{"$f":"'Fixed P&Gs'!B3","v":"SCHEDULE OF QUANTITIES: "}]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":4},{"$f":"'Fixed P&Gs'!F4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"SCHEDULE B: BULK SUPPLY AND NETWORK DISTRIBUTION WORKS"]
[null,"SECTION 4: ANCILLARY WATER SUPPLY WORKS"]
[]
[null,"ITEM NUMBER","LI","PAYMENT CLAUSE","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"B.4",null,null,"ANCILLARY WORKS:"]
[{"$nulls":4},"(As specified in the Project Specifications.)"]
[null,4.1,null,"PSH 4.1","Elevated Pressed Steel Reservoir:"]
[{"$nulls":4},"(Reservoir shall be a Braithwaite type, or similar,pressed steel. All manufacturing to SABS standards with hot dip galvaising to SANS 121(ISO 1461), Installation to be performed by the supplier)"]
[null,"4.1.1",null,null,"Supply and erect 1105 kl capacity elevated pressed steel reservoir with base 10.0m above natural ground level.","No.",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.2",null,null,"Excavating in soft material for maximum depth of 2.0m for the tank footings.","m3",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.3",null,null,"Extra over subitem 4.1.3 for excavation in hard material, irrespective of depth.","m3",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.4",null,null,"Supply, bend and fixing of High yield stress steel reinforcement for the tank footings.","t",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.5",null,null,"Supply, bend and fixing of Mild stress steel reinforcement for the tank footings.","t",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.6",null,null,"Vertical formwork to provide Class F1 surface finish to the tank footings.","m2",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.7",null,null,"Supply and placement of blinding layer concrete. [Class 15/10 MPa] for the tank footings.","m3",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.8",null,null,"Supply and placement of reinforced concrete. [Class 25/19 MPa] for the tank footings.","m3",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.9",null,null,"Supply and install Ø24mm x 700mm long holding bolts to be casted in the tank footings.","No.",{"v":0,"d":"0.00"},0,"Rate only"]
[null,"4.1.11",null,null,"Provision for extension of the existing tank stand","Prov.Sum",{"v":1,"d":"1.00"},null,{"$f":"H22*G22","v":0}]
[]
[null,4.2,null,null,"Borehole Development:"]
[{"$nulls":4},"Re-drilling and Equipping  Boreholes "]
[null,"4.2.1",null,null,"Re-drilling and or rehabilitation of Borehole H11-2768 including yield test and chemical analysis reporting. Borehole depth up to 120m ","Sum",{"v":1,"d":"1.00"},0,"Rate only"]
[null,"4.2.2",null,null,"Supply and equip new Boreholes with a suitably sized 3 phase electric motor.  Unit complete with starter panel, cabling, valves, flow meter and delivery pipework as per drawing No….","No.",{"v":1,"d":"1.00"},0,"Rate only"]
[null,"4.2.3",null,null,"Supply, delivery and installation of 2.4m high concrete palisade fence c/w 4.5m wide steel sliding gate, inclusive of area clearance, and civil foundations as per drawings  INV-STD-10&12","m",{"v":100,"d":"100.00"},0,"Rate only"]
[null,"4.2.4",null,null,"Allow a Provisional Sum for removing, cleaning and handing over to the Engineer existing Boreholes H11- 2768 & 1372 diesel engine equipment.","Sum",{"v":1,"d":"1.00"},0,"Rate only"]
[null,"4.2.5",null,null,"Supply and install precast concrete pump house as per DWS specifications, complete with heavy duty lockable steel access door for boreholes above.","No.",{"v":1,"d":"1.00"},0,"Rate only"]
[null,"4.2.6",null,null,"Provision for ESKOM Connection","Prov.Sum",{"v":1,"d":"1.00"},{"v":150000,"d":"150,000.00"},"Rate only"]
[null,"4.2.7",null,null,"Overheads, charges and profit on item 4.2.13","%",{"$f":"I31","v":"Rate only"},0,"Rate only"]
[]
[null,4.3,null,null,"Water Package Plant in Bodi Village:"]
[null,"4.3.1",null,null,"Installation of 1166 KL/day Water Treatment Package Plant for Reverse Osmosis.","Prov.Sum",{"v":1,"d":"1.00"},"Rate only","Rate only"]
[{"$nulls":4},"Overheads, charges and profit on item 4.2.13","%",{"$f":"I35","v":"Rate only"},0,"Rate only"]
[null,"4.3.2",null,null,"Allow for formation of a reed bed effluent discharge in 4.3.1 above","Prov.Sum",{"v":1,"d":"1.00"},"Rate only","Rate only"]
[]
[null,"TOTAL SCHEDULE B - SECTION 4 CARRIED TO SUMMARY:",{"$nulls":6},{"$f":"SUM(I9:I37)","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]

{"sheet":"SUM","index":15,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[3,5,3,7],[4,1,5,7],[6,1,6,7],[7,3,7,5],[7,6,7,7],[8,2,8,5],[8,6,8,7],[9,3,9,5],[9,6,9,7],[10,3,10,5],[10,6,10,7],[11,3,11,5],[11,6,11,7],[12,3,12,5],[12,6,12,7],[13,3,13,5],[13,6,13,7],[14,3,14,5],[14,6,14,7],[15,1,15,5],[15,6,15,7],[16,2,16,5],[16,6,16,7],[17,3,17,5],[17,6,17,7],[18,3,18,5],[18,6,18,7],[19,3,19,5],[19,6,19,7],[20,3,20,5],[20,6,20,7],[21,1,21,5],[21,6,21,7],[23,1,23,5],[23,6,23,7],[24,1,24,5],[24,6,24,7],[25,1,25,5],[25,6,25,7],[26,1,26,5],[27,1,27,5],[27,6,27,7],[28,1,28,5],[28,6,28,7],[29,1,29,5],[29,6,29,7],[30,1,30,5],[30,6,30,7],[32,1,32,6]]}
[]
[null,{"$f":"'Fixed P&Gs'!B2","v":"CAPRICORN DISTRICT MUNICIPALITY - LIMPOPO PROVINCE "},{"$nulls":5},{"$f":"'Fixed P&Gs'!H1","v":"ORB.INV_02.22"}]
[null,"SUMMARY SCHEDULE OF QUANTITIES"]
[null,{"$f":"'Fixed P&Gs'!B4","v":"INVERAAN VILLAGE WATER SUPPLY"},{"$nulls":3},{"$f":"'Fixed P&Gs'!F4:H4","v":"CONTRACT No INF-W27/2022/2023"}]
[null,"CALCULATION OF TENDER SUM"]
[]
[null,"CONT B. RETICULATION  - SPLIT 2"]
[null,"SCHEDULE","SECTION","SECTION DESCRIPTION",null,null,"TENDERED AMOUNT"]
[null,"A","PRELIMINARY AND GENERAL:"]
[null,"A",1,"FIXED CHARGE AND VALUE RELATED OBLIGATIONS",null,null,{"$f":"'Fixed P&Gs'!H42","v":0}]
[null,"A",2,"TIME RELATED OBLIGATIONS",null,null,{"$f":"'Time Related'!H42","v":0}]
[null,"A",3,"PROVISIONAL SUMS",null,null,{"$f":"'Prov Sums'!H40","v":0}]
[null,"A",4,"PRIME COST SUMS",null,null,{"$f":"'PC Items'!H27","v":0}]
[null,"A",5,"DAYWORKS",null,null,{"$f":"Dayworks!H42","v":0}]
[null,"A",6,"TEMPORARY WORKS",null,null,{"$f":"'Temp Works'!H24","v":0}]
[null,"TOTAL SCHEDULE A:",{"$nulls":4},{"$f":"SUM(G9:H15)","v":0}]
[null,"B","BULK SUPPLY AND NETWORK DISTRIBUTION WORKS:"]
[null,"B",1,"EARTHWORKS FOR PIPE TRENCHES",null,null,{"$f":"Earthworks_Trench!I32","v":0}]
[null,"B",2,"PIPE BEDDING",null,null,{"$f":"Pipelines1!I42","v":0}]
[null,"B",3,"MEDIUM PRESSURE PIPELINES AND ANCILLARIES",null,null,{"$f":"Pipelines5!I27","v":0}]
[null,"B",4,"ANCILLARY WATER SUPPLY WORKS",null,null,{"$f":"Ancillaries!I39","v":0}]
[null,"TOTAL SCHEDULE B:",{"$nulls":4},{"$f":"SUM(G18:H21)","v":0}]
[]
[null,"TOTAL AMOUNT -  SCHEDULE A: ",{"$nulls":4},{"$f":"G16","v":0}]
[null,"TOTAL AMOUNT – SCHEDULE B: ",{"$nulls":4},{"$f":"G22","v":0}]
[null,"TENDER SUM:",{"$nulls":4},{"$f":"G24+G25","v":0}]
[null,"2.5% CPA (Applied to A+B)",{"$nulls":5},{"$f":"G25*2.5%","v":0}]
[null,"CONTINGENCIES [10.00%]:",{"$nulls":4},{"$f":"G26*10%","v":0}]
[null,"SUB-TOTAL:",{"$nulls":4},{"$f":"G26+G28+H27","v":0}]
[null,"VAT [15.00%]:",{"$nulls":4},{"$f":"G29*15%","v":0}]
[null,"TENDER PRICE:",{"$nulls":4},{"$f":"G29+G30","v":0}]
[]
[null,{"$f":"'Fixed P&Gs'!$B$44:$G$44","v":"INVERAAN CONT B WS BoQ "}]
[{"$nulls":7},{"$f":"G31*1%","v":0}]