{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["SUMMARY","PART 1.1 Ps&Gs","PART 1.2","PART 2","PART 3","PART 4","PART 5","PART 6","QUANTITIES","Sheet2"],"not_rendered":{"images":1,"external_links":1,"defined_names":15},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"SUMMARY","index":0,"n_rows":226,"n_cols":6,"rows_kept":226,"merged":[[8,0,8,5],[9,0,9,5],[21,2,21,3],[21,4,21,5],[22,4,22,5],[23,2,23,3],[23,4,23,5],[24,4,24,5],[25,2,25,3],[25,4,25,5],[26,4,26,5]],"flags":["formulas_cached_only"]}
[]
[]
["PROJECT:","SANBI PNBG CHILDREN'S EDU-TAINMENT GARDEN"]
["CONTRACT:","G493-2023"]
["CONTRACTOR:"]
["DATE:"]
[]
[]
["LANDCAPE BILL OF QUANTITIES - HARD & SOFT LANDSCAPING PHASE 1"]
["SUMMARY"]
[]
[null,"DESCRIPTION",{"$nulls":3},"AMOUNTS"]
[]
[null,"PART: 1.1 - Preliminaries & General",{"$nulls":3},0]
[null,"PART: 1.2 - Miscellaneous Items",{"$nulls":3},0]
[null,"PART: 2 - Earth Works & Soil Preparation",{"$nulls":3},0]
[null,"PART: 3 - Planting",{"$nulls":3},0]
[null,"PART: 4 - Hard Landscaping",{"$nulls":3},{"v":320000,"d":"R320,000.00"}]
[null,"PART: 5 - Irrigation",{"$nulls":3},0]
[null,"PART: 6 - Maintenance",{"$nulls":3},0]
[]
[null,null,"Sub-Total Excl. VAT",null,{"v":320000,"d":"R320,000.00"}]
[]
[null,null,"VAT @ 15%",null,{"v":48000,"d":"R48,000.00"}]
[]
[null,"`","Grand Total Incl. VAT",null,{"v":368000,"d":"R368,000.00"}]
[]
[null,"EXCLUSIONS"]
[null,"Professional fees"]
[null,"Electrical reticulation, Water reticulation and storm water piping"]
[null,"Bulk shaping"]
{"$rows_empty":104}
[{"$nulls":3},1650]
[{"$nulls":3},350]
{"$rows_empty":38}
[{"$nulls":3},240]
[]
[]
[]
[]
[null,"HAND RAIL ON RAMP AND BALUSTRADE\n(See drawing: NBP 0008 ALCD 302 & NBP 0008 ALCDXXX )"]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},52]
[{"$nulls":3},52]
{"$rows_empty":21}
[null,"Supply, deliver and install purpose made concrete drinking fountain (Supplier : Spectacular Concrete Works",null,3,{"v":7500,"d":"7,500.00"}]
{"$rows_empty":14}
[null,"Provision for 500mm x 1000mm wire mesh gabion\nbaskets. 3mm mesh with 40mm wide x 80mm high,\nopenings",null,140]

