{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["A-P&G ","A-Prov Sum","A-Daywork ","A-Temporary Works","new sewers","rebuild sewers","existing sewers","sewers on stands","Sum Opt2"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"A-P&G ","index":0,"n_rows":122,"n_cols":11,"rows_kept":122,"cut":false,"hidden":false,"merged":[[76,4,76,6],[4,0,5,0],[4,2,5,6],[4,7,5,7],[4,8,5,8],[19,4,19,6]]}
["Contract:  RLM/OMM/0156/2024/25"]
["Part C2:  Pricing Data"]
["Section C2.2:  Bill of Quantities"]
["Preliminary and General"]
["Item","Payment","Description",null,null,null,null,"Unit","Qty","Rate","Amount"]
[null,"Reference",null,null,null,null,null,null,null,"(R)","(R)"]
[]
[null,"SANS","BILL NO",null,1]
[null,"1200 A","PRELIMINARY AND GENERAL"]
[]
[{"$f":"IF(OR(AND(M11>0),M11>1),O11,\"\")","v":""},"PSA8.1","FIXED-CHARGE ITEMS"]
[{"$f":"IF(OR(AND(M12>0),M12>1),O12,\"\")","v":""}]
[{"$f":"IF(ISBLANK(H13),\"\",($E$8&\".\"&+(COUNTA(H$7:H13))))","v":"1.1"},"8.3.1","Contractual Requirements",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H14),\"\",($E$8&\".\"&+(COUNTA(H$7:H14))))","v":""}]
[{"$f":"IF(ISBLANK(H15),\"\",($E$8&\".\"&+(COUNTA(H$7:H15))))","v":""},null,"Establishment of  Facilities on Site"]
[{"$f":"IF(ISBLANK(H16),\"\",($E$8&\".\"&+(COUNTA(H$7:H16))))","v":""}]
[{"$f":"IF(ISBLANK(H17),\"\",($E$8&\".\"&+(COUNTA(H$7:H17))))","v":""},"8.3.2",".1","Facilities for the Engineer"]
[{"$f":"IF(ISBLANK(H18),\"\",($E$8&\".\"&+(COUNTA(H$7:H18))))","v":""},"PSAB",null,"Dwg no"]
[{"$f":"IF(ISBLANK(H19),\"\",($E$8&\".\"&+(COUNTA(H$7:H19))))","v":""}]
[{"$f":"IF(ISBLANK(H20),\"\",($E$8&\".\"&+(COUNTA(H$7:H20))))","v":"1.2"},"PSAB2",null,"(a,f,h)","Furnished offices, latrines and carports",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H21),\"\",($E$8&\".\"&+(COUNTA(H$7:H21))))","v":"1.3"},"PSAB3",null,"(b)","Engineers cellular phone costs",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H22),\"\",($E$8&\".\"&+(COUNTA(H$7:H22))))","v":"1.4"},"PSAB1",null,"(c)","Nameboards",null,null,"no",2]
[{"$f":"IF(ISBLANK(H23),\"\",($E$8&\".\"&+(COUNTA(H$7:H23))))","v":"1.5"},"PSAB5",null,"(d)","Survey assistant",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H24),\"\",($E$8&\".\"&+(COUNTA(H$7:H24))))","v":"1.6"},"PSAB6",null,"(e)","Survey equipment ",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H25),\"\",($E$8&\".\"&+(COUNTA(H$7:H25))))","v":"1.7"},"PSAB4.2",null,"(g)","Laboratory equipment ",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H26),\"\",($E$8&\".\"&+(COUNTA(H$7:H26))))","v":""}]
[{"$f":"IF(ISBLANK(H27),\"\",($E$8&\".\"&+(COUNTA(H$7:H27))))","v":""},"8.3.2",".2","Facilities for the Contractor"]
[{"$f":"IF(ISBLANK(H28),\"\",($E$8&\".\"&+(COUNTA(H$7:H28))))","v":""}]
[{"$f":"IF(ISBLANK(H29),\"\",($E$8&\".\"&+(COUNTA(H$7:H29))))","v":"1.8"},null,null,"(a)","Offices and storage sheds",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H30),\"\",($E$8&\".\"&+(COUNTA(H$7:H30))))","v":"1.9"},null,null,"(b)","Workshops",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H31),\"\",($E$8&\".\"&+(COUNTA(H$7:H31))))","v":"1.10"},null,null,"(c)","Laboratories",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H32),\"\",($E$8&\".\"&+(COUNTA(H$7:H32))))","v":"1.11"},null,null,"(d)","Living accommodation",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H33),\"\",($E$8&\".\"&+(COUNTA(H$7:H33))))","v":"1.12"},null,null,"(e)","Ablution and latrine facilities",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H34),\"\",($E$8&\".\"&+(COUNTA(H$7:H34))))","v":"1.13"},null,null,"(f)","Tools and equipment",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H35),\"\",($E$8&\".\"&+(COUNTA(H$7:H35))))","v":"1.14"},null,null,"(g)","Water supplies, power and communication",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H36),\"\",($E$8&\".\"&+(COUNTA(H$7:H36))))","v":"1.15"},null,null,"(h)","Dealing with water (Sub-clause 5.5)",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H37),\"\",($E$8&\".\"&+(COUNTA(H$7:H37))))","v":"1.16"},null,null,"(i)","Access (Sub-clause 5.8)",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H38),\"\",($E$8&\".\"&+(COUNTA(H$7:H38))))","v":"1.17"},null,null,"(j)","Plant",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H39),\"\",($E$8&\".\"&+(COUNTA(H$7:H39))))","v":""}]
[{"$f":"IF(ISBLANK(H40),\"\",($E$8&\".\"&+(COUNTA(H$7:H40))))","v":"1.18"},"8.3.3","Other fixed-charge obligations ",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H41),\"\",($E$8&\".\"&+(COUNTA(H$7:H41))))","v":""}]
[{"$f":"IF(ISBLANK(H42),\"\",($E$8&\".\"&+(COUNTA(H$7:H42))))","v":""},"8.3.4","Removal of Contractor's and Engineers site"]
[{"$f":"IF(ISBLANK(H43),\"\",($E$8&\".\"&+(COUNTA(H$7:H43))))","v":"1.19"},null,"establishment on completion",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H44),\"\",($E$8&\".\"&+(COUNTA(H$7:H44))))","v":""}]
[{"$f":"IF(ISBLANK(H45),\"\",($E$8&\".\"&+(COUNTA(H$7:H45))))","v":""},"8.3.5","Occupational Health and Safety"]
[{"$f":"IF(ISBLANK(H46),\"\",($E$8&\".\"&+(COUNTA(H$7:H46))))","v":""}]
[{"$f":"IF(ISBLANK(H47),\"\",($E$8&\".\"&+(COUNTA(H$7:H47))))","v":""},"PSA7","Compliance with Occupational Health and Safety Act"]
[{"$f":"IF(ISBLANK(H48),\"\",($E$8&\".\"&+(COUNTA(H$7:H48))))","v":""},null,"(Act 85 of 1993) and its regulations and with the"]
[{"$f":"IF(ISBLANK(H49),\"\",($E$8&\".\"&+(COUNTA(H$7:H49))))","v":"1.20"},null,"Employers Health and Safety Specification",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H50),\"\",($E$8&\".\"&+(COUNTA(H$7:H50))))","v":""}]
[{"$f":"IF(ISBLANK(H51),\"\",($E$8&\".\"&+(COUNTA(H$7:H51))))","v":""},"8.3.6","Environmental Managemant"]
[{"$f":"IF(ISBLANK(H52),\"\",($E$8&\".\"&+(COUNTA(H$7:H52))))","v":""}]
[{"$f":"IF(ISBLANK(H53),\"\",($E$8&\".\"&+(COUNTA(H$7:H53))))","v":"1.21"},"PSAB8","Compliance with Environmental Management plan",null,null,null,null,"sum",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward",{"$f":"SUM(K11:K64)","v":0}]
[null,null,null,null,null,null,null,null,null,"Brought Forward",{"$f":"K65","v":0}]
[]
[{"$f":"IF(ISBLANK(H68),\"\",($E$8&\".\"&+(COUNTA(H$7:H68))))","v":""},"PSA8.2","TIME-RELATED ITEMS"]
[{"$f":"IF(ISBLANK(H69),\"\",($E$8&\".\"&+(COUNTA(H$7:H69))))","v":""}]
[{"$f":"IF(ISBLANK(H70),\"\",($E$8&\".\"&+(COUNTA(H$7:H70))))","v":"1.22"},"8.4.1","Contractual requirements",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H71),\"\",($E$8&\".\"&+(COUNTA(H$7:H71))))","v":""}]
[{"$f":"IF(ISBLANK(H72),\"\",($E$8&\".\"&+(COUNTA(H$7:H72))))","v":""},null,"Operation and maintenance of facilities on the Site for"]
[{"$f":"IF(ISBLANK(H73),\"\",($E$8&\".\"&+(COUNTA(H$7:H73))))","v":""},null,"the duration of construction"]
[{"$f":"IF(ISBLANK(H74),\"\",($E$8&\".\"&+(COUNTA(H$7:H74))))","v":""},"8.4.2",".1","Facilities for the Engineer"]
[{"$f":"IF(ISBLANK(H75),\"\",($E$8&\".\"&+(COUNTA(H$7:H75))))","v":""},null,null,"Dwg no"]
[{"$f":"IF(ISBLANK(H76),\"\",($E$8&\".\"&+(COUNTA(H$7:H76))))","v":""}]
[{"$f":"IF(ISBLANK(H77),\"\",($E$8&\".\"&+(COUNTA(H$7:H77))))","v":"1.23"},"PSAB2",null,"(a,f,h)","Furnished offices, latrines and carports",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H78),\"\",($E$8&\".\"&+(COUNTA(H$7:H78))))","v":"1.24"},"PSAB3",null,"(b)","Telephone (Telkom landline)",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H79),\"\",($E$8&\".\"&+(COUNTA(H$7:H79))))","v":"1.25"},"PSAB1",null,"(c)","Nameboards",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H80),\"\",($E$8&\".\"&+(COUNTA(H$7:H80))))","v":"1.26"},"PSAB5",null,"(d)","Survey assistant",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H81),\"\",($E$8&\".\"&+(COUNTA(H$7:H81))))","v":"1.27"},"PSAB6",null,"(e)","Survey equipment ",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H82),\"\",($E$8&\".\"&+(COUNTA(H$7:H82))))","v":"1.28"},"PSAB4.2",null,"(g)","Laboratory equipment ",null,null,"sum",1]
[]
[{"$f":"IF(ISBLANK(H84),\"\",($E$8&\".\"&+(COUNTA(H$7:H84))))","v":""},"8.4.2",".2","Facilities for the Contractor"]
[{"$f":"IF(ISBLANK(H85),\"\",($E$8&\".\"&+(COUNTA(H$7:H85))))","v":""}]
[{"$f":"IF(ISBLANK(H86),\"\",($E$8&\".\"&+(COUNTA(H$7:H86))))","v":"1.29"},null,null,"(a)","Offices and storage sheds",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H87),\"\",($E$8&\".\"&+(COUNTA(H$7:H87))))","v":"1.30"},null,null,"(b)","Workshops",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H88),\"\",($E$8&\".\"&+(COUNTA(H$7:H88))))","v":"1.31"},null,null,"(c)","Laboratories",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H89),\"\",($E$8&\".\"&+(COUNTA(H$7:H89))))","v":"1.32"},null,null,"(d)","Living accommodation",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H90),\"\",($E$8&\".\"&+(COUNTA(H$7:H90))))","v":"1.33"},null,null,"(e)","Ablution and latrine facilities",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H91),\"\",($E$8&\".\"&+(COUNTA(H$7:H91))))","v":"1.34"},null,null,"(f)","Tools and equipment",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H92),\"\",($E$8&\".\"&+(COUNTA(H$7:H92))))","v":"1.35"},null,null,"(g)","Water supplies, power and communication",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H93),\"\",($E$8&\".\"&+(COUNTA(H$7:H93))))","v":"1.36"},null,null,"(h)","Dealing with water (Sub-clause 5.5)",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H94),\"\",($E$8&\".\"&+(COUNTA(H$7:H94))))","v":"1.37"},null,null,"(i)","Access (Sub-clause 5.8)",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H95),\"\",($E$8&\".\"&+(COUNTA(H$7:H95))))","v":"1.38"},null,null,"(j)","Plant",null,null,"sum",1]
[{"$f":"IF(ISBLANK(H96),\"\",($E$8&\".\"&+(COUNTA(H$7:H96))))","v":""}]
[{"$f":"IF(ISBLANK(H97),\"\",($E$8&\".\"&+(COUNTA(H$7:H97))))","v":"1.39"},"8.4.3","Supervision for duration of construction",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H98),\"\",($E$8&\".\"&+(COUNTA(H$7:H98))))","v":""}]
[{"$f":"IF(ISBLANK(H99),\"\",($E$8&\".\"&+(COUNTA(H$7:H99))))","v":""},"8.4.4","Company and head office overhead costs for the duration"]
[{"$f":"IF(ISBLANK(H100),\"\",($E$8&\".\"&+(COUNTA(H$7:H100))))","v":"1.40"},null,"of the contract",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H101),\"\",($E$8&\".\"&+(COUNTA(H$7:H101))))","v":""}]
[{"$f":"IF(ISBLANK(H102),\"\",($E$8&\".\"&+(COUNTA(H$7:H102))))","v":"1.41"},"8.4.5","Other time-related obligations",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H103),\"\",($E$8&\".\"&+(COUNTA(H$7:H103))))","v":""}]
[{"$f":"IF(ISBLANK(H104),\"\",($E$8&\".\"&+(COUNTA(H$7:H104))))","v":""},"8.4.6","Occupational Health and Safety"]
[{"$f":"IF(ISBLANK(H105),\"\",($E$8&\".\"&+(COUNTA(H$7:H105))))","v":""}]
[{"$f":"IF(ISBLANK(H106),\"\",($E$8&\".\"&+(COUNTA(H$7:H106))))","v":""},"PSA7","Compliance with Occupational Health and Safety Act"]
[{"$f":"IF(ISBLANK(H107),\"\",($E$8&\".\"&+(COUNTA(H$7:H107))))","v":""},null,"(Act 85 of 1993) and its regulations and with the"]
[{"$f":"IF(ISBLANK(H108),\"\",($E$8&\".\"&+(COUNTA(H$7:H108))))","v":"1.42"},null,"Employers Health and Safety Specification",null,null,null,null,"sum",1]
[{"$f":"IF(ISBLANK(H109),\"\",($E$8&\".\"&+(COUNTA(H$7:H109))))","v":""}]
[{"$f":"IF(ISBLANK(H110),\"\",($E$8&\".\"&+(COUNTA(H$7:H110))))","v":""},"8.4.7","Environmental Managemant"]
[{"$f":"IF(ISBLANK(H111),\"\",($E$8&\".\"&+(COUNTA(H$7:H111))))","v":""}]
[{"$f":"IF(ISBLANK(H112),\"\",($E$8&\".\"&+(COUNTA(H$7:H112))))","v":"1.43"},"PSAB8","Compliance with Environmental Management plan",null,null,null,null,"sum",1]
[]
[{"$f":"IF(ISBLANK(H114),\"\",($E$8&\".\"&+(COUNTA(H$7:H114))))","v":""},null,"Management of Local Subcontractors"]
[{"$f":"IF(ISBLANK(H115),\"\",($E$8&\".\"&+(COUNTA(H$7:H115))))","v":""}]
[{"$f":"IF(ISBLANK(H116),\"\",($E$8&\".\"&+(COUNTA(H$7:H116))))","v":"1.44"},"PSA8.4.8","Management of all Local Subcontractors",null,null,null,null,"sum",1]
[]
[]
[{"$f":"IF(OR(AND(M119>0),M119>1),O119,\"\")","v":""},null,{"$f":"C8","v":"BILL NO"},null,{"$f":"$E$8","v":1}]
["",null,"PRELIMINARY AND GENERAL"]
[""]
["",null,"Carried forward to Summary of Bills",null,null,null,null,null,null,"Total",{"$f":"SUM(K66:K116)","v":0}]

{"sheet":"A-Prov Sum","index":1,"n_rows":124,"n_cols":11,"rows_kept":124,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,6],[4,7,5,7],[4,8,5,8]]}
[{"$f":"'A-P&G '!A1","v":"Contract:  RLM/OMM/0156/2024/25"}]
["Part C2:  Pricing Data"]
["Section C2.2:  Bill of Quantities"]
["Provisional Sums and Prime Cost Items"]
["Item","Payment","Description",null,null,null,null,"Unit","Qty","Rate","Amount"]
[null,"Reference",null,null,null,null,null,null,null,"(R)","(R)"]
[]
[null,"SANS","BILL NO",null,2]
[null,"1200 A","PROVISIONAL SUMS AND PRIME COST ITEMS"]
[{"$f":"IF(ISBLANK(H10),\"\",($E$8&\".\"&+(COUNTA(H$7:H10))))","v":""}]
[null,null,"Note:"]
[{"$f":"IF(ISBLANK(H12),\"\",($E$8&\".\"&+(COUNTA(H$7:H12))))","v":""},null,"Expenditure under the following Provisional Sums is for"]
[{"$f":"IF(ISBLANK(H13),\"\",($E$8&\".\"&+(COUNTA(H$7:H13))))","v":""},null,"work executed by the Contractor\\Sub-contractor or"]
[{"$f":"IF(ISBLANK(H14),\"\",($E$8&\".\"&+(COUNTA(H$7:H14))))","v":""},null,"Supplier during the construction phase of the contract."]
[{"$f":"IF(ISBLANK(H15),\"\",($E$8&\".\"&+(COUNTA(H$7:H15))))","v":""},null,"Values paid under these items shall be \"nett values"]
[null,null,"excluding discount and VAT\""]
[null,null,"Invoices shall be supplied for each expenditure and "]
[null,null,"attached to the payment certificates."]
[]
[]
[{"$f":"IF(ISBLANK(H21),\"\",($E$8&\".\"&+(COUNTA(H$7:H21))))","v":""},"PSA9.2","SUMS STATED PROVISIONALLY BY THE ENGINEER"]
[{"$f":"IF(ISBLANK(H22),\"\",($E$8&\".\"&+(COUNTA(H$7:H22))))","v":""}]
[{"$f":"IF(ISBLANK(H23),\"\",($E$8&\".\"&+(COUNTA(H$7:H23))))","v":""},null,"For work to be executed by the Contractor\\Sub-contractor"]
[{"$f":"IF(ISBLANK(H24),\"\",($E$8&\".\"&+(COUNTA(H$7:H24))))","v":""},null,"or Supplier and valued in terms of the \"Valuation of "]
[{"$f":"IF(ISBLANK(H25),\"\",($E$8&\".\"&+(COUNTA(H$7:H25))))","v":""},null,"Variations\" clause in the Conditions of Contract."]
[]
[{"$f":"IF(ISBLANK(H27),\"\",($E$8&\".\"&+(COUNTA(H$7:H27))))","v":""},null,"ALLOWANCES"]
[{"$f":"IF(ISBLANK(H28),\"\",($E$8&\".\"&+(COUNTA(H$7:H28))))","v":""}]
[{"$f":"IF(ISBLANK(H29),\"\",($E$8&\".\"&+(COUNTA(H$7:H29))))","v":""},null,"Allowances"]
[{"$f":"IF(ISBLANK(H30),\"\",($E$8&\".\"&+(COUNTA(H$7:H30))))","v":""}]
[{"$f":"IF(ISBLANK(H31),\"\",($E$8&\".\"&+(COUNTA(H$7:H31))))","v":""},8.5,"(a)",".1","Community requirements"]
[{"$f":"IF(ISBLANK(H32),\"\",($E$8&\".\"&+(COUNTA(H$7:H32))))","v":""}]
[{"$f":"IF(ISBLANK(H33),\"\",($E$8&\".\"&+(COUNTA(H$7:H33))))","v":"2.1"},"PSA9,3",null,null,".1","CLO/LDO remuneration",null,"Prov sum",1,null,150000]
[{"$f":"IF(ISBLANK(H34),\"\",($E$8&\".\"&+(COUNTA(H$7:H34))))","v":""}]
[{"$f":"IF(ISBLANK(H35),\"\",($E$8&\".\"&+(COUNTA(H$7:H35))))","v":"2.2"},null,null,null,".2","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K33*J35)","v":0}]
[{"$f":"IF(ISBLANK(H36),\"\",($E$8&\".\"&+(COUNTA(H$7:H36))))","v":""}]
[{"$f":"IF(ISBLANK(H37),\"\",($E$8&\".\"&+(COUNTA(H$7:H37))))","v":""},"PSA9,4",null,null,".3","Accredited training courses for selected "]
[{"$f":"IF(ISBLANK(H38),\"\",($E$8&\".\"&+(COUNTA(H$7:H38))))","v":"2.3"},null,null,null,null,"local and other labourers",null,"Prov sum",1,null,100000]
[{"$f":"IF(ISBLANK(H39),\"\",($E$8&\".\"&+(COUNTA(H$7:H39))))","v":""}]
[{"$f":"IF(ISBLANK(H40),\"\",($E$8&\".\"&+(COUNTA(H$7:H40))))","v":"2.4"},null,null,null,".4","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K38*J40)","v":0}]
[{"$f":"IF(ISBLANK(H41),\"\",($E$8&\".\"&+(COUNTA(H$7:H41))))","v":""}]
[{"$f":"IF(ISBLANK(H42),\"\",($E$8&\".\"&+(COUNTA(H$7:H42))))","v":""},null,null,null,".5","Wages and salaries of local and other "]
[{"$f":"IF(ISBLANK(H43),\"\",($E$8&\".\"&+(COUNTA(H$7:H43))))","v":"2.5"},null,null,null,null,"labourers employed during training",null,"Prov sum",1,null,50000]
[{"$f":"IF(ISBLANK(H44),\"\",($E$8&\".\"&+(COUNTA(H$7:H44))))","v":""}]
[{"$f":"IF(ISBLANK(H45),\"\",($E$8&\".\"&+(COUNTA(H$7:H45))))","v":"2.6"},null,null,null,".6","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K43*J45)","v":0}]
[{"$f":"IF(ISBLANK(H46),\"\",($E$8&\".\"&+(COUNTA(H$7:H46))))","v":""}]
[{"$f":"IF(ISBLANK(H47),\"\",($E$8&\".\"&+(COUNTA(H$7:H47))))","v":"2.7"},"PSA9.9",null,null,".7","Relocation of existing residents on site",null,"Prov sum",1,null,25000]
[{"$f":"IF(ISBLANK(H48),\"\",($E$8&\".\"&+(COUNTA(H$7:H48))))","v":""}]
[{"$f":"IF(ISBLANK(H49),\"\",($E$8&\".\"&+(COUNTA(H$7:H49))))","v":"2.8"},null,null,null,".8","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K47*J49)","v":0}]
[]
[{"$f":"IF(ISBLANK(H51),\"\",($E$8&\".\"&+(COUNTA(H$7:H51))))","v":"2.9"},"PSA9,11",null,null,".9","PSC Members Meeting Allowance",null,"Prov sum",1,null,{"$f":"6*1000*15","v":90000}]
[{"$f":"IF(ISBLANK(H52),\"\",($E$8&\".\"&+(COUNTA(H$7:H52))))","v":""}]
[{"$f":"IF(ISBLANK(H53),\"\",($E$8&\".\"&+(COUNTA(H$7:H53))))","v":"2.10"},null,null,null,".10","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K51*J53)","v":0}]
[]
[{"$f":"IF(ISBLANK(H55),\"\",($E$8&\".\"&+(COUNTA(H$7:H55))))","v":"2.11"},"PSA9.10",null,null,".11","Specialist Social Facilitator ",null,"Prov sum",1,null,{"$f":"60000*15","v":900000}]
[{"$f":"IF(ISBLANK(H56),\"\",($E$8&\".\"&+(COUNTA(H$7:H56))))","v":""}]
[{"$f":"IF(ISBLANK(H57),\"\",($E$8&\".\"&+(COUNTA(H$7:H57))))","v":"2.12"},null,null,null,".12","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K55*J57)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward",{"$f":"K65","v":0}]
[]
[{"$f":"IF(ISBLANK(H68),\"\",($E$8&\".\"&+(COUNTA(H$7:H68))))","v":""},null,"ENGINEERS REQUIREMENTS"]
[{"$f":"IF(ISBLANK(H69),\"\",($E$8&\".\"&+(COUNTA(H$7:H69))))","v":""}]
[{"$f":"IF(ISBLANK(H70),\"\",($E$8&\".\"&+(COUNTA(H$7:H70))))","v":""},8.5,"(a)",".2","Engineers requirements"]
[{"$f":"IF(ISBLANK(H71),\"\",($E$8&\".\"&+(COUNTA(H$7:H71))))","v":""}]
[{"$f":"IF(ISBLANK(H72),\"\",($E$8&\".\"&+(COUNTA(H$7:H72))))","v":"2.13"},"PSA9.5",null,null,".1","Engineers cellular phone costs",null,"Prov sum",1,null,25000]
[{"$f":"IF(ISBLANK(H73),\"\",($E$8&\".\"&+(COUNTA(H$7:H73))))","v":""}]
[{"$f":"IF(ISBLANK(H74),\"\",($E$8&\".\"&+(COUNTA(H$7:H74))))","v":"2.14"},null,null,null,".2","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K72*J74)","v":0}]
[]
[{"$f":"IF(ISBLANK(H76),\"\",($E$8&\".\"&+(COUNTA(H$7:H76))))","v":"2.15"},"PSA9.7",null,null,".3","Acceptance control testing",null,"Prov sum",1,null,25000]
[]
[{"$f":"IF(ISBLANK(H78),\"\",($E$8&\".\"&+(COUNTA(H$7:H78))))","v":"2.16"},null,null,null,".4","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K76*J78)","v":0}]
[{"$f":"IF(ISBLANK(H79),\"\",($E$8&\".\"&+(COUNTA(H$7:H79))))","v":""}]
[{"$f":"IF(ISBLANK(H80),\"\",($E$8&\".\"&+(COUNTA(H$7:H80))))","v":""},null,"WORK TO EXISTING SERVICES"]
[{"$f":"IF(ISBLANK(H81),\"\",($E$8&\".\"&+(COUNTA(H$7:H81))))","v":""}]
[{"$f":"IF(ISBLANK(H82),\"\",($E$8&\".\"&+(COUNTA(H$7:H82))))","v":""},8.5,"(a)",".3","Existing services"]
[{"$f":"IF(ISBLANK(H83),\"\",($E$8&\".\"&+(COUNTA(H$7:H83))))","v":""}]
[{"$f":"IF(ISBLANK(H84),\"\",($E$8&\".\"&+(COUNTA(H$7:H84))))","v":"2.17"},null,null,null,".1","Locating existing services",null,"Prov sum",1,null,70000]
[{"$f":"IF(ISBLANK(H85),\"\",($E$8&\".\"&+(COUNTA(H$7:H85))))","v":""}]
[{"$f":"IF(ISBLANK(H86),\"\",($E$8&\".\"&+(COUNTA(H$7:H86))))","v":"2.18"},null,null,null,".2","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K84*J86)","v":0}]
[{"$f":"IF(ISBLANK(H87),\"\",($E$8&\".\"&+(COUNTA(H$7:H87))))","v":""}]
[{"$f":"IF(ISBLANK(H88),\"\",($E$8&\".\"&+(COUNTA(H$7:H88))))","v":"2.19"},"PSA9.9",null,null,".3","Relocating existing services",null,"Prov sum",1,null,{"$f":"100000-3686.36","v":96313.64}]
[{"$f":"IF(ISBLANK(H89),\"\",($E$8&\".\"&+(COUNTA(H$7:H89))))","v":""}]
[{"$f":"IF(ISBLANK(H90),\"\",($E$8&\".\"&+(COUNTA(H$7:H90))))","v":"2.20"},null,null,null,".4","Overheads, charges and profit on above",null,"%",null,null,{"$f":"SUM(K88*J90)","v":0}]
[{"$f":"IF(ISBLANK(H91),\"\",($E$8&\".\"&+(COUNTA(H$7:H91))))","v":""}]
[{"$f":"IF(ISBLANK(H92),\"\",($E$8&\".\"&+(COUNTA(H$7:H92))))","v":""},"PSA10","PRIME COST ITEMS"]
[{"$f":"IF(ISBLANK(H93),\"\",($E$8&\".\"&+(COUNTA(H$7:H93))))","v":""}]
[null,null,"Note:"]
[{"$f":"IF(ISBLANK(H95),\"\",($E$8&\".\"&+(COUNTA(H$7:H95))))","v":""},null,"Expenditure under the following Prime Cost Item is for"]
[{"$f":"IF(ISBLANK(H96),\"\",($E$8&\".\"&+(COUNTA(H$7:H96))))","v":""},null,"material purchases by the Contractor in the execution of"]
[{"$f":"IF(ISBLANK(H97),\"\",($E$8&\".\"&+(COUNTA(H$7:H97))))","v":""},null,"dayworks only."]
[{"$f":"IF(ISBLANK(H98),\"\",($E$8&\".\"&+(COUNTA(H$7:H98))))","v":""},null,"Values paid under these items shall be \"nett values"]
[null,null,"excluding discount and VAT\""]
[null,null,"Invoices shall be supplied for each expenditure and "]
[null,null,"attached to the payment certificates."]
[{"$f":"IF(ISBLANK(H102),\"\",($E$8&\".\"&+(COUNTA(H$7:H102))))","v":""}]
[{"$f":"IF(ISBLANK(H103),\"\",($E$8&\".\"&+(COUNTA(H$7:H103))))","v":""}]
[{"$f":"IF(ISBLANK(H104),\"\",($E$8&\".\"&+(COUNTA(H$7:H104))))","v":""},8.6,"Materials for dayworks"]
[{"$f":"IF(ISBLANK(H105),\"\",($E$8&\".\"&+(COUNTA(H$7:H105))))","v":""}]
[{"$f":"IF(ISBLANK(H106),\"\",($E$8&\".\"&+(COUNTA(H$7:H106))))","v":"2.21"},"PSA10.1","(a)","Materials used in the execution of dayworks",null,null,null,"PC item",1,null,5000]
[{"$f":"IF(ISBLANK(H107),\"\",($E$8&\".\"&+(COUNTA(H$7:H107))))","v":""}]
[{"$f":"IF(ISBLANK(H108),\"\",($E$8&\".\"&+(COUNTA(H$7:H112))))","v":"2.22"},null,"(b)","Overheads, charges and profit on above",null,null,null,"%",null,null,{"$f":"SUM(K106*J108)","v":0}]
[]
[]
[]
[]
[{"$f":"IF(ISBLANK(H113),\"\",($E$8&\".\"&+(COUNTA(H$7:H113))))","v":""}]
[{"$f":"IF(ISBLANK(H114),\"\",($E$8&\".\"&+(COUNTA(H$7:H114))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C8","v":"BILL NO"},null,{"$f":"$E$8","v":2}]
[null,null,"PROVISIONAL SUMS AND PRIME COST ITEMS"]
[]
[null,null,"Carried forward to Summary of Bills",null,null,null,null,null,null,"Total"]

