{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["1-P&G","2-Daywork ","3-GUARD HOUSE 1","4-GUARD HOUSE 2","5-BOUNDARY WALL","6-Summary","450mm Bedding","450mm Bedding (2)","Calcs","Pipe Fittings"],"not_rendered":{"images":1,"external_links":15,"defined_names":1020},"read":"whole","date_system":"1900"}

{"sheet":"1-P&G","index":0,"n_rows":233,"n_cols":7,"rows_kept":233}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE            (R)","AMOUNT           (R)"]
["`"]
[null,"SANS 1200 A","SECTION 1 : GENERAL"]
[]
[1.1,8.3,"Contractual Requirements"]
[]
["1.1.1","8.3.1","Contractual requirements","Sum",1]
["1.1.2",null,"Fixed preliminary and general charges","Sum",1]
[null,"8.3.2","Establishment of facilities on site:"]
[]
[null,"8.3.2.1","Facilities for Employers Agent "]
[]
["1.1.3","8.3.2.1(a)","Provision of a furnished meeting room and office for the Employers Agent's Representative (including all furnishings, facilities and equipment including toilet facilities) ","Sum",1]
["1.1.4",null,"Provision of survey equipment (PSAB 4.2)","Sum",1]
[]
["1.1.5",null,"Contract Nameboard (2 No.) and Identity Boards (2 No.) with supports erected & moved complete. (Refer to PSAB 3.1) ","No.",2]
[]
["1.1.6",null,"Provision of survey assistants \n(Refer PSAB 5.5)","Sum",1]
[]
["1.1.7",null,"Covered Parking (2 bays) \n(Refer PSAB 3.3)","Sum",1]
[]
["1.1.8",null,"PPE for Engineer, assistants and students","Sum",1]
[]
["1.1.9",null,"Security of works","Sum",1]
[]
["1.1.10",null,"All other specified facilities (incl wifi internet connection and printer)","Sum",1]
[]
["1.1.11","8.3.2.2,                      8.3.2.3","Facilities for Contractor"]
[]
["1.1.11.1",null,"a) Offices and storage sheds","Sum",1]
[]
["1.1.11.2",null,"b) Workshops","Sum",1]
[]
["1.1.11.3",null,"c) Laboratories","Sum",1]
[]
["1.1.11.4",null,"d) Living Accommodation","Sum",1]
[]
["1.1.11.5",null,"e) Ablution and latrine facilities","Sum",1]
[]
["1.1.11.6",null,"f) Tools and equipment","Sum",1]
[]
["1.1.11.7",null,"g) Water supplies, electric power and \n    communications","Sum",1]
[]
["1.1.11.8",null,"h) Dealing with water","Sum",1]
[]
["1.1.11.9",null,"i) Access","Sum",1]
[]
["1.1.11.10",null,"j) Construction Plant and Transport","Sum",1]
[]
["1.1.11.11","8.3.4","Remove all site establishment on completion","Sum",1]
[]
["1.1.11.12","PSA 8.3.5.3","Dealing with conditions of permits, Wayleave Agreements, EIA, RoD. (Refer to C3.4.4.8) ","Sum",1]
[]
["1.1.11.13","PSA 8.3.5.1","Notices and warmings to consumers","Sum",1]
[]
[]
[null,null,"TOTAL CARRIED FORWARD"]
[null,null,"TOTAL BROUGHT FORWARD"]
[]
["1.1.12","PSA 8.8 a","OH&S Requirements (Fixed charges)"]
[]
[null,"PSA 8.3.5.2","The sum shall cover all preparation of risk assessments (Annexure D), safe work procedures, the project H&S File, the H&S Plan, medicals for all workers, the provision of PPE and protective clothing,  including hazards and potential hazard identification, Standard Working Procedures, and Method Statements and all other costs necessary in complying generally with the Occupational Health and Safety Act 85 of 1993, (as amended), the Construction Regulations 2014 and the Particular Safety Specification (Annexure C)","Sum",1]
[]
["1.1.13",null,"Completing and checking the Project H&S File and handing over to Client on completion of the works and exit medicals for all workers.","Sum",1]
[]
["1.1.14",null,"HIV / AIDS Awareness"]
[null,null,"Refer to SANS 1921-6 and Annexure F"]
[]
[null,null,"Conduct HIV/AIDS awareness programme workshops on site for not less than 90% of the workers inclusive of all direct and indirect costs (at least once every 4 months)","No.",2]
[]
["1.1.15",null,"Provide and maintain condom dispenser","No.",1]
[]
["1.1.15",null,"Provide and maintain HIV/AIDS awareness posters","No.",1]
[]
["1.1.16",null,"Provide information regarding the voluntary testing of construction workers, counselling, support and care in a monthly report","Sum",1]
[]
["1.1.17","PSA 8.3.5.3","Environmental Management and EMP"]
[]
[null,null,"The sum shall cover the cost of all activities necessary to comply with section C3.5 and Annexure M of the Environmental Management Particular Specification, and Environmental Management Plan, which incorporates the ROD requirements for the Project, which have not been included in the tendered rates for the scheduled items allowed elsewhere in the bill of quantities","Sum",1]
[]
[]
[null,null,"Appointment of Safety Officer","Sum",1]
[]
[null,null,"Appointment of Environmental Officer","Sum",1]
[]
[1.2,"SANS 1200A","\nTIME RELATED ITEMS"]
[]
["1.2.1","PSA 8.4.1","Contractual requirements (including, EPWP, QA and Project Reporting)\n","Months",6]
[]
[]
[]
[]
[null,null,"TOTAL CARRIED FORWARD",null,null,"R"]
[null,null,"TOTAL BROUGHT FORWARD",null,null,"R"]
[]
[null,"PSA 8.4.2","Operate and maintain facilities on Site"]
[]
[null,"8.4.2.1","Facilities for Engineer for duration of contract (SANS 1200AB)"]
[]
["1.2.2","8.4.2.1 (a)","Provision of meeting room and office for the Engineer's Representative including toilet facilities as per PSAB 5.2 & PSAB 3.2","Months",6]
[]
["1.2.3",null,"Provision of survey equipment (Refer to PSAB 4.2) ","Months",6]
[]
["1.2.4",null,"Provision of 2 № survey assistants (Refer to PSAB 5.5)","Months",6]
["1.2.5",null,"Nameboards (2No.)","Months",6]
[]
["1.2.6",null,"PPE for Engineer and assistants","Months",6]
[]
["1.2.7",null,"Engineer's Office and parking facilities","Months",6]
[]
["1.2.7",null,"Security of works","Months",6]
[]
["1.2.8","8.4.2.2 8.4.2.3","Facilities for Contractor"]
[]
["1.2.8.1",null,"a) Offices and storage sheds","Months",6]
[]
["1.2.8.2",null,"b) Workshops","Months",6]
[]
["1.2.8.3",null,"c) Laboratories","Months",6]
[]
["1.2.8.4",null,"d) Living Accommodation","Months",6]
[]
["1.2.8.5",null,"e) Ablution and latrine facilities","Months",6]
[]
["1.2.8.6",null,"f) Tools and equipment","Months",6]
[]
["1.2.8.7",null,"g) Water supplies, electric power and \n    communications","Months",6]
[]
["1.2.8.8",null,"h) Dealing with water","Months",6]
[]
["1.2.8.9",null,"i) Access","Months",6]
[]
["1.2.8.10",null,"j) Construction Plant and Transport","Months",6]
[]
["1.2.9","PSA 8.4.3","Supervision for duration of the contract (all supervisory staff not considered labour)","Months",6]
[]
["1.2.10","8.4.4","Company and Head Office overhead costs","Months",6]
[]
["1.2.11",null,"General responsibilities and other time related obligations","Months",6]
[]
[null,"PSA 8.4.6.1","Permits and Wayleaves"]
[]
["1.2.12",null,"Dealing with conditions of permits, Wayleave Agreements, EIA, RoD (Refer to C3.4.4.8)","Months",6]
{"$rows_empty":11}
[null,null,"TOTAL CARRIED FORWARD",null,null,"R"]
[null,null,"TOTAL BROUGHT FORWARD",null,null,"R"]
[]
[]
["1.2.13","PSA 8.4.6.1","OH&S Requirements (Time charges)"]
[]
[null,null,"Updating and amending the risk assessments, safe work procedures, the project H&S File, the H&S Plan, medicals for all workers, the provision of PPE and protective clothing,  including hazards and potential hazard identification, Standard Working Procedures, and Method Statements and all other costs necessary in complying generally with the Occupational Health and Safety Act 85 of 1993, (as amended), the Construction Regulations 2014 and the Particular Safety Specification (Annexure C)","Months",6]
[]
["1.2.14",null,"Full compliance and checking the Project H&S File during construction of the works under the Contract.","Months",6]
[]
["1.2.15",null,"The sum shall cover all activities necessary in complying with the requirements of the Health and Safety Specification in terms of Training as the Work proceeds","Months",6]
[]
["1.2.16",null,"The sum shall cover all activities necessary in complying with the requirements of the Health and Safety Specification in terms of Monitoring and Review as the Work proceeds","Months",6]
[]
["1.2.17",null,"The sum shall cover the cost of all activities necessary to comply with section C3.5 and Annexure M of the Environmental Management Particular Specification, and Environmental Management Plan, which incorporates the ROD requirements for the Project, which have not been included in the tendered rates for the scheduled items allowed elsewhere in the bill of quantities","Months",6]
[]
["1.2.18","PSA 8.4.6.2","Security in accordance with C3.4.4.6","Months",6]
[]
["1.2.19",null,"Any other time related obligations ","Months",6]
[]
[null,null,"EME's or QSE's"]
[]
["1.2.20","PSA 8.5.4\n","Contractor to provide manager for dealing with  EME's or QSE's for duration of contract to meet local employment and local enterprise targets (Refer to C1.8, C1.9 and C3.4.10 & PSA 5.10)","Months",6]
[]
[]
["1.2.21",null,"Dealing with conditions of EME's or QSE's sub-contractors and local/target labour (Refer to C1.9, C3.4.10 & C3.3.2).The tendered rate shall cover all costs including but not limited to procurement, management, administration, overheads, finance costs, transportation, training, risk and profit and any other costs associated on work allocated to EME's or QSE's and targeted labour in order to achieve the required participation goals. (Contractor to allocate packages)\n","Months",6]
{"$rows_empty":9}
[null,null,"TOTAL CARRIED FORWARD",null,null,"R"]
[null,null,"TOTAL BROUGHT FORWARD",null,null,"R"]
[]
[]
["1.3",8.5,"SUMS STATED PROVISIONALLY BY ENGINEER"]
[]
["1.3.1","PSA 8.4.6.1","Quality assurance and management plan","Sum",{"v":1,"d":"1.0"}]
[]
["1.3.2","PSA 8.4.6.1","Provisional sum for Independent OHS, EMP practitioners","Prov. Sum",{"v":1,"d":"1.0"}]
[]
[]
[1.4,8.8,"TEMPORARY WORKS"]
[]
["1.4.1","PSA 8.8.4","Dealing with traffic or accommodation of traffic and erecting signage (also refer to SANS 1921-2)","Sum",1]
[]
["1.4.2","PSA 8.8.5","Access to works including all temporary roads, excavations and ramps, etc.","Sum",1]
[]
["1.4.3","PSA 8.8.6","Dealing with water","Sum",1]
[]
["1.4.4","8.8.3","Dealing with existing infrastructure","Sum",1]
[]
["1.4.5","PSA 8.8.7","Dealing with Public","Sum",1]
[]
["1.4.6","PSA 8.8.8","Barricading of Trenches","Sum",1]
[]
["1.4.7","PSA 8.8.9","Fencing","Sum",1]
[]
[]
["1.4.9","PSA 8.8.10","Allow for the attendance of other Contractors, JW staff and public within the parameters of the site.","Sum",1]
{"$rows_empty":13}
[null,"TOTAL FOR SECTION 1 CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R"]

