{"text_format":"3","workbook":"xls","n_sheets":12,"sheets":["Summary","Section 1","Section 2","Section 3A-SHE","Section 4 - QUALITY","Section 5-EMS","Section 6","Section 7","Section 8","Section 9","Section 10 ","Section 11"],"not_rendered":{"images":1,"external_links":2,"defined_names":16,"comments":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Summary","index":0,"n_rows":35,"n_cols":4,"rows_kept":35,"merged":[[0,0,0,2],[5,0,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[8,4,16,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,0,29,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[38,1,38,2],[39,1,39,2]],"flags":["formulas_cached_only"]}
["RAND WATER"]
["Project Name         :",":","Installation of a 400mm Meter Connection in Mnandi"]
["Document Name    :",":","Cost Estimate"]
["Date                      :",":"]
[]
["SUMMARY"]
["SECTION","DESCRIPTION",null," AMOUNT"]
[]
[1,"PRELIMINARY AND GENERAL : FIXED CHARGES",null,0]
[]
[2,"PRELIMINARY AND GENERAL : TIME RELATED",null,0]
[]
[3,"OCCUPATIONAL HEALTH AND SAFETY",null,0]
[]
[4,"QUALITY ",null,0]
[]
[5,"ENVIRONMENT",null,0]
[]
[6,"DAYWORKS",null,0]
[]
[7,"SITE CLEARANCE",null,0]
[]
[8,"EARTHWORKS AND BEDDING",null,0]
[]
[9,"N/A"]
[]
[10,"CONNECTION CHAMBERS - CONCRETE AND STEELWORK",null,0]
[]
[]
["SUB-TOTAL A (Excl. VAT)",null,null,0]
[11,"SED",null,0]
["SUB-TOTAL B (Excl. VAT)",null,null,0]
["VAT 15%",null,null,0]
["TOTAL  (Incl. VAT)",null,null,0]
["NB: Estimate valid for  6 months."]

{"sheet":"Section 1","index":1,"n_rows":54,"n_cols":7,"rows_kept":54,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[5,1,6,1],[53,0,53,5]],"flags":["formulas_cached_only"]}
["Installation of a 400 mm meter connection in Mnandi",{"$nulls":4},"Section 1 : P&G Fixed"]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[]
[null,"SABS 1200AA","SECTION 1:  PRELIMINARY & GENERAL"]
[null,null,"FIXED CHARGES"]
[]
["1.1","8.3.1","Contractual Requirements"]
[]
["1.1.1",null,"Contractual Requirements","Sum",1,null,0]
[]
["1.2","8.3.2.","Provision of Facilities on Site"]
[]
["1.2.1","a)","Facilities required by Engineer","Sum",1,null,0]
[null,"b)","Facilities required by Contractor","Sum",1,null,0]
[]
["1.3","8.3.3","General Responsibilities and Other Fixed-term Obligations","Sum",1,null,0]
[]
["1.4","8.3.4","Removal of Site Establishment","Sum ",1,null,0]
[]
["1.5","PSA 8.10","HIV / AIDS awareness"]
[]
["1.5.1",null,"Conduct HIV/AIDS awareness programme workshops on site for not less than 90% of the workers inclusive of all direct and indirect costs","Sum",1,null,0]
[]
["1.5.1.1",null,"Provide and maintain condom dispenser","Sum",1,null,0]
[]
["1.5.1.2",null,"Provide and maintain HIV/AIDS awareness posters","Sum",1,null,0]
[]
["1.5.1.3",null,"Provide information regarding voluntary testing of construction workers and counselling, support and care in a monthly report.","Sum",1,null,0]
[]
["1.6",null,"Quality Control"]
[]
["1.6.1","PS A 8.10","Quality control and all activities necessary to comply with all requirements of the specified quality control system as per PS 5.","Sum",1,null,0]
[]
[1.7,null,"High Voltage Safe Working Procedures"]
[]
["1.7.1","PSA 8.10","Comply with Safe Working Procedures for pipeline construction within High Voltage Transmission Lines Servitude (See TS041 in Specification Rand Water Cathodic Protection System Technical Specification)","Sum",1,null,0]
[]
["1.8 ",null,"Removal of Water on Site "]
["1.8.1","P.8.8.7","Provisions must be made to deal with any water that may be found on site during excavations or that may be found in existing chambers","Sum  ",1,null,0]
{"$rows_empty":12}
["Section 1 Total - Carried Forward To Summary Page",{"$nulls":5},0]

{"sheet":"Section 2","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[41,0,41,5]],"flags":["formulas_cached_only"]}
["Installation of a 400 mm meter connection in Mnandi",{"$nulls":5},"Section 2 : P&G Time Related"]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[]
[null,"SABS 1200AA","SECTION 2:  PRELIMINARY & GENERAL \nTIME RELATED ITEMS"]
[]
[2.1,"8.4.1","Contractual Requirements"]
[]
["2.1.1",null,"Contractual Requirements","Sum",1,null,0]
[]
[2.2,"8.4.2","Operation and Maintenance of Facilities on Site"]
[]
["2.2.1","a)","Facilities for Engineer","Sum",1,null,0]
[]
["2.2.2","b)","Facilities for Contractor","Sum",1,null,0]
[]
[2.3,"8.4.3","Genral Responsibilities and other Time-related Obligations","Sum",1,null,0]
[]
[2.4,null,"HIV / AIDS awareness"]
[]
["2.4.1","PSA 8.10","Conduct HIV/AIDS awareness programme workshops on site for not less than 90% of the workers inclusive of all direct and indirect costs","Sum",1,null,0]
[]
["2.4.1.1","PSA 8.10","Provide and maintain condom dispenser","Sum",1,null,0]
[]
["2.4.1.2","PSA 8.10","Provide and maintain HIV/AIDS awareness posters","Sum",1,null,0]
[]
["2.4.1.3","PSA 8.10","Provide information regarding voluntary testing of construction workers and counselling, support and care in a monthly report.","Sum",1,null,0]
[]
[2.6,null,"Quality Control"]
[]
["2.6.1","PS A 8.10","Quality control and all activities necessary to comply with all requirements of the specified quality control system as per PS 5.","Sum",1,null,0]
[]
[2.7,null,"High Voltage Safe Working Procedures"]
[]
["2.7.1","PSA 8.10","Comply with Safe Working Procedures for pipeline construction within High Voltage Transmission Lines Servitude (See TS041 in Specification Rand Water Cathodic Protection System Technical Specification)","Sum",1,null,0]
[]
[]
[]
[]
[]
["Section 2 Total - Carried Forward To Summary Page",{"$nulls":5},0]

{"sheet":"Section 3A-SHE","index":3,"n_rows":59,"n_cols":10,"rows_kept":59,"merged":[[4,5,4,6],[4,7,4,8],[58,0,58,6]],"flags":["formulas_cached_only"]}
[]
["Installation of a 400 mm meter connection in Mnandi",{"$nulls":7},"Section 3: Health & Safety "]
[]
[]
["Item No.",null,"Description","Qty (A)","U O M","Rate (B)",null,"Total A*B"]
[3,null,"OCCUPATIONAL HEALTH AND SAFETY"]
[]
[3.1," 2.4 & 2.5    (Part A)","Preparation of the Contractor's site specific Health and Safety Plan",1,"Sum",{"$nulls":3},0]
[]
[3.2,"3.2                    (Part A)","Principal Contractor's initial obligations in respect of the Occupational Health and Safety Act  85 of 1993 and all applicable  regulations",1,"Sum",{"$nulls":3},0]
[]
[3.3,"3.2                         (Part A)","Principal Contractor's time related obligations in respect of the Occupational Health and Safety Act 85 of 1993 and all applicable  regulations",3," Month",{"$nulls":3},0]
[]
[3.4,"10d                        (Part B)","Provision of Personal Protective Equipment (PPE)",1,"Sum",{"$nulls":3},0]
[]
[3.5,"3.2.1 (Part A)","Provision of a full-time Construction Health and Safety Officer",3," Month",{"$nulls":3},0]
[]
[3.6,"15 (Part A)","Cost of medical certificates and medical surveillance",{"$nulls":5},0]
[]
["3.6.1","15 (Part A)","(a) Initial (baseline) medical examinations",1,"Sum",{"$nulls":3},0]
[]
["3.6.2","15 (Part A)","(b) Periodic medical  examinations",1,"Sum",{"$nulls":3},0]
[]
["3.6.3","15 (Part A)","(c) Medical consultation as when required with OHP and OMP",1,"Prov. Sum",{"$nulls":3},0]
[]
["3.6.4","15 (Part A)","(d) Exit examinations",1,"Sum",{"$nulls":3},0]
[]
[3.7,"9.3 (Part A)","Induction training",1,"Sum",{"$nulls":3},0]
[]
[3.8,"16 (Part A)","Provision of First Aid Boxes to GSR requirements and other emergency safety equipment such as fire extinguishers.",1,"Sum",{"$nulls":3},0]
[]
[3.9,"24 C09 (Part A) &                      10c(i) (Part B)","Transportation of Workers",1,"Sum",{"$nulls":3},0]
[]
[{"v":3.1,"d":"3.10"},"11 (Part A)","Welfare Facilities",1,"Sum",{"$nulls":3},0]
[]
[3.11,"14 (Part A)","Occupational Hygiene Surveys",1,"Sum",{"$nulls":3},0]
[]
[3.12,"10 (Part A)","Health and safety Training",1,"Sum",{"$nulls":3},0]
[]
[3.13,"Annexure 11.1 (Part B)","Security requirements including the security risk assessment (before site establishment)",1,"Sum",{"$nulls":3},0]
[]
[3.14,"24 C14, 7              (Part A)","Employee wellness programs",1,"Sum",{"$nulls":3},0]
[]
[3.15,"7 (Part A)","Drug and Alcohol Testing, Policies and Procedures",1,"Sum",{"$nulls":3},0]
[]
[3.16,"10k (Part B)","Barricading",1,"Sum",{"$nulls":3},0]
[]
[3.17,"10a (Part B)","Safety notices and signs",1,"Sum",{"$nulls":3},0]
[]
[3.18,"8 (Part A)","SHE  Incentives",1,"Prov. Sum",{"$nulls":3},0]
[]
[3.19,"24 C19 (Part A) ","Construction work permit application fee",1,"Prov. Sum",{"$nulls":3},0]
[]
[{"v":3.2,"d":"3.20"},"24 C20 (Part A) /10g, n ,v & s (Part B)  ","Adequate ventilation and lighting during construction",1,"Sum",{"$nulls":3},0]
[]
[3.21,"2.9 (Part A)","Submission of the Health and Safety File (hard and soft copies - After tender award and  project completion)",1,"Sum",{"$nulls":3},0]
[]
[3.22,"3.1 (Part A)","Provision of Client Pr.CHSA (Construction Health & Safety  Agent) registered with SACPCMP for the duration of the project.",1,"Prov. Sum",{"$nulls":3},0]
["Total amount excluding Value-Added Tax (VAT) to be carried to  - Summary of Price Schedules",{"$nulls":7},0,0]

{"sheet":"Section 4 - QUALITY","index":4,"n_rows":40,"n_cols":7,"rows_kept":40,"merged":[[10,3,16,3],[10,4,16,4],[10,5,16,5],[10,6,16,6],[39,0,39,5]],"flags":["formulas_cached_only"]}
[{"$nulls":6},"Installation of a 400 mm meter connection in Mnandi"]
["Contract No.:",null,"RWXXXX",{"$nulls":3},"Section 4 :  Quality"]
["Description:",null,"Installation of a 400 mm meter connection in Mnandi"]
[]
[]
["Item ","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[null,null,"SECTION 4 : QUALITY MANAGEMENT"]
[]
["No.","Refers"]
[4,"PS A 8.10","Quality control and all activities necessary to comply with all requirements of the specified quality control system as per PS 5.","Sum",1,"Included in Section 2 - 2.6.1",0]
[]
["4.4",null,"Preparation of the Quality Control Plans/Inspection and Testing plans for each activity "]
[]
[null,null,"Earthworks "]
[]
["4.6",null,"Provision of experienced Quality Control Officer to conduct the inspections "]
{"$rows_empty":22}
["SCHEDULE 4 SUBTOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},0]

{"sheet":"Section 5-EMS","index":5,"n_rows":49,"n_cols":7,"rows_kept":49,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[48,0,48,5]],"flags":["formulas_cached_only"]}
["Istallation of a 400 mm meter connection in Mnandi",{"$nulls":5},"Section 5 : Environment"]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[null,"PSAA 8.12","SECTION 5 :  ENVIRONMENT"]
[]
[5.1,null,"Signage"]
["5.1.1",null,"Environmental information sign at gate \n(metal - A2 size)","Each",1,null,0]
["5.1.2",null,"Topsoil (corex board with wooden peg A3 size)","Each",4,null,0]
[]
[5.2,"TS 1.26","Storm water deflection berms / cross embankments / erosion control berms for steep slope erosion protection or for the protection of topsoil stockpiles.","  Lump sum",1,null,0]
[]
[5.3,null,"Pollution Prevention"]
["5.3.1",null,"Waste disposal provision at an approved location","  Lump sum",1,null,0]
["5.3.2",null,"Waste bins and receptacles that have water tight lids","Lump sum",1,null,0]
["5.3.3",null,"Spillage kits for all construction vehicles and be easily available on site","Lump sum",1,null,0]
["5.3.4",null,"Drip trays for all vehicles parked overnight ","Lump sum",1,null,0]
[]
[5.5,null,"Administration and documentation","  Lump sum",1,null,0]
[]
[5.6,null,"Fire protection equipment. Two flappers and one fire extinguisher per working head","  Lump sum",1,null,0]
{"$rows_empty":27}
["Section 5 Total - Carried Forward To Summary Page",{"$nulls":5},0]

{"sheet":"Section 6","index":6,"n_rows":109,"n_cols":9,"rows_kept":109,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[107,0,107,5]],"flags":["formulas_cached_only"]}
["Istallation of a 400 mm meter connection in Mnandi",{"$nulls":5},"Section 6 : Dayworks"]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[]
[null,"SANS","SECTION 6: DAYWORKS"]
[null,"1200A"]
["6.1",8.7,"Labour by class"]
[]
["6.1.1",null,"Unskilled Labourers","hrs",25,null,0]
[]
["6.1.2",null,"Semi Skilled Labourers","hrs",10,null,0]
[]
["6.1.3",null,"Skilled labour","hrs",5,null,0]
[]
["6.2",8.7,"Labour by trade"]
[]
["6.2.1",null,"Construction Hand and Operator","hrs",10,null,0]
[]
["6.2.2",null,"Carpenter","hrs",2.5,null,0]
[]
["6.2.3",null,"Clerk","hrs",2.5,null,0]
[]
["6.2.4",null,"Artisans","hrs",5,null,0]
[]
["6.2.5",null,"Foreman","hrs",5,null,0]
[]
["6.2.6",null,"Gangers and Section Leaders","hrs",5,null,0]
[]
["6.2.7",null,"Steel fixer","hrs",2.5,null,0]
[]
["6.2.8",null,"Bricklayer or Plasterer","hrs",2.5,null,0]
[]
["6.2.9",null,"Welder","hrs",2.5,null,0]
[]
["6.3",8.7,"Materials"]
[]
["6.3.1",null,"Provisional sum for cost of material","Sum",0.5,null,0]
[]
["6.3.2",null,"Contractors mark-up on material","%",{"v":0.1,"d":"10%"},null,0]
[]
["6.4",8.7,"Plant"]
[]
[null,null,"Tenderers to insert the hire rate at which each item will be charged, which is to cover all relevant costs of plant hire, including operating crew"]
[]
["6.4.1",null,"Lowbed transport of plant to and from site","t.km",100,null,0]
[]
["6.4.2",null,"Bulldozer and ripper (D6 or equivalent)","hrs",2.5,null,0]
[]
["6.4.3",null,"Grader (120G or equivalent)","hrs",2.5,null,0]
[]
["6.4.4",null,"Front end wheel loaders (Cat 950 or similar)","hrs",2.5,null,0]
[]
["6.4.5",null,"Back acting excavators (Hitachi EX200 or similar)","hrs",2.5,null,0]
[]
["6.4.6",null,"T L B","hrs",2.5,null,0]
[]
["6.4.7",null,"Tractors and drawn trailers and rollers","hrs",2.5,null,0]
[]
["6.4.8",null,"Compactors (D72Y or equivalent)","hrs",2.5,null,0]
[]
["6.4.9",null,"Compressors (250CFM or equivalent)","hrs",5,null,0]
[]
["6.4.10",null,"Trucks (7t or equivalent)","hrs",5,null,0]
[]
["6.4.11",null,"Tip Trucks (10t or equivalent)","hrs",5,null,0]
[]
["6.4.12",null,"Water Tanker","hrs",5,null,0]
[]
["6.4.13",null,"Plate Compactor","hrs",5,null,0]
[]
["6.4.14",null,"Light delivery vehicles (1t or equivalent)","km",150,null,0]
[]
["6.4.15",null,"Site Boom","No.",0.5,null,0]
[]
["6.4.16",null,"Generator","No.",0.5,null,0]
{"$rows_empty":31}
["Section 6 Total - Carried Forward To Summary Page",{"$nulls":5},0]
[{"$nulls":8},0]

{"sheet":"Section 7","index":7,"n_rows":63,"n_cols":7,"rows_kept":63,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[40,1,41,1],[42,1,43,1],[44,0,44,5],[45,2,46,2],[45,3,46,3],[45,4,46,4],[45,5,46,5],[45,6,46,6],[62,0,62,5]],"flags":["formulas_cached_only"]}
["Istallation of a 400 mm meter connection in Mnandi",{"$nulls":5},"Section 7 : Site Clearance and Rehabilitation"]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[]
[null,"SABS 1200D","SECTION 7:  SITE CLEARANCE AND REHABILITATION"]
[]
[7.1,null,"Site Clearance"]
[]
["7.1.1","8.2.1","Clear and grub vegetation and trees of girth up to 0.5 m along the route of the mainline (Within 10 m wide working strip and excluding trees to be relocated) (See PS2.6 & PSC 5.9)","m",10,null,0]
[]
["7.1.2","8.2.2 ","Clear large trees of girth and designated obstacles (See PS2.6, PSC5.9 & PSC 5.10)"]
[]
["7.1.2.1",null,"a) over 1m and up to and including 2m","no",0,null,0]
[]
["7.1.2.2",null,"b) over 2m m and up to and including 3m","no",0,null,0]
[]
["7.1.2.3",null,"c) over 3m in steps of 1m","no",0,null,0]
[]
[null,"SABS 1200C"]
[7.3,null,"Transportation of debris "]
[]
["7.3.1","8.2.9","Transport debris and materials resulting from site clearing to unspecified location ","m3.km",100,null,0]
[]
[7.3,null,"Remove and Stockpile Topsoil"]
[]
["7.3.1","8.2.10","Remove and stockpile topsoil to a depth of 150mm along the route of the pipeline (within working servitude) and maintain","Sum",1,null,0]
[]
[7.6,"TS1","Fire Breaks"]
[]
["7.6.1",1.24,"Form fire breaks on Engineer's Instruction","m²",38,null,0]
[]
[7.7,"TS1","Rehabilitation"]
[]
["7.7.1","TS 1.26","Restoring the ground surface for the full working area around chambers and over excavated trenches.","m3",6,null,0]
[]
["7.8","SABS 1200C","Final Grading"]
[]
["7.8.1","5.2.4.1","Ripping of compacted and disturbed areas to 150mm depth","m2",23,null,0]
[]
["7.9",null,"Topsoiling"]
[]
["7.9.1","PSDA  8.3.6","Place topsoil to a depth of 150mm","m2",23,null,0]
[]
["Carried Forward ",{"$nulls":5},0]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[null,"Brought Forward",{"$nulls":4},0]
[]
[]
["7.10","SANS 1200D","Vegetation Re-establishment"]
[]
["7.10.1","8.3.11","Hydroseeding with appropriate grass seed mix. (Deemed to be inclusive of soil preparation and improvements, materials and labour).","m2",23,null,0]
[]
["7.11","8.3.8.1","Existing services"]
[null,"a)","The supply of specialist equipment for detection.","Sum",1,null,0]
[null,"b)","The use or hire of specialist equipment","Hours",3,null,0]
[]
[]
[]
[]
[]
["Section 7 Total - Carried Forward To Summary Page",{"$nulls":5},0]

{"sheet":"Section 8","index":8,"n_rows":27,"n_cols":7,"rows_kept":27,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[4,1,5,1],[26,0,26,5]],"flags":["formulas_cached_only"]}
["Istallation of a 400 mm meter connection in Mnandi",{"$nulls":5},"Section 8: Earthworks and Bedding"]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[null,null,"SECTION 8 :  EARTHWORKS & BEDDING"]
[]
[null,"NOTE ","The contractor should pay special attention to the excavation payment lines illustrated on the accompanying drawings. All allowance in the tender rates must be included for workspace"]
[]
[8.1,"SABS 1200DA","Excavation for Chambers and trenches"]
[]
["8.1.1","PSDA8.3.2(a)","Excavation in all materials for chambers and other minor structures outside the limits of the trench excavation, backfill, compact and dispose of surplus / unsuitable material.","m³",330,null,0]
[]
["8.1.2","8.3.2(b)","Extra over Item 1.1 for excavation in hard rock.","m³",70,null,0]
[]
[]
["8.1.3","8.3.4.1","Importing of backfill G7 Material compacted in layers not exceeding 150mm in thickness compacted to 93% MOD AASHTO density AT -1% to +2% OMC","m³",11,null,0]
[]
["8.1.4","8.3.4.2","G5 Material compacted in layers not exceeding 100 mm in thickness compacted to 95% MOD AASHTO density AT -1% to +2% OMC","m³",15,null,0]
[]
["8.1.5","PSDA 8.3.10","Take and provide photographic records","sum",1,null,0]
[]
["8.2 ",null,"TESTING "]
[null,null,"The sampling and testing of materials to ensure the consistency of materials, and stability of backfilling of structures. Testing to ensure the requirements and specifications are met and that compaction is obtained","sum ",1,null,0]
[]
[]
[]
["Section 8 Total - Carried Forward To Summary Page",{"$nulls":5},0]