{"sheet":"A-Daywork ","index":2,"n_rows":132,"n_cols":11,"rows_kept":132,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,6],[4,7,5,7],[4,8,5,8]]}
[{"$f":"'A-P&G '!A1","v":"Contract:  RLM/OMM/0156/2024/25"}]
["Part C2:  Pricing Data"]
["Section C2.2:  Bill of Quantities"]
["Dayworks and Temporary Works"]
["Item","Payment","Description",null,null,null,null,"Unit","Qty","Rate","Amount"]
[null,"Reference",null,null,null,null,null,null,null,"(R)","(R)"]
[]
[null,"SANS","BILL NO",null,3]
[null,"1200 A","DAYWORKS "]
[]
[null,null,"DAYWORKS"]
[{"$f":"IF(ISBLANK(H12),\"\",($E$8&\".\"&+(COUNTA(H$7:H12))))","v":""}]
[{"$f":"IF(ISBLANK(H13),\"\",($E$8&\".\"&+(COUNTA(H$7:H13))))","v":""},null,"Note:"]
[{"$f":"IF(ISBLANK(H14),\"\",($E$8&\".\"&+(COUNTA(H$7:H14))))","v":""},null,"Dayworks executed on instruction of the Engineer only."]
[{"$f":"IF(ISBLANK(H15),\"\",($E$8&\".\"&+(COUNTA(H$7:H15))))","v":""},null,"Supervision of dayworks is not payable under this section"]
[{"$f":"IF(ISBLANK(H16),\"\",($E$8&\".\"&+(COUNTA(H$7:H16))))","v":""},null,"and is deemed to be included under Preliminary and"]
[{"$f":"IF(ISBLANK(H17),\"\",($E$8&\".\"&+(COUNTA(H$7:H17))))","v":""},null,"General items in 1200A"]
[{"$f":"IF(ISBLANK(H18),\"\",($E$8&\".\"&+(COUNTA(H$7:H18))))","v":""},null,"Daywork sheets shall be delivered to the Engineer at the"]
[{"$f":"IF(ISBLANK(H19),\"\",($E$8&\".\"&+(COUNTA(H$7:H19))))","v":""},null,"end of each day for approval, failing this, the Engineer"]
[{"$f":"IF(ISBLANK(H20),\"\",($E$8&\".\"&+(COUNTA(H$7:H20))))","v":""},null,"will reject the dayworks."]
[]
[{"$f":"IF(ISBLANK(H22),\"\",($E$8&\".\"&+(COUNTA(H$7:H22))))","v":""}]
[{"$f":"IF(ISBLANK(H23),\"\",($E$8&\".\"&+(COUNTA(H$7:H23))))","v":""},"8.7.1","LABOUR"]
[{"$f":"IF(ISBLANK(H24),\"\",($E$8&\".\"&+(COUNTA(H$7:H24))))","v":""}]
[{"$f":"IF(ISBLANK(H25),\"\",($E$8&\".\"&+(COUNTA(H$7:H25))))","v":"3.1"},null,"(a)","Skilled",null,null,null,"hr",25]
[]
[{"$f":"IF(ISBLANK(H27),\"\",($E$8&\".\"&+(COUNTA(H$7:H27))))","v":"3.2"},null,"(b)","Semi-skilled ",null,null,null,"hr",35]
[]
[{"$f":"IF(ISBLANK(H29),\"\",($E$8&\".\"&+(COUNTA(H$7:H29))))","v":"3.3"},null,"(c)","Un-skilled",null,null,null,"hr",50]
[{"$f":"IF(ISBLANK(H30),\"\",($E$8&\".\"&+(COUNTA(H$7:H30))))","v":""}]
[{"$f":"IF(ISBLANK(H31),\"\",($E$8&\".\"&+(COUNTA(H$7:H31))))","v":""},null,"PLANTHIRE (WORK RATES ON SITE)"]
[{"$f":"IF(ISBLANK(H32),\"\",($E$8&\".\"&+(COUNTA(H$7:H32))))","v":""}]
[{"$f":"IF(ISBLANK(H33),\"\",($E$8&\".\"&+(COUNTA(H$7:H33))))","v":""},null,"TRUCKS"]
[{"$f":"IF(ISBLANK(H34),\"\",($E$8&\".\"&+(COUNTA(H$7:H34))))","v":""}]
[{"$f":"IF(ISBLANK(H35),\"\",($E$8&\".\"&+(COUNTA(H$7:H35))))","v":""},"8.7.2",".1","Tipper trucks (specify capacity)"]
[{"$f":"IF(ISBLANK(H36),\"\",($E$8&\".\"&+(COUNTA(H$7:H36))))","v":""}]
[{"$f":"IF(ISBLANK(H37),\"\",($E$8&\".\"&+(COUNTA(H$7:H37))))","v":"3.4"},null,null,"(a)","Capacity_____m³ (small)",null,null,"hr",5]
[{"$f":"IF(ISBLANK(H38),\"\",($E$8&\".\"&+(COUNTA(H$7:H38))))","v":""},null,"LDV'S"]
[{"$f":"IF(ISBLANK(H39),\"\",($E$8&\".\"&+(COUNTA(H$7:H39))))","v":""}]
[{"$f":"IF(ISBLANK(H40),\"\",($E$8&\".\"&+(COUNTA(H$7:H40))))","v":""},"8.7.2",".4","LDV (specify size)"]
[{"$f":"IF(ISBLANK(H41),\"\",($E$8&\".\"&+(COUNTA(H$7:H41))))","v":""}]
[{"$f":"IF(ISBLANK(H42),\"\",($E$8&\".\"&+(COUNTA(H$7:H42))))","v":"3.5"},null,null,"(a)","LDV_____ton",null,null,"km",50]
[{"$f":"IF(ISBLANK(H43),\"\",($E$8&\".\"&+(COUNTA(H$7:H43))))","v":""}]
[{"$f":"IF(ISBLANK(H44),\"\",($E$8&\".\"&+(COUNTA(H$7:H44))))","v":""},null,"WATER TANKERS"]
[{"$f":"IF(ISBLANK(H45),\"\",($E$8&\".\"&+(COUNTA(H$7:H45))))","v":""}]
[{"$f":"IF(ISBLANK(H46),\"\",($E$8&\".\"&+(COUNTA(H$7:H46))))","v":""},"8.7.2",".5","Water tankers (specify capacity)"]
[{"$f":"IF(ISBLANK(H47),\"\",($E$8&\".\"&+(COUNTA(H$7:H47))))","v":""}]
[{"$f":"IF(ISBLANK(H48),\"\",($E$8&\".\"&+(COUNTA(H$7:H48))))","v":"3.6"},null,null,"(a)","Capacity______liter (small, towable)",null,null,"hr",5]
[{"$f":"IF(ISBLANK(H49),\"\",($E$8&\".\"&+(COUNTA(H$7:H49))))","v":""},null,"TLB'S"]
[{"$f":"IF(ISBLANK(H50),\"\",($E$8&\".\"&+(COUNTA(H$7:H50))))","v":""}]
[{"$f":"IF(ISBLANK(H51),\"\",($E$8&\".\"&+(COUNTA(H$7:H51))))","v":""},"8.7.2",".10","Tractor loader backhoe (TLB)(specify model)"]
[{"$f":"IF(ISBLANK(H52),\"\",($E$8&\".\"&+(COUNTA(H$7:H52))))","v":""}]
[{"$f":"IF(ISBLANK(H53),\"\",($E$8&\".\"&+(COUNTA(H$7:H53))))","v":"3.7"},null,null,"(a)","Model__________",null,null,"hr",5]
[{"$f":"IF(ISBLANK(H54),\"\",($E$8&\".\"&+(COUNTA(H$7:H54))))","v":""}]
[{"$f":"IF(ISBLANK(H55),\"\",($E$8&\".\"&+(COUNTA(H$7:H55))))","v":""},null,"WALK BEHIND ROLLERS"]
[{"$f":"IF(ISBLANK(H56),\"\",($E$8&\".\"&+(COUNTA(H$7:H56))))","v":""}]
[{"$f":"IF(ISBLANK(H57),\"\",($E$8&\".\"&+(COUNTA(H$7:H57))))","v":""},"8.7.2",".14","Walk behind vibrating rollers (specify model)"]
[{"$f":"IF(ISBLANK(H58),\"\",($E$8&\".\"&+(COUNTA(H$7:H58))))","v":""}]
[{"$f":"IF(ISBLANK(H59),\"\",($E$8&\".\"&+(COUNTA(H$7:H59))))","v":"3.8"},null,null,"(a)","Model_______(BW 61) (small)",null,null,"hr",5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[{"$f":"IF(ISBLANK(H71),\"\",($E$8&\".\"&+(COUNTA(H$7:H71))))","v":""}]
[{"$f":"IF(ISBLANK(H72),\"\",($E$8&\".\"&+(COUNTA(H$7:H72))))","v":""},null,"COMPACTORS"]
[{"$f":"IF(ISBLANK(H73),\"\",($E$8&\".\"&+(COUNTA(H$7:H73))))","v":""}]
[{"$f":"IF(ISBLANK(H74),\"\",($E$8&\".\"&+(COUNTA(H$7:H74))))","v":""},"8.7.2",".15","Plate compactors (specify model)"]
[{"$f":"IF(ISBLANK(H75),\"\",($E$8&\".\"&+(COUNTA(H$7:H75))))","v":""}]
[{"$f":"IF(ISBLANK(H76),\"\",($E$8&\".\"&+(COUNTA(H$7:H76))))","v":"3.9"},null,null,"(a)","Model_______",null,null,"hr",5]
[{"$f":"IF(ISBLANK(H77),\"\",($E$8&\".\"&+(COUNTA(H$7:H77))))","v":""}]
[{"$f":"IF(ISBLANK(H78),\"\",($E$8&\".\"&+(COUNTA(H$7:H78))))","v":""},"8.7.2",".16","Wackers (specify model)"]
[{"$f":"IF(ISBLANK(H79),\"\",($E$8&\".\"&+(COUNTA(H$7:H79))))","v":""}]
[{"$f":"IF(ISBLANK(H80),\"\",($E$8&\".\"&+(COUNTA(H$7:H80))))","v":"3.10"},null,null,"(a)","Model_______",null,null,"hr",5]
[]
[{"$f":"IF(ISBLANK(H82),\"\",($E$8&\".\"&+(COUNTA(H$7:H82))))","v":""}]
[{"$f":"IF(ISBLANK(H83),\"\",($E$8&\".\"&+(COUNTA(H$7:H83))))","v":""},null,"WATERPUMPS"]
[{"$f":"IF(ISBLANK(H84),\"\",($E$8&\".\"&+(COUNTA(H$7:H84))))","v":""}]
[{"$f":"IF(ISBLANK(H85),\"\",($E$8&\".\"&+(COUNTA(H$7:H85))))","v":""},"8.7.2",".19","Waterpump (specify capacity)"]
[{"$f":"IF(ISBLANK(H86),\"\",($E$8&\".\"&+(COUNTA(H$7:H86))))","v":""}]
[{"$f":"IF(ISBLANK(H87),\"\",($E$8&\".\"&+(COUNTA(H$7:H87))))","v":"3.11"},null,null,"(a)","Capacity_____ liter/sec (small)",null,null,"hr",5]
[{"$f":"IF(ISBLANK(H88),\"\",($E$8&\".\"&+(COUNTA(H$7:H88))))","v":""}]
[{"$f":"IF(ISBLANK(H89),\"\",($E$8&\".\"&+(COUNTA(H$7:H89))))","v":""},null,"TRANSPORT (COST TO AND FROM SITE)"]
[{"$f":"IF(ISBLANK(H90),\"\",($E$8&\".\"&+(COUNTA(H$7:H90))))","v":""}]
[{"$f":"IF(ISBLANK(H91),\"\",($E$8&\".\"&+(COUNTA(H$7:H91))))","v":""},null,"Note:"]
[{"$f":"IF(ISBLANK(H92),\"\",($E$8&\".\"&+(COUNTA(H$7:H92))))","v":""},null,"Distance shall be measured one way only (tender"]
[{"$f":"IF(ISBLANK(H93),\"\",($E$8&\".\"&+(COUNTA(H$7:H93))))","v":""},null,"rates shall include for transport in both directions"]
[{"$f":"IF(ISBLANK(H94),\"\",($E$8&\".\"&+(COUNTA(H$7:H94))))","v":""},null,"to and from site)"]
[]
[{"$f":"IF(ISBLANK(H96),\"\",($E$8&\".\"&+(COUNTA(H$7:H96))))","v":""}]
[{"$f":"IF(ISBLANK(H97),\"\",($E$8&\".\"&+(COUNTA(H$7:H97))))","v":""},"8.7.3",".1","Low bed"]
[{"$f":"IF(ISBLANK(H98),\"\",($E$8&\".\"&+(COUNTA(H$7:H98))))","v":""}]
[{"$f":"IF(ISBLANK(H99),\"\",($E$8&\".\"&+(COUNTA(H$7:H99))))","v":""},null,null,"(a)","Low-bed (suitable for the largest piece"]
[{"$f":"IF(ISBLANK(H100),\"\",($E$8&\".\"&+(COUNTA(H$7:H100))))","v":"3.12"},null,null,null,"of equipment above)",null,null,"km",50]
[{"$f":"IF(ISBLANK(H101),\"\",($E$8&\".\"&+(COUNTA(H$7:H101))))","v":""}]
[{"$f":"IF(ISBLANK(H102),\"\",($E$8&\".\"&+(COUNTA(H$7:H102))))","v":""},"8.7.3",".2","Tipper truck"]
[{"$f":"IF(ISBLANK(H103),\"\",($E$8&\".\"&+(COUNTA(H$7:H103))))","v":""}]
[{"$f":"IF(ISBLANK(H104),\"\",($E$8&\".\"&+(COUNTA(H$7:H104))))","v":"3.13"},null,null,"(a)","Small",null,null,"km",50]
[{"$f":"IF(ISBLANK(H105),\"\",($E$8&\".\"&+(COUNTA(H$7:H105))))","v":""}]
[{"$f":"IF(ISBLANK(H106),\"\",($E$8&\".\"&+(COUNTA(H$7:H106))))","v":""},"8.7.3",".4","Water tanker"]
[{"$f":"IF(ISBLANK(H107),\"\",($E$8&\".\"&+(COUNTA(H$7:H107))))","v":""}]
[{"$f":"IF(ISBLANK(H108),\"\",($E$8&\".\"&+(COUNTA(H$7:H108))))","v":"3.14"},null,null,"(a)","Small",null,null,"km",50]
[{"$f":"IF(ISBLANK(H109),\"\",($E$8&\".\"&+(COUNTA(H$7:H109))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C8","v":"BILL NO"},null,{"$f":"$E$8","v":3}]
[null,null,"DAYWORKS "]
[]
[null,null,"Carried forward to Summary of Bills",null,null,null,null,null,null,"Total"]

{"sheet":"A-Temporary Works","index":3,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,6],[4,7,5,7],[4,8,5,8]]}
[{"$f":"'A-P&G '!A1","v":"Contract:  RLM/OMM/0156/2024/25"}]
["Part C2:  Pricing Data"]
["Section C2.2:  Bill of Quantities"]
["Dayworks and Temporary Works"]
["Item","Payment","Description",null,null,null,null,"Unit","Qty","Rate","Amount"]
[null,"Reference",null,null,null,null,null,null,null,"(R)","(R)"]
[]
[null,"SANS","BILL NO",null,4]
[null,"1200 D"," TEMPORARY WORKS"]
[]
[{"$f":"IF(ISBLANK(H11),\"\",($E$8&\".\"&+(COUNTA(H$7:H11))))","v":""}]
[null,"PSD5","ACCOMMODATION OF TRAFFIC"]
[]
[null,null,"Accommodation of traffic during construction where"]
[null,null,"work is constructed where public traffic needs to be"]
[null,null,"accommodated during the construction"]
[]
[{"$f":"IF(ISBLANK(H18),\"\",($E$8&\".\"&+(COUNTA(H$7:H18))))","v":"4.1"},"8.8.2","Accommodation of traffic",null,null,null,null,"sum",1]
[]
[{"$f":"IF(ISBLANK(H20),\"\",($E$8&\".\"&+(COUNTA(H$7:H20))))","v":""},null,"WORK TO EXISTING SERVICES"]
[{"$f":"IF(ISBLANK(H21),\"\",($E$8&\".\"&+(COUNTA(H$7:H21))))","v":""}]
[{"$f":"IF(ISBLANK(H22),\"\",($E$8&\".\"&+(COUNTA(H$7:H22))))","v":""},"8.3.8","Existing services"]
[]
[{"$f":"IF(ISBLANK(H24),\"\",($E$8&\".\"&+(COUNTA(H$7:H24))))","v":""},null,"(a)","Supply or hire specialist equipment for the detection"]
[{"$f":"IF(ISBLANK(H25),\"\",($E$8&\".\"&+(COUNTA(H$7:H10))))","v":"4.0"},null,null,"of services",null,null,null,"sum",1]
[]
[{"$f":"IF(ISBLANK(H27),\"\",($E$8&\".\"&+(COUNTA(H$7:H27))))","v":"4.3"},null,"(b)","The use of equipment referred to above",null,null,null,"day",10]
[{"$f":"IF(ISBLANK(H28),\"\",($E$8&\".\"&+(COUNTA(H$7:H28))))","v":""}]
[{"$f":"IF(ISBLANK(H29),\"\",($E$8&\".\"&+(COUNTA(H$7:H29))))","v":""},null,"(c)","Excavation by hand in soft material to expose"]
[{"$f":"IF(ISBLANK(H30),\"\",($E$8&\".\"&+(COUNTA(H$7:H10))))","v":"4.0"},null,null,"services",null,null,null,"m³",55]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C8","v":"BILL NO"},null,{"$f":"$E$8","v":4}]
[null,null," TEMPORARY WORKS"]
[]
[null,null,"Carried forward to Summary of Bills",null,null,null,null,null,null,"Total"]

