{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["S1","S2","S2 (2)","S3","S4","S5","S5 (2)","S6","SUMMARY "],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"S1","index":0,"n_rows":197,"n_cols":7,"rows_kept":197}
[{"$nulls":6},"CONTRACT NUMBER:  JW14513"]
[{"$nulls":6},"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"]
[{"$nulls":6},"SECTION 1: GENERAL"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["NO","REF"]
[1,"SABS 1200A & 1200AB","SCHEDULE 1:  PRELIMINARY AND GENERAL"]
["1.1","8.3","FIXED-CHARGE ITEMS"]
[]
["1.1.1","8.3.1","Contractual requirements","Sum",1]
[]
["1.1.2","8.3.2","Provision of facilities on site:"]
[]
[null,"8.3.2.1","1) Facilities for Engineer:"]
[null,null,"a)Engineers Office Type 2 and parking (No.=2)","Sum",1]
[null,null,"b)Nameboards (No=2)","Sum",1]
[null,null,"c) Meeting room Type 1","Sum",1]
[null,null,"d) Latrine facilities","Sum",1]
[]
["1.1.3","8.3.2.2","2) Facilities for the Contractor"]
[null,null,"a) Offices and storage sheds","Sum",1]
[null,null,"b) Ablution and latrine facilities","Sum",1]
[null,null,"c) Access (see sub-clause 5.8)","Sum",1]
[null,null,"d) Water supplies, electric power and communications","Sum",1]
[null,null,"e) Dealing with water ","Sum",1]
[]
["1.1.4","PSA 8.3.5.2","OHS Act Obligations (Compilation of OHSAct file)","Sum",1]
["1.1.5","PSA 8.3.5.3","EMP Obligations","Sum",1]
["1.1.6","PSA 8.3.5.1 ","Issuing of notices to consumers ","Sum",1]
["1.1.7","8.3.4","Removal of site Establishment","Sum",1]
[]
["1.2",8.4,"TIME RELATED ITEMS"]
["1.2.1","8.4.1","Contractual requirements","month",17]
[]
["1.2.2","8.4.2","Operation and maintainance of facilities on site."]
[]
["1.2.2.1","8.4.2.1","1) Facilities for Engineer:"]
[null,null,"a)Engineers Office Type 2 and parking (No.=2)","month",17]
[null,null,"b)Nameboards (No=2)","month",17]
[null,null,"c) Meeting room Type 1","month",17]
[null,null,"d) Latrine facilities","month",17]
[]
["1.2.2.2","8.4.2.2","2)Facilities for the Contractor:"]
[null,null,"a) Offices and storage sheds","month",17]
[null,null,"b) Ablution and latrine facilities","month",17]
[null,null,"c) Access (see sub-clause 5.8)","month",17]
[null,null,"d) Plant","month",17]
[null,null,"e) Water supplies, electric power and communications","month",17]
[null,null,"f) Dealing with water ","month",17]
["1.2.3","8.4.3","Supervision for the duration of construction","month",17]
["1.2.4","8.4.4","Company and head office overhead costs for the duration of the Contract","month",17]
["1.2.5","PSA 8.4.6.2","Security Services","month",17]
[]
["1.3","OHS Spec.","Allow for compliance with all aspects of the OHS specification including:"]
["1.3.1","PSA 8.4.6.4","Risk assesment","month",17]
["1.3.2","PSA 8.4.6.1(1)","Complaince with Health and Safety Plan including Safety Officer Salary","month",17]
{"$rows_empty":7}
[" TOTAL CARRIED FORWARD"]
[]
[{"$nulls":6},{"$f":"G1","v":"CONTRACT NUMBER:  JW14513"}]
[{"$nulls":6},{"$f":"G2","v":"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"}]
[{"$nulls":6},{"$f":"G3","v":"SECTION 1: GENERAL"}]
[{"$f":"A4","v":"ITEM"},{"$f":"B4","v":"PAYMENT"},"DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[{"$f":"A5","v":"NO"},{"$f":"B5","v":"REF"}]
["BROUGHT FORWARD"]
["1.4","EMP ","Allow for compliance with all aspects of the EMP/Authorizations  including"]
["1.4.1","PSA 8.4.6.1(2)","a)Environmental Officer Salary","month",17]
["1.4.2","PSA 8.4.6.1(3)","b) Environmental Control Officer","P/S",1,{"v":170000,"d":"170,000.00"},{"v":170000,"d":"R170,000.00"}]
["1.4.3",null,"c) Overheads, charges and profit on item 1.4.2(b) above","%",170000]
[null,null,"d) Search and Rescue specialist (protected plants)","P/S",1,{"v":200000,"d":"200,000.00"},{"v":200000,"d":"R200,000.00"}]
[null,null,"e) Profit on item (d) above","%",200000]
[]
["1.5","8.6","Prime cost items"]
["1.5.1",null,"a) Materials used in the execution of dayworks","P/S",1,{"v":30000,"d":"30,000.00"},{"v":30000,"d":"R30,000.00"}]
["1.5.2",null,"b) Overheads, charges and profit on item 1.4.1(a) above","%",30000]
[]
["1.6","8.8","TEMPORARY WORKS"]
["1.6.1","8.8.2","Dealing with traffic for the duration of the Contract","Sum",1]
["1.6.2","8.8.6","Dealing with water","Sum",1]
["1.6.3","8.8.4","Existing services"]
["1.6.4","PSA 8.8.4 (a)","a) Supply or hire of specialist equipment for the detection and Scanning of existing services.","P/S",1,{"v":50000,"d":"50,000.00"},{"v":50000,"d":"R50,000.00"}]
["1.6.5",null,"Profit on item 1.6.4 (a) above","%",50000]
["1.6.6"," PSA 8.8.4 (b)","b) Excavation by hand to expose existing services.","m3",200]
["1.7","PSA 8.5","PROVISIONAL SUMS STATED BY ENGINEER"]
[null,null,"a) Reinstatement of asphalt by JRA","P/S",1,{"v":500000,"d":"500,000.00"},{"v":500000,"d":"R500,000.00"}]
[null,null,"b) Engineer's Equipment and Independent testing","P/S",1,{"v":250000,"d":"250,000.00"},{"v":250000,"d":"R250,000.00"}]
[null,null,"c) Temporary protection of existing services","P/S",1,{"v":150000,"d":"150,000.00"},{"v":150000,"d":"R150,000.00"}]
[null,null,"d) Community Liaison Officer","P/S",1,{"v":237500,"d":"237,500.00"},{"v":237500,"d":"R237,500.00"}]
[null,null,"e) Landscaping and including irrigation system","P/S",1,{"v":150000,"d":"150,000.00"},{"v":150000,"d":"R150,000.00"}]
[null,null,"f) Relocation of existing services","P/S",1,{"v":10000,"d":"10,000.00"},{"v":10000,"d":"R10,000.00"}]
[null,null,"g) Training of local labour","P/S",1,{"v":200000,"d":"200,000.00"},{"v":200000,"d":"R200,000.00"}]
[null,null,"h) Alterations and connection to Municipal services and repair to damaged services where approved by Engineer","P/S",1,{"v":100000,"d":"100,000.00"},{"v":100000,"d":"R100,000.00"}]
[null,null,"i) Investigations as ordered by the Engineer","P/S",1,{"v":120000,"d":"120,000.00"},{"v":120000,"d":"R120,000.00"}]
[null,null,"j) Survey as per the Engineer's instruction. Rate to include for a CD with AutoCAD drawing/s and co-ordinates data in CSV or text format.","P/S",1,{"v":250000,"d":"250,000.00"},{"v":250000,"d":"R250,000.00"}]
[null,null,"k) Reinstatement of existing outer buildings to its original state or to Engineer's satisifactory as per the Engineer's instruction. Rate to include for a CD with AutoCAD drawing/s and co-ordinates data in CSV or text format.","P/S",1,{"v":100000,"d":"100,000.00"},{"v":100000,"d":"R100,000.00"}]
[null,null,"l) Overheads, charges and profit on items (a-k) above ","%",2067500]
["1.8","P.S 3.2.8","m) Overheads, charges and profit on Management fees for SMMEs based on SMME value paid to them (Value of Provisional Sum provided is indicative and will depend on a work package allocation) ","%",38142663.8085]
[null,null,"i) Evaluation of trees by Johannesburg City Parks and Zoo","P/S",1,{"v":5500000,"d":"5,500,000.00"},{"v":5500000,"d":"R5,500,000.00"}]
[null,null,"ii) Overhead, charges and profit on i) above","%",5500000]
{"$rows_empty":11}
[" TOTAL CARRIED FORWARD"]
[]
[{"$nulls":6},{"$f":"G1","v":"CONTRACT NUMBER:  JW14513"}]
[{"$nulls":6},{"$f":"G2","v":"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"}]
[{"$nulls":6},{"$f":"G3","v":"SECTION 1: GENERAL"}]
[{"$f":"A4","v":"ITEM"},{"$f":"B4","v":"PAYMENT"},"DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[{"$f":"A5","v":"NO"},{"$f":"B5","v":"REF"}]
["BROUGHT FORWARD"]
["1.9","8.7","Day works (to be executed on instruction from the Engineer)"]
[null,null,"Labour"]
[null,null,"a) Unskilled","hr",{"v":20,"d":"20.00"}]
[null,null,"b) Semi skilled","hr",{"v":20,"d":"20.00"}]
[null,null,"c) Skilled","hr",{"v":20,"d":"20.00"}]
[null,null,"d) Armed Security guard","hr",{"v":20,"d":"20.00"}]
[null,null,"Tipper truck"]
[null,null,"a) Capacity 6m³ (small)","hr",{"v":20,"d":"20.00"}]
[null,null,"b) Capacity 10m³ (medium)","hr",{"v":20,"d":"20.00"}]
[null,null,"c) Capacity 12m³ (large)","hr",{"v":20,"d":"20.00"}]
[null,null,"Flat bed tracks"]
[null,null,"a) Capacity 3 ton (small)","hr",{"v":20,"d":"20.00"}]
[null,null,"b) Capacity 5 ton (medium)","hr",{"v":20,"d":"20.00"}]
[null,null,"c) Capacity 10 ton (large)","hr",{"v":20,"d":"20.00"}]
[null,null,"LDV's"]
[null,null,"a) Capacity 1 ton","hr",{"v":20,"d":"20.00"}]
[null,null,"Conservancy/ Water  tankers"]
[null,null,"a) Capacity 6,000 litres (small)","hr",{"v":20,"d":"20.00"}]
[null,null,"b) Capacity 9,000 litres (medium)","hr",{"v":20,"d":"20.00"}]
[null,null,"c) Capacity 15,000 litres (large)","hr",{"v":20,"d":"20.00"}]
[null,null,"Excavator (Crawler excavator)"]
[null,null,"a) 20 tonne","hr",{"v":20,"d":"20.00"}]
[null,null,"b) 30 tonne","hr",{"v":20,"d":"20.00"}]
[null,null,"TLB's (Tractor loader backhoe)"]
[null,null,"a) 2x4","hr",{"v":20,"d":"20.00"}]
[null,null,"b) 4x4","hr",{"v":20,"d":"20.00"}]
[null,null,"Walk behind vibrating rollers"]
[null,null,"a) Model BW 61 (small)","hr",{"v":20,"d":"20.00"}]
[null,null,"b) Model BW 76 (medium)","hr",{"v":20,"d":"20.00"}]
[null,null,"c) Model BW 90 (large)","hr",{"v":20,"d":"20.00"}]
[null,null,"Compactors"]
[null,null,"b) Plate compactor","hr",{"v":20,"d":"20.00"}]
[null,null,"Compressors (Potable Diesiel Compressor)"]
[null,null,"a) Small","hr",{"v":20,"d":"20.00"}]
[null,null,"b) Medium","hr",{"v":20,"d":"20.00"}]
[null,null,"c) Large","hr",{"v":20,"d":"20.00"}]
[null,null,"Portable water pumps"]
[null,null,"a) Small","hr",{"v":20,"d":"20.00"}]
[null,null,"b) Medium","hr",{"v":20,"d":"20.00"}]
[null,null,"c) Large","hr",{"v":20,"d":"20.00"}]
{"$rows_empty":33}
[" TOTAL CARRIED TO SUMMARY"]

{"sheet":"S2","index":1,"n_rows":62,"n_cols":7,"rows_kept":62}
[{"$nulls":6},"CONTRACT NUMBER:  JW14513"]
[{"$nulls":6},"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"]
[{"$nulls":6},"SCHEDULE 2: SITE CLEARANCE"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["NO","REF"]
[2,"SANS 1200C","SCHEDULE 2: SITE CLEARANCE"]
[]
["2.1","8.2.1 ","Clear and grub for width of 3 metres along the pipe route","m",3300]
[]
["2.2","8.2.2 ","1) Remove and grub large trees and tree stumps of girth "]
[null,null,"a) over 1m and up to and including 2m","No. ",100]
[null,null,"b) over 2m and up to and including 3m","No. ",50]
[null,null,"c) over 3m and up to and including 4m","No. ",20]
[]
[null,null,"2) Replanting of trees"]
[null,null,"a) Replant trees taken down","No",170]
[null,null,"b) transplant of the plant species outside pipeline route","No",25]
[]
["2.3","PSC 8.2.5","Take down existing masonry walls, palisade fences and other obstructions on the pipe route"]
[null,null,"a)110mm wall","m²",100]
[null,null,"b) 220mm wall","m²",100]
[null,null,"c) 330mm wall ","m²",100]
[null,null,"d) Steel pallisade fences ","m²",100]
[null,null,"e) Concrete pallisade fences ","m²",100]
[]
["2.4","8.2.10","Remove topsoil to nominal depth of 150mm and stockpile","m³",1485]
[]
["2.5","PSC 8.2.11b","Removal of man-made surfaces"]
[]
[null,null,"a) Roadway, Asphalt and other layers"]
[null,null,"i) Asphalt (≤ 50mm thick) and including base, sub-base and subgrades layers up to 800mm deep","m²",450]
[null,null,"ii) Asphalt (> 50mm ≤ 100mm thick)  and including base, sub-base and subgrades layers up to 800mm deep","m²",450]
[]
[null,null,"b) Footways and Driveways"]
[null,null,"i) Asphalt ≤ 50mm thickness","m²",75]
[null,null,"ii) Asphalt > 50 ≤ 100mm thickness","m²",75]
[null,null,"iii) Interlocking concrete segmental paving blocks (all colours)","m²",850]
[null,null,"iv) Concrete slabs (450 x 450mm)","m²",250]
[null,null,"v)Brick paving","m²",300]
[null,null,"vi)Unreinforced concrete ≤ 75mm thick","m²",250]
[null,null,"vii)Reinforced concrete ≤ 75mm thick","m²",250]
[null,null,"viii)Grassing","m²",3300]
[null,null,"ix)Kerbing (all types of kerbing)","m",550]
[]
["2.5.1","PSC 8.2.12.1","Backfilling and reinstatement of roads"]
[null,null,"(a) 150mm base","m³",550]
[null,null,"(b) 150mm subbase","m³",550]
[null,null,"(c)150mm selected subgrade","m³",550]
[]
["2.5.2","PSC 8.2.12.2","Backfilling and reinstatement of footways"]
[]
[null,null,"a)Using removed materials:"]
[null,null,"i)Interlocking concrete segmental paving blocks (all colours)","m²",150]
[null,null,"ii)Brick paving","m²",30]
[null,null,"iii) Grassing","m²",350]
[null,null,"iv)Kerbing (all types of kerbing)","m",250]
[null,null,"b) Using new material "]
[null,null,"i) ≤50mm thick Bitumen hot - mix: Fine","m²",225]
[null,null,"ii) >50mm≤100mm thick Bitumen hot - mix: Fine","m²",225]
[null,null,"iii) interlocking concrete segmental paving blocks, including a 20mm river sand bedding layer, jointing sand (plaster sand) and mortar infill between edge restraint and blocks","m²",600]
[null,null,"iv) Concrete slabs (450 x 450mm) including a 20mm river sand bedding layer, jointing mortar","m²",250]
[" TOTAL CARRIED FORWARD"]

{"sheet":"S2 (2)","index":2,"n_rows":55,"n_cols":7,"rows_kept":55}
[{"$nulls":6},"CONTRACT NUMBER:  JW14513"]
[{"$nulls":6},"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"]
[{"$nulls":6},"SCHEDULE 2: SITE CLEARANCE"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["NO","REF"]
["BROUGHT FORWARD"]
[null,null,"v) Brick paving including a 20mm river sand bedding layer, jointing sand (plaster sand) and mortar infill between edge restraint and bricks","m²",270]
[null,null,"vi) Unreinforced concrete ≤ 75mm thick (15MPa)","m²",250]
[null,null,"vii) Reinforced concrete ≤ 75mm thick (15MPa)","m²",250]
[null,null,"viii)Grassing","m²",3300]
[null,null,"ix) Kerbing, including a 50mm bedding (cement and river sand), jointing mortar and 15MPa concrete haunching at all joints","m",550]
[]
[null,null,"b) Using new materials:"]
[]
[null,null,"i)Interlocking concrete segmental paving blocks (all colours)","m²",50]
[null,null,"ii)Brick paving","m²",20]
[null,null,"iii) Grassing","m²",50]
[null,null,"iv)Kerbing (all types of kerbing)","m",50]
[null,null,"b) Using new material "]
[null,null,"i) ≤50mm thick Bitumen hot - mix: Fine","m²",40]
[null,null,"ii) >50mm≤100mm thick Bitumen hot - mix: Fine","m²",40]
[null,null,"iii) interlocking concrete segmental paving blocks, including a 20mm river sand bedding layer, jointing sand (plaster sand) and mortar infill between edge restraint and blocks","m²",200]
[null,null,"iv) Concrete slabs (450 x 450mm) including a 20mm river sand bedding layer, jointing mortar","m²",50]
[null,null,"v) Brick paving including a 20mm river sand bedding layer, jointing sand (plaster sand) and mortar infill between edge restraint and bricks","m²",50]
[null,null,"vi) Unreinforced concrete ≤ 75mm thick (15MPa)","m²",50]
[null,null,"vii) Reinforced concrete ≤ 75mm thick (15MPa)","m²",50]
[null,null,"viii)Grassing","m²",1500]
[null,null,"ix) Kerbing, including a 50mm bedding (cement and river sand), jointing mortar and 15MPa concrete haunching at all joints","m",150]
[]
[null,null,"c) Environmental Rehabilitation as per EA and WULA requirements"]
[null,null,"i) Re-vegetation ","No",20]
[null,null,"ii) Hydroseeding ","m²",100]
[null,null,"iii) Grassing","m²",100]
[null,null,"iv) Importation of topsoil, incase the one removed is not sufficient","m³",150]
[null,null,"v) WULA Requirements","P/S",1,{"v":1000000,"d":"1,000,000.00"},{"$f":"E35*F35","v":{"v":1000000,"d":"R1,000,000.00"}}]
[null,null,"vi) Overheard, charges for item (v) above","%",1000000]
["2.5.3","PSC 8.2.13","Reinstatement of existing masonry walls and palisade fences "]
[]
[null,null,"a) Face Brick"]
[null,null,"i)110mm wall","m²",100]
[null,null,"ii) 220mm wall","m²",100]
[null,null,"ii)330mm wall","m²",100]
[]
[null,null,"b) Plastered Brick"]
[null,null,"i)110mm wall","m²",100]
[null,null,"ii) 220mm wall","m²",100]
[null,null,"ii) 330mm wall","m²",100]
[]
[null,null,"c) Steel Palisade fences (2.1m height)","m²",150]
[null,null,"d) Concrete Palisade fences (2.1m height)","m²",100]
[null,null,"e) Any other types of walls other than the ones listed above","m²",100]
[]
[]
[]
[" TOTAL CARRIED SUMMARY"]

{"sheet":"S3","index":3,"n_rows":70,"n_cols":7,"rows_kept":70}
[{"$nulls":6},"CONTRACT NUMBER:  JW14513"]
[{"$nulls":6},"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"]
[{"$nulls":6},"SCHEDULE 3: EARTHWORKS (PIPE TRENCHES)"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["NO","REF"]
["3.0","SANS 1200DB","SCHEDULE 3: EARTHWORKS (PIPE TRENCHES)"]
[]
["3.1","8.3.2","Excavation"]
[]
[null,null,"(a) Excavate in all materials, backfill and compact and dispose of surplus and unsuitable materials within the free haul distance, for trenches "]
[null,null,"i) > 0m but ≤ 1.0m deep","m³",150]
[null,null,"ii) > 1.0m but ≤ 2.0m deep","m³",12500]
[null,null,"iii) > 2.0m but ≤ 3.0m deep","m³",8500]
[null,null,"iv) > 3.0m but ≤ 4.0m deep","m³",10800]
[null,null,"(b) Extra over item (a) above for: "]
[null,null,"i) Intermediate material","m³",3600]
[null,null,"ii) Hard rock material","m³",1800]
[null,null,"iii) Boulder excavation","m³",750]
[null,"8.3.4","(c) Extra over item (a) above (shoring and or bracing of trench sides) for: "," "]
[null,null,"i) > 0m but ≤ 1.0m deep (using timber sheeting)","m",0]
[null,null,"ii) > 1.0m but ≤ 2.0m deep (using timber sheeting)","m",2000]
[null,null,"iii) > 2.0m but ≤ 3.0m deep (using timber sheeting)","m",1000]
[null,null,"iv) > 3.0m but ≤ 4.0m deep (using steel sheeting)","m",500]
[]
["3.2","8.3.3","Excavation ancillaries"]
[null,"8.3.3.1","Make up deficiency in backfill material: "]
[null,null,"a) By importation from commercial source or off-site sources selected by the Contractor ","m³",2700]
[]
["3.3",null,"Additional compaction"]
[null,"8.3.3.3","Compaction in road reserve"]
[null,null,"a) Additional compaction to 93% mod AASHTO density in road reserves","m³",520]
["3.4","PSDB 8.3.5","Existing services that intersect or adjoin a pipe trench:"]
[null,null,"a) Service that intersect a trench"]
[null,null,"(i) Cables.","No.",85]
[null,null,"(ii) Water mains ","No.",25]
[null,null,"(iii) Water house connections","No.",125]
[null,null,"(iv) Sewer pipes ","No.",55]
[null,null,"(v) Storm water pipes ","No.",45]
[null,null,"(vi) Kerbs and channels","No.",56]
[null,null,"b) Services that adjoin a trench"]
[null,null,"(i) Cables.","m",3300]
[null,null,"(ii) Water mains ","m",3300]
[null,null,"(iii) Storm water pipes","m",2500]
[null,null,"(iv) Kerbs and channels","m",780]
[null,null,"(v) Sewer pipes ","m",3300]
[null,null,"(c) Services that require special care","No",20]
{"$rows_empty":23}
[" TOTAL CARRIED TO SUMMARY"]

{"sheet":"S4","index":4,"n_rows":50,"n_cols":7,"rows_kept":50}
[{"$nulls":6},"CONTRACT NUMBER:  JW14513"]
[{"$nulls":6},"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"]
[{"$nulls":6},"SCHEDULE 4: BEDDING (PIPES)"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["NO","REF"]
["4.0","SANS  1200LB","SCHEDULE 4: BEDDING (PIPES)"]
[]
["4.1",null,"Provision of bedding:"]
[]
["4.1.1","8.2.1","(a) from trench excavations "]
[null,null,"i) selected granular material","m³",9000]
[null,null,"ii) selected fill material","m³",1800]
[]
["4.1.2","8.2.2.3","(b) from commercial sources"]
[null,null,"i) selected granular material","m³",1500]
[null,null,"ii) selected fill material","m³",150]
[null,null,"(iii)      Bidim A2","m²",1800]
[null,null,"(iv)     19mm crusher run stone","m³",450]
[null,null,"(v)     River sand","m³",750]
[null,null,"(vi)     Dump Rock","m³",350]
{"$rows_empty":29}
[" TOTAL CARRIED TO SUMMARY"]

{"sheet":"S5","index":5,"n_rows":50,"n_cols":7,"rows_kept":50}
[{"$nulls":6},"CONTRACT NUMBER:  JW14513"]
[{"$nulls":6},"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"]
[{"$nulls":6},"SCHEDULE 5: SEWERS RISING MAIN"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["NO","REF"]
["5.0","SANS 1200LD","SCHEDULE 5: SEWERS RISING MAIN"]
[]
["5.1","8.2.1","b) Supply, lay, bed (class B bedding), all test and disinfect, backfill complete joints to be butt welded or electro fusion, HDPE PE100 SDR11 PN16 pipes:"]
[]
[null,null,"i) DN900","m",{"v":3300,"d":"3300.00"}]
[null,"8.2.2","Extra-over for 5.1 for the supply, lay and bedding of Specials with couplings:"]
["5.2",null,"Fittings to suit HDPE PN 16 SDR 11 PE 100 pipes"]
["5.2.1",null,"a) Segmented bends for HDPE pipe PN16 SDR11 PE100"]
[null,null,"i) 90⁰ bend for 900 diameter pipe","No",{"v":12,"d":"12.00"}]
[null,null,"ii) 45⁰ bend for 900 diameter pipe","No",{"v":21,"d":"21.00"}]
[null,null,"iii) 22.5⁰ bend for 900 diameter pipe","No",18]
[null,null,"iv) 11¼⁰ bend for 900 diameter pipe","No",{"v":18,"d":"18.00"}]
[]
["5.2.2",null,"b) Stub and Flange for HDPE PN16 PE100 SDR11"]
[null,null,"i) Stub and Flange for 900 diameter pipe","No",{"v":50,"d":"50.00"}]
[]
["5.2.3",null,"c) Unequal Tees"]
[null,null,"i) 900 x 110","No",{"v":6,"d":"6.00"}]
[null,null,"ii) 900 x 160","No",{"v":32,"d":"32.00"}]
[null,null,"iii) 900 x 200","No",{"v":4,"d":"4.00"}]
["5.3","PSL 8.2.19(b)","Supply, handle, fixing, lay, bed of scour valves including chambers, complete with all fittings for connection to main line as per detail. JW14513-CRA-VCD-S02. (Rate to include all fittings required including isolation valve, couplings,  welding of joints, chamber and cover , etc.)"]
[null,null,"i) DN900","No",{"v":9,"d":"9.00"}]
[]
["5.4","8.2.11","Thrust blocks"]
[null,null,"Supply, handle, mixing and testing of concrete thrust blocks. Rate shall cover the cost of excavation and trimming, formwork, reinforcement and screeding of top surfaces:"]
[]
[null,null,"At 11.25° bend","No.",{"v":18,"d":"18.00"}]
[null,null,"At 22.5° bend","No.",{"v":18,"d":"18.00"}]
[null,null,"At 45° bend","No.",{"v":21,"d":"21.00"}]
[null,null,"At 90° bend","No.",{"v":12,"d":"12.00"}]
[]
["5.5","PSL 8.2.19(b)","Supply, handle, fixing, lay, bed of single chamber flanged double acting air release valves (Combination valves), complete with all fittings for connection to main line as per detail JW14513-CRA-VCD-S02. (Rate to include all fittings required including isolation valve, couplings,  wrapping of joints, chamber and cover , etc.) Air valves to be PN16 and Double Fusion  Epoxy Bonded  coated."]
[null,null,"iii)DN150","No",{"v":9,"d":"9.00"}]
[]
[]
["5.6",null,"Supply, handle, fixing, lay, bed of Swing Check Valve (Non-Return Valve) Wafer Type, Single Disc, complete with all fittings for connection to main line as per detail JW14513-CRA-VCD-S03. (Rate to include all fittings required including isolation valve, couplings,  wrapping of joints, chamber and cover , etc.","No.",{"v":1,"d":"1.00"}]
{"$rows_empty":8}
[" TOTAL CARRIED FORWARD"]

{"sheet":"S5 (2)","index":6,"n_rows":67,"n_cols":7,"rows_kept":67}
[{"$nulls":6},"CONTRACT NUMBER:  JW14513"]
[{"$nulls":6},"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"]
[{"$nulls":6},"SCHEDULE 5: SEWERS RISING MAIN"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["NO","REF"]
["BROUGHT FORWARD"]
["5.7",null,"Supply, handle, lay and test through Horizotal Direction Drilling (through soft, medium and hard material) for depth not exceeding 10metres including supply of equipment for road and river crossings (Launch and reception pits will be paid under earthworks):"]
["5.7.1",null,"(a) HDPE PE100 PN 16"]
[null,null,"i) DN900","m",{"v":204,"d":"204.00"}]
[]
["5.8.1",null,"Demolish existing manholes where new manholes will be constructed for pipe diameters 160mm to 600mm"]
[null,null,"a) > 3m but ≤ 4.0m deep","No.",{"v":1,"d":"1.00"}]
[]
["5.8.2",null,"Repair manhole benching in existing manholes up to 5m depth"]
[null,null,"a) 1250mm - 1500mm diameter","No.",{"v":1,"d":"1.00"}]
[]
[]
["5.9","8.2.11","Connect to existing Sewers"]
[null,null,"Break existing manhole, channel and benching and rebuilt manhole with new channel and benching the rate shall include any temporary sewer diversion or over pumping required","No",{"v":1,"d":"1.00"}]
["5.10","8.2.12","Raising or Lowering of Existing Manholes"]
[null,null,"i) 1500mm diameter","No.",{"v":1,"d":"1.00"}]
{"$rows_empty":45}
[" TOTAL CARRIED TO SUMMARY"]

{"sheet":"S6","index":7,"n_rows":63,"n_cols":7,"rows_kept":63}
[{"$nulls":6},"CONTRACT NUMBER:  JW14513"]
[{"$nulls":6},"UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2"]
[{"$nulls":6},"SCHEDULE 6: CCTV CAMERA SURVEY AND PIPE CRACKING"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["NO","REF"]
["6.0",null,"SCHEDULE 6: CCTV CAMERA SURVEY  AND PIPE CRACKING"]
["6.1",null,"CCTV surveys"]
[]
["6.1.2","PS 4.2.16","Cleaning of conduits by pressure jetting method for the following pipe diameter diameter after installation if required:"]
[null,null,"a) > 355mm diameter","m",3300]
[]
["6.1.3","PS 4.2.17","CCTV camera surveys of pipelines before upgrade works, of the following diameters. The CCTV should identify any house connections, manholes and any other detail and defects in the sewer line:"]
[null,null,"a) > 355mm diameter","m",750]
[]
["6.1.4","PS 4.2.17","CCTV camera surveys of pipelines after upgrade works, of the following diameters. The CCTV should identify any house connections, manholes and any other detail and defects in the sewer line:"]
[null,null,"a) > 355mm diameter","m",3300]
["6.2.2",null,"Overpumping and manhole isolation"]
[null,null,"Manhole length isolation"]
["6.2.2.1","P.S.4.2.49.3","a) Plugging Conduits:"]
[null,null,"i) ≥ 400mm diameter ","No.",110]
["6.2.2.2","P.S.4.2.49.4","b) Over-pumping"]
[null,null,"i) 315 > and ≤ 500mm diameter maximum flow rate 430 litres per sec","hours",350]
{"$rows_empty":40}
[" TOTAL CARRIED TO SUMMARY"]

{"sheet":"SUMMARY ","index":8,"n_rows":30,"n_cols":3,"rows_kept":30,"merged":[[0,0,1,2],[2,0,2,2]]}
["Contract: JW14513\n                       UPGRADING OF INCHANGA SEWER RISING MAIN PACKAGE 2 \nVolume 1: Tender and Contract\nSUMMARY "]
[]
["SUMMARY OF BILL OF QUANTITIES"]
["SECTION","DESCRIPTION","AMOUNT"]
[]
["SECTION 1","SCHEDULE 1:  PRELIMINARY AND GENERAL","R"]
[]
["SECTION 2","SCHEDULE 2: SITE CLEARANCE","R"]
[]
["SECTION 3","SCHEDULE 3: EARTHWORKS (PIPE TRENCHES)","R"]
[]
["SECTION 4","SCHEDULE 4: BEDDING (PIPES)","R"]
[]
["SECTION 5","SCHEDULE 5: SEWERS","R"]
[]
["SECTION 6","SCHEDULE 6: CCTV CAMERA SURVEY  AND PIPE CRACKING","R"]
[]
[null,"SUBTOTAL","R"]
[]
[null,"Add Escalation (@ 7% of Contract Value) ","R"]
[]
[null,"SUBTOTAL","R"]
[]
[null,"Add Contingencies (@ 10% of Contract Value) ","R"]
[]
[null,"SUBTOTAL","R"]
[]
[null,"Add 15% VAT","R"]
[]
["TOTAL TO TENDER SUMMARY","GRAND TOTAL","R"]