{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Detailed Activity schedule","P&G's","Geo-tech","Fees ","Dwellers- Buildings ","Kraal & Fencing","Decommissioning","Main Access road-Gravel","Dwellers - Drive-way","Water reticulation ","Sewer reticulation","Electricity"],"not_rendered":{"images":1,"external_links":224,"defined_names":11499,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Detailed Activity schedule","index":0,"n_rows":107,"n_cols":5,"rows_kept":107,"merged":[[2,1,2,4],[5,2,6,2],[5,3,6,3],[5,4,6,4],[24,1,29,1],[24,2,29,2],[30,1,34,1],[30,2,34,2],[35,1,40,1],[35,2,40,2],[41,1,47,1],[41,2,47,2],[48,1,56,1],[48,2,56,2],[57,1,61,1],[57,2,61,2],[67,1,68,1],[67,2,68,2],[67,3,68,3],[67,4,68,4]]}
[]
[]
[null,"C2.2 the activity schedule"]
[]
[]
[null,"Item","Programme Reference","Activity description","Price"]
[null,"No."]
[null,"A1",null,"PRELIMINARY AND GENERAL x 4,5 MONTHS",{"$f":"SUM(E9:E10)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"P&G s for 4,5 months"]
[]
[null,"B",null,"Designs",{"$f":"SUM(E12:E16)","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Architectural & Structural Designs for the houses including foundations, walls, and roofs"]
[null,2,null,"Roads and Civils "]
[null,3,null,"Borehole Pump Systems, Head Resevoirs, Potable Water Reticulation, including foundations and structural elements"]
[null,4,null,"Sewer Reticulation including the conservancy tanks"]
[null,5,null,"Electrical reticulation including solar panels, earthing & lightning protection"]
[]
[null,"C",null,"GEOTECHNICAL & GEOHYDROLOGICAL INVESTIGATIONS",{"$f":"SUM(E19:E22)","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Review of the Geohydrological & Geotechnical Reports provided by the Employer"]
[null,2,null,"Geohydrological Deliverables"]
[null,3,null,"Geotechnical Deliverables"]
[null,4,null,"Further Geotechnical tests to be conducted"]
[]
[null,"D",null,"DWELLER HOMESTEADS AND INFRASTRUCTURE ",{"$f":"E25+E31+E36+E42+E49+E58+E63+E64","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Construction of Five (5) Housing Units including Rondavel and Ablution facility for Dweller One Homestead - P Shabalala",{"$f":"SUM(E26:E30)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Type B Sheet 15"]
[{"$nulls":3},"Type C Sheet 3"]
[{"$nulls":3},"Type C Sheet 12"]
[{"$nulls":3},"Rondavel Type F"]
[{"$nulls":3},"Ablution Block"]
[null,2,null,"Construction of Five (5) Housing Units including Rondavel and Ablution facility for Dweller Two Homestead - E Shabalala",{"$f":"SUM(E32:E35)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Type B Sheet 15"]
[{"$nulls":3},"Type C Sheet 12"]
[{"$nulls":3},"Rondavel Type F"]
[{"$nulls":3},"Ablution Block"]
[null,3,null,"Construction of Six (6) Housing Units including a Rondavel and Ablution facility for Dweller Three Homestead - B Shabalala",{"$f":"SUM(E37:E41)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Type B Sheet 15"]
[{"$nulls":3},"Type C Sheet 3"]
[{"$nulls":3},"Type C Sheet 12"]
[{"$nulls":3},"Rondavel Type F"]
[{"$nulls":3},"Ablution Block"]
[null,4,null,"Construction of Four (4) Housing Units including a Rondavel and Ablution facility for Dweller Four Homestead - J Dlamini",{"$f":"SUM(E43:E48)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Type A Sheet 1"]
[{"$nulls":3},"Type A Sheet 11"]
[{"$nulls":3},"Type C Sheet 3"]
[{"$nulls":3},"Type C Sheet 12"]
[{"$nulls":3},"Rondavel Type F"]
[{"$nulls":3},"Ablution Block"]
[null,5,null,"Construction of Five (5) Housing Units including Two (2) Rondavels and Ablution facility for Dweller Five Homestead - P Mkhwanazi",{"$f":"SUM(E50:E57)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Type A Sheet 11"]
[{"$nulls":3},"Type B Sheet 2"]
[{"$nulls":3},"Type B Sheet 15"]
[{"$nulls":3},"Type C Sheet 3"]
[{"$nulls":3},"Type C Sheet 12"]
[{"$nulls":3},"Rondavel Type F"]
[{"$nulls":3},"Rondavel Type F"]
[{"$nulls":3},"Ablution Block"]
[null,6,null,"Construction of Two (2) Housing Units including a Rondavel and Ablution facility for Dweller Six Homestead - C Shabalala",{"$f":"SUM(E59:E62)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"Type B Sheet 15"]
[{"$nulls":3},"Type C Sheet 12"]
[{"$nulls":3},"Rondavel Type F"]
[{"$nulls":3},"Ablution Block"]
[null,7,null,"Construction of Six (6) Kraals, One (1) per Dweller"]
[null,8,null,"Decommissioning and Rehabilitation of previously occupied dwellings"]
[]
[null,"E",null,"ACCESS ROADS, DRIVEWAYS, ETC",{"$f":"SUM(E67:E69)","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Construction of the main access road (Bedford dam route) to the dwellers site including hauling, watering, and the placement of selected subgrade & layerworks as well as stormwater management"]
[null,2,null,"Construction of the internal access roads to each dweller including hauling, watering, and the placement of selected subgrade &layerworks as well as stormwater management"]
[]
[]
[null,"F",null,"PERIMETER FENCING, ACCESS GATES, ETC",{"$f":"SUM(E72:E73)","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Installation of Perimeter Fencing, Stock Fences, Grave fences and Access Gates"]
[]
[null,"G",null,"POTABLE WATER SYSTEM",{"$f":"SUM(E75:E83)","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Construction of Potable Water System, including Construction of Boreholes, Fencing, Borehole Pump System, Bulk Reservoir, Jojo Tanks & Reticulation for Dweller One Homestead"]
[null,2,null,"Construction of Potable Water System, including Construction of Boreholes, Fencing, Borehole Pump System, Bulk Reservoir, Jojo Tanks & Reticulation for Dweller Two Homestead"]
[null,3,null,"Construction of Potable Water System, including Construction of Boreholes, Fencing, Borehole Pump System, Bulk Reservoir, Jojo Tanks & Reticulation for Dweller Three Homestead"]
[null,4,null,"Construction of Potable Water System, including Construction of Boreholes, Fencing, Borehole Pump System, Bulk Reservoir, Jojo Tanks & Reticulation for Dweller Four Homestead"]
[null,5,null,"Construction of Potable Water System, including Construction of Boreholes, Fencing, Borehole Pump System, Bulk Reservoir, Jojo Tanks & Reticulation for Dweller Five Homestead"]
[null,6,null,"Construction of Potable Water System, including Construction of Boreholes, Fencing, Borehole Pump System, Bulk Reservoir, Jojo Tanks & Reticulation for Dweller Six Homestead"]
[null,7,null,"Construction of Potable Water System for Animal Consumption"]
[null,8,null,"Supply and Install Windmill complete with components tested and commissioned "]
[null,9,null,"Commissioning & Testing of boreholes, tanks, pump systems, pipework, etc."]
[]
[null,"H",null,"HOT WATER SYSTEM",{"$f":"SUM(E86:E91)","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Installation of Solar Water Geyser and Hot Water Reticulation for Dweller One Homestead"]
[null,2,null,"Installation of Solar Water Geyser and Hot Water Reticulation for Dweller Two Homestead"]
[null,3,null,"Installation of Solar Water Geyser and Hot Water Reticulation for Dweller Three Homestead"]
[null,4,null,"Installation of Solar Water Geyser and Hot Water Reticulation for Dweller Four Homestead"]
[null,5,null,"Installation of Solar Water Geyser and Hot Water Reticulation for Dweller Five Homestead"]
[null,6,null,"Installation of Solar Water Geyser and Hot Water Reticulation for Dweller Six Homestead"]
[]
[null,"I",null,"SEWAGE RETICULATION & TREATMENT SYSTEM",{"$f":"SUM(E94:E99)","v":{"v":0,"d":"R0.00"}}]
[null,1,null," Install Sewage Reticulation & Treatment System for Dweller Five Homestead"]
[null,2,null," Install Sewage Reticulation & Treatment System for Dweller Five Homestead"]
[null,3,null," Install Sewage Reticulation & Treatment System for Dweller Five Homestead"]
[null,4,null," Install Sewage Reticulation & Treatment System for Dweller Five Homestead"]
[null,5,null," Install Sewage Reticulation & Treatment System for Dweller Five Homestead"]
[null,6,null," Install Sewage Reticulation & Treatment System for Dweller Five Homestead"]
[]
[null,"I",null,"ELECTRICAL WORKS",{"$f":"SUM(E102)","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Supply and installation of Electrical Work (including Solar Power, Cabling, Earthing, Lighting, Testing and Commissioning and As Built Drawings)"]
[]
[null,"J",null,"HANDOVER",{"$f":"SUM(E105)","v":{"v":0,"d":"R0.00"}}]
[null,1,null,"Handover documentation"]
[]
[{"$nulls":3},"TOTAL",{"$f":"SUM(E101+E93+E85+E74+E71+E66+E24+E18+E11+E8+E104)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"P&G's","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[]
[]
[]
[]
[null,"Item","Bill description","Unit","Quantity","Rate","Amont "]
[]
[]
[null,null,"PRELIMINARIES & GENERALS "]
[]
[null,null,"Preliminery and General"]
[null,1,"Contractrual Requirements","Sum",1,null,{"$f":"E11*F11","v":0}]
[null,2,"Designs ,Approvals, Surveys  and Permitts ","Sum",0,null,0]
[null,3,"Set up & Manage programme for scheduling & tracking of project ","Sum",1,null,0]
[{"$nulls":6},0]
[null,null,"Fixed P&Gs",{"$nulls":3},0]
[null,4,"Site Establishment","Sum",1,null,0]
[null,5,"Safety File","Sum",1,null,0]
[null,6,"Plant ","Sum",1,null,0]
[null,9," PPE","Sum",1,null,0]
[]
[null,null,"Time Related",{"$nulls":3},{"$f":"E21*F21","v":0}]
[null,7,"Offices & Storage Containers ","Sum",4.5,null,0]
[null,8,"Site Supervision ","Sum",4.5,null,0]
[null,10,"SHEQ ","Sum",4.5,null,0]
[null,11,"Site staff accomodation","Sum",4.5,null,0]
[null,12,"Site travelling expenses","Sum",4.5,null,0]
[null,13,"Facility of the contractor","Sum",4.5,null,0]
[]
[null,null,"BILL NO.1 : PRELIMINARIES & GENERALS ",{"$nulls":3},{"$f":"SUM(G11:G27)","v":0}]

{"sheet":"Geo-tech","index":2,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[7,2,9,2],[7,3,9,3],[12,2,14,2],[15,1,17,1],[15,2,17,2],[23,1,23,4]]}
[]
[]
[]
[]
[null,"DESCRIPTION","UNIT","QTY","Rate ","Amount"]
[]
[]
[null,"Fieldwork and Report with","No",6]
[null,"interpretations, covering the site"]
[null,"suitably.",{"$nulls":3},{"$f":"D8*E10","v":0}]
[]
[]
[null," Establishment","No"]
[]
[null," Establishment and Equipment to site",null,{"v":1,"d":"1.00"},null,{"$f":"D15*E15","v":0}]
[null," P&G Daily","No"]
[]
[{"$nulls":3},6,null,{"$f":"D18*E18","v":0}]
[]
[]
[null,"Geo-Tech Engineer team","No",6,null,{"$f":"D21*E21","v":0}]
[]
[null,"Allow additional tests ","Provision",1,null,{"$f":"D23*E23","v":0}]
[{"$nulls":5},{"$f":"SUM(F8:F23)","v":0}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},{"$f":"F8","v":0}]

{"sheet":"Fees ","index":3,"n_rows":19,"n_cols":17,"rows_kept":19}
[]
[]
["Professional Fee's "]
[]
["CONSTRUCTION VALUE FOR FEE PURPOSES (Excluding VAT)"]
[]
["Discipline","Design Costs",{"$nulls":6},"Claim from IDT Sub consultant","Total","Agreement with Sub consultant","Stage 1 to 3","Stage 4 to 6","Stage 1 to 6","Total","Durapi Margin","DURAPI QS/PM VALUE"]
[]
["Quantity Surveying",{"$nulls":15},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Architect",{"$nulls":7},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!*40%","v":{"$error":"#REF!"}},{"$f":"(#REF!*60%)*95%","v":{"$error":"#REF!"}},null,{"$f":"SUM(L10:N10)","v":{"$error":"#REF!"}},{"$f":"J10-O10","v":{"$error":"#REF!"}}]
["Civil/Structural Engineer"]
["Electrical Engineer"]
[]
["Total Fees:",{"$f":"SUM(B9:B12)","v":0}]
[]
[]
["1. Fee scale method proposed for determining professional fees, the method is standard basis for widely accepted by the Built environment "]
["2. For Engineering scope of works low complexity project category used to calculate costs estimate "]
["3. Consultations, local authority approvals, design development "]

{"sheet":"Dwellers- Buildings ","index":4,"n_rows":72,"n_cols":5,"rows_kept":72,"merged":[[1,1,1,4],[12,1,12,4],[22,1,22,4],[34,1,34,4],[47,1,47,4],[61,1,61,4],[71,1,71,3]]}
[]
[null,"Dweller 01"]
[]
[null,"Dwelling Type ","No off ","Rate ","Amount "]
[]
[null,"Type B Sheet 15",{"v":1,"d":"1.00"},null,{"$f":"C6*D6","v":0}]
[null,"Type C Sheet 3",{"v":4,"d":"4.00"},null,{"$f":"C7*D7","v":0}]
[null,"Type C Sheet 12",{"v":1,"d":"1.00"},null,{"$f":"C8*D8","v":0}]
[null,"Rondawel Type F",{"v":2,"d":"2.00"},null,0]
[null,"Ablution Block",{"v":1,"d":"1.00"},null,0]
[{"$nulls":4},{"$f":"SUM(E2:E10)","v":0}]
[]
[null,"Dweller 02"]
[null,"Dwelling Type ","No off ","Rate ","Amount "]
[]
[null,"Type B Sheet 15",{"v":1,"d":"1.00"},null,{"$f":"C16*D16","v":0}]
[null,"Type C Sheet 12",{"v":4,"d":"4.00"},null,{"$f":"C17*D17","v":0}]
[null,"Rondawel Type F",{"v":1,"d":"1.00"},null,{"$f":"C18*D18","v":0}]
[null,"Ablution Block",{"v":1,"d":"1.00"},null,0]
[{"$nulls":4},{"$f":"SUM(E14:E19)","v":0}]
[]
[]
[null,"Dweller 03"]
[]
[null,"Dwelling Type ","No off ","Rate ","Amount "]
[]
[null,"Type B Sheet 15",1,null,{"$f":"C27*D27","v":0}]
[null,"Type C Sheet 3",1,null,{"$f":"C28*D28","v":0}]
[null,"Type C Sheet 12",3,null,0]
[null,"Rondawel Type F",2,null,0]
[null,"Ablution Block",1,null,0]
[{"$nulls":4},{"$f":"SUM(E24:E31)","v":0}]
[]
[]
[null,"Dweller 04"]
[]
[null,"Dwelling Type ","No off ","Rate ","Amount "]
[]
[null,"Type A Sheet 1",1,null,{"$f":"C39*D39","v":0}]
[null,"Type A Sheet 11",1,null,{"$f":"C40*D40","v":0}]
[null,"Type C Sheet 3",1,null,{"$f":"C41*D41","v":0}]
[null,"Type C Sheet 12",1,null,0]
[null,"Rondawel Type F",1,null,{"$f":"C43*D43","v":0}]
[null,"Ablution Block",1,null,0]
[{"$nulls":4},{"$f":"SUM(E39:E44)","v":0}]
[]
[]
[null,"Dweller 05"]
[]
[null,"Dwelling Type ","No off ","Rate ","Amount "]
[null,"Type A Sheet 11",1,null,{"$f":"C51*D51","v":0}]
[null,"Type B Sheet 2",1,null,{"$f":"C52*D52","v":0}]
[null,"Type B Sheet 15",1,null,0]
[null,"Type C Sheet 3",1,null,0]
[null,"Type C Sheet 12",1,null,0]
[null,"Rondawel Type C",1,null,0]
[null,"Rondawel Type F",1,null,0]
[null,"Ablution Block",1,null,0]
[{"$nulls":4},{"$f":"SUM(E51:E58)","v":0}]
[]
[]
[null,"Dweller 06"]
[]
[null,"Dwelling Type ","No off ","Rate ","Amount "]
[]
[null,"Type B Sheet 15",1,null,{"$f":"C66*D66","v":0}]
[null,"Type C Sheet 12",1,null,{"$f":"C67*D67","v":0}]
[null,"Rondawel Type F",1,null,0]
[null,"Ablution Block",1,null,0]
[{"$nulls":4},{"$f":"SUM(E63:E69)","v":0}]
[]
[null,"Total ",null,null,{"$f":"E11+E20+E32+E45+E59+E70","v":0}]

{"sheet":"Kraal & Fencing","index":5,"n_rows":23,"n_cols":7,"rows_kept":23}
[]
[null,"Item","Bill description","Unit","Quantity","Rate","Amount"]
[]
[null,null,"KRAAL & FENCING",""]
[]
[null,"1","Clearing of working area of the kraal with all associated material required for installing the kraal"]
[]
[null,"1.1","Gum poles 2.4 m x 126","No",{"$f":"126*6","v":756},null,{"$f":"F8*E8","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[null,"1.2"," Gate ","No",6,null,{"$f":"F11*E11","v":{"v":0,"d":"R 0.00"}}]
[]
[null,2,"Supply, deliver and install new 1,83m high galvanized diamond mesh 'safety fence' complete with steel post etc"]
[]
[null,null,"1.8m diamond mesh ","m",{"$f":"440*6","v":2640},null,{"$f":"F15*E15","v":{"v":0,"d":"R 0.00"}}]
[]
[null,null," Gate ","No",6,null,{"$f":"F17*E17","v":{"v":0,"d":"R 0.00"}}]
[]
[null,null,"Kraal",{"$nulls":3},{"$f":"SUM(G8:G11)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,null,"Fence",{"$nulls":3},{"$f":"SUM(G15:G17)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,null,"TOTAL ",{"$nulls":3},{"$f":"SUM(G19:G21)","v":{"v":0,"d":"R 0.00"}}]

{"sheet":"Decommissioning","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"merged":[[1,0,1,5]]}
[]
["Decommissioning and Rehabilitation of previously occupied dwellings"]
[]
["Item","Bill description","Unit","Quantity","Rate","Amount"]
[]
[null,null,""]
[null,"Demolish existing infrastructure ","No",6,null,{"$f":"D7*E7","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Rehabilitation ","No",6,null,{"$f":"D9*E9","v":{"v":0,"d":"R 0.00"}}]
[{"$nulls":5},{"$f":"SUM(F7:F9)","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[]
[null,"Tlb",{"$f":"2*9*240*8","v":34560}]
[null,"Tipper truck",{"$f":"3*650","v":1950}]
[null,"Labour",{"$f":"5*35*9*8","v":12600}]
[null,null,{"$f":"SUM(C14:C16)","v":49110}]

{"sheet":"Main Access road-Gravel","index":7,"n_rows":73,"n_cols":9,"rows_kept":73,"merged":[[0,1,0,8]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QTY","MATERIAL","LABOUR/PLANT","PROFIT","AMOUNT"]
[]
[null,null,"PREAMBLES"]
[]
[null,null,"For Preambles see \"Model Preambles For Trades\""]
[]
[null,null,"Nature of ground"]
[]
[null,null,"A soil investigation has been carried out on site and the report is annexed to these bills of quantities. Descriptions of excavations shall be deemed to include all ground conditions classifiable as \"earth\" described in the above report and where conditions of a more difficult character are indicated these are separately measured."]
[]
[null,null,"SITE CLEARANCE"]
[]
[null,{"$f":"'Dwellers - Drive-way'!B59+1","v":22},"Digging up and removing rubbish, debris, vegetation, hedges, shrubs, bush, etc and trees not exceeding 200mm girth","m2",12600,{"$nulls":3},{"$f":"(H14+G14+F14)*E14","v":0}]
[]
[null,null,"REMOVING TOPSOIL"]
[]
[null,{"$f":"B14+1","v":23},"Remove topsoil up to depth of 100mm and stockpile on site to preserve and maintain for reinstatement","m3",8400,{"$nulls":3},{"$f":"(H18+G18+F18)*E18","v":0}]
[]
[null,null,"BULK EXCAVATIONS"]
[]
[null,{"$f":"B18+1","v":24},"150mm deep Bulk Excavation in all material for:"]
[]
[null,{"$f":"B22+1","v":25},"Bulk excavation to underside of Roadbed","m3",12600,{"$nulls":3},{"$f":"(H24+G24+F24)*E24","v":0}]
[]
[null,null,"Extra over bulk excavation in earth for excavation in"]
[]
[null,{"$f":"B24+1","v":26},"Intermediate excavation","m3",126,{"$nulls":3},{"$f":"(H28+G28+F28)*E28","v":0}]
[]
[null,{"$f":"B28+1","v":27},"Hard rock excavation","m3",63,{"$nulls":3},{"$f":"(H30+G30+F30)*E30","v":0}]
[]
[null,null,"RIP & RECOMPACT"]
[]
[null,null,"Base preparation of in-situ material (Rip and recompacted 150mm deep to 95% MOD AASHTO or as specified by the Engineer):"]
[]
[null,{"$f":"B30+1","v":28},"Rip and Recompact underside of Roadbed","m2",12600,{"$nulls":3},{"$f":"(H36+G36+F36)*E36","v":0}]
[]
[null,null,"FILL IN LAYERWORKS"]
[]
[null,null,"Imported Fill supplied by the contractor from commercial sources"]
[]
[null,29,"Surplus material from excavations and/or stock piles on site to a dumping site to be located by the contractor","m3",10,{"$nulls":3},{"$f":"(H42+G42+F42)*E42","v":0}]
[]
[null,null,"Prescribed density tests on filling"]
[]
[null,30,"Modified AASHTO Density test","No",50,{"$nulls":3},{"$f":"(H46+G46+F46)*E46","v":0}]
[]
[null,null,"EARTHWORKS",{"$nulls":5},{"$f":"SUM(I4:I47)","v":0}]
[]
[null,null,"STORMWATER WORKS"]
[]
[null,null,"PREAMBLES"]
[]
[null,null,"For Preambles see \"Model Preambles For Trades\""]
[]
[null,null,"Please refer to the drawing for the stormwater culverts when costing the Structure. The Cost shall include everything in order to complete each structure. This shall comprise of the supply of all materials, imported fill, removal and disposal of excess material, reinstatement and rehabilitation; and other items included in the design drawings, including but not limited to the following Items:"]
[]
[null,null,"1) All excavation, earthworks, and road works associated with the stormwater culverts, including backfilling and reinstatement of road layerworks, adjacent to and above culverts"]
[null,null,"2) Supply & install Culverts, headwalls, wingwalls, concrete floor slabs, reno-mattresses, and other structures"]
[null,null,"3) Supply & Install Stormwater Culvert and Outlet from culvert excavations"]
[null,null,"4) Provide layerworks and foundations below culverts"]
[null,null,"5) Supply and install steel pipe supports within culverts"]
[null,null,"6) All testing "]
[]
[null,{"$f":"B46+1","v":31},"Stormwater  consisting of 6X600mm dia. Culvert wwith headwall ","No.",3,{"$nulls":3},{"$f":"(H65+G65+F65)*E65","v":0}]
[]
[null,null,"STORMWATER WORKS",{"$nulls":5},{"$f":"SUM(I49:I66)","v":0}]
[]
[null,null,{"$f":"C48","v":"EARTHWORKS"},{"$nulls":5},{"$f":"I48","v":0}]
[]
[null,null,{"$f":"C67","v":"STORMWATER WORKS"},{"$nulls":5},{"$f":"I65","v":0}]
[]
[null,null,"TOTAL",{"$nulls":5},{"$f":"I69+I71","v":0}]

{"sheet":"Dwellers - Drive-way","index":8,"n_rows":66,"n_cols":9,"rows_kept":66,"merged":[[0,1,0,8],[1,1,1,8]]}
[]
[]
[null,"ITEM","DESCRIPTION","UNIT","QTY","MATERIAL","LABOUR/PLANT","PROFIT","AMOUNT"]
[]
[]
[null,null,"EARTHWORKS "]
[]
[null,null,"Nature of ground"]
[]
[null,null,"A soil investigation has been carried out on site and the report is annexed to these bills of quantities. Descriptions of excavations shall be deemed to include all ground conditions classifiable as \"earth\" described in the above report and where conditions of a more difficult character are indicated these are separately measured."]
[]
[null,null,"Refer to Geotech report by Peregrine Geoconsultants."]
[]
[null,null,"SITE CLEARANCE"]
[]
[null,{"$f":"'P&G''s'!B27+1","v":14},"Digging up and removing rubbish, debris, vegetation, hedges, shrubs, bush, etc and trees not exceeding 200mm girth","m2",{"v":13500,"d":"13500.00"},{"$nulls":3},{"$f":"(H16+G16+F16)*E16","v":0}]
[]
[null,null,"REMOVING TOPSOIL"]
[]
[null,{"$f":"B16+1","v":15},"Remove topsoil up to depth of 100mm and stockpile on site to preserve and maintain for reinstatement","m3",{"v":1350,"d":"1350.00"},{"$nulls":3},{"$f":"(H20+G20+F20)*E20","v":0}]
[]
[null,null,"BULK EXCAVATIONS"]
[]
[null,null,"150mm deep Bulk Excavation in all material for:"]
[]
[null,{"$f":"B20+1","v":16},"Bulk excavation to underside of Roadbed","m3",{"v":2025,"d":"2025.00"},{"$nulls":3},{"$f":"(H26+G26+F26)*E26","v":0}]
[]
[null,null,"Extra over bulk excavation in earth for excavation in"]
[]
[null,{"$f":"B26+1","v":17},"Intermediate excavation","m3",{"v":202.5,"d":"202.50"},{"$nulls":3},{"$f":"(H30+G30+F30)*E30","v":0}]
[]
[null,{"$f":"B30+1","v":18},"Hard rock excavation","m3",101.25,{"$nulls":3},{"$f":"(H32+G32+F32)*E32","v":0}]
[]
[null,null,"RIP & RECOMPACT"]
[]
[null,null,"Base preparation of in-situ material (Rip and recompacted 150mm deep to 95% MOD AASHTO or as specified by the Engineer):"]
[]
[null,{"$f":"B32+1","v":19},"Rip and Recompact underside of Roadbed","m3",{"v":2025,"d":"2025.00"},{"$nulls":3},{"$f":"(H38+G38+F38)*E38","v":0}]
[]
[null,null,"ENGINEERED FILL IN LAYERWORKS"]
[]
[null,null," Fill supplied by the contractor "]
[]
[null,{"$f":"B38+1","v":20},"Selected Layer - removed material compacted to 95% Modified AASHTO density in layers 150mm thick","m3",{"v":2025,"d":"2025.00"},{"$nulls":3},{"$f":"(H44+G44+F44)*E44","v":0}]
[]
[null,null,"EARTHWORKS",{"$nulls":5},{"$f":"SUM(I5:I45)","v":0}]
[]
[null,null,"STORMWATER WORKS"]
[]
[null,null,"Please refer to the drawing for the stormwater culverts when costing the Structure. The Cost shall include everything in order to complete each structure. This shall comprise of the supply of all materials, imported fill, removal and disposal of excess material, reinstatement and rehabilitation; and other items included in the design drawings, including but not limited to the following Items:"]
[]
[null,null,"1) All excavation, earthworks, and road works associated with the stormwater culverts, including backfilling and reinstatement of road layerworks, adjacent to and above culverts"]
[null,null,"2) Supply & install Culverts, headwalls, wingwalls, concrete floor slabs, reno-mattresses, and other structures"]
[null,null,"3) Supply & Install Stormwater Culvert and Outlet from culvert excavations"]
[null,null,"4) Provide layerworks and foundations below culverts"]
[null,null,"5) Supply and install steel pipe supports within culverts"]
[null,null,"6) All testing "]
[]
[null,{"$f":"B44+1","v":21},"Stormwater  consisting of 6X600mm dia. Culvert with concrete encasement","No.",{"v":6,"d":"6.00"},{"$nulls":3},{"$f":"(H59+G59+F59)*E59","v":0}]
[]
[null,null,"STORMWATER WORKS",{"$nulls":5},{"$f":"SUM(I47:I60)","v":0}]
[]
[null,null,{"$f":"C46","v":"EARTHWORKS"},{"$nulls":5},{"$f":"I46","v":0}]
[]
[null,null,{"$f":"C61","v":"STORMWATER WORKS"},{"$nulls":5},{"$f":"I59","v":0}]
[{"$nulls":8},{"$f":"SUM(I63:I65)","v":0}]

{"sheet":"Water reticulation ","index":9,"n_rows":105,"n_cols":7,"rows_kept":105,"merged":[[104,2,104,5]]}
[]
[null,"Item","Bill description","Unit","Quantity","Rate","Amount"]
[]
[null,null,"WATER RETICULATION & HOT WATER",""]
[]
[null,null,"EXCAVATION",""]
[]
[null,null,"Clearing and removal of the top soil along the pipe route.","m2",{"v":2325,"d":"2,325"},null,{"$f":"E8*F8","v":0}]
[]
[null,null,"Excavate in all materials, select materials, backfill, and dispose of surplus and unsuitable material, for pipes for total trench depths:",""]
[]
[null,null,"Exceeding      but     not exceeding",""]
[]
[null,null,".01)   0.0 m                      1.0 m","m³",450,null,{"$f":"E14*F14","v":0}]
[]
[null,null,"Extra-over items 1.1.1  for :",""]
[]
[null,null,".01) Intermediate excavation","m³",225,null,{"$f":"E18*F18","v":0}]
[]
[]
[null,null,"PIPELINE",""]
[]
[null,null,"Supply, handle, lay on flexible pipe bedding.",""]
[]
[null,null,"Joint with victaulic couplings, test, and disinfect (potable Class 9 water pipeline)",""]
[]
[]
[null,null,".02) 110 mm dia.","m",500,null,{"$f":"E28*F28","v":0}]
[]
[null,null,".03) 90 mm dia.","m",1050,null,{"$f":"E30*F30","v":0}]
[]
[]
[null,null,"Supply, handle, lay on flexible pipe bedding. Joint with compression fittings, test, and disinfect (potable water pipeline)",""]
[]
[null,null,"PN 10 HDPE pipes:",""]
[]
[null,null,".01) 40 mm dia.","m",30,null,{"$f":"E37*F37","v":0}]
[]
[null,null,".02) 32 mm dia.","m",600,null,{"$f":"E39*F39","v":0}]
[]
[null,null,".02) 25mm dia.","m",300,null,{"$f":"E41*F41","v":0}]
[]
[null,null,"PROVISION OF BEDDING",""]
[]
[null,null,"Available from trench within 0.5km",""]
[]
[null,null,"(a) Selected granular material","m³",{"v":164.92000000000002,"d":"164.92"},null,{"$f":"E47*F47","v":0}]
[]
[null,null,"(b) Selected fill material","m³",494.76,null,{"$f":"E49*F49","v":0}]
[]
[null,null,"(c) Excavated material ","m³",936.51,null,{"$f":"E51*F51","v":0}]
[]
[]
[null,null,"Sundries Provision of all work related to the removal of existing pipework and fittings (where ordered by Engineer) after replacement of new ones, including for their loading and re-use/disposal (measured per all inclusive metre of pipeline):",""]
[]
[]
[null,null,"Water Connections to Existing  Connection of the house units to the new reticulation complete all fittings.","No",12,null,{"$f":"E57*F57","v":0}]
[]
[null,null,"ANCILLARIES",""]
[]
[null,null,"Anchor/Thrust blocks","m³",15,null,{"$f":"E61*F61","v":0}]
[]
[null,null,"Valve chambers for item 1.4.2. Supply all materials and construct valvechambers","No.",6,null,{"$f":"E63*F63","v":0}]
[]
[null,null,"Marker Posts","No.",6,null,{"$f":"E65*F65","v":0}]
[]
[null,null,"END CAPS",""]
[]
[null,null,".01) 110mm Diameter","No.",6,null,{"$f":"E69*F69","v":0}]
[]
[null,null," Water Tank Support",""]
[]
[null,null,"Conrete platform (2 x 20 000 litres)","No",9,null,{"$f":"E73*F73","v":0}]
[]
[null,null,"Conrete platform ( 6 x 10 000 litres)","No",16.2,null,{"$f":"E75*F75","v":0}]
[]
[null,null," Water Tank"]
[]
[null,null,"20 000 litres","No",2,null,{"$f":"E79*F79","v":0}]
[]
[null,null," 6 x 10 000 litres","No",6,null,{"$f":"E81*F81","v":0}]
[]
[null,null," WINDMILL "]
[]
[null,null,"Windmill complete with components , installed, tested and commissioned ","Prov.",1,null,{"$f":"E85*F85","v":0}]
[]
[null,null,"Construction of Potable Water System for Animal Consumption","Prov.",1,null,{"$f":"E87*F87","v":0}]
[]
[null,null,"HOT WATER(SOLAR GEYSER)"]
[]
[null,null,"Solar geyser complete with components , installed, tested and commissioned ","No",6,null,{"$f":"F91*E91","v":0}]
[]
[]
[null,null,"Commissioning flow and pressure tests as instucted  by Project Manager","Prov.",1,null,{"$f":"F94*E94","v":0}]
[]
[null,null,"Water reticulation",{"$nulls":3},{"$f":"SUM(G8:G82)","v":0}]
[]
[null,null,"Windmill",{"$nulls":3},{"$f":"G85","v":0}]
[]
[null,null,"Portable water for animal consumption",{"$nulls":3},{"$f":"G87","v":0}]
[]
[null,null,"Hot water (Solar geyser)",{"$nulls":3},{"$f":"G91","v":0}]
[]
[null,null,"Commissioning ",{"$nulls":3},{"$f":"G94","v":0}]
[null,null,"TOTAL",{"$nulls":3},{"$f":"SUM(G96:G104)","v":0}]

{"sheet":"Sewer reticulation","index":10,"n_rows":46,"n_cols":7,"rows_kept":46}
[]
[]
[null,"Item","Bill description","Unit","Quantity","Rate","Amount"]
[]
[null,null,"SEWERS",""]
[]
[null,null,"EXCAVATION",""]
[]
[null,null,"Excavate in all materials for trenches, select materials, backfill, compact and dispose of surplus and unsuitable material, for pipes:",""]
[]
[null,null,"i) 110mm diam. For total trench depths: Exceeding      but       not exceeding",""]
[]
[null,null,"a) 0.0 m                       1.0 m","m3",150,null,{"$f":"E13*F13","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[null,null,"i) Intermediate excavation","m³",37.5,null,{"$f":"E16*F16","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[null,null,"PROVISION OF BEDDING",""]
[]
[null,null,"Provision of Bedding from Trench Excavation",""]
[]
[null,null,"a) Selected Granular Material","m³",{"v":60.3309,"d":"60.33"},null,{"$f":"E23*F23","v":{"v":0,"d":"R 0.00"}}]
[]
[null,null,"b) Selected Fill Material","m³",{"v":42.599999999999994,"d":"42.60"},null,{"v":0,"d":"R 0.00"}]
[]
[null,null,"(c) Excavated material ","m³",{"v":104.37000000000002,"d":"104.37"},null,{"$f":"E27*F27","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[null,null,"PIPEWORK",""]
[]
[null,null,"Supply, lay, joint, bed and test Class 34 Solid Wall uPVC sewer pipes, including fittings and specials",""]
[]
[null,null,"a) 110 mm dia. pipes","m",300,null,{"$f":"E34*F34","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[]
[null,null,"MANHOLES, ETC.",""]
[]
[null,null,"Precast concrete manholes 1250 mm diameter complete with HDPE step irons and medium duty concrete cover and frame for depths over and up to",""]
[]
[null,null,"i) 0.0 m                       1.0 m","No",6,null,{"$f":"E42*F42","v":{"v":0,"d":"R 0.00"}}]
[]
[null,null,"Conservacy tank ","No",6,null,{"$f":"E44*F44","v":{"v":0,"d":"R 0.00"}}]
[]
[null,null,"TOTAL",{"$nulls":3},{"$f":"SUM(G6:G44)","v":{"v":0,"d":"R 0.00"}}]

{"sheet":"Electricity","index":11,"n_rows":16,"n_cols":4,"rows_kept":16,"merged":[[1,1,1,3],[2,1,2,2]]}
[]
[null,"supply and installation of Electrical Work (including Solar Power, Cabling, Earthing, Lighting, Testing and Commissioning and As Built Drawings"]
[null,"Rate/m2 "]
[]
[null,"Dweller 01 ",{"v":301.495244375,"d":"301.50"},{"$f":"C5*$D$3","v":0}]
[]
[null,"Dweller 02 ",{"v":228.16164437500004,"d":"228.16"},{"$f":"C7*$D$3","v":0}]
[]
[null,"Dweller 03 ",{"v":272.87008875000004,"d":"272.87"},{"$f":"C9*$D$3","v":0}]
[]
[null,"Dweller 04",{"v":376.0590693750001,"d":"376.06"},{"$f":"C11*$D$3","v":0}]
[]
[null,"Dweller 05 ",{"v":451.5467887500001,"d":"451.55"},{"$f":"C13*$D$3","v":0}]
[]
[null,"Dweller 06 ",{"v":146.465644375,"d":"146.47"},{"$f":"C15*$D$3","v":0}]
[{"$nulls":3},{"$f":"SUM(D5:D15)","v":0}]