{"sheet":"PART 1.1 Ps&Gs","index":1,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[0,0,0,5],[1,1,1,5],[38,1,38,3]],"flags":["formulas_cached_only"]}
["LANDCAPE BILL OF QUANTITIES - HARD & SOFT LANDSCAPING PHASE 1"]
[null,"PART: 1.1 - Preliminaries & General"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE ","TOTAL "]
[]
["1.1.1","Site establishment"]
[null,"An area will be allocated to the contractor to establish the site camp. Allow for the fencing of the site camp with 2,1 m high 50% plastic shade netting supported with standards and wires. Maintain the fence for the duration of the contract and demolish afterwards. Remove all remaining rubble and rehablitate the site with appropriate grass seeding ","item",1,null,0]
["1.1.2","Construction site"]
[null,"Note that the PNBG site is currently used by visitors and their safety must at all times be considered. Fence off the construction area as indicated with 2.1m high 50% shade netting supported on standards and wires. Maintaint the fence for the duaration of the contract and demolish at the end thereof. Repair any damages caused to paving, services and lawn.","item",1,null,0]
["1.1.3","Access to the site "]
[null,"An access route to the construction site will be indicated by the Employer. Use this route only. Speed limit for all construction vehicles is 15km/h. At all times consider visitors' safety at the PNBG","item",1,null,0]
["1.1.4"," Construction site ablutions and meeting place"]
[null,"Supply and maintain temporary ablution facilities for contractor's staff. At no stage may existing ablution facilities at the PNBG be used by contractor's staff. Supply and maintain a site office large enough with furniture to seat 10 people at a table.","item",1,null,0]
["1.1.5","Damage to existing site facilities, services and vegetation"]
[null,"Any damages caused by the contractor to existing site facilities, services and vegetation mst be repaired to the satisfaction of the Principal Agent","item",1,null,0]
["1.1.6","Form of Contract and contractual clauses"]
[null,"The JBCC Principal Building Ageement/Minor Works Agreement will used for this project. The following Contract Data will apply:",null,1,null,0]
["1.1.6.1","Start date and competion dates: to be confirmed by the Client/ in the procurement document. All days referred to in the Contract will mean calendar day and include weekends, public holidays and builder's holidays","item",1,null,0]
["1.1.6.2","Contractor's program: A Program that indicates work flow and critical milestones to be submitted for approval within 7 days of site handover and subsequently updated and reported on at progress meetings","item",1,null,0]
["1.1.6.3","Construction guarantee required.","item",1,null,0]
["1.1.6.4","Payment guarantee will not be applicable","item",1,null,0]
["1.1.6.5","Penalties for late completion","item",1,null,0]
["1.1.6.6","Public liability insurance required","item",1,null,0]
["1.1.6.7","Provisional sum for play equipment: allowance has been indicated for a provisional sum amount in the contract for the delivered and installed children's play equipment. Contractor to add subcontract management and support if required.","item","sum"]
["1.1.6.8","Provisional sum for signage: allow for the sum of RXXXX as a provisional amount in the contract for the delivered and installed signage. Add subcontract management and support if required","item","sum"]
["1.1.6.9","Payment by the Employer: payment certificates will be paid by the Employer 30 days from the date of the certificates unless otherwise stated by the Client","item",1,null,0]
["1.1.6.10","Maintenance during the 90-days defects liability period: The Contractor to allow for the horticultural maintenance of plant material during the 90-days defects liability period. Payment hereof will be certified at the end of the 90-days by the PA","item",1,null,0]
["1.1.7","Contract management"]
[null,"The contract will be administered and the works inspected by the Principal Agent (PA) The PA will valuate progress and issue monthly payment certificates for payment by the Employer. Bi-weekly site inspections and progress meetings will be held on site. The contractor to attend the inspections and meetings an be represented by an authorised Site Manager who can receive instructions from PA.","item",1,null,0]
["1.1.8","Existing potable and irrigation water"]
[null,"Available on site, Contractor to allow for connections into such water supplies. Connection positions are indicated on the drawings","item",1,null,0]
["1.1.9","Existing electrical supply"]
[null,"Available on site, Contractor to allow for connections into such electrical supply. Connection positions are indicated on the drawings","item",1,null,0]
["1.1.10","Samples and workmanship"]
[null,"Samples of materials and workmanship must be provided at no cost for approval by the PA where requested","item",1,null,0]
["1.1.11","Plants supplied by employer"]
[null,"Note that some plants will be supplied by the Employer, allow for the receiving and storage on site The installation of such plants are covered under Part 3 of the BoQ ","item",1,null,0]
[]
[null,"TOTAL FOR PART 1.1",{"$nulls":3},0]

{"sheet":"PART 1.2","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,0,0,5],[1,1,1,5],[10,1,10,3]],"flags":["formulas_cached_only"]}
["LANDCAPE BILL OF QUANTITIES - HARD & SOFT LANDSCAPING PHASE 1"]
[null,"PART: 1.2 - Miscellaneous Items"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE ","TOTAL "]
[]
["1.2","Site Clearance"]
["i","Provision to lift and cart off site exsiting paving/ rubble/ flower bed edging ","m²",200,null,0]
["ii","Provision for thinning out of existing vegetation and removal of unwanted vegetation in existing soft landscaped areas including planted zones to be rehabilitated","m²",1000,null,0]
["iii","Removal of existing large trees that are old/unstable or within the construction footprint","no",10,null,0]
[]
[null,"TOTAL FOR PART 1.2",{"$nulls":3},0]

{"sheet":"PART 2","index":3,"n_rows":56,"n_cols":6,"rows_kept":56,"merged":[[0,0,0,5],[1,1,1,5],[55,1,55,3]],"flags":["formulas_cached_only"]}
["LANDCAPE BILL OF QUANTITIES - HARD & SOFT LANDSCAPING PHASE 1"]
[null,"Part 2: Earth works and Soil preparation"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE ","TOTAL "]
[]
["2.1","Provision for topsoil"]
[null,"The contractor to provide all necessary equipment, labor and machinery for import and spread of topsoil."]
[null,"The topsoil to be free of any building rubble, rocks or plant materials."]
[null,"Inclusive of all handwork where required."]
[null,"Compact soils where required, and prevent erosion at all times."]
["i","200 mm layer over new planting areas ","m³",113]
["ii","should be 50mm (was100mm) over new lawn areas","m³",14]
["iii","0.45m³ per tree hole ","m³",10]
["iv","Total topsoil import and spread on site","m³",137,null,0]
["2.2","Scarifying"]
[null,"Supply all the necessary equipment, tools  and labor for scarifying of all areas. "]
[null,"Rip soil in all areas in two directions and to a depth of 250mm."]
[null,"Use hand labour to scarify under trees to ensure that tree roots do not get damaged."]
[null,"Contractor to ensure that no services, existing paving or  concrete haunching behind curbs, are damaged."]
[null,"Remove all unwanted debris and medium to large sized rocks from the scarified soils and use suitable materials for soil berm filling."]
[null,"All inclusive rate per square meter."]
["i","Provision for scarifying of planting areas","m²",1000,null,0]
["2.3","Fine grading"]
[null,"Supply all necessary labor, machinery and equipment for the fine trimming of the planting soils of all areas."]
[null,"The contractor must ensure that all areas to be planted are compacted sufficiently to avoid any subsidence later on. Soil surface to be planted should not exceed a tolerance of 30mm in height when measured from the basic topographical line."]
[null,"Cultivate fertilizers and compost as supplied elsewhere."]
[null,"Provision must be made for proper and effective storm  water drainage. "]
[null,"Soil erosion should be avoided at all times."]
[null,"Stones larger than 40mm in diameter and all foreign material must be removed and used for fill."]
[null,"Final surface must be shaped to desired profiles as to flow into levels of roadways and structures."]
[null,"No irrigation or storm water should be allowed to puddle anywhere behind the retaining walls or in any of the allocated plant bed areas."]
["i","Provision for planting areas ","m²",565,null,0]
["2.4","Provision for Compost import and spreading in plant beds"]
[null,"The contractor to provide all necessary equipment, labor and machinery for import and spread of compost."]
[null,"Sample of compost must comply with specification and be approved by the Landscape Architect prior to delivery on site."]
[null,"All compost shall consist of well-decomposed organic material, free of detrimental salts, glass, debris, weeds and other toxic impurities."]
[null,"The pH shall not exceed 7.0."]
[null,"Compost shall be protected against excessive rain, wind and dissipation."]
[null,"Payment after planting."]
[null,"Application rate:"]
["i","20mm deep over planting areas ","m³",11]
["ii","0.35m³ per tree hole ","m³",8]
["iii","Total compost import and spread","m³",19,null,0]
["2.5","Provision for Fertilizers"]
["2.5.1","Superphosphate over planting"]
["i","100 g/m² in planting areas","kg",57]
["ii","375 g/per tree hole","kg",8]
["iii","Total Super phosphate","kg",65,null,0]
["2.5.2","Mixture 2:3:2 over planting"]
["i","50 g/m² in planting areas ","kg",28]
["ii","100 g/per tree hole ","kg",2]
["iii","Total 3:2:3","kg",30,null,0]
["2.6","Provision for Mulching for planted areas"]
["i","30mm good quality bark chip mulch layer to be approved by Landscape Architect","m³",11,null,0]
[]
[null,"TOTAL FOR PART 2",{"$nulls":3},0]

{"sheet":"PART 3","index":4,"n_rows":84,"n_cols":6,"rows_kept":84,"merged":[[0,0,0,5],[1,1,1,5],[83,1,83,3]],"flags":["formulas_cached_only"]}
["LANDCAPE BILL OF QUANTITIES - HARD & SOFT LANDSCAPING PHASE 1"]
[null,"PART: 3 - Planting"]
[]
["ITEM","DESCRIPTION","UNIT","QTY.","RATE","TOTAL"]
[]
["3.1","METHOD FOR PLANTING TREES"]
[null,"Refer to  planting plan."]
[null,"Supply all equipment and labour for planting of trees."]
[null,"Provide all necessary stakes for trees and secure each tree firmly. Use 2 tree stakes placed opposite sides of the trees and attach to tree with approved tree ties. Tree stakes to be a minimum of 50mm dia. 500 mm into solid / firm soil."]
[null,"Prepare the hole as specified, place the plant and backfill with soil, compost and fertilizer to specification and tramp down firmly."]
[null,"Form pond around trees aand water well after planting."]
[null,"Remove all surplus soil."]
[null,"Keep all plants moist."]
[null,"Tree positions as per plan and confirmed by client and Landsacpe Architect."]
["i","Trees will be provided by SANBI. Contractor to prepare the tree holes, provide three stakes, anchor wires, and ties as per plans & details as well as maintain the planting for the specified maintenance period. Contractor to quote a rate per tree to be planted as specified.","no",22,null,0]
["3.2","METHOD FOR PLANTING SHRUBS & GROUNDCOVERS"]
[null,"Refer to planting plan."]
[null,"Supply all equipment and labour for planting of shrubsand groundcovers."]
[null,"Prepare the hole as specified, place the plant and backfill with soil, compost and fertilizer to specification and tramp down firmly."]
[null,"Remove all surplus soil."]
[null,"Form pond around shrubs and ground covers and water well after planting."]
[null,"Keep all plants moist."]
[null,"Plant densities as per plan and confirmed by client and Landsacpe Architect."]
[null,"Shrubs and groundcovers will be provided by SANBI. Contractor to prepare the holes, plant the plants as per the plans as well as maintain the planting for the specified maintenance period. Contractor to quote a rate per plant to be planted as specified."]
["3.3","REHABILITATION OF FOREST GARDEN:"]
[null,"Large shrubs to be thinned out."]
[null,"Shrubs and trees to be trimmed to achieve a clearance of 2m from floor height."]
[null,"Dead or dying existing plant material to be removed."]
[null,"Existing groundcovers and shrubs in a healthy condition to be retained. New plants to be planted between the existing."]
["i","Contractor to provide a rate for rehabilitation of forest garden.","m²",1505,null,0]
["3.4","PLANTING IN REHABILITATED FOREST GARDEN:"]
[null,"The following species to be added to area evenly (confirmed placement of plants with landscape architect on site):"]
["3.4.1","REHABILITATED FOREST ZONE 1 (730m²):"]
[null,"Dracaena aletriformis (no. 50)"]
[null,"Eucomis autumnalis (no. 50)"]
[null,"Asparagus densiflorus meyersii (no. 50)"]
[null,"Scadoxus paniculatus (no. 50)"]
[null,"Crinum moorei (no. 50)"]
[null,"Agapanthus inapertus (no. 100)"]
[null,"Scabiosa africana (no. 50)"]
[null,"Chlorophytum bowkeri (no. 50)"]
["i","Plants will be provided by SANBI. Contractor to prepare the holes, plant the plants as per the plans as well as maintain the planting for the specified maintenance period. Contractor to quote a rate per plant to be planted as specified.","no",450,null,0]
["3.4.2","REHABILITATED FOREST ZONE 2 (500m²):"]
[null,"Bareleria obtusa (no. 50)"]
[null,"Plectranthus ecklonii (no. 10)"]
[null,"Ocimum labiatum (no. 50)"]
[null,"Crocosmia aurea (no. 50)"]
[null,"Aristea ecklonii (no. 50)"]
[null,"Asystasia gangetica (no. 50)"]
["i","Plants will be provided by SANBI. Contractor to prepare the holes, plant the plants as per the plans as well as maintain the planting for the specified maintenance period. Contractor to quote a rate per plant to be planted as specified.","no",260,null,0]
["3.4.3","REHABILITATED FOREST ZONE 3 (275m²):"]
[null,"Eucomis autumnalis (no. 25)"]
[null,"Asparagus densiflorus meyersii (no. 25)"]
[null,"Crinum moorei (no. 25)"]
[null,"Agapanthus inapertus (no. 25)"]
[null,"Scabiosa africana (no. 25)"]
[null,"Chlorophytum bowkeri (no. 25)"]
[null,"Aristea ecklonii (no. 25)"]
[null,"Setaria megaphylla (no. 25)"]
["i","Plants will be provided by SANBI. Contractor to prepare the holes, plant the plants as per the plans as well as maintain the planting for the specified maintenance period. Contractor to quote a rate per plant to be planted as specified.","no",200,null,0]
["3.5","PLAY AREAS PLANTING:"]
["3.5.1","PLANT MIX 1 (92m²):"]
[null,"Portulacaria afra prostrata (no. 92)"]
[null,"Felicia amelloides (no. 184)"]
[null,"Pelargonium acetosum (no. 184)"]
["i","Plants will be provided by SANBI. Contractor to prepare the holes, plant the plants as per the plans as well as maintain the planting for the specified maintenance period. Contractor to quote a rate per plant to be planted as specified.","no",460,null,0]
["3.5.2","PLANT MIX 2 (186m²):"]
[null,"Juncus krausii (no. 93)"]
[null,"Dietes bicolor (no. 186)"]
[null,"Agapanthus nana blue (no. 372)"]
[null,"Crocosmia aurea (no. 372)"]
[null,"Bulbine frutescens (no. 372)"]
["i","Plants will be provided by SANBI. Contractor to prepare the holes, plant the plants as per the plans as well as maintain the planting for the specified maintenance period. Contractor to quote a rate per plant to be planted as specified.","no",1395,null,0]
["3.5.3","PLANT MIX 3 (285m²):"]
[null,"Setaria megaphylla (no. 142)"]
[null,"Aloe ecklonis (no. 570)"]
[null,"Agapanthus nana white (no. 570)"]
[null,"Plectranthus ecklonii (no. 20)"]
[null,"Asparagus densiflorus Myersii (no. 570)"]
["i","Plants will be provided by SANBI. Contractor to prepare the holes, plant the plants as per the plans as well as maintain the planting for the specified maintenance period. Contractor to quote a rate per plant to be planted as specified.","no",1872,null,0]
["3.6","NEW LAWN AREAS"]
["i","Supply and install new Kikuyu lawn as indicated on landscape plan","m²",273,null,0]
[]
[null,"TOTAL FOR PART 3",{"$nulls":3},0]

{"sheet":"PART 4","index":5,"n_rows":65,"n_cols":6,"rows_kept":65,"merged":[[0,0,0,5],[1,1,1,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[64,1,64,3]],"flags":["formulas_cached_only"]}
["LANDCAPE BILL OF QUANTITIES - HARD & SOFT LANDSCAPING PHASE 1"]
[null,"PART: 4 - Hard Landscaping"]
[]
["ITEM","DESCRIPTION","UNIT","QTY.","RATE","TOTAL"]
[]
["4.1","PAVING  & HARD SURFACES "]
["a","The contractor to provide all necessary machinery, labour, transport and materials for the supply and installation of paving."]
["b","Test sample edge: The contractor needs to install 2Lm on a concrete footing for approval. All aspects as specified need to be included into the test panel sample."]
["c","Setting out of pavers:"]
["-","All areas to be enclosed with the hard edge should be shaped to the desired slope and final soil levels for approval by the Landscape Architect, prior to the setting out of the edges for approval."]
["-","All edges to be set out by the contractor for approval by the Landscape Architect prior to the soil preparations for the footings."]
["-","Landscape architect to indicate all desired final levels, prior to installation."]
["d","Soil preparation:"]
["-","Excavate to allow for a 220mm wide (with 220 x 108,5 x 50mm  concrete edge units)  excavation to install the walkway dges. Structural engineer to confirm."]
["-","Base of the excavation should be compacted to 95% MOD AASHTO."]
["-","Where the surrounding area (enclosed area) sub-base needs to be compacted the excavation for the footing should only commence on completion of the compaction of the larger area."]
["-","No cracked, chipped, pavers with unwanted markings will be accepted. "]
["-","All areas showing subsidence on the final product will mean that the larger area will be redone, re-compacted and repaired to meet the specifications."]
["-","All levels need to accommodate a minimum fall to allow for sufficient water run off."]
["-","Install all the pavers top finishing levels 35 mm above the surrounding planting soil levels but level connecting to pathway heights or pathway kerbing."]
["-","Install whole pavers on all ends."]
["-","Install 10mm recessed, smooth mortar joints."]
["-","Rate to include all mechanical cutting of paver units."]
["-","Concrete to allow for breakage."]
["4.1.1","NEW PAVING"]
[null,"Supply, deliver & install (200 x 100 x 50mm) Corobrik De Hoop Multiblend Modular 50mm thick Paver, herringbone. Allow for compaction, 25mm compacted sand and agreed final levels.","m²",468,null,0]
["4.1.2","GRAVEL"]
["i","Supply, deliver & install 60mm thick gravel layer on Bidem geotextile and gravel fix (to later detail) Bidem to be included in price.","m³",10,null,0]
["ii","Supply, deliver & install Bera Gravel fix for gravel areas as per supplier's instruction.","m²",10,null,0]
["4.1.3","RUBBERISED SURFACES FOR PLAY AREAS:"]
[null,"Supply, deliver and install 40mm thick EPDM rubber surface in various colours:"]
["i","Colour: light blue","m²",113,null,0]
["ii","Colour: Light brown","m²",225,null,0]
["iii","Colour: Mustard yellow","m²",120,null,0]
["4.1.4","PERMA-EDGE"]
[null,"Provision to deliver, supply and install 1000 x 125 x 1.6mm Perma-edge galvanized steel edging, dark brown, or similar approved, between planted areas and gravel areas as indicated on plan","Lm",25,null,0]
["4.1.5","COMPOSITE DECKING"]
[null,"Provision to deliver, supply and install Composite decking for boardwalk and wetland deck, to later specification","m²",76,null,0]
["4.1.6","SANDPIT"]
[null,"Provision to deliver, supply and install 400mm average depth of sand for sandpit, including concrete base and structure to engineer's later  specification.","m³",15,null,0]
["4.1.7","STEEL EDGE FOR RUBBER SURFACES"]
[null,"Provision to deliver, supply and install 40mm x 40mm x 4mm mild steel edge bolted into concrete base, with 2 x coats of black etch primer","Lm",190,null,0]
["4.2","BRICK SEATING & RETAINING WALL"]
[null,"Provision for 405mm high, 455mm wide, seating walls with facebrick finish. Corobrik Tambotie facebrick finish. Stack bond. Foundations and compacted soil layers to engineer's detail with brick on edge coping.","Lm",50,null,0]
["4.3","EXTERNAL LIGHTING:"]
[null,"AS PER ELECTRICAL ENGINEER'S LATER  SPECIFICATION AND BOQ"]
[null,"Sum allowance for external lighting (Post-top lights to later specification)","no",7,null,0]
["4.4","STREET FURNITURE AND PLAY EQUIPMENT:"]
["4.4.1","PRE-CAST CONCRETE BENCH"]
[null,"2000 x 900 x 450mm Pre-cast concrete Wilson Stone Turin Quartz bench, Colour Grey or similar approved (with indigenous games detail)","no",4,null,0]
["4.4.2","PRE-CAST CONCRETE LITTER BINS"]
[null,"600mm x 600mm pre-cast concrete litter bin to later specification","no",7,null,0]
["4.4.3","PRE-CAST CONCRETE DRINKING FOUNTAIN"]
[null,"Pre-cast concrete drinking fountain to later specification, including installation and all fixing and foundation work.","no",1,null,0]
["4.5","PLAY EQUIPMENT"]
[null,"The rate for gym and play equipment must allow for the purchase, transport, off loading, storage on site and installation. All equipment is to be of an Architectural standard and will be subject to the closet scrutiny for blemishes and imperfections. Installation must strictly be according to manufactures specifications. The contractor will be hereby deemed to have taken this into account in his prices."]
["4.5.1","Supply, deliver and install custom older children play structure (composite timber decking and steel components)","prov. sum",null,null,{"v":150000,"d":"R150,000.00"}]
["4.5.2","Supply, deliver and install custom toddler play structure (composite timber decking and steel components)","prov. sum",null,null,{"v":110000,"d":"R110,000.00"}]
["4.6","SIGNAGE"]
[null,"Sum allowance for signage (to later specification)","prov. sum",null,null,{"v":40000,"d":"R40,000.00"}]
["4.7","CONCRETE ELEMENTS"]
["4.7.1","Sum allowance for concrete sports and games tables (to later specification)","prov. sum",null,null,{"v":20000,"d":"R20,000.00"}]
["4.7.3","Allowance for supply and install Vanstone pre-cast concrete circular tree ring (minimum 1200mm dia.) (to be filled with gravel and Bidum geotextile)","No",3,null,0]
[]
[null,"TOTAL FOR PART 4",{"$nulls":3},{"v":320000,"d":"R320,000.00"}]

{"sheet":"PART 5","index":6,"n_rows":85,"n_cols":6,"rows_kept":85,"merged":[[0,0,0,5],[1,1,1,5],[5,0,5,1],[10,0,10,1],[17,0,17,1],[58,0,58,1],[77,0,77,1],[84,1,84,3]],"flags":["formulas_cached_only"]}
["LANDCAPE BILL OF QUANTITIES - HARD & SOFT LANDSCAPING PHASE 1"]
[null,"PART: 5 - Irrigation"]
[]
["ITEM","DESCRIPTION","UNIT","QTY.","RATE","TOTAL"]
[]
["Water Connection Point"]
["GN32","NIPPLE BARREL GALV 32MM   ",null,{"v":2,"d":"2.00"},null,0]
["H-GV32","BRASS GATE VALVE 1.1/4\"",null,{"v":1,"d":"1.00"},null,0]
["CPRV-11/4","32MM BSP P.R.VALVE",null,{"v":1,"d":"1.00"},null,0]
["RBVB430","RAINBIRD 430MM RECTANGULAR VALVEBOX WITH LID",null,{"v":1,"d":"1.00"},null,0]
["Mainline Materials"]
["CMA32X11/4","SAB MALE ADAPTER 32MM x 1.1/4\"",null,{"v":1,"d":"1.00"},null,0]
["CT50","SAB 50MM COMPRESSION TEE ",null,{"v":1,"d":"1.00"},null,0]
["HD050PN08","50MM PN06 X P/M HDPE PIPE SANS PE100",null,{"v":400,"d":"400.00"},null,0]
["CE50","SAB ELBOW 50MM",null,{"v":12,"d":"12.00"},null,0]
["CC50","SAB COUPLING 50MM",null,{"v":4,"d":"4.00"},null,0]
["CT50","SAB 50MM COMPRESSION TEE ",null,{"v":7,"d":"7.00"},null,0]
["Sprayline Materials"]
["HPS50X1","SAB 50MM X 1\" HP SADDLE PN16",null,{"v":9,"d":"9.00"},null,0]
["CFE50X11/2","SAB FEMALE ELBOW 50MM x 1.1/2\"",null,{"v":3,"d":"3.00"},null,0]
["CMA32X11/2","SAB MALE ADAPTER 32MM x 1.1/2\"",null,{"v":3,"d":"3.00"},null,0]
["CMA32X1","SAB MALE ADAPTER 32MM x 1\"",null,{"v":9,"d":"9.00"},null,0]
["HD032PN10","32MM PN10 X P/M HDPE PIPE SANS PE100",null,{"v":12,"d":"12.00"},null,0]
["CME32X1","SAB MALE ELBOW 32MM x 1\"",null,{"v":12,"d":"12.00"},null,0]
["H-V202100","COMPACT BALL VALVE FEM/THR 1\"",null,{"v":12,"d":"12.00"},null,0]
["RBVB250","RAINBIRD 250MM ROUND VALVEBOX WITH LID",null,{"v":12,"d":"12.00"},null,0]
["LD25C3","25 CLASS 3 LDPE PIPE",null,{"v":700,"d":"700.00"},null,0]
["LD20C3","20 CLASS 3 LDPE PIPE",null,{"v":12,"d":"12.00"},null,0]
["LD15C3","15 CLASS 3 LDPE",null,{"v":140,"d":"140.00"},null,0]
["RB1804","1804 R/BIRD POP-UP 100mm",null,{"v":116,"d":"116.00"},null,0]
["RB3504","RAINBIRD GEAR DRIVE POP UP FR/PC",null,{"v":22,"d":"22.00"},null,0]
["MBP651","EMJAY PP SOCKET 1/2\" (15MM) BSP",null,{"v":22,"d":"22.00"},null,0]
["PR15X0.75","15MM X 0.75M GREEN PVC RISER",null,{"v":22,"d":"22.00"},null,0]
["RB5004PC","RAINBIRD GEAR DRIVE POP-UP P/C",null,{"v":9,"d":"9.00"},null,0]
["RB5000SPC","RAINBIRD PC SHRUB ROTOR - SAM",null,{"v":3,"d":"3.00"},null,0]
["MBP652","EMJAY PP SOCKET 3/4\" (20MM) BSP",null,{"v":3,"d":"3.00"},null,0]
["PR20X0.75","20MM X 0.75M GREEN PVC RISER",null,{"v":3,"d":"3.00"},null,0]
["RB1401","RAINBIRD PREE.COMP BUBBLER0.25GPM",null,{"v":6,"d":"6.00"},null,0]
["MBP651","EMJAY PP SOCKET 1/2\" (15MM) BSP",null,{"v":6,"d":"6.00"},null,0]
["PR15X0.40","15MM X 0.40M GREEN PVC RISER",null,{"v":6,"d":"6.00"},null,0]
["RB15H","R-BIRD 15' H-CIRCLE NOZZLE 180° (3.4 - 4.6M)",null,{"v":87,"d":"87.00"},null,0]
["RB15VAN","R-BIRD 15' VAN NOZZLE ADJ ARC 0° - 360°",null,{"v":30,"d":"30.00"},null,0]
["FF1350","FULL FLOW MALE ELBOW 25MM X 1\"",null,{"v":11,"d":"11.00"},null,0]
["FF1050","FULL FLOW TEE 25MM",null,{"v":11,"d":"11.00"},null,0]
["FFF","FULL FLOW FITTINGS",null,{"v":88,"d":"88.00"},null,0]
["FF1050","FULL FLOW TEE 25MM",null,{"v":44,"d":"44.00"},null,0]
["FF1060","FULL FLOW ELBOW 25MM ",null,{"v":37,"d":"37.00"},null,0]
["FF1040","FULL FLOW CONNECTOR 25MM ",null,{"v":10,"d":"10.00"},null,0]
["FF1070","FULL FLOW REDUCING TEE 25MM X 15MM",null,{"v":105,"d":"105.00"},null,0]
["FF1110","FULL FLOW REDUCER 25MM X 15MM",null,{"v":36,"d":"36.00"},null,0]
["FF1013","FULL FLOW ELBOW 15MM",null,{"v":116,"d":"116.00"},null,0]
["FF1021","FULL FLOW MALE ADAPTOR 15MM X 1/2\"",null,{"v":116,"d":"116.00"},null,0]
["FF1015","FULL FLOW MALE ELBOW 15MM X 1/2\"",null,{"v":28,"d":"28.00"},null,0]
["FF1105","FULL FLOW REDUCING TEE 25MM X 20MM",null,{"v":9,"d":"9.00"},null,0]
["FF1045","FULL FLOW REDUCER 25MM X 20MM",null,{"v":3,"d":"3.00"},null,0]
["FF1014","FULL FLOW ELBOW 20MM",null,{"v":9,"d":"9.00"},null,0]
["FF1022","FULL FLOW MALE ADAPTER 20MM X 3/4\"",null,{"v":9,"d":"9.00"},null,0]
["FF1016","FULL FLOW MALE ELBOW 20MM X 3/4\"",null,{"v":3,"d":"3.00"},null,0]
["Turf Valve Materials"]
["CMA50X1","SAB MALE ADAPTER 50MM x 1\"",null,{"v":4,"d":"4.00"},null,0]
["MBP813","EMJAY PP FEMALE ELBOW 1\" (25MM) BSP",null,{"v":4,"d":"4.00"},null,0]
["MBP756","EMJAY PP MALE/FEMALE ELBOW 1\" (25MM) BSP",null,{"v":12,"d":"12.00"},null,0]
["PR25X0.30","25MM X 0.30M GREEN PVC RISER",null,{"v":4,"d":"4.00"},null,0]
["H-V202100","COMPACT BALL VALVE FEM/THR 1\"",null,{"v":4,"d":"4.00"},null,0]
["RBVB250","RAINBIRD 250MM ROUND VALVEBOX WITH LID",null,{"v":4,"d":"4.00"},null,0]
["AQ71PM","AQUA 25 PLASTIC TURF VALVE",null,{"v":4,"d":"4.00"},null,0]
["AQ70PMK","AQUA PLASTIC TURF VALVE KEY",null,{"v":3,"d":"3.00"},null,0]
["MB734","EMJAY COMB. FEMALE ELBOW 20MM X 3/4\"",null,{"v":3,"d":"3.00"},null,0]
["THC8","TORK 19-26MM HOSE CLAMP PERFORATED (20MM PIPE)",null,{"v":6,"d":"6.00"},null,0]
["DL20X30","20MM X 30M DRAGLINE M-DUTY BLACK",null,{"v":3,"d":"3.00"},null,0]
["SB225","3/4in SNAP ON HOSE CONNECTOR",null,{"v":1,"d":"1.00"},null,0]
["SB500","SNAP ON SPRAY NOZZLE",null,{"v":1,"d":"1.00"},null,0]
["DS20X.6","20MM X .6M DRAGLINE STAND",null,{"v":3,"d":"3.00"},null,0]
["AQ20PC-4.36X2.38","AQUA BRASS SPRINKLER P/C 3/4\" - 4.36MM X 2.38MM",null,{"v":3,"d":"3.00"},null,0]
["Labour"]
["LABMAINSTD","M-LINE LAB,TRENCH, INST.&BACKFILL UP TO 500MM DEEP",null,{"v":400,"d":"400.00"},null,0]
["LABSPRAY","SPRAYLINE LABOUR TRENCH & BACKFILL UP TO 450MM",null,{"v":400,"d":"400.00"},null,0]
["Contingencies"]
["MISC WCP FITT","CONN. TO EXIST. MAINS,PTFE,HEMP,ADD. FITTINGS ETC.",null,{"v":1,"d":"1.00"},null,0]
["MISC PIPE FITT","DANGERTAPE,IT,ADD PIPE FITTING-COUPLING,ELBOWS ETC",null,{"v":1,"d":"1.00"},null,0]
["MISC SPRAY FIT","FLAGS,PTFE,INS TAPE,REP COUPLING,ADD FF FITTINGS",null,{"v":1,"d":"1.00"},null,0]
["MISC AUTO FITT","CONDUIT,FASTENERS,GLANDS, INS. TAPE, JUNCTION BOX",null,{"v":1,"d":"1.00"},null,0]
["MISC TV FITT","PTFE, STABALISING RODS, HOSE REP COUPLINGS ETC",null,{"v":1,"d":"1.00"},null,0]
[]
[null,"TOTAL FOR PART 5",{"$nulls":3},0]

{"sheet":"PART 6","index":7,"n_rows":29,"n_cols":6,"rows_kept":29,"merged":[[0,0,0,5],[1,1,1,5],[28,1,28,3]],"flags":["formulas_cached_only"]}
["LANDCAPE BILL OF QUANTITIES - HARD & SOFT LANDSCAPING PHASE 1"]
[null,"PART: 6 - Maintenance"]
[]
["ITEM","DESCRIPTION","UNIT","QTY.","RATE","TOTAL"]
[]
["6.1","AFTER COMPLETION MAINTENANCE FOR 3 MONTHS"]
[null,"Allow for the complete maintenance and establishment of all planted areas, inclusive of:"]
[null,"Weekly mowing of lawn areas"]
[null,"Weekly removal and clearing of weeds in lawn areas"]
[null,"All clippings and roots are to be collected and dumped as instructed by the client."]
[null,"Monthly corrective pruning of shrubs and climbers"]
[null,"Weekly removal and clearing of weeds in planting areas"]
[null,"Keep tree rings/basins clear of weeds on a weekly basis"]
[null,"Maintain tree stake"]
[null,"Upon instruction, replacement of plants, all according to the specifications and as may be instructed by the Landscape Architect."]
[null,"Spray monthly for pests and diseases with an appropriate insecticide or fungicide as approved by the Landscape Architect and client."]
[null,"Weekly cleaning of paved areas"]
[null,"Monthly control of weeds in paved areas"]
[null,"Weekly raking and levelling of all gravel areas"]
[null,"Weekly raking and levelling of all bark chip mulch areas"]
[null,"Maintain perma edge by corrective pruning species overgrowing the edge"]
[null,"Daily sweeping of the all decking areas"]
[null,"Daily cleaning, leveling and raking of sandpit areas"]
[null,"Weekly clean up and remove litter from all planted areas"]
[null,"The maintenance period will commence upon issue of the Certificate of Practical Completion"]
[null,"Rate to be all inclusive"]
["i","Provision for 3 month landscape maintenance on trees and planting.","Mths",3,null,0]
[]
[null,"TOTAL FOR PART 6",{"$nulls":3},0]

{"sheet":"QUANTITIES","index":8,"n_rows":70,"n_cols":17,"rows_kept":70,"hidden":true,"merged":[[2,1,2,7],[71,1,71,7]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,"Proposed Landscape Design of the University of Mpumalanga "]
[null,null,"Park St, Gus St, Janie St, John Page St & Jules St"]
[null,null,"Johannesburg"]
[null,null,"for the Johannesburg Development Agency - JDA"]
[]
[null,null,"Landscape installation and maintenance preliminary cost estimate"]
[{"$nulls":7},"2018-11-20"]
[]
[null,"ITEM ","ITEM DESCRIPTION","UNIT","RATE","PLANTS/M²","QTY","TOTAL"]
[]
[]
[null,null,"SOFT LANDSCAPING ",{"$nulls":4},0]
[{"$nulls":3},"-----","-----",null,"-----","-----"]
[]
[null,"2","Groundcovers"]
[{"$nulls":3},"-----","-----",null,"-----","-----"]
[]
[null,"2.1","Planting mix 01 (succulent mix)",347,"m²"]
[null,"2.1.1","Aptenia cordifolia (4L)","ea",0,{"v":3,"d":"3.00"},{"v":1041,"d":"1041.00"},{"$nulls":7},"3/m2 /",null,1035]
[null,"2.1.3","Bulbine frutescens (4L)","ea",0,{"v":3,"d":"3.00"},{"v":1041,"d":"1041.00"},0,{"$nulls":5},"3/m2/",null,1035]
[null,"2.1.4","Aloe cooperii (4L)","ea",0,{"v":2,"d":"2.00"},{"v":694,"d":"694.00"},0]
[]
[]
[null,"2.3","Planting mix 02 (Grass mix)",115,"m²"]
[null,"2.3.2","Aristida (4L)","ea",0,{"v":4,"d":"4.00"},{"v":460,"d":"460.00"},0]
[null,"2.1.3","Aloe arborecens","ea",0,{"v":0.5,"d":"0.50"},{"v":57.5,"d":"57.50"},0]
[null,"2.1.5","Aloe cooperi","ea",0,{"v":2,"d":"2.00"},{"v":230,"d":"230.00"},0]
[]
[null,"2.7","Planter mix",105]
[null,"2.7.1","Plectranthus neohilus (2L)","ea",0,{"v":6,"d":"6.00"},{"v":630,"d":"630.00"},0]
[]
[]
[null,"2.8","Parking",100,"m²"]
[null,"2.6.1","Carpobrotus edulis (plugs)","ea",0,{"v":12,"d":"12.00"},{"v":1200,"d":"1200.00"},0]
[]
[null,"2.9","Lawn",4567,"m²"]
[null,"2.9.1","lm lawn","ea",0,null,null,0]
{"$rows_empty":10}
[null,null,"total m2 plants",667]
[null,null,"total m2 with lawn",5234]
[]
[null,"4","Trees"]
[{"$nulls":3},"-----","-----",null,"-----","-----"]
[{"$nulls":3},"size"]
[null,"4.1","Buddleja",50,0,"-----",8,0,null,"200liter"]
[null,"4.2","Ekebergia",20,0,"-----",25,0,null,"100liter",34]
[null,"4.3","Harpephyllum caffrum ",50,0,"-----",19,0,null,"50liter",44,null,"Pavetta lanceolata  OK"]
[null,"4.4","Searsia lepodictia",20,0,"-----",9,0,null,"20 liter",null,null,"Searsia leptodictya OK"]
[null,"4.5","Pappea capensis",50,0,"-----",17,0,{"$nulls":4},"OK"]
[{"$nulls":12}," OK"]
[]
[]
[]
[{"$nulls":12},"OK"]
[{"$nulls":12}," OK"]
[{"$nulls":12}," OK"]
[]
[{"$nulls":5},"total trees",78]

{"sheet":"Sheet2","index":9,"n_rows":11,"n_cols":7,"rows_kept":11,"hidden":true,"flags":["formulas_cached_only"]}
[null,"2.1.1","Filling of imported soil mixture for planters"]
[null,"a.","Supply, deliver, load, cart, spread and shape imported soil mixture to specification for planters as per layout"]
[null,"b.","Thickness as indicated on plan"]
[null,"c.","Inclusive of hand compaction in 150mm layers to avoid subsidence"]
[null,"d.","Material to be thoroughly mixed before filling in the following ration:"]
[null,null,"* 6 parts selected sandy loam topsoil to specification"]
[null,null,"* 2 parts clean, coarse double washed river sand"]
[null,null,"* 1 part compost"]
[null,null,"* fertilizers as specified"]
[null,"f.","Rate to be all inclusive"]
[null,"n.","Total topsoil import for planters","m³",{"$error":"#REF!"},{"v":450,"d":"450.00"},{"$error":"#REF!"}]