{"sheet":"new sewers","index":4,"n_rows":468,"n_cols":11,"rows_kept":468,"cut":false,"hidden":false,"merged":[[70,2,70,6],[463,3,463,6],[4,0,5,0],[4,2,5,6],[4,7,5,7],[163,2,163,6],[196,2,196,6],[198,2,198,6],[310,4,310,6],[4,8,5,8],[10,2,10,6],[374,2,374,6],[411,2,411,6],[376,2,376,6],[378,2,378,6],[380,2,380,6],[31,2,31,6],[67,2,67,6],[128,4,128,6],[130,4,130,6],[240,2,240,6],[242,2,242,6],[244,2,244,6],[132,4,132,6],[134,2,134,6]]}
[{"$f":"'A-P&G '!A1","v":"Contract:  RLM/OMM/0156/2024/25"}]
["Part C2:  Pricing Data"]
["Section C2.2:  Bill of Quantities"]
["uPVC Sewers"]
["Item","Payment","Description",null,null,null,null,"Unit","Qty","Rate","Amount"]
[null,"Reference",null,null,null,null,null,null,null,"(R)","(R)"]
[]
[null,"SANS","BILL NO",null,5]
[null,"1200 LD","NEW SEWERS"]
[]
[{"$f":"IF(ISBLANK(H11),\"\",($E$8&\".\"&+(COUNTA(H$7:H11))))","v":""},"PSC","DEMOLITIONS"]
[]
[{"$f":"IF(ISBLANK(H13),\"\",($E$8&\".\"&+(COUNTA(H$7:H13))))","v":""},"SANS","DEMOLISH AND SPOIL MATERIAL OFF SITE"]
[{"$f":"IF(ISBLANK(H14),\"\",($E$8&\".\"&+(COUNTA(H$7:H14))))","v":""},"1200 C"]
[{"$f":"IF(ISBLANK(H15),\"\",($E$8&\".\"&+(COUNTA(H$7:H15))))","v":""},"PSC1","Demolish and spoil material for structures, buildings,"]
[{"$f":"IF(ISBLANK(H16),\"\",($E$8&\".\"&+(COUNTA(H$7:H16))))","v":""},null,"etc at a spoil site established by the Contractor"]
[{"$f":"IF(ISBLANK(H17),\"\",($E$8&\".\"&+(COUNTA(H$7:H17))))","v":""}]
[{"$f":"IF(ISBLANK(H18),\"\",($E$8&\".\"&+(COUNTA(H$7:H18))))","v":""},"8.2.8","(a)","Sundry structures, etc"]
[{"$f":"IF(ISBLANK(H19),\"\",($E$8&\".\"&+(COUNTA(H$7:H19))))","v":""}]
[{"$f":"IF(ISBLANK(H20),\"\",($E$8&\".\"&+(COUNTA(H$7:H20))))","v":"5.1"},null,null,".3","Mass concrete structures",null,null,"m³",25]
[{"$f":"IF(ISBLANK(H21),\"\",($E$8&\".\"&+(COUNTA(H$7:H21))))","v":""}]
[{"$f":"IF(ISBLANK(H22),\"\",($E$8&\".\"&+(COUNTA(H$7:H22))))","v":"5.2"},null,null,".4","Reinforced concrete structures",null,null,"m³",25]
[{"$f":"IF(ISBLANK(H23),\"\",($E$8&\".\"&+(COUNTA(H$7:H23))))","v":""}]
[{"$f":"IF(ISBLANK(H24),\"\",($E$8&\".\"&+(COUNTA(H$7:H24))))","v":"5.3"},null,null,".5","150mm Thick concrete paving ",null,null,"m²",100]
[{"$f":"IF(ISBLANK(H25),\"\",($E$8&\".\"&+(COUNTA(H$7:H25))))","v":""}]
[{"$f":"IF(ISBLANK(H26),\"\",($E$8&\".\"&+(COUNTA(H$7:H26))))","v":"5.4"},null,null,".6","150mm Thick reinforced concrete paving ",null,null,"m²",100]
[{"$f":"IF(ISBLANK(H27),\"\",($E$8&\".\"&+(COUNTA(H$7:H27))))","v":""}]
[{"$f":"IF(ISBLANK(H28),\"\",($E$8&\".\"&+(COUNTA(H$7:H28))))","v":"5.5"},null,null,".7","Concrete kerbing (all types and sizes)",null,null,"m",100]
[{"$f":"IF(ISBLANK(H29),\"\",($E$8&\".\"&+(COUNTA(H$7:H29))))","v":""}]
[{"$f":"IF(ISBLANK(H30),\"\",($E$8&\".\"&+(COUNTA(H$7:H30))))","v":"5.6"},null,null,".8","Mass brickwork structures",null,null,"m³",25]
[{"$f":"IF(ISBLANK(H31),\"\",($E$8&\".\"&+(COUNTA(H$7:H31))))","v":""}]
[null,"PSC","CLEAR SITE"]
[]
[{"$f":"IF(ISBLANK(H34),\"\",($E$8&\".\"&+(COUNTA(H$7:H34))))","v":""},"SANS","CLEAR AND GRUB SITE"]
[{"$f":"IF(ISBLANK(H35),\"\",($E$8&\".\"&+(COUNTA(H$7:H35))))","v":""},"1200 C"]
[{"$f":"IF(ISBLANK(H36),\"\",($E$8&\".\"&+(COUNTA(H$7:H36))))","v":""},"8.3.1","(a)","Clear and grub strips for (where not cleared within"]
[{"$f":"IF(ISBLANK(H37),\"\",($E$8&\".\"&+(COUNTA(H$7:H37))))","v":""},"PSC2",null,"other clear and grub areas)"]
[{"$f":"IF(ISBLANK(H38),\"\",($E$8&\".\"&+(COUNTA(H$7:H38))))","v":""}]
[{"$f":"IF(ISBLANK(H39),\"\",($E$8&\".\"&+(COUNTA(H$7:H39))))","v":"5.7"},null,null,".1","Pipeline 3m wide",null,null,"m",7271]
[{"$f":"IF(ISBLANK(H40),\"\",($E$8&\".\"&+(COUNTA(H$7:H40))))","v":""}]
[{"$f":"IF(ISBLANK(H41),\"\",($E$8&\".\"&+(COUNTA(H$7:H41))))","v":""},"PSC3","REMOVE LARGE TREES AND STUMPS"]
[{"$f":"IF(ISBLANK(H42),\"\",($E$8&\".\"&+(COUNTA(H$7:H42))))","v":""}]
[{"$f":"IF(ISBLANK(H43),\"\",($E$8&\".\"&+(COUNTA(H$7:H43))))","v":""},"8.3.1","(b)","Remove and grub large trees and tree stumps of girth"]
[{"$f":"IF(ISBLANK(H44),\"\",($E$8&\".\"&+(COUNTA(H$7:H44))))","v":""}]
[{"$f":"IF(ISBLANK(H45),\"\",($E$8&\".\"&+(COUNTA(H$7:H45))))","v":"5.8"},null,null,".1","Exceeding 1m and up to and including 2m",null,null,"no",15]
[]
[{"$f":"IF(ISBLANK(H47),\"\",($E$8&\".\"&+(COUNTA(H$7:H47))))","v":"5.9"},null,null,".2","Exceeding 2m and up to and including 3m",null,null,"no",5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[null,"PSDB","TRENCHING"]
[]
[null,null,"Note:"]
[null,null,"Please note that dewatering of trenches must be priced under the P&G section of these bills of quantities under items 8.3.2.2.h and 8.4.2.2.h"]
[]
[{"$f":"IF(ISBLANK(H73),\"\",($E$8&\".\"&+(COUNTA(H$7:H73))))","v":""},"SANS","EXCAVATION AND BACKFILLING"]
[{"$f":"IF(ISBLANK(H74),\"\",($E$8&\".\"&+(COUNTA(H$7:H74))))","v":""},"1200 DB"]
[{"$f":"IF(ISBLANK(H75),\"\",($E$8&\".\"&+(COUNTA(H$7:H75))))","v":""},null,"Excavate in all materials, backfill and compact to 93%"]
[{"$f":"IF(ISBLANK(H76),\"\",($E$8&\".\"&+(COUNTA(H$7:H76))))","v":""},null,"mod AASHTO density, and dispose of surplus and"]
[{"$f":"IF(ISBLANK(H77),\"\",($E$8&\".\"&+(COUNTA(H$7:H77))))","v":""},null,"unsuitable materials for trenches"]
[{"$f":"IF(ISBLANK(H78),\"\",($E$8&\".\"&+(COUNTA(H$7:H78))))","v":""}]
[{"$f":"IF(ISBLANK(H79),\"\",($E$8&\".\"&+(COUNTA(H$7:H79))))","v":""},"8.3.2","(a)",".1","Up to 1m wide"]
[{"$f":"IF(ISBLANK(H80),\"\",($E$8&\".\"&+(COUNTA(H$7:H80))))","v":""}]
[{"$f":"IF(ISBLANK(H81),\"\",($E$8&\".\"&+(COUNTA(H$7:H81))))","v":"5.10"},null,null,null,".2","Over 1m and up to 2m deep",null,"m³",6123]
[{"$f":"IF(ISBLANK(H82),\"\",($E$8&\".\"&+(COUNTA(H$7:H82))))","v":""}]
[{"$f":"IF(ISBLANK(H83),\"\",($E$8&\".\"&+(COUNTA(H$7:H83))))","v":"5.11"},null,null,null,".3","Over 2m and up to 3m deep",null,"m³",5723]
[{"$f":"IF(ISBLANK(H84),\"\",($E$8&\".\"&+(COUNTA(H$7:H84))))","v":""}]
[{"$f":"IF(ISBLANK(H85),\"\",($E$8&\".\"&+(COUNTA(H$7:H85))))","v":"5.12"},null,null,null,".4","Over 3m and up to 4m deep",null,"m³",211]
[{"$f":"IF(ISBLANK(H86),\"\",($E$8&\".\"&+(COUNTA(H$7:H86))))","v":""}]
[{"$f":"IF(ISBLANK(H87),\"\",($E$8&\".\"&+(COUNTA(H$7:H87))))","v":"5.13"},null,null,null,".5","Over 4m and up to 5m deep",null,"m³",22]
[{"$f":"IF(ISBLANK(H88),\"\",($E$8&\".\"&+(COUNTA(H$7:H88))))","v":""}]
[{"$f":"IF(ISBLANK(H89),\"\",($E$8&\".\"&+(COUNTA(H$7:H89))))","v":"5.14"},null,null,null,".6","Over 5m and up to 6m deep",null,"m³",11]
[]
[{"$f":"IF(ISBLANK(H91),\"\",($E$8&\".\"&+(COUNTA(H$7:H91))))","v":""},"8.3.2","(b)","Extra over reference 8.3.2 (a) for"]
[{"$f":"IF(ISBLANK(H92),\"\",($E$8&\".\"&+(COUNTA(H$7:H92))))","v":""}]
[{"$f":"IF(ISBLANK(H93),\"\",($E$8&\".\"&+(COUNTA(H$7:H93))))","v":"5.15"},null,null,".2","Hard rock excavation",null,null,"m³",2300]
[]
[{"$f":"IF(ISBLANK(H95),\"\",($E$8&\".\"&+(COUNTA(H$7:H95))))","v":"5.16"},null,null,".3","Hard rock excavation (controlled blasting)",null,null,"m³",1000]
[{"$f":"IF(ISBLANK(H96),\"\",($E$8&\".\"&+(COUNTA(H$7:H96))))","v":""}]
[{"$f":"IF(ISBLANK(H97),\"\",($E$8&\".\"&+(COUNTA(H$7:H97))))","v":"5.17"},null,null,".4","Hard rock excavation (chemical blasting)",null,null,"m³",100]
[{"$f":"IF(ISBLANK(H98),\"\",($E$8&\".\"&+(COUNTA(H$7:H98))))","v":""}]
[{"$f":"IF(ISBLANK(H99),\"\",($E$8&\".\"&+(COUNTA(H$7:H99))))","v":""},"8.3.2","(c)","Excavate unsuitable material from trench bottom, "]
[{"$f":"IF(ISBLANK(H100),\"\",($E$8&\".\"&+(COUNTA(H$7:H100))))","v":""},null,null,"dispose of material, and re-fill with suitable imported"]
[{"$f":"IF(ISBLANK(H101),\"\",($E$8&\".\"&+(COUNTA(H$7:H102))))","v":"5.18"},null,null,"material compacted to 90% mod AASHTO density",null,null,null,"m³",50]
[{"$f":"IF(ISBLANK(H102),\"\",($E$8&\".\"&+(COUNTA(H$7:H102))))","v":""}]
[{"$f":"IF(ISBLANK(H103),\"\",($E$8&\".\"&+(COUNTA(H$7:H103))))","v":""},null,"DEFICIENCY IN BACKFILL MATERIAL"]
[{"$f":"IF(ISBLANK(H104),\"\",($E$8&\".\"&+(COUNTA(H$7:H104))))","v":""}]
[{"$f":"IF(ISBLANK(H105),\"\",($E$8&\".\"&+(COUNTA(H$7:H105))))","v":""},"8.3.3","Excavation ancillaries"]
[{"$f":"IF(ISBLANK(H106),\"\",($E$8&\".\"&+(COUNTA(H$7:H106))))","v":""}]
[{"$f":"IF(ISBLANK(H107),\"\",($E$8&\".\"&+(COUNTA(H$7:H107))))","v":""},null,".1","Make up deficiency in backfill material"]
[{"$f":"IF(ISBLANK(H108),\"\",($E$8&\".\"&+(COUNTA(H$7:H108))))","v":""}]
[{"$f":"IF(ISBLANK(H109),\"\",($E$8&\".\"&+(COUNTA(H$7:H109))))","v":"5.19"},null,null,"(a)","From other necessary excavations on site",null,null,"m³",150]
[{"$f":"IF(ISBLANK(H110),\"\",($E$8&\".\"&+(COUNTA(H$7:H110))))","v":""}]
[{"$f":"IF(ISBLANK(H111),\"\",($E$8&\".\"&+(COUNTA(H$7:H111))))","v":""},null,null,"(c)","By importation of G7 material from commercial"]
[{"$f":"IF(ISBLANK(H112),\"\",($E$8&\".\"&+(COUNTA(H$7:H112))))","v":"5.20"},null,null,null,"sources selected by the Contractor",null,null,"m³",150]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[{"$f":"IF(ISBLANK(H124),\"\",($E$8&\".\"&+(COUNTA(H$7:H194))))","v":""}]
[{"$f":"IF(ISBLANK(H125),\"\",($E$8&\".\"&+(COUNTA(H$7:H125))))","v":""},null,"SHORING OF TRENCHES"]
[{"$f":"IF(ISBLANK(H126),\"\",($E$8&\".\"&+(COUNTA(H$7:H126))))","v":""}]
[{"$f":"IF(ISBLANK(H127),\"\",($E$8&\".\"&+(COUNTA(H$7:H127))))","v":""},"8.3.4","(a)","Shore trench opposite structure or service"]
[{"$f":"IF(ISBLANK(H128),\"\",($E$8&\".\"&+(COUNTA(H$7:H128))))","v":""}]
[{"$f":"IF(ISBLANK(H129),\"\",($E$8&\".\"&+(COUNTA(H$7:H129))))","v":"5.21"},null,null,".1","Shoring of sewer trenches maximum 2m deep of approved method (both sides to be shored - measured as trench length and both sides to be priced in one measurement)",null,null,"m",100]
[{"$f":"IF(ISBLANK(H130),\"\",($E$8&\".\"&+(COUNTA(H$7:H130))))","v":""}]
[{"$f":"IF(ISBLANK(H131),\"\",($E$8&\".\"&+(COUNTA(H$7:H131))))","v":"5.22"},null,null,".2","Ditto maximum 4m deep",null,null,"m",100]
[]
[{"$f":"IF(ISBLANK(H133),\"\",($E$8&\".\"&+(COUNTA(H$7:H133))))","v":"5.23"},null,null,".3","Ditto maximum 6m deep",null,null,"m",10]
[]
[null,null,"EXISTING SERVICES"]
[]
[{"$f":"IF(ISBLANK(H137),\"\",($E$8&\".\"&+(COUNTA(H$7:H137))))","v":""},"PDBD2","WORK TO EXISTING SERVICES"]
[{"$f":"IF(ISBLANK(H138),\"\",($E$8&\".\"&+(COUNTA(H$7:H138))))","v":""}]
[{"$f":"IF(ISBLANK(H139),\"\",($E$8&\".\"&+(COUNTA(H$7:H139))))","v":""},null,"Existing services that intersect or adjoin  pipe trench"]
[{"$f":"IF(ISBLANK(H140),\"\",($E$8&\".\"&+(COUNTA(H$7:H140))))","v":""},null,"excavations"]
[{"$f":"IF(ISBLANK(H141),\"\",($E$8&\".\"&+(COUNTA(H$7:H141))))","v":""}]
[{"$f":"IF(ISBLANK(H142),\"\",($E$8&\".\"&+(COUNTA(H$7:H142))))","v":""},"8.3.5","(a)","Services that intersect a trench"]
[{"$f":"IF(ISBLANK(H143),\"\",($E$8&\".\"&+(COUNTA(H$7:H143))))","v":""}]
[{"$f":"IF(ISBLANK(H144),\"\",($E$8&\".\"&+(COUNTA(H$7:H144))))","v":"5.24"},null,null,".1","Electric cable",null,null,"no",75]
[{"$f":"IF(ISBLANK(H145),\"\",($E$8&\".\"&+(COUNTA(H$7:H145))))","v":""}]
[{"$f":"IF(ISBLANK(H146),\"\",($E$8&\".\"&+(COUNTA(H$7:H146))))","v":""},null,null,".4","Water main not exceeding 300mm dia"]
[{"$f":"IF(ISBLANK(H147),\"\",($E$8&\".\"&+(COUNTA(H$7:H147))))","v":"5.25"},null,null,null,"(house connection pipes not measurable)",null,null,"no",75]
[{"$f":"IF(ISBLANK(H148),\"\",($E$8&\".\"&+(COUNTA(H$7:H148))))","v":""}]
[{"$f":"IF(ISBLANK(H149),\"\",($E$8&\".\"&+(COUNTA(H$7:H149))))","v":"5.26"},null,null,".5","Sewer main not exceeding 300mm dia",null,null,"no",50]
[{"$f":"IF(ISBLANK(H150),\"\",($E$8&\".\"&+(COUNTA(H$7:H150))))","v":""}]
[{"$f":"IF(ISBLANK(H151),\"\",($E$8&\".\"&+(COUNTA(H$7:H151))))","v":"5.27"},null,null,".6","Stormwater pipe not exceeding 600mm dia",null,null,"no",50]
[{"$f":"IF(ISBLANK(H152),\"\",($E$8&\".\"&+(COUNTA(H$7:H152))))","v":""}]
[{"$f":"IF(ISBLANK(H153),\"\",($E$8&\".\"&+(COUNTA(H$7:H153))))","v":""},"8.3.5","(b)","Services that adjoin a trench"]
[{"$f":"IF(ISBLANK(H154),\"\",($E$8&\".\"&+(COUNTA(H$7:H154))))","v":""}]
[{"$f":"IF(ISBLANK(H155),\"\",($E$8&\".\"&+(COUNTA(H$7:H155))))","v":"5.28"},null,null,".1","Electric cable",null,null,"m",300]
[{"$f":"IF(ISBLANK(H156),\"\",($E$8&\".\"&+(COUNTA(H$7:H156))))","v":""}]
[{"$f":"IF(ISBLANK(H157),\"\",($E$8&\".\"&+(COUNTA(H$7:H157))))","v":""},null,null,".4","Water main not exceeding 300mm dia"]
[{"$f":"IF(ISBLANK(H158),\"\",($E$8&\".\"&+(COUNTA(H$7:H158))))","v":"5.29"},null,null,null,"(house connection pipes not measurable)",null,null,"m",400]
[]
[{"$f":"IF(ISBLANK(H160),\"\",($E$8&\".\"&+(COUNTA(H$7:H160))))","v":"5.30"},null,null,".5","Sewer main not exceeding 300mm dia",null,null,"m",400]
[{"$f":"IF(ISBLANK(H161),\"\",($E$8&\".\"&+(COUNTA(H$7:H161))))","v":""}]
[{"$f":"IF(ISBLANK(H162),\"\",($E$8&\".\"&+(COUNTA(H$7:H172))))","v":"5.31"},null,null,".6","Stormwater pipe not exceeding 600mm dia",null,null,"m",100]
[]
[null,null,"REPAIR ROADS AND PAVING"]
[]
[{"$f":"IF(ISBLANK(H166),\"\",($E$8&\".\"&+(COUNTA(H$7:H166))))","v":""},"SANS","FINISHING AND REPAIRING EXISTING ROAD "]
[{"$f":"IF(ISBLANK(H167),\"\",($E$8&\".\"&+(COUNTA(H$7:H167))))","v":""},"1200 DB","CROSSINGS COMPLETE"]
[{"$f":"IF(ISBLANK(H168),\"\",($E$8&\".\"&+(COUNTA(H$7:H168))))","v":""},"PSDB8"]
[{"$f":"IF(ISBLANK(H169),\"\",($E$8&\".\"&+(COUNTA(H$7:H169))))","v":""},"8.3.6.1","(a)","Layerworks including extra over item 8.3.2 for"]
[{"$f":"IF(ISBLANK(H170),\"\",($E$8&\".\"&+(COUNTA(H$7:H170))))","v":""},null,null,"carefull excavation and stockpiling of materials for"]
[{"$f":"IF(ISBLANK(H171),\"\",($E$8&\".\"&+(COUNTA(H$7:H171))))","v":""},null,null,"re-use, or replacing with new material, including all"]
[{"$f":"IF(ISBLANK(H172),\"\",($E$8&\".\"&+(COUNTA(H$7:H172))))","v":""},null,null,"accommodation of traffic and bypasses, complete"]
[{"$f":"IF(ISBLANK(H173),\"\",($E$8&\".\"&+(COUNTA(H$7:H173))))","v":""}]
[{"$f":"IF(ISBLANK(H174),\"\",($E$8&\".\"&+(COUNTA(H$7:H174))))","v":""},null,null,".1","G5 gravel shoulders 150mm thick compacted to"]
[{"$f":"IF(ISBLANK(H175),\"\",($E$8&\".\"&+(COUNTA(H$7:H175))))","v":"5.32"},null,null,null,"93% mod AASHTO density",null,null,"m²",250]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[{"$f":"IF(ISBLANK(H180),\"\",($E$8&\".\"&+(COUNTA(H$7:H180))))","v":""}]
[{"$f":"IF(ISBLANK(H181),\"\",($E$8&\".\"&+(COUNTA(H$7:H181))))","v":""},null,null,".2","G7 selected layer 150mm thick compacted to"]
[{"$f":"IF(ISBLANK(H182),\"\",($E$8&\".\"&+(COUNTA(H$7:H182))))","v":"5.33"},null,null,null,"93% mod AASHTO density",null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H183),\"\",($E$8&\".\"&+(COUNTA(H$7:H183))))","v":""}]
[{"$f":"IF(ISBLANK(H184),\"\",($E$8&\".\"&+(COUNTA(H$7:H184))))","v":""},null,null,".3","C4 stabilised subbase layer 150mm thick"]
[{"$f":"IF(ISBLANK(H185),\"\",($E$8&\".\"&+(COUNTA(H$7:H185))))","v":"5.34"},null,null,null,"compacted to 95% mod AASHTO density",null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H186),\"\",($E$8&\".\"&+(COUNTA(H$7:H186))))","v":""}]
[{"$f":"IF(ISBLANK(H187),\"\",($E$8&\".\"&+(COUNTA(H$7:H187))))","v":""},null,null,".4","G1 base layer 150mm thick compacted to"]
[{"$f":"IF(ISBLANK(H188),\"\",($E$8&\".\"&+(COUNTA(H$7:H188))))","v":"5.35"},null,null,null,"86% apparent density",null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H189),\"\",($E$8&\".\"&+(COUNTA(H$7:H189))))","v":""}]
[{"$f":"IF(ISBLANK(H190),\"\",($E$8&\".\"&+(COUNTA(H$7:H190))))","v":""},"8.3.6.1","(b)","Continuously graded medium asphalt, including"]
[{"$f":"IF(ISBLANK(H191),\"\",($E$8&\".\"&+(COUNTA(H$7:H191))))","v":""},null,null,"prime and tack coat preparation"]
[{"$f":"IF(ISBLANK(H192),\"\",($E$8&\".\"&+(COUNTA(H$7:H192))))","v":""}]
[{"$f":"IF(ISBLANK(H193),\"\",($E$8&\".\"&+(COUNTA(H$7:H193))))","v":"5.36"},null,null,".2","30mm Thick ",null,null,"m²",1250]
[]
[{"$f":"IF(ISBLANK(H195),\"\",($E$8&\".\"&+(COUNTA(H$7:H195))))","v":""},null,"REPAIRING KERBING"]
[{"$f":"IF(ISBLANK(H196),\"\",($E$8&\".\"&+(COUNTA(H$7:H196))))","v":""}]
[{"$f":"IF(ISBLANK(H197),\"\",($E$8&\".\"&+(COUNTA(H$7:H197))))","v":"5.37"},null,"Remove precast concrete kerbing and set aside for re-use",null,null,null,null,"m",900]
[{"$f":"IF(ISBLANK(H198),\"\",($E$8&\".\"&+(COUNTA(H$7:H198))))","v":""}]
[{"$f":"IF(ISBLANK(H199),\"\",($E$8&\".\"&+(COUNTA(H$7:H199))))","v":"5.38"},null,"Take from site precast concrete kerbing and re-install complete",null,null,null,null,"m",900]
[]
[{"$f":"IF(ISBLANK(H201),\"\",($E$8&\".\"&+(COUNTA(H$7:H201))))","v":""},"PSMJ","LIFTING EXISTING PAVING"]
[{"$f":"IF(ISBLANK(H202),\"\",($E$8&\".\"&+(COUNTA(H$7:H202))))","v":""},"SANS"]
[{"$f":"IF(ISBLANK(H203),\"\",($E$8&\".\"&+(COUNTA(H$7:H203))))","v":""},"1200 MJ","Lifting up existing paving blocks including neatly, "]
[{"$f":"IF(ISBLANK(H204),\"\",($E$8&\".\"&+(COUNTA(H$7:H204))))","v":""},"8.2.6","stacking on site designated by the Engineer"]
[{"$f":"IF(ISBLANK(H205),\"\",($E$8&\".\"&+(COUNTA(H$7:H205))))","v":""},null,"(to be re-used, and re-use measured elsewhere)"]
[{"$f":"IF(ISBLANK(H206),\"\",($E$8&\".\"&+(COUNTA(H$7:H206))))","v":""}]
[{"$f":"IF(ISBLANK(H207),\"\",($E$8&\".\"&+(COUNTA(H$7:H207))))","v":"5.39"},null,".1","Driveway or site paving (all types)",null,null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H208),\"\",($E$8&\".\"&+(COUNTA(H$7:H208))))","v":""}]
[{"$f":"IF(ISBLANK(H209),\"\",($E$8&\".\"&+(COUNTA(H$7:H209))))","v":""},null,"REINSTATEMENT OF EXISTING PAVING"]
[{"$f":"IF(ISBLANK(H210),\"\",($E$8&\".\"&+(COUNTA(H$7:H210))))","v":""}]
[{"$f":"IF(ISBLANK(H211),\"\",($E$8&\".\"&+(COUNTA(H$7:H211))))","v":""},"8.2.8","Take from stockpile on site existing paving blocks"]
[{"$f":"IF(ISBLANK(H212),\"\",($E$8&\".\"&+(COUNTA(H$7:H212))))","v":""},null,"and reinstate in similar position, including levelling "]
[{"$f":"IF(ISBLANK(H213),\"\",($E$8&\".\"&+(COUNTA(H$7:H213))))","v":""},null,"and compacting earthworks to 93% mod AASHTO "]
[{"$f":"IF(ISBLANK(H214),\"\",($E$8&\".\"&+(COUNTA(H$7:H214))))","v":""},null,"density, supply and lay new 20mm riversand bedding "]
[{"$f":"IF(ISBLANK(H215),\"\",($E$8&\".\"&+(COUNTA(H$7:H215))))","v":""},null,"and re-lay existing bricks, compacting and brooming "]
[{"$f":"IF(ISBLANK(H216),\"\",($E$8&\".\"&+(COUNTA(H$7:H216))))","v":""},null,"in plastesand into joints on completion"]
[{"$f":"IF(ISBLANK(H217),\"\",($E$8&\".\"&+(COUNTA(H$7:H217))))","v":""}]
[{"$f":"IF(ISBLANK(H218),\"\",($E$8&\".\"&+(COUNTA(H$7:H218))))","v":"5.40"},null,".1","Driveway or site paving (all types)",null,null,null,"m²",1250]
[]
[5.41,null,"Procure to site paving blocks including levelling ",null,null,null,null,"m²",250]
[null,null,"and compacting earthworks to 93% mod AASHTO "]
[null,null,"density, supply and lay new 20mm riversand bedding "]
[null,null,"and lay 60mm new bricks, compacting and brooming "]
[null,null,"in plastesand into joints on completion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[{"$f":"IF(ISBLANK(H239),\"\",($E$8&\".\"&+(COUNTA(H$7:H239))))","v":""},null,"CONCRETE DRIVEWAYS AND WALKWAYS ETC."]
[{"$f":"IF(ISBLANK(H240),\"\",($E$8&\".\"&+(COUNTA(H$7:H240))))","v":""},"SANS"]
[{"$f":"IF(ISBLANK(H241),\"\",($E$8&\".\"&+(COUNTA(H$7:H241))))","v":"5.42"},"1200 MK","Demolish existing concrete, not exceeding 100mm ",null,null,null,null,"m³",300]
[{"$f":"IF(ISBLANK(H242),\"\",($E$8&\".\"&+(COUNTA(H$7:H242))))","v":""},null,"thickness, and spoil at an appropriate site found by "]
[null,null,"the Contractor."]
[]
[{"$f":"IF(ISBLANK(H245),\"\",($E$8&\".\"&+(COUNTA(H$7:H245))))","v":"5.43"},"8.2.8","Cast insitu concrete, 25Mpa/19mm, to 100mm",null,null,null,null,"m³",300]
[null,null,"thickness"]
[]
[null,"8.2.10","Sealed joints to concrete driveways and walkways etc."]
[]
[null,null,"(b)","10mm Sondor Jointex expansion joint 150mm "]
[null,null,null,"high between concrete faces, including formwork"]
[null,null,null,"and raking out 10mm expansion joint material "]
[null,null,null,"to a depth of 20mm, prime with approved"]
[null,null,null,"primer and fill joint with approved"]
[{"$f":"IF(ISBLANK(H255),\"\",($E$8&\".\"&+(COUNTA(H$7:H255))))","v":"5.44"},null,null,"polyurethane sealer",null,null,null,"m",1000]
[]
[{"$f":"IF(ISBLANK(H257),\"\",($E$8&\".\"&+(COUNTA(H$7:H257))))","v":""},"PSLB","BEDDING FROM TRENCH EXCAVATIONS"]
[{"$f":"IF(ISBLANK(H258),\"\",($E$8&\".\"&+(COUNTA(H$7:H258))))","v":""},"SANS"]
[{"$f":"IF(ISBLANK(H259),\"\",($E$8&\".\"&+(COUNTA(H$7:H259))))","v":""},"1200 LB","Provision of bedding material from trench excavations"]
[{"$f":"IF(ISBLANK(H260),\"\",($E$8&\".\"&+(COUNTA(H$7:H260))))","v":""},"8.2.1"]
[{"$f":"IF(ISBLANK(H261),\"\",($E$8&\".\"&+(COUNTA(H$7:H261))))","v":"5.45"},null,"(a)","Selected granular material ",null,null,null,"m³",100]
[{"$f":"IF(ISBLANK(H262),\"\",($E$8&\".\"&+(COUNTA(H$7:H262))))","v":""}]
[{"$f":"IF(ISBLANK(H263),\"\",($E$8&\".\"&+(COUNTA(H$7:H263))))","v":"5.46"},null,"(b)","Selected fill material",null,null,null,"m³",100]
[]
[{"$f":"IF(ISBLANK(H265),\"\",($E$8&\".\"&+(COUNTA(H$7:H265))))","v":""},null,"BEDDING FROM OTHER EXCAVATIONS ON SITE"]
[{"$f":"IF(ISBLANK(H266),\"\",($E$8&\".\"&+(COUNTA(H$7:H266))))","v":""}]
[{"$f":"IF(ISBLANK(H267),\"\",($E$8&\".\"&+(COUNTA(H$7:H267))))","v":""},"8.2.2",".1","Provision of bedding material by importation from"]
[{"$f":"IF(ISBLANK(H268),\"\",($E$8&\".\"&+(COUNTA(H$7:H268))))","v":""},null,null,"other necessary excavations within the freehaul "]
[{"$f":"IF(ISBLANK(H269),\"\",($E$8&\".\"&+(COUNTA(H$7:H269))))","v":""},null,null,"distance"]
[{"$f":"IF(ISBLANK(H270),\"\",($E$8&\".\"&+(COUNTA(H$7:H270))))","v":""}]
[{"$f":"IF(ISBLANK(H271),\"\",($E$8&\".\"&+(COUNTA(H$7:H271))))","v":"5.47"},null,null,"(a)","Selected granular material ",null,null,"m³",100]
[{"$f":"IF(ISBLANK(H272),\"\",($E$8&\".\"&+(COUNTA(H$7:H272))))","v":""}]
[{"$f":"IF(ISBLANK(H273),\"\",($E$8&\".\"&+(COUNTA(H$7:H273))))","v":"5.48"},null,null,"(b)","Selected fill material",null,null,"m³",100]
[{"$f":"IF(ISBLANK(H274),\"\",($E$8&\".\"&+(COUNTA(H$7:H274))))","v":""}]
[{"$f":"IF(ISBLANK(H275),\"\",($E$8&\".\"&+(COUNTA(H$7:H275))))","v":""},"PSLB2","BEDDING FROM COMMERCIAL SOURCES"]
[{"$f":"IF(ISBLANK(H276),\"\",($E$8&\".\"&+(COUNTA(H$7:H276))))","v":""}]
[{"$f":"IF(ISBLANK(H277),\"\",($E$8&\".\"&+(COUNTA(H$7:H277))))","v":""},"8.2.2",".3","Provision of bedding material by importation from "]
[{"$f":"IF(ISBLANK(H278),\"\",($E$8&\".\"&+(COUNTA(H$7:H278))))","v":""},null,null,"commercial sources selected by the Contractor"]
[{"$f":"IF(ISBLANK(H279),\"\",($E$8&\".\"&+(COUNTA(H$7:H279))))","v":""}]
[{"$f":"IF(ISBLANK(H280),\"\",($E$8&\".\"&+(COUNTA(H$7:H280))))","v":"5.49"},null,null,"(a)","Selected granular material ",null,null,"m³",1100]
[{"$f":"IF(ISBLANK(H281),\"\",($E$8&\".\"&+(COUNTA(H$7:H281))))","v":""}]
[{"$f":"IF(ISBLANK(H282),\"\",($E$8&\".\"&+(COUNTA(H$7:H282))))","v":"5.50"},null,null,"(b)","Selected fill material",null,null,"m³",1100]
[{"$f":"IF(ISBLANK(H283),\"\",($E$8&\".\"&+(COUNTA(H$7:H283))))","v":""}]
[{"$f":"IF(ISBLANK(H284),\"\",($E$8&\".\"&+(COUNTA(H$7:H284))))","v":"5.51"},null,null,"(c)","19mm Crushed stone drainage material",null,null,"m³",{"$f":"845*0.2","v":169}]
[{"$f":"IF(ISBLANK(H285),\"\",($E$8&\".\"&+(COUNTA(H$7:H285))))","v":""}]
[{"$f":"IF(ISBLANK(H286),\"\",($E$8&\".\"&+(COUNTA(H$7:H286))))","v":"5.52"},null,null,"(d)","Bidim A2 fabric wrapped around crushed stone",null,null,"m²",{"$f":"14600*0.2","v":2920}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[{"$f":"IF(ISBLANK(H297),\"\",($E$8&\".\"&+(COUNTA(H$7:H297))))","v":""},"SANS","uPVC SEWER PIPES"]
[{"$f":"IF(ISBLANK(H298),\"\",($E$8&\".\"&+(COUNTA(H$7:H298))))","v":""},"1200 LD"]
[{"$f":"IF(ISBLANK(H299),\"\",($E$8&\".\"&+(COUNTA(H$7:H299))))","v":""},"8.2.1","(a)","Supply, lay, joint, bed (flexible pipe bedding) and test "]
[{"$f":"IF(ISBLANK(H300),\"\",($E$8&\".\"&+(COUNTA(H$7:H300))))","v":""},"PSLD",null,"uPVC class 34 spigot and socket sewer pipes "]
[{"$f":"IF(ISBLANK(H301),\"\",($E$8&\".\"&+(COUNTA(H$7:H301))))","v":""},null,null,"with moulded rubber rings to SABS 791"]
[{"$f":"IF(ISBLANK(H302),\"\",($E$8&\".\"&+(COUNTA(H$7:H302))))","v":""}]
[{"$f":"IF(ISBLANK(H303),\"\",($E$8&\".\"&+(COUNTA(H$7:H303))))","v":"5.53"},null,null,".2","160mm Diameter",null,null,"m",6182]
[{"$f":"IF(ISBLANK(H304),\"\",($E$8&\".\"&+(COUNTA(H$7:H304))))","v":""}]
[{"$f":"IF(ISBLANK(H305),\"\",($E$8&\".\"&+(COUNTA(H$7:H305))))","v":"5.54"},null,null,".3","200mm Diameter ",null,null,"m",341]
[{"$f":"IF(ISBLANK(H306),\"\",($E$8&\".\"&+(COUNTA(H$7:H306))))","v":""}]
[{"$f":"IF(ISBLANK(H307),\"\",($E$8&\".\"&+(COUNTA(H$7:H307))))","v":"5.55"},null,null,".4","250mm Diameter ",null,null,"m",459]
[{"$f":"IF(ISBLANK(H308),\"\",($E$8&\".\"&+(COUNTA(H$7:H308))))","v":""}]
[{"$f":"IF(ISBLANK(H309),\"\",($E$8&\".\"&+(COUNTA(H$7:H309))))","v":"5.56"},null,null,".5","315mm Diameter",null,null,"m",289]
[]
[null,null,null,6,"110mm Perforated Pipe (Subsoil drainage)",null,null,"m",200]
[]
[{"$f":"IF(ISBLANK(H313),\"\",($E$8&\".\"&+(COUNTA(H$7:H313))))","v":""},"PSLD2","MANHOLES"]
[{"$f":"IF(ISBLANK(H314),\"\",($E$8&\".\"&+(COUNTA(H$7:H314))))","v":""},null,"Precast concrete manholes complete with precast concrete"]
[{"$f":"IF(ISBLANK(H315),\"\",($E$8&\".\"&+(COUNTA(H$7:H315))))","v":""},null,"cover slab and heavy duty cover and frame as specified"]
[{"$f":"IF(ISBLANK(H316),\"\",($E$8&\".\"&+(COUNTA(H$7:H316))))","v":""},null,"Dwg LSO-228-SW-TD01"]
[{"$f":"IF(ISBLANK(H317),\"\",($E$8&\".\"&+(COUNTA(H$7:H317))))","v":""}]
[{"$f":"IF(ISBLANK(H318),\"\",($E$8&\".\"&+(COUNTA(H$7:H318))))","v":""},"8.2.3","(a)",".1","Manholes 1000mm diameter (straight & angle)"]
[{"$f":"IF(ISBLANK(H319),\"\",($E$8&\".\"&+(COUNTA(H$7:H319))))","v":""}]
[{"$f":"IF(ISBLANK(H320),\"\",($E$8&\".\"&+(COUNTA(H$7:H320))))","v":"5.58"},null,null,null,".2","1,0 - 1,5m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H321),\"\",($E$8&\".\"&+(COUNTA(H$7:H321))))","v":""}]
[{"$f":"IF(ISBLANK(H322),\"\",($E$8&\".\"&+(COUNTA(H$7:H322))))","v":"5.59"},null,null,null,".3","1,5 - 2,0m Deep",null,"no",25]
[{"$f":"IF(ISBLANK(H323),\"\",($E$8&\".\"&+(COUNTA(H$7:H323))))","v":""}]
[{"$f":"IF(ISBLANK(H324),\"\",($E$8&\".\"&+(COUNTA(H$7:H324))))","v":"5.60"},null,null,null,".4","2,0 - 2,5m Deep",null,"no",14]
[]
[{"$f":"IF(ISBLANK(H326),\"\",($E$8&\".\"&+(COUNTA(H$7:H326))))","v":"5.61"},null,null,null,".5","2,5 - 3,0m Deep",null,"no",9]
[{"$f":"IF(ISBLANK(H327),\"\",($E$8&\".\"&+(COUNTA(H$7:H327))))","v":""}]
[{"$f":"IF(ISBLANK(H328),\"\",($E$8&\".\"&+(COUNTA(H$7:H328))))","v":"5.62"},null,null,null,".6","3.0 - 3.5m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H329),\"\",($E$8&\".\"&+(COUNTA(H$7:H329))))","v":""}]
[{"$f":"IF(ISBLANK(H330),\"\",($E$8&\".\"&+(COUNTA(H$7:H330))))","v":"5.63"},null,null,null,".7","3.5 - 4.0m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H331),\"\",($E$8&\".\"&+(COUNTA(H$7:H331))))","v":""}]
[{"$f":"IF(ISBLANK(H332),\"\",($E$8&\".\"&+(COUNTA(H$7:H332))))","v":"5.64"},null,null,null,".8","4.0 - 4.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H333),\"\",($E$8&\".\"&+(COUNTA(H$7:H333))))","v":""}]
[{"$f":"IF(ISBLANK(H334),\"\",($E$8&\".\"&+(COUNTA(H$7:H334))))","v":"5.65"},null,null,null,".9","4.5 - 5.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H335),\"\",($E$8&\".\"&+(COUNTA(H$7:H335))))","v":""}]
[{"$f":"IF(ISBLANK(H336),\"\",($E$8&\".\"&+(COUNTA(H$7:H336))))","v":""},"8.2.3","(a)",".2","Manholes 1250mm diameter (single junction)"]
[{"$f":"IF(ISBLANK(H337),\"\",($E$8&\".\"&+(COUNTA(H$7:H337))))","v":""}]
[{"$f":"IF(ISBLANK(H338),\"\",($E$8&\".\"&+(COUNTA(H$7:H338))))","v":"5.66"},null,null,null,".2","1,0 - 1,5m Deep",null,"no",2]
[]
[{"$f":"IF(ISBLANK(H340),\"\",($E$8&\".\"&+(COUNTA(H$7:H340))))","v":"5.67"},null,null,null,".3","1,5 - 2,0m Deep",null,"no",16]
[]
[{"$f":"IF(ISBLANK(H342),\"\",($E$8&\".\"&+(COUNTA(H$7:H342))))","v":"5.68"},null,null,null,".4","2,0 - 2,5m Deep",null,"no",10]
[{"$f":"IF(ISBLANK(H343),\"\",($E$8&\".\"&+(COUNTA(H$7:H343))))","v":""}]
[{"$f":"IF(ISBLANK(H344),\"\",($E$8&\".\"&+(COUNTA(H$7:H344))))","v":"5.69"},null,null,null,".5","2,5 - 3,0m Deep",null,"no",4]
[{"$f":"IF(ISBLANK(H345),\"\",($E$8&\".\"&+(COUNTA(H$7:H345))))","v":""}]
[{"$f":"IF(ISBLANK(H346),\"\",($E$8&\".\"&+(COUNTA(H$7:H346))))","v":"5.70"},null,null,null,".6","3.0 - 3.5m Deep",null,"no",2]
[]
[{"$f":"IF(ISBLANK(H348),\"\",($E$8&\".\"&+(COUNTA(H$7:H348))))","v":"5.71"},null,null,null,".7","3.5 - 4.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H349),\"\",($E$8&\".\"&+(COUNTA(H$7:H349))))","v":""}]
[{"$f":"IF(ISBLANK(H350),\"\",($E$8&\".\"&+(COUNTA(H$7:H350))))","v":"5.72"},null,null,null,".8","4.0 - 4.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H351),\"\",($E$8&\".\"&+(COUNTA(H$7:H351))))","v":""}]
[{"$f":"IF(ISBLANK(H352),\"\",($E$8&\".\"&+(COUNTA(H$7:H355))))","v":"5.73"},null,null,null,".9","4.5 - 5.0m Deep",null,"no",1]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[{"$f":"IF(ISBLANK(H357),\"\",($E$8&\".\"&+(COUNTA(H$7:H357))))","v":""},"8.2.3","(a)",".3","Manholes 1500mm diameter (double junction)"]
[{"$f":"IF(ISBLANK(H358),\"\",($E$8&\".\"&+(COUNTA(H$7:H358))))","v":""}]
[{"$f":"IF(ISBLANK(H359),\"\",($E$8&\".\"&+(COUNTA(H$7:H359))))","v":"5.74"},null,null,null,".2","1,0 - 1,5m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H360),\"\",($E$8&\".\"&+(COUNTA(H$7:H360))))","v":""}]
[{"$f":"IF(ISBLANK(H361),\"\",($E$8&\".\"&+(COUNTA(H$7:H361))))","v":"5.75"},null,null,null,".3","1,5 - 2,0m Deep",null,"no",12]
[{"$f":"IF(ISBLANK(H362),\"\",($E$8&\".\"&+(COUNTA(H$7:H362))))","v":""}]
[{"$f":"IF(ISBLANK(H363),\"\",($E$8&\".\"&+(COUNTA(H$7:H363))))","v":"5.76"},null,null,null,".4","2,0 - 2,5m Deep",null,"no",8]
[{"$f":"IF(ISBLANK(H364),\"\",($E$8&\".\"&+(COUNTA(H$7:H364))))","v":""}]
[{"$f":"IF(ISBLANK(H365),\"\",($E$8&\".\"&+(COUNTA(H$7:H365))))","v":"5.77"},null,null,null,".5","2,5 - 3,0m Deep",null,"no",4]
[{"$f":"IF(ISBLANK(H366),\"\",($E$8&\".\"&+(COUNTA(H$7:H366))))","v":""}]
[{"$f":"IF(ISBLANK(H367),\"\",($E$8&\".\"&+(COUNTA(H$7:H367))))","v":"5.78"},null,null,null,".6","3.0 - 3.5m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H368),\"\",($E$8&\".\"&+(COUNTA(H$7:H368))))","v":""}]
[{"$f":"IF(ISBLANK(H369),\"\",($E$8&\".\"&+(COUNTA(H$7:H369))))","v":"5.79"},null,null,null,".7","3.5 - 4.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H370),\"\",($E$8&\".\"&+(COUNTA(H$7:H370))))","v":""}]
[{"$f":"IF(ISBLANK(H371),\"\",($E$8&\".\"&+(COUNTA(H$7:H371))))","v":"5.80"},null,null,null,".8","4.0 - 4.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H372),\"\",($E$8&\".\"&+(COUNTA(H$7:H372))))","v":""}]
[{"$f":"IF(ISBLANK(H373),\"\",($E$8&\".\"&+(COUNTA(H$7:H373))))","v":"5.81"},null,null,null,".9","4.5 - 5.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H374),\"\",($E$8&\".\"&+(COUNTA(H$7:H374))))","v":""}]
[{"$f":"IF(ISBLANK(H375),\"\",($E$8&\".\"&+(COUNTA(H$7:H375))))","v":""},null,"ERF CONNECTIONS"]
[null,null,"Note:"]
[null,null,"Erf connections are to be installed up to 1m inside the residential stand boundary"]
[]
[null,null,"Removal and re-installation of boundary fences and walls, or tunneling below perimeter fences and walls are measured elsewhere"]
[]
[null,null,"Contractors are to allow for hand excavation for installation of the erf connections inside the erf boundary (approximately 1m long)"]
[]
[{"$f":"IF(ISBLANK(H383),\"\",($E$8&\".\"&+(COUNTA(H$7:H383))))","v":""},null,"ERF CONNECTIONS"]
[{"$f":"IF(ISBLANK(H384),\"\",($E$8&\".\"&+(COUNTA(H$7:H384))))","v":""}]
[{"$f":"IF(ISBLANK(H385),\"\",($E$8&\".\"&+(COUNTA(H$7:H385))))","v":""},null,"Supply and install erf connections complete  with all"]
[{"$f":"IF(ISBLANK(H386),\"\",($E$8&\".\"&+(COUNTA(H$7:H386))))","v":""},null,"fittings as described including excavation, bedding,"]
[{"$f":"IF(ISBLANK(H387),\"\",($E$8&\".\"&+(COUNTA(H$7:H387))))","v":""},null,"backfilling to 93% mod AASHTO density, testing, etc "]
[{"$f":"IF(ISBLANK(H388),\"\",($E$8&\".\"&+(COUNTA(H$7:H388))))","v":""},null,"complete"]
[{"$f":"IF(ISBLANK(H389),\"\",($E$8&\".\"&+(COUNTA(H$7:H389))))","v":""},null,"Dwg :LSO-228-SW-TD05"]
[{"$f":"IF(ISBLANK(H390),\"\",($E$8&\".\"&+(COUNTA(H$7:H390))))","v":""}]
[{"$f":"IF(ISBLANK(H391),\"\",($E$8&\".\"&+(COUNTA(H$7:H391))))","v":""},"8.2.6","Direct erf connections type 1 not exceeding 2m deep"]
[]
[{"$f":"IF(ISBLANK(H393),\"\",($E$8&\".\"&+(COUNTA(H$7:H393))))","v":"5.82"},null,"(a)","110mm Single connection (type D1 & D2)",null,null,null,"no",429]
[{"$f":"IF(ISBLANK(H394),\"\",($E$8&\".\"&+(COUNTA(H$7:H394))))","v":""}]
[{"$f":"IF(ISBLANK(H395),\"\",($E$8&\".\"&+(COUNTA(H$7:H395))))","v":""},"8.2.6","Sloping drop connections type 2 not exceeding 3m deep"]
[]
[{"$f":"IF(ISBLANK(H397),\"\",($E$8&\".\"&+(COUNTA(H$7:H397))))","v":"5.83"},null,"(c)","110mm Single connection (type SD1 & SD2)",null,null,null,"no",496]
[]
[{"$f":"IF(ISBLANK(H399),\"\",($E$8&\".\"&+(COUNTA(H$7:H399))))","v":""},"8.2.6","Vertical drop connections type 3 not exceeding 6m deep"]
[{"$f":"IF(ISBLANK(H400),\"\",($E$8&\".\"&+(COUNTA(H$7:H400))))","v":""}]
[{"$f":"IF(ISBLANK(H401),\"\",($E$8&\".\"&+(COUNTA(H$7:H401))))","v":"5.84"},null,"(e)","110mm Single connection (type VD1 & VD2)",null,null,null,"no",1]
[{"$f":"IF(ISBLANK(H402),\"\",($E$8&\".\"&+(COUNTA(H$7:H402))))","v":""}]
[{"$f":"IF(ISBLANK(H403),\"\",($E$8&\".\"&+(COUNTA(H$7:H403))))","v":""},"8.2.6","Extra over  reference 8.2.6 for sewer pipes crossing the "]
[{"$f":"IF(ISBLANK(H404),\"\",($E$8&\".\"&+(COUNTA(H$7:H404))))","v":""},null,"road including all excavations, bedding, backfilling to 93%"]
[{"$f":"IF(ISBLANK(H405),\"\",($E$8&\".\"&+(COUNTA(H$7:H405))))","v":""},null,"mod AASHTO density, etc complete"]
[{"$f":"IF(ISBLANK(H406),\"\",($E$8&\".\"&+(COUNTA(H$7:H406))))","v":""}]
[{"$f":"IF(ISBLANK(H407),\"\",($E$8&\".\"&+(COUNTA(H$7:H410))))","v":"5.85"},null,"(h)","110mm Diameter",null,null,null,"m",3750]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[{"$f":"IF(ISBLANK(H411),\"\",($E$8&\".\"&+(COUNTA(H$7:H411))))","v":""}]
[{"$f":"IF(ISBLANK(H412),\"\",($E$8&\".\"&+(COUNTA(H$7:H412))))","v":""},null,"SUNDRIES"]
[]
[{"$f":"IF(ISBLANK(H414),\"\",($E$8&\".\"&+(COUNTA(H$7:H414))))","v":""},null,"CONCRETE ENCASEMENT AND THRUST BLOCKS"]
[{"$f":"IF(ISBLANK(H415),\"\",($E$8&\".\"&+(COUNTA(H$7:H415))))","v":""}]
[{"$f":"IF(ISBLANK(H416),\"\",($E$8&\".\"&+(COUNTA(H$7:H416))))","v":""},"8.2.7","Encasement of pipes in strength concrete 25Mpa/19mm"]
[{"$f":"IF(ISBLANK(H417),\"\",($E$8&\".\"&+(COUNTA(H$7:H417))))","v":""},null,"including all formwork, reinforcement, etc"]
[{"$f":"IF(ISBLANK(H418),\"\",($E$8&\".\"&+(COUNTA(H$7:H418))))","v":""}]
[{"$f":"IF(ISBLANK(H419),\"\",($E$8&\".\"&+(COUNTA(H$7:H419))))","v":"5.86"},null,"(a)","Casing around pipes",null,null,null,"m³",10]
[]
[{"$f":"IF(ISBLANK(H421),\"\",($E$8&\".\"&+(COUNTA(H$7:H421))))","v":""},null,"SOILCRETE"]
[{"$f":"IF(ISBLANK(H422),\"\",($E$8&\".\"&+(COUNTA(H$7:H422))))","v":""}]
[{"$f":"IF(ISBLANK(H423),\"\",($E$8&\".\"&+(COUNTA(H$7:H423))))","v":""},null,"Soilcrete (5% OPC) "]
[{"$f":"IF(ISBLANK(H424),\"\",($E$8&\".\"&+(COUNTA(H$7:H424))))","v":""}]
[{"$f":"IF(ISBLANK(H425),\"\",($E$8&\".\"&+(COUNTA(H$7:H425))))","v":"5.87"},null,"(a)","Backfilling around pipes",null,null,null,"m³",20]
[{"$f":"IF(ISBLANK(H426),\"\",($E$8&\".\"&+(COUNTA(H$7:H426))))","v":""}]
[{"$f":"IF(ISBLANK(H427),\"\",($E$8&\".\"&+(COUNTA(H$7:H427))))","v":""},null,"KERB MARKINGS"]
[{"$f":"IF(ISBLANK(H428),\"\",($E$8&\".\"&+(COUNTA(H$7:H428))))","v":""}]
[{"$f":"IF(ISBLANK(H429),\"\",($E$8&\".\"&+(COUNTA(H$7:H429))))","v":""},null,"Markings and marker posts , etc"]
[{"$f":"IF(ISBLANK(H430),\"\",($E$8&\".\"&+(COUNTA(H$7:H430))))","v":""}]
[{"$f":"IF(ISBLANK(H431),\"\",($E$8&\".\"&+(COUNTA(H$7:H431))))","v":""},"8.2.9","(a)","Inscribed and painted marking on kerbing "]
[{"$f":"IF(ISBLANK(H432),\"\",($E$8&\".\"&+(COUNTA(H$7:H432))))","v":""}]
[{"$f":"IF(ISBLANK(H433),\"\",($E$8&\".\"&+(COUNTA(H$7:H433))))","v":"5.88"},null,null,".1","Kerb marking",null,null,"no",925]
[]
[{"$f":"IF(ISBLANK(H435),\"\",($E$8&\".\"&+(COUNTA(H$7:H435))))","v":""},null,"CCTV CAMERA INSPECTION OF PIPES"]
[{"$f":"IF(ISBLANK(H436),\"\",($E$8&\".\"&+(COUNTA(H$7:H436))))","v":""}]
[{"$f":"IF(ISBLANK(H437),\"\",($E$8&\".\"&+(COUNTA(H$7:H437))))","v":""},"8.2.14","CCTV camera inspection of sewer pipes to include"]
[{"$f":"IF(ISBLANK(H438),\"\",($E$8&\".\"&+(COUNTA(H$7:H438))))","v":""},null,"establishment, camera inspections and submission of"]
[{"$f":"IF(ISBLANK(H439),\"\",($E$8&\".\"&+(COUNTA(H$7:H439))))","v":""},null,"inspection report for approval by the Engineer"]
[]
[{"$f":"IF(ISBLANK(H441),\"\",($E$8&\".\"&+(COUNTA(H$7:H441))))","v":"5.89"},null,"(a)","160mm Dia sewer line",null,null,null,"m",6182]
[{"$f":"IF(ISBLANK(H442),\"\",($E$8&\".\"&+(COUNTA(H$7:H442))))","v":""}]
[{"$f":"IF(ISBLANK(H443),\"\",($E$8&\".\"&+(COUNTA(H$7:H443))))","v":"5.90"},null,"(b)","200mm Dia sewer line",null,null,null,"m",341]
[{"$f":"IF(ISBLANK(H444),\"\",($E$8&\".\"&+(COUNTA(H$7:H444))))","v":""}]
[{"$f":"IF(ISBLANK(H445),\"\",($E$8&\".\"&+(COUNTA(H$7:H445))))","v":"5.91"},null,"(c)","250mm Dia sewer line",null,null,null,"m",459]
[{"$f":"IF(ISBLANK(H446),\"\",($E$8&\".\"&+(COUNTA(H$7:H446))))","v":""}]
[{"$f":"IF(ISBLANK(H447),\"\",($E$8&\".\"&+(COUNTA(H$7:H447))))","v":"5.92"},null,"(d)","315mm Dia sewer line",null,null,null,"m",289]
[]
[]
[{"$f":"IF(ISBLANK(H450),\"\",($E$8&\".\"&+(COUNTA(H$7:H450))))","v":""},null,"WORK TO EXISTING SERVICES"]
[{"$f":"IF(ISBLANK(H451),\"\",($E$8&\".\"&+(COUNTA(H$7:H451))))","v":""}]
[{"$f":"IF(ISBLANK(H452),\"\",($E$8&\".\"&+(COUNTA(H$7:H452))))","v":""},"8.2.11","Connection to existing sewer manhole"]
[{"$f":"IF(ISBLANK(H453),\"\",($E$8&\".\"&+(COUNTA(H$7:H453))))","v":""}]
[{"$f":"IF(ISBLANK(H454),\"\",($E$8&\".\"&+(COUNTA(H$7:H454))))","v":"5.93"},null,"(a)","160mm Diameter pipe ",null,null,null,"no",25]
[{"$f":"IF(ISBLANK(H455),\"\",($E$8&\".\"&+(COUNTA(H$7:H459))))","v":""}]
[{"$f":"IF(ISBLANK(H456),\"\",($E$8&\".\"&+(COUNTA(H$7:H456))))","v":"5.94"},null,"(b)","200mm Diameter pipe ",null,null,null,"no",2]
[{"$f":"IF(ISBLANK(H457),\"\",($E$8&\".\"&+(COUNTA(H$7:H457))))","v":""}]
[{"$f":"IF(ISBLANK(H458),\"\",($E$8&\".\"&+(COUNTA(H$7:H459))))","v":"5.95"},null,"(c)","250mm Diameter pipe ",null,null,null,"no",3]
[]
[{"$f":"IF(ISBLANK(H460),\"\",($E$8&\".\"&+(COUNTA(H$7:H460))))","v":"5.96"},null,"(d)","315mm Diameter pipe ",null,null,null,"no",1]
[{"$f":"IF(ISBLANK(H461),\"\",($E$8&\".\"&+(COUNTA(H$7:H461))))","v":""}]
[{"$f":"IF(ISBLANK(H462),\"\",($E$8&\".\"&+(COUNTA(H$7:H462))))","v":""},"8.2.12","Raising or lowering of existing manholes"]
[{"$f":"IF(ISBLANK(H463),\"\",($E$8&\".\"&+(COUNTA(H$7:H463))))","v":""}]
[{"$f":"IF(ISBLANK(H464),\"\",($E$8&\".\"&+(COUNTA(H$7:H466))))","v":"5.97"},null,"(a)","Remove manhole cover slab with access cover and frame and set aside for re-use, remove manhole ring sections to obtain the correct manhole height and hand over to the Engineer for storage, and re-install manhole cover slab with cover and frame and seal manhole watertight",null,null,null,"no",51]
[]
[]
[{"$f":"IF(ISBLANK(H467),\"\",($E$8&\".\"&+(COUNTA(H$7:H467))))","v":""},null,"uPVC SEWERS"]
[{"$f":"IF(ISBLANK(H468),\"\",($E$8&\".\"&+(COUNTA(H$7:H468))))","v":""},null,"Carried forward to Summary of Bills",null,null,null,null,null,null,"Total"]

