{"text_format":"3","workbook":"xlsx","n_sheets":24,"sheets":["Schedule A","Schedule B","Schedule C","Schedule D","Schedule E","Schedule F","Schedule G","Schedule H","Schedule J","Schedule K","SCHED MA","SCHED MB","SCHED MC","SCHED MD","SCHED ME","SCHED MF","SCHED MG","SCHED EA","SCHED EB","SCHED EC","SCHED ED","SCHED EF","SCHED EG","SUMMARY"],"not_rendered":{"external_links":2,"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"Schedule A","index":0,"n_rows":168,"n_cols":9,"rows_kept":168,"merged":[[0,2,0,4],[1,2,1,4],[2,2,2,4],[7,2,8,2],[128,4,130,4],[132,4,133,4]]}
[null,null,"CONTRACT NO"]
[null,null,"WINBURG WATER TREATMENT WORKS"]
[null,null,"SCHEDULE A: GENERAL SITE WORKS"]
[]
[null,null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,null,"NO","CLAUSE"]
[]
[null,null,"A.1","SANS"]
[{"$nulls":3},"1200A","FIXED CHARGED ITEMS"]
[{"$nulls":3},8.3,{"$nulls":4},{"$f":"IF(G10>0,ROUND(G10*H10,2),\"\")","v":""}]
[]
[null,null,"A.1.1"," 8.3.1","Contractual requirements ","sum",1]
[]
[{"$nulls":3},"8.3.2","ESTABLISH FACILITIES ON THE SITE"]
[]
[{"$nulls":3},"8.3.2.1","FACILITIES FOR THE ENGINEER"]
[]
[null,null,"A.1.2","PSAB 3.1","Name board","no",1]
[]
[null,null,"A.1.3","PSAB 3.2","Engineer's office and facilities","sum",1]
[{"$nulls":8},""]
[null,null,"A.1.4","PSAB 4.1","Telephone/cellphone","prov sum",1,{"v":8000,"d":"R8,000.00"},{"v":8000,"d":"R8,000.00"}]
[{"$nulls":8},""]
[null,null,"A.1.5",null,"Contractor's mark up on Item A.1.4","%",{"$f":"H22","v":{"v":8000,"d":"8,000.00"}}]
[]
[{"$nulls":3},"8.3.2.2","FACILITIES FOR CONTRACTOR"]
[]
[null,null,"A.1.6",null,"Office and storage sheds","sum",1]
[]
[null,null,"A.1.7",null,"Workshops","sum",1]
[]
[null,null,"A.1.8",null,"Laboratories","sum",1]
[]
[null,null,"A.1.9",null,"Living accommodation","sum",1]
[]
[null,null,"A.1.10",null,"Ablution and toilet facilities","sum",1]
[]
[null,null,"A.1.11",null,"Tools and equipment","sum",1]
[]
[null,null,"A.1.12",null,"Water supply, electic power and communications","sum",1]
[]
[null,null,"A.1.13",null,"Dealing with water (sub clause PSA 5.5)","sum",1]
[]
[null,null,"A.1.14",null,"Access","sum",1]
[]
[null,null,"A.1.15",null,"Other fixed charged obligations(specify)","sum",1]
[{"$nulls":4},"______________________________________________________________________________"]
[null,null,"A.1.16",null,"Remove engineer's and contractor's site establishment on completion of contract","sum",1]
[]
[]
[null,null,"A.2",8.4,"TIME RELATED ITEMS"]
[]
[null,null,"A.2.1","8.4.1","Contractual requirements ","sum",1]
[]
[{"$nulls":3},"8.4.2","OPERATION AND MAINTENANCE OF FACILITIES ON SITE"]
[{"$nulls":4},"FOR DURATION OF CONSTRUCTION"]
[]
[{"$nulls":3},"8.4.2.1","FACILITIES FOR ENGINEER"]
[]
[null,null,"A.2.2","PSAB 3.1","Name board","sum",1]
[]
[null,null,"A.2.3","PSAB 3.2","Engineer's office and facilities","sum",1]
[]
[]
[]
[]
[{"$nulls":4}," CARRIED FORWARD"]
[{"$nulls":4},"BROUGHT FORWARD"]
[]
[null,null,"A.2.4","PSAB 4.1","Telephone","prov sum",1,{"v":8000,"d":"R8,000.00"}]
[]
[null,null,"A.2.5",null,"Contractor's mark up on Item A.2.4","%",{"$f":"H70","v":{"v":8000,"d":"8,000.00"}}]
[]
[{"$nulls":3},"8.4.2.2","FACILITIES FOR CONTRACTOR FOR THE DURATION"]
[{"$nulls":4},"OF CONSTRUCTION"]
[]
[null,null,"A.2.6",null,"Offices and storage sheds","sum",1]
[]
[null,null,"A.2.7",null,"Workshops","sum",1]
[]
[null,null,"A.2.8",null,"Laboratories","sum",1]
[]
[null,null,"A.2.9",null,"Living accommodation","sum",1]
[]
[null,null,"A.2.10",null,"Ablution and toilet facilities","sum",1]
[]
[null,null,"A.2.11",null,"Tools and equipment","sum",1]
[]
[null,null,"A.2.12",null,"Water supply, electric power and communications","sum",1]
[]
[null,null,"A.2.13",null,"Dealing with water (sub clause 5.5)","sum",1]
[]
[null,null,"A.2.14",null,"Access","sum",1]
[]
[null,null,"A.2.15","8.4.5","Other time related obligations (specify)","sum",1]
[]
[null,null,"A.3",8.5,"PROVISIONAL ITEMS"]
[]
[null,null,"A.3.1",null,"Community liaison officer","prov sum",1]
[]
[null,null,"A.3.2",null,"Contractor's mark up on Item A.3.1","%",{"$f":"H99","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"A.4","PSA 8.4.6","STANDING TIME COSTS"]
[]
[null,null,"A.4.1","a","Labour (Rate only)","sum/day"]
[]
[null,null,"A.4.2","b","Other resources (Rate only)","sum/day",null,null,{"$f":"IF(G107>0,ROUND(G107*H107,2),\"\")","v":""}]
[{"$nulls":8},""]
[null,null,"A.4.3","PSA 8.7","Daywork (provisional)","prov sum",1,{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"}]
[{"$nulls":8},""]
[{"$nulls":8},""]
[null,null,"A.5",8.6,"SUMS STATED PROVISIONALLY BY ENGINEER",{"$nulls":3},""]
[{"$nulls":8},""]
[null,null,"A.5.1","a","Additional tests required by the Engineer","prov sum",1,{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"}]
[{"$nulls":8},""]
[null,null,"A.5.2","b","Overheads, profit and charges on A.5.1 above","%",{"$f":"H114","v":{"v":50000,"d":"50,000.00"}}]
[{"$nulls":8},""]
[]
[]
[]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":4}," CARRIED FORWARD"]
[{"$nulls":4},"BROUGHT FORWARD"]
[{"$nulls":8},""]
[null,null,"A.6","PSA 8.9","OCCUPATIONAL HEALTH AND SAFETY MEASURES",{"$nulls":3},""]
[{"$nulls":8},""]
[null,null,"A.6.1","PSA 8.9.1","Cost of health and safety measures required in terms of the Construction Regulations (2003) of the Occupational Health and Safety act","sum",1]
[]
[]
[]
[null,null,"A.6.2","PSA 8.9.2","Including Risk Assessments, Safe Work Procedures and Method Statements","sum",1]
[]
[]
[null,null,"A.6.3","PSA 8.9.3","Compilation and maintenance of a Health and Safety File","sum",1]
[]
[null,null,"A.7","PSA 8.10","ENVIRONMENTAL MANAGEMENT PLAN"]
[]
[null,null,"A.7.1","PSA 8.10.1","Providing a Method Statement on compliance with client's Environmental Management Plan Specification","sum",1]
[]
[null,null,"A.7.2","PSA 8.10.2","Complying with requirements of the Environmental Management Plan","sum",1]
[{"$nulls":8},{"$f":"IF(G143>0,ROUND(G143*H143,2),\"\")","v":""}]
[]
[]
[]
[]
[]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[]
[]
[{"$nulls":4},"TOTAL FOR SCHEDULE A (CARRIED FORWARD TO SUMMARY)",{"$nulls":3},{"$f":"SUM(I125:I167)","v":0}]

{"sheet":"Schedule B","index":1,"n_rows":116,"n_cols":9,"rows_kept":116,"merged":[[0,2,0,4],[1,2,1,4],[2,2,2,4],[115,2,115,7]]}
[null,null,"CONTRACT NO"]
[null,null,"WINBURG WATER TREATMENT WORKS"]
[null,null,"SCHEDULE B: GENERAL SITE WORKS"]
[]
[null,null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,null,"NO","CLAUSE"]
[]
[null,null,"B.1","SANS"]
[{"$nulls":3},"1200C","SITE CLEARANCE"]
[]
[null,null,"B.1.1","8.2.1","Clear and grub small trees and bushes","m²",400]
[]
[{"$nulls":3},"8.2.2","REMOVE AND GRUB LARGE TREES AND TREE STUMPS OF GIRTH"]
[]
[null,null,"B.1.2","(a)","Over 1 m and up to 2 m","no",1]
[]
[null,null,"B.1.3","(b)","Over 2 m and up to 3 m","no",1]
[]
[null,null,"B.1.4","8.2.4","Reclear surfaces (provisional) (where ordered by the Engineer)","m²",100]
[]
[{"$nulls":3},"SANS","EARTHWORKS"]
[{"$nulls":3},"1200D"]
[]
[null,null,"B.2","8.3.2","EXCAVATION"]
[]
[null,null,"B.2.1","8.3.1.2","Remove topsoil to nominal depth of 100 mm, stockpile and maintain","m²",200]
[]
[{"$nulls":4},"BULK EARTHWORKS"]
[]
[{"$nulls":3},"8.3.2(a)","EXCAVATE IN ALL MATERIALS AND USE FOR EMBANKMENT, TERRACE CONSTRUCTION, BACKFIL OR DISPOSE WITHIN 1.5 km"]
[]
[null,null,"B.2.2",null,"Cut to fill for forming terraces compacted to 93% MOD AASHTO density","m³",50]
[]
[null,null,"B.2.3",null,"Cut to stockpile for forming terraces (only when ordered)","m³",50]
[]
[null,null,"B.2.4",null,"Stockpile to fill for forming terraces (only when ordered) compacted to 93% MOD AASHTO density","m³",50]
[]
[null,null,"B.2.5",null,"Cut to spoil","m³",50]
[]
[{"$nulls":3},"8.3.3(b)","EXTRA OVER ITEMS B.2.2 to B.2.5 FOR EXCAVATIONS IN:"]
[]
[null,null,"B.2.6",null,"Hard rock material","m³",50]
[]
[null,null,"B.2.7","8.3.6","Overhaul (provisional)","m³km",500]
[]
[null,null,"B.3","SANS 1200MJ","SEGMENTED CONCRETE BLOCK PAVING AROUND STRUCTURES ON TERRACES"]
[]
[null,null,"B.3.1",8.1,"Preparation of area to be paved","m²",200]
[]
[null,null,"B.3.2","8.2.2","Construction of paving with 60 mm thick concrete blocks (natural colour) including sandbed complete","m²",200]
[]
[null,null,"B.3.3","8.2.1","Extra over item B.3.2 for provision and installation of edge restraints consisting of kerbing as per SANS 927 Fig. 6","m",200]
[]
[{"$nulls":3},"8.2.3","CUTTING UNITS TO FIT EDGE RESTRAINTS"]
[]
[null,null,"B.3.4",null,"Straight","m",200]
[]
[{"$nulls":4},"CARRIED FORWARD"]
[{"$nulls":4},"BROUGHT FORWARD"]
[]
[null,null,"B.3.5",null,"Circular","m",50]
[]
[]
[null,null,"B.4",null,"ROAD CONSTRUCTION"]
[]
[{"$nulls":3},"SANS 1200DM","EARTHWORKS"]
[]
[null,null,"B.4.1","8.3.2(a)","Remove topsoil 150 mm deep to stockpile and maintain","m³",30]
[]
[null,null,"B.4.2","8.3.7","Excavate in all materials and spoil","m³",20]
[]
[{"$nulls":4},"CUT TO FILL"]
[]
[null,null,"B.4.3","8.3.4","Compact to 90% Mod. AASHTO maximum density","m³",30]
[]
[{"$nulls":4},"TREATMENT OF ROAD-BED"]
[]
[null,null,"B.4.4","8.3.3(a)","Road-bed preparation (150 mm thick) and compaction of material to 93% Mod. AASHTO maximum density","m³",90]
[]
[{"$nulls":3},"8.3.13","SURFACE FINISHES"]
[]
[null,null,"B.4.5",null,"Topsoiling and grading shoulders","m²",200]
[]
[{"$nulls":3},"1200ME","SUBBASE (95% Mod. AASHTO MAXIMUM DENSITY)"]
[]
[{"$nulls":4},"CONSTRUCT GRAVEL BASE WITH MATERIAL FROM DESIGNATED EXCAVATIONS:"]
[]
[null,null,"B.4.6","8.3.1","Construct base with material from borrow pits or stockpiles within the freehaul distance","m³",30]
[]
[null,null,"B.4.7","8.3.1","Construct subbase with material from obtained from commercial sources","m³",60]
[]
[null,null,"B.4.8","8.3.5","Process material by means of stabilising","m³",90]
[]
[null,null,"B.4.9","8.3.8","Stabilising agent : Portland blast furnace cement (3% by mass)","t",3]
[]
[{"$nulls":4},"OVERHAUL"]
[]
[null,null,"B.4.10","8.3.9","Extra over item B.4.7 for hauling material in excess of the freehaul distance","m³.km",500]
[]
[{"$nulls":3},"SABS"]
[{"$nulls":3},"1200MJ","SEGMENTED CONCRETE BLOCK PAVING ON ROADS"]
[]
[null,null,"B.4.11",8.1,"Preparation of area to be paved","m²",400]
[]
[null,null,"B.4.12","8.2.2","Construction of paving with 80 mm thick concrete blocks (natural colour) including sandbed complete","m²",400]
[]
[null,null,"B.4.13","8.2.1","Extra over item B.3.2 for provision and installation of edge restraints consisting of kerbing as per SANS 927 Fig. 6","m",250]
[]
[{"$nulls":3},"8.2.3","CUTTING UNITS TO FIT EDGE RESTRAINTS"]
[]
[null,null,"B.4.14",null,"Straight","m",200]
[]
[null,null,"B.4.15",null,"Circular","m",50]
[]
[]
[null,null,"TOTAL FOR SCHEDULE B (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"Schedule C","index":2,"n_rows":145,"n_cols":8,"rows_kept":145,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3],[98,1,98,6],[99,1,99,6],[144,1,144,6]]}
[null,"CONTRACT NO"]
[null,"WINBURG WATER TREATMENT WORKS"]
[null,"SCHEDULE C: CHEMICAL DOSING BUILDING"]
[]
[null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"NO","CLAUSE"]
[]
[null,null,"PART "]
[null,null,"SPEC"]
[null,null,"PB 8.2.1"]
[null,"C.1","8.2.5","TILING"]
[]
[null,"C.1.1","(a)","500mm x 500mm heavy duty non slip floor tiles","m²",45]
[]
[null,"C.1.2","(b)","150mm x 150mm heavy duty non slip wall tiles ","m²",15]
[]
[null,"C.2","8.2.9","WATERPROOFING OF CONCRETE ROOFS"]
[]
[null,"C.2.1",null,"Waterproofing of concrete roofs with approved synthetic rubber or plastic sheet covering capable of being fusion welded, resistant to ultra-violet rays and heat, of thickness of not less than 2mm, complete with flashing around edges and covered with approved reflective paint.","m²",26]
[]
[null,"C.3","8.2.20","PAINTING"]
[]
[null,"C.3.1",null,"Varnishing door D1 and frame with Woodoc 50 or approved water repellent wood sealer.\nRate includes preparation of surface.","no",1]
[]
[null,"C.3.2",null,"Window W1 with approved enamel paint","no",3]
[]
[]
[{"$nulls":3},"CHEMICAL TANKS SHELTER"]
[{"$nulls":3},"REFER TO DRG. U029-S04-0 & U029-S05-0"]
[]
[null,"C.4","SANS"]
[null,null,"1200D","EARTHWORKS"]
[]
[null,null," 8.3.3","RESTRICTED EXCAVATION"]
[]
[null,null,"8.3.3(a)","EXCAVATE FOR FOUNDATIONS AND CABLE TRENCHES IN ALL MATERAILS, BACKFILL BEHIND STRUCTURES, CONSTRUCT EMBANKMENTS OR DISPOSE WITHIN THE FREEHAUL DISTANCE FOR DEPTHS:"]
[]
[null,"C.4.1",null,"0 m up to 2 m","m³",14]
[]
[{"$nulls":3},"FOUNDATION FILL COMPACTED TO 95% MOD AASHTO IN LAYERS NOT EXCEEDING 150 mm IN THICKNESS, CONSISTING OF: "]
[]
[null,"C.4.2",null,"Compacted hardcore filling","m³",8.5]
[]
[null,null,"8.3.3 (b)","EXTRA OVER ITEM E.1.1 FOR EXCAVATION IN:"]
[]
[null,"C.4.3",null,"Hard rock material","m³",{"$f":"0.25*F38","v":3.5}]
[]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"C.5","SANS","CONCRETE (STRUCTURAL)"]
[null,null,"1200G"]
[]
[null,null,8.2,"FORMWORK"]
[]
[null,null,"8.2.2","SMOOTH FORMWORK (MEASURED TO 150mm below"]
[{"$nulls":3},"FINISHED GROUND LEVEL WHERE APPLICABLE)"]
[]
[]
[{"$nulls":3},"PLANE VERTICAL "]
[]
[{"$nulls":3},"Trimming/preparing vertical sides of excavation to cast concrete strip footings in soft or intermediate material"]
[]
[null,"C.5.1",null,"Sides of footings of shelter structure foundations","m2",5.8]
[]
[null,"C.5.2",null,"Sides of footings (where not cast against face of excavation)","m2",2.9]
[]
[null,"C.5.3",null,"External faces of stub columns","m2",12.3]
[]
[null,"C.6",8.3,"REINFORCEMENT"]
[]
[null,"C.6.1",null,"High-tensile steel bars","t",0.5]
[]
[null,"C.6.2",null,"Mild steel bars","t",0.2]
[]
[]
[null,"C.7",8.4,"CONCRETE"]
[]
[null,"C.7.1","8.4.2","BLINDING LAYER IN GRADE 15/10 CONCRETE 50 mm THICKNESS","m2",6]
[]
[null,null,"8.4.3","STRENGTH CONCRETE 25/19"]
[]
[null,"C.7.2",null,"Column Footings","m3",2.1]
[]
[null,"C.7.3",null,"Stub Columns","m3",1.65]
[]
[null,"C.8","SANS 1200H","SUPPLY OF STRUCTURAL STEEL"]
[null,null,"8.3.1"]
[{"$nulls":3},"Unless other specified, structural steelwork complies with EN10025-2 Grade S355 JR. Circular Hollow Sections used for bracing will be cold formed from grade 300W steel to SANS 657-1, in accordance with the specification and tender drawings complete with all necessary cleats, brackets, gussets stiffeners, cap and base plates, packs and the like. "]
[]
[null,"C.8.1",null,"Preparation of shop detail drawings","Sum",1]
[]
[null,"C.8.2",null,"Universal columns (lighter than 60kg/m) incl end plates","t",{"$f":"(52/1000)*12.52*1.1","v":{"v":0.716144,"d":"0.72"}}]
[]
[null,"C.8.3",null,"Universal beams (lighter that 50kg/m) incl. end plates","t",{"$f":"(31/1000)*31.8*1.1","v":{"v":1.0843800000000001,"d":"1.08"}}]
[{"$nulls":7},{"$f":"IF(F98>0,ROUND(F98*G98,2),\"\")","v":""}]
[null,"CARRIED FORWARD"]
[null,"BROUGHT FORWARD"]
[]
[null,"C.8.4",null,"Cold rolled lipped channel - purlins and girts with yield stress 225MPa","t",{"$f":"(4.54/1000)*94.2*1.1","v":{"v":0.47043480000000004,"d":"0.47"}}]
[]
[null,"C.8.5",null,"50x50x5mm sag bars","t",{"$f":"(3.77/1000)*3","v":{"v":0.01131,"d":"0.01"}}]
[]
[]
[null,"C.8.6",null,"365x290x16mm Galvanised Base Plate as per detail","No",4]
[]
[null,"C.8.7",null,"Purlins-Black Bolts Grade 8.8 including flat and /or tapered washers - HD Galvanized (as shown on drawing)","Sum",1]
[]
[null,"C.8.8","8.3.4","Base-Black Bolts Grade 8.8 including flat and /or tapered washers - HD Galvanized (as shown on drawing)","No",16]
[]
[null,"C.8.9","8.3.13","m) Hot deep Galvanizing As Per Engineer's Specification ","t",2.5]
[]
[null,null,"8.3.2","Delivery"]
[]
[{"$nulls":3},"Load at Works, delivery to site, offload, transport and stack","t",2.5]
[]
[null,"C.8.10",null,"Erection"]
[]
[{"$nulls":3},"Erection, including taking from stacking area, transporting to site, erecting and touching up primer coat where damaged and painting, one under coat and one finish coat as per specification, after erection","t",2.5]
[]
[]
[null,"C.9","SANS "]
[null,null,"1200HB","ROOF COVERINGS,ETC"]
[]
[null,null,"8.2.2","RIBBED METAL SHEETING AND ACCESSORIES"]
[]
[{"$nulls":3},"\"0.5mm \"IBR roof sheeting and accessories fixed to steel purlins at 1200mm centres, all in accordance with manufacturer's recommendations. "]
[]
[null,"C.9.1",null,"Roof covering with pitch not exceeding 5 degrees, in transprtable lengths not exceeding 10m.","m2",65]
[]
[null,"C.9.2",null,"Badged flashings curved on each side.",{"v":7.8,"d":"7.80"},95]
[]
[{"$nulls":3},"RAINWATER GOODS ETC."]
[]
[{"$nulls":3},"Gutters"]
[]
[null,"C.9.3",null,"220 x 200 seamless box gutter fixed to steel section","m",{"v":7.8,"d":"8"}]
[]
[null,"C.9.4",null,"110mm x110mm aluminium down pipes ","m",3]
[]
[]
[{"$nulls":7},{"$f":"IF(F144>0,ROUND(F144*G144,2),\"\")","v":""}]
[null,"TOTAL FOR SCHEDULE C (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"Schedule D","index":3,"n_rows":340,"n_cols":8,"rows_kept":340,"merged":[[7,1,8,1],[339,1,339,6]]}
[null,"CONTRACT NO"]
[null,{"$f":"'[2]SCHED-D'!A2","v":"WINBURG WATER TREATMENT WORKS"}]
[null,"SCHEDULE D: RAPID GRAVITY SAND FILTERS"]
[]
[null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"NO","CLAUSE"]
[]
[null,"D.1","SANS"]
[null,null,"1200D","EARTHWORKS"]
[]
[null,null," 8.3.3","RESTRICTED EXCAVATION"]
[]
[null,null,"8.3.3(a)","EXCAVATE FOR FOUNDATIONS AND PIPE "]
[{"$nulls":3},"TRENCHES IN ALL MATERAILS, BACKFILL BEHIND "]
[{"$nulls":3},"STRUCTURES, CONSTRUCT EMBANKMENTS OR "]
[{"$nulls":3},"DISPOSE WITHIN THE FREEHAUL DISTANCE FOR"]
[{"$nulls":3},"DEPTHS:"]
[]
[null,"D.1.1",null,"0 m up to 2 m","m³",26]
[]
[null,"D.1.2",null,"Exceeding 2m up to 4m","m³",18]
[]
[null,"D.1.3","8.3.3(b)","Extra over items D.1.1 to D.1.2  for excavation in hard rock ","m³",10]
[{"$nulls":3},"material"]
[]
[null,"D.1.4","PSD 8.3.3","Extra over itemes D.1.1 to D.1.3 for 5% soil cement backfilling ","m³",10]
[null,null,"(c)","where instructed by the engineer"]
[]
[null,"D.1.5","PSD 8.3.3","Excavate and dispose of unsuitable material from bottom","m³",25]
[null,null,"(d)","of excavations"]
[]
[null,"D.2","1200L","PIPE SPECIALS"]
[]
[null,"D.2.1","8.2.5","Supply, installation and testing of pipes, fittings and specials as detailed in the pipe schedule","sum",1]
[]
[null,"D.3","SANS","CONCRETE (STRUCTURAL)"]
[null,null,"1200G"]
[]
[null,null,8.2,"FORMWORK"]
[]
[null,null,"8.2.1","ROUGH WORK"]
[]
[{"$nulls":3},"PLANE VERTICAL"]
[]
[null,"D.3.1",null,"Sides of floor slabs not to be trimmed","m²",5]
[]
[null,null,"8.2.2","SMOOTH FORMWORK (MEASURED TO 150mm"]
[{"$nulls":3},"BELOW FINISHED GROUND LEVEL WHERE"]
[{"$nulls":3},"APPLICABLE)"]
[]
[{"$nulls":3},"PLANE VERTICAL "]
[]
[null,"D.3.2",null,"Sides of floor slabs ","m²",12]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"D.3.3",null,"Internal face of roof parapet walls","m²",9]
[]
[null,"D.3.4",null,"External faces of walls below ground level","m²",80]
[]
[null,"D.3.5",null,"Sides of mass concrete where ordered by the Engineer","m²",5]
[]
[null,null,"8.2.2","SPECIAL SMOOTH REPAIRED AND RUBBED"]
[{"$nulls":3},"FORMWORK (MEASURED FROM 150 mm BELOW"]
[{"$nulls":3},"FINISHED GROUND LEVEL WHERE APPLICABLE)"]
[{"$nulls":3},"PLANE HORIZONTAL"]
[]
[null,"D.3.6",null,"Soffits of filter outlet channels and boxes","m²",28]
[]
[null,"D.3.7",null,"Soffit of roof slabs","m²",60]
[]
[null,"D.3.8",null,"Soffit of walkways and floor slabs","m²",45]
[]
[{"$nulls":3},"PLANE SLOPING"]
[]
[null,"D.3.9",null,"Soffit of staircases","m²",4]
[]
[{"$nulls":3},"PLANE VERTICAL "]
[]
[null,"D.3.10",null,"External faces of filter walls","m²",150]
[]
[null,"D.3.11",null,"Internal faces of filter walls","m²",200]
[]
[null,"D.3.12",null,"Sides of walkways","m²",20]
[]
[null,"D.3.13",null,"Sides of risers of stairs","m²",5]
[]
[null,"D.3.14",null,"Sides of beams","m²",2]
[]
[null,"D.3.15",null,"Sides of columns","m²",4]
[]
[null,"D.3.16",null,"External sides of roof slabs and parapet walls","m²",30]
[]
[null,"D.3.17",null,"Sides of overflow channel","m²",185]
[]
[null,"D.3.18",null,"Sides of upstand on walkways and stairs (100mm high)","m²",10]
[]
[{"$nulls":3},"SPECIAL FORMWORK"]
[]
[null,null," 8.2.6 ","BOX OUT HOLES / FORM VOIDS"]
[]
[null,"D.3.19","(a)","Small, circular of diameter up to 0.35m, up to 0.5m deep","no",16]
[]
[null,"D.3.20","(b)","Small, other than circular of area up to and including 0.1m² up to 0.5m deep","no",2]
[]
[null,"D.3.21","(c )","Large, other than circular of area over 0.1m² up to and including 0.5m², up to 0.5m deep","no",8]
[]
[]
[null,"D.3.22","(d)","Large, other than circular of area over 0.5m² up to and including 1m², up to 0.5m deep","no",22]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"D.4",8.3,"REINFORCEMENT"]
[]
[{"$nulls":3},"HIGH TENSILE STEEL BARS"]
[]
[null,"D.4.1","8.3.1","Y25 mm dia. : basic price","t",15]
[]
[{"$nulls":3},"EXTRA OVER ITEM D.4.1 (PROVISIONAL QUANTITIES)"]
[{"$nulls":3},"FOR BARS OF DIAMETER"]
[]
[null,"D.4.2",null,"Y10 m","t",2.5]
[]
[null,"D.4.3",null,"Y12 mm","t",10]
[]
[null,"D.4.4",null,"Y16 mm","t",3]
[]
[null,"D.4.5",null,"Y20 mm","t",3]
[]
[{"$nulls":3},"MILD STEEL BARS"]
[]
[null,"D.4.6","8.3.1","R25 mm dia. : basic price","t",2]
[]
[{"$nulls":3},"EXTRA OVER ITEM D.4.6 (PROVISIONAL QUANTITIES) "]
[{"$nulls":3},"FOR BARS OF DIAMETER"]
[]
[null,"D.4.7",null,"R8 mm","t",0.5]
[]
[null,"D.4.8",null,"R10 mm","t",1]
[]
[null,"D.4.9",null,"R12 mm","t",0.5]
[]
[null,"D.4.10",null,"Apply 30 microns of waterborne rust converter (Polycell End Rust by Plascon or similar approved) to exposed rebar","ℓ",100]
[]
[null,"D.5",8.4,"CONCRETE"]
[]
[null,null,"8.4.2","BLINDING LAYER IN GRADE 20/20 CONCRETE 50 mm "]
[{"$nulls":3},"THICKNESS"]
[]
[null,"D.5.1",null,"Horizontal","m²",110]
[]
[{"$nulls":3},"STRENGTH CONCRETE GRADE 20/20 IN FILLING OF OVER-BREAK IN EXCAVATIONS IN ROCK TO FORM BLINDING LAYER"]
[null,"D.5.2",null,"Horizontal","m²",110]
[]
[{"$nulls":3},"STRENGTH CONCRETE 20/20"]
[]
[null,"D.5.4",null,"Mass concrete below structures or where ordered","m³",5]
[]
[{"$nulls":3},"STRENGTH CONCRETE 20/10"]
[]
[null,"D.5.5",null,"Benching to channels","m³",9]
[]
[null,"D.5.6",null,"Screeds to floors and roofs","m³",6]
[]
[{"$nulls":3},"STRENGTH CONCRETE 35/20"]
[]
[null,"D.5.7",null,"Floor slabs","m³",35]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"D.5.8",null,"Straight walls","m³",100]
[]
[null,"D.5.9",null,"Walkways","m³",10]
[]
[null,"D.5.10",null,"Roof slabs","m³",16]
[]
[null,"D.5.11",null,"Walls of overflow channel","m³",8]
[]
[null,"D.5.12",null,"Parapet walls","m³",2]
[]
[null,"D.5.13",null,"Stair cases","m³",3]
[]
[null,"D.5.14",null,"Columns","m³",5]
[]
[null,"D.5.15",null,"Filter false floor (under supervision of mechanical contractor)","m³",6]
[]
[null,null,"8.4.4","UNFORMED SURFACE FINISHES"]
[]
[null,"D.5.16",null,"To upper surfaces of concealed work and surfaces to receive benching or screed","m²",15]
[]
[]
[{"$nulls":3},"WOOD FLOAT FINISH"]
[]
[null,"D.5.17",null,"To upper surfaces of screed on roof slabs","m²",70]
[]
[null,"D.5.18",null,"Top of walls and parapet walls","m²",8]
[]
[null,"D.5.19",null,"Top of walkways, false floors and channel floors","m²",35]
[]
[null,"D.5.20",null,"Tread of stairs","m²",4]
[]
[null,"D.5.21",null,"Filter false floor","m²",26]
[]
[{"$nulls":3},"STEEL FLOAT FINISH"]
[]
[{"$nulls":3},"UPPER SURFACES OF:"]
[]
[null,"D.5.22",null,"Benching in channels","m²",85]
[]
[null,"D.5.24",null,"Backwash and weirs","m²",7]
[]
[null,"D.6",8.7,"GROUTING IN OF EQUIPMENT SUPPLIED AND "]
[{"$nulls":3},"INSTALLED BY PLANT SUPPLIER WITH"]
[]
[null,"D.6.1",null,"Non-shrink grout (\"Degussa Masterflow 524\" or similar approved)","m³",0.25]
[]
[null,null,"PSG 8.9","TESTING STRUCTURES FOR WATERTIGHTNESS"]
[]
[null,"D.6.2",null,"Filters (including outlet channels)","no",3]
[]
[null,null,"PSG 8.10","BUILDING PIPES INTO CONCRETE WORK AND GROUTING PIPES INSTALLED BY THE MECHANICAL CONTRACTOR"]
[]
[{"$nulls":3},"PIPES SUPPLIED AND INSTALLED BY THE CIVIL "]
[{"$nulls":3},"CONTRACTOR OF DIAMETER AND OPENING SIZES"]
[{"$nulls":3},"(IRRESPECTIVE OF TYPE)"]
[]
[null,"D.6.3",null,"Up to and including 200mm diameter, openings up to 400mm square","no",1]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[null,"D.6.4",null,"Over 200mm up to and including 300mm diameter, openings up to 500mm square","no",1]
[]
[null,"D.6.5",null,"Over 300mm up to and inlcuding 400mm diameter, openings up to 600mm square","no",1]
[]
[null,"D.6.6",null,"Over 400mm up to and including 500mm diameter, openings up to 700mm square","no",2]
[]
[null,"D.6.7",null,"Over 500mm up to and including 600mm diameter, openings up to 900mm square","no",1]
[]
[{"$nulls":3},"PIPES SUPPLIED AND INSTALLED BY MECHANICAL "]
[{"$nulls":3},"CONTRACTOR OF DIAMETER AND OPENING SIZES "]
[{"$nulls":3},"(IRRESPECTIVE OF TYPE)"]
[]
[null,"D.6.8",null,"Up to and including 200mm diameter, openings up to 400mm square","no",2]
[]
[null,"D.6.9",null,"Over 200mm up to and including 300mm diameter, openings up to 500mm square","no",16]
[]
[null,"D.6.10",null,"Over 800mm up to and including 900mm diameter, openings up to 1100mm square","no",3]
[]
[{"$nulls":3},"BUILDING PIPES INTO BRICKWORK"]
[]
[null,"D.6.11",null,"160mm PVC pipes into 230mm thick brick wall","no",2]
[]
[null,"D.7","SANS","STRUCTURAL STEELWORK (SMALL WORK)"]
[null,null,"1200 HA"]
[]
[null,"D.7.1","8.3.2 (b)","Galvanised handrail assembly complete","m",65]
[]
[null,"D.7.2","8.3.4 (a)","SS304 open grid steel flooring complete and installed with SS304 frames","m²",2]
[]
[null,"D.8","PART","BUILDING WORK"]
[null,null,"SPEC PB"]
[null,null,"8.2.1","BRICKWORK"]
[]
[null,"D.8.1",null,"230mm thick, both faces face brick (allow a purchase price of R3000,00 per 1000 bricks, excl VAT)","m²",85]
[]
[null,"D.8.2",null,"Supply and install Kilcher Limitgliss bearing (40kN/m) between concrete roof and brickwork (220mm wide)","m",30]
[]
[{"$nulls":3},"WATERPROOFING OF CONCRETE ROOFS"]
[null,"D.8.3",null,"Waterproofing of concrete roofs with approved synthetic rubber or plastic sheet covering capable of being fusion welded, resistant to ultra-violet rays and heat, of thickness of not less than 2mm, complete with flashing around edges and covered with approved reflective paint.","m²",5]
[]
[null,"D.8.4","(a)","Brick on edge on external side of window including DPC as shown in the drawings.","m",15]
[]
[null,"D.8.5","(b)","Quarry tile, 110mm wide, on internal side of window.","m",15]
[]
[null,null,"8.2.5","TILING"]
[null,"D.8.6",null,"150mm x 150mm white glazed tiles to walls and floors of clear-water filter outlet channels.","m²",15]
[]
[null,null,"8.2.14","RAINWATER OUTLETS"]
[null,"D.8.7",null,"Supply and installation of 80mm diameter \"Eze-flo\" or similar approved cast iron rainwater outlet in roof slab","no",2]
[]
[null,"D.8.8",null,"80mm diameter medium quality galvanised screwed and socketed pipes including galvanised holding brackets","m",10]
[]
[null,"D.8.9",null,"80mm diameter medium qulaity galvanized 45  degree bends","no",2]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[null,null,"8.2.17","JOINERY "]
[null,"D.8.10","(a)","Supply and install door D1 (800mm wide x 2100mm high) complete with frame","no",3]
[]
[null,"D.8.11","(a)","Supply and install door D2 (1500mm wide x 2400mm high) complete with frame","no",1]
[]
[null,null,"8.2.18","METAL WORK"]
[null,"D.8.12",null,"Supply and install standard industrial type window SS23, 673mm wide x 1445mm high, complete as specified (window W1)","no",2]
[]
[null,"D.8.13",null,"Supply and install standard industrial type window SS43, 1300mm wide x 1445mm high, complete as specified (window W2)","no",6]
[null,null,"8.2.20","PAINTING"]
[]
[null,"D.8.14",null,"Door D1 and frame with Woodoc 50 or approved water repellent wood sealer","no",3]
[]
[null,"D.8.15",null,"Door D2 and frame with Woodoc 50 or approved water repellent wood sealer","no",1]
[]
[null,"D.8.18",null,"window W1 with Plascon Velvaglo (or similar approved) paint, colour olive branch D22-6","no",2]
[]
[null,"D.8.19",null,"window W2 with Plascon Velvaglo (or similar approved) paint, colour olive branch D22-6","no",6]
[]
[null,"D.9",null,"SUNDRY ITEMS"]
[]
[null,null,"SANS 1200LD 8.2.4","MANHOLE COVERS"]
[]
[null,"D.9.1",null,"Supply and install  760 mm square manhole cover and frame complete, including forming of opening in 250mm thick concrete slab as specified on DWG 230410PR0/05/02","no",1]
[]
[{"$nulls":3},"VOID FORMERS"]
[]
[null,"D.9.2",null,"Polystyrene void formers","m³",3]
[]
[{"$nulls":3},"CORING OF OPENINGS IN CONCRETE MEMBERS"]
[]
[null,"D.9.3",null,"Coring of 65mm diameter openings in 250mm thick reinforced ","no",12]
[{"$nulls":3},"concrete floors"]
[]
[null,"D.9.4",null,"Coring of 100mm diameter openings in 250mm thick reinforced concrete floors","no",1]
{"$rows_empty":10}
[null,"TOTAL FOR SCHEDULE D (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"Schedule E","index":4,"n_rows":209,"n_cols":8,"rows_kept":209,"merged":[[7,1,8,1],[208,1,208,6]]}
[null,"CONTRACT NO"]
[null,{"$f":"'[2]SCHED-D'!A2","v":"WINBURG WATER TREATMENT WORKS"}]
[null,"SCHEDULE E: CHLORINATION BUILDING"]
[]
[null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"NO","CLAUSE"]
[]
[null,"E.1","SANS"]
[null,null,"1200D","EARTHWORKS"]
[]
[null,null," 8.3.3","RESTRICTED EXCAVATION"]
[]
[null,null,"8.3.3(a)","EXCAVATE FOR FOUNDATIONS AND CABLE TRENCHES IN ALL MATERAILS, BACKFILL BEHIND STRUCTURES, CONSTRUCT EMBANKMENTS OR DISPOSE WITHIN THE FREEHAUL DISTANCE FOR DEPTHS:"]
[]
[null,"E.1.1",null,"0 m up to 2 m","m³",13]
[]
[{"$nulls":3},"FOUNDATION FILL COMPACTED TO 95% MOD AASHTO IN LAYERS NOT EXCEEDING 150 mm IN THICKNESS, CONSISTING OF: "]
[]
[null,"E.1.2",null,"Compacted hardcore filling","m³",13]
[]
[null,null,"8.3.3 (b)","EXTRA OVER ITEM E.1.1 FOR EXCAVATION IN:"]
[]
[null,"E.1.3",null,"Hard rock material","m³",6]
[]
[null,null,"PART SPEC PB","WATERPROOFING"]
[]
[null,"E.1.4","8.2.9 (a)","250 micron plastic sheeting underneath floorslabs","m²",19]
[]
[null,"E.2","SANS","CONCRETE (STRUCTURAL)"]
[null,null,"1200G"]
[]
[null,null,"8.2.1","ROUGH FORMWORK"]
[]
[{"$nulls":3},"PLANE VERTICAL"]
[]
[null,"E.2.1",null,"Trimming/preparing vertical sides of excavation to cast concrete against it in soft and intermediate material","m²",5]
[]
[null,null,8.2,"FORMWORK"]
[]
[null,null,"8.2.2","SMOOTH FORMWORK"]
[{"$nulls":3},"(MEASURED FROM 150 mm BELOW FINISHED "]
[{"$nulls":3},"GROUND LEVEL WHERE APPLICABLE)"]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[{"$nulls":3},"PLANE HORIZONTAL"]
[]
[null,"E.2.2",null,"Soffit of roof slab (including overhang)","m²",26]
[]
[{"$nulls":3},"PLANE VERTICAL "]
[]
[null,"E.2.3",null,"Sides of footings (where not cast against face of excavation)","m²",5]
[]
[null,null,"8.2.3","SPECIAL SMOOTH, REPAIRED AND RUBBED FORMWORK (MEASURED FROM 150mm BELOW FINISHED GROUND LEVEL)"]
[{"$nulls":3},"PLANE VERTICAL"]
[]
[null,"E.2.4",null,"Sides of roof slabs (150 mm high)","m²",6]
[]
[]
[{"$nulls":3},"SPECIAL FORMWORK"]
[]
[null,null," 8.2.6 ","BOX OUT HOLES / FORM VOIDS"]
[]
[null,"E.2.5",null,"Forming drip groove tapering from 38 to 30mm, 20mm deep below roof slab","m",20]
[]
[null,"E.2.6",null,"Leave 150 mm wide x 160 mm high openings in 220 mm brickwork and building in of pipes up to 100 mm diameter","no",6]
[]
[null,"E.3",8.3,"REINFORCEMENT"]
[]
[{"$nulls":3},"HIGH TENSILE STEEL BARS"]
[]
[null,"E.3.1","8.3.1","Y25 mm dia. : basic price","t",0.8]
[]
[{"$nulls":3},"EXTRA OVER ITEM E.3.1 (PROVISIONAL QUANTITIES)"]
[{"$nulls":3},"FOR BARS OF DIAMETER"]
[]
[{"$nulls":3},"FOR BARS OF DIAMETER"]
[]
[null,"E.3.2",null,"Y10 mm","t",0.6]
[]
[null,"E.3.3",null,"Y12 mm","t",0.1]
[]
[null,"E.3.4",null,"Y16 mm","t",0.1]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[{"$nulls":3},"MILD STEEL BARS"]
[]
[null,"E.3.5","8.3.1","R25 mm dia. : basic price","t",0.01]
[]
[{"$nulls":3},"EXTRA OVER ITEM E.3.5 (PROVISIONAL QUANTITIES) "]
[{"$nulls":3},"FOR BARS OF DIAMETER"]
[]
[null,"E.3.6",null,"R8 mm","t",0.004]
[]
[null,"E.3.7",null,"R10 mm","t",2E-3]
[]
[null,"E.3.8",null,"R12 mm","t",2E-3]
[]
[null,"E.3.9",null,"High-tensile welded mesh reference 245","m²",19]
[]
[null,"E.4",8.4,"CONCRETE"]
[]
[{"$nulls":3},"STRENGTH CONCRETE 20/20"]
[]
[null,"E.4.1",null,"Footing to brick walls ","m³",4]
[]
[null,"E.4.2",null,"Floor slab of chlorination building","m³",3]
[]
[{"$nulls":3},"STRENGTH CONCRETE 35/20"]
[]
[null,"E.4.3",null,"Roof slab","m³",6]
[]
[null,null,"8.4.4","UNFORMED SURFACE FINISHES"]
[]
[null,"E.4.4",null,"To upper surfaces of concealed work and surfaces to receive benching or screed ","m²",2]
[]
[{"$nulls":3},"WOOD FLOAT FINISH"]
[]
[null,"E.4.5",null,"To upper surfaces of floor slabs","m²",19]
[]
[null,"E.5",null,"STEEL FLOAT FINISH"]
[]
[{"$nulls":3},"UPPER SURFACES OF:"]
[]
[null,"E.4.6",null,"Top of roof slab","m²",26]
[]
[null,"E.6","PART","BUILDING WORK"]
[null,null,"SPEC PB"]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"E.6","PART","BUILDING WORK"]
[null,null,"SPEC PB"]
[]
[null,null,"8.2.1","BRICKWORK"]
[]
[null,"E.6.1",null,"220mm thick, both faces face brick ","m²",54]
[]
[null,"E.6.2",null,"220 mm, one face stock brick, other face, face brick, for foundation walls, below ground level","m²",12]
[]
[null,"E.6.3",null,"220 mm, both faces face brick, for foundation walls above final ground level","m²",7]
[]
[null,"E.6.4",null,"Supply and install Kilcher Limitgliss bearing (30kN/m) between concrete roof and brickwork (220mm wide)","m",22]
[]
[null,"E.6.5",null,"Supply and install two layers 250 micron thick plastic sheeting,  220mm wide between floor slab and brick wall (DPC)","m",22]
[]
[{"$nulls":3},"WATERPROOFING OF CONCRETE ROOFS"]
[]
[null,"E.6.7",null,"Waterproofing of concrete roofs with approved synthetic rubber or plastic sheet covering capable of being fusion welded, resistant to ultra-violet rays and heat, of thickness of not less than 2mm, complete with flashing around edges and covered with approved reflective paint.","m²",27]
[]
[null,null,"8.2.4","WINDOW SILLS"]
[]
[null,"E.6.7","(b)","Quarry tile, 110mm wide, on both sides of window","m",3]
[]
[null,null,"8.2.17","JOINERY "]
[]
[null,"E.6.11","(a)","Supply and install door D1 (915 mm wide x 2100 mm high) complete with frame","no",1]
[]
[null,"E.6.11","(a)","Supply and install door D2 (1 500 mm wide x 2 500mm high) complete with frame","no",1]
[]
[null,null,"8.2.18","METAL WORK"]
[null,"E.6.12",null,"Supply and install standard bronze anodized aluminium window (1 022  mm wide x 949 mm high)","no",1]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,null,"8.2.20","PAINTING"]
[null,"E.6.14",null,"Varnishing door D1 with approved water repellent wood sealer and painting of framewith enamel paint","no",1]
[]
[null,"E.6.15",null,"Varnishing door D2 with approved water repellent wood sealer and painting of framewith enamel paint","no",1]
[]
[null,"E.7",null,"MISCELLANEOUS"]
[]
[null,"E.7.1",null,"Leaving openings in brickwork for fans provided by mechanical supplier, including building in","no",2]
[{"$nulls":7},{"$f":"IF(F180>0,ROUND(F180*G180,2),\"\")","v":""}]
{"$rows_empty":28}
[null,"TOTAL FOR SCHEDULE E (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"Schedule F","index":5,"n_rows":120,"n_cols":8,"rows_kept":120,"merged":[[119,1,119,6]]}
[null,"CONTRACT NO"]
[null,"WINBURG WATER TREATMENT WORKS"]
[null,"SCHEDULE F: ADMINISTRATION BUILDING"]
[]
[null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"NO","CLAUSE"]
[]
[null,"F.1","PS PB","TILING"]
[]
[null,"F.1.1","8.2.5","Wall tiles (glazed ceramic) white","m²",54]
[]
[null,"F.1.2","8.2.19 (a)","Vinyl floor tiles (2mm Marley Heavy Duty or equal approved)","m²",45]
[]
[null,"F.1.3","8.2.5 (b)","Vinyl cove skirting","m",40]
[]
[null,"F.1.4","8.2.5 (a)","300mm x 300mm heavy duty non slip floor tiles","m²",30]
[]
[null,"F.1.5","8.2.5 (b)","100mm high heavy duty non slip tile skirting including cutting of tiles","m²",15]
[]
[]
[null,"F.2","8.2.18","STEEL DOOR FRAMES INCLUDING LINTOL"]
[]
[null,"F.2.1",null,"D3 (1500 x 2000 x 220 wall)","no",1]
[]
[null,"F.3","PSPB","JOINERY"]
[]
[null,"F.3.1",null,"D3 (1500 x 2000 x 45) hardwood double door (outward opening)","no",1]
[]
[null,"F.3","PSPB","STRUCTURAL TIMBER"]
[]
[null,"F.3.1","8.2.11 (f)","Brandering  38 x 38 SAP","m",130]
[]
[null,"F.3.2","8.2.12","Double roman through colour concrete roof tiles","m²",5]
[]
[null,"F.3.3",null,"Ridge tiles edge bedded solid at joints","m",5]
[]
[null,"F.4",null,"GUTTERS"]
[]
[null,"F.4.1",null,"80 x 55 colourbond aluminium downpipes","m",14]
[]
[null,"F.5",null,"PLUMBING"]
[]
[null,"F.5.1",null,"Water closet suite (semi-close-coupled), fittings and connections to relevant pipework","no",1]
[]
[null,"F.5.2",null,"Hand wash basin complete, fittings, taps and connections to relevant pipework","no",1]
[]
[null,"F.5.3",null,"Shower tray (905mm x 905mm), fittings, taps and connections to relevant pipework","no",1]
[]
[null,"F.5.4",null,"Stainless steel double bowl, 1800 x 600 x 150, fittings, taps, cabinet and connections to relevant pipework","no",1]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[]
[null,"F.5.5",null,"Laboratory sink, fittings, taps, cabinet and connections to relevant pipework","no",1]
[null," "]
[null,"F.5.6",null,"150 litre high pressure horizontal mounted geyser, complete with drip tray, pressure control valve, overflow and connections to relevant pipework","no",1]
[]
[null,"F.5.7",null,"Supply, install and connect 15 mm copper pipes including for all applicable fittings to complete cold and hot water reticulation and connection to main water supply line","sum",1]
[]
[null,"F.5.8",null,"Extra over item F.12.7 for supply and installation of 15 mm dia. ","no",1]
[{"$nulls":3},"brass stopcock"]
[]
[null,"F.5.9",null,"Extra over item F.12.7 for supply and installation of Masterflow or equal approved pressure reducing valve (pressure rating 100 kPa)","no",1]
[]
[{"$nulls":3},"SUPPLY, INSTALL AND CONNECT PVC WASTE PIPES INCLUDING FOR APPLICABLE FITTINGS"]
[]
[]
[null,"F.5.10",null,"(a)  Hand wash basin 40 mm dia.","no",1]
[]
[null,"F.5.11",null,"(b)  Sink 40 mm dia.","no",1]
[]
[null,"F.5.12",null,"(c)  Laboratory sink 40 mm dia.","no",1]
[]
[null,"F.5.13",null,"(d)  Shower 40 mm dia.","no",1]
[{"$nulls":5}," "]
[null,"F.5.14",null,"Connect WC with PVC pipework and fittings to PVC  reticulation,including 50 mm diameter two-way siphon valve","no",1]
[]
[null,"F.5.15",null,"Supply and install concrete gulley","no",4]
[]
[null,"F.6","PSPB","PAINTING"]
[]
[null,null,"8.2.20","PAINTING OF ADMINISTRATION BUILDING"]
[]
[null,"F.6.1",null,"Ceilings (plascon double velvet)","sum",1]
[]
[null,"F.6.2",null,"Door and window frames (plascon enamel)","sum",1]
[]
[null,"F.6.3",null,"Wooden doors (woodoc 50)","sum",1]
[]
[null,"F.6.4",null,"Fascias, gutters and downpipes (plascon enamel)","sum",1]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[null,"F.7",null,"PROVISIONAL ITEMS"]
[]
[null,"F.7.1",null,"Supply and installation of office furniture","prov.","sum"]
[]
[null,"F.7.2",null,"Supply and installation of laboratory furniture and water testing equipment","prov.","sum"]
[]
[null,"F.7.3",null,"Add Contractor's charges onto the Provisional Sums","%",{"$f":"SUM(G99:G101)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4}," "]
[null,"F.8",null,"MISCELLANEOUS"]
[]
[null,"F.8.1",null,"Hardwood bench, complete as detailed on the drawings","no",1]
[]
[null,"F.8.2",null,"Metal factory locker, two compartments","no",4]
[]
[null,"F.8.3",null,"Precast rainwater channels (1000 x 300 x 150 mm)","no",4]
[]
[null,"F.8.4",null,"Triple sliding white aluminium shower door with obscure translucent safety glass for 1000mm wide opening","no",1]
[]
[null,"F.8.5",null,"Supply and installation of 3000 litre calcamite septic tank, including connections to relevant pipework","no",1]
[]
[null,"F.8.6",null,"French drain complete","sum",1]
[]
[]
[null,"TOTAL FOR SCHEDULE F (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"Schedule G","index":6,"n_rows":227,"n_cols":8,"rows_kept":227,"merged":[[7,1,8,1],[226,1,226,6]]}
[null,"CONTRACT NO"]
[null,"WINBURG WATER TREATMENT WORKS"]
[null,"SCHEDULE G: INTERCONNECTING PIPEWORK AND MANHOLES"]
[]
[null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"NO","CLAUSE"]
[]
[null,"G.1","SANS","EARTHWORKS (PIPE TRENCHES)"]
[null,null,"1200DB"]
[]
[null,null," 8.3.2","EXCAVATION"]
[]
[null,null,"8.3.2(a)","EXCAVATE IN ALL MATERIALS FOR TRENCHES, BACKFILL AND COMPACT, INCLUDING DISPOSAL OF SURPLUS UNSUITABLE MATERIAL WITHIN THE FREEHAUL DISTANCE FOR PIPES, CABLE DUCTS AND PIPE SLEEVES WITH DIAMETER"]
[]
[{"$nulls":3},"UP TO 100 mm DIAMETER FOR DEPTHS"]
[]
[{"$nulls":3},"OVER AND UP TO:"]
[]
[null,"G.1.1",null,"0,0m - 1,5m","m",200]
[]
[null,"G.1.2",null,"1,5m - 2,5m","m",40]
[]
[{"$nulls":3},"OVER 100mm UP TO 315 mm DIAMETER FOR DEPTHS"]
[]
[null,"G.1.3",null,"0,0m - 1,5m","m",550]
[]
[null,"G.1.4",null,"1,5m - 2,5m","m",175]
[]
[null,"G.1.5",null,"2,5m - 3,0m","m",2]
[]
[null,"G.1.6","8.3.2(b)","Extra over Items G.1.1 to G.1.5 for excavation (provisional)","m³",350]
[{"$nulls":3},"in hard rock material"]
[]
[null,"G.1.7","PSDB","Excavate by hand in soft material to expose existing services","m³",5]
[null,null,"8.3.2(d)"]
[]
[null,"G.1.8","PSDB","Excavate and backfill by hand in restriced areas","m³",5]
[null,null,"8.3.2 (e)"]
[]
[null,"G.1.9","8.2.4","Shoring of trenches where instructed by the engineer","m²",5]
[]
[null,null,"8.3.3.1","IMPORT BACKFILL MATERIALS FROM"]
[]
[null,"G.1.10","(a)","Other excavations on site","m³",300]
[]
[null,"G.2","1200L","PIPE SPECIALS"]
[]
[null,"G.2.1","8.2.5","Supply, installation and testing of pipes and specials as detailed in the pipe schedule","sum",1]
[]
[null,"G.3","SANS","MEDIUM PRESSURE PIPELINES"]
[null,null,"1200L"]
[]
[null,null,"8.2.1","SUPPLY, HANDLE, LAY AND BED FOR FLEXIBLE PIPES"]
[]
[{"$nulls":3},"uPVC class 9"]
[]
[null,"G.3.1",null,"90 mm diameter ","m",150]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[{"$nulls":3},"`"]
[null,"G.3.2",null,"110 mm diameter ","m",5]
[]
[null,"G.3.3",null,"160 mm diameter ","m",5]
[]
[null,"G.3.4",null,"200 mm diameter","m",5]
[]
[null,"G.3.5",null,"250 mm diameter","m",350]
[]
[{"$nulls":3},"uPVC Class 12"]
[]
[null,"G.3.6",null,"315 mm diameter","m",10]
[]
[null,null,"8.2.2","SPECIALS AND FITTINGS"]
[]
[{"$nulls":3},"SUPPLY, LAY, JOINT, BED FOR FLEXIBLE PIPES AND TEST, INCLUDING CUTTING PIPES, SUPPLYING FLEXIBLE COUPLINGS AND STEEL BENDS WHERE APPLICABLE"]
[]
[{"$nulls":3},"EXTRA OVER ITEMS G.3.1 TO G.3.6 FOR PIPE LAYING"]
[]
[{"$nulls":3},"uPVC 90° BENDS"]
[]
[null,"G.3.7",null,"90mm diameter","no",5]
[]
[null,"G.3.8",null,"110mm diameter","no",1]
[]
[null,"G.3.9",null,"160mm diameter","no",1]
[]
[null,"G.3.10",null,"200mm diameter","no",1]
[]
[null,"G.3.11",null,"250mm diameter","no",2]
[]
[null,"G.3.12",null,"315 mm diameter","no",1]
[]
[{"$nulls":3},"uPVC 45° BENDS"]
[]
[null,"G.3.13",null,"90mm diameter","no",2]
[]
[null,"G.3.14",null,"110mm diameter","no",1]
[]
[null,"G.3.15",null,"160mm diameter","no",1]
[]
[null,"G.3.16",null,"200mm diameter","no",1]
[]
[null,"G.3.17",null,"250 mm diameter","no",1]
[]
[null,"G.3.18",null,"315 mm diameter","no",1]
[]
[{"$nulls":3},"uPVC 22,5° BENDS"]
[]
[null,"G.3.19",null,"90mm diameter","no",2]
[]
[null,"G.3.20",null,"250mm diameter","no",2]
[]
[]
[]
[{"$nulls":3},"SUB-TOTAL CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[{"$nulls":3},"SUPPLY, HANDLE, LAY AND BED CLASS B AND JOIN WITH PLASSON COUPLINGS"]
[]
[{"$nulls":3},"HDPE CLASS 10"]
[]
[null,"G.3.21",null,"25mm diameter","m",30]
[]
[null,"G.3.22",null,"32mm diameter","m",30]
[]
[null,"G.3.23",null,"50mm diameter","m",30]
[]
[{"$nulls":3},"TAPS WITH HOSE CONNECTIONS"]
[]
[null,"G.3.24",null,"Standpipes with 25mm tap and hose connection projecting 900mm above ground level complete with 25mm diameter GMS connecting pipe, adaptors, supports (Y-section standard)","no",5]
[]
[{"$nulls":3},"EXTRA OVER ITEMS G.3.21 TO G.3.23"]
[]
[{"$nulls":3},"HDPE COMPRESSION ELBOWS"]
[]
[null,"G.3.25",null,"25mm diameter","no",2]
[]
[null,"G.3.26",null,"32mm diameter","no",2]
[]
[null,"G.3.27",null,"45mm diameter","no",2]
[]
[{"$nulls":3},"HDPE COMPRESSION MALE ADAPTORS"]
[]
[null,"G.3.28",null,"25mm diameter","no",2]
[]
[null,"G.3.29",null,"32mm diameter","no",2]
[]
[null,"G.3.30",null,"50mm diameter","no",2]
[]
[{"$nulls":3},"HDPE COMPRESSION 90° EQUAL TEES"]
[]
[null,"G.3.31",null,"25mm diameter","no",2]
[]
[null,"G.3.32",null,"32mm diameter","no",2]
[]
[null,"G.3.33",null,"50mm diameter","no",2]
[]
[{"$nulls":3},"HDPE COMPRESSION REDUCING COUPLINGS"]
[]
[null,"G.3.34",null,"32 x 25mm","no",2]
[]
[null,"G.3.35",null,"50 x 32mm","no",2]
[]
[null,"G.3.36","PSL 8.2.11","Anchor or thrust blocks","m³",3]
[]
[null,"G.3.37","8.2.11","Encase pipes in concrete Grade 20/20","m³",3]
[]
[]
[]
[]
[]
[]
[{"$nulls":3},"SUB-TOTAL CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"G.4","SANS 1200LB","BEDDING (PIPES)"]
[]
[null,null,"8.2.1","FROM TRENCH EXCAVATION"]
[]
[null,"G.4.1","(a)","Selected granular material for bedding cradle","m³",70]
[]
[null,"G.4.2","(b)","Selected fill material","m³",300]
[]
[{"$nulls":3},"SUPPLY ONLY OF BEDDING MATERIAL BY IMPORTING FROM BORROW PITS WITHIN THE FREEHAUL DISTANCE"]
[]
[null,"G.4.3","(a)","Selected granular material for bedding cradle","m³",300]
[]
[null,null,"8.2.5","OVERHAUL OF MATERIAL FOR BEDDING"]
[]
[null,"G.4.4",null,"Overhaul","m³.km",200]
[]
[null,"G.5","SANS","CABLE DUCTS"]
[null,null,"1200LC"]
[]
[null,null,"8.2.5","SUPPLY, LAY, BED AND PROVE DUCT"]
[]
[null,"G.5.1",null,"110 mm uPVC class 34","m",20]
[]
[null,"G.5.2",null,"160 mm uPVC class 34","m",20]
[]
[null,"G.5.3","8.2.7","Construct brick draw pits 1500 x 1500 x 1500mm deep","no",2]
[{"$nulls":3},"complete with base and cover slabs including class 4 manhole cover and frame"]
[]
[null,"G.6","SANS","SEWERS"]
[null,null,"1200LD"]
[]
[null,null,"8.2.1","SUPPLY, LAY, JOINT, BED CLASS B AND TEST uPVC CLASS 34 PIPES WITH INCLUDING CUTTING OF PIPES"]
[]
[null,"G.6.1",null,"110 mm diameter","m",30]
[]
[null,"G.6.2",null,"315 mm diameter","m",175]
[]
[null,null,"8.2.3","MANHOLES"]
[]
[{"$nulls":3},"MANHOLES 1000mm DIAMETER COMPLETE WITH"]
[{"$nulls":3},"TYPE 4 COVER AND FRAME FOR DEPTHS:"]
[]
[null,"G.6.3",null,"Up to 1,5m","no",6]
[]
[null,"G.6.4",null,"1,5m up to 2,5m","no",2]
[]
[]
[]
[{"$nulls":7},{"$f":"IF(F225>0,ROUND(F225*G225,2),\"\")","v":""}]
[{"$nulls":7},""]
[null,"TOTAL FOR SCHEDULE G (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"Schedule H","index":7,"n_rows":302,"n_cols":8,"rows_kept":302,"merged":[[268,3,269,3],[271,3,272,3]]}
[null,"CONTRACT NO"]
[null,{"$f":"'[2]SCHED-D'!A2","v":"WINBURG WATER TREATMENT WORKS"}]
[null,"SCHEDULE H: MODIFICATIONS TO EXISTING SLUDGE HOLDING PONDS"]
[]
[null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"NO","CLAUSE"]
[]
[null,"H.1","SANS","EARTHWORKS (Small Earth Dams)"]
[null,null,"1200DE"]
[]
[null,null,"8.3.1.6","SITE CLEARANCE"]
[]
[null,"H.1.1","8.3.2","Topsoil to nominal depth of 100 mm, stockpile and maintain","ha",0.6]
[]
[null,null,"8.3.3","EXCAVATION"]
[]
[null,"H.1.2","8.3.3(a)","Material unsuitable for embankment (cut to spoil to designated spoil site)","m³",{"v":1000,"d":"1,000"}]
[]
[null,"H.1.3","8.3.3(b)","Material suitable for embankment (cut to stockpile)","m³",500]
[]
[null,null,"8.3.3(c)","EXTRA OVER ITEM G.1.2 AND G.1.3 FOR EXCAVATION IN:"]
[]
[null,"H.1.4",null,"Hard rock material","m³",100]
[]
[null,null,"8.3.4","PREPARATION OF EXPOSED SURFACES FOR AREA TO BE COVERED BY POND EMBANKMENT AND AREA TO BE COVERED BY BENTONITE MIXED WITH SOIL LAYER"]
[]
[null,"H.1.5",null,"Scarify 150 mm deep and compact to 93% mod. AASHTO density (horizontal) ","m²",{"v":3400,"d":"3,400"}]
[]
[null,"H.1.6",null,"As in item G.1.5 but sloping 1:2","m²",{"v":1600,"d":"1,600"}]
[]
[null,"H.1.7",null,"As in item G.1.5 but sloping 1:6","m²",1000]
[]
[null,null,"8.3.5","FORMING EMBANKMENT WITH SUITABLE MATERIAL COMPACTED TO 93% MOD AASHTO"]
[]
[null,"H.1.8",null,"From pond excavations (i.e. from stockpile) or other excavations on site","m³",500]
[]
[{"$nulls":3},"IMPORT MATERIAL, PLACE AND COMPACT EMBANKMENT TO 93% MOD AASHTO DENSITY"]
[]
[null,"H.1.9",null,"From existing borrow pits and excavations on site","m³",1000]
[]
[null,"H.1.10",null,"From commercial sources","m³",250]
[]
[null,null,"8.3.5","Construct layer not exceeding 150 mm consisting of 10 to 12 kg/m² Bentonite mixed thoroughly with dry suitable soil imported from borrow pit within 2,0 km or excavations elswhere on site. Thereafter raise moisture content to between OMC and 2% wet of OMC and compact to 93% MOD AASHTO"]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"H.1.11",null,"150 mm layer (horizontal)","m²",{"v":3400,"d":"3,400"}]
[]
[null,"H.1.12",null,"150 mm layer (sloping 1:2)","m²",{"v":1600,"d":"1,600"}]
[]
[null,"H.1.13",null,"150 mm layer (sloping 1:10)","m²",1000]
[]
[null,null,"8.3.5","Construct horizontal cover layer not exceeding 150 mm consisting of selected granular material compacted to 93% MOD AASHTO"]
[]
[null,"H.1.14",null,"From pond excavations or other excavations on site","m²",100]
[]
[null,"H.1.15",null,"From existing borrow pits and excavations on site","m²",{"v":3000,"d":"3,000"}]
[]
[null,"H.1.16",null,"From commercial sources","m²",200]
[]
[null,null,"8.3.8","OVERHAUL"]
[]
[null,"H.1.17",null,"Overhaul in excess of 3 km (provisional)","m³/km",{"v":1000,"d":"1,000"}]
[]
[null,"H.2","1200L","PIPE SPECIALS"]
[]
[null,"H.2.1","8.2.5","Supply, installation and testing of pipes and specials as detailed in the pipe schedule","sum",1]
[]
[null,"H.3","PSG 8.10","BUILDING PIPES INTO CONCRETE WORK"]
[]
[{"$nulls":3},"PIPES SUPPLIED AND INSTALLED BY THE CONTRACTOR (IRRESPECTIVE OF TYPE)"]
[]
[null,"H.3.1",null,"150 mm dia","no",6]
[]
[null,"H.3.2",null,"300 mm dia","no",5]
[]
[null,"H.3.3",null,"400 mm dia","no",1]
[]
[null,"H.4","PSVA","LANDSCAPING AND GRASSING"]
[]
[null,"H.4.1","8.1(b)","Trimming to receiving topsoil (both horizontal and sloping)","m²",650]
[]
[null,"H.4.2","8.3(b)(i)","Topsoil 100 mm thick (obtained from the stockpile) on horizontal areas (top of embankment)","m²",500]
[]
[null,"H.4.3",null,"Same as item G.4.2 above but on areas sloping 1:2","m²",500]
[]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,null,"8.3(d)","SUPPLYING AND APPLYING CHEMICAL FERTILIZER 2:3 (22) at 50g/m²"]
[]
[null,"H.4.4",null,"On horizontal areas","kg",35]
[]
[null,"H.4.5",null,"On areas sloping 1:2","kg",25]
[]
[null,null,"8.4(a)","KIKUYU CUTTINGS"]
[]
[null,"H.4.6",null,"On horizontal areas","m²",650]
[]
[null,"H.4.7",null,"On areas sloping 1:2","m²",500]
[]
[null,null,"8.4(b)","KIKUYU SODDING"]
[]
[null,"H.4.8",null,"On horizontal areas","m²",100]
[]
[null,"H.4.9",null,"On areas sloping 1:2","m²",100]
[]
[null,"H.5","SANS","CONCRETE (STRUCTURAL)"]
[null,null,"1200G"]
[{"$nulls":3},"FORMWORK"]
[]
[null,null,8.2,"ROUGH FORMWORK (MEASURED TO 150mm BELOW FINISHED GROUND LEVEL WHERE APPLICABLE)"]
[]
[{"$nulls":3},"PLANE VERTICAL"]
[]
[null,"H.5.1",null,"Sides of mass concrete (provisional)","m²",5]
[]
[{"$nulls":3},"SMOOTH FOMRWORK (MEASURED FROM 150mm BELOW FINISHED GROUND LEVEL WHERE APPLICABLE)"]
[]
[null,null,"8.2.3","PLANE VERTICAL"]
[]
[null,"H.5.2",null,"Sides of floors of boxes","m²",8]
[]
[null,"H.5.3",null,"Sides of concrete liner slabs (around pipe inlets and outlets)","m²",2]
[]
[null,"H.5.4",null,"External faces of walls of boxes (below ground)","m²",60]
[]
[{"$nulls":3},"SPECIAL SMOOTH REPAIRED AND RUBBED FORMWORK (MEASURED FROM 150mm BELOW FINISHED GROUND LEVEL)"]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,null,"8.2.3","PLANE VERTICAL"]
[]
[null,"H.5.5",null,"Internal and external faces of boxes (above ground level)","m²",95]
[]
[{"$nulls":3},"PLANE HORIZONTAL"]
[]
[null,"H.5.6",null,"Soffits of cover slabs","m²",5]
[]
[{"$nulls":3},"SPECIAL  FORMWORK"]
[]
[null,null,"8.2.6","BOX OUT HOLES / FORM VOIDS"]
[]
[null,"H.5.7","(a)","Small, circular of diameter up to 0,35m, up to 0,5m deep","no",5]
[]
[null,"H.5.8","(d)","Large, other than circular of area over 0,1m², up to 0,5m² deep","no",2]
[]
[null,"H.6",8.3,"REINFORCEMENT"]
[]
[null,null,"8.3.2","HIGH TENSILE WELDED MESH"]
[]
[null,"H.6.1",null,"Ref: 245","m²",13]
[]
[{"$nulls":3},"HIGH TENSILE STEEL BARS"]
[]
[null,"H.6.2","8.3.1","Y25 mm dia.: basic price","t",3]
[]
[{"$nulls":3},"EXTRA OVER ITEM G.6.2 (PROVISIONAL QUANTITIES) FOR BARS OF DIAMETER"]
[]
[null,"H.6.3",null,"Y10 mm","t",1]
[]
[null,"H.6.4",null,"Y12 mm","t",1]
[]
[null,"H.6.5",null,"Y16 mm","t",0.5]
[]
[null,"H.6.6",null,"Y20 mm","t",0.5]
[]
[{"$nulls":3},"MILD STEEL BARS"]
[]
[null,"H.6.7",null,"R25mm dia.: basic price","t",0.25]
[]
[{"$nulls":3},"EXTRA OVER ITEM G.6.7 (PROVISIONAL QUANTITIES) FOR BARS OF DIAMETER"]
[]
[null,"H.6.8",null,"R8 mm","t",0.1]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"H.6.9",null,"R10 mm","t",0.1]
[]
[null,"H.6.10",null,"R12 mm","t",0.05]
[]
[null,"H.7",8.4,"CONCRETE"]
[]
[{"$nulls":3},"BLINDING LAYER IN GRADE 20/20 CONCRETE 50mm THICKNESS"]
[]
[null,"H.7.1",null,"Horizontal","m²",25]
[]
[]
[{"$nulls":3},"STRENGTH CONCRETE 20/20"]
[]
[null,"H.7.2",null,"Mass concrete where instructed by the engineer","m³",4]
[]
[{"$nulls":3},"STRENGTH CONCRETE 20/10"]
[]
[null,"H.7.3",null,"Benching in boxes","m³",2]
[]
[{"$nulls":3},"STRENGTH CONCRETE 35/20"]
[]
[null,"H.7.4",null,"Floor slabs boxes","m³",7]
[]
[null,"H.7.5",null,"Walls of boxes ","m³",20]
[]
[null,"H.7.6",null,"Sloping floor panels (around pipe inlets)","m³",1]
[]
[{"$nulls":3},"UNFORMED FINISHES"]
[]
[null,"H.7.7",null,"To upper sufraces of concealed (under benching) work","m²",13]
[]
[{"$nulls":3},"WOOD FLOAT FINISH"]
[]
[null,"H.7.8",null,"Top of walls and boxes","m²",3]
[]
[{"$nulls":3},"STEEL FLOAT FINISH"]
[]
[{"$nulls":3},"UPPER SURFACES OF"]
[]
[null,"H.7.9",null,"Sloping floor panels","m²",8]
[]
[null,"H.7.10",null,"Benching in boxes","m²",13]
[]
[null,"H.7.11",null,"Floors of boxes","m²",16]
[]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,null,"8.4.4(a)","WOOD-FLOATED FINISH"]
[]
[null,"H.7.12",null,"Upper surfaces of sloping concrete paving","m²",8]
[]
[null,"H.8","SANS","STRUCTURAL STEELWORK (SMALL WORK)"]
[]
[null,"H.8.1","8.3.2(b)","Galvanised handrail assembly complete","m",28]
[]
[null,null,"8.3.4(a)","3CR12 open grid steel flooring complete and installed with 3CR12 frames","m²",5]
[]
[null,"H.8.2","8.3.4(a)","3CR12 chequer plate covers for 1000mm x 600mm openings","no",2]
[]
[null,null,"8.3.4(b)","COVER PLATES"]
[]
[null,"H.8.3",null,"Supply and install Saint Gobain Aksess 700 lockable manhole cover to SANS 50124, into concrete cover slab","no",2]
[]
[{"$nulls":3},"ALUMINIUM SLUICE GATES"]
[]
[null,"H.8.4",null,"350 mm wide x 800 high 6mm thick (Gereg or similar approved) drip tight aluminium handstop with extended handles in 500 wide x 1095mm high frame to be installed centrally in concrete wall, handles to extend to 200mm above frame","no",2]
[]
[{"$nulls":3},"GANTRY"]
[null,"H.8.5",null,"Supply and installation of heavy duty galvanised mild steel gantry for sludge pump station complete as shown ","no",1]
[]
[null,"H.9","SANS","SEWERS"]
[null,null,"1200LD"]
[]
[null,null,"8.2.3","MANHOLES"]
[]
[{"$nulls":3},"MANHOLES 1000mm DIAMETER COMPLETE WITH TYPE 4 COVER AND FRAME FOR DEPTHS:"]
[]
[null,"H.9.1",null,"Up to 2,0m","no",6]
[]
[null,"H.10","8.2.20","PAINTING"]
[]
[null,"H.10.1",null,"Paint galvanised handrail assembly complete, apply self-etch wash primer and two coats Plascon Valvaglo (or similar approved) paint. Stanchions in colour black and handrail tubing in colour golden yellow","m",28]
[{"$nulls":3},"CARRIED FORWARD"]
[{"$nulls":3},"BROUGHT FORWARD"]
[]
[null,"PSD 8.6","PSD 8.6","EMPTY AND CLEAN EXISTING MATURATION PONDS"]
[]
[null,null,"(a)","Pumping of water/sludge mixture to other structures within a distance of 500 meters ","m³",3600]
[]
[]
[null,null,"(c)","Removal of non-pumpable sludge/soil mixture and disposal within the freehaul distance of 3.0km","m³",{"$f":"F269","v":3600}]
[{"$nulls":7},{"$f":"IF(F273>0,ROUND(F273*G273,2),\"\")","v":""}]
{"$rows_empty":21}
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":3},"TOTAL FOR SCHEDULE H (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"Schedule J","index":8,"n_rows":48,"n_cols":8,"rows_kept":48}
[null,"CONTRACT NO"]
[null,{"$f":"'[2]SCHED-D'!A2","v":"WINBURG WATER TREATMENT WORKS"}]
[null,"SCHEDULE J: REFURBISHMENT OF CLARI-FLOCCULATOR"]
[]
[null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"NO","CLAUSE"]
[]
[null,"J.1",null,"REFURBISHMENT OF CLARI-FLOCCULATOR"]
[]
[null,"J.1.1",null,"Empty and clean clari-flocculator, including removal of sludge to an approved site within 500 metres","sum",1]
[]
[null,"J.1.2",null,"Unblock sludge pipe between the centre of the tank and the sludge draw-off box","sum",1]
[]
[null,"J.1.3",null,"Unblock sludge pipe between the sludge draw-off box and the sludge ponds","sum",1]
[]
[null,"J.1.4",null,"Test structure for watertightness","sum",1]
[]
[null,"J.1.5",null,"Concrete repairs"]
[]
[null,"J.1.5.1",null,"Floor"]
[]
[{"$nulls":3},"a) Remove Failed Concrete 50mm deep & Clean Surface","m³",4]
[]
[{"$nulls":3},"b) Apply SikTop Armatec 110 Prime (or similar approved)","m²",80]
[]
[{"$nulls":3},"c) Apply Sikacrete 214 (or similar approved)","m³",4]
[]
[{"$nulls":3},"d) Apply Sika Injection 203 (Pressured) (or similar approved)","m³","0.001"]
[]
[null,"J.1.5.2",null,"Walls"]
[]
[{"$nulls":3}," a) Remove Failed Concrete 50mm deep & Clean Surface","m³","0.4"]
[]
[{"$nulls":3},"b) Apply SikTop Armatec 110 Prime (or similar approved)","m²",20]
[]
[{"$nulls":3},"c) Apply Sika Monotop 412 NFG (or similar approved)","m³",{"v":0.6,"d":"1"}]
[]
[]
[null,"J.1.5.3",null,"WALL & FLOOR "]
[]
[{"$nulls":3},"a) Sikadur Combiflex SG20 (200x2mm) with Sika 31 DW (or similar approved)","m",43]
[]
[null,"J.1.5.4",null,"FINAL COATING"]
[{"$nulls":3},"Apply Coate of Sikagard 720 Epocem & Sikagard 63N","m²",154]
[]
[null,"J.1.5.5",null,"Specialist to Manage repair of works, salary, vehicle & accomodation","Sum",1]
[]
[{"$nulls":3},"TOTAL FOR SCHEDULE J (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"Schedule K","index":9,"n_rows":136,"n_cols":8,"rows_kept":136,"merged":[[0,1,0,5],[1,1,1,3],[2,1,2,3],[44,1,44,6],[45,1,45,6],[90,1,90,6],[91,1,91,6]]}
[null,"CONTRACT NO"]
[null,"WINBURG WATER TREATMENT WORKS"]
[null,"SCHEDULE K:  RENOVATIONS TO OLD PUMPHOUSE BUILDING"]
[]
[null,"ITEM","PAYMENT ","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"NO","CLAUSE"]
[]
[null,"K.1",null,"PREPARATION"]
[]
[null,"K.1.1",null,"Preparation of old Walls. Remove old paint and wash inside of building with high pressure washer","Sum",1]
[]
[null,"K.1.2",null,"Supply all scaffolding inside and outside for painting purposes","Sum",1]
[]
[null,"K.1.3",null,"Clear all vegetation inside pump house and around the building. Including all vegetation ontop of the roof.","Sum",1]
[]
[null,"K.1.4",null,"Repair all concrete floors and walkways in and around the pump house were required","Sum",1]
[]
[null,"K.2","PS PB","TILING"]
[]
[null,"K.2.1","8.2.5","Wall tiles (glazed ceramic) white","m²",28]
[]
[null,"K.2.2","8.2.19 (a)","Vinyl floor tiles (2mm Marley Heavy Duty or similar approved)","m²",45]
[]
[null,"K.2.3","8.2.5 (b)","Vinyl cove skirting","m",40]
[]
[null,"K.2.4","8.2.5 (a)","300mm x 300mm heavy duty non slip floor tiles","m²",30]
[]
[null,"K.2.5","8.2.5 (b)","100mm high heavy duty non slip tile skirting including cutting of tiles","m²",36]
[]
[null,"K.3","8.2.18","REPLACE ALL OLD DOOR FRAMES AND DOORS WITH STEEL/ALLUMINUIM FRAMES AND WOODEN DOORS.\nPRICE TO INCLUDE THE BREAKING OUT OF OLD DOOR FRAMES."]
[]
[null,"K.3.1",null,"Door (900 x 2100 x 220 wall)","No",4]
[]
[null,"K.3.2",null,"Door (800 x 2100 x 220 wall)","No",2]
[]
[null,"K.3.2",null,"Door (900 x 2100 x 220 wall)","No",2]
[]
[null,"K.3.3",null,"Door (1800 x 2100 x 220 wall)","No",3]
[]
[null,"K.3.4",null,"Door (900 x 2400 x 220 wall)","No",3]
[]
[null,"K.3.5",null,"Door (3500 x 2900 x 220 wall)","No",1]
[{"$nulls":7},{"$f":"IF(F43>0,ROUND(F43*G43,2),\"\")","v":""}]
[{"$nulls":7},""]
[null,"CARRIED FORWARD"]
[null,"BROUGHT FORWARD"]
[]
[null,"K.4",null,"REPLACE ALL OLD WINDOW FRAMES WITH ALLUMINUIM FRAMES AND GLAZING. PRICE TO INCLUDE THE BREAKING OUT OF OLD DOOR FRAMES. NEW FRAMES TO INCLUDE BURGLAR BARS."]
[]
[null,"K.4.1",null,"Window ( 2370 x 340)","No",3]
[]
[null,"K.4.2",null,"Window ( 3600 x 1800)","No",4]
[]
[null,"K.4.3",null,"Window ( 1200 x 1900 )","No",3]
[]
[null,"K.4.4",null,"Window ( 600 x 1900 )","No",2]
[]
[null,"K.4.5",null,"Window ( 4800 x 1500)","No",2]
[]
[null,"K.4.6",null,"Window (5500 x 340)","No",6]
[]
[null,"K.4.7",null,"Window (2000 x 1600 )","No",1]
[]
[null,"K.4.8",null,"Window (1500 x 600 )","No",1]
[]
[null,"K.4.9",null,"Window (5200 x 600 )","No",1]
[]
[null,"K.5","PSPB","JOINERY"]
[]
[null,null,"8.2.17","DOORS"]
[]
[null,"K.5.1",null,"Door (900 x 2100 x 110 wall)","No",4]
[]
[null,"K.5.2",null,"Door (800 x 1200 x 110 wall)","No",2]
[]
[null,"K.5.3",null,"Door (900 x 2100 x 110 wall)","No",2]
[]
[null,"K.5.4",null,"Door (1800 x 2100 x 110 wall)","No",3]
[]
[null,"K.5.5",null,"Door (900 x 2400 x 110 wall)","No",3]
[]
[null,"K.5.6",null,"Door (3500 x 2900 x 110 wall)","No",1]
[]
[null,"K.6",null,"PAINTING"]
[null,null,"8.2.20","PAINTING OF OLD WATER TREATMENT WORKS BUILDING"]
[]
[null,"K.6.1",null,"Roof Slab (plascon double velvet)","m²",42]
[]
[null,"K.6.2",null,"Steel works and down pipes (plascon enamel)","m²",110]
[]
[null,"CARRIED FORWARD"]
[null,"BROUGHT FORWARD"]
[]
[null,"K.6.3",null,"Wooden doors (woodoc 50)","m²",25]
[]
[null,"K.6.4",null,"Outside Walls","m²",1250]
[]
[null,"K.6.5",null,"Inside Walls","m²",400]
[]
[null,"K.7",null,"PROVISIONAL ITEMS"]
[]
[null,"K.7.1",null,"Supply and installation of office furniture inside the pump room offices","Prov. Sum",1,40000,{"$f":"G102","v":{"v":40000,"d":"R40,000.00"}}]
[null,"K.7.2",null,"Supply and installation of laboratory furniture and water testing equipment","Prov. Sum",1,40000,{"$f":"G103","v":{"v":40000,"d":"R40,000.00"}}]
[]
[null,"K.7.3",null,"Appoint of a Structural expert to inspect and asses the integraty of the concrete roof at the existing Pump Room.","Prov. Sum",1,{"v":240000,"d":"R240,000.00"},{"$f":"G105","v":{"v":240000,"d":"R240,000.00"}}]
[]
[null,"K.7.4",null,"Skim Coat and Fixing of Crack for the Roof Slab","Prov. Sum",1,{"v":450000,"d":"R450,000.00"},{"$f":"G107","v":{"v":450000,"d":"R450,000.00"}}]
[]
[null,"K.7.5",null,"Add Contractor's charges onto the Provisional Sums","%"]
{"$rows_empty":26}
[{"$nulls":3},"TOTAL FOR SCHEDULE K (CARRIED FORWARD TO SUMMARY)"]

{"sheet":"SCHED MA","index":10,"n_rows":19,"n_cols":26,"rows_kept":19,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,5],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[18,0,18,4]]}
["CONTRACT NO"]
["WINBURG WATER TREATMENT WORKS"]
["SECTION MA:  PRELIMINARY AND GENERAL "]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":5},"R"]
[null,"Allow for all costs and expenses in connection with the following:",{"$nulls":5},{"$f":"SUM(I6:Z6)","v":0}]
["MA1     ","Providing performance security.","Sum",1,{"$nulls":3},{"$f":"SUM(I7:Z7)","v":0}]
["MA2     ","Providing insurance.","Sum",1,{"$nulls":3},0]
["MA3     ","Design of works and submission of Contractor’s documents.","Sum",1,{"$nulls":3},0]
["MA4     ","Establishment on site.","Sum",1,{"$nulls":3},0]
["MA5     ","Setting out of work and checking work carried out by others.","Sum",1,{"$nulls":3},0]
["MA6     ","Liaison, co-operation and any necessary attendance upon the Client or other Contractors.","Sum",1,{"$nulls":3},0]
["MA7     ","General expenses incurred in complying with the requirements of T1.2: Tender Data, not included above.","Sum",1,{"$nulls":3},0]
["MA8     ","General expenses incurred in complying with the requirements of C1.2: Tender Data, not included above.","Sum",1,{"$nulls":3},0]
["MA9     ","Other general expenses incurred in complying with the requirements of the Scope of Work not included above (Specify).","Sum",1,{"$nulls":3},0]
["MA10     ","Preliminary and General Item for selected sub-contractor (Prov. Sum)","Prov. Sum",1,{"v":72536.34,"d":"R72,536.34"},{"$f":"IF(D16>0,D16*E16,\"\")","v":{"v":72536.34,"d":"R72,536.34"}},null,0]
["MA10.1     ","Contractor's mark up on Item MA10, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"F16","v":{"v":72536.34,"d":"R72,536.34"}},{"$nulls":3},0]
[{"$nulls":7},0]
["TOTAL FOR SECTION MA CARRIED FORWARD TO SUMMARY",{"$nulls":6},0]

{"sheet":"SCHED MB","index":11,"n_rows":22,"n_cols":26,"rows_kept":22,"merged":[[2,0,2,5],[3,0,4,0],[3,1,4,1],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[21,0,21,1]]}
["CONTRACT NO "]
["WINBURG WATER TREATMENT WORKS"]
["SECTION MB:  CHEMICAL DOSING EQUIPMENT"]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":5},"R"]
[null,"Allow for all costs and expenses in connection with the following:",{"$nulls":5},{"$f":"SUM(I6:Z6)","v":0}]
["MB1     ","Allow for all costs and expenses for installed testing and repairs to installed dosing pumps by ",{"$nulls":3},{"$f":"IF(D7>0,D7*E7,\"\")","v":""},null,{"$f":"SUM(I7:Z7)","v":0}]
["MB2     ","Completion of all pipework, valves, check valves, air release valves and strainers required for flocculant dosing purposes, as specified.","Sum",1,{"$nulls":3},0]
["MB3     ","Electrical control panel, level controller, cabling and all required electrical equipment.","Sum",1,{"$nulls":3},0]
[{"$nulls":7},0]
[null,"Installation, testing, commissioning and maintenance during the Defects Liability Period of the following plant.",{"$nulls":5},0]
["MB10  ","Allow for operators  to be trained in the operation and control of the plant, for a period of 72 hours only after successfully commissioning of the equipment.","Sum",1,{"$nulls":3},0]
["MB11  ","Allow for the cost of returning to site if ordered to carry out tests excluding visits required for the successful operation of the plant (per trip).","Sum",1,{"$nulls":3},0]
["MB12  ","Allow for Operating and Maintenance manuals for this Section of the contract.","Sum",1,{"$nulls":3},0]
["MB13  ","Allow for health and safety measures, plan and safety file for this Section of the contract.","Sum",1,{"$nulls":3},0]
["MB14  ","Allow for off-site storage of plant supplied under this Section of the contract, if and when ordered by the Engineer","Sum",1,{"$nulls":3},0]
[null,"(per day at R /day for 100 days)",{"$nulls":3},{"$f":"IF(D17>0,D17*E17,\"\")","v":""},null,0]
[{"$nulls":5},{"$f":"IF(D18>0,D18*E18,\"\")","v":""},null,0]
[{"$nulls":5},{"$f":"IF(D19>0,D19*E19,\"\")","v":""},null,0]
[{"$nulls":5},{"$f":"IF(D20>0,D20*E20,\"\")","v":""},null,0]
[{"$nulls":7},0]
["TOTAL FOR SECTION MA CARRIED FORWARD TO SUMMARY ",{"$nulls":6},0]

{"sheet":"SCHED MC","index":12,"n_rows":24,"n_cols":26,"rows_kept":24,"merged":[[2,0,2,5],[3,0,4,0],[3,1,4,1],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[23,0,23,1]]}
["CONTRACT NO"]
["WINBURG WATER TREATMENT WORKS"]
["SECTION MC: FLOW METERS "]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":5},"R"]
[null,"Supply and delivery to site of the following plant complete as specified.",{"$nulls":5},{"$f":"SUM(I6:Z6)","v":0}]
["MC1     ","ONE 150mm NB straight in-line integrating flow meter for raw water complete as specified, including converter, duty data logger, spare data logger, lightning protection, electrical control panel and interconnecting cabling, all as specified. (Prov. Sum)","Prov. Sum",1,{"v":55000,"d":"R55,000.00"},{"$f":"IF(D7>0,D7*E7,\"\")","v":{"v":55000,"d":"R55,000.00"}},null,{"$f":"SUM(I7:Z7)","v":0}]
["MC1.1     ","Contractor's mark up on Item MC1, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E7","v":{"v":55000,"d":"R55,000.00"}},{"$nulls":3},0]
["MC2     ","Pipework, valves, gaskets, bolts and nuts, flexible couplings, supports, etc., complete as specified and indicated on the drawings for meter in MC1 above. (Prov. Sum)","Prov. Sum",{"v":1,"d":"R1.00"},20000,{"$f":"IF(D9>0,D9*E9,\"\")","v":{"v":20000,"d":"R20,000.00"}},null,0]
["MC2.1     ","Contractor's mark up on Item MC2, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E9","v":{"v":20000,"d":"R20,000.00"}},{"$nulls":3},0]
["MC3     ","ONE 150 NB straight in-line integrating flow meter for clear water complete as specified, including converter, duty data logger, spare data logger, lightning protection, electrical control panel and interconnecting cabling, all as specified.","Sum",1,{"$nulls":3},0]
["MC4     ","Pipework, valves, gaskets, bolts and nuts, flexible couplings, supports, etc., complete as specified and indicated on the drawings for meter in MC3 above.","Sum",1,{"$nulls":3},0]
[null,"Installation, testing, commissioning and maintenance during the Defects Liability Period of the following plant.",{"$nulls":3},"",null,0]
["MC5     ","Plant supplied under Items MC1 and MC2. (Prov. Sum)","Prov. Sum",1,7500,{"v":7500,"d":"R7,500.00"},null,0]
["MC5.1     ","Contractor's mark up on Item MC5, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E14","v":7500},{"$nulls":3},0]
["MC6     ","Plant supplied under Items MC3 and MC4.",{"$nulls":3},"",null,0]
["MC7     ","Allow for the cost of returning to site if ordered to carry out tests excluding visits required for the successful operation of the plant (per trip). (Prov. Sum)","Prov. Sum",1,8290,{"v":8290,"d":"R8,290.00"},null,0]
["MC7.1     ","Contractor's mark up on Item MC7, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E17","v":8290},{"$nulls":3},0]
["MC8     ","Allow for Operating and Maintenance manuals for this Section of the contract. (Prov. Sum)","Prov. Sum",1,7500,{"v":7500,"d":"R7,500.00"},null,0]
["MC8.1     ","Contractor's mark up on Item MC8, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E19","v":7500},{"$nulls":3},0]
["MC9     ","Allow for health and safety measures, plan and safety file for this Section of the contract. (Prov. Sum)","Prov. Sum",1,7500,{"v":7500,"d":"R7,500.00"},null,0]
["MC9.1     ","Contractor's mark up on Item MC9, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E21","v":7500},{"$nulls":3},0]
["MC10 ","Allow for off-site storage of plant supplied under this Section of the contract, if and when ordered by the Engineer","Sum",1,{"$nulls":3},0]
["TOTAL FOR SECTION MA CARRIED FORWARD TO SUMMARY ",{"$nulls":6},0]

{"sheet":"SCHED MD","index":13,"n_rows":24,"n_cols":26,"rows_kept":24,"merged":[[2,0,2,5],[3,0,4,0],[3,1,4,1],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[21,0,22,0],[23,0,23,1]]}
["CONTRACT NO"]
["WINBURG WATER TREATMENT WORKS"]
["SECTION MD: RAPID GRAVITY FILTRATION EQUIPMENT"]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":5},"R"]
[null,"Supply and delivery to site of the following plant complete as specified."]
["MD1     ","Equipment for THREE rapid gravity filters, including media, distribution pipework within the filters, nozzles, false floor complete as specified","Sum",1,{"$nulls":3},{"$f":"SUM(I7:Z7)","v":0}]
["MD2     ","TWO backwash water pump sets complete with motors, couplings, baseplates, holding down bolts and all equipment as specified","Sum",1,{"$nulls":3},{"$f":"SUM(I8:Z8)","v":0}]
["MD3     ","Modification to existing air blower delivery pipework, complete as specified","Sum",1,{"$nulls":3},0]
["MD4     ","All interconnecting pipework, valves, control system and fittings necessary for operation of filter plant, all as specified","Sum",1,{"$nulls":3},0]
["MD5     ","ONE drainage pump (gland leakage) with pipework and level switches complete as specified","Sum",1,{"$nulls":3},0]
[null,"Installation, testing, commissioning and maintenance during the Defects Liability Period of the following plant",{"$nulls":5},0]
["MD6     ","Plant supplied under Item MD1","Sum",1,{"$nulls":3},0]
["MD7     ","Plant supplied under Item MD2","Sum",1,{"$nulls":3},0]
["MD8     ","Plant supplied under Item MD3","Sum",1,{"$nulls":3},0]
["MD9     ","Plant supplied under Item MD4","Sum",1,{"$nulls":3},0]
["MD10  ","Plant supplied under Item MD5","Sum",1,{"$nulls":3},0]
["MD12  ","Allow for operation of the plant supplied under this Section for a period of 72 hours, during which time the operators shall also be trained in the operation and control of the plant, only after successfully commissioning of the equipment","Sum",1,{"$nulls":3},0]
["MD13  ","Allow for the cost of returning to site if ordered to carry out tests excluding visits required for the successful operation of the plant (per trip)","Sum",1,{"$nulls":3},0]
["MD14  ","Allow for Operating and Maintenance manuals for this Section of the contract","Sum",1,{"$nulls":3},0]
["MD15  ","Allow for health and safety measures, plan and safety file for this Section of the contract.","Sum",1,{"$nulls":3},0]
["MD16  ","Allow for off-site storage of plant supplied under this Section of the contract, if and when ordered by the Engineer","Sum",1,{"$nulls":3},0]
[null,"(per day at R /day for 100 days)",{"$nulls":5},0]
["TOTAL FOR SECTION MA CARRIED FORWARD TO SUMMARY ",{"$nulls":6},0]

{"sheet":"SCHED ME","index":14,"n_rows":43,"n_cols":26,"rows_kept":43,"merged":[[2,0,2,5],[3,0,4,0],[3,1,4,1],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[40,0,41,0],[42,0,42,1]]}
["CONTRACT NO "]
["WINBURG WATER TREATMENT WORKS"]
["SECTION ME: PUMPING EQUIPMENT"]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":5},"R"]
[null,"Supply and delivery to site of the following plant complete as specified.",{"$nulls":5},{"$f":"SUM(I6:Z6)","v":0}]
["ME1     ","TWO inclined axial flow propeller type pumps, complete with motors, speed reducers (if applicable), shafts and all equipment as specified. (Wolwas Pumps) Pumps to be identical to the existing pumps and must be priced here as the Main Offer).  Alternative offers TO be priced separately in the covering letter.","No",2,{"$nulls":3},{"$f":"SUM(I7:Z7)","v":0}]
["ME2     ","Modifications to existing delivery pipework, as well as new pipework where required. (Prov. Sum)","Prov. Sum",1,55000,{"$f":"IF(D8>0,D8*E8,\"\")","v":{"v":55000,"d":"R55,000.00"}},null,0]
["ME2.1     ","Contractor's mark up on Item ME2, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E8","v":55000},{"$nulls":3},0]
["ME3     ","TWO horizontal shaft raw water pump sets complete with motors, couplings, baseplates, holding down bolts and all equipment as specified (Raw Water Pumps). (Prov. Sum)","Prov. Sum",1,435363.37,{"v":435363.37,"d":"R435,363.37"},null,0]
["ME3.1     ","Contractor's mark up on Item ME3, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E10","v":435363.37},{"$nulls":3},0]
["ME4     ","Complete replacement of existing suction and delivery pipework, including new valves, non return valves, flexible couplings, supports etc. (including new pressure gauges) for pumps in item ME3, complete as specified. (Prov. Sum)","Prov. Sum",1,55000,{"v":55000,"d":"R55,000.00"},null,0]
["ME4.1     ","Contractor's mark up on Item ME4, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E12","v":55000},{"$nulls":3},0]
["ME5     ","TWO horizontal shaft clear water pump sets complete with motors, couplings, baseplates, holding down bolts and all equipment as specified ( Clear Water Pumps )  )  Pumps to be identical to the existing pumps and must be priced here as the Main Offer)  Alternative offers must be priced separately in the covering letter.","No",2,{"$nulls":3},0]
["ME6     ","Refurbishing of existing suction and delivery pipework, valves, flexible couplings, as well as new pressure gauges for pumps in item ME5. ","Sum",1,{"$nulls":3},0]
["ME7     ","TWO submersible washwater return pumps, complete with motors, guide rails and lifting chains and all equipment as specified.","No",2,{"$nulls":3},0]
["ME8     ","Pipework, valves, flexible couplings, supports etc. (including pressure gauges) for pumps in item ME7, complete as specified.","Sum",1,{"$nulls":3},0]
["ME9     ","ONE drainage pump (gland leakage) with pipework and level switches complete as specified in the Raw Water Pump Station.","No",1,{"$nulls":3},0]
["ME10  ","ONE drainage pump (gland leakage) with pipework and level switches complete as specified in the Clear Water Pump Station.","No",1,{"$nulls":3},0]
["ME11  ","ONE set of lifting gear for the submersible sludge pump station (travelling trolley, block and tackle), complete as specified (Gantry supplied under civils). (Prov. Sum)","Prov. Sum",1,60000,{"v":60000,"d":"R60,000.00"},null,0]
["ME11.1     ","Contractor's mark up on Item ME11, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E20","v":60000},{"$nulls":3},0]
["ME12  ","Additional miscellaneous equipment, as specified, but not specifically listed above",{"$nulls":3},"",null,0]
[null,"Installation, testing, commissioning and maintenance during the Defects Liability Period of the following plant.",{"$nulls":3},"",null,0]
["ME13     ","Plant supplied under Items ME1 and ME2. (Prov. Sum)","Prov. Sum",1,15000,{"v":15000,"d":"R15,000.00"},null,0]
["ME13.1     ","Contractor's mark up on Item ME13, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E24","v":15000},{"$nulls":3},0]
["ME14     ","Plant supplied under Items ME3 and ME4. (Prov. Sum)","Prov. Sum",1,20000,{"v":20000,"d":"R20,000.00"},null,0]
["ME14.1     ","Contractor's mark up on Item ME14, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E26","v":20000},{"$nulls":3},0]
["ME15     ","Plant supplied under Items ME5 and ME6.","Sum",1,{"$nulls":3},0]
["ME16     ","Plant supplied under Items ME7 and ME8.","Sum",1,{"$nulls":3},0]
["ME17     ","Plant supplied under Item ME9.","Sum",1,{"$nulls":3},0]
["ME18     ","Plant supplied under Item ME10.","Sum",1,{"$nulls":3},0]
["ME19     ","Plant supplied under Item ME11.","Sum",1,{"$nulls":3},0]
["ME20     ","Allow for operation of the plant supplied under this Section for a period of 72 hours, during which time the operators shall also be trained in the operation and control of the plant, only after successfully commissioning of the equipment. (Prov. Sum)","Prov. Sum",1,15000,{"v":15000,"d":"R15,000.00"},null,0]
["ME20.1     ","Contractor's mark up on Item ME20, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E33","v":15000},{"$nulls":3},0]
["ME21     ","Allow for the cost of returning to site if ordered to carry out tests excluding visits required for the successful operation of the plant (per trip). (Prov. Sum)","Prov. Sum",1,7500,{"v":7500,"d":"R7,500.00"},null,0]
["ME21.1     ","Contractor's mark up on Item ME21, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E35","v":7500},{"$nulls":3},0]
["ME22  ","Allow for Operating and Maintenance manuals for this Section of the contract. (Prov. Sum)","Prov. Sum",null,7500,"",null,0]
["ME22.1     ","Contractor's mark up on Item ME22, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E37","v":7500},{"$nulls":3},0]
["ME23  ","Allow for health and safety measures, plan and safety file for this Section of the contract. (Prov. Sum)","Prov. Sum",1,7500,{"v":7500,"d":"R7,500.00"},null,0]
["ME23.1     ","Contractor's mark up on Item ME23, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E39","v":7500},{"$nulls":3},0]
["ME24  ","Allow for off-site storage of plant supplied under this Section of the contract, if and when ordered by the Engineer","Sum",1,{"$nulls":3},0]
[null,"(per day at R /day for 100 days)",{"$nulls":5},0]
["TOTAL FOR SECTION MA CARRIED FORWARD TO SUMMARY PAGE C.",{"$nulls":6},0]

