{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["Summary","C","A","D","DB ","G","HA","HC","L","LB","ME","LD","LG","MJ","MK","PLB","PLG","450mm Bedding","450mm Bedding (2)","Calcs","Pipe Fittings"],"not_rendered":{"images":1,"external_links":24,"defined_names":1420,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":45,"n_cols":16,"rows_kept":45,"merged":[[3,2,3,4]]}
[]
[null,"SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
[null,"SECTION","DESCRIPTION",{"$nulls":6},"TOTAL"]
[null,"SECTION A:","PRELIMINARY AND GENERAL",{"$nulls":5},"R"]
[]
[null,"SECTION C:","SITE CLEARANCE",{"$nulls":5},"R"]
[]
[null,"SECTION D:","EARTHWORKS",{"$nulls":5},"R"]
[]
[null,"SECTION DB:","EARTHWORK (PIPE TRENCHES)",{"$nulls":5},"R"]
[]
[null,"SECTION G:","CONCRETE ",{"$nulls":5},"R"]
[]
[null,"SECTION HA:","STRUCTURAL STEELWORK",{"$nulls":5},"R"]
[]
[null,"SECTION HC:","CORROSION PROTECTION OF STRUCTURAL STEEL",{"$nulls":5},"R"]
[]
[null,"SECTION L:","WATER MAINS",{"$nulls":5},"R"]
[]
[null,"SECTION LB:","BEDDING FOR PIPES",{"$nulls":5},"R"]
[]
[null,"SECTION LD:","SEWER",{"$nulls":5},"R"]
[]
[null,"SECTION LG:","PIPE JACKING",{"$nulls":5},"R"]
[]
[null,"SECTION ME:","SUBBASE",{"$nulls":5},"R"]
[]
[null,"SECTION MJ:","SEGMENTED PAVING",{"$nulls":5},"R"]
[]
[null,"SECTION MK:","KERBING AND CHANNELLING",{"$nulls":5},"R",{"$nulls":6},"`"]
[]
[null,"SECTION PLB:","MISCELLANEOUS WORKS FOR TANKS",{"$nulls":5},"R"]
[]
[null,"SECTION PLG:","ELECTRICAL WORKS",{"$nulls":5},"R"]
[]
[null,"TOTAL FOR SCHEDULE OF QUANTITIES",{"$nulls":6},"R"]
[]
[null,"ADD CONTINGENCIES (10%)",{"$nulls":6},"R"]
[]
[null,"ADD ESCALATION (5%)",{"$nulls":6},"R"]
[null,"SUBTOTAL ",{"$nulls":6},"R"]
[null,"ADD 15 % VAT",{"$nulls":6},"R"]
[]
[null,"TOTAL FOR TENDER (FORWARD TO THE FORM OF TENDER)",{"$nulls":6},"R"]

{"sheet":"C","index":1,"n_rows":57,"n_cols":8,"rows_kept":57}
[]
["ITEM        NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[]
[null,"SABS 1200 C","SECTION C: SITE CLEARANCE"]
[]
["C1",null,"CLEAR SITE"]
["C1.1","8.2.1","Clear and grub site and remove any obstruction that may occur and spoil to designated site.  Only areas indicated in writing by Engineer must be cleared:"]
[null,null,"Clear and grub including all vegetation for Site footprint","m²",{"v":2255,"d":"2,255"},{"v":35,"d":"35.00"}]
[]
["C1.2","PSC 5.1","Clear and grub including all vegetation for pipe route 3m wide.","m",{"v":1153.9,"d":"1,154"},{"v":60,"d":"60.00"}]
[]
["C1.3","PSC 3.1","Transport spoil material to unspecified sites and dump (provisional)","m³.km",{"v":7661.926091211245,"d":"7,662"},{"v":23,"d":"23.00"}]
[]
[null,null,"SITE PREPARATION"]
["C1.4","8.2.10","Remove top soil to nominal depth 75 mm, stockpile and maintain","m³",187,{"v":100,"d":"100.00"}]
{"$rows_empty":41}
[null,"TOTAL FOR SECTION C CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"A","index":2,"n_rows":205,"n_cols":8,"rows_kept":205}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[null,"SANS 1200 A","SECTION 1 : GENERAL"]
[]
["A1","8.3","Scheduled fixed-charge and value- related items"]
[]
["A1.1","8.3.1","Contractual requirements for the provision of all sureties, Insurance of the works and Plant, Third Party Liability Insurance, Unemployment Insurance and any other statutory requirements","Sum",{"v":1,"d":"1.0"},{"v":400000,"d":"400,000.00"}]
[]
["A1.2","PSA 8.3.1","Fixed preliminary and general charges","Sum",{"v":1,"d":"1.0"},{"v":20000,"d":"20,000.00"}]
[]
[null,"8.3.2","Establishment of Facilities on Site (Only on the written instruction of the Engineer)"]
[]
["A1.3",null,"Facilities for the Engineer (See Clause C3.4.2.2) "]
[]
[null,null,"(a) Furnished offices (1 No.)","Sum",{"v":1,"d":"1.0"},{"v":10000,"d":"10,000.00"}]
[null,null,"(b) Telephone (1 Cellphone with Simcard)","P. Sum",{"v":1,"d":"1.0"},{"v":10000,"d":"10,000.00"},{"v":12500,"d":"12,500.00"},{"$f":"G16","v":{"v":12500,"d":"12,500.00"}}]
[null,null,"(c) Percentage mark-up on (a+b) above","%",{"$f":"H16+H15","v":{"v":12500,"d":"12,500.0"}},{"v":0.1,"d":"10%"}]
[null,null,"(d) Nameboards ( No.)","Sum",{"v":1,"d":"1.0"},{"v":20000,"d":"20,000.00"}]
[null,null,"(e) PPE for Engineer and assistants","Sum",{"v":1,"d":"1.0"},{"v":5000,"d":"5,000.00"}]
[null,null,"(f) Survey instruments, etc.","Sum",{"v":1,"d":"1.0"},{"v":7500,"d":"7,500.00"}]
[]
["A1.4","8.3.2.2","Facilities for the Contractor"]
[]
[null,null,"All facilities as scheduled in Clause 8.3.2.2 of SABS 1200A"]
[null,null,"(a) Offices and storage sheds","Sum",{"v":1,"d":"1.0"},{"v":40000,"d":"40,000.00"}]
[null,null,"(b) Workshops","Sum",{"v":1,"d":"1.0"},{"v":25000,"d":"25,000.00"}]
[null,null,"(c) Laboratories","Sum",{"v":1,"d":"1.0"},{"v":15000,"d":"15,000.00"}]
[null,null,"(d) Living accommodation","Sum",{"v":1,"d":"1.0"},{"v":12500,"d":"12,500.00"}]
[null,null,"(e) Ablution and toilet facilities","Sum",{"v":1,"d":"1.0"},{"v":15000,"d":"15,000.00"}]
[null,null,"(f) Tools and equipment","Sum",{"v":1,"d":"1.0"},{"v":30000,"d":"30,000.00"}]
[null,null,"(g) Water supplies, electric power and  communications","Sum",{"v":1,"d":"1.0"},{"v":25000,"d":"25,000.00"}]
[null,null,"(h) Protection against water and storms (see PSA 5.5)","Sum",{"v":1,"d":"1.0"},{"v":20000,"d":"20,000.00"}]
[null,null,"(i) Access ","Sum",{"v":1,"d":"1.0"},{"v":15000,"d":"15,000.00"}]
[null,null,"(j) Plant","Sum",{"v":1,"d":"1.0"},{"v":50000,"d":"50,000.00"}]
[null,null,"(k) PPE for Contractors staff, suppliers, subcontractors and visitors","Sum",{"v":1,"d":"1.0"},{"v":70000,"d":"70,000.00"}]
[]
["A1.5","8.3.3","Other fixed-charge obligations","Sum",{"v":1,"d":"1.0"},{"v":25000,"d":"25,000.00"}]
[]
["A1.5.1",null,"Removal of Site Establishment (On Instruction by Engineer)","Sum",{"v":1,"d":"1.0"},{"v":75000,"d":"75,000.00"}]
[]
["A1.5.2","PS7.1","Provision of a Safety Plan in terms of OHS Act and Safety Regulations","Sum",{"v":1,"d":"1.0"},{"v":15000,"d":"15,000.00"}]
[]
["A2",8.4,"Scheduled Time-related items"]
[]
["A2.1","PSA 8.4.1","Time-related preliminary and general items","Month",{"v":16,"d":"16.0"},{"v":50000,"d":"50,000.00"}]
[]
["A2.2","8.4.2","Operation and maintenance of facilities for the duration of construction"]
[]
["TOTAL CARRIED FORWARD",{"$nulls":4},"R","R"]
["BROUGHT FORWARD",{"$nulls":4},"R","R"]
[]
["A2.3","8.4.2.1","Facilities for the Engineer"]
[]
[null,null,"(a) Furnished offices (1 No.)","Month",{"v":16,"d":"16.0"},{"v":1500,"d":"1,500.00"}]
[null,null,"(b) Telephone (R900 per month airtime for celphone)","Month",{"v":16,"d":"16.0"},{"v":900,"d":"900.00"}]
[null,null,"(c) Nameboards (2 No.)","Month",{"v":16,"d":"16.0"},{"v":500,"d":"500.00"}]
[null,null,"(d) Survey instruments, etc.","Month",{"v":16,"d":"16.0"},{"v":500,"d":"500.00"}]
[null,null,"(e) PPE for Engineer and assistants","Month",{"v":16,"d":"16.0"},{"v":500,"d":"500.00"}]
[]
["A2.4","8.4.2.2","Facilities for the Contractor"]
[]
[null,null,"All facilities as scheduled in Clause 8.4.2.2 of SABS 1200A"]
[null,null,"(a) Offices and storage","Month",{"v":16,"d":"16.0"},{"v":9500,"d":"9,500.00"}]
[null,null,"(b) Workshops","Month",{"v":16,"d":"16.0"},{"v":5000,"d":"5,000.00"}]
[null,null,"(c) Laboratories","Month",{"v":16,"d":"16.0"},{"v":5000,"d":"5,000.00"}]
[null,null,"(d) Living accommodation","Month",{"v":16,"d":"16.0"},{"v":9500,"d":"9,500.00"}]
[null,null,"(e) Ablution and toilet","Month",{"v":16,"d":"16.0"},{"v":5500,"d":"5,500.00"}]
[null,null,"(f) Tools and equipment","Month",{"v":16,"d":"16.0"},{"v":12500,"d":"12,500.00"}]
[null,null,"(g) Water supplies, electric power and  communications","Month",{"v":16,"d":"16.0"},{"v":5000,"d":"5,000.00"}]
[null,null,"(h) Dealing with water (Sub-clause5.8)","Month",{"v":16,"d":"16.0"},{"v":4000,"d":"4,000.00"}]
[null,null,"(i) Access (Sub-clause 5.8)","Month",{"v":16,"d":"16.0"},{"v":5000,"d":"5,000.00"}]
[null,null,"(j) Plant","Month",{"v":16,"d":"16.0"},{"v":30000,"d":"30,000.00"}]
[]
["A2.5","8.4.3","Supervision for duration of construction","Month",{"v":16,"d":"16.0"},{"v":75000,"d":"75,000.00"}]
[]
["A2.6","8.4.4","Company and head office overhead costs for the duration of the contract","Month",{"v":16,"d":"16.0"},{"v":50000,"d":"50,000.00"}]
[]
["A2.7","8.4.5","Other time-related obligations","Month",{"v":16,"d":"16.0"},{"v":17500,"d":"17,500.00"}]
[]
["A2.8","PSA 8.9","Compliance with OHS act and Construction Regulations","Month",{"v":16,"d":"16.0"},{"v":20000,"d":"20,000.00"}]
[]
["A2.9",null,"Compliance with Record of Decision issued by GDARD","Month",{"v":16,"d":"16.0"},{"v":3500,"d":"3,500.00"}]
[]
["A3",8.5,"SUMS STATED PROVISIONALLY BY ENGINEER"]
[]
["A3.1",null,"Supply and Install lightning protection according to latest applicable SANS codes","SUM",{"v":1,"d":"1.0"},{"v":30000,"d":"30,000.00"}]
[]
["A3.2",null,"Supply and install VSD, displays, DC chokes, telemetry cabinet, fibre cable, SD4 data radio, instrumentation, c/w antenna and mast","SUM",{"v":1,"d":"1.0"},{"v":1226500,"d":"1,226,500.00"}]
[]
["A3.3",null,"CLO's"]
[null,null,"Payment for CLO"]
[null,null,"(i) Remuneration of CLO (based on R10500/month incl. traveling allowance)","Month",{"v":18,"d":"18.0"},{"v":8500,"d":"8,500.00"}]
[null,null,"(ii) Cell phone allowance (R150 airtime per month)","Month",{"v":18,"d":"18.0"},{"v":150,"d":"150.00"}]
[null,null,"(iii) Contractors mark-up on items (i) and (ii) above for Contractor's overheads, liaison, making payments and supplying office space and associated facilities within his establishment","%",{"v":45600,"d":"45,600.0"},{"v":0.1,"d":"0.10"}]
["A3.4","PSA 5.5","Protection against water and storms","Sum",{"v":1,"d":"1.0"}]
[]
["TOTAL CARRIED FORWARD",{"$nulls":4},"R","R"]
["BROUGHT FORWARD",{"$nulls":4},"R","R"]
[]
["A3.5",null,"Quality assurance and management plan","SUM",{"v":1,"d":"1.0"},{"v":120000,"d":"120,000.00"}]
["A3.6",null,"Provisional sum for Independent OHS, EMP and Electrical practitioners","Prov. SUM",{"v":1,"d":"1.0"},{"v":200000,"d":"200,000.00"},{"v":250000,"d":"250,000.00"},{"$f":"G101","v":{"v":250000,"d":"250,000.00"}}]
[]
["A3.7",null,"Provide Security guard (armed response) for duration of the construction works during the day and after hours, and on instruction by the Engineer","Month",{"v":16,"d":"16.0"},{"v":5000,"d":"5,000.00"}]
[]
["A4",8.7,"DAYWORK","Days",{"v":20,"d":"20.0"},{"v":1000,"d":"1,000.00"}]
[null,null,"Note: Executed on Instruction of the Engineer Only"]
[]
["A4.1",null,"Labour"]
[null,null,"(i) Un-skilled","hr.",{"v":10,"d":"10.0"},{"v":30,"d":"30.00"}]
[null,null,"(ii) Semi-skilled","hr.",{"v":10,"d":"10.0"},{"v":40,"d":"40.00"}]
[null,null,"(iii) Skilled (artisan - welder plumber etc.)","hr.",{"v":10,"d":"10.0"},{"v":85,"d":"85.00"}]
[null,null,"(iv) Engineer","hr.",{"v":5,"d":"5.0"},{"v":600,"d":"600.00"}]
[null,null,"(v) Technician","hr.",{"v":5,"d":"5.0"},{"v":400,"d":"400.00"}]
[null,null,"(vi) Foreman","hr.",{"v":10,"d":"10.0"},{"v":120,"d":"120.00"}]
[null,null,"(vii) Driver (LDV,machine, trucks, etc.)","hr.",{"v":10,"d":"10.0"},{"v":120,"d":"120.00"}]
[null,null,"(viii) Certified Blaster","hr.",{"v":10,"d":"10.0"},{"v":400,"d":"400.00"}]
[null,null,"(ix) Steel fixer","hr.",{"v":10,"d":"10.0"},{"v":150,"d":"150.00"}]
[null,null,"(x) Concretor","hr.",{"v":10,"d":"10.0"},{"v":150,"d":"150.00"}]
[null,null,"(xi) Charge hand","hr.",{"v":10,"d":"10.0"},{"v":100,"d":"100.00"}]
[null,null,"(xii) Security guard","hr.",{"v":10,"d":"10.0"},{"v":200,"d":"200.00"}]
[]
["A4.2",null,"Plant and equipment"]
[]
[null,null,"(a) Tractor loader backhoe (TLB)"]
[null,null,"(i) Tractor Loader Backhoe (Bigger than 45kW but smaller than 70kW)","hr.",{"v":10,"d":"10.0"},{"v":1000,"d":"1,000.00"}]
[]
[null,null,"(b) Crawler Excavators"]
[null,null,"(i) Smaller than 93kW (small)","hr.",{"v":10,"d":"10.0"},{"v":1200,"d":"1,200.00"}]
[null,null,"(ii) Bigger than 93kW but smaller than 200kW ( Medium)","hr.",{"v":10,"d":"10.0"},{"v":1300,"d":"1,300.00"}]
[]
[null,null,"(c) Tipper Trucks"]
[null,null,"(i) Tipper trucks (3m³) Small","hr.",{"v":10,"d":"10.0"},{"v":300,"d":"300.00"}]
[null,null,"(ii) Tipper trucks (5m³) Medium","hr.",{"v":10,"d":"10.0"},{"v":400,"d":"400.00"}]
[null,null,"(iii) Tipper trucks (10m³) Large","hr.",{"v":10,"d":"10.0"},{"v":500,"d":"500.00"}]
[]
[null,null,"(d) Flat Bed Trucks"]
[null,null,"(i) Flat bed 5t capacity","hr.",{"v":8,"d":"8.0"},{"v":300,"d":"300.00"}]
[null,null,"(ii) Flat bed 7t capacity","hr.",{"v":8,"d":"8.0"},{"v":400,"d":"400.00"}]
[]
[null,null,"(e) LDV"]
[null,null," (i) 1t Pick-up","hr.",{"v":10,"d":"10.0"},{"v":200,"d":"200.00"}]
[]
[null,null,"(f) Mobile Crane 5t at 3m radius","hr.",{"v":10,"d":"10.0"},{"v":800,"d":"800.00"}]
[]
[null,null,"(g) Walk behind vibrating rollers"]
[null,null,"(i) Model - Bomag 60 or similar  (small)","hr.",{"v":10,"d":"10.0"},{"v":500,"d":"500.00"}]
[null,null,"(ii) Model - Bomag 76 or similar  (medium)","hr.",{"v":10,"d":"10.0"},{"v":700,"d":"700.00"}]
[null,null,"(iii) Model - Bomag 90 or similar","hr.",{"v":10,"d":"10.0"},{"v":800,"d":"800.00"}]
[]
[]
[]
[]
["TOTAL CARRIED FORWARD",{"$nulls":4},"R","R"]
["BROUGHT FORWARD",{"$nulls":4},"R","R"]
[null,null,"(h) Plate compactors"]
[null,null,"(i) Vipac or similar","hr.",{"v":10,"d":"10.0"},{"v":150,"d":"150.00"}]
[]
[null,null,"(i) Rammers"]
[null,null,"(i) Model - Wacker or similar","hr.",{"v":10,"d":"10.0"},{"v":75,"d":"75.00"}]
[]
[null,null,"(j) Concrete mixers"]
[null,null,"(i) Volume 100 litre wet (small, towable)","hr.",{"v":8,"d":"8.0"},{"v":150,"d":"150.00"}]
[null,null,"(ii) Volume 175 litre wet (medium)","hr.",{"v":8,"d":"8.0"},{"v":180,"d":"180.00"}]
[null,null,"(iii) Volume 250 litre wet (large)","hr.",{"v":8,"d":"8.0"},{"v":200,"d":"200.00"}]
[]
[null,null,"(k) Diesel compressors including hoses and tools","hr",{"v":10,"d":"10.0"},{"v":4398.12,"d":"4,398.12"}]
[null,null,"(i) Capacity smaller than 200 cfm (small)","hr.",{"v":10,"d":"10.0"},{"v":250,"d":"250.00"}]
[null,null,"(ii) Capacity bigger than 200 cfm smaller than 400 cfm (medium)","hr.",{"v":10,"d":"10.0"},{"v":300,"d":"300.00"}]
[null,null,"(iii) Capacity bigger than 400 cfm (large)","hr.",{"v":10,"d":"10.0"},{"v":480,"d":"480.00"}]
[null,null,"            "]
[null,null,"(l) Waterpump"]
[null,null,"(i) Capacity smaller than 400 litre/min (medium)","hr",{"v":10,"d":"10.0"},{"v":250,"d":"250.00"}]
[null,null,"(ii) Capacity bigger than 400 but smaller than 600 litre/min (medium) ","hr",{"v":10,"d":"10.0"},{"v":300,"d":"300.00"}]
[null,null,"(iii) Capacity bigger than 600 but smaller then 1 100 litre/sec (large)","hr",{"v":10,"d":"10.0"},{"v":480,"d":"480.00"}]
[]
["A5",8.8,"TEMPORARY WORKS"]
["A5.1",null,"Provide and maintain access roads and adjacent streets including reinstatement of roads on completion of Works (or accommodation of traffic)","Sum",{"v":1,"d":"1.0"},{"v":50000,"d":"50,000.00"}]
[]
[null,null,"Existing services"]
[]
["A5.2",null,"Temporarily protection of existing services","P. SUM",{"v":1,"d":"1.0"},{"v":10000,"d":"10,000.00"},{"v":12500,"d":"12,500.00"},{"$f":"G181","v":{"v":12500,"d":"12,500.00"}}]
[]
["A5.3",null,"Contractor's mark-up on 108 above","%",{"$f":"H181","v":{"v":12500,"d":"12,500.0"}},{"v":1000,"d":"1,000.00"}]
[]
["A5.4",null,"Cast insitu class 20/19 concrete for encasing of existing services","m³",{"v":10,"d":"10.0"},{"v":1400,"d":"1,400.00"}]
[]
["A5.5",null,"Welded steel reinforcing mesh (Ref 395)","m²",{"v":100,"d":"100.0"},{"v":150,"d":"150.00"}]
[]
["A5.6",null,"Relocation of existing services","P. SUM",{"v":1,"d":"1.0"},{"v":75000,"d":"75,000.00"},{"v":93750,"d":"93,750.00"},{"$f":"G189*E189","v":{"v":93750,"d":"93,750.00"}}]
[]
["A5.7",null,"Contractor's mark-up on A5.6 above","%",{"$f":"H189","v":{"v":93750,"d":"93,750.0"}},{"v":0.1,"d":"10%"}]
[]
["A6",null,"Sub-Contractor P&G's for all packages",null,{"v":1,"d":"1.0"},{"v":6566101.405167351,"d":"6,566,101.41"}]
[null,null,"Contractor's mark-up on A6 above","%",{"v":0.1,"d":"10%"},{"v":8207626.756459188,"d":"8,207,626.76"}]
{"$rows_empty":10}
[null,"TOTAL FOR SECTION A CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"D","index":3,"n_rows":50,"n_cols":8,"rows_kept":50}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE","AMOUNT"]
[]
[null,"SABS     1200 D","SECTION D: EARTHWORKS"]
[]
["D1 SC","PSD 8.3.2","EXCAVATION"]
[null,"8.3.2a","Excavate in all materials and use for backfill, or dispose as ordered:"]
[null,null,"(a) Tower Foundation (measured under Work Packages)","m³",228,{"v":0,"d":"0.00"}]
[null,null,"(b) Valve Chamber","m³",353,{"v":250,"d":"250.00"}]
[]
["D1.2","8.3.2b","Excavate in all materials to spoil:"]
[null,null,"(a) Tower Foundation","m³",{"v":491.01461556465864,"d":"491"},{"v":300,"d":"300.00"}]
[null,null,"(b) Valve Chamber","m³",{"v":140.52412,"d":"141"},{"v":300,"d":"300.00"}]
[]
["D1.3","8.3.2c","Extra over items D1.1 to D1.4 for excavation in:"]
[null,null,"(a) Intermediate material","m³",{"v":181.8808103346988,"d":"182"},{"v":400,"d":"400.00"}]
[null,null,"(b) Hard rock material","m³",{"v":60.62693677823294,"d":"61"},{"v":600,"d":"600.00"}]
[]
["D1.4","8.3.2d","Extra over items D1.1 to D1.4 for excavation in:"]
[null,null,"Hand excavation or other method (excluding blasting) to remove rock outcrops or rock underbreak after bulk excavation to form level site (alternative for soilcrete backfilling in rock overbreak)","m³",20,{"v":250,"d":"250.00"}]
[]
["D2",null,"EXISTING SERVICES"]
["D2.1","PSD8.3.8.1","Hand excavation for locationg and exposing existing services in:"]
[null,null,"(a) Roadways","m³",30,{"v":300,"d":"300.00"}]
[null,null,"(b) All other areas","m³",30,{"v":300,"d":"300.00"}]
[]
["D3",null,"Topsoiling from stockpile 75 mm layer:"]
[null,"PSD 8.3.10","Level on Site","m³",{"v":113.7675,"d":"114"},{"v":300,"d":"300.00"}]
[]
["D4 SC",null,"Extra over items PSD 8.3.2. for "]
[null,"PSD 8.3.14","(a) Temporary stockpiling","m³",{"$f":"E9","v":353},{"v":250,"d":"250.00"}]
[null,"PSD 8.3.15","(b) Disposing of spoil material on a site provided by The Contractor (measured under Work Packages)","m³",{"$f":"E13+E12","v":{"v":631.5387355646586,"d":"632"}},{"v":0,"d":"0.00"}]
[]
["D5 SC",null,"Grassing"]
[null,"PGENRD 8","Grassing (Kikuyu instant lawn) (measured under Work Packages)","m³",{"v":1517,"d":"1,517"},{"v":0,"d":"0.00"}]
{"$rows_empty":14}
[null,"TOTAL FOR SECTION D CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"DB ","index":4,"n_rows":51,"n_cols":8,"rows_kept":51}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[]
[null,"SABS     1200 DB","SECTION DB: PIPE TRENCHES"]
[]
["DB1",null,"EXCAVATION"]
["DB1.1","PSDB8.3.2a","Excavate by machine in all materials for trenches, backfill, compact and dispose of surplus or unsuitable material for pipes up to 650 mm diameter for dephts:"]
[null,null,"Over and up to"]
[null,"","(a)   0,0 m     1,0 m"," m",66,{"v":200,"d":"200.00"}]
[null,"","(b)   1,0 m     2,0 m"," m",{"v":1021.9000000000001,"d":"1,022"},{"v":250,"d":"250.00"}]
[null,"","(c)   2,0 m     3,0 m"," m",{"v":289.3,"d":"289"},{"v":300,"d":"300.00"}]
[]
["DB1.2","8.3.2b","Extra-over items DB1.1 to DB1.3 for excavation in (provisional):"]
[null,null,"(a)  Intermediate material","m³",492,{"v":200,"d":"200.00"}]
[null,null,"(b)  Hard rock material","m³",164,{"v":600,"d":"600.00"}]
[]
["DB1.3","8.3.2c","Excavate unsuitable material from trench bottom and dispose of it","m³",65,{"v":225,"d":"225.00"}]
[]
["DB2","8.3.3","EXCAVATION ANCILLARIES"]
["DB2.1","8.3.3.1a","Imported backfill materials from trench excavation or stockpiles on site:"]
[null,null,"Acquire, deliver, place and compact imported selected backfill to fill over-excavation under pipe bedding where unsuitable material under item DB1.5 is removed","m³",65,{"v":250,"d":"250.00"}]
[]
["DB2.2","PSDB8.3.2(4)","Backfill stabilized with 5% cement where directed by the Engineer ","m³",10,{"v":0,"d":"0.00"}]
[]
["DB2.3","PSDB8.3.2(5)","Soilcrete backfill where directed by the Engineer ","m³",15,{"v":0,"d":"0.00"}]
{"$rows_empty":25}
[null,"TOTAL FOR SECTION DB CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"G","index":5,"n_rows":115,"n_cols":8,"rows_kept":115}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[]
[null,"SABS","SECTION G: CONCRETE "]
[null,"1200 G","                   (STRUCTURAL)"]
["G1","8.2","FORMWORK"]
[null,"8.2.2","Smooth vertical plane to:"]
["G1.1",null,"Tower Foundation","m²",123,{"v":450,"d":"450.00"}]
["G1.2",null,"Chambers and thrust blocks","m²",164,{"v":650,"d":"650.00"}]
[]
[null,"8.2","FORMWORK"]
[null,"8.2.2","Special smooth vertical plane to:"]
["G1.3",null,"Internal and External Shaft Walls","m²",{"v":1240,"d":"1,240"},{"v":825,"d":"825.00"}]
["G1.4",null,"Internal and External Tank Walls","m²",828,{"v":1050,"d":"1,050.00"}]
[]
[null,"8.2.2","Smooth horizontal to:"]
["G1.5",null,"Circular landing at top of internal tank walls","m²",{"v":12.717167061731482,"d":"13"},{"v":2350,"d":"2,350.00"}]
["G1.6",null,"Chamber soffits","m²",{"v":70.26206,"d":"70"},{"v":500,"d":"500.00"}]
[]
[null,"8.2.2","Smooth inclined formwork:"]
["G1.7",null,"Inclined portion of tank walls","m²",789,{"v":2750,"d":"2,750.00"}]
[]
[null,"8.2.4","Smooth domed formwork:"]
["G1.8",null,"Domed Roof","m²",178,{"v":1025,"d":"1,025.00"}]
[]
[null,"8.2.5","Narrow Widths"]
["G1.9",null,"Chamber Bases","m",{"v":48.510000000000005,"d":"49"},{"v":175,"d":"175.00"}]
["G1.10",null,"Tower Dome Roof","m",62,{"v":375,"d":"375.00"}]
["G1.11",null,"Chamber Roofs","m",{"v":48.510000000000005,"d":"49"},{"v":210,"d":"210.00"}]
[]
[null,null,"BOX OUT HOLES/FORM VOIDS"]
[null,"PSG 8.10","Small circular holes of diameter up to 0.35m sealed with a bentonite strip when grouted."]
["G1.12",null,"Scour and overflow pipes","No",5,{"v":2000,"d":"2,000.00"}]
[]
[null,"PSG 8.10","Small circular holes of diameter 0.35m up to 0.65m sealed with a bentonite strip when grouted."]
["G1.13",null,"Inflow and Outflow pipes","No",8,{"v":3500,"d":"3,500.00"}]
[]
["G2","8.3","REINFORCEMENT"]
["G2.1","8.3.1","Mild steel bars:"]
[null,null,"Diameters 8 mm to 40 mm: average price for manholes","t",{"v":22.3,"d":"22"},{"v":16500,"d":"16,500.00"}]
[]
["G2.2","8.3.1","High-tensile steel bars average"]
[null,null,"price:"]
[null,null,"Diameters 10 mm to 40 mm: average price as indicated on schedules","t",223,{"v":16500,"d":"16,500.00"}]
[]
["G3","8.4","CONCRETE"]
["G3.1","8.4.2","Blinding layer in 15 MPa/19 mm concrete:"]
[null,null,"50 mm minimum thickness","m²",650,{"v":380,"d":"380.00"}]
[]
["G3.2","8.4.3","Mass concrete: 15MPa/19 mm:"]
[null,null,"Below tower foundation","m³",{"v":12.375,"d":"12"},{"v":1600,"d":"1,600.00"}]
[]
[]
[]
[null,null,"TOTAL CARRIED FORWARD",null,null,"R","R"]
[null,null,"TOTAL BROUGHT FORWARD",null,null,"R","R"]
[]
[null,"8.4.3","Strength concrete: 20 MPa/19 mm:"]
["G3.3",null,"Concrete for Scour tank base","m³",{"v":1.8941999999999999,"d":"2"},{"v":1650,"d":"1,650.00"}]
[]
[null,"8.4.3","Strength concrete: 30 MPa/19 mm:"]
["G3.4",null,"Tower Base","m³",478,{"v":1750,"d":"1,750.00"}]
["G3.5",null,"Chamber Base and Thrust blocks","m³",{"v":19.459715000000003,"d":"19"},{"v":1750,"d":"1,750.00"}]
[]
[null,"8.4.3","Strength concrete: 35 MPa/19 mm:"]
["G3.6",null,"Shaft Walls","m³",179,{"v":2100,"d":"2,100.00"}]
["G3.7",null,"Chamber and scour Walls","m³",{"v":24.061235000000007,"d":"24"},{"v":2100,"d":"2,100.00"}]
["G3.8",null,"Dome Roof","m³",{"v":53.900010633328996,"d":"54"},{"v":2100,"d":"2,100.00"}]
["G3.9",null,"Chamber Roof","m³",{"v":17.565515,"d":"18"},{"v":2100,"d":"2,100.00"}]
[]
[null,"8.4.3","Strength concrete: 40 MPa/19 mm:"]
["G3.10",null,"Tank Walls","m³",{"v":290.2876738897298,"d":"290"},{"v":2850,"d":"2,850.00"}]
[]
["G4","8.4.4","UNFORMED SURFACE FINISHINGS"]
[null,null,"Wood floated finishings:"]
["G4.1",null,"Top of Tower base","m²",195,{"v":75,"d":"75.00"}]
["G4.2",null,"Top of dome roof and ringbeam","m²",194,{"v":95,"d":"95.00"}]
["G4.3",null,"Chamber Base and Overflow tank","m²",{"v":76.57606,"d":"77"},{"v":75,"d":"75.00"}]
["G4.4",null,"Chamber roof","m²",{"v":70.26206,"d":"70"},{"v":80,"d":"80.00"}]
[]
["G5","PSG8.9","CONCRETE CUBE-TESTING MACHINE"]
["G5.1",null,"Testing of concrete cubes","No",{"v":179.42389158717648,"d":"179"},{"v":300,"d":"300.00"}]
["G5.2",null,"Supply cube-testing machine on site with"]
[null,null,"recent calibration certificate and water trough","Sum",1,{"v":6000,"d":"6,000.00"}]
[]
[]
[{"$nulls":7},""]
[]
[{"$nulls":7},""]
{"$rows_empty":25}
[null,"TOTAL FOR SECTION G CARRIED TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"HA","index":6,"n_rows":44,"n_cols":8,"rows_kept":44}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[]
[null,"SABS ","SECTION HA : STRUCTURAL "]
[null,"1200 HA","                    STEELWORK"]
[]
["H1","8.3.1","SUPPLY AND FABRICATION"]
["H1.1 SC","8.3.1.1","Preparation and submission to the Engineer for approval of shop detail drawings. (measured under Work Packages)","t",{"v":11.511500000000003,"d":"11.5"},{"v":0,"d":"0.00"}]
[]
["H2",null,"Supply and fabrication of steelwork"]
[null,null,"A.  Hot rolled steel"]
[null,null,"(a)  PFC Sections for platforms"]
["H2.1 SC",null,"1. 230 x 90 mm  (measured under Work Packages)","t",{"v":11.511500000000003,"d":"11.5"},{"v":0,"d":"0.00"}]
["H2.2",null,"Trial assembly of platforms (measured under Work Packages)","No",{"v":8,"d":"8.0"},{"v":0,"d":"0.00"}]
[]
["H3","8.3.2","DELIVERY"]
["H3.1 SC","8.3.2.1","Delivery of steelwork to site of all items under 8.3.1 above (measured under Work Packages)","t",{"v":11.511500000000003,"d":"11.5"},{"v":0,"d":"0.00"}]
[]
["H4","8.3.3","ERECTION"]
["H4.1 SC",null,"Offloading of steel, stacking on site, and erection of steelwork of all items under 8.3.1 above (measured under Work Packages)","t",{"v":11.511500000000003,"d":"11.5"},{"v":0,"d":"0.00"}]
[]
["H5","8.3.4","ERECTION BOLTS"]
[null,null,"Supply, deliver and storage of bolts, washer and nuts as indicated on drawing 1440a/WA/DET09"]
["H5.1 SC",null,"(a) M16 (measured under Work Packages)","t",{"v":1.1511500000000003,"d":"1.2"},{"v":0,"d":"0.00"}]
[]
["H6","8.3.7","HANDRAILS"]
[null,null,"Handrails assembly complete as per drawing 1440a/WA/DET09"]
["H6.1 SC",null,"a) Horisontal (measured under Work Packages)","m",{"v":63.36000000000001,"d":"63"},{"v":0,"d":"0.00"}]
["H6.2 SC",null,"b) Sloping on stairs at 45 deg angle (measured under Work Packages)","m",{"v":66.352,"d":"66"},{"v":0,"d":"0.00"}]
[]
["H7","8.3.8","LADDERS"]
["H7.1 SC",null,"Supply and install Hot dip galvanized mild steel Catladders as detailed on drawing 1440aWA/DET03 (measured under Work Packages)","m",{"v":26.664000000000005,"d":"27"},{"v":0,"d":"0.00"}]
[]
["H8","8.3.9","FLOORING"]
["H8.1 SC",null,"Hot dip galvanized open grid flooring complete and installed with frames for floors and stairs  (measured under Work Packages)","m²",{"v":174.68000000000004,"d":"175"},{"v":0,"d":"0.00"}]
[]
["H9","8.3.10","NON-DESTRUCTIVE TESTING"]
["H9.1 SC",null,"Testing of welding as indicated by the engineer including supply of test certificates. (measured under Work Packages)","No.",120,{"v":0,"d":"0.00"}]
[]
["H10","8.3.12","SECURITY DOOR"]
["H10.1 SC",null,"Supply and Install \"TDL\" type door from STRONG DOOR or similar approved. (measured under Work Packages)","No",2,{"v":0,"d":"0.00"}]
[]
[]
[null,"TOTAL FOR SECTION HA CARRIED TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"HC","index":7,"n_rows":61,"n_cols":8,"rows_kept":61}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE","AMOUNT"]
[]
[null,"SABS 1200 HC","SECTION HC: CORROSION PROTECTION OF STRUCTURAL  STEELWORK"]
[]
["HC1","8.2.3        ","SURFACE PREPARATION AND COATING APPLICATION"]
[null,null,"Shopwork:"]
["HC1.1",null,"Surface preparation (acid bath) and cleaning","t",{"v":11.511500000000003,"d":"11.5"},{"v":2500,"d":"2,500.00"}]
["HC1.2",null,"Hot dip Galvanzied coating","t",{"v":11.511500000000003,"d":"11.5"},{"v":7500,"d":"7,500.00"}]
{"$rows_empty":51}
[null,"TOTAL FOR SECTION HC CARRIED TO SUMMARY",{"$nulls":3},"R"]

{"sheet":"L","index":8,"n_rows":157,"n_cols":8,"rows_kept":157}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[]
[null,"SABS     1200 L","SECTION L: WATER MAINS"]
[]
["L1","8.2.2","PIPE LINE"]
[null,null,"Supplying, laying, and jointing of water pipes SAW to API 5L Grade X42, 6mm thick with 6mm CML and Rigid Polyurethane coating."]
[null,"","(a) 650mm Steel"," m",{"v":1100,"d":"1,100"},{"v":4100,"d":"4,100.00"}]
[null,null,"(b) 550mm Steel","m",30,{"v":3550,"d":"3,550.00"}]
[null,null,"(c) 450mm  Steel"," m",30,{"v":2541.715976331361,"d":"2,541.72"}]
[null,null,"(d) 200mm  Steel","m",7,{"v":525.1479289940828,"d":"525.15"}]
[]
["L2",null,"Supplying, laying, and jointing of water pipes, Grade 316 Stainless Steel, according to SABS719, irrespective of depth. "]
[null,null,"(a) 650mm Stainless Steel","m",42,{"v":40800,"d":"40,800.00"}]
[null,null,"(b) 550mm Stainless Steel","m",36,{"v":29211.834319526628,"d":"29,211.83"}]
[null,null,"(c) 250mm Stainless Steel","m",48,{"v":6035.502958579881,"d":"6,035.50"}]
[null,null,"(d) 200mm Stainless Steel","m",36,{"v":3862.721893491125,"d":"3,862.72"}]
[]
["L3",null,"CONNECTION INTO EXISTING"]
[null,null,"Connection to existing pipeline complete as shown on drawings including excavation and all specials"]
["L3.1",null,"Connection to existing pipe junctions including excavation and making good.","No",2,{"v":25000,"d":"25,000.00"}]
["L3.2",null,"Connection to existing pipe junction at Reservoir site including excavation, breaking through walls and making good.","No",1,{"v":250000,"d":"250,000.00"}]
[]
["L4",null,"Bends"]
[null,null,"(a) Item 1.1: S.S 90 deg 650mm dia ","No",2,{"v":28560,"d":"28,560.00"}]
[null,null,"(b) Item 1.2: S.S 45 deg 650mm dia","No",2,{"v":28560,"d":"28,560.00"}]
[null,null,"(c) Item 1.3: S.S 43.5 deg 550mm dia  ","No",1,{"v":20448.28402366864,"d":"20,448.28"}]
[null,null,"(d) Item 1.4: S.S 90 deg 550mm dia ","No",1,{"v":20448.28402366864,"d":"20,448.28"}]
[null,null,"(e) Item 1.5: S.S. 45 deg 250mm dia ","No",2,{"v":14640.48737789293,"d":"14,640.49"}]
[null,null,"(f) Item 1.6: S.S. 90 deg 250mm dia ","No",2,{"v":14640.48737789293,"d":"14,640.49"}]
[null,null,"(g) Item 1.8: S.S. 45 deg 200mm dia","No",4,{"v":9369.911921851477,"d":"9,369.91"}]
[null,null,"(h) Item 1.9 M.S. 90 deg 650mm dia fully flanged ","No",1,{"v":5616,"d":"5,616.00"}]
[null,null," ","No",2,{"v":6240,"d":"6,240.00"}]
[null,null,"(j) Item 1.11: M.S. 55 deg 550mm dia bevel edged bend","No",1,{"v":5616,"d":"5,616.00"}]
[null,null,"(k) Item 1.12: M.S. 90 deg 250mm dia Bevel edged bend","No",1,{"v":1194.2148760330579,"d":"1,194.21"}]
[]
["L5",null,"Valves"]
[null,null,"(a) Item 2.1: 200mm dia, cast iron, gate valve (See SANS1123 Table 1600)","No",1,{"v":40000,"d":"40,000.00"}]
[null,null,"(b) Item 2.2: 400mm dia, cast iron, gate valve (See SANS1123 Table 1600)","No",9,{"v":79524.72,"d":"79,524.72"}]
[null,null,"(c) Item 2.3: 400mm dia, cast iron, Combination control Valve","No",1,{"v":1080000,"d":"1,080,000.00"}]
[null,null,"(d) Item 2.4: 250mm dia, cast iron, Combination control Valve","No",6,{"v":675000,"d":"675,000.00"}]
[null,null,"(e) Item 2.5: 250mm dia, cast iron, NRV","No",3,{"v":49702.95,"d":"49,702.95"}]
[]
["L6",null,"Cut Lengths"]
["L6.1",null,"Item 4.1: SS 650mm dia pipe (l=2000) One End Flanged.","No",2,{"v":7500,"d":"7,500.00"}]
[]
[]
[null,null,"TOTAL CARRIED FORWARD",{"$nulls":3},"R"]
[null,null,"TOTAL BROUGHT FORWARD",{"$nulls":3},"R"]
[]
["L6.2",null,"Item 4.2: SS 650mm dia pipe (l=6000) Flanged Both Ends","No",4,{"v":15000,"d":"15,000.00"}]
["L6.3",null,"Item 4.3: SS 650mm dia pipe (l=1260) No Flanges","No",1,{"v":2500,"d":"2,500.00"}]
["L6.4",null,"Item 4.4: SS 650mm dia pipe (l=400) Flange one end","No",1,{"v":7500,"d":"7,500.00"}]
["L6.5",null,"Item 4.5: SS 650mm dia pipe (l=2075) One End Flanged","No",1,{"v":7500,"d":"7,500.00"}]
["L6.6",null,"Item 4.6: SS 650mm dia pipe (l=2520) One End Flanged","No",1,{"v":7500,"d":"7,500.00"}]
["L6.7",null,"Item 4.7: SS 550mm dia pipe (l=300) One End Flanged","No",1,{"v":7500,"d":"7,500.00"}]
["L6.8",null,"Item 4.8: SS 550mm dia pipe (l=6000) Flanged Both Ends","No",4,{"v":12000,"d":"12,000.00"}]
["L6.9",null,"Item 4.9: SS 550mm dia pipe (l=2660) One End Flanged","No",1,{"v":6000,"d":"6,000.00"}]
["L6.10",null,"Item 4.10: SS 550mm dia pipe (l=1350) Flanged One End","No",1,{"v":6000,"d":"6,000.00"}]
["L6.11",null,"Item 4.11: SS 750mm dia pipe (l=300) No Flanges","No",1,{"v":25000,"d":"25,000.00"}]
["L6.12",null,"Item 4.12: SS 250mm dia pipe (l=350) One End Flanged","No",1,{"v":1000,"d":"1,000.00"}]
["L6.13",null,"Item 4.13: SS 250mm dia pipe (l=6000) Flanged Both Ends","No",3,{"v":3500,"d":"3,500.00"}]
["L6.14",null,"Item 4.14: SS 250mm dia pipe (l=2260) One End Flanged","No",1,{"v":2000,"d":"2,000.00"}]
["L6.15",null,"Item 4.15: SS 250mm dia pipe (l=350) One end flanged","No",1,{"v":2000,"d":"2,000.00"}]
["L6.16",null,"Item 4.16: SS 250mm dia pipe (l=3900) One End Flanged","No",1,{"v":3500,"d":"3,500.00"}]
["L6.17",null,"Item 4.17: SS 250mm dia pipe (l=980) One End Flanged ","No",1,{"v":2500,"d":"2,500.00"}]
["L6.18",null,"Item 4.18: SS 200mm dia pipe (l=300) One End Flanged","No",3,{"v":1250,"d":"1,250.00"}]
["L6.19",null,"Item 4.19: SS 200mm dia pipe (l=415) Flanged Both Ends","No",1,{"v":1500,"d":"1,500.00"}]
["L6.20",null,"Item 4.20: SS 200mm dia pipe (l=6000) Both Ends Flanged","No",3,{"v":9530,"d":"9,530.00"}]
["L6.21",null,"Item 4.21: SS 200mm dia pipe (l=1875) Flanged Both Ends","No",1,{"v":2750,"d":"2,750.00"}]
["L6.22",null,"Item 4.22: SS 200mm dia pipe (l=350) One End Flanged ","No",1,{"v":1250,"d":"1,250.00"}]
["L6.23",null,"Item 4.26: MS 650mm dia pipe (l=19100) One End Flanged, one edge bevelled","No",1,{"v":112320,"d":"112,320.00"}]
["L6.24",null,"Item 4.27: MS 650mm dia pipe (l=1744) Bevel edged","No",1,{"v":2750,"d":"2,750.00"}]
["L6.25",null,"Item 4.28: MS 650mm dia pipe (l=510) One end Flanged other bevelled","No",1,{"v":1800,"d":"1,800.00"}]
["L6.26",null,"Item 4.29: MS 400mm dia pipe (l=500) bevel edged","No",1,{"v":2250,"d":"2,250.00"}]
["L6.27",null,"Item 4.30: MS 550mm dia pipe (l=10910) Flanged Both Ends","No",1,{"v":56160,"d":"56,160.00"}]
["L6.28",null,"Item 4.31: MS 550mm dia pipe (l=4481) Flanged Both Ends","No",1,{"v":1000,"d":"1,000.00"}]
["L6.29",null,"Item 4.32: SS 250mm dia pipe (l=495) Flanged One End","No",1,{"v":3474.9,"d":"3,474.90"}]
[]
[]
[null,null,"TOTAL CARRIED FORWARD",{"$nulls":3},"R"]
[null,null,"TOTAL BROUGHT FORWARD",{"$nulls":3},"R"]
[]
["L6.29",null,"Item 4.33: MS 550mm dia pipe (l=586) Both ends flanged","No",1,{"v":900,"d":"900.00"}]
["L6.30",null,"Item 4.34: MS 550mm dia pipe (l=2187) One end Flanged","No",1,{"v":2150,"d":"2,150.00"}]
["L6.31",null,"Item 4.35: MS 550mm dia pipe (l=12631) Bevelled edges","No",1,{"v":15500,"d":"15,500.00"}]
["L6.32",null,"Item 4.36: MS 400mm dia pipe (l=3955) Both ends flanged","No",1,{"v":7580,"d":"7,580.00"}]
["L6.33",null,"Item 4.37: MS 400mm dia pipe (l=2293) Both ends flanged","No",1,{"v":4850,"d":"4,850.00"}]
["L6.34",null,"Item 4.38: MS 350mm dia pipe (l=4895) Both ends flanged","No",1,{"v":5200,"d":"5,200.00"}]
["L6.35",null,"Item 4.39: MS 250mm dia pipe (l=958) Both ends flanged","No",1,{"v":1200,"d":"1,200.00"}]
["L6.36",null,"Item 4.40: MS 250mm dia pipe (l=1053) Both ends flanged","No",1,{"v":1250,"d":"1,250.00"}]
["L6.37",null,"Item 4.41: MS 250mm dia pipe (l=2508) Both ends flanged","No",1,{"v":2650,"d":"2,650.00"}]
["L6.38",null,"Item 4.42: MS 250mm dia pipe (l=1377) Both ends flanged","No",1,{"v":1450,"d":"1,450.00"}]
["L6.39",null,"Item 4.43: MS 250mm dia pipe (l=150) Both ends flanged","No",3,{"v":750,"d":"750.00"}]
[]
["L5",null,"Reducers"]
["L5.1",null,"Item 5.1: SS 1000 x 750mm dia Eccentric reducer","No",1,{"v":17500,"d":"17,500.00"}]
["L5.2",null,"Item 5.2: SS 750 x 500mm dia Eccentric reducer","No",1,{"v":15250,"d":"15,250.00"}]
["L5.3",null,"Item 5.3: SS 500 x 300mm dia Eccentric reducer","No",1,{"v":12300,"d":"12,300.00"}]
["L5.4",null,"Item 5.4: SS 300 x 250mm dia Eccentric reducer","No",1,{"v":9750,"d":"9,750.00"}]
["L5.5",null,"Item 5.5: MS 650 x 400mm dia Concentric reducer","No",3,{"v":13000,"d":"13,000.00"}]
["L5.6",null,"Item 5.6: MS 550 x 400mm dia Concentric reducer","No",7,{"v":9600,"d":"9,600.00"}]
["L5.7",null,"Item 5.7: MS 400 x 350mm dia Concentric reducer","No",1,{"v":7250,"d":"7,250.00"}]
["L5.8",null,"Item 5.8: MS 400 x 250mm dia Concentric reducer","No",1,{"v":6500,"d":"6,500.00"}]
["L5.9",null,"Item 5.9: MS 350 x 250mm dia Concentric reducer","No",1,{"v":5500,"d":"5,500.00"}]
[]
["L6",null,"General"]
["L6.1",null,"Item 1.7: SS 250mm by 200mm Reducing Tee","No",1,{"v":3000,"d":"3,000.00"}]
["L6.2",null,"Item 3.1: SS 650mm dia pipe (l=1255) with puddle flange","No",1,{"v":3000,"d":"3,000.00"}]
["L6.3",null,"Item 3.2: SS 650mm dia pipe (l=1085), one end flanged with puddle flange","No",1,{"v":3000,"d":"3,000.00"}]
[null,null,"Item 3.3: SS 250mm dia pipe (l=995), Paddle flange only","No",1,{"v":2500,"d":"2,500.00"}]
["L6.4",null,"Item 3.4: SS 200mm dia pipe (l=1000), One end flanged with paddle flange","No",1,{"v":2500,"d":"2,500.00"}]
["L6.7",null,"Item 3.9: MS 650mm dia pipe (l=1045) fully flanged with puddle flange","No",3,{"v":7500,"d":"7,500.00"}]
["L6.8",null,"Item 3.10: MS 550mm dia pipe (l=1655) fully flanged with puddle flange","No",2,{"v":2750,"d":"2,750.00"}]
["L6.9",null,"Item 3.11: MS 400mm dia Equal tee, fuly flanged with 505mm spool piece","No",4,{"v":12500,"d":"12,500.00"}]
[null,null,"TOTAL CARRIED FORWARD",{"$nulls":3},"R"]
[null,null,"TOTAL BROUGHT FORWARD",{"$nulls":3},"R"]
[]
["L6.10",null,"Item 3.12 MS 650mm dia S-Bend pipe both ends flanged","No",1,{"v":12500,"d":"12,500.00"}]
["L6.11",null,"Item 3.13 MS 550mm dia S-Bend pipe both ends flanged","No",1,{"v":12500,"d":"12,500.00"}]
["L6.12",null,"Item 3.14 MS 650mm Blind flange","No",1,{"v":2500,"d":"2,500.00"}]
["L6.13",null,"Item 3.15: MS 550mm dia pipe (l=1045) fully flanged with puddle flange","No",3,{"v":12500,"d":"12,500.00"}]
["L6.14",null,"Item 3.16: MS 550 x 300mm dia tee with 300mm spool piece fully flanged","No",1,{"v":10300,"d":"10,300.00"}]
["L6.15",null,"Item 3.17: MS 550mm Blind flange","No",2,{"v":8750,"d":"8,750.00"}]
["L6.16",null,"Item 3.18: MS 300mm Blind flange","No",1,{"v":6275,"d":"6,275.00"}]
["L6.17",null,"Item 3.19: MS 650mm dia 37.65 deg long radius bend with spool piece fully flanged","No",1,{"v":11250,"d":"11,250.00"}]
["L6.18",null,"Item 3.20: MS 500mm dia Tee with 505 spool piece fully flanged","No",2,{"v":8900,"d":"8,900.00"}]
["L6.19",null,"Item 3.21: MS 400mm dia Tee with 505 spool piece fully flanged","No",2,{"v":6500,"d":"6,500.00"}]
["L6.20",null,"Item 3.22: MS 250mm dia Tee with 505 spool piece fully flanged","No",1,{"v":3500,"d":"3,500.00"}]
["L6.21",null,"Item 3.23: MS 400mm dia Sweeping Tee with 505 spool piece fully flanged","No",3,{"v":15000,"d":"15,000.00"}]
[]
["L7",null,"Expansion Joints"]
["L7.1",null,"Item 6.1: SS 650mm dia Expansion Joint","No",1,{"v":47745,"d":"47,745.00"}]
["L7.2",null,"Item 6.2: SS 550mm dia Expansion Joint","No",1,{"v":38580,"d":"38,580.00"}]
["L7.3",null,"Item 6.3: SS 250mm dia Expansion Joint","No",1,{"v":17002.5,"d":"17,002.50"}]
[]
["L8",null,"Supply, install and commission Pumps"]
["L8.1",null,"KSB SA OMEGA 250-480A (423 impeller) with a WEG 250kW 380v 355 M/L 4p motor or similar approved including base plate, supply and delivery pipe modifications to ensure fit, capable of following duty: 275l/s at 51.5m with range from 43.5 to 57 ","Item",3,{"v":727276.55,"d":"727,276.55"}]
["L8.2",null,"Provisional sum to change pipe work to suit selected pump in and outlets","Sum",1,{"v":300000,"d":"300,000.00"}]
["L8.3",null,"Provisional sum MCC and electrical controls","Sum",1,{"v":2106650,"d":"2,106,650.00"}]
["L8.4",null,"Provisional sum for lighting, socket outlets, cables, earthing and bonding, ups and lightning protection.","Sum",1,{"v":392600,"d":"392,600.00"}]
[]
["L9",null,"Pipeline route markers"]
["L9.1","PSL 8.2.18","Route markers are to be constructed with a 100mm pvc sleeve filled with 20MPa concrete, as per drawing 1440b/WA/Lay01RR & 02RR","No",10,{"v":1500,"d":"1,500.00"}]
[]
["L10","PL GD","Standby Generator"]
["L10.1",null,"Design and other documentation","Item",1,{"v":20000,"d":"20,000.00"}]
["L10.2",null,"Procurement/Fabrication/Installation, Testing and delivery","Item",1,{"v":700000,"d":"700,000.00"}]
["L10.3",null,"Installation/Testing and comssioning","Item",1,{"v":80000,"d":"80,000.00"}]
{"$rows_empty":7}
[null,"TOTAL FOR SECTION L CARRIED FORWARD TO SUMMARY",{"$nulls":4},"R"]

{"sheet":"LB","index":9,"n_rows":58,"n_cols":8,"rows_kept":58}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE","AMOUNT"]
[]
[null,"SABS     1200 LB","SECTION LB: BEDDING FOR PIPES"]
["","","",""]
["LB1","8.2.1","PROVISION OF BEDDING"]
[null,null,"Available from trench excavation without the need for screening or treatment:"]
[null,null,"Steel pipes (non flexible pipe bedding)"]
["LB1.1",null,"(a) Selected granular material","m³",326,{"v":100,"d":"100.00"}]
["LB1.2",null,"(b) Selected fill material","m³",975,{"v":100,"d":"100.00"}]
[]
[null,null,"Including screening and/or other treatment:"]
[null,null,"Steel pipes (non flexible pipe bedding)"]
["LB1.3",null,"(a) Selected granular material","m³",66,{"v":350,"d":"350.00"}]
["LB1.4",null,"(b) Selected fill material","m³",195,{"v":350,"d":"350.00"}]
[]
["LB2","8.2.2","Supply of imported bedding material from:"]
[null,"8.2.2.2 & 8.2.2.3","Borrow pits or commercial sources (Provisional)"]
["LB2.1",null,"(a) Selected granular material","m³",{"v":32.6,"d":"33"},{"v":400,"d":"400.00"}]
["LB2.2",null,"(b) Selected fill material","m³",{"v":97.5,"d":"98"},{"v":400,"d":"400.00"}]
[]
["LB2.3",null,"Supply and place 6-20 mm graded stone as directed by the Engineer","m³",75,{"v":450,"d":"450.00"}]
[]
["LB2.4","PSLB 8.2.6","Extra over items 8.2.1 and 8.2.2 for bedding stabilized with 5% cement","m³",15,{"v":0,"d":"0.00"}]
{"$rows_empty":33}
[null,"TOTAL FOR SECTION LB CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"ME","index":10,"n_rows":62,"n_cols":8,"rows_kept":62}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE","AMOUNT"]
[]
[null,"SABS     1200 ME","SECTION ME: SUBBASE"]
[]
["ME1","8.3.2","SUBBASE"]
["ME1.1 SC",null,"Construct gravel subbase with material from commercial source and compact to 97% Mod AASHTO for paved areas (measured under Work Packages)","m³",{"v":130,"d":"130.00"},781.25]
[]
["ME2","8.3.5","Process material by means of:"]
["ME2.1 SC",null,"(a) Stabilization (measured under Work Packages)","m³",{"v":130,"d":"130.00"},{"v":0,"d":"0.00"}]
[]
["ME3","8.3.8","STABILIZING AGENT"]
["ME3.1 SC",null,"Portland cement (measured under Work Packages)","t",11.96,{"v":0,"d":"0.00"}]
{"$rows_empty":48}
[null,"TOTAL FOR SECTION ME CARRIED TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"LD","index":11,"n_rows":53,"n_cols":8,"rows_kept":53}
[]
["ITEM NO","PAYMENT REFERS","SHORT  DESCRIPTION","UNIT","TENDER","RATE","ADJUSTED RATE","AMOUNT"]
[]
[null,"SANS     1200 LD","SECTION LD : SEWERS"]
[]
["LD1",null,"PIPE WORK"]
[null,null,"Supply, handle, lay, join (butt-fusion) bed in specified class, test and disinfect HDPE pipe PE100, PN12,5, SDR 13,6 (SANS 4427):"]
["LD1.1 SC",null,"(a)  110 mm dia (measured under Work Packages)","m",{"v":157.3,"d":"157"},{"v":0,"d":"0.00"}]
[]
["LD2","8.2.3","MANHOLES"]
[null,null,"Manholes (1000mm inside diameter) to complete with concrete cover and frame, for depths :"]
[null,null,"Over and up to :"]
["LD2.1 SC",null,"(a)    3.0 m        4,0 m (measured under Work Packages)","No",4,{"v":0,"d":"0.00"}]
[]
["LD2.2 SC",null,"Extra-over items LD2.1 to LD2.3 for \"Heavy Duty\" cover and frame in road areas (measured under Work Packages)","No",4,{"v":0,"d":"0.00"}]
[]
["LD2.3 SC","8.2.7","Encasing 110mm dia pipes in 15 MPA concrete (measured under Work Packages)","m³",{"v":6.25,"d":"6"},{"v":0,"d":"0.00"}]
[]
["LD2.4 SC","8.2.11","Break into existing manhole, connect new network and make good (measured under Work Packages)","No",1,{"v":0,"d":"0.00"}]
{"$rows_empty":33}
[null,"TOTAL FOR SECTION LD CARRIED TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"LG","index":12,"n_rows":48,"n_cols":7,"rows_kept":48,"merged":[[46,2,48,4],[46,6,48,6]]}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","ADJUSTED RATE ","AMOUNT"]
[null,"SANS 1200LG","SECTION LG: PIPE JACKING"]
[null,null,"PIPE JACKING AT ROAD CROSSINGS"]
["LG1","8.2.1","Jacking Establishment for 2 positions:"]
["LG1.1",null,"Fixed charges","Sum",2]
["LG1.2",null,"Time related charges","Sum",2]
[]
["LG2","8.2.2","Supply and delivery of pipes to be jacked:"]
["LG2.1",null,"900 mm ø Class 100-D with In-the-wall rubber ring joint.","m",55]
[]
["LG3","8.2.3","Jacking of pipes:"]
["LG3.1",null,"900 mm ø  Class 100-D with In-the-wall rubber ring joint.","m",55]
[]
["LG4","8.2.4","Excavation for jacking using hand held pneumatic tools:"]
["LG4.1",null,"Soft excavation-with clay spade attachments","m3",53]
["LG4.2",null,"Intermediate","m3",{"v":13.25,"d":"13"}]
["LG4.3",null,"Extra over LG4.1 for unforseen rock or boulders in the Jacking pit","m3",{"v":13.25,"d":"13"}]
[]
["LG6","8.2.9","Stabilization of unstable areas and grouting of voids where necessary"]
["LG6.1",null,"Provision and establishment of equipment on site and removal on completion","No",2]
["LG6.2",null,"Operation of equipment","Day",2]
["LG6.3",null,"Material used based on 10:1 sand cement mix","m3",{"v":32.92424119585697,"d":"33"}]
{"$rows_empty":23}
[null,null,"TOTAL FOR SECTION LG CARRIED TO SUMMARY"]
[{"$nulls":5},"R"]

{"sheet":"MJ","index":13,"n_rows":59,"n_cols":8,"rows_kept":59,"merged":[[58,1,58,4]]}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[]
[null,null,"SECTION MJ : SEGMENTED PAVING"]
[]
["MJ1",null,"CONSTRUCT PRECAST CONCRETE SEGMENTED PAVING"]
["MJ1.1 SC","PSMJ 8.2.2","Provide and construct segmented paving lain in Herringbone pattern 60 mm thick, 25 Mpa Type S-A concrete paving blocks.  Price must include bedding, sand layer, compaction and finishing (Colour to suit Client) (measured under Work Packages)","m²",{"v":738.1,"d":"738"},{"v":0,"d":"0.00"}]
[{"$nulls":5}," "]
["MJ1.2 SC","8.2.3","Cut units to fit edge restraints (measured under Work Packages)","m",258,{"v":0,"d":"0.00"}]
[]
["MJ1.3 SC","8.2.4","Roll to Locked-up Condition as Specified in clause 5.6.2 (provisional) (measured under Work Packages)","m²",{"v":738.1,"d":"738"},{"v":0,"d":"0.00"}]
{"$rows_empty":42}
[{"$nulls":5}," ",null," "]
[]
[]
[]
[]
[null,"TOTAL FOR SECTION MJ CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"MK","index":14,"n_rows":55,"n_cols":8,"rows_kept":55,"merged":[[54,1,54,4]]}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE","AMOUNT"]
[]
[null,null,"SECTION MK : KERBING AND CHANNELLING"]
[]
["MK1 SC","8.2.1","CONCRETE KERBING"]
[null,null,"Figure 8 b precast kerbs for new construction"]
["MK1.1 SC",null,"Radius over 20m (measured under Work Packages)","m",215,{"v":0,"d":"0.00"}]
["MK1.2 SC",null,"Radius less than 20m (measured under Work Packages)","m",43,{"v":0,"d":"0.00"}]
[]
["MK1.3 SC",null,"Figure 13 precast edge beam for new construction (measured under Work Packages)","m",258,{"v":0,"d":"0.00"}]
[]
["MK2 SC",null,"TRANSITIONS"]
[null,null,"From mountable kerb to vertical kerb (measured under Work Packages)","No",2,{"v":0,"d":"0.00"}]
[]
["MK3 SC",null,"TRIMMING"]
[null,null,"Trimming of excavations for mountable kerbs :"]
[null,null,"(a)  Soft (measured under Work Packages)","m²",60,{"v":0,"d":"0.00"}]
[null,null,"(b)  Intermediate (measured under Work Packages)","m²",10,{"v":0,"d":"0.00"}]
{"$rows_empty":35}
[null,"TOTAL FOR SECTION MK CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"PLB","index":15,"n_rows":48,"n_cols":8,"rows_kept":48}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[]
[null,"PART SPEC PLB","SECTION PB: MISCELLANEOUS WORK FOR TANKS"]
[]
["PLB1","PLB 8.1","STERILIZATION"]
["PLB1.1",null,"Reservoir and internal pipes","Sum",1,{"v":120000,"d":"120,000.00"}]
["PB1.2",null,"Supply pipeline","Sum",1,{"v":50000,"d":"50,000.00"}]
[]
["PB2","PLB 8.2","WATER TIGHTNESS"]
["PB2.1",null,"Test for reservoir and pipes for water tightness","Sum",1,{"v":80000,"d":"80,000.00"}]
[]
["PB3",null,"PROTECTION SYSTEMS"]
["PB3.2",null,"Aircraft warning light","Prov. Sum",1,{"v":90000,"d":"90,000.00"},{"v":112500,"d":"112,500.00"},{"$f":"G14","v":{"v":112500,"d":"112,500.00"}}]
["PLB3.3",null,"CP and DC Mitigation - Professional services and Installation","Prov. Sum",1,{"v":2280000,"d":"2,280,000.00"},{"v":2850000,"d":"2,850,000.00"},{"$f":"G15","v":{"v":2850000,"d":"2,850,000.00"}}]
["PLB3.4",null,"Contractors mark-up on PB3.3 above","%",{"$f":"G15","v":{"v":2850000,"d":"2,850,000"}},{"v":0.1,"d":"10%"}]
[]
["PLB4","PGENR B1","FENCING"]
["PLB4.1 SC",null,"2.4m high concrete fence as per drawing 1440a/WT/DET08RR (measured under Work Packages)","m",302,{"v":2500,"d":"2,500.00"}]
["PLB4.2 SC","PGENR B1","Supply and install double sliding gate to match security fencing as per drawing 1440a/WT/DET08RR (measured under Work Packages)","No",1,{"v":45000,"d":"45,000.00"}]
[]
["PLB5",null,"GUARD HOUSE"]
["PLB5.1 SC","PSTRU E","Construct guard house complete as per drawing 1440a/WT/DET06RR (measured under Work Packages)","Sum",1,{"v":700000,"d":"700,000.00"}]
[]
["PLB6",null,"VALVE ROOM"]
["PLB6.1 SC","PSTRU E","Construct Valve Room as per drawing 1440a/WT/DET07RR (measured under Work Packages)","Sum",1,{"v":750200.0000000001,"d":"750,200.00"}]
["PLB6.2 SC",null,"Supply and Install overhead Gantry beams complete with 3 ton Block and Tackle (measured under Work Packages)","Sum",1,{"v":75000,"d":"75,000.00"}]
[]
["PLB7",null,"GENERATOR ROOM"]
["PLB7.1 SC","PSTRU E","Modify existing Pump station to accommodate new generator (measured under Work Packages)","Prov. Sum",1,{"v":125000,"d":"125,000.00"},{"v":125000,"d":"125,000.00"},{"$f":"G30","v":{"v":125000,"d":"125,000.00"}}]
{"$rows_empty":17}
[null,"TOTAL FOR SECTION PLB CARRIED TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"PLG","index":16,"n_rows":106,"n_cols":8,"rows_kept":106}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","ADJUSTED RATE ","AMOUNT"]
[]
[null,"PART SPEC PL G","SECTION PLG: ELECTRICAL WORKS"]
["PLG1",null,"LV Network and power supplies"]
["PLG1.1 SC",null,"Provisional amount for a 40A, Single phase ESKOM connection fee to the tower site in a position to be indicated on site. (measured under Work Packages)","P. Sum",1,{"v":0,"d":"0.00"},{"v":43750,"d":"43,750.00"},{"$f":"G6","v":{"v":43750,"d":"43,750.00"}}]
["PLG1.2 SC",null,"Contractor's overhead, surcharge and profit on item PA1.1 (measured under Work Packages)","%",{"$f":"G6","v":{"v":43750,"d":"43,750"}},{"v":0,"d":"0%"}]
["PLG1.3 SC",null,"Supply and install a single phase metering kisok to Eskom specification complete with meter and circuit breaker (measured under Work Packages)","No",1,{"v":0,"d":"0.00"}]
[]
["PLG2",null,"Conduit and Wiring"]
["PLG2.1 SC",null,"Conduit installed in ceiling void, masonry walls, floors, etc complete with all fixing accessories, couplings, bushes, locknuts, end boxes (50 x 100mm or 100 x 100mm as the case may be), terminations and male adapters"]
[null,null,"Supply, deliver and Install"]
[null,null,"(a) 25mm Ø galvanized steel (measured under Work Packages)","m",200,{"v":0,"d":"0.00"}]
[null,null,"(b) 25mm Ø u-PVC (measured under Work Packages)","m",50,{"v":0,"d":"0.00"}]
[]
["PLG2.2 SC",null,"Supply, deliver and install insulated stranded copper conductors "]
[null,null,"(a)  4 mm² (measured under Work Packages)","m",150,0]
[null,null,"(b)  6 mm² (measured under Work Packages)","m",100,{"v":0,"d":"0.00"}]
[null,null,"(c) 16mm² 4-core PVC/SWA/PVC (measured under Work Packages)","m",50,{"v":0,"d":"0.00"}]
[]
["PLG2.3 SC",null,"Supply deliver and install insulated copper earth conductors "]
[null,null,"(a)  4 mm² (measured under Work Packages)","m",150,0]
[null,null,"(b)  6 mm² (measured under Work Packages)","m",100,0]
[null,null,"(c) 6mm² BCEW (measured under Work Packages)","m",30,0]
[]
["PA3",null,"Distribution Boards"]
["PA3.1 SC",null,"Design and manufacture new factory wired distribution board complete as per schematic diagram and specification. Delivery, offloading, installation and commissioning of new factory wired distribution board"]
[null,null,"(a) DB-Main at Guard House (measured under Work Packages)","No",1,{"v":0,"d":"0.00"}]
[null,null,"(b) Sub DB for Valve room (measured under Work Packages)","No",1,{"v":0,"d":"0.00"}]
[]
["PA4",null,"Luminaires"]
["PA4.1 SC",null,"Light fittings complete with lamps and fixing accessories with 5Amp plugs and boxes"]
[null,null,"(a) Supply, deliver and install Type 1 luminaire (2x54W Open channel) (measured under Work Packages)","No",10,{"v":0,"d":"0.00"}]
[null,null,"(b)  Supply, deliver and install Beka Dart, spotlight with 70W MH lamp (or similar approved). (measured under Work Packages)","No",8,{"v":0,"d":"0.00"}]
[]
["PA5",null,"Socket Outlets"]
["PA5.1 SC",null,"Supply, deliver and install 16A normal surface mounted outdoor water proof single socket outlet complete. (measured under Work Packages)","No",4,{"v":0,"d":"0.00"}]
["PA5.2 SC",null,"Supply, deliver and install 16A normal embedded in the wal single socket outlet complete. (measured under Work Packages)","No",6,{"v":0,"d":"0.00"}]
[]
[null,null,"TOTAL CARRIED FORWARD",null,null,"R","R"]
[null,null,"TOTAL BROUGHT FORWARD",null,null,"R","R"]
[]
["PA6 SC",null,"Light switches complete as specified"]
[null,null,"Supply, deliver and install 16A single lever one-way light switch (measured under Work Packages)","No",6,{"v":0,"d":"0.00"}]
[]
[]
[null,null,"Provisional Sum for Solar Led Flood Lightining as per below specifications","Prov sum",1,null,{"v":500000,"d":"500,000.00"},{"$f":"G47","v":{"v":500000,"d":"500,000.00"}}]
[]
[null,null,"Solar LED  High Masts Floodlights complete as per and in accordance Clause PSW1,PSW2,PSW3,PSW4,PSW5,PSW6,PSW7,PSW8 of portion C: Particular Project Specification."]
{"$rows_empty":56}
[null,"TOTAL FOR SECTION PLG CARRIED TO SUMMARY",{"$nulls":3},"R","R"]

{"sheet":"450mm Bedding","index":17,"n_rows":20,"n_cols":10,"rows_kept":20,"hidden":true}
["BEDDING QUANTITIES"]
["Class B (Concrete and vitrified clay)",{"$nulls":3},{"$f":"+(PI())","v":{"v":3.141592653589793,"d":"3.1"}}]
["Length of pipe(m)",{"$f":"Calcs!C130","v":143},"sewer"]
["Diameter(mm)",110]
["(100mm bed,300mm sa)",null,"(dia/4 bed,300mm sa)",null,"(dia/4 bed,400mm sa)",null,"(200mm bed,400mm sa)",null,"(200mm bed,500mm sa)"]
["For 0 to 400 diam",null,"For 401 to 700 diam",null,"For 701 to 800 diam",null,"For 801 to 1000 diam",null,"For 1001 to 2000 diam"]
["Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.1+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":15.057662778936695,"d":"15.1"}},"Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.75*$B$4/1000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":7.696737778936698,"d":"7.7"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.75*$B$4/1000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":10.0562377789367,"d":"10.1"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.2+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":32.5036627789367,"d":"32.5"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.2+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":32.5036627789367,"d":"32.5"}}]
["Fill Blanket(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":35.3636627789367,"d":"35.4"}},"Fill Blanket",{"$f":"+(((2*0.3+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":35.3636627789367,"d":"35.4"}},"Fill Blanket",{"$f":"+(((2*0.4+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":45.5166627789367,"d":"45.5"}},"Fill Blanket",{"$f":"+(((2*0.4+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":45.5166627789367,"d":"45.5"}},"Fill Blanket",{"$f":"+(((2*0.5+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":55.6696627789367,"d":"55.7"}}]
[]
["Class C (Steel)"]
["(100mm bed,300mm sa)",null,"(100mmbed,400mm sa)",null,"(dia/8 bed,400mm sa)",null,"(dia/8 bed,500mm sa)",null,"(200mm bed,500mm sa)"]
["For 0 to 700 diam",null,"For 701 to 800 diam",null,"For 801 to 1000 diam",null,"For 1001 to 1600 diam",null,"For 1601 to 20000 diam"]
["Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.1+$B$4/6000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":11.890927222801682,"d":"11.9"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.1+$B$4/6000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":15.275260556135018,"d":"15.3"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(7/24*$B$4/1000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":4.051548056135016,"d":"4.1"}},"Granular cradle(m3)",{"$f":"+(((2*0.5+$B$4/1000)*(7/24*$B$4/1000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":4.969131389468351,"d":"5.0"}},"Granular cradle(m3)",{"$f":"+(((2*0.5+$B$4/1000)*(0.2+$B$4/6000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":34.53259388946835,"d":"34.5"}}]
["Fill Blanket(m3)",{"$f":"+((2*0.3+$B$4/1000)*(0.3+$B$4/1000+0.1)-(PI()*($B$4/1000)^2/4))*$B$3-B13","v":{"v":38.53039833507171,"d":"38.5"}},"Fill Blanket",{"$f":"+((2*0.4+$B$4/1000)*(0.3+$B$4/1000+0.1)-(PI()*($B$4/1000)^2/4))*$B$3-D13","v":{"v":49.732065001738384,"d":"49.7"}},"Fill Blanket",{"$f":"+((2*0.4+$B$4/1000)*(0.3+1.125*$B$4/1000)-(PI()*($B$4/1000)^2/4))*$B$3-F13","v":{"v":49.73206500173838,"d":"49.7"}},"Fill Blanket",{"$f":"+((2*0.5+$B$4/1000)*(0.3+1.125*$B$4/1000)-(PI()*($B$4/1000)^2/4))*$B$3-H13","v":{"v":60.93373166840505,"d":"60.9"}},"Fill Blanket",{"$f":"+((2*0.5+$B$4/1000)*(0.3+$B$4/1000+0.2)-(PI()*($B$4/1000)^2/4))*$B$3-J13","v":{"v":60.93373166840505,"d":"60.9"}}]
[]
["Flexible Pipe"]
["(100mm bed,300mm sa)",null,"(dia/4bed,300mm sa)",null,"(dia/4 bed,400mm sa)",null,"(200 bed,400mm sa)",null,"(200mm bed,500mm sa)"]
["For 0 to 400 diam",null,"For 401 to 700 diam",null,"For 701 to 800 diam",null,"For 801 to 1000 diam",null,"For 1001 to 20000 diam"]
["Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.2+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":30.11532555787339,"d":"30.1"}},"Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.1+$B$4/4000+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":22.754400557873392,"d":"22.8"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.1+$B$4/4000+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":29.54690055787339,"d":"29.5"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.3+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":51.994325557873395,"d":"52.0"}},"Granular cradle(m3)",{"$f":"+(((2*0.5+$B$4/1000)*(0.3+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":63.720325557873394,"d":"63.7"}}]
["Fill Blanket(m3)",{"$f":"+((2*0.3+$B$4/1000)*0.2)*$B$3","v":{"v":20.305999999999997,"d":"20.3"}},"Fill Blanket",{"$f":"+((2*0.3+$B$4/1000)*0.2)*$B$3","v":{"v":20.305999999999997,"d":"20.3"}},"Fill Blanket",{"$f":"+((2*0.4+$B$4/1000)*0.2)*$B$3","v":{"v":26.026000000000003,"d":"26.0"}},"Fill Blanket",{"$f":"+((2*0.4+$B$4/1000)*0.2)*$B$3","v":{"v":26.026000000000003,"d":"26.0"}},"Fill Blanket",{"$f":"+((2*0.5+$B$4/1000)*0.2)*$B$3","v":{"v":31.746000000000006,"d":"31.7"}}]