{"sheet":"rebuild sewers","index":5,"n_rows":388,"n_cols":11,"rows_kept":388,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,6],[4,7,5,7],[4,8,5,8],[10,2,10,6],[197,2,197,6],[199,2,199,6],[201,2,201,6],[325,2,325,6],[27,4,27,6],[29,2,29,6],[38,2,38,6],[84,4,84,6],[86,4,86,6],[88,4,88,6],[90,2,90,6],[131,2,131,6],[160,2,160,6],[162,2,162,6],[41,2,41,6]]}
[{"$f":"'A-P&G '!A1","v":"Contract:  RLM/OMM/0156/2024/25"}]
["Part C2:  Pricing Data"]
["Section C2.2:  Bill of Quantities"]
["uPVC Sewers"]
["Item","Payment","Description",null,null,null,null,"Unit","Qty","Rate","Amount"]
[null,"Reference",null,null,null,null,null,null,null,"(R)","(R)"]
[]
[null,"SANS","BILL NO",null,6]
[null,"1200 LD","REBUILD SEWERS"]
[]
[{"$f":"IF(ISBLANK(H11),\"\",($E$8&\".\"&+(COUNTA(H$7:H11))))","v":""},null,"DEMOLITIONS"]
[]
[{"$f":"IF(ISBLANK(H13),\"\",($E$8&\".\"&+(COUNTA(H$7:H13))))","v":""},"SANS","REMOVAL OF EXISTING SERVICES"]
[{"$f":"IF(ISBLANK(H14),\"\",($E$8&\".\"&+(COUNTA(H$7:H14))))","v":""},"1200 C"]
[{"$f":"IF(ISBLANK(H15),\"\",($E$8&\".\"&+(COUNTA(H$7:H15))))","v":""},"8.2.7","(a)","Dismantle remove and spoil pipelines, powerlines,"]
[{"$f":"IF(ISBLANK(H16),\"\",($E$8&\".\"&+(COUNTA(H$7:H16))))","v":""},null,null,"cables, etc (excavation, backfilling and removal of"]
[{"$f":"IF(ISBLANK(H17),\"\",($E$8&\".\"&+(COUNTA(H$7:H17))))","v":""},null,null,"concrete, etc measured elsewhere)"]
[{"$f":"IF(ISBLANK(H18),\"\",($E$8&\".\"&+(COUNTA(H$7:H18))))","v":""}]
[{"$f":"IF(ISBLANK(H19),\"\",($E$8&\".\"&+(COUNTA(H$7:H19))))","v":"6.1"},null,null,".1","160mm uPVC sewer pipeline ",null,null,"m",3924]
[{"$f":"IF(ISBLANK(H20),\"\",($E$8&\".\"&+(COUNTA(H$7:H20))))","v":""}]
[{"$f":"IF(ISBLANK(H21),\"\",($E$8&\".\"&+(COUNTA(H$7:H21))))","v":""},null,"DEMOLISH AND SPOIL MATERIAL OFF SITE"]
[{"$f":"IF(ISBLANK(H22),\"\",($E$8&\".\"&+(COUNTA(H$7:H22))))","v":""}]
[{"$f":"IF(ISBLANK(H23),\"\",($E$8&\".\"&+(COUNTA(H$7:H23))))","v":""},null,"Demolish and spoil material for structures, buildings,"]
[{"$f":"IF(ISBLANK(H24),\"\",($E$8&\".\"&+(COUNTA(H$7:H24))))","v":""},null,"etc at a spoil site established by the Contractor"]
[{"$f":"IF(ISBLANK(H25),\"\",($E$8&\".\"&+(COUNTA(H$7:H25))))","v":""}]
[{"$f":"IF(ISBLANK(H26),\"\",($E$8&\".\"&+(COUNTA(H$7:H26))))","v":""},"8.2.8","(a)","Sundry structures, etc"]
[{"$f":"IF(ISBLANK(H27),\"\",($E$8&\".\"&+(COUNTA(H$7:H27))))","v":""}]
[{"$f":"IF(ISBLANK(H28),\"\",($E$8&\".\"&+(COUNTA(H$7:H28))))","v":"6.2"},null,null,".9","Existing sewer manhole complete (concrete cover with cover and frame to be delivered to Engineers office for storage)",null,null,"no",40]
[{"$f":"IF(ISBLANK(H29),\"\",($E$8&\".\"&+(COUNTA(H$7:H29))))","v":""}]
[null,null,"CLEAR SITE"]
[]
[{"$f":"IF(ISBLANK(H32),\"\",($E$8&\".\"&+(COUNTA(H$7:H32))))","v":""},"SANS","CLEAR AND GRUB SITE"]
[{"$f":"IF(ISBLANK(H33),\"\",($E$8&\".\"&+(COUNTA(H$7:H33))))","v":""},"1200 DB"]
[{"$f":"IF(ISBLANK(H34),\"\",($E$8&\".\"&+(COUNTA(H$7:H34))))","v":""},"8.3.1","(a)","Clear and grub strips for (where not cleared within"]
[{"$f":"IF(ISBLANK(H35),\"\",($E$8&\".\"&+(COUNTA(H$7:H35))))","v":""},null,null,"other clear and grub areas)"]
[{"$f":"IF(ISBLANK(H36),\"\",($E$8&\".\"&+(COUNTA(H$7:H36))))","v":""}]
[{"$f":"IF(ISBLANK(H37),\"\",($E$8&\".\"&+(COUNTA(H$7:H37))))","v":"6.3"},null,null,".1","Pipeline 3m wide",null,null,"m",3924]
[{"$f":"IF(ISBLANK(H38),\"\",($E$8&\".\"&+(COUNTA(H$7:H38))))","v":""}]
[null,null,"TRENCHING"]
[]
[null,null,"Note:"]
[null,null,"Please note that dewatering of trenches must be priced under the P&G section of these bills of quantities under items 8.3.2.2.h and 8.4.2.2.h"]
[]
[{"$f":"IF(ISBLANK(H44),\"\",($E$8&\".\"&+(COUNTA(H$7:H44))))","v":""},"SANS","EXCAVATION AND BACKFILLING"]
[{"$f":"IF(ISBLANK(H45),\"\",($E$8&\".\"&+(COUNTA(H$7:H45))))","v":""},"1200 DB"]
[{"$f":"IF(ISBLANK(H46),\"\",($E$8&\".\"&+(COUNTA(H$7:H46))))","v":""},null,"Excavate in all materials, backfill and compact to 93%"]
[{"$f":"IF(ISBLANK(H47),\"\",($E$8&\".\"&+(COUNTA(H$7:H47))))","v":""},null,"mod AASHTO density, and dispose of surplus and"]
[{"$f":"IF(ISBLANK(H48),\"\",($E$8&\".\"&+(COUNTA(H$7:H48))))","v":""},null,"unsuitable materials for trenches"]
[{"$f":"IF(ISBLANK(H49),\"\",($E$8&\".\"&+(COUNTA(H$7:H49))))","v":""}]
[{"$f":"IF(ISBLANK(H50),\"\",($E$8&\".\"&+(COUNTA(H$7:H50))))","v":""},"8.3.2","(a)",".1","Up to 1m wide"]
[{"$f":"IF(ISBLANK(H51),\"\",($E$8&\".\"&+(COUNTA(H$7:H51))))","v":""}]
[{"$f":"IF(ISBLANK(H52),\"\",($E$8&\".\"&+(COUNTA(H$7:H52))))","v":"6.4"},null,null,null,".2","Over 1m and up to 2m deep",null,"m³",3330]
[{"$f":"IF(ISBLANK(H53),\"\",($E$8&\".\"&+(COUNTA(H$7:H53))))","v":""}]
[{"$f":"IF(ISBLANK(H54),\"\",($E$8&\".\"&+(COUNTA(H$7:H54))))","v":"6.5"},null,null,null,".3","Over 2m and up to 3m deep",null,"m³",3112]
[{"$f":"IF(ISBLANK(H55),\"\",($E$8&\".\"&+(COUNTA(H$7:H55))))","v":""}]
[{"$f":"IF(ISBLANK(H56),\"\",($E$8&\".\"&+(COUNTA(H$7:H56))))","v":"6.6"},null,null,null,".4","Over 3m and up to 4m deep",null,"m³",114]
[{"$f":"IF(ISBLANK(H57),\"\",($E$8&\".\"&+(COUNTA(H$7:H57))))","v":""}]
[{"$f":"IF(ISBLANK(H58),\"\",($E$8&\".\"&+(COUNTA(H$7:H58))))","v":"6.7"},null,null,null,".5","Over 4m and up to 5m deep",null,"m³",22]
[{"$f":"IF(ISBLANK(H59),\"\",($E$8&\".\"&+(COUNTA(H$7:H59))))","v":""}]
[{"$f":"IF(ISBLANK(H60),\"\",($E$8&\".\"&+(COUNTA(H$7:H60))))","v":"6.8"},null,null,null,".6","Over 5m and up to 6m deep",null,"m³",11]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[{"$f":"IF(ISBLANK(H70),\"\",($E$8&\".\"&+(COUNTA(H$7:H70))))","v":""},null,"DEFICIENCY IN BACKFILL MATERIAL"]
[{"$f":"IF(ISBLANK(H71),\"\",($E$8&\".\"&+(COUNTA(H$7:H71))))","v":""}]
[{"$f":"IF(ISBLANK(H72),\"\",($E$8&\".\"&+(COUNTA(H$7:H72))))","v":""},"8.3.3","Excavation ancillaries"]
[{"$f":"IF(ISBLANK(H73),\"\",($E$8&\".\"&+(COUNTA(H$7:H73))))","v":""}]
[{"$f":"IF(ISBLANK(H74),\"\",($E$8&\".\"&+(COUNTA(H$7:H74))))","v":""},null,".1","Make up deficiency in backfill material"]
[{"$f":"IF(ISBLANK(H75),\"\",($E$8&\".\"&+(COUNTA(H$7:H75))))","v":""}]
[{"$f":"IF(ISBLANK(H76),\"\",($E$8&\".\"&+(COUNTA(H$7:H76))))","v":"6.9"},null,null,"(a)","From other necessary excavations on site",null,null,"m³",100]
[{"$f":"IF(ISBLANK(H77),\"\",($E$8&\".\"&+(COUNTA(H$7:H77))))","v":""}]
[{"$f":"IF(ISBLANK(H78),\"\",($E$8&\".\"&+(COUNTA(H$7:H78))))","v":""},null,null,"(c)","By importation of G7 material from commercial"]
[{"$f":"IF(ISBLANK(H79),\"\",($E$8&\".\"&+(COUNTA(H$7:H79))))","v":"6.10"},null,null,null,"sources selected by the Contractor",null,null,"m³",150]
[{"$f":"IF(ISBLANK(H80),\"\",($E$8&\".\"&+(COUNTA(H$7:H158))))","v":""}]
[{"$f":"IF(ISBLANK(H81),\"\",($E$8&\".\"&+(COUNTA(H$7:H81))))","v":""},null,"SHORING OF TRENCHES"]
[{"$f":"IF(ISBLANK(H82),\"\",($E$8&\".\"&+(COUNTA(H$7:H82))))","v":""}]
[{"$f":"IF(ISBLANK(H83),\"\",($E$8&\".\"&+(COUNTA(H$7:H83))))","v":""},"8.3.4","(a)","Shore trench opposite structure or service"]
[{"$f":"IF(ISBLANK(H84),\"\",($E$8&\".\"&+(COUNTA(H$7:H84))))","v":""}]
[{"$f":"IF(ISBLANK(H85),\"\",($E$8&\".\"&+(COUNTA(H$7:H85))))","v":"6.11"},null,null,".1","Shoring of sewer trenches maximum 2m deep of approved method (both sides to be shored - measured as trench length and both sides to be priced in one measurement)",null,null,"m",50]
[{"$f":"IF(ISBLANK(H86),\"\",($E$8&\".\"&+(COUNTA(H$7:H86))))","v":""}]
[{"$f":"IF(ISBLANK(H87),\"\",($E$8&\".\"&+(COUNTA(H$7:H87))))","v":"6.12"},null,null,".2","Ditto maximum 4m deep",null,null,"m",40]
[]
[{"$f":"IF(ISBLANK(H89),\"\",($E$8&\".\"&+(COUNTA(H$7:H89))))","v":"6.13"},null,null,".3","Ditto maximum 6m deep",null,null,"m",10]
[]
[null,null,"EXISTING SERVICES"]
[]
[{"$f":"IF(ISBLANK(H93),\"\",($E$8&\".\"&+(COUNTA(H$7:H93))))","v":""},null,"WORK TO EXISTING SERVICES"]
[{"$f":"IF(ISBLANK(H94),\"\",($E$8&\".\"&+(COUNTA(H$7:H94))))","v":""}]
[{"$f":"IF(ISBLANK(H95),\"\",($E$8&\".\"&+(COUNTA(H$7:H95))))","v":""},null,"Existing services that intersect or adjoin  pipe trench"]
[{"$f":"IF(ISBLANK(H96),\"\",($E$8&\".\"&+(COUNTA(H$7:H96))))","v":""},null,"excavations"]
[{"$f":"IF(ISBLANK(H97),\"\",($E$8&\".\"&+(COUNTA(H$7:H97))))","v":""}]
[{"$f":"IF(ISBLANK(H98),\"\",($E$8&\".\"&+(COUNTA(H$7:H98))))","v":""},"8.3.5","(a)","Services that intersect a trench"]
[{"$f":"IF(ISBLANK(H99),\"\",($E$8&\".\"&+(COUNTA(H$7:H99))))","v":""}]
[{"$f":"IF(ISBLANK(H100),\"\",($E$8&\".\"&+(COUNTA(H$7:H100))))","v":"6.14"},null,null,".1","Electric cable",null,null,"no",75]
[{"$f":"IF(ISBLANK(H101),\"\",($E$8&\".\"&+(COUNTA(H$7:H101))))","v":""}]
[{"$f":"IF(ISBLANK(H102),\"\",($E$8&\".\"&+(COUNTA(H$7:H102))))","v":""},null,null,".4","Water main not exceeding 300mm dia"]
[{"$f":"IF(ISBLANK(H103),\"\",($E$8&\".\"&+(COUNTA(H$7:H103))))","v":"6.15"},null,null,null,"(house connection pipes not measurable)",null,null,"no",75]
[{"$f":"IF(ISBLANK(H104),\"\",($E$8&\".\"&+(COUNTA(H$7:H104))))","v":""}]
[{"$f":"IF(ISBLANK(H105),\"\",($E$8&\".\"&+(COUNTA(H$7:H105))))","v":"6.16"},null,null,".5","Sewer main not exceeding 300mm dia",null,null,"no",50]
[{"$f":"IF(ISBLANK(H106),\"\",($E$8&\".\"&+(COUNTA(H$7:H106))))","v":""}]
[{"$f":"IF(ISBLANK(H107),\"\",($E$8&\".\"&+(COUNTA(H$7:H107))))","v":"6.17"},null,null,".6","Stormwater pipe not exceeding 600mm dia",null,null,"no",50]
[{"$f":"IF(ISBLANK(H108),\"\",($E$8&\".\"&+(COUNTA(H$7:H108))))","v":""}]
[{"$f":"IF(ISBLANK(H109),\"\",($E$8&\".\"&+(COUNTA(H$7:H109))))","v":""},"8.3.5","(b)","Services that adjoin a trench"]
[{"$f":"IF(ISBLANK(H110),\"\",($E$8&\".\"&+(COUNTA(H$7:H110))))","v":""}]
[{"$f":"IF(ISBLANK(H111),\"\",($E$8&\".\"&+(COUNTA(H$7:H111))))","v":"6.18"},null,null,".1","Electric cable",null,null,"m",300]
[{"$f":"IF(ISBLANK(H112),\"\",($E$8&\".\"&+(COUNTA(H$7:H112))))","v":""}]
[{"$f":"IF(ISBLANK(H113),\"\",($E$8&\".\"&+(COUNTA(H$7:H113))))","v":""},null,null,".4","Water main not exceeding 300mm dia"]
[{"$f":"IF(ISBLANK(H114),\"\",($E$8&\".\"&+(COUNTA(H$7:H114))))","v":"6.19"},null,null,null,"(house connection pipes not measurable)",null,null,"m",400]
[]
[{"$f":"IF(ISBLANK(H116),\"\",($E$8&\".\"&+(COUNTA(H$7:H116))))","v":"6.20"},null,null,".5","Sewer main not exceeding 300mm dia",null,null,"m",400]
[{"$f":"IF(ISBLANK(H117),\"\",($E$8&\".\"&+(COUNTA(H$7:H117))))","v":""}]
[{"$f":"IF(ISBLANK(H118),\"\",($E$8&\".\"&+(COUNTA(H$7:H140))))","v":"6.21"},null,null,".6","Stormwater pipe not exceeding 600mm dia",null,null,"m",400]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[null,null,"REPAIR ROADS AND PAVING"]
[]
[{"$f":"IF(ISBLANK(H134),\"\",($E$8&\".\"&+(COUNTA(H$7:H134))))","v":""},"SANS","FINISHING AND REPAIRING EXISTING ROAD "]
[{"$f":"IF(ISBLANK(H135),\"\",($E$8&\".\"&+(COUNTA(H$7:H135))))","v":""},"1200 DB","CROSSINGS COMPLETE"]
[{"$f":"IF(ISBLANK(H136),\"\",($E$8&\".\"&+(COUNTA(H$7:H136))))","v":""}]
[{"$f":"IF(ISBLANK(H137),\"\",($E$8&\".\"&+(COUNTA(H$7:H137))))","v":""},"8.3.6.1","(a)","Layerworks including extra over item 8.3.2 for"]
[{"$f":"IF(ISBLANK(H138),\"\",($E$8&\".\"&+(COUNTA(H$7:H138))))","v":""},null,null,"carefull excavation and stockpiling of materials for"]
[{"$f":"IF(ISBLANK(H139),\"\",($E$8&\".\"&+(COUNTA(H$7:H139))))","v":""},null,null,"re-use, or replacing with new material, including all"]
[{"$f":"IF(ISBLANK(H140),\"\",($E$8&\".\"&+(COUNTA(H$7:H140))))","v":""},null,null,"accommodation of traffic and bypasses, complete"]
[{"$f":"IF(ISBLANK(H141),\"\",($E$8&\".\"&+(COUNTA(H$7:H141))))","v":""}]
[{"$f":"IF(ISBLANK(H142),\"\",($E$8&\".\"&+(COUNTA(H$7:H142))))","v":""},null,null,".1","G5 gravel shoulders 150mm thick compacted to"]
[{"$f":"IF(ISBLANK(H143),\"\",($E$8&\".\"&+(COUNTA(H$7:H143))))","v":"6.22"},null,null,null,"93% mod AASHTO density",null,null,"m²",250]
[{"$f":"IF(ISBLANK(H144),\"\",($E$8&\".\"&+(COUNTA(H$7:H144))))","v":""}]
[{"$f":"IF(ISBLANK(H145),\"\",($E$8&\".\"&+(COUNTA(H$7:H145))))","v":""},null,null,".2","G7 selected layer 150mm thick compacted to"]
[{"$f":"IF(ISBLANK(H146),\"\",($E$8&\".\"&+(COUNTA(H$7:H146))))","v":"6.23"},null,null,null,"93% mod AASHTO density",null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H147),\"\",($E$8&\".\"&+(COUNTA(H$7:H147))))","v":""}]
[{"$f":"IF(ISBLANK(H148),\"\",($E$8&\".\"&+(COUNTA(H$7:H148))))","v":""},null,null,".3","C4 stabilised subbase layer 150mm thick"]
[{"$f":"IF(ISBLANK(H149),\"\",($E$8&\".\"&+(COUNTA(H$7:H149))))","v":"6.24"},null,null,null,"compacted to 95% mod AASHTO density",null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H150),\"\",($E$8&\".\"&+(COUNTA(H$7:H150))))","v":""}]
[{"$f":"IF(ISBLANK(H151),\"\",($E$8&\".\"&+(COUNTA(H$7:H151))))","v":""},null,null,".4","G1 base layer 150mm thick compacted to"]
[{"$f":"IF(ISBLANK(H152),\"\",($E$8&\".\"&+(COUNTA(H$7:H152))))","v":"6.25"},null,null,null,"86% apparent density",null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H153),\"\",($E$8&\".\"&+(COUNTA(H$7:H153))))","v":""}]
[{"$f":"IF(ISBLANK(H154),\"\",($E$8&\".\"&+(COUNTA(H$7:H154))))","v":""},"8.3.6.1","(b)","Continuously graded medium asphalt, including"]
[{"$f":"IF(ISBLANK(H155),\"\",($E$8&\".\"&+(COUNTA(H$7:H155))))","v":""},null,null,"prime and tack coat preparation"]
[{"$f":"IF(ISBLANK(H156),\"\",($E$8&\".\"&+(COUNTA(H$7:H156))))","v":""}]
[{"$f":"IF(ISBLANK(H157),\"\",($E$8&\".\"&+(COUNTA(H$7:H157))))","v":"6.26"},null,null,".2","30mm Thick ",null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H158),\"\",($E$8&\".\"&+(COUNTA(H$7:H158))))","v":""}]
[{"$f":"IF(ISBLANK(H159),\"\",($E$8&\".\"&+(COUNTA(H$7:H159))))","v":""},null,"REPAIRING KERBING"]
[{"$f":"IF(ISBLANK(H160),\"\",($E$8&\".\"&+(COUNTA(H$7:H160))))","v":""}]
[{"$f":"IF(ISBLANK(H161),\"\",($E$8&\".\"&+(COUNTA(H$7:H161))))","v":"6.27"},null,"Remove precast concrete kerbing and set aside for re-use",null,null,null,null,"m",900]
[{"$f":"IF(ISBLANK(H162),\"\",($E$8&\".\"&+(COUNTA(H$7:H162))))","v":""}]
[{"$f":"IF(ISBLANK(H163),\"\",($E$8&\".\"&+(COUNTA(H$7:H163))))","v":"6.28"},null,"Take from site precast concrete kerbing and re-install complete",null,null,null,null,"m",900]
[]
[{"$f":"IF(ISBLANK(H165),\"\",($E$8&\".\"&+(COUNTA(H$7:H165))))","v":""},"SANS","LIFTING EXISTING PAVING"]
[{"$f":"IF(ISBLANK(H166),\"\",($E$8&\".\"&+(COUNTA(H$7:H166))))","v":""},"1200 MJ"]
[{"$f":"IF(ISBLANK(H167),\"\",($E$8&\".\"&+(COUNTA(H$7:H167))))","v":""},"8.2.6","Lifting up existing paving blocks including neatly, "]
[{"$f":"IF(ISBLANK(H168),\"\",($E$8&\".\"&+(COUNTA(H$7:H168))))","v":""},null,"stacking on site designated by the Engineer"]
[{"$f":"IF(ISBLANK(H169),\"\",($E$8&\".\"&+(COUNTA(H$7:H169))))","v":""},null,"(to be re-used, and re-use measured elsewhere)"]
[{"$f":"IF(ISBLANK(H170),\"\",($E$8&\".\"&+(COUNTA(H$7:H170))))","v":""}]
[{"$f":"IF(ISBLANK(H171),\"\",($E$8&\".\"&+(COUNTA(H$7:H171))))","v":"6.29"},null,".1","Driveway or site paving (all types)",null,null,null,"m²",1250]
[{"$f":"IF(ISBLANK(H172),\"\",($E$8&\".\"&+(COUNTA(H$7:H172))))","v":""}]
[{"$f":"IF(ISBLANK(H173),\"\",($E$8&\".\"&+(COUNTA(H$7:H173))))","v":""},null,"REINSTATEMENT OF EXISTING PAVING"]
[{"$f":"IF(ISBLANK(H174),\"\",($E$8&\".\"&+(COUNTA(H$7:H174))))","v":""}]
[{"$f":"IF(ISBLANK(H175),\"\",($E$8&\".\"&+(COUNTA(H$7:H175))))","v":""},"8.2.8","Take from stockpile on site existing paving blocks"]
[{"$f":"IF(ISBLANK(H176),\"\",($E$8&\".\"&+(COUNTA(H$7:H176))))","v":""},null,"and reinstate in similar position, including levelling "]
[{"$f":"IF(ISBLANK(H177),\"\",($E$8&\".\"&+(COUNTA(H$7:H177))))","v":""},null,"and compacting earthworks to 93% mod AASHTO "]
[{"$f":"IF(ISBLANK(H178),\"\",($E$8&\".\"&+(COUNTA(H$7:H178))))","v":""},null,"density, supply and lay new 20mm riversand bedding "]
[{"$f":"IF(ISBLANK(H179),\"\",($E$8&\".\"&+(COUNTA(H$7:H179))))","v":""},null,"and re-lay existing bricks, compacting and brooming "]
[{"$f":"IF(ISBLANK(H180),\"\",($E$8&\".\"&+(COUNTA(H$7:H180))))","v":""},null,"in plastesand into joints on completion"]
[{"$f":"IF(ISBLANK(H181),\"\",($E$8&\".\"&+(COUNTA(H$7:H181))))","v":""}]
[{"$f":"IF(ISBLANK(H182),\"\",($E$8&\".\"&+(COUNTA(H$7:H182))))","v":"6.30"},null,".1","Driveway or site paving (all types)",null,null,null,"m²",1250]
[]
[]
[]
[4.43,null,"Procure to site paving blocks including levelling ",null,null,null,null,"m²",200]
[null,null,"and compacting earthworks to 93% mod AASHTO "]
[null,null,"density, supply and lay new 20mm riversand bedding "]
[null,null,"and lay 60mm new bricks, compacting and brooming "]
[null,null,"in plastesand into joints on completion"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[{"$f":"IF(ISBLANK(H196),\"\",($E$8&\".\"&+(COUNTA(H$7:H196))))","v":""},"SANS","CONCRETE DRIVEWAYS AND WALKWAYS ETC."]
[{"$f":"IF(ISBLANK(H197),\"\",($E$8&\".\"&+(COUNTA(H$7:H197))))","v":""},"1200 MK"]
[{"$f":"IF(ISBLANK(H198),\"\",($E$8&\".\"&+(COUNTA(H$7:H198))))","v":"6.32"},null,"Demolish existing concrete, not exceeding 100mm ",null,null,null,null,"m³",300]
[{"$f":"IF(ISBLANK(H199),\"\",($E$8&\".\"&+(COUNTA(H$7:H199))))","v":""},null,"thickness, and spoil at an appropriate site found by "]
[null,null,"the Contractor."]
[]
[{"$f":"IF(ISBLANK(H202),\"\",($E$8&\".\"&+(COUNTA(H$7:H202))))","v":"6.33"},"8.2.8","Cast insitu concrete, 25Mpa/19mm, to 100mm",null,null,null,null,"m³",300]
[null,null,"thickness"]
[]
[null,"8.2.10","Sealed joints to concrete driveways and walkways etc."]
[]
[null,null,"(b)","10mm Sondor Jointex expansion joint 150mm "]
[null,null,null,"high between concrete faces, including formwork"]
[null,null,null,"and raking out 10mm expansion joint material "]
[null,null,null,"to a depth of 20mm, prime with approved"]
[null,null,null,"primer and fill joint with approved"]
[{"$f":"IF(ISBLANK(H212),\"\",($E$8&\".\"&+(COUNTA(H$7:H212))))","v":"6.34"},null,null,"polyurethane sealer",null,null,null,"m",1000]
[]
[{"$f":"IF(ISBLANK(H214),\"\",($E$8&\".\"&+(COUNTA(H$7:H214))))","v":""},"SANS","BEDDING FROM TRENCH EXCAVATIONS"]
[{"$f":"IF(ISBLANK(H215),\"\",($E$8&\".\"&+(COUNTA(H$7:H215))))","v":""},"1200 LB"]
[{"$f":"IF(ISBLANK(H216),\"\",($E$8&\".\"&+(COUNTA(H$7:H216))))","v":""},"8.2.1","Provision of bedding material from trench excavations"]
[{"$f":"IF(ISBLANK(H217),\"\",($E$8&\".\"&+(COUNTA(H$7:H217))))","v":""}]
[{"$f":"IF(ISBLANK(H218),\"\",($E$8&\".\"&+(COUNTA(H$7:H218))))","v":"6.35"},null,"(a)","Selected granular material ",null,null,null,"m³",100]
[{"$f":"IF(ISBLANK(H219),\"\",($E$8&\".\"&+(COUNTA(H$7:H219))))","v":""}]
[{"$f":"IF(ISBLANK(H220),\"\",($E$8&\".\"&+(COUNTA(H$7:H220))))","v":"6.36"},null,"(b)","Selected fill material",null,null,null,"m³",100]
[{"$f":"IF(ISBLANK(H221),\"\",($E$8&\".\"&+(COUNTA(H$7:H221))))","v":""}]
[{"$f":"IF(ISBLANK(H222),\"\",($E$8&\".\"&+(COUNTA(H$7:H222))))","v":""},null,"BEDDING FROM OTHER EXCAVATIONS ON SITE"]
[{"$f":"IF(ISBLANK(H223),\"\",($E$8&\".\"&+(COUNTA(H$7:H223))))","v":""}]
[{"$f":"IF(ISBLANK(H224),\"\",($E$8&\".\"&+(COUNTA(H$7:H224))))","v":""},"8.2.2",".1","Provision of bedding material by importation from"]
[{"$f":"IF(ISBLANK(H225),\"\",($E$8&\".\"&+(COUNTA(H$7:H225))))","v":""},null,null,"other necessary excavations within the freehaul "]
[{"$f":"IF(ISBLANK(H226),\"\",($E$8&\".\"&+(COUNTA(H$7:H226))))","v":""},null,null,"distance"]
[{"$f":"IF(ISBLANK(H227),\"\",($E$8&\".\"&+(COUNTA(H$7:H227))))","v":""}]
[{"$f":"IF(ISBLANK(H228),\"\",($E$8&\".\"&+(COUNTA(H$7:H228))))","v":"6.37"},null,null,"(a)","Selected granular material ",null,null,"m³",100]
[{"$f":"IF(ISBLANK(H229),\"\",($E$8&\".\"&+(COUNTA(H$7:H229))))","v":""}]
[{"$f":"IF(ISBLANK(H230),\"\",($E$8&\".\"&+(COUNTA(H$7:H230))))","v":"6.38"},null,null,"(b)","Selected fill material",null,null,"m³",100]
[{"$f":"IF(ISBLANK(H231),\"\",($E$8&\".\"&+(COUNTA(H$7:H231))))","v":""}]
[{"$f":"IF(ISBLANK(H232),\"\",($E$8&\".\"&+(COUNTA(H$7:H232))))","v":""},null,"BEDDING FROM COMMERCIAL SOURCES"]
[{"$f":"IF(ISBLANK(H233),\"\",($E$8&\".\"&+(COUNTA(H$7:H233))))","v":""}]
[{"$f":"IF(ISBLANK(H234),\"\",($E$8&\".\"&+(COUNTA(H$7:H234))))","v":""},"8.2.2",".3","Provision of bedding material by importation from "]
[{"$f":"IF(ISBLANK(H235),\"\",($E$8&\".\"&+(COUNTA(H$7:H235))))","v":""},null,null,"commercial sources selected by the Contractor"]
[{"$f":"IF(ISBLANK(H236),\"\",($E$8&\".\"&+(COUNTA(H$7:H236))))","v":""}]
[{"$f":"IF(ISBLANK(H237),\"\",($E$8&\".\"&+(COUNTA(H$7:H237))))","v":"6.39"},null,null,"(a)","Selected granular material ",null,null,"m³",500]
[{"$f":"IF(ISBLANK(H238),\"\",($E$8&\".\"&+(COUNTA(H$7:H238))))","v":""}]
[{"$f":"IF(ISBLANK(H239),\"\",($E$8&\".\"&+(COUNTA(H$7:H239))))","v":"6.40"},null,null,"(b)","Selected fill material",null,null,"m³",500]
[]
[{"$f":"IF(ISBLANK(H241),\"\",($E$8&\".\"&+(COUNTA(H$7:H241))))","v":"6.41"},null,null,"(c)","19mm Crushed stone drainage material",null,null,"m³",{"$f":"450*0.2","v":90}]
[{"$f":"IF(ISBLANK(H242),\"\",($E$8&\".\"&+(COUNTA(H$7:H242))))","v":""}]
[{"$f":"IF(ISBLANK(H243),\"\",($E$8&\".\"&+(COUNTA(H$7:H243))))","v":"6.42"},null,null,"(d)","Bidim A2 fabric wrapped around crushed stone",null,null,"m²",{"$f":"7150*0.2","v":1430}]
[{"$f":"IF(ISBLANK(H244),\"\",($E$8&\".\"&+(COUNTA(H$7:H244))))","v":""}]
[{"$f":"IF(ISBLANK(H245),\"\",($E$8&\".\"&+(COUNTA(H$7:H245))))","v":""},"SANS","uPVC SEWER PIPES"]
[{"$f":"IF(ISBLANK(H246),\"\",($E$8&\".\"&+(COUNTA(H$7:H246))))","v":""},"1200 LD"]
[{"$f":"IF(ISBLANK(H247),\"\",($E$8&\".\"&+(COUNTA(H$7:H247))))","v":""},"8.2.1","(a)","Supply, lay, joint, bed (flexible pipe bedding) and test "]
[{"$f":"IF(ISBLANK(H248),\"\",($E$8&\".\"&+(COUNTA(H$7:H248))))","v":""},null,null,"uPVC class 34 spigot and socket sewer pipes "]
[{"$f":"IF(ISBLANK(H249),\"\",($E$8&\".\"&+(COUNTA(H$7:H249))))","v":""},null,null,"with moulded rubber rings to SABS 791"]
[{"$f":"IF(ISBLANK(H250),\"\",($E$8&\".\"&+(COUNTA(H$7:H250))))","v":""}]
[{"$f":"IF(ISBLANK(H251),\"\",($E$8&\".\"&+(COUNTA(H$7:H251))))","v":"6.43"},null,null,".2","160mm Diameter",null,null,"m",3924]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[{"$f":"IF(ISBLANK(H261),\"\",($E$8&\".\"&+(COUNTA(H$7:H261))))","v":""},null,"MANHOLES"]
[{"$f":"IF(ISBLANK(H262),\"\",($E$8&\".\"&+(COUNTA(H$7:H262))))","v":""}]
[{"$f":"IF(ISBLANK(H263),\"\",($E$8&\".\"&+(COUNTA(H$7:H263))))","v":""},null,"Precast concrete manholes complete with precast concrete"]
[{"$f":"IF(ISBLANK(H264),\"\",($E$8&\".\"&+(COUNTA(H$7:H264))))","v":""},null,"cover slab and heavy duty cover and frame as specified"]
[{"$f":"IF(ISBLANK(H265),\"\",($E$8&\".\"&+(COUNTA(H$7:H265))))","v":""},null,"Dwg LSO-228-SW-TD01"]
[{"$f":"IF(ISBLANK(H266),\"\",($E$8&\".\"&+(COUNTA(H$7:H266))))","v":""}]
[{"$f":"IF(ISBLANK(H267),\"\",($E$8&\".\"&+(COUNTA(H$7:H267))))","v":""},"8.2.3","(a)",".1","Manholes 1000mm diameter (straight & angle)"]
[{"$f":"IF(ISBLANK(H268),\"\",($E$8&\".\"&+(COUNTA(H$7:H268))))","v":""}]
[{"$f":"IF(ISBLANK(H269),\"\",($E$8&\".\"&+(COUNTA(H$7:H269))))","v":"6.44"},null,null,null,".2","1,0 - 1,5m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H270),\"\",($E$8&\".\"&+(COUNTA(H$7:H270))))","v":""}]
[{"$f":"IF(ISBLANK(H271),\"\",($E$8&\".\"&+(COUNTA(H$7:H271))))","v":"6.45"},null,null,null,".3","1,5 - 2,0m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H272),\"\",($E$8&\".\"&+(COUNTA(H$7:H272))))","v":""}]
[{"$f":"IF(ISBLANK(H273),\"\",($E$8&\".\"&+(COUNTA(H$7:H273))))","v":"6.46"},null,null,null,".4","2,0 - 2,5m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H274),\"\",($E$8&\".\"&+(COUNTA(H$7:H274))))","v":""}]
[{"$f":"IF(ISBLANK(H275),\"\",($E$8&\".\"&+(COUNTA(H$7:H275))))","v":"6.47"},null,null,null,".5","2,5 - 3,0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H276),\"\",($E$8&\".\"&+(COUNTA(H$7:H276))))","v":""}]
[{"$f":"IF(ISBLANK(H277),\"\",($E$8&\".\"&+(COUNTA(H$7:H277))))","v":"6.48"},null,null,null,".6","3.0 - 3.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H278),\"\",($E$8&\".\"&+(COUNTA(H$7:H278))))","v":""}]
[{"$f":"IF(ISBLANK(H279),\"\",($E$8&\".\"&+(COUNTA(H$7:H279))))","v":"6.49"},null,null,null,".7","3.5 - 4.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H280),\"\",($E$8&\".\"&+(COUNTA(H$7:H280))))","v":""}]
[{"$f":"IF(ISBLANK(H281),\"\",($E$8&\".\"&+(COUNTA(H$7:H281))))","v":"6.50"},null,null,null,".8","4.0 - 4.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H282),\"\",($E$8&\".\"&+(COUNTA(H$7:H282))))","v":""}]
[{"$f":"IF(ISBLANK(H283),\"\",($E$8&\".\"&+(COUNTA(H$7:H283))))","v":"6.51"},null,null,null,".9","4.5 - 5.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H284),\"\",($E$8&\".\"&+(COUNTA(H$7:H284))))","v":""}]
[{"$f":"IF(ISBLANK(H285),\"\",($E$8&\".\"&+(COUNTA(H$7:H285))))","v":""},"8.2.3","(a)",".2","Manholes 1250mm diameter (single junction)"]
[{"$f":"IF(ISBLANK(H286),\"\",($E$8&\".\"&+(COUNTA(H$7:H286))))","v":""}]
[{"$f":"IF(ISBLANK(H287),\"\",($E$8&\".\"&+(COUNTA(H$7:H287))))","v":"6.52"},null,null,null,".2","1,0 - 1,5m Deep",null,"no",2]
[]
[{"$f":"IF(ISBLANK(H289),\"\",($E$8&\".\"&+(COUNTA(H$7:H289))))","v":"6.53"},null,null,null,".3","1,5 - 2,0m Deep",null,"no",2]
[]
[{"$f":"IF(ISBLANK(H291),\"\",($E$8&\".\"&+(COUNTA(H$7:H291))))","v":"6.54"},null,null,null,".4","2,0 - 2,5m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H292),\"\",($E$8&\".\"&+(COUNTA(H$7:H292))))","v":""}]
[{"$f":"IF(ISBLANK(H293),\"\",($E$8&\".\"&+(COUNTA(H$7:H293))))","v":"6.55"},null,null,null,".5","2,5 - 3,0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H294),\"\",($E$8&\".\"&+(COUNTA(H$7:H294))))","v":""}]
[{"$f":"IF(ISBLANK(H295),\"\",($E$8&\".\"&+(COUNTA(H$7:H295))))","v":"6.56"},null,null,null,".6","3.0 - 3.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H296),\"\",($E$8&\".\"&+(COUNTA(H$7:H296))))","v":""}]
[{"$f":"IF(ISBLANK(H297),\"\",($E$8&\".\"&+(COUNTA(H$7:H297))))","v":"6.57"},null,null,null,".7","3.5 - 4.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H298),\"\",($E$8&\".\"&+(COUNTA(H$7:H298))))","v":""}]
[{"$f":"IF(ISBLANK(H299),\"\",($E$8&\".\"&+(COUNTA(H$7:H299))))","v":"6.58"},null,null,null,".8","4.0 - 4.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H300),\"\",($E$8&\".\"&+(COUNTA(H$7:H300))))","v":""}]
[{"$f":"IF(ISBLANK(H301),\"\",($E$8&\".\"&+(COUNTA(H$7:H301))))","v":"6.59"},null,null,null,".9","4.5 - 5.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H302),\"\",($E$8&\".\"&+(COUNTA(H$7:H302))))","v":""}]
[{"$f":"IF(ISBLANK(H303),\"\",($E$8&\".\"&+(COUNTA(H$7:H303))))","v":""},"8.2.3","(a)",".3","Manholes 1500mm diameter (double junction)"]
[{"$f":"IF(ISBLANK(H304),\"\",($E$8&\".\"&+(COUNTA(H$7:H304))))","v":""}]
[{"$f":"IF(ISBLANK(H305),\"\",($E$8&\".\"&+(COUNTA(H$7:H305))))","v":"6.60"},null,null,null,".2","1,0 - 1,5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H306),\"\",($E$8&\".\"&+(COUNTA(H$7:H306))))","v":""}]
[{"$f":"IF(ISBLANK(H307),\"\",($E$8&\".\"&+(COUNTA(H$7:H307))))","v":"6.61"},null,null,null,".3","1,5 - 2,0m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H308),\"\",($E$8&\".\"&+(COUNTA(H$7:H308))))","v":""}]
[{"$f":"IF(ISBLANK(H309),\"\",($E$8&\".\"&+(COUNTA(H$7:H309))))","v":"6.62"},null,null,null,".4","2,0 - 2,5m Deep",null,"no",2]
[{"$f":"IF(ISBLANK(H310),\"\",($E$8&\".\"&+(COUNTA(H$7:H310))))","v":""}]
[{"$f":"IF(ISBLANK(H311),\"\",($E$8&\".\"&+(COUNTA(H$7:H311))))","v":"6.63"},null,null,null,".5","2,5 - 3,0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H312),\"\",($E$8&\".\"&+(COUNTA(H$7:H312))))","v":""}]
[{"$f":"IF(ISBLANK(H313),\"\",($E$8&\".\"&+(COUNTA(H$7:H313))))","v":"6.64"},null,null,null,".6","3.0 - 3.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H314),\"\",($E$8&\".\"&+(COUNTA(H$7:H314))))","v":""}]
[{"$f":"IF(ISBLANK(H315),\"\",($E$8&\".\"&+(COUNTA(H$7:H315))))","v":"6.65"},null,null,null,".7","3.5 - 4.0m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H316),\"\",($E$8&\".\"&+(COUNTA(H$7:H316))))","v":""}]
[{"$f":"IF(ISBLANK(H317),\"\",($E$8&\".\"&+(COUNTA(H$7:H317))))","v":"6.66"},null,null,null,".8","4.0 - 4.5m Deep",null,"no",1]
[{"$f":"IF(ISBLANK(H318),\"\",($E$8&\".\"&+(COUNTA(H$7:H318))))","v":""}]
[{"$f":"IF(ISBLANK(H319),\"\",($E$8&\".\"&+(COUNTA(H$7:H319))))","v":"6.67"},null,null,null,".9","4.5 - 5.0m Deep",null,"no",1]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[{"$f":"IF(ISBLANK(H325),\"\",($E$8&\".\"&+(COUNTA(H$7:H325))))","v":""}]
[{"$f":"IF(ISBLANK(H326),\"\",($E$8&\".\"&+(COUNTA(H$7:H326))))","v":""},null,"SUNDRIES"]
[]
[{"$f":"IF(ISBLANK(H328),\"\",($E$8&\".\"&+(COUNTA(H$7:H328))))","v":""},null,"CONCRETE ENCASEMENT AND THRUST BLOCKS"]
[{"$f":"IF(ISBLANK(H329),\"\",($E$8&\".\"&+(COUNTA(H$7:H329))))","v":""}]
[{"$f":"IF(ISBLANK(H330),\"\",($E$8&\".\"&+(COUNTA(H$7:H330))))","v":""},"8.2.7","Encasement of pipes in strength concrete 25Mpa/19mm"]
[{"$f":"IF(ISBLANK(H331),\"\",($E$8&\".\"&+(COUNTA(H$7:H331))))","v":""},null,"including all formwork, reinforcement, etc"]
[{"$f":"IF(ISBLANK(H332),\"\",($E$8&\".\"&+(COUNTA(H$7:H332))))","v":""}]
[{"$f":"IF(ISBLANK(H333),\"\",($E$8&\".\"&+(COUNTA(H$7:H333))))","v":"6.68"},null,"(a)","Casing around pipes",null,null,null,"m³",2]
[{"$f":"IF(ISBLANK(H334),\"\",($E$8&\".\"&+(COUNTA(H$7:H334))))","v":""}]
[{"$f":"IF(ISBLANK(H335),\"\",($E$8&\".\"&+(COUNTA(H$7:H335))))","v":""},null,"SOILCRETE"]
[{"$f":"IF(ISBLANK(H336),\"\",($E$8&\".\"&+(COUNTA(H$7:H336))))","v":""}]
[{"$f":"IF(ISBLANK(H337),\"\",($E$8&\".\"&+(COUNTA(H$7:H337))))","v":""},null,"Soilcrete (5% OPC) "]
[{"$f":"IF(ISBLANK(H338),\"\",($E$8&\".\"&+(COUNTA(H$7:H338))))","v":""}]
[{"$f":"IF(ISBLANK(H339),\"\",($E$8&\".\"&+(COUNTA(H$7:H339))))","v":"6.69"},null,"(a)","Backfilling around pipes",null,null,null,"m³",20]
[{"$f":"IF(ISBLANK(H340),\"\",($E$8&\".\"&+(COUNTA(H$7:H340))))","v":""}]
[{"$f":"IF(ISBLANK(H341),\"\",($E$8&\".\"&+(COUNTA(H$7:H341))))","v":""},null,"CCTV CAMERA INSPECTION OF PIPES"]
[{"$f":"IF(ISBLANK(H342),\"\",($E$8&\".\"&+(COUNTA(H$7:H342))))","v":""}]
[{"$f":"IF(ISBLANK(H343),\"\",($E$8&\".\"&+(COUNTA(H$7:H343))))","v":""},"8.2.14","CCTV camera inspection of sewer pipes to include"]
[{"$f":"IF(ISBLANK(H344),\"\",($E$8&\".\"&+(COUNTA(H$7:H344))))","v":""},null,"establishment, camera inspections and submission of"]
[{"$f":"IF(ISBLANK(H345),\"\",($E$8&\".\"&+(COUNTA(H$7:H345))))","v":""},null,"inspection report for approval by the Engineer"]
[]
[{"$f":"IF(ISBLANK(H347),\"\",($E$8&\".\"&+(COUNTA(H$7:H347))))","v":"6.70"},null,"(a)","160mm Dia sewer line",null,null,null,"m",3924]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(ISBLANK(H382),\"\",($E$8&\".\"&+(COUNTA(H$7:H382))))","v":""}]
[]
[]
[]
[{"$f":"IF(ISBLANK(H386),\"\",($E$8&\".\"&+(COUNTA(H$7:H386))))","v":""},null,{"$f":"C8","v":"BILL NO"},null,6]
[{"$f":"IF(ISBLANK(H387),\"\",($E$8&\".\"&+(COUNTA(H$7:H387))))","v":""},null,"uPVC SEWERS"]
[{"$f":"IF(ISBLANK(H388),\"\",($E$8&\".\"&+(COUNTA(H$7:H388))))","v":""},null,"Carried forward to Summary of Bills",null,null,null,null,null,null,"Total"]