{"sheet":"SCHED MF","index":15,"n_rows":33,"n_cols":26,"rows_kept":33,"merged":[[2,0,2,5],[3,0,4,0],[3,1,4,1],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[27,0,28,0],[32,0,32,1]]}
["CONTRACT NO"]
["WINBURG WATER TREATMENT WORKS"]
["SECTION MF: CLARI-FLOCCULATOR EQUIPMENT "]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":5},"R"]
[null,"Supply and delivery to site of the following plant complete as specified."]
["MF1     ","ONE new paddle mixer, complete with motor and speed reducer, all as specified, complete with extension to existing bridge to mount new mixer","No",1,{"$nulls":3},{"$f":"SUM(I7:Z7)","v":0}]
["MF2     ","Refurbishment of ONE existing paddle mixer, including replacement of motor and speed reducer, all as specified","No",1,{"$nulls":3},{"$f":"SUM(I8:Z8)","v":0}]
["MF3     ","Refurbishment of rotating bridge drive, including replacement of motor and speed reducer, all as specified","Sum",1,{"$nulls":3},0]
["MF4     ","New electrical control panel for paddle mixers and bridge drive, including cabling.","Sum",1,{"$nulls":3},0]
["MF5     ","Replacement of sludge valve, complete with electric actuator. ","Sum",1,{"$nulls":3},0]
["MF6     ","New electrical control panel for actuated valve, including cabling.","Sum",1,{"$nulls":3},0]
["MF7     ","Refurbishment of existing rotating bridge assembly and scrapers, all as specified","Sum",1,{"$nulls":3},0]
["MF8     ","Additional miscellaneous equipment, as specified, but not specifically listed above","Sum",1,{"$nulls":3},0]
[null,"Installation, testing, commissioning and maintenance during the Defects Liability Period of the following plant",{"$nulls":5},0]
["MF9     ","Plant supplied under Item MF1","Sum",1,{"$nulls":3},0]
["MF10   ","Plant supplied under Item MF2","Sum",1,{"$nulls":3},0]
["MF11   ","Plant supplied under Item MF3","Sum",1,{"$nulls":3},0]
["MF12   ","Plant supplied under Item MF4","Sum",1,{"$nulls":3},0]
["MF13   ","Plant supplied under Item MF5","Sum",1,{"$nulls":3},0]
["MF14   ","Plant supplied under Item MF6","Sum",1,{"$nulls":3},0]
["MF15   ","Plant supplied under Item MF7","Sum",1,{"$nulls":3},0]
["MF16   ","Plant supplied under Item MF8","Sum",1,{"$nulls":3},0]
["MF17   ","Allow for operation of the plant supplied under this Section for a period of 72 hours, during which time the operators shall also be trained in the operation and control of the plant, only after successfully commissioning of the equipment","Sum",1,{"$nulls":3},0]
["MF18   ","Allow for the cost of returning to site if ordered to carry out tests excluding visits required for the successful operation of the plant (per trip)","Sum",1,{"$nulls":3},0]
["MF19   ","Allow for Operating and Maintenance manuals for this Section of the contract","Sum",1,{"$nulls":3},0]
["MF20   ","Allow for health and safety measures, plan and safety file for this Section of the contract","Sum",1,{"$nulls":3},0]
["MF21   ","Allow for off-site storage of plant supplied under this Section of the contract, if and when ordered by the Engineer","Sum",1,{"$nulls":3},0]
[null,"(per day at R /day for 100 days)",{"$nulls":3},{"$f":"IF(D29>0,D29*E29,\"\")","v":""}]
["MF22","Allow Prov. Sum for Specialist  Design, manufacture, supply and delivery for replacement of Rotating Bridge assemby, including\nTwo (2) paddle mixers with motor and speed reducer;\nRotating Bridge Drive motor and speed reducer;\nScrapers.\nAll as specified","Prov. Sum",1,{"v":1500000,"d":"R1,500,000.00"},{"v":1500000,"d":"R1,500,000.00"}]
["MF23","Contractor's mark up on Item MF22, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E30","v":1500000}]
[{"$nulls":7},0]
["TOTAL FOR SECTION MF CARRIED FORWARD TO SUMMARY PAGE C.",{"$nulls":6},0]