{"sheet":"2-Daywork ","index":1,"n_rows":269,"n_cols":10,"rows_kept":269}
[]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE            (R)","AMOUNT           (R)"]
[]
[2,"SANS 1200A","SECTION 2:  DAYWORKS, PROVISIONAL SUMS AND PRIME COST ITEMS"]
[null,8.7]
[2.1,"PSA 8.6","DAYWORKS"]
[]
[null,null,"Labour"]
[]
["2.1.1","8.5 (b.1)","Allow for total remuneration paid to workers","Prov Sum",1,{"v":30000,"d":"30,000.00"},{"$f":"E10*F10","v":{"v":30000,"d":"30,000.00"}}]
[]
["2.1.2","PSA 8.5","Overheads, charges and profit on 2.1.1 above","%",{"$f":"F10","v":{"v":30000,"d":"30,000.00"}}]
[]
["2.1.3",null,"Team Leader / charge hand","hr",5]
[]
["2.1.4",null,"Artisan","hr",10]
[]
["2.1.5",null,"Skilled","hr",10]
[]
["2.1.6",null,"Semi-skilled","hr",10]
[]
["2.1.7",null,"Unskilled","hr",10]
[]
["2.1.10",null,"Foreman","hr.",{"v":10,"d":"10.0"}]
[]
["2.1.11",null,"Driver (LDV,machine, trucks, etc.)","hr.",{"v":10,"d":"10.0"}]
[]
["2.1.12",null,"Certified Blaster","hr.",{"v":10,"d":"10.0"}]
[]
["2.1.13",null,"Steel fixer","hr.",{"v":10,"d":"10.0"}]
[]
["2.1.14",null,"Concretor","hr.",{"v":10,"d":"10.0"}]
[]
["2.1.15",null,"Charge hand","hr.",{"v":10,"d":"10.0"}]
[]
["2.1.16",null,"Security guard","hr.",{"v":10,"d":"10.0"}]
[]
[null,null,"Plant and equipment"]
[]
[null,null,"(a) Tractor loader backhoe (TLB)"]
["2.1.17",null,"(i) Tractor Loader Backhoe (Bigger than 45kW but smaller than 70kW)","hr.",{"v":5,"d":"5.0"}]
[]
[null,null,"(b) Crawler Excavators"]
["2.1.18",null,"(i) Smaller than 93kW (small)","hr.",{"v":0,"d":"0.0"}]
["2.1.19",null,"(ii) Bigger than 93kW but smaller than 200kW ( Medium)","hr.",{"v":0,"d":"0.0"}]
[]
[null,null,"(c) Tipper Trucks"]
["2.1.20",null,"(i) Tipper trucks (3m³) Small","hr.",{"v":5,"d":"5.0"}]
["2.1.21",null,"(ii) Tipper trucks (5m³) Medium","hr.",{"v":5,"d":"5.0"}]
["2.1.22",null,"(iii) Tipper trucks (10m³) Large","hr.",{"v":5,"d":"5.0"}]
[]
[null,null,"(d) Flat Bed Trucks"]
["2.1.23",null,"(i) Flat bed 5t capacity","hr.",{"v":8,"d":"8.0"}]
["2.1.24",null,"(ii) Flat bed 7t capacity","hr.",{"v":8,"d":"8.0"}]
[]
[null,null,"(e) LDV"]
["2.1.25",null," (i) 1t Pick-up","hr.",{"v":5,"d":"5.0"}]
[]
["2.1.26",null,"(f) Mobile Crane 5t at 3m radius","hr.",{"v":5,"d":"5.0"}]
[]
[null,null,"(g) Walk behind vibrating rollers"]
["2.1.27",null,"(i) Model - Bomag 60 or similar  (small)","hr.",{"v":5,"d":"5.0"}]
["2.1.28",null,"(ii) Model - Bomag 76 or similar  (medium)","hr.",{"v":0,"d":"0.0"}]
["2.1.29",null,"(iii) Model - Bomag 90 or similar","hr.",{"v":0,"d":"0.0"}]
{"$rows_empty":8}
[null,null,"TOTAL CARRIED FORWARD"]
[null,null,"TOTAL BROUGHT FORWARD"]
[]
[null,null,"(h) Plate compactors"]
["2.1.30",null,"(i) Vipac or similar","hr.",{"v":5,"d":"5.0"}]
[]
[null,null,"(i) Rammers"]
["2.1.31",null,"(i) Model - Wacker or similar","hr.",{"v":5,"d":"5.0"}]
[]
["2.1.32",null,"(j) Concrete mixers",{"$nulls":6},222222]
["2.1.33",null,"(i) Volume 100 litre wet (small, towable)","hr.",{"v":8,"d":"8.0"}]
["2.1.34",null,"(ii) Volume 175 litre wet (medium)","hr.",{"v":0,"d":"0.0"}]
["2.1.35",null,"(iii) Volume 250 litre wet (large)","hr.",{"v":0,"d":"0.0"}]
[]
[null,null,"(k) Diesel compressors including hoses and tools","hr",{"v":8,"d":"8.0"}]
["2.1.36",null,"(i) Capacity smaller than 200 cfm (small)","hr.",{"v":0,"d":"0.0"}]
["2.1.37",null,"(ii) Capacity bigger than 200 cfm smaller than 400 cfm (medium)","hr.",{"v":0,"d":"0.0"}]
["2.1.38",null,"(iii) Capacity bigger than 400 cfm (large)","hr.",{"v":0,"d":"0.0"}]
[null,null,"            "]
["2.1.39",null,"(l) Waterpump"]
["2.1.40",null,"(i) Capacity smaller than 400 litre/min (medium)","hr",{"v":4,"d":"4.0"}]
["2.1.41",null,"(ii) Capacity bigger than 400 but smaller than 600 litre/min (medium) ","hr",{"v":0,"d":"0.0"}]
["2.1.42",null,"(iii) Capacity bigger than 600 but smaller then 1 100 litre/sec (large)","hr",{"v":0,"d":"0.0"}]
[]
[null,null,"Materials"]
[]
["2.1.43","8.5 (a, b1)","Net cost of goods or materials","Prov Sum",1,{"v":50000,"d":"50,000.00"},{"$f":"E99*F99","v":{"v":50000,"d":"50,000.00"}}]
[]
["2.1.44","PSA 8.5","Overheads, charges and profit on 2.1.8 above","%",{"$f":"F99","v":{"v":50000,"d":"50,000.00"}}]
[]
[null,null,"Contractors own Plant"]
[]
["2.1.45","8.5 (a)","Allow for all-inclusive cost of using Contractor's own plant on site.","Prov Sum",1]
[]
[null,null,"Plant hired by the Contractor"]
[]
["2.1.46","8.5 (b.1)","Net cost of hired plant","Prov Sum",1]
[]
["2.1.47","PSA 8.5","Overheads, charges and profit on 2.1.11 above","%",{"v":25000,"d":"25,000.00"}]
[]
[null,null,"Survey Beacons/Pegs"]
[]
["2.1.48","8.5 (a)","Search for, record, reference and protect survey stations, bench marks, erf boundary pegs and other reference pegs and expose on completion of works","Sum",1]
[]
[2.2,8.5,"SUMS STATED PROVISIONALLY BY THE ENGINEER"]
[null,"PSA 8.5"]
["2.2.1",null,"Cellphone allowance for the Employers Agent Representative and their assistant for the duration of the contract (R1500 pm)","Prov Sum",1,{"v":9000,"d":"9,000.00"},{"$f":"E119*F119","v":{"v":9000,"d":"9,000.00"}}]
[]
["2.2.2",null,"Overheads, charges and profit on 2.2.1 above","%",{"$f":"F119","v":{"v":9000,"d":"9,000.00"}}]
{"$rows_empty":14}
[null,null,"TOTAL CARRIED FORWARD",null,null,"R",{"$f":"SUM(G74:G125)","v":{"v":59000,"d":"59,000.00"}}]
[null,null,"TOTAL BROUGHT FORWARD",null,null,"R",{"$f":"G136","v":{"v":59000,"d":"59,000.00"}}]
[]
[]
["2.2.7",null,"Equipment for the Employers Agent Representative and their assistant for the duration of the contract","Prov Sum",1,{"v":10000,"d":"10,000.00"},{"$f":"E140*F140","v":{"v":10000,"d":"10,000.00"}}]
[]
["2.2.8",null,"Overheads, charges and profit on 2.2.7 above","%",{"$f":"F140","v":{"v":10000,"d":"10,000.00"}}]
[null,null,"Survey"]
[]
["2.2.9",null,"Ad-hoc topographical survey as requested by the Engineer during the contract","Prov Sum",1,{"v":12000,"d":"12,000.00"},{"$f":"E145*F145","v":{"v":12000,"d":"12,000.00"}}]
[]
["2.2.10",null,"Overheads, charges and profit on 2.2.9 above","%"]
[]
[null,"PSA 8.5.3\n","Community Liason Officer and Consultant"]
[]
["2.2.11","a)","Employment of the CLO for duration of contract who shall be appointed by the Contractor and shall report to the Engineer and the Client (R8500 pm plus R500 pm cellphone allowance) (refer C3.4.7)","Prov Sum",1,{"$f":"81000","v":{"v":81000,"d":"81,000.00"}},{"$f":"E151*F151","v":{"v":81000,"d":"81,000.00"}}]
[]
["2.2.12","b)","Overheads, charges and profit on 2.2.11","%",{"$f":"G151","v":{"v":81000,"d":"81,000.00"}}]
[]
["2.2.13",null,"Employment of a social consultant for duration of contract ","Prov Sum",1,{"v":81000,"d":"81,000.00"},{"$f":"E155*F155","v":{"v":81000,"d":"81,000.00"}}]
[]
["2.2.14","PSA 8.5","Overheads, charges and profit on 2.2.13","%",{"$f":"F155","v":{"v":81000,"d":"81,000.00"}}]
[{"$nulls":6},{"$f":"IF(E158=\"-\",F158,IF(E158=\"\",\"\",F158*E158))","v":""}]
[null,"PSA 8.12","Training",{"$nulls":3},{"$f":"IF(E159=\"-\",F159,IF(E159=\"\",\"\",F159*E159))","v":""}]
[null,"PSA 8.13"]
["2.2.15",null,"Allowance for training of local unskilled labour","Prov Sum",1,{"v":150000,"d":"150,000.00"},{"$f":"E161*F161","v":{"v":150000,"d":"150,000.00"}}]
[]
["2.2.16","PSA 8.5","Overheads, charges and profit on 2.2.15","%",{"$f":"F161","v":{"v":150000,"d":"150,000.00"}}]
[]
["2.2.17","PSA 8.14","Allowance for transport","Prov Sum",1,{"v":25000,"d":"25,000.00"},{"$f":"E165*F165","v":{"v":25000,"d":"25,000.00"}}]
[]
["2.2.18",null,"Overheads, charges and profit on 2.2.17","%",{"$f":"F165","v":{"v":25000,"d":"25,000.00"}}]
[]
[null,"Spec PC","Re-vegetation",{"$nulls":3},{"$f":"IF(E169=\"-\",F169,IF(E169=\"\",\"\",F169*E169))","v":""}]
[]
["2.2.19",null,"Re-vegetation of the site","Prov Sum",1,{"v":15000,"d":"15,000.00"},{"$f":"E171*F171","v":{"v":15000,"d":"15,000.00"}}]
[]
["2.2.20","PSA 8.5","Overheads, charges and profit on 2.2.19","%",{"$f":"F171","v":{"v":15000,"d":"15,000.00"}}]
[]
[null,null,"Pipework",{"$nulls":3},{"$f":"IF(E175=\"-\",F175,IF(E175=\"\",\"\",F175*E175))","v":""}]
[]
["2.2.21",null,"Connection to existing / proposed pipework ","Prov Sum",1,{"v":15000,"d":"15,000.00"},{"$f":"E177*F177","v":{"v":15000,"d":"15,000.00"}}]
[]
["2.2.22",null,"Overheads, charges and profit on 2.2.21","%",{"$f":"F177","v":{"v":15000,"d":"15,000.00"}}]
[]
[null,null,"Control Testing",{"$nulls":3},{"$f":"IF(E181=\"-\",F181,IF(E181=\"\",\"\",F181*E181))","v":""}]
[]
["2.2.23","PSA 8.5.1","Acceptance Control Testing","Prov Sum",1,{"v":15000,"d":"15,000.00"},{"$f":"E183*F183","v":{"v":15000,"d":"15,000.00"}}]
[]
["2.2.24","8.5 (b)","Overheads, charges and profit on 2.2.23","%",{"$f":"F183","v":{"v":15000,"d":"15,000.00"}}]
{"$rows_empty":15}
[null,null,"TOTAL CARRIED FORWARD",null,null,"R"]
[null,null,"TOTAL BROUGHT FORWARD",null,null,"R"]
[]
[null,"PSA 8.5","Students"]
[]
["2.2.25",null,"Provisional Sum for employing students on the Contract","Prov Sum",1,{"v":100000,"d":"100,000.00"},{"$f":"E206*F206","v":{"v":100000,"d":"100,000.00"}}]
[]
["2.2.26",null,"Overheads, charges and profit on 2.2.25 above","%",{"$f":"F206","v":{"v":100000,"d":"100,000.00"}}]
[]
[2.3,"PSA 8.4.7","MISCELLANEOUS"]
[]
["2.3.1",null,"General Signage, as per the Engineer's instructions (Prov)","Prov Sum",1,{"v":5000,"d":"5,000.00"},{"$f":"E212*F212","v":{"v":5000,"d":"5,000.00"}}]
[]
["2.3.2",null,"Overheads, charges and profit on 2.3.1","%",{"$f":"F212","v":{"v":5000,"d":"5,000.00"}}]
[]
["2.3.3","PSA 8.8.11","Allow for the attendance of EME's or QSE's and other Contractors within the parameters of the site \n(refer C3.5.26)","Sum",1]
{"$rows_empty":52}
[null,"TOTAL FOR SECTION 2 CARRIED FORWARD TO SUMMARY",{"$nulls":3},"R"]