{"sheet":"existing sewers","index":6,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,6],[4,7,5,7],[4,8,5,8],[10,2,10,6]]}
[{"$f":"'A-P&G '!A1","v":"Contract:  RLM/OMM/0156/2024/25"}]
["Part C2:  Pricing Data"]
["Section C2.2:  Bill of Quantities"]
["uPVC Sewers"]
["Item","Payment","Description",null,null,null,null,"Unit","Qty","Rate","Amount"]
[null,"Reference",null,null,null,null,null,null,null,"(R)","(R)"]
[]
[null,"SANS","BILL NO",null,7]
[null,"1200 LD","EXISTING SEWERS"]
[]
[{"$f":"IF(ISBLANK(H11),\"\",($E$8&\".\"&+(COUNTA(H$7:H11))))","v":""},null,"CLEANING SEWERS"]
[]
[{"$f":"IF(ISBLANK(H13),\"\",($E$8&\".\"&+(COUNTA(H$7:H13))))","v":""},null,"CLEARING OF EXISTING SEWER LINES"]
[{"$f":"IF(ISBLANK(H14),\"\",($E$8&\".\"&+(COUNTA(H$7:H14))))","v":""}]
[{"$f":"IF(ISBLANK(H15),\"\",($E$8&\".\"&+(COUNTA(H$7:H15))))","v":""},"8.2.13","Cleaning of existing sewer lines by approved method"]
[{"$f":"IF(ISBLANK(H16),\"\",($E$8&\".\"&+(COUNTA(H$7:H16))))","v":""},null,"and hand over in working condition"]
[{"$f":"IF(ISBLANK(H17),\"\",($E$8&\".\"&+(COUNTA(H$7:H17))))","v":""}]
[{"$f":"IF(ISBLANK(H18),\"\",($E$8&\".\"&+(COUNTA(H$7:H18))))","v":"7.1"},null,"(b)","160mm Dia sewer line",null,null,null,"m",1652]
[{"$f":"IF(ISBLANK(H19),\"\",($E$8&\".\"&+(COUNTA(H$7:H19))))","v":""}]
[{"$f":"IF(ISBLANK(H20),\"\",($E$8&\".\"&+(COUNTA(H$7:H20))))","v":""},null,"CLEANING OF EXISTING MANHOLES"]
[{"$f":"IF(ISBLANK(H21),\"\",($E$8&\".\"&+(COUNTA(H$7:H21))))","v":""}]
[{"$f":"IF(ISBLANK(H22),\"\",($E$8&\".\"&+(COUNTA(H$7:H22))))","v":""},"8.2.13","Cleaning of existing manholes by approved method"]
[{"$f":"IF(ISBLANK(H23),\"\",($E$8&\".\"&+(COUNTA(H$7:H23))))","v":""},null,"and hand over in working condition"]
[{"$f":"IF(ISBLANK(H24),\"\",($E$8&\".\"&+(COUNTA(H$7:H24))))","v":""}]
[{"$f":"IF(ISBLANK(H25),\"\",($E$8&\".\"&+(COUNTA(H$7:H25))))","v":"7.2"},null,"(p)","Manhole (all sizes and depths)",null,null,null,"no",51]
[{"$f":"IF(ISBLANK(H26),\"\",($E$8&\".\"&+(COUNTA(H$7:H26))))","v":""}]
[{"$f":"IF(ISBLANK(H27),\"\",($E$8&\".\"&+(COUNTA(H$7:H27))))","v":""},null,"CCTV PIPE INSPECTION OF EXISTING SEWERS"]
[{"$f":"IF(ISBLANK(H28),\"\",($E$8&\".\"&+(COUNTA(H$7:H28))))","v":""}]
[{"$f":"IF(ISBLANK(H29),\"\",($E$8&\".\"&+(COUNTA(H$7:H29))))","v":""},null,"CCTV pipe inspection of existing pipework complete"]
[{"$f":"IF(ISBLANK(H30),\"\",($E$8&\".\"&+(COUNTA(H$7:H30))))","v":""}]
[{"$f":"IF(ISBLANK(H31),\"\",($E$8&\".\"&+(COUNTA(H$7:H31))))","v":"7.3"},null,"(b)","160mm Dia sewer line",null,null,null,"m",1652]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(ISBLANK(H69),\"\",($E$8&\".\"&+(COUNTA(H$7:H69))))","v":""},null,{"$f":"C8","v":"BILL NO"},null,7]
[{"$f":"IF(ISBLANK(H70),\"\",($E$8&\".\"&+(COUNTA(H$7:H70))))","v":""},null,"uPVC SEWERS"]
[{"$f":"IF(ISBLANK(H71),\"\",($E$8&\".\"&+(COUNTA(H$7:H71))))","v":""},null,"Carried forward to Summary of Bills",null,null,null,null,null,null,"Total"]