{"sheet":"SCHED MG","index":16,"n_rows":34,"n_cols":26,"rows_kept":34,"merged":[[2,0,2,5],[3,0,4,0],[3,1,4,1],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[31,0,32,0],[33,0,33,1]]}
["CONTRACT NO "]
["WINBURG WATER TREATMENT WORKS"]
["SECTION MG:  CHLORINATION EQUIPMENT "]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":5},"R"]
[null,"Supply and delivery to site of the following plant complete as specified.",{"$nulls":5},{"$f":"SUM(I6:Z6)","v":0}]
["MG1    ","TWO wall-mounted chlorination units complete with auto change over, heating system, including two control valves and injectors and all accessories as specified.","Sum",1,{"$nulls":3},{"$f":"SUM(I7:Z7)","v":0}]
["MG2    ","TWO emergency chlorine shut-off systems.","Sum",1,{"$nulls":3},0]
["MG3    ","THREE booster pumps complete as specified.","Sum",1,{"$nulls":3},0]
["MG4    ","All interconnecting pipework, valves, diffusers, etc., all as specified.","Sum",1,{"$nulls":3},0]
["MG5    ","TWO 68 kg load cells, all as specified.","Sum",1,{"$nulls":3},0]
["MG6    ","ONE lifting gear and trolley complete as specified.","Sum",1,{"$nulls":3},0]
["MG7    ","Wind direction indicator, as specified.","Sum",1,{"$nulls":3},0]
["MG8    ","Complete chlorine gas leakage detection system, including fans, all as specified.","Sum",1,{"$nulls":3},0]
["MG9    ","Safety equipment and warning signs, as specified.","Sum",1,{"$nulls":3},0]
["MG10  ","Additional miscellaneous equipment, as specified, but not specifically listed above (including GRP Safety Box)","Sum",1,{"$nulls":3},0]
[null,"Installation, testing, commissioning and maintenance during the Defects Liability Period of the following plant.",{"$nulls":5},0]
["MG11  ","Plant supplied under Item MG1.","Sum",1,{"$nulls":3},0]
["MG12  ","Plant supplied under Item MG2.","Sum",1,{"$nulls":3},0]
["MG13  ","Plant supplied under Item MG3.","Sum",1,{"$nulls":3},0]
["MG14  ","Plant supplied under Item MG4.","Sum",1,{"$nulls":3},0]
["MG15  ","Plant supplied under Item MG5.","Sum",1,{"$nulls":3},0]
["MG16  ","Plant supplied under Item MG6.","Sum",1,{"$nulls":3},0]
["MG17  ","Plant supplied under Item MG7.","Sum",1,{"$nulls":3},0]
["MG18  ","Plant supplied under Item MG8.","Sum",1,{"$nulls":3},0]
["MG19  ","Plant supplied under Item MG9.","Sum",1,{"$nulls":3},0]
["MG20  ","Plant supplied under Item MG10.","Sum",1,{"$nulls":3},0]
["MG21  ","Allow for operation of plant supplied under this Section for a period of 72 hours, during which time operators shall be trained in the operation and control of the plant, only after successfully commissioning of equipment.","Sum",1,{"$nulls":3},0]
["MG22  ","Allow for cost of returning to site if ordered to carry out tests excluding visits required for the successful operation of the plant (per trip).","Sum",1,{"$nulls":3},0]
["MG23  ","Allow for Operating and Maintenance manuals for this Section of the contract.","Sum",1,{"$nulls":3},0]
["MG24  ","Allow for health and safety measures, plan and safety file for this Section of the contract.","Sum",1,{"$nulls":3},0]
["MG25  ","Allow for off-site storage of plant supplied under this Section of the contract, if and when ordered by the Engineer","Sum",1,{"$nulls":3},0]
[null,"(per day at R /day for 100 days)",{"$nulls":5},0]
["TOTAL FOR SECTION MG CARRIED FORWARD TO SUMMARY PAGE C.",{"$nulls":4},{"$f":"SUM(F7:F33)","v":0},null,0]