{"sheet":"3-GUARD HOUSE 1","index":2,"n_rows":750,"n_cols":7,"rows_kept":750,"merged":[[734,1,734,6],[739,2,739,4]]}
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[13.2,null,"GUARD HOUSE 1"]
[3]
["3.1",null,"BILL NO. 1"]
[]
[null,null,"EARTHWORKS"]
[]
["3.1.1",null,"Site clearance"]
[]
["3.1.1.1","SANS 1200C 8.2.1","Digging up and remoing rubbish, debris, vegetation, hedge, shrubs, bush etc and trees not exceeding 200mm girth","m²",{"v":50,"d":"50.00"}]
[]
["3.1.1.2","8.2.10","Remove top 150mm, around the building","m²",30]
[]
["3.1.2","SANS 1200DA","EARTHFILLING"]
[]
["3.1.2.1","8.3.4","Backfill with G5 material to create level platform compacted to 95% AASHTO MOD.","m³",{"$f":"3.6*3.4*0.3","v":{"v":3.6719999999999997,"d":"4"}}]
[]
["3.1.2.2",null,"Backfilling to trenches","m³",{"$f":"(3.6+3.6+3.5)*2*0.5*0.25","v":{"v":2.675,"d":"3"}}]
[]
["3.1.3","8.3.2","EXCAVATIONS"]
[]
[null,null,"Excavate in earth not exceeding 2m deep"]
[]
["3.1.3.1",null,"Trenches","m³",{"$f":"A2","v":{"v":13.2,"d":"13"}}]
["3.1.3.2",null,"Extra over excavation in soft rock","m³",1]
["3.1.3.3",null,"Extra over excavation in hard rock","m³",1]
[]
[null,null,"Extraover all excavations for carting away"]
[]
["3.1.3.4","8.3.3","Surplus material from excavations or stockpile on site to a dumping site","m³",{"$f":"E24","v":{"v":13.2,"d":"13"}}]
[]
[null,null,"Keeping excavation free of water"]
[]
["3.1.3.5",null,"Keeping excavations free of water other than subterranean water","item",1]
[]
[null,"8.3.7","Risk of collapse"]
[]
["3.1.3.6",null,"Sides of excavations not exceeding 1.5m deep","m²",{"$f":"A2*0.7*2","v":{"v":18.479999999999997,"d":"18"}}]
[]
[null,"8.3.9","Filling etc"]
[]
["3.1.3.7",null,"Earth filling obtained from excavations and/or prescibed stock piles on site, compacted to 95 Mod AASHTO density"]
[]
["3.1.3.8",null,"Under floors","m³",{"$f":"3.6*3","v":{"v":10.8,"d":"11"}}]
[]
["3.1.3.9",null,"Backfilling to trenches, holes etc","m³",{"$f":"A2*0.24*2*0.5","v":{"v":3.1679999999999997,"d":"3"}}]
[]
[null,null,"Weed killers, insecticides, etc"]
["3.1.3.10",null,"Bottom and side of trenchs","m²",{"$f":"A2*2.1","v":{"v":27.72,"d":"28"}}]
["3.1.3.11",null,"Bottom of surfacebed","m²",{"$f":"3.6*3","v":{"v":10.8,"d":"11"}}]
[]
[null,null,"CARRIED FORWARD"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["3.2",null,"BILL NO. 2"]
[]
[null,"SANS1200 GA","CONCRETE, FORMWORK AND REINFORCEMENT"]
[]
["3.2.1","8.4.2","15MPa/19MM CONCRETE"]
[]
["3.2.1.1",null,"Surface blinding under footings and bases","m³",{"$f":"A2*0.7*0.05","v":{"v":0.46199999999999997,"d":"0.5"}}]
[]
["3.2.2","8.4.3","CONCRETE FOUNDATION"]
[]
["3.2.2.1",null,"25MPa/19mm concrete footing","m³",{"$f":"A2*0.7*0.2","v":{"v":1.8479999999999999,"d":"2"}}]
["3.2.2.2",null,"20MPa/19mm surfacebed","m³",{"$f":"3.6*3.1","v":{"v":11.16,"d":"11"}}]
["3.2.2.3",null,"20MPa/19mm Apron","m³",{"$f":"(A2+4)*1*0.05","v":{"v":0.86,"d":"1"}}]
[]
["3.2.3","8.4.3","CONCRETE SLAB"]
[]
["3.2.3.1",null,"25MPa/19mm slabs including beams andinverted beams","m³",{"$f":"3.9*3.3*0.17","v":{"v":2.1879,"d":"2"}}]
[]
["3.2.4","8.3.1","HIGH STRENGTH STEEL REINFORCEMENT"]
[]
["3.2.4.1",null,"Y12 Bars ","t",{"$f":"(A2*4*0.888*0.001)+(14*3.3*0.888*2*0.001)+(11*0.888*3.9*2*0.001)","v":{"v":0.20512799999999998,"d":"0.21"}}]
[]
["3.2.5","8.3.1","MILD STRENGTH STEEL"]
[]
["3.2.5.1",null,"R8 bars","t",{"$f":"A2/0.3*2*0.4*0.001","v":{"v":0.0352,"d":"0.04"}}]
[]
[null,"8.3.2","Fabric Reinforcement"]
[]
["3.2.5.2",null,"Mesh ref 193","m²",{"$f":"3.6*3","v":{"v":10.8,"d":"11"}}]
["3.2.5.3",null,"Mesh ref 100","m²",{"$f":"A2*1+4*0.6","v":{"v":15.6,"d":"16"}}]
[]
["3.2.6","8.4.4","CONCRETE FINISHES"]
["3.2.6.1",null,"Woodfloat finishing to surface bed","m²",{"$f":"3.6*3","v":{"v":10.8,"d":"11"}}]
["3.2.6.2",null,"Woodfloat finishing to apron ","m²",{"$f":"E84","v":{"v":15.6,"d":"16"}}]
["3.2.6.3",null,"Woodfloat finishing to roof slab","m²",{"$f":"3.6*3.5","v":{"v":12.6,"d":"13"}}]
[]
["3.2.6.4",null,"50mm diameter sleeves","m",50]
[]
["3.2.7","8.2","FORMWORK"]
[]
["3.2.7.1","8.2.2","Formwork to soffit of concrete slab","m²",{"$f":"3.9*3.3","v":{"v":12.87,"d":"13"}}]
["3.2.7.2",null,"Formwork to sides of concrete not exceeding 300mm","m",{"$f":"3.9*2+3.3*2","v":{"v":14.399999999999999,"d":"14"}}]
[]
["3.2.8",null,"Prescribed density tests on filling"]
[]
["3.2.8.1",null,"Modified AASHTO Density tests","No",2]
[null,null,"Concrete Sundries"]
[]
["3.2.8.2",null,"Making and testing 150x150x150mm concrete test cubes","Item",2]
[]
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 3"]
[]
["3.3",null,"MASONRY"]
[]
[null,"PQA 15.1","Brickwork of NFP bricks in class II mortar"]
[]
["3.3.1",null,"One brick wall in foundation","m²",{"$f":"A2*0.5","v":{"v":6.6,"d":"7"}}]
[]
["3.3.2","PQA 15.1","Brickwork of FBX bricks in class II mortar"]
[]
["3.3.2.1",null,"One brickwall in supperstructure","m²",{"$f":"A2*3","v":{"v":39.599999999999994,"d":"40"}}]
[]
["3.3.2.2.",null,"115mm common brick","m²",{"$f":"3*3","v":9}]
[]
["3.3.3",null,"Brickwork reinforcement"]
[]
["3.3.3.1","PQA 15.1","a) Brick reinforcement 75mm wide built into brick walls with sufficient laps at end joints, angles and intersections (measured net)","m",{"$f":"2700/340*3","v":{"v":23.823529411764707,"d":"24"}}]
[]
["3.3.3.2","PQA 15.1","b) Brick reinforcement 150mm wide built into brick walls with sufficient laps at end joints, angles and intersections (measured net)","m",{"$f":"3500/255*A2","v":{"v":181.17647058823528,"d":"181"}}]
[]
["3.3.4",null,"JOINTS IN WALLS, FLOORS AND ROOF"]
[]
["3.3.4.1",null,"Maltoid on walls ","m",{"$f":"A2+3","v":{"v":16.2,"d":"16"}}]
[]
["3.3.4.2",null,"Saw cut joints on floor and apron ","m",12]
[]
[null,null,"Prestressed fabricated Lintels"]
[]
["3.3.4.3","PQA 15.5","110x170mm lintel in lengths not exceeding 3m","No.",{"v":12,"d":"12.00"}]
{"$rows_empty":21}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 4"]
[]
["3.4",null,"WATERPROOFING"]
[]
["3.4.1","PQA 15.4","DPC 250micron in solid walls","m",{"$f":"A2","v":{"v":13.2,"d":"13.20"}}]
[]
["3.4.2",null,"170micron dpm under surfacebed laid with 150mm overlaps","m²",{"$f":"3.6*3","v":{"v":10.8,"d":"10.80"}}]
[]
["3.4.3","PQA 16.4","Bituminous aluminium paint finish to concrete roof","m²",{"$f":"3.9*3.3","v":12.87}]
[]
["3.4.4","PQA 16.4","double malthoid between concrete and brick surfaces","m",{"$f":"A2+3","v":{"v":16.2,"d":"16.20"}}]
{"$rows_empty":44}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 5"]
[]
["3.5",null,"CARPENTRY AND JOINERY"]
[]
["3.5.1",null,"Doors etc"]
[]
["3.5.2",null,"44mm solid core masonite door with hardwood edge strips on both side 877x2100mm","no.",{"v":2,"d":"2.00"}]
{"$rows_empty":49}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 6"]
[]
["3.6",null,"FLOOR COVERINGS, WALL LINNINGS ETC"]
["3.6.1","PQB 7.5.1","Floor tiles ","m²",{"$f":"3.6*3.5","v":{"v":12.6,"d":"12.60"}}]
[]
["3.6.2","PQB 7.5.1","Walls tiles","m²",{"v":1,"d":"1.00"}]
{"$rows_empty":51}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 7"]
[]
["3.7",null,"IRONMONGERY"]
[]
[null,null,"Hinges, Bolts etc"]
[]
["3.7.1",null,"Brass hinges with nylon washers","No",{"v":4,"d":"4.00"}]
[]
[null,null,"Locks"]
["3.7.2"]
[null,null,"2 lever motice lockest and handles","No.",{"v":2,"d":"2.00"}]
[]
["3.7.3",null,"Bathroom fittings"]
[]
["3.7.3.1",null,"Satin stainless steel paper towel dispensor","No.",{"v":1,"d":"1.00"}]
[]
["3.7.3.2",null,"Toilet roll holder","No.",{"v":1,"d":"1.00"}]
{"$rows_empty":41}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 8"]
[]
["3.8",null,"METALWORK"]
[]
[null,null,"Welded screens"]
["3.8.1"]
[null,null,"Security mild steel gate","No.",{"v":1,"d":"1.00"}]
[]
["3.8.2",null,"Prestressed steel door frames"]
[]
["3.8.2.1","PQA 15.3","1.2mm double rebate frame suitable for one brick wall","No.",{"v":1,"d":"1.00"}]
[]
["3.8.2.2",null,"1.2mm rebate frame suitable for half brick wall","No.",{"v":1,"d":"1.00"}]
[]
["3.8.3",null,"Window frames"]
[]
["3.8.3.1","PQA 15.3","Type C1","No",{"v":1,"d":"1.00"}]
[]
["3.8.3.2",null,"Type C2","No",{"v":3,"d":"3.00"}]
{"$rows_empty":9}
[{"$nulls":6},{"$f":"IF(E427=\"\",\"\",E427*F427)","v":""}]
{"$rows_empty":26}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 9"]
[]
["3.9",null,"PLASTERING"]
[]
["3.9.1",null,"SCREED"]
[]
["3.9.1.1","PQA 17.1","3:1 Cement plaster screed woodfloated on concrete"]
[]
["3.9.1.2",null,"30mm thick screed on floors ","m²",{"$f":"3.2*2.8","v":{"v":8.959999999999999,"d":"8.96"}}]
[]
["3.9.1.3",null,"50mm thick screed on roof","m²",{"$f":"3.6*3.5","v":{"v":12.6,"d":"12.60"}}]
[]
["3.9.2",null,"Internal Plaster"]
[]
["3.9.2.1","PQA 17.1","One coat cement plaster and one coat rhinolite plaster"]
[]
["3.9.2.2",null,"On walls","m²",{"$f":"(A2-0.9)*3","v":{"v":36.9,"d":"36.90"}}]
[]
["3.9.2.3",null,"on soffit of concrete slab","m²",{"$f":"3.9*3.3","v":12.87}]
{"$rows_empty":37}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 10"]
[]
["3.10",null,"PLUMBING AND DRAINAGE"]
[]
["3.10.1","PQF 5.1","Sanitary fittings"]
[]
["3.10.1.1",null,"Waste chamber","No.",{"v":1,"d":"1.00"}]
[]
["3.10.1.2",null,"Wash hand basin","No.",{"v":1,"d":"1.00"}]
[]
["3.10.1.3",null,"Basin waste union","No.",{"v":1,"d":"1.00"}]
[]
["3.10.1.4",null,"\"P\" trap","No.",{"v":1,"d":"1.00"}]
[]
["3.10.2","PQF 5.1","Sanitary plumbing"]
[]
["3.10.2.1",null,"uPVC, soil and vent pipes"]
[]
["3.10.2.2",null,"50mm pipes ","m",{"v":10,"d":"10.00"}]
[]
["3.10.2.3",null,"110mm pipes","m",{"v":100,"d":"100.00"}]
[]
["3.10.3","PQF 5.1","Extra over uPVC, soil, vent pipes for fittings"]
[]
["3.10.3.1",null,"110mm access bend with anti-siphon horn","No.",{"v":1,"d":"1.00"}]
[]
["3.10.3.2",null,"110mm Pan connector","No.",{"v":1,"d":"1.00"}]
[]
["3.10.3.3",null,"110mm x 50mm eccentric reducer","No.",{"v":1,"d":"1.00"}]
[]
["3.10.3.4",null,"110mm junction","No.",{"v":1,"d":"1.00"}]
[]
["3.10.3.5",null,"110mm air  vent cowl","No.",{"v":1,"d":"1.00"}]
[]
["3.10.3.6",null,"110mm GI vent valve","No.",{"v":1,"d":"1.00"}]
[]
["3.10.3.7",null,"110mm coupling","No.",{"v":15,"d":"15.00"}]
[]
["3.10.3.8",null,"50mm 90 degree bends","No.",{"v":4,"d":"4.00"}]
[]
["3.10.3.9",null,"50mm to 110 90 degree connector","No.",{"v":1,"d":"1.00"}]
{"$rows_empty":16}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 11"]
[]
["3.11",null,"GLAZING"]
[]
["3.11.1",null,"Windor glazing"]
[]
["3.11.1.1",null,"Type C1: 4mm obscured glazing","m²",{"$f":"0.6*0.9","v":0.54}]
[]
["3.11.1.2",null,"Type C2:clear glazing ","m²",{"$f":"1.5*1.2","v":{"v":1.7999999999999998,"d":"1.80"}}]
[]
[null,null,"Mirrors"]
[]
["3.11.1.3",null,"Stainless steel mirrors 500x600x13mm, concealed thief resistant fixings, plugged and screwed to the wall, stainless steel screws","No.",{"v":1,"d":"1.00"}]
{"$rows_empty":42}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 12"]
[]
["3.12",null,"PAINTWORK "]
[]
["3.12.1",null,"On floated plaster"]
[]
["3.12.1.1","PQH 4.1","Apply one coat plascon merit plaster prime, two coats double velvet pure acrylic "]
[]
["3.12.1.2",null,"On internal walls","m²",{"$f":"A2*3+6*3","v":{"v":57.599999999999994,"d":"57.60"}}]
[]
["3.12.2",null,"On smooth concrete "]
[]
["3.12.2.1","PQH 4.1","Prepare areas with slash coat and apply one coat universal undercoat and two coats plascon acrylic white"]
[]
["3.12.2.2",null,"On soffits","m²",{"$f":"3.9*3.3","v":12.87}]
[]
["3.12.3",null,"On metals"]
[]
["3.12.3.1",null,"One coat universal undercoat and two coats plascon"]
[]
[null,"PQH 4.2","On door frames","m²",{"$f":"5*0.3*2","v":{"v":3,"d":"3.00"}}]
[]
["3.12.3.2",null,"On wood"]
[]
["3.12.3.2.1","PQH 4.2","One coat undercoat and apply three coats clear matt varnish plascon polyurethane matt varnish"]
[]
["3.12.3.2.2",null,"On doors","m²",{"$f":"0.85*2.1*2","v":3.57}]
{"$rows_empty":25}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 13"]
[]
["3.13",null,"PROVISIONAL SUM"]
[]
["3.13.1",null,"ELECTRICAL","SUM",{"v":1,"d":"1.00"},{"v":25000,"d":"25,000.00"},{"$f":"E693*F693","v":{"v":25000,"d":"25,000.00"}}]
[]
["3.13.2",null,"WATER CONNECTION","SUM",{"v":1,"d":"1.00"},{"v":10000,"d":"10,000.00"},{"$f":"E695*F695","v":{"v":10000,"d":"10,000.00"}}]
[]
["3.13.3",null,"CALCAMITE SEPTIC TANL OR SIMILAR APPROVED SUPPLY AND INSTALLATION","SUM",{"v":1,"d":"1.00"},{"v":40000,"d":"40,000.00"},{"v":40000,"d":"40,000.00"}]
{"$rows_empty":36}
[null,null,"CARRIED FORWARD TO SUMMARY"]
[null,"SUMMARY"]
[]
[null,null,"Page 1 - Earthwork"]
[null,null,"Page 2 - Concrete & Formwork"]
[null,null,"Page 3 - Masonry"]
[null,null,"Page 4 - Waterproofing"]
[null,null,"Page 5 - Carpentry & Joinery"]
[null,null,"Page 6 - Floor Coverings & Linings"]
[null,null,"Page 7 - Ironmongery"]
[null,null,"Page 8 - Metalwork"]
[null,null,"Page 9 - Plastering"]
[null,null,"Page 10 - Plumping & Drainage"]
[null,null,"Page 11 - Glazing"]
[null,null,"Page 12 - Paintwork"]
[null,null,"Page 13 - Provisional Sums"]
[null,null,"Total"]

{"sheet":"4-GUARD HOUSE 2","index":3,"n_rows":750,"n_cols":8,"rows_kept":750,"merged":[[734,1,734,6],[739,2,739,4]]}
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[4,null,"GUARD HOUSE 2"]
[3]
["4.1",null,"BILL NO. 1"]
[]
[null,null,"EARTHWORKS"]
[]
["4.1.1",null,"Site clearance"]
[]
["4.1.1.1","SANS 1200C 8.2.1","Digging up and remoing rubbish, debris, vegetation, hedge, shrubs, bush etc and trees not exceeding 200mm girth","m²",{"v":50,"d":"50.00"}]
[]
["4.1.1.2","8.2.10","Remove top 150mm, around the building","m²",30]
[]
["4.1.2","SANS 1200DA","EARTHFILLING"]
[]
["4.1.2.1","8.3.4","Backfill with G5 material to create level platform compacted to 95% AASHTO MOD.","m³",{"$f":"3.6*3.4*0.3","v":{"v":3.6719999999999997,"d":"4"}}]
[]
["4.1.2.2",null,"Backfilling to trenches","m³",{"$f":"(3.6+3.6+3.5)*2*0.5*0.25","v":{"v":2.675,"d":"3"}}]
[]
["4.1.3","8.3.2","EXCAVATIONS"]
[]
[null,null,"Excavate in earth not exceeding 2m deep"]
[]
["4.1.3.1",null,"Trenches","m³",{"$f":"A2","v":4}]
["4.1.3.2",null,"Extra over excavation in soft rock","m³",1]
["4.1.3.3",null,"Extra over excavation in hard rock","m³",1]
[]
[null,null,"Extraover all excavations for carting away"]
[]
["4.1.3.4","8.3.3","Surplus material from excavations or stockpile on site to a dumping site","m³",{"$f":"E24","v":4}]
[]
[null,null,"Keeping excavation free of water"]
[]
["4.1.3.5",null,"Keeping excavations free of water other than subterranean water","item",1]
[]
[null,"8.3.7","Risk of collapse"]
[]
["4.1.3.6",null,"Sides of excavations not exceeding 1.5m deep","m²",{"$f":"A2*0.7*2","v":{"v":5.6,"d":"6"}}]
[]
[null,"8.3.9","Filling etc"]
[]
["4.1.3.7.",null,"Earth filling obtained from excavations and/or prescibed stock piles on site, compacted to 95 Mod AASHTO density"]
[]
["4.1.3.8",null,"Under floors","m³",{"$f":"3.6*3","v":{"v":10.8,"d":"11"}}]
[]
["4.1.3.9",null,"Backfilling to trenches, holes etc","m³",{"$f":"A2*0.24*2*0.5","v":{"v":0.96,"d":"1"}}]
[]
[null,null,"Weed killers, insecticides, etc"]
["4.1.3.10",null,"Bottom and side of trenchs","m²",{"$f":"A2*2.1","v":{"v":8.4,"d":"8"}}]
["4.1.3.11",null,"Bottom of surfacebed","m²",{"$f":"3.6*3","v":{"v":10.8,"d":"11"}}]
[]
[null,null,"CARRIED FORWARD"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
["4.2",null,"BILL NO. 2"]
[]
[null,"SANS1200 GA","CONCRETE, FORMWORK AND REINFORCEMENT"]
[]
["4.2.1.","8.4.2","15MPa/19MM CONCRETE"]
[]
["4.2.1.1.",null,"Surface blinding under footings and bases","m³",{"$f":"A2*0.7*0.05","v":{"v":0.13999999999999999,"d":"0.1"}}]
[]
["4.2.2.","8.4.3","CONCRETE FOUNDATION"]
[]
["4.2.2.1",null,"25MPa/19mm concrete footing","m³",{"$f":"A2*0.7*0.2","v":{"v":0.5599999999999999,"d":"1"}}]
["4.2.2.2",null,"20MPa/19mm surfacebed","m³",{"$f":"3.6*3.1","v":{"v":11.16,"d":"11"}}]
["4.2.2.3",null,"20MPa/19mm Apron","m³",{"$f":"(A2+4)*1*0.05","v":{"v":0.4,"d":"0"}}]
[]
["4.2.3","8.4.3","CONCRETE SLAB"]
[]
["4.2.3.1",null,"25MPa/19mm slabs including beams andinverted beams","m³",{"$f":"3.9*3.3*0.17","v":{"v":2.1879,"d":"2"}}]
[]
["4.2.4","8.3.1","HIGH STRENGTH STEEL REINFORCEMENT"]
[]
["4.2.4.1",null,"Y12 Bars ","t",{"$f":"(A2*4*0.888*0.001)+(14*3.3*0.888*2*0.001)+(11*0.888*3.9*2*0.001)","v":{"v":0.17244959999999998,"d":"0.17"}}]
[]
["4.2.5","8.3.1","MILD STRENGTH STEEL"]
[]
["4.2.5.1",null,"R8 bars","t",{"$f":"A2/0.3*2*0.4*0.001","v":{"v":0.010666666666666668,"d":"0.01"}}]
[]
[null,"8.3.2","Fabric Reinforcement"]
[]
["4.2.5.2.",null,"Mesh ref 193","m²",{"$f":"3.6*3","v":{"v":10.8,"d":"11"}}]
["4.2.5.3",null,"Mesh ref 100","m²",{"$f":"A2*1+4*0.6","v":{"v":6.4,"d":"6"}}]
[]
["4.2.6","8.4.4","CONCRETE FINISHES"]
["4.2.6.1",null,"Woodfloat finishing to surface bed","m²",{"$f":"3.6*3","v":{"v":10.8,"d":"11"}}]
["4.2.6.2",null,"Woodfloat finishing to apron ","m²",{"$f":"E84","v":{"v":6.4,"d":"6"}}]
["4.2.6.3",null,"Woodfloat finishing to roof slab","m²",{"$f":"3.6*3.5","v":{"v":12.6,"d":"13"}}]
[]
["4.2.6.4",null,"50mm diameter sleeves","m",50]
[]
["4.2.7","8.2","FORMWORK"]
[]
["4.2.7.1","8.2.2","Formwork to soffit of concrete slab","m²",{"$f":"3.9*3.3","v":{"v":12.87,"d":"13"}}]
["4.2.7.2",null,"Formwork to sides of concrete not exceeding 300mm","m",{"$f":"3.9*2+3.3*2","v":{"v":14.399999999999999,"d":"14"}}]
[]
["4.2.8",null,"Prescribed density tests on filling"]
[]
["4.2.8.1.",null,"Modified AASHTO Density tests","No",2]
[null,null,"Concrete Sundries"]
[]
["4.2.8.2",null,"Making and testing 150x150x150mm concrete test cubes","Item",2]
[]
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 3"]
[]
["4.3",null,"MASONRY"]
[]
[null,"PQA 15.1","Brickwork of NFP bricks in class II mortar"]
[]
["4.3.1",null,"One brick wall in foundation","m²",{"$f":"A2*0.5","v":2}]
[]
["4.3.2","PQA 15.1","Brickwork of FBX bricks in class II mortar"]
[]
["4.3.2.1.",null,"One brickwall in supperstructure","m²",{"$f":"A2*3","v":12}]
[]
["4.3.2.2",null,"115mm common brick","m²",{"$f":"3*3","v":9}]
[]
["4.3.3",null,"Brickwork reinforcement"]
[]
["4.3.3.1","PQA 15.1","a) Brick reinforcement 75mm wide built into brick walls with sufficient laps at end joints, angles and intersections (measured net)","m",{"$f":"2700/340*3","v":{"v":23.823529411764707,"d":"24"}}]
[]
["4.3.3.2","PQA 15.1","b) Brick reinforcement 150mm wide built into brick walls with sufficient laps at end joints, angles and intersections (measured net)","m",{"$f":"3500/255*A2","v":{"v":54.90196078431372,"d":"55"}}]
[]
["4.3.3.4",null,"JOINTS IN WALLS, FLOORS AND ROOF"]
[]
["4.3.4.1",null,"Maltoid on walls ","m",{"$f":"A2+3","v":7}]
[]
["4.3.4.2",null,"Saw cut joints on floor and apron ","m",12]
[]
[null,null,"Prestressed fabricated Lintels"]
[]
["4.3.4.3","PQA 15.5","110x170mm lintel in lengths not exceeding 3m","No.",{"v":12,"d":"12.00"}]
{"$rows_empty":21}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 4"]
[]
["4.4",null,"WATERPROOFING"]
[]
["4.4.1.","PQA 15.4","DPC 250micron in solid walls","m",{"$f":"A2","v":{"v":4,"d":"4.00"}}]
[]
["4.4.2",null,"170micron dpm under surfacebed laid with 150mm overlaps","m²",{"$f":"3.6*3","v":{"v":10.8,"d":"10.80"}}]
[]
["4.4.3","PQA 16.4","Bituminous aluminium paint finish to concrete roof","m²",{"$f":"3.9*3.3","v":12.87}]
[]
["4.4.4","PQA 16.4","double malthoid between concrete and brick surfaces","m",{"$f":"A2+3","v":{"v":7,"d":"7.00"}}]
{"$rows_empty":44}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 5"]
[]
["4.5",null,"CARPENTRY AND JOINERY"]
[]
["4.5.1",null,"Doors etc"]
[]
["4.5.2",null,"44mm solid core masonite door with hardwood edge strips on both side 877x2100mm","no.",{"v":2,"d":"2.00"}]
{"$rows_empty":49}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 6"]
[]
["4.6",null,"FLOOR COVERINGS, WALL LINNINGS ETC"]
["4.6.1","PQB 7.5.1","Floor tiles ","m²",{"$f":"3.6*3.5","v":{"v":12.6,"d":"12.60"}}]
[]
["4.6.2","PQB 7.5.1","Walls tiles","m²",{"v":1,"d":"1.00"}]
{"$rows_empty":51}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 7"]
[]
["4.7",null,"IRONMONGERY"]
[]
[null,null,"Hinges, Bolts etc"]
[]
["4.7.1",null,"Brass hinges with nylon washers","No",{"v":4,"d":"4.00"}]
[]
[null,null,"Locks"]
["4.7.2"]
[null,null,"2 lever motice lockest and handles","No.",{"v":2,"d":"2.00"}]
[]
["4.7.3",null,"Bathroom fittings"]
[]
["4.7.3.1",null,"Satin stainless steel paper towel dispensor","No.",{"v":1,"d":"1.00"}]
[]
["4.7.3.2",null,"Toilet roll holder","No.",{"v":1,"d":"1.00"}]
{"$rows_empty":41}
[null,null,"CARRIED FORWARD TO SUMMARY",{"$nulls":3},{"$f":"SUM(G339:G395)","v":{"v":0,"d":"0.00"}}]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 8"]
[]
["4.8",null,"METALWORK"]
[]
[null,null,"Welded screens"]
["4.8.1"]
[null,null,"Security mild steel gate","No.",{"v":1,"d":"1.00"}]
[]
["4.8.2",null,"Prestressed steel door frames"]
[]
["4.8.2.1","PQA 15.3","1.2mm double rebate frame suitable for one brick wall","No.",{"v":1,"d":"1.00"}]
[]
["4.8.2.2",null,"1.2mm rebate frame suitable for half brick wall","No.",{"v":1,"d":"1.00"}]
[]
["4.8.3",null,"Window frames"]
[]
["4.8.3.1","PQA 15.3","Type C1","No",{"v":1,"d":"1.00"}]
[]
["4.8.3.2.",null,"Type C2","No",{"v":3,"d":"3.00"}]
{"$rows_empty":36}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 9"]
[]
["4.9",null,"PLASTERING"]
[]
["4.9.1",null,"SCREED"]
[]
["4.9.1.1","PQA 17.1","3:1 Cement plaster screed woodfloated on concrete"]
[]
["4.9.1.2",null,"30mm thick screed on floors ","m²",{"$f":"3.2*2.8","v":{"v":8.959999999999999,"d":"8.96"}}]
[]
["4.9.1.3",null,"50mm thick screed on roof","m²",{"$f":"3.6*3.5","v":{"v":12.6,"d":"12.60"}}]
[]
["4.9.2",null,"Internal Plaster"]
[]
["4.9.2.1","PQA 17.1","One coat cement plaster and one coat rhinolite plaster"]
[]
["4.9.2.2",null,"On walls","m²",{"$f":"(A2-0.9)*3","v":{"v":9.3,"d":"9.30"}}]
[]
["4.9.2.3",null,"on soffit of concrete slab","m²",{"$f":"3.9*3.3","v":12.87}]
{"$rows_empty":37}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 10"]
[]
["4.10",null,"PLUMBING AND DRAINAGE"]
[]
["4.10.1","PQF 5.1","Sanitary fittings"]
[]
["4.10.1.1",null,"Waste chamber","No.",{"v":1,"d":"1.00"}]
[]
["4.10.1.2",null,"Wash hand basin","No.",{"v":1,"d":"1.00"}]
[]
["4.10.1.3",null,"Basin waste union","No.",{"v":1,"d":"1.00"}]
[]
["4.10.1.4",null,"\"P\" trap","No.",{"v":1,"d":"1.00"}]
[]
["4.10.2","PQF 5.1","Sanitary plumbing"]
[]
["4.10.2.1",null,"uPVC, soil and vent pipes"]
[]
["4.10.2.2",null,"50mm pipes ","m",{"v":10,"d":"10.00"}]
[]
["4.10.2.3",null,"110mm pipes","m",{"v":100,"d":"100.00"}]
[]
["4.10.3","PQF 5.1","Extra over uPVC, soil, vent pipes for fittings"]
[]
["4.10.3.1",null,"110mm access bend with anti-siphon horn","No.",{"v":1,"d":"1.00"}]
[]
["4.10.3.2",null,"110mm Pan connector","No.",{"v":1,"d":"1.00"}]
[]
["4.10.3.3",null,"110mm x 50mm eccentric reducer","No.",{"v":1,"d":"1.00"}]
[]
["4.10.3.4",null,"110mm junction","No.",{"v":1,"d":"1.00"}]
[]
["4.10.3.5",null,"110mm air  vent cowl","No.",{"v":1,"d":"1.00"}]
[]
["4.10.3.6",null,"110mm GI vent valve","No.",{"v":1,"d":"1.00"}]
[]
["4.10.3.7",null,"110mm coupling","No.",{"v":15,"d":"15.00"}]
[]
["4.10.3.8",null,"50mm 90 degree bends","No.",{"v":4,"d":"4.00"}]
[]
["4.10.3.9",null,"50mm to 110 90 degree connector","No.",{"v":1,"d":"1.00"}]
{"$rows_empty":16}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 11"]
[]
["4.11",null,"GLAZING"]
[]
["4.11.1",null,"Windor glazing"]
[]
["4.11.1.1",null,"Type C1: 4mm obscured glazing","m²",{"$f":"0.6*0.9","v":0.54}]
[]
["4.11.1.2",null,"Type C2:clear glazing ","m²",{"$f":"1.5*1.2","v":{"v":1.7999999999999998,"d":"1.80"}}]
[]
[null,null,"Mirrors"]
[]
["4.11.1.3",null,"Stainless steel mirrors 500x600x13mm, concealed thief resistant fixings, plugged and screwed to the wall, stainless steel screws","No.",{"v":1,"d":"1.00"}]
{"$rows_empty":42}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 12"]
[]
["4.12",null,"PAINTWORK "]
[]
["4.12.1",null,"On floated plaster"]
[]
["4.12.1.1","PQH 4.1","Apply one coat plascon merit plaster prime, two coats double velvet pure acrylic "]
[]
["4.12.1.2",null,"On internal walls","m²",{"$f":"A2*3+6*3","v":{"v":30,"d":"30.00"}}]
[]
["4.12.2",null,"On smooth concrete "]
[]
["4.12.2.1","PQH 4.1","Prepare areas with slash coat and apply one coat universal undercoat and two coats plascon acrylic white"]
[]
["4.12.2.2",null,"On soffits","m²",{"$f":"3.9*3.3","v":12.87}]
[]
["4.12.3",null,"On metals"]
[]
["4.12.3.1",null,"One coat universal undercoat and two coats plascon"]
[]
[null,"PQH 4.2","On door frames","m²",{"$f":"5*0.3*2","v":{"v":3,"d":"3.00"}}]
[]
["4.12.3.2",null,"On wood"]
[]
["4.12.3.2.1","PQH 4.2","One coat undercoat and apply three coats clear matt varnish plascon polyurethane matt varnish"]
[]
["4.12.3.2.2",null,"On doors","m²",{"$f":"0.85*2.1*2","v":3.57}]
{"$rows_empty":25}
[null,null,"CARRIED FORWARD TO SUMMARY"]
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"BILL NO. 13"]
[]
["4.13",null,"PROVISIONAL SUM"]
[]
["4.13.1",null,"ELECTRICAL","SUM",{"v":1,"d":"1.00"},{"v":25000,"d":"25,000.00"}]
[]
["4.13.2",null,"WATER CONNECTION","SUM",{"v":1,"d":"1.00"},{"v":10000,"d":"10,000.00"}]
[]
["4.13.3",null,"CALCAMITE SEPTIC TANL OR SIMILAR APPROVED SUPPLY AND INSTALLATION","SUM",{"v":1,"d":"1.00"},{"v":40000,"d":"40,000.00"}]
{"$rows_empty":36}
[null,null,"CARRIED FORWARD TO SUMMARY"]
[null,"SUMMARY"]
[]
[null,null,"Page 1 - Earthwork"]
[null,null,"Page 2 - Concrete & Formwork"]
[null,null,"Page 3 - Masonry"]
[null,null,"Page 4 - Waterproofing"]
[null,null,"Page 5 - Carpentry & Joinery"]
[null,null,"Page 6 - Floor Coverings & Linings"]
[null,null,"Page 7 - Ironmongery"]
[null,null,"Page 8 - Metalwork"]
[null,null,"Page 9 - Plastering"]
[null,null,"Page 10 - Plumping & Drainage"]
[null,null,"Page 11 - Glazing"]
[null,null,"Page 12 - Paintwork"]
[null,null,"Page 13 - Provisional Sums"]
[null,null,"Total",{"$nulls":4},{"$f":"G750*2","v":0}]

{"sheet":"5-BOUNDARY WALL","index":4,"n_rows":76,"n_cols":7,"rows_kept":76}
["ITEM NO.","PAYMENT REFERS","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[693,null,"JOHANNESBURG WATER LAANGLAGTE DEPOT"]
[]
[5,null,"Construction of a Boundary wall"]
[]
[null,null,"Site clearance"]
[]
["5.1","SANS1200 C 8.2.1","Dig up and remove rubbish, debris, vegetation, hedges, shrubs and trees not exceeding 200mm girth, bush etc.","m²",{"$f":"A3*3","v":{"v":2079,"d":"2,079.00"}}]
[]
["5.2",null,"EXCAVATION, FILLING, ETC."]
[]
[null,"SANS 1200DA","Excavation in earth not exceeding 2m. deep"]
[]
["5.2.1","8.3.2","Trenches.","m³",{"$f":"(A3*0.75*0.7)+(A3/3.2*0.7*1.3*0.6)","v":{"v":482.068125,"d":"482.07"}}]
[]
["5.2.2",null,"Extra over Blasting of trench and hole excavations in earth for excavation in"]
[]
["5.2.2.1",null,"Soft rock.","m³",{"$f":"0.1*E15","v":{"v":48.206812500000005,"d":"48.21"}}]
["5.2.2.2",null,"Hard rock.","m³",{"$f":"0.05*E15","v":{"v":24.103406250000003,"d":"24.10"}}]
[]
[null,null,"Extra over all excavations for carting away"]
[]
["5.2.3","8.3.3","Surplus material from excavations and /or stock pile on site to a dumping site to be located by the contractor (up to a radius of 5km - return distance not covered)","m³",{"$f":"(A3*0.7*0.35)+(A3*0.23*0.4)","v":{"v":233.54099999999997,"d":"233.54"}}]
[]
[null,null,"Risk of collapse of excavations"]
[]
["5.2.4","8.3.7","Sides of trench and hole excavations not exceeding 1,5m deep including keeping excavations free from water","m²",{"$f":"A3*2*0.75","v":{"v":1039.5,"d":"1,039.50"}}]
[]
[null,null,"Keeping excavations free of water"]
[]
["5.2.5",null,"Keeping excavations free of water other than subterranean water","Item",{"v":1,"d":"1.00"}]
[]
[null,null,"Earth filling obtained from excavations and/or prescribed stock piles on site compacted to 95% Mod AASHTO density "]
[]
["5.2.6","8.3.9","Backfill to trenches, holes, etc.","m³",{"$f":"E15-E24","v":{"v":248.52712500000004,"d":"248.53"}}]
[]
[null,null,"SOIL POISONING"]
[]
[null,null,"Weedkillers, Insecticides, etc. Environmentaly friendly and SABS approved."]
[]
["5.3",null,"Bottoms and sides of trenches etc.","m²",{"$f":"A3*(0.75+0.75+0.7)","v":{"v":1524.6000000000001,"d":"1,524.60"}}]
[]
["5.4","SANS 1200GA","25MPa/20mm. concrete"]
[]
["5.4.1","8.4.3","Strip footings and bases","m³",{"$f":"A3*0.7*0.35+(A3/3.2*0.3*1.3*0.6)","v":{"v":220.46062499999996,"d":"220.46"}}]
[]
["5.4.2","8.4.3","Column concrete in-fill","m³",{"$f":"A3/3.2*0.22*0.22*3","v":{"v":31.444874999999996,"d":"31.44"}}]
[]
["5.5",null,"REINFORCEMENT"]
[]
[null,null,"Hight strengh steel reinforcement to structural concrete work"]
[]
["5.5.1","8.3.1","12mm. diameter bars","t",{"$f":"(A3*1.1*4*0.888*0.001)+(A3/3.2*4*1.2*0.888*0.001)","v":{"v":3.6307656,"d":"3.63"}}]
[]
[null,null,"Mild strengh steel reinforcement to structural concrete work"]
[]
["5.5.2","8.3.1","8mm diameter bars","t",{"$f":"(A3/0.3*2*0.4*0.001)+(A3/3.2*10*0.4*0.7*0.001)","v":{"v":2.454375,"d":"2.45"}}]
[]
["5.6",null,"PRECAST WALL"]
[]
["5.6.1",null,"3M High Concrete Heavy duty Prestressed 150mm thick wall with concrete columns complete with Design, Surverying, Engineers Certificate, supply and Installation. ","m",{"v":835,"d":"835.00"}]
[]
["5.6.2",null,"1m High 40x40x2 Palisade fixed to concrete palisade","m",{"v":835,"d":"835.00"}]
[]
["5.6.3",null,"Razor wire"]
[]
["5.6.3.1",null,"Supply and install 800mm diameter spiral razor wire including all accessories.","m",{"v":835,"d":"835.00"}]
[]
["5.6.3.2",null,"Supply and install razor wire flat wrap including all accessories.","m",{"$f":"E68*2","v":{"v":1670,"d":"1,670.00"}}]
[]
[null,null,"ELECTRIC GATE"]
[]
["5.6.4",null,"Supply and install double sliding gate and boom to match security fencing as per drawing","No",1]
[]
[null,null,"TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(G9:G75)","v":0}]

{"sheet":"6-Summary","index":5,"n_rows":46,"n_cols":20,"rows_kept":46,"merged":[[3,2,3,4]]}
[]
[null,"SUMMARY OF BILL OF QUANTITIES: LAANGLATGE DEPOT"]
[]
[null,"BILL","DESCRIPTION",{"$nulls":6},"TOTAL"]
[]
[null,1,"PRELIMINARY AND GENERAL",{"$nulls":5},"R"]
[]
[null,2,"DAY WORKS & PROVISIONAL SUMS",{"$nulls":5},"R"]
[]
[null,3,"GUARD HOUSE No. 1",{"$nulls":5},"R"]
[]
[null,4,"GUARD HOUSE No. 2",{"$nulls":5},"R"]
[]
[null,5,"BOUNDARY WALL",{"$nulls":5},"R"]
{"$rows_empty":17}
[{"$nulls":19},"`"]
[]
[]
[]
[]
[]
[null,"TOTAL FOR SCHEDULE OF QUANTITIES",{"$nulls":6},"R"]
[]
[null,"ADD 10 % CONTINGENCY"]
[]
[null,"SUB-TOTAL"]
[]
[null,"ADD 15 % VAT",{"$nulls":6},"R"]
[]
[null,"TOTAL FOR TENDER (FORWARD TO THE FORM OF TENDER)",{"$nulls":6},"R"]

{"sheet":"450mm Bedding","index":6,"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":7,"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":8,"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":9,"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]