{"sheet":"450mm Bedding (2)","index":18,"n_rows":20,"n_cols":10,"rows_kept":20,"hidden":true}
["BEDDING QUANTITIES"]
["Class B (Concrete and vitrified clay)",{"$nulls":3},{"$f":"+(PI())","v":{"v":3.141592653589793,"d":"3.1"}}]
["Length of pipe(m)",{"$f":"Calcs!C137","v":{"v":1153.9,"d":"1154"}},"all steel pipes"]
["Diameter(mm)",650]
["(100mm bed,300mm sa)",null,"(dia/4 bed,300mm sa)",null,"(dia/4 bed,400mm sa)",null,"(200mm bed,400mm sa)",null,"(200mm bed,500mm sa)"]
["For 0 to 400 diam",null,"For 401 to 700 diam",null,"For 701 to 800 diam",null,"For 801 to 1000 diam",null,"For 1001 to 2000 diam"]
["Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.1+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":421.5596387677634,"d":"421.6"}},"Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.75*$B$4/1000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":511.7080762677634,"d":"511.7"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.75*$B$4/1000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":624.2133262677634,"d":"624.2"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.2+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":686.9566387677635,"d":"687.0"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.2+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":686.9566387677635,"d":"687.0"}}]
["Fill Blanket(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":710.0346387677633,"d":"710.0"}},"Fill Blanket",{"$f":"+(((2*0.3+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":710.0346387677633,"d":"710.0"}},"Fill Blanket",{"$f":"+(((2*0.4+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":854.2721387677635,"d":"854.3"}},"Fill Blanket",{"$f":"+(((2*0.4+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":854.2721387677635,"d":"854.3"}},"Fill Blanket",{"$f":"+(((2*0.5+$B$4/1000)*(0.3+$B$4/2000))-(PI()*($B$4/1000)^2/8))*$B$3","v":{"v":998.5096387677634,"d":"998.5"}}]
[]
["Class C (Steel)"]
["(100mm bed,300mm sa)",null,"(100mmbed,400mm sa)",null,"(dia/8 bed,400mm sa)",null,"(dia/8 bed,500mm sa)",null,"(200mm bed,500mm sa)"]
["For 0 to 700 diam",null,"For 701 to 800 diam",null,"For 801 to 1000 diam",null,"For 1001 to 1600 diam",null,"For 1601 to 20000 diam"]
["Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.1+$B$4/6000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":265.71026730054837,"d":"265.7"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.1+$B$4/6000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":313.7894339672151,"d":"313.8"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(7/24*$B$4/1000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":282.4177777172151,"d":"282.4"}},"Granular cradle(m3)",{"$f":"+(((2*0.5+$B$4/1000)*(7/24*$B$4/1000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":326.16981938388165,"d":"326.2"}},"Granular cradle(m3)",{"$f":"+(((2*0.5+$B$4/1000)*(0.2+$B$4/6000))-($B$4/1000)^2*(PI()-2)/16)*$B$3","v":{"v":552.2621006338817,"d":"552.3"}}]
["Fill Blanket(m3)",{"$f":"+((2*0.3+$B$4/1000)*(0.3+$B$4/1000+0.1)-(PI()*($B$4/1000)^2/4))*$B$3-B13","v":{"v":865.8840102349784,"d":"865.9"}},"Fill Blanket",{"$f":"+((2*0.4+$B$4/1000)*(0.3+$B$4/1000+0.1)-(PI()*($B$4/1000)^2/4))*$B$3-D13","v":{"v":1060.123843568312,"d":"1060.1"}},"Fill Blanket",{"$f":"+((2*0.4+$B$4/1000)*(0.3+1.125*$B$4/1000)-(PI()*($B$4/1000)^2/4))*$B$3-F13","v":{"v":1060.123843568312,"d":"1060.1"}},"Fill Blanket",{"$f":"+((2*0.5+$B$4/1000)*(0.3+1.125*$B$4/1000)-(PI()*($B$4/1000)^2/4))*$B$3-H13","v":{"v":1254.3636769016448,"d":"1254.4"}},"Fill Blanket",{"$f":"+((2*0.5+$B$4/1000)*(0.3+$B$4/1000+0.2)-(PI()*($B$4/1000)^2/4))*$B$3-J13","v":{"v":1254.3636769016448,"d":"1254.4"}}]
[]
["Flexible Pipe"]
["(100mm bed,300mm sa)",null,"(dia/4bed,300mm sa)",null,"(dia/4 bed,400mm sa)",null,"(200 bed,400mm sa)",null,"(200mm bed,500mm sa)"]
["For 0 to 400 diam",null,"For 401 to 700 diam",null,"For 701 to 800 diam",null,"For 801 to 1000 diam",null,"For 1001 to 20000 diam"]
["Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.2+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":843.1192775355267,"d":"843.1"}},"Granular cradle(m3)",{"$f":"+(((2*0.3+$B$4/1000)*(0.1+$B$4/4000+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":933.2677150355267,"d":"933.3"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.1+$B$4/4000+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":1143.854465035527,"d":"1143.9"}},"Granular cradle(m3)",{"$f":"+(((2*0.4+$B$4/1000)*(0.3+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":1206.597777535527,"d":"1206.6"}},"Granular cradle(m3)",{"$f":"+(((2*0.5+$B$4/1000)*(0.3+$B$4/1000))-($B$4/1000)^2*(PI())/4)*$B$3","v":{"v":1425.8387775355266,"d":"1425.8"}}]
["Fill Blanket(m3)",{"$f":"+((2*0.3+$B$4/1000)*0.2)*$B$3","v":{"v":288.475,"d":"288.5"}},"Fill Blanket",{"$f":"+((2*0.3+$B$4/1000)*0.2)*$B$3","v":{"v":288.475,"d":"288.5"}},"Fill Blanket",{"$f":"+((2*0.4+$B$4/1000)*0.2)*$B$3","v":{"v":334.6310000000001,"d":"334.6"}},"Fill Blanket",{"$f":"+((2*0.4+$B$4/1000)*0.2)*$B$3","v":{"v":334.6310000000001,"d":"334.6"}},"Fill Blanket",{"$f":"+((2*0.5+$B$4/1000)*0.2)*$B$3","v":{"v":380.78700000000003,"d":"380.8"}}]

{"sheet":"Calcs","index":19,"n_rows":145,"n_cols":15,"rows_kept":145,"hidden":true,"merged":[[2,1,2,4],[13,1,13,4],[52,1,52,4],[69,1,69,4],[73,1,73,4],[89,1,89,4]]}
[null,"ITEM","QUANTITY","UNIT","DESCRIPTION",null,"Formulae"]
[{"$nulls":6},"Cylinder Volume  ","V=πr2h "]
[null,"PORTION A (Cylindrical Portion)",{"$nulls":4},"Dome Cap Volume  ",null,null,"where a = Radius",null,null,"(1/3)πh2(3r-h)",null,{"$f":"((1/3)*PI()*(C46^2)*((3*C50)-C46))-((1/3)*PI()*(C47^2)*((3*C51)-C47))","v":28.87162918557189}]
[null,"Water Tower Outer Wall Dia.",{"v":19.6,"d":"19.600"},"m","Measured from .DWG ",null,"Conical Volume ","V=1/3πh(a2+ab+b2) where a = Upper Radii and b = lower radii)"]
[null,"Water Tower Inner Wall Dia.",{"$f":"C4-(C8*2)","v":{"v":19,"d":"19.000"}},"m","Measured from .DWG ",null,"Surface Area Cone","A=π(a+b)l  where a = Upper Radii and b = lower radii)"]
[null,"Water Tower Outer Wall Radius",{"$f":"C4/2","v":{"v":9.8,"d":"9.800"}},"m",null,null,"Surface Area Dome","A=2πrh"]
[null,"Water Tower Inner Wall Radius",{"$f":"C5/2","v":{"v":9.5,"d":"9.500"}},"m",null,null,"Surface area Cylinder ","A=2πrh"]
[null,"Water Tower Wall Thickness",{"v":0.3,"d":"0.300"},"m","Measured from .DWG ",null,"Area Circle","A=πr2"]
[null,"Circumference of Water Tower Outer Wall",{"$f":"PI()*C4","v":{"v":61.57521601035995,"d":"61.575"}},"m"]
[null,"Circumference of Water Tower Inner  Wall",{"$f":"PI()*C5","v":{"v":59.690260418206066,"d":"59.690"}},"m"]
[null,"Height (Portion A Only)",{"v":5.8,"d":"5.800"},"m","Height from WL (+35.10) to 45 deg Point"]
[null,"Water Tower Wall Height",{"$f":"C11+0.4","v":{"v":6.2,"d":"6.200"}},"m","Full Height of cylindrical portion of Water Tower"]
[]
[null,"PORTION B (Conical Portion)"]
[null,"Area in Cross Section",{"v":27.4831,"d":"27.483"},"m2","Area in section obtained from the .dwg"]
[null,"Height (Portion B Only)",{"v":5.93,"d":"5.930"},"m"]
[null,"Upper Diameter",{"v":19.1,"d":"19.100"},"m"]
[null,"Lower Diameter",{"$f":"C20*2","v":{"v":7.100000000000001,"d":"7.100"}},"m"]
[null,"Upper Radius",{"$f":"C17/2","v":{"v":9.55,"d":"9.550"}},"m"]
[null,"Lower Radius",{"$f":"C19-6","v":{"v":3.5500000000000007,"d":"3.550"}},"m"]
[null,"Cone Staircase Upper Radius",{"v":3.6621,"d":"3.662"},"m","Radius from centre of staircase to Outer Wall of staircase"]
[null,"Cone Staircase Lower Radius",{"v":5.2,"d":"5.200"},"m","Radius from centre of staircase to Outer Wall of staircase"]
[null,"Cone Staircase Height",0.738,"m"]
[]
[null,"Upper Staircase Outer Dia.",{"v":3.4,"d":"3.400"},"m"]
[null,"Upper Staircase Inner Dia.",{"$f":"C25-(2*C29)","v":{"v":2.8,"d":"2.800"}},"m"]
[null,"Upper Staircase Outer Radius",{"$f":"C25/2","v":{"v":1.7,"d":"1.700"}},"m"]
[null,"Upper Staircase Inner Radius",{"$f":"C26/2","v":{"v":1.4,"d":"1.400"}},"m"]
[null,"Upper Staircase Wall Thickness",{"v":0.3,"d":"0.300"},"m"]
[null,"Circumference of Upper Staircase Outer Wall",{"$f":"PI()*C25","v":{"v":10.681415022205297,"d":"10.681"}},"m"]
[null,"Circumference of Upper Staircase Inner Wall",{"$f":"PI()*C26","v":{"v":8.79645943005142,"d":"8.796"}},"m"]
[null,"Upper Staircase Full Height",{"v":11.2,"d":"11.200"},"m","Measured from .DWG "]
[]
[null,"Conical Staircase Height",{"v":1.8,"d":"1.800"},"m"]
[]
[null,"Lower Staircase Outer Dia.",{"v":6.2,"d":"6.200"},"m"]
[null,"Lower Staircase Inner Dia.",{"$f":"C36-(2*C40)","v":{"v":5.6000000000000005,"d":"5.600"}},"m"]
[null,"Lower Staircase Outer Radius",{"$f":"C36/2","v":{"v":3.1,"d":"3.100"}},"m"]
[null,"Lower Staircase Inner Radius",{"$f":"C37/2","v":{"v":2.8000000000000003,"d":"2.800"}},"m"]
[null,"Lower Staircase Wall Thickness",{"v":0.3,"d":"0.300"},"m"]
[null,"Lower Staircase Full Height",{"v":23.13,"d":"23.130"},"m"]
[null,"Circumference of Lower Staircase Outer Wall",{"$f":"PI()*C36","v":{"v":19.477874452256717,"d":"19.478"}},"m"]
[null,"Circumference of Lower Staircase Inner Wall",{"$f":"PI()*C37","v":{"v":17.59291886010284,"d":"17.593"}},"m"]
[]
[null,"Dome Roof Thickness",{"v":0.3,"d":"0.300"},"m","Tapers from 0.300m to 0.125m"]
[null,"Dome Outer Height",{"v":2.85,"d":"2.850"},"m"]
[null,"Dome Inner Height ",{"v":2.7,"d":"2.700"},"m"]
[null,"Dome Outer Dia. ",{"$f":"C4","v":{"v":19.6,"d":"19.600"}},"m"]
[null,"Dome Inner Dia.",{"$f":"C5","v":{"v":19,"d":"19.000"}},"m"]
[null,"Dome Outer Radius",{"$f":"C48/2","v":{"v":9.8,"d":"9.800"}},"m"]
[null,"Dome Inner Radius",{"$f":"C49/2","v":{"v":9.5,"d":"9.500"}},"m"]
[]
[null,"WATER VOLUME CAPACITY"]
[null,"Portion A Water Volume",{"$f":"(PI()*C7^2*C11)-(PI()*C27^2*C11)","v":{"v":1591.8072984621049,"d":"1591.807"}},"m3","Volume of Water Tower Inner Wall - Volume of Upper Staircase Outer Wall"]
[null,"Portion B Water Volume",{"$f":"(1/3*PI()*C16*(C20^2+(C20*C19)+C19^2))-(PI()*C27^2*5.2)-(1/3*PI()*C23*(C21^2+(C21*C22)+C22^2))","v":{"v":761.9566246933955,"d":"761.957"}},"m3","Cone Volume of Portion B - Cylindrical Staircase Outer Wall of Portion B - Conical Volume of Staircse of Portion B"]
[null,"Water Tower Total WATER Volume",{"$f":"ROUNDUP(SUM(C54:C55),0)","v":{"v":2354,"d":"2354.000"}},"m3","Total Volume of Water Capacity up to WL = +35.10"]
[null,"Water Tower Total WATER Volume",{"$f":"C56*1000/1000","v":{"v":2354,"d":"2354.000"}},"kl"]
[]
[null,"Base Length",{"v":15,"d":"15.000"},"m"]
[null,"Base Width",{"v":15,"d":"15.000"},"m"]
[null,"Base Height",{"v":1.85,"d":"1.850"},"m"]
[null,"Blinding Layer Length",{"v":15.5,"d":"15.500"},"m"]
[null,"Blinding Layer Width",{"v":15.5,"d":"15.500"},"m"]
[null,"Blinding Layer thickness",{"v":0.05,"d":"0.050"},"m"]
[null,"Lower Staircase Base Diameter",{"$f":"C36","v":{"v":6.2,"d":"6.200"}},"m"]
[null,"Lower Staircase Base Radius",{"$f":"C65/2","v":{"v":3.1,"d":"3.100"}},"m"]
[null,"Lower Staircase Base Height",{"$f":"0.6","v":{"v":0.6,"d":"0.600"}},"m"]
[]
[]
[null,"BLINDING CONCRETE VOLUME"]
[null,"125mm Blinding Concrete ",{"$f":"C62*C63*C64","v":{"v":12.012500000000001,"d":"12.013"}},"m3"]
[null,"Total Blinding Concrete Volume",{"$f":"ROUNDUP(SUM(C71),0)","v":{"v":13,"d":"13.000"}},"m3"]
[]
[null,"CONCRETE VOLUME"]
[null,"Concrete Base",{"$f":"C59*C60*C61","v":{"v":416.25,"d":"416.250"}},"m3"]
[null,"Lower Staircase Base (0.6m High)",{"$f":"PI()*C66^2*C67","v":{"v":18.11442324059875,"d":"18.114"}},"m3"]
[null,"Lower Staircase Wall Volume",{"$f":"(PI()*C38^2*C41)-(PI()*C39^2*C41)","v":{"v":128.61711739723148,"d":"128.617"}},"m3","26m = Lower Staircase Height"]
[null,"Lower Staircase Platform Volume",{"$f":"(PI()*C39^2*0)","v":{"v":0,"d":"0.000"}},"m3","0.00m = Platform Thickness"]
[null,"Upper Staircase Wall Volume",{"$f":"(PI()*C27^2*C32)-(PI()*C28^2*C32)","v":{"v":32.72282907979127,"d":"32.723"}},"m3","11.2m = Upper Staircase Height"]
[null,"Upper Staircase Platform Volume",{"$f":"(PI()*C28^2*0.2)","v":{"v":1.2315043202071987,"d":"1.232"}},"m3"]
[null,"Conical Staircase Wall Volume Upper Portion",{"$f":"((1/3)*PI()*0.729*(1.831^2+(1.831*2.6)+2.6^2))-((1/3)*PI()*0.729*(1.4^2+(1.4*1.9671)+1.9671^2))","v":{"v":4.801630561004646,"d":"4.802"}},"m3","Measured from .dwg:\nHeight = 0.729m\nOuter Radii: a = 1.831m b = 2.6m\nInner  Radii: a = 1.4m b = 1.9671m"]
[null,"Conical Staircase Wall Volume Lower Portion",{"$f":"((1/3)*PI()*1.071*(3.1^2+(3.1*4.1341)+4.1341^2))-((1/3)*PI()*1.071*(1.9671^2+(1.9671*2.8)+2.8^2))","v":{"v":25.009557975850853,"d":"25.010"}},"m3","Measured from .dwg:\nHeight = 1.071m\nOuter Radii: a = 3.1m b = 4.1341m\nInner  Radii: a = 1.9671m b = 2.8m"]
[null,"Cylindrical Water Tower Wall (Portion A)",{"$f":"(PI()*C6^2*C12)-(PI()*C7^2*C12)","v":{"v":112.7768930785669,"d":"112.777"}},"m3"]
[null,"Conical Water Tower Wall (Portion B)",{"$f":"((1/3)*PI()*C16*(4.1341^2+(4.1341*C6)+C6^2))-((1/3)*PI()*C16*(3.4^2+(3.4*C7)+C7^2))","v":{"v":121.30980373887735,"d":"121.310"}},"m3","Measured from .dwg:\nHeight = 5.930m\nOuter Radii: a = 4.1341m b = 9.7m\nInner  Radii: a = 3.4m b = 9.4m"]
[null,"Dome Roof volume",{"$f":"(((PI()*C46)/6)*((3*C50^2)+C46^2))-(((PI()*C47)/6)*((3*C51^2)+C47^2))","v":{"v":49.00000966666272,"d":"49.000"}},"m3",{"$f":"((1/3)*PI()*(C46^2)*((3*C50)-C46))-((1/3)*PI()*(C47^2)*((3*C51)-C47))","v":{"v":28.87162918557189,"d":"28.872"}}]
[null,"Spiral Staircase Volume",null,"m3","TBC - Concrete or steel?"]
[{"$nulls":3},"m3"]
[null,"Total Concrete Volume",{"$f":"ROUNDUP(SUM(C75:C87),0)","v":{"v":910,"d":"910.000"}},"m3"]
[]
[null,"SURFACE AREA"]
[null,"Dome Outside",{"$f":"2*PI()*C50*C46","v":{"v":175.48936562952588,"d":"175.489"}},"m2"]
[null,"Dome Inside",{"$f":"2*PI()*C51*C47","v":{"v":161.16370312915637,"d":"161.164"}},"m2"]
[null,"Cylindrical Water Tower Wall Outside",{"$f":"2*PI()*C6*C12","v":{"v":381.7663392642317,"d":"381.766"}},"m2"]
[null,"Cylindrical Water Tower Wall Inside",{"$f":"2*PI()*C7*C12","v":{"v":370.0796145928776,"d":"370.080"}},"m2"]
[null,"Conical Water Tower Wall Outside",{"$f":"PI()*(C20+C19)*9.5009","v":{"v":391.00824511663563,"d":"391.008"}},"m2","l = 9.5009m"]
[null,"Conical Water Tower Wall Inside",{"$f":"PI()*(C7+C39)*8.4354","v":{"v":325.9572652421235,"d":"325.957"}},"m2","l = 8.4354m"]
[null,"Conical Water Tower Horizontal Lip",{"$f":"(PI()*3.4^2)-(PI()*2.6^2)","v":{"v":15.079644737231,"d":"15.080"}},"m2","Outer Radius of Lip = 3.4m; Inner Radius of Lip = 2.6m"]
[null,"Upper Staircase Outer Wall ",{"$f":"2*PI()*C27*C32","v":{"v":119.63184824869931,"d":"119.632"}},"m2"]
[null,"Upper Staircase Inner Wall",{"$f":"2*PI()*C28*C32","v":{"v":98.52034561657591,"d":"98.520"}},"m2"]
[null,"Lower Staircase Outer Wall",{"$f":"2*PI()*C38*C41","v":{"v":450.52323608069787,"d":"450.523"}},"m2"]
[null,"Lower Staircase Inner Wall",{"$f":"2*PI()*C39*C41","v":{"v":406.9242132341787,"d":"406.924"}},"m2"]
[null,"Lower Staircase Base Outer",{"$f":"2*PI()*C60*C61","v":{"v":174.35839227423352,"d":"174.358"}},"m2"]
[null,"Lower Staircase Base Top ",{"$f":"(PI()*C60^2)-(PI()*C38^2)","v":{"v":676.6676416567055,"d":"676.668"}},"m2"]
[null,"Conical Staircase Outside",{"$f":"PI()*(C27+C38)*1.2403","v":{"v":18.703283367587616,"d":"18.703"}},"m2","l = 1.2403m"]
[null,"Conical Staircase Inside",{"$f":"PI()*(C38+C28)*2.2804","v":{"v":32.238395492607744,"d":"32.238"}},"m2","l = 2.2804m"]
[null,"Lower Staircase Floor",{"$f":"PI()*C39^2","v":{"v":24.630086404143984,"d":"24.630"}},"m2"]
[null,"Total Surface Area",{"$f":"ROUNDUP(SUM(C91:C106),0)","v":{"v":3823,"d":"3823.000"}},"m2"]
[]
[]
[null,"Site Clearance - Measured from CAD",{"$f":"1.1*2050","v":2255},null,"Measrued from CAD"]
[null,"Blinding area",{"$f":"C62*C63","v":{"v":240.25,"d":"240"}}]
[null,"narrow width on dome outside",{"$f":"2*PI()*C50*1.1","v":{"v":67.73273761139595,"d":"68"}}]
[null,"Total Base excavation",{"$f":"1.1*(C59+1)*(C60+1)*(C61+C67+0.1)","v":{"v":718.0800000000002,"d":"718"}},"m3"]
[null,"Valve Chamber excavation",{"$f":"1.1*(C120+1)*(1+C121)*C124","v":{"v":492.61883000000006,"d":"493"}},"m3"]
[null,"Scour box excavation",0,"m3","On top of base"]
[]
[null,"walkway fwk on top of internal walls",{"$f":"PI()*2*2.3*0.8","v":{"v":11.561060965210437,"d":"12"}},"m2"]
[null,"Tower base wood float",{"$f":"PI()*7.5^2*1.1","v":{"v":194.38604544086846,"d":"194"}}]
[]
[null,"Valve room - Length",10.42,null,"Length"]
[null,"Width",6.13,null,"Width"]
[null,"Wall height",2.2]
[null,"Brick wall height",3.3]
[null,"Total Height",{"$f":"C123+C122","v":5.5}]
[null,"Base thickness",0.25]
[]
[null,"Guard house",3,null,"Length"]
[null,null,{"v":5.475,"d":"5.48"},null,"Width"]
[]
[null,"sewer line length",{"$f":"130*1.1","v":143},"measured on Google earth"]
[null,"Paving area",{"$f":"1.1*671","v":738.1},"measrued from C3d"]
[]
[null,"Pipe Length",{"$nulls":3},"0m-1m","1m-2m","2m-3m"]
[null,"650mm supply",{"$f":"F134+G134+H134","v":1000},null,"650mm supply",0,880,120]
[null,"400mm at reservoir",{"$f":"F135+G135+H135","v":30},null,"400mm at reservoir",null,30]
[null,"550mm ",{"$f":"F136+G136+H136","v":19},null,"550mm ",null,19]
[null,"total",{"$f":"C136*1.1+C135*1.1+C134*1.1","v":1153.9},null,"Sewer",null,null,{"$f":"C130","v":143}]
[{"$nulls":4},"Electrical from Connection to Main DB",40,null,null,"Estimated from site layout + Risk"]
[{"$nulls":4},"Telemetry sleeves",{"$f":"20","v":20},null,null,"Measrued from Site layout"]
[{"$nulls":4},"Total",{"$f":"SUM(F134:F139)","v":60},{"$f":"SUM(G134:G139)","v":929},{"$f":"SUM(H134:H139)","v":263}]
[null,"overflow/scour box",4.1,"length"]
[null,null,0.3,"base height"]
[null,null,2.075,"wall height"]
[null,null,0.2,"wall t"]
[null,null,1.4,"width"]

{"sheet":"Pipe Fittings","index":20,"n_rows":49,"n_cols":24,"rows_kept":49,"hidden":true,"merged":[[4,1,4,4],[4,6,4,8],[4,10,4,13],[4,15,4,18],[4,20,4,23]]}
[{"$nulls":7},"nrv","non return valve",{"$nulls":7},"ecc","eccentric",{"$nulls":3},"pf","puddle flange"]
[{"$nulls":16},"con","concentric",{"$nulls":3},"oef","one end flanged"]
[{"$nulls":16},"ff","fully flanged",{"$nulls":3},"bef","both ends flanged"]
[]
[null,"BENDS",{"$nulls":4},"VALVES",{"$nulls":3},"CUT LENGTHS",{"$nulls":4},"REDUCERS",{"$nulls":4},"GENERAL"]
[null,"Item No","Quantity","Description","Length",null,"Item No","Quantity","Description",null,"Item No","Quantity","Description","Length",null,"Item No","Quantity","Description","Length",null,"Item No","Quantity","Description","Length"]
[null,1.1,{"$f":"1+1","v":2},"SS 650mm dia","90 deg",null,2.1,1,"200mm Gate valve",null,4.1,2,"ss 650 oef",2000,null,5.1,1,"1000 to 750","ecc",null,1.7,1,"250 by 200 reducing tee","90 and 100"]
[null,1.2,{"$f":"1+1","v":2},"SS 650mm dia","45 deg",null,2.2,{"$f":"3+6","v":9},"400mm gate valve",null,4.2,4,"ss 650 bef",6000,null,5.2,1,"750 to 500 ","ecc",null,3.1,1,"SS 650, pf",1255]
[null,1.3,1,"SS 550mm dia","43.5 deg",null,2.3,1,"400mm combination control valve",null,4.3,1,"ss 650 oef",1260,null,5.3,1,"500 to 300 ","ecc",null,3.2,1,"SS 550, pf, oef",1085]
[null,1.4,1,"SS 550mm dia","90 deg",null,2.4,6,"250mm combi control valve",null,4.4,1,"ss650 oef",400,null,5.4,1,"300 to 250","ecc",null,3.3,1,"SS 250, pf",995]
[null,1.5,{"$f":"1+1","v":2},"SS 250mm dia","45 deg",null,2.5,3,"250mm NRV",null,4.5,1,"ss 650 oef",2075,null,5.5,3,"650 to 400","con ff",null,3.4,1,"SS 200 pf, oef",1000]
[null,1.6,1,"SS 250mm dia","90 deg",{"$nulls":5},4.6,1,"ss 650 oef",2520,null,5.6,{"$f":"3+4","v":7},"550 to 400","con ff",null,3.5]
[null,1.7,null,"See GENERAL",{"$nulls":6},4.7,1,"ss550 oef",300,null,5.7,1,"400 to 350","con ff",null,3.6]
[null,1.8,{"$f":"1+1+1+1","v":4},"SS 200mm dia","45 deg",{"$nulls":5},4.8,3,"ss550 bef",6000,null,5.8,1,"400 to 250 ","con ff",null,3.7]
[null,1.9,1,"SS 200mm dia","90 deg",{"$nulls":5},4.9,1,"ss550 oef",2660,null,5.9,1,"350 to 250","con ff",null,3.8]
[null,{"v":1.1,"d":"1.10"},2,"MS 650mm dia","47.83 deg",{"$nulls":5},{"v":4.101,"d":"4.10"},1,"ss550 oef",1350,{"$nulls":6},3.9,3,"MS 650 , pf, ff",1045]
[null,1.11,1,"MS 550mm dia","55 deg",{"$nulls":5},4.11,1,"ss750",300,{"$nulls":6},{"v":3.101,"d":"3.10"},2,"MS 550, pf, ff",1655]
[null,1.12,1,"MS 250mm dia","90 deg",{"$nulls":5},4.12,1,"ss350 oef",350,{"$nulls":6},3.11,4,"MS 400 ,ff, tee, 505 spool",610]
[{"$nulls":10},4.13,4,"ss250 bef",6000,{"$nulls":6},{"v":3.119,"d":"3.12"},1,"MS 650,ff, s-bend 45 deg",3350]
[{"$nulls":10},4.14,1,"ss250 oef",2260,{"$nulls":6},{"v":3.128,"d":"3.13"},1,"ms 550, s-bend 45 deg"]
[{"$nulls":10},4.15,1,"ss250 oef",350,{"$nulls":6},{"v":3.137,"d":"3.14"},1,"ms 650 blind flange"]
[{"$nulls":10},4.16,1,"ss250oef",3900,{"$nulls":6},{"v":3.146,"d":"3.15"},1,"ms 550 pf, ff",1045]
[{"$nulls":10},4.17,1,"ss250oef",980,{"$nulls":6},{"v":3.155,"d":"3.16"},1,"ms 550 by 300 tee"]
[{"$nulls":10},4.18,3,"ss200oef",300,{"$nulls":6},{"v":3.173,"d":"3.17"},2,"ms 550 blind flange"]
[{"$nulls":10},4.19,1,"ss200",415,{"$nulls":6},{"v":3.182,"d":"3.18"},1,"ms 300 blind flange"]
[{"$nulls":10},{"v":4.201,"d":"4.20"},3,"ss200 bef",6000,{"$nulls":6},{"v":3.191,"d":"3.19"},1,"ms 650 long radius bend","ff"]
[{"$nulls":10},4.21,1,"ss200 bef",1875,{"$nulls":6},{"v":3.2,"d":"3.20"},2,"ms 500 equal t"]
[{"$nulls":10},4.22,1,"ss200oef",350,{"$nulls":6},{"v":3.209,"d":"3.21"},2,"ms 400 equal t"]
[{"$nulls":10},4.23,{"$nulls":9},{"v":3.218,"d":"3.22"},1,"350 by 250 reducing t"]
[{"$nulls":10},4.24,{"$nulls":9},{"v":3.227,"d":"3.23"},3,"400 by 250 sweeping tee"]
[{"$nulls":10},4.25]
[{"$nulls":10},4.26,1,"ms650 oef",19100]
[{"$nulls":10},4.27,1,"ms650 bevelled",1744]
[{"$nulls":10},4.28,1,"ms650 oef",510]
[{"$nulls":10},4.29,6,"ms400 bef",500]
[{"$nulls":10},{"v":4.3002,"d":"4.30"},1,"ms550ff",10910]
[{"$nulls":10},4.31,1,"ms550 ff",2675]
[{"$nulls":10},4.32,1,"ss250 oef",495]
[{"$nulls":10},4.33,1,"ms 550 bef",586]
[{"$nulls":10},4.34,1,"ms 550 oef",2187]
[{"$nulls":10},4.35,1,"ms 550 oef",12631]
[{"$nulls":10},4.35999999999999,1,"ms 400 bef",3955]
[{"$nulls":10},4.36999999999999,1,"ms 400 bef",2293]
[{"$nulls":10},4.37999999999999,1,"ms 350 bef",4895]
[{"$nulls":10},4.38999999999999,1,"ms 250 bef",958]
[{"$nulls":10},{"v":4.39999999999999,"d":"4.40"},1,"ms 250 bef",1053]
[{"$nulls":10},4.40999999999999,1,"ms 250 oef",2508]
[{"$nulls":10},4.41999999999999,1,"ms 250 oef",1377]
[{"$nulls":10},4.42999999999999,3,"ms 150bef",150]