{"sheet":"SCHED EA","index":17,"n_rows":16,"n_cols":9,"rows_kept":16,"merged":[[2,0,2,5],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[15,0,15,4]]}
["CONTRACT NO "]
["WINBURG WATER TREATMENT WORKS"]
["SECTION EA:  PRELIMINARY AND GENERAL"]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT",null,"TOTAL","CERT 1"]
[{"$nulls":5},"R / c"]
[null,"Preliminary and General items related to the electrical equipment and not included in the Bills of Materials"]
["EA1","All contractual requirements","Sum ",1,{"$nulls":3},{"$f":"SUM(I7:Z7)","v":{"v":0,"d":"0.00"}}]
["EA2","All overhead costs","Sum ",1,0,"Incl. Above",null,{"$f":"SUM(I8:Z8)","v":{"v":0,"d":"0.00"}}]
["EA3","Three sets of Operating and Maintenance Manuals, including “As Built” drawings","Sum ",1,{"$nulls":3},{"v":0,"d":"0.00"}]
["EA4","Liaison and co-ordination with other contractors","Sum ",1,{"$nulls":3},{"v":0,"d":"0.00"}]
["EA5","Occupational Health & Safety Act requirements, including safety plan, safety file and all measures required (see Appendix B).","Sum ",1,{"$nulls":3},{"v":0,"d":"0.00"}]
["EA6","All other obligations (specify)",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,"……………………………………………………………………………..……….….……………..………………………………………..……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..…..…………………………………………………………………………………………………………………………………………………………………………………………………",{"$nulls":5},{"v":0,"d":"0.00"}]
["EA7","Preliminary and General Item for selected sub-contractor (Prov. Sum)","Prov","Sum",{"v":49000,"d":"R 49,000.00"},{"v":49000,"d":"R49,000.00"},null,{"v":0,"d":"0.00"}]
["EA7.1","Contractor's mark up on Item EA7.1, specify percentage below and provide total in the amount. Percentage……………..","%",{"$f":"E14","v":49000},{"$nulls":3},{"v":0,"d":"0.00"}]
["TOTAL FOR SECTION EA CARRIED FORWARD TO SUMMARY",{"$nulls":6},{"v":0,"d":"0.00"}]