{"sheet":"Section 9","index":9,"n_rows":120,"n_cols":8,"rows_kept":120,"hidden":true,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[8,17,8,19],[9,17,9,19],[10,17,10,19],[17,9,17,11],[17,12,17,14],[119,0,119,5],[157,5,238,6],[434,0,434,4]],"flags":["formulas_cached_only"]}
["Istallation of a 400 mm meter connection in Mnandi",{"$nulls":5},"Section 9 : Connections Pipe Specials "]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount","Comments"]
["No.","Refers"]
[]
[null,null,"SECTION 9:  CONNECTION CHAMBERS - CONNECTIONS PIPE SPECIALS"]
[]
[9.1,null,"Transportation, inspection(at point of loading and off loading), loading and off loading of All Pipe Specials","Sum",1,{"v":6000,"d":"R6,000.00"},{"v":6000,"d":"R6,000.00"},"As per RW crew "]
[null,null,"Fittings  - Refer to Drg. No. RA26854"]
[]
[9.2,"TS 5.11","Manufacture of Pipe specials"]
[null,null,"Fittings  - Refer to Drg. No. RA26854"]
[null,null," "]
[]
["9.2.1",null,"Item 1:DN1000mm steel pipe, 5600mm long with puddle flange placed at 650mm from end of pipe ","No",1,null,null,"As per the estimate"]
[]
["9.2.2",null,"Item 2: 6mm thick collar plate 200mmm width  DN1000","No",1,{"v":4250,"d":"R4,250.00"},{"v":4250,"d":"R4,250.00"},"As per the estimate"]
[]
["9.2.3",null,"Item 3:406.4mm O.D straight pipe, with 114.3mm O.D stub pipe 686mm long as dimensioned in Drg. No. RA26854 .  And collar plate (SEE ITEM 4). 406.4mm O.D t= 9.52mm 114.3mm O.D t=6.02mm","No",3,{"v":7985,"d":"R7,985.00"},{"v":23955,"d":"R23,955.00"},"As per the estimate"]
[]
["9.2.4",null,"Item 4: 6mm collar plate, 100mm width ","No",4,{"v":2250,"d":"R2,250.00"},{"v":9000,"d":"R9,000.00"},"As per RW crew "]
[]
["9.2.5",null,"Item 5: 114.3mm O.D 90° bend at 114mm c/end. t=6.02mm","No",3,{"v":10450,"d":"R10,450.00"},{"v":31350,"d":"R31,350.00"},"As per the estimate"]
[]
["9.2.6",null,"Item 7: 114.3mm O.D straight pipe, 310mm long flange one end, plain end other end  t=6.02mm","No",1,{"v":13980,"d":"R13,980.00"},{"v":13980,"d":"R13,980.00"},"As per the estimate"]
[]
["9.2.7",null,"Item 9: 406.4mm O.D straight pipe, flanged other end and plain ended other. 440mm LONG. t=9.52mm","No",1,null,null,"As per RW crew "]
[]
["9.2.8",null,"Item 10: 406.4mm 90° bend at 450mm c/c.t=9.52mm","No",1,null,null,"As per RW crew "]
[]
["9.2.9",null,"Item 11: 406.4mm OD straight pipe, flanged both ends of  DN400 WITH 114.3mm O.D stub pipe plain ended as dimensioned in  Drg. No. RA26854.  And collar plate (See item 4). 406.4mm O.D t= 9.52mm 114.3mm O.D t=6.02mm","No",1,null,null,"As per the estimate"]
[]
["9.2.10",null,"Item 12: 406.4mm O.D Dirt Box . (See detail for dimensions).","No",1,{"v":90000,"d":"R90,000.00"},{"v":90000,"d":"R90,000.00"},"As per the estimate"]
[]
["9.2.11",null,"Item 13:DN400 Dismantling joint Max=316mm f/f ","No",1,6000,6000,"As per the estimate"]
[]
["9.2.12",null,"Item 14:DN400 Insulation Flangee","No",2,null,null,"As per the estimate"]
[]
["9.2.13",null,"Item 15:DN400 Electromagnetic flow meter","No",1,110000,110000,"As per the estimate"]
[]
["9.2.14",null,"Item 16: 406.4mm O.D Spool piece  flanged both ends, 1600mml ong . t=9.52mm","No",1,null,null,"As per the estimate"]
[]
["9.2.15",null,"Item 17:406.4mm OD straight pipe, 800mm long flanged both ends with 114.3mm O.D stub pipe 515mm long plain ended as dimensioned in Drg. No. RA26854.  And collar plate (See item 4). 406.4mm O.D t= 9.52mm 114.3mm O.D t=6.02mm","No",1,null,null,"As per the estimate"]
[]
["9.2.16",null,"Item 18:114mm OD straight pipe, 460mm long flanged one end, plain ended other end t=6.02mm","No",2,null,null,"As per the estimate"]
[]
["9.2.17",null,"Item 19:406.4mm O.D straight pipe with puddle flange at 114.3mm O.D branc plain ended as dimensioned in Drg. No. RA26854  406.4mm O.D t= 9.52mm 114.3mm O.D t=6.02mm","No",1,null,null,"As per the estimate"]
[]
["9.2.18",null,"Item 20:406.4mm O.D Dome, 425mm long t= 9.52mm","No",1,null,null,"As per the estimate"]
[]
[9.3,"TS 5.11","Installation of Pipe specials"]
[]
[null,null,"Installation of the following steel pipe specials in accordance with the specifications.  Rate to include cutting into or welding or jointing with flanges as required and for making good of coating and lining as per specifications after fabrication for all chambers.  Flanges according to Rand Water Specification (Dwg A11791)."]
[]
["9.3.1",null,"Item 1:DN1000mm steel pipe, 5600mm long with puddle flange placed at 650mm from end of pipe ","No",1,null,null,"As per the estimate"]
[]
["9.3.2",null,"Item 2: 6mm thick collar plate 200mmm width  DN1000","No",1,{"v":637.5,"d":"R637.50"},{"v":637.5,"d":"R637.50"},"As per the estimate"]
[]
["9.3.3",null,"Item 3:406.4mm O.D straight pipe, with 114.3mm O.D stub pipe 686mm long as dimensioned in Drg. No. RA26854 .  And collar plate (SEE ITEM 4). 406.4mm O.D t= 9.52mm 114.3mm O.D t=6.02mm","No",3,{"v":1197.75,"d":"R1,197.75"},{"v":3593.25,"d":"R3,593.25"},"As per the estimate"]
[]
["9.3.4",null,"Item 4: 6mm collar plate, 100mm width ","No",4,{"v":337.5,"d":"R337.50"},{"v":1350,"d":"R1,350.00"},"As per the estimate"]
[]
["9.3.5",null,"Item 5: 114.3mm O.D 90° bend at 114mm c/end. t=6.02mm","No",3,{"v":1567.5,"d":"R1,567.50"},{"v":4702.5,"d":"R4,702.50"},"As per the estimate"]
[]
["9.3.6",null,"Item 7: 114.3mm O.D straight pipe, 310mm long flange one end, plain end other end  t=6.02mm","No",1,{"v":2097,"d":"R2,097.00"},{"v":2097,"d":"R2,097.00"},"As per the estimate"]
[]
["9.3.7",null,"Item 9: 406.4mm O.D straight pipe, flanged other end and plain ended other. 440mm LONG. t=9.52mm","No",1,null,null,"As per the estimate"]
[]
["9.3.8",null,"Item 10: 406.4mm 90° bend at 450mm c/c.t=9.52mm","No",1,null,null,"As per the estimate"]
[]
["9.3.9",null,"Item 11: 406.4mm OD straight pipe, flanged both ends of  DN400 WITH 114.3mm O.D stub pipe plain ended as dimensioned in  Drg. No. RA26854.  And collar plate (See item 4). 406.4mm O.D t= 9.52mm 114.3mm O.D t=6.02mm","No",1,null,null,"As per the estimate"]
[]
["9.3.10",null,"Item 12: 406.4mm O.D Dirt Box . (See detail for dimensions).","No",1,13500,13500,"As per the estimate"]
[]
["9.3.11",null,"Item 13:DN400 Dismantling joint Max=316mm f/f ","No",1,900,900,"As per the estimate"]
[]
["9.3.12",null,"Item 14:DN400 Insulation Flangee","No",2,null,null,"As per the estimate"]
[]
["9.3.13",null,"Item 15:DN400 Electromagnetic flow meter","No",1,16500,16500,"As per the estimate"]
[]
["9.3.14",null,"Item 16: 406.4mm O.D Spool piece  flanged both ends, 1600mml ong . t=9.52mm","No",1,null,null,"As per the estimate"]
[]
["9.3.15",null,"Item 17:406.4mm OD straight pipe, 800mm long flanged both ends with 114.3mm O.D stub pipe 515mm long plain ended as dimensioned in Drg. No. RA26854.  And collar plate (See item 4). 406.4mm O.D t= 9.52mm 114.3mm O.D t=6.02mm","No",1,null,null,"As per the estimate"]
[]
["9.3.16",null,"Item 18:114mm OD straight pipe, 460mm long flanged one end, plain ended other end t=6.02mm","No",2,null,null,"As per the estimate"]
[]
["9.3.17",null,"Item 19:406.4mm O.D straight pipe with puddle flange at 114.3mm O.D branc plain ended as dimensioned in Drg. No. RA26854  406.4mm O.D t= 9.52mm 114.3mm O.D t=6.02mm","No",1,null,null,"As per the estimate"]
[]
["9.3.18",null,"Item 20:406.4mm O.D Dome, 425mm long t= 9.52mm","No",1,null,null,"As per the estimate"]
[]
[9.4,"TS 5.12","Valves"]
[]
[null,null,"All valve to be according to RW Specifications. (All valves to be supplied and installed as indicated on drawings including valve supports)."]
[]
["9.4.1",null,"Item 6: ø400mm  Sluice valve","No",2,{"v":45000,"d":"R45,000.00"},{"v":90000,"d":"R90,000.00"},"As per RW crew "]
["9.4.2",null,"Item 8: ø100 mm Bypass Sluice valve","No",2,{"v":257000,"d":"R257,000.00"},{"v":514000,"d":"R514,000.00"},"As per RW crew "]
[]
[]
[9.6,null,"STOP COCK"]
[]
[null,null,"Collect and install stop cock on either side on large sluice valves. ate to include cutting into the pipeline and welding"]
[]
["9.6.1",null,"25mm Stop Cock","No",2,{"v":1000,"d":"R1,000.00"},"Rate only ","As per the estimate"]
[]
[9.7,"TS 2.9","Coating and lining (Collection and installation)"]
["9.7.1",null,"ø100 mm for ","m",7,{"v":180,"d":"R180.00"},{"v":1260,"d":"R1,260.00"},"As per the estimate"]
["9.7.2",null,"ø400 mm for ","m",12,{"v":720,"d":"R720.00"},{"v":8640,"d":"R8,640.00"},"As per the estimate"]
[]
["9.7.3",{"$nulls":6},"As per RW crew "]
[{"$nulls":7},"As per RW crew "]
[]
[{"$nulls":7},"As per RW crew "]
[]
[{"$nulls":7},"As per RW crew "]
[]
[{"$nulls":7},"As per RW crew "]
[]
[{"$nulls":7},"As per RW crew "]
[]
["Section 9 Total - Carried Forward To Summary Page",{"$nulls":5},{"v":951715.25,"d":"R 951,715.25"}]