{"sheet":"sewers on stands","index":7,"n_rows":348,"n_cols":16,"rows_kept":348,"cut":false,"hidden":false,"merged":[[299,2,299,6],[219,2,219,6],[265,2,265,6],[134,2,134,6],[270,2,270,6],[157,2,157,6],[200,2,200,6],[175,2,175,6],[178,2,178,6],[4,7,5,7],[4,8,5,8],[20,2,20,6],[14,2,14,6],[16,2,16,6],[18,2,18,6],[63,2,63,6],[121,2,121,6],[126,2,126,6],[124,2,124,6],[4,0,5,0],[4,2,5,6]]}
[{"$f":"'A-P&G '!A1","v":"Contract:  RLM/OMM/0156/2024/25"}]
["Part C2:  Pricing Data"]
["Section C2.2:  Bill of Quantities"]
["Sewers on stands"]
["Item","Payment","Description",null,null,null,null,"Unit","Qty","Rate","Amount"]
[null,"Reference",null,null,null,null,null,null,null,"(R)","(R)"]
[]
[null,null,"BILL NO",null,8]
[null,null,"SEWERS ON EXISTING STANDS"]
[]
[null,null,"LABOUR INTENSIVE WORK"]
[]
[null,null,"Note:"]
[]
[null,null,"Work inside residential stands is to be constructed using labour intensive methods to minimise damage to existing structures and services."]
[]
[null,null,"Contractors is to allow for this in their tender rates and no claims for additional costs will be entertained"]
[]
[null,null,"Labour intensive work will be indicated in the payment reference column with the letters \"LI\""]
[]
[null,null,"REMOVAL OF FENCING AND WALLS"]
[]
[{"$f":"IF(ISBLANK(H23),\"\",($E$8&\".\"&+(COUNTA(H$7:H23))))","v":""},"SANS","REMOVAL OF FENCES, BOUNDARY WALLS, ETC"]
[{"$f":"IF(ISBLANK(H24),\"\",($E$8&\".\"&+(COUNTA(H$7:H24))))","v":""},"1200 C","AND STOCKPILE MATERIAL FOR RE-USE"]
[{"$f":"IF(ISBLANK(H25),\"\",($E$8&\".\"&+(COUNTA(H$7:H25))))","v":""}]
[{"$f":"IF(ISBLANK(H26),\"\",($E$8&\".\"&+(COUNTA(H$7:H26))))","v":""},null,"Note:"]
[{"$f":"IF(ISBLANK(H27),\"\",($E$8&\".\"&+(COUNTA(H$7:H27))))","v":""},null,"All existing material removed and to be re-used for"]
[{"$f":"IF(ISBLANK(H28),\"\",($E$8&\".\"&+(COUNTA(H$7:H28))))","v":""},null,"re-erection later, must be stockpiled neatly on a site"]
[{"$f":"IF(ISBLANK(H29),\"\",($E$8&\".\"&+(COUNTA(H$7:H29))))","v":""},null,"designated by the Engineer and protected from"]
[{"$f":"IF(ISBLANK(H30),\"\",($E$8&\".\"&+(COUNTA(H$7:H30))))","v":""},null,"damage or theft"]
[]
[{"$f":"IF(ISBLANK(H32),\"\",($E$8&\".\"&+(COUNTA(H$7:H32))))","v":""}]
[{"$f":"IF(ISBLANK(H33),\"\",($E$8&\".\"&+(COUNTA(H$7:H33))))","v":""},"8.2.5","Taking down existing fences "]
[{"$f":"IF(ISBLANK(H34),\"\",($E$8&\".\"&+(COUNTA(H$7:H34))))","v":""}]
[{"$f":"IF(ISBLANK(H35),\"\",($E$8&\".\"&+(COUNTA(H$7:H35))))","v":"8.1"},"LI","(a)","Fencing maximum 1,8m high",null,null,null,"m",410]
[{"$f":"IF(ISBLANK(H36),\"\",($E$8&\".\"&+(COUNTA(H$7:H36))))","v":""}]
[{"$f":"IF(ISBLANK(H37),\"\",($E$8&\".\"&+(COUNTA(H$7:H37))))","v":""},"8.2.13","Taking down existing precast concrete boundary walls"]
[{"$f":"IF(ISBLANK(H38),\"\",($E$8&\".\"&+(COUNTA(H$7:H38))))","v":""}]
[{"$f":"IF(ISBLANK(H39),\"\",($E$8&\".\"&+(COUNTA(H$7:H39))))","v":"8.2"},"LI","(b)","Precast concrete boundary walls maximum 1,8m high",null,null,null,"m",100]
[{"$f":"IF(ISBLANK(H40),\"\",($E$8&\".\"&+(COUNTA(H$7:H40))))","v":""}]
[{"$f":"IF(ISBLANK(H41),\"\",($E$8&\".\"&+(COUNTA(H$7:H41))))","v":""},"8.2.14","Taking down existing brick boundary walls and spoil "]
[{"$f":"IF(ISBLANK(H42),\"\",($E$8&\".\"&+(COUNTA(H$7:H42))))","v":""},null,"material except bricks - bricks to be cleaned and stacked"]
[{"$f":"IF(ISBLANK(H43),\"\",($E$8&\".\"&+(COUNTA(H$7:H43))))","v":""},null,"on site"]
[{"$f":"IF(ISBLANK(H44),\"\",($E$8&\".\"&+(COUNTA(H$7:H44))))","v":""}]
[{"$f":"IF(ISBLANK(H45),\"\",($E$8&\".\"&+(COUNTA(H$7:H45))))","v":""},"LI","(a)","115mm Thick brick boundary wall including pilasters,"]
[{"$f":"IF(ISBLANK(H46),\"\",($E$8&\".\"&+(COUNTA(H$7:H46))))","v":"8.3"},null,null,"etc maximum 1,8m high",null,null,null,"m",150]
[{"$f":"IF(ISBLANK(H47),\"\",($E$8&\".\"&+(COUNTA(H$7:H47))))","v":""}]
[{"$f":"IF(ISBLANK(H48),\"\",($E$8&\".\"&+(COUNTA(H$7:H48))))","v":"8.4"},"LI","(c)","230mm Thick brick boundary wall maximum 1,8m high",null,null,null,"m",200]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[null,null,"REPAIR OF FENCING AND WALLS"]
[]
[{"$f":"IF(ISBLANK(H66),\"\",($E$8&\".\"&+(COUNTA(H$7:H66))))","v":""},null,"REINSTATEMENT OF FENCES, BOUNDARY "]
[{"$f":"IF(ISBLANK(H67),\"\",($E$8&\".\"&+(COUNTA(H$7:H67))))","v":""},null,"WALLS, ETC"]
[{"$f":"IF(ISBLANK(H68),\"\",($E$8&\".\"&+(COUNTA(H$7:H68))))","v":""}]
[{"$f":"IF(ISBLANK(H69),\"\",($E$8&\".\"&+(COUNTA(H$7:H69))))","v":""},"8.2.15","Take from stockpile on site existing fences and reinstate"]
[{"$f":"IF(ISBLANK(H70),\"\",($E$8&\".\"&+(COUNTA(H$7:H70))))","v":""},null,"in similar position including replacing missing or damaged"]
[{"$f":"IF(ISBLANK(H71),\"\",($E$8&\".\"&+(COUNTA(H$7:H71))))","v":""},null," elements, etc"]
[{"$f":"IF(ISBLANK(H72),\"\",($E$8&\".\"&+(COUNTA(H$7:H72))))","v":""}]
[{"$f":"IF(ISBLANK(H73),\"\",($E$8&\".\"&+(COUNTA(H$7:H73))))","v":"8.5"},"LI","(a)","Fencing maximum 1,8m high",null,null,null,"m",410]
[{"$f":"IF(ISBLANK(H74),\"\",($E$8&\".\"&+(COUNTA(H$7:H74))))","v":""}]
[{"$f":"IF(ISBLANK(H75),\"\",($E$8&\".\"&+(COUNTA(H$7:H75))))","v":""},"8.2.18","Take from stockpile on site existing precast concrete "]
[{"$f":"IF(ISBLANK(H76),\"\",($E$8&\".\"&+(COUNTA(H$7:H76))))","v":""},null,"boundary wall and reinstate in similar position including"]
[{"$f":"IF(ISBLANK(H77),\"\",($E$8&\".\"&+(COUNTA(H$7:H77))))","v":""},null,"replacing missing or damaged elements, etc"]
[{"$f":"IF(ISBLANK(H78),\"\",($E$8&\".\"&+(COUNTA(H$7:H78))))","v":""}]
[{"$f":"IF(ISBLANK(H79),\"\",($E$8&\".\"&+(COUNTA(H$7:H79))))","v":"8.6"},"LI","(a)","Precast concrete boundary walls maximum 1,8m high",null,null,null,"m",100]
[{"$f":"IF(ISBLANK(H80),\"\",($E$8&\".\"&+(COUNTA(H$7:H80))))","v":""}]
[{"$f":"IF(ISBLANK(H81),\"\",($E$8&\".\"&+(COUNTA(H$7:H81))))","v":""},"8.2.19","Take from stockpile on site existing bricks and reinstate"]
[{"$f":"IF(ISBLANK(H82),\"\",($E$8&\".\"&+(COUNTA(H$7:H82))))","v":""},null,"brick walls in similar position including new concrete"]
[{"$f":"IF(ISBLANK(H83),\"\",($E$8&\".\"&+(COUNTA(H$7:H83))))","v":""},null,"foundation, cement mortar and one coat cement plaster"]
[{"$f":"IF(ISBLANK(H84),\"\",($E$8&\".\"&+(COUNTA(H$7:H84))))","v":""},null,"or face brick on both sides, including replacing missing or"]
[{"$f":"IF(ISBLANK(H85),\"\",($E$8&\".\"&+(COUNTA(H$7:H85))))","v":""},null,"damaged bricks, etc"]
[{"$f":"IF(ISBLANK(H86),\"\",($E$8&\".\"&+(COUNTA(H$7:H86))))","v":""}]
[{"$f":"IF(ISBLANK(H87),\"\",($E$8&\".\"&+(COUNTA(H$7:H87))))","v":""},"LI","(a)","115mm Thick brick boundary wall including pilasters,"]
[{"$f":"IF(ISBLANK(H88),\"\",($E$8&\".\"&+(COUNTA(H$7:H88))))","v":"8.7"},null,null,"etc maximum 1,8m high",null,null,null,"m",150]
[{"$f":"IF(ISBLANK(H89),\"\",($E$8&\".\"&+(COUNTA(H$7:H89))))","v":""}]
[{"$f":"IF(ISBLANK(H90),\"\",($E$8&\".\"&+(COUNTA(H$7:H90))))","v":"8.8"},"LI","(c)","230mm Thick brick boundary wall maximum 1,8m high",null,null,null,"m",100]
[{"$f":"IF(ISBLANK(H91),\"\",($E$8&\".\"&+(COUNTA(H$7:H91))))","v":""}]
[{"$f":"IF(ISBLANK(H92),\"\",($E$8&\".\"&+(COUNTA(H$7:H92))))","v":""},null,"DEMOLISH AND SPOIL MATERIAL OFF SITE"]
[{"$f":"IF(ISBLANK(H93),\"\",($E$8&\".\"&+(COUNTA(H$7:H93))))","v":""}]
[{"$f":"IF(ISBLANK(H94),\"\",($E$8&\".\"&+(COUNTA(H$7:H94))))","v":""},null,"Demolish and spoil material for structures, buildings,"]
[{"$f":"IF(ISBLANK(H95),\"\",($E$8&\".\"&+(COUNTA(H$7:H95))))","v":""},null,"etc at a spoil site established by the Contractor"]
[{"$f":"IF(ISBLANK(H96),\"\",($E$8&\".\"&+(COUNTA(H$7:H96))))","v":""}]
[{"$f":"IF(ISBLANK(H97),\"\",($E$8&\".\"&+(COUNTA(H$7:H97))))","v":""},"8.2.8","(a)","Sundry structures, etc"]
[{"$f":"IF(ISBLANK(H98),\"\",($E$8&\".\"&+(COUNTA(H$7:H98))))","v":""}]
[{"$f":"IF(ISBLANK(H99),\"\",($E$8&\".\"&+(COUNTA(H$7:H99))))","v":"8.9"},"LI",null,".3","Mass concrete structures",null,null,"m³",5]
[{"$f":"IF(ISBLANK(H100),\"\",($E$8&\".\"&+(COUNTA(H$7:H100))))","v":""}]
[{"$f":"IF(ISBLANK(H101),\"\",($E$8&\".\"&+(COUNTA(H$7:H101))))","v":"8.10"},"LI",null,".4","Reinforced concrete structures",null,null,"m³",5]
[{"$f":"IF(ISBLANK(H102),\"\",($E$8&\".\"&+(COUNTA(H$7:H102))))","v":""}]
[{"$f":"IF(ISBLANK(H103),\"\",($E$8&\".\"&+(COUNTA(H$7:H103))))","v":"8.11"},"LI",null,".5","150mm Thick concrete paving ",null,null,"m²",100]
[{"$f":"IF(ISBLANK(H104),\"\",($E$8&\".\"&+(COUNTA(H$7:H104))))","v":""}]
[{"$f":"IF(ISBLANK(H105),\"\",($E$8&\".\"&+(COUNTA(H$7:H105))))","v":"8.12"},"LI",null,".6","150mm Thick reinforced concrete paving ",null,null,"m²",100]
[{"$f":"IF(ISBLANK(H106),\"\",($E$8&\".\"&+(COUNTA(H$7:H106))))","v":""}]
[{"$f":"IF(ISBLANK(H107),\"\",($E$8&\".\"&+(COUNTA(H$7:H107))))","v":"8.13"},"LI",null,".7","Concrete kerbing (all types and sizes)",null,null,"m",50]
[{"$f":"IF(ISBLANK(H108),\"\",($E$8&\".\"&+(COUNTA(H$7:H108))))","v":""}]
[{"$f":"IF(ISBLANK(H109),\"\",($E$8&\".\"&+(COUNTA(H$7:H109))))","v":"8.14"},"LI",null,".8","Mass brickwork structures",null,null,"m³",30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[{"$f":"IF(ISBLANK(H122),\"\",($E$8&\".\"&+(COUNTA(H$7:H122))))","v":""},null,"TUNNELING BELOW BOUNDARY WALLS AND FENCING"]
[null,null,"Note:"]
[]
[null,null,"The following method of passing below boundary walls and fencing will be preferred if possible, and not demolishing walls and fencing for sewers to pass below"]
[]
[{"$f":"IF(ISBLANK(H127),\"\",($E$8&\".\"&+(COUNTA(H$7:H127))))","v":""},null,"Tunneling below the following structures for sewers to pass below, including protecting the structures from damage and supporting the structures above the sewer trench and backfilling and compaction of trench complete"]
[{"$f":"IF(ISBLANK(H128),\"\",($E$8&\".\"&+(COUNTA(H$7:H128))))","v":""}]
[{"$f":"IF(ISBLANK(H129),\"\",($E$8&\".\"&+(COUNTA(H$7:H129))))","v":"8.15"},"LI",".1","Perimeter fencing (all types)",null,null,null,"no",308]
[{"$f":"IF(ISBLANK(H130),\"\",($E$8&\".\"&+(COUNTA(H$7:H130))))","v":""}]
[{"$f":"IF(ISBLANK(H131),\"\",($E$8&\".\"&+(COUNTA(H$7:H131))))","v":"8.16"},"LI",".2","Perimeter precast concrete walls (all types)",null,null,null,"no",51]
[{"$f":"IF(ISBLANK(H132),\"\",($E$8&\".\"&+(COUNTA(H$7:H132))))","v":""}]
[{"$f":"IF(ISBLANK(H133),\"\",($E$8&\".\"&+(COUNTA(H$7:H133))))","v":"8.17"},"LI",".3","Perimeter brick walls (all types)",null,null,null,"no",154]
[{"$f":"IF(ISBLANK(H134),\"\",($E$8&\".\"&+(COUNTA(H$7:H134))))","v":""}]
[null,null,"REINSTATEMENT OF EXISTING SERVICES"]
[]
[{"$f":"IF(ISBLANK(H137),\"\",($E$8&\".\"&+(COUNTA(H$7:H137))))","v":""},"SANS","LIFTING EXISTING PAVING"]
[{"$f":"IF(ISBLANK(H138),\"\",($E$8&\".\"&+(COUNTA(H$7:H138))))","v":""},"1200 MJ"]
[{"$f":"IF(ISBLANK(H139),\"\",($E$8&\".\"&+(COUNTA(H$7:H139))))","v":""},"8.2.6","Lifting up existing paving blocks including neatly, "]
[{"$f":"IF(ISBLANK(H140),\"\",($E$8&\".\"&+(COUNTA(H$7:H140))))","v":""},null,"stacking on site designated by the Engineer"]
[{"$f":"IF(ISBLANK(H141),\"\",($E$8&\".\"&+(COUNTA(H$7:H141))))","v":""},null,"(to be re-used, and re-use measured elsewhere)"]
[{"$f":"IF(ISBLANK(H142),\"\",($E$8&\".\"&+(COUNTA(H$7:H142))))","v":""}]
[{"$f":"IF(ISBLANK(H143),\"\",($E$8&\".\"&+(COUNTA(H$7:H143))))","v":"8.18"},"LI",".1","Driveway or site paving (all types)",null,null,null,"m²",10261]
[{"$f":"IF(ISBLANK(H144),\"\",($E$8&\".\"&+(COUNTA(H$7:H144))))","v":""}]
[{"$f":"IF(ISBLANK(H145),\"\",($E$8&\".\"&+(COUNTA(H$7:H145))))","v":""},null,"REINSTATEMENT OF EXISTING PAVING"]
[{"$f":"IF(ISBLANK(H146),\"\",($E$8&\".\"&+(COUNTA(H$7:H146))))","v":""}]
[{"$f":"IF(ISBLANK(H147),\"\",($E$8&\".\"&+(COUNTA(H$7:H147))))","v":""},"8.2.8","Take from stockpile on site existing paving blocks"]
[{"$f":"IF(ISBLANK(H148),\"\",($E$8&\".\"&+(COUNTA(H$7:H148))))","v":""},null,"and reinstate in similar position, including levelling "]
[{"$f":"IF(ISBLANK(H149),\"\",($E$8&\".\"&+(COUNTA(H$7:H149))))","v":""},null,"and compacting earthworks to 93% mod AASHTO "]
[{"$f":"IF(ISBLANK(H150),\"\",($E$8&\".\"&+(COUNTA(H$7:H150))))","v":""},null,"density, supply and lay new 20mm riversand bedding "]
[{"$f":"IF(ISBLANK(H151),\"\",($E$8&\".\"&+(COUNTA(H$7:H151))))","v":""},null,"and re-lay existing bricks, compacting and brooming "]
[{"$f":"IF(ISBLANK(H152),\"\",($E$8&\".\"&+(COUNTA(H$7:H152))))","v":""},null,"in plastesand into joints on completion"]
[{"$f":"IF(ISBLANK(H153),\"\",($E$8&\".\"&+(COUNTA(H$7:H153))))","v":""}]
[{"$f":"IF(ISBLANK(H154),\"\",($E$8&\".\"&+(COUNTA(H$7:H154))))","v":"8.19"},"LI",".1","Driveway or site paving (all types)",null,null,null,"m²",10261]
[{"$f":"IF(ISBLANK(H155),\"\",($E$8&\".\"&+(COUNTA(H$7:H155))))","v":""}]
[{"$f":"IF(ISBLANK(H156),\"\",($E$8&\".\"&+(COUNTA(H$7:H156))))","v":""},null,"REINSTATEMENT OF EXISTING GARDENS"]
[{"$f":"IF(ISBLANK(H157),\"\",($E$8&\".\"&+(COUNTA(H$7:H157))))","v":""}]
[{"$f":"IF(ISBLANK(H158),\"\",($E$8&\".\"&+(COUNTA(H$7:H158))))","v":""},null,"The following tendered sums of money is for the reinstatement of existing gardens (hard surfacing, walls, etc excluded) on the existing housing stands complete to its original state before sewer installation started"]
[]
[{"$f":"IF(ISBLANK(H160),\"\",($E$8&\".\"&+(COUNTA(H$7:H160))))","v":"8.20"},"LI",".1","Grass only",null,null,null,"stands",257]
[{"$f":"IF(ISBLANK(H161),\"\",($E$8&\".\"&+(COUNTA(H$7:H161))))","v":""}]
[{"$f":"IF(ISBLANK(H162),\"\",($E$8&\".\"&+(COUNTA(H$7:H219))))","v":"8.30"},"LI",".2","Grass and vegetable gardens",null,null,null,"stands",257]
[{"$f":"IF(ISBLANK(H163),\"\",($E$8&\".\"&+(COUNTA(H$7:H163))))","v":""}]
[{"$f":"IF(ISBLANK(H164),\"\",($E$8&\".\"&+(COUNTA(H$7:H164))))","v":""},"SANS","CLEAR AND GRUB SITE"]
[{"$f":"IF(ISBLANK(H165),\"\",($E$8&\".\"&+(COUNTA(H$7:H165))))","v":""},"1200 DB"]
[{"$f":"IF(ISBLANK(H166),\"\",($E$8&\".\"&+(COUNTA(H$7:H166))))","v":""},"8.3.1","(a)","Clear and grub strips for (where not cleared within"]
[{"$f":"IF(ISBLANK(H167),\"\",($E$8&\".\"&+(COUNTA(H$7:H167))))","v":""},null,null,"other clear and grub areas)"]
[{"$f":"IF(ISBLANK(H168),\"\",($E$8&\".\"&+(COUNTA(H$7:H168))))","v":""}]
[{"$f":"IF(ISBLANK(H169),\"\",($E$8&\".\"&+(COUNTA(H$7:H169))))","v":"8.22"},"LI",null,".1","Pipeline 2m wide",null,null,"m",27191]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[{"$f":"IF(ISBLANK(H175),\"\",($E$8&\".\"&+(COUNTA(H$7:H175))))","v":""}]
[null,null,"TRENCHING"]
[]
[null,null,"Note:"]
[null,null,"Please note that dewatering of trenches must be priced under the P&G section of these bills of quantities under items 8.3.2.2.h and 8.4.2.2.h"]
[]
[{"$f":"IF(ISBLANK(H181),\"\",($E$8&\".\"&+(COUNTA(H$7:H181))))","v":""},"SANS","EXCAVATION AND BACKFILLING"]
[{"$f":"IF(ISBLANK(H182),\"\",($E$8&\".\"&+(COUNTA(H$7:H182))))","v":""},"1200 DB"]
[{"$f":"IF(ISBLANK(H183),\"\",($E$8&\".\"&+(COUNTA(H$7:H183))))","v":""},null,"Excavate in all materials, backfill and compact to 93%"]
[{"$f":"IF(ISBLANK(H184),\"\",($E$8&\".\"&+(COUNTA(H$7:H184))))","v":""},null,"mod AASHTO density, and dispose of surplus and"]
[{"$f":"IF(ISBLANK(H185),\"\",($E$8&\".\"&+(COUNTA(H$7:H185))))","v":""},null,"unsuitable materials for trenches"]
[{"$f":"IF(ISBLANK(H186),\"\",($E$8&\".\"&+(COUNTA(H$7:H186))))","v":""}]
[{"$f":"IF(ISBLANK(H187),\"\",($E$8&\".\"&+(COUNTA(H$7:H187))))","v":""},"8.3.2","(a)",".1","Up to 1m wide"]
[{"$f":"IF(ISBLANK(H188),\"\",($E$8&\".\"&+(COUNTA(H$7:H188))))","v":""}]
[{"$f":"IF(ISBLANK(H189),\"\",($E$8&\".\"&+(COUNTA(H$7:H189))))","v":"8.23"},"LI",null,null,".2","Maximum 2m deep",null,"m³",{"$f":"23087+((26090-23087)*0.15)","v":23537.45}]
[{"$f":"IF(ISBLANK(H190),\"\",($E$8&\".\"&+(COUNTA(H$7:H190))))","v":""}]
[{"$f":"IF(ISBLANK(H191),\"\",($E$8&\".\"&+(COUNTA(H$7:H191))))","v":""},"8.3.2","(b)","Extra over reference 8.3.2 (a) for"]
[{"$f":"IF(ISBLANK(H192),\"\",($E$8&\".\"&+(COUNTA(H$7:H192))))","v":""}]
[{"$f":"IF(ISBLANK(H193),\"\",($E$8&\".\"&+(COUNTA(H$7:H193))))","v":"8.24"},"LI",null,".2","Hard rock excavation (controlled blasting)",null,null,"m³",154]
[{"$f":"IF(ISBLANK(H194),\"\",($E$8&\".\"&+(COUNTA(H$7:H194))))","v":""}]
[{"$f":"IF(ISBLANK(H195),\"\",($E$8&\".\"&+(COUNTA(H$7:H195))))","v":"8.25"},"LI",null,".3","Hard rock excavation (chemical blasting)",null,null,"m³",103]
[]
[{"$f":"IF(ISBLANK(H197),\"\",($E$8&\".\"&+(COUNTA(H$7:H197))))","v":""},"8.3.2","(c)","Excavate unsuitable material from trench bottom, "]
[{"$f":"IF(ISBLANK(H198),\"\",($E$8&\".\"&+(COUNTA(H$7:H198))))","v":""},"LI",null,"dispose of material, and re-fill with suitable imported"]
[{"$f":"IF(ISBLANK(H199),\"\",($E$8&\".\"&+(COUNTA(H$7:H199))))","v":"8.26"},null,null,"material compacted to 90% mod AASHTO density",null,null,null,"m³",51]
[{"$f":"IF(ISBLANK(H200),\"\",($E$8&\".\"&+(COUNTA(H$7:H200))))","v":""}]
[null,null,"EXISTING SERVICES"]
[]
[{"$f":"IF(ISBLANK(H203),\"\",($E$8&\".\"&+(COUNTA(H$7:H203))))","v":""},null,"WORK TO EXISTING SERVICES"]
[{"$f":"IF(ISBLANK(H204),\"\",($E$8&\".\"&+(COUNTA(H$7:H204))))","v":""}]
[{"$f":"IF(ISBLANK(H205),\"\",($E$8&\".\"&+(COUNTA(H$7:H205))))","v":""},null,"Existing services that intersect or adjoin  pipe trench"]
[{"$f":"IF(ISBLANK(H206),\"\",($E$8&\".\"&+(COUNTA(H$7:H206))))","v":""},null,"excavations"]
[{"$f":"IF(ISBLANK(H207),\"\",($E$8&\".\"&+(COUNTA(H$7:H207))))","v":""}]
[{"$f":"IF(ISBLANK(H208),\"\",($E$8&\".\"&+(COUNTA(H$7:H208))))","v":""},"8.3.5","(a)","Services that intersect a trench"]
[{"$f":"IF(ISBLANK(H209),\"\",($E$8&\".\"&+(COUNTA(H$7:H209))))","v":""}]
[{"$f":"IF(ISBLANK(H210),\"\",($E$8&\".\"&+(COUNTA(H$7:H210))))","v":"8.27"},"LI",null,".1","Electric cables",null,null,"no",257]
[{"$f":"IF(ISBLANK(H211),\"\",($E$8&\".\"&+(COUNTA(H$7:H211))))","v":""}]
[{"$f":"IF(ISBLANK(H212),\"\",($E$8&\".\"&+(COUNTA(H$7:H212))))","v":"8.28"},"LI",null,".4","Water main not exceeding 300mm dia",null,null,"no",257]
[{"$f":"IF(ISBLANK(H213),\"\",($E$8&\".\"&+(COUNTA(H$7:H213))))","v":""}]
[{"$f":"IF(ISBLANK(H214),\"\",($E$8&\".\"&+(COUNTA(H$7:H214))))","v":""},"8.3.5","(b)","Services that adjoin a trench"]
[{"$f":"IF(ISBLANK(H215),\"\",($E$8&\".\"&+(COUNTA(H$7:H215))))","v":""}]
[{"$f":"IF(ISBLANK(H216),\"\",($E$8&\".\"&+(COUNTA(H$7:H216))))","v":"8.29"},"LI",null,".1","Electric cables",null,null,"m",257]
[]
[{"$f":"IF(ISBLANK(H218),\"\",($E$8&\".\"&+(COUNTA(H$7:H218))))","v":"8.30"},"LI",null,".4","Water main not exceeding 300mm dia",null,null,"m",257]
[{"$f":"IF(ISBLANK(H219),\"\",($E$8&\".\"&+(COUNTA(H$7:H219))))","v":""}]
[null,null,"BEDDING"]
[]
[{"$f":"IF(ISBLANK(H222),\"\",($E$8&\".\"&+(COUNTA(H$7:H222))))","v":""},"SANS","BEDDING FROM TRENCH EXCAVATIONS"]
[{"$f":"IF(ISBLANK(H223),\"\",($E$8&\".\"&+(COUNTA(H$7:H223))))","v":""},"1200 LB"]
[{"$f":"IF(ISBLANK(H224),\"\",($E$8&\".\"&+(COUNTA(H$7:H224))))","v":""},"8.2.1","Provision of bedding material from trench excavations"]
[{"$f":"IF(ISBLANK(H225),\"\",($E$8&\".\"&+(COUNTA(H$7:H225))))","v":""}]
[{"$f":"IF(ISBLANK(H226),\"\",($E$8&\".\"&+(COUNTA(H$7:H226))))","v":"8.31"},"LI","(a)","Selected granular material ",null,null,null,"m³",359]
[{"$f":"IF(ISBLANK(H227),\"\",($E$8&\".\"&+(COUNTA(H$7:H227))))","v":""}]
[{"$f":"IF(ISBLANK(H228),\"\",($E$8&\".\"&+(COUNTA(H$7:H228))))","v":"8.32"},"LI","(b)","Selected fill material",null,null,null,"m³",257]
[{"$f":"IF(ISBLANK(H229),\"\",($E$8&\".\"&+(COUNTA(H$7:H229))))","v":""}]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward"]
[]
[{"$f":"IF(ISBLANK(H233),\"\",($E$8&\".\"&+(COUNTA(H$7:H233))))","v":""},null,"BEDDING FROM OTHER EXCAVATIONS ON SITE"]
[{"$f":"IF(ISBLANK(H234),\"\",($E$8&\".\"&+(COUNTA(H$7:H234))))","v":""}]
[{"$f":"IF(ISBLANK(H235),\"\",($E$8&\".\"&+(COUNTA(H$7:H235))))","v":""},"8.2.2.1","Provision of bedding material by importation from"]
[{"$f":"IF(ISBLANK(H236),\"\",($E$8&\".\"&+(COUNTA(H$7:H236))))","v":""},null,"other necessary excavations within the freehaul "]
[{"$f":"IF(ISBLANK(H237),\"\",($E$8&\".\"&+(COUNTA(H$7:H237))))","v":""},null,"distance"]
[{"$f":"IF(ISBLANK(H238),\"\",($E$8&\".\"&+(COUNTA(H$7:H238))))","v":""}]
[{"$f":"IF(ISBLANK(H239),\"\",($E$8&\".\"&+(COUNTA(H$7:H239))))","v":"8.33"},"LI","(a)","Selected granular material ",null,null,null,"m³",359]
[{"$f":"IF(ISBLANK(H240),\"\",($E$8&\".\"&+(COUNTA(H$7:H240))))","v":""}]
[{"$f":"IF(ISBLANK(H241),\"\",($E$8&\".\"&+(COUNTA(H$7:H241))))","v":"8.34"},"LI","(b)","Selected fill material",null,null,null,"m³",257]
[{"$f":"IF(ISBLANK(H242),\"\",($E$8&\".\"&+(COUNTA(H$7:H242))))","v":""}]
[{"$f":"IF(ISBLANK(H243),\"\",($E$8&\".\"&+(COUNTA(H$7:H243))))","v":""},null,"BEDDING FROM COMMERCIAL SOURCES"]
[{"$f":"IF(ISBLANK(H244),\"\",($E$8&\".\"&+(COUNTA(H$7:H244))))","v":""}]
[{"$f":"IF(ISBLANK(H245),\"\",($E$8&\".\"&+(COUNTA(H$7:H245))))","v":""},"8.2.2.3","Provision of bedding material by importation from "]
[{"$f":"IF(ISBLANK(H246),\"\",($E$8&\".\"&+(COUNTA(H$7:H246))))","v":""},null,"commercial sources selected by the Contractor"]
[{"$f":"IF(ISBLANK(H247),\"\",($E$8&\".\"&+(COUNTA(H$7:H247))))","v":""}]
[{"$f":"IF(ISBLANK(H248),\"\",($E$8&\".\"&+(COUNTA(H$7:H248))))","v":"8.35"},"LI","(a)","Selected granular material ",null,null,null,"m³",2873]
[{"$f":"IF(ISBLANK(H249),\"\",($E$8&\".\"&+(COUNTA(H$7:H249))))","v":""}]
[{"$f":"IF(ISBLANK(H250),\"\",($E$8&\".\"&+(COUNTA(H$7:H250))))","v":"8.36"},"LI","(b)","Selected fill material",null,null,null,"m³",2052]
[{"$f":"IF(ISBLANK(H251),\"\",($E$8&\".\"&+(COUNTA(H$7:H251))))","v":""}]
[{"$f":"IF(ISBLANK(H252),\"\",($E$8&\".\"&+(COUNTA(H$7:H252))))","v":"8.37"},"LI","(c)","19mm Crushed stone drainage material",null,null,null,"m³",{"$f":"2905*0.05","v":145.25},null,null,"No ground water expected due to shallow on-site sewer depth, however, some test pits had refusal at 0.2m, therefore, allow 15% for trenches with ground water."]
[{"$f":"IF(ISBLANK(H253),\"\",($E$8&\".\"&+(COUNTA(H$7:H253))))","v":""}]
[{"$f":"IF(ISBLANK(H254),\"\",($E$8&\".\"&+(COUNTA(H$7:H254))))","v":"8.38"},"LI","(d)","Bidim A2 fabric wrapped around crushed stone",null,null,null,"m²",{"$f":"46910*0.05","v":2345.5}]
[{"$f":"IF(ISBLANK(H255),\"\",($E$8&\".\"&+(COUNTA(H$7:H255))))","v":""}]
[{"$f":"IF(ISBLANK(H256),\"\",($E$8&\".\"&+(COUNTA(H$7:H256))))","v":""},null,"uPVC SEWER PIPES"]
[{"$f":"IF(ISBLANK(H257),\"\",($E$8&\".\"&+(COUNTA(H$7:H257))))","v":""}]
[{"$f":"IF(ISBLANK(H258),\"\",($E$8&\".\"&+(COUNTA(H$7:H258))))","v":""},"8.2.1.a","Supply, lay, joint, bed (flexible pipe bedding) and test "]
[{"$f":"IF(ISBLANK(H259),\"\",($E$8&\".\"&+(COUNTA(H$7:H259))))","v":""},null,"uPVC class 34 spigot and socket sewer pipes "]
[{"$f":"IF(ISBLANK(H260),\"\",($E$8&\".\"&+(COUNTA(H$7:H260))))","v":""},null,"with moulded rubber rings to SABS 791"]
[{"$f":"IF(ISBLANK(H261),\"\",($E$8&\".\"&+(COUNTA(H$7:H261))))","v":""}]
[{"$f":"IF(ISBLANK(H262),\"\",($E$8&\".\"&+(COUNTA(H$7:H262))))","v":"8.39"},"LI",".1","110mm Diameter",null,null,null,"m",{"$f":"909*35","v":31815},null,null,null,{"$f":"I269/2","v":909},null,{"$f":"909*40","v":36360}," no of stands*45m"]
[{"$f":"IF(ISBLANK(H263),\"\",($E$8&\".\"&+(COUNTA(H$7:H263))))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"I262/M262","v":35}]
[{"$f":"IF(ISBLANK(H264),\"\",($E$8&\".\"&+(COUNTA(H$7:H264))))","v":""},null,"CLEANING EYES"]
[{"$f":"IF(ISBLANK(H265),\"\",($E$8&\".\"&+(COUNTA(H$7:H265))))","v":""},null,null,null,null,null,null,null,null,null,null,null,"1:60 grade",{"$f":"1/60","v":1.6666666666666666E-2}]
[{"$f":"IF(ISBLANK(H266),\"\",($E$8&\".\"&+(COUNTA(H$7:H266))))","v":""},null,"Supply and install cleaning eye complete (all depths)",null,null,null,null,null,null,null,null,null,0.5,"0.5m deep at gully"]
[{"$f":"IF(ISBLANK(H267),\"\",($E$8&\".\"&+(COUNTA(H$7:H267))))","v":""},null,"Dwg LSO-228-SW-TD02"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"30*N265","v":0.5}]
[{"$f":"IF(ISBLANK(H269),\"\",($E$8&\".\"&+(COUNTA(H$7:H269))))","v":"8.40"},"LI",".1","110mm Dia pipes",null,null,null,"no",{"$f":"909*2","v":1818},null,null,null,{"$f":"M266+M268","v":1},"depth of on-site sewer pipe, therefore only encounter possible ground water at tie-n to main line"]
[]
[{"$f":"IF(ISBLANK(H271),\"\",($E$8&\".\"&+(COUNTA(H$7:H271))))","v":""},null,"SUNDRIES",null,null,null,null,null,null,null,null,null,"geotech - say rock at 1m average depth and ground water between rock and soil, therefore, ground water at 1m depth"]
[]
[{"$f":"IF(ISBLANK(H273),\"\",($E$8&\".\"&+(COUNTA(H$7:H273))))","v":""},null,"CONCRETE ENCASEMENT AND THRUST BLOCKS"]
[{"$f":"IF(ISBLANK(H274),\"\",($E$8&\".\"&+(COUNTA(H$7:H274))))","v":""}]
[{"$f":"IF(ISBLANK(H275),\"\",($E$8&\".\"&+(COUNTA(H$7:H275))))","v":""},"8.2.7","Encasement of pipes in strength concrete 25Mpa/19mm"]
[{"$f":"IF(ISBLANK(H276),\"\",($E$8&\".\"&+(COUNTA(H$7:H276))))","v":""},null,"including all formwork, reinforcement, etc"]
[{"$f":"IF(ISBLANK(H277),\"\",($E$8&\".\"&+(COUNTA(H$7:H277))))","v":""}]
[{"$f":"IF(ISBLANK(H278),\"\",($E$8&\".\"&+(COUNTA(H$7:H278))))","v":"8.41"},"LI","(a)","Casing around pipes",null,null,null,"m³",5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Carried Forward"]
[null,null,null,null,null,null,null,null,null,"Brought Forward",{"$f":"K289","v":0}]
[{"$f":"IF(ISBLANK(H291),\"\",($E$8&\".\"&+(COUNTA(H$7:H291))))","v":""}]
[{"$f":"IF(ISBLANK(H292),\"\",($E$8&\".\"&+(COUNTA(H$7:H292))))","v":""},null,"SOILCRETE"]
[{"$f":"IF(ISBLANK(H293),\"\",($E$8&\".\"&+(COUNTA(H$7:H293))))","v":""}]
[{"$f":"IF(ISBLANK(H294),\"\",($E$8&\".\"&+(COUNTA(H$7:H294))))","v":""},null,"Soilcrete (5% OPC) "]
[{"$f":"IF(ISBLANK(H295),\"\",($E$8&\".\"&+(COUNTA(H$7:H295))))","v":""}]
[{"$f":"IF(ISBLANK(H296),\"\",($E$8&\".\"&+(COUNTA(H$7:H296))))","v":"8.42"},"LI","(a)","Backfilling around pipes",null,null,null,"m³",51]
[]
[]
[]
[{"$f":"IF(ISBLANK(H300),\"\",($E$8&\".\"&+(COUNTA(H$7:H300))))","v":""},null,"WORK TO EXISTING PIPEWORK"]
[]
[{"$f":"IF(ISBLANK(H302),\"\",($E$8&\".\"&+(COUNTA(H$7:H302))))","v":""},null,"WORK TO EXISTING SERVICES"]
[{"$f":"IF(ISBLANK(H303),\"\",($E$8&\".\"&+(COUNTA(H$7:H303))))","v":""}]
[{"$f":"IF(ISBLANK(H304),\"\",($E$8&\".\"&+(COUNTA(H$7:H304))))","v":""},"8.2.11","Connection to existing sewer "]
[{"$f":"IF(ISBLANK(H305),\"\",($E$8&\".\"&+(COUNTA(H$7:H305))))","v":""}]
[{"$f":"IF(ISBLANK(H306),\"\",($E$8&\".\"&+(COUNTA(H$7:H306))))","v":"8.43"},"LI","(a)","110mm Dia pipe to existing manholes or erf connections",null,null,null,"no",103]
[{"$f":"IF(ISBLANK(H307),\"\",($E$8&\".\"&+(COUNTA(H$7:H307))))","v":""}]
[{"$f":"IF(ISBLANK(H308),\"\",($E$8&\".\"&+(COUNTA(H$7:H308))))","v":"8.44"},"LI","(b)","110mm Dia pipe to existing house connection",null,null,null,"no",{"$f":"903","v":903}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C8","v":"BILL NO"},null,{"$f":"$E$8","v":8}]
[null,null,"EARTHWORKS ( PIPE TRENCHES )"]
[]
[null,null,"Carried forward to Summary of Bills",null,null,null,null,null,null,"Total"]

{"sheet":"Sum Opt2","index":8,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[9,0,9,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[25,0,25,1],[26,0,26,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1]]}
[{"$f":"'A-P&G '!A1","v":"Contract:  RLM/OMM/0156/2024/25"}]
["Part C2:  Pricing Data"]
["Section C2.3: Summary of Bills"]
[]
["Rustenburg Local Municipality"]
["APPOINTMENT OF A CONTRACTOR FOR THE REPLACEMENT OF TLHABANE  AC SEWER PIPES - PHASE 2B"]
["CONTRACT RLM/OMM/0156/2024/25"]
[]
[]
[" Summary of Bills"]
[]
["Bill No.","Description","Amount ( R )"]
[1,"Preliminary and General"]
[2,"Provisional Sums and Prime Cost Items"]
[3,"Dayworks"]
[4,"Temporary Works "]
[5,"New sewers"]
[6,"Rebuild sewers"]
[7,"Existing sewers"]
[8,"Sewers on existing stands"]
[null,"Sub-Total"]
["Provisional sum: Allowance for Contract Price Adjustment (6% of Sub-Total)"]
["Sub-Total all Portions"]
["Provisional sum: Allowance for Contingencies (10% of Sub-Total)"]
["Total Construction Cost"]
["Value Added Tax at 15%"]
["Total Project Cost"]