{"sheet":"SCHED EB","index":18,"n_rows":37,"n_cols":28,"rows_kept":37,"merged":[[2,0,2,6],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,6],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[3,26,4,26],[3,27,4,27],[11,5,11,6],[12,5,12,6],[13,5,13,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[34,1,34,4],[36,0,36,6]]}
["CONTRACT NO "]
["WINBURG WATER TREATMENT WORKS"]
["SECTION EB:  ELECTRICAL POWER CABLES"]
["ITEM","FROM – TO","CABLE mm2 x core Cu / Al","BCEC mm2","TOTAL LENGTH (m)","RATE",null,"AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":5},"Supply","Inst","R / c"]
["EB1","Water Treatment Works MCC"]
["EB1.1","Pump 1","95 x 4 Cu",132,15,{"$nulls":4},{"$f":"SUM(K7:AB7)","v":0}]
["EB1.2","Pump 2","95 x 4 Cu",132,15,{"$nulls":4},{"$f":"SUM(K8:AB8)","v":0}]
["EB1.3","Blower 1","10 x 4 Cu",null,"Existing",{"$nulls":4},0]
["EB1.4","Blower 2","10 x 4 Cu",44,15,{"$nulls":4},0]
["EB1.5","Drainage Pump","10 x 4 Cu",null,"Existing",{"$nulls":4},0]
["EB1.6","Rietfontein Pump Station ","120 x 4 Al",null,420,"Prov. Sum",null,{"v":95592,"d":"R95,592.00"},null,0]
["EB1.6.1","Contractor's mark up on Item EB1.6.1. Percentage……………",{"$nulls":7},0]
["EB1.7","Recycle Pump Station ","35 x 4 Al",75,175,{"$nulls":4},0]
["EB1.8","DB Admin Building","10 x 4 Cu",44,45,{"$nulls":4},0]
["EB1.9","Chlorine Store","4 x 3 Cu",33,55,{"$nulls":4},0]
["EB1.10","DB Dosing","4 x 4 Cu",33,75,{"$nulls":4},0]
["EB1.11","Settling / Mixer","4 x 4 Cu",33,80,{"$nulls":4},0]
["EB1.12","WTW Fresh Water Chamber Level Sensor  Full / Empty (Low)","4 x 4 Cu",33,55,{"$nulls":4},0]
["EB1.13","Recycle Pump Station MCC Interposing Relay","4 x 4 Cu",33,175,{"$nulls":4},0]
["EB1.14","Rietfontein (Dam) Pump Station MCC Interposing Relay","4 x 4 Cu",null,420,"Prov. Sum",null,{"v":23751,"d":"R23,751.00"},null,0]
["EB1.14.1","Contractor's mark up on Item EB1.14.1. Percentage……………",{"$nulls":7},0]
["EB1.15","Interposing Relay","1 x 1.5 Cu",null,"In Panel ","Prov. Sum",null,{"v":1500,"d":"R1,500.00"},null,0]
["EB1.15.1","Contractor's mark up on Item EB1.15.1. Percentage……………",{"$nulls":7},0]
["EB2","Rietfontein (Dam) Pump Station MCC",{"$nulls":7},0]
["EB2.1","Interposing Relay Pump Inhibit / Stop","1 x 1.5 Cu",null,"In Panel ","Prov. Sum",null,{"v":1500,"d":"R1,500.00"},null,0]
["EB2.1.1","Contractor's mark up on Item EB2.1. Percentage……………",{"$nulls":7},0]
["EB2.2","Interposing Relay Pump Running","1 x 1.5 Cu",null,"In Panel ","Prov. Sum",null,{"v":1500,"d":"R1,500.00"},null,0]
["EB2.2.1","Contractor's mark up on Item EB2.2. Percentage……………",{"$nulls":7},0]
["EB3","Wolwas Pump Station MCC",{"$nulls":7},0]
["EB3.1","Pump 1","50 x 4 Al",83,15,{"$nulls":4},0]
["EB3.2","Pump 2","50 x 4 Al",83,15,{"$nulls":4},0]
["EB4","Winburg Central reservoir",{"$nulls":7},0]
["EB4.1","Level Sensor  Full / Not-Full","4 x 4 Cu",33,25,{"$nulls":4},0]
["EB5","CABLES NOT MENTIONED ABOVE, BUT DEEMED NECESSARY TO COMPLETE THE INSTALLATION IN FULL WORKING ORDER",{"$nulls":7},0]
[null,"…………………………………………....…..…...…….……………………..………..……….….……………..………………………………………..………………………………………………………………………………………………………………………………",{"$nulls":7},0]
["TOTAL CARRIED OVER TO ITEM CABLES: SCHEDULE OF PRICES",{"$nulls":8},0]