{"sheet":"Section 10 ","index":10,"n_rows":126,"n_cols":7,"rows_kept":126,"merged":[[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[125,0,125,5]],"flags":["formulas_cached_only"]}
["Istallation of a 400 mm meter connection in Mnandi",{"$nulls":5},"Section 10 : Concrete and Steel works "]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[]
[10,null,"SECTION 10: VALVE CHAMBERS - CONCRETE AND STEELWORK"]
[]
[null,"SABS\n1200GA","SECTION 10.1: CONCRETE (SMALL WORKS) "]
[]
[10.1,8.2,"Formwork"]
[]
["10.1.1","8.2.1","Rough Formwork"]
[]
["10.1.1.1",null,"Roof soffit (at a height of 3.95 m) ","m2",38,null,0]
[]
[null,null,"Supply all materials, install and remove formwork (rate to include for forming of 20 x 20 chamfers to all exposed edges for:"]
[]
["10.1.2","8.2.2","Smooth Formwork"]
[]
["10.1.2.1",null,"To walls","m²",262,null,0]
[]
["10.1.3","8.2.3","Narrow Widths"]
[]
["10.1.3.1",null,"Sides of roof slab 250mm high","m",34,null,0]
[]
["10.1.3.2",null,"Sides of downstand beams 100mm high","m",47,null,0]
[]
["10.1.3.3",null,"Sides of base slab 400mm high","m",36,null,0]
[]
["10.1.4","8.2.4","Box out Holes / Form Voids"]
[]
["10.1.4.1",null,"To box out hole for 50 mm diameter removable roof panel","No.",8,null,0]
[]
["10.1.4.2",null,"To box out hole for 200 mm for sleeves drectly above valve cap","No.",2,null,0]
[]
["10.1.4.3",null,"To box out hole for 110 mm for sleeve directly above valve cap","No.",2,null,0]
[]
["10.1.4.4",null,"To box out hole for 0.4m diameter pipe for depth  exceeding 300mm thick","No.",1,null,0]
[]
["10.1.4.5",null,"To box out hole for 1m diameter pipe for depth  exceeding 300mm thick","No.",2,null,0]
[]
["10.1.4.6",null,"To box out hole in floor 500mm x 500mm x 200mm (Sump)","No.",1,null,0]
[]
["10.1.4.7",null,"To box out hole for 110mm diameter x 300mm depth  (Ventilation sleeves)","No.",11,null,0]
[]
[]
[10.2,8.3,"Reinforcement"]
[]
["10.2.1","8.3.1","Steel Bars"]
[]
["10.2.1.1",null,"i) High Tensile Steel","t",17,null,0]
[]
["10.2.1.2",null,"ii) Mild Steel","t",{"v":2.04,"d":"2.0"},null,0]
[]
[]
[10.3,8.4,"Concrete"]
[]
["10.3.1","8.4.2","15MPa Blinding Layer (50 mm thick)","m²",62,null,0]
[]
["10.3.2","8.4.3","Strength concrete Grade 35MPa ","m³",84,null,0]
[]
[]
["10.3.3","8.4.4","Unformed surface finishes"]
[]
["10.3.3.1","(a)","Wood floated finish to top of floor slab","m²",38,null,0]
[]
[]
[10.4,"8.8","Miscellaneous"]
[]
["10.4.1",null,"Cast in PVC sleeves:"]
[]
["10.4.2",null,"110mm diameter x 300mm long including vermin proof mesh","No.",11,null,0]
[]
["10.4.3",null,"Cast in 50mm diameter x 280mm long PVC sleeves in roof slab for lifting purposes","No.",8,null,0]
[]
["10.4.4",null,"Cast in standard Rand Water manhole frame and cover (supplied by Rand Water)","No.",1,null,0]
[]
["10.4.5",null,"Concrete sampling and strength testing as per SANS 2001-CC1 ","Sum ",1,null,0]
[]
[10.5,"SABS\n1200HA","SECTION 10.2: STRUCTURAL STEELWORK (SUNDRY ITEMS)"]
["10.5.1","8.3.1","Structural Steel "]
[]
["10.5.1.1","8.3.1","Supply all materials and install valve supports as detailed on Rand Water Detail Drg A12210","No.",2,null,0]
[]
["10.5.2","8.3.3","Handrails"]
[]
["10.5.2.1",null,"Supply all materials and install galvanised steel ladders complete as detailed on Rand Water Detail Drg A7406 with lengths of:"]
[null,null,"a) 2.5 m","No.",3,null,0]
[]
["10.5.3","PSHA 8.3.10","Collect from Rand Water Supply and install 590 x 490mm square steel fibre concrete lockable manhole cover as per Rand Water Detail Drg 11860","No.",2,null,0]
[]
["10.5.4",null,"Supply and install locks for manholes."]
[]
["10.5.4.1",null,"Manco locking device with 20mm locking bar as per Rand Water details","No.",2,null,0]
[]
["10.5.5",null,"Grab rails and platforms"]
[]
["10.5.5.1","PSHA  8.3.7","Supply and install Grab Rails as detailed on Rand Water Detail Drg. A9858","No.",2,null,0]
[]
["10.5.6",null,"Water proofing compound - \"Sika Cemflex\" 1m wide rolls fabric: 20m*150mm OR similar Approved (All around) applied in strict accordance with manufacture's specifications","Sum",1,null,0]
[]
[]
["10.5.7","PSA 8-10","Water Tightness Test"]
[]
["10.5.7.1",null,"Test water tightness of all concrete valve chambers (excluding air valves) as per SANS 2001 CC1","No.",1,null,0]
[]
[]
["10.6","SABS\n1200HC","SECTION 10.3:CORROSION PROTECTION OF STRUCTURAL STEELWORK "]
[]
["10.6.1","8.2.3","Surface preparation and coating application on site for:"]
[]
["10.6.1.1",null,"a) Cat ladders (as per DRG No. A7406) "]
[null,null,"i) 2500mm high, refer to DRG R022515","m2",1,null,0]
[]
["10.6.1.2",null,"c) Grab rails  (as per DRG. No. A9858)","m",1.4,null,0]
[]
["10.6.1.3",null,"d) Valve Supports","m",4,null,0]
[]
["10.6.2 ","8.2.4","Establishment on site for corrosion protection ","Sum ",1,null,0]
[]
[]
[]
[]
[]
[]
["Section 10 Total - Carried Forward To Summary Page",{"$nulls":5},0]

{"sheet":"Section 11","index":11,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,0,0,2],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[32,0,32,5]],"flags":["formulas_cached_only"]}
["SECTION 11:  PROVISION FOR SOCIO ECONOMIC DEVELOPMENT"]
[]
["Item","Payment Ref.","Description","U O M","Qty                 (A)","Rate                     (B)","Total                   (A*B)"]
["No."]
[]
[null,null,"SCHEDULE 11 :  SOCIO ECONOMIC DEVELOPMENT "]
[]
["11.1",null,"SKILLS DEVELOPMENT PROGRAM"]
[]
["11.1.1",null,"Accredited training programmes are targeted which will provide the beneficiaries with significant and recognized credit value in accordance with the National Qualification Framework (NQF) (2% of Project Value - Sub Total A)","Sum",null,{"v":0.02,"d":"2.0%"},0]
[]
["11.1.2",null,"Contractors mark-up on Item 11.1.1 above","%",null,{"v":0.1,"d":"10%"},0]
[]
["11.2",null," SOCIAL RESPONSIBILITY PROGRAM"]
[]
["11.2.1",null,"Social Responsibility programs aimed at community development  (1% of Project Value - Sub Total A)","Sum",0,{"v":0.01,"d":"1.0%"},0]
[]
["11.2.2",null,"Contractors mark-up on Item 11.2.1 above","%",null,{"v":0.1,"d":"10%"},0]
[]
["11.3",null,"COMMUNITY LIASON OFFICER"]
[]
["11.3.1",null,"Community Liason Officer. A key component in aiding the realisation of the SED objectives is effective community liaison with all the relevant role-players, structures, civic organisations and the community at large.","Sum",0,{"v":0.01,"d":"1.0%"},0]
[]
["11.3.2",null,"Contractors mark-up on Item 11.3.1 above","%",null,{"v":0.1,"d":"10%"},0]
[]
[]
["11.4",null,"PARTICIPATION OF LOCAL ENTERPRICES"]
[]
["11.4.1",null,"Work Allocated to Local Enterprises  (Inclusive of P&G's and SHEQ) (Minimum 5% of Project Value) (Sub-Total A)","Sum",0,{"v":0.05,"d":"5%"},"Rate Only"]
[]
["11.4.2",null,"Contractors mark-up on Item 11.4.1 above","%",{"v":0.05,"d":"R0.05"}]
[]
["Section 11 Total Amount Carried Forward To Summary",{"$nulls":5},0]