{"sheet":"SCHED EC","index":19,"n_rows":51,"n_cols":27,"rows_kept":51,"merged":[[2,0,2,5],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,3,5],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[3,26,4,26],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[28,0,28,5],[29,0,29,5],[48,1,48,2],[50,0,50,5]]}
["CONTRACT NO "]
["WINBURG WATER TREATMENT WORKS"]
["SECTION EC:  EXCAVATIONS FOR CABLES"]
["ITEM","Route","600mm wide x 800mm deep in linear meter","RATE",null,null,"AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":3},"Excavate","Supply ","Backfill","R / c"]
["EC1","Water Treatment Works MCC to"]
["EC1.1","Riefontein Pump Station ",{"$nulls":6},{"$f":"SUM(J7:AA7)","v":0}]
["EC1.1.1","Pickable soil",260,"Prov. Sum",null,null,{"v":28600,"d":"R28,600.00"},null,{"$f":"SUM(J8:AA8)","v":0}]
["EC1.1.1.1","Contractor's mark up on Item EC1.1.1 Percentage……………",{"$nulls":6},0]
["EC1.1.2","Soft Rock",60,"Prov. Sum",null,null,{"v":10800,"d":"R10,800.00"},null,0]
["EC1.1.2.1","Contractor's mark up on Item EC1.1.2 Percentage……………",{"$nulls":6},0]
["EC1.1.3","Hard Rock",25,"Prov. Sum",null,null,{"v":14000,"d":"R14,000.00"},null,0]
["EC1.1.3.1","Contractor's mark up on Item EC1.1.3 Percentage……………",{"$nulls":6},0]
["EC1.1.4","Bedding 200mm thick in linear meters for a trench 600mm wide",315,"Prov. Sum",null,null,{"v":18900,"d":"R18,900.00"},null,0]
["EC1.1.4.1","Contractor's mark up on Item EC1.1.4 Percentage……………",{"$nulls":6},0]
["EC1.2","Recycle Pump Station ",{"$nulls":6},0]
["EC1.2.1","Pickable soil",175,null,"XXXX",{"$nulls":3},0]
["EC1.2.2","Soft Rock",0,null,"XXXX",{"$nulls":3},0]
["EC1.2.3","Hard Rock",0,null,"XXXX",{"$nulls":3},0]
["EC1.2.4","Bedding 200mm thick in linear meters for a trench 600mm wide",170,"XXXX",{"$nulls":4},0]
["EC1.3","DB Admin Building",{"$nulls":6},0]
["EC1.3.1","Pickable soil",15,240,"XXXX",{"$nulls":3},0]
["EC1.3.2","Soft Rock",30,720,"XXXX",{"$nulls":3},0]
["EC1.3.3","Hard Rock",0,null,"XXXX",{"$nulls":3},0]
["EC1.3.4","Bedding 200mm thick in linear meters for a trench 600mm wide",40,"XXXX",{"$nulls":4},0]
["EC1.4","Chlorine Store",{"$nulls":6},0]
["EC1.4.1","Pickable soil",20,null,"XXXX",{"$nulls":3},0]
["EC1.4.2","Soft Rock",35,null,"XXXX",{"$nulls":3},0]
["CARRIED FORWARD"]
["BROUGHT FORWARD"]
[]
["EC1.4.3","Hard Rock",0,null,"XXXX",{"$nulls":3},0]
["EC1.4.4","Bedding 200mm thick in linear meters for a trench 600mm wide",40,"XXXX",{"$nulls":4},0]
["EC1.5","DB Dosing",{"$nulls":6},0]
["EC1.5.1","Pickable soil",40,240,"XXXX",{"$nulls":3},0]
["EC1.5.2","Soft Rock",35,null,"XXXX",{"$nulls":3},0]
["EC1.5.3","Hard Rock",0,null,"XXXX",{"$nulls":3},0]
["EC1.5.4","Bedding 200mm thick in linear meters for a trench 600mm wide",75,"XXXX",{"$nulls":4},0]
["EC1.6","Settling / Mixer",{"$nulls":6},0]
["EC1.6.1","Pickable soil",40,null,"XXXX",{"$nulls":3},0]
["EC1.6.2","Soft Rock",35,null,"XXXX",{"$nulls":3},0]
["EC1.6.3","Hard Rock",0,null,"XXXX",{"$nulls":3},0]
["EC1.6.4","Bedding 200mm thick in linear meters for a trench 600mm wide",75,"XXXX",{"$nulls":4},0]
["EC1.7","WTW Fresh Water Chamber Level Sensor  Full / Empty (Low)",{"$nulls":6},0]
["EC1.7.1","Pickable soil",40,null,"XXXX",{"$nulls":3},0]
["EC1.7.2","Soft Rock",15,null,"XXXX",{"$nulls":3},0]
["EC1.7.3","Hard Rock",0,null,"XXXX",{"$nulls":3},0]
["EC1.7.4","Bedding 200mm thick in linear meters for a trench 600mm wide",55,"XXXX",{"$nulls":4},0]
["EC1.8","EXCAVATIONS NOT MENTIONED ABOVE, BUT DEEMED NECESSARY TO COMPLETE THE INSTALLATION IN FULL WORKING ORDER",{"$nulls":6},0]
[null,"…………………………………………....…..…...…….……………………..………..……….….……………..………………………………………..…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………",{"$nulls":6},0]
["TOTAL CARRIED OVER TO ITEM CABLES: SCHEDULE OF PRICES",{"$nulls":7},0]

{"sheet":"SCHED ED","index":20,"n_rows":28,"n_cols":27,"rows_kept":28,"merged":[[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,5],[19,4,19,5],[21,4,21,5],[24,1,24,3],[27,0,27,5]]}
["CONTRACT NO "]
["WINBURG WATER TREATMENT WORKS"]
["SECTION ED:  MCC ALTERATIONS AND NEW MCCS",{"$nulls":7},"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
["ITEM","Description of work item","Unit of Measure","Quantity","RATE",null,"AMOUNT"]
[{"$nulls":4},"Supply","Inst","R / c"]
["ED1.","Water Treatment Works MCC Alterations",{"$nulls":6},{"$f":"SUM(J6:AA6)","v":0}]
["ED1.1","1 x 10A 2-pole, 10kA, supply and install in MCC","Each",1,{"$nulls":4},{"$f":"SUM(J7:AA7)","v":0}]
["ED1.2","1 x 100A 3-pole, 10kA CB, supply and install in MCC","Each",1,{"$nulls":4},0]
["ED1.3","3 x Insulated Terminal / Busbars, Terminal Interface to Feeder Cable. Tails: From Circuit Breaker to Terminal / Busbar: 25mm² per phase colour coded Cu PVC.Feeder cable: 120mm² Al 4-core PVC/SWA/PVC Bi metal lugs required","Sum",1,{"$nulls":4},0]
["ED1.4","1 x 100A 3-pole, 10kA CB, supply and install in MCC","Each",1,{"$nulls":4},0]
["ED1.5","1 x 60A 3-pole, 10kA CB, supply and install in MCC","Each",1,{"$nulls":4},0]
["ED1.6","1 x 10A 2-pole, 10kA, supply and install in MCC","Each",1,{"$nulls":4},0]
["ED1.7","1 x 25A 3-pole, 10kA CB, supply and install in MCC","Each",1,{"$nulls":4},0]
["ED1.8","1 x 25A 2-pole, 10kA, supply and install in MCC","Each",1,{"$nulls":4},0]
["ED1.9","Interposing Relays (230V, 2 x N/C + 2 x N0O), supply and install in MCC including all small wiring to complete the integration","Each",4,{"$nulls":4},0]
["ED1.10","Adjustable Timers 0-30min, 230V, supply and install, Control / delay automatic Stop, including all small wiring to complete the integration","Each",3,{"$nulls":4},0]
["ED1.11","Removal of the old MCC (lower level)","Sum",1,{"$nulls":4},0]
["ED2.","Rietfontein (Dam) Pump Station MCC Alterations",{"$nulls":6},0]
["ED2.1","Interposing Relays (230V, 2 x N/C + 2 x N0O), supply and install in MCC including all small wiring to complete the integration Pump Inhibit / Stop","Prov. Sum",1,null,null,{"v":75000,"d":"R75,000.00"},null,0]
["ED2.1.1","Contractor's mark up on Item ED2.1","%",null,{"$f":"G19","v":{"v":75000,"d":"R75,000.00"}},{"$nulls":3},0]
["ED2.2","Interposing Relays (230V, 2 x N/C + 2 x N0O), supply and install in MCC including all small wiring to complete the integration Pump Running","Prov. Sum",1,null,null,{"v":75000,"d":"R75,000.00"},null,0]
["ED2.2.1","Contractor's mark up on Item ED2.2","%",null,{"$f":"G21","v":{"v":75000,"d":"R75,000.00"}},{"$nulls":3},0]
["ED3.","Wolwas Pump Station MCC New Complete MCC",{"$nulls":6},0]
["ED3.1","MCC, supply and install including the decommissioning and removal of the old panel and re-connecting all necessary cables","Sum",1,{"$nulls":4},0]
[null,"CABLES NOT MENTIONED ABOVE, BUT DEEMED NECESSARY TO COMPLETE THE INSTALLATION IN FULL WORKING ORDER",{"$nulls":6},0]
[null,"Extension of electrical panel to accommodate extra circuit breakers……………….…….….…………………………………………………………………………………………………………………………………………………"]
[null,"Conduit, cable racks etc………………………………..………..……….….……………..………………………………………..……………………………………………………………………………………………………………………………………………………………………",{"$nulls":6},0]
["TOTAL CARRIED OVER TO ITEM MCC Alterations and New MCCs: SCHEDULE OF PRICES",{"$nulls":7},0]

{"sheet":"SCHED EF","index":21,"n_rows":15,"n_cols":27,"rows_kept":15,"merged":[[2,0,2,4],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,5],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[3,26,4,26],[9,4,9,5],[12,1,12,3],[14,0,14,5]]}
["CONTRACT NO"]
["WINBURG WATER TREATMENT WORKS"]
["SECTION EF:  TELEMETRY"]
["ITEM","Description of work item","Unit of Measure","Quantity","RATE",null,"AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":4},"Supply","Inst","R / c"]
["EF1.","Water Treatment MCC"]
["EF1.1","Supply and install the complete telemetry system with the required I/O, Controlled etc. as specified, this includes all cabling, sundry supplies, antenna, programming and telemetry radio and integration with the MCC","Sum",1,{"$nulls":4},{"$f":"SUM(J7:AA7)","v":0}]
["EF2.","Rietfontein (Dam) Pump Station MCC Alterations",{"$nulls":6},{"$f":"SUM(J8:AA8)","v":0}]
["EF2.1","Supply and install the complete telemetry system with the required I/O, Controlled etc. as specified, this includes all cabling, sundry supplies, antenna, programming and telemetry radio and integration with the MCC and Water Treatment MCC Telemetry","Prov. Sum",1,null,null,{"v":49100,"d":"R49,100.00"},null,0]
["EF2.1.1","Contractor's mark up on Item EF2.1","%",null,{"$f":"G9","v":{"v":49100,"d":"R49,100.00"}},{"$nulls":3},0]
["EF3.","Winburg Central Reservoir ",{"$nulls":6},0]
["EF3.1","Supply and install the complete telemetry system with the required I/O, Controlled etc. as specified, this includes all cabling, sundry supplies, antenna, programming and telemetry radio and integration with the Water Treatment MCC Telemetry","Sum",1,{"$nulls":4},0]
[null,"TELEMETRY NOT MENTIONED ABOVE, BUT DEEMED NECESSARY TO COMPLETE THE INSTALLATION IN FULL WORKING ORDER",{"$nulls":6},0]
[null,"…………………………………………....…..…...…….……………………..………..……….….……………..………………………………………..………………………………………………………………………………………………………………………………………………",{"$nulls":6},0]
["TOTAL CARRIED OVER TO ITEM TELEMETRY: SCHEDULE OF PRICES",{"$nulls":7},0]

{"sheet":"SCHED EG","index":22,"n_rows":28,"n_cols":25,"rows_kept":28,"merged":[[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[25,1,25,2],[27,0,27,2]]}
["CONTRACT NO "]
["WINBURG WATER TREATMENT WORKS"]
["SECTION:  EG GENERAL ITEMS"]
["ITEM","DESCRIPTION OF WORK ITEM","UNIT OF MEASURE","Quantity","AMOUNT",null,"TOTAL","CERT 1","CERT 2","CERT 3","CERT 4","CERT 5","CERT 6","CERT 7","CERT 8","CERT 9","CERT 10","CERT 11","CERT 12","CERT 13","CERT 14","CERT 15","CERT 16","CERT 17","CERT 18"]
[{"$nulls":4},"R / C"]
["EG1.","PROVISIONAL SUMS",{"$nulls":4},{"$f":"SUM(H6:Y6)","v":0}]
["EG1.1","Electrical installation , renovating portions of the existing water treatment main building","SUM",{"$nulls":3},{"$f":"SUM(H7:Y7)","v":0}]
["EG1.2","Electrical installation of for the new administration building","SUM",{"$nulls":3},0]
["EG1.3","Electrical installation of for the new chlorine store","SUM",{"$nulls":3},0]
["EG1.4","Electrical installation of for the new dosing building","SUM",{"$nulls":3},0]
["EG1.5","Electrical installation , renovating portions of the existing Rietfontein pump station","PROV SUM",null,{"v":12000,"d":"R12,000.00"},null,0]
["EG1.6","Alterations to the security / safety fence around the water treatment transformer","SUM",{"$nulls":3},0]
["EG2.","CERTIFICATES OF COMPLIANCE FOR THE ELECTRICAL INSTALLATIONS",{"$nulls":4},0]
["EG2.1","Water treatment works main building (renovated portion) and mcc","SUM",1,null,null,0]
["EG2.2","Water treatment works new administration building","SUM",1,null,null,0]
["EG2.3","Water treatment works new chlorine store","SUM",1,null,null,0]
["EG2.4","Water treatment works new dosing building","SUM",1,null,null,0]
["EG2.5","Rietfontein pump station (renovated portion) and mcc","PROV SUM",1,{"v":2000,"d":"R2,000.00"},null,0]
["EG3.","CABLE ROUTE TRACING AT WATER TREATMENT PLANT",{"$nulls":4},0]
["EG3.1","Tracing of cables between the water treatment transformer and the water treatment mcc","SUM",1,null,null,0]
["EG3.2","Tracing of cables between the water treatment mcc and the various water treatment installations","SUM",1,null,null,0]
["EG3.3","Tracing of cables between the water treatment mcc and the Rietfontein pumps station walkway","PROV SUM",1,{"v":4000,"d":"R4,000.00"},null,0]
["EG3.3.1","Contractor's mark up on Item EG3.3  Percentage……………","%",{"$f":"E22","v":{"v":4000,"d":"R4,000.00"}},null,null,0]
["EG3.4","Groundwater Source Development to augement potable water supply to Winburg WTW","PROV SUM",{"v":1,"d":"R1.00"},{"v":18000000,"d":"R18,000,000.00"}]
["EG3.4.1","Contractor's mark up on Item EG3.4  Percentage……………","%",{"v":18000000,"d":"R18,000,000.00"},null,null,{"$f":"SUM(H25:Y25)","v":0}]
[null,"ITEMS  NOT MENTIONED ABOVE, BUT DEEMED NECESSARY TO COMPLETE THE INSTALLATION IN FULL WORKING ORDER",{"$nulls":4},0]
["EG4","…………………………………………....…..…...…….……………………..………..……….….……………..………………………………………..………………………………………………………………………………………………………………………………………… ",{"$nulls":4},0]
["TOTAL CARRIED OVER TO ITEM GENERAL ITEMS: SCHEDULE OF PRICES",{"$nulls":5},0]

{"sheet":"SUMMARY","index":23,"n_rows":51,"n_cols":11,"rows_kept":51,"merged":[[0,1,1,8],[2,3,2,8],[4,3,4,8],[6,3,6,4],[11,1,11,8],[12,2,12,7],[13,2,13,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,2,22,7],[23,1,23,7],[25,1,25,8],[26,2,26,7],[27,2,27,7],[28,2,28,7],[29,2,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[33,2,33,7],[34,1,34,7],[36,1,36,8],[37,2,37,7],[38,2,38,7],[39,2,39,7],[40,2,40,7],[41,2,41,7],[42,2,42,7],[43,2,43,7],[44,1,44,7],[45,2,45,7],[46,1,46,7],[47,1,47,7],[48,1,48,7],[49,1,49,7],[50,1,50,7],[51,1,51,7]]}
[null,"SUMMARY OF SCHEDULES"]
[]
[null,"Name of Service",":",{"$f":"'[1]Project Summary'!D3","v":"UPGRADING AND REHABILITATAION OF THE WINBURG WTW: CIVIL, MECHANICAL AND ELECTRICAL ENGINEERING WORKS"}]
[]
[null,"Contract No",":",{"$f":"'[1]Project Summary'!D5","v":"2018/08/009"}]
[]
[null,"Date",":",{"$f":"'[1]Project Summary'!D7","v":"2021-05-11"}]
[]
[null,"Contractor",":",{"$f":"'[1]Project Summary'!D9","v":"MATJABENG JV"},{"$nulls":3},"Certificate No.  :",{"$f":"'[1]Project Summary'!N9","v":24}]
[]
[]
[null,"CIVIL SUMMARY"]
[null,"SCHEDULE","DESCRIPTION",{"$nulls":5},"AMOUNT "]
[null,"A","PRELIMINARY AND GENERAL",{"$nulls":5},{"$f":"'Schedule A'!I168","v":0}]
[null,"B","GENERAL SITE WORKS",{"$nulls":5},{"$f":"'Schedule B'!I116","v":0}]
[null,"C","CHEMICAL DOSING BUILDING",{"$nulls":5},{"$f":"'Schedule C'!H145","v":0}]
[null,"D","RAPID GRAVITY SAND FILTERS ",{"$nulls":5},{"$f":"'Schedule D'!H340","v":0}]
[null,"E","CHLORINATION BUILDING",{"$nulls":5},{"$f":"'Schedule E'!H209","v":0}]
[null,"F","ADMINISTRATION BUILDING",{"$nulls":5},{"$f":"'Schedule F'!H120","v":0}]
[null,"G","INTERCONNECTING PIPEWORK AND MANHOLES",{"$nulls":5},{"$f":"'Schedule G'!H227","v":0}]
[null,"H","MODIFICATIONS TO EXISTING SLUDGE HOLDING PONDS",{"$nulls":5},{"$f":"'Schedule H'!H302","v":0}]
[null,"J","REFURBISHMENT OF CLARI-FLOCCULATOR",{"$nulls":5},{"$f":"'Schedule J'!H48","v":0}]
[null,"K","RENOVATIONS TO OLD PUMPHOUSE BUILDING",{"$nulls":5},{"$f":"'Schedule K'!H136","v":0}]
[null,"TOTAL CARRIED FORWARD TO MAIN SUMMARY OF SCHEDULES - a",{"$nulls":6},{"$f":"SUM(I14:I22)","v":0}]
[]
[null,"MECHANICAL SUMMARY"]
[null,"SECTION","DESCRIPTION",{"$nulls":5},"AMOUNT "]
[null,"MA","PRELIMINARY AND GENERAL","CLEARING AND GRUBBING","CLEARING AND GRUBBING","CLEARING AND GRUBBING","CLEARING AND GRUBBING","CLEARING AND GRUBBING",{"$f":"'SCHED MA'!F19","v":0}]
[null,"MB","CHEMICAL DOSING EQUIPMENT","DAYWORKS","DAYWORKS","DAYWORKS","DAYWORKS","DAYWORKS",{"$f":"'SCHED MB'!F22","v":0}]
[null,"MC","FLOW METERS","DRAINS","DRAINS","DRAINS","DRAINS","DRAINS",{"$f":"'SCHED MC'!F24","v":0}]
[null,"MD","RAPID GRAVITY FILTRATION EQUIPMENT","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS",{"$f":"'SCHED MD'!F24","v":0}]
[null,"ME","PUMPING EQUIPMENT","MASS EARTHWORKS","MASS EARTHWORKS","MASS EARTHWORKS","MASS EARTHWORKS","MASS EARTHWORKS",{"$f":"'SCHED ME'!F43","v":0}]
[null,"MF","CLARI_FLOCCULATOR EQUIPMENT","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$f":"'SCHED MF'!F33","v":0}]
[null,"MG","CHLORINATION EQUIPMENT","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$f":"'SCHED MG'!F34","v":0}]
[null,"TOTAL CARRIED FORWARD TO MAIN SUMMARY OF SCHEDULES - b",{"$nulls":6},{"$f":"SUM(I28:I34)","v":0}]
[]
[null,"ELECTRICAL SUMMARY"]
[null,"SECTION","DESCRIPTION",{"$nulls":5},"AMOUNT OF WORK DONE"]
[null,"EA","PRELIMINARY AND GENERAL ","CLEARING AND GRUBBING","CLEARING AND GRUBBING","CLEARING AND GRUBBING","CLEARING AND GRUBBING","CLEARING AND GRUBBING",{"$f":"'SCHED EA'!F16","v":0}]
[null,"EB","ELECTRICAL POWER CABLES","DAYWORKS","DAYWORKS","DAYWORKS","DAYWORKS","DAYWORKS",{"$f":"'SCHED EB'!H37","v":0}]
[null,"EC","EXCAVATIONS FOR CABLES","DRAINS","DRAINS","DRAINS","DRAINS","DRAINS",{"$f":"'SCHED EC'!G51","v":0}]
[null,"ED","MCC ALTERATIONS AND NEW MCCS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS","CONCRETE KERBING, CONCRETE CHANNELLING, CHUTES AND DOWNPIPES, AND CONCRETE LININGS FOR OPEN DRAINS",{"$f":"'SCHED ED'!G28","v":0}]
[null,"EF","TELEMETRY","MASS EARTHWORKS","MASS EARTHWORKS","MASS EARTHWORKS","MASS EARTHWORKS","MASS EARTHWORKS",{"$f":"'SCHED EF'!G15","v":0}]
[null,"EG","GENERAL ITEMS","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL","PAVEMENT LAYERS OF GRAVEL MATERIAL",{"$f":"'SCHED EG'!E28","v":0}]
[null,"TOTAL CARRIED FORWARD TO MAIN SUMMARY OF SCHEDULES - c",{"$nulls":6},{"$f":"SUM(I39:I44)","v":0}]
[]
[null,"SUB-TOTAL (a + b + c)",{"$nulls":6},{"$f":"I24+I35+I45","v":0}]
[null,"Add 10% Contingencies",{"$nulls":6},{"$f":"0.1*I47","v":0}]
[null,"SUB-TOTAL with Contingencies",{"$nulls":6},{"$f":"I47+I48","v":0}]
[null,"Add 15% VAT",{"$nulls":6},{"$f":"I49*0.15","v":0}]
[null,"TOTAL TENDER AMOUNT CARRIED FORWARD TO THE FORM OF OFFER",{"$nulls":6},{"$f":"SUM(I49:I50)","v":0},null,{"v":36180156.673622504,"d":"R36,180,156.67"}]